npc

[Avalon]

lol, wtf my npc's dont work, only skill trainer work, u cannot talk to guard, traders, etc..

I using Ascent DB..

[nether drake]

npc flags are not inserted

change your repack

[Rednexx]

or just run a npc fix

[klen]

What repack are you using? There are alot of good ones here!

[Avalon]

Hurley Bob's repack

[nether drake]

Hurley Bob's repack

2.3.0 ascent repack?

[Avalon]

yes i am using 2.3.0 repack

[Ebon]

Execute this:
UPDATE creature_proto SET npcflags = 135296 WHERE npcflags = 16644;
UPDATE creature_proto SET npcflags = 4243 WHERE npcflags = 16407;
UPDATE creature_proto SET npcflags= 4241 WHERE npcflags = 16405;
UPDATE creature_proto SET npcflags = 4112 WHERE npcflags = 16400;
UPDATE creature_proto SET npcflags = 4227 WHERE npcflags = 16391;
UPDATE creature_proto SET npcflags = 4226 WHERE npcflags = 16390;
UPDATE creature_proto SET npcflags = 4225 WHERE npcflags = 16389;
UPDATE creature_proto SET npcflags = 4224 WHERE npcflags = 16388;
UPDATE creature_proto SET npcflags = 4099 WHERE npcflags = 16387;
UPDATE creature_proto SET npcflags = 4096 WHERE npcflags = 16384;
UPDATE creature_proto SET npcflags = 4194307 WHERE npcflags = 8195;
UPDATE creature_proto SET npcflags = 4194305 WHERE npcflags = 8193;
UPDATE creature_proto SET npcflags = 4194304 WHERE npcflags = 8192;
UPDATE creature_proto SET npcflags = 2097152 WHERE npcflags = 4096;
UPDATE creature_proto SET npcflags = 1048577 WHERE npcflags = 2049;
-- UPDATE creature_proto SET npcflags = 262145 WHERE npcflags = 1537;
-- UPDATE creature_proto SET npcflags = 262144 WHERE npcflags = 1536;
UPDATE creature_proto SET npcflags = 524417 WHERE npcflags = 1029;
UPDATE creature_proto SET npcflags = 524416 WHERE npcflags = 1028;
UPDATE creature_proto SET npcflags = 524288 WHERE npcflags = 1024;
UPDATE creature_proto SET npcflags = 131075 WHERE npcflags = 259;
UPDATE creature_proto SET npcflags = 131073 WHERE npcflags = 257;
UPDATE creature_proto SET npcflags = 131072 WHERE npcflags = 256;
UPDATE creature_proto SET npcflags = 65667 WHERE npcflags = 135;
UPDATE creature_proto SET npcflags = 65665 WHERE npcflags = 133;
UPDATE creature_proto SET npcflags = 65664 WHERE npcflags = 132;
UPDATE creature_proto SET npcflags = 65539 WHERE npcflags = 131;
UPDATE creature_proto SET npcflags = 65537 WHERE npcflags = 129;
-- UPDATE creature_proto SET npcflags = ??? WHERE npcflags = 64;
UPDATE creature_proto SET npcflags = 32769 WHERE npcflags = 33;
UPDATE creature_proto SET npcflags = 32768 WHERE npcflags = 32;
UPDATE creature_proto SET npcflags = 147 WHERE npcflags = 23;
UPDATE creature_proto SET npcflags = 145 WHERE npcflags = 21;
UPDATE creature_proto SET npcflags = 8195 WHERE npcflags = 11;
UPDATE creature_proto SET npcflags = 8194 WHERE npcflags = 10;
UPDATE creature_proto SET npcflags = 8193 WHERE npcflags = 9;
UPDATE creature_proto SET npcflags = 8192 WHERE npcflags = 8;
UPDATE creature_proto SET npcflags = 130 WHERE npcflags = 6;
UPDATE creature_proto SET npcflags = 129 WHERE npcflags = 5;
UPDATE creature_proto SET npcflags = 128 WHERE npcflags = 4;

I DO NOT TAKE CREDIT FOR THIS FIX!!! Execute this into your Ascent Database.

[Avalon]

Thanks, it fixed!

[ADAMZY]

How do you execute that script using SQLyog??

Thanks in advance

NVM, i figured out how

(im sooo stupid)