+- 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
thats the point luoo, people need to understand that if you made a little bit, i did another lil bit and another did a lil bit, thats 3 lil bits thats all together can make what all are looking for. And thats what MaX is looking after on this board. Thanks Kokokoul.
- Sutz - 11-18-2012
I'd just like to point out I'm not attacking or picking or pointing out anyone! I just feel this board has been a "wow look what I got working hahah! you cant have" type of board which is really sad!
If people helped others these "others" might get encouraged to get other things working by learning from peoples guides or releases.
Its a simple chain which may turn in the original peoples favor! You never know when you might get stuck with something an someone else has access to whatever it is (a fresh look may uncover new possibilities).
Of course there will always be the other people that use this boards progress an credit as their own its something everyone has to accept as part of this board an any other board.
But together we can be great!
- Gothic - 11-18-2012
Here is a small fix for you as far as the postoffice.
-- ----------------------------
-- Table structure for `postoffice`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice`;
CREATE TABLE `postoffice` (
`recvdate` varchar(50) NOT NULL,
`sendcharacteridx` int(11) NOT NULL,
`msgcategory` smallint(6) NOT NULL DEFAULT '-1',
`msgtype` smallint(6) NOT NULL DEFAULT '-1',
`recvcharacteridx` int(11) NOT NULL DEFAULT '0',
`subject` varchar(41) DEFAULT '',
`contents` varchar(255) DEFAULT '',
`money` bigint(20) DEFAULT '0',
`billreqflag` smallint(6) DEFAULT '0',
`viewicon` int(11) NOT NULL DEFAULT '0',
`sendName` varchar(20) NOT NULL DEFAULT '',
`recvName` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `msgcategorypostoffice` (`msgcategory`),
KEY `msgtypepostoffice` (`msgtype`),
KEY `sendcharacteridxpostoffice` (`sendcharacteridx`),
CONSTRAINT `postoffice_ibfk_1` FOREIGN KEY (`msgcategory`) REFERENCES `premiumtype` (`msgcategory`),
CONSTRAINT `postoffice_ibfk_2` FOREIGN KEY (`msgtype`) REFERENCES `msgtype` (`msgtype`),
CONSTRAINT `postoffice_ibfk_3` FOREIGN KEY (`sendcharacteridx`) REFERENCES `mailaccount` (`sendcharacteridx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice
-- ----------------------------
- Koko - 11-18-2012
Ok so here's my (far from complete) post db: 2
Notes:
- Does not include luoo/Gothic fixes
- Does not stop the post error 700 message
- Contains every table used by the subhelper so far
Working on a fixed one (will include the last releases), i'll post that tonight.
- Gothic - 11-18-2012
Ok so here's my (far from complete) post db: 2
Notes:
- Does not include luoo/Gothic fixes
- Does not stop the post error 700 message
- Contains every table used by the subhelper so far
Working on a fixed one (will include the last releases), i'll post that tonight.
You a noob? i think yes my fixx is 1 from the 31 Tabels in the _post and your link is ***** the right have more than 64KB as a SQL file.
Koko i know your a admin and i say shut hup you dont know waht is my fix.
- BaZZtian - 11-18-2012
Ok so here's my (far from complete) post db: 2
Notes:
- Does not include luoo/Gothic fixes
- Does not stop the post error 700 message
- Contains every table used by the subhelper so far
Working on a fixed one (will include the last releases), i'll post that tonight.
Realy nice idea from you to give us your IP dude ...
- Anja - 11-18-2012
And what you can do with it, man? )
- Gothic - 11-18-2012
Its a wrong DB from Koko and its dont have all full infos and have wrong infos...................... and the his IP insite lol
/*
Navicat MySQL Data Transfer
Source Host : 192.168.56.3:3306
Source Database : newproject_post
Target Host : 192.168.56.3:3306
Target Database : newproject_post
Date: 2012-11-18 21:06:37
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for postoffice
-- ----------------------------
DROP TABLE IF EXISTS `postoffice`;
CREATE TABLE `postoffice` (
`slot_number` int(11) DEFAULT NULL,
`subject` varchar(20) NOT NULL,
`characteridx` int(11) NOT NULL,
`msgcategory` int(11) DEFAULT NULL,
`contents` varchar(255) NOT NULL,
`money` int(11) DEFAULT NULL,
`msgtype` int(11) DEFAULT NULL,
`billreqflag` int(11) DEFAULT NULL,
`timeresult` time DEFAULT NULL,
`viewicon` int(11) DEFAULT NULL,
`sendName` varchar(20) DEFAULT NULL,
`recvName` varchar(20) DEFAULT NULL,
`limittime` int(11) DEFAULT NULL,
`itemserial` int(11) DEFAULT NULL,
`itemidx` int(11) NOT NULL,
`option1` int(11) DEFAULT NULL,
`option2` int(11) DEFAULT NULL,
`option3` int(11) DEFAULT NULL,
`option4` int(11) DEFAULT NULL,
`option5` int(11) DEFAULT NULL,
`optionlevel1` int(11) DEFAULT NULL,
`optionlevel2` int(11) DEFAULT NULL,
`optionlevel3` int(11) DEFAULT NULL,
`optionlevel4` int(11) DEFAULT NULL,
`optionlevel5` int(11) DEFAULT NULL,
`socket` int(11) DEFAULT NULL,
`timelimite1` int(11) DEFAULT NULL,
`timelimite2` int(11) DEFAULT NULL,
`plus` int(11) DEFAULT NULL,
`flag` int(11) DEFAULT NULL,
`itemcount` int(11) DEFAULT NULL,
`preslot` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice
-- ----------------------------
INSERT INTO `postoffice` VALUES ('1', 'test', '1', '1', 'test test', '1', '1', '1', '-00:00:01', '1', 'test', 'test', '-1', null, '0', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '0', '-1', '0', '0');
-- ----------------------------
-- Table structure for usermailbox
-- ----------------------------
DROP TABLE IF EXISTS `usermailbox`;
CREATE TABLE `usermailbox` (
`slot_number` int(11) DEFAULT NULL,
`subject` varchar(20) NOT NULL,
`characteridx` int(11) NOT NULL,
`msgcategory` int(11) DEFAULT NULL,
`contents` varchar(255) NOT NULL,
`money` int(11) DEFAULT NULL,
`msgtype` int(11) DEFAULT NULL,
`billreqflag` int(11) DEFAULT NULL,
`timeresult` time DEFAULT NULL,
`viewicon` int(11) DEFAULT NULL,
`sendName` varchar(20) DEFAULT NULL,
`recvName` varchar(20) DEFAULT NULL,
`limittime` int(11) DEFAULT NULL,
`itemserial` int(11) DEFAULT NULL,
`itemidx` int(11) NOT NULL,
`option1` int(11) DEFAULT NULL,
`option2` int(11) DEFAULT NULL,
`option3` int(11) DEFAULT NULL,
`option4` int(11) DEFAULT NULL,
`option5` int(11) DEFAULT NULL,
`optionlevel1` int(11) DEFAULT NULL,
`optionlevel2` int(11) DEFAULT NULL,
`optionlevel3` int(11) DEFAULT NULL,
`optionlevel4` int(11) DEFAULT NULL,
`optionlevel5` int(11) DEFAULT NULL,
`socket` int(11) DEFAULT NULL,
`timelimite1` int(11) DEFAULT NULL,
`timelimite2` int(11) DEFAULT NULL,
`plus` int(11) DEFAULT NULL,
`flag` int(11) DEFAULT NULL,
`itemcount` int(11) DEFAULT NULL,
`preslot` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of usermailbox
-- ----------------------------
The Right usermailbox (I have delet strings)
-- ----------------------------
-- Table structure for `usermailbox`
-- ----------------------------
DROP TABLE IF EXISTS `usermailbox`;
CREATE TABLE `usermailbox` (
`characteridx` int(11) NOT NULL,
`msgcategory` smallint(6) NOT NULL DEFAULT '-1',
`*************************************************,
`msgtype` smallint(6) NOT NULL DEFAULT '-1',
`**************************************************,
`contents` varchar(255) DEFAULT '',
`******************************,
`billreqflag` smallint(6) NOT NULL DEFAULT '0',
`limittime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`viewicon` int(11) DEFAULT '-1',
`sendcharacteridx` int(11) NOT NULL,
`********************************************'',
`recvName` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`characteridx`,`msgcategory`,`slot_number`,`msgtype`),
KEY `slotnumberusermailbox` (`slot_number`),
KEY `msgcategoryusermailbox` (`msgcategory`),
KEY `msgtypeusermailbox` (`msgtype`),
CONSTRAINT `usermailbox_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `usermailbox_ibfk_2` FOREIGN KEY (`msgcategory`) REFERENCES `premiumtype` (`msgcategory`),
CONSTRAINT `usermailbox_ibfk_3` FOREIGN KEY (`msgtype`) REFERENCES `msgtype` (`msgtype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of usermailbox
-- ----------------------------
- CyberClaus - 11-18-2012
Guys, stop attacking each other... you know alot of this? good to you, i hope i get the opportunity to know something you dont to call you a noob... stop beeing a lil kid and respect to be respected. And Bazz, search and read a lil bit about IP Protocols, 192.168.x.x its internal ip, you could only do something if you where inside Koko lan... And thank you guys for the effort and sharing! Lets make MaX proud -.o
- BaZZtian - 11-18-2012
Guys, stop attacking each other... you know alot of this? good to you, i hope i get the opportunity to know something you dont to call you a noob... stop beeing a lil kid and respect to be respected. And Bazz, search and read a lil bit about IP Protocols, 192.168.x.x its internal ip, you could only do something if you where inside Koko lan... And thank you guys for the effort and sharing! Lets make MaX proud -.o
i just say thanks that he share his ip with us ...
i dont want attak him and nothing more ...
it was only an real mean thanks ... -.-
and i know that 192.168.x.x is an local IP ...
i'm not stupid ...