[Ascent] 2.3.0 NPC Solution

[grandmst20]

Go to my [Ascent] Server Files (Last Update: 11/14/07) - MMORPG Development Forums - RaGEZONE thread and download NCDB Rev 656, one of the latest Ascent compiles, Character DB (2.3.0 Full), and the SQL Updates. Do everything normally and run the new SQL fixes (2300+) and most of (if not all) NPCs should work properly.

If you have any problems then you are a moron because I just did this 5 minutes ago and had no problems whatsoever. If you get an error while executing a SQL script than it means it's already been implemented.

For the moment you have to get these files via Rapidshare because I'm currently uploading to Filebeam. Don't complain about there not being any Filebeam links at the moment or I'll destroy your house with a cruise missile.

[MentaL]

[Paco44]

A cruise missile? ROFL.

I'm considering tagging alongside you and begin providing compiles as well. Tired of me being the only one benefiting.

[fox333]

Fix WeaponMaster Trainre too?

[edor5555]

in that ncdb all the trianer no work ! plz fix it on the next rev and i wil be happy ! :)

[DRYPER]

IT DOESNT WORK.... if it does upload your db and give us prove ...

[Dopestar]

IT DOESNT WORK.... if it does upload your db and give us prove ...

it works fine I tested it , your obviously doing something wrong

[edor5555]

i do all the SQL fixes stay no work :(
the npc said : hi who can i help you ?

[Dopestar]

ok i can confirm it doesnt work with clean 656 rev and the latest 2.3 character db

it must be something else we did I'll look into that now

[edor5555]

so how much time the trianer wil work <>
i very need it

[DRYPER]

yeah edor is correct they just say: How can i help you.... irritating :) lol

Hope you can come with a solution Dopestar :)

[madjock]

Yea there is a problem with the trainers/NPC's I found that the new updates of the Creature Names table seemed to screw things up a bit.

Try applying (2325) World - Creature Names.sql after you have applied all the relevant sql table updates and see if that helps - fixed mine :) at rev 2364

/MJ

[DRYPER]

Nope didnt work :=(

[madjock]

you could try applying these 2 as I do them automatically now to avoid the "no NPC problem" but it shouldn't make any diff to trainers/NPC

(1393) World - Banned Names.sql
(1649) World - Banned Phrases.sql

Will also have a think about it as I may have done something else as it did take me about 3 hrs to get the release working properly especially the NPC side of it.

[zlaya07]

to fix npc's execute:
(2325) World - Creature Names.sql
(2074) World - Quests Localized.sql
(2074) World - NPC Text Localized.sql
(2074) World - Items Localized.sql
(2074) World - Itempages Localized.sql
(2074) World - Gameobject Names Localized.sql
(2074) World - Creature Names Localized.sql
(1393) World - Banned Names.sql
(1649) World - Banned Phrases.sql

that helped by my case and everything is fine.

@fox333-to fix weapon trainers you need to set the flags of the weapon trainers to 16 in the creature_proto table,that's all

[grandmst20]

Not all NPCs are fixed. Give it time you morons. I just provided the solution for a majority now.