+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 2 Releases (https://lckb.dev/forum/forumdisplay.php?fid=186)
+----- Forum: Server Side (https://lckb.dev/forum/forumdisplay.php?fid=143)
+----- Thread: newproject_post (/showthread.php?tid=1254)
- CyberClaus - 11-18-2012
Hi community!
Once again i come here to leave something i found.
I see lots of LCKB users, are looking for the famous _post DB.
Ill leave what i found out although its still incomplete. If anyone finds out more and are willing to help fill it, feel free to post under and ill update this post, giving all the credits.
so here we go. First we are creating the _post DB and then we are creating the tables that ill put next, dont forget they are case sensitive, so copy it right.
The tables are:
-eventquest
-mailaccount
-msgtype
-postoffice
-postoffice_att0
-postoffice_att1
-postoffice_att2
-postoffice_att3
-postoffice_att4
-postoffice_att5
-postoffice_att6
-postoffice_att7
-postoffice_att8
-postoffice_att9
-premiumtype
-preslot
-preuserattachement0
-preuserattachement1
-preuserattachement2
-preuserattachement3
-preuserattachement4
-preuserattachement5
-preuserattachement6
-preuserattachement7
-preuserattachement8
-preuserattachement9
-slotidx
-storage_postoffice
-storage_postoffice_att0
-storage_postoffice_att1
-storage_postoffice_att2
-storage_postoffice_att3
-storage_postoffice_att4
-storage_postoffice_att5
-storage_postoffice_att6
-storage_postoffice_att7
-storage_postoffice_att8
-storage_postoffice_att9
-usermailbox
Ok, so these are the tables i found out for the _post DB, if i find more and/or if i find how to fill these tables ill post here.
Again, if someone has any further info, post under and ill edit this post. Lets help the community guys!!!
- Paramount - 11-18-2012
-- ------------------------------ Table structure for `postoffice`-- ----------------------------CREATE TABLE `postoffice` ( `index` int(5) NOT NULL DEFAULT '0', `msgtype` int(5) DEFAULT NULL, `msgcategory` int(5) DEFAULT NULL, `recvdate` int(10) DEFAULT NULL, PRIMARY KEY (`index`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;CREATE TABLE `eventquest`;CREATE TABLE `mailaccount`;CREATE TABLE `msgtype`;CREATE TABLE `postoffice_att0`;CREATE TABLE `postoffice_att1`;CREATE TABLE `postoffice_att2`;CREATE TABLE `postoffice_att3`;CREATE TABLE `postoffice_att4`;CREATE TABLE `postoffice_att5`;CREATE TABLE `postoffice_att6`;CREATE TABLE `postoffice_att7`;CREATE TABLE `postoffice_att8`;CREATE TABLE `postoffice_att9`;CREATE TABLE `premiumtype`;CREATE TABLE `preslot`;CREATE TABLE `preuserattachment0`;CREATE TABLE `preuserattachment1`;CREATE TABLE `preuserattachment2`;CREATE TABLE `preuserattachment3`;CREATE TABLE `preuserattachment4`;CREATE TABLE `preuserattachment5`;CREATE TABLE `preuserattachment6`;CREATE TABLE `preuserattachment7`;CREATE TABLE `preuserattachment8`;CREATE TABLE `preuserattachment9`;CREATE TABLE `slotidx`;CREATE TABLE `storage_postoffice`;CREATE TABLE `storage_postoffice_att0`;CREATE TABLE `storage_postoffice_att1`;CREATE TABLE `storage_postoffice_att2`;CREATE TABLE `storage_postoffice_att3`;CREATE TABLE `storage_postoffice_att4`;CREATE TABLE `storage_postoffice_att5`;CREATE TABLE `storage_postoffice_att6`;CREATE TABLE `storage_postoffice_att7`;CREATE TABLE `storage_postoffice_att8`;CREATE TABLE `storage_postoffice_att9`;CREATE TABLE `usermailbox`;
So, but a table must have at least 1 column.
Will work...
- CyberClaus - 11-18-2012
thanks Krosent for your aport
- luoo - 11-18-2012
to remove the error you only need the first table
CREATE TABLE `postoffice` (
`index` int(5) NOT NULL DEFAULT '0',
`msgtype` int(5) DEFAULT NULL,
`msgcategory` int(5) DEFAULT NULL,
`recvdate` int(10) DEFAULT NULL,
PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Post it already here
2
- Paramount - 11-18-2012
Not sure. If there is a tables - they perform their function. So, they are also needed.
- CyberClaus - 11-18-2012
luoo is right and Krosent ir right too... but the purpose of this post is to find the complete _Post DB, and not just make it remove the error of the subhelper...
- luoo - 11-18-2012
It make no sense because the _post isnt needed by gameserver.
I think that can help you 2 posted by Wizatek.
- CyberClaus - 11-18-2012
well, this his exactly what MaX says... everyone wants to get helped, but noone wants to work his ***** a little bit to help himself or others. im not after wizatek or others work, im doing this alone, if you already knew this why havent your posted to help others? MaX is right... if you know how it works, greetz, im trying to help others.
- Koko - 11-18-2012
I made a few columns from what i've found in the subhelper, i'll post that later (i don't have it on that computer)
- luoo - 11-18-2012
From 00044918 to 00049137 you see all querys ( SubHelper you only need )
I cant help because i didnt make it for all tables ^^