Main Website RSS FeedCurrent Article

Reaper MaNGOS 5953 with ScriptDev 414|Server Compatible With 2.4.2 (UDB ONLY!)

Hello Everyone! Here is another one of my releases for the Reaper-X-MaNGOS-WoW Developement Project.  In this release I have looked through my previous bugs/errors and have cleaned them out and I am almost positive that they all have been resolved. So if you have any questions comments or concerns please leave us a comment, when you do myself and the community will be glad to assist you!

Updated in this Revision:

  • Completely re-done fishing loot template.
  • Fishing base skill level table added
  • Lots of Black Temple updates
  • Loot added for creatures that are mineable and gatherable
  • Rewards added for quests with quest flags|512 (Quests like Teron Gorefiend I am!)
  • Many quest fixes in general
  • 175 fishing holes added (like school of fish) with loot
  • Instance loot tables updated:
    • Zul’Farrak
    • Sunken Temple
    • Black Rock Depths
    • Dire Maul
    • Black Rock Spire 
  • World drop loot tables for levels 1-34 created (SIGNIFICANT decrease in creature_loot_template size again. All world drop tables are now created. Loot table size before world tables ~950000 rows — after 284594 rows. ~7mB instead of ~22mB)
  • Some 2.4.2 related item changes
  • L70ETC spawns / event included in the DB (still need the ACID script from the ACID team)
  • Fresh Installer Fixed!
  • Map/DBC Extractors Fixed!
  • ACID Included (Means Extra NPC’s and Such Have Been Scripted)
  • MaNGOSD.exe Errors Should Be Fixed!
  • Authentication Bug Should Be Fixed!
  • Vendors/GM Island Vendors Should Work Again if you Enable them by Going Into the Reaper-X-Mangos.bat File.
  • NO MORE EXE’s! I have decided to keep them in Batch format due to complaints about Errors/Trojans.

Shattered Sun Soldiers

REQUIREMENTS:

1. MySQL Database and the Guide on how to Install MySQL

2. World of Warcraft Client version 2.4.2

3. Updated DBC’s, VMAP’s, and MAPS Updated for 2.4.2!
DBC’s are already included as part of this release! Also if you already have the 2.4.2 DBC’s, Maps, and VMaps then there is no reason to extract them again.

4. Reaper-Mangos Server :
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | File Beam
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Rapidshare
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Mega Upload
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Media Fire

Update:
Davtex from www.blitz.sk have uploaded vmaps and maps extracted from WoW 2.4.2 so to those who have problem perhaps can try downloading the extracted maps and vmaps files by Davtex ;)

2.4.2 Maps:

  1. http://rapidshare.com/files/120427182/maps.part01.rar
  2. http://rapidshare.com/files/120427405/maps.part02.rar
  3. http://rapidshare.com/files/120427402/maps.part03.rar

Vmaps from WoW 2.4.2:

  1. http://rapidshare.com/files/120495428/vmaps.part01.rar
  2. http://rapidshare.com/files/120495485/vmaps.part02.rar
  3. http://rapidshare.com/files/120495478/vmaps.part03.rar
  4. http://rapidshare.com/files/120495532/vmaps.part04.rar
  5. http://rapidshare.com/files/120495474/vmaps.part05.rar
  6. http://rapidshare.com/files/120495501/vmaps.part06.rar
  7. http://rapidshare.com/files/120495246/vmaps.part07.rar

Thanks to Davtex for uploading the maps and vmaps files

Custom Vendors Pack

http://filebeam.com/ba76aee3d934e0ab9d7e2f7c4d40452a

Credits to Firane for creating the Custom Vendors Pack

DBC and Maps Extractor:

Just in case the included ad.exe (map extractor) and dbc extractor isn’t working for you (like you keep getting message about maps or dbc file is not compatible), you can try using this one:

DBC and Map Extractor (131KB)

That archive just contain only one file (ad.exe) … and all you have to do is just put it into your WoW installation directory (where wow.exe and launcher.exe can be found) … and delete maps and dbc folder there if exist and then run the new ad.exe … and it’ll extract the maps and dbc files automatically (the output will be in maps and dbc directory)

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

1. First you’ll need to install MySQL

2. Extracting Maps, DBC and VMaps from your World of Warcraft installation
(You can safely ignore the Patch-2, or any not found xxx-2 message)–This only happens if your extracting from patch 2.4.0

3. Run the reaper-x-mangos.bat inside the reaper-x-mangos 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 Input Directory

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.

Jared ReaperMangos Version of 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

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 :)

Optional :
If you want to change the server name into something else, you can use the reaper-x-mangos.bat to adjust it :)

Upgrading from 5953 Release:

1. Re-extract vmaps, maps and dbc because this version no longer supports the old World of Warcraft 2.3.3 installation and only supports the new 2.4.2 (YOU MAY SKIP RE-EXTRACTING IF YOUR DBC’S, MAPS, AND VMAPS ARE ALREADY FROM A 2.4.2 CLIENT!)

2. Go into your WoW Reaper Server Directory, and open reaper-eazy-mangos. Next I recommend opening the batch file and backing up your character data. This is optional though.

3. Open the Folder called “Upgrade” and run reaper-x-upgrade.bat.

4. Next type in the directory to the Bin Folder where your mysql.exe and mysqldump.exe files are located.

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.
Upgrade Warning

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 (C:\Reaper-X-Easy-MaNGOS\reaper-eazy-mangos)
And run the batch file called reaper-x-mangos, 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 waht 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 MANGO;MANGOS to your root DB name, likey it’s just root, and YOUR batabase (DB) password (you should know this)

YOU DO NOT CHANGE THE IP’S here or in the realmd file, ONLY THROUGH THAT BATCH FILE, i mentioned above. (that file does it for you)

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

Hope you enjoy this release if you have any questions feel free to post them as a comment below!

RSS Feed for This Post762 Comment(s)

  1. 1
    Anderek | May 26, 2008 at 11:09 / 11:09 AM | Links to this comments | Reply

    Yay first =D, cant wait for the links

  2. 2
    Viktor | May 26, 2008 at 11:11 / 11:11 AM | Links to this comments | Reply

    The only thing your latest needed was s4 and kil'jaeden loots but good job in upgrading :p

  3. 3
    Oatman | May 26, 2008 at 11:13 / 11:13 AM | Links to this comments | Reply

    #Anderek

    Yep they are on their way!

    #Viktor

    Yea those are in there yet I believe but they will be in there in a future release for sure. I mainly released this so early because of so many errors and complaints in the previous release.

  4. 4
    Anderek | May 26, 2008 at 11:26 / 11:26 AM | Links to this comments | Reply

    Also not sure if you know this but there are no mobs in the sunwell raid, i was also having problems with more than one person getting inside of it.

  5. 5
    Oatman | May 26, 2008 at 11:39 / 11:39 AM | Links to this comments | Reply

    #Anderek

    Yea I am aware of that and there isn't any in this release either. Its more of a prep for when its ready.

  6. 6
    Oatman | May 26, 2008 at 11:43 / 11:43 AM | Links to this comments | Reply

    OK LINKS UPDATED!
    5953 IS NOW RELEASED!

    ENJOY!

  7. 7
    Reggie | May 26, 2008 at 13:02 / 1:02 PM | Links to this comments | Reply

    Thank you so much for releasing the rev 5953. how to transfer the old Mangos rev 3462's database to the new Mangos rev 5472 or higher? Please , help me!

  8. 8
    madmax765 | May 26, 2008 at 13:26 / 1:26 PM | Links to this comments | Reply

    Sorry but i am still getting this same error when i try to install

    ERROR 1045 (28000):access denied for user '-p####'@'localhost' (using password: no/0
    mysql: option '-D' requires an argument

    Not sure why this repaer version gives me this trouble.. the other ones installed ok. Can you give me the order of the SQL.files and ill just import them

  9. 9
    madmax765 | May 26, 2008 at 13:31 / 1:31 PM | Links to this comments | Reply

    ok i got it figure out... what is different from this version and old ones is. Like where it ask what data base you like to use (MaNGOS) . I used to just hit enter it would use default with out me halfing to type in anything. Now its not like that. You got to type it in

  10. 10
    Viktor (in school lol) | May 26, 2008 at 13:33 / 1:33 PM | Links to this comments | Reply

    I tried yesterday to add Brutal gladiator and the new Guardian parts myself but it didnt work, got some wrong bla bla at row 1 ... :<

  11. 11
    sicx | May 26, 2008 at 13:39 / 1:39 PM | Links to this comments | Reply

    i cant extract any of the maps i can extract the data but not maps my wow client is 2.4.2 fully updated and everything and im trying to do a fresh install anyone got some help for me? im nto fully sure how to do this

  12. 12
    Viktor (in school lol) | May 26, 2008 at 13:42 / 1:42 PM | Links to this comments | Reply

    Follow the instructions carefully and it will work fine, a thing many people forget is to WAIT after vmaps_simple is finished (or not) until you get press any key to continue message.

  13. 13
    lauriene | May 26, 2008 at 13:59 / 1:59 PM | Links to this comments | Reply

    i took the realmd and mangosd config files from reaper 5472 and put them in 5931 and it loaded fine

  14. 14
    Johann | May 26, 2008 at 14:02 / 2:02 PM | Links to this comments | Reply

    Exactly - it will sort-of look like the vmaps process has finished, but it is quietly going through the split-maps config and making the vmaps folder after the buildings folder has been created. IT TAKES A LONG TIME. Go mow the lawn (or someone else's if you don't have one), then take a nap, then come back and it should be done.

  15. 15
    Dopey | May 26, 2008 at 14:03 / 2:03 PM | Links to this comments | Reply

    Maybe I'm doing something wrong but after doing a fresh install the GM island vendors aren't installing properly. It's telling me that the columns don't match. Any ideas?

  16. 16
    madmax765 | May 26, 2008 at 14:04 / 2:04 PM | Links to this comments | Reply

    Hello when i try to install the optional GM island vendors i get the fallowing error

    error 1136 (21s01) as line 24: column count doesn't match value at row 1

    and thats the best part i like... and clue of how to fix this ?

  17. 17
    Johann | May 26, 2008 at 14:08 / 2:08 PM | Links to this comments | Reply

    BTW Oatman,

    If you are looking for better instructions for PSDB, there is a new 'how-to' post on the PS website. Longer read but better detailed. Maybe this will help you to include PSDB in your future releases.

    Keep up the good work, you rock!

  18. 18
    Johann | May 26, 2008 at 14:08 / 2:08 PM | Links to this comments | Reply

    Ooops, forgot the link...

    http://projectsilvermoon.net/index.php?showtopic=12566

  19. 19
    Mod | May 26, 2008 at 14:20 / 2:20 PM | Links to this comments | Reply

    i'm getting "ERROR 1045 : Access denied for user 'root'@'localhost' "
    anyone know how to get over this error? i've tried installing older versions, but they give the same error.

    i'm using all the default database names

  20. 20
    Dopey | May 26, 2008 at 14:30 / 2:30 PM | Links to this comments | Reply

    That points to a wrong username or password to access the MySQL database

  21. 21
    lauriene | May 26, 2008 at 14:33 / 2:33 PM | Links to this comments | Reply

    did you manually add your password to the config files?

  22. 22
    sicx | May 26, 2008 at 14:53 / 2:53 PM | Links to this comments | Reply

    ok all is good i got everything working but the gm island vendors any ideas on how to get that installed..and does anyone have a guide ro anything to make this public so like if my friend across the country wants to connect to it he can style u know what i mean?

  23. 23
    lauriene | May 26, 2008 at 15:01 / 3:01 PM | Links to this comments | Reply

    i logged and restarted realmd and got this
    2008-05-26 00:42:54 ERROR:SQL: UPDATE realmlist SET color = 0, population = 0 WHERE id = '1'
    2008-05-26 00:42:54 ERROR:SQL ERROR: Table 'mangos.realmlist' doesn't exist
    2008-05-26 00:46:15 ERROR:SQL: UPDATE realmlist SET color = 2 WHERE id = '1'
    2008-05-26 00:46:15 ERROR:SQL ERROR: Table 'mangos.realmlist' doesn't exist
    2008-05-26 00:46:15 ERROR:SQL: UPDATE characters SET online = 0
    2008-05-26 00:46:15 ERROR:SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
    2008-05-26 00:46:15 ERROR:SQL ERROR: Table 'mangos.characters' doesn't exist
    2008-05-26 00:46:15 ERROR:SQL ERROR: Table 'mangos.account' doesn't exist
    2008-05-26 00:46:15 Halting process...

  24. 24
    Firane | May 26, 2008 at 15:09 / 3:09 PM | Links to this comments | Reply

    reaper gave us a PS only custom vendor and then didn't give us the PS DB. Ironic?
    Well I did a workaround and got a file to load into the UDB for custom vendors so ill put it up for DL on like filebeam in a sec.

  25. 25
    Beliah | May 26, 2008 at 15:21 / 3:21 PM | Links to this comments | Reply

    Madmax said:

    Hello when i try to install the optional GM island vendors i get the fallowing error

    error 1136 (21s01) as line 24: column count doesn’t match value at row 1.

    I'm having the same error, I think that happens becose in the new SQL Table called npc_vendor there is a new column called ExtendedCost, and the SQL structure of the vendors are build like the old one without that column, I just tried to add it with the mysql query browser steep by steep and just including in the row a ,0), more. And it worked. Lets look the example -->

    INSERT INTO `npc_vendor` VALUES (500000,16677,0,0),(500000,16679,0,0); -->[here i get the Column count dosen't match value count at row 1]

    Ok thats the old structure, i just changed that -->

    INSERT INTO `npc_vendor` VALUES (500000,16677,0,0,0) , (500000,16679,0,0,0); [WooT! it works now!!]

    If you see there is a ",0)" more, why that? becose in the new npc_vendor table there is one more column the ExtendedCost. I think that the solution is just to ad that ,0) in each of all the npc_vendor values but... I dont know if there is some "automatizated" way of doinf this... its kinda "hardcore" to do it with your own hand.

  26. 26
    suchness18 | May 26, 2008 at 15:52 / 3:52 PM | Links to this comments | Reply

    I just have to say you are the best! IMHO

  27. 27
    AddonWhore | May 26, 2008 at 16:30 / 4:30 PM | Links to this comments | Reply

    Hello Oatman,

    Thanks so much for the quick update, I didn't expect that!

    I have a small question though - only started playing with this private server stuff recently. My boyfriend and I have been working on a nice lightweight interface (we find it impossible to play with default Blizz interface - but I digress) since I got my server upgraded to 5951. So my question is, would upgrading it to 5953 mess all our work up? I know new WoW patches often mess stuff up, but I have no idea how these upgrades influence these things..

    Sorry for the silly question, I really have no clue. :) Thanks again!

  28. 28
    AddonWhore | May 26, 2008 at 16:31 / 4:31 PM | Links to this comments | Reply

    *5951 is meant to be 5931, oops!

  29. 29
    Greg | May 26, 2008 at 17:16 / 5:16 PM | Links to this comments | Reply

    Downloading now, and i had no issues with the previous release what i did was installed it fresh then ran the update and it worked flawlessly, except for the vendors and gmisland ofc

  30. 30
    Diesel | May 26, 2008 at 17:36 / 5:36 PM | Links to this comments | Reply

    Excellent work as always Oatman.

    Just one question.......Although the sunwell npc's are not spawned, is it still possible to spawn Kiljaeden's full loot table? The legendary bow looks awesome hehe.

    Oh and is there a replacement for ".addspw"?

    Many Thanks

    Diesel

  31. 31
    SGT Mac | May 26, 2008 at 17:40 / 5:40 PM | Links to this comments | Reply

    So, do I HAVE to extract the DBC's, maps, and VMaps or not? In the fresh installation instructions it says to do so, but in the note before is says not to. And if I don't have to, would you recommend still doing so? Thanks, and hoping for a speedy recovery for reaper-x.

  32. 32
    Phen | May 26, 2008 at 17:56 / 5:56 PM | Links to this comments | Reply

    Probably a really stupid question, but...

    It says "Upgrading from 5953 Release:"

    This IS the 5953 release, no? So do we upgrade from 5953 with this or from 5472?

    Just asking before I mess things up. ^^

  33. 33
    Wolfi | May 26, 2008 at 17:59 / 5:59 PM | Links to this comments | Reply

    I'm still having the problems and I cannot figure out how to change my MySQL user nameor fix it, it still says access denied @ 127.0.0.1 for username root, root is the username and I AM using the correct password =( idk

  34. 34
    Phen | May 26, 2008 at 17:59 / 5:59 PM | Links to this comments | Reply

    #SGT Mac

    As I understand it, you only have to extract them again if you did not already do it for the 2.4.2 version of WoW. (Like, if you installed the release a few days ago you would already have those folders in their correct version. They did not change.)

  35. 35
    Dudex | May 26, 2008 at 18:31 / 6:31 PM | Links to this comments | Reply

    I still get this error:

    'mysql' is not recognized as an internal or external command,
    operable program or batch file.
    'mysql' is not recognized as an internal or external command,
    operable program or batch file.
    'mysql' is not recognized as an internal or external command,
    operable program or batch file.

    Please wait it'll take a while to import the database

    Press any key to continue . . .

  36. 36
    SGT Mac | May 26, 2008 at 18:34 / 6:34 PM | Links to this comments | Reply

    #Phen

    Thanks for the rapid response. The last version I had was 2.3.3 before I was given a trial version of WoW , which got me even more addicted. I HOPE that the quests that were glitching on me before were fixed, I would really like to get my hands on Verdigan's Fist.

  37. 37
    IntErlOpr | May 26, 2008 at 19:05 / 7:05 PM | Links to this comments | Reply

    Just wanted to say cheers for the hard work Jared! It's much appreciated on my part, and I got this release working flawlessly first try.

  38. 38
    Phen | May 26, 2008 at 19:18 / 7:18 PM | Links to this comments | Reply

    #SGT Mac

    I find that if a quest is hoplessly glitched and I feel I spent enough time on trying to get it to work, I deserve the reward so I simply grant it to myself. ^^ Just a thought.

  39. 39
    SGT Mac | May 26, 2008 at 19:22 / 7:22 PM | Links to this comments | Reply

    I'm RATHER new to SQL so how do I "grant" myself the reward?

  40. 40
    Freze | May 26, 2008 at 19:24 / 7:24 PM | Links to this comments | Reply

    Error in item_template table, probably sql file format was updated (there should
    be 140 fields in sql). ?

    Thanks Freze

  41. 41
    Phen | May 26, 2008 at 19:34 / 7:34 PM | Links to this comments | Reply

    #SGT Mac

    You need to be on a GM account.

    If you have not done so yet, go to the mangosd.exe prompt and type "setgm YOURACCOUNTNAME 3" (without quotes and using the name of the account you use).

    Then, from inside the game you type ".lookup item Verdigan" If it comes up with more than one result you look through them for the fist, because you need the number given.
    Next you type ".additem HEREGOESTHENUMBER" substituting the number you just looked up.
    This should put the item into your inventory. :3

  42. 42
    Phen | May 26, 2008 at 20:21 / 8:21 PM | Links to this comments | Reply

    Upgrade successful. :D Thanks, Oatman.

  43. 43
    Evok3r | May 26, 2008 at 20:28 / 8:28 PM | Links to this comments | Reply

    Hi

    I cant get the gm island to work can anybody direct me to a tutorial.It says that there is an error at line 24.

    Plz Help

    Evok3r

  44. 44
    Evok3r | May 26, 2008 at 20:30 / 8:30 PM | Links to this comments | Reply

    Hi

    Can anybody help me plz. Im getting an error of the wow gm island stuff in line 24. Can anybody plz help.

    Thx

    Evok3r

  45. 45
    Ramon | May 26, 2008 at 21:27 / 9:27 PM | Links to this comments | Reply

    Hey Oatman.

    I did a fresh install and everything worked fine. But I still get the .0004331map error when starting Mangos. I have tried the new and the old ad.exe. The installation from reaper-x bat worked fine and MySQL and realmd are working fine also. What should I do?

  46. 46
    kriss | May 26, 2008 at 21:40 / 9:40 PM | Links to this comments | Reply

    oh no config editor :(

  47. 47
    Talux | May 26, 2008 at 21:40 / 9:40 PM | Links to this comments | Reply

    Could you reinstate the .fly command? pwease? :D

  48. 48
    Jas | May 26, 2008 at 21:57 / 9:57 PM | Links to this comments | Reply

    Hello there,

    First I would like to say Thank you for your help on this project, I have been a silent fan as well as user for a long time now.

    I currently have 5953 installed and working. Just with a few problems... First, I if I create a second character on the same account, the log in screen shows no characters. if I only have one toon, all is fine...

    Second, I cannot attack any of the mobs, anywhere. This means in instances, outside, pre bc as well as bc. Also I cannot interact with any npc's... no flight path guys, no bankers, no quest givers.. they are there, just cant select them or "talk" to them.

    lol other than that.. it seems to be running great:)

    Any help would be greatly appreciated:)

    Jas

  49. 49
    thyll | May 26, 2008 at 22:01 / 10:01 PM | Links to this comments | Reply

    hi, I have a problem:
    In fresh installation I have this error during the 1 step of the reaper-x-mangos...

    error 1045 (28000): acces denied for user '-p(password)@localhost using password: NO
    mysql: unknown option '-D
    mysql: unknown option '-D

    someone can help me?

  50. 50
    Jas | May 26, 2008 at 22:04 / 10:04 PM | Links to this comments | Reply

    thyll,

    It looks as though you do not have the correct values for your username and password when you run the reaper exe. The user (usually "root") and the password are what you setup when you installed MySQL.

  51. 51
    thyll | May 26, 2008 at 22:19 / 10:19 PM | Links to this comments | Reply

    thanks Jas...

    but I'm sure, the psw is the same used on the mysql installation and for the user I use the standard "root"...
    It's the first time that I have this problem...

    maybe I need a different version of the mysq? I use the mysql-5.0.51a..

  52. 52
    Jas | May 26, 2008 at 22:25 / 10:25 PM | Links to this comments | Reply

    Thyll,

    5.0 should work fine, but if you want to uninstall it and install the newest, 6.0 is out.

    http://dev.mysql.com/downloads/mysql/6.0.html

    Is this install of mySQL 5.0 what you were using previous to the 5953 fresh install of Reaper-X, or is it a fresh install of MySQL as well?

  53. 53
    Jas | May 26, 2008 at 22:29 / 10:29 PM | Links to this comments | Reply

    Just in case you do install 6.0, I grabbed Reapers guide for you:)

    http://www.reaper-x.com/2007/06/27/mysql-installation-and-configuration-setting-up-private-wow-server/

    Just follow this and it should work swell:)

  54. 54
    thyll | May 26, 2008 at 22:33 / 10:33 PM | Links to this comments | Reply

    It's a complete fresh installation, I have format lately my PC.

  55. 55
    Jas | May 26, 2008 at 22:41 / 10:41 PM | Links to this comments | Reply

    Do me a favor and open up your command prompt.. Start>Run, type in cmd, hit enter, then type:

    mysql -u root -p

    it should prompt for a password, if so, then enter your password. Then it should say your mySQL version, connection id and such..

    This just shows if your mysql is set up correctly :)

    If it doesnt, post your error here:)

  56. 56
    Lee BeZaro | May 26, 2008 at 22:42 / 10:42 PM | Links to this comments | Reply

    Maybe this is a simple problem. but howcome when I run mangosd.exe and realmd.exe it says it can't connect to the database?

    Is it someone simple I'm missing?

  57. 57
    thyll | May 26, 2008 at 22:44 / 10:44 PM | Links to this comments | Reply

    mysql is set up correctly and is running... the problem is the batch files...I think.

  58. 58
    Jas | May 26, 2008 at 22:47 / 10:47 PM | Links to this comments | Reply

    If mysql is running correctly and you are using the same user and password in the reaper exe as you did in the cmd prompt, then you might try redownloading the batchfiles and trying again, not sure:(

  59. 59
    Jas | May 26, 2008 at 22:48 / 10:48 PM | Links to this comments | Reply

    Lee BeZaro,

    Did you edit the mangosconfig, realmdconfig and scriptdevconfig files with your username and password for mysql? You have to do it manually now, since the config editor doesnt work in the batch file.

  60. 60
    thyll | May 26, 2008 at 22:49 / 10:49 PM | Links to this comments | Reply

    ok now I try this solution...
    thanks again.

  61. 61
    Jas | May 26, 2008 at 22:50 / 10:50 PM | Links to this comments | Reply

    no problem, hopefully this works for you:)

  62. 62
    OpticalMouse | May 26, 2008 at 22:56 / 10:56 PM | Links to this comments | Reply

    I updated my MaNGOS from 5472 to this version and None of the quests are working, everything else seems to be perfect though... thoughts?

    At first I was getting a 'gameobject' error, something about the SQL not having the right number of files or something. So I used that MaNGOS database someone posted.. it let me log in, but like I said quests aren't working.

    Also, my accounts transferred but the characters didn't. What do I do?

  63. 63
    FrostLord | May 26, 2008 at 23:00 / 11:00 PM | Links to this comments | Reply

    Ehi, Oatman, nice so fast a new release!
    There's a thing I'm wondering... the upgrade tool of 5953 version works only from previous 5951 release or from previous reaper-x release (5472) too ?

  64. 64
    thyll | May 26, 2008 at 23:01 / 11:01 PM | Links to this comments | Reply

    Thanks Jas!
    now it's ok!

    p.s. the mangos config (option 4) does'nt work?

  65. 65
    Jas | May 26, 2008 at 23:09 / 11:09 PM | Links to this comments | Reply

    Good to hear Thyll:) and no the config editor is not functuional, have to do it manualy.

    As for updating from 5472 straight to 5953, I am not sure. I updated from 5472 to 5951 to 5953.. If I am correct the previous updates only allowed upgrade from the most recent, but I could be wrong.

  66. 66
    Lee BeZaro | May 26, 2008 at 23:18 / 11:18 PM | Links to this comments | Reply

    Jas;

    You were right, I found the section on Editing and Mangosd.conf file/s and did what it said and it worked.

    Thanks for the help :D
    really appiciate it :)

  67. 67
    Jas | May 26, 2008 at 23:20 / 11:20 PM | Links to this comments | Reply

    Lee BeZaro,

    Great to hear:)

    Is it just my install that makes the npcs non-interactive? lol

  68. 68
    Phen | May 26, 2008 at 23:23 / 11:23 PM | Links to this comments | Reply

    #Talux

    The command ".flymode [on/off]" has been changed to ".gm fly [on/off]"

  69. 69
    jhyn | May 26, 2008 at 23:37 / 11:37 PM | Links to this comments | Reply

    hey...
    100% work...
    now i need add mob "gm command" please...
    tnqx ALL!

  70. 70
    Kyle | May 27, 2008 at 0:01 / 12:01 AM | Links to this comments | Reply

    hey im just updating now but does the .addspw command work in this release ???

  71. 71
    elderslayer | May 27, 2008 at 0:07 / 12:07 AM | Links to this comments | Reply

    I have a couple diffrent questions first of all my custom vendors are not thier (fresh install) was wondering how to get the vendors back?

    second of all im kinda struggling to set up a registration page any assistance on either or both topics would be appriciated.

    also looking for experienced gm's that can assist me with small fixes and above mentioned questions

    thanx in advance

  72. 72
    Jas | May 27, 2008 at 0:15 / 12:15 AM | Links to this comments | Reply

    Kyle,

    .addspw is now .npc add (creatureID)
    and .npc delete to delete it.

  73. 73
    Kyle | May 27, 2008 at 0:21 / 12:21 AM | Links to this comments | Reply

    ok ive used all the other realeases fin includiong 5931 but this one when i try to use the upgrade feature i get this

    'mysql' is not recognized as an internal or external command,
    operable program or batch file.
    'mysql' is not recognized as an internal or external command,
    operable program or batch file.
    'mysql' is not recognized as an internal or external command,
    operable program or batch file.
    'mysql' is not recognized as an internal or external command,
    operable program or batch file.
    'mysql' is not recognized as an internal or external command,
    operable program or batch file.

  74. 74
    Jas | May 27, 2008 at 0:24 / 12:24 AM | Links to this comments | Reply

    you happen to lose your MySQL somehow?

  75. 75
    Kyle | May 27, 2008 at 0:27 / 12:27 AM | Links to this comments | Reply

    nope still got it, im trying another link

  76. 76
    Kyle | May 27, 2008 at 0:30 / 12:30 AM | Links to this comments | Reply

    ok i got it to work

  77. 77
    Kyle | May 27, 2008 at 0:39 / 12:39 AM | Links to this comments | Reply

    ok HOW DO YOU FREAKING SPAWN NPC'S IN THIS RELEASE!!!!

  78. 78
    Jas | May 27, 2008 at 0:42 / 12:42 AM | Links to this comments | Reply

    .npc add "creatureid"

    so it will look like

    .npc add 16508

    (no clue what 16508 is, I just picked a random number)

    :)

  79. 79
    elderslayer | May 27, 2008 at 0:45 / 12:45 AM | Links to this comments | Reply

    I have a couple diffrent questions first of all my custom vendors are not thier (fresh install) was wondering how to get the vendors back?

    second of all im kinda struggling to set up a registration page any assistance on either or both topics would be appriciated.

    also looking for experienced gm’s that can assist me with small fixes and above mentioned questions these gms will get gm access to my server

    thanx in advance

  80. 80
    Brutus | May 27, 2008 at 1:13 / 1:13 AM | Links to this comments | Reply

    Hi Reaper,

    First of all good work, its nice to have a good private wow server.

    I have some questions.

    Im having some little problems in game:

    1 In an Instance all the mobs are comming through the walls to kills us. Normaly they don't ;)

    2 When i have a enchant on my weapon and its glowing. When i use that weapon after that the glow is gone. When i re attach my weapon it glows again. Do jou have any clue what this could be?

    I think its not my wow installation because some friends ho are also in my server have these problems to.

    Hope anyone could help me.

    Thanks allot Brutus

  81. 81
    Jas | May 27, 2008 at 1:13 / 1:13 AM | Links to this comments | Reply

    bah - still not allowing me to have more than one character per account, well I can make them, but as soon as I make a second one the log in screen shows no characters:(
    also still not able to interact with npc's and cannot target or attack mobs...

    I wiped my db and did a fresh install. Not sure what the problem is if anyone can help I would greatly appreciate it:)

  82. 82
    FrostFyre | May 27, 2008 at 1:18 / 1:18 AM | Links to this comments | Reply

    great job !

    can someone tell me how can i add a special portal to a place that i want ? or can someone tell me how can i make the Shattrath Portal to Thunderbluff to be used by allience to ? Thanks !

  83. 83
    thyll | May 27, 2008 at 1:19 / 1:19 AM | Links to this comments | Reply

    Jas

    do you have a working Gm command list?

    how can I add money?
    Thaks

  84. 84
    Hip-Hop | May 27, 2008 at 1:20 / 1:20 AM | Links to this comments | Reply

    I've made it to take it to work by copying the data from Mangos 5472 CONF files to the 5953 (the mangosd, scriptdev and realmd CONF files) Don't copy the whole files, just take the specified spots and overwhrite them in the CONF files (5953 Release) I hope I was in any kind of assistance! Good Luck!

  85. 85
    Hip-Hop | May 27, 2008 at 1:22 / 1:22 AM | Links to this comments | Reply

    Oatman please if it is not a problem to you to give us the GM commands of Mangos 5953, cuz some of the ones in 5472 don't work. (Sorry for the double-post)

  86. 86
    elderslayer | May 27, 2008 at 1:23 / 1:23 AM | Links to this comments | Reply

    can anyone tell me how to get the custom vendors working for this release? and also the portal to shatt doesnt seem tow work ?

  87. 87
    elderslayer | May 27, 2008 at 1:26 / 1:26 AM | Links to this comments | Reply

    u can find a list of the commands in the database under the command table

  88. 88
    elderslayer | May 27, 2008 at 1:29 / 1:29 AM | Links to this comments | Reply

    they have altered allot of them such ass money is now a modify option and to add game objects and or npc it id add after what u want to add for example

    .npc add 67868
    or .gobject add 757575

    money is .modify money 9832749237

    allot of it is subcommand based meaning it starts with what u want to do and then has add or delete or move and so on after

  89. 89
    Dopey | May 27, 2008 at 1:35 / 1:35 AM | Links to this comments | Reply

    @ Firane,

    Did you get the modified vendors file posted?

    @ Oatman,

    Any chance we can get the vendors back from the 5472 release? Those vendors are the ones I like with all the trainer vendors included. Tried reinstalling 5472, then the custom vendors, then running all the upgrades to this one, and it kinda worked. MOST of the vendors showed up (oh, and I had to modify the GUIDs for all the vendors). Anyway, thanks again for all the hard work.

  90. 90
    mhs2011 | May 27, 2008 at 1:43 / 1:43 AM | Links to this comments | Reply

    Ok i have this problem when upgrading. i had the newest version before this, but it wasnt working. i had the same problem as i do now. and i dont want to restart my whole database.
    so when i run mangos.exe i get this error message.
    "Loading Items...
    Error in item_template table, probably sql file formant was updated (there should be 140 fields in sql."

  91. 91
    elderslayer | May 27, 2008 at 1:53 / 1:53 AM | Links to this comments | Reply

    i had roughly the same issue mine was error in gameobject_template probably sql file formant was updated "there should be 32 fields in sql.”

    i tried everything.. had to delete and fresh install database now she works but im wondering hpw to get my custom vendor back up

  92. 92
    jalexbivin | May 27, 2008 at 1:57 / 1:57 AM | Links to this comments | Reply

    There was a problem with the batch file to extract DBC. Not sure if you caught it yet or not.
    On line three it reads:
    mpqe /d "." expansion-local-enUS *.dbc
    where it should read:
    mpqe /d "." expansion-locale-enUS.MPQ *.dbc

    Hope all is well with the Reaper man!

    Alex

  93. 93
    elderslayer | May 27, 2008 at 2:00 / 2:00 AM | Links to this comments | Reply

    ok imma try this again since i have had no responses yet

    I have a couple diffrent questions first of all my custom vendors are not thier (fresh install) was wondering how to get the vendors back?

    second of all im kinda struggling to set up a registration page any assistance on either or both topics would be appriciated.

    also looking for experienced gm’s that can assist me with small fixes and above mentioned questions these gms will get gm access to my server

    thanx in advance

  94. 94
    Mod | May 27, 2008 at 2:02 / 2:02 AM | Links to this comments | Reply

    i still dont understand what i did wrong. when i go to the reaper-x-mangos.exe it asks me where my files are so i put in to location and then i push 1 for installation. it asks for my username and i just use root. does the password have to be the same as the MySQL password? i've been using the words for the database names it gives like when it says "What is your World/Mangos Database Name ? (Most likely "mangos") i'll use mangos

  95. 95
    Mod | May 27, 2008 at 2:04 / 2:04 AM | Links to this comments | Reply

    nvm thanks, i think i got it now :)

  96. 96
    Mod | May 27, 2008 at 2:24 / 2:24 AM | Links to this comments | Reply

    ok now i'm finally passed the reaper-x-mangos file, but now when i open mangosd.exe, it works until it gets to:

    WORLD: VMap support included. LineOfSight:0, getHeight:0
    WORLD: VMap data directory is: ./vmaps
    WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
    Check existing of map file './maps/0004331.map': not exist!
    Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.

    so am i missing a file or something?

  97. 97
    elderslayer | May 27, 2008 at 2:29 / 2:29 AM | Links to this comments | Reply

    u need to run the map tool again

  98. 98
    Mod | May 27, 2008 at 2:33 / 2:33 AM | Links to this comments | Reply

    do you mean the "makevmaps_SIMPLE"?

  99. 99
    elderslayer | May 27, 2008 at 2:34 / 2:34 AM | Links to this comments | Reply

    no the maps tool not vmaps i beleave the file is called ad.exe

  100. 100
    Mod | May 27, 2008 at 2:36 / 2:36 AM | Links to this comments | Reply

    oh ok, thanks. i'll try that

  101. 101
    elderslayer | May 27, 2008 at 2:37 / 2:37 AM | Links to this comments | Reply

    actually it could be in ur config file in the manos config file thier is a line to enter your data directory aka the location u have ur maps vmaps and dbc folder make sure the directory is correct

  102. 102
    Mod | May 27, 2008 at 2:45 / 2:45 AM | Links to this comments | Reply

    i was looking through the mangosd.conf file, but i dont see any directory to where my maps and vmaps are

  103. 103
    Brutus | May 27, 2008 at 2:47 / 2:47 AM | Links to this comments | Reply

    Hi Reaper,

    First of all good work, its nice to have a good private wow server.

    I have some questions.

    After I updated to this version all the quests i have where i need to kill some creatures the counter does not work. So i can't complete them??

    Im having some little problems in game:

    1 In an Instance all the mobs are comming through the walls to kills us. Normaly they don’t ;)

    2 When i have a enchant on my weapon and its glowing. When i use that weapon after that the glow is gone. When i re attach my weapon it glows again. Do jou have any clue what this could be?

    I think its not my wow installation because some friends ho are also in my server have these problems to.

    Hope anyone could help me.

    Thanks allot Brutus

  104. 104
    elderslayer | May 27, 2008 at 2:53 / 2:53 AM | Links to this comments | Reply

    RealmID = 1
    DataDir = "C:\wow\Data"
    LogsDir = ""

    it should be in a group like this
    its in the first set of alterable tables

  105. 105
    Mod | May 27, 2008 at 2:56 / 2:56 AM | Links to this comments | Reply

    ok i found out why it says the file doesnt exist. its because my maps and vmaps folders are empty. i thought they came with the file since the dbc folder did and i didnt check them.

  106. 106
    Mod | May 27, 2008 at 3:00 / 3:00 AM | Links to this comments | Reply

    also, i had:

    RealmID = 1
    DataDir = “.”
    LogsDir = “”

    i didnt know i had to change that

  107. 107
    elderslayer | May 27, 2008 at 3:10 / 3:10 AM | Links to this comments | Reply

    k well u need to run the extractor and get all ur files in order and set that datadir path and u should be good to go

  108. 108
    elderslayer | May 27, 2008 at 3:10 / 3:10 AM | Links to this comments | Reply

    anyone figure out how to get all the ustom vendors back yet?

  109. 109
    Brent | May 27, 2008 at 3:11 / 3:11 AM | Links to this comments | Reply

    My loading screen keeps getting stuck at logging into game server any ideas?

  110. 110
    elderslayer | May 27, 2008 at 3:16 / 3:16 AM | Links to this comments | Reply

    does mangos exe show its up and online and do u have realmd up with no errors?

  111. 111
    lauriene | May 27, 2008 at 3:26 / 3:26 AM | Links to this comments | Reply

    i am getting errors when i start realmd, i think the info when running # 6 in reaper isnt carrying thru.

  112. 112
    lauriene | May 27, 2008 at 3:27 / 3:27 AM | Links to this comments | Reply

    and yes that info shows up in my sqylog database

  113. 113
    elderslayer | May 27, 2008 at 3:28 / 3:28 AM | Links to this comments | Reply

    what errors is realmd giving

  114. 114
    lauriene | May 27, 2008 at 3:31 / 3:31 AM | Links to this comments | Reply

    i am doing a fresh install so dont have that info at the moment, but the errors were the info that is added to #6

  115. 115
    Tyrael | May 27, 2008 at 3:37 / 3:37 AM | Links to this comments | Reply

    hi, guys one question, whats the ACID script for??

  116. 116
    Mod | May 27, 2008 at 3:40 / 3:40 AM | Links to this comments | Reply

    i have the vmaps file from running the ad.exe, but now i'm running makevmaps_SIMPLE and i get down to the part that says to wait until i get PRESS ANY KEY TO CONTINUE MESSAGE and i know i'm supposed to wait until it gets to that, but it wont go any farther. at the bottom it just says:

    C:\Program Files\World of Warcraft>vmap_assembler.exe buildings vmaps splitConfig.txt

    any ideas why it wont continue?

  117. 117
    elderslayer | May 27, 2008 at 3:41 / 3:41 AM | Links to this comments | Reply

    no idea

  118. 118
    elderslayer | May 27, 2008 at 3:41 / 3:41 AM | Links to this comments | Reply

    it will go just wait it takes forever

  119. 119
    elderslayer | May 27, 2008 at 3:45 / 3:45 AM | Links to this comments | Reply

    takes that part as long if not longer than the whole vmap process

  120. 120
    Mod | May 27, 2008 at 4:07 / 4:07 AM | Links to this comments | Reply

    it finally finished, but i still dont have a maps folder. just vmaps

  121. 121
    elderslayer | May 27, 2008 at 4:08 / 4:08 AM | Links to this comments | Reply

    u need to place the ad.exe in ur main wow folder as the directions say and run it it will make a map folder and then when its done move that to the directory u should look at the installation instructions for fresh install if u dont follow it stepop by step u will have several issues

  122. 122
    Mod | May 27, 2008 at 4:13 / 4:13 AM | Links to this comments | Reply

    when i ran the ad.exe file, it made a vmaps folder with 2000 something files in it. when i ran makevmaps_SIMPLE it just added more files to the vmaps folder. my vmaps folder now has 3334 files in it. i just ran the extract-map file and it made a map folder so i'm going to try to see if it works

  123. 123
    elderslayer | May 27, 2008 at 4:14 / 4:14 AM | Links to this comments | Reply

    not trying to be rude its just very hard to explain step by step and its already thier and written for ya :)

  124. 124
    lauriene | May 27, 2008 at 4:15 / 4:15 AM | Links to this comments | Reply

    realmd error:
    SQL: select id, name, address,port,icon,color,timezone,allowed securitylevel, population FROM realmlist where color ORDER BY name queary error: TABLE 'mangos.realmlist' dosen't exist
    No valid realms specified.
    i ran #6 in reaper and this is what i get when i open my realmd any help?

  125. 125
    elderslayer | May 27, 2008 at 4:16 / 4:16 AM | Links to this comments | Reply

    thats a new one for me couldnt tell u

  126. 126
    elderslayer | May 27, 2008 at 4:16 / 4:16 AM | Links to this comments | Reply

    so mod isnt short for modified is it previously from sof2?

  127. 127
    Mod | May 27, 2008 at 4:17 / 4:17 AM | Links to this comments | Reply

    i think it works, i just created my account
    thanks a lot for the help elderslayer

  128. 128
    Mod | May 27, 2008 at 4:18 / 4:18 AM | Links to this comments | Reply

    sof2?

  129. 129
    elderslayer | May 27, 2008 at 4:20 / 4:20 AM | Links to this comments | Reply

    guess that wasnt u then just a diffrent game and when u are ready to put the server online u will need to edit the realmlist file in the database to ur ip address u can do this by using sqlyog to edit the file

  130. 130
    Mickwald | May 27, 2008 at 4:21 / 4:21 AM | Links to this comments | Reply

    Ok, so I've installed this, fixed the maps, vmaps and the dbc (they're all in "c:\games\world of warcraft\data\")the realmd.exe starts with the mangos realm going up, but when I try to start mangosd.exe it just closes instantly. anyone who can solve this?

  131. 131
    elderslayer | May 27, 2008 at 4:22 / 4:22 AM |