Main Website RSS FeedCurrent Article

Mangos 4602, ScriptDev2 145 with Unified Database 0.7.5 CS319 work with WoW 2.1.3 to 2.2.3

Time for another Mangos release again :) … this time the Mangos revision used is 4602 with ScriptDev2 145, and as a warning that although you can play it using WoW Client version 2.2.x (such as WoW 2.2.0, 2.2.2, and 2.2.3), but it’s still not officially supported, so expect something to behave strange for example, hidden teleport in Orgrimmar when you are using WoW 2.2.x client. Although there’s already a fix for it, but since i prefer to distribute a clean compiled version without adding custom patch (such as database, script, mangos core), i decided not to include it :)

Things to note in this version :

1. I decided not to include the Project Silvermoon Database because Project Silvermoon Database website is down (it has been several days if i remembered it correctly)

2. No custom vendor on GM Island (because this is using Unified Database only, and custom vendor which is available on GM Island can only be found in Project Silvermoon database)

3. As for feeding pet … i’m not to sure on how to test it (seriously, because i never play on official server, though i wish i could play too)

That’s it … and now here are the steps :

Requirements :

Update : Reaper Mangos 4629 with ScriptDev2 150 and Dual Database has been released :)

1. MySQL (link to my previous post on how to install mysql)

2. Mangos + Database :

Optional :

Fresh Installation Guide (follow this if you’re planning on installing Mangos for the first time) :

1. Extract Maps, Vmaps and dbc files from WoW Client

2. Extract the self extracting archive somewhere, or you can just simply run it and choose to extract into the current directory (don’t worry it’ll create the ReaperMangos4602 folder automatically)

3. Run the reaper-x-mangos.bat inside the reaper-eazy-mangos directory / folder, and you’ll be greeted with this screen, and all you have to do is just write the full path to your mysql installation directory (or where mysql.exe and mysqldump.exe can be found) ;)

Reaper Eazy Mangos

4. After finished writing the full path to your mysql installation directory, now you just need to choose option #1 to install the database for you and when prompted for your root password, you just need to write your mysql root password (remember the mysql installation ?) ;)

Database installation

5. After finished with the above process, now you just need to choose option #4, and adjust each option accordingly (the most important thing is your Datadir location)

Mangos Datadir

6. Now you need to go into your World of Warcraft Installation directory and open the realmlist.wtf file using notepad and then change these lines :

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

into :

set realmlist 127.0.0.1

7. Now run mangosd.exe and realmd.exe

8. The first thing you should do of course create a new account for you, and this can be done by typing create username password in the mangosd window as shown on below image

Creating Account in mangos

But a normal account can be boring of course, so we need to configure our username to be a GM, and this can be done by simply typing setgm username 3 (the highest level of course, so you can do anything you want in your server) :P … and done :)

Superman

Upgrading from 4577 or below version (note: i only test it from Mangos 4488++ so if you’re using any version lower than 4488, i can’t give you any support)

1. Run the reaper-x-mangos.bat, and then go with option #99 and wait until finished

2. Then choose to backup your database

3. After finished with the backup process now you just need to choose the first option to install the database

4. Now you just need to choose the restore option

5. For the last step you just need to continue with configuring datadir (If you’re using ReaperMangos4577 previously, you just need to copy the previous mangosd.conf and realmd.conf into ReaperMangos4602 directory and done) :)

Sailing

Related Links :

RSS Feed for This Post245 Comment(s)

  1. 1
    siegelink | Oct 15, 2007 at 19:26 / 7:26 PM | Links to this comments | Reply

    Hi,

    I do play on the official servers, so if you have to know certain thing's (like pet feeding) pls ask.

  2. 2
    Nick | Oct 15, 2007 at 22:40 / 10:40 PM | Links to this comments | Reply

    Sorry to imform you this but you have forgotten
    mangosd.conf again just like in the rev4575

  3. 3
    RazMaTaz | Oct 16, 2007 at 1:16 / 1:16 AM | Links to this comments | Reply

    Offical PSDB Backup Site
    ps.eamped.com

  4. 4
    Sanctus | Oct 16, 2007 at 2:21 / 2:21 AM | Links to this comments | Reply

    Hello there,

    Do you know how I can build a real Mod for WoW. With Custom Maps and Systems?

    Learning how to develop to ScriptDev2 will do the trick?

    Thanks and regards...

    SKristies

  5. 5
    metaltilfra | Oct 16, 2007 at 2:59 / 2:59 AM | Links to this comments | Reply

    thanks reaper i though u were going to stop at 4590 but u went up anyway and I'm glad you chose to use the unified db it's much more functional than the silvermoon one's

  6. 6
    metaltildea | Oct 16, 2007 at 3:44 / 3:44 AM | Links to this comments | Reply

    sorry i forgot to post this before but i can never seem to get my vmaps completely so could you post a download for them already extracted?

  7. 7
    Jared | Oct 16, 2007 at 3:51 / 3:51 AM | Links to this comments | Reply

    I use silvermoon, but oh well its good that he got this for others :) I'll see if I can find the new database for project silvermoon and tell reaper cause they have backup sites.

  8. 8
    Repins | Oct 16, 2007 at 7:26 / 7:26 AM | Links to this comments | Reply

    Hey Reaper I just wanna say thanks for takin the time do post all the how to's and things... I've been tryin for weeks to make a private stable server and your guides have become a life saver! thanks again and please keep up the good work!!!!

  9. 9
    Reaper-X | Oct 16, 2007 at 8:34 / 8:34 AM | Links to this comments | Reply

    # Nick

    Well ... actually i already included it with different name :) , try using the batch file and then choose the fourth option to adjust datadir and drop rate ;)

    # Sanctus

    Probably but im not to sure about creating custom maps though, i think mangosproject website should give you some information about it :)

    # metaltildea

    Unfortunately it's impossible for me to upload large files (100MB+) such as maps and vmaps :( (even 10MB file takes 30 minutes to complete)

    btw actually you just need to wait until all the vmaps gets extracted properly (check the vmaps extraction guide so you know how it'll looks like when vmaps extraction finished) :)

    # Repins

    Your welcome Repins, glad you like it :)

    # RazMaTaz & Jared

    Thanks for the link to the backup site of PSDB ;)

    i just downloaded the 18.5 release but still wondering should i include it in this one or include it on the next release ?

  10. 10
    Xyzy | Oct 16, 2007 at 9:25 / 9:25 AM | Links to this comments | Reply

    Most things on the server seem to be functioning well, but I am having problems with instances, especially the Caverns of Time. In Old Hillsbrad, the internment camp is in flames from the start. In Hyjal Summit, there are no waves of enemies; they just stand there. And in the caverns themselves, those two little children who give the quests are not there (though the swirly purple design is).

  11. 11
    Xyzy | Oct 16, 2007 at 9:25 / 9:25 AM | Links to this comments | Reply

    Not to mention, I couldn't finish Taretha's diversion; the barrels were in the flaming houses, but lighting them did nothing.

  12. 12
    Demig0d | Oct 16, 2007 at 16:20 / 4:20 PM | Links to this comments | Reply

    Actually those don't work because they have not been scripted yet. Void Reaver was working a bit more like intended already, there still are some wrong flags in the arcane orb target definitions, they have a dumb model and you nearly always resist their damage, althought they are marked to be lvl 70 in the DB but they appear as lvl 1 creatures. He also enrages after 10 minutes, that was kinda hilarious to experience.

  13. 13
    mapisto | Oct 16, 2007 at 17:59 / 5:59 PM | Links to this comments | Reply

    Hey
    Thanks a lot to Reaper-X for all your work and dedication
    I just have this little problem with this version. I backed up, installed, and restored, upgrading from version 4535. now, mangosd.exe is working just fine but when I try to work ralmd.exe it gives me the following error:
    Database: 127.0.0.1;3306;mangos;mangos;realmd
    SQL: SELECT `id`, `name`, `address`, `port`, `icon`, `color`, `timezone`, `allowedSecurityLevel`, `population` FROM `realmlist` WHERE `color` != `3` ORDER BY `name`
    query ERROR: Unknown column `allowedSecurityLevel` in `field list`
    No valid realms specified.

    Please please help me out...

  14. 14
    Reaper-X | Oct 16, 2007 at 18:34 / 6:34 PM | Links to this comments | Reply

    # mapisto

    Did you choose to upgrade realmd first ? (option number 99) because there're several changes made into the realmd database :)

  15. 15
    Oko | Oct 16, 2007 at 18:41 / 6:41 PM | Links to this comments | Reply

    Hello there,

    I have your compiled windows version running nicely. However I grabbed r4602 from the SVN repository and built it for Linux. At first I got "Unable to validate game version" but resolved this with a simple fix to src/realmd/AuthSocket.cpp (validating any game version).

    Now I get so far as to choose a realm language & type, get recommended MaNGOS realm and then i get stuck at the realm list. Selecting the MaNGOS realm again brings up "Logging into game server" and then it gives up, returning to the realm list.

    Are there any specific patches / changes you do to your source tree before building it for windows?

    Thanks

    Oko

  16. 16
    mapisto | Oct 16, 2007 at 18:49 / 6:49 PM | Links to this comments | Reply

    Thanks a lot Reaper-X that solved it :)

  17. 17
    WaLshy | Oct 16, 2007 at 19:41 / 7:41 PM | Links to this comments | Reply

    Does anyone know of a fully working Database? With all / most bosses scripted right?

    Thx in advanced

  18. 18
    will | Oct 16, 2007 at 20:38 / 8:38 PM | Links to this comments | Reply

    Reaper help please just tryed to do a clean installation and i get this application has failed to start because msvcr71.dll was not found re-installing the application may fix it this happens when i try to bring up mangosd.exe and i have redone it all 7 times still same thing please help

  19. 19
    Oko | Oct 16, 2007 at 21:07 / 9:07 PM | Links to this comments | Reply

    Scrap my previous message, solution was found on http://www.mangos-fae.info/ 'Realm Looping' is caused by having the incorrect IP in the realmd.realmlist table. ( Ooppss )

    Oko

  20. 20
    Repins | Oct 16, 2007 at 21:56 / 9:56 PM | Links to this comments | Reply

    hey will i had that problem a while back and they way that i fixed it was like this: I tried to Register MSVCR71.DLL and it wouldn't work then I found the same type of file but only in lowercase letters and lowercase ext. and it worked. Sorry I can't remember where I found the file but you can try to rename it in all lowercase and then register it.. Hope that helps.

  21. 21
    stitches | Oct 17, 2007 at 0:56 / 12:56 AM | Links to this comments | Reply

    I have a similar problem to Oko's login loop, although I am using the windows version from this guide.

    I get as far as Oko where you have to choose a realm language & type, but I get recommended Reaper-X realm and then I also get stuck at the realm list. Selecting the Reaper-X realm again brings up “Logging into game server” and then it gives up, returning to the realm list.

    Thanks for any help.

  22. 22
    will | Oct 17, 2007 at 1:48 / 1:48 AM | Links to this comments | Reply

    2007-10-16 14:43:46 Using configuration file mangosd.conf.
    2007-10-16 14:43:46 MaNGOS daemon /Reaper-X R4577 0.8-SVN http://www.reaper-x.com (Win32)
    2007-10-16 14:43:46 to stop.

    MM MM MM MM MMMMM MMMM MMMMM
    MM MM MM MM MMM MMM MM MM MMM MMM
    MMM MMM MMM MM MMM MMM MM MM MMM
    MM M MM MMMM MM MMM MM MM MMM
    MM M MM MMMMM MM MMMM MMM MM MM MMM
    MM M MM M MMM MM MMM MMMMMMM MM MM MMM
    MM MM MMM MM MM MM MMM MM MM MMM
    MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
    MM MM MM MMM MM MM MMMMMM MMMM MMMMM
    MM MMM http://www.mangosproject.org
    MMMMMM

    Reaper-X R4577 SD2-140 http://www.reaper-x.com

    2007-10-16 14:43:46 World Database: 127.0.0.1;3306;mangos;mangos;mangos
    2007-10-16 14:43:46 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
    2007-10-16 14:43:46 Realm running as realm ID 1
    2007-10-16 14:43:46 Using UDB 0.7.5 (319) with SD2 calls rev.145
    2007-10-16 14:43:46 Using DataDir C:\wow\data/
    2007-10-16 14:43:46 WORLD: VMap support included. LineOfSight:1, getHeight:1
    2007-10-16 14:43:46 WORLD: VMap data directory is: C:\wow\data/vmaps
    2007-10-16 14:43:46 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
    2007-10-16 14:43:46 Initialize data stores...
    2007-10-16 14:43:46
    2007-10-16 14:43:46 >> Loaded 38 data stores
    2007-10-16 14:43:46
    2007-10-16 14:43:46 Using Autodetected DBC Locale (0).

    2007-10-16 14:43:46 Cleaning up instances...
    2007-10-16 14:43:46
    2007-10-16 14:43:46 >> Initialized 0 instances, deleted 0 old instances
    2007-10-16 14:43:46 Packing instances...
    2007-10-16 14:43:46
    2007-10-16 14:43:46 >> Instance numbers remapped, next instance id is 1
    2007-10-16 14:43:46 Loading Game Object Templates...
    2007-10-16 14:43:46 >> Loaded 12991 game object templates
    2007-10-16 14:43:46
    2007-10-16 14:43:46 Loading Spell Chain Data...
    2007-10-16 14:43:46
    2007-10-16 14:43:46 >> Loaded 1904 spell chain records
    2007-10-16 14:43:46 Loading Spell Learn Skills...
    2007-10-16 14:43:46
    2007-10-16 14:43:46 >> Loaded 42 spell learn skills + found in DBC 74
    2007-10-16 14:43:46 Loading Spell Learn Spells...
    2007-10-16 14:43:46
    2007-10-16 14:43:46 >> Loaded 42 spell learn spells + found in DBC 5930
    2007-10-16 14:43:46 Loading Spell Proc Event conditions...
    2007-10-16 14:43:46
    2007-10-16 14:43:46 >> Loaded 850 spell proc event conditions
    2007-10-16 14:43:46 Loading Aggro Spells Definitions...
    2007-10-16 14:43:46 >> Loaded 56 aggro generating spells
    2007-10-16 14:43:46
    2007-10-16 14:43:46 Loading NPC Texts...
    2007-10-16 14:43:47
    2007-10-16 14:43:47 >> Loaded 3522 npc texts
    2007-10-16 14:43:47 Loading Item Random Enchantments Table...
    2007-10-16 14:43:47
    2007-10-16 14:43:47 >> Loaded 28408 Item Enchantment definitions
    2007-10-16 14:43:47 Loading Items...
    2007-10-16 14:43:47 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 138 fields in sql).

    well i got past that file problem now i get this any suggestions oh and ty on the advise

  23. 23
    Roman | Oct 17, 2007 at 2:10 / 2:10 AM | Links to this comments | Reply

    Hey. I got this problem too with Mangos 4577 but then I found out it was the program Mysql that did not work correctly. I reinstalled MySQL and re-uesd reaper-x-mangos.bat to reinstall the right data. then it loaded completely. Maybe it will help you too.

  24. 24
    Xyzy | Oct 17, 2007 at 3:53 / 3:53 AM | Links to this comments | Reply

    Pretty much NONE of the scripts/triggers for events work. Mobs only auto-attack, instances in doors don't open (Shadow Labs just tested); in CoT all three instances are bugged (the buildings in Hillsbrad are on fire to begin with, but I can't talk to Thrall, Medivh won't begin opening the portal, and enemies in Hyjal just stand around doing nothing).

  25. 25
    simon | Oct 17, 2007 at 5:31 / 5:31 AM | Links to this comments | Reply

    Hi - I posted a couple of weeks ago and gave up in frustration at being unable to get a server up and running.

    Well I am trying again and Have a Mangos 1.0.8 working - obviously this is not much good but I see graphics and all that pretty WOW stuff like a game - now I would like to try to upgrade.

    Is there a tutorial on how to do this? Or do I really have to ditch this and start from scratch? I would appreciate any advice you could give me.

    Thank you.

  26. 26
    simon | Oct 17, 2007 at 5:44 / 5:44 AM | Links to this comments | Reply

    I should mention my Noob status - so please go slow with instructions :)

  27. 27
    elliott | Oct 17, 2007 at 5:48 / 5:48 AM | Links to this comments | Reply

    hey, ty for everything its all working well, i'm havening issues getting a site template to work.

  28. 28
    Chris | Oct 17, 2007 at 6:41 / 6:41 AM | Links to this comments | Reply

    Great guide. Thanks for the work. My server is up and running with only minor issues that I am working through. It works for clients up through 2.2.3. This last upgrade appears to fixed the pet feeding issue as it is now working for me. Thanks again.

  29. 29
    elliott | Oct 17, 2007 at 7:08 / 7:08 AM | Links to this comments | Reply

    hye on this version does gm island have any venders?? and if not where can i get a patch for it.. and also lol how do you install patchs? i got one from the forms for instances.. but it doesnt tell me how to patch the server.

  30. 30
    simon | Oct 17, 2007 at 7:36 / 7:36 AM | Links to this comments | Reply

    Decided to try from scratch - realised upgrading from 1.0.8 seems crazy.

    Am I correct in thinking I put the extracted maps, vmaps and DBC folders in the ReaperMangos4602 folder?

    Thanks again for your time and patience

  31. 31
    simon | Oct 17, 2007 at 7:38 / 7:38 AM | Links to this comments | Reply

    I seem to get a Buildings Folder aswell from "make maps simple.bat" Is that right and should they be moved to the same location?

  32. 32
    simon | Oct 17, 2007 at 10:29 / 10:29 AM | Links to this comments | Reply

    okay got all the way through DBC, Map and Vmap installation. Got to running Realmd and mangosd. Realmd works fine - Mangosd crashes instantly. Barely blinks on screen a second the is gone. I looked for a Mangosd Config file but there is none. Is this what I need or not?

  33. 33
    Vedin | Oct 17, 2007 at 11:07 / 11:07 AM | Links to this comments | Reply

    I also would like to know where I can find some patches and how to install them so that I can get the scripts running correctly for the instances

  34. 34
    Reaper-X | Oct 17, 2007 at 11:09 / 11:09 AM | Links to this comments | Reply

    # simon

    Yep you'll need that mangosd.conf file first ;)

    try running the reaper-x-mangos.bat and choose option 4 and adjust it accordingly, and you'll get that mangosd.conf file :D

    # WaLshy

    Actually it's not database related, but it's scriptdev2 related :)

    # Oko

    try looking at the src/shared/common.h ;)

    # elliott

    Patching the source code require you to recompile the code again :)

  35. 35
    simon | Oct 17, 2007 at 11:31 / 11:31 AM | Links to this comments | Reply

    Thanks for the tips. I reinstalled the database (assuming that is what you meant Elliott - you where a little unlcear - or more likely I am too much of a noob to understand the reference)

    Made sure I chose option 4 this time and sure enough the config file was there.

    Fired up MySQL and tried again. Realmd worked ok. Mangosd. Failed again - I seem to remember getting this probelm before - Cannot remember how I fixed it. Gah

  36. 36
    KompressR | Oct 17, 2007 at 11:34 / 11:34 AM | Links to this comments | Reply

    I have the same problem as will up there, but I had the file it asked for in multiple places on my computer and after reading the Repins post i was about to ask how to register it. However i copied the file into my server folder and ran realmd again and it worked. :)

  37. 37
    simon | Oct 17, 2007 at 11:40 / 11:40 AM | Links to this comments | Reply

    O.M.G! It's Worrking. Hm - Well it would be but My graphics card just fizzled on me -

    Ah well that is a seperate issue. Mangos seems to be up and runnning. Thank you so much for your help - it must have been like pulling teeth out there. :)

  38. 38
    Jason | Oct 17, 2007 at 13:58 / 1:58 PM | Links to this comments | Reply

    Hey Reaper,

    I'm just curious on what gear you're using to crit for 23k white dmg. or what gm commands you're using to crit for that much, any reply would be great thanks.

    Jason

  39. 39
    KompressR | Oct 17, 2007 at 14:28 / 2:28 PM | Links to this comments | Reply

    Now I actually have the same problem as will's second problem... I got my hands on the psdb 18.5, so i took a buncha :REM's outta reaper-x-mangos.bat, matched the filenames and made it so i could choose the psdb option. the database fnisihed uploading but now i get this error as i boot up mangosd:

    Loading Item Random Enchantments Table...
    ==================================================== 100%
    >> Loaded 28361 Item Enchantment definitions

    Loading Items...
    Error in `item_template` table, probably sql file format was updated (there shou
    ld be 140 fields in sql).

    Any ideas? Anyone else install the psdb 18.5 db with no errors?

  40. 40
    WaLshy | Oct 17, 2007 at 14:52 / 2:52 PM | Links to this comments | Reply

    @KrompressR
    You should use the SQL Updates in the Core Archive.

    "4594_item_template.sql"

    Code:
    ALTER TABLE `item_template`
    ADD COLUMN `minMoneyLoot` int(11) unsigned NOT NULL default '0' AFTER `FoodType`,
    ADD COLUMN `maxMoneyLoot` int(11) unsigned NOT NULL default '0' AFTER `minMoneyLoot`;

    I used SQLyog to make the changes and it went fine

  41. 41
    WaLshy | Oct 17, 2007 at 15:31 / 3:31 PM | Links to this comments | Reply

    KompressR, what you need to do is apply the update "4594_item_template.sql" in the Mangos/OriginalSQL/Mangos4602/updates folder.

    I used the SQLyog program to do it for mine, and it worked fine.

  42. 42
    Reaper-X | Oct 17, 2007 at 17:15 / 5:15 PM | Links to this comments | Reply

    # Jason

    Lol ... actually i'm using a modded weapon (dunno what's the original name of that weapon, but my modded weapon called omega weapon and ultima weapon) that gives you +1000 stats :P

    # KompressR

    Just as Walshy said, you'll need to execute / import each core update until 4602 :)

  43. 43
    Skreci | Oct 17, 2007 at 18:47 / 6:47 PM | Links to this comments | Reply

    Hey there I need help I can't make a blood elf or a draenei why I made a bc acc pliz help me ;(

  44. 44
    KompressR | Oct 17, 2007 at 20:50 / 8:50 PM | Links to this comments | Reply

    execute each core update? I reinstalled WoW and TBC and then installed mangos 4602 fresh. Worked fine the first time with the UDB, but as soon as I updated to the PSDB, I got that error. How do I import each core update untill 4062? (and with what updates do i start? this wasn't an upgrade it was a fresh install

  45. 45
    KompressR | Oct 17, 2007 at 20:50 / 8:50 PM | Links to this comments | Reply

    sorry, didn't see walshys post. my bad.

  46. 46
    Raptos | Oct 17, 2007 at 21:01 / 9:01 PM | Links to this comments | Reply

    Hey,could you help me with something,everytime i'm running mangosd i get this error:
    Loading items…
    Error in “item_template” table,probably sql file was updated there should be 138 fields in sql
    Please help!

  47. 47
    simon | Oct 17, 2007 at 22:12 / 10:12 PM | Links to this comments | Reply

    Would anyone happen to know of a link to a site that covers basic mangos instructions like server autosaves and that sort of thing?

    Thanks

  48. 48
    merijn | Oct 17, 2007 at 22:38 / 10:38 PM | Links to this comments | Reply

    Hi reaper

    i have the server running now but how can i change
    the server name ?

    greetings

  49. 49
    simon | Oct 17, 2007 at 22:53 / 10:53 PM | Links to this comments | Reply

    Been looking round the server as a GM. Used teleport commands - Got killed - appeared in graveyard. Spirit healer invisible and unable to select it. Cannot use ANY gm comands. All say "cannot chat when you are dead"

    Any ideas would be appreciated - Thanks :)

  50. 50
    Reaper-X | Oct 17, 2007 at 22:54 / 10:54 PM | Links to this comments | Reply

    # simon

    actually mangos autosave your character data :) .. but if you prefer to use manual way to save your character data, you can just type .saveall (ingame) or saveall (mangosd window)

    # merijn

    use the batch file provided (reaper-x-mangos.bat) and choose the option to change your realmlist ip address :)

  51. 51
    Reaper-X | Oct 17, 2007 at 22:55 / 10:55 PM | Links to this comments | Reply

    # KompressR and Raptos

    well if you prefer to use another database (not the one included), you need to execute / import each core update manually :)

    # Skreci

    Which version you're using ? i believe i've already set TBC to be used by default

  52. 52
    will | Oct 17, 2007 at 23:26 / 11:26 PM | Links to this comments | Reply

    pleasee some one help me oh before i forget it sucks when to are 65yrs old but ty reaper and and your team for taking all this time to do this for all of us i got two questions for anybody that could help me out how do i setup a portal say from undercity to shattrath and how do i setup or get the creatures vendors to stay were i move them pleaseee help ty

  53. 53
    simon | Oct 18, 2007 at 0:21 / 12:21 AM | Links to this comments | Reply

    Thanks for the save commands Reaper.

    Death still an issue - anyone else have this problem who has found a solution?

  54. 54
    Peter | Oct 18, 2007 at 0:39 / 12:39 AM | Links to this comments | Reply

    @ simon

    if you die you can use the .revive command in /guild/party/whisper and you will be auto ressed, as it surgest you cannot chat while dead but guild, party and whisper are not classed as "general chat"

    @ will

    i am not sure exactly how you set up portals but you can create objects and spwn them so try the .lookupobject command for eg Portal andd see what it comes up with and to move a vendor you will need mysql database editing progam eg navicat or mysqlyog and edit the database for the npc coordinates manually (this is by no easy thing to do so use caution) the reason they move back is when you restart the server or they die they will spwn in there database location and not there moved location.

  55. 55
    Cyrrus | Oct 18, 2007 at 0:51 / 12:51 AM | Links to this comments | Reply

    I did everything as directed for updating from 4577, and yes i did restore the character data with out any errors. when I got into the character selection screen everything looked normal but when I got on my character all the gear was missing along with all spells/abilities, I didn't even have a hearthstone... Any clue why this happened and is there any way to restore them now?

  56. 56
    simon | Oct 18, 2007 at 1:54 / 1:54 AM | Links to this comments | Reply

    Thanks Peter - that will do 'til I can fix the spirit healers ;)

  57. 57
    KompressR | Oct 18, 2007 at 6:05 / 6:05 AM | Links to this comments | Reply

    ok well, while this sounds like a long painful process, is there a guide around anywhere on how to do that?

  58. 58
    WaLshy | Oct 18, 2007 at 8:16 / 8:16 AM | Links to this comments | Reply

    KrompressR:
    http://ps.eamped.com/topic6.html
    This is a guide that show you how to update you database.

    http://ps.eamped.com/mangos-database-discussion-vf3.html
    This are numerous fixes for that particular database.

    Reaper:
    Is there anyway that I can update the scriptdev2 myself manually? Thx

  59. 59
    xXWoWXx | Oct 18, 2007 at 8:47 / 8:47 AM | Links to this comments | Reply

    I need help on making my server public when i type the UPDATE 'realmlist' set 'address' 'My Lan ip' where 'id' =1 i get an error saying incorrect syntax plz use mysql manual that comes with the program to fix it. HELP ME PLZZZZ!

  60. 60
    KompressR | Oct 18, 2007 at 10:49 / 10:49 AM | Links to this comments | Reply

    ok so i've found an older guide for setting up a server on your site, and i've managed to succesfully import the psdb, then ran the 4594_item_template.sql update. it now gets past that error, and i can get on the server. however i still get quite a few errors while mangos loads up. two questions:

    am i supposed to install all the updates from this one on for better compatibility? and if so, i don't need to install any before this one?

    secondly, am i supposed to install these updates before or after i install the database?

    thanks for your help, you've makde it pretty easy to get this far anyways.

  61. 61
    Reaper-X | Oct 18, 2007 at 11:04 / 11:04 AM | Links to this comments | Reply

    # xXWoWXx

    Could you tell me what is your mysql version ? i've just tested it again and it worked just fine

    # KompressR

    Based from the PSDB 18.5 description, it seems that DB is based from core 4556 ... which mean :D

    if you're going to use with this version (4602), you'll need to import each available core update since 4557 and above :)

    as a side note,

    Mangos has just officially support the WOW 2.2.3 :) (just checked it today also there's database update from UDB) ... and that mean there'll be another release soon / perhaps after few days since i just released this 4602 version ;)

  62. 62
    Reaper-X | Oct 18, 2007 at 11:11 / 11:11 AM | Links to this comments | Reply

    # Walshy

    it seems your post got caught by the automatic spam filtering system im using on this web site (im sorry for this issue) .. and i just recovered it manually (thanks God i take a look at the spam zone, because usually i dont check the spam area)

    as for your question about scriptdev

    you'll need to recompile scriptdev manually and also recompile the mangos core too :)

  63. 63
    boldspud | Oct 18, 2007 at 11:39 / 11:39 AM | Links to this comments | Reply

    Hey, I don't exactly know what I'm doing wrong. I followed your instructions for the three extraction processes exactly. Yet, when I looked in my World of Warcraft folder after that 2 hours process, there were no additional folders like vmaps or maps. It seems like the scripts did actually do anything...

    Again, I don't know what's happening, but clearly I've done something wrong.

  64. 64
    Skreci | Oct 18, 2007 at 12:58 / 12:58 PM | Links to this comments | Reply

    I'm using 2.2.3 patch version but I set my acc to expansion and nothing :/ can you help me with that problem ?

  65. 65
    Jason | Oct 18, 2007 at 13:14 / 1:14 PM | Links to this comments | Reply

    Hey Reaper,

    What do you download to be able to make you're own custom weapons cause I'd love to be able to solo black temple and other instance. Any info'd be great.

    Thanks Jason

  66. 66
    Skreci | Oct 18, 2007 at 14:36 / 2:36 PM | Links to this comments | Reply

    and one more question can you tell me how can I change system message to my nick word pliz
    thnaks ;)

  67. 67
    Peter | Oct 18, 2007 at 14:59 / 2:59 PM | Links to this comments | Reply

    @ jason

    the making of custom weapons is hard, if you are talking about making a "whole new weapon" then you will need a model maker, model viewer, and more, the easiest thing you can do though is use a existing template eg thunderfury and change the stats, you can do this with navicat and mysql but will take time to perfect and also takes a general understanding of how databases work, to get navicat you can go to http://www.navicat.com/download.html
    be carful when you are doing this as editing things in the database may have unforseen curcumstances.

    @ skreci

    in the mangos command propt there is an option to use the command motd

    so type as follows

    motd

  68. 68
    Peter | Oct 18, 2007 at 14:59 / 2:59 PM | Links to this comments | Reply

    sorry for double post

    i meant motd your required message

  69. 69
    Jason | Oct 18, 2007 at 15:44 / 3:44 PM | Links to this comments | Reply

    okay thanks peter I'll check it out.

  70. 70
    Skreci | Oct 18, 2007 at 16:02 / 4:02 PM | Links to this comments | Reply

    thanks Peter I'm a bit newbie in server ownings sorry for my english :)

  71. 71
    Lordkex | Oct 18, 2007 at 17:45 / 5:45 PM | Links to this comments | Reply

    Hey... when i try to use Mangos.exe it only says it cannot connect what does that mean?

  72. 72
    Skreci | Oct 18, 2007 at 18:01 / 6:01 PM | Links to this comments | Reply

    Lordkex use the reaper-x-mangos.bat to change your directory for mangos

  73. 73
    Lordkex | Oct 18, 2007 at 18:03 / 6:03 PM | Links to this comments | Reply

    what u mean?

  74. 74
    Skreci | Oct 18, 2007 at 18:38 / 6:38 PM | Links to this comments | Reply

    Use the reaper-x-mangos.bat to change directory I mean{1.install 2.backup etc) and choose 4.

  75. 75
    dante | Oct 18, 2007 at 19:19 / 7:19 PM | Links to this comments | Reply

    Silvermoon is back up, maybe youl do a whole new package? ^.^ I realy do love these

  76. 76
    Reaper-X | Oct 18, 2007 at 20:04 / 8:04 PM | Links to this comments | Reply

    # dante

    Actually im already using the latest 4617 mangos (2.2.3 official) with UDB 0.8, but i think i'd be best to wait a little while because currently silvermoon hasn't released another update :)

  77. 77
    Skreci | Oct 18, 2007 at 20:37 / 8:37 PM | Links to this comments | Reply

    Pls help me Reaper cuz I can't make dranei or blooedelfes on my server I'm GM 3 I set my acc to bc and nothing I can't tele to outland too pliz help me ;(

  78. 78
    Merijn | Oct 18, 2007 at 22:34 / 10:34 PM | Links to this comments | Reply

    Hi reaper

    I have 1 question: how can i change my realm name ??

    greetings

  79. 79
    Jordavious | Oct 19, 2007 at 0:34 / 12:34 AM | Links to this comments | Reply

    Merijn,

    You need to go into your realmd database, go to the realmlist table, once you get to the realmlist table you can go to the name field and change the name to what ever you want

    Jordavious

  80. 80
    Jordavious | Oct 19, 2007 at 0:40 / 12:40 AM | Links to this comments | Reply

    Skreci,

    The only way that you wouldn't be able to use dranei or bloodelfs is 1.) you didn't enable TBC on your account. 2.) you dont have TBC installed.

    Jordavious

  81. 81
    Jordavious | Oct 19, 2007 at 0:49 / 12:49 AM | Links to this comments | Reply

    Jason,

    Making weapons, armor, trinkets, rings, basically any item all you need is the program Quice http://wowps.org/forum/showthread.php?p=8627

    Its a very simple program to use, all you have to do is tell Quice how to get to your database :server address, username, password, and what data base you want to edit (incase you run more then one server like i do). once you connect to your database, for practice i would make a duplicate item then change the GUID of the duplicate so you dont change the stats of the original item.

    Jordavious
    if you need any help with quice you can email me at thebloodthurst@yahoo.com

  82. 82
    Skreci | Oct 19, 2007 at 1:03 / 1:03 AM | Links to this comments | Reply

    damn but I have TBC installed my firneds tryed to make draenyers or bloodelfes they still can't too ;((((

  83. 83
    Skreci | Oct 19, 2007 at 1:06 / 1:06 AM | Links to this comments | Reply

    and I hav bc enabled on my acc.... i created acc in mangosd.exe in the console with create name pass and setbc 1

  84. 84
    Jordavious | Oct 19, 2007 at 1:14 / 1:14 AM | Links to this comments | Reply

    Skreci,

    Sorry i also forgot to metion that you have to have Expansion = 1 in the mangosd.conf file, if all 3 of those things are all right, then i would suggest extracting all the files again. also make sure that you have a fresh install of WOW and TBC, sometimes if you dont have a fresh install of the WOW clients the extractors wont work right.

    Jordavious

  85. 85
    Jordavious | Oct 19, 2007 at 1:18 / 1:18 AM | Links to this comments | Reply

    Skreci,

    What i mean by fresh install is make sure that the wow folder that you extracted from wasnt a copy of the original wow folder, when your extracting files from a copy of the original folder is where you can experience problems. If all the 3 Things that I mentioned are correct, then MaNGOS doesnt have the required DBC,Map, and VMap files to enable TBC, and that is why you would have to re-extract the files from a fresh wow client

    Jordavious

  86. 86
    Skreci | Oct 19, 2007 at 1:18 / 1:18 AM | Links to this comments | Reply

    ahh damn but I yesterday re-installed my WoW and TBC what a hell is goin on omg I re-installed the server too and nothing :( and one more question in game when I writing soemthing with .announce I always see system message how I change it my name??

  87. 87
    Jordavious | Oct 19, 2007 at 1:39 / 1:39 AM | Links to this comments | Reply

    Skreci,

    The only thing left that i can say to look into is, are you useing Reaper-x's extractors that came with this repack, if not make sure that they are compatible with TBC. The fact that you said that the 3 things i metioned are correct has me a little stumped, those are the only 3 reasons in 1+ years of working with magos that would fix your problem. If none of these things that i have metioned dont help please email me at thebloodthurst@yahoo.com i would like to help you figure this out.( i hate not knowing whats wrong, i always have to have thigs work right)

    good luck,
    Jordavious

  88. 88
    Jason | Oct 19, 2007 at 1:42 / 1:42 AM | Links to this comments | Reply

    Hey,

    I found an Item creator but I don't know where to place the items once they're done. It saves them to .sql format but where do I place the .sql. Any help would be grand.

    Thanks Jason

  89. 89
    Skreci | Oct 19, 2007 at 1:51 / 1:51 AM | Links to this comments | Reply

    ok then I try to do something but one more question about that ingame message system message with .announce how can I make this my nick message thank Jordavius

  90. 90
    Jordavious | Oct 19, 2007 at 1:55 / 1:55 AM | Links to this comments | Reply

    Jason,

    what is the name of the item creator, the only tools that i have used to make custom ites is Quice, and SQLyog. If you use one of those the program saves the item right to the db that you created or modified it in, if your using a program that doesnt connect to MYSQL then you are going to have to import that .SQL file into you weapon_template table. NOTE: you have to make sure that the item that you created doesnt have the same ID # as another item, if you try inserting a new item into the db with the same ID # as another item, the new item that you are inserting will over wright the original item that cause some problems for you in the long run, i always make the item #'s rediculously high so that the ID#'s wont clash. But to import the item into your database your going to have to use a SQL editor, i suggest MYSylog, once you have a SQL editor you can just go to your DB(i think its mangos by default) right click on what ever you named your mangos db and click import batch file and find the sql file that you made and import it. Its way easier to make items if you just use Quice, that program automatically inserts the item into your db

    good luck,
    jordavious

  91. 91
    Jordavious | Oct 19, 2007 at 1:59 / 1:59 AM | Links to this comments | Reply

    Skerci,

    Technically i believe that the system message is considdered a world chat. if that is so then you can only change it in the mangos sorce. and you can only do that by compiling mangos yourself. This might be a difficult task for you if you dont have any experience with programming(c++, vb.net) but there are instructions on how to do that at mangosproject.org, i would explain it to you hear but i dont think reaper-x would appreciate that.

    feel free to email me,

    Jordavious

  92. 92
    Jason | Oct 19, 2007 at 3:35 / 3:35 AM | Links to this comments | Reply

    Jordavious,

    The program I downloaded is just called TBC Item Creator, confusing to use and understand. However I did download Quice but I don't know how to set it up? Any help would be great.

    Thanks Jason

  93. 93
    Jordavious | Oct 19, 2007 at 4:53 / 4:53 AM | Links to this comments | Reply

    Jason,

    if you send me your email to
    thebloodthurst@yahoo.com or jordavious@yahoo.com i will be more then willing to send you a detailed email on how to set up quice and how to use it. Quice is a very easy program to use and learn how to use.

    Jordavious

  94. 94
    simon | Oct 19, 2007 at 4:58 / 4:58 AM | Links to this comments | Reply

    Hi Jordavious. I read you are using Quince. I just downloaded it and would be really chuffed if I could badger you for those instructions you mentioned. Would that be okay?

  95. 95
    Jordavious | Oct 19, 2007 at 5:06 / 5:06 AM | Links to this comments | Reply

    Simon,

    Yes, that is perfectly fine, just send me a email to jordavious@yahoo.com or thebloodthurst@yahoo.com requesting some instructions on how to set up and use Quice. I don't want to post the instructions here since Quice doesn't pertain to the subject of Mangos 4602, ScriptDev2 145 with Unified Database 0.7.5 CS319 work with WoW 2.1.3 to 2.2.3. so anyone who would like how to use quice you can email me.

    Thanks,

    Jordavious

  96. 96
    boldspud | Oct 19, 2007 at 5:08 / 5:08 AM | Links to this comments | Reply

    So does anyone know what I'm doing wrong? Again, I'm not getting any results of any kind when I do the three extraction processes. I'm following the directions and getting all the same finished messages at the end of the scripts, but not finding and new folders like vmaps, maps, or dbc. Thanks in advance!

  97. 97
    Jordavious | Oct 19, 2007 at 5:21 / 5:21 AM | Links to this comments | Reply

    boldspud,

    from experience normally that happens when you dont have a fresh install of WoW and TBC when you go to extract all the need files.Look up a few posts about what i said to Skerci. If you dont have a fresh ver of WOW and TBC uninstall WoW then reinstall everything

    Jordavious

  98. 98
    simon | Oct 19, 2007 at 5:23 / 5:23 AM | Links to this comments | Reply

    You could try a windows search for the folders to make sure they didn't end up somewhere you were not expecting. "VMAPS" must be a fairly unique folder name.

  99. 99
    Jordavious | Oct 19, 2007 at 5:29 / 5:29 AM | Links to this comments | Reply

    boldspud,

    what simon said too is also true if you may have moved them, but if you followed reaper-x's instrucions you should have DBC, VMaps, Maps, and Building folders in your wow folder, you need to make sure that the extractors are placed in the correct folders. If the extractors are not in the proper folders the files will not be extracted

    Jordavious

  100. 100
    Grady | Oct 19, 2007 at 5:58 / 5:58 AM | Links to this comments | Reply

    Wow, what is is? Three days since you got this up? A lot of posts. Congratz.

    BTW i was wondering about your custom weapon. I have the program that allows me to alter my server files, Navicat Lite, and i know where the weapons are, and i can probably make my own, but i am not sure what all the columns mean. I have messed around with it a bit in the past, but could you help and post/send something that explains what all the columns are for?

    Thanks

  101. 101
    xXWoWXx | Oct 19, 2007 at 7:26 / 7:26 AM | Links to this comments | Reply

    sorry it took so long i had band practice. My mysql version is 5.0 community free edition 42.0 megabites is the size.

  102. 102
    Reaper-X | Oct 19, 2007 at 8:54 / 8:54 AM | Links to this comments | Reply

    # Jordavious

    Technically i believe that the system message is considdered a world chat. if that is so then you can only change it in the mangos sorce. and you can only do that by compiling mangos yourself. This might be a difficult task for you if you dont have any experience with programming(c++, vb.net) but there are instructions on how to do that at mangosproject.org, i would explain it to you hear but i dont think reaper-x would appreciate that.

    ah ... you don't need to worry about it :)

    # Grady

    You can see each column description from the itemprototype.h , or if you prefer to see it directly, i just paste the content of itemprototype.h to pastebin ;)

    http://pastebin.ca/741889

    # xXWoWXx

    I'd suggest you to open the reaper-x-mangos.bat directly and then copy paste the sql query used and execute it directly from the command prompt :)

    1. Open command prompt
    2. type mysql -umangos -pmangos -D realmd
    3. and paste the sql query used from the batch file ;)

  103. 103
    xxwowxx | Oct 19, 2007 at 9:15 / 9:15 AM | Links to this comments | Reply

    but i do n ot know were the sql querry is

  104. 104
    Reaper-X | Oct 19, 2007 at 11:10 / 11:10 AM | Links to this comments | Reply

    try following the above step to go into your command prompt first :)

    Follow the step to go to command prompt and when you've logged in into mysql type this

    UPDATE `realmd`.`realmlist` SET `name` = 'YOUR DESIRED REALMD NAME', `address` = 'YOUR LAN IP' WHERE `realmlist`.`id` = 1 LIMIT 1;

  105. 105
    Merijn | Oct 19, 2007 at 21:03 / 9:03 PM | Links to this comments | Reply

    Ty

  106. 106
    Merijn | Oct 19, 2007 at 21:05 / 9:05 PM | Links to this comments | Reply

    reaper how can i 'put' silvermoon in my server
    i have the newest database but dont know how to use it

    greetings

  107. 107
    Skreci | Oct 19, 2007 at 22:15 / 10:15 PM | Links to this comments | Reply

    Hey Reaper can you explain me how I change the ingame message .announce --> system message to .announce my nick ????? thanks :)

  108. 108
    online | Oct 20, 2007 at 1:26 / 1:26 AM | Links to this comments | Reply

    DBC Files extracted from WoW 2.2.3 enUS Client rapid link please :(

  109. 109
    Sully | Oct 20, 2007 at 2:33 / 2:33 AM | Links to this comments | Reply

    Hey reaper, nice site... I am in the middle of installing WoW and WoW BC on a computer (so i can extract the maps) then i will delete WoW and set up my server!! (if you can let me know when your going to release the next package, cause I can't wait!)

  110. 110
    Sully | Oct 20, 2007 at 3:11 / 3:11 AM | Links to this comments | Reply

    and sorry for the double post but, after I extract the maps and the database files, how big will the maps, vmaps and dbc directories be? cause i am low on space

  111. 111
    Sully | Oct 20, 2007 at 4:50 / 4:50 AM | Links to this comments | Reply

    and since no one posted about it yet, when I extract map files do i need 2.2.3 or can I just use the regular WoW TBC? (like 2.1.3)?? Please, someone post and tell me!

  112. 112
    xXWoWXx | Oct 20, 2007 at 5:38 / 5:38 AM | Links to this comments | Reply

    still won't work now it says my thing when i type select * from realmlist; then it says that i set my ip to YOUR DESIRED REALM NAME | YOUR LAN IP
    HELP!!! and i still get teh same message when i do the 'harder' way that u told my it still say incorrect sql please use the manual that came with your mysql version to fix this problem HELP MEEE!!!!!

  113. 113
    wow | Oct 20, 2007 at 6:44 / 6:44 AM | Links to this comments | Reply

    i download the reaper thing and started reaper-mangos.bat and when it asked me for the root password i typed it in (i had to change it to another one) it gives me a bunch of number without stopping.

  114. 114
    xXWoWXx | Oct 20, 2007 at 7:38 / 7:38 AM | Links to this comments | Reply

    I have just ran the reaper-x-mangos.bat and it says cant connect to mysql server on 'localhost' when i try to use the #5 option to set up fro lan party. Help again...

  115. 115
    xXWoWXx | Oct 20, 2007 at 7:42 / 7:42 AM | Links to this comments | Reply

    OMFG NOW IT WONT EVEN LET ME TYPE MY ROOT PASSWORD TO LOG ONTO MYSQL! HELP ME PLZ!!!

  116. 116
    xXWoWXx | Oct 20, 2007 at 7:48 / 7:48 AM | Links to this comments | Reply

    ... it will not let me sign on to mysql and when i try to start a new service it says cannot restart service error 0 so.. help or not.? if u r i need it soon bcause none of that other stuff worked and now it's just being gay saying i cant log onto mysql. HELP!!!!!! FAST!

  117. 117
    xXWoWXx | Oct 20, 2007 at 7:49 / 7:49 AM | Links to this comments | Reply

    Now it wont even let me run my server.. this is being stupid i really hope u can help me SOON!

  118. 118
    wow | Oct 20, 2007 at 8:27 / 8:27 AM | Links to this comments | Reply

    ok well it did stop and says at each line with this */ . does that mean its finished and the installation worked?

  119. 119
    Sully | Oct 20, 2007 at 8:45 / 8:45 AM | Links to this comments | Reply

    ok, i finally downloaded it and installed WoW... it took like 5+ hours... what a waste... :-(

    I installed wow and connected to a private server just so it could make all its files, ok everything was good, then I copyed ad.exe and the extract bat file thing and opened the batch file (the one that runs ad.exe and makes the maps folder)...

    It made the folder and loaded the files, but as soon as it started to proccess the files a windows error came up: Ad.exe has blah blah blah...

    i am unhappy....

    in case it matters I am on Windows 2000 Pro. with all updates on a 950MHz 512 Ram computer

    please explain what I should do, I ran repair.exe like 3 times and it still had an error with I ran ad.exe again :(

    please help me

  120. 120
    Sully | Oct 20, 2007 at 8:47 / 8:47 AM | Links to this comments | Reply

    ****typo, with (in the last sentence) should be when

  121. 121
    wow | Oct 20, 2007 at 9:51 / 9:51 AM |