Store Skull

[PapaZola]

hello

can i have a script auto storeall skull[7420] when player enter map payg_cas04??

[Arcenciel]

There's no script command for storing specific items into the storage.

[PapaZola]

ok thx for the info

[goddameit]

Test in SQL

if(!countitem(7420))end;
query_sql("SELECT `amount`,`id` FROM `storage` WHERE (`account_id` = "+getcharid(3)+"&&`nameid`=7420)",.@a,.@id);
if(.@a==0)
 query_sql "INSERT `storage` VALUES ( NULL,"+getcharid(3)+",7420,"+countitem(7420)+",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)";
else
 query_sql "UPDATE `storage` set amount = "+(.@a+countitem(7420))+" where id = "+.@id;
delitem 7420,countitem(7420);

[Euphy]

Goddameit, does that work without relogging? From what I've tested in the past, none of my SQL queries on active characters are applied until I log off.

[goddameit]

Goddameit, does that work without relogging? From what I've tested in the past, none of my SQL queries on active characters are applied until I log off.

yes, it's need re-login so you can't take back your skull before you re-login

there is other ways can do it, but I don't like it

here is how that works:

first record all you have (getinventorylist;)

and delete all item except skull

now use '@storeall' to storage all you item, cause you only have skull now, target complete

after all, take back all your others item (getitem) and clean variable.

but there is a problem on cart (but you can set that skull can't be put into cart).

Edited July 28, 2012 by goddameit