Minilogin to public server? (i'll settle for the minilogin source code)

[Sakrateri]

user entry? you mean account id? no , i cant get past 8

btw , I am using MYSQL Front , so what ever I need to do in the database is pretty easy.

[Aerewen]

execute this query in your database:

SELECT * FROM `account` WHERE `id` = 9;

then tell me if it returned any information

[Sakrateri]

it returned

Empty set <0.00 sec>

[Aerewen]

that's really odd... the only thing i can think of to try is changing line 161 from:

		$sql = "INSERT INTO `account` (`id`,`name`,`charname`,`sharedplat`,`password`,`status`,`lsaccount_id`,`gmspeed`,`revoked`,`minilogin_ip`,`hideme`,`rulesflag`) VALUES (". $newno. ",'". $_POST['username']. "','',0,'". $_POST['password']. "',". $admin_level. ",". $newno. ",0,0,'". $_SERVER['REMOTE_ADDR']. "',0,0)";

to

		$sql = "INSERT INTO `account` (`id`,`name`,`charname`,`sharedplat`,`password`,`status`,`lsaccount_id`,`gmspeed`,`revoked`,`minilogin_ip`,`hideme`,`rulesflag`) VALUES (NULL,'". $_POST['username']. "','',0,'". $_POST['password']. "',". $admin_level. ",". $newno. ",0,0,'". $_SERVER['REMOTE_ADDR']. "',0,0)";

and hope your database is set to auto increment the id field

[John Adams]

I wouldn't insert 'id' at all, on an auto-increment field.

[Aerewen]

setting it to null will cause it to auto increment as well. as memory serves me older versions of MySQL will spit out an error if your insert query doesnt specify at least a null value for a key

[John Adams]

Just because I am in an argumentive mood today (grin), no value passed would also be NULL.

Ok, I am done.

[LordHogFred]

Ok I'm getting some really horrible errors:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Inetpub\wwwroot\eqlogin\index.php on line 119

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 120

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 122

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 123

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 158

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 159

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 163

Any ideas?