When i try to look at other players the server freezes for a few seconds then i get these errors.
[30/7/2015 18:47:12] mysql_real_query(): SELECT `frags` FROM `players` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'frags' in 'field list' (1054)
[30/7/2015 18:47:12] [Error - CreatureScript Interface]
[30/7/2015 18:47:12] function onLook(cid, thing, position, lookDistance)
[30/7/2015 18:47:13] function getKillsPlayer(cid)
[30/7/2015 18:47:13] local Info = db.getResult("SELECT `frags` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
[30/7/2015 18:47:13] local frags= Info:getDataInt("frags")
[30/7/2015 18:47:13] return frags
[30/7/2015 18:47:13] end
[30/7/2015 18:47:13] function getDeathsPlayer(cid)
[30/7/2015 18:47:13] local Info = db.getResult("SELECT `deaths` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
[30/7/2015 18:47:14] local deaths= Info:getDataInt("deaths")
[30/7/2015 18:47:14] return deaths
[30/7/2015 18:47:14] end
[30/7/2015 18:47:14] if isPlayer(thing.uid) then
[30/7/2015 18:47:14] local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
[30/7/2015 18:47:14] doPlayerSetSpecialDescription(thing.uid, (getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " Kills: ["..getKillsPlayer(thing.uid).."] "..(getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " Death: ["..getDeathsPlayer(thing.uid).."] \nPVP Rating:["..kdr.."] ")
[30/7/2015 18:47:14] end
[30/7/2015 18:47:14] if(thing.uid == cid) then
[30/7/2015 18:47:14] local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
[30/7/2015 18:47:14] doPlayerSetSpecialDescription(thing.uid, "\nKills: ["..getKillsPlayer(thing.uid).."] \nDeath: ["..getDeathsPlayer(thing.uid).."] \nPVP Rating: ["..kdr.."] \nPrestiges: ["..getCreatureStorage(thing.uid, 85987).."] \nLevel: ["..getPlayerLevel(thing.uid).."] \n")
[30/7/2015 18:47:15] end
[30/7/2015 18:47:15] return true
[30/7/2015 18:47:15] end
[30/7/2015 18:47:15]
nLook
[30/7/2015 18:47:15] Description:
[30/7/2015 18:47:15] data/lib/004-database.lua:66: [Result:getDataInt] Result not set!
[30/7/2015 18:47:15] stack traceback:
[30/7/2015 18:47:15] [C]: in function 'error'
[30/7/2015 18:47:15] data/lib/004-database.lua:66: in function 'getDataInt'
[30/7/2015 18:47:15] [string "LuaInterface::loadBuffer"]:4: in function 'getKillsPlayer'
[30/7/2015 18:47:16] [string "LuaInterface::loadBuffer"]:14: in function <[string "LuaInterface::loadBuffer"]:1>
[30/7/2015 18:47:12] mysql_real_query(): SELECT `frags` FROM `players` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'frags' in 'field list' (1054)
[30/7/2015 18:47:12] [Error - CreatureScript Interface]
[30/7/2015 18:47:12] function onLook(cid, thing, position, lookDistance)
[30/7/2015 18:47:13] function getKillsPlayer(cid)
[30/7/2015 18:47:13] local Info = db.getResult("SELECT `frags` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
[30/7/2015 18:47:13] local frags= Info:getDataInt("frags")
[30/7/2015 18:47:13] return frags
[30/7/2015 18:47:13] end
[30/7/2015 18:47:13] function getDeathsPlayer(cid)
[30/7/2015 18:47:13] local Info = db.getResult("SELECT `deaths` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
[30/7/2015 18:47:14] local deaths= Info:getDataInt("deaths")
[30/7/2015 18:47:14] return deaths
[30/7/2015 18:47:14] end
[30/7/2015 18:47:14] if isPlayer(thing.uid) then
[30/7/2015 18:47:14] local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
[30/7/2015 18:47:14] doPlayerSetSpecialDescription(thing.uid, (getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " Kills: ["..getKillsPlayer(thing.uid).."] "..(getPlayerSex(thing.uid) == 0 and "\nShe" or "\nHe") .. " Death: ["..getDeathsPlayer(thing.uid).."] \nPVP Rating:["..kdr.."] ")
[30/7/2015 18:47:14] end
[30/7/2015 18:47:14] if(thing.uid == cid) then
[30/7/2015 18:47:14] local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
[30/7/2015 18:47:14] doPlayerSetSpecialDescription(thing.uid, "\nKills: ["..getKillsPlayer(thing.uid).."] \nDeath: ["..getDeathsPlayer(thing.uid).."] \nPVP Rating: ["..kdr.."] \nPrestiges: ["..getCreatureStorage(thing.uid, 85987).."] \nLevel: ["..getPlayerLevel(thing.uid).."] \n")
[30/7/2015 18:47:15] end
[30/7/2015 18:47:15] return true
[30/7/2015 18:47:15] end
[30/7/2015 18:47:15]
[30/7/2015 18:47:15] Description:
[30/7/2015 18:47:15] data/lib/004-database.lua:66: [Result:getDataInt] Result not set!
[30/7/2015 18:47:15] stack traceback:
[30/7/2015 18:47:15] [C]: in function 'error'
[30/7/2015 18:47:15] data/lib/004-database.lua:66: in function 'getDataInt'
[30/7/2015 18:47:15] [string "LuaInterface::loadBuffer"]:4: in function 'getKillsPlayer'
[30/7/2015 18:47:16] [string "LuaInterface::loadBuffer"]:14: in function <[string "LuaInterface::loadBuffer"]:1>