1
[Talkactions] Alguna script?? el Sáb Dic 23, 2017 1:47 am
kgjunior91

Nuevo Miembro

para que se vea los rebirths que llevan los players???
igual que el level, el magic, y las skills??
Tibiaface | Una comunidad Open Tibia donde encontras : mapas, scripts, Otserver, npc y amigos etc ...
function onSay(cid, words, param)
local players = 20 -- How many players will be showed in the highscore
local str = ""
local name = ""
local player_id = 0
local result = nil
local result2 = nil
local first_val = ""
local first_nam = ""
str = "# [Rebirths] - Name\n"
name = "name"
result = db.getResult("SELECT `player_id`, (`value` * 1) AS `value` FROM `player_storage` WHERE `key` = 85987 ORDER BY `value` DESC;")
result2 = db.getResult("SELECT `name` FROM `players` WHERE id = "..result:getDataString("player_id")..";")
first_val = result:getDataString("value")
first_nam = result2:getDataString("name")
str = str.."\n ".."1. ["..first_val.."] - "..first_nam
if (result:getID() ~= -1) then
local i = 2
while TRUE do
if not(result:next()) or i > players then
break
end
result2 = db.getResult("SELECT `name` FROM `players` WHERE id = "..result:getDataString("player_id")..";")
str = str .. "\n " .. i .. ". [" .. result:getDataString("value") .. "] - " .. (name ~= "" and result2:getDataString("name") or getPlayerNameByGUID(result:getDataInt(player_id)))
i = i+1
result2:free()
end
result:free()
end
if str ~= "" then
doPlayerPopupFYI(cid, str)
end
return TRUE
end
<talkaction words="!rank rebirth" event="script" value="rank rebirth.lua"/>
function onSay(cid, words, param)
-- max players on the highscore
local players = 20 -- The amount of players that is shown in the list
-- don't touch --
local str = ""
local value = ""
local name = ""
local player_id = 0
local result = nil
if param == "level" or param == "exp" or param == "lvl" then
str = "# [Level] - Name\n"
value = "level"
name = "name"
result = db.getResult("SELECT `level`, `name` FROM `players` ORDER BY `level` DESC, `name` ASC;")
elseif param == "magiclevel" or param == "magic" or param == "mlevel" or param == "ml" then
str = "# [Magic Level] - Name\n"
value = "maglevel"
name = "name"
result = db.getResult("SELECT `name`, `maglevel` FROM `players` ORDER BY `maglevel` DESC, `name` ASC;")
elseif param == "fist" then
str = "# [Fist] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 0 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "club" then
str = "# [Club] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 1 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "sword" then
str = "# [Sword] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 2 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "axe" then
str = "# [Axe] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 3 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "dist" or param == "distance" then
str = "# [Distance] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 4 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "shield" or param == "shielding" then
str = "# [Shield] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 5 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "fish" or param == "fishing" then
str = "# [Fishing] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 6 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "Rebirth" or param == "reb" then
str = "# [Rebirths] - Name\n"
value = "Rebirths"
name = "name"
result = db.getResult("SELECT `Rebirths`, `name` FROM `players` ORDER BY `Rebirths` DESC, `name` ASC;")
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Unbekannter skill: '" .. param .. "'")
return TRUE
end
if (result:getID() ~= -1) then
local i = 1
while TRUE do
if not(result:next()) or i > players then
break
end
str = str .. "\n " .. i .. ". [" .. result:getDataInt(value) .. "] - " .. (name ~= "" and result:getDataString("name") or getPlayerNameByGUID(result:getDataInt(player_id)))
i = i+1
end
result:free()
end
if str ~= "" then
doPlayerPopupFYI(cid, str)
end
return TRUE
end
<talkaction words="!highscore;!top;!high" event="script" value="highscore.lua"/>
function onSay(cid, words, param)
-- max players on the highscore
local players = 20 -- The amount of players that is shown in the list
-- don't touch --
local str = ""
local value = ""
local name = ""
local player_id = 0
local result = nil
if param == "level" or param == "exp" or param == "lvl" then
str = "# [Level] - Name\n"
value = "level"
name = "name"
result = db.getResult("SELECT `level`, `name` FROM `players` ORDER BY `level` DESC, `name` ASC;")
elseif param == "magiclevel" or param == "magic" or param == "mlevel" or param == "ml" then
str = "# [Magic Level] - Name\n"
value = "maglevel"
name = "name"
result = db.getResult("SELECT `name`, `maglevel` FROM `players` ORDER BY `maglevel` DESC, `name` ASC;")
elseif param == "fist" then
str = "# [Fist] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 0 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "club" then
str = "# [Club] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 1 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "sword" then
str = "# [Sword] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 2 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "axe" then
str = "# [Axe] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 3 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "dist" or param == "distance" then
str = "# [Distance] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 4 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "shield" or param == "shielding" then
str = "# [Shield] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 5 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "fish" or param == "fishing" then
str = "# [Fishing] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 6 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "Rebirth" or param == "reb" then
str = "# [Rebirths] - Name\n"
value = "Rebirths"
name = "name"
result = db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = 85987 ORDER BY `value` DESC, `player_id` ASC;")
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Unbekannter skill: '" .. param .. "'")
return TRUE
end
if (result:getID() ~= -1) then
local i = 1
while TRUE do
if not(result:next()) or i > players then
break
end
str = str .. "\n " .. i .. ". [" .. result:getDataInt(value) .. "] - " .. (name ~= "" and result:getDataString("name") or getPlayerNameByGUID(result:getDataInt(player_id)))
i = i+1
end
result:free()
end
if str ~= "" then
doPlayerPopupFYI(cid, str)
end
return TRUE
end
function onSay(cid, words, param)
-- max players on the highscore
local players = 20 -- The amount of players that is shown in the list
-- don't touch --
local str = ""
local value = ""
local name = ""
local player_id = 0
local result = nil
if param == "level" or param == "exp" or param == "lvl" then
str = "# [Level] - Name\n"
value = "level"
name = "name"
result = db.getResult("SELECT `level`, `name` FROM `players` ORDER BY `level` DESC, `name` ASC;")
elseif param == "magiclevel" or param == "magic" or param == "mlevel" or param == "ml" then
str = "# [Magic Level] - Name\n"
value = "maglevel"
name = "name"
result = db.getResult("SELECT `name`, `maglevel` FROM `players` ORDER BY `maglevel` DESC, `name` ASC;")
elseif param == "fist" then
str = "# [Fist] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 0 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "club" then
str = "# [Club] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 1 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "sword" then
str = "# [Sword] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 2 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "axe" then
str = "# [Axe] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 3 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "dist" or param == "distance" then
str = "# [Distance] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 4 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "shield" or param == "shielding" then
str = "# [Shield] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 5 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "fish" or param == "fishing" then
str = "# [Fishing] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 6 ORDER BY `value` DESC, `player_id` ASC;")
elseif param == "Rebirth" or param == "reb" then
str = "# [Rebirths] - Name\n"
value = "Rebirths"
name = "name"
result = db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = 85987 ORDER BY cast(value as INTEGER) DESC;")
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Unbekannter skill: '" .. param .. "'")
return TRUE
end
if (result:getID() ~= -1) then
local i = 1
while TRUE do
if not(result:next()) or i > players then
break
end
str = str .. "\n " .. i .. ". [" .. result:getDataInt(value) .. "] - " .. (name ~= "" and result:getDataString("name") or getPlayerNameByGUID(result:getDataInt(player_id)))
i = i+1
end
result:free()
end
if str ~= "" then
doPlayerPopupFYI(cid, str)
end
return TRUE
end
function onSay(cid, words, param)
local players = 20 -- How many players will be showed in the highscore
local str = ""
local name = ""
local player_id = 0
local result = nil
local result2 = nil
local first_val = ""
local first_nam = ""
str = "# [Rebirths] - Name\n"
name = "name"
result = db.getResult("SELECT `player_id`, (`value` * 1) AS `value` FROM `player_storage` WHERE `key` = 85987 ORDER BY `value` DESC;")
result2 = db.getResult("SELECT `name` FROM `players` WHERE id = "..result:getDataString("player_id")..";")
first_val = result:getDataString("value")
first_nam = result2:getDataString("name")
str = str.."\n ".."1. ["..first_val.."] - "..first_nam
if (result:getID() ~= -1) then
local i = 2
while TRUE do
if not(result:next()) or i > players then
break
end
result2 = db.getResult("SELECT `name` FROM `players` WHERE id = "..result:getDataString("player_id")..";")
str = str .. "\n " .. i .. ". [" .. result:getDataString("value") .. "] - " .. (name ~= "" and result2:getDataString("name") or getPlayerNameByGUID(result:getDataInt(player_id)))
i = i+1
result2:free()
end
result:free()
end
if str ~= "" then
doPlayerPopupFYI(cid, str)
end
return TRUE
end
Permisos de este foro:
No puedes responder a temas en este foro.
|
|