No npc in game

Go down

No npc in game

Post by Ewok on Wed Oct 10, 2012 6:30 am

Core: Mangos 3.3.5a
Problem: The npc is not there. it says in the server "Creature <Entry: 190000> has no model defined in table 'creature_template', can't load.

What I Did: I looked in that table and there is no entry 190000, did cntrl+F and searched 190000 and found nothing. In the game on my gm i can do .lookup creature portal master and see that it has an id of 190000, but when i do .npc add 190000 i get a syntax error and it wont spawn.


Ewok

Viestien lukumäärä : 2
Join date : 2012-10-09

Back to top Go down

Re: No npc in game

Post by Rochet2 on Thu Oct 11, 2012 7:19 am

I have not updated the SQLs for a year or few now.
I bet mangos has changed.

Ill try fixing it up over the next week .. possibly.
avatar
Rochet2
Admin

Viestien lukumäärä : 196
Join date : 2010-02-04

http://emuproject.bbflash.net

Back to top Go down

fixed it!

Post by Ewok on Fri Oct 12, 2012 5:25 am

i got it working. It had to have something to do with navicat not executing the sql right. I had to go into the table creature_template and create the entry 190000. for some reason my navicat wasnt doing it. i just looked at the portal master sql i downloaded and read where it said
INSERT INTO creature_template (entry, modelid_1, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, dmg_multiplier, unit_flags, type, type_flags, InhabitType, unk16, unk17, RegenHealth, flags_extra) VALUES
('190000', '21572', "Portal Master", "", 'Directions', '50000', 71, 71, 13700, 13700, 6540, 6540, 5700, 35, 35, 3, 1, 1.14286, 1.25, 1, 1, 2, 7, 138936390, 3, 1, 1, 1, 2);
i had to run the sql into the database, but it didnt make the entry into creature_template so just manually creating the 190000 entry and inserting all of those values into the right column is all i needed to do.

Ewok

Viestien lukumäärä : 2
Join date : 2012-10-09

Back to top Go down

Re: No npc in game

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum