Stik wrote: OK total noob here as far as sql is concerned, so how do i use them pls Rage'
Enterprise manager tools menu... take sql analyzer..
then you paste this script to that code window.. and make shure.. that in at the top middle dropdown.. you have selected WS1, not mainlog or some other database...
then you change character name anywhere is written RageGM.. and then execute script with F5 (your char must be loged out and he has to wear or carry in bag DKsword or DKwand)
if you want to bind some other item, then you should add this item number (from item.cfg you can look for this number) to the "IN (itemnumber, itemnumber, itemnumber)" clause..
thats it...
I plan to write SQL script that makes all this binding automatically... and put it into the database job.. that executes this automatic script once in a hour... then you can put DK items to the BS, but them can wear and upgrade only 180 lvl ppl.. who has completed requirements (for DKwand INT must be 100+ and for other weapons must be lvl 180 and only one DKweapon present...)