Reaper MaNGOS 5953 with ScriptDev 414|Server Compatible With 2.4.2 (UDB ONLY!)
By Oatman on May 26, 2008 in Reaper Mangos, Reaper Mangos Mod
Hello Everyone! Here is another one of my releases for the Reaper-X-MaNGOS-WoW Developement Project. In this release I have looked through my previous bugs/errors and have cleaned them out and I am almost positive that they all have been resolved. So if you have any questions comments or concerns please leave us a comment, when you do myself and the community will be glad to assist you!
Updated in this Revision:
- Completely re-done fishing loot template.
- Fishing base skill level table added
- Lots of Black Temple updates
- Loot added for creatures that are mineable and gatherable
- Rewards added for quests with quest flags|512 (Quests like Teron Gorefiend I am!)
- Many quest fixes in general
- 175 fishing holes added (like school of fish) with loot
- Instance loot tables updated:
- Zul’Farrak
- Sunken Temple
- Black Rock Depths
- Dire Maul
- Black Rock Spire
- World drop loot tables for levels 1-34 created (SIGNIFICANT decrease in creature_loot_template size again. All world drop tables are now created. Loot table size before world tables ~950000 rows — after 284594 rows. ~7mB instead of ~22mB)
- Some 2.4.2 related item changes
- L70ETC spawns / event included in the DB (still need the ACID script from the ACID team)
- Fresh Installer Fixed!
- Map/DBC Extractors Fixed!
- ACID Included (Means Extra NPC’s and Such Have Been Scripted)
- MaNGOSD.exe Errors Should Be Fixed!
- Authentication Bug Should Be Fixed!
- Vendors/GM Island Vendors Should Work Again if you Enable them by Going Into the Reaper-X-Mangos.bat File.
- NO MORE EXE’s! I have decided to keep them in Batch format due to complaints about Errors/Trojans.
REQUIREMENTS:
1. MySQL Database and the Guide on how to Install MySQL
2. World of Warcraft Client version 2.4.2
3. Updated DBC’s, VMAP’s, and MAPS Updated for 2.4.2!
DBC’s are already included as part of this release! Also if you already have the 2.4.2 DBC’s, Maps, and VMaps then there is no reason to extract them again.
4. Reaper-Mangos Server :
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | File Beam
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Rapidshare
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Mega Upload
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Media Fire
Update:
Davtex from www.blitz.sk have uploaded vmaps and maps extracted from WoW 2.4.2 so to those who have problem perhaps can try downloading the extracted maps and vmaps files by Davtex ;)
2.4.2 Maps:
- http://rapidshare.com/files/120427182/maps.part01.rar
- http://rapidshare.com/files/120427405/maps.part02.rar
- http://rapidshare.com/files/120427402/maps.part03.rar
Vmaps from WoW 2.4.2:
- http://rapidshare.com/files/120495428/vmaps.part01.rar
- http://rapidshare.com/files/120495485/vmaps.part02.rar
- http://rapidshare.com/files/120495478/vmaps.part03.rar
- http://rapidshare.com/files/120495532/vmaps.part04.rar
- http://rapidshare.com/files/120495474/vmaps.part05.rar
- http://rapidshare.com/files/120495501/vmaps.part06.rar
- http://rapidshare.com/files/120495246/vmaps.part07.rar
Thanks to Davtex for uploading the maps and vmaps files
Custom Vendors Pack
http://filebeam.com/ba76aee3d934e0ab9d7e2f7c4d40452a
Credits to Firane for creating the Custom Vendors Pack
DBC and Maps Extractor:
Just in case the included ad.exe (map extractor) and dbc extractor isn’t working for you (like you keep getting message about maps or dbc file is not compatible), you can try using this one:
DBC and Map Extractor (131KB)
That archive just contain only one file (ad.exe) … and all you have to do is just put it into your WoW installation directory (where wow.exe and launcher.exe can be found) … and delete maps and dbc folder there if exist and then run the new ad.exe … and it’ll extract the maps and dbc files automatically (the output will be in maps and dbc directory)
Fresh Install:
Important Note : Fresh installation will overwrite your database
1. First you’ll need to install MySQL
2. Extracting Maps, DBC and VMaps from your World of Warcraft installation
(You can safely ignore the Patch-2, or any not found xxx-2 message)–This only happens if your extracting from patch 2.4.0
3. Run the reaper-x-mangos.bat inside the reaper-x-mangos folder, and you’ll see something like below image for an example, and then you just need to write the full path to your mysql installation directory (where mysql.exe and mysqldump.exe can be found) ;)
4. Selection Option 1 by pressing “1&Prime on the keyboard and pressing enter.
Note: This will wipe out any previous versions of WoW you have in your database.
6. After finished with all of the above process, all you have to do now is just open the realmlist.wtf file in your World of Warcraft installation directory (the default location can be found at C:\Program Files\World of Warcraft) using Notepad, Wordpad, or your favorite text editor and then …
Replace :
set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com
With :
set realmlist 127.0.0.1
and then save it and close realmlist.wtf File.
7. Now you just need to run mangosd.exe and realmd.exe from your mangos directory and then the next step would be creating your own username with your desired password for your own WoW server account as shown on below image followed by typing setgm to give yourself a GM level account
By the way, if you can’t see what you should type inside the mangosd window from the above image, actually you just need to type :
create username password
to create the account
setgm username 1-3
to give yourself GM Access at certain level (3 is the highest level and should only be used on your account while normal player is 0)
8. Finally if you have Burning Crusade client installed and want to be able to create Burning Crusade specific character, all you have to do is just type :
setbc username 1
to enable burning crusade expansion for your account :)
Optional :
If you want to change the server name into something else, you can use the reaper-x-mangos.bat to adjust it :)
Upgrading from 5953 Release:
1. Re-extract vmaps, maps and dbc because this version no longer supports the old World of Warcraft 2.3.3 installation and only supports the new 2.4.2 (YOU MAY SKIP RE-EXTRACTING IF YOUR DBC’S, MAPS, AND VMAPS ARE ALREADY FROM A 2.4.2 CLIENT!)
2. Go into your WoW Reaper Server Directory, and open reaper-eazy-mangos. Next I recommend opening the batch file and backing up your character data. This is optional though.
3. Open the Folder called “Upgrade” and run reaper-x-upgrade.bat.
4. Next type in the directory to the Bin Folder where your mysql.exe and mysqldump.exe files are located.
5. Then make sure that you are upgrading from the latest previous version or else you WILL corrupt your database and possibly lose your character data.
Guide on how to Edit Mangos.Conf
Thanks for the Mangosd.conf edit guide Jeremy!
First off make sure that you have your MySQL running before doing anything.
You need to go back into the reaper folder (C:\Reaper-X-Easy-MaNGOS\reaper-eazy-mangos)
And run the batch file called reaper-x-mangos, there is an option there to setup your LAN or IP for use, This new batch file does correctly setup your DB to the IP you enter in this batch file. Once you’ve done that, if you haven’t gone back in to edit the config files in your reaper folder mentioned above, you need to do that, there is a section in there with this.
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = “C:\Reaper-X\data”
This is an example of waht it may look like. You need to change this to the path where you put your data folder with the maps, vmaps, and dbc’s.
Second, …
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database - use named pipes at Windows
# Named pipes: mySQL required adding “enable-named-pipe” to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;mangos”
CharacterDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;characters”
Above, you need to change the MANGO;MANGOS to your root DB name, likey it’s just root, and YOUR batabase (DB) password (you should know this)
YOU DO NOT CHANGE THE IP’S here or in the realmd file, ONLY THROUGH THAT BATCH FILE, i mentioned above. (that file does it for you)
Next open scriptdev2.conf and realmd.conf and edit the info for them to connect to your database as well.
Hope you enjoy this release if you have any questions feel free to post them as a comment below!
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
Yay first =D, cant wait for the links
The only thing your latest needed was s4 and kil'jaeden loots but good job in upgrading :p
#Anderek
Yep they are on their way!
#Viktor
Yea those are in there yet I believe but they will be in there in a future release for sure. I mainly released this so early because of so many errors and complaints in the previous release.
Also not sure if you know this but there are no mobs in the sunwell raid, i was also having problems with more than one person getting inside of it.
#Anderek
Yea I am aware of that and there isn't any in this release either. Its more of a prep for when its ready.
OK LINKS UPDATED!
5953 IS NOW RELEASED!
ENJOY!
Thank you so much for releasing the rev 5953. how to transfer the old Mangos rev 3462's database to the new Mangos rev 5472 or higher? Please , help me!
Sorry but i am still getting this same error when i try to install
ERROR 1045 (28000):access denied for user '-p####'@'localhost' (using password: no/0
mysql: option '-D' requires an argument
Not sure why this repaer version gives me this trouble.. the other ones installed ok. Can you give me the order of the SQL.files and ill just import them
ok i got it figure out... what is different from this version and old ones is. Like where it ask what data base you like to use (MaNGOS) . I used to just hit enter it would use default with out me halfing to type in anything. Now its not like that. You got to type it in
I tried yesterday to add Brutal gladiator and the new Guardian parts myself but it didnt work, got some wrong bla bla at row 1 ... :<
i cant extract any of the maps i can extract the data but not maps my wow client is 2.4.2 fully updated and everything and im trying to do a fresh install anyone got some help for me? im nto fully sure how to do this
Follow the instructions carefully and it will work fine, a thing many people forget is to WAIT after vmaps_simple is finished (or not) until you get press any key to continue message.
i took the realmd and mangosd config files from reaper 5472 and put them in 5931 and it loaded fine
Exactly - it will sort-of look like the vmaps process has finished, but it is quietly going through the split-maps config and making the vmaps folder after the buildings folder has been created. IT TAKES A LONG TIME. Go mow the lawn (or someone else's if you don't have one), then take a nap, then come back and it should be done.
Maybe I'm doing something wrong but after doing a fresh install the GM island vendors aren't installing properly. It's telling me that the columns don't match. Any ideas?
Hello when i try to install the optional GM island vendors i get the fallowing error
error 1136 (21s01) as line 24: column count doesn't match value at row 1
and thats the best part i like... and clue of how to fix this ?
BTW Oatman,
If you are looking for better instructions for PSDB, there is a new 'how-to' post on the PS website. Longer read but better detailed. Maybe this will help you to include PSDB in your future releases.
Keep up the good work, you rock!
Ooops, forgot the link...
http://projectsilvermoon.net/index.php?showtopic=12566
i'm getting "ERROR 1045 : Access denied for user 'root'@'localhost' "
anyone know how to get over this error? i've tried installing older versions, but they give the same error.
i'm using all the default database names
That points to a wrong username or password to access the MySQL database
did you manually add your password to the config files?
ok all is good i got everything working but the gm island vendors any ideas on how to get that installed..and does anyone have a guide ro anything to make this public so like if my friend across the country wants to connect to it he can style u know what i mean?
i logged and restarted realmd and got this
2008-05-26 00:42:54 ERROR:SQL: UPDATE realmlist SET color = 0, population = 0 WHERE id = '1'
2008-05-26 00:42:54 ERROR:SQL ERROR: Table 'mangos.realmlist' doesn't exist
2008-05-26 00:46:15 ERROR:SQL: UPDATE realmlist SET color = 2 WHERE id = '1'
2008-05-26 00:46:15 ERROR:SQL ERROR: Table 'mangos.realmlist' doesn't exist
2008-05-26 00:46:15 ERROR:SQL: UPDATE characters SET online = 0
2008-05-26 00:46:15 ERROR:SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
2008-05-26 00:46:15 ERROR:SQL ERROR: Table 'mangos.characters' doesn't exist
2008-05-26 00:46:15 ERROR:SQL ERROR: Table 'mangos.account' doesn't exist
2008-05-26 00:46:15 Halting process...
reaper gave us a PS only custom vendor and then didn't give us the PS DB. Ironic?
Well I did a workaround and got a file to load into the UDB for custom vendors so ill put it up for DL on like filebeam in a sec.
Madmax said:
Hello when i try to install the optional GM island vendors i get the fallowing error
error 1136 (21s01) as line 24: column count doesn’t match value at row 1.
I'm having the same error, I think that happens becose in the new SQL Table called npc_vendor there is a new column called ExtendedCost, and the SQL structure of the vendors are build like the old one without that column, I just tried to add it with the mysql query browser steep by steep and just including in the row a ,0), more. And it worked. Lets look the example -->
INSERT INTO `npc_vendor` VALUES (500000,16677,0,0),(500000,16679,0,0); -->[here i get the Column count dosen't match value count at row 1]
Ok thats the old structure, i just changed that -->
INSERT INTO `npc_vendor` VALUES (500000,16677,0,0,0) , (500000,16679,0,0,0); [WooT! it works now!!]
If you see there is a ",0)" more, why that? becose in the new npc_vendor table there is one more column the ExtendedCost. I think that the solution is just to ad that ,0) in each of all the npc_vendor values but... I dont know if there is some "automatizated" way of doinf this... its kinda "hardcore" to do it with your own hand.
I just have to say you are the best! IMHO
Hello Oatman,
Thanks so much for the quick update, I didn't expect that!
I have a small question though - only started playing with this private server stuff recently. My boyfriend and I have been working on a nice lightweight interface (we find it impossible to play with default Blizz interface - but I digress) since I got my server upgraded to 5951. So my question is, would upgrading it to 5953 mess all our work up? I know new WoW patches often mess stuff up, but I have no idea how these upgrades influence these things..
Sorry for the silly question, I really have no clue. :) Thanks again!
*5951 is meant to be 5931, oops!
Downloading now, and i had no issues with the previous release what i did was installed it fresh then ran the update and it worked flawlessly, except for the vendors and gmisland ofc
Excellent work as always Oatman.
Just one question.......Although the sunwell npc's are not spawned, is it still possible to spawn Kiljaeden's full loot table? The legendary bow looks awesome hehe.
Oh and is there a replacement for ".addspw"?
Many Thanks
Diesel
So, do I HAVE to extract the DBC's, maps, and VMaps or not? In the fresh installation instructions it says to do so, but in the note before is says not to. And if I don't have to, would you recommend still doing so? Thanks, and hoping for a speedy recovery for reaper-x.
Probably a really stupid question, but...
It says "Upgrading from 5953 Release:"
This IS the 5953 release, no? So do we upgrade from 5953 with this or from 5472?
Just asking before I mess things up. ^^
I'm still having the problems and I cannot figure out how to change my MySQL user nameor fix it, it still says access denied @ 127.0.0.1 for username root, root is the username and I AM using the correct password =( idk
#SGT Mac
As I understand it, you only have to extract them again if you did not already do it for the 2.4.2 version of WoW. (Like, if you installed the release a few days ago you would already have those folders in their correct version. They did not change.)
I still get this error:
'mysql' is not recognized as an internal or external command,
operable program or batch file.
'mysql' is not recognized as an internal or external command,
operable program or batch file.
'mysql' is not recognized as an internal or external command,
operable program or batch file.
Please wait it'll take a while to import the database
Press any key to continue . . .
#Phen
Thanks for the rapid response. The last version I had was 2.3.3 before I was given a trial version of WoW , which got me even more addicted. I HOPE that the quests that were glitching on me before were fixed, I would really like to get my hands on Verdigan's Fist.
Just wanted to say cheers for the hard work Jared! It's much appreciated on my part, and I got this release working flawlessly first try.
#SGT Mac
I find that if a quest is hoplessly glitched and I feel I spent enough time on trying to get it to work, I deserve the reward so I simply grant it to myself. ^^ Just a thought.
I'm RATHER new to SQL so how do I "grant" myself the reward?
Error in item_template table, probably sql file format was updated (there should
be 140 fields in sql). ?
Thanks Freze
#SGT Mac
You need to be on a GM account.
If you have not done so yet, go to the mangosd.exe prompt and type "setgm YOURACCOUNTNAME 3" (without quotes and using the name of the account you use).
Then, from inside the game you type ".lookup item Verdigan" If it comes up with more than one result you look through them for the fist, because you need the number given.
Next you type ".additem HEREGOESTHENUMBER" substituting the number you just looked up.
This should put the item into your inventory. :3
Upgrade successful. :D Thanks, Oatman.
Hi
I cant get the gm island to work can anybody direct me to a tutorial.It says that there is an error at line 24.
Plz Help
Evok3r
Hi
Can anybody help me plz. Im getting an error of the wow gm island stuff in line 24. Can anybody plz help.
Thx
Evok3r
Hey Oatman.
I did a fresh install and everything worked fine. But I still get the .0004331map error when starting Mangos. I have tried the new and the old ad.exe. The installation from reaper-x bat worked fine and MySQL and realmd are working fine also. What should I do?
oh no config editor :(
Could you reinstate the .fly command? pwease? :D
Hello there,
First I would like to say Thank you for your help on this project, I have been a silent fan as well as user for a long time now.
I currently have 5953 installed and working. Just with a few problems... First, I if I create a second character on the same account, the log in screen shows no characters. if I only have one toon, all is fine...
Second, I cannot attack any of the mobs, anywhere. This means in instances, outside, pre bc as well as bc. Also I cannot interact with any npc's... no flight path guys, no bankers, no quest givers.. they are there, just cant select them or "talk" to them.
lol other than that.. it seems to be running great:)
Any help would be greatly appreciated:)
Jas
hi, I have a problem:
In fresh installation I have this error during the 1 step of the reaper-x-mangos...
error 1045 (28000): acces denied for user '-p(password)@localhost using password: NO
mysql: unknown option '-D
mysql: unknown option '-D
someone can help me?
thyll,
It looks as though you do not have the correct values for your username and password when you run the reaper exe. The user (usually "root") and the password are what you setup when you installed MySQL.
thanks Jas...
but I'm sure, the psw is the same used on the mysql installation and for the user I use the standard "root"...
It's the first time that I have this problem...
maybe I need a different version of the mysq? I use the mysql-5.0.51a..
Thyll,
5.0 should work fine, but if you want to uninstall it and install the newest, 6.0 is out.
http://dev.mysql.com/downloads/mysql/6.0.html
Is this install of mySQL 5.0 what you were using previous to the 5953 fresh install of Reaper-X, or is it a fresh install of MySQL as well?
Just in case you do install 6.0, I grabbed Reapers guide for you:)
http://www.reaper-x.com/2007/06/27/mysql-installation-and-configuration-setting-up-private-wow-server/
Just follow this and it should work swell:)
It's a complete fresh installation, I have format lately my PC.
Do me a favor and open up your command prompt.. Start>Run, type in cmd, hit enter, then type:
mysql -u root -p
it should prompt for a password, if so, then enter your password. Then it should say your mySQL version, connection id and such..
This just shows if your mysql is set up correctly :)
If it doesnt, post your error here:)
Maybe this is a simple problem. but howcome when I run mangosd.exe and realmd.exe it says it can't connect to the database?
Is it someone simple I'm missing?
mysql is set up correctly and is running... the problem is the batch files...I think.
If mysql is running correctly and you are using the same user and password in the reaper exe as you did in the cmd prompt, then you might try redownloading the batchfiles and trying again, not sure:(
Lee BeZaro,
Did you edit the mangosconfig, realmdconfig and scriptdevconfig files with your username and password for mysql? You have to do it manually now, since the config editor doesnt work in the batch file.
ok now I try this solution...
thanks again.
no problem, hopefully this works for you:)
I updated my MaNGOS from 5472 to this version and None of the quests are working, everything else seems to be perfect though... thoughts?
At first I was getting a 'gameobject' error, something about the SQL not having the right number of files or something. So I used that MaNGOS database someone posted.. it let me log in, but like I said quests aren't working.
Also, my accounts transferred but the characters didn't. What do I do?
Ehi, Oatman, nice so fast a new release!
There's a thing I'm wondering... the upgrade tool of 5953 version works only from previous 5951 release or from previous reaper-x release (5472) too ?
Thanks Jas!
now it's ok!
p.s. the mangos config (option 4) does'nt work?
Good to hear Thyll:) and no the config editor is not functuional, have to do it manualy.
As for updating from 5472 straight to 5953, I am not sure. I updated from 5472 to 5951 to 5953.. If I am correct the previous updates only allowed upgrade from the most recent, but I could be wrong.
Jas;
You were right, I found the section on Editing and Mangosd.conf file/s and did what it said and it worked.
Thanks for the help :D
really appiciate it :)
Lee BeZaro,
Great to hear:)
Is it just my install that makes the npcs non-interactive? lol
#Talux
The command ".flymode [on/off]" has been changed to ".gm fly [on/off]"
hey...
100% work...
now i need add mob "gm command" please...
tnqx ALL!
hey im just updating now but does the .addspw command work in this release ???
I have a couple diffrent questions first of all my custom vendors are not thier (fresh install) was wondering how to get the vendors back?
second of all im kinda struggling to set up a registration page any assistance on either or both topics would be appriciated.
also looking for experienced gm's that can assist me with small fixes and above mentioned questions
thanx in advance
Kyle,
.addspw is now .npc add (creatureID)
and .npc delete to delete it.
ok ive used all the other realeases fin includiong 5931 but this one when i try to use the upgrade feature i get this
'mysql' is not recognized as an internal or external command,
operable program or batch file.
'mysql' is not recognized as an internal or external command,
operable program or batch file.
'mysql' is not recognized as an internal or external command,
operable program or batch file.
'mysql' is not recognized as an internal or external command,
operable program or batch file.
'mysql' is not recognized as an internal or external command,
operable program or batch file.
you happen to lose your MySQL somehow?
nope still got it, im trying another link
ok i got it to work
ok HOW DO YOU FREAKING SPAWN NPC'S IN THIS RELEASE!!!!
.npc add "creatureid"
so it will look like
.npc add 16508
(no clue what 16508 is, I just picked a random number)
:)
I have a couple diffrent questions first of all my custom vendors are not thier (fresh install) was wondering how to get the vendors back?
second of all im kinda struggling to set up a registration page any assistance on either or both topics would be appriciated.
also looking for experienced gm’s that can assist me with small fixes and above mentioned questions these gms will get gm access to my server
thanx in advance
Hi Reaper,
First of all good work, its nice to have a good private wow server.
I have some questions.
Im having some little problems in game:
1 In an Instance all the mobs are comming through the walls to kills us. Normaly they don't ;)
2 When i have a enchant on my weapon and its glowing. When i use that weapon after that the glow is gone. When i re attach my weapon it glows again. Do jou have any clue what this could be?
I think its not my wow installation because some friends ho are also in my server have these problems to.
Hope anyone could help me.
Thanks allot Brutus
bah - still not allowing me to have more than one character per account, well I can make them, but as soon as I make a second one the log in screen shows no characters:(
also still not able to interact with npc's and cannot target or attack mobs...
I wiped my db and did a fresh install. Not sure what the problem is if anyone can help I would greatly appreciate it:)
great job !
can someone tell me how can i add a special portal to a place that i want ? or can someone tell me how can i make the Shattrath Portal to Thunderbluff to be used by allience to ? Thanks !
Jas
do you have a working Gm command list?
how can I add money?
Thaks
I've made it to take it to work by copying the data from Mangos 5472 CONF files to the 5953 (the mangosd, scriptdev and realmd CONF files) Don't copy the whole files, just take the specified spots and overwhrite them in the CONF files (5953 Release) I hope I was in any kind of assistance! Good Luck!
Oatman please if it is not a problem to you to give us the GM commands of Mangos 5953, cuz some of the ones in 5472 don't work. (Sorry for the double-post)
can anyone tell me how to get the custom vendors working for this release? and also the portal to shatt doesnt seem tow work ?
u can find a list of the commands in the database under the command table
they have altered allot of them such ass money is now a modify option and to add game objects and or npc it id add after what u want to add for example
.npc add 67868
or .gobject add 757575
money is .modify money 9832749237
allot of it is subcommand based meaning it starts with what u want to do and then has add or delete or move and so on after
@ Firane,
Did you get the modified vendors file posted?
@ Oatman,
Any chance we can get the vendors back from the 5472 release? Those vendors are the ones I like with all the trainer vendors included. Tried reinstalling 5472, then the custom vendors, then running all the upgrades to this one, and it kinda worked. MOST of the vendors showed up (oh, and I had to modify the GUIDs for all the vendors). Anyway, thanks again for all the hard work.
Ok i have this problem when upgrading. i had the newest version before this, but it wasnt working. i had the same problem as i do now. and i dont want to restart my whole database.
so when i run mangos.exe i get this error message.
"Loading Items...
Error in item_template table, probably sql file formant was updated (there should be 140 fields in sql."
i had roughly the same issue mine was error in gameobject_template probably sql file formant was updated "there should be 32 fields in sql.”
i tried everything.. had to delete and fresh install database now she works but im wondering hpw to get my custom vendor back up
There was a problem with the batch file to extract DBC. Not sure if you caught it yet or not.
On line three it reads:
mpqe /d "." expansion-local-enUS *.dbc
where it should read:
mpqe /d "." expansion-locale-enUS.MPQ *.dbc
Hope all is well with the Reaper man!
Alex
ok imma try this again since i have had no responses yet
I have a couple diffrent questions first of all my custom vendors are not thier (fresh install) was wondering how to get the vendors back?
second of all im kinda struggling to set up a registration page any assistance on either or both topics would be appriciated.
also looking for experienced gm’s that can assist me with small fixes and above mentioned questions these gms will get gm access to my server
thanx in advance
i still dont understand what i did wrong. when i go to the reaper-x-mangos.exe it asks me where my files are so i put in to location and then i push 1 for installation. it asks for my username and i just use root. does the password have to be the same as the MySQL password? i've been using the words for the database names it gives like when it says "What is your World/Mangos Database Name ? (Most likely "mangos") i'll use mangos
nvm thanks, i think i got it now :)
ok now i'm finally passed the reaper-x-mangos file, but now when i open mangosd.exe, it works until it gets to:
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: ./vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
Check existing of map file './maps/0004331.map': not exist!
Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
so am i missing a file or something?
u need to run the map tool again
do you mean the "makevmaps_SIMPLE"?
no the maps tool not vmaps i beleave the file is called ad.exe
oh ok, thanks. i'll try that
actually it could be in ur config file in the manos config file thier is a line to enter your data directory aka the location u have ur maps vmaps and dbc folder make sure the directory is correct
i was looking through the mangosd.conf file, but i dont see any directory to where my maps and vmaps are
Hi Reaper,
First of all good work, its nice to have a good private wow server.
I have some questions.
After I updated to this version all the quests i have where i need to kill some creatures the counter does not work. So i can't complete them??
Im having some little problems in game:
1 In an Instance all the mobs are comming through the walls to kills us. Normaly they don’t ;)
2 When i have a enchant on my weapon and its glowing. When i use that weapon after that the glow is gone. When i re attach my weapon it glows again. Do jou have any clue what this could be?
I think its not my wow installation because some friends ho are also in my server have these problems to.
Hope anyone could help me.
Thanks allot Brutus
RealmID = 1
DataDir = "C:\wow\Data"
LogsDir = ""
it should be in a group like this
its in the first set of alterable tables
ok i found out why it says the file doesnt exist. its because my maps and vmaps folders are empty. i thought they came with the file since the dbc folder did and i didnt check them.
also, i had:
RealmID = 1
DataDir = “.”
LogsDir = “”
i didnt know i had to change that
k well u need to run the extractor and get all ur files in order and set that datadir path and u should be good to go
anyone figure out how to get all the ustom vendors back yet?
My loading screen keeps getting stuck at logging into game server any ideas?
does mangos exe show its up and online and do u have realmd up with no errors?
i am getting errors when i start realmd, i think the info when running # 6 in reaper isnt carrying thru.
and yes that info shows up in my sqylog database
what errors is realmd giving
i am doing a fresh install so dont have that info at the moment, but the errors were the info that is added to #6
hi, guys one question, whats the ACID script for??
i have the vmaps file from running the ad.exe, but now i'm running makevmaps_SIMPLE and i get down to the part that says to wait until i get PRESS ANY KEY TO CONTINUE MESSAGE and i know i'm supposed to wait until it gets to that, but it wont go any farther. at the bottom it just says:
C:\Program Files\World of Warcraft>vmap_assembler.exe buildings vmaps splitConfig.txt
any ideas why it wont continue?
no idea
it will go just wait it takes forever
takes that part as long if not longer than the whole vmap process
it finally finished, but i still dont have a maps folder. just vmaps
u need to place the ad.exe in ur main wow folder as the directions say and run it it will make a map folder and then when its done move that to the directory u should look at the installation instructions for fresh install if u dont follow it stepop by step u will have several issues
when i ran the ad.exe file, it made a vmaps folder with 2000 something files in it. when i ran makevmaps_SIMPLE it just added more files to the vmaps folder. my vmaps folder now has 3334 files in it. i just ran the extract-map file and it made a map folder so i'm going to try to see if it works
not trying to be rude its just very hard to explain step by step and its already thier and written for ya :)
realmd error:
SQL: select id, name, address,port,icon,color,timezone,allowed securitylevel, population FROM realmlist where color ORDER BY name queary error: TABLE 'mangos.realmlist' dosen't exist
No valid realms specified.
i ran #6 in reaper and this is what i get when i open my realmd any help?
thats a new one for me couldnt tell u
so mod isnt short for modified is it previously from sof2?
i think it works, i just created my account
thanks a lot for the help elderslayer
sof2?
guess that wasnt u then just a diffrent game and when u are ready to put the server online u will need to edit the realmlist file in the database to ur ip address u can do this by using sqlyog to edit the file
Ok, so I've installed this, fixed the maps, vmaps and the dbc (they're all in "c:\games\world of warcraft\data\")the realmd.exe starts with the mangos realm going up, but when I try to start mangosd.exe it just closes instantly. anyone who can solve this?
what operating system are u running ?
if vista right click on mangos and tek it to run as admin if not then i hav e no idea
if you are running vista right click on mangos exe and tell it to run as administrator if nt i have no idea
I just discovered that the WoWServer\data folder missed the maps and vmaps, moving now to see if it solves the problem with mangosd.exe
nope, didn't help
Anyone?
oh, yeah...
is there a problem with custom databases? cuz I've chosen to name the wowXXXXX (realm, world script, chars) I have changed the .conf files accordingly though..
just because I can't see my post about what os I'm running, here it is again (with some random chit-chat so that wordpress doesn't detect double post) -.- xp sp2 with admin acc
sry at this point ur guess is as good as mine
im still trying to get a response to my ?'s unfortunatly i been helping all day and still havent gotten ne one to help me
does ne one have ne idea how i get the cendors to work on this release?
I'm still getting the same error:
Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos
How do I fix this crap?
@bear
Assuming you're using "root" as your admin account for mysql.....change the first "mangos;" to your actual SQL password. Do that for all three entries in the mangos.conf file.
when u installed mysql did u set no password or have u used php admin to set up account access for the database?
has ne one found out how to set up the custom vendors on this realease?
Great Work!!!
I would love it if:
@Sunwell was working properly
@The "new island" was fully working
@Arena 4 sets where available
@GM Island had the vendors
4 things on my wish list apart from that everything else works great!
I tryed to upgrade from Reaper Mangos 5472 to Reaper MaNGOS 5931 and some characters are corrupt. Restored a working 5472, did up grade again with Reaper MaNGOS 5953 still corrupt. Upgrade from 5472 to Reaper MaNGOS 5953 still corrupt. Restore the 5472 and everything works. What am I missing this time?
P.S. I am upgrading not doing the full install.
Is there a way to back up characters then do a fresh install then restore characters? I am guessing not and have it work. It tells me that the data string for those missing characters is messed up so not all characters load just some of them.
If someone could answer some of my questions, it would be greatly appreciated.
1) Is Magister's Terraces and Sunwell working?
2) Where can I find the latest GM commands?
Thanks again to Oatman and whomever can help me.
Maybe you could be of some assistance Reaper... I decided to just do a fresh install of Reaper Mangos 5953 due to my previous version being outdated by a bit. I did all of the extracting and such, but when I try to run "mangosd.exe" i get this message after this nice MANGOS sign is produced:
World Database: 127.0.0.1:3306;root;mangos;mangos
Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password:YES)
Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos
When I try running "realmd.exe" I get:
Database: 127.0.0.1;3306;root;mangos;realmd
Could not connect to MySQL database at 127.0.0.1: Access denied for 'root'@'localhost' (using password: YES)
Cannot connect to database
I checked my mangosd.conf file and found this information (if it helps)
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;mangos;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;mangos;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"
Ok, nevermind I fixed the above error... I have "realmd.exe" working properly but now when I run "mangosd.exe" I get this to appear:
Using DataDir ./
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: ./vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIDs
Check existing of map file '.maps/0004331.map': not exist!
Correct *.map files not found in path '.maps' or *.vmaps/*vmdir files in '.vmaps'. Please place a *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
What is the DataDir value supposed to be / located??
#Jacob
No idea about your first question, but I extracted the commands from the database and posted them here:
http://forums.reaper-x.com/topic/gm-commands#post-5091
The list may not be complete, but it's a start. :3
#Alex P
The data directory can be anywhere you put your maps and vmaps and dbc folders.
When you extract the first two using the provided tools these folders are created in the main WoW installation folder and the dbc folder is already in the pack.
You have to create a 'data' folder (I recommend a subfolder of your Mangos installation) and move the maps, vmaps and dbc folders there, then edit the resulting path into the mangosd.conf file.
ok now i freaking love this release jared you are so AWESOME!!!!!!!
I can't exit:
[ 8 ] Exit
8
You are Now Leaving
Are you sure you want to leave ? Yes/No
Yes
"Yes" is incorrect
Press any key to continue . . .
But looks like it completes without error.
Do not use cap Y in "Yes"
Type
yes all in lower
hey reaper this is the first version iv tried to install mangos and its asked me my mysql username and password and such and i did all that and it installed but then when i opened mangosd.exe it said:
2008-05-26 18:35:29 World Database: 127.0.0.1;3306;root;mangos;mangos
2008-05-26 18:35:29 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2008-05-26 18:35:29 ERROR:Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos
there use to be an option to configure the config files, now you have to do it manually, so as they have your password, read up on the instruct and some posts.
still havent got a fix for my prob :-(
Does this support World of Warcraft Wrath of the Lich King?
Any ETA on any 2.4.3? ;)
2008-05-26 19:04:28 MySQL client library: 5.0.56
2008-05-26 19:04:28 MySQL server ver: 6.0.4-alpha-community
2008-05-26 19:04:28 ERROR:SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel, population FROM realmlist WHERE color 3 ORDER BY name
2008-05-26 19:04:28 ERROR:query ERROR: Table 'mangos.realmlist' doesn't exist
2008-05-26 19:04:28 ERROR:No valid realms specified.
anyone?
Hey Reaper,
just commenting to say good job, and i hope your feeling better! ^_^
~Jink
anyone figured out how to get the vendors alive yet?>
smb -- funny! but the program asks with capital 'Y' in Yes. thanks, a bit misleading.
mangosd crashes when trying to do fishing quest (red snappers). i'm playing as a draenei character. i tried to cast the net on red snappers. i get disconnected message in-game. when i exit wow, i see no manosd dos window.
I'm having a weird problem with ad.exe. It gets to 41% and then crashes. Anyone having this problem or know a work around?
Im having a problem making my server live, everyone time I run the reaper-x-mangos.bat or whatever and do the server setup for lan play/whatever it wont let me connect from a another computer or even the computer running the server
@Brent
you probably set it up right, but did u change your realmlist to the new address?
For all those looking for custom vendors:
I have only been able to get them back one way.
(WARNING: THIS METHOD IS SOMEWHAT INVOLVED AND REQUIRES DATABASE EDITING. ANYONE UNWILLING OR UNABLE TO DO THIS SHOULD WAIT UNTIL REAPER OR OATMAN RELEASE A FIX TO THE VENDORS)
BTW this is NOT the GM Island vendors. These are the vendors that were in the 5472 release that were in Stormwind and Orgrimmar.
1) Backup your characters using the reaper tool
2) completely delete your database (use SQLyog or other tool, right click on mangos, realmd, characters, and scriptdev2 databases and click drop database)
3) Download 5472 release and do a fresh install of that release.
4) in the reaper tool for the 5472 release select the custom stuff and install custom vendors.
5) Download 5931 release and do upgrade option
6) Run 5953 upgrade.
7) ReRun 5953 reaper tool and restore characters.
8) use SQLyog (or other tool) and go into mangos/creature.
9) sort by guid
10)scroll down until you hit the guids that are above 2 million.
11) all guids that are above 2 million need to be renamed as it causes a guid overflow error. What I did was I started at the first one and renumbered it 500000. the next one was 500001 and so on and so forth.
12) now when you start your server you should have most if not all of the custom vendors
Hope this helps you guys get your vendors back.
-Dopey
@ Firane,
Did you get the modified vendors file posted that you refered to earlier?
modified vendors file? how would i get it and then how would i apply it
#Scott
Are you using the provided extract-map.bat file to run the ad.exe?
I have got this wrong info: Check Existing of map file './maps/0004331.map': not exist! Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
I checked the maps folder. I found the map of 0004331.map. I don't know why it showed these messages above. And the mangos stopped running.
ok, through some microing I found out that it complains about line 426, unfinished quote...would anyone know which line this is(in the mangos.conf) (microing = printscreen at startup, through vnc in school xD)
hi~
how can i import my custom item txt from 5472 database to 5953 database?
thanks
i got the 'ExtendedCost' error when i import my 5472 item, but i use Quice122 to check other official item in the 5953 database and cannot find the ExtendedCost line in those. so what can i do for that?
Hi,let me start by saying what an excellent job at this and keep up the good work.
But i have one question.
All the spells are not there for my druid.
When i create a druid i cannot get the flight form from the trainer,not even the level 68 normal one.
Does anyone know what i have to do to be able to learn it from the trainer and also be able to obtain the quest for the epic one?
thanks in advance.
ok, so the smart me forgot that you can run it in cmd to get the complete error msg without the window closing, going to check that now xD
ok, so the error msg I get now is:
C:\Games\WoWServer>mangosd
DOTCONF++: file 'C:\Games\WoWServer\mangosd.conf', line 425: unterminated quote
Could not find the configuration file mangosd.conf
thing is, it reads the conf file and then says it can't be found.
also, the line 426 is:
Motd = "Welcome to Mickwald's WoW Server"
which doesn't have any unterminated quotes..
any clues?
ahh, problem solved, I just noticed I've got a "'" which seems to start a quote.. even though it's in the quote, removed it and it seems to work
hmm...now I've got a problem with mangosd.exe crashing about every minute...
also, when I try to connect I get the "unable to connect" error
ok, it's confirmed when "uptime" reaches 1 min it chrashes, 3 times in a row I've had "info" give uptime 59s and next it crashes
One step closer, edited the realmlist.wtf and added the port to the WORLD (8085) and got through to authenticating, still, I got stuck there and about a min later the mangosd.exe crashed
There's a couple of downloadable Brutal Gladiator + Guardian items on mmowned.com, but I just can't 'em to work. It would be awesome if someone could post a link to a working ".sql" or query here that is working for this version of mangos.
Thanks :D
My GM Island is bombing out on line 24, which is the creature INSERT, not the NPC. Any ideas on columns there?
Thanks!
#Phen
Yes, I tried the extract-map.bat and ad.exe by itself, but both consistently crash at exactly 41%. I did some googling and apparently some others are having the exact same problem, but no one seems to be able to figure out why.
I'm guessing Vista has something to do with it since I hear the Linux version does not have the same problem. :P
If you are getting the vmap error at mangosd startup, recreate the maps (not vmaps).
AD.EXE has been updated in this release. So if you created the maps using an earlier version of ad.exe from your 2.4.2, you'll need to do it again using this version.
This needs maps only, not vmaps.
is this compatible with vista
WOOOT YOU FUCKING ROCK!!!!!!!!!!!!!!!!!!!
@dopey
yes i did it but i realized after i put that up that none of the creatures in the release for SW or ORG had locations so i got them to work but they weren't spawned and i didn't feel like spawning everything
@Elderslayer:
Custom vendors require data in three tables. Creature, npc_vendor and creature_template. If you didn't backup your old custom vendors they could be gone from this database.
I try to keep a batch of SQL scripts just for creating my personal custom vendors like my level 40 armor greens vendor in gadgetzan looks like this. http://www.reaper-x.com/2008/03/23/reaper-mangos-5472-easy-wow-private-server-for-world-of-warcraft-233/#comment-88563
The other question you had was regarding web pages. I'm thinking there are several out there and they include step by steps and seems like the main thing to do would be opening forwarding port 8080 on your router firewall and desktop firewall. This is a risk you should take carefully, if you have never run a public web site before. just as we forward ports 8085 and 3724 for realmd to make them publicly visible.
The only other thing is to configure your web page so it knows your mysql login and password so it can update/insert people into your database.
Hope that helps. I've been gone playing the new dailies in quel'danas on retail wow if anyone was wondering where I'd gone. I have to catch up and install this latest version but glad to see you folks are all still plugging away at the ole Mangos. Thanks Reaper / Oatman!
Ah - after some more reading - If I read this correctly, it is only set to run with the unified database (UDB) not the project silvermoon (PSDB) with all the custom vendors. Still if you know your custom vendors insert SQL script code as in my prior post you can insert some custom vendors into any database pretty much.
Can anyone help me?
Whenever i try to run mangosd it gets up to 88% but then it says some required .dbc files not found or compatible?
how do i fix this?
Hi, I hope someone can help me.
After i installed this update. I cant complete quests with mob counts in it. So you need to kill 10 of these and 10 of those and then your done. But de mobs aren't counted in de quests. Its hard to level at this point :P
Hope someone can help me.
Greeting Brutus
Can someone upload 2.4.2 dbc files plz
ive been trying to get mine to work i got the new pack and still got the same error about no items so i was looking thru the postes and grabed the new mysql6.0 installed it vuseing the reaper page on howto do it and made sure to have a bin well i had to name it mysql4 it wouldnt let me use mysql even tho i deleted the 5.0 i had and now the realmd wont connect says it cant find it dies any1 have any ideas thanx
I just made a fresh install and copy back my character and realmd data but i still cant complete any quests with mob counts in it.
Even when i remove the quest and get it again i cant complete them with killing the ricght mobs.
Hope someone can help me.
Greetz Brutus
DBC's were included with the release.
After restoring my characters I cant loging myself getting that old unknown column Sha_Pass_Hash error in the field list trying to log in; must be some difference with the old PSDB I was running before. DB was clean fresh install, hmm, Extraneous DLL's maybe I'll make a clean mangos folder. Otherwise may scrap all and start fresh.
will this work with patch 2.4.1
ok, so I did a fresh install and everything seems to be working except that I get stuck at the Authenticating screen when logging in, any clues?
erm, fixed the realmlist.wtf and got in
srry if this question was already asked...but can i update this newer one from the 2.3.3 one (Mangos 5472 release) so i still have my characters.....or do i need to update with the first 2.4.2 one and then go from there?
thankz
I'm getting error's like:
Loading Items...
[**************************************************] 100%
>> Loaded 23551 item prototypes
Item (Entry: 8591) has wrong Subclass value (5) for class 15
Item (Entry: 13086) has wrong Subclass value (5) for class 15
Item (Entry: 13335) has wrong Subclass value (5) for class 15
Item (Entry: 18245) has wrong Subclass value (5) for class 15
Item (Entry: 18246) has wrong Subclass value (5) for class 15
Item (Entry: 18247) has wrong Subclass value (5) for class 15
Item (Entry: 18248) has wrong Subclass value (5) for class 15
Item (Entry: 19029) has wrong Subclass value (5) for class 15
Item (Entry: 19030) has wrong Subclass value (5) for class 15
Item (Entry: 19872) has wrong Subclass value (5) for class 15
Item (Entry: 19902) has wrong Subclass value (5) for class 15
Item (Entry: 21176) has wrong Subclass value (5) for class 15
Item (Entry: 21218) has wrong Subclass value (5) for class 15
Item (Entry: 21321) has wrong Subclass value (5) for class 15
Item (Entry: 21323) has wrong Subclass value (5) for class 15
Item (Entr
tim@LAMP:/opt/mangos/bin$ screen -a
insertPendingThread()
1 pending-thread added.
Thread joining...
Thread exiting...
insertPendingThread()
1 pending-thread added.
Thread joining...
Thread exiting...
insertPendingThread()
1 pending-thread added.
ThreadQueue waiting on remaining threads...
pollUserThreads()
pollPendingThreads()
Thread destroyed.
1 pending-thread reclaimed.
Thread destroyed.
1 pending-thread reclaimed.
Thread destroyed.
1 pending-thread reclaimed.
pollReferenceThreads()
Thread destroyed.
1 reference-thread reclaimed.
ThreadQueue destroyed
And it stops at the:
Loading Creature templates i dont know why
And i'm using this database and sqls
But i'm running my server on linux, and some help of Mangosproject.org
I mostly download ur revisions and i use the sqls after that I download the revision that you used in this case: 5953
I hope you can help
ok, fresh install made it work^^ NICE JOB REAPER!!
ive tried re installing everything and still getting same errors when i open realmd, any help?
2008-05-26 19:05:37 MySQL client library: 5.0.56
2008-05-26 19:05:37 MySQL server ver: 6.0.4-alpha-community
2008-05-26 19:05:37 ERROR:SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel, population FROM realmlist WHERE color 3 ORDER BY name
2008-05-26 19:05:37 ERROR:query ERROR: Table 'mangos.realmlist' doesn't exist
2008-05-26 19:05:37 ERROR:No valid realms specified.
I'm still getting this error after a fresh install of Reaper Mangos 5953.
Check existing of map file './maps/0004331.map': not exist!
Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmap
s'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correc
t the DataDir value in the mangosd.conf file.
Seen error has been posted before, but I can't find the solution/correction. Any clues ?
This is for everyone with the following error when running mongosd.exe
World Database:
127.0.0.1;3306;root;mangos;mangos
ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘root’@'localhost’ (using password: YES)
ERROR:Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos
To correct this, open your mangosd.conf file in wordpad and find this section:
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;mangos;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;mangos;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"
Now, where it says "127.0.0.1;3306;root;mangos;realmd/mangos/characters",
change the word after root to your password!!!
(ie 127.0.0.1;3306;root;PASSWORD;realmd)
If you have a further problem with a DataDir after this is fixed, simply reopen your mangosd.conf file and change the portion stating (DataDir = ".") to where your data folder is in your World of Warcraft folder (ie ataDir = "C:/Program Files/World of Warcraft/data")
Now, if you had the first problem with opening mangosd.exe, you will probably have a similar problem when opening realmd.exe. To fix this open realmd.conf in notepad, scroll to the bottom of the document. Find this insert (LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd") to fix this do the same as before, replacing the first mangos with your password (ie LoginDatabaseInfo = "127.0.0.1;3306;root;PASSWORD;realmd"
@Firane,
If you edited the file yourself, then I tip my hat to you. If it is the same SQL file I have, then I have the file that spawns all the vendors if you would like a copy. Just needs to be edited and I don't have the time to do it. Send me an email at airman_dopey@comcast.net if you want it. And if you'd be willing to send me the other one that would be great.
-Dopey
@Glenn: further up I saw someone said the currently included script for gmisland did not match the new file format. The database table for that third insert in the vendors.sql included insert statements where each items was missing the last column which could be added as just a 0.
I did this by doing a search replace on that third insert text and replaceing
),(
with
,0),(
Then it seemed to work fine. If not you could paste it into SQLYog and run it there which was actually how I got the 5000 rows inserted message.
What they need is a way to add all weapon proficiencies with a single command like .learn all_weaponsk or all_armortypes
=)
ok so i decided to fresh install....and now when i go to run it....it says cannot connect to database
slight problem.. upgraded from 5475.. went to restore my Characters db and got this error..
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databa' at line 1
The system cannot find the file specified.
any help would be appreciated..
When i launch mangosd it says Error: Table mangos.db_version doesnt exist,Error: Table mangos.creature doesnt exist,Error: Table: mangos.gameobject doesnt exist, Error Table mangos.mangos_string doesnt exist, and DB table mangos_sttring is empty,cannot continue.
@Craig 318
Do not run the restore characters script after you upgraded to a newer repack. It will corrupt your db.
Pretty much what is happening is that when you are using the character backup command, you are backing up the data ONLY for that same release version.
Using the upgrade tool should properly migrate your characters data to the newer release. =)
@ reggie and anyone else with a similar problem
whenever you get this error message :
Check existing of map file ‘.maps/0004331.map’: not exist!
Correct *.map files not found in path ‘.maps’ or *.vmaps/*vmdir files in ‘.vmaps’. Please place a *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
It means that MaNGOS is looking for your data directory file.
Open up your MaNGOS Config file and look for
Datadir "."
change it to:
Datadir "C:\WoW\data"
or to your [data] folder where you keep your maps, vmaps, and dbc files. I have mine at C:\WoW\data in this example
If you do this and continually receive this error message again you might need to re-extract your maps, vmaps, and dbc files again. Hope this helps
Hi, this is my first attempt at creating my own private server. I've read all the posts above (along with a couple other guides posted on this site) and managed to get past a few bugs that have already been stated. My issue now is when I run mangosd.exe it gives me the following error:
Using UDB 0.10.2 (351) for MaNGOS rev. 5949 with SD2 SQL for rev. 414
Using DataDir G:\WoW Private\data/
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: G:\WoW Private\data/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Check existing of map file 'G:\WoW Private\data/maps/5301243.map': not exist!
Correct *.map files not found in path 'G:\WoW Private\data/maps' or *.vmap/*vmdi
r files in 'G:\WoW Private\data/vmaps'. Please place *.map/*.vmap/*.vmdir files
in appropriate directories or correct the DataDir value in the mangosd.conf file
This is a different 'missing' file from the one listed by other people. I already manually changed the config to the correct directory, the file itself is just missing. I've run the extract-map.bat properly atleast 3 times, and the file is still missing. Any help is appreciated. Thanks!
~Blahofstars
Oh, and to add on to my post, the version of my WoW client says v2.4.2.8278. It's fully updated, as I can long onto the actual WoW servers and all.
@ Blahofstars
Sounds like you got your mangos config file set properly no problems there.
I would also double check to see if you have the newer updated version of the map extractor.
Fixed character problem. Not sure why but characters saved with GM ON failed to upgrade. Had to turn gm off and remove all pets then they updated with out corruption. I dont understand it but its what worked.
nvm, I did more searching. I needed to turn off the expansion in config file. works now!
hey guys. i seem to have conquered some of the problems i was having. if anyone is having trouble connecting to the world database when they run mangos.exe well you have to go into mangos config,realmd config, and scriptdev2 config reaper explains what to do near the end after he tells you to try and run mangos.
that solved my problem except iv come across a new problem. i try to run mangos.exe and i start loading the server but then it says this.
2008-05-27 17:58:41 >> Loaded 500 MaNGOS strings
2008-05-27 17:58:41 Initialize data stores...
2008-05-27 17:58:43 ERROR:
Some required *.dbc files (9 from 52) not found or not compatible:
C:\Program Files\World of Warcraft\Data/dbc/BattlemasterList.dbc (exist, but have 32 fields instead 33) Wrong client version DBC file?
C:\Program Files\World of Warcraft\Data/dbc/CharTitles.dbc (exist, but have 20 fields instead 37) Wrong client version DBC file?
C:\Program Files\World of Warcraft\Data/dbc/ChrClasses.dbc (exist, but have 24 fields instead 58) Wrong client version DBC file?
C:\Program Files\World of Warcraft\Data/dbc/ChrRaces.dbc (exist, but have 35 fields instead 69) Wrong client version DBC file?
C:\Program Files\World of Warcraft\Data/dbc/CreatureDisplayInfo.dbc (exist, but have 21 fields instead 14) Wrong client version DBC file?
C:\Program Files\World of Warcraft\Data/dbc/ItemExtendedCost.dbc (exist, but have 13 fields instead 14) Wrong client version DBC file?
C:\Program Files\World of Warcraft\Data/dbc/Map.dbc (exist, but have 123 fields instead 125) Wrong client version DBC file?
C:\Program Files\World of Warcraft\Data/dbc/Spell.dbc (exist, but have 211 fields instead 213) Wrong client version DBC file?
C:\Program Files\World of Warcraft\Data/dbc/SpellShapeshiftForm.dbc (exist, but have 23 fields instead 35) Wrong client version DBC file?
it seems like i extracted the dbc wrong but i tried 2 more times and it still seems to be missing things in the dbc. i am extracting the ones from the mangos download link above. if anyone knows whats wrong could they please comment a solution. thanks sorry for the long comment.
Regarding the custom vendors...
In addition to the "ExtendedCost" column in npc_vendors...
It looks like the `creature` table added the column "spawnMask" which looks like it can take a value of "1", dropped columns "spawn_position_x" (and Y and Z) and "spawn_orientation"
I restored the old tables, loaded the custom vendor rows, altered the columns, exported the rows again and imported into the new data.
Quick and dirty fix to the "creature guid overflow"...
update creature set guid=id where guid>1000000 and map=0
update creature set guid=id+10000 where guid>1000000 and map=1
Anyone getting the error "Player #5 have broken data in `data` field. Can't be loaded."
hi
aney one know how to get the GM Island vendors working
Thanks Daggo,
I'm getting, any help would be greatly appreciated...again
2008-05-28 02:31:38 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2008-05-28 02:31:38 ERROR:Cannot connect to Character database 127.0.0.1;3306;root;MyPassword;characters
I'm pretty sure I edited the Configuration files properly. I had this error before i tried to restore my Characters db.. it's why I tried to restore it in the first place..
Hey guys grazz great work, by me everything works fine, everything i tryed works :) but now I have just one question: How can I instal the vendors? I run the reaper-x-mangos then I use option 7 tipe my mySQL username and pass then he ask me for the name of my MaNGOS/WORLD database? i dont know what to tipe there... I dont changed any database name only ma pass and username so can any1 say me what to tipe there ??
i think the database name is Mangos but i get the
but i get error at line 24 colum coun dosn't match value count at row 1
I don't know if it is me but what happened to the gm commands seems we are missing a few like .addspw and .money and a few others I have noticed
.addspw changed to .npc add
and
.money changed to .modify money
i gotta question how do u add portals like there are portals in shaat to sw org darnassus thunder bluff ect ect ect u know what i mean anyways how do i add another like if i wanted to put a portal in stormwind and orgrimmar to get to dire maul arena and gurubashi arena and stuff post reply here or email me at sicx69sicx@hotmail.com
also if anyone know how to make it so people can register on your website then the mangos programm or somethin auto makes there account if anyone knows anything about that let me know kk thanks
I've been wondering why items with id higher then 35000 can't be add to player. It says me invalid ID, but the items are from version 2.4.2? :| I'm speaking for items like Brutal Gladiator for example. If someone can answer this please to do it so.
Thanks Reaper, now my server works very good. :D
My character list for my server wont come up it just stays on the "Logging in to game server" message.
Why can i not crate two realms?
I'm having the same issue Chris. I can log in just fine on the local machine, but if I try over LAN or Internet, I get stuck at Logging into Game Server
Weird
Hi, I know there's a guide on creating a webpage for account creation, but I just can't find it... any pointers?
@ Brian & Chris
I had the same prob... I just reinstalled, saving the dbc, vmaps and maps folders and redid the .conf file, with datadir etc.. worked for me...done quite fast too
hmm. that didnt change anything for me. Any other ideas? I know SQL, Manosd, and realmd are up and running as everything works on the local machine.
Is there a remote setting?
Thank you very much Reaper-x and Jared !!
Great job!! Keep doing it !!! ;)
Its OK I've found a post on another forum and it explained how to fix it.
Anyone know a place where the map files are available for download? For some reason my ad.exe keeps bugging out at 41%, and I cannot extract the map files from my 2.4.2. client.
Brilliant repack no troubles at all =)
Well im not using the reaper-x repacks but i started compiling and having my own server with reaper-x repacks so im here to help like he helped me in the past :")
@Weiss935
what Mysql viewing software you are using sq;yog or navicat?
please let me know.
sorry for double posts.
@Weiss935
what Mysql viewing software you are using sqlyog or navicat?
please let me know.
i don't realy know. i'm using that reaper is let us download. mysql server 5.0 then i don't know more.
Thank you for the new release ! ;) i made it all without no probs :)
ok sorry for the 2 posts but im gonna do it simple for those who dont undertand this quite good :
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;mangos;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;mangos;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"
1. Go to your Mangos.conf file
2. Find the stuff above
3. Set ur MySQL password Like this :
root;PASSWORD;mangos" Note: you will have to set ur MySQL password on realmd,Mangos,Characters
4 run mangos.exe :)
5. and if you got problems after that above go back to this and change your DataDir :
DataDir = "." "127.0.0.1;3306;root;mangos;realmd" <--
TO :
"127.0.0.1;3306;root;PASSWORD;realmd"
i hope this helps :)
Ooops all didnt come .. But anywayz Sorry for the 3rd comment >.<
This goes out to 2 different people for 2 different reasons:
1. #Oatman
Thank you for the update. Now, once again, this humble soldier in the middle of Iraq can get his WoW fix until he gets a better computer built back home. I dunno what the rest of you are having issues with, I'm a dunce when it comes to SQL and mine works fine.
2. #Phen
Thanks again for you rapid response. I honestly would probably never seen that coming. I may wind up researching more commands to have a little more fun, hee hee hee.
Are the season 4 items available to see/use in game? I know blizzard have already added them in the 2.4.2 patch but just not activated on the real server.
Also, is there a way to access the legendary bow from kil'jaden? :)
Yea I set up my realmlist and everything else fine
@Mojo
I dont think season 4 has been added
.lookup item thor, then .additem when thor'idal the stars fury number comes up
Can anyone help me w/ a slight prob? When I try logging into the server onto the character selection screen, it just brings me back to the server list. Mangos and realmd are running fine, but when I start mangos, i get this:
mangos>Grid [35,34] on map 566 moved to IDLE state
Grid [36,34] on map 566 moved to IDLE state
Not sure if this is causing it or what....any ideas?
Greetings, these are the errors im having trouble with when i try to run; mangosd.exe and realmd.exe.
World Database 127.0.0.1;3306;root;my password;mangos
Could not connect to MySQL database at 127.0.0.1: Unknown database 'mangos'
Cannot connect to world database 127.0.0.1;3306;root;My password;mangos
When i launch reaper-x-mangos.bat
and select to install "option 1"
once i get to this step"what is your scriptdev2 database name" i type in "ScriptDev2" and this shows up.
'mysql' is not recognized as an internal or external command, operable program or batch file.
'mysql' is not recognized as an internal or external command, operable program or batch file.
'mysql' is not recognized as an internal or external command, operable program or batch file.
please wait it'll take a while to import the database
Press any key to continue...
then 1 second later this same messege shows up but six times.
'mysql' is not recognized as an internal or external command, operable program or batch file.
'mysql' is not recognized as an internal or external command, operable program or batch file.
'mysql' is not recognized as an internal or external command, operable program or batch file.
'mysql' is not recognized as an internal or external command, operable program or batch file.
'mysql' is not recognized as an internal or external command, operable program or batch file.
'mysql' is not recognized as an internal or external command, operable program or batch file.
'mysql' is not recognized as an internal or external command, operable program or batch file.
Done
If you see any error messege just let me know
Can someone please help me?
im trying to use quince but i dont know my db name can i have some help (everything is at defaults)?
ok well when that happened to me , did you copy and paste it from the text where is says "typer were your mysql bin is and then it says
C:\Program Files\MySQL\MySQL Server 5.1\bin" because it says 5.1 and you might have 5.0 which is one reason why it might not be able to establish connection, give it a try becauase i realize that one typo screwed me over big tim
@Weiss935
ok look like this it will take so much time to help you out if u want u can pm me on my site http://wowriot.net or come on my ventrilo and ill help you out it will be faster cause im always working on my server.
@Reaper & oatman
Hey reaper hope u get better soon man your a great dude man and ill help in what ever i can just let me know thru my site pm me or come on my vent ya guys are always welcomed.
oatman Great job takes alot to take this job on i know you guys are helping ppl get started in this emu biz Keep up the good work
When i open up mangosd.exe it closes real quick. A few times it stayed up for a few seconds and i saw cannot find mangosd config file. What am i doing wrong?
make sure your mangosd.conf file is configured the right way
ok i fixed my last problem but i keep getting the missing map error. Ive reextracted my maps and the location is correct. What else could it be?
@ Brett
MaNGOS config file:
Datadir "."
change to:
Datadir "C:\ (location of data directory)"
also make sure if you have the Expansion enabled or disabled in your mangos config file depending on your client.
The datadir location is correct and it is set to expansion and still got the map error
is it normal to see a window like the matrix or something???
i'm having a problem when running mangos.exe
it comes with this error:
ERROR: Table 'mangos.db_version' doesn't exist
and this:
ERROR: table 'mangos.mangos_string' doesn't exist
can anybody help me?
this REpack is fully functionally ! YOU NEED ONLY READ AND YOU 100 % FIND HOW TO FIX YOUR PROBLEM !
Chris could you share the link that fixed your problem?
ok i've found the problem i just had to run reaper-x-mangos.bat
but now i'm getting this:
Initialize data stores...
================================= = 88%
Some required *.dbc files not found or not compatible:
C:\WOW\data\dbc\BattlemasterList.dbc Wrong client version DBC file?
C:\WOW\data\dbc\ChrClasses.dbc Wrong client version DBC file?
C:\WOW\data\dbc\ChrRaces.dbc Wrong client version DBC file?
C:\WOW\data\dbc\CreatureDisplayInfo.dbc Wrong client version DBC file?
C:\WOW\data\dbc\Map.dbc Wrong client version DBC file?
C:\WOW\data\dbc\Spell.dbc Wrong client version DBC file?
i'm doing a fresh install not upgrading
Hello... When I install GM Island Custom Vendors i get the error what all of you know... But i can't fix it... someone can insert a link where can I download it?
can someone plz help me?
I decided to install the GM vendors. Everything installed correctly but when i log in and click my realm it loads but then takes me back to the realm list. how do i fix this?
Hey Brian,
Have you installed GM Island Vendors? If yes, they work properly? If yes, send by e-mail to me your "vendors.sql" please..
@ Tim,
Go into your database (using SQLYog or similar tool) go into realmd, then realmlist. Change your server IP address to whatever it is on the network, NOT the loopback address (ex. 192.168.XX.XX, NOT 127.0.0.1)
-Dopey
has anyone else tried to set up a second realm? I am trying to, if anyone has had any luck please contact me on aim or msn
aim: usaf733n
msn: usaf_mcintyre@hotmail.com
@ Brett
When extracting maps make sure that
#1 double check to see if you are using the most recent map extractor, Ive seen some people have problems with the older one
#2 you are extracting maps, vmaps, and dbc files AFTER upgrading your client to 2.4.2
#3 In some rare instances, check your file permissions and make sure you have admin rights to the files.
Its also possible that your computer is having trouble with the map extractor. As a means of troubleshooting, try using the map extractor on another computer with 2.4.2 installed and transfer those map files to your current data map folder. This will help to see if its a problem with your map extractor or map files.
Is this a fresh install? or an upgrade of a previous version?
WORLD: CMSG_ITEM_QUERY_SINGLE - NO item INFO! (ENTRY: 34247)
STORAGE: Item Query = 34334
WORLD: CMSG_ITEM_QUERY_SINGLE - NO item INFO! (ENTRY: 34334)
STORAGE: Item Query = 34247
I get these errors when trying to access Apolyon and Thori'dal from Kil'jaden, either they don't actually exist in the game yet or my database lost them lol
I can't install the gm vendors in gm island pls tell me what to do!
Here is the link to the page that helped solve my problem
http://forums.reaper-x.com/topic/logging-in-to-game-server
Also is this version compatable with the WotLK alpha or will there be a version available
Thanks
@Kyle
and
@Daggo
Kyle, i checked he directory to the version of MySQL and it was 5.0 >,< like you said. that typo was the problem.
Daggo, not long after i changed the version number on the .bat file i encountered a directory problem in the mangosdconfig.txt because the mangosd.exe couldn't find the data folder. So i edit the file as you said and magos.exe found the data directory.
Thanks a bunch for your post and i am happy to say that the server is now running thanks to you two ^ ^
Reaper-X thank you for the wonderful guide, and your time devoted to this project.
awesum work, reaper.
but..whut happened 2 the .morph command? =(
@ EVERYONE WHO WANTS CUSTOM VENDORS
stop asking for CUSTOM VENDORS they aren't in this release jeezus
@Gymp @Reaper
A TON of commands got reworked
If you build your own binaries it give u a list
but since ur using reaper's u don't have it
reaper if you could... go into the chat.cpp and in there theres the list of all the commands u could possibly include a text doc in the next release cuz all the commands aren't listed in SQLyog
@gymp
lol whoops
but anyway its been changed to
.m morph ###
when ever i try to install the gm vendors i get the same error message which is
ERROR 1136 (21S01) at line 24: column count doesn't match value count at row one
i have tried this on two machines and it comes with same message what can i do help me please
hey im just wondering since i havnt updated my mangos in a long time but now im installing this one. im having trouble starting up this one and im just wondering if its because i have not installed the last 3 versions. im updated to 2.4.2. anyhow when i run mangos.exe it tells me i might have the wrong dbc file. and that im missing parts to the dbc.
Sorry to bug you again.. I got pass my other errors but now I've hit another one.
When i run mangosd.exe I get this error.
Loading MaNGOS strings...
ERROR:SQL: SELECT entry,content_default FROM mangos_string
ERROR:query ERROR: Table 'mangos.mangos_string' doesn't exist
ERROR:>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue.
@ Qwerdo
The included vendors .sql script is outdated and will not properly load. Ever since 2.4.1 the data tables for npc vendors was altered and because of this will not load into the newer database. (Thats essentially what the error you are receiving is saying) We will just have to wait for another vendors sql script updated for the 2.4.2 database to come out. You may however, do a tedious workaround like some have to somehow migrate it into the newer database. The alternative would be to learn a few GM commands and create vendors in your realm, its not very hard and fun!
@aaron
Make sure you used your map, vmap, and dbc extractors after updating to 2.4.2. Also, the included dbc files in this repack should work just fine. Oh, and make sure your mangos config file is set up nice and properly. LoginDatabase, worldDatabase, and CharactersDatabase, and datadir all configured properly.
@Craig 318
Looks like your mangos db is missing the 'mangos.mangos_string' table. see if this works. Iv uploaded the table to http://www.2shared.com/file/3361578/ec3919cf/mangos_string.html
download it to your desktop. Manually import it to your database using SQLyog (its what I use). To do that, open up SQLyog and when you see your databases on the left colums, highlight your 'mangos' db, then DB>Restore from SQL Dump, then navigate to the file, and then execute. lets see what happens.
@ Daggo
This is a fresh install. The extractor im using was the extractor from the most recent mangos. Im already updated to 2.4.2. I have admin permissions for the files. the only this is i dont have another computer to try the extractor on. One other thing the map that the error says doesnt exist is in the map folder.
@Daggo
the mangos.mangos_string table sql file work perfectly.. now it says this.
2008-05-30 00:05:41 >> Loaded 52 data stores2008-05-30 00:05:41
2008-05-30 00:05:41 Using Autodetected DBC Locale (0).
2008-05-30 00:05:41 Cleaning up instances...
2008-05-30 00:05:41
2008-05-30 00:05:41 >> Initialized 0 instances, deleted 4 old instances
2008-05-30 00:05:41 Packing instances...
2008-05-30 00:05:41
2008-05-30 00:05:41 >> Instance numbers remapped, next instance id is 5
2008-05-30 00:05:41 Loading Localization strings...
2008-05-30 00:05:41
2008-05-30 00:05:41 >> Loaded 0 MaNGOS locale strings. DB table `mangos_string` contains no localization.
2008-05-30 00:05:41
2008-05-30 00:05:41 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.
2008-05-30 00:05:41 ERROR:SQL: SELECT entry,name_loc1,name_loc2,name_loc3,name_loc4,name_loc5,name_loc6,name_loc7,castbarcaption_loc1,castbarcaption_loc2,castbarcaption_loc3,castbarcaption_loc4,castbarcaption_loc5,castbarcaption_loc6,castbarcaption_loc7 FROM locales_gameobject
2008-05-30 00:05:41 ERROR:query ERROR: Unknown column 'castbarcaption_loc1' in 'field list'
2008-05-30 00:05:41
2008-05-30 00:05:41 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.
2008-05-30 00:05:41
2008-05-30 00:05:41 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.
2008-05-30 00:05:41
2008-05-30 00:05:41 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.
2008-05-30 00:05:41
2008-05-30 00:05:41 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.
2008-05-30 00:05:41
2008-05-30 00:05:41 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.
2008-05-30 00:05:41 Loading Page Texts...
2008-05-30 00:05:41 >> Loaded 1373 page texts
2008-05-30 00:05:41
2008-05-30 00:05:41 Loading Game Object Templates...
2008-05-30 00:05:41 ERROR:Error in gameobject_template table, probably sql file format was updated (there should be 33 fields in sql).
@Daggo
This is what im seeing
ERROR:Check existing of map file '“C:\Reaper-X\Reaper/maps/0004331.map': not exist!
2008-05-30 00:37:25 ERROR:Correct *.map files not found in path '“C:\Reaper-X\Reaper/maps' or *.vmap/*vmdir files in '“C:\Reaper-X\Reaper/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
@Craig318
just as I expected actually, you are missing a bunch of needed tables in your mangos db. You most likely will need to do a fresh install of the repack in order to get ALL of the tables inserted into the database correctly. Hopefully that should solve the issue. Your configuration seems fine so far, you just need to redo the mangos install. btw, what version of sql are you using?
@Brett
Try turning expansion to 'off' in your mangos config file. see what happens. If you look in your map folder can you actually see the file?Do you have Burning Crusade installed on your machine? Also double check your [datadir = '.'] in your config file.
@Daggo,
Thanks for all your help It's been very useful.
I'm not sure why it didn't include all the tables with the upgrade.. So now I just have to backup my characters database then do a fresh install and then restore my characters and I should be fine to go..
I'll let you know how it goes. Thanks.
Oh I'm using MySQL Server 5.0
@Daggo,
the Fresh install went without a hitch. the only problem that i have now.. I've restored my characters db, When I goto login it says the details are when.. i went into sqlyog and the characters are there... all of them So I went back into mangosd.exe and tried to change the gm lvl on my accounts and it told me they werent found.. so my guess is that they're not being restored properly.. any clue how to fix that?
@daggo
I do have BC installed. Turning off expansion it did the same thing. Yes i actually see 0004331.map in my map folder. And ive checked the datadir in triplicate about 2 million times lol
i'm having a problem when running mangos
Initialize data stores...
============================================= = 88%
Some required *.dbc files (6 from 51) not found or not compatible:
C:\WOW\data/dbc/BattlemasterList.dbc (exist, but have 33 fields instead 32) Wron
g client version DBC file?
C:\WOW\data/dbc/ChrClasses.dbc (exist, but have 58 fields instead 24) Wrong clie
nt version DBC file?
C:\WOW\data/dbc/ChrRaces.dbc (exist, but have 69 fields instead 35) Wrong client
version DBC file?
C:\WOW\data/dbc/CreatureDisplayInfo.dbc (exist, but have 14 fields instead 21) W
rong client version DBC file?
C:\WOW\data/dbc/Map.dbc (exist, but have 125 fields instead 123) Wrong client ve
rsion DBC file?
C:\WOW\data/dbc/Spell.dbc (exist, but have 213 fields instead 211) Wrong client
version DBC file?
can anyone help me with this it says that i don't have the right version of DBC files but i'm using those which was with the mangos files.
E-mail: Chrisseravis@hotmail.com
@Craig318
Was your characters backup from an earlier release? What I am guessing what happened was that when you restored your characters to your db, it failed to restore your accounts along with it. This is still fixable, you will need to recreate your username and password in your mangos screen. Then log in to your MYSQL and go to your character.characters table. From there, you need to match up your characters to your appropriate UserID.
@Daggo
Ok, I did that now when i goto log into my account. I get no characters and I get these errors in Mangosd.exe
2008-05-30 02:57:57 ERROR:ERROR: Player #2 have broken data in `data` field. Can't be loaded.
2008-05-30 02:57:57 ERROR:ERROR: Player #6 have broken data in `data` field. Can't be loaded.
2008-05-30 02:58:05 ERROR:ERROR: Player #2 have broken data in `data` field. Can't be loaded.
2008-05-30 02:58:05 ERROR:ERROR: Player #6 have broken data in `data` field. Can't be loaded.
2008-05-30 02:58:05 ERROR:ERROR: Player #2 have broken data in `data` field. Can't be loaded.
2008-05-30 02:58:05 ERROR:ERROR: Player #6 have broken data in `data` field. Can't be loaded.
@ Brett
hmmm.. im scratching my head at this one. Dunno, maybe just for kicks, how about moving your data folder somewhere apart from your reaper-x folder, say C:\wow\data.
I also recall seeing someone with a similar problem on the forums.
http://forums.reaper-x.com/topic/error-with-map-0004331map
Maybe posting the vital parts of your config file could shed some light.
@Daggo
Not luck putting the data folder in my wow folder. Heres the vitals from my config file.
RealmID = 1
DataDir = “C:\Program Files\World of Warcraft\Data”
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;cartman;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;cartman;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;cartman;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"
@Craig
woah, ive never seen that before! Did you restore your characters using the Reaper-tool? If you did, (fresh install again, sorry)try to restore your characters from an sql dump directly using your SQLyog. your backup-char.sql should work. Then (again) crate a new username/password in mangos and then match up the characters to your accountID's.
@ Brett
Oh, sorry if I seemed a little confusing. I diddnt mean to put your data folder in your 'C:\Program Files\World of Warcraft\Data'. Just somewhere very simple as in create a folder in your C: named 'wow'. So your datadir would look like this:
DataDir = “C:\wow\data”
I doubt that would solve the issue directly, just wanted to make sure all the file permission issues were out of the way.
@daggo
Yeah, I restored them using the reaper tool. (Of course something astronomical happens only to me during this shitty ass week lol) Ok, I'll do another fresh install then I'll restore using sqlyog, Then I'll create a new username and pass.. Does it have to be a new one or can i use my old one? I'll get back to ya in about 5-10 mins give or take.
Anyone know how to add portals/custom items and vendors?
@Daggo
Making the new folder didnt solve it so im gonna try extracting the maps with the batch file instead and see what that does
BTW Thx for ur help Daggo. I really appreciate it.
No prob, just want you to get up and running =)
Well that didnt work either
Hmmm I just dont understand why its says a map doesnt exist but i look in the folder and its there
from what I understand the batch file is the same as the exe only that it creates a folder in the existing directory.
ill have to study up on this bug a little more.
@Daggo
I still get the same error.
@ Brett
Hmmm, interesting. Ill have to try and recreate the issue. What version was it when you originally created your characters backup? OS? and SQL version? ill see what I come up with.
oh sorry last post was meant for Craig. /blush (yeah im tired and cant think *bonks head)
@ Brett
Open up the issue in the forums and post your entire config file. (except passwords, just put 'mypassword')
Ill see what I can do
I was using 5475 I backed up from that revision then I upgraded to 5953, backed up from the 5953 revision. I've been restoring from my latest backup. I'm using Windows XP Pro Retail SP3 and I'm running Mysql server 5.0 like the old guide said to use from quite a few revisions back...
Hope that helps you.
I'm gonna try to create a new account and a new character and see if i can manually replace the tables from the old character to the new character.
I keep getting the same error of a compatibility problem with map file 0004331.map.
Map file 'C:\Reaper-X\Reaper MaNGOS 5953\data/maps/0004331.map' is non-compatibl
e version (outdated?). Please, create new using ad.exe program.
I've used the ad.exe after getting the error but it made no difference. I also got an error for the path file to the maps, vmaps, and dbc files. The path is correct and was set in the realmd.conf file.
Correct *.map files not found in path 'C:\Reaper-X\Reaper MaNGOS 5953\data/maps'
or *.vmap/*vmdir files in 'C:\Reaper-X\Reaper MaNGOS 5953\data/vmaps'. Please p
lace *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDi
r value in the mangosd.conf file.
Help please!!! My game is patched to 2.4.2, any have an idea why there is a problem with the files?
Sorry meant Mangosd.conf instead of realmd.conf
Any idea when we will see the addition of the AH bot?
Fair notice!! Either it's just me, or it seems that mobs are aggro'ing sooner and/or further away than the 5472 edition. Is there a way to dial it down a bit?
@ EVERYONE WHO WANTS CUSTOM VENDORS and reaper if you want to use this
CUSTOM VENDORS MADE AND SPAWNED
only thing is I hate when ppl have to get the stupid item requirements for T3 and up so all the extended costs are taken out so whenever something is bought your mangos will give you an error saying "incorrect extended cost" but if u want to fix it do it urself
Its on filebeam [URL=http://filebeam.com/24cee7fa8ca67c7f85df85e18f5e88b0]Here[/URL]
uhh whoops not sure if that one works
Here
I'm getting this error:
ERROR 1136 (21S01) at line 24: Column count doesn't match value count at row 1
When I use option 7, Installs the Optional GM Island Vendors!
Do you have an update, Jared?
Help please.
hi guys, nice work oatman, great release, everything is running nice and smooth, one question..
anyone knows whats the best loot rate for the boss, cause when we kill some boss they usually drop like 3 or 4 things nomatter if we change the loot from 10 all the way to 900, so anyone knows whats the best loot rate or how to change the loot from the bosses??
Ok I got it all working, but a lot of the quests in the game are being buggy, stuff won't spawn, and doing certain things won't trigger the completion of the part. Is there anything I can do to fix this? At first it was just 1 quest, but now its a ton of quests. Any help would be apreciated.
firane thx for the file but when i rename it to vendors and try to run via the option 7 in the reaper installer i get a error 1062 at line 2: duplicate entry '96635' for key 1
am i doing this wrong is thier ne other way to insert this into the creature template via sqlyog or whats up?
nevermind i got them in and going just had a error somewhere and had to manually spawn them no biggy thx again
awesome job reaper, but i do have some issues i'd like to bring to attention:
first off the attack range of mobs is WAY too close, like when i try to back up just a little the mob follows and sticks really close to me like glue..any solution to this?
and secondly, which is not that important to me, but would still like some input on it, is why aren't there any mobs in the Kil'Jaeden raid on sunwell isle? do i need to complete the prereq. quests first for the mobs to appear so i can run that instance and witness the events?
gotta say though, i am impressed with the improved quest and npc scripting..good job! :)
The vendors you gave oss firane doen't work :(
I've just installed this version of Mangos, however I'm getting an error when I start mangos.exe.
World Database: 127.0.0.1;3306;root;mangos;mangos
Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@
'localhost' (using password: YES)
Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos
Any insight into my problem?
yes your problem is you need edit your mangosd.cfg and change this 127.0.0.1;3306;root;mangos;mangos
to this
127.0.0.1;3306;root;YOURMYSQLROOTPASSWORD;mangos
but you need change it in all World database character database ...
is it just me or is this release a little more resource hungry my pc doesnt seem to like it very much but other than that it seems to work.
great job once again
thanx
@BaDBoY: Thank you for your response, I changed the three lines to include my password. However now I'm getting this message.
World Database: 127.0.0.1;3306;root;mypassword;mangos
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.56
MySQL server ver: 5.0.51b-community-nt
AUTOCOMMIT SUCCESSFULLY SET TO 1
Character Database: 127.0.0.1;3306;root;mypassword;characters
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.56
MySQL server ver: 5.0.51b-community-nt
AUTOCOMMIT SUCCESSFULLY SET TO 1
Login Database: 127.0.0.1;3306;root;mypassword;realmd
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.56
MySQL server ver: 5.0.51b-community-nt
AUTOCOMMIT SUCCESSFULLY SET TO 1
Realm running as realm ID 1
Using UDB 0.10.2 (351) for MaNGOS rev. 5949 with SD2 SQL for rev. 414
Using DataDir ./
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: ./vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Check existing of map file './maps/0004331.map': not exist!
Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmap
s'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correc
t the DataDir value in the mangosd.conf file.
Hello!
i just started option [ 4 ] mangos character data and or FULL database restoration... and it has been rolling like 1.5hours now.... 30 minnutes still.. and its eating all my memory and cpu.. is there eny way i could confirm is it doing enything.. or do u know why its still in the same place than 30 minutes ago?
PS: i love this software and could respect if u answerred fast : )
my server works fine now and i can play on it but when my friend is connecting to my server in the same network hes getting the logging in to same server problem. does someone know my problem?
Ok I'm having a few problems with the server and I don't know whats wrong.
1st, some of the quests don't acknowledge that certain steps are being completed.
2nd, certain parts of the quests aren't even appearing, mostly npc corpses and stuff like that.
3rd, combat doesn't end till like 5 seconds after I kill the enemy, not that bad but kind of annoying.
4th, many many enemies are like glitched under the ground. You can see there names, and only the top of them walking around.
5th, and last a lot of npcs and enemies that patrol freeze in place and then like teleport far away. You can't talk to them while they are frozen because the game registers them as walking.
Any help on any of these would be greatly appreciated. And keep up the good work.
@djosh @who wants custom vendors
ok im sorry but wtf do u expect its a fake wow server basically, it won't be perfect and if ur not happy then make one urself seriously.
and if your getting glitched under the ground npc's then enable vmaps in mangosd.conf
for custom vendors go
here
@Zalgradis
make sure your datadir is set to the correct place to where your vmap folder is
if its just inside your reaper folder then make it say datadir "." with the period inside
either that or u need to use the updated ad.exe
@Zalgradis
Go into your mangos config folder and change your Datadir="." to Datadir="C:\[to your data files]" maps, vmaps, and dbc files.
@Mixudjinn
Restoring the full database may take some time depending on your processor speed. And there are some points where it just sits there for a while (no biggie). If it seems very sluggish, then freeing up some user processes/ram before running the script may increase performance.
@Weiss 935
There are a few howtos on this site that will show you how to create a lan party. I have mine set up this way:
http://www.reaper-x.com/2008/02/04/how-to-set-up-public-wow-server/
Its where my realmlist is set to my External IP address and port forwarded to my realmd, mangosd, Sql server.
@djosh
This isn't so much a Reaper-x Repack problem as it is more of a Universal Database and MaNGOS team scripting problem. UDB are the guys who actually do the quests and such and the MaNGOS are the gys who brings everything to life. They dedicate their time and talents to bring us this game as close to the original Blizzard servers as possible. Of course many things aren't going to be perfect but some things are manageable. Reaper brings us a wonderful easy to use package compilation of all the necessary files and databases we need to get things started.
Also, make sure that you have ScriptDev2 working properly. Go into your ScriptDev2 config file and input your username and password into:
ScriptDev2DatabaseInfo="127.0.0.1;3306;root;[PASSWORD];scriptdev2"
and start up mangos to see if it loads properly. (You will see it near the end.)
If you have problems with NPC's/creatures walking through walls, then enable vmaps, and Line of Sight in your mangos config
vmap.enableLOS = 1
vmap.enableHeight = 1
It will eat up more of your processor but can solve many issues.
i am stuck on the part whre is says what is your wolrd/mangos database name... what do i put there?
this is my first time install mangos... is this just a update?
ok... i typed in all the stuff it says most likely... and after i type in the last thing... scriptdev to and hit enter it says 'mysql' is not recognized as a internal or external command operable program or batch file. it says that 3 times. what am i doin wrong?
i noticed a lot of people are having this problem but i dont see anyone saying how they fixd it
ok i copy and pasted the dir and it worked now... now my ext problem... when i run mangosd.exe connot connect to world database 127.0.0.1;3306;root;mangos;mangos any ideas?
Hello again! i got my problem fixed with installing mangos again BUT now i have a new problem!
ive done everything as the guide says to do AND
when i try start mangosd.exe it says
"unable to find component"
The application failed to start cos MSVR71.dll was not found.
msvcr71.dll i mean
War, I think I may be able to help you, if you have aim, pst me @ xSerpentKnightsx and if anybody would like to help me test the server pst me on aim as well. :)
@Mixudjinn
Install this .dll:
@http://www.dll-files.com/dllindex/dll-files.shtml?msvcr71
and now im having the same problem as war
LoL
Would you like to take this to the instant messenger of your choice and I can give it a shot to help you out?
yes sure : ) i would love to
Alrighty, my AIM screenname is xSerpentKnightsx, unless you prefer another IM client.
Hey everybody.
Is there any Auction Bot in this version of MaNGOS?If so, how do you set it up/use it? Thank you.
~Jink
@Jink
Yes, AH bot works in this version. First you need to create an account for your bot. Then by using SQLyog navigate into your characters.characters table to find out the GUID and Account . Put these numbers into your mangos config file:
AuctionHouseBot.Account = [Account number]
AuctionHouseBot.GUID = [Guid Number]
AuctionHouseBot.NoMail = 0
AuctionHouseBot.AllianceItems = 1000
AuctionHouseBot.HordeItems = 1000
AuctionHouseBot.NeutralItems = 400
Next, set the number of alliance/horde/neutral items that will spawn in eash AH. There are also many other configuration to tweak your AH settings, but this is a short simple way of getting things started.
Thank you guys I think I got it working now. :D
Hey guys, Reaper, I have a quick question for anyone.
My current DB verion is PSDB X9 SD2 297. Will all my .SQL's dump fine in this version or should I wait for a later release for something more compatible?
Thx
i got everything set up working good. i wanted to know how easy it is to xfer everythin from 1 of my computers to another. like what files i would need to copy over and all that without having a big problem. and with0ut starting new. can anyone help me out? my AIM is wardogbobie. If somone can help me out i will send them $20 paypal.
People who are getting not recognized you have prob downloaded 5.0 instead of 5.1 so make sure you are typing in the correct directory i did that mistake :D im just having problems setting up accounts on it as of now as it wont let me edit my config files through the reaper-x mangos.bat it says do it in note pad and i cant see where to add accounts and change them to GM's
Relaying this to this page as well since I noticed someone had this issue here:
For those that receive:
Loading game object templates…
Error in game object_template tables, probably sql file format was updated (there should be 33 fields in sql).
I found that it was me mistyping or not filling out the installation/update questions. I was assuming it auto filled the defaults into it but it does not. Once I filled them in manually all was well!
I talking about these questions:
(All you need to do is type what the most likely name is or your custom name if you did it differently)
What is your MySQL database USERNAME ? (Most likely “root”)
What is your database PASSWORD ?
What is your World/Mangos Database Name ? (Most likely “mangos”)
What is your Characters Database Name ? (Most likely “characters”)
What is your Realmd Database Name ? (Most likely “realmd”)
What is your ScriptDev2 Database Name ? (Most likely “ScriptDev2″)
Yeah I understand, I was just wondering if there was something wrong with mine specifically and if there was a way to fix any of them. I know this is an amazing program, and I thank for all the hard work they all put into this, I just wanted to make sure it was running right and I wasn't doing anything dumb. Thanks for the help, its running better now.
@Draggo
Sorry, but i have no idea how to use SQLyog XD. Can you help me with that? Thanks
~Jink
There is an easier way to see your GUID and Account numbers. Create your AH bot character and login with him.Also make sure you have set GM level 3 for that character. Inside the game type:
'.pinfo'
It will show you misc. information about your current player. It will also show you your Guid and account. Hope that helps.
SQLyog is a program you can use to directy edit your database. Its a powerful tool and can also be used to import/export .sql scripts (such as the current vendors script). heres the download
http://www.webyog.com/en/downloads.php
Once opened, you will be able to see your databases and the tables information inside of each.
@Daggo
Thanks much for your help. I have found an easier way however(!) If you use Quice, you can go to "characters" tab and it will tell you the account and GUID for that character....and all characters you have created (if you need that for some reason...) Thanks though ^_^! What i need to know now is how do you USE the AH bot? do they spawn somewhere?
~Jink
Also, I CAN'T GET THE GM ISLAND VENDORS TO FREAKIN' WORK! I get the same error as everyone above (column count doesn’t match value at row 1, or something similar) what do i do to fix this?
Ok my bro is now trying to install it on his comp, but he is having some trouble, its not showing him his ip address anywhere so he can't set it up completely. Any help.
Ok another problem, sorry for the double post. My bro can't change his realmlist.wtf file. It won't let him save it no matter what he does. Is there any way to get around this or anything?? Thanks for the help.
can u send the error message over here?
but also i have a problem...
so. I have mysql 6. i started install the server but it seems like im having alot of problems. first and worse is that this reaper-x-mangos sorfware works incredibly slow.. i started part 1 the install. but it seems like it rolled over 3 hours
and i dont have a slow computer...
enyone knows the reason?
@jink
Im not sure quite what you are asking. All the AH bot does is it runs passively through mangos to automatically load your auction houses. You dont need the character logged in the game for it to work, nor is there a 'bot' in game which contains all the items. Just find your local Auction House guys in each major city and it should be loaded. You will notice that the seller would be the name of your created AH bot character.
Btw, thanks for the Quice idea. I havent had the chance to use quice but now im very excited to try it out =).
The GM vendors in this repack release will not properly load because the script is out of date. Its incompatible with 2.4.2. What you can do is this.
Download the latest .sql script that Firane provided in his post from:
http://filebeam.com/24cee7fa8ca67c7f85df85e18f5e88b0
This is how I did it. extract the contents of the zip. Then open it up in a notepad, you will see a bunch of jibberish (code). Open up your SQLyog and copy all of the content from the notepad and paste it into the 'query' box. Right click > Execute query > Execute All Queries. You will most likely recieve a bunch of error messages. The messages indicate that the vendors are unable to spawn in their proper location but at least they are loaded into your database for you to spawn wherever you like ingame. I would recommend waiting for the next repack for the custom vendors, but if you really really want them. This is sort of a ghetto way to get them in. Also, if anyone successfully found a better way to get vendors in, please share.
@djosh
Im guessing you are using windows vista. It is definitely a file permission setting in your realmlist.wtf file. Right click the file and select properties. Navigate to the 'security' tab. Select your username from the 'Group or user names:' box and hit 'Edit..." another dialogue box will pop up. again select your username and under the 'Permissions for users' area, hit Full controll allow check box. This will give any user full control over the file. That should do it.
Also a quick way to figure your ip address would be to go Start> run , and then type in 'cmd' (no quotes) then in the command prompt type 'ipconfig'. It will shou you info on your network devices. note: in vista you need to type 'cmd' in the start > search bar.
@Mixudjinn
Ive heard that many have had issues with sql 6.0 in the past. I havent used it personally (yet) so I dont really know. I recommend installing 5.0, or 5.1. Granted it doesnt have all the bells and whistles that 6.0 does but will do the job just fine if you are using it only for mangos. 6.0 seems like overkill to me at the moment. Its possible this may be the issue. The install shouldnt take nearly that long even on an older cpu. How high is your cpu/memory utilization before and during the install?
this is probably a stupid question, but when i back up my character data, what is the standard characters database name?
i have tried to use the ad.exe via the batch file and by makeing my own map folder but it always seems to get stuck at 41% and just stays there is there something i could to to fix it? or am i just screwed? i can just revert back to 2.3.3 witch works fine but the new ad.exe hates me.
thanks for any help
hello all i am looking for a expereinced gm for my server if chosen u would have full gm rights to my server if enterested please send me a email goodboy3242003@hotmail
looking for experienced gms please send email to goodboy3242003 @ hotmail if enterested
Seriously, is there a way to dial down the aggro? I've seen mobs charge me when I was considerably further away in this recent repack than 5472. Also, none of the mobs who can use magic do so. I recently defeated the Collector and his 2 cronies, including a mage, and the mage didn't even throw 1 fireball like she did in repack 5472. Is there a way to change this as well? I almost felt guilty in how easily I dropped this bunch of Defias goons.
i have a problem for gm isle's vendor. With Daggo's sistem it isn't work
@antielfi
The process I provided will only input the vendors into the database FOR YOU TO SPAWN ingame. Its because the script is inconsistent with the current version concerning the initial spawning point of the vendors. Therefore, my method will NOT spawn all the vendors to start with but will require you to manually '.npc add' the vendors ingame. Its a crude way to get vendors in but if you really want them without waiting for the next repack, this is an alternative. (Or until I find am up-to-date vendors script)
@STG Mac
Check out the mangos config file under:
#CREATURE SETTINGS
#
# Rate.Creature.Aggro
# Aggro radius percent or off.
# Default: 1 - 100%
# 1.5 - 150%
# 0 - off (0%)
Fiddle around with the
'Rate.Creature.Aggro = 1'
See what happens.
@Everyone who couldnt get my vendors to load
I made some typos so in a sec ill put up the correct and working version
sorry everyone
@Custom Vendors!!!!!
NEW RELEASE OF CUSTOM VENDORS WORKING FOR REAPER MANGOS
If you get an error when importing it to your database then you need to delete the entire reaper database and make a new one (because of duplicate errors)
here it is =D
Here
hey I've been able to get through a few problems I've had but I cannot figure out why mangos and realmd will not open up. This is the message:
World Database: 127.0.0.1;3306;root;mangos;mangos
Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost'
MySQL seems to to working and the pass is right so I don't know.
ok, i figured out the database for characters, feel like a retard. but i have another question. i had to do a fresh installation because i had version 5116 and this version can only upgrade from the last. once i finish the installation, how do i get my characters back?
@craig your problem is that you didn't put your password in the mangos and realmd file. Where it says 127.0.0.1;root;mangos;mangos change the first mangos to your password you set up for your database.
@custom vendors
I see its already been downloaded
tell me if its working for you
i am looking for expereinced gm's for my server please email me if enterested at goodboy3242003@hotmail.com
Hey everyone! Just wanting to know if my current DB's SQL's (PSDB X9 SD2 297) are compatible with this release of Mangos. If anyone could let me know, that'd be great! (I have people waiting for me to update to 2.4.2 so I wanna make sure their character data and account data are good to go. Also all of my custom vendors/items need to make a smooth transition over as well as my WebSite info.)
Thx!
@Firane - custom vendors
Errors while importing for me. I noticed that in the script it tries to input '`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`' into the creature table which these columns do not exist in the current 2.4.2 table setup.
@Daggo Everyone else
Ok i didn't realize I was using and outdated reaper mangos Database
so this is the correct working one
sorry for the inconvienience
but this works =)
(and if it fails wipe the reaper mangos database from your SQLyog and reimport it)
Last and Final Release until a new Reaper Mangos
OMFG OK I GOT THIS
i did another typo so it didnt freaking work
ITS GOOD TO GO NOW
I SWEAR
this one works zomg!
sry for doing mas errors
here ya guys go
also its about 1/10 of the size
(im trying hard here lol)
Here
hey i was just wondering if someone knew where the item database ie.... i need it for my custom items
@Firane
I got it working with a little tweaking in your script! Ill post it in a sec
******************************************
THE FIX FOR VENDORS !!!
Download this file and extract the contents to your Reaper-x-mangos folder and overwrite the previous vendors.sql. Then run the script from the reaper mangos tools.
http://filebeam.com/739d346276bdf95e48910b8bd85b85c0
We give gratitude to FIRANE who provided us with the script!
******************************************
@Firane
ok this is the tweak I did. After a clean install I noticed that the .sql script you provided us has many of the guid's overlapping with the clean install database tables in 'creatures'. So I altered the guid's to input from 97085 to 97243 and also deleted the rows 54-49999 which were inneccesary for the script. (looks like you extracted your whole npc_vendors table by accident lol. This eliminated all duplicate errors and ive tested it on two of my realms, one clean and one chuck full. works both ways. =) Thanks for your help bro!
@Firane
ack! Touche, you beat me on the upload. I was working on your 'Last and Final Release'. Good show mate.
Hey!
Im trying to make my own customised item.. i use heidiSQL program..
so when i try to import my file (wich i made in "http://wow-v.com/") it says "SQL error: unknown column 'ExtendedCost' in 'field list'
if someone could help me plz
i would just like to say thank you too all those that helped me and to reaper for making the server.....
i have got my WOWBC to work.
Great job once again!
Everything working great, except a few quest. For example, the event in BFD to open the door to boss doesn't work.
NPC's will stop and talk, you have to follow them around.
Any idea on how to fix this?
Is it possible to save your progress within a raid instance so that when I restart MaNGOs the next time I can pick up where I left off (kind of like on the retail servers)?
I'm getting duplicate errors when importing the newest GM vendor SQL file. What parts of the mangos DB do I need to delete to avoid this?
@Daggo
Yea my typo was that in SQLyog I typed in some command wrong and like 50000 tables got left in lol
so when I tested it on a blank table it worked fine... haha
It took me 4 times to get it right
ive never done this before D=
but yea now this is a working script
well more so this
WTF?????? WHY IS MY LINKS NOT WORKINGZ?
how about this?
They only became blue..
wierddd
If I delete everything in creature and npc_vendors then import your newest script, will that leave me with ONLY the GM island vendors?
I can't get it to properly execute because of the dupe errors.
@JesseWVU
The best way to get the vendors in is by doing this:
#1 Backup your current characters database
#2 Go in to your C:\Program Files\MySQL\MySQLServer5.x\data\mangos, and delete ALL of the contents within that mangos folder.
#3 Fresh install using the Reaper-x-mangos tool
#4 Restore characters
#5 Run vendors script
@Firane
I noticed that when the script is run a second time, that is when you will receive a duplicate error. Maybe we should work on the script to 'replace' or 'remove' the current entries before insterting the data into the tables. Ill look into it.
Anyone know if Reaper-x or Oatman is alive?
Ok after searching around the net i still cannot get my online account registration page live i am using rospora v1.32 this was a antrix page setup im running mangos i thought it would be easy to fix i guess i was wrong i really could use some help setting up a working account registration web page currently my registration page does know the server is online and the players that are on it however when attempting to make an account i get Creation of account
vsdfdsfs
was not possible !
not sure whats going on canb ne one help please feel free to email me the info at goodboy3242003@hotmail.com
@Daggo & Firane:
Thanks, everything imported fine after a reinstall and using the newest vendor.sql file. Just one more question; How do I make them spawn on GM island? Can I get the NPC ids from somewhere?
Got it! I was entering the 'GUID' from the SQL file when I should have been entering the 'ID'
So walking around in the building I can place the vendors by typing:
.npc add 500001 through .npc add 500030
Thanks guys!
@Daggo
yea it didn't feel like changing the whole thing after screwing up 4 times so i just left it
but i just guessed no one would import it multiple times
I'm having a problem reextracting the maps, whenever I run the extract-map.bat, I get an error that something's wrong with ad.exe? Any suggestions as to what might be causing this?
Hi there. First off, my compliments on your fine work. This is an amazing piece of software and I commend you for your hard work.
Okay, on to my question...
I'm golden on the install and running of the program, but when I enter the "create account password" command in Mangosd, it gives me the following error:
SQL Error: Unknown column 'sha_pass_hash' in 'field list'.
I'm really stumped on how to fix this, and I'd appreciate any advice you guys could offer.
Thanks in advance.
Ah, wait, I figured it out. Just had to get a new version of realmd.sql and I'm up and running.
However, now I get to the character creation screen, roll one up, hit create, it goes through the process, and then leaves me at the character selection screen with nothing. My just-created toon doesn't show up.
Hmm anyone knows when reaper is going 2 release that niece of software with never mangos and SDev2 revisions ?
Is there a way to modify the base stats (i.e. strength, agility, stamina) of the character with this new version of MaNGOs? I have tried using both the .mod32value and .setvalue commands and neither of them are recognized. Any help would be appreciated. Thanks.
Kinda outdaded.
Looking something like Maangos Revision 6037, ScriptDev2 Rev.424, ACID Rev. 10
If you want latest Mangos and ScriptDev2 you can always update source with TortoiseSVN and compile using C++. Latest atm is 6041 and 424. New patches comes almost every day, but i can't see any point installing whole server that often. Once in about 3 or 4 weeks is enough for me.
But still, Reaper and Oatman are doing great job. Packs are always working good and easy to install. Just read instructions carefully and there isn't any problems.
My 5 cents :P (just bored, too hot to play =) )
Heh i messed server with adding new mangos revision and sd2 installs. Thaks 2 god i had characters backed up and reverted bac 2 that release :/. But in that releas is illidan hardli bugged. He goes in non attackable state.
*************************************************
Setting up multiple realms Tutorial
To learn how to set up multiple realms go to the Forums:
http://forums.reaper-x.com/topic/multiple-realms-tutorial
*************************************************
*its my first tutorial so go easy on me ;)
@ Riven the only way i know how to change stats is to edit the armor that i have on with SQLyog. it is very easy to use, you do have to look up what some of the values mean to get the right stat to change. but it's fun experimenting :)
Custom Vendors
Just for the sake of keeping this know about i put up another post cuz most ppl dont look at the whole page
Custom Vendors
I am getting the following error on a fresh install.. I know the username and password are correct, as I can log into mysql just fine with them at the command prompt.:
What is your MySQL database USERNAME ? (Most likely "root")
Cyb0r
What is your database PASSWORD ?
*******
What is your World/Mangos Database Name ? (Most likely "mangos")
mangos
What is your Characters Database Name ? (Most likely "characters")
characters
What is your Realmd Database Name ? (Most likely "realmd")
realmd
What is your ScriptDev2 Database Name ? (Most likely "ScriptDev2")
scriptdev2
--------------
DROP DATABASE IF EXISTS `mangos`
--------------
--------------
DROP DATABASE IF EXISTS `realmd`
--------------
--------------
DROP DATABASE IF EXISTS `characters`
--------------
--------------
DROP DATABASE IF EXISTS `scriptdev2`
--------------
--------------
GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUE
RIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0
--------------
ERROR 1045 (28000) at line 9: Access denied for user 'Cyb0r'@'localhost' (using
password: YES)
ERROR 1049 (42000): Unknown database 'realmd'
ERROR 1049 (42000): Unknown database 'characters'
Please wait it'll take a while to import the database
Press any key to continue . . .
ERROR 1049 (42000): Unknown database 'mangos'
ERROR 1049 (42000): Unknown database 'scriptdev2'
ERROR 1049 (42000): Unknown database 'mangos'
ERROR 1049 (42000): Unknown database 'mangos'
ERROR 1049 (42000): Unknown database 'mangos'
ERROR 1049 (42000): Unknown database 'scriptdev2'
Done
If you see any error message just let me know
Press any key to continue . . .
I've been trying to work through some problems, but I'm stuck at something I haven't found in the comments thus far.
When I run mangosd I get this message:
2008-06-03 18:45:06 ERROR:SQL: DELETE FROM ip_banned WHERE unbandate<=UNIX_TIMESTAMP() AND unbandatebandate
2008-06-03 18:45:06 ERROR:SQL ERROR: Table 'realmd.ip_banned' doesn't exist
2008-06-03 18:45:06 ERROR:SQL: UPDATE realmlist SET color = 0, population = 0 WHERE id = '1'
2008-06-03 18:45:06 ERROR:SQL ERROR: Table 'realmd.realmlist' doesn't exist
2008-06-03 18:45:56 ERROR:SQL: UPDATE realmlist SET color = 2 WHERE id = '1'
2008-06-03 18:45:56 ERROR:SQL ERROR: Table 'realmd.realmlist' doesn't exist
And when I run realmd I get this message:
2008-06-03 18:45:59 ERROR:SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel, population FROM realmlist WHERE color 3 ORDER BY name
2008-06-03 18:45:59 ERROR:query ERROR: Table 'realmd.realmlist' doesn't exist
2008-06-03 18:45:59 ERROR:No valid realms specified.
Could someone please help?
@gallwin: I'm having the exact same problem. I can't select the MaNGOS realm to create a character.
Anyone know what's up with that?
@Saerra
it means u dont have a realmd database
use reapers thing to make a fresh install
thanks for this nice review, but what should i do next?
I did all this, but what should i do now? i mean i want to create homepage, where everyone can register, see map and other stuff.. how can i do that?
Just a random question for in the game. Is there any way to increase the quest cap?? 25 is kinda low for me lol, seeing as I like to do every quest, and I don't know where every quest is and when I see them I like to pick them up. If not oh well, I can live with it, bit if there is that would be awesome. Thanks.
Well, I have previously made a Mangos Server on an old one but dropped it, when there was no updates.. but now i'm back and making this update but I am having trouble with this one thing..
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: ./vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Check existing of map file ‘./maps/0004331.map’: not exist!
Correct *.map files not found in path ‘./maps’ or *.vmap/*vmdir files in ‘./vmap
s’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correc
t the DataDir value in the mangosd.conf file.
and NO, I'm not stupid I have set the directory path to where my data is.. I was in WoW Main folder and both the ad and extract-map files create map files in the "map" folder but none in the "vmap" folder, any know as to why it comes up with this? This is the sole reason as to why it has errors.. if i get this file to make files in "vmap" id be right to go..
If anyone has questions and answers regarding my question, you can contact via by my e-mail. Jeszce_Polska_Nie_Zcinela@hotmail.com Thanks.
Has anyone come across having the database load then like 10-20 mins later it says
"sql:update uptime set uptime = 600,max players = 0 where starttime = 1212603298 sql error:mysql server has gone away." I can reload the game and it works just fine. Just wanted to fix it. im currently using windows server 2003, mysql server ver. 5.2.3-falcon-alpha-community-nt mysql client library: 5.0.56. using current ver of mangos. thxs.
Hey everyone, first of all id like to say great work to everyone who is working on these private server releases, i have been using them for a while and had no issues at all until now, unfortunately hehe but even still great job :D
My problem is that when i start mangos it says that a certain map file is invalid or outdated
WORLD: VMap support included. LineOfSight:1, getHeight:1
WORLD: VMap data directory is: data/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Map file 'data/maps/0004331.map' is non-compatible version (outdated?). Please,
create new using ad.exe program.
Correct *.map files not found in path 'data/maps' or *.vmap/*vmdir files in 'dat
a/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or
correct the DataDir value in the mangosd.conf file.
i used the map extractor that was included with this release, how can i overcome this problem? is there a more up to date version of the map extractor or something? eveything has worked fine up till this point on and now im stuck lol
I fixed the problem with mysql server gone away. i changed the ping times in both the realm.conf and mangos.conf from 30 to 5 min intervals. seems to be working great.
Ok, I got the former error fixed, just needed to replaced the "mangos" in the scriptdev2.config file with my username.
So everything started working, mangosd and realmd worked fine, I was able to make my account and set the gm level. (I think.)
But now WoW won't start. I put in my account name and password, but it's unable to connect. I follow the directions above perfectly, but it won't connect. Any ideas what I can do?
I got the same problem as Kyle from a while up there and i don't know how to fix it... anyone have any help?
Umm ok.. I couldnt connect MySQL Server from 'Localhost' anyone have any idea on how i can connect it back up?
With regards to the custom vendors.
instlled them with that script that was posted on the page but I am unable to use them
any idea what the problem could be
HEY REAPER,
UNDER FRESH INSTALL, you need to link how to extract maps/vmaps/dbc for new users.
i'm very satisfied with your newest release and already know how to set it up, but new people on the free-server-bandwagon need instructions of how to do it ;)
just some friendly advice. peace man
the programme seems to be functioning perfect, however when i try to access the system from a seperate machine, i can login and am transferred to the realm i created, however the screen sticks on logging in to realm server. i cannot find any error, but i would really like to hook up my second account so i can start exploring the raid content
Just upgraded from 5472 to the 5953....everything works, but the realm I had under the old along with all my characters are gone. Tried to go back in & run the reaper x-mangos.exe to reconfigure, & that option is not there anymore. I tried to copy & paste over the characters.sql & realmd.sql from the 5472 to the 5953 & that didn't do it. Copied & pasted the Scriptdev2 file from the old 5472 folder to the new 5953 folder as well & that didn't help. Is there a fast & simple way of transferring the realm & characters from the 5472 to the 5953 after the conversion? I'm missing something obvious here & have several people getting upset over it. Also stuck here at work & don't have a lot of time to play with it any further. Any & all help is greatly appreciated!
HI guys, firstly Reaper and Oatman thanx for teh repack really some awsome work. Then CybOrSpasm i had the same prob once hw i solved it i uninstall MySql then Reinstall then try , and Saerra check ur configs , if the password is not the same like ur Sql password u might get that also try reinstalling the Database
@Bastian,
Go into your database using a tool like SQLyog, got into realmd/realmlist, and change your IP address from 127.0.0.1 to whatever it actually is on the network (ex. 192.168.xx.xx). That should fix your problem.
-Dopey
Just wanted to say THANKS !
installed yesterday - worked at first try
will try tonite the lan options
thanks again for the great efforts in this emulator
Okey, I've faced a problem now. I'm unable to create a GM account in mangosd. I keep getting this error message:
create MyAccount MyPasswordCLI command under proccessing...
SQL: SELECT 1 FROM account WHERE username='MyAccount'
query: ERROR: Table 'mangos.account' doesn't exist. User MyAccount with password MyPassword created succesfully. Mangos>SQL: INSERT INFO account VALUES <'MYACCOUNT',SHA1<CONCAT<UPPER,':'UPPER>>,NOW>
SQL ERROR: Table 'mangos.account' doesn't exist
SQL INSERT INTO realmcharacters SELECT realmlist.id, account.id, 0 FROM account, realmlist WHERE account.id NOT IN
SQL ERROR: Table 'mangos.realmcharacters' doesnt exist.
Any help would be greatly appriciated.
I get the
"Database: 127.0.0.1;3306;root;mangos;realmd
Could not connect to MySQL database at 127.0.0.1:
Access denied for user 'root'@'localhost'(using password: YES)
Cannot connect to database"
How do i fix this problem?
This happens when i am opening mangosd.exe and realmd.exe
Hi guys im trying to spawn portals in the game to the main cities (ie Origrimmer). I am using the admin/gm command .gobject add 176499 , However the portal spawns bt when i try to use it it suddenly becomes locked it says portal locked any1 knw hw i can spawn it unlocked ? Thanks in Advanced …
Dude The Vendors don't work for this release It gives me Error 1136 (21s01)at line 24:Column count doesn't match value count at row 1. this error is from release 5953 but good work anyway .:P:P XD
@silenium
My custom vendors
Here
Please Help
I am using WoW client 2.4.2 (8278) release
I keep on getting this error below.
Map file 'C:\WoW\data/maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.
Correct *.map files not found in path 'C:\WoW\data/maps' or *.vmap/*vmdir files in 'C:\WoW\data/vmaps' Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
I have edit my mangosed.conf file to point to the C:\WoW\data and can see 0004331.map and other maps there. Have rerun the ad.exe many times and still the same error.
any idea or suggestion with be great.
Many thanks.
Is there any way to modify the base stats (i.e. strength, agility, stamina) of the character with this new version of MaNGOs? I have tried using both the .mod32value and .setvalue commands and neither of them are recognized. Any help would be appreciated. Thanks.
Hey Wai
Try this.
Extract everything and run Reaper-x. etc etc.
Create a map and name it data and put it in the Data map. put the dbc,maps and vmaps in the second data map. I have put the mangos and realmd stuff within the second data map too.
Here is what it looks like within my case.
C:\Program Files\WOW\Data\data.
It worked for me.
Oke its kinda annoying. Ive got some trouble so I did a new fresh install but my problem now is that everything worked fine. But when to start my world of warcraft to log in to the server it talks about validate game version... How possible... This supports the latest version. Someone a resolve?
Hello.
I got the error Could not connect to MySQL server database at 127.0.0.1: Can't connect to mySQL server on 127.0.0.1 10061
Cant connect to world database 127.0.0.1 3306 root root mangos
Thanks for the tip, I will give that a try this weekend!
Hey Bob,
Try what you said. But still getting the same error.
Thanks
Hello.
I get this strange error when I try to create an account
2008-06-06 23:17:10 ERROR:SQL: INSERT INTO account(username,sha_pass_hash,joindate) VALUES('KALLE',SHA1(CONCAT(UPPER('KALLE'),':',UPPER('kalle'))),NOW())
2008-06-06 23:17:10 ERROR:SQL ERROR: Unknown column 'sha_pass_hash' in 'field list'
@Psamtik
drop all your DB's and make new ones
How did I create new Databases?
When I make an item, it shows a question mark icon while it is in my inventory, but when I equip it it acts properly, with a model and icon.
How can i make the icon stay even when it is in my inventory?
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`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `Duration`) VALUES (3, 7, 12, 0, 'Mote of the Vortex', 39200, 6, 0, 0, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 0, 0, 0, -1, 0, -1, 1, 'May be traded in for equipment', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
@ dopey thanks for the tip but i already did that. i changed the ip to my public IP address through navicat. however the other system seems to recognize the other system as it tells me the name of the realm. and says the realm is up, however it keeps hanging on logging in to realm server. could it be that i need different settings to use public IP. i'll connect my systems through router and see if it works on internal IP's
does someone know if i can set realmd in one computer and connect with mangosd from other computers?
Help...,
Please give me GM Commands for this version...
@opirt and anyone else
First off never say "GIVE ME"
makes me not want to do anything for u
but here ya go anyway
GM command list
down load the text document
and read the instructions at the top
Here
And here are my
Custom vendors
Fresh install doesnt put anything in the realmd database.
im using mysql 4.1
all other databases are fine
please help
fixed had tp edit realmd.sql email field to 225 instead of 320 and load it with phpmyadmin
for one more time, Thank you guys for your efforts. Works like a charm. 1 thing i cant understand though, what is the difference between Project Silvermoon db and Unified db ?!?!!? and what is the ScriptDev2 db that i had to create to make it work???
T.Y. :)
I am having a problem restoring my old characters from my previous version.
I used the restore function, which seemed to work ok, then ran mangosd.exe and realmd.exe, ran the wow.exe file to go into game, logged in with account from previous version, and it came up, but with no characters.
I then see in the mangosd the following errors:
Loading char guid 2 from account 5.
ERROR: Player #2 have broken data in `data` field. Can’t be loaded.
Loading char guid 4 from account 5.
ERROR: Player #4 have broken data in `data` field. Can’t be loaded.
Loading char guid 7 from account 5.
ERROR: Player #7 have broken data in `data` field. Can’t be loaded.
Loading char guid 9 from account 5.
ERROR: Player #9 have broken data in `data` field. Can’t be loaded.
Loading char guid 10 from account 5.
ERROR: Player #10 have broken data in `data` field. Can’t be loaded.
Loading char guid 12 from account 5.
ERROR: Player #12 have broken data in `data` field. Can’t be loaded.
Loading char guid 13 from account 5.
ERROR: Player #13 have broken data in `data` field. Can’t be loaded.
I see this error mentioned before, but there didn't seem to be a solution for it that worked. Any suggestions/help please?
@Bastian,
I was refering to your internal address within the network. Pointing it to your public address is only needed if you are trying to connect from outside your network. So instead of putting your ISP-provided IP (ex. 24.10.87.xxx) put your IP address that you use from inside your network (192.0.XXX.XXX).
Help!
I can't get through stage 3-4-(5).
When I write my "MySQL BIN path", the following comes up:
http://images.reaper-x.com/blogs/menu.jpg
But what then?
How do I choose one of the options?
What's the "1&Prime?
("4. Selection Option 1 by pressing "1&Prime" on the keyboard and pressing enter.")
What kind of button is that? Some kind of American button? :S
Forget my earlier comment.
Dno why but before It just didn't seem to work. So I got a little confused.
Anyway, I should be done with step 6.
But mangosd.exe won't really work.
It says "Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos"
-realmd.exe won't work either.
When I did the 4-(5) step, I just typed all the defaults (except from my password).
I haven't changed anything, so everything should be set to default. (Like "mangos", "ScriptDev2", etc.)
I'm somewhat confident, that I've completed it.
I did get this socalled 'Matrix'-effect.
Well, I did get to see a lot of numbers being displayed in the Command Promt.
So... What can I do? I can't quite figure out, where I've made a mistake.
Also, does anybody know if 'set realmlist 127.0.0.1' works for everyone?
im tryin to get this thing set up. is it possible to make this run on a wrath of the lich king alpha client?(im downloading tbc atm so i cant extract) also i would like to know if there is another link other then rapid share which only lets me download 1 file per hour for the maps. if i could get a link off all the maps and vmaps without waiting for my download of the tbc client to be finished, i could test it out with WotLK, and also i would like to know how to set up new accounts manually. i use navicat for mysql and cant seem to figure that out. i am a noob and reaper has done an excellent job in explanations and his softwares. greatly apreciated
Hey, I have a problem. Almost all the NPC's and creatures in instances show yellow. I can attack them, but they won't attack me. Also, council will not die, even with .die. It says I can't attack Illidian either. Lol, please help.
# sirfredalbob
are you using the .gm on command? if so then try typing .gm off because if you have gm status enabled mobs won't attack you ;)
# austin
haven't tried the lich king alpha client yet :( as for rapidshare well since i can't mirror it to other filesharing website because my upload speed is 8 KBps at max and it's impossible for me to mirror it elsewhere :(
# Wonkinator
if you get cant connect message that means mangos can't access your database for some reasons like:
1. MySQL Server is not running yet
2. Incorrect username and or password
# john
if you use the restore function then you'll need to run the upgrade once again because the character structure has been changed (because the previous backup still use the old structure)
Hey Reaper when did u get it to where both or our comments are in black cause thats really cool. It used to be that only the poster had theirs in black but I really like this new addition.
Welcome back guys ^^
Hey, Reaper im sure that some other people had this error and i dont know if its been fixed or whatever but when i try to run the fresh instalation and i put in my Username , password wich i am 100% sure are correct i then Type in Mangos for the worldDB and Realmd for the Realmdb and so on then it says
'mysql' is not recognised as an internal or external command, operable program or batchfile
a couple of times over then says 'Done'
And the lovely as always "if you see any error message let me know" so here i am, hopeing its a simple problem.
# Oatman
right before i write about the maintenance completed on my twitter and now it got pulled of too directly and can be seen at top right side of the sidebar :D
# Hello
Helloo too, ahaha thanks
I guess you're working pretty slowly or are you fully back on track now Reaper?
Looking forward to see your upcoming releases, since I dont know how to update them from other Mangos releases. (not yours)
# Whats up?
Well now i can use my computer again, but the doctor still said that i shouldn't be on computer for too long so i guess that means 4 hours is not a problem lol (well back then i often not sleep for more than 36 hours) :)
Anderek again, i really hope you guys will be able to get a WOTLK Alpha private server running as they already have them popping up in places, the website with the alpha downloads and information about private servers is:
http://wotlk.wikidot.com/
Good Luck on getting it to work guys i know you can!
welcome back guys, and thanks for the help and the great upgrade Reaper - look after yourself!
Cheers.