I need help with my account sign up page

[pooooo132]

ok i did everything exactly the same as the guide i used and everyone else who used the guide said it was good and worked for them but it doesnt work for me i get this

mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\account.php on line 479
Error: Unable to connect to MySQL server. MySQL reported: Access denied for user 'root'@'MASTER' (using password: YES).



please tell me if you know whats wrong thanks ill +Rep if it works!

[BillyBob31]

My row 479 is this

$logincheck = mysql_num_rows($uniqueuser);

But also im using a form of spora idk what your using ... why dont u say what kind ur using and show the line your error is like show just 479

... then also show more of the file like 4 lines before and after with including the 479 line

[dann462]

ok i did everything exactly the same as the guide i used and everyone else who used the guide said it was good and worked for them but it doesnt work for me i get this

You must configurate the config.php with your correct MySQL data's.

[volitle]

check yeh config.php like the guy above said there will be a password part you have missed and if you are using spora it will be pretty easy to find

[2dgreengiant]

post your index.php file or conf.php file

[pooooo132]

this it waht it looks like


$lang="en"; // Language ("en" - english, "ru" - russian)
$title="phoenix funserver"; // Insert the title of your server here
$host="5.90.161.241"; // HOST for Character database
$user="root"; // USER for Character database
$password="password i use to get into navicat"; // PASS for Character database
$db="logon"; // NAME of Character database
$hostr="5.90.161.241"; // HOST for Logonserver database
$userr="root"; // USER for Logonserver database
$passwordr="password i use to get into navicat"; // PASS for Logonserver database
$dbr="localhost"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "5.90.161.241"; // Ascent Server Address
$port = "3306"; // Ascent Server Port
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address


thanks for the help

[pooooo132]

O and that is one of the many things i have done like i have tryed a bunch of other users and passes and a bunch of other everything but it just never works

[pooooo132]

and this is spora v1.4

[Sonic Waffle]

Try this?:
In yellow is what I changed:
$lang="en"; // Language ("en" - english, "ru" - russian)
$title="phoenix funserver"; // Insert the title of your server here
$host="localhost"; // HOST for Character database
$user="root"; // USER for Character database
$password="password i use to get into navicat"; // PASS for Character database
$db="logon"; // NAME of Character database
$hostr="localhost"; // HOST for Logonserver database
$userr="root"; // USER for Logonserver database
$passwordr="password i use to get into navicat"; // PASS for Logonserver database
$dbr="localhost"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "localhost"; // Ascent Server Address
$port = "3306"; // Ascent Server Port
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address

[pooooo132]

it worked thanks you so much +rep

[pooooo132]

actually nvm it doesnt work now i get this

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\account.php on line 479

[TheSpidey]

You probably have a problem with your DB.