Removing TRYK Items from the database

[second_coming 836]

Seeing as TRYK has been pulled from the Steam Workshop, here is a php script for removing TRYK items from your database:

DISCLAIMER: I AM NOT RESPONSIBLE IF YOU WIPE YOUR DATABASE OR YOUR SERVER EXPLODES IF YOU USE THIS SCRIPT

MAKE A F**KING BACKUP BEFORE RUNNING THIS SCRIPT

http://pastebin.com/PwRXjfQ6

[Razor77 222]

does anybody know why its gone, is it worth keeping on the server?

[eraser1 329]

I put code in my server and now black screen. What do? /s

[thegeneral 3]

you could also do it this way in your mysql database 

UPDATE player
SET uniform='Exile_Uniform_Woodland',vest='V_PlateCarrierGL_blk',headgear='H_HelmetLeaderO_ocamo',backpack='B_Carryall_oli'
WHERE uniform like 'TRYK%'
OR vest like 'TRYK%'
OR headgear like 'TRYK%'
OR backpack like 'TRYK%';

 

Edited May 11, 2016 by thegeneral

[papahyooie 144]

13 minutes ago, thegeneral said:

you could also do it this way in your mysql database 

UPDATE player
SET uniform='Exile_Uniform_Woodland',vest='V_PlateCarrierGL_blk',headgear='H_HelmetLeaderO_ocamo',backpack='B_Carryall_oli'
WHERE uniform like 'TRYK%'
AND vest like 'TRYK%'
AND headgear like 'TRYK%'
AND backpack like 'TRYK%';

 

That would only replace an item if ALL of them were tryk.  Better to break them up into separate statements. 

[thegeneral 3]

20 minutes ago, papahyooie said:

That would only replace an item if ALL of them were tryk.  Better to break them up into separate statements. 

should be good now just changed the and to or

[second_coming 836]

that only changes equipped gear not items in backpacks/vehicles/containers and is also changes all equipped items not just the tryk ones

Edited May 11, 2016 by second_coming

[papahyooie 144]

31 minutes ago, thegeneral said:

should be good now just changed the and to or

if you just changed the and to or, then it would replace ALL their gear if only one piece was tryk. So like, if their headgear was tryk, it would replace their uniform, vest, etc. 

 

Still better to break them out into their own statements lol. 

[second_coming 836]

8 minutes ago, papahyooie said:

if you just changed the and to or, then it would replace ALL their gear if only one piece was tryk. So like, if their headgear was tryk, it would replace their uniform, vest, etc. 

 

Still better to break them out into their own statements lol. 

that's essentially all the php script is doing anyway

[thegeneral 3]

8 minutes ago, second_coming said:

that's essentially all the php script is doing anyway

true but some people like me dont have a website.