Reaper Mangos 5472 - Easy WoW Private Server for World of Warcraft 2.3.3
By Reaper-X on Mar 23, 2008 in Reaper Mangos, Reaper Mangos Mod
I think the previous release of Reaper Mangos that is released 1 month ago can be considered as outdate, and … so i decided that perhaps a new Reaper Mangos release for WoW 2.3.3 version probably will be better although there’ll be new patch coming up from Blizzard (based from the Blizzard announcement displayed on WoW Launcher) … but well … even if there’s new patch you can always revert back to 2.3.3 or create two world of warcraft directory just in case you also play on official server ;)
Like the previous release this new Reaper Mangos 5472 include auction house bot to automatically populate your Auction House with random items, and also multithreading maps that probably useful especially to those who are using dual core processor, and of course also contains the latest available Scriptdev (297), and World Database from UDB and PSDB (UDB 343 and PSDB X9) or in other words dual database and finally i also include the previous Custom Vendors just in case someone use it :)
But since there are too many changes too be listed from the last release, i’d suggest you to backup your character data first before running the upgrade process (to those who are upgrading their installation but if you’re installing for the first time, you can just ignore this), just in case something goes wrong :)
Download:
- ReaperMangos5472 | 18.5 MB | Megaupload
- ReaperMangos5472 | 18.5 MB | Rapidshare
- ReaperMangos5472 | 18.5 MB | Mediafire
Optional Download:
Fresh Installation Instruction:
1. Make sure your processor support SSE Instruction, if you don’t know what is SSE all about, you just need to know what processor you’re using (Open System Properties via Control Panel, or press Windows Key + Pause/Break) and basically if you’re …
- running at least Pentium 3 (Intel Processor)
- or running at least Athlon XP (AMD Processor) or newer AMD Duron series but not AMD Thunderbird
You don’t need to worry about it :)
2. Make sure you have .NET Framework Installed (grab it from Microsoft website) or you’ll get error message saying The application failed to initialize properly (0xc0000135) when you run it
Note: if you have fast connection speed you can choose to download the .NET Framework 3.5 (197 MB) instead of .NET 2.0 (22.4 MB)
3. When you have .NET Framework installed, all you have to do is just read my previous post about Reaper Mangos Installation Instruction (i’m really sorry i haven’t updated it yet to reflect the changes made since Reaper Mangos 5225)
But basically all you have to do to install it is just run reaper-x-mangos inside reaper-eazy-mangos directory, and then choose option 1 to install it, and then continue with option 4 to configure the data directory and you’re done :)
Upgrading Instruction:
1. Choose to upgrade from reaper-x-mangos menu
2. and then don’t forget to choose the current database you’re using in order to upgrade it
Important Note to those who are upgrading:
If you have made custom items, tele, etc. AND using PSDB as your database make sure that you backup the custom items, etc. first because it’ll overwrite your world database but if you’re using UDB as your database, then it’ll automatically gets upgraded (but to be safe, backup your custom items first)
Switching Database:
All you have to do is just choose option 7 on reaper-x-mangos and done :P … but please note, switching database will overwrite any custom items you’ve made
Misc. Section:
Set up Mangos as Windows Service:
In order to set up mangos to run as service (windows), all you have to do is just :
1. Open Command Prompt
2. Change directory to where mangosd.exe and realmd.exe can be found (for example C:\ReaperMangos5472) by typing :
cd C:\ReaperMangos5472
or
cd /d C:\ReaperMangos5472
3. and then to install the realmd.exe and mangosd.exe as service, you need to type these:
mangosd.exe -s install
realmd.exe -s install
to install it as windows service … or type …
mangosd.exe -s uninstall
realmd.exe -s uninstall
to uninstall / remove it from windows service
OR if you prefer a more direct way of doing it … you can type:
C:\ReaperMangos5472\mangosd.exe -s install / -s uninstall
directly without changing directory first
Well i hope i’ve covered it all and didn’t miss anything … but if you still have any question feel free to post your question below or at the forum :)
as a side note, the GM Commands page has been updated too, so don’t forget to check it out if you’re looking for the easiest way to lookup GM Commands in Mangos ;)
As a last note, if you get a virus alert from your Antivirus saying that reaper-x-mangos.exe is a Trojan, Suspicious File, Malicious File, etc. You can ignore that message, i guarantee that file is clean and that is a false alert / alarm generated by your antivirus software. And you can always send that file to your antivirus vendor so they can inspect that file directly
Website RSS Feed
Stumble this post
Bookmark this post on Del.icio.us
Submit this post to Digg
Submit this post to Reddit
Print this
Trackback URL
nice thanx you are the man
Thanks Reaper!
Good stuff!!
Working great this is sweet Reaper…
Awesome release…2.4 is coming soon new instance and tons of new items…looking forward to the reaper version of it!
Wow. Excellent release!
Very easy to use.
Upgraded VERY smoothly from 5225.
The performance is a nice improvement.
Thanks Reaper……very easy to upgrade from 5225.
Keep up the good work
my keeps saying it needs to download patch 2.4 and has tryed it a few times though.. but im still on 2.3.3 :P
Thanks guys glad to hear it works fine :)
Queston I dont know if this is on the right post But.when I follow the Old instruction its completly diffren it telles me to give hte name of the data base or jsut put in enter iam confused on what to do when I get to the end X( On the Wow Private server Guide
Having a problem with these exe’s and vista. It doesnt work. I run the exe, I enter my sql directory, the window closes.
Any ideas?
posting bats instead of exes?
Well, I screwed it up the first time, so just deleted everything and started a fresh install. It’s all working EXCEPT when I went to set up the auctionbot… I created the account, and a character, and logged into it fine, b ut when I went to set it up in reaper, I get:
What is the username you’ve created for the auction bot purpose ?
auctionbot
+—-+————+
| id | username |
+—-+————+
| 7 | auctionbot |
+—-+————+
Now what is your character id ? (see the above number)
7
ERROR 1146 (42S02) at line 1: Table ‘characters.character’ doesn’t exist
Press any key to continue . . .
Any ideas?
actually let me clairify.
I am running WInDOWS VISTA Ultimate x64
I have all updates, includeing frame 3.5
Duo2 Quad 2.4 4g ram
I am running a previous version of mangos but not the 5224 (I couldnt get that one working either)
What happens is that I run the exe, I enter the needed path, the cmd window closes.
I’ve ran it as admin with the same result as well as in compatibility with_x.
The CMD window closes.
I’m out of ideas. Anyone have suggestions?
Thank you so much!!!!!
I’ve been working on this for hours over 3 days but I was using the wrong Mangos version finally it has worked.
Reaper-x you are a god!!!
Hey Reaper Great Job….But One Tiny Problem, The Auction House Bot Doesn’t Work It Says Characters.Character doesn’t exist. But In My DB Under Characters There Is Character Which Is The Correct Path. What Do I DO?
Please e-mail Me Some one ktuite@hotmail.com
please help me on this……
Thanks,
Kyle
Looks very good here A+. I get a bunch of these weird errors while launching mangos. Any idea what the impact/cause/fix for these warnings would be?
Item (Entry: 32048) has wrong ExtendedCost - CondExtendedCost pair (1431, 52)
Top of my wish list remains these few things:
More blizlike scripting for instances
Some sort of “teleport guy” so instead of making portals everywhere so we can just spawn the tele guy wherever we want to have transport to all the other spots available.
Any custom instances (to make up for missing or lacking blizzard instances scripting) if anyone has any info on that sort of thing.
@Kyle: The Characters database had a table “character” which was renamed to “characters” with this release. If you still have a table named character it is probably because you backed up your character table and restored it. If this is true then you need to apply the char-up.sql to get it to apply the database alter/upgrades again. ;)
Thanks, But Here’s The Error Im Getting
Choose your destination
6
What is the username you’ve created for the auction bot purpose ?
+—-+———–+
| id | username |
+—-+———–+
| 5 | kyle |
| 6 | archangel |
| 7 | ahbot |
+—-+———–+
Now what is your character id ? (see the above number)
7
ERROR 1146 (42S02) at line 1: Table ‘characters.character’ doesn’t exist
Press any key to continue . . .
this is the problem i need solved
One last weird thing I am getting. It doesn’t seem to ‘like’ custom items. I had one item like a starter sword and an elastic dufflebag which is still on the people that already had the item. But it wont let me additem to give it to anyone and same goes for the playercreate_item info it wont give it to any new people being creaetd weird behavior like that on custom items.
@Kyle: I went into the characters table and visually noted the account and guid of whatever character I had previously setup to be my auctionhouse bot and plugged those into the CONF file manually and it’s working perfectly including the random AH populated items. Sweet code BTW hat off to Reaper for this little very Blizlike randomly populated AH! Excited to see what it does over time. Do new items appear to keep it always full (I expect so).
Reaper - once again thanks for your work!!!
I know you didn’t post them here, but can you point me to a site that has the list of upgrades to the game with the latest scriptdev changes, etc.
Thanks!
Here is a vendor I made for gadgetzan who sells green level 40 gear find him behind (his twin brother) the tailoring vendor on the hilltop. Paste the text after the begin copy paste line into your SQLYog and hit F9 or save as an SQL file and import/run it.
=============begin copy paste after here===========
USE MANGOS ;
INSERT INTO `creature`(`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (75359, 75359, 1, 0, 0,-7123.3,-3704.4, 14.045, 5.565, 900, 0, 0, -7123, -3704, 14.045, 5.565, 9800, 100, 0, 0);
INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime) VALUES
(75359, 8187 ,0 ,0),
(75359, 8189 ,0 ,0),
(75359, 8198 ,0 ,0),
(75359, 8191 ,0 ,0),
(75359, 8185 ,0 ,0),
(75359, 7491 ,0 ,0),
(75359, 6425 ,0 ,0),
(75359, 15614 ,0 ,0),
(75359, 10026 ,0 ,0),
(75359, 10003 ,0 ,0),
(75359, 10024 ,0 ,0),
(75359, 9999 ,0 ,0),
(75359, 10001 ,0 ,0),
(75359, 10027 ,0 ,0),
(75359, 4736 ,0 ,0),
(75359, 6407 ,0 ,0),
(75359, 4061 ,0 ,0),
(75359, 4738 ,0 ,0),
(75359, 4063 ,0 ,0),
(75359, 6431 ,0 ,0),
(75359, 4737 ,0 ,0),
(75359, 4062 ,0 ,0),
(75359, 6430 ,0 ,0),
(75359, 8192 ,0 ,0),
(75359, 9285 ,0 ,0),
(75359, 9286 ,0 ,0),
(75359, 9287 ,0 ,0),
(75359, 9288 ,0 ,0),
(75359, 9289 ,0 ,0),
(75359, 9290 ,0 ,0),
(75359, 9291 ,0 ,0),
(75359, 9292 ,0 ,0);
INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`,`attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`,`rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`,`RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (75359, 7216, 0, 7216, 0, ‘Raid Max’, ‘Level 40 Armor Dealer’, 50, 50, 9800, 9800, 0, 0, 1, 474, 474, 130, 1.2, 0, 116, 155, 0, 474, 1510, 1661, 0, 0, 0, 0, 0, 0, 0, 66.44, 91.355, 100, 7, 1, 0, 6568, 0, 0, 0, 0, 0, 0, 0, 0, 0,0, 0, 0, 0, 0, ”, 0, 3, 0, 1, 635, ”);
Chris K is the maker of the ahbot so hats of to him, and also to the people over at the magosproject , they are the ones who do all the hard work , all reaper does is pack a pack for people who cant use a database .
You lot should really make your own compiles
Hello Reaper,
Just want to say thanks for the wonderful work once again and keep up the awesome work! This is truely a dream come true for me ever since I started WoW I always wanted to have a offline private server version. Just a few note.. I been trying to find out more on how to edit or make coding adjustment to it but haven’t learned enough to do so yet.. I did noticed the following:
1. Magic seems to be not do any damage from Enermy NPC. Mainly the ranged effect one. ex. Human Mage’s Fireball, Spider’s Web Shooting. Forgive my lack of knowledge on this one but is that always how it is? Haven’t read anything regarding this.
2. Is there a way or how can you add a changable perimeter in the mangosd.conf file to change the Ghost Form running speed? Reason for this is because sometime I run into a few bugs and when I reenter the server from logging off it shows me as dead.. Was thinking it would be nice to be able to run back to my body quicker.
BTW: I think its really nice to be able to find a server that is nearly as complete as the original.. Personally I don’t like to mod things much… And amazing work you have put into this project as well as the up to date effort.
Please let us know if there are anything else we may do to help..
Thank you and have a wonderful day Reaper. Looking forward always to see your work grow with our WoW..
Best Regards,
Revi
Hello all,
What restarter and auto-backup tools you everyone been using? I have been looking for days and still have not found one that works well with Mangos.
I have found a few for Ascent. I did found a restarter that works, but the backup part does not.
Thank you
Saktron
This is so weird. I can eventually probably fix these items by building new items. I thought at first it might be they didn’t like that some had the script as internalitemhanler and not internalitemhandler with a D. Still wont work though. I fixed the missing bag item by copying a plain primal mooncloth bag and not a custom one.
It still won’t add a simple 12-22 dmg weapon which I can lookup in the lookup item and view it as a simple normal one hand item 7.4 dps and all that would be expected of a basic weapon.
When I try to addietm the item it says cannot create item 44810 (amount 1) the debug message on the mangos screen says
STORAGE: Can’t create initial item 44810 (not existed item id) for race 8 class 4 , error msg = 0
Is it trying to put initially created ietms in their hands and maybe the worn dagger or something is already there where previous versions jsut put them in the bag? No that cant be it or the manual .additem would work later when I tried it and this still fails.
@Saktron: My backups (BU) are just SQLYog exports which are saved as “sjasession.xml” files which are then run from my windows desktop Scheduler. Very easy. Could easily add a rar/zip batch to occur prior to each back to keep prior days stored by day of week or something but I for now overwrite last backup with new one each time and only BU once per day. This simplified automation batches is one reason to recommend SQLYOG.
Mangos doesn’t ever crash for me but I never have more than 5-10 friends and family on there at once ever so it’s probably just me. When I had a restarter it seemed to work fine. it was named restarter.exe created Feb/9/2008 was619k in size. But with no crashes it got very light testing (like manually closed mangos.exe and it launched it again).
Thanks Informative,
I have restarter that works, but like you said, most of my crashes are from me just closing mangos after I have been working on my config file or updating. Reaper-X runs very well.
I just had a scare when I thought my harddrive crashed, and I had been using the Reaper-X to do my backups, and all my backups were in the the Reaper-X folder still.heh
I was using Navcat, and couldn’t get the scheduler to work right. I have Sqlyog also and will give it a try.
Thanks Informative
Saktron
hi,
just wondering, do we download all three of the links or just one of them?
cheers
#chrisg
only one of the links
#Reaper-x
as you havent given the links to the vmaps and maps from 5225, im going to prosume that new ones are needed and so im going too extract them myself and post links up for the enGB one’s as i dont have US warcraft
Steve
all of the dbc, maps and vmaps are into my upload. each of my uploades comes in 9 parts, 8 are 100mb and the ninth is about 57mb. Uploding to the first mirror now, mediafire. Want more mirrors?, just ask! or email me steveya@steveya.tk
more info when first mirror is finished
Emm…. u dont need new Vmaps and dbc
:P
Works fine with previous ones; since it needs 2.3.3 as well. At least works same for me
:)
does it work for 2.3.0????
#squall5668
oh well, ive done it now.
#john
2.3.3 only
#reaper-x
http://www.mediafire.com/?sharekey=5104e3f9bab22a538c9e7c56ba37815f2f61e4805bedc005 and follow these instructions:
download all the files to the same place, open and extract - enGB dbc, maps and vmaps.part01.rar - and it’l do extract the rest for you.
I just wondering if anyone could help me with eventai_scripts. Everything works fine exept action set unit field. For example im doing
/*
REPLACE INTO `eventai_scripts` VALUES
(NULL,51000,8,100,0,0,17,
34,20,1,2,
1,0,0,0,
0,0,0,’Booster Killed’,0,100);
*/
It Yells the text on die but not modifying targets level. And i tryed update value ingame, it works fine. Just somehow monsters not doing this. Maybe it must be some NPC who allowed to modify players values or something? Please help me or send me to right forum where i can get some info about this. Thank you very much if someone can handle that for me.
ok ive manually plugged in my AH Bot’s info in the
mangos.conf when i turn on mangosd.exe it loads it says thats it loaded all the items, but when i log in nothing is in the Auction House….. Some One Help me my server is set to go public next weekend
lol nvm igot ti working thanks reaper and informative u guys rock!
Hi, nice work reaper, as always,
I never had any problem whit your previous releases but in this one i cant log in and i get the same error from every account:
SQL: SELECT sha_pass_hash,id,locked,last_ip,gmlevel FROM account WHERE username = ‘TYRAEL’
query ERROR: Unknown column ’sha_pass_hash’ in ‘field list’
Any ideas for this error ??? :s
I downloaded and tried out the new 5472 it installed fine with no errors. I am also getting the same error as Tyrael.
SQL: SELECT sha_pass_hash,id,locked,last_ip,gmlevel FROM account WHERE username = ‘martian’
query ERROR: Unknown column ’sha_pass_hash’ in ‘field list’
It will not allow me to log in or even create A new account with mangosd.exe nor delete. So I had to downgraded back to 5225 and it is working just fine, but still not able to use my old characters. It is like they disappeared. Only I can find them all in the warcraft files under c:\wow\world of warcraft\wtf\accounts. I did backup my character data then upgraded, modified, and restored as previous versions using reaper-easy-mangos. This one tells me that my account and password are incorrect. Will not allow me to log in. So back to 5225 for now have tried to upgrade 3 times with the same issues.
mArTiAn
@Tyrael: The 5225 characters are in a completely different table from the 5472. It was actually renamed:
database\table
from characters\character
to characters\characters
So what you need to do is look for the upgrade folder and inside there you will see a script like char-up.sql OK so after you restore your characters you will need to run this char-up.sql script to er-convert it to the new format and table name. Hope that helps and makes sense. Worked like a charm for me.
Oh yes if you get an error trying to RE-Convert your characters it’s probably because you have to delete the characters and groups tables so it can RENAME them again. If you through the process created the new characters and groups tables and restore your old character and group table it can;t rename the old tables to upgrade them again because you’ll get an error that the destination table exists so can’t rename to that… right?
sha_pass_hash is a new name for the password field looks like to me. (guessing but good chance this is accurate). Used to be something like “I” or something which made less sense so I guess they changed it. Now like with the other problems you will need to apply the upgrade script to this database as well to properly format the accounts table and stuff to the new format. Same as with the Characters upgrade.
Testing through it. My favorite bug remains. The one where if you make a Warlock and do like .tele orgrimmar and .level 40 and go try to train, the trainer starts trying to feed you life tap (1) or fear (1) which you already have and you have to manually click each spell to get the ones available to you. just in case anyone out there is working on keeping track of whats still broken. This ones is a favorite of private server complainers. I hate when they complain. =p
Sorry if I post a lot and seems like spammy. Just hope some of my posts are helpful or informative.
I DID get it to crash by turning on like .mod aspeed 30 or something super fast and zooming around and finally bam it crashed! =P
Think it is first ever for Mangos. Some people say Ascent is better for raids and 100+ users. Ha like thats ever gonna happen on my server. =) Don’t think so unless a T1 Santa comes to my door.
@everyone with this issue
@reaper
what really bothered me is that i had to freaking manually change SQLyog to make the passwords work…
if u want to fix it u can do it this way
go into SQLyog
go to the DB realmd
then right click on account
click alter table
then at the bottom where there is a blank space
double click there and type in sha_pass_hash
then change the next column (datatype) to medium text
and then click alter table
it worked for me after that
however it really is annoying that i had to do it manually
Thanks informative I’ll give that A shoot as soon as I can.
Ive searched and search for answers on how to fix this but cant get it done. What happens is i get everything installed, the server works, i can create a char and play it blah blah blah. Yet my problem is that once i create a 2nd char or other accounts i can no longer see any characters in ANY accounts. Then once i delete all accounts but 1 i can see those chars again. Can any one help me :(
Very good repack!
Although I do miss the option of setting the droprate for each quality-class items individually in the MaNGOS Config file like in 5225.
Will it work if I manually add in the lines of code in this version?
Thanks guys!
@ inform or reaper,
Is there anyway that I can upgrade to the new 5472 and just recreate accounts. If I try to do that now it gives me the same error. Will not allow me to even create A new account to try.
@ night
Are you using SQL 6.0 or 5.0?
This problem has happened with 5225 and people were using 6.0 and not 5.0.
Hey reaper at the very top of ur guide or speech thingy (lolz). You cant really create 2 dirs for world of warcraft unless u edit the registery. i have the reg keys indeed but i cbf putting em up on megaupload,rapidshare w/e cause my bandwidth is low and it will prob take ages.
Yea a lil pointless post but i guess its better than nothing xD
well, i’ve stumbled my way through three versions of reaper mangos, and I have to say this is the shiznit, but you already knew that ;> Problem is realmd and mangosd are closing with an error right after they open. Had the same problem with oatman’s version (4116?), but 5000 series were working fine until this one. I do not have a SSE capable pc… kinda suprized anything ran on my OLD 700mhz pc133 POS in the first place. Can’t afford a new one, so that’s OOTQ. Just curios if it’s the SSE that’s causing the error, and if you plan on using it for all newer versions you’re going to make. BTW it seems last time the only things I did to fix it before was upgraded .NET to 3.5, and changed to Igor Pavlov version. Can’t upgrade .NET any higher, and this is a Igor version. Couldn’t find any help last time, so I’m throwing this post on for anyone else having the same problem. Thanks again!
Bonehead don’t think it’s the SSE giving you the error problem. I don’t have SSE either and still using .net 2.0 and mysql 5.0 and don’t have any issues. Running on P II 2.1G, 1G DDR ram. Never had any loading issues and surprised 5225 works, for ya, if that is the one your using. You may try to upgrade more RAM that might fix the problem.
dam I need to upgrade my .net lol ‘o well it works
carefull people blizz just patched today ill prolly wait for next mangos release
what is the sword the skele is weilding the fire one? =P
Hi, does anyone know how to manage the skill rate increase when in game (defense, dagger, sword, etc.)? My skills are raised almost on every kill and I think the rate is too fast.
@Dave: “Re:carefull people blizz just patched today” (shrug) Patches are for retail Wow playing. Mangos is as I understand it not obligated or under any urgency to keep up except perhaps when a really cool new feature is released to retail that they really WANT to get it included.
@bonehead. If I have problems I do as follows.
Backup characters and realmd DATABASES
rename c:\Mangos to mangosMMDDYYwhatever
Create a new C:\Mangos
Install everything
Test it is working in 127.0.0.1 IP mode to self
Drop Characters Database (not just table)
Drop RealmD Database (not table)
Restore from backed up databases from step 1
Run the char-up.sql and realm-up.sql
Update all CONF files for lan/inet play
Reinstall any custom items/vendors/portals
That’s about how my upgrade went. It requires a little competency with SQLYOG or similar tools to understand what each step is calling for here but if you grasp most of what this is saying, and have maybe one or two questions. Throw the ??’s here I will help if I can.
The renaming Mangos directory is mainly to ensure old DLL’s are such are out of the way. I’ve had those cause problems. I’ve also had problems with MySQL which were resolved by dropping the database entirely and recreating them.
MySQL also LOVES it when you completely uninstall it and delete the MySql data folders and reboot then install it and reboot then configure it and reboot. Yes rebooting each time. Then reinstall the databases after all of that. Don’t ask me why, but might explain why it’s free.
ok since this recent patch, everytime i go to log into my server through the WOW log in i get this message: Unable to Validate Game Version.
any suggestions or tips on how to fix this. Ive tried deleting and reinstalling everything.
Any one having a problem where when you make new accounts, they never work. They’re in the database but when you try to login, it says incorrect username / password. My first account works but none of the new ones do.
i have a problem. The server works fine butt not the sql! i use minimanager to create accounts and it doesen’t work it says “Unknown column ‘I’ in ‘field list’” something must be wrong with the sql!
Thx man this Version Fixes alot of bugs on my server mate if anybody needs help setting Reaper mangos server add me on MSN od_haste@hotmail.com
Ok can this new release help me edit the world database as much as i like cause i really wish to chnage most things from PSD …. Also in PSD i notice they added some npc whom channel spells but it doesn’t cast it just continues casting …ect AT a portal looks wicke di wish to add them to the GM island also i wanted to add the floating rocks/tree from outland to gmisland i am getting the hang of working with mangos just wish we could edit the world more :-p lovely release btw i’ll update and check it out…
GUYS I MADE A GLOBAL FLYING MOUNT FOR REAPER-X MANGOS 2.3.3!!!! Heres D-link
http://www.mediafire.com/?vpb0jvz1bne
All credits to me =]
gotta have gm on atm to use it in azeroth =[ but im fixing it now =]
I heard of this server company from a buddy at work the other day. He runs web servers and mentioned setting up a dedicated Wow server. He recommended ABMX.com ’cause they’re really low priced, and they do live over-the-phone tech support. No indians! lol ya thought i’d mention it…
Not something wrong with the SQL, something wrong with your editor. There’s been changes in the DB layout, you need to find a fix for mangosmanager
@Agusdfnjs: The “I” field if I guess correctly was the password field which was renamed to sha-hash-pass. New name which seems to make more sense for a password encrypted field than just “I”
Thanks for the sweet mount will add it.
My other favorite mount for GMs is still
.learn 26655
then macro .fly on
and click or macro cast the instant mount spell.
No cast time
Of course GM can always .mod aspeed 7
or whatever and don’t need a mount.
and btw it has no cast time it is a trinket as soon as you equip it with .gm on then youw ill automatically be mounted and im adding the DND++ mount speed spell to it as well so it is instant on equip
I added the new griffin mount to my Gadgetzan vendor says 300 some odd gold and I have enough gold but when I try to buy the item it says the item was not found. Tried manually adding with
.additem 304561
Can’t create item 304561 (count 1)
I’ve had lots of problems with custom items in this release
@informative try going into the DB and changing the spawn number to a 3 or 4 digit entry becuase it might be that your DB isn’t reading the entry item correctly and this may be the reason since on my server im using project silvermoon DB which allows high item ID exceptions try backing up your Character DB then importing into the Project Silvermoon DB and try that if option 1 doesnt work
The problem to your issue, is the IP address you had set in your database.
It demand alot on your setup for WOW server.
Are you using another PC to access the WOW PC? If you are, you will need to configure the IP address of your database to the router.
@martian Thanks but I do have 1gb ram
@informative Thanks as well, I haven’t messed with sqylog yet, guess it’s about time. btw, I rebuilt the DB again with Ver. 5225, and it works fine. Seems like for the new version, it’s not even loading the realmd.exe file… I’ll try what you said though, much appreciated guys!
hello reaper i got a larger bug here…. my server was not running uptimal because i cant make more accounts whitout my client makes a little thing… it makes my characteres go away if i got two accounts
Ty i did it work when i changed I to sha_pass_hash <3 REAPER-X
why did you change so much database name’s all is wrong the site is not compatible with the sql :(
# Those who are having problem with Realmd table
I’ve been trying to replicate the problem by fresh installing 5225 and then upgrade into 5472 but the realmd table gets updated too (which means i dont see any problem at all because the realm-up.sql that changes the ‘I’ column into ’sha_pass_hash’ in realmd table gets executed) :(
btw here’s the code:
ALTER TABLE `account` CHANGE COLUMN `I` `sha_pass_hash` VARCHAR(40) NOT NULL default '';UPDATE account SET username = UPPER(username);# revan666666
are you running mysql 6.0? :) if so try running mysql 5.0 instead ;)
# Those who keep getting Unable to Validate Game Version message
That means you are not using compatible wow version (in this case you’ll need to use wow 2.3.3 only because that’s the only version supported in this release) ;)
what if i have the WoW 2.3.3 enEU DBC patch? does it still work? (european version)
I have an interesting problem. I have the second realm up and running, and when I log into wow, I can choose either realm.. The problem is that when I log out of one realm, and it takes me back to the character list, and I click change realm, it just says retrieving realm list. It will not bring the list of realms back up until I completely exit wow, and log in again.
Any ideas?
oops….wrong forum…sorry
If i update this from the “old” version 5225, will it delete all the objects i have spawned too??
Reaper i realy hope you read this i have tryed to contact you for some time about this but can you do a special favor for me… its about a WSG emu… i hope you can help me… i think you have my mail:D please write me
2.3.3 wow extracts still available @ http://rapidshare.com/users/38S1XZ
I’ll be uploading the new 2.4.0 extracts tomorrow.
When will there be some new Edition for 2.4.0.8089
@ freze, this versionis only 3 days old, first give the man a break, then pound his head for a new version :)
Can’t pretend I’m not curious too for the 2.4 server :)
I’m a bit baffled. I’ve been trying for over a month now but can’t figure out a way to find what a player’s level is based on the DB. Does anyone know? Is it a calculation passed on “leveltime”?
Thanks,
shinzon
Can some one tell me step by step on how to set up the AUCTION HOUSE BOT are the only setting i got to mess with AuctionHouseBot.Account and AuctionHouseBot.GUID ??
i made a acount for the bot. dose it got to be loged into game to work ? are there commands i must enter after and if i got to join the game ?
and has anyone had luck moving acounts from 5225 to 5472 ? i not had not luck… i get error after error
Yes, I too had problems migrating the accounts from 5225 to 5472… but my problems were related to the fact that I was updating three realms and had to restore the REALMD database each time so that it would upgraded each time… long story.
Updated today to 5472 and all went smoothly. I have also updated an old 5116 installation up to 5472, with no problems at all.
Thanks Reaper for this new, great update… but can’t wait to see 2.4.0 me too :)
yeap great job reaper once again hi could anybody tell me how to make a custom portal im trying to make a portal to a whole new place
Hi reaper, first of all, tank you very much for your work, well done mate :)
i’ve a question:
How can i change one npc from normal to elite?? (The rank of the NPC ( Elite, Rare Elite etc )
thanks again for everything :-)
If i update this from the “old” version 5225, will it delete all the objects i have spawned too???
Here is the tank I use now for level 40’s instant cast but no flaying. The instant cast is addictive though.
I think you can chance replace to INSERT for adding it first time or maybe it’s already in there not sure..
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `ExtendedCost`, `CondExtendedCost`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `Duration`) VALUES (51019, 15, 0, -1, ‘Black Qiraji Resonating Crystal’, 33967, 5, 64, 1, 0, 0, 0, -1, 1791, 40, 40, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26655, 0, 0, 0, -1, 330, 3, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, ‘Summons a rideable Black Qiraji Battle Tank’, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, ‘internalitemhandler’, 0, 0, 0, 0, 0);
First of all, great job and thanks.
Is there some way to fix the pet’s issues? (hunters and warlocks)
Hi guys, please a help…
there is someone who has a german client and can share with me the dbc data?
I suppose that this is the data for the quest text in german language…
Please…
ThankS!!!!!
@ LEMON
I don’t think your spawns will disappear. I spawned some instance bosses here and there and they were still there after i updated.
Well its more if my objects like chairs and tables i’ve spawned will dissappear.
nvm, i switched database anyway….well now i got a new problem, how do i get the auction house bot to work, i’ve put in the GUID and all that but when i log in there’s nothing in the auction house?
uh nvm i got that to work also :P
Read your mangos.conf file and right at the end you will be able to setup your auctionbot manualy if you know your account and character id’s
Cheers
Hi, first of all, Thank you Reaper-x for making this awsome package. now for the strangeness. Is anyone else seeing this error upon startup? (Mangos keeps working - but the message is there for a reason - yes?)
2008-03-27 22:18:51 quest_start_scripts :2008-03-27 22:18:51 ERROR:Table `quest_start_scripts` has quest (ID: 2755) in SCRIPT_COMMAND_QUEST_EXPLORED in `datalong` for script id 2755, but quest not have flag QUEST_MANGOS_FLAGS_EXPLORATION_OR_EVENT in quest flags. Script command or quest flags wrong. Quest modified to require objective.
I don’t see anyone reporting it yet. I only noticed it since I tried using log level 3 and enable log colours in the mangos.conf file otherwise I don’t think this message appears. Thanks.
Regards,
Kruge99.
hey reaper please or anybody know how to make custom portals
@Franken
Good point :-D
and now it seems that Mangos.exe is crashing when I exit the program and keeps writing out a massive log file until I press CTRL+C…
Revision: 5472Date 28:3:2008. Time 9:45
//=====================================================
*** Hardware ***
Processor: Intel(R) Pentium(R) 4 CPU 1.70GHz
Number Of Processors: 1
Physical Memory: 490224 KB (Available: 162608 KB)
Commit Charge Limit: 1148412 KB
*** Operation System ***
Microsoft Windows XP Professional Service Pack 2 (Version 5.1, Build 2600)
//=====================================================
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 004F922B 01:000F822B C:\darkhelm\mangosd.exe
Registers:
EAX:15B06F5C
EBX:00000000
ECX:0FE7D770
EDX:0B033F00
ESI:15B06F50
EDI:15B06F50
CS:EIP:001B:004F922B
SS:ESP:0023:0012FEC0 EBP:15B05EE8
DS:0023 ES:0023 FS:003B GS:0000
Flags:00010202
Call stack:
Address Frame Function SourceFile
004F922B 00000000 ?ChangeMembersGroup@Group@@QAEXPAVPlayer@@ABE@Z+29CB
147D7D88 00000000 0000:00000000
15B05EE8 00000000 0000:00000000
0CDE8530 00000000 0000:00000000
Got any clues anyone?
Regards,
Kruge99.
thanx for another great release,is there anywhere where you can find a list of what works and dosnt work in the udb and what script dev actually currenty has scripted,as far as i can tell you have to read endless forums ?
Hi
I have tried to upgrade from your latest release and tried a fresh install but at a certain point at the installation ReaperMangos just stops.
Please wait a while to import the datebase
press a button
Then it stops at the following line:
LOCK TABLES ‘creature’ WRITE
—————————-
—————————-
/*!40000 ALTER TABLE ‘creature” DISABLE KEYS */
When I wait for 6 minutes and then it shows a lot of numbers which end with 1200,100,0,1)
I know it is supposed to do that but after that it just stops.
With previous upgrades it did not take this long.
This happens at both databases.
What is there to do?
@bakaslayer
About UDB its easier to find what doesn’t work
…:P
About scriptdev2 u can find right here http://www.scriptdev2.com/index.php/topic,922.0.html
Do you think you (or anyone) could make a private server where everyone get GM powers? I can’t install all of the programs you’ve listed… It would be greatly appreciated! Or could you please make me a server? I know, it’s stupid of me to ask. Thanks for the guide!
When I start Mangosd.exe, I get a problem with the locales_** files. It says they’re empty.
Also, when I’m doing quests (such as “The Sun Gate” or any escorts), events necessary to complete the quest never happen.
Are the two problems related? How can I fix them?
-Derek
I just want to let Reaper know that I found a broken quest in this release. Nat’s Bargain in Tidefury says Item not found when you try to accept the quest.
I’m curious to know how this works in relation to the latest 2.4 patch just released by Blizzard. Is it possible to set up / install a SECOND copy of WoW that is only patched through 2.3.3? If this IS the case, I’ve been reading where people keep getting messages in the WoW client forcing them to upgrade to 2.4… how can this be disabled? Thanks for any feedback you can offer!!
u can if ur on 2.3.3 only use wow.exe in ur folder and erase patchlist XXXXX in your realmlist
@Russel: There are thousands of quests. You can monitor the Mangos boards silvermoon and others for occasional fixes to bugged quests. The amazing thing is MOST of them work. Haven’t tried the escort quests yet are they still all broken too? Probably.
@Hanns: Yes your Mangos personal playing version of Wow should be at version 2.3.3 and you should launch with the Wow.exe not the launcher.exe so it never tries to patch itself until you want it patched. Expecting people who work for free to write a hot fast update every Tuesday so we don’t have to keep separate copies of our RETAIL WOW and Mangos Wow is highly optimistic and very unlikely.
@Martin: I would read my message at top of this thread and try those things.
http://www.reaper-x.com/2008/03/23/reaper-mangos-5472-easy-wow-private-server-for-world-of-warcraft-233/#comment-89023<