[SQL] UPDATE player_storage. HELP

[szyszek05]

Hello
I have problem, because I want update player storage and set key 'xxx'.
What is the command?
I wait for answer

 

[Sweddy]

Just add it manually?

 

[Knight God]

is for all player? or one?
if is for all players use global_storage

 

[szyszek05]

For all player, but not for new player.

 

[szyszek05]

Refresh

 

[EliteOTs]

nvm, sec

 

[szyszek05]

Refresh

 

[dgprado]

update player_storage set key = xxx where key = yyy ?

 

[sn3ejk]

Try it:​

/storage who, key, value

 

[szyszek05]

Yeah, but I would like for all players, not one.
Please help, I must have fast this command.

 

[Sweddy]

Yeah, but I would like for all players, not one.
Please help, I must have fast this command.

So you want all players to have x storage always?, if so set a onlogin script for it? ;o

 

[Herpicus]

If you want it to set a storage on login for players that are over a certain level try something like this

In data > creaturescripts > login.lua
Under function onLogin(cid)

Add:

[B][COLOR=#0000ff]if[/COLOR][/B] getPlayerLevel[COLOR=#000080]([/COLOR]cid[COLOR=#000080])[/COLOR] [COLOR=#000080]>=[/COLOR] 20 [B][COLOR=#0000ff]then[/COLOR][/B]
    doCreatureSetStorage[COLOR=#000080]([/COLOR]cid, key, value[COLOR=#000080])[/COLOR]
[B][COLOR=#0000ff]end[/COLOR][/B]

getPlayerLevel(cid) >= 20
If the player is higher or equal to level 20

doCreatureSetStorage(cid, key, value)
Change key and value to what ever you want.

 

[szyszek05]

I don't want give storage for new player.

 

[Herpicus]

I don't want give storage for new player.

Well they won't get this storage until they reach a certain level. Edit and successfully the internets

 

[Sweddy]

I don't want give storage for new player.

Or tell us exactly what you want

 

[szyszek05]

I want get for players vip access key:1111, and if you start game in me server, u don't have this storage xD

 

[Sweddy]

I want get for players vip access key:1111, and if you start game in me server, u don't have this storage xD

Ehh, so you want all players that plays in your server right NOW get that storage, or you want all NEW Players from NOW on to get it or you want ALL Players that play your server get it?

 

[szyszek05]

I want all players that plays in me server right NOW get that storage

 

[NuFFeRs]

I want all players that plays in me server right NOW get that storage

now or NOW?

 

[sn3ejk]

if getPlayerLevel(cid) >= 20 then
    doCreatureSetStorage(cid, key, value)
end

This is bad. You should try do this in this style:​

if (getPlayerLevel(cid) >= 20 and getCreatureStorage(cid, key) == -1) then
    doCreatureSetStorage(cid, key, value)
end