Quest pentru clasament pvp in joc
Intrati in Manangerul de DB pe care-l folositi (ex: Navicat). Mergeti la tabelul player si apasati ctrl+q apoi executati urmatorul cod:

ALTER TABLE `player`
ADD COLUMN `kills` varchar(5000) NULL DEFAULT ‘0’ ;

Iesiti si compilti questul acesta:

quest pvp_ranking begin
state start begin
when kill with npc.is_pc() begin
local kill_now = mysql_query(“SELECT kills from player.player WHERE name=’”..pc.get_name()..”‘ LIMIT 1″)
local kill_up = mysql_query(“UPDATE player.player SET kills =’”..(kill_now.kills[1]+1)..”‘ WHERE name =’”..pc.get_name()..”‘ LIMIT 1″)
end

when 20004.chat.”Clasament PvP” begin
say(“Salut, poate o sa ti se para ciudat,”)
say(“insa eu stiu totul despre lupte, si numarul acestora!”)
say_reward(“Vrei sa arunci o privire ?”)
local sel = select(“Clasament General”,”Shinshoo”,”Chunjo”,”Jinno”,”Nu,nu vreau!”)
local pp
if sel == 5 then
return
elseif sel == 1 then
pp = mysql_query(“select name,kills from player.player ORDER BY kills desc,level desc,name asc LIMIT 15″)
else
pp = mysql_query(“select name,kills from player.player where (SELECT empire from player.player_index where player.account_id =id) = “..(sel-1)..” ORDER BY kills desc,level desc,name asc LIMIT 15″)
end
if pp == nil or (pp[1] or {})[1] == nil then
say(“Es gab einen Fehler.”)
return
end
say(“Rang – Nume – Puncte PvP”)
table.foreachi(pp,function(i,l)
say(i..” – “..l[1]..” – “..l[2])
end)
end
end
end

In quest_functions adaugati urmatoarea linie la sfarsit:

mysql_query