Fixing a SQL script

[Wizet]

`id` int(11) NOT NULL auto_increment,
  `name` varchar(13) NOT NULL,
  `password` varchar(128) NOT NULL,
  `salt` varchar(32) default NULL,
  `email` tinytext NOT NULL,
  `createdat` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `verification` varchar(200) NOT NULL default '0',
  `verified` varchar(1) NOT NULL default '0',
  `loggedin` tinyint(4) NOT NULL default '0',
  `lastlogin` timestamp NULL default NULL,
  `banned` tinyint(1) NOT NULL default '0',
  `banreason` text NULL,
  `sitelogin` int(11) default NULL,
  `maincharacter` int(255) default '0',
  `postedthread` int(11) default NULL,
  `webadmin` smallint(1) NOT NULL default '0',
  `positiveratings` int(11) NOT NULL default '0',
  `neutralratings` int(11) NOT NULL default '0',
  `negativeratings` int(11) NOT NULL default '0',
  `sellingauctions` int(11) NOT NULL default '8',
  `buyingauctions` int(11) NOT NULL default '2', 

This is my website sql script. I am offering an amount of credits desired but not too much. (Don't worry I'm not that cheap) Also the object of this offer is to fix the script so that members do not need to verify themselves but you can only do that by editing the script and not removing any tables. It seems easy but it isn't.

[michael9]

`id` int(11) NOT NULL auto_increment,
  `name` varchar(13) NOT NULL,
  `password` varchar(128) NOT NULL,
  `salt` varchar(32) default NULL,
  `email` tinytext NOT NULL,
  `createdat` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `verification` varchar(200) NOT NULL default '0',
  `verified` varchar(1) NOT NULL default '1',
  `loggedin` tinyint(4) NOT NULL default '0',
  `lastlogin` timestamp NULL default NULL,
  `banned` tinyint(1) NOT NULL default '0',
  `banreason` text NULL,
  `sitelogin` int(11) default NULL,
  `maincharacter` int(255) default '0',
  `postedthread` int(11) default NULL,
  `webadmin` smallint(1) NOT NULL default '0',
  `positiveratings` int(11) NOT NULL default '0',
  `neutralratings` int(11) NOT NULL default '0',
  `negativeratings` int(11) NOT NULL default '0',
  `sellingauctions` int(11) NOT NULL default '8',
  `buyingauctions` int(11) NOT NULL default '2',

There is your fix. I'd like 300 credits at the least

[Wizet]

*Nods head* I told you it wasn't that easy. If an admin lets me upload my site files which I doubt I could. I would be able to show you. If you have hamachi, if not download here: https://secure.logmein.com/products/hamachi/list.asp and use the hamachi ip http://5.95.152.209 to access my website. You can register and see for yourself as living proof as that doesn't work.

[supajason]

`id` int(11) NOT NULL auto_increment,
  `name` varchar(13) NOT NULL,
  `password` varchar(128) NOT NULL,
  `salt` varchar(32) default NULL,
  `email` tinytext NOT NULL,
  `createdat` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `verification` varchar(200) NOT NULL default '0',
  `verified` varchar(1) NOT NULL default '0',
  `loggedin` tinyint(4) NOT NULL default '0',
  `lastlogin` timestamp NULL default NULL,
  `banned` tinyint(1) NOT NULL default '0',
  `banreason` text NULL,
  `sitelogin` int(11) default NULL,
  `maincharacter` int(255) default '0',
  `postedthread` int(11) default NULL,
  `webadmin` smallint(1) NOT NULL default '0',
  `positiveratings` int(11) NOT NULL default '0',
  `neutralratings` int(11) NOT NULL default '0',
  `negativeratings` int(11) NOT NULL default '0',
  `sellingauctions` int(11) NOT NULL default '8',
  `buyingauctions` int(11) NOT NULL default '2', 

This is my website sql script. I am offering an amount of credits desired but not too much. (Don't worry I'm not that cheap) Also the object of this offer is to fix the script so that members do not need to verify themselves but you can only do that by editing the script and not removing any tables. It seems easy but it isn't.

please explain want you in more detail!

verify themselves?

[Wizet]

No the thing is I don't want them to verified so when they register they can login without any problems. Unfortunately I told you it wasn't that easy.

[supajason]

can you post the login script!

and tell me your hamachi network name and password?

[Wizet]

Uh how should I say this. There is no page that says login.php so thats out of the question. Also the hamachi network is network name: x10hosting
password: x10hosting. Also the network name is case-sensitive.

[Wizet]

Does anyone else want to try. Please PM me to see it first-hand.