+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep2 Guides (https://lckb.dev/forum/forumdisplay.php?fid=165)
+----- Thread: How to fix the register on Noisy's DarkGlow website (/showthread.php?tid=2220)
- Walletman987 - 07-20-2013
Make a new Query and past this into it:
DROP TABLE IF EXISTS `bg_user`;
CREATE TABLE `bg_user` (
`user_code` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` varchar(30) NOT NULL DEFAULT 0,
`truepasswd` varchar(30) DEFAULT NULL,
`passwd` varchar(200) NOT NULL DEFAULT 0,
`chk_tester` char(1) NOT NULL DEFAULT N,
`jumin` varchar(20) DEFAULT 0,
`chk_service` char(1) DEFAULT Y,
`partner_id` char(2) NOT NULL DEFAULT LC,
`active_passwd` varchar(15) NOT NULL DEFAULT 0,
`active_time` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,
`create_date` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,
`email` varchar(100) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
`hashigh` smallint(6) DEFAULT NULL,
`send` int(11) DEFAULT 0,
`question` varchar(200) DEFAULT NULL,
`answer` varchar(200) DEFAULT NULL,
`chk_closebeta` char(1) NOT NULL,
`cash` int(10) DEFAULT 0,
`a_cash` int(10) DEFAULT NULL,
`a_online_time` int(10) DEFAULT NULL,
`cellphone` varchar(100) DEFAULT NULL,
`gender` varchar(100) DEFAULT NULL,
`day` varchar(10) DEFAULT NULL,
`month` varchar(50) DEFAULT NULL,
`year` varchar(100) DEFAULT NULL,
`avatar` varchar(500) DEFAULT NULL,
PRIMARY KEY (`user_code`),
UNIQUE KEY `user_id` (`user_id`),
KEY `passwd` (`passwd`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
---------------------------------------------------------------------------------------------------------------------------------------------------------
MAKE A BACKUP OF BG_USER BEFORE YOU TRY THIS!
- DrGenius - 07-20-2013
just a warning, if you use this querry you will lose all you bg_user data, better if make these configs manually
- Noizy - 07-20-2013
heh
just alert table and add column with alert u`ll not lose a data
- WorldOfWars - 07-25-2013
All account ^^