Reset Random Option

[lamnor]

Olá, Alguém sabe como eu reseto as random options de todos os equipamentos e de todas as contas do meu servidor?

---------------------------------------------------------------------------------------------

Hello, I need to reset all random options of equipment from my server in all accounts.

Anyone know how I do it?

[Emistry]

shut down server, and execute these queries.

UPDATE `cart_inventory` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;
UPDATE `guild_storage` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;
UPDATE `inventory` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;
UPDATE `mail_attachments` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;
UPDATE `storage` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;

 

[lamnor]

3 hours ago, Emistry said:

shut down server, and execute these queries.

UPDATE `cart_inventory` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;
UPDATE `guild_storage` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;
UPDATE `inventory` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;
UPDATE `mail_attachments` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;
UPDATE `storage` SET `option_id0` = 0,`option_val0` = 0,`option_parm0` = 0,`option_id1` = 0,`option_val1` = 0,`option_parm1` = 0,`option_id2` = 0,`option_val2` = 0,`option_parm2` = 0,`option_id3` = 0,`option_val3` = 0,`option_parm3` = 0,`option_id4` = 0,`option_val4` = 0,`option_parm4` = 0;

 

Work! Thanks