Lua Add a frag..

[knightxd]

i'm trying to add a frag to players in a creature event;

the part that add frags is

l = db.executeQuery("INSERT INTO `player_deaths` (`player_id`, `date`, `level`) VALUES (" .. getPlayerGUID(pid) .. ", " .. os.time() .. ", " .. getPlayerLevel(pid) .. ");")
j = db.executeQuery("INSERT INTO `killers` ('death_id', 'final_hit', 'unjustified') VALUES (" .. l .. ", 1, 1);")	
db.executeQuery("INSERT INTO `player_killers` (`kill_id`, `player_id`) VALUES (" .. j .. ", " .. getPlayerLevel(cid) .. ");")

ps. the part of add player deaths work just fine...

the other two is not because i don't know what id to use on the first entryes.. :S

 

[knightxd]

found a way.. close please

 

[Stellow]

function onKill(cid, target, damage, flags)
    if getCreatureName(target):lower() == "princess" then
    l = db.executeQuery("INSERT INTO `player_deaths` (`player_id`, `date`, `level`) VALUES (" .. getPlayerGUID(pid) .. ", " .. os.time() .. ", " .. getPlayerLevel(pid) .. ");")
j = db.executeQuery("INSERT INTO `killers` ('death_id', 'final_hit', 'unjustified') VALUES (" .. l .. ", 1, 1);")
db.executeQuery("INSERT INTO `player_killers` (`kill_id`, `player_id`) VALUES (" .. j .. ", " .. getPlayerLevel(cid) .. ");")
        return true
    end

not tested

posted by mistake! my bad.