second_coming

Removing TRYK Items from the database

11 posts in this topic

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

2 people like this

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
Advertisement

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

2 people like this

Share this post


Link to post
Share on other sites

Posted (edited)

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 by thegeneral

Share this post


Link to post
Share on other sites
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. 

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Posted (edited)

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

Edited by second_coming

Share this post


Link to post
Share on other sites
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. 

Share this post


Link to post
Share on other sites
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 :)

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.