|
|
 |
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
|
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. |

03-13-2008, 08:19 AM
|
Sarnak
|
|
Join Date: Mar 2008
Posts: 71
|
|
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
|

03-13-2008, 08:52 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
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';
|

03-13-2008, 03:09 PM
|
Sarnak
|
|
Join Date: Mar 2008
Posts: 71
|
|
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
|

03-13-2008, 03:28 PM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
Yeah. Don't ask me why, but melee is misspelled in the table, so that's just how it is.
|

03-13-2008, 03:59 PM
|
Sarnak
|
|
Join Date: Mar 2008
Posts: 71
|
|
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?
|

03-13-2008, 04:36 PM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
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?
|

03-13-2008, 04:43 PM
|
Sarnak
|
|
Join Date: Mar 2008
Posts: 71
|
|
Greatstaff of the four winds .. and yep its a custom NPC, does that matter?
|

03-13-2008, 05:48 PM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
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.
|

03-14-2008, 09:35 AM
|
Sarnak
|
|
Join Date: Mar 2008
Posts: 71
|
|
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 )
|

03-14-2008, 10:25 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
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.
|

03-14-2008, 12:17 PM
|
Sarnak
|
|
Join Date: Mar 2008
Posts: 71
|
|
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
|

03-14-2008, 01:50 PM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
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.
|

03-14-2008, 01:55 PM
|
Sarnak
|
|
Join Date: Mar 2008
Posts: 71
|
|
haha knew youd have an answer =] ty ty bro
|

03-15-2008, 01:23 AM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
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.
|

03-15-2008, 03:28 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
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.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 07:04 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |