Lua How to set a account storage?

[gnr]

I would like to know, how to set a account storage..

I think that is this function:

setGlobalStorageValue(valueid, newvalue)

But I am in doubt...

Can someone help me?

 

[Breakdown]

Bump :: I too wouldnt mind knowing this.

 

[Bintzer]

Well I didn't make these functions, but I forgot where I found them.

So, credits to the original maker!

First run this query in your database:

CREATE TABLE `account_storage`
(
	`account_id` INT NOT NULL DEFAULT 0,
	`key` INT UNSIGNED NOT NULL DEFAULT 0,
	`value` VARCHAR(255) NOT NULL DEFAULT '0',
	KEY (`account_id`), UNIQUE (`account_id`, `key`),
        FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE
) ENGINE =MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;

And then go into data/lib/function.lua and add these functions:

function setAccountStorageValue(accid, key, value)
  local getvalue = db.getResult("SELECT `value` FROM `account_storage` WHERE `account_id` = " .. accid .. " and `key` = " .. key .. " LIMIT 1;")
   if(getvalue:getID() ~= -1) then
   db.executeQuery("UPDATE `account_storage` SET `value` = " .. accid .. " WHERE `key`=" .. key .. " LIMIT 1');")
   getvalue:free()
   return 1
   else
   db.executeQuery("INSERT INTO `account_storage` (`account_id`, `key`, `value`) VALUES (" .. accid .. ", " .. key .. ", '"..value.."');")
   return 1
   end
 end

and

function getAccountStorageValue(accid, key)
  local value = db.getResult("SELECT `value` FROM `account_storage` WHERE `account_id` = " .. accid .. " and `key` = " .. key .. " LIMIT 1;")
   if(value:getID() ~= -1) then
    return value:getDataInt("value")
   else
    return -1
   end
   value:free()
 end

 

[gnr]

@Bintzer

Thanks man

But, it detect account id automatically? Like (cid)?

 

[Bintzer]

No I think you need to use the function getPlayerAccountId(cid)

I've never actually tested this, I just had them saved

 

[D_Evans89]

Well I didn't make these functions, but I forgot where I found them.

So, credits to the original maker!

First run this query in your database:

CREATE TABLE `account_storage`
(
    `account_id` INT NOT NULL DEFAULT 0,
    `key` INT UNSIGNED NOT NULL DEFAULT 0,
    `value` VARCHAR(255) NOT NULL DEFAULT '0',
    KEY (`account_id`), UNIQUE (`account_id`, `key`),
        FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE
) ENGINE =MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;

And then go into data/lib/function.lua and add these functions:

function setAccountStorageValue(accid, key, value)
  local getvalue = db.getResult("SELECT `value` FROM `account_storage` WHERE `account_id` = " .. accid .. " and `key` = " .. key .. " LIMIT 1;")
   if(getvalue:getID() ~= -1) then
   db.executeQuery("UPDATE `account_storage` SET `value` = " .. accid .. " WHERE `key`=" .. key .. " LIMIT 1');")
   getvalue:free()
   return 1
   else
   db.executeQuery("INSERT INTO `account_storage` (`account_id`, `key`, `value`) VALUES (" .. accid .. ", " .. key .. ", '"..value.."');")
   return 1
   end
 end

and

function getAccountStorageValue(accid, key)
  local value = db.getResult("SELECT `value` FROM `account_storage` WHERE `account_id` = " .. accid .. " and `key` = " .. key .. " LIMIT 1;")
   if(value:getID() ~= -1) then
    return value:getDataInt("value")
   else
    return -1
   end
   value:free()
 end

two things:

1. which database am I running that first part in on localhost? otserv database, I'm assuming?
2. I cant find data/lib/function.lua in my server files.

@Xikini
@Bintzer