env = assert(luasql.mysql())
con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))
if param == "level" or param == "exp" or param == "lvl" then
local topPlayers = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` <= "..maxgroupid.." ORDER BY `experience` DESC LIMIT 0,"..players..";")
str = "# [Level] - Name - (Experience)\n"
local i = 0
local level = topPlayers:getDataInt(level)
local name = topPlayers:getDataString(name)
local experience = topPlayers:getDataInt(experience)
while(true) do
str = str.."\n#"..(i+1).." ["..level.."] - "..name.." - ("..experience..")"
i = i+1
if not(topPlayers:next()) then
break
end
end
topPlayers:free()
[17/11/2008 12:56:10] Error during getDataInt().
[17/11/2008 12:56:10] Error during getDataString().
[17/11/2008 12:56:10] Error during getDataInt().
<!-- Highscore Book -->
<action itemid="1981" function="highscoreBook"/>
Sorry for bumping this post, but does anyone knows how to make this work on TFS 0.3?
I couldn't make it work:
(part of the code, I don't think the whole code is needed, just the part that gets the data from the database)
PHP:if param == "level" or param == "exp" or param == "lvl" then local topPlayers = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` <= "..maxgroupid.." ORDER BY `experience` DESC LIMIT 0,"..players..";") str = "# [Level] - Name - (Experience)\n" local i = 0 local level = topPlayers:getDataInt(level) local name = topPlayers:getDataString(name) local experience = topPlayers:getDataInt(experience) while(true) do str = str.."\n#"..(i+1).." ["..level.."] - "..name.." - ("..experience..")" i = i+1 if not(topPlayers:next()) then break end end topPlayers:free()
I get these errors:
result.getDataInt(resId, s)
result.getDataLong(resId, s)
result.getDataString(resId, s)
result.getDataStream(resId, s, length)
result.next(resId)
result.free(resId)
0.3 functions are:
Code:result.getDataInt(resId, s) result.getDataLong(resId, s) result.getDataString(resId, s) result.getDataStream(resId, s, length) result.next(resId) result.free(resId)
Lua script error: [TalkAction Interface]
data/talkactions/scripts/highscores.luanSay
data/talkactions/scripts/highscores.lua:7: attempt to index global 'luasql' < a nil value >
stack traceback:
data/talkactions/scripts/highscores.lua:7: in function <data/talkactions/scripts/highscores.lua:1>
i have downloaded the version 0.3, but i got this error