Rank Reset Fika Tudo Limpo Sem Nome De Jogador

[admpaktuz 0]

Viu , eu peguei um rank de reset no Devil , dai eu fiz tudo ,

 

só que quando eu falo !rank reset , aparece a telinha

 

Rank reset - Nome do Jogador

 

só que nao aparce nada em baixo

Editado Outubro 22, 2010 por admpaktuz

[Vodkart 1515]

é porque tem que mudar o valor da storage no script

a storage do devilmoon não era 1020...

[admpaktuz 0]

Vodkart ta 1020 mais nao aparece igual :S

 

isso Aki ta no Script Ranking !

 

-----------------------------------------------------------------------------------

 

function getPlayerNameByGUID2(n)

local c = db.getResult("SELECT `name` FROM `players` WHERE `id` = "..n..";")

if c:getID() == -1 then

return "SQL_ERROR["..n.."]"

end

return c:getDataString("name")

end

 

function onSay(cid, words, param)

local max = 10

local letters_to_next = 20

 

local skills = {

['fist'] = 0,

['club'] = 1,

['sword'] = 2,

['axe'] = 3,

['distance'] = 4,

['shielding'] = 5,

['fishing'] = 6,

['dist'] = 4,

['shield'] = 5,

['fish'] = 6,

}

local name_now

local name = "Highscore for level\n"

local rkn = 0

local no_break = 0

param = string.lower(param)

dofile('config.lua')

if param == "" or param == "level" and ( param ~= "magic" and param == "ml") and skills[param] == nil then

name = name.."\n"

name = name.."Rank Level - Nome do Jogador\n"

local v = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` <= 2 ORDER BY `experience` DESC LIMIT 0,"..(max)..";")

repeat

no_break = no_break +1

if v:getID() == -1 then

break

end

rkn = rkn+1

name_now, l = v:getDataString("name"), string.len(v:getDataString("name"))

space = ""

for i=1, letters_to_next-l do

space = space.." "

end

name = name..rkn..". "..v:getDataInt("level") .." - "..name_now..space.." ".."\n"

if no_break >= 20 then

break

end

until v:next() == false

 

elseif param == "magic" or param == "ml" then

name = name.."\n"

name = name.."Rank Magic - Nome do Jogador\n"

local v = db.getResult("SELECT `name`, `level`, `maglevel` FROM `players` WHERE `group_id` <= 2 ORDER BY `maglevel` DESC LIMIT 0,"..(max)..";")

repeat

if v:getID() == -1 then

break

end

rkn = rkn+1

name_now, l = v:getDataString("name"), string.len(v:getDataString("name"))

space = ""

for i=1, letters_to_next-l do

space = space.." "

end

name = name..rkn..". "..v:getDataInt("maglevel").." - "..name_now..space.." ".." ".."".."\n"

until v:next() == false

 

elseif param == "reset" or param == "resets" then

name = name.."\n"

name = name.."Rank Reset - Nome do Jogador\n"

local v = db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = 1020 ORDER BY cast(value as INTEGER) DESC;")

local kk = 0

 

repeat

if kk == max or v:getID() == -1 then

break

end

kk = kk+1

name_now, l = getPlayerNameByGUID2(v:getDataInt("player_id")), string.len(getPlayerNameByGUID2(v:getDataInt("player_id")))

space = ""

for i=1, letters_to_next-l do

space = space.." "

end

if name_now == nil then

name_now = 'sql error['..v:getDataInt("player_id")..']'

end

name = name..kk..". "..v:getDataInt("value").." - "..name_now..space.." \n"

until v:next() == false

 

elseif skills[param] ~= nil then

name = name.."\n"

name = name.."Rank "..param.." fighting - Nome do Jogador\n"

local v = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = "..skills[param].." ORDER BY `value` DESC;")

local kk = 0

 

repeat

if kk == max or v:getID() == -1 then

break

end

kk = kk+1

name_now, l = getPlayerNameByGUID2(v:getDataInt("player_id")), string.len(getPlayerNameByGUID2(v:getDataInt("player_id")))

space = ""

for i=1, letters_to_next-l do

space = space.." "

end

 

if name_now == nil then

name_now = 'sql error['..v:getDataInt("player_id")..']'

end

name = name..kk..". "..v:getDataInt("value").." - "..name_now..space.." \n"

until v:next() == false

end

if name ~= "Highscore\n" then

doPlayerPopupFYI(cid, name)

end

 

return TRUE

end

[netflat5 1]

Tenta usa este:

 

function getPlayerNameByGUID2(n) 
       local c = db.getResult("SELECT `name` FROM `players` WHERE `id` = "..n..";") 
       if c:getID() == -1 then 
               return "SQL_ERROR["..n.."]" 
       end 
               return c:getDataString("name") 
       end 

function onSay(cid, words, param) 
       local max = 10 
       local letters_to_next = 20 

local skills = { 
       ['fist'] = 0, 
       ['club'] = 1, 
       ['sword'] = 2, 
       ['axe'] = 3, 
       ['distance'] = 4, 
       ['shielding'] = 5, 
       ['fishing'] = 6, 
       ['dist'] = 4, 
       ['shield'] = 5, 
       ['fish'] = 6, 
} 
       local name_now 
       local name = "Highscore for level\n" 
       local rkn = 0 
       local no_break = 0 
               param = string.lower(param) 
               dofile('config.lua') 
   if param == "" or param == "level" and ( param ~= "magic" and param == "ml") and skills[param] == nil then 
               name = name.."\n" 
               name = name.."Rank Level - Nome do Jogador\n" 
       local v = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` <= 2 ORDER BY `experience` DESC LIMIT 0,"..(max)..";") 
       repeat 
               no_break = no_break +1 
       if v:getID() == -1 then 
       break 
       end 
               rkn = rkn+1 
               name_now, l = v:getDataString("name"), string.len(v:getDataString("name")) 
               space = "" 
       for i=1, letters_to_next-l do 
               space = space.." " 
       end 
               name = name..rkn..". "..v:getDataInt("level") .."  -  "..name_now..space.." ".."\n"  
       if no_break >= 20 then 
       break 
       end 
       until v:next() == false 

       elseif param == "magic" or param == "ml" then 
               name = name.."\n" 
               name = name.."Rank Magic - Nome do Jogador\n" 
       local v = db.getResult("SELECT `name`, `level`, `maglevel` FROM `players` WHERE `group_id` <= 2 ORDER BY `maglevel` DESC LIMIT 0,"..(max)..";") 
       repeat 
       if v:getID() == -1 then 
       break 
       end 
               rkn = rkn+1 
               name_now, l = v:getDataString("name"), string.len(v:getDataString("name")) 
               space = "" 
       for i=1, letters_to_next-l do 
               space = space.." " 
       end 
               name = name..rkn..". "..v:getDataInt("maglevel").."  -  "..name_now..space.." ".." ".."".."\n"  
       until v:next() == false 

   elseif param == "reset" or param == "resets" then 
       name = name.."Rank Reset - Nome do Jogador\n" 
   local v = db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = 1020 ORDER BY cast(value as INTEGER) DESC;") 
   local kk = 0 

   repeat 
   if kk == max or v:getID() == -1 then 
   break 
   end 
       kk = kk+1 
       name_now, l = getPlayerNameByGUID2(v:getDataInt("player_id")), string.len(getPlayerNameByGUID2(v:getDataInt("player_id"))) 
       space = "" 
   for i=1, letters_to_next-l do 
       space = space.." " 
   end 
   if name_now == nil then 
       name_now = 'sql error['..v:getDataInt("player_id")..']' 
   end 
       name = name..kk..". "..v:getDataInt("value").."  -  "..name_now..space.." ".." ".."".."\n"  
   until v:next() == false 

       elseif skills[param] ~= nil then 
               name = name.."\n" 
               name = name.."Rank "..param.." fighting - Nome do Jogador\n" 
       local v = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = "..skills[param].." ORDER BY `value` DESC;") 
       local kk = 0 

       repeat 
       if kk == max or v:getID() == -1 then 
       break 
       end 
               kk = kk+1 
               name_now, l = getPlayerNameByGUID2(v:getDataInt("player_id")), string.len(getPlayerNameByGUID2(v:getDataInt("player_id"))) 
               space = "" 
       for i=1, letters_to_next-l do 
               space = space.." " 
       end 
       if name_now == nil then 
               name_now = 'sql error['..v:getDataInt("player_id")..']' 
       end 
               name = name..kk..". "..v:getDataInt("value").."  -  "..name_now..space.." \n" 
       until v:next() == false 
       end 
       if name ~= "Highscore\n" then 
               doPlayerPopupFYI(cid, name)
       end

       return true
end

[admpaktuz 0]

Não deu certo igual , a meu ot é 8.4 :S fika tudo limpo mesma coisa , ta foda arruma :S:S

Rankreset.bmp

[Legendios2 1]

●Estou Precisando de arrumar esse script tbm, aparece tudo em branco. :v.v:

●Se alguém souber onde encontrar/existe? "rank reset" para site gesior... me passa o link please.

 

►Informações: Styller Yourots 8.54/8.57

►Mysql

 

Rank.lua ↓

function getPlayerNameByGUID2(n)          local c = db.getResult("SELECT `name` FROM `players` WHERE `id` = "..n..";")          if c:getID() == -1 then                  return "SQL_ERROR["..n.."]"          end                  return c:getDataString("name")          end    function onSay(cid, words, param)          local max = 10          local letters_to_next = 20    local skills = {          ['fist'] = 0,          ['club'] = 1,          ['sword'] = 2,          ['axe'] = 3,          ['distance'] = 4,          ['shielding'] = 5,          ['fishing'] = 6,          ['dist'] = 4,          ['shield'] = 5,          ['fish'] = 6,  }          local name_now          local name = "Highscore for level\n"          local rkn = 0          local no_break = 0                  param = string.lower(param)                  dofile('config.lua')      if param == "" or param == "level" and ( param ~= "magic" and param == "ml") and skills[param] == nil then                  name = name.."\n"                  name = name.."Rank Level - Nome do Jogador\n"          local v = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` <= 2 ORDER BY `experience` DESC LIMIT 0,"..(max)..";")          repeat                  no_break = no_break +1          if v:getID() == -1 then          break          end                  rkn = rkn+1                  name_now, l = v:getDataString("name"), string.len(v:getDataString("name"))                  space = ""          for i=1, letters_to_next-l do                  space = space.." "          end                  name = name..rkn..". "..v:getDataInt("level") .."  -  "..name_now..space.." ".."\n"           if no_break >= 20 then          break          end          until v:next() == false            elseif param == "magic" or param == "ml" then                  name = name.."\n"                  name = name.."Rank Magic - Nome do Jogador\n"          local v = db.getResult("SELECT `name`, `level`, `maglevel` FROM `players` WHERE `group_id` <= 2 ORDER BY `maglevel` DESC LIMIT 0,"..(max)..";")          repeat          if v:getID() == -1 then          break          end                  rkn = rkn+1                  name_now, l = v:getDataString("name"), string.len(v:getDataString("name"))                  space = ""          for i=1, letters_to_next-l do                  space = space.." "          end                  name = name..rkn..". "..v:getDataInt("maglevel").."  -  "..name_now..space.." ".." ".."".."\n"           until v:next() == false                elseif param == "reset" or param == "resets" then          name = name.."Rank Reset - Nome do Jogador\n"      local v = db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = 1020 ORDER BY cast(value as INTEGER) DESC;")      local kk = 0        repeat      if kk == max or v:getID() == -1 then      break      end          kk = kk+1          name_now, l = getPlayerNameByGUID2(v:getDataInt("player_id")), string.len(getPlayerNameByGUID2(v:getDataInt("player_id")))          space = ""      for i=1, letters_to_next-l do          space = space.." "      end      if name_now == nil then          name_now = 'sql error['..v:getDataInt("player_id")..']'      end          name = name..kk..". "..v:getDataInt("value").."  -  "..name_now..space.." ".." ".."".."\n"       until v:next() == false            elseif skills[param] ~= nil then                  name = name.."\n"                  name = name.."Rank "..param.." fighting - Nome do Jogador\n"          local v = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = "..skills[param].." ORDER BY `value` DESC;")          local kk = 0            repeat          if kk == max or v:getID() == -1 then          break          end                  kk = kk+1                  name_now, l = getPlayerNameByGUID2(v:getDataInt("player_id")), string.len(getPlayerNameByGUID2(v:getDataInt("player_id")))                  space = ""          for i=1, letters_to_next-l do                  space = space.." "          end          if name_now == nil then                  name_now = 'sql error['..v:getDataInt("player_id")..']'          end                  name = name..kk..". "..v:getDataInt("value").."  -  "..name_now..space.." \n"          until v:next() == false          end          if name ~= "Highscore\n" then                  doPlayerPopupFYI(cid, name)         end          return true end

 

Skytera 8.54/8.57