newproject_post

[CyberClaus]

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]

 

-- ------------------------------ 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]

thanks Krosent for your aport

[luoo]

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]

Not sure. If there is a tables - they perform their function. So, they are also needed.

[CyberClaus]

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]

It make no sense because the _post isnt needed by gameserver.

 

I think that can help you 2 posted by Wizatek.

[CyberClaus]

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]

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]

From 00044918 to 00049137 you see all querys ( SubHelper you only need )

I cant help because i didnt make it for all tables ^^