[Ascent] Rev2406, Rev2400 with AHBot, NCDB Rev662 [11/22/07]

[Solo761]

Ascent compiles

Ascent Rev2439
Ascent Rev2439
Ascent Rev2406
Ascent Rev2400
Ascent Rev2397
Ascent Rev2396
Ascent Rev2383
Ascent Rev2381 - it seems crash issue has been resolved, I dropped Volatile Rum and server didn't crash
Ascent Rev2378 - crashes when you try to drop item on the ground (dispose of item)
Ascent Rev2375 - crashes when you try to drop item on the ground (dispose of item)
Ascent Rev2364


Ascent compiles with Auction House bot patch by Darvaleo

Ascent Rev2462 with AHBot
Ascent Rev2422 with AHBot
Ascent Rev2400 with AHBot
Ascent Rev2364 with AHBot


NCDB revs

NCDB Rev 679
NCDB Rev 665
NCDB Rev 662
NCDB Rev 661 - just 1649world_banned_phrases.sql and 2325_world_creature_names.sql are needed for this DB to work with Ascent (tested on Ascent Rev2397)
NCDB Rev 660
NCDB Rev 658 - [Fix][NPCs] Weapon Trainers flags
NCDB Rev 657 - It seems Vendors are working with this one without aditional fixes (except 2325_world_creature_names.sql)
NCDB Rev 656
NCDB Rev 655 - it seems this one has issues with class trainers not working

----------------------------------------------------------------

For more details about AHBot patch go here

Board Message

It's easy to use and it's configuration is in ascent.conf. It is on by default.


----------------------------------------------------------------

If your weapon masters don't work try fix in post 16. This should be included in NCDB revs 658 and higher.

[MentaL]

[ltglobal]

okey man :) this rev and NCDB is good ;) all npc everything allright... but ... the trainers dont train just say : "Hello nick " but i think its db issue

[Kameleon20]

got same problem as ltglobal!

[Solo761]

It seems it's db issue. Druid trainer in Thunderbluff also doesn't work.

There's rev 656 already out, I tried it and it seems they fixed it, Thunderbluff trainer works. Although Thunderbluff auction guys are missing, in 656 and 655, Orgirmar auction house works fine.

[ltglobal]

656 so why you dont post the link ? :) we will be very happy if you post link :P

[ltglobal]

sorry you post the link THANX

[ltglobal]

ironforge , stormwind trainers seems not to work in NCDB 655

[Kameleon20]

sorry, did it again, and trainers are working now :)
tho now the quests aren't working

[Solo761]

I guess we'll have to wait until they release db for 2.3.0, these are mainly for 2.2.3 and while we can add SQL updates to it, I think that there will be issues with traders, vendors, trainers and what else until db devs take a look at it, they know know the best what they used for each of them and where they put them :).

I'll try to upp new revisions in hope some of them will work better, at this moment Rev656 is still the current one.

[Paco44]

My server currently has critical errors upon talking to multiple vendors (mostly custom)... it's a good idea to wait for the NCDB and Ascent teams to catch up with the new update.

[Solo761]

Updated post with revs 2375 and 2378, just as I edited the post with 2375 I checked SVN and 2377 was available, and just as I compiled 2377 I checked SVN again and 2378 was available, fix for a fix in 2377 :P.

There are some new SQL updates in 2375 (and later), but nothing I could identify in game in short time I tried it. One thing I noticed in 2364, 2375 and 2378 is that mage's blink is detected as speedhack and after few times I get kicked from the game.

[ltglobal]

i have see few critical bugs first in the water you can walk no breath ... second when you want to drop item on the ground server crash...

[Solo761]

Yup, just tried it, in 2378 dropping an item crashes the server, but in 2364 dropping works fine.

Also in 2364 that green water in Undercity works as water, in 2378 water in Stranglethorn Valley works as water, in 2364 it doesn't.

[ltglobal]

thanx man i will try with 2364

[Solo761]

I just added and Rev2381 Ascent, this one didn't crash when I dropped an item, and I added NCDB Rev657, acording to SVN they added 2368_world_map_checkpoint.sql and 2368_world_worldmap_info.sql to it, unfortunatly 2325_world_creature_names.sql wasn't included so there weren't any NPCs. But after I imported it they spawned and also, vendors were working without additional fixes. Water wasn't working until I imported 2074 series files, after that STV sea and river was working as water. Still waiting for zeppelin to check other areas, too lazy to switch to GM account :P.

So, to have NPCs and water working I imported these files to NCDB 657

2074world_creature_names_localized.sql
2074world_gameobject_names_localized.sql
2074world_itempages_localized.sql
2074world_items_localized.sql
2074world_npc_text_localized.sql
2074world_quests_localized.sql
1649world_banned_phrases.sql
2325_world_creature_names.sql
2368_character_guild_checkpoints.sql

I don't know if 1649world_banned_phrases.sql is needed for something specific, I just noticed that ascent reports it as missing, after I imported it that message dissapears.

*edit*

Brightwater Lake in Tirisfal Glades also works as it should.

[Solo761]

To have Weapon Masters fixed execute this SQL query in your world database

#<Weapon Master> should be a trainer
UPDATE `creature_proto` SET `npcflags`='16' WHERE `entry`='11867';
UPDATE `creature_spawns` SET `flags`='16' WHERE `entry`='11867';

#Set UNIT_NPC_FLAG_TRAINER flag for ALL weapon masters
UPDATE `creature_proto` SET `npcflags` = '16' WHERE `entry` in (select `entry` from `creature_names` where `subname` like '%weapon master%');

[arnamajd]

The links are not working..

[Solo761]

What links exactly? I tried few and they work.

[arnamajd]

Filebeam seems to work again..

[nanouniko]

Well my problem is this: I come from Latin America, and when translating leaves me translate quests and items but not the npc, one could help me with that .... thanks. I used the rev2394 and ncdbREV661

[Solo761]

Updated Ascent and NCDB revs.

[ltglobal]

newest rev and newest db also water bug :(
you can walk under the water you dont swim :\

[ltglobal]

i think in newest rev need compile with oldest files

[nanouniko]

Good, well what happens is that the backup charge of the accounts in the rev2397 and NCDB661 but when I do that when it is to create a new character comes out without clothes and when you try to enter one of old characters the server goes down, please help me. Thank you.

[Solo761]

I'm not sure I understood. You have backup of your characters, you set Ascent rev2397 and NCDB rev661 but characters don't have their equipment? I'm not sure I can help, I only compile these revs. I try them but I never had that problem.

Is this character backup from 2.3.0 WoW version or from earlier. If it's from older WoW version (older Ascent revs), have you imported SQL updates to your character database? Mainly these

2272_character_playeritems.sql
2302_character_characters_insert_queue.sql
2302_character_playeritems_insert_queue.sql
2368_character_guild_checkpoints.sql

@ltglobal

When I tried Rev2397 and NCDB 661 I deleted my old world database, and just imported NCDB in new database. When I tried it then the water worked fine (tried water in STV and lake in Tirisfal Glades) but there weren't any NPCs and mobs. Then I imported 1649world_banned_phrases.sql and 2325_world_creature_names.sql and NPCs also worked, trainers and vendors. Where exactly have you tried to swim, so I can check if water there works for me. I think this is DB issue, not ascent. Those areas might have not yet been set as water.

I'm just compiling new revision of Ascent and NCDB, I'll test them and post them little later.