How to fix the register on Noisy's DarkGlow website

[Walletman987]

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]

just a warning, if you use this querry you will lose all you bg_user data, better if make these configs manually

[Noizy]

heh just alert table and add column

with alert u`ll not lose a data

[WorldOfWars]

All account ^^