NPC's Spawning w/ Weps in Hands

[nezmyth]

Hi guys, Ive been #spawning mobs while inserting itemid #'s in primary & secondary slots but when they spawn they dont show up... Ive searched and dont think anyone has found a solution so Im bringing this topic up again to see if possibly mabye someone knows the solution. I'd like the mob to have the weapon graphic but not have the actual weapon in the loot table

[So_1337]

Use this query:

UPDATE npc_types SET d_meele_texture1 = XXXXX WHERE id = YYYYY;

The Xs are the 'idfile' value that you'll find when looking at the raw data for a weapon on Lucy or in the database and the Ys are the NPC ID. Use only the numbers that you find.

For example, Seru holds the Sword of Truth [which has an 'idfile' value of 'IT10025'] and he is NPC ID 159690. So the query for him looks like this:

UPDATE npc_types SET d_meele_texture1 = '10025' WHERE id = '159690';

[nezmyth]

Well im typing this into the MYSQL QUery Browser in the top ...

UPDATE npc_types SET d_meele_texture1 = 17278 WHERE id = 580001;

I have the npc_types table selected and i click execute with the above typed in... I get an error saying

Unknown column 'd_melee_texture1' in field list

EDIT:: mispelled melee ganna go check if it worked =p

[So_1337]

Yeah. Don't ask me why, but melee is misspelled in the table, so that's just how it is.

[nezmyth]

k im havign a problem its not showing but im trying to figure it out on my own and experiment but im sick of having to shutdown the server by X'ing out the 3 command windows that start the server up and restarting them up again (start.bat, world.exe, zone.exe) whenever i update something in the database, is there a way for it to take affect right when i update the database? So i can just zone out or something and itll take affect?

[So_1337]

It depends upon what you're updating. Some things will take, some things won't. You'll have to give some examples.

As for it not working, what weapon are you trying to have them hold? And is that a custom NPC you're assigning it to?