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

[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.

[Aerewen]

Just to sustain your mood :p

You are correct, however if someone were to type in an emty set of quotes or a 0 there thinking it was a mistake in my post, then the query wouldnt work

which is why i added the column and the NULL value to the query

[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?

[John Adams]

Yeah, google this:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Tons of posts about this on the net.