Reaper Mangos 5116 with Scriptdev2 247 - Easy WoW Private Server compatible with WoW 2.3.3
By Reaper-X on Feb 2, 2008 in Reaper Mangos, Reaper Mangos Mod, Software
This is the old version, get the new Reaper Mangos 5225 instead
Another update for Reaper Mangos, because mangos has officially support the 2.3.3 client of WoW … which means in order to use this, you’ll need to update your old 2.3.2 version into 2.3.3 because the previous (2.3.2) version is no longer supported … and if you still use the old client you’ll be unable to login :)
Also because it seems that some people want to switch database just like the old release of Reaper Mangos, i’ve decided to include the Silvermoon Database once again, which means you can switch between UDB and PSDB to test which one fit best for you ;)
And without further ado, here’s how to use it :
Download Reaper Mangos :
Optional :
Fresh Installation :
1. Read my post on how to install Reaper Mangos from scratch (fresh installation) (i’m sorry the screenshots a little bit old, i’ll update it later) :)
2. If you plan on activating / enabling the Auction House Bot, you can use the Reaper-X-Mangos to get your character GUID and ID, read below for more info on how to activate auction house bot :)
Note: Vmaps isn’t enabled by default even if you’re using the Reaper-X-Mangos.exe to edit your configuration files because some people have problem with VMaps and in order to enable it you need to open mangosd.conf and replace :
vmap.enableLOS = 0
vmap.enableHeight = 0
to
vmap.enableLOS = 1
vmap.enableHeight = 1
To those who are upgrading from the 5082 version here are the steps :
1. Create a backup just in case something goes wrong and copy / move the backup file somewhere
2. Run the reaper-x-upgrade in Upgrade directory to upgrade your character table with the new SQL for GuildBank
3. Now create a backup again so your character backup is using the new char table and don’t run the upgrader again
4. And finally you can choose between Silvermoon database and UDB ;)
Note : If you have already extracted DBC, VMaps, and maps from wow 2.3.3 you don’t need to re-extract it again, but if you’re still using the old DBC from WoW 2.3.2 then you’ll need to re-extract the DBC Files only because the only changed is in the DBC files
Also finally, currently i’m having a big problem and that’s because … the area where i lived got flooded once again (i just hope this time the waters doesn’t get inside my house though like what is happening on February last year / 2007) or else i’d have to evacuate somewhere
So if you have posted comment / have sent me an email message and i didn’t respond, i’d like to apologize because of the current situation i’m facing now … for more info about this, you can try searching for Jakarta Floods 2008 using Google or your favorite search engine
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
I can't connect to my server.
It just says unable to connect..
I tried 192.0.0.1
and my lan ip and public..
it worked yesterday for me but now it doesnt
Kurt could you try using the default 127.0.0.1 ? (change the realmlist ip to 127.0.0.1) and also make sure that the realmlist.wtf file also point to 127.0.0.1 for test purpose to check whether the problem lies elsewhere
Reaper-X
Thanks for the new version. Is it my copy of mangos.conf or is the mangos.conf kinda messed up, all mashed togather?
Thx again.. will download and use :P
Good luck with the flood.. that really s***
Thanx again for another great version. I'll send you a canoe as soon as i can lol jk, oh and 1 more question how can i make Tempest Keep weapons usable everywhere?
Lazy reader here... but can I choose between Silvermoon and UDB from upgrade or only fresh install?
# Saktron
ah i believe that is because mangosd.conf use UNIX Line break (not Windows Line Break), if you want to see it properly under windows you'll need to use Wordpad to edit it ;)
btw i believe i have converted the line break into windows line break
# AceWinner
Thanks :)
# vibe
Yes, but you'll need to edit the database directly or you can also use this command :
1. open command prompt
2. type mysql -uroot -p
3. type this
UPDATE mangos.item_template SET map = 0 WHERE map = 550;NOTE : It'll not ask for your confirmation (and there are 9 items)
# Okono
You can switch between UDB and Silvermoon anytime you want :) ... but if you're upgrading make sure that you've upgraded your installation first (and don't run the upgrader again) because of the new structure in your character database (well the new table is for GuildBank) :D
Ok well I got my server to work again but now the problem lies with people trying to connect INTO my server..
I made a dns ip with no-ip.com but people aren't able to connect to it..
I can connect to it MYSELF but others cannot
Reaper-x
Thank you, your the man. wordpad worked great. just been using notepad for so long didnt think to check wordpad.
be safe and dry
Is there a how to on switching back and forth to Silvermoon?
Yep that did it thnx again Reaper-X btw how did u learn all of this?
aww no mediafire/filebeam. looks like its time to for a virus scan my internet is screwed the only way to download is by save target as... right clicl btw
BTW for upgrading Mr reaper how do you make back-ups? i know im stupid xD
ok im trying to host the server so that my friends
in texas can join i am folowing the mysql line UPDATE `realmlist` SET `adress` = '192.168.2.3` WHARE `id` =1; but i gives me this:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\wow_server>mysql -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use realmd
Database changed
mysql> update `realmlist` set `address` = '127.168.2.3` whare `id` =1;
'>
'>
'>
'>
'>
PLZ HELP zode.......
sry wrong paste:
C:\Documents and Settings\wow_server>mysql -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use realmd
Database changed
mysql> UPDATE `realmlist` SET `address` = '127.156.2.3` WHARE `id` =1;
'>
'>
'>
'>
'>
ok you lost me on this one. What is the silvermoon DB and where do we get it or do we already have it with the 5084 release? (probably not). If we get Silvermoon and install that into different database names so they can live side by side in our MYSQL data folder, how do we tell it to switch to use the other. Seeing nothing different yet I concluded I must have the same stuff but am now capable of switching over to some NEW stuff in this silvermoon database which I don't know where to get that or if I need or should want to.
Hey I said I was lost. No problems it did something to my system. Where would I go to look for a guild bank if I had a guild?
#informative
The silvermoon DB is just like the Unified DB you have been working with just with more custom content for "fun" servers. If you wanna new item vendors like teir1 -6 vendors etc, new quests an such then SMDB is like that. UNified DB is jus tlike normal wow can be. They wont sit side by side parsay...but you can switch between the two without any problems really. As for the guild bank, you need to have a guild in..then in stormwind bank area there is massive square vaults that yu would click on and set it up there, ironforge bank area same thing, ogrimmar has giant vault like thingies to. undercity has some skulls on the corner of there bank and thunderbluff has a big totem outside of theres. click that and follow the prompts
#zode
your typing the second part in wrong. this is what you should type:
UPDATE `realmlist` SET `address`= '127.156.2.3' WHERE `id` =1;
make sure you get the ``'' the right way round to.
Steve
* '127.156.2.3'
Sorry for the error before
Steve
I am having a problem where the pet a player has summoned will kill itself on logout.
IE Summoned Felguard will die, the Soul Shard is returned to the player. Is anyone else experiencing this problem and is there a fix for this?
T0: Reaper-x
heya
I did a freash install on silvermoon and found 3 errors, <- should I worry?
[ Reaper-X Quick and Dirty Mangos Helper Main Menu ]
[ Mangos R5116 ScriptDev2 247 ]
[ http://www.reaper-x.com ]
Your MYSQL Information :
========================
MySQL Location = g:\mysql\bin
Username = root
Password =
Choose your destination :
=========================
[ FRESH INSTALL ]
================================================================
[ 1 ] Installation
----------------------------------------------------------------
[ 2 ] Backup Your Mangos Character Data
----------------------------------------------------------------
[ 3 ] Restore Your Mangos Character Data
----------------------------------------------------------------
[ 4 ] Mangos Config Editor (you need to run this at least once)
----------------------------------------------------------------
[ 5 ] Configure your WOW Realm for LAN Party and your realm name
(run this later after you're sure your server is working)
----------------------------------------------------------------
[ 6 ] Get your character GUID and ID for Auction BOT
----------------------------------------------------------------
[ 7 ] Switch Database to Silvermoon or UDB
Note: This will overwrite your database, so if you have
made customization to your database it'll be lost
This will not overwrite your character
----------------------------------------------------------------
[ 8 ] Exit
================================================================
Choose 1, 2, 3, 4, 5, 6, 7 ... or 8
1
Which database you want to install ?
[ 1 ] Unified Database
[ 2 ] Project Silvermoon
2
--------------
DROP DATABASE IF EXISTS `mangos`
--------------
--------------
DROP DATABASE IF EXISTS `realmd`
--------------
--------------
DROP DATABASE IF EXISTS `characters`
--------------
ERROR 1051 (42S02) at line 3: Unknown table 'arena_team,arena_team_member,arena_
team_stats,auctionhouse,character,character_action,character_aura'
ERROR 1049 (42000): Unknown database 'realmd'
--------------
DROP TABLE IF EXISTS `arena_team`
--------------
ERROR 1051 (42S02) at line 21: Unknown table 'arena_team'
Please wait it'll take a while to import the database
Press any key to continue . . .
ERROR 1049 (42000): Unknown database 'mangos'
Done
If you see any error message just let me know
Press any key to continue . . .
What DB would you guys recommend? UDB or Silvermoon? UDB seems to be missing a lot of game content, especially late-game instances/outland, and I haven't yet tried Silvermoon; just wondering if they've progressed further than UDB.
Is there any difrence between Silvermoon and normal ?
OK I would love to try out the silvermoon fun database can anyone point me to a download link for a recent one that will work with this core?
I just did the Upgrade from 5082 and it was very quick and mostly for the most part flawless.
Kudos to the Reaper-x/Oatman team
In a word...Nice.
Well in my effort to BE informative here is what I found by trying to remember my own lesson that google is my friend.
Is this the silvermoon db of which you speak?
http://forum.ragezone.com/f114/mangos-trembon-2-3-3-repack-356850/
If it hopefully what you are refering to? Let us know because some of us will be able to easily recover from careful backups but others may spend a weekend trashing and rebuilding their server if this isn't the right silvermoon of which you speak. Searches for silvermoon return a lot of old dead links mostly. TYVM!
Ehhhh the Vmap extrator issent working for me
where can i download them pre-made?
Reaper-X
I really want to use the Mangos MiniManager with your repack, but having trouble figuring out how. Just wondering if you ever heard of it and if so could you assist me. Thank you ahead of time.
How is better
This new version
or the old version???
The DBC Extractor issent either working
Freze
OK that works and I have cool new potrals and I'm a red santa-gnome and there are harvest foods outside orgrimmar now and all. I just have two questions and one piece of information to be informative =p
OK http://trembon-compiles.6x.to/ this was where I got the repack to update the database - I did the script batch inside and did backup characters then full install of silvermoon and THEN restore characters. No bumps except for the errors launching mangos - anything you can do to help me understand those errors is something I will remain GREATLY THANKFUL for (/bow).
One piece of information to those that keep posting "hey I got cannot log into root @ localhost with pwd: YES). I actually GOT that message. Seems I overwriote my scriptdev2.conf with a new one and there it was I said HEY I see that every day posted on Reaper-X blog. Went into Scriptdev2.CONF file and changed 127.0.0.1;mangos;mangos;whatever to read
192.168.1.121;root;password;database
Find these in all four CONF files and make sure they are CORRECT for your setup! localhost;pwd:YES problemos shuold go away..
I see the new reaper install exe. I was using the old .bat file. This is why I did not see the Silvermoon switch. Reaper do you recomend replacing the whole reaper folder or copying new updates into our existing reaper folder?
Doh forgot to past MY errors here they are:
Creature 19668 has no data for Level 73 pet stats data, using data of Level 72.
Creature 19668 has no data for Level 74 pet stats data, using data of Level 73.
Creature 19668 has no data for Level 75 pet stats data, using data of Level 74.
Creature 19668 has no data for Level 76 pet stats data, using data of Level 75.
Creature 19668 has no data for Level 77 pet stats data, using data of Level 76.
Race 11 Class 7 Level 72 does not have stats data. Using stats data of level 71.
Race 11 Class 7 Level 73 does not have stats data. Using stats data of level 72.
Race 11 Class 7 Level 74 does not have stats data. Using stats data of level 73.
Race 11 Class 7 Level 75 does not have stats data. Using stats data of level 74.
Race 11 Class 7 Level 76 does not have stats data. Using stats data of level 75.
TYVM!
I may have figured it out. If you set maxlevel to like 80 instead of 70 it gives these warnings.
Re fresh install 5116 found 4 errors
instead of silvermoon Ive tried the other, same errors, then I tried to ignore and just continuing on for the lan party and get another error,
error 1049 at line 1: Unknown database 'realmd'
this is looking another patch :)
or is it just my end, and I hope it is just at my end
thanx for your help in advance
For anyone wondering how to import custom items they may have had. The only diff I am seeing between the current 5082 and this new silvermoon is the items all have an extra field at the end named Duration. I plugged in zeroes for this field and they seem to be importing my items OK..
What about Gm island for this ver?
And I made on account for the AuctionHouseBot, but what do I do next to make it work? What do I need to change in mangosd.conf? The name I made for it is (boot) and the id # for it is 5.
QAlexT: I just made an account. Made a character on it named like AHbotnik. Went out to the database characters table and looked at the CHR to make note of the GUID and ACCOUNT numbers and placed those into the mangosd.conf file where it asks for them. It seems to work perfectly ever since. Nothing else needed. I suspect it simply uses that characters bank space to email items won to all winning bidders and to mail unsold items back to people who post and don't sell when time expires.
My Idiotic DBC issent working can somone send me the new of them at Freze.thomsen@gmail.com ? Thanks Very mutch you will get a GM users at my server if you writing a Username and a pass too'
Freze
ok, since i am new to this and don't know any better can someone give me the quick and skinny on the difference between silvermoon and UDB?
Thanks
ok, seem the Demon Trainer's Imp is still killing people that get to close. Just had this happen in the Bloodelf starter zone. The Imp is under the floor and I can't target it to delete it. Anyway to fix this? Other then that everything seem ok for now
Also finally, currently i’m having a big problem and that’s because … the area where i lived got flooded once again (i just hope this time the waters doesn’t get inside my house though like what is happening on February last year / 2007) or else i’d have to evacuate somewhere
THIS IS REALLY BAD! :(
# Saktron, You could modify your hp to a higher amount( .Modify hp 999999 for example)
and then set your level to 1.
This will make him attack you but not kill you directly giving you a chance to delete him.
upgraded no problems
Thank You Reaper
Was going to try something like that. I had to delete the Imp in the gnome starter area also. Tried with a higher lvl character, but of corse he wouldn't attack me.heh
Good luck with the flood guys! I hope it recedes quickly! I know I speak for everyone here, we need you and wish you well.
cant you please post this on another download source i cant get either of the 2 here to download help!!please
ignore previous post thanx
# Merlin756
hm that's strange, could you tell me what is your Operating system ? and what mysql version you're running ?
# informative
Ah that error message means, the stats havent been defined (stat table) for (pet / character) with that level
you can take a look inside :
pet_levelstats and player_levelstats
by default the database has been made for level 70 and below only, and if you set your level higher than that there'll be no bonus given to your char or pet (to be honest, its hard to explain it but i hope you could understand what im trying to say)
# Okono and Excalibur76
Thanks a lot :)
# bakaslayer
Actually at first i want to upload it somewhere else too, but since those two filesharing site are the fastest for me i decided to upload it to rs and mu (well my upload speed is just 8 KBps)
if you / anyone else want to mirror it somewhere else, i'd be delighted to put the link into the post :)
# Everyone
Finally for the next version, i've make sure to check for various error before each process to make sure that the database has been set up properly :)
btw ... currently im testing ascent ... if anyone interested on testing ascent (my wow knowledge is limited because i never play on official wow lol), just let me know about it ;)
What is the changes in this since the last version you released?
you can check below link :
http://pastebin.ca/889737
Reaper:
I can test out ascent for you. I've played on bliz servers for years. Would just need too figure out how too set up two realmd's on my computer, probably just by following your guide on how too do it, if I'm going too test it on my own computer. otherwise...
Only thing I haven't played before is the end game instances in outland. The guild I was in didn't get that far.
i know this might sound kindof noobish but once you upgrade can you delete the old reaper-x-mangos file???
thx in advance
I would'nt mind testing Ascent. I've played a Pally and a Rogue on live for 1year & half.
I can also help you with code / debugging if you need help.. Same thing for the database, I'm an oracle dev, I'm quite good with SQL.
If you need help, let me know ;)
I'm having a problem with friends connecting from outside my LAN. With my LAN IP in the database and in my second computer's realmlist I can connect fine but my friend cannot. If I change the IP in my database to that of my public IP then my friend still cannot connect nor can I. Can someone please help me out with simple instructions? I've tried everything I've found on the site but apparently I'm missing something. Thanks.
justin484 : You're probably behind a router right?. If it's the case, you need to forward the ports 3724 and 8085 to your server's IP.
see this post on the mangos forum for more info :
http://www.mangosproject.org/forum/index.php?showtopic=11737
Yes I'm behind a router but I've already set up port forwarding on those two ports, that isn't my problem. Using my LAN IP I can connect from any computer on my network, but if I change to my actual IP no one can connect.
When I am able to connect on my network I'm using the ip address found by ipconfig (192.xxx.x.xxx) and everything works fine but my friend cannot connect. When I change it to the ip address found at whatsmyip.com (74.xxx.xx.xxx) then he can't connect nor can I connect from the network. I'm not sure if there's some little simple thing I'm missing or what.
do we still need to edit the realm and scriptdev2 conf. manually??
is this right
sd2: warning >>loaded 0 localized_texts
sd2: warning >>loaded 0 eventai_scripts
help please?
everything seems to be working thanx again for the good work,i could still use your help to update my 4703 characters :) how can i get them to you?
Greetings!
Is there a way to add how much money a player should start with when they create a new character?
and I want them to have a mail in there backpack with some rules that I write in it?
how do I make this?
everything working but i dont know how to set the server to public. for all can join my server?
well hat off to you guys nice and smooth i love it i wish you could bring back the vendors you make once in orgimmar and storm if not who to you make the gmisland visible so to be able to put portals and how do you change the message of day in the ingame
@will: go to the mangosd command window and type
motd Welcome to Will's Fun Wow Server!
What would be really useful for me would be a set of standard backup SQL of items people usually normally find on an AH. Then maybe script it so every 48 hours the system INSERTS a bunch of typical AH items on 48 hour buyouts so we could go to the AH and find ten stacks of wool cloth and stuff like that available. Maybe make a second AH bot who will be the poster of everything so the expireds go to his mailbox and then automatically purge AHBot number 2's mailbox at the tmie we do the inserts? Just an idea, BUT I hate an empty AH =) dont you?
@Justin484: I’m using the ip address found by ipconfig (192.xxx.x.xxx).
Is this the IP you also have your Router forwarding 3724 and 8085 to?
Did you also make sure to update your IP in your realmd database realmlist table ALSO got updated to the ip address found at whatsmyip.com (74.xxx.xx.xxx)? Yes you gotta put THAT there too.
To: Reaper-x
op vista32
Microsoft Windows [Version 6.0.6000]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
OK so on the AH idea I think I can do this but I need to know what is the format of the time field on the auctions table? That's gonna need to be customized everytiem or the auctions will all expire instantly
Hi guys, I've been out of the scene for a while and came back with the release before this one. Everything seems to be going great with the server program give or take a few bugs.. (High level Imps in starting areas being one of them).
Anyway the issue that is troubling me at the moment is the quest "Tree's Company" for the alliance. When I go to traitors cove the guy is there and so is the flag, but when I put on the disguise nothing happens... anyone else experienced this? Is it simply not in the DB or can I somehow fix it?
Any help would be greatly appreciated. Thanks in advance.
P.S. Thanks for all the great work on this project
I have a problem NPCs on the map are not or just very slowly moving after setting up a fresh 2.3.3 server.
The big creature in Dolnaar is just moving in a small area not around the path, as it should.
Someone can help`?
@DomiOh: make sure to set the priority to High for the Mangosd.conf might help.
Also just taking some wild guess. Is your server on it's own machine (helps to be on own machine obviously not the one playing Wow). Is the machine underpowered by any chance?
I'm not having any lag slowness nor seeing any reported really, but my server is it's own separate machine and is a hyper-threading multi-core with extra RAM.
Was your auto-update turned on and maybe it started downloading and installing Microsoft updates in the background? No thats usually 3AM and your post was 1AM (prolly not that). Did you turn off anti-virus? Turn off scheduled late night defrags? etc. etc.
Oh if you really DO have an underpowered machine or less than 2 gig of RAM and want to free up some resources you know look in teh task list and there are 20 things you can;t identify and want to turn some off here is some batch file commands to turn off some of the more likely improvements. READ the REM comments and don't turn off things you need if you need your wireless connection from your machine to a wireless router for example...
REM Windows Firewall/Internet Connection Sharing (ICS) This can fix ALL sorts of problems
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\SharedAccess" /v Start /t REG_DWORD /d 0x4 /f
REM disable Automatic Updates
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\wuauserv" /v Start /t REG_DWORD /d 0x4 /f
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\BITS" /v Start /t REG_DWORD /d 0x4 /f
REM This will disable dialup connections and telephony
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\RasAuto" /v Start /t REG_DWORD /d 0x4 /f
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\RasMan" /v Start /t REG_DWORD /d 0x4 /f
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\TapiSrv" /v Start /t REG_DWORD /d 0x4 /f
REM disable Performance Logs and Alerts
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\SysmonLog" /v Start /t REG_DWORD /d 0x4 /f
REM Disable Wireless Configuration Connections
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\WZCSVC" /v Start /t REG_DWORD /d 0x4 /f
REM Application compatibility Service
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\AeLookupSvc" /v Start /t REG_DWORD /d 0x4 /f
EXIT
Cheers!
THOSE are almost certainly not VISTA compatible registry commands BY THE WAY!
Damn,Reaper. I hope those floods stop soon!
And it's interesting to me that you're testing Ascent. Last I heard there was some implosion of the leadership. Did someone pick it up again?
@Nivo
That quest simply seems to be too hard to code in for the DBs. I tried it with both Silvermoon and UDB and it doesn't seem to work. Also, I think the Draeni starting area didn't get as much love as the BE starting area. . . perhaps because they're not eye candy or something ;).
I have disabled really ALL what runs on my system.
As I said before - the big creature in Dolnaar does not move around. It makes one step an stands still. The it turns around and makes another step. And stands still again.
The spiders don't attack the player, when the player is close to them.
The player can walk through them. Then they react and walk like they should.
Strange
PS: What are the "optional" VMAPS for?
Oh, and I almost forgot. You can bypass weird quests like that in some cases by going to thottbot, wowhead, or similar sites and looking up the name of the next quest in the series.
Once you know the name, type .lookup quest [quest name]. This should give you a quest number.
Next, type .addquest [quest number] and it'll add it to your quest log. In most cases you can then continue on, hopefully to completion of the chain.
I honestly don't know why the Mangos team didn't code in a ".complete quest" command, as it'd be extremely useful for situations such as yours, but we take what we're given, hehe. They do great work.
How do I reactivate the AH bot when upgrading. All my items are gone and its not working. Everything else is doing great. Thanks
Hi reaper,
i have a problem with the extract dbc files.
It keeps on saying:
Fatal could not locate SFmpq.dll
grtz
Very strange thing with my moving problem.
With the unified databse they don't move.
With the project silvermoon database they DO.
Muskar wrote:
Ok this may seem a little off-topic since it’s related to this post instead, but since the other topic is old, I’ll give this a try:
I have a problem. I added a few objects and I can’t seem to find a way to delete them again.
.targetobject does only find a Rich Thorium Vein, and if I do .targetobject 22083 it can’t find anything.
.delobject 22083 doesn’t work either.
Any ideas or support?
In addition, I spawned a boss twice and the second one isn’t targetable or anything so I can’t delete it, this is awful since I spawned it a wrong spot.
Any help?
Additional information; I do no have any experience of editing MaNGoS outside of WoW, so please if you refer to editing tables or other data, please explain it more detailed.
Muskar wrote:
Ok, an additional question:
How do I edit the level requirements for each GM level?
I would like to have it this way:
GM4 (Admin) - 255
GM3 - 100
GM2 - 90
GM1 - 80
GM0 (Players) - 70
This IS possible, since I have seen it before on another MaNGoS server.
If anyone know how to do this, please let me know.
@muskar
you just do a .levelup 254 on them and org server lvl at 70 so if you want to go past 70 u need to do .levelup cmd.
I've got my server up and running, and I've set it up for a LAN so that my GF and I can both use it. The problem is that she needs to get past my router to connect.
I've set up port forwarding for port 3724. Are there any other ports I need to worry about?
# Nero
im not sure about ascent internal area lol .. but currently im testing ascent now, and one thing i can say there are big differences between mangos and ascent lol. Everything works fine (latest development rev) but i still need to read some stuff about the scriptdev2 replacement for ascent (well i heard about moon but i couldnt find any stable release for it) and other stuff like their LUA engine, etc lol
# Checkmate
you can edit the mangosd.conf and adjust the guid and character id used there ;)
# Milembar
Are you running 64 Bit Windows or Vista (32/64bit) ?
# Muskar
you can try looking at the creature table and look at the last GUID generated (usually that is your spawned creature) or you can also try looking for the boss id in the creature table (well since there's only one boss and if there's another one that means the other one is your spawned creature)
as for GM level based on character level, since the default in mangos isnt based from the character level, probably they've created their own code
# SanityImpaired
yes.. 8085 .. :) (3724 realmd, 8085 world)
How do you get arena points so you get a rating, or how do you get a rating because with the items, it won't let me put them on...
Nevermind that, found out what I did wrong, sorry.
Hmm I tried to extract 5116 and it seems I get a virus warning (trojan agent.ntx) for opening the batch file, the main one.. not the upgrade one. Did a virus scan but nothing :|
# Raidex
could you tell me what is your antivirus software ? i've checked it using Kaspersky 7 and NOD32 (latest update) and found nothing :)
CA Anti-Virus see's nothing there. I'm really doubting there is an actual virus.
Hey Reaper hopefully you could give me a hand with this since I believe its my last step before being able to get on my server.
So I did everything on the guide and get to the part where I need to have mangosd.exe and realmd.exe, once I open mangos.exe it opens and then starts saying:
Check existing of map file ':\world of warcraft\data/maps/0004331.map': not exist!
Correct *.map files not found in path ':\world of warcraft\data/maps' or *.vmap/ *vmdir files in ':\world of warcraft\data/vmaps'. Please place *.map/*/vmap/*vmdir files in appropriate directories or correct the DataDir value in the mangos.conf file.
Any help?
Bug Report:
After some testing, I realise that there are some skills not working properly,
They are Blizzard and Rain of Fire, they do not damage.
Also, are there any article that teaches how to set up a new realm?
2008-02-03 23:27:01 Daemon PID: 916
2008-02-03 23:27:01 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2008-02-03 23:27:01 MySQL client library: 5.0.54
2008-02-03 23:27:01 MySQL server ver: 5.0.51a-community-nt
2008-02-03 23:27:01 Character Database: 127.0.0.1;3306;mangos;mangos;characters
2008-02-03 23:27:01 MySQL client library: 5.0.54
2008-02-03 23:27:01 MySQL server ver: 5.0.51a-community-nt
2008-02-03 23:27:01 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2008-02-03 23:27:01 MySQL client library: 5.0.54
2008-02-03 23:27:01 MySQL server ver: 5.0.51a-community-nt
2008-02-03 23:27:01 Realm running as realm ID 1
2008-02-03 23:27:01 Using UDB 0.9.1 (337) with SD2 calls rev.247
2008-02-03 23:27:01 Using DataDir C:\world of warcraft\data/
2008-02-03 23:27:01 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-02-03 23:27:01 WORLD: VMap data directory is: C:\world of warcraft\data/vmaps
2008-02-03 23:27:01 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-02-03 23:27:01 ERROR:Check existing of map file 'C:\world of warcraft\data/maps/0004331.map': not exist!
2008-02-03 23:27:01 ERROR:Correct *.map files not found in path 'C:\world of warcraft\data/maps' or *.vmap/*vmdir files in 'C:\world of warcraft\data/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
Other one was a bit wrong since I didn't copy and paste.
I am using AVG with latest updates
This happened when I tried to open the batch file again so i could reinstall database.
Everything loads fine in mangosd.exe until it gets here, and just stops loading. Please help.
Loading Items...
Error in `item_template` table, probably sql file format was updated (there shou
ld be 142 fields in sql).
I've done all i can at this point.
# richard
I assume that you're able to locate that 04331.map file directly using windows search function. Now could you try moving the data directory from C:\World of warcraft into something like C:\WoW\data ? :)
and oh dont forget to adjust the datadir once again ;)
# Raidex
I'll download AVG tonight (my local time displayed at every comment posted) and try to scan it using AVG :)
# Pat
Are you using this version ? because you shouldnt get that error message because the database that is included already updated to this revision :)
btw if you're restoring backup then the problem probably caused by the old data
Yes i do run windows vista, but on the server i'm now running xp. But still getting error message's ..
Will try to reinstall wow first and then let you know if it helpt.
Found another possible issue I think.
I was messing around in ZG and realised that none of the mobs were lootable.. The corpses were glowing and everything, just the icon wouldn't turn gold to allow me to loot. Anyone else got this?
ehm i don't know if it is just me but my anti-virus system (AVG) detected a Trojan horse agent.NTX (i think) in the reaper exe file where the sql files is.. now i know anti-virus protections sometimes is wrong but i tried to open the file and it said the thing you don't wanna see when trying to open a suspicied virus file..
no offense against reaper-x but this is a bit a problem if it appears to be on the new server?
ohh saw someone already have discovered this..
hey i did all the stuff in reaper-x-mangos.exe
but when i start realmd.exe it says realmd process priority class set to high
p.s. i can't whrite anything in mangosd.exe
did instal wow, but still getting a error message.
(it's in dutch sorry)
But can manly it says can't initialize. and even when i drag the .mpq file to the mpq extractor it gives the same error
informative ty on that message done but another question how do i unveal the location of gmisland so i could make portals to the island see i finally three other halfway house with teens that are coming on board i wish reraper and oatman would make a shopping mall that would be great with all the vendors and crafts and trainers that would really be the final nail if they do get to do it then if they made the portals to the mall other then that you boys keep it up and reaper let me know on the flood problem if i could help in anyway let me know.
did find the problem, i needed to install a update from the windows website. Something had to do with .net, atm i am making the dbc files :D
if anyone is having troubles with the AHbot with the new 5116 repack here is the problem.
After you enter your Guide and account number for you character that is hosting the items, look down a few lines. They are "0"'s for item quanity. change it to this.
# Note: If you enable AllowTwoSide.Interaction.Trade, ALL auction houses are
# linked to the neutral auction house.
AuctionHouseBot.AllianceItems = 300
AuctionHouseBot.HordeItems = 300
AuctionHouseBot.NeutralItems = 500
that will fix you right up. restart your server and there ya go. hope this helps who have problems
Yeah I was able to locate the 04331.map with the search function. I still didn't understand by what you meant by:
"Now could you try moving the data directory from C:\World of warcraft into something like C:\WoW\data?"
Oh also im not using my main World of Warcraft folder I made a copy of it to my desktop so I can still play WoW while being able to play on a private server. So would it have to say when I adjust the datadir?
#Will
I no longer work on this project. I was going to be doing the Anscent Releases but seeing that it keeps crashing on my Vista I am not sure. At the moment I am working on the Server Mega-WoW which Reaper and I are going to be operating. It will be avaible to the public once Reaper and I discuss more stuff about it soon. If anyone would like the beta link to it I have provided the link. Please Note:
This is under Pre-Beta and please do not email Reaper-x.com for any problems on the server or email them to be a beta tester. If you send an email to Reaper it will either be deleted or he'll email back saying that he is not doing work on it yet. So for the time being we will provide an email for it for you guys to check out.
My personal Email for the Server is:
jjones@reaper-x.net
Please use that email to contact me concerning it.
Here is the link providing the web address to the server. I am aware that their may be some confussion as to how to connect to it. We are aware of this. Just please contact us by the email I have provided. Also I have coded a launcher in VB.net that will automatically replace the realmlist.wtf file to let you connect to the server.
Here is the Link to the Server:
http://mega-wow.reaper-x.net
If you have any questions please post them on that site since it is not yet part of this site.
Thanks,
Jared
:)
Ok....im having super difficulty getting a server online. ive followed guide after guide and i can't seem to get it. it's eaither "20.200.200.200 is not allowed to connect to mysql host. bla bla. or its go through all the setting. and try back and forth to see if i maybe get something right. port forwarding. that dont' help me. i need something more specific. names of what is exactly being forwarded. to what port? dmz? i mean...i tried so manny things....and i can't get it. 127.0.0.1. yeah. easy. got a LAN one werking. but...i no no....im lost. and its frustrating. im dum i know...so don't rub it in.
I apologize if this is off topic, but I would really like to know how to modify a spell. For example Blink is broken on this release for me. If I can find out how to modify spells I could maybe go back to an old release and compare to see if there is any difference and fix it in this spells.dbc.
As it is spells cannot be changed. I must figure out how to decompile and alter then recompile this file. Any help is appreciated.
Another change I would like to attempt might be for example to make the qiraji resonating crystal spell unrestricted and not just for use in an-qiraj because its a nice mount for everyone else and would like to put it on a vendor and make it like level 40 or 50..
Just my preference but I think this could also be fixed in the spells.dbc if I could figure out how to edit that.
@will: Vendors are pretty easy! Using QUICE you can click creature and type in a name like KAFTIZ and up comes Captain Kaftiz! He sells marks of honor at very affordable prices! If you select an NPC and type .delete it will go away and remove that spawn point.
The good news is you can add items to vendors easily and you can spawn EXTRA copies of vendors wherever you want them by typing. Yes you can clone "Captain" Kaftiz as much as you like.
So just go around and write down the names of the vendors and trainers you want in your shopping mall and look them all up in quice and THEN go where your mall will be - some like to use for example the landing strip in northeast Dun Murogh and walk around going
.addspw number
.addspw number
.addspw number
and just pop in a bunch of trainers and vendors. You will no doubt also want a portal to get people there and back easily but I'm going to go try to learn that next...
Anyone got the three minute guide to making custom mangos portals? C'mon be informative no wait I'm informative =p
OK OK. I think I got this making portals thing down. If you type in
.lookup object portal to shat
or
.lookup object shattrath portal
That should list most of the common ones you might want.
To insert them where you want them you just do .addgo number
Getting rid of them is a little trickier. You first have to know the number and then you type target number THEN to get rid of it read the targeted message and type
.delobject guid
stub in the guid number from the targeted info it kicks back when you target it. OK so
I add an Ironforge portal with
.addgo 183322
then
.target 183322
it says GUID 59290
.delobject 59290
to get rid of it.
Is it permanent? Not sure.. think so.
Can we make our own custom portals. Probably there are a bunch of odd named ones if you just use .lookup object portal, could almost certainly reuse some of those to set the coords to match your .gps readings of your desired destination - wish I had more to offer but I am filling up Reaper and Oatman's blog like the flood waters already no =)
MPQ-Extractor v1.4 by WRS
Fatal: Could not locate SFmpq.dll
MPQ-Extractor v1.4 by WRS
Fatal: Could not locate SFmpq.dll
MPQ-Extractor v1.4 by WRS
Fatal: Could not locate SFmpq.dll
The system cannot find the file specified.
Press any key to continue . . .
I'm getting this error, which I've been getting since last patch. Please someone come up with an answer, I'm killing myself here!
Most of the portals appear to use spell numbers which preset their destination. Is it possible to create a custom portal to go someplace not already scripted?
@Uberwabbit: Did you follow this guide step by step? drop all of those programs they giev you for extraction into the production warcraft folder and run them and they should extract your maps vmaps and dbc's. Not even sure they need all of them. There is that flag to turn like vmaps on and off you could probably run without them if you set those to 0 is my guess just to prove it works and then come back when you have regained your confidence and calm.
http://www.reaper-x.com/2007/10/10/wow-mangos-map-vmaps-and-dbc-extraction-guide/
@informative: I've followed the tutorial step by step, and I still receive the same error message no matter what I do. This is very frustrating as I have set up a reaper-x server up on my old computer.
Please if anyone else can help me find a solution don't hesitate!
can i get the DBC in GB edition???
@freze: It's in the DBC Extractor folder, there's a extract-enUS and extract-enGB.
#Uberwabbit: Old system? Oh no Vista? There were special instructions to per-make the destination folders for Vista users I think. Ugly stuff. Wait you mean I don;t have the right to make a folder on the fly using the MAKEDIR command in Vista. That's so clever it kinda wraps around full circle and comes up dumb.
PRE-MAKE the destination folders. Better yet if it's really vista what better time to download VPC and run XP or 2003 in a Virtual machine and just run your map makers in a virtual machine.
informative: Sigh... yes I have vista 64bit, but how is the error I'm receiving tied to vista? I thought it would require me to edit something in mangos config not get a new OS.... However I guess I'll try these special instructions you mention, please give link and thanks for your response.
i just did a new installation of mangos 5116. i'm pretty sure i followed all the steps properly but im getting the following error when i try to run mangosd.exe after successfully initializing data stores:
You have _outdated_ DBC files. Please extract correct versions from current using client.
i rerun extract-enUS and notice this error:
Output directory: .
Fatal: Could not locate MPQ archive patch-enUS-2.MPQ
Press any key to continue. . .
so i press any key to close window and check C:\Program Files\World of Warcraft\Data\enUS and patch-enUS-2.MPQ is not there. assuming all is fine, i move the new dbc folder to C:\WoW\data overriding the old one (that i just moved there while extracting maps, vmaps, and dbc files). i rerun mangosd and get the same error. after this i run the Blizzard Repair Utility and repeat everything from extracting the DBC files to running mangosd, getting the same exact results. im not sure what im doing wrong, any advice? thanks in advance.
Hello guys, is there anyone who knows how can i modify the items so they don't cost any gold/honor/arena points etc?
Any help is appreciated,
Dex.
MPQ-Extractor v1.4 by WRS
Fatal: Could not locate SFmpq.dll
MPQ-Extractor v1.4 by WRS
Fatal: Could not locate SFmpq.dll
MPQ-Extractor v1.4 by WRS
Fatal: Could not locate SFmpq.dll
The system cannot find the file specified.
Press any key to continue . . .
Still getting this error... :'(
# Aratel
could you tell me what is your WoW version ?
# Raidex
Yesterday i sent an email message to AVG team about that false alarm, and today i just received a reply from them and they've confirmed it's a false alarm and already released new virus update today that fix this issue :) .. btw if your virusscan detect something on my weblog or anything here, just let me know about it (i always take serious action when it comes to something like this) ;)
# Dex
are you sure ? okay then do these :)
1. open command prompt
2. type mysql -u root -p
3. then type :
update mangos.item_template set BuyPrice =0, requiredhonorrank = 0, RequiredArenaRank = 0;and done
# UberWabbit
unfortunately the dbc extractor can't run properly on 64 bit OS :(
btw if you're running enUS version, you can grab the already extracted dbc files below the link to reaper mangos (search for optional using your browser search function)
but even if you do that im still not sure whether mangos will run without problem in 64bit environment (unless you're planning on using virtual machine) :)
Thank you so much Reaper! I just have one more question, where can I find some info about silvermoon vs unified?
Thank you Reaper-X.
The only command that worked was for the gold.
The other 2 (honor and arena points) didn't work.
I tried to type them seperate and the command told me that it found some, changed 0 warnings 0.
Any ideas?
# UberWabbit
you can try reading Reaper Mangos FAQ :)
# Dex
Ah forgot to tell you this, actually you need to delete CACHE directory inside your WoW directory ;) ... the gold can be directly seen because its not cached while the arena and honor gets cached
Ok so i delete my CACHE directory and re-type the command?
I tried only to delete the CACHE directory, then closed-opened the server and the items still needed honor/arena points + marks :(
I'll try to retype the command now.
Dang, now I have an error with realmd.exe.
Database: 127.0.0.1;3306;mango;mango;realmd
MySQL client library: 5.0.54
MySQL server ver: 4.1.22-community-nt
SQL: SELECT 'id', 'name','address','port','icon','color','timezone','allowedSecurityLevel','population' FROM 'realmlist' WHERE 'color !='3' ORDOR BY 'name'
No valid realms specified.
Is it because I have v4 mysql?
Hmm still nothing Reaper :(
Damn!
Isn't there a program that can allow me to modify the database?
# UberWabbit
no .. that shouldnt be a problem, its related to something missing on your realmlist table
try typing these
1. mysql -u root -p
2. select * from realmd.realmlist;
# Dex
whoops forgot to add this command :
update mangos.item_template set ExtendedCost = 0;
because blizzard store the extended cost (honor,arena) in the extendedcost.dbc and the extcost stored the at extcost in the database
and finally dont forget to delete the cache ;)
@Reaper-x: What? lol... can you use the big writing please, I'm so nooby.
Some zones under Tele command wont work.
It's a weird thing they show if you .lookup the tele but when you try to go they say no such tele location. (on silvermoon db)
load the Unified data base and some work but then others are gone completely.
other then that any idea when we will see some sunwell content filtering through?
What the different of UDB and Silvermoon DB ??
Thanks Reaper now it worked fine :)
I have another question though:
I play with Silvermoon DB and when i do the ''.addspw'' command and place one vendor in some place after a while it disappears.
Is there any other command i could use?
This is my cerious problem now because i spawned the GM vendors in a place but after a while the just gone.
Any help is appreciated,
Dex.
I would Like to enable flying mounts in the regular maps like they are in the outlands so that flying mounts can be used anywhere in WoW?
How would I go about doing this?
Thanks,
Nathan
Normally if you .addspw (id)1 that should make it perm. Just put a space and a 1. that makes it perm Hope this helps you out.
@Dex
They will come again just wait and keep you server op ill tryed it before :)
Can the battlegrounds be fixed? Also, why is it when I am beyond level 70, it says that I do not meet level requirments to enter? Also, where is the eye of the storm people and the arena itself? There is not even a .tele there.
# Gta and Freze
Yup after some time they just came back :)
Ah I understand. Thank you Reaper :D
So Blink works ok for everyone else? I click it ten times and maybe it goes off once really strange.
will this update fix the problem im having with the earlier release?
xp bar disapears at lvl 88, its imposible to get past that lvl even though u are still gaining alot of xp from kills...
i set the lvl cap in mangos to lvl 241, the only way i could get to lvl241 is with gm command.
I havnt played much with this repack yet. But there is data tables for levels,spells and pets. The normal table goes to 70 and past that it will not calculate what is needed for the next level, even though you can use GM commands to go higher, It looks like they put in a sql tables to level 88. Past that you will not gain exp on your character. If your runing silvermoon go to there web site. http://www.Projectsilvermoon.net and look around. some of the users posted a SQL that will update yor tables to utilize up to 255. I was running Ascent and alot of them are updated already. But sometimes there is problems with the calculations for the next level.
hope this helps you out
thanks, thats why i was gonna install this update and change my database to silvermoon.
i am gonna look on that website u said , i just register but waiting for them to let me in.
even if i cant get the tables figured out, i just wanted players to be able to level up to 241 even if it takes data from 70.
the skills will still be higher than lvl70 skills, u just wont get any extra hp when u lvl, i can fix that by adding custom weapons with +hp +strength on them for higher lvl players and so on...
thx again.
@Reaper-x: what do you mean with select * from realmd.realmlist;? Please come back reaper!
First, thanks for the awesome guides and all the hard work! :)
Quick question. I've installed everything, I can log in ect... But it seems the mobs and NPCs are having pathing issues. They either just stand in place or the walk back and forth for a short distance. This happens almost everwhere I go, any ideas on how to fix this?
oatman doe's that mean you and reaper are no longer going to do anymore mango's
ok could someone help me how do i do the ahbot and could i place high lvl gear in there like tier sets
@Uberwabbit: "Select *"
is the first SQL statement you learn when you go to chapter one, page one of most Learn SQL in 15 minutes books. Reaper is just explaining that you need to go look inside your database tables. In this case your REALMD database REALMLIST table.
Select * will simply list all fields for all records. If you says Select field1, field2, field2 from Realmlist Where Field1='abc'
You would only be listing three fields from the table and only for those where field1 had "ABC" in it so you can also filter your results.
If you can't get the hang of SQLYog or one of the other tools for manipulating databases the simplest entry point for you might be to install MySQL ODBC drivers and use Microsoft Access or some more user friendly tools to get a peek inside the database. Just tell access you want to link all the tables. It will prompt you to setup a ODBC DSN.
Why are we asking Oatman if he is coming back? Did he or his computer get flooded away? Nooo!
I try an older version of Silvermoon executables and sure enough Blink works on that one but casters arent casting and lots of other stuff I don't care for. Do Casters cast on our current version with the broken mage Blink?
Spell trainers are hosed in some way also. If I make a new warlock for example and make him level 40 (.level 39) and then go to lock trainer and give him some money and just start training he will start showing as many as four spells which he has but start appearing on the to buy FEAR RANK (1) and to buy LIFE TAP RANK (1) and it also show rank 3 or 4 which can be bought but the Rank 1 is not really there.
You can tell this is not really there because (A) you can't buy it and (B) if you release the trainer and click him again it's not erally there until you BUY something ELSE then bam it reappears again. Buggy stuff.
@informative: 0.o so what am I suppose to do? lol ><
If you play alone on a server, how do you enter an instance without a party without using port?(most ports don't go inside:-/)
pleaaaase:D
@Mike: Ensure that you have gm power, then type .gm on. When you are in the instance type gm off so the creatures attack you.
im using 2.3.3
#Userwabbit: well do what Reaper said - in SQLYog you type
select * from table
Then press F9 I think to get it to refresh the query display
Actually - I think he is trying to tell you to use the console command line version of MySQL interface. If you like old school thats a good option. I've grown too GUI over the years and got the beard to prove it =p
Uber:
SQL: SELECT ‘id’, ‘name’,'address’,'port’,'icon’,'color’,'timezone’,'allowedSecurityLevel’,'population’ FROM ‘realmlist’ WHERE ‘color !=’3′ ORDOR BY ‘name’
This should perhaps say 'Order By; instead fo Odor By or whatever.
Something is either wrong in your Realmlist table or in the code that is trying to read your realmlist table. I think it just means you hosed it - format C: and start over NO just kidding!
Anyone have or already started writing a simple way to manage all of these realmlist.wtf files I am creating. Together with the various wow230m wow232, wow233 folders I'm getting confused and losing my passwords now that I have like nine different wow's to log into.
@informative: Wow now I'm even more confused.. lol! Well I downloaded SQLyog, and then typed select * from table in query and pressed f9. Then I got the following message,
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table' at line 1
(0 ms taken).
You know when I did this before it was a lot easier.. I miss my old computer!
For people that that asked about the Differance between UDB and Silvermoon. UDB is more like a Regular Blizzlike server and Silvermoon is more of a fun type server. They added portals to other citys and created extra npc's with extra vendors. There both good and worth a check out. Just depends on how you want to run your Realms.
Hope this helps anyone who asked.
gta i am on the silvermoon and i only seen one portal now oatman and reaper correct me if im wrong but very time i set up portals and vendors save it and then have to restart the server there gone any help pleasee i had dell acer donated more computers for three more halfway house's for teens so we are going to set everything together we will have 158 teens linked and i want to be able to setup so they could log in and then portal to gmisland and setup there toons please help oatman or reaper-x if this go's well by next two months we will have 4 more halfway house's for teens reaper you and your staff are the best could never had done this without you guys i think of you guys as robinhood and the gang keep it up well its kind of corny but what do you expact from a 71yr old fart with a big heart
#Uber: You have to click on the REALMD database on the left side of SQLYog first. Then you type
select * from realmlist
In the top right window and press F9 and it will display the table bottom right. C'mon your killen meh!
Ok, I have a really serious problem. I was not online while it happened so I have no idea why it happened.
All NPCs are gone, and, to me, it looks like they are all deleted.
Have a look in the .log files:
Server.log | DBErrors.log
@Will: We seem to be having an absence of expert replies lately, so I am trying to help with what little I know. I don't know if this will work, but I saw a reference to using a 1 after the .addspw creaturenumber 1 command to make them permanent. Maybe that works for portal objects too? Have you tried .addgo portalnumber 1? Worth a shot.
Btw, is there any way I can check which character/account who use which commands? (Not viewing if they are GM or not... viewing whatever their GM command history).
#Will: before you get too busy with finishing touches like portals and such, have you confirmed this is a good "somewhat final" properly working release? I've got Blink not working and caster mobs not casting and all of Muskar's mobs disappeared etc.
Could just be my install I am hopeful Reaper or Oatman comes back with some help to allow me to determine whats wrong here.
I do know the blink problem is in the compiled EXE because an older Silvermoon EXE (plus DLLs) blink works great against the very same database. Anyway, as great as this looks, I'm still thinking just between us all here that this MAYBE isn't "the one" to put a lot of time into applying finishing touches to. My two cents.
As a side note Reaper seemed to be directing us in this direction - so I will also post this link in the hopes you guys can consider AS a worst case only we could go there and get answers and updates that are possibly compatible with Reaper/Oatman's builds.
http://projectsilvermoon.net/index.php?act=idx
@Muskar: I have no clue. Brainstorming all records deleted scenarios, did you use a secure password for your MySQL (not root not mangos not password or even a dictionary word etc) and make sure port 3306 is not open to the internet? Firewall in place? I think there IS an option to turn on GM command and GM trades in the Conf files if I recall. It should also indicate where the log file is located. go to your Mangos folder and hit F3 and search for *.log maybe.
So long as your characters and realmd are backed up you should always be able to do a fresh install and quickly restore accounts and such (recoverable).
If you make a bunch of people GM's they could easily enough go around type .delete on everything I suppose. Seems unlikely but not that unlikely - would only take one bad one I suppose.
#Informative
Yes, i did choose an advanced password that doesn't match any dictionary word or anything.
Yeah, one of the worst firewalls ever, is enabled (Windows Firewall).
And I'm quite sure it was a player who did this.
And, yes, a large amount of the players joining choose to become GMs, but since I have tried making my own server before, I updated the command tables, so they wont be able harm the server at GM lvl 1.
Someone somehow did anyway, I suppose.
If you are asking me for a specific .log file, please let me know which one to upload.
I used silvermoon db and went to there forum and saw they have a new db. My q is can we updated the db with there new db or will we need to do more?
#AlexT
Even though I no longer work on the Reaper MaNGOS Project, I do not recommend updating it yourslef because then you will no longer be compatible with udpates for Reaper MaNGOS.
--Jared
Will. like Informative said you add a 1 at the end of the id number to make it perm. Someone else had the same problem. When they logged back in after the one they spawned back up again. if you look up alittle on this page you will see it.
Also on the portals. there at all the Boat docks. they boats work but they take you there alot quicker. nice for a nice non-blizz type server. I havnt checked the Zeppelins yet on the horde side but im sure there at the air docks also.
hope this helps
@AlexT I seen the new data base at projectsilver moon as well. I downloaded it and its just fine. If you want multiple databases without dumping the old one. Here is what you do. You can do this without worring about loosing all your info. But like anyting you always want to always have a back up on anything.
1: on Sqlyog Right click And Creat new database.
2: call it lets say Mangos2
3: right click on Mangos2 Restore from sql dump.
4: click on the new database. wait for it to finish.
5: open mangosd.conf file. edit it and add the "2" to the end of mangos on the world database info entry.
6: reload and there ya go. Easy wasnt it.
you dont have to loose your old database and you can test as many as you want without dumping the old one. Its easy to revert back to the old one.
Even if you ever have to change the tables on Charactes do the same thing. you always have a back up of your old files.
I have 2 realms set up on mine with 3 databases for each one. i just change the world database info to get them up.
Hope this helps you out
You wont have to worry about updating your reaper when new updates come out, the new database in under mangos2.It wont see it. You can do the same thing with the new repack. Just click sqlyog and on mangos 2. Click empty database on mangos2. Then load a differant database on it. Or if you want create another one called mangos3 and have 3 databases to choose from. If any database dosent work with it. just change the World database info back and your back online.
@Informative: I did what you said and got the following error;
Error Code : 1146
Table 'realmd.realmlist' doesn't exist
(0 ms taken)
I know I'm killing you, but trust me this is killing me more! :P
Hey, I have been having this problem from the first Mangos. Whenever I create a night elf character and level him beyond 70, when I click on the Character tab, WoW crashes. Help
Hey, you can post an tutorial (or a link to one) to me know how to make items?
And monsters too, if you can.
@Uber
If you toasted your realmd database no worrys. You can just empty the database and go to your
C:\reaper\Reaper-X-Easy-MaNGOS\reaper-eazy-mangos folder. there is a SQL realmd in there. after it is emptied just restore from sql dump and it will reload it back in.
This is all done from sqlyog. Just right click on realmd data and you can select what to do.
If there is no data in the realmd database you will have to do this to reload it.
hope this helps you out.
you only empty the database you are going to reload. which is Realmd. You right click on realmd and empty it. Then click restore form sql dump and pick realmd.sql. browse to your folder and there you go. it loads it back in. Just wanted to clarify this.
@Gta: When I went to restore I got an error. I would post what it said but its like a page long... I'm sure I used the right one 'realmd.sql'.
gta how do i set up the auction bot and is there a way to unveal gmisland so i could put portals there or could i dump gear into the auction bot
@Uber, if you havnt done alot to the repack as in you added alot of content. you are better starting over with a fresh install. if you were just trying to edit the realm list. All you have to do is click the + next to the realmd and it will expand and you can click on realmlist. you can edit it from there. when you are done there is alitte disk above the box. you click that to save. If you ever want to refresh the database you click on the top drop bar and click DB and refresh object browser. I understand your frustration. It looks hard at start but it really is pretty easy.
@Will,
What you want to do is create a character. Call it like ahbot. Log into the character once. after that you will need the account and Guid number. You go to sqlyog and under characters you will see your characters and the numbers you need. You may have to refresh the database. Under DB on the top bar click refresh object browser. Write down the guid and account number. you will need this for the next step
Next open up mangosd.conf file. Scroll almost all the way down. you will see this.
# Auction House Bot character data
AuctionHouseBot.Account = 5
AuctionHouseBot.GUID = 2
those are my numbers. "0"s are there now. enter your numbers. your almost done
# Note: If you enable AllowTwoSide.Interaction.Trade, ALL auction houses are
# linked to the neutral auction house.
AuctionHouseBot.AllianceItems = 300
AuctionHouseBot.HordeItems = 300
AuctionHouseBot.NeutralItems = 500
Now you will see this. Those will be "0"s at default. enter these numbers you see here.
Restart your server and do not log into your ahbot character again. When you go there with your other the auction house will be full of items. Thats all,restart your server if you hadnt yet.
Yeah you can put portals at Gm island. anyone can go there that you want to. Theres a few others depending on the data base which are cool also. GMlace and GMplace2. yo ucan just spawn the NPC venders there as well. just add the 1 at the end with a space to make them stay perm. Im a pro at making portals on ascent but havnt tackled mangos yet. i will browse up on it and if you need help let me know.
Hope this helps you out.
I am having problem with the items loading:
Paget text (Id: 42) has not existing next page (Id: 43)
Paget text (Id: 263) has not existing next page (Id: 264)
Paget text (Id: 383) has not existing next page (Id: 384)
Paget text (Id: 704) has not existing next page (Id: 705)
Paget text (Id: 2635) has not existing next page (Id: 2636)
Loading Items...
Error in 'item_template' table, probably sql file format was updated (there should be 142 fields in sql).
-------------------
And after I can't do anything.
@Pirox thats a easy one. there is a GREAT site that it is automated. Just drop down menus. You can create items, weapens bags, npc. its for mangos and ascent both. they also have already made items. after you are done making it you download as a SQL and just restore from sql dump and select the sql you want to add.
You will have to register an account. its free and easy.
http://wow-v.com/browse.php?t=all
@Gta: I've never uninstalled mangos before ><. So I'm guessing I just have to delete the folder holding all my map, vmaps and database.. right?
I am having a problem with 'item_template' here it say this maybe be outdated, where I can find the newest?
can anyone tell me the size of vmaps and maps?
@aqw The vmaps folder is 1.75 and maps is 1.06.
@Uber you dont have to delete the Vmaps and Maps. You can jsut cut and paste them somewhere else. Delte the old foldere where reaper was. Re-install. cut and paste the maps and vmaps back. there is no reason to redo. The new install will over write the files on your database.
Hope this helps
@Gta: >:(!! Still getting that error when I start realmd....
Forgot to add, now my mangosd is really stuffed too....
I will need an SDB newer than 207-4344? If yes, where I can find it?
@Gta
thanks, its good to hear that since my old vamps for v232 is ~2.0gb large.
Bumpy ;P
i never got an answer so im reposting this.
i have WoW version 2.3.3 and i just did a new installation of mangos 5116. i’m pretty sure i followed all the steps properly but im getting the following error when i try to run mangosd.exe after successfully initializing data stores:
You have _outdated_ DBC files. Please extract correct versions from current using client.
i rerun extract-enUS and notice this error:
Output directory: .
Fatal: Could not locate MPQ archive patch-enUS-2.MPQ
Press any key to continue. . .
so i press any key to close window and check C:\Program Files\World of Warcraft\Data\enUS and patch-enUS-2.MPQ is not there. assuming all is fine, i move the new dbc folder to C:\WoW\data overriding the old one (that i just moved there while extracting maps, vmaps, and dbc files). i rerun mangosd and get the same error. after this i run the Blizzard Repair Utility and repeat everything from extracting the DBC files to running mangosd, getting the same exact results. im not sure what im doing wrong, any advice? thanks in advance.
@Aratel: If you look for the files they are trying to run against you should find these particular MPQ files from which the DBC's will be extracted probably reside in the DATA subfolder of your C:\program files\world of warcraft folder SO just copy the five files from the DBC Extractor folder into this data folder and try rnuning them from there. They should create a DBC subfolder within the data folder and there will be all of your DBC files
Later you will need to have this new DBC folder grouped together in a folder with your other extracts (MAPS and VMAPS folders all referenced in the Mangos CONF file).
Cheers and good luck.
Oatman! What do you mean you no longer work on the mangos project?! GASP! Nooo.
If it's not out of line to ask, do you maybe have source code somewhere of your last release you could share - has someone else picked it up? Our blink is broken even if we can't figure that iout ourselves we might be able to find someone smart like yourself to study it and find the problem to get us fixed.
What caused this terrible event the flood? I'm pretty bummed about that. Did I miss a message elsewhere in teh blogs?
Hi there , how can i change Reputation of chars in 5116 rev ?? thanks for help
@warchieft
Look in your database under characters.
go down to character_reputaion and Click the little eye on the top bar. you can edit and save there. I dont think mangos has GM commands to edit reputions. I looked and couldnt find any. you will have to edit by hand. Its pretty easy
Anyone else got some insight on my problem?
@Uber
If you deleted the old reaper folder and installed the new one at the default settings, then run the install thats included it should of rebuilt the database. Did you extract the DBC files? This version i believe didnt come with any. I just used my old ones from 5082.
I guess you can try to delete the old database tables. Characters,mangos,realmd and scriptdev2. You just click on each one and click drop database. it will get rid of all the files and database. This way you can start with a empty fresh database. Let the program extract to the deafult directory.
Then go to your reaper--easy-mangos folder and click reaper-x-mangos. not the one in the upgrade, since you are not upgrading. Go through the settings and it will load the database back up.
Move your DBC folder,maps and vmaps to a folder called Data. then the data folder goes
here C:\reaper-x-easy-mangos.
you should be able to click mangosd.exe and realmd.exe. it should load up. let me know.
Btw I get this error while installing,
'mysql' is not recognized as an internal or external command,
operable program or batch file.
What version of mysql server are you running? I have 5.0. You may want to go to control pannel and uninstall mysql server. then you may have to do a restart before you can delete the actual folder. Go to program files and mysql server folder and delete it. Then do a fresh install of it. Your mysql server may be corrupted some how. It happened to me once alittle while back. It is very frustrating i know. But sooner or later it will be going for you.
@Uberwabbit: MySQL can be run in either GUI mode where you go to services and turn on the service there or it can be started and utilized in a console mode like an EXE file. When you see commands trying to run MySQL as an EXEcutable program instead of a service you will perhaps want to make sure that the MYSQL programs are in your computers environment PATH.
If you aren;t familar with this, it's usually gotten to by right click on "MyComputer" and go to properties, advanced, Environment.
Another way to see what your path looks like is to open the Command prompt window and type SET
SET will display all environment variables too.
Either way you will want to either put the MySQL executable programs in one of the existing paths OR perhaps preferably ADD the path where they reside on your machine to your PATH environment variable string.
I hope that helps.
@Gta: I have fully uninstalled and deleted everything to do with MySQL. However I'm still getting that error!! Plus when I opened mangosd this time I saw something else 'realm.realmd.realmlist missing. So do I download a realmlist or something?
#Uber and anyone having trouble getting a hang of this MySQL database please read:
Here is a very easy way of getting through the SQLYog import of the SQL files which I had gone to a while back when I was stuck.
Somewhere in the various Mangos install packages locate the SQL files. There will sometimes be one each for Characters, Realmd, scriptdev2 and Mangos. Sometimes they roll it all into one big SQL file. Sometimes they include delete table commands sometimes not (and in that case you have to clear the old tables yourself). How you can deal with all of these conditions and variables is to try to get a better knowledge of MySQL and lets say SQLYog because well it's what I like to use.
When it's all in one SQL file the file will usually have USE statements within to switch the default database from database to database.
The USE Statement is just like clicking on the database in SQLYog where the import will then default to the currently selected database as if you had typed USE MANGOS or USE REALMD in the SQL script
If you use a fast editor like ConText (free editor can be downloaded which I recommend unless you have a good one already TextPad also good) and load one of the large Mangos.SQL files they are usually at least 60 meg on up to 170 meg depending on which one you want to use.
SO OK Load it up in your text editor (hopefulyl not notepad) and look near the top they usually have comments like this
"Target Database: mangos"
To properly import such a database you will usually want to select the Mangos database in your SQLYog and Right click on it and tell it to EMPTY database then go to tools and restore database from Dump and reimport the SQL to fill that database again. Thats one very easy way to make sure you (A) have Mangos selected as the default database (B) empty the mangos database and have it ready to receive a new SQL dump (C) what sort of SQL dump it is won't matter as much if it is simply creating tables and filling them or had the DROP table commands included when the SQL dump was created.
Next back to the use command. With SQLYog open click on a populated Mangos database if you have one and click in the open top right SQL command line 'QUERY window' and type this (making sure to delete whatever was there before you started typing so that what you type next that is the ONLY text in that window)
select * from db_version
then press [F9].
Note how it returns your database revision and that of course comes from your Mangos database db_version table.
Next type USE CHARACTERS [F9]
and then select * from db_version [F9] again
Notice how you get an error. probably looks like this
Error Code : 1146 Table 'characters.db_version' doesn't exist
OK so click mangos again and do the select again and it works now instead of typing use characters simply CLICK on the characters database and then run the select dbversion again and same error. Just pointing out that some people may not realize that clicking a database and typing USE DATABASE are pretty much the same thing and what dataabse you have selected MAKES a big difference because it's like type USE DATABASE which changes your default database
OK I realize this is below the level most of you are at but a very short tutorial seemed like it might be helpful for some who are struggling with some seemingly simple errors like 1146's which are now hopefully obvious user errors and not release issues. Carpet bombing the net with 'user error questions' won't usually get you where you want to go and will wear out those who seek to provide help when it is most needed after you;ve done your homework and hit a really good snag.
This may just be my perception and please I'm NOT in any way being uncaring or rude. IF you find you are asking a LOT of questions, you may really just need to go back and review all of the answers already provided and make sure you have fully accounted for and taken in those answers fully before saturating us with each obstacle you encounter. I'm in the kindest way trying to say, there is no substitute for spending some extra time in gaining the knowledge versus just obtaining the answers you seek...
Oh forgot through that whole tutorial/rant I to mention one of the BEST practice drills for gaining an excellent knowledge of this process is trying to DUMP your own SQL file. Look at the options SQLYOG gives you when creating a SQL dump, include table drop commands?, include table create commands? etc.
Practice emptying your own database tables, views etc and reimporting your own SQL dumps. You wont just get to play the latest Wow database but you'll learn your way around MySQL!
Is it possibly to get rid of "unique" in a unique-item so you can equip the 2 items at the same time?
@informative: 0.o I barely understood any of that. Not particularly noob friendly..
I read it a few times but I'm still lost, sorry..
Well before a month ago I had never installed MySQL so I'm not much beyond noob myself.
Some SQL files will create the databases and the tables like this
CREATE TABLE
USE TABLE
CREATE TABLE
INSERT DATA INTO TABLE
CREATE TABLE
INSERT DATA INTO TABLE
CREATE TABLE
INSERT DATA INTO TABLE
CREATE OTHERDATABASE
USE OTHERDATABASE
CREATE TABLE
INSERT DATA INTO TABLE
CREATE TABLE
INSERT DATA INTO TABLE
You should open your SQL files and figure out what you are dealing with before giving up and declaring its a defective SQL file. They aren't all the same.
Some just have the create table and insert data statements. When that is the case you need to make sure you create the database OR EMPTY the database if it already exists.
Hopefully thats more to the point and useful.
thank you gta i will try it
correction to be clear:
CREATE DATABASE
USE DATABASE
CREATE TABLE
INSERT DATA INTO TABLE
CREATE TABLE
INSERT DATA INTO TABLE
CREATE TABLE
INSERT DATA INTO TABLE
CREATE OTHERDATABASE
USE OTHERDATABASE
CREATE TABLE
INSERT DATA INTO TABLE
CREATE TABLE
INSERT DATA INTO TABLE
@Raidex: the item_template table has a column named maxcount. Should be column 24? (eyball estimate) Set to 1 = unique, set to 0 = not unique I believe.
How I can fix that:
2008-02-08 05:45:54 Paget text (Id: 42) has not existing next page (Id:43)
2008-02-08 05:45:54 Paget text (Id: 263) has not existing next page (Id:264)
2008-02-08 05:45:54 Paget text (Id: 383) has not existing next page (Id:384)
2008-02-08 05:45:54 Paget text (Id: 704) has not existing next page (Id:705)
2008-02-08 05:45:54 Paget text (Id: 2635) has not existing next page (Id:2636)
?
2008-02-08 05:45:54 Loading Items...
2008-02-08 05:45:59 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 141 fields in sql).
No matter what I do it doesn't work... I'm about ready to quit.
One last idea for those with errors to research try this for example for error 1146 you can search this site with google just type something like this and can see that four people asked about error 1146 in the last few months on various revisions and blog threads. Why ask if you can find your answer may already be posted.
Google: 1146 site:www.reaper-x.com
Just got a question if realmd.realmlist doesn't exist can't I just download it?
yes but its one of four databases you need. If you are missing one you may be missing others.
Ok, server working, but now what I must do to add creature or items after I get the script?
Adding ietms is easy. Go to wow-v.com
pick an item to download, Assign an item number like 51001,51002 and download the mangos SQL script. Then run the script like any SQL script. SQLYog or whatever you like.
Enter game and type .additem 51001
.additem 51002 to add your items to your inventory and check them out
for something cool I discovered try this -
.learn 31700
check your spellbook for the battle tank - instant cast and works anywhere
Should be able to put that spell on an item (may already be on an item) but thought I'd share that with those who find it not particularly noob friendly.. (snif)
@informative: Well could you give me a link to download and then I just add it? Or doesn't it work like that?
He reaper i have a little idea for u should i upload the enGB dbc so u can link it here cus you have only enUS so mail me to my mail
Greetz
Hi Reaper,
great instructions, for someone who has never done this they were easy to follow and the screen shots helped. With that said I need a little help. I've gotten to the part where I run mangosd.exe and I'm getting the following error:
Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
I tried changing the entry in the conf file with root;password;mangos but no luck. I created the file structure of c:\wow\data and made sure the datadir in the conf file had the right entry. I put the dbc, maps and vmaps into the data folder as well as everything from the reaper folder. I turned off security and made sure MySql is running. What am I missing here?
Zeezrom: Have you updated the root;password in the realmd.conf?
informative: I just tried that but got the same thing.
But to do creatures, what I do?(I have Quice here)
hi all , how can we enter Black Temple or any Dungeon , what is it command for it , cuz we don't like attunements for BT , Thanks much
About the problem I listed above, is there some inline commands I can use to trouble shoot with? I can open MySql and see the databases, tables and anything else I want.
ok, I guess my "Bump" didn't work...
So I repost my problem...
Ok, I have a really serious problem. I was not online while it happened so I have no idea why it happened.
All NPCs are gone, and, to me, it looks like they are all deleted.
Have a look in the .log files:
Server.log | DBErrors.log
#Informative
Yes, i did choose an advanced password that doesn’t match any dictionary word or anything.
Yeah, one of the worst firewalls ever, is enabled (Windows Firewall).
And I’m quite sure it was a player who did this.
And, yes, a large amount of the players joining choose to become GMs, but since I have tried making my own server before, I updated the command tables, so they wont be able harm the server at GM lvl 1.
Someone somehow did anyway, I suppose.
If you are asking me for a specific .log file, please let me know which one to upload.
**
World Database: 127.0.0.1;3306;root;kellymp110733;mangos
Could not connect to MySQL database at 127.0.0.1: Can’t connect to MySQL server
on ‘127.0.0.1′ (10061)
Cannot connect to world database 127.0.0.1;3306;root;kellymp110733;mangos
**
that is the msg i get when running mangosd.exe and a similatr one occurs when running realmd.exe although all other things i run seem to work properly
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"
Mangosd.conf file listed above. Edit it with your info. the same as when you created mysql.
Name is root and password is what you set it at. normally the root is common as the name. But if you changed default put it in.
Now to realmd.conf file
LoginDatabaseInfo = "127.0.0.1;3306;root;password;realmd"
enter the username and password you entered in Mysql.
now the last one.
scriptdev2.conf file
ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;password;scriptdev2"
the same as above. the info you entered in mysql
You edit these files in notepad and save them. then reload server. your done.
hope this helps
For some reason, whenever I equip a legendary item, it just disappears, anyone know why this happens?
Need alittle more info Raidex. What is the ID number of the item. What is the database and version of reaper are you running. What race and class are you using. I will check it out also and see if i can help you more on it.
#Gta
I am using the silvermoon database and running version 5116. For Rac and class, its all of them really. I dont know the ID's for any legendary item in the database, ill try and get them.
I really dont know what the problem is. What happends exactly? You can get the item in your bag and when you equpit it, it disapears? I am running 5116 with Silvermoon X6 and my second realm X7. (the newest 2) I have equipted a warrior and warlock on both with full legenday items. They both work fine. Did you get them from the vendors or did you .additem?
i did the .additem command. I can equip the item and do dmg/spell/other action with it.. its just over time.. it randomly disappears. I honestly cant find anything in the tables that suggests what might be the problem :|
@Mike: now that you've posted what appears to be your systems database password publicly REMEMBER to go into "MySQL Server Instance Config Wizard" and change your password later then update that again into all of your CONF files.
OK Has anyone gotten the voice chat working? Please share I would really like to get this working somehow.
Is Reaper of Oatman coming back? If they are gone I sure hope they gave the latest sourcecode to someone =(
Hello guys, anyone know how can i add one graveyard just outside Gurubashi Arena?
Or even better how can i add graveyards in some locations?
Any help appreciated,
Dex.
For Uberwabbit or anyone who may still be having trouble getting it to work still I put together a partial extract repack. I just wanted to take my working database and make that available to anyone who cared to try it. I built four separate SQL files one for each database in MySQL (Mangos, charaters, realmd and scriptdev2) and this makes it easier for me to install because I dont have to trust the SQL always has the CREATE DATABASE - USE DATABASE syntax.
Each of the SQL files does have the create database - USE database syntax at teh beginning of each so they should be pretty foolproof.
I started out practicing writing out SQL backups and restoring them to make sure I knew how to do that and decided to share them with the group.
I added a couple of bags and weapons to the starter gear so it's officially a FUN server build - everyone seemed to enjoy it..
http://filebeam.com/5f4234cad3da564e415291a52b19a491
I'm not highly technical so my ability to answer questions about it may be limited to my knowledge of the subject which is only intermediate. Now if I could just get answers to some of MY questions I'll die a happy RPG'er
@Dex
I believe you type .addgrave
Where you are standing to add a graveyard. That use to work. havnt tried it in the new pack yet. But the command is still on the GM lest for 5116.
http://steveya.wordpress.com/2008/02/03/reaper-x-mangos-5116-gm-commands-list/
Just wondering if anyone managed to ring the gong and open the gates in ahn qiraj.
were tryin to do it, but maybe we need more people on the server cause we cant get thru some quests. or its bugged i dont know.
did anyone manage to do it or is it bugged, im using porject silvermoon db. thanks
@informative: I ran your repack, but now everything has stopped working. I can't even run any of the exe files with out getting a huge line of errors. Also I still haven't been able to import realmd to SQL without getting an error.
@Kane
I dont know myself. But you can check out on other forums if no one knows here. If your on silvermoon go here
http://projectsilvermoon.net/
And check out the core to see if the instance does does work. great site also.
http://www.mangosproject.org/forum/
You will have to create accounts to search the forums, but well worth it.
thx i already registered on there, hard to use the search on silvermoon forum, gives me error page.
i added the "scepter of shifting sands" to my inventory with admin comand lol, i guess blizz saw that one coming a mile away.(didnt work either)
@Kane
Im not sure if this will work. I found this on Mangos project forum.
do .targetobject close to the entrance door then u see the objectnr. If u want to delete this door type .delobject + objectnr
Then ur door should be gone
If u type .gmon u can just walk through it
thx, but i can already pass thru that door no prob, into the regular instance. i had recently herd there was a hidden place when u ring the gong and monsters come pouring out for 10 hours it stays opened and u can get a bug mount and alot of epic stuff in that time...
Uber: if you have logmein.com or some other way for me to log into your desktop and fix it I know how I backup and restore my system from this set of files and it should work unless you have other things locking the tables while you are doing this or something.
Look at the realmd database its small and the commands are simple and it drops teh database and creates it new and inserts a few tables and records. If this is failing, it's not the SQL causing the failure. Gotta be something else.
Rememebr Your MAPS have to be good, pulled from a recent 2.3.3 retail warcraft extract.
Did you read the read me file and follow it?
hi There , can u tell me , how can we enter Black Temple or any Dungeon , What is it Command for this ? cuz we don't like to do Attunements , thanks ...
Reaper, one question - can you post the Auction-Bot patch somewhere? I compile the server on a linux-system for internal usage between the neighbours, and I can not for the heck of it find the patch anywhere (if it's not already in trunk that is...)
Can someone tell me how to change between the two databases?
So far so good with this...really enjoying it.
However, enemy casters dont cast spells...they just melee you
...if you can tell me how to fix that...would be very grateful
Mozz: have you confirmed this on all casters? We ran a Ramparts group couple of nights ago with a 62 Warrior and three other 60's and it went great casters were killing us left and right. I've checked and you are right though all of the casters in the regular world outside the instances are still not casting on my database. Where is that broken in the scripts?
mangosd.exe wont connect to the mysql database i changed the username and password in mangosd.config but still nothing
not got to instances yet...however my warlock imp does exactly the same thing...doesnt spell cast....just melee.
really annoying :(
I read that at mangos projects web site. They have a fix in the new core for it. Its a core issue. they added this to the core and mangosd.conf to fix this problem.
# Creature Spell Damage Rate.
# Examples: 2 - creatures will damage with spells 2x, 1.7 - 1.7x.
Rate.Creature.Normal.SpellDamage = 1
Rate.Creature.Elite.Elite.SpellDamage = 1
Rate.Creature.Elite.RAREELITE.SpellDamage = 1
Rate.Creature.Elite.WORLDBOSS.SpellDamage = 1
Rate.Creature.Elite.RARE.SpellDamage = 1
Its in 5157. I have the new core but trying to compile with the new AHbot.
for anyone interested here is the new 5157+scriptdev2. it does not have the Ahbot yet in it. you have to compile yourself. I offer no support for this. This is i beleive the newest core out, it has the spell fix in it for the mobs. I uploaded it for ya all who wants it,
http://www.megaupload.com/?d=WHLI527N
Enjoy
will that also fix your imp? constantly have ot manually press fireball..grrrr
also, i get manic aggro, i did the treant quest (early Belf one), and like 5-6 attacked me all at the same time even though i wasnt close enough to pull even one of them.
@Mozz
look in mangosd.conf look for
# Min limit is max aggro radius (45) * Rate.Creature.Aggro
Visibility.Distance.Creature = 66
Visibility.Distance.Player = 66
Try adjusting those to see if it helps you out. I think the main radius is a core thing but you may be able to tweak it here alittle.
There is a few more options if you scroll down alittle.
@Mozz
untill they fix the imp (or the new pack has it, havnt tried it yet) make a macro for the imp fireball. alot easier than using your mouse to use it.
Well this is odd. I went in tonight and tried looking for mobs that wont cast. Started a new Orc and the familiars in Orc starter area casting fireballs just fine. Loaded my 60 mage and his blink is working ten times in a row.
In fact, I couldn't find any real bugs in the system now. I was sure blink wasn't working before; why would it just start working like that?
So nobody has gotten the voice chat working?
should i be adjusting those levels down?
Hey. I have a question. Every time someone buys out an auction from the AHbot (possibly from other players as well.. not sure), a certain error pops up on mangos.
SESSION: received unhandled opcode CMSG_EMOTE (0x0102)
Is that anything bad?
And since I implemented the AHbot, the server has been crashing
//=====================================================
//Date 10:2:2008. Time 2:41
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 0059E666 01:0019D666 C:\ManGOS\mangosd.exe
Registers:
EAX:0398FE01
EBX:0039F4A0
ECX:13482862
EDX:0039F4A0
ESI:1BFC1DF8
EDI:1F0B6FE8
CS:EIP:001B:0059E666
SS:ESP:0023:0398FE48 EBP:0039F4A0
DS:0023 ES:0023 FS:003B GS:0000
Flags:00010202
Call stack:
Address Frame Function SourceFile
0059E666 0398FE5C deleteOldAuctions+176 i:\vscompile\mangos\reapermangos5116\src\game\auctionhousebot.cpp line 119
0059EDC4 0398FE68 AuctionHouseBot+24 i:\vscompile\mangos\reapermangos5116\src\game\auctionhousebot.cpp line 311
004A2162 0398FEAC World::Update+82 i:\vscompile\mangos\reapermangos5116\src\game\world.cpp line 886
00420903 01A41523 WorldRunnable::run+53 i:\vscompile\mangos\reapermangos5116\src\mangosd\worldrunnable.cpp line 68
========================
Local Variables And Parameters
Call stack:
Address Frame Function SourceFile
0059E666 0398FE5C deleteOldAuctions+176 i:\vscompile\mangos\reapermangos5116\src\game\auctionhousebot.cpp line 119
Local unsigned long 'ahMapID' = 59EDC4
Local 'itr'
0059EDC4 0398FE68 AuctionHouseBot+24 i:\vscompile\mangos\reapermangos5116\src\game\auctionhousebot.cpp line 311
004A2162 0398FEAC World::Update+82 i:\vscompile\mangos\reapermangos5116\src\game\world.cpp line 886
Local 'this'
Local int 'diff' = 3E0039EDE0
Local 'AuctionMap'
Local int 'i' = 1A41523
Local 'next'
Local 'itr'
Local 'next'
00420903 01A41523 WorldRunnable::run+53 i:\vscompile\mangos\reapermangos5116\src\mangosd\worldrunnable.cpp line 68
========================
Global Variables
That mean anything to anyone?
Hey Reaper-X !
I'm compiling the trunk-version of the MaNGOS server on a linux-box, and I am a bit puzzled here as I can not find the patch for the AuctionHouse bot.
Or rather, the one I find is for an old revision, and fails during compile (might be something in my end though, but it complains about some of the AuctionHouseBot code during compile, and it' shows some global defines etc, which might be why it doesn't work on *nix).
I'm currently working on a MaNGOS 0.10.0/r5194 + SD2 r251 + PSDB r222 -pack/release for linux/windows, and would be interested in topping it off with the AHBot if I could get that working as well.
#Gta
With the graveyard command nothing worked :(
I used ''commands'' to see if there is any more but nothing.
I also want to do something like to change some vendors so they are non-targetable and i would like to add some missing skills in the vendors.
Anyone know how can i do this? I have to get in the database right? If that is i dont know how :P (i have a program named Navicat i think) that as i read i can use it to see the database.
Any ideas?
Dex.
Does the auction house usually work? Has it (A) ever worked properly and stopped or (B) never worked? If (B) then probably isn't configured properly. Trying to think like a programmer for a minute, it is just using an AHBOT characters email to BE the AH. So everything posted goes into an email to the AHBot and everything coming back is either emailed back to the poster (not sold) or emailed to the Buyer (bought out or won). I tested this on mine and it seems to work fine. If I get better at putting releases together I could easily enough hopefully share my working setup with those of you who wanted. it's a pretty good blizlike server - best I've come across actually but I am still hopeful for upgrades and will continue trying new servers.
Without source code it's tough to know what might be on line 68.
I asked but nobody has suggested where source code might be or when the Reaper might return for that matter. I'm switching over to watching various release chains occur on the Silvermoon site now.
Whats funny now on my server is the warlock imps do shoot fireballs but my 60 locks imp can bun down 60 elites which just AINT RIGHT. =p
Either their health regen is too low or the elites damage is too low or they are chain casting faster than they appear to be or elites have fewer HP than they should - it's just wrong heh. Funny, but wrong.
@CHRISZ: ok so trying to be helpful. Make sure the AHBOT character can send and receive mail. Log into that account and actually send and receive warcraft mail. Then make sure your ACCT ID and Character GUID ID are noted and logged in the CONF file properly.
On some of that other stuff you all might make sure to DELETE the cache folder in yoru production World of Warcraft folder that you use to play Mangos Wow with. You should also probably make sure your scriptdev2 folder and database are setup properly for the spellcasting and/or instance bugs (I think - remember I'm like 6 weeks since getting started on this whole hobby)
Cheers.
The auction house bot is added to the core as a patch. They developed the patch at Mangos Projects. When you apply the patch then you recompile the core. The compiling is done from reaper to make things easier.
The imp fireball does work but you have to press the fireball button everytime to use it.
most all the spell problems would be core related. They have a newer core out that is spose to address those issues.
Just download the core or the patch and If your a C++ programer you can edit the source. Its not keeped by reaper. It can be found at mangos project.
You may already know this, but do not ask any questions about repacks there. Most sites frown upon them. They will always say dont be lazy and compile your own.
Its really not that hard by the way to compile your own. just follow there giude there.
ok ,nice guid ,everything seems to work :)one last thing how to make a tbc server? I have wow 2.3.3 TBC (but its french version patch frFR)!!! mangos 5116 and mysql 5.0 !! my server is up but i can't make a blood elf :( help me plzz
gta in the new mangos is there changes also where do i find the guide to compile my own please help ty
@Will
Yes there is new changes. they address the issure with spell caster mods and added a new section in the mangosd.conf to help with it. you will have to create a free account to veiw it but here is the link
http://www.mangosproject.org/forum/index.php?showtopic=7679&hl=compile+guide
ok just a few questions
1. do the pools of fish work on the copy or broke on just mine?
2. and events like gurabashi arena, and the darkmoon fair do they work they show as running in mangos but nothing happens in game?
just laboring to see if I installed wrong or they just havent been fixed in this version yet no biggie just wondering
good lets forget the post before this its fixed :)
here the step to do :
open the mangosd.exe and type this setbc account number(0normal , 1tbc)that's it its to easy
new problem...all quests have dissapeared on this repack that fixes the spell casters.
when i start the mangos server i get loads of errors referring to quests scripts saying it does not exist
does any one have a script to fix the imp that keeps killing charactors in the begining levels
it's a really anoying thing.
currently have to delete the imps or use an alternative pack
Lol, no just dont delete. you can fix it. Dont just delete before asking questions. The npc faction is set to 14. A enemy. You can change in the game but its only temporary. .setfaction 12
Now to make permament. Click on npc and
.npcinfo
Its ID is 12922. Now go to your data base under mangos. expand Creature_template and check the Show all. Scroll down to 12922.
Then go over to Faction A and Faction H
change it to 35. it will register the imps with the same Faction as there owner. restart and your done without deleting.
Dont forget to click the little disk that will save what you have done. Restart your server and its now friendly.
I have read and followed all directions but cant find a way to fix a connection problem
what i have is a plubic server that friends CAN connect to it works great im happy.
i have two computers at home
one has My server + client which WORKS with no problems the relmlist set to wowch.servegame.net
the other computer has clent but wont connect to server in bedroom.
SO
COM 1 = My server with client relmlist is set to wowch.servegame.net and WORKS
COM 2 = client NOT CONNECTING properly
Online both ports work and all friends CAN connect
so heres what i tried
on com 2 set relmlist to wowch.servegame.net and i tried my real ip from telus 70.5.526.121
(this is an example ip)
BOTH DOE NOT WORK i get unable to connect
Now if i set relmlist same as COM 1's lanIP 168.254.125.1 i get connection but after i select my relm the charactor load screen goes back to relm selection
now i know my COM 2 client does work properly due if set relmlist to reaperx.com i can play and when i had the server set as lan it worked too.
help please thanks
Sorry i use Ascent also. The GM command for mangos ingame faction is .Modify faction 12 for friendly.
Thanks Benmozz & Gta
@haney
Try changing your realmd database realmlist to your IP (not your lan one). The one under whats my IP. use that besides wowch.servegame.net. I had the same problem and that fixed it for me. and people still can connect. Just something to try.
Can anyone help me with this one? i set the right values for mangos.conf file
vmap.enableLOS = 1
vmap.enableHeight = 1
but when i try to run mangosd i get this error
Please help ><
World Database: 127.0.0.1;3306;mangos;mangos;mangos
MySQL client library: 5.0.54
MySQL server ver: 5.0.45-community-nt
Character Database: 127.0.0.1;3306;mangos;mangos;characters
MySQL client library: 5.0.54
MySQL server ver: 5.0.45-community-nt
Login Database: 127.0.0.1;3306;mangos;mangos;realmd
MySQL client library: 5.0.54
MySQL server ver: 5.0.45-community-nt
Realm running as realm ID 1
Using UDB 0.9.1 (337) with SD2 calls rev.247
Using DataDir @prefix@/share/mangos/
WORLD: VMap support included. LineOfSight:1, getHeight:1
WORLD: VMap data directory is: @prefix@/share/mangos/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Check existing of map file '@prefix@/share/mangos/maps/0004331.map': not exist!
Correct *.map files not found in path '@prefix@/share/mangos/maps' or *.vmap/*vm
dir files in '@prefix@/share/mangos/vmaps'. Please place *.map/*.vmap/*.vmdir fi
les in appropriate directories or correct the DataDir value in the mangosd.conf
file.
@ Haney
You can leave your realmlist in the wow directory with wowch.servegame.net. Just change the database one under Realmd to your real ip
@ undead
Your missing your Vmaps, diddnt extract them all or your conf file is pointing to a wrong folder.
is there anyway to get the casters working under reaper or do i have to use that repack posted?
@GTA: Lol, no just dont delete. you can fix it.
But the only purpose the imp serves is to help identify the Demon trainer standing right next to the Warlock trainer... So I vote .DELETE is way quicker =P
Found it :D nm =P
@Undead
You need to set up the Conf files. None appear to look setup. You need to set the Vmap folder and set you username and password as well. The one you used to create Mysql. Make sure you follow the Guide step by step. Theres a few things you have to set up to make it run
@informative
Why delete lol. Its easy to fix. My self i like to keep it Blizz like as possible. Plus it teaches others how to do simple things in the database. A nice learning tool to do other things and how things work in the game.
Thats just my opinion.
quickest way to get an idea if you have an install issue or not is probably to compare what files you are running to what everyone else is running.
I'm not sure what the best way to compare files is but probably size and date stamp from your EXE files and filecount and size of your DBC, MAPS, VMAPS would be a good start since I keep hearing a lot of folks figuring out they are missing files or running the wrong files.
Database compares are a bit trickier since every database is different and changes every day.. Still a full dump from someone elses working system shuold help address that and while they may import slowly SQL files RAR up nice and small.
for example I am running these EXE's
01/31/2008 14:23 3,629,568 mangosd.exe
01/31/2008 14:18 564,224 realmd.exe
If I right click my data folder with the three folders DBC, MAPS and VMAPS it says 6955 files in three folders at
2.86 GB (3,079,309,132 bytes)
If yours are significantly different let me know you may want to grab my current exe's and an extract from my SQL database (I posted one above)
Gta | Feb 11, 2008 at 3:42 / 3:42 AM | Links
@ Haney
You can leave your realmlist in the wow directory with wowch.servegame.net. Just change the database one under Realmd to your real ip
i have tried that and no one could reach me from the outside. ????
it seems i have to choose lan or plubic or simply it could be my router it's a cheap one from telus
Oh yeah here are the DLL's in my Mangos folder alongside my EXE's
12/08/2007 17:52 640,000 dbghelp.dll
10/21/2007 18:10 1,015,808 libeay32.dll
12/14/2007 11:14 2,080,768 libmySQL.dll
01/31/2008 14:30 949,760 MaNGOSScript.dll
07/15/2005 07:39 544,768 msvcr71.dll
@Haney
Make sure your ports are open and set to your ip address that your server is on. Example 192.168.0.4 each computer will be differant depending on how many you have on the network.
Under run. ipconfig will tell ya. Double check your ports. Like 8129 3306 80 if your running a web server, theres more but i have set mine up to run 2 totally differant cores. ascent and mangos both. Did you set up your windows Host file also?
Gta | Feb 11, 2008 at 3:27 / 3:27 AM | Links to this comments | Reply
Lol, no just dont delete. you can fix it. Dont just delete before asking questions. The npc faction is set to 14. A enemy. You can change in the game but its only temporary. .setfaction 12
Now to make permament. Click on npc and
.npcinfo
Its ID is 12922. Now go to your data base under mangos. expand Creature_template and check the Show all. Scroll down to 12922.
Then go over to Faction A and Faction H
change it to 35. it will register the imps with the same Faction as there owner. restart and your done without deleting.
i cant find file creature_template c:/wow/data/dbc/creature_template not there there are other like creaturetype.dbc
but when i open file with notepad or wordpad its garble so how do you expand
im using mysql 5.0
no wait i found it under progam files mysql mangos blah blah but which creature_template do i do theres more then one like frm and myd and myi
This is edited through Sqlyog. Open it up and connect to the database. You will see the differant database names. Go to Mangos. expand it with the +. Then down to creature_template. Expand that or press the little eye on the top bar of sqlyog. You will see the table open up on the right side of Sqlyog. Then check the Show all. This will take a moment due to the large database table. Then click the ID. it will put them in numerical order. Scroll down untill you see 12922. Scroll over and you will see the Imp. Keep scrolling right and you will see Faction A table and Next to it is Faction H
For horde and alliance. There will be a 14 in those. Change them to 35. Both of them. You will notice a red message on the top bar where you were typing. it says you change the database. now click the little disk on that small box where you were typing. it will save the info of what you did. Now your done.
Let me know if you need more help
If you click on the "entry" field when you select all button. It will put them in order and makes it easier to scroll through.
oh i cee im suppose to install the gui thanks
ok i figured ity out thanks
now why do i have to change the faction number to 35
@Haney
there is Mysqlyog and navicat. They are very simular, they both allow you to edit your database. Try em both and see which one you like better. I prefer Mysqlog. They both have free editions. Having one of theses are a must if you want to edit, update or change your databases.
Setting up is easy. When you create a connection you can name it whatever you want. Then your loaclhost, 3306 port and your username and password you used when you set up Mysql server. Hope this helps
@haney
because 14 is a enemy faction number. They attack. Now if you set it to 35 it makes it friendly and i belive 1604 makes it the same faction as the owner of the imp. On mine project silvermoon used 35 and UDB uses 1604. Both on the Faction_A and Faction_H. then restart your server and they are now friendly.
And dont forget to click the Little disk above that window. it saves the changes, otherwise it reverts back to the original settings
its done it works thankyou
GTA IS A GOD
is there a manual for learning those valus and what they mean
GGGGG TTTTTTTTTT A
GGG G TT A A
GGG TT A A
GGG GGGG TT A A
GGG GG TT A AAAA A
GGG GG TT A A
GGGGGG TT A A
IS A GOD
AHHHH THAT SUCKS IT WAS SUPPOSE TO BE A GIANT GTA
Actually there is a guide i compiled through my serach. Its a GM bible i got from a site. it has every faction nuber, every item number. Everything you ever wanted to know. Its in excel format. i will dig it out and put it on filebea, for you.
Im glad its working for you now:) if you need anymore help let me know.
Here ya go. Here is one of them Its the GM handbook. I will get ya more soon.
[URL=http://filebeam.com/3cc753886b9798256e861ac899d66dab]DOWNLOAD NOW![/URL]
You can get a free excell viewer from Microsoft.
http://filebeam.com/3cc753886b9798256e861ac899d66dab
Again thanks GTA once i become a master at this i will join the ranks of the helpful
LONG LIVE GTA AND REAPER-X
http://www.mangosproject.org/trac/wiki/Database/item_template
Heres another great piece of info. Alot of good stuff here.
Once you understand the database alittle better. This site is GREAT to add items and such. You actualy make them with there online windows, download the sql and execute it. Its real easy and fun to add new stuff to your Realm. Check it out.
http://wow-v.com/
@ Benmozz
What kind of problems are you having with the casters? With the mob casting? If so it is a core issue. You will have to get the new core and compile or get a pre-compiled one. You will have to set up from scratch unless they make a new pack at reaper. Alot of things are dealt with on the core level and require a patch and re-compiling.
If that is something you want to tackle go to
http://www.mangosproject.org/forum/
Its really not that hard. Just alot of reading and instaling C++ software. It takes alitte practice to compile your own.
Did not notice anyone else having this show up:
Error in `item_template` table, probably sql file format was updated (there should be 141 fields in sql).
Anyone have have a clue. This shows up when i try to start server abd it gets to loading items section.
Thanks for any help u can provide :)
@ madkicker
Actually i ran across that same error awhile back. I cant remeber the whole thing since i do alot of differant Cores. I belive its a database problem. I just emptied the database in sqlyog and restore from sql dump and intalled again (the database mangos). Make sure you use the right database. Each one is core related to a point since the have differant tables.
The UDB and Silvermoon that comes with the pack work fine. Also the New rev 7 project silver moon works as well.
If you need more help let me know.
I got it working thanks :)
What does re-extract mean what do i have to do to re-extract you know like re-extract maps,vmaps,dbc. what does it mean?
@ Ruben
Re-extract is refering to someone who has already running a reaper-repack. When you go from a patch 2.3.2 to 2.3.3 it uses the new files which are part of the client. The patch number is on your wow when you launch it. its on the bottem left side. we are up to 2.3.3.7799 If you were running the reaper 5082 you are good to go on it. It was a 2.3.3.7799 build. They just added some new features to this one. Like AHbot and Guild banks. Just follow the guides to extract the Maps,Vmaps and DBC files, that is if you have not done this repack before. It does take alittle while. Depends on your computer speed.
Just follow the guide on how to extract and where to put them.
Make sure you have the newest client. 2.3.3.7799 other wise your pack will not work. Just use the wow launcher to update your client. Also never use this again until you know its safe to get the newest build. Sometimes it takes awhile before the developers to get the new core out to work with it. You would get "cannot validate game version" if so you would have to downgrade your wow client. Which is easy and a differant guide..
Hope this helps you out
Also you must have the newest client before you can extract. other wise you will extract the lower client version and they are not compatable.
Hi guys, I'm back!
@informative: I tried all of your suggestions with no avail, I'm still receiving the same stupid error;
Database: 127.0.0.1;3306;mango;mango;realmd
MySQL client library: 5.0.54
MySQL server ver: 4.1.22-community-nt
SQL: SELECT ‘id’, ‘name’,'address’,'port’,'icon’,'color’,'timezone’,'allowedSecurityLevel’,'population’ FROM ‘realmlist’ WHERE ‘color !=’3′ ORDOR BY ‘name’
No valid realms specified.
Anymore suggestions? Would appreciate if reaper would come back, thought he might have some fix.
Hey Uber: very end of weekend here not time remains for proper assiatance. Still willing to get you configured personally if you can setup logmein or one of those type remote solution. Where it asys mangos;mangos you changed it in all the CONF files to have your correct MySQL login and password?
Is there going to be a new update of 2.3.3?
@informative: Do you mean on your repack, or reapers?
when is the 2.4.0 reaper mangos going to be available!!!!
i dont get the database for realmd>realmlist
so when i wanna start my server i get the error :Table 'realmd.realmlist' doesn't exist, some1 now wath i did wrong? did instal few times again, still didnt work
thx in advance :)
how do i get into old iron forge as a gm?
Hey everyone, and yes I am A noob to all of this.
I do know and work in the networking industry so I am kinda use to this. This is my first time installing this and i beleive i did pretty good. considering this is the only error that i have been getting for a week now. i have tried everything moving the vmap, map, and db files to wow\data and mangos\data with the same errors. tried everything on this forum to fix it too with no results. mangosd.exe is the only thing that fails everytime.
this is what my mangosd.config file looks like.
(just too datadir= that is)
# MaNGOS Configuration file
ConfVersion=2007103101
# RealmID must match the realmlist
RealmID = 1
# 0 NORMAL 1 PVP 4 NORMAL 6 RP 8 RPPVP
GameType = 1
# Allow server use expansion content
# 0 (not check expansion maps existence, not allow wisit its, not allow create new race characters, ignore account expansion setting)
# Default: 1 (check expansion maps existence, and if client support expansion and account have expansion setting then allow visit expansion maps, allow create new races character)
Expansion = 1
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = "c:\World of Warcraft\Reaper-X-Easy-MaNGOS\data"
<<<<<>>>>>>>>
wow ver 2.3.3
MaNGOS daemon /0.10.0-SVN (Revision 5054 ) (Win32)
World Database: 127.0.0.1;3306;root;martian;mangos
MySQL server ver: 5.0.51a-community-nt
Character Database: 127.0.0.1;3306;root;martian;character
Login Database: 127.0.0.1;3306;root;martian;realmd
Using UDB 0.9.0 (334) with SD2 calls rev.218
Using DataDir c:\World of Warcraft\Reaper-X-Easy-MaNGOS\data
WORLD: VMap data directory is: c:\World of Warcraft\Reaper-X-Easy-MaNGOS\data
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
ERROR:Check existing of map file c:\World of Warcraft\Reaper-X-Easy-MaNGOS\data/maps/0004331.map': not exist!
ERROR:Correct *.map files not found in path c:\World of Warcraft\Reaper-X-Easy-MaNGOS\data/maps' or *.vmap/*vmdir files in 'c:\World of Warcraft\Reaper-X-Easy-MaNGOS\data
Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
please help and yes that 0004331.map' does exist it is in the file.
"when is the 2.4.0 reaper mangos going to be available!!!!"
When it is done.
Reaper have some insight into my problem?
Martian: I would recommend putting your data files (maps, vmaps, dbc) in the root of your hard drive in a folder called data.
You currently have:
DataDir = “c:\World of Warcraft\Reaper-X-Easy-MaNGOS\data”
Try puting it as
DataDir = “c:\data\"
I may be wrong, but I hope this helps get you on the right track.
How would i incorparate the 5157 spell fix into this reaper x release?
Anyways Like someone commented earlier about the Event AI i get the same
sd2: warning >>loaded 0 localized_texts
sd2: warning >>loaded 0 eventai_scripts
Now is this just a work in progress or did something not load properly or do I have to change something to possibly make it work? Or is there another Script i could add after the installation and make it work. Cause ive noticed any quest that requires an NPC walk (ie Escort Quests) or even some Instance Events like Razorfen Krauls portal that has to open at the end of it doesnt trigger. If anyone has any information for me I would really appreciate it. Thanks
@Uber: I am using Reapers repack initially. I've overlayed different databases since he also announced it would work with Silvermoon so I probably have a version of Silvermoon for my database at this point. The key question here is how to take a working system and replicate that to another system. I would assume that would be transfer of my backup (four SQL files) and the Mangos folder which includes the EXE and DLL files and CONF files (3 of those I think).
The part that cannot be replicated because of size is the DBC, VMAPS and MAPS folders. These weer extracted directly from the 2.3.3 Warcraft. Since we haven't hear a word from Reaper in a very long time, I would not be turning blue waitnig on a 2.4.0 mangos release.
Has anyone even verified that the production Warcraft 2.4 will not run on this? I'm not going to test it because I'm perfectly happy with 2.3.3 right now. If you look ahead at some point Blizzard will deliberately make their CLIENT software incompatible with all Mangos/Ascent style reverse engineering. How do I know this? Common sense.
I'd be happy to make another package of my backup for you minus the VMAPS DBC and MAPS if "more than one" person says they will download and try to use it...
it seems to work very well and has the Silvermoon portals at all the boat locations, AH works, most mobs appear to be casting spells, overpowered Warlock imp and all. blink even seems to be working now most of the time. Every instance I have tried seems to work and GMIsland has vendors with cool epic sets on them. Not sure what else you could want.
Reaper/Oatman did an excellent job.
Oh, Btw this adds on to what i just said. Another quest trigger. The paladin Second Trail the one where the four guys have to attack you one at a time is broken aswell.
@imformative
With what your using for your private server.. do all of the Escort/instance events work properly?
um, i got it all to work and can play lan n stuff.... heres my problem. every thing runs about 2x speed, creutures, NPCs, even me. now this is my setup
im running the server on a older xp computer, i link it with 2 vista computers (and it all works) im useing the unified database.... Not silver moon, though i dont care if i need to switch. um, when i go to the champions hall to get pvp stuff, the armor venders dont work.
At the blood elf starting place place there is this thing that keeps killin me in 1 hit. now, i have tryed recopying the maps n stuff, no go. any ideas reaper?
BTW, the gm island vendors are none existent on my sever too, i dont know why......
I always get "logging in to game server"!!
I can't connect! what should I do?
I tried many many many things, but none worked!
I really need some help here!
#Reaper-X
--READ
The last poster is not reaper x. The entire contentent has been without internet for the last 2 weeks.
So, this means reaper will be gone until its fixed.
--READ
@Quillix: my testing has been somewhat limited to the instances we have played. For example I don;t know that Ramparts has any such escort quests. Do you have a particular one you would like us to test we were planning to play again Wednesday night we can try it if you name it.
Oatman! WB.
I don't understand -why- everyone is always so itchy to go to the next client release. Do what I do. Make a copy of your Warcraft folder and don't expect that everytime Bliz throws an update at you that everyone will immediately scramble to make mangos and ascent work with the next client version.
Bliz client is for retail database. If anything else works with like 2.4.x thats lucky - feel lucky. =)
Sorry to hear about Reaper's connectivity but happy to hear it's JUST connectivity and in the universe of possibility he is probably going to be back yay!
I've played two chars to lvl 70 in a regular server. But aside from a few instances I grinded/quested my way. If you have a Q let me know.
#Danilo: Sounds like you may have a setup issue with your REALMD. Check the realmd.conf and look inside the realmlist table to ensure it is set to your IP address.
#Rule: the GM Island vendors are added by option #7 as I recall it from the Reaper install batch menu.
# informative
Thanks for the tips and pointing me in the right direction. Checked some things out and found out that the AH distribution of items was equal to 101% instead of 100%. After i fixed that, no more crashes. Not sure if that was the exact problem since i tweaked some other AH bot settings.
But things are good here and i wanted to make sure to thank you for taking the time.
@imformative
Well, Wailing Caverns has an escort quest with Narlax.. and a few of the actual "Events" like in RazorFen Kraul at the end where there is this big purple shield blocking the way to the boar boss. Thats supposed to come down after triggers from killing the NPCs outside. And a few other quests i found are broken Princess Trapped quest in Arathi Highlands, The Second Trial (paladin quest).
Another quick question is there a way to increase spawn amounts.. Like in Badlands with the rock elementals and stuff where online there is about 20 in one little spawn area but on here i found maybe 2-3 of them at one time.
Also do you have any Scripts you added of your own to fix certain quests or areas?
Will check it out and let you know. I went to Zangarmarsh SE area and there is a Kayla something which is an escort quest I think and confirmed that one is not working.
Does anyone know of any current servers that have working escort quests? I think this may be universal - ALL broken maybe.
@Informative
I know on both Ascent and Mangos both, they have problems with escort quests. Its core realated and im not sure if they have working scripts for it yet for this core. It has something to do with waypoints.
@Informative
Patch 2.4 would not work with this core. They will have to work on a new version for this to work. Lately ascent has been releasing faster cores for the patches. With ascent, you are able to change the build range in the Conf. file to a point. But the new patch is not a few bug fixes. Some new content is being added. So everyone wait to update to 2.4 untill they have the new core out. It takes a few days to a few weeks depending on the Developers.
thanks mangosfan well sorta but i found the problem it was the expansion= thingy dam im dumb sometimes...see below...
IT WORKS :)!!!!!
for all of you having error *******.map does not exist try this...
change mangosd.conf files data dir=
use the / instead of \
if you still get error change were it says expansion=1 to expansion=0
and it should work just fine it did for me :)
THANK YOU REAPER-X
and good luck on the flooding there...Hope it receeds...
well mangosd.exe works now but when I try to log into WOW. I get a validation error and files maybe corrupt visit blizzard.com/support
anyone know how to fix this?
And please dont say fresh install.
@Martian
What is your client Version? It is in the bottem left corner. It says something like 2.3.3.7799.
This repack only supports 2.3.3.7799. If its under you need to run the patch to update to 2.3.3.7799. If you go over that patch you will have to downgrade.
@Martian
Never use your wow launcher. Always use Wow.exe. The launcher will always check for updates. Only update when you know your server will support the current core.
Reaper, I recently upgraded from Reaper Mangos 4651 to 5116 and am experiencing in-game issues on both UDB and Silvermoon with mob NPCs all being neutral and in a state of semi-evade bugged.
I can attack them and deal damage, but the NPCs remain neutral and if I don't deal enough damage to 1-shot kill them they regenerate back to full health within a few milliseconds.
I did not experience this issue with the older 4651 release. Did something change with the databases or did I just get really unlucky and my install became corrupted?
Is anyone else having this issue with one or both of the databases?
Dose any one knows what is the default password that is with the default 4 accounts in the database for the 4 users, Administrator, Game master, Player and the other one forgot which one it was.
gta or info do you know a site that is somewhat safe where i could start my server
i got all my computer gear up and running please help oh and how is that new silvermoon oh and ty you guys and one more thing how do i get a quest giver to give a quest and then the person turns and gives it back and they recieve money and a weapon of there choice
tu
#alexT
Do ya have GM mode enabled ? try typing .gm mode off
ops last post is for TheoryCalc so sorry
#AlexT
Try using the same password as the logon so Administrator:Administrator
LOGON : PASSWORD
I'm getting a wierd error when I run either Mangosd.exe or realmd.exe, After Mangosd.exe loads like all the stuff, I'll get an error saying: This application has requested the runtime to terminate it in an unusual way. The Same with Realmd.exe, Any help?
What would be the best way to add defualt items into all new characters inventory? i.e. add a large bag to all new characters, etc.
Thanks..
Guys how do you make custom quests like what program do you use? And how do you make custom npc's for the quests?
@Bilbemax
go to your database with Sqlyog. Go to Mangos and under playercreateinfo_item. You can add and change any class items there. Theres like 5 of these types of tables you can alter spells,skills and stuff like that on startup. You can even change there start location. Hope this helps you out
@AlexT Yeah there is a program for that, I have one for ascent, but i will look for one for you for mangos.
@will
Alot of people host there own game server. You can get a free DNS and its attached to your IP address. You could have a host company host your game for you but It can be pricey getting a good one. It has to be a pretty fast server. My self, i host my own game and have a host for my main website and forums so theres no extra taxing on my server. I have Godaddy for my website. There cheap, you can pay monthly,Descent support,cheap Domain names (1.99) and cheap startup costs. I got mine going for under 20.00. Its set up and ready to use in like 10 minutes.
The Dynamic DMS in like mygameserver.serveftp.org
There free. go here
http://www.dyndns.com/services/dns/dyndns/
and here
http://www.no-ip.com/login/?url=%2Fmembers%2Fmenu%2F%3Fsid%3D548e5c283ffa1eff842013f4880fc9db
If you need a guide to sett up let me know. I have a few laying around
@Gta
Im trying to make a daily quest for gold. I tried using Quice but it is hard and complicated. If there is a how to make a custom quest that will be great.
Thanks for your help.
@TheoryCalc
Databases do change over releases. When you upgrade from to big of a revision you could have problems. it sounds like you have database problems. There is guides out that show you how to take critical information from one to another. But if they change the tables to much you will have to convert to the new tables. This can take some time. I usually upgrade as much as possible to avoid alot of problems down the road.
@alexT
This is not ny guide. I got it from a differant site.
Unlike making custom vendors, there is a lot more customization that you can do with quests. Rather then list a guide showing how to create every quest combination I'm just going to explain each part of a quest. For simplification purposes I am using SQLyog to edit the tables for quests. For some odd reason when I use Navicate there are "memo" column I'm not allowed to edit thus making naming the quests impossible.
I break quests into 4 parts. Though some quests only need 3 parts to them. Everyquest has to have the quest itself. (part 1) Some method of starting the quest. (part 2) More then one method to starting a quest can be used. Some object or person to turn the quest into. (part 3) The 4th part is something that gives you a quest item. I am still working on this part, have had some problems with it.
Part one: The Quest
Zone ID: The zone you want your quest to be listed under. Some usable ID numbers.
blank = 5
aldrassil = 256
azshara = 16
azshara crater = 268
blasted lands = 4
duskwood = 10
echo ridge mine = 34
Elwynn forest = 12
kul tiras = 21
longshore = 2
moonbrook = 20
refuge pointe = 320
reuse me 6 = 66
stranglethorn vale = 33
swamp of sorrows = 8
the cemetery = 32
the dark portal = 72
the maclure vineyards = 64
the world tree = 13
westfall = 49
ziata'jal ruins = 128
QuestSort: The zone you want your quest to be listed under again. Why twice I don't know, but imputing a number into the first gives the same result as imputing a number into the second and leaving the first. However if you have different numbers in both of these columns the ZoneID numbers seems to be ignored and the quest will still be listed under whatever ID number you put into QuestSort
QuestFlags: Though one would imagine there is a usefulness of this column as of yet different numbers in here doesn't seem to effect quests any.
Minlevel: the level you have to be to pick up the quest
Maxlevel: the level of the quest itself. (not the "max" level to get credit for) so if you put 30 here the quest will be yellow to a 30 but gray to a 60
Type: The numbers say it all
0 blank (solable)
1(group)
41(pvp)
62(raid)
81(dungeon)
Required Races: Only these races will be able to pick up the quest. This is done binary style. To have more then one race be allowed to pick it up add the listed ID numbers together. If you only want only humans put a 1 into here. If you want only humans and dwarfs place a 5 into here. 1+4=5.
1 = human
2 = orc
4 = dwarf
8 = night elf
16 = undead
32 = tauren
64 = gnome
128 = troll
512 = bloodelf
1024 = dranei
690 = all horde races
1101 = all alliance races
***as of 5.0/5.1 this column isn't working quite right. I'll see if the base numbers have changed later***
The other Requireds are pretty self explanatory. I'll try to create a ID listing of usable numbers for these fields later on.
Limittime: now many seconds you have to complete the quest. 60=1 minute ect. Have to actually have a requirement to complete the quest, or it auto flags failed.
Special flags: Don't seem to be very special. Haven't noticed any difference in quests by placing any numbers into here.
PrevquestID: Self explanatory
NextquestID: QuestID you'll be offered as soon as you finish this one
SrcItem: ID number of an item you get when accepting the quest
SrcItemCount: How many of the items you get when picking up the quest.
Title: The name that appears inside your quest log
Details: The text at the top when you pick up a quest (ideally the in character explanation for the quest)
Quest Objectives: Text at the bottom when you pick up a quest. (the recap on what you need to do)
Quest incomplete: Text you get when you go to turn in the quest. (gives the gray out continue if you haven't completed the requirements or the pushable continue if you have)
Quest ending: shown underneath quest objectives when viewed from the quest log.
quest complete: Text you get when you turn in the quests before you click on "complete quest" button
Object text: Overwrite text describing what is required to complete a requirement. If left bank this will be be taken care of automatically by creating required mobkill or items ect later on. Text placed into here will overwrite the auto fills. Does nothing if quest has no requirements (the text to the left of "0/1" in your quest log)
ReqItemId1-4: ID numbers of item(s) needed to complete the quest
ReqItemCount1-4: How many of the item(s) you need to complete the quest
ReqKillmoborGOId1: ID number of the creature you want to require to be killed. Found inside creature_names. I'll look into the GOid part later on.
ReqkillmoborGOidcount: How many you have to kill
RewChoiceItem1-6: ID number of item(s) you can pick for completing the quest
RewChoiceCount1-6: How many you get of said item
RewItemId1-4: Item you automatically get when completing the quest
RewRepFaction1-2: ID for reputation modification when completing a quest
RewRepValue1-2: #value your rep will increase. Can also use negative numbers to decrease rep
RewRepLimit: may have a use but all blizzard quests have 0 so 0 is good enough for me.
RewMoney: how many coins you get. 1=1copper 10000=1gold
ReqXP: amount of XP you get (at max level this is automatically turned into gold)
Rewspell: Spell ID you learn upon completing the quest
Castspell: spell ID that gets casted on you upon completing the quest
Pointmapid: Not sure how it works
RequiredMoney: to complete quest. 1=1copper 10000=copper
Exploretrigger1-4: Location you must have explored to complete quest
RequiredQuest1-4: IDs of quests required to have been completed before you can get this quest
ReceiveItemId11-4: IDs of item(s) you will receive upon completing the quest. (often used to give additional quest items for later quest chains)
ReceiveItemCount1-4: Number you get of said item(s)
Isrepeatable: 0=not repeatable 1=repeatable
Part 2
Quest starter
Creature_quest_starter or gameobject_quest_starter
ID = ID of NPC who offers the quest
Quest = ID of quest offered
To make an Item give you the quest create an item or use an already made one.
Add the Quest ID number to the quest_id column
Part 3
Quest finisher
Creature_quest_finisher or gameobject_quest_finisher
ID = ID of NPC who offers the quest
Quest = ID of quest offered
Part 4
Drop quest Items
Still working on this part myself
Long but it works
All Credit Goes to Xerex
If you want to make npc vendors or items easily go here. A great site, i posted this awhile back. But its a great site.
http://wow-v.com/browse.php?t=all
#BurnZeZ: I'm making a guess you might have a problem with a DLL out of sync with the EXE. Make sure you are using a proper Server package with all of the matched DLL's to go with your Mangos and realmd EXE's. I'd also read somewhere you should install both the 2.x Dot Net runtime package as well as the 3.x (3.5?) version I thought I heard Oatman say this once and I just went and did it.
Good luck.
Yes most if not all of the escort quests are indeed bugged. Oh well. I can live with it.
Does anyone have a better launcher than mine? Here is mine. It is in EXCEL format. Just select the server name on the left and make a mental note of the login and password and then click Launch. It also has a column for the launch folder for Warcraft so you can store older version like 230 and 233 etc. Since not all servers use the same. This is handy for keeping your Production Wow (now at 240) separate and still being able to launch it conveniently. Also helps me keep my passwords straight.
http://filebeam.com/38e89efa21f3f7e78715e9abe5387f1a
Thanks in advance for sharing.
Here is a simple realm launcher. I have quite a few.
http://filebeam.com/bc01799cea6f988ca222826cf69997f7
Here is another. Almost like The orignal one.
http://filebeam.com/f963112d96bddd9ac8194b8ad9f6d957
I hope you enjoy and let me know if you like them. I didnt make them but im all over the net and have tons of addons for mangos and ascent both.
Gta your the best!
Thanks for all your help very nice gued. Was able to make my own quest :).
Thank you one more time.
Guys i have installed both Apache - PHP and they work fine.
I have forwarded the port but people can’t connect to the webpage and register. (i used the RoSpora one).
The webpage is working fine by me as i can open it and make an account.
Any help is appreciated,
Dex.
Also in his guide on ''How to install Apache2.2 and PHP'' in the final step he says ”to remove the ; from the extensions” what does that mean and where do i have to search for them and remove them?
Im still pretty knew at this stuff.. anyways Im just curious about the server itself. I have it running and well sometimes when I start it up I notice that some of the things that load change often it seems like less are loading each time. Maybe its just me but atleast it seemed that way. I most likely just save the character data then redo the whole thing.
I've done the installation and all that stuff but how can i change the realmlist to something else than 127.0.0.1 - i tried to just configure the realmlist in mangosd.conf and realmd.conf but it said i wasnt allowed to do that when i started the server
OK. Thnks informative. Um, 1 last question.....
any idea how to slow the gameplay down so every thing is'nt running 2X?
@ Lemon
This is done in the database itself. go to your database and under Realmd you will see realmlist. you edit it there, dont forget to click the little disk above the area to save. Just reload your server and you ready to go.
You edit the data base with Sqlyo or navicat. they both have free versions
@AlexT
Im glad you got it working:) If you need help just let me know and i will do my best to help you out. I have Alot of differant kind of Guids, i also have ascent guides if you ever descide to run ascent.
@Dex
Im sure you got a dynamic dns from http://www.dyndns.com. On your router port forward di you also add port 80? That is for the web page. You will also have to edit your windows host file. did you edit that as well with your dyndns info? With out that it will not work.
hope this helps
k ty gta i have two servers made only for it i thought there was a place like some of the other servers they put them in like top 100 game servers with the way my servers are setup i should be able to handle at lease 1800 per server or more with both runing will be good now i have another question that new silvermoon you posted i have not tryed it but doe's it work and if it doe's there are some files missing are we to take from the reaper mangos file and copy the missing files and add them inside with silvermoons file or what please let me know and ty for your help i will be finishing up my web and get this going for both servers
Well i've got the server running now and all that stuff. But now i have a new problem, when i make a char it doesnt show up in the char page
i wounder if reaper will be back before they release the linch king
well reaper if u see this .... either email me or put a post here on how to make that tool u`r ussing for the installing or i`l just name the new db`s and slq`s as the one`s u`r ussing :P
Hello again,
well fixed my problem before then stared getting validation errors. So decided to upgrade to mangos 5116 to support 2.3.3.7799. installed udb files and upgraded. Now I am back to the same old error that I was having issues with before. I did try the / and \ marks for the datadir= but the thing is it says logs= and there is no datadir= under mangosd.config with this new upgrade. getting that error 0004331.map does not exists please put .map .vmap and bla bla bla in correct path file. tried the expansion=0 that worked with 5089 and it ignored the error. I do have the map that it says I am missing so it isnt that.
can anyone help me? or can i use the mangos.config files from 5082 and if i did would it work? without validation errors.
and no I am not running launcher just wow.exe and that is were i get validation errors with 5082 so i figured maybe it was time to upgrade to 5116.
martian .... repair u`r wow .. and fresh install the 5116 release it doesen`t have any problem and it works very smoothly ....
and damn guys u`r bitching here about some issues that normaly if u folow the guide step by step they don`t appear
I have 5116 running very well and have only one concern. I know this has been mentioned, but I'm not sure it has been addressed. NPC scripting for the follow/escort quests.
I have found that many of the quests that require an NPC to interact with the environment are currently broken. Shadowfang Keep, where the prisoner must pick the door lock for you does not work. The Defias Traitor in Westfall does not move (though that one IS completed by entering the instance in the Deadmines itself). There are a couple more that have been confirmed above.
Where would one start to dig into the scripting aspect. I am good with SQL so if it is a DB issue I can start there. If it's in the .exe I can look there as well. My problem is basically not knowing where to start looking. Once I understand the basics of the scripting, It wouldn't be too hard for me to debug the issue.
Thanks
#Lemon: Wow Lemon that's a new one. Obviously the place I would start would be looking at the Characters database. Since it switches from REALMD to the CHARACTERS database you should verify connectivity to the database characters table using your login passwords from the Mangosd.conf file and Realmd.conf file.
Try taking what you have listed in those files and create a new connection with an enterprise manager type tool like SQLYog. Type in what you put in the conf files and make SURE you can actually manually connect with those logins and passwords you listed in the CONF's files. One time I figured I'd make it more secure and go with 3307 instead of 3306 for the MySQL port for example. It's REALLY easy to miss a little setting somewhere when you do that sort of stuff; happens to all of us.
Ok guys I set up a lvl 88 server extended the db of player stats and pet stats to 88 I allso extended the base xp db table to 88. Now when I rich lvl 70 in game the xp bar is gone and I do get xp for kills but the lvl dose not go up it stays at 70 what am i doing wrong or what do I need to do? In mangoes.config it is set to lvl 88 by the way im using silvermoon db. thank you.
@AlexT
Its core related to be level 70. I believe you will need to get a patch so it will calculate past 70. Both Ascent and Mangos developers want to keep it as much like the real blizz as possible. They make the patches and stuff like that. Matter of fact they made the auction house bot. But you have to download via svn and recompile the core to utilize this. I know this doesnt help you much but you can research it at http://www.mangosproject.org/forum/
@Osmenthe
Ascent and mangos both have the problems with the escort quests. You will have to download the Core via svn, then the patch and then recompile. You will need to install quite a few more prorams to do this. If you want to do this for mangos go here for the info.
http://www.mangosproject.org/forum/
Theres alot more to it than the repacks.
@Osmenthe
Oh and the scripting has nothing to do with Sql. Its all done in C++, so i hope your good at programming. There is patches out there that others have done. But read the guides on how to install. it takes some time to do. alot of trial and error.
@martian
No you cannot on this release use the old config files. They are differtant. But you will have to edit your new ones. Your data dir is not set to the correct path for your maps. thats what the error is. Open up both conf files and see how it was done on the original one. Mangosd.conf file. look here
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = "C:/reaper-x-easy-mangos/data"
Make sure you put all your stuff in the data folder and point to it. Like your Vmaps,maps and DBC files. now it should work with no problems.
@GTA
Thanks! C++ I can do!
I just discovered the ScriptDev2 forums and they are a wealth of knowledge! Anyone wanting to take on some of the scripting would do well to take a look at http:\www.scriptdev2.com
whoops: http://www.scriptdev2.com
@Sprite
I dont see anyone bitching here, they are asking questions because they simply overlooked something. For most, this is there first time. And a validation error does NOT need a wow repair and a missing vmap does not require a full re-install. A validation error has to do with the client not being the right version with the repack version and the Vmap error Has issuses with missing files normally due to the data-dir missing or poiting to the wrong location. Giving misleading information will even confuse them anymore. Lets try to help these people out bescides "Read the Guide" Im sure they did, thats why there asking questions.
Hey Guys - this site rocks. I carefully went through the instructions on setting up my first private wow server and all went smoothly. I'm using Hamachi on a private vpn so that I don't have to worry about dynamic IPs changing the realmlist info.
Anyway - I do have an issue... when a new character starts out in the world regardless of faction, the pets of any friendly people are hostile! like the warlock trainers - you get nearby and the imps just go BOOM HEADSHOT and it's all over. Anyone else see this and know a possible cause?
# Gta
When you are tellig me to edit my windows host file what must i look for?
Can you give more info about that?
Regards, Dex.
Hi , i have 1 one question,
i run reaper-x-mangos , well by choosing i chose 4 ,
Where is your Datadir Located?
The system cannot find the given up path.
DBC Directory doesnt exist make sure to put/copy/move the DBC directory into c: \ Program Files\World or Warcraft\Data\Mangos Maps
Press any key to continue. . .
but if i go to that map, i see dbc standing there :S , someone knows what's the problem is?
# Dflame
It seems that you're using the new 5225 version based from your description
and actually that problem was caused because there's space at your data directory location (i'll fix this on the next version, i'm really sorry for this)
as for the solution (for this problem), you need to create a new directory that doesnt contain space, for example
C:\WoW\data
and place the DBC directory, VMaps directory and Maps directory inside C:\WoW\data :)
sorry but i dont really understand u, u mean IN the world of warcraft map or a new map named WoW?,
i made now C:\WoW\data ,and i put there the maps, but i get a error for that to and in my installdir world of warcraft like C:\World of Warcraft\data\
i cant put there the maps cause i see there something like expansion.mpq and some other things, and already tried that to, :( ,
(im really noob at this, and its hard for me to understand cause im not good at english) ;)
#johann: the level 55+ aggro IMP bug in the newb areas is a bug in the release. I just selected the IMP and typed
.delete
No more imp. I think GTA mentioned a proper fix to change their faction or something.
Ok here is what my mangosd.config looks like. The old one (5082) had the DATADIR=.
This is 5116 and there is logsdir=, but NO DATADIR=. So were does it go? I ran the upgrade and got no errors. Now I am back to getting error 0004331.map does not exist. I tried the trick I did to get 5082 to work by changing expansion=0. That fixed the problem with 5082, but will not work with 5116. I need to know were to put DATADIR=
# MaNGOS Configuration file
ConfVersion=2007103101
# RealmID must match the realmlist
RealmID = 1
# 0 NORMAL 1 PVP 4 NORMAL 6 RP 8 RPPVP
# and also custom type: 16 FFA_PVP (free for all pvp mode like arena PvP in all zones except rest activated places and sanctuaries)
GameType = 1
# Allow server use expansion content
# 0 (not check expansion maps existence, not allow wisit its, not allow create new race characters, ignore account expansion setting)
# Default: 1 (check expansion maps existence, and if client support expansion and account have expansion setting then allow visit expansion maps, allow create new races character)
Expansion = 0
# Logs directory setting.
# Important: Logs dir must exists, or all logs be disable
# Default: "" - no log directory prefix, if used log names isn't absolute path then logs will be stored in current directory for run program.
LogsDir = ""
# 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;martian;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;martian;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;martian;characters"
Nevermind already found it :p , thnx for help
@Martian: I don't know what you mean there is no datadir. I still have one. The logs are for logging. My data dir (which also doesn't include space in the path name - not by coincidence) looks like this. Inside the C:\mangos\data folder you would find my DBC MAPS and VMAPS folders. If I were to put my MySQL data on the C: it would probably be there too but I opted to put that on a different drive for speed and to avoid writing so much to the C: drive.
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may # contain space characters.
DataDir = "C:\mangos\data"
# Logs directory setting.
# Important: Logs dir must exists, or all logs be disable
# Default: "" - no log directory prefix, if used log names isn't absolute path then logs will be stored in current directory for run program.
LogsDir = "Logs"
@ informative
in the magosd.config file there use to be datadir=
in my mangosd.config file there is no listed anywere in the file as shown in previous posting. All I have is logsdir=
your mangosd.config actually has the below mine does not.
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may # contain space characters.
DataDir = “”
This is wierd I know. I'll try A repair with wow and fresh install mangos 5116 and see if that fixes the problem.
thanks,
Martian
Ok i believe i followed every single details in installing Mangos Easy Server 2.3.3 Only problem am getting is when extracting the vmaps... When i extrated the first time it give me the following folders... (Maps) (Vmaps) (DBC) now the only thing i noticed is that the vmaps folder is empty after extraction and also i beleiev after looking at the log some files are still missing from the maps... So when ever i run the mangosd.exe i believe that's the name i cannot create an account...The following code below is the exact error i get when running....
2008-02-19 00:18:38 Using configuration file mangosd.conf.2008-02-19 00:18:38 MaNGOS daemon /0.10.0-SVN (Revision 5116 ) - http://www.reaper-x.com (Win32)
2008-02-19 00:18:38 to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM
2008-02-19 00:18:38 Daemon PID: 3348
2008-02-19 00:18:38 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2008-02-19 00:18:38 MySQL client library: 5.0.54
2008-02-19 00:18:38 MySQL server ver: 5.0.45-community-nt
2008-02-19 00:18:38 Character Database: 127.0.0.1;3306;mangos;mangos;characters
2008-02-19 00:18:38 MySQL client library: 5.0.54
2008-02-19 00:18:38 MySQL server ver: 5.0.45-community-nt
2008-02-19 00:18:38 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2008-02-19 00:18:38 MySQL client library: 5.0.54
2008-02-19 00:18:38 MySQL server ver: 5.0.45-community-nt
2008-02-19 00:18:38 Realm running as realm ID 1
2008-02-19 00:18:38 Using UDB 0.9.1 (337) with SD2 calls rev.247
2008-02-19 00:18:38 Using DataDir C:\WoW\data/
2008-02-19 00:18:38 WORLD: VMap support included. LineOfSight:1, getHeight:1
2008-02-19 00:18:38 WORLD: VMap data directory is: C:\WoW\data/vmaps
2008-02-19 00:18:38 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-02-19 00:18:38 ERROR:Could not find vmap file 'C:\WoW\data/vmaps/000_43_31.vmdir'
2008-02-19 00:18:38 ERROR: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 place the vmaps/map/dbc into C:\WoW\data and yet i still get this error. Not sure why... Oh another thing my World of Warcraft was a fresh copy from the server downloaded... Took me 5 hrs to download does this has anything to do with it not sure if security reason also i have install all patches.. And the only thing i ebelive missing is a copy of Burning Crusader Expanson ... My wow folder uses 6.5 gigs and not the computer i have setup the mysql and world of warcraft has no internet connection... I believe the mysql data base on the pc should auto log me cause it's on the same server if not.. Please help me otherwise.. I did everything ok.. Setup mysql...ect with no problems.. I now need futher help..
Thanks..
Ah if you don't have Burning Crusade expansion installed, you can open mangosd.conf directly and change
Expansion = 1toExpansion = 0and btw this is the old version, the new version is at 5225 :)
hello im trying tu update my server from 5085 to 5116 but i get that error on the update program
Performing Upgrade:
ERROR 1045 Access denied for user `mangos`@`localhost`
ERROR 1045 Access denied for user `mangos`@`localhost`
Done
If you see any error message just let me know
press any key to continue
how can i get that problem off...
btw my MySQL is version 5.0 and my username is Root not Mangos (maybe thats the problem and if it is how do i change mangos to root?)
thx again... on all emu server we tried (me n friends) you the most stable and with the less bugs!!!
the error message aint full in the upper post here the full version
ERROR 1045 Access denied for user `mangos`@`localhost`
ahhh the last part doesnt appers ill write it another way change the * to
*using password: YES*
btw im really sorry for flood
Anyone knows why Soul Link doesn't work
(icon doesn't appear and i dont think the
effect works either)
Thanks in Advance
Reaper, I'm in the army about to leave for Iraq and I was wondering if you could mail me a .zip file with everything I need to start a server for my friends in Iraq. Plz let me know. Thank you.
Deamondreas
im coming back the error i got...
i found how to change mangos @ localhost to root but now the error looks like
Performing Upgrade:
ERROR 1045 Access denied for user `root`@`localhost`
ERROR 1045 Access denied for user `root`@`localhost`
Done
If you see any error message just let me know
press any key to continue
what is that new problem and how do i fix that??
and why cant i get the Using Password: YES appearing with > and < (cant use the other side)
does someone mind uploadin that reaper mango file onto mediafire instead? thx!
I have a question, I went to shut down my server by typing the exit command so i could update all my modifications, then when i went to try get back into there it said on the Realmd.exe and Mangosd.exe..... Cannot connect to world database 127.0.0.1;3306;Natedogga2;password;Realm-x
Hey all just downloaded 2.4.0 patch. (Almost a Gig) Gonna extract all my maps and get everything all set. And just for the heck of it im going to try to get it going ^ ^ Wish me luck..
And Nathan...double check see if if Mysql is running. Try to login with you SQLyog to test it or ctrl+alt+del and look for the process
Just curious...What exactly gets updated when you upgrade the Mangos for the server? I'm curious to see the error I get when I try to run it with this version. What does Reaper do to make him god?
im actually having the same problem as lemon above, creating a character after logging in, and getting nothing to show up in the selection screen. my mangos cmd line says cannot connect to characters.characters. im sure this seems infantile, and the workaround is simple, but im not the best at programming and dont know what im missing. all the .conf files seem fine. HELP would be awesome.
Thanks Reaper for an excellent job. But I have the same problem. I have tested it with other races too and so far the undead has a similar issue. There is an imp next to Sarvis when you have just started and it will just attack and kill you just as you enter the deathknell.
Hi All,
I have an issue that nobody else seems to have. I get mobs that can walk into hills etc, mobs that attack you when you are flying 20ft above them. I have had other problems but I am hoping that if I fix the big one all the others will go away too. I have tried reinstalling my client and rebuilding the maps, dbc and vmaps folders. Enabled vmaps, disabled vmaps, tried both databases, tried running with a fresh client. I have tried completely blowing everything away and starting again more than once, and still no luck. Any ideas would be appreciated.
Version 2.3.3 enUS
Thanks,
Richard.
Hey. I have followed the instructions on the website and have created a GM account.
When I login to this account WoW takes me to a "Suggest a Server Page". Now I'm certain that I selected my server to be a PvP server but when I tell WoW that I would like to play on a PvP server, it has nothing to suggest.
Thanks.
Sorry, I meant Suggest a realm
Has anyone gotten 2.4+ to work yet? I have not updated because I have not seen any posted updates..