nice thanks man, +rep
nice thanks man, +rep
So I just gave up for awhile and just played on my crappy outdated server :devillaugh:
Now that some time has past, I'll try something new
Is there a place that shows how to make a new server, from scratch, with your DB,
That a newb can set upand that I will still be able to transfer MY characters into? :bigbrain2::mwink:
I know....big question![]()
download Ascent 2.4-STABLE (from one of the topics on this forum)
download ncdb 0.2.3 (this is the WorldDB, also posted on this forum)
to transfer chars and accs... there are a few tables you have to copy into your new db... (the logonDB and CharDB)
then make sure config files are set up ok....
start up the server and have fun
grtz
note: if you dont know what tables to copy into your new DB well simple way to work is:
-> make a new DB with navicat (or some other program)
-> import the worldDB (ncdb 0.2.3)
-> open your old DB and check what tables your old DB has more then your new one and copy them to your new one
-> check if your logonDB or CharDB tables need updates or not!
The only thing I've worried about doing something like that is, I have seen repeatedly that if you are not knowledgeable about Emu's, don't use Ascent. It's why I still have my antrix server. Maybe it's time to take the plunge
Thanks![]()
hehheh, well, if you used Xephers server set-up page (which is gone now) and followed it but didn't totally understand it, then it's not quite that easy
not that I'm a total noob, I do have some computer knowledge, but I'm lacking in a lot of server knowledge.......
Anyway, I DL'd Ascent core (from one of your threads) rev 2409 and unRar'd it in a folder by itself. Then (and this may have been a mistake) I DL'd NCDB 2, 2.1, 2.2, & 2.3. Using Navicat, I made a new DB called "NCDB" and then used the "tool.bat" inside each and did "full" or "update" where applicable, Modified the ".conf" as best I understood. Started my server like I always do but used the Ascent "logonserver.exe" and "ascent.exe". all starts up accept Ascent, I get that stupid windows "ascent encountered a problem" alarm. So I figured I had to copy all the stuff from my antrix folder (dbc, maps, .dll's, etc.), so I did, Now all this crap flies up the screen on the ascent window, then it says "authentication Failed" like 3 times, and then I get that stupid windows alarm again.
So, did I do something really stupid? did I give enough info for you to tell? lol
.
.
.
Last edited by psychobandit; 12-28-2007 at 01:22 AM.
I think that's why I don't "get" some of this stuff...... there is no flow to the info inside the .conf files, It's just thrown in. and there is so much, I miss stuff.
So, I FINALLY found the 2 places to change the remote logon password and that seems to fix the authentication fail, BUT, Ascent still crashes and gives the windows alarm. FYI, incase I had fried my ascent core by using those .dll's, I un-.rar'd the original ascent into a folder and pasted my .conf to it, and then copied my dbc & maps folders only to it and that's all before doing the above and it changed nothing.
I'm gonna add in here what my logonserver & ascent does, maybe it will help
logonserver:
Code:Ascent 2.4-STABLE r2409/Release-Win32 (X86) :: Logon Server ============================================================================== The key combination <Ctrl-C> will safely shut down the server at any time. 18:32 N System: Initializing Random Number Generators... 18:32 N Config: Loading Config Files... 18:32 S Config: >> logonserver.conf 18:32 N ThreadMgr: Starting... 18:32 D ThreadPool: Startup, launched 5 threads. 18:32 D ThreadPool: Thread 2608 entered the free pool. 18:32 D ThreadPool: Thread 1424 entered the free pool. 18:32 D ThreadPool: Thread 3244 entered the free pool. 18:32 D ThreadPool: Thread 4044 entered the free pool. 18:32 D ThreadPool: Thread 180 entered the free pool. 18:32 D ThreadPool: IntegrityCheck: Perfect! 18:32 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********) 18:32 D ThreadPool: Thread 2608 left the thread pool. 18:32 D ThreadPool: Thread 2608 is now executing task at 0x003958E0. 18:32 N AccountMgr: Starting... 18:32 N InfoCore: Starting... 18:32 N PatchMgr: Loading Patches... 18:32 N AccountMgr: Precaching accounts... Sql query failed due to [Unknown column 'forceLanguage' in 'field list'], Query: [SELECT acct, login, password, gm, flags, banned, forceLanguage FROM accounts] 18:32 N AccountMgr: 0 accounts are loaded and ready. 18:32 D ThreadPool: Thread 1424 left the thread pool. 18:32 D ThreadPool: Thread 1424 is now executing task at 0x00395C10. 18:32 D ThreadPool: Thread 3244 left the thread pool. 18:32 D ThreadPool: Thread 3244 is now executing task at 0x00395C48. IOCP: Spawning 1 worker threads. 18:32 D ThreadPool: Thread 4044 left the thread pool. 18:32 D ThreadPool: Thread 4044 is now executing task at 0x00395CE0. 18:32 D ThreadPool: Thread 180 left the thread pool. 18:32 D ThreadPool: Thread 180 is now executing task at 0x00398220. 18:32 D ThreadPool: Thread 884 is now executing task at 0x003989C0. Hooking signals...
ascent:
Code:!!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc !!! possible invalid format in file DBC/ItemExtendedCost.dbc (us: 14, them: 13) !!! Read buffer overflow in DBC reading of file DBC/ItemExtendedCost.dbc 18:33 N DBC: Loading DBC/Talent.dbc. 18:33 N DBC: Loading DBC/SpellCastTimes.dbc. 18:33 N DBC: Loading DBC/SpellRadius.dbc. 18:33 N DBC: Loading DBC/SpellRange.dbc. 18:33 N DBC: Loading DBC/SpellDuration.dbc. 18:33 N DBC: Loading DBC/ItemRandomProperties.dbc. 18:33 N DBC: Loading DBC/AreaTable.dbc. 18:33 N DBC: Loading DBC/FactionTemplate.dbc. 18:33 N DBC: Loading DBC/Faction.dbc. 18:33 N DBC: Loading DBC/TaxiNodes.dbc. 18:33 N DBC: Loading DBC/TaxiPath.dbc. 18:33 N DBC: Loading DBC/TaxiPathNode.dbc. 18:33 N DBC: Loading DBC/CreatureSpellData.dbc. 18:33 N DBC: Loading DBC/CreatureFamily.dbc. 18:33 N DBC: Loading DBC/ChrRaces.dbc. 18:33 N DBC: Loading DBC/ChrClasses.dbc. 18:33 N DBC: Loading DBC/Map.dbc. 18:33 N DBC: Loading DBC/AuctionHouse.dbc. 18:33 N DBC: Loading DBC/ItemRandomSuffix.dbc. 18:33 N World: Beginning parallel server startup with 2 threads. 18:33 N ObjectMgr: 12 players loaded. 18:33 N Storage: 12352 entries loaded from table gameobject_names. 18:33 N Storage: 13832 entries loaded from table creature_proto. 18:33 N ObjectMgr: 52 player create infos loaded. 18:33 N ObjectMgr: 52 level up informations generated. 18:33 N Storage: 710 entries loaded from table areatriggers. 18:33 N Storage: 833 entries loaded from table itempages. 18:33 N Storage: 384 entries loaded from table graveyards. 18:33 N Storage: 59 entries loaded from table teleport_coords. 18:33 N Storage: 328 entries loaded from table fishing. 18:33 N Storage: 2966 entries loaded from table npc_text. 18:33 N Storage: 22 entries loaded from table zoneguards. 18:33 N ObjectMgr: 1 disabled spells. 18:33 N ObjectMgr: 40723 waypoints cached. 18:33 N ObjectMgr: 107 totem spells loaded. 18:33 N ObjectMgr: 6558 spell skills loaded. 18:33 N ObjectMgr: 397 spell fixes loaded. 18:33 N ObjectMgr: 674 trainers loaded. 18:33 N ObjectMgr: 1385 vendors loaded. 18:33 N ObjectMgr: 69 spell threats loaded. 18:33 N ObjectMgr: HighGuid(CORPSE) = 5 18:33 N ObjectMgr: HighGuid(PLAYER) = 16 18:33 N ObjectMgr: HighGuid(GAMEOBJ) = 35902 18:33 N ObjectMgr: HighGuid(UNIT) = 85660 18:33 N ObjectMgr: HighGuid(ITEM) = 4294967295 18:33 N ObjectMgr: HighGuid(CONTAINER) = 4294967295 18:33 N ObjectMgr: HighGuid(GROUP) = 0 18:33 N ObjectMgr: HighGuid(CHARTER) = 0 18:33 N ObjectMgr: 981 reputation modifiers on reputation_creature_onkill. 18:33 N ObjectMgr: 0 reputation modifiers on reputation_faction_onkill. 18:33 N ObjectMgr: 223 monster say events loaded. 18:33 N WeatherMgr: Loaded weather information for 51 zones. 18:33 N ObjectMgr: 0 groups loaded. 18:33 N ObjectMgr: 43 spell overrides loaded. 18:33 N ObjectMgr: 89 NPC Gossip TextIds loaded. Sql query failed due to [Table 'ncdb.creature_names_localized' doesn't exist], Q uery: [SELECT DISTINCT language_code FROM creature_names_localized] Sql query failed due to [Table 'ncdb.gameobject_names_localized' doesn't exist], Query: [SELECT DISTINCT language_code FROM gameobject_names_localized] Sql query failed due to [Table 'ncdb.items_localized' doesn't exist], Query: [SE LECT DISTINCT language_code FROM items_localized] Sql query failed due to [Table 'ncdb.quests_localized' doesn't exist], Query: [S ELECT DISTINCT language_code FROM quests_localized] Sql query failed due to [Table 'ncdb.npc_text_localized' doesn't exist], Query: [SELECT DISTINCT language_code FROM npc_text_localized] Sql query failed due to [Table 'ncdb.itempages_localized' doesn't exist], Query: [SELECT DISTINCT language_code FROM itempages_localized] 18:33 N World: Database loaded in 11953ms. Sql query failed due to [Unknown column 'id' in 'field list'], Query: [SELECT MA X(id) FROM instances] 18:33 N InstanceMgr: Deleting Expired Instances... Sql query failed due to [Unknown column 'expiration' in 'where clause'], Query: [DELETE FROM instances WHERE expiration <= 1198809202] 18:33 N InstanceMgr: Loading 0 saved instances. 18:33 N World: Processing 31365 spells... 18:33 N World: Starting Transport System... 18:33 N ObjectMgr: Loading Transports... 18:33 N World: Starting Auction System... 18:33 N AuctionMgr: Loading Auction Houses... Sql query failed due to [Unknown column 'group' in 'field list'], Query: [SELECT DISTINCT `group` FROM auctionhouse] Sql query failed due to [Unknown column 'creature_entry' in 'field list'], Query : [SELECT creature_entry, `group` FROM auctionhouse] 18:33 N World: Backgrounding loot loading... 18:33 N BattlegroundManager: Starting... 18:33 N DayWatcherThread: Started. Starting network subsystem... IOCP: Spawning 1 worker threads. Loading External Script Libraries... GossipScripts.dll : 0x003D0000 : v3.0 : loaded. InstanceScripts.dll : 0x02770000 : v3.0 : loaded. ServerStatusPlugin.dll : 0x06940000 : v3.0 : Sql query failed due to [Table 'n cdb.playeritems_insert_queue' doesn't exist], Query: [LOCK TABLES `playeritems_i nsert_queue` WRITE] Sql query failed due to [Table 'ncdb.playeritems_insert_queue' doesn't exist], Q uery: [SELECT * FROM playeritems_insert_queue] Sql query failed due to [Table 'ncdb.characters_insert_queue' doesn't exist], Qu ery: [LOCK TABLES `characters_insert_queue` WRITE] Sql query failed due to [Table 'ncdb.characters_insert_queue' doesn't exist], Qu ery: [SELECT * FROM characters_insert_queue] loaded. SpellHandlers.dll : 0x027E0000 : v3.0 : loaded. Loaded 4 external libraries. Server is ready for connections. Startup time: 12594ms 18:33 N LogonCommClient: Attempting to connect to logon server... 18:33 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`... 18:33 N LogonCommClient: Authenticating... 18:33 N LogonCommClient: Authentication succeeded. 18:33 N LogonCommClient: Registering Realms... 18:33 N LogonCommClient: Realm `Aldoroth` registered as realm 1. 18:33 N LogonCommClient: Build character mapping in 0ms. (3) 18:33 N LogonCommClient: Logonserver latency is 15ms.
Edit: o.k., I've been messing around trying different stuff. I totally deleted the DB and then just ran the ncdb 2.3 full and added my accounts/characters/etc. to it. Ascent did not crash, but it says my account info (logon on Wow) was wrong and wouldn't let me in the game.
I tried separating the accounts into there own DB (and yes changed .conf) and got the same thing. so I went again and created a DB from ncdb 2 and updated to 2.3 but still kept accounts separate and now ascent is crashing again??? close to give up stage again....:confused:
.
.
.
Last edited by psychobandit; 12-28-2007 at 01:19 AM.
I'm using the ascent rev 2409 core you told me to DL, as for bad DBC files, do you mean the Milestone.rar's I got from here or do you mean the folder I have called "dbc" 'cause it's the one that I have used with antrix w/o problems? oh, and I set max client to 8000 which is above my current version.
(see, I knew this wasn't gonna be "just that easy" like everyone says :hehehe: :runaway: )
.
.
.
O.K., I'm adding this about 1 hour later... I have been doing lots of reading and have decided to start over from scratch using stuff I DL'd from your "[Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)" thread, so I'll let you know if that changes anything. I did notice while I was reading that thread, that xbobohobox and Cloraphil had the exact problem I'm having now and looks like they didn't find or receive a solution. At least not in that thread.
.
.
.
Last edited by psychobandit; 12-28-2007 at 11:10 PM.
K, it's been 8 hours since I wrote the above. Since then I have pretty much destroyed my old server and then using stuff from your thread that I noted above (ascent core and other stuff).
I now have Wow updated to vers. 2.3, a 2.3 dbc folder, new maps made from my 2.3 Wow folder (transfered to the ascent folder of course). I deleted my antrix Navicat connection and made a new one for Ascent.
Ascent.exe doesn't crash but I had solved that awhile ago.....
What IS still happening is, Wow says my account name or password is not correct!
Now, I have tried using my old account & character .sql that I had made, I also tried usind your "clean account.sql" and them making a new login with it. I STILL get that message!!!
Here is what shows up in ascent.exe (I highlighted what areas are F'd up)
Code:Ascent 2.5-TRUNK r2422/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. 03:33 S Rnd: Initialized Random Number Generators. 03:33 D ThreadPool: Startup, launched 5 threads. 03:33 D ThreadPool: Thread 3116 entered the free pool. 03:33 D ThreadPool: Thread 2496 entered the free pool. 03:33 D ThreadPool: Thread 1336 entered the free pool. 03:33 D ThreadPool: Thread 2928 entered the free pool. 03:33 D ThreadPool: Thread 2896 entered the free pool. 03:33 D ThreadPool: IntegrityCheck: Perfect! 03:33 N Config: Loading Config Files... 03:33 S Config: >> ascent.conf 03:33 S Config: >> realms.conf 03:33 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********) 03:33 D ThreadPool: Thread 3116 left the thread pool. 03:33 D ThreadPool: Thread 3116 is now executing task at 0x00F75D58. 03:33 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********) 03:33 D ThreadPool: Thread 2496 left the thread pool. 03:33 D ThreadPool: Thread 2496 is now executing task at 0x00F75EB0. 03:33 N World: Loading DBC files... 03:33 N DBC: Loading DBC/ItemSet.dbc. 03:33 N DBC: Loading DBC/Lock.dbc. 03:33 N DBC: Loading DBC/EmotesText.dbc. 03:33 N DBC: Loading DBC/SkillLineAbility.dbc. 03:33 N DBC: Loading DBC/SpellItemEnchantment.dbc. 03:33 N DBC: Loading DBC/GemProperties.dbc. 03:33 N DBC: Loading DBC/SkillLine.dbc. 03:33 N DBC: Loading DBC/Spell.dbc. 03:33 N DBC: Loading DBC/ItemExtendedCost.dbc. 03:33 N DBC: Loading DBC/Talent.dbc. 03:33 N DBC: Loading DBC/SpellCastTimes.dbc. 03:33 N DBC: Loading DBC/SpellRadius.dbc. 03:33 N DBC: Loading DBC/SpellRange.dbc. 03:33 N DBC: Loading DBC/SpellDuration.dbc. 03:33 N DBC: Loading DBC/ItemRandomProperties.dbc. 03:33 N DBC: Loading DBC/AreaTable.dbc. 03:33 N DBC: Loading DBC/FactionTemplate.dbc. 03:33 N DBC: Loading DBC/Faction.dbc. 03:33 N DBC: Loading DBC/TaxiNodes.dbc. 03:33 N DBC: Loading DBC/TaxiPath.dbc. 03:33 N DBC: Loading DBC/TaxiPathNode.dbc. 03:33 N DBC: Loading DBC/CreatureSpellData.dbc. 03:33 N DBC: Loading DBC/CreatureFamily.dbc. 03:33 N DBC: Loading DBC/ChrRaces.dbc. 03:33 N DBC: Loading DBC/ChrClasses.dbc. 03:33 N DBC: Loading DBC/Map.dbc. 03:33 N DBC: Loading DBC/AuctionHouse.dbc. 03:33 N DBC: Loading DBC/ItemRandomSuffix.dbc. 03:33 N World: Beginning parallel server startup with 2 threads. 03:33 N ObjectMgr: 0 players loaded. 03:33 N Storage: 22217 entries loaded from table items. 03:33 N Storage: 14107 entries loaded from table creature_names. 03:33 N ObjectMgr: 52 player create infos loaded. 03:33 N ObjectMgr: 52 level up informations generated. 03:33 N Storage: 12412 entries loaded from table gameobject_names. 03:33 N Storage: 710 entries loaded from table areatriggers. 03:33 N Storage: 13818 entries loaded from table creature_proto. 03:33 N Storage: 912 entries loaded from table itempages. 03:33 N Storage: 384 entries loaded from table graveyards. 03:33 N Storage: 5173 entries loaded from table quests. 03:33 N Storage: 59 entries loaded from table teleport_coords. 03:33 N Storage: 328 entries loaded from table fishing. 03:33 N Storage: 2987 entries loaded from table npc_text. 03:33 N Storage: 61 entries loaded from table worldmap_info. 03:33 N Storage: 22 entries loaded from table zoneguards. 03:33 N ObjectMgr: 0 disabled spells. 03:33 N ObjectMgr: 40639 waypoints cached. 03:33 N ObjectMgr: 678 trainers loaded. 03:33 N ObjectMgr: 107 totem spells loaded. 03:33 N ObjectMgr: 6659 spell skills loaded. Sql query failed due to [Table 'ascent.spells112' doesn't exist], Query: [SELECT * FROM spells112] 03:33 N ObjectMgr: 43 spell overrides loaded. 03:33 N ObjectMgr: 1386 vendors loaded. 03:33 N ObjectMgr: 69 spell threats loaded. 03:33 N ObjectMgr: 981 reputation modifiers on reputation_creature_onkill. 03:33 N ObjectMgr: 0 reputation modifiers on reputation_faction_onkill. 03:33 N ObjectMgr: HighGuid(CORPSE) = 0 03:33 N ObjectMgr: HighGuid(PLAYER) = 0 03:33 N ObjectMgr: HighGuid(GAMEOBJ) = 33874 03:33 N ObjectMgr: 223 monster say events loaded. 03:33 N ObjectMgr: HighGuid(UNIT) = 85672 03:33 N WeatherMgr: Loaded weather information for 51 zones. 03:33 N ObjectMgr: 0 groups loaded. 03:33 N ObjectMgr: HighGuid(ITEM) = 0 03:33 N ObjectMgr: HighGuid(CONTAINER) = 0 03:33 N ObjectMgr: HighGuid(GROUP) = 0 03:33 N ObjectMgr: HighGuid(CHARTER) = 0 03:33 N ObjectMgr: 89 NPC Gossip TextIds loaded. 03:33 N World: Database loaded in 7266ms. Sql query failed due to [Unknown column 'id' in 'field list'], Query: [SELECT MA X(id) FROM instances] 03:33 N Map: 22515 creatures / 12468 gameobjects on map 0 cached. 03:33 N Map: 25223 creatures / 8327 gameobjects on map 530 cached. 03:33 N InstanceMgr: Creating static instance 1 on map 530. 03:33 N InstanceMgr: Creating static instance 2 on map 0. 03:33 N Map: 22 creatures / 51 gameobjects on map 369 cached. 03:33 N Map: 90 creatures / 2 gameobjects on map 34 cached. 03:33 N InstanceMgr: Creating static instance 3 on map 369. 03:33 N Map: 5 creatures / 44 gameobjects on map 249 cached. 03:33 N Map: 502 creatures / 373 gameobjects on map 229 cached. 03:33 N Map: 25397 creatures / 10455 gameobjects on map 1 cached. 03:33 N InstanceMgr: Creating static instance 4 on map 1. 03:33 N Map: 306 creatures / 103 gameobjects on map 469 cached. 03:33 N Map: 222 creatures / 25 gameobjects on map 48 cached. 03:33 N Map: 1065 creatures / 432 gameobjects on map 230 cached. 03:33 N Map: 211 creatures / 26 gameobjects on map 36 cached. 03:33 N Map: 811 creatures / 90 gameobjects on map 429 cached. 03:33 N Map: 404 creatures / 89 gameobjects on map 90 cached. 03:33 N Map: 611 creatures / 24 gameobjects on map 349 cached. 03:33 N Map: 182 creatures / 3 gameobjects on map 409 cached. 03:33 N Map: 272 creatures / 64 gameobjects on map 129 cached. 03:33 N Map: 206 creatures / 47 gameobjects on map 47 cached. 03:33 N Map: 329 creatures / 90 gameobjects on map 189 cached. 03:33 N Map: 404 creatures / 62 gameobjects on map 289 cached. 03:33 N Map: 143 creatures / 32 gameobjects on map 33 cached. 03:33 N Map: 377 creatures / 163 gameobjects on map 329 cached. 03:33 N Map: 261 creatures / 180 gameobjects on map 70 cached. 03:33 N Map: 356 creatures / 74 gameobjects on map 109 cached. 03:33 N Map: 260 creatures / 55 gameobjects on map 209 cached. 03:33 N Map: 313 creatures / 76 gameobjects on map 43 cached. 03:33 N Map: 724 creatures / 125 gameobjects on map 309 cached. 03:33 N Map: 143 creatures / 11 gameobjects on map 389 cached. 03:33 N Map: 1152 creatures / 136 gameobjects on map 533 cached. 03:33 N Map: 13 creatures / 20 gameobjects on map 449 cached. 03:33 N InstanceMgr: Creating static instance 5 on map 449. 03:33 N Map: 13 creatures / 0 gameobjects on map 450 cached. 03:33 N InstanceMgr: Creating static instance 6 on map 450. 03:33 N Map: 156 creatures / 0 gameobjects on map 547 cached. 03:33 N Map: 98 creatures / 16 gameobjects on map 554 cached. 03:33 N Map: 295 creatures / 1 gameobjects on map 564 cached. 03:33 N Map: 242 creatures / 0 gameobjects on map 534 cached. 03:33 N Map: 73 creatures / 0 gameobjects on map 543 cached. 03:33 N Map: 9 creatures / 1 gameobjects on map 557 cached. 03:33 N Map: 333 creatures / 171 gameobjects on map 560 cached. 03:33 N Map: 9 creatures / 0 gameobjects on map 30 cached. 03:33 N Map: 363 creatures / 2 gameobjects on map 532 cached. 03:33 N Map: 9 creatures / 0 gameobjects on map 529 cached. 03:33 N Map: 3 creatures / 0 gameobjects on map 562 cached. 03:33 N Map: 181 creatures / 15 gameobjects on map 553 cached. 03:33 N Map: 175 creatures / 15 gameobjects on map 545 cached. 03:33 N Map: 65 creatures / 2 gameobjects on map 269 cached. 03:33 N Map: 175 creatures / 0 gameobjects on map 550 cached. 03:33 N Map: 95 creatures / 0 gameobjects on map 540 cached. 03:33 N Map: 94 creatures / 0 gameobjects on map 542 cached. 03:33 N Map: 151 creatures / 1 gameobjects on map 555 cached. 03:33 N Map: 60 creatures / 1 gameobjects on map 552 cached. 03:33 N Map: 22 creatures / 0 gameobjects on map 565 cached. 03:33 N Map: 17 creatures / 0 gameobjects on map 544 cached. 03:33 N Map: 78 creatures / 2 gameobjects on map 548 cached. 03:33 N Map: 113 creatures / 0 gameobjects on map 531 cached. 03:33 N Map: 146 creatures / 0 gameobjects on map 509 cached. 03:33 N Map: 92 creatures / 0 gameobjects on map 556 cached. 03:33 N Map: 36 creatures / 0 gameobjects on map 558 cached. 03:33 N Map: 5 creatures / 0 gameobjects on map 546 cached. 03:33 N Map: 0 creatures / 0 gameobjects on map 35 cached. 03:33 N Map: 0 creatures / 0 gameobjects on map 169 cached. 03:33 N InstanceMgr: Creating static instance 7 on map 169. 03:33 N Map: 0 creatures / 0 gameobjects on map 489 cached. 03:33 N Map: 0 creatures / 0 gameobjects on map 568 cached. 03:33 N InstanceMgr: Deleting Expired Instances... Sql query failed due to [Unknown column 'expiration' in 'where clause'], Query: [DELETE FROM instances WHERE expiration <= 1198928016] 03:33 N InstanceMgr: Loading 0 saved instances. 03:33 N World: Processing 32833 spells... 03:33 N World: Starting Transport System... 03:33 N ObjectMgr: Loading Transports... 03:33 N World: Starting Auction System... 03:33 N AuctionMgr: Loading Auction Houses... 03:33 N World: Backgrounding loot loading... 03:33 N BattlegroundManager: Starting... 03:33 N DayWatcherThread: Started. Sql query failed due to [Table 'ascent.playeritems_insert_queue' doesn't exist], Query: [LOCK TABLES `playeritems_insert_queue` WRITE] Sql query failed due to [Table 'ascent.playeritems_insert_queue' doesn't exist], Query: [SELECT * FROM playeritems_insert_queue] Sql query failed due to [Table 'ascent.characters_insert_queue' doesn't exist], Query: [LOCK TABLES `characters_insert_queue` WRITE] Sql query failed due to [Table 'ascent.characters_insert_queue' doesn't exist], Query: [SELECT * FROM characters_insert_queue] Starting network subsystem... IOCP: Spawning 1 worker threads. Loading External Script Libraries... GossipScripts.dll : 0x003E0000 : v3.0 : loaded. InstanceScripts.dll : 0x02790000 : v3.0 : loaded. ServerStatusPlugin.dll : 0x0EEE0000 : v3.0 : loaded. SpellHandlers.dll : 0x0F270000 : v3.0 : loaded. Loaded 4 external libraries. Server is ready for connections. Startup time: 12735ms 03:33 N LogonCommClient: Attempting to connect to logon server... 03:33 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`... 03:33 N LogonCommClient: Authenticating... 03:33 N LogonCommClient: Authentication succeeded. 03:33 N LogonCommClient: Registering Realms... 03:33 N LogonCommClient: Realm `Aldoroth` registered as realm 1. 03:33 N LogonCommClient: Logonserver latency is 0ms.
And Logonserver
Also, separate issue, I have DL'd the "Milestone 0.2.3.rar" 4 times. every one of them I tried the update from 2.2 to 2.3, and every time I got this alarmCode:Ascent 2.5-TRUNK r2422/Release-Win32 (X86) :: Logon Server ============================================================================== The key combination <Ctrl-C> will safely shut down the server at any time. 03:33 N System: Initializing Random Number Generators... 03:33 N Config: Loading Config Files... 03:33 S Config: >> logonserver.conf 03:33 N ThreadMgr: Starting... 03:33 D ThreadPool: Thread 788 entered the free pool. 03:33 D ThreadPool: Startup, launched 5 threads. 03:33 D ThreadPool: Thread 136 entered the free pool. 03:33 D ThreadPool: Thread 2476 entered the free pool. 03:33 D ThreadPool: Thread 2212 entered the free pool. 03:33 D ThreadPool: Thread 3148 entered the free pool. 03:33 D ThreadPool: IntegrityCheck: Perfect! 03:33 N Database: Connecting to MySQL on 127.0.0.1 with (root : *********) 03:33 D ThreadPool: Thread 788 left the thread pool. 03:33 D ThreadPool: Thread 788 is now executing task at 0x00395798. 03:33 N AccountMgr: Starting... 03:33 N InfoCore: Starting... 03:33 N PatchMgr: Loading Patches... 03:33 N AccountMgr: Precaching accounts... Sql query failed due to [Unknown column 'forceLanguage' in 'field list'], Query: [SELECT acct, login, password, gm, flags, banned, forceLanguage FROM accounts] 03:33 N AccountMgr: 0 accounts are loaded and ready. 03:33 D ThreadPool: Thread 2476 left the thread pool. 03:33 D ThreadPool: Thread 2476 is now executing task at 0x00395AC8. 03:33 D ThreadPool: Thread 3148 left the thread pool. 03:33 D ThreadPool: Thread 3148 is now executing task at 0x00395B00. IOCP: Spawning 1 worker threads. 03:33 D ThreadPool: Thread 2212 left the thread pool. 03:33 D ThreadPool: Thread 2212 is now executing task at 0x00395B98. 03:33 D ThreadPool: Thread 136 left the thread pool. 03:33 D ThreadPool: Thread 136 is now executing task at 0x00398180. 03:33 D ThreadPool: Thread 1232 is now executing task at 0x00398920. Hooking signals... Authentication request from 127.0.0.1, result OK. Key: 8E575BB6C2CBD81F533FC3C1186F170814EC3C2B Registering realm `Aldoroth` under ID 1. 03:35 D ThreadPool: IntegrityCheck: (gobbled < 0) Spawning 6 threads. 03:35 D ThreadPool: Thread 3708 entered the free pool. 03:35 D ThreadPool: Thread 1536 entered the free pool. 03:35 D ThreadPool: Thread 3620 entered the free pool. 03:35 D ThreadPool: Thread 3712 entered the free pool. 03:35 D ThreadPool: Thread 1528 entered the free pool. 03:35 D ThreadPool: Thread 3192 entered the free pool. 03:37 D ThreadPool: Killing 1 excess threads. 03:37 D ThreadPool: IntegrityCheck: (gobbled > 5) Killing 1 threads. 03:37 D ThreadPool: Thread 3620 exiting. 03:39 D ThreadPool: IntegrityCheck: Perfect! 03:41 D ThreadPool: IntegrityCheck: Perfect! 03:43 D ThreadPool: IntegrityCheck: Perfect! Sql query failed due to [Unknown column 'forceLanguage' in 'field list'], Query: [SELECT acct, login, password, gm, flags, banned, forceLanguage FROM accounts] 03:44 D ThreadPool: IntegrityCheck: Perfect! 03:46 D ThreadPool: IntegrityCheck: Perfect! 03:48 D ThreadPool: IntegrityCheck: Perfect!
so I just have to do a full db from 2.3.....Code:[Importing] World database update Started... ERROR 1054 (42S22) at line 1313: Unknown column 'ffa_loot' in 'field list' [Importing] Updated Finished! Press any key to continue . . .
By the way, it may not sound like it, but I really appreciate the help your giving
.
.
.
Last edited by psychobandit; 12-29-2007 at 06:41 PM.
the ncdb update feature is kinda ****ed up i guess :-/
but your other problem... ascent console is full of errors about missing tables...are u sure you have worldDB + CharDB + LogonDB ? and alse if that did not work yet did you check for sql updates for the core?
grtz
ps: srr that it took that long to reply... its verry busy here with holidays :-/ i havent touched my computer for hours xD
Well, I have spent countless hoursreading and trying to figure out why the damn thing wouldn't work 'cause I couldn't even get it to work with a CLEAN char & logon DB which I mentioned in my last post.
So, what I found out, the Clean account.sql inside the milestone .rar and the one you have on the "[Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)" thread are not compatible with ascent 2409 & Wow 2.3.0 which is why I could never log in. they are not only missing some of the stuff needed (like account data, banned names, etc) but, for example, if you open them in navicat, the accounts has an extra column, the characters has 2 extra. plus they don't have the same names so totally incompatible. What I finally did was found a "repack" on mmowned (one of mafiaboy's, I'm trying to find it as I type this) and in it, there is a accounts sql that is 2.3 compatible. I finally could log in. now, using navicat, I figured out how to import some of my old account stuff. I have lost all my inventories and it filled my bags with keys for some reason. Oh, and it f'd up all my armor so I can just give myself gold and buy all new stuff, and they can't be deleted (the keys,not sure what to do about that yet). Also, all my professions have reverted to level 2 but I still have all the crap. so, anyway, I CAN GET IN but it's messed up.
well I can't find the repack now but in it was a file called "ascent9.sql" for the world DB and "character.sql" for a clean account, I used both and got absolutely no errors on load. What I did to get MY info into the clean account.sql was use the "import/export" tool in Navicat and did a lot of guessing.
This is getting longer than I expected so I'm gonna stop nowhope some of that info is useful to you or someone else, and thanks again for trying to help me with all this. I gave you my one and only rep point
And it's fine that you took awhile to answer, it forced me to learn on my own
Edit: I found it (where I got the good .sql files) it is from Mafiaboy's Repack V3.rar
.
.
.
Last edited by psychobandit; 12-31-2007 at 05:26 AM.
good... precompiled bins topic needs an update i know... but i had dam much problems... i talked to kandyman already so expect news soon
always keep in mind that posts on here are not always up to date... newest stuff and structures you can always find on the ascent and ncdb SVN
grtz![]()