Arcane-Fire UR1 MaNGOS (2.4.3)

IF YOU HAVE NOT ALREADY APPLIED ARCANE-FIRE THEN DO NOT!!! MAJOR BUG AND WE ARE WORKING OUR BUTTS OFF TO MAKE A STABLE VERSION!!!

Here it is! The Reaper-X customized MaNGOS release UR1 "Arcane-Fire" is now available. UR1 is also a raw copy and if you look below you will find that we will be adding updates as we go! A changelog and what revs Arcane-Fire uses! Also note that Arcane-Fire no longer supports PSDB (sorry for anyone who uses it)!

—MaNGOS Rev. 6382
———UDB Rev. 358
-ScriptDev2 Rev. 512
——–ACID Rev. 18

Empty cave in Silithus spawned

Added missing rares in map1 (Kalimdor)

Various improvements in Outland spawns

LOTS of waypoints

Minions that are summoned by ACID r18 deleted

Random changes everywhere

More 2.4.x items. again…

Arena Season 4 vendors populated

Template scripts for SD2 up to 502 and ACID up to 0.0.2 r18

Plus lots more fixes!

UR1 DOESN’T HAVE MANY OF THE EXTRA FEATURES THAT WE SAID WE WOULD LIKE TO HAVE SO BELOW THIS WILL BE LINKS TO NEW FEATURES AND UPDATES THAT WE DIDN’T HAVE TIME TO ADD IN THE FULL RELEASE (WHEN DOWNLOADING THE UPDATES PLEASE READ THE DARN README FILES):

none
None
None

SET UP:

Step 1: Install MySQL using the guide here >>> (MySQL Installation and Configuration)

NOTE: You can get either MySQL 5.0 or 5.1 (It does NOT matter).

Step 2: Download Reaper-X UR1 "Arcane-Fire" (below are list of mirror to file). File have been compressed! These have been updated with UDB Fix 1!

1. No Download

2. No Download

3. No Download

GM COMMAND LIST:

Updated GM Command List for this version

Fresh Install:
Important Note : Fresh installation will overwrite your database!!!

Pictures in this guide have NOT been updated (sorry again)!!!

1. Make sure you have MySQL (5.0 or 5.1) installed and configured correctly on your computer.

2. Extracting Maps, DBC and VMaps from your World of Warcraft installation

YOU NEED TO EXTRACT FOR 2.4.3!!!

3. Run the Arcane-Fire.bat inside the Fresh Install folder, and you’ll see something like below image for an example, and then you just need to write the full path to your mysql installation directory (where mysql.exe and mysqldump.exe can be found)

MySQL BIN Image

4. Selection Option 1 by pressing “1&Prime on the keyboard and pressing enter.
Note: This will wipe out any previous versions of WoW you have in your database.

Mangos batch menu

6. After finished with all of the above process, all you have to do now is just open the realmlist.wtf file in your World of Warcraft installation directory (the default location can be found at C:\Program Files\World of Warcraft) using Notepad, Wordpad, or your favorite text editor and then …

Replace :

set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com

With :

set realmlist 127.0.0.1

and then save it and close realmlist.wtf File.

7. Now you just need to run mangosd.exe and realmd.exe from your mangos directory and then the next step would be creating your own username with your desired password for your own WoW server account as shown on below image followed by typing setgm to give yourself a GM level account

Mangos EXE

By the way, if you can’t see what you should type inside the mangosd window from the above image, actually you just need to type :

create username password

to create the account

setgm username 1-3

to give yourself GM Access at certain level (3 is the highest level and should only be used on your account while normal player is 0)

8. Finally if you have Burning Crusade client installed and want to be able to create Burning Crusade specific character, all you have to do is just type:

setbc username 1

to enable burning crusade expansion for your account !

Upgrading from 6245 Release:

1. Make sure to RE-EXTRACT your DBC’s, Maps, and VMaps, because this release now supports 2.4.3!

2. Go into your WoW Reaper Server Directory, and open Reaper-X-MaNGOS.

3. Open the Folder called “Upgrade” and run Upgrade-2-UR1.bat.

4. Next type in the directory to the Bin Folder where your mysql.exe and mysqldump.exe files are located. (Default is C:\Program Files\MySQL\MySQL Server 5.0\bin)

5. Then make sure that you are upgrading from the latest previous version or else you WILL corrupt your database and possibly lose your character data.

Updated Batch image

Guide on how to Edit Mangos.Conf
Thanks for the Mangosd.conf edit guide Jeremy!

First off make sure that you have your MySQL running before doing anything.

You need to go back into the reaper folder and run the batch file called Arcane-Fire.bat, there is an option there to setup your LAN or IP for use, This new batch file does correctly setup your DB to the IP you enter in this batch file. Once you’ve done that, if you haven’t gone back in to edit the config files in your reaper folder mentioned above, you need to do that, there is a section in there with this.

# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = “C:\Reaper-X\data”

This is an example of what it may look like. You need to change this to the path where you put your data folder with the maps, vmaps, and dbc’s.

Second, …

# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database – use named pipes at Windows
# Named pipes: mySQL required adding “enable-named-pipe” to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database – use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “127.0.0.1;3306;root;PASSWORD;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;root;PASSWORD;mangos”
CharacterDatabaseInfo = “127.0.0.1;3306;root;PASSWORD;characters”

Above, you need to change the ROOT;PASSWORD to your root DB name, likey it’s just root, and YOUR database (DB) password (you should know this)

YOU DO NOT CHANGE THE IP’S!!! Here is a guide to make your server public! Public Setup Guide!

Next open scriptdev2.conf and realmd.conf and edit the info for them to connect to your database as well.

Comments Navigation 1 2 3 ... 5 Next »

Striike said Jul 27, 2008 at 4:31 am

@Summonence+Colt45
Great, thanks for the quick fix guys.

Link to this comment Reply to this comment
Summonence said Jul 27, 2008 at 4:22 am

Ok, tested out the new version of the repack im currently building with the new line on the mysql full install, and it working for characters now. I’m looking into the other errors now.

Link to this comment Reply to this comment
Summonence said Jul 27, 2008 at 4:18 am

Alright, there is a problem when creating a new database, Characters. on the Characters table. there is a missing factor of, `dungeon_difficulty` tinyint(3) unsigned NOT NULL default ‘0′,
Though, i am going to have Colt45 update the repack. So no others will have that issue.

Link to this comment Reply to this comment
Summonence said Jul 27, 2008 at 4:15 am

@ Napredator

Hey btw, mine is approx 1.79-1.8 Gb in size. You should be almost done now.

Link to this comment Reply to this comment
Summonence said Jul 27, 2008 at 4:12 am

Yes im currently talking with Colt45 about the database when creating characters issue. I might have found a fix. Working on that.

Link to this comment Reply to this comment
bakaslayer said Jul 27, 2008 at 4:08 am

my ad.exe keeps crashing any ideas??

Link to this comment Reply to this comment
Soulslave said Jul 27, 2008 at 4:07 am

Okay i think i am having the same problem as a few of you other guys. I have successfully created the server, got it up, and am able to log into it. When however it try to create a character it does not show up in the character list. I this this may be the problem…

2008-07-26 15:55:58 SQL: SELECT mapid, resettime FROM instance_reset
2008-07-26 15:55:58 query ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: DELETE FROM instance USING instance LEFT JOIN instance_reset ON mapid = map WHERE (instance.resettime ‘0′) OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < ‘1217105758′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.group_instance’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’249′,’4182106432′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’269′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’309′,’2137088320′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’409′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’469′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’509′,’2137088320′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’531′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’532′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’533′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’534′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’540′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’542′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’543′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’544′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’545′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’546′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’547′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’548′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’550′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’552′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’553′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’554′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’555′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’556′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’557′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’558′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’560′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’564′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’565′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’568′,’2137088320′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’580′,’1932157248′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES (’585′,’1839124800′)
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 15:55:58 SQL: DELETE FROM instance USING instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.group_instance’ doesn’t exist
2008-07-26 15:55:58 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
2008-07-26 15:55:58 SQL ERROR: Table ‘characters.group_instance’ doesn’t exist
2008-07-26 15:55:58 Spell 33280 listed in `spell_proc_event` does not exist
2008-07-26 15:55:58 Spell 35092 listed in `spell_proc_event` does not exist
2008-07-26 15:55:58 Spell 35093 listed in `spell_proc_event` does not exist
2008-07-26 15:55:58 Spell 35094 listed in `spell_proc_event` does not exist
2008-07-26 15:56:01 Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
2008-07-26 15:56:01 Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
2008-07-26 15:56:01 Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
2008-07-26 15:56:01 Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
2008-07-26 15:56:01 Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
2008-07-26 15:56:01 Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
2008-07-26 15:56:01 Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
2008-07-26 16:00:49 SQL: SELECT mapid, resettime FROM instance_reset
2008-07-26 16:00:49 query ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: DELETE FROM instance USING instance LEFT JOIN instance_reset ON mapid = map WHERE (instance.resettime ‘0′) OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < ‘1217106049′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.group_instance’ doesn’t exist
2008-07-26 16:00:49 SQL: DELETE FROM instance USING instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.group_instance’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’249′,’4182106432′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’269′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’309′,’2137088320′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’409′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’469′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’509′,’2137088320′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’531′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’532′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’533′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’534′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’540′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’542′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’543′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’544′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’545′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’546′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’547′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’548′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’550′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’552′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’553′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’554′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’555′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’556′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’557′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’558′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’560′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’564′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’565′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’568′,’2137088320′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’580′,’1932157248′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES (’585′,’1839124800′)
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.instance_reset’ doesn’t exist
2008-07-26 16:00:49 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
2008-07-26 16:00:49 SQL ERROR: Table ‘characters.group_instance’ doesn’t exist
2008-07-26 16:00:49 Spell 33280 listed in `spell_proc_event` does not exist
2008-07-26 16:00:49 Spell 35092 listed in `spell_proc_event` does not exist
2008-07-26 16:00:49 Spell 35093 listed in `spell_proc_event` does not exist
2008-07-26 16:00:49 Spell 35094 listed in `spell_proc_event` does not exist
2008-07-26 16:00:52 Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
2008-07-26 16:00:52 Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
2008-07-26 16:00:52 Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
2008-07-26 16:00:52 Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
2008-07-26 16:00:52 Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
2008-07-26 16:00:52 Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
2008-07-26 16:00:52 Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
2008-07-26 16:01:25 Spell (id: 51798) have SPELL_EFFECT_QUEST_COMPLETE for quest 11122 , but quest not have flag QUEST_MANGOS_FLAGS_EXPLORATION_OR_EVENT. Quest flags must be fixed, quest modified to enable objective.
2008-07-26 16:01:26 Spell 16824 listed in `spell_affect` does not exist
2008-07-26 16:01:26 Spell 16824 listed in `spell_affect` does not exist
2008-07-26 16:01:30 SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, isRaid, difficulty, leaderGuid FROM groups
2008-07-26 16:01:30 query ERROR: Unknown column ‘difficulty’ in ‘field list’
2008-07-26 16:03:30 SQL: INSERT INTO characters (guid,account,name,race,class,map, dungeon_difficulty, position_x, position_y, position_z, orientation, data, taximask, online, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, gmstate, stable_slots, at_login, zone, death_expire_time, taxi_path) VALUES (2, 5, ‘Waricild’, 1, 1, 0, 0, -8949.95, -132.493, 83.5312, 0, ‘2 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 100 0 60 0 1000 0 100 0 1 1 16777473 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1156415488 1157234688 1157234688 1053240066 1069547520 49 49 0 1084527177 1086624329 0 0 0 0 0 0 0 0 0 1065353216 0 0 0 0 23 20 22 20 20 0 0 0 0 0 0 0 0 0 0 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 10240 29 0 0 11 0 0 1076138569 1080332873 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 151128835 33554440 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2362 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 1073741824 0 0 0 0 5 1073741824 7 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 1073741824 11 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 13 1073741824 15 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 400 26 65537 0 95 327681 0 44 327681 0 54 327681 0 43 327681 0 162 327681 0 98 19661100 0 413 65537 0 414 65537 0 415 65537 0 433 65537 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1083892040 0 1084227584 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4294967295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 70 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ‘, ‘2 0 0 8 0 0 0 0 ‘, 0, 0, 0, 0, 0, 1217106210, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 0, ” )
2008-07-26 16:03:30 SQL ERROR: Unknown column ‘dungeon_difficulty’ in ‘field list’

I have tryed everything I could think of to try to fix this but at this point I no longer think it is an error on my part.

Link to this comment Reply to this comment
bakaslayer said Jul 27, 2008 at 4:04 am

help

Link to this comment Reply to this comment
Napredator said Jul 27, 2008 at 3:58 am

I was wondering if someone could tell me the size of the vmaps folder in its present form, so far im still waiting for the excract_vmaps thing to finish and so far the vmaps folder is 1.54GB’s, i was wondering if someone could tell me how big it is so i know how much longer i have to wait :)

Link to this comment Reply to this comment
bakaslayer said Jul 27, 2008 at 3:33 am

there used to be 2 different extractors for the dbc one for the uk and one for the us game versions is the new ad.exe going to work with my uk game client???

Link to this comment Reply to this comment
Summonence said Jul 27, 2008 at 3:29 am

First of all, give a bit of time for someone to respond, and to be polite don’t post the same lien multiple times.

Secondly, custom zones, like ones that aren’t in Blizzards servers? I don’t believe there is custom zones. and a Custom world? dude, are you programming your own worlds, with maps that work with wow? Im not. NPC, there is way you can create your own npc’s.

Link to this comment Reply to this comment
bakaslayer said Jul 27, 2008 at 3:29 am

will the ad.exe work with the uk version of the game and why iis this release so much smaller than previous??

Link to this comment Reply to this comment
wow-romania.ro said Jul 27, 2008 at 3:27 am

Does this have custom zones for leveling, custom world, npc, etc?

Does this have custom zones for leveling, custom world, npc, etc?
Does this have custom zones for leveling, custom world, npc, etc?

Link to this comment Reply to this comment
Summonence said Jul 27, 2008 at 3:23 am

ad.exe is mixed with the maps extractor now. If you remember from the last repack, they announced they merged them.

Link to this comment Reply to this comment
Sythus said Jul 27, 2008 at 3:05 am

Well i already updated to 6245.
Can I not run the upgrade?
Could I do a fresh install and then restore my characters without issue?

Link to this comment Reply to this comment
Napredator said Jul 27, 2008 at 3:04 am

Where is the DBC extractor?

Link to this comment Reply to this comment
treebeard said Jul 27, 2008 at 3:02 am

@Striike
Same error in my log.

Link to this comment Reply to this comment
Striike said Jul 27, 2008 at 2:57 am

2008-07-26 15:56:11 ERROR:SQL: INSERT INTO characters (guid,account,name,race,class,map, dungeon_difficulty, position_x, position_y, position_z,….

Copy from the server.log

Don’t know if this helps anyone.

Link to this comment Reply to this comment
wow-romania.ro said Jul 27, 2008 at 2:53 am

Does this have custom zones for leveling, custom world, npc, etc?

Link to this comment Reply to this comment
Summonence said Jul 27, 2008 at 2:45 am

@ Ode

Go up and follow the instructions again. Your either not installing MySQL, to have a database, or you didn’t install the tables into the databases correctly, or your just not setting up your conf properly. But reading your posts. your lost when it comes to setting up conf.

Link to this comment Reply to this comment
Ode said Jul 27, 2008 at 2:29 am

My mysql command line client shows that its not using any database (!). The spot where the name of the database should be is empty. Could this be the problem? Can it be solved?

Link to this comment Reply to this comment
Ode said Jul 27, 2008 at 2:25 am

Thanks for the replies striike, i did that, replaced the passwords with correct ones but it still says access denied when trying in to database..

Link to this comment Reply to this comment
Striike said Jul 27, 2008 at 2:24 am

@Ode
The password you need to put in is the mySQL password you entered when you ran the mySQL config.

Link to this comment Reply to this comment
Striike said Jul 27, 2008 at 2:23 am

@Ode
Go to the folder where your MaNGOSD.exe is located, and open up mangosd.conf with notepad. Scan through the text, I think you’ll find it.

@treebeard, rikiller
Having the same problem getting a character to show up, in my case a new one. My MaNGOSD.exe displays: SQL ERROR: Unknown column ‘dungeon_difficulty’ in ‘field list’ CMSG_REALM_SPLIT.
Not sure if this error message is related to problem, but I’m hoping someone figures out how to fix this soon :)

Link to this comment Reply to this comment
tomb said Jul 27, 2008 at 2:20 am

i can’t enter the world, after build the character, what’s worry

Link to this comment Reply to this comment
Ode said Jul 27, 2008 at 2:18 am

I have no idea what you meant by those last 2 posts..

Is the database pw same as the pw i used when i installed mysql? And how do i determine my database?

Damn im helples

Link to this comment Reply to this comment
treebeard said Jul 27, 2008 at 2:13 am

Ode,
127.0.0.1;3306;root;;mangos

Link to this comment Reply to this comment
treebeard said Jul 27, 2008 at 2:12 am

is your password to the database realmd?

Link to this comment Reply to this comment
Ode said Jul 27, 2008 at 2:11 am

How can I change the password? I assume you mean mangos password or something like that? becouse when i start realmd it gives same error but password is realmd.

Link to this comment Reply to this comment
Striike said Jul 27, 2008 at 2:06 am

Fixed my problem, so for anyone that had this trouble, I had to copy the msvcr71.dll located in x:\program files\common files\Blizzard Entertainment\world of warcraft and paste it in the folder where MaNGOSD.exe is located.

Link to this comment Reply to this comment
Bigmarky said Jul 27, 2008 at 2:03 am

Ode, change the PASSWORD to your sql pw
(that should be a given)

Yup, looks like more then just me ran into that character problem – even if a create a new character – it doesnt show up and preimported aren’t showing up either

Link to this comment Reply to this comment
Ode said Jul 27, 2008 at 2:00 am

Oh yea sorry for double post, I used the fresh install.

Link to this comment Reply to this comment
Ode said Jul 27, 2008 at 2:00 am

Any idea what’s wrong? When i fire up my mangos.exe it says cannot connect to world database 127.0.0.1;3306;root;PASSWORD;mangos

Please mail me.

Thankfully
Ode

Link to this comment Reply to this comment
treebeard said Jul 27, 2008 at 1:56 am

Same here i am having this problem just installed arcane-fire extracted the DBCs Vmaps etc and i cannot create any characters/none there.

Link to this comment Reply to this comment
Rikiller said Jul 27, 2008 at 1:54 am

Interestingly enough, if you try to create a new character, it doesn’t show up either.

Link to this comment Reply to this comment
Rikiller said Jul 27, 2008 at 1:52 am

Argh, there is a problem. I ran the update from 6245, extracted the maps, dbc and vmaps.
Set my data dir, completed the necessary fields in the conf files…
I can connect but there are no characters there.
I checked the database, and the characters are still there, but they just don’t show up.
HELP PLZ!!

Link to this comment Reply to this comment
coz said Jul 27, 2008 at 1:45 am

Hey guys, i downloaded this but, when i go to extracct the data, vmaps and maps, some of the extraction tools are not included , can someone help me out on this>?

Link to this comment Reply to this comment
Striike said Jul 27, 2008 at 1:39 am

This application has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem.

Have tried re-installing, same message?

Link to this comment Reply to this comment
Bigmarky said Jul 27, 2008 at 1:33 am

nevermind the above comment, i just skipped it and it works, now just gotta remember how to import my characters (usernames are there just doesnt show the characters even though it says i have 10 made)

Link to this comment Reply to this comment
Bigmarky said Jul 27, 2008 at 1:14 am

hmm, when i run the vmaps it finished extracting but never ran the line

vmap_assembler.exe buildings vmaps splitConfig.txt

just stopped after extracting

i tried just running that byitself and its sitting there as well…

odd never had that problem the 10 other times i’ve installed mangos

Link to this comment Reply to this comment
tomb said Jul 27, 2008 at 1:04 am

did you get the “eyes of the beast” bug fix. i really want to try it

Link to this comment Reply to this comment
tomb said Jul 27, 2008 at 1:02 am

i gonna try this one, thanx man

Link to this comment Reply to this comment
Bigmarky said Jul 27, 2008 at 12:00 am

gonna d/l and try it out

Link to this comment Reply to this comment
Striike said Jul 26, 2008 at 11:23 pm

Fantastic, ty. Just curious, when you do the updates, will there be a new revision, or do I have to check this thread to see when to update?

Link to this comment Reply to this comment
Rikiller said Jul 26, 2008 at 11:01 pm

Superb

Link to this comment Reply to this comment
bakaslayer said Jul 26, 2008 at 10:49 pm

can i update from MaNGOS 6245 because this page says Upgrading from 5953

Link to this comment Reply to this comment
SR2 said Jul 26, 2008 at 10:48 pm

Upgrading from 5953 Release? The previous was 6245! Is that good?

Link to this comment Reply to this comment
Colt45 said Jul 26, 2008 at 10:42 pm

Oh I dont think I added this in the post but AH Bot rev 78 is included!

Link to this comment Reply to this comment
aequitus said Jul 26, 2008 at 10:32 pm

Hooray! Good work, fellas.

Link to this comment Reply to this comment
Colt45 said Jul 26, 2008 at 10:19 pm

FINALLY IM DONE!!! :P

Link to this comment Reply to this comment