[Ascent]Help! Trainers.. Ascent

[IceSaint]

Hello there peoples of RaGEZONE! I got a major problem with my trainers, when you right click them, to get to train they only have the "tab" that says Bring me back to life. But when I click that nothing happens either, anyways, Someone possibly have any trainer fix? Thanks!

 

[amxar]

bump.

 

[Pus]

Wrong faction.

 

[Ackhole]

update `creature_proto` set `npcflags` = '16' where `npcflags` = '16384';
update `creature_proto` set `npcflags` = '4224' where `npcflags` = '128';
update `creature_proto` set `npcflags` = '16384' where `npcflags` = '32768';

That should work, provided by ACP.

 

[drphil69]

i dont see creature_proto can you tell me how to put these in please ok i found it in my sql file how do i add these if you dont mind me asking

 

[Ackhole]

i dont see creature_proto can you tell me how to put these in please ok i found it in my sql file how do i add these if you dont mind me asking

if you use SQLYOG, put the three in the Queries box and run them while your selecting the worlddb.

otherwise, make a new file called something.sql, put the queries in there, and rightclick the worlddb and "click restore from SQL dump".

 

[amxar]

Thanks to you both, damn im blind...

 

[amxar]

Damn, it didnt work though.. Still the same thing.

 

[drphil69]

yea me to didnt work

 

[amxar]

Got it to work by downloading a sql query. Cant remember where though.