Ir para conteúdo

(Resolvido)Membros da staff esta no !rank

Por ADM Mayk on BaiakME
em Suporte Tibia OTServer (Resolvidos)

Featured Replies

Postado

Base: server 10.10 

Qual erro está surgindo/O que você procura?

membros da staff: ex. [ADM] [CM] [Game Master] [MOD] [TUTOR]

estão aparecendo no ranking quero remover eles de todos os ranks .. 

modaldialog2 = {
	title = "Rank System",
	message = "Selecione a classificação que você quer ver:",
	buttons = {
		{ id = 1, value = "Ver" },
		{ id = 2, value = "Sair" },
	},
	buttonEnter = 1,
	buttonEscape = 2,
	choices = {
		{ id = 1, value = "Rank Soco" },
		{ id = 2, value = "Rank Clava" },
		{ id = 3, value = "Rank Espada" },
		{ id = 4, value = "Rank Machado" },
		{ id = 5, value = "Rank Distancia" },
		{ id = 6, value = "Rank Escudo" },
		{ id = 7, value = "Rank Pesca" },
		{ id = 8, value = "Rank Magia" },
		{ id = 9, value = "Rank Level" }
	},
	popup = false
}

function callback2(cid, button, choice)
	if (button == 1) then
		local str = ""
		if (choice == 1) then
			str = "--[ Rank Soco ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 0 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 2) then
			str = "--[ Rank Clava ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 1 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 3) then
			str = "--[ Rank Espada ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 2 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 4) then
			str = "--[ Rank Machado ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 3 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 5) then
			str = "--[ Rank Distancia ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 4 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 6) then
			str = "--[ Rank Escudo ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 5 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 7) then
			str = "--[ Rank Pesca ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 6 ORDER BY `value` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 8) then
			str = "--[ Rank Magia ]--\n"
			query = db.getResult("SELECT `maglevel`, `name` FROM `players` WHERE `group_id` < 3 ORDER BY `maglevel` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("maglevel") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 9) then
			str = "--[ Rank Level ]--\n"
			query = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` < 3 ORDER BY `experience` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("level") .. "]"
				k = k + 1 until not query:next()
			end
		end
		doShowTextDialog(cid, 5785, str)
	end
end
	
function onSay(cid, words, param)
	addDialog(modaldialog2, 1002, cid, callback2);
	return true
end

 

758x426.bmp

  • Citar
  • Mention

    • Resolvido por Vodkart

    Ir para solução
    • Respostas 7
    • Visualizações 600
    • Created
    • Última resposta

    Top Posters In This Topic

    Popular Days

    Most Popular Posts

    • Vodkart
      Vodkart

      ta configurado para aparecer só id maior que 6 kk   nessa parte do código    WHERE `id` > 6 AND   coloca maior que 2   WHERE `id` > 2 AND     da

    Posted Images

    Postado 
    modaldialog2 = {
	title = "Rank System",
	message = "Selecione a classificação que você quer ver:",
	buttons = {
		{ id = 1, value = "Ver" },
		{ id = 2, value = "Sair" },
	},
	buttonEnter = 1,
	buttonEscape = 2,
	choices = {
		{ id = 1, value = "Rank Soco" },
		{ id = 2, value = "Rank Clava" },
		{ id = 3, value = "Rank Espada" },
		{ id = 4, value = "Rank Machado" },
		{ id = 5, value = "Rank Distancia" },
		{ id = 6, value = "Rank Escudo" },
		{ id = 7, value = "Rank Pesca" },
		{ id = 8, value = "Rank Magia" },
		{ id = 9, value = "Rank Level" }
	},
	popup = false
}
function getGroupDb(player_id)
	local query = db.getResult("SELECT `group_id` FROM `players` WHERE `id`= "..player_id)
	return query:getDataInt("group_id")
end
function callback2(cid, button, choice)
	if (button == 1) then
		local str = ""
		if (choice == 1) then
			str = "--[ Rank Soco ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 0 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 2) then
			str = "--[ Rank Clava ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 1 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 3) then
			str = "--[ Rank Espada ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 2 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 4) then
			str = "--[ Rank Machado ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 3 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 5) then
			str = "--[ Rank Distancia ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 4 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 6) then
			str = "--[ Rank Escudo ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 5 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 7) then
			str = "--[ Rank Pesca ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 6 ORDER BY `value` DESC LIMIT 20;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 8) then
			str = "--[ Rank Magia ]--\n"
			query = db.getResult("SELECT `maglevel`, `name` FROM `players` WHERE `group_id` < 3 ORDER BY `maglevel` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("maglevel") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 9) then
			str = "--[ Rank Level ]--\n"
			query = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` < 3 ORDER BY `experience` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("level") .. "]"
				k = k + 1 until not query:next()
			end
		end
		doShowTextDialog(cid, 5785, str)
	end
end
	
function onSay(cid, words, param)
	addDialog(modaldialog2, 1002, cid, callback2);
	return true
end

     

    vodkart_logo.png

    [*Ninguém será digno do sucesso se não usar suas derrotas para conquistá-lo.*]

     

    DISCORD: vodkart#6090

     

  • Citar
  • Mention
    • Postado
    • Autor
    1 hora atrás, Vodkart disse: 
    
modaldialog2 = {
	title = "Rank System",
	message = "Selecione a classificação que você quer ver:",
	buttons = {
		{ id = 1, value = "Ver" },
		{ id = 2, value = "Sair" },
	},
	buttonEnter = 1,
	buttonEscape = 2,
	choices = {
		{ id = 1, value = "Rank Soco" },
		{ id = 2, value = "Rank Clava" },
		{ id = 3, value = "Rank Espada" },
		{ id = 4, value = "Rank Machado" },
		{ id = 5, value = "Rank Distancia" },
		{ id = 6, value = "Rank Escudo" },
		{ id = 7, value = "Rank Pesca" },
		{ id = 8, value = "Rank Magia" },
		{ id = 9, value = "Rank Level" }
	},
	popup = false
}
function getGroupDb(player_id)
	local query = db.getResult("SELECT `group_id` FROM `players` WHERE `id`= "..player_id)
	return query:getDataInt("group_id")
end
function callback2(cid, button, choice)
	if (button == 1) then
		local str = ""
		if (choice == 1) then
			str = "--[ Rank Soco ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 0 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 2) then
			str = "--[ Rank Clava ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 1 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 3) then
			str = "--[ Rank Espada ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 2 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 4) then
			str = "--[ Rank Machado ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 3 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 5) then
			str = "--[ Rank Distancia ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 4 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 6) then
			str = "--[ Rank Escudo ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 5 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 7) then
			str = "--[ Rank Pesca ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 6 ORDER BY `value` DESC LIMIT 20;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 8) then
			str = "--[ Rank Magia ]--\n"
			query = db.getResult("SELECT `maglevel`, `name` FROM `players` WHERE `group_id` < 3 ORDER BY `maglevel` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("maglevel") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 9) then
			str = "--[ Rank Level ]--\n"
			query = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` < 3 ORDER BY `experience` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("level") .. "]"
				k = k + 1 until not query:next()
			end
		end
		doShowTextDialog(cid, 5785, str)
	end
end
	
function onSay(cid, words, param)
	addDialog(modaldialog2, 1002, cid, callback2);
	return true
end

     

    no distancia o adm aparece é no rank magia é rank level aparece o account mananger o resto deu certo tem como arruma por favor?

    758x426.bmp

  • Citar
  • Mention
    • Postado 
    modaldialog2 = {
	title = "Rank System",
	message = "Selecione a classificação que você quer ver:",
	buttons = {
		{ id = 1, value = "Ver" },
		{ id = 2, value = "Sair" },
	},
	buttonEnter = 1,
	buttonEscape = 2,
	choices = {
		{ id = 1, value = "Rank Soco" },
		{ id = 2, value = "Rank Clava" },
		{ id = 3, value = "Rank Espada" },
		{ id = 4, value = "Rank Machado" },
		{ id = 5, value = "Rank Distancia" },
		{ id = 6, value = "Rank Escudo" },
		{ id = 7, value = "Rank Pesca" },
		{ id = 8, value = "Rank Magia" },
		{ id = 9, value = "Rank Level" }
	},
	popup = false
}
function getGroupDb(player_id)
	local query = db.getResult("SELECT `group_id` FROM `players` WHERE `id`= "..player_id)
	return query:getDataInt("group_id")
end
function callback2(cid, button, choice)
	if (button == 1) then
		local str = ""
		if (choice == 1) then
			str = "--[ Rank Soco ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 0 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 2) then
			str = "--[ Rank Clava ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 1 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 3) then
			str = "--[ Rank Espada ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 2 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 4) then
			str = "--[ Rank Machado ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 3 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 5) then
			str = "--[ Rank Distancia ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 4 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 6) then
			str = "--[ Rank Escudo ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 5 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 7) then
			str = "--[ Rank Pesca ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 6 ORDER BY `value` DESC LIMIT 20;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 8) then
			str = "--[ Rank Magia ]--\n"
			query = db.getResult("SELECT `maglevel`, `name` FROM `players` WHERE `id` > 6 AND `group_id` < 3 ORDER BY `maglevel` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("maglevel") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 9) then
			str = "--[ Rank Level ]--\n"
			query = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `id` > 6 AND `group_id` < 3 ORDER BY `experience` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("level") .. "]"
				k = k + 1 until not query:next()
			end
		end
		doShowTextDialog(cid, 5785, str)
	end
end
	
function onSay(cid, words, param)
	addDialog(modaldialog2, 1002, cid, callback2);
	return true
end

     

    vodkart_logo.png

    [*Ninguém será digno do sucesso se não usar suas derrotas para conquistá-lo.*]

     

    DISCORD: vodkart#6090

     

  • Citar
  • Mention
    • Postado
    • Autor
    Em 01/06/2018 em 17:57, Vodkart disse: 
    
modaldialog2 = {
	title = "Rank System",
	message = "Selecione a classificação que você quer ver:",
	buttons = {
		{ id = 1, value = "Ver" },
		{ id = 2, value = "Sair" },
	},
	buttonEnter = 1,
	buttonEscape = 2,
	choices = {
		{ id = 1, value = "Rank Soco" },
		{ id = 2, value = "Rank Clava" },
		{ id = 3, value = "Rank Espada" },
		{ id = 4, value = "Rank Machado" },
		{ id = 5, value = "Rank Distancia" },
		{ id = 6, value = "Rank Escudo" },
		{ id = 7, value = "Rank Pesca" },
		{ id = 8, value = "Rank Magia" },
		{ id = 9, value = "Rank Level" }
	},
	popup = false
}
function getGroupDb(player_id)
	local query = db.getResult("SELECT `group_id` FROM `players` WHERE `id`= "..player_id)
	return query:getDataInt("group_id")
end
function callback2(cid, button, choice)
	if (button == 1) then
		local str = ""
		if (choice == 1) then
			str = "--[ Rank Soco ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 0 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 2) then
			str = "--[ Rank Clava ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 1 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 3) then
			str = "--[ Rank Espada ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 2 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 4) then
			str = "--[ Rank Machado ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 3 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 5) then
			str = "--[ Rank Distancia ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 4 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 6) then
			str = "--[ Rank Escudo ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 5 ORDER BY `value` DESC;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 7) then
			str = "--[ Rank Pesca ]--\n"
			query = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 6 ORDER BY `value` DESC LIMIT 20;")
			if (query:getID() ~= -1) then 
			k = 1 
			repeat 
			if k > 20 then break end
			if getGroupDb(query:getDataString("player_id")) < 3 then	
				str = str .. "\n " .. k .. ". "..(getPlayerNameByGUID(query:getDataString("player_id"))).." - [" .. query:getDataInt("value") .. "]"
				k = k + 1 
			end
				until not query:next()
			end
		elseif (choice == 8) then
			str = "--[ Rank Magia ]--\n"
			query = db.getResult("SELECT `maglevel`, `name` FROM `players` WHERE `id` > 6 AND `group_id` < 3 ORDER BY `maglevel` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("maglevel") .. "]"
				k = k + 1 until not query:next()
			end
		elseif (choice == 9) then
			str = "--[ Rank Level ]--\n"
			query = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `id` > 6 AND `group_id` < 3 ORDER BY `experience` DESC LIMIT 20;")
			if (query:getID() ~= -1) then k = 1 repeat if k > 20 then break end
				str = str .. "\n " .. k .. ". "..(query:getDataString("name")).." - [" .. query:getDataInt("level") .. "]"
				k = k + 1 until not query:next()
			end
		end
		doShowTextDialog(cid, 5785, str)
	end
end
	
function onSay(cid, words, param)
	addDialog(modaldialog2, 1002, cid, callback2);
	return true
end

     

    image.png.069308c5a5213b4f2ffcab22ac4064a8.pngos demais estão correto porem o rank de level não aparece os player...

    758x426.bmp

  • Citar
  • Mention

    • Participe da conversa

    Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

    Visitante
    Responder
    Ir para a lista de tópicos

    Quem Está Navegando 0

    • Nenhum usuário registrado visualizando esta página.

    Estatísticas dos Fóruns

    • Tópicos 96.9k
    • Posts 520.1k

    Informação Importante

    Confirmação de Termo

    I accept