shadow-xx hiscore

[Mocro]

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

[MentaL]

[wesman2232]

$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

[Mocro]

what other script 0_O

i added in index.php but you say other script

[wesman2232]

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.

[Mocro]

if i do it under i get error

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

[wesman2232]

just change the ORDER BY XP to ORDER BY KillCount

[Mocro]

nvm fixed ty for your help

[shadow-xx]

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

[Mocro]

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

nah its fine just tested works perfect for me . and i just wanted a kill hiscore becaus i like that

[Mocro]

Sorry for double post but another quistion is it possible to make it top 200 if yes how

[shadow-xx]

in config.php change the $row_limit from 100 to 200

[Mocro]

in config.php change the $row_limit from 100 to 200

ty didnt see that love your release

[shadow-xx]

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

[wesman2232]

xD nice shadow im going to check it out now