Windows Mysql query for deleting quest?

[Ceejzor]

At the title say's just looking for a query to delete everyone's storage.

so they can redo quest.

will rep++ :$

 

[Gramwsloneczko]

UPDATE `player_storage`  SET value = -1 WHERE value >=0;

 

[Ceejzor]

Will I need to restart server after I do it?

 

[Cykotitan]

If you want to completely delete all records of storages,

DELETE FROM `player_storage`;

inb4 no but players should be offline at the time you execute this query

 

[Ceejzor]

So instead of this....

UPDATE `player_storage`  SET value = -1 WHERE value >=0;

I should use this?

If you want to completely delete all records of storages,

DELETE FROM `player_storage`;

inb4 no but players should be offline at the time you execute this query

 

[Cykotitan]

Yes?? That's the proper way and what you requested in the first place.

 

[Ceejzor]

Yes?? That's the proper way and what you requested in the first place.

worked like a charm ^.^

 

[Ceejzor]

would UPDATE `players` SET `redskulltime`=0; 'blackskulltime'=0;
erase all red and black skull sin database?

 

[Cykotitan]

would UPDATE `players` SET `redskulltime`=0; 'blackskulltime'=0;
erase all red and black skull sin database?

nop

UPDATE `players` SET `skull` = 0, `skulltime` = 0;

 

[Gramwsloneczko]

sent him the same query 2 minutes ago xd