TFS 0.3.4 Death not working!

[Danjelos]

When someone die on my ot its working great, but its not showing on the homepage etc.

  local config = {
        deathListEnabled = getBooleanFromString(getConfigInfo('deathListEnabled')),
        sqlType = getConfigInfo('sqlType'),
        maxDeathRecords = getConfigInfo('maxDeathRecords')
}

config.sqlType = config.sqlType == "sqlite" and DATABASE_ENGINE_SQLITE or DATABASE_ENGINE_MYSQL

function onDeath(cid, corpse, lastHitKiller, mostDamageKiller)
        if(config.deathListEnabled ~= TRUE) then
                return
        end

        local hitKillerName = "field item"
        local damageKillerName = ""
        if(lastHitKiller ~= FALSE) then
                if(isPlayer(lastHitKiller) == TRUE) then
                        hitKillerName = getPlayerGUID(lastHitKiller)
                else
                        hitKillerName = getCreatureName(lastHitKiller)
                end

                if(mostDamageKiller ~= FALSE and mostDamageKiller ~= lastHitKiller and getCreatureName(mostDamageKiller) ~= getCreatureName(lastHitKiller)) then
                        if(isPlayer(mostDamageKiller) == TRUE) then
                                damageKillerName = getPlayerGUID(mostDamageKiller)
                        else
                                damageKillerName = getCreatureName(mostDamageKiller)
                        end
                end
        end

        db.executeQuery("INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `altkilled_by`) VALUES (" .. getPlayerGUID(cid) .. ", " .. os.time() .. ", " .. getPlayerLevel(cid) .. ", " .. db.escapeString(hitKillerName) .. ", " .. db.escapeString(damageKillerName) .. ");")
        local rows = db.getResult("SELECT `player_id` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. ";")
        if(rows:getID() ~= -1) then
                local amount = rows:getRows(true) - config.maxDeathRecords
                if(amount > 0) then
                        if(config.sqlType == DATABASE_ENGINE_SQLITE) then
                                for i = 1, amount do
                                        db.executeQuery("DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT 1);")
                                end
                        else
                                db.executeQuery("DELETE FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT " .. amount .. ";")
                        end
                end
        end
end

GEting this in /phpmyadmin

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003 sec

and i cant click on "browse" aswell on player_death

 

[DarkstaR]

Re-Import the latest forgottenserver.SQL file

__________________

Are you tired of the customer neglect of TibiaBotNG? Do you think LoW needs to add more updates? Are you tired of using a crappy bot because its a cheap alternative to Elf? Well, dont be tired anymore! Check out my blog!
​

 

[Danjelos]

Its not working, the database dosent register player deaths!