[ArcEmu] Donor/Normal account differences

[reaku]

Hello there. I have a funserver. In this funserver i maid some donation gear, but there is so much difference between normal players and donor ones. I was wondering if there is any way that i can raise all stats on server ( blizz items and mobbs) because the donors are like gods. Please help if you know a mod or a query or a .lua that can do that please post i'll +Rep anyone!!

[Ground Zero]

Wouldn't it be easier to just reduce the Donor gear? It would take alot longer to increase everything else.

[reaku]

ies it whould but i want a funserver not a just a little over blizz server. i need somethings edited anyway so... just tell me what to edit

[Aellya]

You could boost the stats for all items which weren't donated items.

e.g.
Assumes your donation items are at 100000 and higher and is based on Ascent/Arcemu sql structure.

UPDATE items SET stat_value1 = stat_value1 * 1.5 WHERE stat_type1 > 0 AND entry < 100000;
UPDATE items SET stat_value2 = stat_value2 * 1.5 WHERE stat_type2 > 0 AND entry < 100000;
UPDATE items SET stat_value3 = stat_value3 * 1.5 WHERE stat_type3 > 0 AND entry < 100000;
UPDATE items SET stat_value4 = stat_value4 * 1.5 WHERE stat_type4 > 0 AND entry < 100000;
UPDATE items SET stat_value5 = stat_value5 * 1.5 WHERE stat_type5 > 0 AND entry < 100000;
UPDATE items SET stat_value6 = stat_value6 * 1.5 WHERE stat_type6 > 0 AND entry < 100000;
UPDATE items SET stat_value7 = stat_value7 * 1.5 WHERE stat_type7 > 0 AND entry < 100000;
UPDATE items SET stat_value8 = stat_value8 * 1.5 WHERE stat_type8 > 0 AND entry < 100000;
UPDATE items SET stat_value9 = stat_value9 * 1.5 WHERE stat_type9 > 0 AND entry < 100000;
UPDATE items SET stat_value10 = stat_value10 * 1.5 WHERE stat_type10 > 0 AND entry < 100000;

Same with other item values like damage, armour, resistances, etc...
Hope this helped

[Aellya]

Just thinking that another option would be to just reduce the level of all items by 10, this will allow players to use properly balanced items relative to each other.

UPDATE items SET requiredlevel = requiredlevel - 10 WHERE entry < 100000;
UPDATE items SET requiredlevel = 0 WHERE requiredlevel < 0; // Fix the items whos requiredlevel went negative.

[Kiev]

Thats some very nice SQL your using there Aellya, im going to see that you might be a good help here.

[reaku]

thank you very much for all. i will try these to see if they work. +rep from me!

EDIT: i tried but the items remained the same or the difference was too small. i need to make all blizz items ( top ones ) to be 20-35 % weaker then ones with 1000+ stats. and yes i deleted my cache before reentry.

[Kiev]

Did you reload the item table or restart the server?

[reaku]

it works! all i had to do is make it bigger. thanks +rep for you. can you make something like that for wepps, shields and mobbs to? please i'll +rep again

[Kiev]

It should do the stats on weapons, to do the damage just change the colums to "min_damage" and "max_damage" and just have two queries.

[reaku]

i don't need for wepps anymore, i solved that. what about mobs. can i use this on mobs to?

[Ground Zero]

UPDATE items SET stat_value1 = stat_value1 * 1.5 WHERE stat_type1 > 0 AND entry < 100000;

to

UPDATE creature_proto SET maxhealth = maxhealth * 1.5 WHERE maxhealth > 0 AND entry < 100000;

Or whatever maxhealth is.

[reaku]

thanks man + rep for you!

[reaku]

guys i have a problem: when i execute the query it gives this error: squote]sql error: you have an error in your sql syntax; check the manual that coresponds to your mysql server version for the right syntax to use near "UPDATE creature_proto set maxhealth = maxhealth * 7.5 WH"[/quote]

i executed:

UPDATE creature_proto SET minhealth = minhealth * 7.5 WHERE minhealth > 0 AND entry < 30000
UPDATE creature_proto SET maxhealth = maxhealth * 7.5 WHERE maxhealth > 0 AND entry < 30000
UPDATE creature_proto SET mindamage = mindamage * 7.5 WHERE mindamage > 0 AND entry < 30000
UPDATE creature_proto SET maxdamage = maxdamage * 7.5 WHERE maxdamage > 0 AND entry < 30000

[Kiev]

This may be a silly question xD, but did you put the ; after the lines?