[Items] Can someone compile an sql script that resets item values and how much of cet

[ryanryan1991]

Can someone compile an sql script that resets item values and how muc of certain "token/currency" is needed because lvl 1's can get t6 and stuff its really annoying, pls can someone spare 20 mins making one as im sure it will help a lot of people

thx

ryan

 

[ryanryan1991]

please please please, another one bites the bump!

 

[melikeme]

i wish this helps :

T4 / T5 / T6 Tokens not needed anymore :



Code:

UPDATE items SET Itemextendedcost=0;

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

Honor / Skill / Reputation not needed anymore :



Code:

UPDATE items SET RequiredPlayerRank1=0 WHERE RequiredPlayerRank1<>0;
UPDATE items SET RequiredPlayerRank2=0 WHERE RequiredPlayerRank2<>0;
UPDATE items SET RequiredFaction=0 WHERE RequiredFaction<>0;
UPDATE items SET RequiredFactionStanding=0 WHERE RequiredFactionStanding<>0;
UPDATE items SET requiredlevel=0 WHERE Requiredlevel<>0;
UPDATE items SET RequiredSkill=0 WHERE RequiredSkill<>0;
UPDATE items SET RequiredSkillRank=0 WHERE RequiredSkillRank<>0;

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

Everything Free :


Code:

UPDATE items SET SELLPRICE=0;

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

How to put in the Database : [FOR DUMMIES!]

1- Create a Text Document any where.

2-Open it.

3-Copy any code you want then paste it in the Text Document u just made.
4-Click File > Save As.

5-In the name type down : anythingyouwant.sql

6-Choose the location.

7-Click Save.

8a-Run Navicat, right click on "Ascent" and click "Execute Batch File.." , Navigate to the "anythingyouwant.sql" file and double click it, and then you're done!

8b-Run SQLyog, Connect, Right Click on "Ascent" and then click "Restore from SQL Dump" , Navigate to the "anythingyouwant.sql" file and double click it, after that click excute and your done!
----------------------------

heres the link for the normal page :
RageZone Thread