Metehan's REAL Non-PTR 2.4 Ascent Compile

[beileroord]

Revision: 4322
Author: optical
Date: 09:26:08, woensdag 16 april 2008
Message:
* fixed the database check, it was checking the wrong table.
----
Modified : /trunk/src/ascent-world/ObjectMgr.cpp

Guess its also better to wait for walla to wakeup and release his 2.4 stuff

[Kolorados]

trainer work however, are for whom fix on it or table trainer_spells?

[metehan]

Rev 4322 uploaded with tons of awesome scripts and illidan scripted and all! No new DB needed just run the updates and you are done!

[Joshbb]

Can somebody Compile a COMPLETE NEW Revision and post.. With database and make it perfect.

[Joshbb]

With Scripts

[Aes]

is the latest one the same to make it public? or do i have to change more things or is there a different way of making it work publicly?

i cant try it now because im at school =C

[metehan]

Can somebody Compile a COMPLETE NEW Revision and post.. With database and make it perfect.

This is a new rev...

[enterthecookie]

Big update: 4/16/08 4:10 PM
Rev 4322 Latest
Scripts included:
Heal NPC
Buff NPC
Custom DJ
Teleporter
PvP token system
Stripper npc
Morph NPC
Max Skill Giver NPC
Download it here!
Best 2.4 compile zomg!
DOWNLOAD NOW!

credits to moon++

I just downloaded this and executed the SQLs, but the trainers still dont seem to work... could you please release a whole pack? As in the REV and the Database for the world and logon databases? (Separated Databases)

[Aes]

when i execute it it stays at 45 for maby 1hour then shows the error. why does it take so long?

[metehan]

Updated fix for vendors.

DELETE FROM trainer_spells WHERE entry NOT IN (SELECT entry FROM trainer_defs WHERE 1=1);
DELETE FROM trainer_defs WHERE entry NOT IN (SELECT entry FROM trainer_spells WHERE 1=1);

Run that and they will work.

[livingbones]

Updated fix for vendors.

DELETE FROM trainer_spells WHERE entry NOT IN (SELECT entry FROM trainer_defs WHERE 1=1);
DELETE FROM trainer_defs WHERE entry NOT IN (SELECT entry FROM trainer_spells WHERE 1=1);

Run that and they will work.

tried it but they still do not train spells..

can you share your trainers tables?

[metehan]

Did you run ALL the sql updates in the SQL folder?

[ivory]

hallo
I come from germany and search a ready DBC for 2.4 in in English there German some bugs has one can help me there?
would be on everybody fall nicely