[SMALL_RELEASE]PvP-Quest-ranking

[killerakoz1999g4]

hello guys today i want share this pvp_quest with this forum
firts of all you have to creat one table in player.player with name :kills
after this you have to put my quest in your quests and in quest_list (quest name: pvp_quest.killerz)
then reboot the server and all its complete you can see the top 15 pvp in [Global,red kingdom,yellow kingdom,blue kingdom]

if you like this small release give thanks

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 20093.chat."Raking 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 = 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("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

and add in fuctions: mysql_query (if you dont have it)

and in questlib.lua

mysql_query = function(query)
local rt = io.open('CONFIG','r'):read('*all')
local pre= string.gsub(rt,'.+PLAYER_SQL:%s(%S+)%s(%S+)%s(%S+) %s(%S+).+','-h%1 -u%2 -p%3 -D%4')
math.randomseed(os.time())
local fi,t,out = 'mysql_data_'..math.random(10^9)+math.random(2^4,2 ^10),{},{}
os.execute('mysql '..pre..' --e='..string.format('%q',query)..' > '..fi)
for av in io.open(fi,'r'):lines() do table.insert(t,split(av,'\t')) end; os.remove(fi);
for i = 2, table.getn(t) do table.foreach(t[i],function(a,b)
out[i-1] = out[i-1] or {}
out[i-1][a] = b
out[t[1][a]] = out[t[1][a]] or {}
out[t[1][a]][i-1] = b
end) end
return out
end

[lukasplny]

what do you mean with this? cyber-ga**rs.org/public/style_emoticons

[killerakoz1999g4]

Originally Posted by lukasplny

what do you mean with this? cyber-ga**rs.org/public/style_emoticons

its icon but i have delete it now.. :P

[killa673]

not bad tanks^^

[deltous'fabius]

Kommt da rein:
#closerequest