War System and Frag Rank !! (SQLite)

[lucas280]

hi guys, i need war system script for my otserver someone have? and i need frag rank script( rank showing players with the most kills) example: talkaction "!rankfrag" and shows >> 1.Spark = 67 frags 2.Lowel = 45 frags 3.Opix= 34... (similar to the level rank but with frags)and if possible, one showing their deaths by players !
sorry for bad english !

 

[luigilc]

the frag rank is somethin I've been lookin for quite a while, would be nice to have it

 

[rodrigo504]

function doPlayerShowHighscore(uid, storage)
local showPlayers = 10
local str = "Frags Highscore:\n# Player - [Score]\n"
local result = db.getResult('SELECT `value`, `player_id` FROM `player_storage` WHERE `key`=19999 ORDER BY cast(`value` as DECIMAL) DESC;')
local i = 1
while i <= showPlayers do
str = str .. "\n " .. i .. ". "..getPlayerNameByGUID(result:getDataInt("player_id")).." - [" .. (result:getDataInt("value") + 1) .. "]"
if not(result:next())then
break
end
i = i+1
end
result:free()
if(str ~= "") then
doShowTextDialog(uid, 8977, str)
end
return true
end

function onSay(cid, words, param)
doPlayerShowHighscore(cid, 19999)
return true
end


<talkaction words="!topranks" script="top.lua"/>

 

[lucas280]

error in frag rank script :/, image :



help me !

 

[luigilc]

pls use lua or code tags to post scripts it's easier to see and understand, also got the error that lucas posted

 

[Knight God]

em, I have to use magnifying glass?
or what?

 

[lucas280]

em, I have to use magnifying glass?
or what?

click on image to zoom it ?

 

[luigilc]

omg pretty obvious mr. smart