Solved Amulet of loss

[gerard95]

Why AoL is not dissappearing after dying?

<item id="2173" article="an" name="amulet of loss">
        <attribute key="weight" value="420" />
        <attribute key="slotType" value="necklace" />
              <attribute key="showcharges" value="1"/> 
        <attribute key="preventDrop" value="1" />
    </item>

Anyone've got a clue?
Thank you.

 

[tetra20]

look at your creaturescript for onpreparedeath or ondeath and paste here

 

[gerard95]

I have nothing similar to that. Thought a friend sent me this:
It still did not work :/

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 getPlayerSlotItem(cid, 2).itemid == 2173 then
                doPlayerRemoveItem(cid, 2173, 1)
end
    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

 

[tetra20]

disable it or change

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

To

config.sqlType = "sqlite" and DATABASE_ENGINE_SQLITE or DATABASE_ENGINE_MYSQL

 

[gerard95]

Not working any clue?

 

[Ninja]

Did you create amulet of loss with your gamemaster or was it purchased from shop?

Amulet of loss created by gamemasters has 100 charges

 

[gerard95]

Nope, it was just created at first_items folder :c

 

[gerard95]

Still not working. Someone got a valid ondeath.lua?

Thank you

 

[gerard95]

Bump please!

 

[Ninja]

Does your firstitems.xml create amulet of loss with 1 charge then?

 

[gerard95]

Working fine with <attribute key="charges" value="1"/>
Thank you Ninja!