So i have this global_reg_val:
PVPTotal
so everytime someone killed someone it adds : PVPTotal = 1 + 1 etc..
Now how can i query this in sql as top 5 highest?
I can't make it work though:
How to get the name of the account_id
//set @nb, query_sql("select account_id,name,str,value from `global_reg_value` WHERE str = 'PVPTotal' ORDER BY str DESC LIMIT 5", @name$, @value,@str ,@account_id);
//mes "Hall Of Fame: TOP5";
//mes "1.("+@value[0]+")"; // Will return a person with the biggest fame value.
//mes "2.("+@value[1]+")";
//mes "3.("+@value[2]+")";
//mes "4.("+@value[3]+")";
//mes "5.("+@value[4]+")";
//close;