that has nothing to do with my scriptsorry double post..
the script have problems in
advance, onlook, quest completed, etc... :S help? look.
PHP:[24/08/2011 13:53:58] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:53:58] [Error - CreatureScript Interface] [24/08/2011 13:53:58] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:53:58] Description: [24/08/2011 13:53:58] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:53:58] stack traceback: [24/08/2011 13:53:58] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:53:58] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:53:58] [Error - CreatureScript Interface] [24/08/2011 13:53:58] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:53:58] Description: [24/08/2011 13:53:58] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:53:58] stack traceback: [24/08/2011 13:53:58] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:53:58] [Error - CreatureScript Interface] [24/08/2011 13:53:58] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:53:58] Description: [24/08/2011 13:53:58] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:53:59] stack traceback: [24/08/2011 13:53:59] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:53:59] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:53:59] [Error - CreatureScript Interface] [24/08/2011 13:53:59] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:53:59] Description: [24/08/2011 13:53:59] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:53:59] stack traceback: [24/08/2011 13:53:59] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:53:59] [Error - CreatureScript Interface] [24/08/2011 13:53:59] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:53:59] Description: [24/08/2011 13:53:59] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:53:59] stack traceback: [24/08/2011 13:53:59] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:53:59] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:00] [Error - CreatureScript Interface] [24/08/2011 13:54:00] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:00] Description: [24/08/2011 13:54:00] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:00] stack traceback: [24/08/2011 13:54:00] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:00] [Error - CreatureScript Interface] [24/08/2011 13:54:00] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:00] Description: [24/08/2011 13:54:00] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:54:00] stack traceback: [24/08/2011 13:54:00] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:54:00] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:00] [Error - CreatureScript Interface] [24/08/2011 13:54:00] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:01] Description: [24/08/2011 13:54:01] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:01] stack traceback: [24/08/2011 13:54:01] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:01] [Error - CreatureScript Interface] [24/08/2011 13:54:01] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:01] Description: [24/08/2011 13:54:01] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:54:01] stack traceback: [24/08/2011 13:54:01] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:54:01] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:01] [Error - CreatureScript Interface] [24/08/2011 13:54:01] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:01] Description: [24/08/2011 13:54:02] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:02] stack traceback: [24/08/2011 13:54:02] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:02] [Error - CreatureScript Interface] [24/08/2011 13:54:02] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:02] Description: [24/08/2011 13:54:02] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:54:02] stack traceback: [24/08/2011 13:54:02] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:54:02] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:02] [Error - CreatureScript Interface] [24/08/2011 13:54:02] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:02] Description: [24/08/2011 13:54:02] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:02] stack traceback: [24/08/2011 13:54:03] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:03] [Error - CreatureScript Interface] [24/08/2011 13:54:03] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:03] Description: [24/08/2011 13:54:03] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:54:03] stack traceback: [24/08/2011 13:54:03] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:54:03] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:03] [Error - CreatureScript Interface] [24/08/2011 13:54:03] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:03] Description: [24/08/2011 13:54:03] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:03] stack traceback: [24/08/2011 13:54:03] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:04] [Error - CreatureScript Interface] [24/08/2011 13:54:04] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:04] Description: [24/08/2011 13:54:04] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:54:04] stack traceback: [24/08/2011 13:54:04] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:54:04] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:04] [Error - CreatureScript Interface] [24/08/2011 13:54:04] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:04] Description: [24/08/2011 13:54:04] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:05] stack traceback: [24/08/2011 13:54:05] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:05] [Error - CreatureScript Interface] [24/08/2011 13:54:05] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:05] Description: [24/08/2011 13:54:05] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:54:05] stack traceback: [24/08/2011 13:54:05] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:54:05] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:05] [Error - CreatureScript Interface] [24/08/2011 13:54:05] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:05] Description: [24/08/2011 13:54:05] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:06] stack traceback: [24/08/2011 13:54:06] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:06] [Error - CreatureScript Interface] [24/08/2011 13:54:06] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:06] Description: [24/08/2011 13:54:06] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:54:06] stack traceback: [24/08/2011 13:54:06] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:54:06] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:06] [Error - CreatureScript Interface] [24/08/2011 13:54:06] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:06] Description: [24/08/2011 13:54:06] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:07] stack traceback: [24/08/2011 13:54:07] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:07] [Error - CreatureScript Interface] [24/08/2011 13:54:07] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:07] Description: [24/08/2011 13:54:07] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:54:07] stack traceback: [24/08/2011 13:54:07] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:54:07] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:08] [Error - CreatureScript Interface] [24/08/2011 13:54:08] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:08] Description: [24/08/2011 13:54:08] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:08] stack traceback: [24/08/2011 13:54:08] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:08] [Error - CreatureScript Interface] [24/08/2011 13:54:08] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:08] Description: [24/08/2011 13:54:08] data/creaturescripts/scripts/FragsOnLook.lua:13: attempt to call field 'insert' (a nil value) [24/08/2011 13:54:08] stack traceback: [24/08/2011 13:54:08] data/creaturescripts/scripts/FragsOnLook.lua:13: in function 'getPlayerFrags' [24/08/2011 13:54:09] data/creaturescripts/scripts/FragsOnLook.lua:36: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:09] [Error - CreatureScript Interface] [24/08/2011 13:54:09] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:09] Description: [24/08/2011 13:54:09] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:09] stack traceback: [24/08/2011 13:54:09] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:09] [Error - CreatureScript Interface] [24/08/2011 13:54:09] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:09] Description: [24/08/2011 13:54:09] data/creaturescripts/scripts/FragsOnLook.lua:22: attempt to call field 'maxn' (a nil value) [24/08/2011 13:54:09] stack traceback: [24/08/2011 13:54:09] data/creaturescripts/scripts/FragsOnLook.lua:22: in function 'getPlayerFrags' [24/08/2011 13:54:10] data/creaturescripts/scripts/FragsOnLook.lua:39: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:10] [Error - CreatureScript Interface] [24/08/2011 13:54:10] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:10] Description: [24/08/2011 13:54:10] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:10] stack traceback: [24/08/2011 13:54:10] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1> [24/08/2011 13:54:10] [Error - CreatureScript Interface] [24/08/2011 13:54:10] data/creaturescripts/scripts/FragsOnLook.lua:onLook [24/08/2011 13:54:10] Description: [24/08/2011 13:54:11] data/creaturescripts/scripts/FragsOnLook.lua:22: attempt to call field 'maxn' (a nil value) [24/08/2011 13:54:11] stack traceback: [24/08/2011 13:54:11] data/creaturescripts/scripts/FragsOnLook.lua:22: in function 'getPlayerFrags' [24/08/2011 13:54:11] data/creaturescripts/scripts/FragsOnLook.lua:39: in function <data/creaturescripts/scripts/FragsOnLook.lua:34> [24/08/2011 13:54:11] [Error - CreatureScript Interface] [24/08/2011 13:54:11] data/creaturescripts/scripts/questLook.lua:onLook [24/08/2011 13:54:11] Description: [24/08/2011 13:54:11] data/creaturescripts/scripts/questLook.lua:7: attempt to call field '?' (a nil value) [24/08/2011 13:54:11] stack traceback: [24/08/2011 13:54:11] data/creaturescripts/scripts/questLook.lua:7: in function <data/creaturescripts/scripts/questLook.lua:1>
add in any file of /data/lib/
Lua:
function getPlayerFrags(cid)
local time = os.time()
local times = {today = (time - 86400), week = (time - (7 * 86400))}
local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")
if(result:getID() ~= -1) then
repeat
local content = {date = result:getDataInt("date")}
if(content.date > times.today) then
table.insert(contents.day, content)
elseif(content.date > times.week) then
table.insert(contents.week, content)
else
table.insert(contents.month, content)
end
until not result:next()
result:free()
end
local size = {
day = table.maxn(contents.day),
week = table.maxn(contents.week),
month = table.maxn(contents.month)
}
return size.day + size.week + size.month
end