[Release][Daily] Ascent, Moon++, LUA++, ABD and Extra's [4533,368,239,131][04-05-08]

yeah the NPC flags changed so u need an SQL fix for it to work.
I'm installing my server again (computer crashed)
and gonna look for bugs and fixes tomorow

try this for the trainer/spirit healer:

Code:

---

UPDATE creature_proto SET npcflags=npcflags & ~16384 | 64 WHERE npcflags & 16384;
UPDATE creature_proto SET npcflags=npcflags & ~32768 | 16384 WHERE npcflags & 32768;

---

found this on ascentemu forum....

Quote:

---

Originally Posted by VizualG

yeah the NPC flags changed so u need an SQL fix for it to work.
I'm installing my server again (computer crashed)
and gonna look for bugs and fixes tomorow

try this for the trainer/spirit healer:

Code:

---

UPDATE creature_proto SET npcflags=npcflags & ~16384 | 64 WHERE npcflags & 16384;
UPDATE creature_proto SET npcflags=npcflags & ~32768 | 16384 WHERE npcflags & 32768;

---

found this on ascentemu forum....

---

I'm kinda noob on fixing with SQL and shit.. But.. what do i do with this

UPDATE creature_proto SET npcflags=npcflags & ~16384 | 64 WHERE npcflags & 16384;
UPDATE creature_proto SET npcflags=npcflags & ~32768 | 16384 WHERE npcflags & 32768


could you tell me exactly how it works? Or could you possibly make an .SQL file for trainer fix? >_>

just make a new text document, put those 2 lines in it
UPDATE creature_proto SET npcflags=npcflags & ~16384 | 64 WHERE npcflags & 16384;
UPDATE creature_proto SET npcflags=npcflags & ~32768 | 16384 WHERE npcflags & 32768;

save it as fix.sql and run it in your database :D

Quote:

---

Originally Posted by curcubeu

just make a new text document, put those 2 lines in it
UPDATE creature_proto SET npcflags=npcflags & ~16384 | 64 WHERE npcflags & 16384;
UPDATE creature_proto SET npcflags=npcflags & ~32768 | 16384 WHERE npcflags & 32768;

save it as fix.sql and run it in your database :D

---

oh... Hope it works! Thanks Curcubeu!

yes thats the way to do it, thnx
i forgot to mention that lol

ooh yeah curcubeu:

i tested the spirit healer script... works thnx

but the rexx sickness spell is a little off, it gives rezz sickness with 0seconds left and keeps blinking at 0sec. maybe i did something wrong dont know...
or the spell is off, it has to be 10min

just wait 10 minutes, on my revision it's gone after 10 minutes, if not search the spell id for res sic and add it instead of that 15007, i think that's the aura id :( i made that script in 10 minutes and didn't had time to test everything

Tested Ascent Trunk4.4 rev4512, Moon++ rev368, LUA++ rev235 with ABD rev125 and
still this dialog appears with profession trainers:

"Hey Admin, how can I help you?"
* Bring me back to life.

Goodbye.


Other profession trainers doesn't have dialog when u right-click them.

Please help.
Spirit Healer now works.:sq_yellow

Gah.. Seems it won't work check this:

http://i178.photobucket.com/albums/w...ic/problem.jpg

i also want to make a script for missing spells, if any1 knows the missing spells for each race and the level that spell require(gold too if you want me to add a price) please post and i'll share the script

ok, here is my trainer_spell table on my database the trainers work, and this table is the only one that have something to do with it, drop your trainer_spells table and run this script in the world database:

Filebeam - Free Fast File Hosting

Let me know if that solves it

i'll look into that tomorrow, i play retail and know a few spells that are missing for some classes.
The rest of the errors give me some time to fix them tomorrow

i need 2 party now, Queens day 2008 Holland

bye bye and cya'll tomorrow

Quote:

---

Originally Posted by curcubeu

ok, here is my trainer_spell table on my database the trainers work, and this table is the only one that have something to do with it, drop your trainer_spells table and run this script in the world database:

Filebeam - Free Fast File Hosting

Let me know if that solves it

---

Still doen't work!:smurf:

Nope, Ain't working... :/

can you tell me the id of a trainer that doesn't work so i test it on my server?