Makeing all stats higher?

[Cison]

Is there a code i can put in somewere on my DB to make all the stats multiple of what i put in?

For example: Say an item is 30dps and 50stam. Is there a way to make it higher along with all the other items in my server without haveing to go single file threw the items list modifying them? i would like to multiply the stat base of all items by 20 or so.

I understand that its probly 12 differnt codes one for dmg one for strength/stamina/intellect/spell power ect ect. But i would just like to know were to find it.

I have seen one server with this were all there dmg has been x10 of the normal. Mond-WoW was kinda wondering how they did it lol.

Anyway ty for your help!

[Hex00010]

hmmmm im sure there could be a sql query possibly like maybe

UPDATE items WHERE something = 9999999999999999

if you can find a way where the " something " matches the column where it uses for spell dmg then that will do that trick for you

[Cison]

Not sure i understand... lol Sorry i guess i sound like a noob. If you wouldnt mind could you explain more? Or contact me at [email protected]. Thats my msn maybe you could help me a lil.

[AfterMidnight]

Because he explains it like a noob; unlike how he was my hero a few days back.
He appears to be telling you that for example, spellpower on blues staves are 343; find that value, execute query to change all entrys with 343 to how much you want it to be (2x 686SP); but this is something that'd take weeks, with all the different values of stats.

Best bet is to hire a dev that'll create a program that can connect with ur SQL; searches in the value rows, fetches the value, multiplies and updates it automaticly; entry by entry.

Because by my best knowledge, which is only moderate, there is no simple config that automates this in a single switch.

[Dynashock]

If you're just interested in updating the old stats by multiplying them you can run a few queries which will do the job for you easily. No need for a hired dev or some fancy program. As Hex pointed out you'll need a query alike his, but his is slightly incomplete so you're going to be looking at something like this. (Do NOT run this query, this is an example one and it won't work!)

UPDATE `items` SET `stat_1` = `stat_1`*20;
UPDATE `items` SET `stat_2` = `stat_2`*20;

[Cison]

Ty all for your imput. I have an idea of how it might work....

Im trying to just multiply all stats BUT agility... so Strength/stamina/intellect/spirit along with Spell power and attack power...

I wonder if i did a code like Dynashock was saying but switching out the stat_1 with the acctauly spell code.. maybe this


UPDATE `items` SET `stat` = `3`*20;
UPDATE `items` SET `stat` = `5`*20;
UPDATE `items` SET `stat` = `6`*20;
UPDATE `items` SET `stat` = `7`*20;
UPDATE `items` SET `stat` = `38`*20;
UPDATE `items` SET `stat` = `45`*20;


Not sure how to code acctauly but with what lil i use to do in VB figured that might work... if someone could give me some input i would love it or maybe correct that code anyway ty all agin!


Nvm i found the real codes on the net for all of you who would like to upgrade your gear here is the code page!

WOWÎïÆ·ºÍ¹ÖÎïµÄ»ù±**ÅúÁ¿**Þ¸ÄÃüÁî½éÉÜ,**¿ªÄ§ ÊÞ˽·þ,×î**ÂħÊÞ˽·þ·¢²¼Íø

It works 100% guarented i just set up all my values.

Once agin they all for the help you gave me i wouldnt have been able to find the code without you.