nubi sql
 

I noticed that the Troopers and Crusaders in Cabilis only use the correct textures when you use #gender 2 in game.

I want to fix the db to this..

select * from npc_types where name='Trooper%'

but I also need to access the various spawn tables in the same query, somthing like if name=Trooper% && zone='Cabwest'

Can also do the same thing for fixing some mobs sizes then.

Any ideas plz?

I'll try and remember to post this when I get home.

It looks like this is a lot harder thanI first thought. I can't find a way to do a join with an updte command.

I can do a select just fine, anyone out there know how to do this?

Hopefully this fix should be in my next DB release.. thanks for the info, I was wondering how to get the Iksar guards to use the right textures.

Even better, cool :)