Custom Wrathful (Season8) Gear.

[lurkinator911]

Hello people of OwnedCore.
i was wondering if there is anyone here that could compile me a SQL, simply just a update SQL for specificly the Wrathful Gear
im having trouble converting ALL the Wrathful (Season gear to lvl 100 gear with better stats. i don't want overpowered stuff, just a buff of 50-70 on each stats and lvl set up to lvl 100, as im putting up a lvl 100 custom lvling/pvp realm.
i'm running a TrinityCore Server btw.
Help would be very much apreciated!

[stoneharry]

UPDATE item_template SET statvalue1 = statvalue1*1.7 WHERE entry = '1';

This would make statvalue1 column times by 1.7. Just edit the query to effect the correct columns and experiment with some different values. You will need to change the entry of the item (currently set to 1). Back up your database before executing any queries in case you get it wrong.

[lurkinator911]

UPDATE item_template SET statvalue1 = statvalue1*1.7 WHERE entry = '1';

This would make statvalue1 column times by 1.7. Just edit the query to effect the correct columns and experiment with some different values. You will need to change the entry of the item (currently set to 1). Back up your database before executing any queries in case you get it wrong.

it's been 3 years since last i did server work / db work and stuff like that.. :| it's like all out of my system, so i barely can do shit other than adding SQLs and editing few bits in DB :/

Also i've recently modified about 20 Wrathful items so far. hence the reason im asking for this, it takes damn long x_x

[stoneharry]

it's been 3 years since last i did server work / db work and stuff like that.. :| it's like all out of my system, so i barely can do shit other than adding SQLs and editing few bits in DB :/

Also i've recently modified about 20 Wrathful items so far. hence the reason im asking for this, it takes damn long x_x

Look up some basic tutorials on how to 'script' MySQL queries.

[lurkinator911]

Look up some basic tutorials on how to 'script' MySQL queries.

cant seem to find any x_x gawd

[bendaferi]

SQL Update

You can find other statements at the left side menu under SQL Basic. You do not need to read the advanced part. At least for this gear update process

[lurkinator911]

SQL Update

You can find other statements at the left side menu under SQL Basic. You do not need to read the advanced part. At least for this gear update process

Could you please tell me how? perhaps through a guide, would be helpfull

[Stige]

Why do you even bother trying to run a server which you cant even run yourself?

[lurkinator911]

Why do you even bother trying to run a server which you cant even run yourself?

i can perfectly fine run my own server. i've been off the emulator work for 3 years, can't ****ing expect me to have it all back in the system in 2 days.
get your facts straight.

[facka138b]

Lurkinator911, just do what stoneharry told you.

Step 1: Create a new SQL file.
Step 2: Open the SQL file.
Step 3: Add this to the SQL File:
UPDATE item_template SET statvalue1 = statvalue1*1.7 WHERE entry = 'REPLACE WITH ITEM ID';
UPDATE item_template SET statvalue2 = statvalue2*1.7 WHERE entry = 'REPLACE WITH ITEM ID';
UPDATE item_template SET statvalue3 = statvalue3*1.7 WHERE entry = 'REPLACE WITH ITEM ID';
UPDATE item_template SET statvalue4 = statvalue4*1.7 WHERE entry = 'REPLACE WITH ITEM ID';
UPDATE item_template SET statvalue5 = statvalue5*1.7 WHERE entry = 'REPLACE WITH ITEM ID';
UPDATE item_template SET statvalue6 = statvalue6*1.7 WHERE entry = 'REPLACE WITH ITEM ID';
UPDATE item_template SET statvalue7 = statvalue7*1.7 WHERE entry = 'REPLACE WITH ITEM ID';
UPDATE item_template SET RequiredLevel = '100' WHERE entry = 'REPLACE WITH ITEM ID';
Step 4: Now delete REPLACE WITH ITEM ID with the entry of the item you want to tweak.
Step 5: Run the SQL file into the database.

HINT: Press Ctrl+H. This brings up a menu. Type this in the specific field:
Replace: REPLACE WITH ITEM ID
Replace With: Entry ID
Then press Replace All. The program will then automatically replace it all with the selected entry id.
Now copy/paste a new line for a new item and do the same thing above.