[29/2/2016 21:30:46] function getDeathsPlayer(cid)
[29/2/2016 21:30:46] local Info = db.getResult("SELECT `deaths` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
[29/2/2016 21:30:46] local deaths= Info:getDataInt("deaths")
[29/2/2016 21:30:46] return deaths
[29/2/2016 21:30:46] end
[29/2/2016 21:30:46] if isPlayer(thing.uid) then
[29/2/2016 21:30:46] local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
[29/2/2016 21:30:46] doPlayerSetSpecialDescription(thing.uid, (getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " has Killed: ["..getKillsPlayer(thing.uid).."] Players."..(getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " has Died: ["..getDeathsPlayer(thing.uid).."] Times.\nThe Kdr(Kill Death Ratio) is: ["..kdr.."].")
[29/2/2016 21:30:46] end
[29/2/2016 21:30:46] if(thing.uid == cid) then
[29/2/2016 21:30:46] local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
[29/2/2016 21:30:46] doPlayerSetSpecialDescription(thing.uid, "\nYou have Killed: ["..getKillsPlayer(thing.uid).."] Players.\nYou have Died: ["..getDeathsPlayer(thing.uid).."] Times.\nYou Kdr(Kill Death Ratio) is: ["..kdr.."].")
[29/2/2016 21:30:46] end
[29/2/2016 21:30:46] return true
[29/2/2016 21:30:46] end
[29/2/2016 21:30:46]
nLook
[29/2/2016 21:30:46] Description:
[29/2/2016 21:30:46] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[29/2/2016 21:30:46] stack traceback:
[29/2/2016 21:30:46] [C]: in function 'error'
[29/2/2016 21:30:46] data/lib/004-database.lua:60: in function 'getDataInt'
[29/2/2016 21:30:46] [string "LuaInterface::loadBuffer"]:4: in function 'getKillsPlayer'
[29/2/2016 21:30:46] [string "LuaInterface::loadBuffer"]:14: in function <[string "LuaInterface::loadBuffer"]:1>
[29/2/2016 21:30:46] mysql_real_query(): SELECT `frags` FROM `players` WHERE `id` = 5 LIMIT 1 - MYSQL ERROR: Unknown column 'frags' in 'field list' (1054)
[29/2/2016 21:30:46] [Error - CreatureScript Interface]
[29/2/2016 21:30:46] function onLook(cid, thing, position, lookDistance)
[29/2/2016 21:30:46] function getKillsPlayer(cid)
[29/2/2016 21:30:46] local Info = db.getResult("SELECT `frags` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
[29/2/2016 21:30:46] local frags= Info:getDataInt("frags")
[29/2/2016 21:30:46] return frags
[29/2/2016 21:30:46] end
[29/2/2016 21:30:46] function getDeathsPlayer(cid)
[29/2/2016 21:30:46] local Info = db.getResult("SELECT `deaths` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
[29/2/2016 21:30:46] local deaths= Info:getDataInt("deaths")
[29/2/2016 21:30:46] return deaths
[29/2/2016 21:30:46] end
[29/2/2016 21:30:46] if isPlayer(thing.uid) then
[29/2/2016 21:30:46] local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
[29/2/2016 21:30:46] doPlayerSetSpecialDescription(thing.uid, (getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " has Killed: ["..getKillsPlayer(thing.uid).."] Players."..(getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " has Died: ["..getDeathsPlayer(thing.uid).."] Times.\nThe Kdr(Kill Death Ratio) is: ["..kdr.."].")
[29/2/2016 21:30:46] end
[29/2/2016 21:30:46] if(thing.uid == cid) then
[29/2/2016 21:30:46] local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
[29/2/2016 21:30:46] doPlayerSetSpecialDescription(thing.uid, "\nYou have Killed: ["..getKillsPlayer(thing.uid).."] Players.\nYou have Died: ["..getDeathsPlayer(thing.uid).."] Times.\nYou Kdr(Kill Death Ratio) is: ["..kdr.."].")
[29/2/2016 21:30:46] end
[29/2/2016 21:30:46] return true
[29/2/2016 21:30:46] end
[29/2/2016 21:30:46]
nLook
[29/2/2016 21:30:46] Description:
[29/2/2016 21:30:46] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[29/2/2016 21:30:46] stack traceback:
[29/2/2016 21:30:46] [C]: in function 'error'
[29/2/2016 21:30:46] data/lib/004-database.lua:60: in function 'getDataInt'
[29/2/2016 21:30:46] [string "LuaInterface::loadBuffer"]:4: in function 'getKillsPlayer'
[29/2/2016 21:30:46] [string "LuaInterface::loadBuffer"]:14: in function <[string "LuaInterface::loadBuffer"]:1>
not look profil character