[QUESTION] Soulbound Items

[tripleblade3]

Does anybody know how to make all soulbound items not soulboud?

I have been looking around for a query for this for a while and if anybody knows one i would greatly appreciate it.

[aflacattack]

yeah give me a second to go look up the name of the thingy and i'll tell you...
never mind, i forgot sorry

[Illidan1]

There is an SQL update for it, but I'm to lazy right now to find it sorry

[aflacattack]

There is an SQL update for it, but I'm to lazy right now to find it sorry

meh i was just trying to remember what column it was, i thought it was bonding, maybe its called binding, dont remember... but you can change the number in the column to 0... something like that

[Illidan1]

Yup, i know, i just can't be stuffed making the row SQL
That Changes them all

[aflacattack]

yeah that would be better lol, specially if you want to do all the items...
woulda been funny if he started trying to change them all by hand

[Illidan1]

lol all what.. 25000 items lol funny

[aflacattack]

heck i'd like to watch someone do it...
make it a contest, see who can do it fastest lol

[Illidan1]

lol i would soo win, even if i didn't have the SQL for all of them

Note Pad FTW lol

who new that Elite Users can have 100x100 Avatar lol i had like a 60x45...

[aflacattack]

lol idk, i think it would be about who could click the fastest...
no sql's, thats like cheating lol...

and i think everyone can have up to a 100x100 avatar

[aflacattack]

never mind i lied.. mine can only be only 80x80

[tripleblade3]

ok, well i c what you guys are getting at but going through and doing it manually would take like a week.....

Thanks anyway and let me know if you ever do find that SQL!

[latruwski]

well try this... it should set all "binds when picked up" , "binds when used" and "binds when equiped" items to normal items:

update items set bonding = 0 where bonding =1;
update items set bonding = 0 where bonding =2;
update items set bonding = 0 where bonding =3;

test it before you do it on real DB...

grtz

[tripleblade3]

Thanks latruwski, ill try it as soon as i can
+rep