Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2008, 08:19 AM
nezmyth
Sarnak
 
Join Date: Mar 2008
Posts: 71
Default NPC's Spawning w/ Weps in Hands

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
Reply With Quote
  #2  
Old 03-13-2008, 08:52 AM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

Use this query:

Code:
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:

Code:
UPDATE npc_types SET d_meele_texture1 = '10025' WHERE id = '159690';
Reply With Quote
  #3  
Old 03-13-2008, 03:09 PM
nezmyth
Sarnak
 
Join Date: Mar 2008
Posts: 71
Default

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

Quote:
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
Quote:
Unknown column 'd_melee_texture1' in field list
EDIT:: mispelled melee ganna go check if it worked =p
Reply With Quote
  #4  
Old 03-13-2008, 03:28 PM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

Yeah. Don't ask me why, but melee is misspelled in the table, so that's just how it is.
Reply With Quote
  #5  
Old 03-13-2008, 03:59 PM
nezmyth
Sarnak
 
Join Date: Mar 2008
Posts: 71
Default

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?
Reply With Quote
  #6  
Old 03-13-2008, 04:36 PM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

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?
Reply With Quote
  #7  
Old 03-13-2008, 04:43 PM
nezmyth
Sarnak
 
Join Date: Mar 2008
Posts: 71
Default

Greatstaff of the four winds .. and yep its a custom NPC, does that matter?
Reply With Quote
  #8  
Old 03-13-2008, 05:48 PM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

Check the raw data on the Greatstaff of the Four Winds and scroll down to the 'idfile' for it. It's IT10507, and we'll drop the IT off it to get what we need:

Code:
UPDATE npc_types SET d_meele_texture1 = 10507 WHERE id = 580001;
Looks like you were using the first value, the Allakhazam item ID

See if that doesn't work for you.
Reply With Quote
  #9  
Old 03-14-2008, 09:35 AM
nezmyth
Sarnak
 
Join Date: Mar 2008
Posts: 71
Default

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 )
Reply With Quote
  #10  
Old 03-14-2008, 10:25 AM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

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.
Reply With Quote
  #11  
Old 03-14-2008, 12:17 PM
nezmyth
Sarnak
 
Join Date: Mar 2008
Posts: 71
Default

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
Reply With Quote
  #12  
Old 03-14-2008, 01:50 PM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

Code:
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.
Reply With Quote
  #13  
Old 03-14-2008, 01:55 PM
nezmyth
Sarnak
 
Join Date: Mar 2008
Posts: 71
Default

haha knew youd have an answer =] ty ty bro
Reply With Quote
  #14  
Old 03-15-2008, 01:23 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

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.
Reply With Quote
  #15  
Old 03-15-2008, 03:28 AM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:04 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3