quest pvp_ranking begin
state start begin
when kill with npc.is_pc() begin
local kill_now = execute_query("SELECT kills from player.player WHERE name='"..pc.get_name().."' LIMIT 1")
local kill_up = execute_query("UPDATE player.player SET kills ='"..(kill_now.kills[1]+1).."' WHERE name ='"..pc.get_name().."' LIMIT 1")
end

when 20093.chat."Ranking PvP" begin
say("Hello player here you can see the top pvp rankings")
say("just select what you want to see:")
say_reward("Select:")
local sel = select("Global","Red Kingdom","Yellow Kingdom","Blue Kingdom","Back")
local pp
if sel == 5 then
return
elseif sel == 1 then
pp = execute_query("select name,kills from player.player ORDER BY kills desc,level desc,name asc LIMIT 15")
else
pp = execute_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("Faild plese try to connect this quest with your database")
table.foreachi(pp,function(i,l)
say(i.." - "..l[1].." - "..l[2])
end)
end
end
end