[Ascent]Modified Ascent Compiles(Last Updated 12/20/2007)

[Shadei]

Resources:
Setup Guide - by grandmst20
Server Files - by grandmst20 & Paco44
GM Commands - Ascent Wiki

Purple Newest Files
Blue Previous Files

All Compiles Include Latest SQL Updates


-----------------------------------------------------------------------------------------------------------------------
Ascent Core
-----------------------------------------------------------------------------------------------------------------------
(Added ALL Flying Mounts to Azeroth)

[NEW]Preview Video - QSave

Note: An exploit was discovered. I fixed in Revision 2610. All Revisions prior to 2610 have been removed and it's recommended you update your core. Check Readme!

QSave
[2643]Ascent.rar - 2.8 Mb
[2629]Ascent.rar - 2.9 Mb
[2610]Ascent.rar - 2.9 Mb

Filebeam
[2643]Ascent.rar - 2.8 Mb
[2629]Ascent.rar - 2.9 Mb
[2610]Ascent.rar - 2.9 Mb

AZ Flying Mounts+LUA Enabled

QSave
[2643]Ascent_LUA.rar - 2.9 Mb
[2629]Ascent_LUA.rar - 2.9 Mb

Filebeam
[2643]Ascent_LUA.rar - 2.9 Mb
[2629]Ascent_LUA.rar - 2.9 Mb


-----------------------------------------------------------------------------------------------------------------------
Other Files
-----------------------------------------------------------------------------------------------------------------------
Moon++ Sripts

QSave
[279]Moon++ Trunk

Filebeam
[279]Moon++ Trunk


-----------------------------------------------------------------------------------------------------------------------
Credits
-----------------------------------------------------------------------------------------------------------------------
grandmst20 - For his Guide to Setting up Ascent.
QSave&Filebeam - For being great file hosts.
Phieeel - For adding flying mounts I missed. Rev 2576+
Ascent - For being an awesome core & Open Source.
NCDB - For currently being my favorite and only supported Database.
mclarkey08 - Who talked me into doing this :P

[MentaL]

[irishboy777]

ty +karma to you

[Kameleon20]

still a problem. this time i've maded a screenshot of it ;)

[Kameleon20]

I've been searching... problem is in the ascent.exe
when i update everything except ascent.exe the problem(s) is(are) solved

[Shadei]

I'm not sure what would cause that, but are your maps and DBC files up to date? Version 2.3.0?

What database are you using?

**Edit** I'm going to do a clean install using the files I provided here. See if I have any problems, but as of right now it hasn't crashed yet.
(added)
I've done a full clean install using my DBC files and The Character DB Provided by grandmst20. With no problems I tried on 3 of my PCs all running XP sp2. I'm going to post my DBC files, it looks like you passed that section without problems, but I know the DBC files are responsible for alot of these access violation errors.

[Kameleon20]

I am using the 2.3.0 maps, and have the most recent DBC files.
I'm using RusDB 100 (latest as far as i know).

I also tried new DBC files, still same error, can't be the problem..
I'm also using WinXP SP2 with latest updates etc. (Vista sucks. here in holland the consumerservice already has told us to boycot Vista *grin*)

[Shadei]

I am using the 2.3.0 maps, and have the most recent DBC files.
I'm using RusDB 100 (latest as far as i know).

I also tried new DBC files, still same error, can't be the problem..
I'm also using WinXP SP2 with latest updates etc. (Vista sucks. here in holland the consumerservice already has told us to boycot Vista *grin*)

I agree my laptop used to have vista. I hated it. It bugged out on everything. It was just there to eat up system rescources. Have you tried using a different database? Also My DBC files and whatnot are all enUS. So maybe that could cause an issue, I'm unsure :( I haven't been able to reproduce the problem myself, and no one else has had an issue that i know of. I'll keep looking into it though.

[Paco44]

It's sexy to see Qsave being used in so many places. Thanks.

[DrCuddles]

Hey, the DBC files are definitely my problem with the Access Violation, i had the same problem last time.
Now you have only put DBC files for enUS, where as i am in GB and my copy of wow is enGB, will that make a difference?

A screen shot of my error has been attached, It seems to occur when loading that Server script

[Kameleon20]

I've tried NCDB and now it is working. Strangely enough not compatible with RusDB ^^

[Shadei]

Hey, the DBC files are definitely my problem with the Access Violation, i had the same problem last time.
Now you have only put DBC files for enUS, where as i am in GB and my copy of wow is enGB, will that make a difference?

A screen shot of my error has been attached, It seems to occur when loading that Server script

Ok I'm updating the links with new compile. You can try it and see if that helps. I don't have a copy of enGB so I can't extract the DBC files myself. If you search the forum I'm sure you can learn how. I think it should work with the enUS DBC files. If I'm not mistaken.

[DrCuddles]

Ok I'm updating the links with new compile. You can try it and see if that helps. I don't have a copy of enGB so I can't extract the DBC files myself. If you search the forum I'm sure you can learn how. I think it should work with the enUS DBC files. If I'm not mistaken.

It does appear to be working just that script error, could you help me out, the version before worked :S
HEEEEEEEEEEEEEEEEEEEEEEEEEEELP
xD
:SniperHea

[Shadei]

What database are you using? Have you tried using a seperate one?

[DrCuddles]

I'm using NCDB692.
Its just that damn Server Status Plugin

[Shadei]

have you tried using revision 2545 yet? Try maybe making a clean install and see if you still have the issue. Make sure you've updated the Dll with the new one contained in the release. Also unless you use the stat dump (stats.xml) I don't think you need that dll.

[DrCuddles]

Upgraded (not a clean install) to 2545 worked perfect thanks, i jsut updated me ncdb to 694 aswell ;)

Thanks man :)

[Shadei]

np, hope you have fun dude.

[DrCuddles]

ARGH, now i updateded to 2545 i am getting so many 'Doesn't exist' errors

[Shadei]

you need to run all the sql updates. It looks for new tables now.

[DrCuddles]

That takes so long with SQLYog is there ayway to execute them all at once?

[Shadei]

Yeah there is a couple of ways, but I really don't recommend using them. There aren't very many you need to run. Just the World ones.

[DrCuddles]

Its not as many but im still missing loads

Ascent 2.5-TRUNK r2473/Release-Win32-X86 :: World Server
Copyright (C) 2005-2007 Ascent Team. http://www.ascentemu.com/
This program comes with ABSOLUTELY NO WARRANTY, and is FREE SOFTWARE.
You are welcome to redistribute it under the terms of the GNU General
Public License, either version 3 or any later version. For a copy of
this license, see the COPYING file provided with this distribution.

The key combination <Ctrl-C> will safely shut down the server at any time.

01:07 S Rnd: Initialized Random Number Generators.
01:07 D ThreadPool: Startup, launched 5 threads.
01:07 D ThreadPool: Thread 396 entered the free pool.
01:07 N Config: Loading Config Files...

01:07 D ThreadPool: Thread 2308 entered the free pool.
01:07 D ThreadPool: Thread 1068 entered the free pool.
01:07 D ThreadPool: Thread 4472 entered the free pool.
01:07 D ThreadPool: Thread 4772 entered the free pool.
01:07 S Config: >> ascent.conf
01:07 S Config: >> realms.conf
01:07 N Database: Connecting to MySQL on localhost with (root : *********)
01:07 D ThreadPool: Thread 396 left the thread pool.
01:07 D ThreadPool: Thread 396 is now executing task at 0x011C5A60.
01:07 N Database: Connecting to MySQL on localhost with (root : *********)
01:07 D ThreadPool: Thread 4772 left the thread pool.
01:07 D ThreadPool: Thread 4772 is now executing task at 0x011C5BD8.



01:07 N World: Loading DBC files...
01:07 N DBC: Loading DBC/ItemSet.dbc.
01:07 N DBC: Loading DBC/Lock.dbc.
01:07 N DBC: Loading DBC/EmotesText.dbc.
01:07 N DBC: Loading DBC/SkillLineAbility.dbc.
01:07 N DBC: Loading DBC/SpellItemEnchantment.dbc.
01:07 N DBC: Loading DBC/GemProperties.dbc.
01:07 N DBC: Loading DBC/SkillLine.dbc.
01:07 N DBC: Loading DBC/Spell.dbc.
01:07 N DBC: Loading DBC/ItemExtendedCost.dbc.
01:07 N DBC: Loading DBC/Talent.dbc.
01:07 N DBC: Loading DBC/SpellCastTimes.dbc.
01:07 N DBC: Loading DBC/SpellRadius.dbc.
01:07 N DBC: Loading DBC/SpellRange.dbc.
01:07 N DBC: Loading DBC/SpellDuration.dbc.
01:07 N DBC: Loading DBC/ItemRandomProperties.dbc.
01:07 N DBC: Loading DBC/AreaTable.dbc.
01:07 N DBC: Loading DBC/FactionTemplate.dbc.
01:07 N DBC: Loading DBC/Faction.dbc.
01:07 N DBC: Loading DBC/TaxiNodes.dbc.
01:07 N DBC: Loading DBC/TaxiPath.dbc.
01:07 N DBC: Loading DBC/TaxiPathNode.dbc.
01:07 N DBC: Loading DBC/CreatureSpellData.dbc.
01:07 N DBC: Loading DBC/CreatureFamily.dbc.
01:07 N DBC: Loading DBC/ChrRaces.dbc.
01:07 N DBC: Loading DBC/ChrClasses.dbc.
01:07 N DBC: Loading DBC/Map.dbc.
01:07 N DBC: Loading DBC/AuctionHouse.dbc.
01:07 N DBC: Loading DBC/ItemRandomSuffix.dbc.

01:07 N World: Beginning parallel server startup with 4 threads.

Sql query failed due to [Table 'character.gameobject_names' doesn't exist], Quer
y: [SELECT * FROM gameobject_names]
Sql query failed due to [Table 'character.items' doesn't exist], Query: [SELECT
MAX(entry) FROM items]
Sql query failed due to [Table 'character.creature_names' doesn't exist], Query:
 [SELECT * FROM creature_names]
Sql query failed due to [Table 'character.creature_proto' doesn't exist], Query:
 [SELECT * FROM creature_proto]
Sql query failed due to [Table 'character.itempages' doesn't exist], Query: [SEL
ECT * FROM itempages]
Sql query failed due to [Table 'character.areatriggers' doesn't exist], Query: [
SELECT * FROM areatriggers]
Sql query failed due to [Table 'character.quests' doesn't exist], Query: [SELECT
 * FROM quests]
Sql query failed due to [Table 'character.graveyards' doesn't exist], Query: [SE
LECT * FROM graveyards]
Sql query failed due to [Table 'character.teleport_coords' doesn't exist], Query
: [SELECT * FROM teleport_coords]
Sql query failed due to [Table 'character.fishing' doesn't exist], Query: [SELEC
T * FROM fishing]
Sql query failed due to [Table 'character.npc_text' doesn't exist], Query: [SELE
CT * FROM npc_text]
Sql query failed due to [Table 'character.worldmap_info' doesn't exist], Query:
[SELECT MAX(entry) FROM worldmap_info]
Sql query failed due to [Table 'character.zoneguards' doesn't exist], Query: [SE
LECT * FROM zoneguards]
Sql query failed due to [Table 'character.items' doesn't exist], Query: [SELECT
* FROM items]
Sql query failed due to [Table 'character.worldmap_info' doesn't exist], Query:
[SELECT * FROM worldmap_info]
01:07 N ObjectMgr: 0 players loaded.
01:07 N ObjectMgr: Sql query failed due to [Table 'character.playercreateinfo' d
oesn't exist], Query: [SELECT * FROM playercreateinfo]
0 guilds loaded.
Sql query failed due to [Table 'character.spelloverride' doesn't exist], Query:
[SELECT DISTINCT overrideId FROM spelloverride]
Sql query failed due to [Table 'character.creature_waypoints' doesn't exist], Qu
ery: [SELECT * FROM creature_waypoints]
Sql query failed due to [Table 'character.vendors' doesn't exist], Query: [SELEC
T * FROM vendors]
Sql query failed due to [Table 'character.spells112' doesn't exist], Query: [SEL
ECT * FROM spells112]
01:07 N ObjectMgr: 0 vendors loaded.
Sql query failed due to [Table 'character.trainer_defs' doesn't exist], Query: [
SELECT * FROM trainer_defs]
Sql query failed due to [Table 'character.spell_disable' doesn't exist], Query:
[SELECT * FROM spell_disable]
01:07 N ObjectMgr: 0 disabled spells.
Sql query failed due to [Table 'character.totemspells' doesn't exist], Query: [S
ELECT * FROM totemspells]
Sql query failed due to [Table 'character.ai_threattospellid' doesn't exist], Qu
ery: [SELECT * FROM ai_threattospellid]
Sql query failed due to [Table 'character.petdefaultspells' doesn't exist], Quer
y: [SELECT * FROM petdefaultspells]
Sql query failed due to [Table 'character.clientaddons' doesn't exist], Query: [
SELECT * FROM clientaddons]
Sql query failed due to [Table 'character.creature_spawns' doesn't exist], Query
: [SELECT MAX(id) FROM creature_spawns]
Query failed: SELECT * FROM clientaddons
Sql query failed due to [Table 'character.gameobject_spawns' doesn't exist], Que
ry: [SELECT MAX(id) FROM gameobject_spawns]
01:07 N ObjectMgr:Sql query failed due to [Table 'character.npc_monstersay' does
n't exist], Query: [SELECT * FROM npc_monstersay]
Sql query failed due to [Table 'character.weather' doesn't exist], Query: [SELEC
T zoneId,high_chance,high_type,med_chance,med_type,low_chance,low_type FROM weat
her]
 HighGuid(CORPSE) = 0
01:07 N Sql query failed due to [Table 'character.reputation_creature_onkill' do
esn't exist], Query: [SELECT * FROM reputation_creature_onkill]
ObjectMgr: 0 groups loaded.
01:07 N Sql query failed due to [Table 'character.ai_agents' doesn't exist], Que
ry: [SELECT * FROM ai_agents]
Sql query failed due to [Table 'character.itempetfood' doesn't exist], Query: [S
ELECT * FROM itempetfood ORDER BY entry]
ObjectMgr: HighGuid(PLAYER) = 0
01:07 N ObjectMgr: 0 reputation modifiers on reputation_creature_onkill.
01:07 N ObjectMgr:Sql query failed due to [Table 'character.reputation_faction_o
nkill' doesn't exist], Query: [SELECT * FROM reputation_faction_onkill]
 6659 spell skills loaded.
01:07 N Sql query failed due to [Table 'character.creature_quest_starter' doesn'
t exist], Query: [SELECT * FROM creature_quest_starter]
Sql query failed due to [Table 'character.creature_quest_finisher' doesn't exist
], Query: [SELECT * FROM creature_quest_finisher]
Sql query failed due to [Table 'character.gameobject_quest_starter' doesn't exis
t], Query: [SELECT * FROM gameobject_quest_starter]
Sql query failed due to [Table 'character.gameobject_quest_finisher' doesn't exi
st], Query: [SELECT * FROM gameobject_quest_finisher]
Sql query failed due to [Table 'character.gameobject_quest_item_binding' doesn't
 exist], Query: [SELECT * FROM gameobject_quest_item_binding]
ObjectMgr:Sql query failed due to [Table 'character.gameobject_quest_pickup_bind
ing' doesn't exist], Query: [SELECT * FROM gameobject_quest_pickup_binding]
 Sql query failed due to [Table 'character.npc_gossip_textid' doesn't exist], Qu
ery: [SELECT * FROM npc_gossip_textid]
HighGuid(GAMEOBJ) = 0
01:07 N ObjectMgr: 0 reputation modifiers on reputation_faction_onkill.
01:07 N ObjectMgr:Sql query failed due to [Table 'character.reputation_instance_
onkill' doesn't exist], Query: [SELECT * FROM reputation_instance_onkill]
 0 NPC Gossip TextIds loaded.
01:07 N ObjectMgr: HighGuid(UNIT) = 0
01:07 N ObjectMgr: HighGuid(ITEM) = 0
01:07 N ObjectMgr: HighGuid(CONTAINER) = 0
01:07 N ObjectMgr: HighGuid(GROUP) = 0
01:07 N ObjectMgr: HighGuid(CHARTER) = 0
01:07 N ObjectMgr: HighGuid(GUILD) = 0
Sql query failed due to [Table 'character.creature_names_localized' doesn't exis
t], Query: [SELECT DISTINCT language_code FROM creature_names_localized]
Sql query failed due to [Table 'character.gameobject_names_localized' doesn't ex
ist], Query: [SELECT DISTINCT language_code FROM gameobject_names_localized]
Sql query failed due to [Table 'character.items_localized' doesn't exist], Query
: [SELECT DISTINCT language_code FROM items_localized]
Sql query failed due to [Table 'character.quests_localized' doesn't exist], Quer
y: [SELECT DISTINCT language_code FROM quests_localized]
Sql query failed due to [Table 'character.npc_text_localized' doesn't exist], Qu
ery: [SELECT DISTINCT language_code FROM npc_text_localized]
Sql query failed due to [Table 'character.itempages_localized' doesn't exist], Q
uery: [SELECT DISTINCT language_code FROM itempages_localized]
Sql query failed due to [Table 'character.creature_names_localized' doesn't exis
t], Query: [SELECT * FROM creature_names_localized]
Sql query failed due to [Table 'character.gameobject_names_localized' doesn't ex
ist], Query: [SELECT * FROM gameobject_names_localized]
Sql query failed due to [Table 'character.items_localized' doesn't exist], Query
: [SELECT * FROM items_localized]
Sql query failed due to [Table 'character.quests_localized' doesn't exist], Quer
y: [SELECT * FROM quests_localized]
Sql query failed due to [Table 'character.npc_text_localized' doesn't exist], Qu
ery: [SELECT * FROM npc_text_localized]
Sql query failed due to [Table 'character.itempages_localized' doesn't exist], Q
uery: [SELECT * FROM itempages_localized]

..\..\src\game\LocalizationMgr.cpp:347 ASSERTION FAILED:
  source_language_id>0&&dest_language_id>0
Sql query failed due to [Table 'character.command_overrides' doesn't exist], Que
ry: [SELECT * FROM command_overrides]
Sql query failed due to [Table 'character.banned_phrases' doesn't exist], Query:
 [SELECT * FROM banned_phrases]

01:07 N World: Database loaded in 1515ms.

Sql query failed due to [Table 'character.creature_formations' doesn't exist], Q
uery: [SELECT * FROM creature_formations]
Sql query failed due to [Table 'character.creature_spawns' doesn't exist], Query
: [SELECT DISTINCT Map FROM creature_spawns]
01:07 N InstanceMgr: Deleting Expired Instances...
01:07 N InstanceMgr: Loading 0 saved instances.

01:07 N World: Processing 32833 spells...
Sql query failed due to [Table 'character.spell_proc_data' doesn't exist], Query
: [SELECT * FROM spell_proc_data]
01:07 N World: Starting Transport System...
01:07 N ObjectMgr: Loading Transports...
Sql query failed due to [Table 'character.transport_data' doesn't exist], Query:
 [SELECT * FROM transport_data]
01:07 N World: Starting Auction System...
01:07 N AuctionMgr: Loading Auction Houses...
Sql query failed due to [Table 'character.auctionhouse' doesn't exist], Query: [
SELECT DISTINCT `group` FROM auctionhouse]
Sql query failed due to [Table 'character.auctionhouse' doesn't exist], Query: [
SELECT creature_entry, `group` FROM auctionhouse]
01:07 N World: Backgrounding loot loading...
01:07 N BattlegroundManager: Starting...
Sql query failed due to [Table 'character.item_randomprop_groups' doesn't exist]
, Query: [SELECT * FROM item_randomprop_groups]
01:07 N Sql query failed due to [Table 'character.item_randomsuffix_groups' does
n't exist], Query: [SELECT * FROM item_randomsuffix_groups]
DayWatcherThread:Sql query failed due to [Table 'character.creatureloot' doesn't
 exist], Query: [SELECT * FROM creatureloot ORDER BY entryid ASC]
Starting network subsystem...
IOCP: Spawning 2 worker threads.
Started.
Loading External Script Libraries...

Sql query failed due to [Table 'character.objectloot' doesn't exist], Query: [SE
LECT * FROM objectloot ORDER BY entryid ASC]
Sql query failed due to [Table 'character.skinningloot' doesn't exist], Query: [
SELECT * FROM skinningloot ORDER BY entryid ASC]
Sql query failed due to [Table 'character.fishingloot' doesn't exist], Query: [S
ELECT * FROM fishingloot ORDER BY entryid ASC]
  GossipScripts.dll : 0x025F0000 : v3.0 : loaded.
Sql query failed due to [Table 'character.itemloot' doesn't exist], Query: [SELE
CT * FROM itemloot ORDER BY entryid ASC]
Sql query failed due to [Table 'character.prospectingloot' doesn't exist], Query
: [SELECT * FROM prospectingloot ORDER BY entryid ASC]
  InstanceScripts.dll : 0x02750000 : v3.0 : loaded.
Sql query failed due to [Table 'character.pickpocketingloot' doesn't exist], Que
ry: [SELECT * FROM pickpocketingloot ORDER BY entryid ASC]
  ServerStatusPlugin.dll : 0x04B20000 : v3.0 : loaded.
  SpellHandlers.dll : 0x027D0000 : v3.0 : loaded.

Loaded 4 external libraries.


Server is ready for connections. Startup time: 1828ms

01:07 N LogonCommClient: Attempting to connect to logon server...
01:07 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`...
01:07 N LogonCommClient: Authenticating...
01:07 N LogonCommClient: Authentication succeeded.
01:07 N LogonCommClient: Registering Realms...
01:07 N LogonCommClient: Realm `Giggle Glade` registered as realm 1.
01:07 N LogonCommClient: Logonserver latency is 0ms.

Sorry i know its a big post but i want to get it fixed :]

[Shadei]

reinstall NCDB again and make sure you config files are directed toward the database you install it to.

[DrCuddles]

IM AN IDIOT
in the ascent.conf file i iput as my worlddatabase 'character' not 'world'
what a tard...

woo it works great now, thanks for all yoor help man!

[Shadei]

hehe np, if you have anymore questions that's what this place is here for ;)