LCKB
looking for the existance of the fabled post.sql (if such file exists) - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: looking for the existance of the fabled post.sql (if such file exists) (/showthread.php?tid=844)

Pages: 1 2 3


- illusionist - 11-13-2012


Quiet literally as the title suggest needs a direction(Note Im not saying link me to anything) to the location of the ep2 server's post.sql database file do not really care where the hell it comes from just need a direction.

 

Cause... in all honesty google is about as useful as a fat kid eatting cake who cant touch the ground with his legs in a running competition!

 

NOW WITH 99.9% more SPAM!!!




- Koko - 11-13-2012

I tried to recreate it but so far no luck, maybe you'll have more, open the subhelper with a hexeditor and find the SQL queries in it, that'll at least give you tables/fields names.




- HateMe - 11-13-2012

to get the tables and fields naems you can use a simple hex editor to thats how i did it to create it




- Koko - 11-13-2012



to get the tables and fields naems you can use a simple hex editor to thats how i did it to create it

 

Well i'm pretty sure i got all the tables but i still get the post error 700, so i guess i got something wrong in there lol




- Sutz - 11-13-2012

Yea I'm also looking for this maybe will take the hex route




- luoo - 11-13-2012



-- Table structure for `postoffice`
-- ----------------------------
DROP TABLE IF EXISTS `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;

 

Work for me




- Koko - 11-13-2012

well got that too, maybe not the correct int type, i'll see




- iFlash - 11-14-2012



-- Table structure for `postoffice`
-- ----------------------------
DROP TABLE IF EXISTS `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;

 

Work for me

where does this go?, should i create new db the query it under there? or...




- Koko - 11-14-2012



where does this go?, should i create new db the query it under there? or...

 

Create a db called newproject_post and run that query




- SibaN - 11-14-2012


thx man

but i have a probleme with rank

2

 

and now in subhelper

<a href='2 src='http://grabilla.com/02b0e-7c0edc2d-fcbd-420d-82e1-5b8c9e846889.png' alt='Captured with Grabilla' /></a>

 

how i fix thes