Got one problem when players die

[Velington]

I have check the database i have set 50 at loss_exp
I have check the console no errors there.
All my players lose normal exp but one of the players who have play there very long was downgraded from level 150 to level 1

Mabye someone know this problem and can help me out?

 

[Big M]

You maybe removed the skills in the database? It can happen sometimes when you are reseting characters.

 

[Velington]

I can check that just wait

EDIT: Skills table works!

 

[Velington]

Bump!

 

[Velington]

Need more help PLEASE!

 

[SpiderOT]

The one downgraded to lvl 1 has promotion?

 

[Velington]

yes

 

[SpiderOT]

You should use search cause this problem has been reported over and over
http://otland.net/search.php?searchid=1162119

 

[Velington]

The link don't work!

 

[SpiderOT]

weird
Anyway search for Keyword: lessloss

 

[Velington]

Can't you just give me the thread or the answer mabye?

 

[Ispiro]

Lazy much?

 

[znake]

Playerdeath.lua;

dofile("./config.lua")

function onDeath(cid, corpse, killer)
    doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You are dead.")
    if deathListEnabled == "yes" then
        if sqlType == "mysql" then
            env = assert(luasql.mysql())
            con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))
        else -- sqlite
            env = assert(luasql.sqlite3())
            con = assert(env:connect(sqliteDatabase))
        end
        local byPlayer = FALSE
        if killer == FALSE then
            killerName = "field item"
        else
            if isPlayer(killer) == TRUE then
                byPlayer = TRUE
            end
            killerName = getCreatureName(killer)
        end
        assert(con:execute("INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `is_player`) VALUES (" .. getPlayerGUID(cid) .. ", " .. os.time() .. ", " .. getPlayerLevel(cid) .. ", '" .. escapeString(killerName) .. "', " .. byPlayer .. ");"))
        local cursor = assert(con:execute("SELECT `player_id` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. ";"))
        local deathRecords = numRows(cursor)
        if sqlType == "mysql" then
            while deathRecords > maxDeathRecords do
                delete = assert(con:execute("DELETE FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT 1;"))
                deathRecords = deathRecords - 1
            end
        else
            while deathRecords > maxDeathRecords do
                delete = assert(con:execute("DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT 1);"))
                deathRecords = deathRecords - 1
            end
        end            
        con:close()
        env:close()
    end
end

 

[Velington]

Where do i put this script znake?