is it possible to make who gote the most kills get in number 1 if yes how i change that
oftopic: shadow-xx great work on hiscore![]()
is it possible to make who gote the most kills get in number 1 if yes how i change that
oftopic: shadow-xx great work on hiscore![]()
$query = query($dbc,"SELECT TOP $row_limit Name,Level,XP,DeathCount,KillCount FROM $table_character AND name IS NOT NULL ORDER BY KillCount DESC");
thats it, do the same thing to the other script
what other script 0_O
i added in index.php but you say other script
theres 2 scripts the first one if connection_type = 1
then theres the
}
else
{
then theres the second script for if your using connection_type = 0
do it to both of them.
if i do it under i get error
Code:Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'., SQL state 37000 in SQLExecDirect in C:\AppServ\www\hiscore\includes\odbc_functions.php on line 34 Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\AppServ\www\hiscore\includes\odbc_functions.php on line 38
just change the ORDER BY XP to ORDER BY KillCount
nvm fixed ty for your help
My rank page is buggy thats why its in development..
i think im gona add an option in the config the select the
field it orders by..
Sorry for double post but another quistion is it possible to make it top 200 if yes how![]()
in config.php change the $row_limit from 100 to 200
Updated the thread with a new version use that one
it has a new option to order the output by other fields..
like.. KillCount etc
xD nice shadow im going to check it out now