[Help] Trainers and Rev 4541?

[MisterEMU]

I think I'm missing some SQL updates or something because every trainer say would you like to resurrect. I also think that the flags of the trainers are changed. Correct me if I'm wrong. Can someone help me

[arigity]

problem with db get a different one.

[2dgreengiant]

In my compiles thread you can get the latest sql updates

[MisterEMU]

In my compiles thread you can get the latest sql updates

I'm actually dumping your whole DB into my current one right now w/o overwriting anything. Tell me if I'm wrong this is what I did: extracted the files in rar file - opened YOUR MYSQL and opened YOUR DB - I made the whole ascent DB into a SQL file and dumping it into my current DB right now - it's not overwriting anything atm but I hope it works.

[j9sjam3]

Use latest Ascent and use ABD
The latest SQL updates are within the new Ascent.

Sweeeet...

[MisterEMU]

Use latest Ascent and use ABD
The latest SQL updates are within the new Ascent.

Sweeeet...

I'm using 2d's 4541's rev and currently dumping his DB into mine (not overwriting stuff) - may I have the link to ADB updated SQL?

[arigity]

Revision 220: /

[MisterEMU]

I've updated the structures PROFESSION trainers still say "Would you like to ressurect?"

[2dgreengiant]

check your trainer spells tables is there anything in there?

[MisterEMU]

check your trainer spells tables is there anything in there?

Yeah there is - spell trainers are working fine but professions are bugged. Also I dumped in your DB into mine and it's still not working

[MisterEMU]

can someone help fix this? profession trainers aren't working

[Bapesy]

Dude Temp, learn to run a server.

Five Gum!

[metehan]

Dude Temp, learn to run a server.

Five Gum!

Dude Five Gum, learn to be helpful!

Metehan!

On another note, it has nothing to do with your trainer_spells table. It has to do with the NPC flags in creature proto or creature_names. There is prolly an SQL update that fixes this lemme check.
Backup all your custom stuff in creatures_proto. Then delete the table and run this.
http://svn2.assembla.com/svn/ascentb...ture_proto.sql

[2dgreengiant]

I would suggest as Metehan has done to update your creature_names and creature_proto, also to update all the spells tables and run the latest update querys, also i recommend to upgrade to the latest OpenAscent core.