Lua How to storage guildname

Sigoles · Jan 5, 2018

I want to save the guild name in the database so that after server save it will not be deleted.

I tested (works but in server save this disappear):

LUA:

Game.setStorageValue(966632, getPlayerGuildName(cid))

and (dont work, give an error for store):

LUA:

 setGlobalStorageValue(966632, getPlayerGuildName(cid))

tfs 1.2
how I can store the guild name?

Znote · Jan 5, 2018

Wait what?

Guild names are already in the database. (Check guilds table).

To get guild name from player:

LUA:

local guild = player:getGuild()
if guild ~= nil then -- If player is in a guild
    local guildname = guild:getName() -- Returns the name of the guild the player is in.
end

2Rec · Jan 5, 2018

If it gave you an error, why didn't you post it?
Along with your global storage function.

Sigoles · Jan 5, 2018

Znote said:
Wait what?

Guild names are already in the database. (Check guilds table).

To get guild name from player:

LUA:

function onStepIn(cid, item, pos, fromPosition) local pos = getThingPos(cid) local player = Player(cid) local guild = player:getGuild() if guild ~= nil then -- If player is in a guild local guildname = guild:getName() -- Returns the name of the guild the player is in. end

I wanted to save a guild so that only she could enter a teleport, when the player is not from this guild X will appear a message to him saying that guild X is the owner of the place.

LUA:

function onStepIn(cid, item, pos, fromPosition)
local pos = getThingPos(cid)
local player = Player(cid)
local guildId = guild:getId()
local newGuild = Guild(guildId)

if getGlobalStorageValue(9999) == newGuild:getName() then
doSendMagicEffect(getThingPos(cid), 14)
else
doPlayerSendCancel(cid, "[MSG] You do not belong to the guild "..getGlobalStorageValue(9999)..".")
end

Script.lua:4: attempt to index local 'guild' (a nil value)

Znote · Jan 5, 2018

This script only sees if player have access to enter somewhere.
Can you post the script that decides which guild owns this place?

LUA:

function onStepIn(creature, item, position, fromPosition)
    if creature:isPlayer() then
        local player_guild = creature:getGuild()
         
        if getGlobalStorageValue(9999) == player_guild:getName() then
            position:sendMagicEffect(14)
        else
            creature:sendTextMessage(MESSAGE_INFO_DESCR, "You do not belong to the guild "..getGlobalStorageValue(9999)..".")
            creature:teleportTo(fromPosition, true)
        end
    end
    return true
end

Sigoles · Jan 5, 2018

Znote said:

This script only sees if player have access to enter somewhere.
Can you post the script that decides which guild owns this place?

LUA:

function onStepIn(creature, item, position, fromPosition)
    if creature:isPlayer() then
        local player_guild = creature:getGuild()
    
        if getGlobalStorageValue(9999) == player_guild:getName() then
            position:sendMagicEffect(14)
        else
            creature:sendTextMessage(MESSAGE_INFO_DESCR, "You do not belong to the guild "..getGlobalStorageValue(9999)..".")
            creature:teleportTo(fromPosition, true)
        end
    end
    return true
end

Yes, its good, but how to setGlobalStorageValue(9999) with this player_guild:getName() ?
The check we have, now we have to set/save

This script decide who own the guild BUT its disappear after server save:

LUA:

Game.setStorageValue(9999, getPlayerGuildName(cid))

because this above dont save in database, I want save this on database with setGlobalStorageValue

If I use setGlobalStorageValue(9999, player_guild) , give an error:
attempt to concatenate local 'value' (a userdata value)

@Znote

Alw · Jan 5, 2018

Game storages resets when the libs reloads.
Regards Alw

Sigoles · Jan 5, 2018

Alw said:
Game storages resets when the libs reloads.
Regards Alw

Thats the problem, I want to no reset, the setGlobalStorageValue dont reset.

2Rec · Jan 5, 2018

Depends when the guild is being rewarded.
I mean, this script's supposed to pass a player through only if he's a member of some winner guild, right?
You gotta add a line to the script responsible for selecting a winner.

It may also happen that this function doesn't operate with strings, so i would recommend using guild Id as value instead.

Alw · Jan 5, 2018

I understand what you want to do, Checks if the player belongs to the guild once he enters the teleport or whatever.
Problem is that setGlobalStorageValue one allows a certain type as a value while you're trying to enter a userdata value, they are different types.
You could perhaps try to use the Guild id instead.
ex setGlobalStorageValue(9999, Guild:getId())
Regards Alw

Sigoles · Jan 5, 2018

2Rec said:
Depends when the guild is being rewarded.
I mean, this script's supposed to pass a player through only if he's a member of some winner guild, right?
You gotta add a line to the script responsible for selecting a winner.

It may also happen that this function doesn't operate with strings, so i would recommend using guild Id as value instead.

"You gotta add a line to the script responsible for selecting a winner."
This is what I'm trying to do, save the winning guild by name and not id

Alw · Jan 5, 2018

Make your own function that allows strings instead then.
Regards Alw

2Rec · Jan 5, 2018

Unnecessary, because you can get guild's name by id anyway.

Sigoles · Jan 5, 2018

2Rec said:
Unnecessary, because you can get guild's name by id anyway.

We can get, but how we can save the guild name on db?

2Rec · Jan 5, 2018

setGlobalStorageValue function???

Sigoles · Jan 5, 2018

2Rec said:
setGlobalStorageValue function???

LUA:

function setGlobalStorageValue(key, value)
    if getGlobalStorageValue(key, true) then
       db.query("UPDATE `global_storage` SET `value` = '".. value .. "' WHERE `key` = ".. key .. ";")
    else
        db.query("INSERT INTO `global_storage` (`key`, `value`) VALUES (".. key ..", ".. value ..");")
    end
    return true
end

We can't save names, we got error when try

Znote · Jan 5, 2018

Don't use guild name, use guild id instead. Much faster. guild:getId()

LUA:

function onStepIn(creature, item, position, fromPosition)
    if creature:isPlayer() then
        local player_guild = creature:getGuild()
        local zone_guild = Guild(getGlobalStorageValue(9999))
         
        if zone_guild:getId() == player_guild:getId() then
            position:sendMagicEffect(14)
        else
            creature:sendTextMessage(MESSAGE_INFO_DESCR, "You do not belong to the guild ".. zone_guild:getName() ..".")
            creature:teleportTo(fromPosition, true)
        end
    end
    return true
end

SQL:

CREATE TABLE IF NOT EXISTS `global_storage` (
  `key` int(10) unsigned NOT NULL DEFAULT '0',
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;

forgottenserver/game.lua at master · otland/forgottenserver · GitHub

LUA:

if not globalStorageTable then
    globalStorageTable = {}
end

function Game.getStorageValue(key)
    -- Return from local table if possible
    if globalStorageTable[key] ~= nil then
        return globalStorageTable[key]
    end

    -- Else look for it on the DB
    local dbData = db.storeQuery("SELECT `value` FROM `global_storage` WHERE `key` = " .. key .. " LIMIT 1;")
    if dbData ~= false then
        local value = result.getNumber(dbData, "value")
        if value ~= nil then
            -- Save it to globalStorageTable
            globalStorageTable[key] = value
            return value
        end
    end

    return nil
end

function Game.setStorageValue(key, value)
    globalStorageTable[key] = value

    local dbData = db.storeQuery("SELECT `value` FROM `global_storage` WHERE `key` = " .. key .. " LIMIT 1;")
    if dbData ~= false then
        db.query("UPDATE `global_storage` SET `value`='".. value .."' WHERE `key` = " .. key .. " LIMIT 1;")
    else
        db.query("INSERT INTO `global_storage` (`key`, `value`) VALUES (" .. key .. ", " .. value .. ");")
    end
end

Sigoles · Jan 5, 2018

Znote said:

Don't use guild name, use guild id instead. Much faster. guild:getId()

LUA:

function onStepIn(creature, item, position, fromPosition)
    if creature:isPlayer() then
        local player_guild = creature:getGuild()
        local zone_guild = Guild(getGlobalStorageValue(9999))
        
        if zone_guild:getId() == player_guild:getId() then
            position:sendMagicEffect(14)
        else
            creature:sendTextMessage(MESSAGE_INFO_DESCR, "You do not belong to the guild ".. zone_guild:getName() ..".")
            creature:teleportTo(fromPosition, true)
        end
    end
    return true
end

SQL:

CREATE TABLE IF NOT EXISTS `global_storage` (
  `key` int(10) unsigned NOT NULL DEFAULT '0',
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;

forgottenserver/game.lua at master · otland/forgottenserver · GitHub

LUA:

if not globalStorageTable then
    globalStorageTable = {}
end

function Game.getStorageValue(key)
    -- Return from local table if possible
    if globalStorageTable[key] ~= nil then
        return globalStorageTable[key]
    end

    -- Else look for it on the DB
    local dbData = db.storeQuery("SELECT `value` FROM `global_storage` WHERE `key` = " .. key .. " LIMIT 1;")
    if dbData ~= false then
        local value = result.getNumber(dbData, "value")
        if value ~= nil then
            -- Save it to globalStorageTable
            globalStorageTable[key] = value
            return value
        end
    end

    return nil
end

function Game.setStorageValue(key, value)
    globalStorageTable[key] = value

    local dbData = db.storeQuery("SELECT `value` FROM `global_storage` WHERE `key` = " .. key .. " LIMIT 1;")
    if dbData ~= false then
        db.query("UPDATE `global_storage` SET `value`='".. value .."' WHERE `key` = " .. key .. " LIMIT 1;")
    else
        db.query("INSERT INTO `global_storage` (`key`, `value`) VALUES (" .. key .. ", " .. value .. ");")
    end
end

Thanks, but I want to save the guild so that it can appear in the message when someone tries to enter teleport and show which guild is the owner of the place.
The only method would be to save the guild ID in the database, we know how to save the guild ID, now how to get the guild name from the guildID?

Znote · Jan 5, 2018

God Of Pain said:
Thanks, but I want to save the guild so that it can appear in the message when someone tries to enter teleport and show which guild is the owner of the place.
The only method would be to save the guild ID in the database, we know how to save the guild ID, now how to get the guild name from the guildID?

Look at this code:

LUA:

function onStepIn(creature, item, position, fromPosition)
    if creature:isPlayer() then
        local player_guild = creature:getGuild()
        local zone_guild = Guild(getGlobalStorageValue(9999))
       
        if zone_guild:getId() == player_guild:getId() then
            position:sendMagicEffect(14)
        else
            creature:sendTextMessage(MESSAGE_INFO_DESCR, "You do not belong to the guild ".. zone_guild:getName() ..".")
            creature:teleportTo(fromPosition, true)
        end
    end
    return true
end

LUA:

local zone_guild = Guild(getGlobalStorageValue(9999))
zone_guild:getName() -- Returns guild name

Lua How to storage guildname

Sigoles

Discord: @sigoles

Znote

Znote

<?php echo $title; ?>

2Rec

Excellent OT User

Sigoles

Discord: @sigoles

Znote

<?php echo $title; ?>

Sigoles

Discord: @sigoles

Alw

Guest

Sigoles

Discord: @sigoles

2Rec

Excellent OT User

Alw

Guest

Sigoles

Discord: @sigoles

Alw

Guest

2Rec

Excellent OT User

Sigoles

Discord: @sigoles

2Rec

Excellent OT User

Sigoles

Discord: @sigoles

Znote

<?php echo $title; ?>

Sigoles

Discord: @sigoles

Znote

<?php echo $title; ?>