Problem With KdR CreatureEvent

[cooleo561]

Hey, Im just messing around with a war server atm and I added a show frags script made by Narko (Official Link: http://otland.net/threads/k-d-ratio-system-by-narko.168501/) and everytime somebody is about to die they just stay alive with no health and I get this error on the server. I am currently running cryingdamson 0.3.6 (8.60) V8.2, and I'm just wondering if anybody knows what the problem is... thanks

 

[Summ]

Try replacing:
db.query
with:
db.executeQuery

 

[cooleo561]

Ok I will try that

 

[Summ]

You are missing an end at the end of the script.

 

[cooleo561]

Yeah I just took it out, I realized what was wrong and fixed that

EDIT:

Ok so I changed the script a little bit and didn't receive any errors at all, But I had two test chars and I killed the one with the other, but I still have a problem with the person dying, they just sit at 0 HP but can still move around, they just won't die , any suggestions?

 

[Summ]

Why wouldn't you post the script lol

 

[cooleo561]

Why wouldn't you post the script lol

I didnt get any script errors but one second, there are 3 scripts and I'll post them all

onkill.lua

    function onKill(cid, target, damage, flags)
if isPlayer(target) == true then
db.executeQuery("UPDATE `players` SET `frags` = `frags` + 1 WHERE id = " .. getPlayerGUID(cid) .. ";")
doCreatureSay(cid, '+1 Frag Point!', TALKTYPE_ORANGE_1)
end
end

onlook.lua

function onLook(cid, thing, position, lookDistance)
function getKillsPlayer(cid)
local Info = db.getResult("SELECT `frags` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
local frags= Info:getDataInt("frags")
return frags
end

function getDeathsPlayer(cid)
local Info = db.getResult("SELECT `deaths` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
local deaths= Info:getDataInt("deaths")
return deaths
end
if isPlayer(thing.uid) then
local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
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.."].")
end
if(thing.uid == cid) then
local kdr = getKillsPlayer(thing.uid)/getDeathsPlayer(thing.uid)
doPlayerSetSpecialDescription(thing.uid, "\nYou have Killed: ["..getKillsPlayer(thing.uid).."] Players.\nYou have Died: ["..getDeathsPlayer(thing.uid).."] Times.\nYou Kdr(Kill Death Ratio) is: ["..kdr.."].")
end
return true
end

onpd.lua

function onPrepareDeath(cid, deathList, lastHitKiller, mostDamageKiller)
if isPlayer(cid) == true then
db.executeQuery("UPDATE `players` SET `deaths` = `deaths` + 1 WHERE id = " .. getPlayerGUID(cid) .. ";")
doCreatureSay(cid, '+1 Death Point!', TALKTYPE_ORANGE_1)
end

return true
end

And here's the SQL script

ALTER TABLE `players` ADD `frags` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `deaths` INT( 11 ) NOT NULL DEFAULT '0';

 

[Limos]

Add return true above the last end of the onKill script.