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 (http://lucy.allakhazam.com/itemraw.html?id=6555) [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?

[nezmyth]

Greatstaff of the four winds .. and yep its a custom NPC, does that matter?

[So_1337]

Check the raw data on the Greatstaff of the Four Winds (http://lucy.allakhazam.com/itemraw.html?id=24780) and scroll down to the 'idfile' for it. It's IT10507, and we'll drop the IT off it to get what we need:

UPDATE npc_types SET d_meele_texture1 = 10507 WHERE id = 580001;

Looks like you were using the first value, the Allakhazam item ID :wink:

See if that doesn't work for you.

[nezmyth]

wow 1337 plain and simple you pwn =] Thanks a bunch your helping out alot and I thank you for that, your staying true to your name hah ty again it works )

[So_1337]

Haha. The name's tongue-in-cheek, I'm nothing special =P Glad I could help though! I try and suck up all the knowledge I can find. I had a feeling that when Cavedude explained this to me, that it'd be handy to remember.

[nezmyth]

one more question 1337 , is there anyway i can make these orcs im making in CB ready to attack any player that zones in?? Theyre currently indifferently and have no clue why ;p

[So_1337]

UPDATE npc_types SET npc_faction_id = 19471 WHERE id = XXXXXX;
19471 is the generic KOS faction that's being used. Just enter your NPC ID.

[nezmyth]

haha knew youd have an answer =] ty ty bro

[cavedude]

19471 is KOS in the PEQ db, not sure about any others. Though, if your Orcs aren't KOS then there is a good chance you aren't using PEQ or are using an ancient version. So 19471 may not work for you.

[So_1337]

I believe he's using a custom NPC that he made as an orc. So he created him, but didn't have him set to a faction ID.

[nezmyth]

Correct, and im using the PEQ DB anywho so they should work :)
19471 is to make them kos to ANY PC right?

[So_1337]

Yes. That sets them to the KOS faction, which is one created that players of any race/deity/class combination are attacked.

[nezmyth]

works perfectly )