Lua executeQuery to add storage?

[seto sazo]

Noob question. Whats the executeQuery to add a storage value such as 1234 to a player in a script?

 

[Bogart]

a query to give a storage to a player? wtf.

setPlayerStorageValue(cid, 1234, 1)

 

[seto sazo]

Noo.... a query like this

 db.executeQuery("UPDATE `players` SET `frags` = 0 WHERE `id` = " .. getPlayerGUID(cid) .. ";")

 

[Doggynub]

You should check first for player id then check if he has that storage value their,if it is there then you will use UPDATE else you should use INSERT

 

[seto sazo]

So this?

  db.executeQuery("INSERT `player_storage` SET `key` = 1234, 'value' = 1, WHERE `player_id` = " .. getPlayerGUID(cid) .. ";")

 

[EvulMastah]

SELECT -> returned something? -> UPDATE / not returned? -> INSERT INTO

 

[Doggynub]

You should use insert ignore then after it use the update

  db.executeQuery("INSERT IGNORE INTO `player_storage` SET  `player_id` = '" .. getPlayerGUID(cid) .. "' `key` = '1234', 'value' = '-1' ;") -- this insert the storage if not exist
  db.executeQuery("UPDATE `player_storage` SET  'value' = '1' WHERE `player_id` = '" .. getPlayerGUID(cid) .. "' AND `key` = '1234' ;")-- this sets the storage to value

 

[Cykotitan]

You should use insert ignore then after it use the update

  db.executeQuery("INSERT IGNORE INTO `player_storage` SET  `player_id` = '" .. getPlayerGUID(cid) .. "' `key` = '1234', 'value' = '-1' ;") -- this insert the storage if not exist
  db.executeQuery("UPDATE `player_storage` SET  'value' = '1' WHERE `player_id` = '" .. getPlayerGUID(cid) .. "' AND `key` = '1234' ;")-- this sets the storage to value

>insert
>set