Need a Fast Script that Remove all Addons form players! [Database]

[johny5608]

I Need fast a srtipt that remove all addons from player [in Database]
Can somebody help me?

 

[Abbedi]

Hehe, i'm not a scripter and i've never scripted something but.. try this one

Delete all addons:
UPDATE `addons` SET `addon` = '0';

 

[Onizuka]

Don't think a column Addons exists at all ;o might just be me

try this

UPDATE `players` SET `lookaddons` = '0';

 

[Cykotitan]

DELETE FROM `player_storage` WHERE `key` >= 10000000;

 

[johny5608]

Cykotitan Thanks.
But i testet this from Anco and it works
Thx For HELP!

 

[Cykotitan]

Cykotitan Thanks.
But i testet this from Anco and it works
Thx For HELP!

My query is for removing addons that players have bought/received, not those that they're wearing.

 

[johny5608]

I looked and that not remove addons i will test that form Cykotitan!

 

[dragonlorde]

This will remove the addons in use by players...
db.executeQuery("UPDATE `players` SET ´lookaddons` = 0;")

This will remove the privilege of use them...
db.executeQuery("UPDATE `players` SET `value` = 0 WHERE `key` >= 10000000;")

 

[Cykotitan]

This will remove the addons in use by players...
db.executeQuery("UPDATE `players` SET ´lookaddons` = 0;")

This will remove the privilege of use them...
db.executeQuery("UPDATE `players` SET `value` = 0 WHERE `key` >= 10000000;")

He needs raw SQL queries, not the ones to be used in Lua scripts

 

[johny5608]

DELETE FROM `player_storage` WHERE `key` >= 10000000;

That Works
Thanks Cykotitan