TFS 1.X+ Add a log to an action

[primate]

How can I add a log in a SQL table when executing any scripts in actions.

Additional Information:

ID

NAME PLAYER

Date and Time

Spoiler: When I run a lever I know create a log of who used the lever

local playerPosition = {
    {x = 247, y = 659, z = 13},
    {x = 247, y = 660, z = 13},
    {x = 247, y = 661, z = 13},
    {x = 247, y = 662, z = 13}
}
local newPosition = {
    {x = 189, y = 650, z = 13},
    {x = 189, y = 651, z = 13},
    {x = 189, y = 652, z = 13},
    {x = 189, y = 653, z = 13}
}

function onUse(player, item, fromPosition, target, toPosition, isHotkey)
    if item.itemid == 1945 then
        local players = {}
        for _, position in ipairs(playerPosition) do
            local topPlayer = Tile(position):getTopCreature()
            if not topPlayer or not topPlayer:isPlayer() or topPlayer:getLevel() < 100 or topPlayer:getStorageValue(PlayerStorageKeys.annihilatorReward) ~= -1 then
                player:sendCancelMessage(RETURNVALUE_NOTPOSSIBLE)
                return false
            end
            players[#players + 1] = topPlayer
        end

        for i, targetPlayer in ipairs(players) do
            Position(playerPosition[i]):sendMagicEffect(CONST_ME_POFF)
            targetPlayer:teleportTo(newPosition[i], false)
            targetPlayer:getPosition():sendMagicEffect(CONST_ME_ENERGYAREA)
        end
        item:transform(1946)
    elseif item.itemid == 1946 then
        player:sendCancelMessage(RETURNVALUE_NOTPOSSIBLE)
    end
    return true

Thanks for your time.

 

[primate]

Upwards!,

How can I add a log when I use a lever to an SQL table?

 

[sharPix]

How can I add a log in a SQL table when executing any scripts in actions.

Additional Information:

ID

NAME PLAYER

Date and Time

Spoiler: When I run a lever I know create a log of who used the lever

local playerPosition = {
    {x = 247, y = 659, z = 13},
    {x = 247, y = 660, z = 13},
    {x = 247, y = 661, z = 13},
    {x = 247, y = 662, z = 13}
}
local newPosition = {
    {x = 189, y = 650, z = 13},
    {x = 189, y = 651, z = 13},
    {x = 189, y = 652, z = 13},
    {x = 189, y = 653, z = 13}
}

function onUse(player, item, fromPosition, target, toPosition, isHotkey)
    if item.itemid == 1945 then
        local players = {}
        for _, position in ipairs(playerPosition) do
            local topPlayer = Tile(position):getTopCreature()
            if not topPlayer or not topPlayer:isPlayer() or topPlayer:getLevel() < 100 or topPlayer:getStorageValue(PlayerStorageKeys.annihilatorReward) ~= -1 then
                player:sendCancelMessage(RETURNVALUE_NOTPOSSIBLE)
                return false
            end
            players[#players + 1] = topPlayer
        end

        for i, targetPlayer in ipairs(players) do
            Position(playerPosition[i]):sendMagicEffect(CONST_ME_POFF)
            targetPlayer:teleportTo(newPosition[i], false)
            targetPlayer:getPosition():sendMagicEffect(CONST_ME_ENERGYAREA)
        end
        item:transform(1946)
    elseif item.itemid == 1946 then
        player:sendCancelMessage(RETURNVALUE_NOTPOSSIBLE)
    end
    return true

Thanks for your time.

Do you want to record events from all quest levers or just from this one?

 

[primate]

Do you want to record events from all quest levers or just from this one?

If I would like to log some levers, but I need an example because I have no idea how to do it.

 

[pink_panther]

If I would like to log some levers, but I need an example because I have no idea how to do it.

Well you'd need to edit the action script for that lever, add something like

db.asyncQuery("")

The insert query would depend on your table and column names

 

[sharPix]

For example you can make table with auto increment value, and references to tfs database