A php error

[petje1]

Hello, i'm trying to add the rankings for my website and i keep getting this error

( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\test\archs.php on line 28
Call Stack
#	Time	Memory	Function	Location
1	0.0003	674816	{main}( )	..\archs.php:0
2	0.0018	714352	mysql_fetch_array ( )	..\archs.php:28

the code says its this line:

while ($row = mysql_fetch_array($rank)) {

That line it directs you to this line:

    $rank = mysql_query('SELECT Name,Class,Level FROM entities WHERE Class=45 '.' ORDER by Class desc LIMIT '.$limit.';');
$i=1;

i checked every single table, but can't figure it out whats wrong =/

[Mr_PoP]

Originally Posted by petje1

$rank = mysql_query('SELECT Name,Class,Level FROM entities WHERE Class=45 '.' ORDER by Class desc LIMIT '.$limit.';');

what is the '.'????

PHP Code:

$rank = mysql_query('SELECT `Name`,`Class`,`Level` FROM `entities` WHERE `Class`=45 ORDER by `Class` desc LIMIT "'.$limit.'" ') or die (mysql_error()); 


and also you can use

PHP Code:

mysql_fetch_assoc($rank) 


but anyways this error becuase you have a wrong query test it

[petje1]

When i remove the or die mysql error i'll get the same else he says this:

"No database selected" but i dunno how come, cause I've got my config included o.o

[Mr_PoP]

Originally Posted by petje1

When i remove the or die mysql error i'll get the same else he says this:

"No database selected" but i dunno how come, cause I've got my config included o.o

PHP Code:

//do something like this
mysql_connect('127.0.0.1','user','pass');//your mysql info
mysql_select_db('cq');//the db which contain your tables 


or upload ur php so we can check what's wrong

[petje1]

I uploaded (check attachment) it Hope you could help me out, cause it was working early this week

[Mr_PoP]

Originally Posted by petje1

I uploaded (check attachment) it Hope you could help me out, cause it was working early this week

well, the phps looks good and there is no error check your Query i guess there is something wrong with it , but i cant help you since i dont have the table 'entities' , or u can msg me with your TV info i may can help you later though!

[petje1]

Originally Posted by Mr_PoP

well, the phps looks good and there is no error check your Query i guess there is something wrong with it , but i cant help you since i dont have the table 'entities' , or u can msg me with your TV info i may can help you later though!

Just change the table entities to your character table should be fine i guess

edit:

i'm useing a flyff site that i wanted to convert from flyff to Conquer, but its useing MD5 for there password like this:

$senha = md5('kikugalanet' . $senha);//senha is the password form id

How can i change that to normal text with the newest conquer stuff(sorry but i'm trying to learn some php xD)

[Mr_PoP]

Originally Posted by petje1

Just change the table entities to your character table should be fine i guess

edit:

i'm useing a flyff site that i wanted to convert from flyff to Conquer, but its useing MD5 for there password like this:

$senha = md5('kikugalanet' . $senha);//senha is the password form id

How can i change that to normal text with the newest conquer stuff(sorry but i'm trying to learn some php xD)

i didnt get you, but the only way i know to check the md5() is to compare it with your db, so if

PHP Code:

$pass='b4f2079eface492a16a3aedc78e22561';//you already know it's petje1
//and you have a query to grab the hash from your db
$query='b4f2079eface492a16a3aedc78e22561';//the hash you got from the db
//so you can say

if($pass==query){
echo 'password is ok';
}esle{
echo 'your pass is wrong!';
} 


something like that though

[petje1]

Originally Posted by Mr_PoP

i didnt get you, but the only way i know to check the md5() is to compare it with your db, so if

PHP Code:

$pass='b4f2079eface492a16a3aedc78e22561';//you already know it's petje1
//and you have a query to grab the hash from your db
$query='b4f2079eface492a16a3aedc78e22561';//the hash you got from the db
//so you can say

if($pass==query){
echo 'password is ok';
}esle{
echo 'your pass is wrong!';
} 


something like that though

You got msn?, so you could check it out through teamviewer?

[Mr_PoP]

i PMed you

[petje1]

I noticed, i've added you