Fix for objects that appear as bags

[Kroeg]

For those of you that have noticed that forges, kilns, ovens etc appearing as a bag on the ground, source the packed sql file and it'll fix the values in your db needed to see objects use their original textures (thanks LE). *Note, 8 objects still remain unfixed by this.. all forges (cultural forges), but out of 298 objects in game -- that's not bad :)

get it here:
http://h37.bounceme.net/eqemu/obj_update.zip


For anyone needing a step-by-step:

I'll assume your db name is 'eq' in this example.

open mysql
use eq
source 0.5xObjectUpdate.sql;
enjoy

Hope this solves a few frustrations :)

[rockocool]

Link not working for me ...

[Kroeg]

rt click and save target as.. it is a good link (many people grabbed it from there)

[mollymillions]

Sweet.

[Arley McFarley]

That will be helpful.

I just got a copy of TCS database (TCS_MW_051_052_alpha1.zip)to work under the current release EQEMu-0.5.1-Win32.zip.

Will this sourcing bust my working database?
Does it work with the EQEmu 5.1 release?

Thanks,
Arley

[rockocool]

I did used right click and then save as, but always got a 3KB file which is not a valid zip file when I tried to unzip it. I tried on both win98 and winXP, using internet explorer.
Is it possible to post the sql file in text format here in the forum if it is not too long? Or can you email the file to me please, to rocko_wang@yahoo.com? Many thanks!
Also your other file, the zoneline.sql in another post, I got same error when try to unzip the downloaded file.

[Tertiary]

When I download it, the contents is this:

update object set objectname='IT128_ACTORDEF' where type='16';
update object set objectname='IT74_ACTORDEF' where type=21;
update object set objectname='IT73_ACTORDEF' where type=22;
update object set objectname='IT70_ACTORDEF' where type=19;
update object set objectname='IT69_ACTORDEF' where type=15;
update object set objectname='IT66_ACTORDEF' where type=17;
update object set objectname='IT66_ACTORDEF' where type=48;

EDIT: Haven't had a chance to see if works yet though.

[Kroeg]

this is what you must type when running mysql:

update object set objectname='IT128_ACTORDEF' where type='16';
update object set objectname='IT74_ACTORDEF' where type=21;
update object set objectname='IT73_ACTORDEF' where type=22;
update object set objectname='IT70_ACTORDEF' where type=19;
update object set objectname='IT69_ACTORDEF' where type=15;
update object set objectname='IT66_ACTORDEF' where type=17;
update object set objectname='IT66_ACTORDEF' where type=48;

[rockocool]

Great, thanks a lot!

[Kroeg]

Thank LE for it, it was him that made this possible... I just wanted to make sure everyone had it.