Need help with C++ changing stamina health bonus, PLS look

**~~Avidgamer~~** · 20-08-10, 02:00 PM

About the SQL can't be sure, I've not really used Mangos much with DBs. There must be a way, but I'm not 100% sure, I'll have a look if you like.

› See More: Need help with C++ changing stamina health bonus, PLS look

**kandi** · 20-08-10, 02:27 PM

Sure I mean if you could find something, dont trouble yourself too much on my account lol Ill check around more too.

Kandi

**~~Avidgamer~~** · 20-08-10, 03:27 PM

Shouldn't be to hard to find it, I'll google it now quickly.

I think this may work:

Code:

UPDATE TABLENAME SET field1=NEWVALUE

Change the "TABLENAME" with I think, "Items" - though I'm not sure what it's
named in Mangos. Then, change "Field1" to whatever the extended cost field
name is, it may be "ExtendedPrice". Then change "NEWVALUE" to the ID of the
token.

e.g.

Code:

UPDATE Items SET ExtendedPrice=1234

**kandi** · 20-08-10, 06:20 PM

OMG, worked beautifully every single item in my database is Bind on Equip now thanks you so much...to tell you the truth I was kind of expecting something to go horribly wrong so I created a backup of my mangos DB lol

Thank you so much though, ill rep you when I can...I just need to find someone else that is repworthy first so I can rep you again lol

Kandi <3

**Dimman** · 20-08-10, 06:36 PM

Code:

Update `item_template` set `type` = ID where `type` = ID;

Replace ID with the value to make an item BoE & change type to the correct column if its not .
Something like that, i dont know the values to make it BoE. Go hunt

**~~Avidgamer~~** · 20-08-10, 06:57 PM

Originally Posted by kandi

OMG, worked beautifully every single item in my database is Bind on Equip now thanks you so much...to tell you the truth I was kind of expecting something to go horribly wrong so I created a backup of my mangos DB lol

Thank you so much though, ill rep you when I can...I just need to find someone else that is repworthy first so I can rep you again lol

Kandi <3

Glad it worked

If you need any more help just ask ^^

**kandi** · 20-08-10, 08:15 PM

yeah so if anyone else wants to know the sql query is

Code:

UPDATE Item_template SET bonding = 2

and that will make all of the items in your DB BoE lol its a lot easier then doing every single item you want individually

Credits to AvidGamer for the structure lol

**kandi** · 22-08-10, 12:34 PM

Ok guys, another question, I edited all of the items in my db to have X100 spell power and all that fun stuff, I just made a priest and equipped an Item set (which has a combo of 66400 SP) but even with all that my crits are only 13k... Is there a reason that its doing this?

(I changed all the core stuff back to normal and deleted my WDB from my cache folder)

Kandi