Mangos 4577, ScriptDev2 140 with PSDB and UDB work with WoW 2.1.3 to 2.2.3
By Reaper-X on Oct 10, 2007 in Emulators, Freeware, Reaper Mangos, Software
Another WoW Mangos Release, and this time the WoW Client Supported is from WoW 2.1.3 into 2.2.3, but please note that currently the Mangos team still hasn’t fully support the 2.2.x client yet so you might see various opcodes related message being displayed on your mangosd window. Though it doesn’t really affect the gameplay itself, because i have tested this release with the newly released WoW 2.2.3 and … so far everything is working (unless it’s database related of course)
Anothing thing to note is, if you get various database related error message such as Item (Entry: xxxx) have wrong (not-existed) spell in spellid_1 … and so on when you run the mangosd.exe process, you can just safely ignore that message … because i also get that message but still the mangosd server process is still up and running and i can play just fine ;) … and no … mangosd process isn’t crash even when i talked to city guard in various place :P
As a lasy note, this new release contain two database from Project Silvermoon and Unified Database so you can switch between those two database freely and decided it by yourself which database is good for you
Screenshot taken using Silvermoon DB
Okay and here are the steps …
Requirements :
Update : Mangos 4602 has been released :)
- MySQL (required in order for Mangos to work)
Mangos 4577 ScriptDev2 Rev 140 with Project Silvermoon 18 and Unified Database 0.7.5 | 14.1MB | RapidshareMangos 4577 ScriptDev2 Rev 140 with Project Silvermoon 18 and Unified Database 0.7.5 | 14.1MB | Megaupload
Fresh Installation :
1. Extracting VMaps, Maps, DBC and configuring it (to make thing easier, i’ve created a separate guide for it)
2. Extract the self extracting 7–zip archive somewhere, or you can choose to extract it in current directory. And you’ll get ReaperMangos4577 Folder
3. Go inside the reaper-eazy-mangos directory and then run the reaper-x-mangos.bat , and you’ll be prompted with this screen :
All you have to do is just write the full path into your MySQL bin directory (where mysql.exe can be found)
Note : The above step is important, if you don’t write the correct path you’ll get problem later
4. Now you just need to choose option number 1 (Install), and insert your mysql root password when prompted)
5. Now you need to configure which database you’re going to use in your Mangos Installation, in this release i have included Project Silvermoon Database and Unified Database. In below example, i choose the Unified database
As a side note, you don’t need to worry about choosing the correct database because you can always switch it later even if you already created your character with full set equipment. I choose to include 2 database so you can pick which one perform best for you
6. When you’ve finished the above process, now you just need to choose option number 4 to configure your mangos installation
If you follow my previous post about the Maps, VMaps and DBC extraction guide … you can just simply write C:\wow\data when prompted for your data directory. As for the rest (adjusting the rate) i think it’s self explained :)
7. Go to your WoW installation directory and open the realmlist.wtf file
and change the realmlist into using this one :
set realmlist 127.0.0.1
8. Run mangosd.exe and realmd.exe
9. Create new account as shown like below image for an example :
10. Done :)
Switching Database or Upgrading :
1. Run reaper-x-mangos.bat and then choose to backup your character
2. Now choose the first option (Install / Upgrade) and continue with the step until you get back to the main menu
3. Choose the third option (Restore Backup) and you’re done with switching / upgrading database
To those who’s upgrading from my previous release
4. Choose the fourth option (Mangos Config Editor) to adjust your datadirectory, and if you already configured your server to be accessible from LAN then you’ll also need to choose the fifth option to adjust your realmlist again
Here’s a screenshot taken using Unified Database (and yep i almost die there even with Custom Weapon that gives all stats plus 1000 bonus) :P
Related Link :
Official Project Related Link :
- Official Forum of Project Silvermoon
- Official Forum of Unified Database (Previously called SDB before merged with MoDB)
Of course the above already tested with WoW 2.2.3 enUS Client :)
Forgot to tell you this, but just in case you want to try my character that is usually shown on my screenshots, i also included my backup character for you to use :) … all you have to do right after installing the database, just choose the restore backup option
Note: If you choose to restore my character backup directly you’ll lose all your character data
The username to login using my test character is Reaper and password is reaper .. enjoy ;)
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
uhhhh still cant not talk to the guard and i still get tele in org to a place i have never seen
whats the difference in the databases??
# Rickie
could you tell me which guard you're talking about ? as for the teleport, that's because you're using the 2.2.x client .. which is still not supported :)
as for fix you can see it directly on :
http://www.udbforums.org/index.php?showtopic=418 (you'll need to register first) but since 2.2.x is still not supported, i decided not to include the fix
# Elliot
the first one is from silvermoon project while the other one is from unified database (previously sdb), but you need to test it by yourself to see which one give you better emulation :P
Hi Reaper,
I'm not able to download the binary from rapidshare... it always tell me that "too many people are downloading this, please retry later"
I tried for about half an hour and I'm still unable to download it...
Your other share.. mega*** was working fine for me :) thanks
You do a great job !
Are these normal also? or did I miss something?
Upgraded from 4524
Many of these are similiar, just an excert.
2007-10-09 16:04:23 ERROR:Item RandomProperty / RandomSuffix id #3475 used in `item_template` but it doesn't have records in `item_enchantment_template` table.
2007-10-09 16:04:23 ERROR:Item (Entry: 7466) have unknown (wrong or not listed in `item_enchantment_template`) RandomProperty (3479)
2007-10-09 16:04:23 ERROR:Item (Entry: 19108) have wrong ExtendedCost (794)
2007-10-09 16:04:23 ERROR:Item (Entry: 23234) have wrong ExtendedCost (3)
2007-10-09 16:04:23 ERROR:Item (Entry: 27422) have wrong Subclass value (1) for class 15
2007-10-09 16:04:23 ERROR:Item (Entry: 27437) have wrong Subclass value (1) for class 15
2007-10-09 16:04:23 ERROR:Item (Entry: 27438) have wrong Subclass value (1) for class 15
2007-10-09 16:04:23 ERROR:Item (Entry: 27439) have wrong Subclass value (1) for class 15
2007-10-09 16:04:23 ERROR:Item (Entry: 28240) have wrong (not-existed) spell in spellid_1 (23273)
2007-10-09 16:04:23 ERROR:Item (Entry: 30943) have wrong ExtendedCost (1473)
2007-10-09 16:04:23 ERROR:Item (Entry: 31458) have wrong ExtendedCost (1585)
Many of these
2007-10-09 16:04:23 ERROR:Item RandomProperty / RandomSuffix id #201 used in `item_template` but it doesn't have records in `item_enchantment_template` table.
2007-10-09 16:04:23 ERROR:Item (Entry: 32319) have wrong (non-existed) faction in RequiredReputationFaction (1856)
TIA
RazMaTaz
hum another question while im waiting for the file...
I'm currently on your 4505 version, can I upgrade directly to this version ? I have some characters I dont want to lose in the process... :)
Thanks !
# Razmataz
Yep it's normal .. and doesn't actually affect gameplay as far as i know :)
# Nexus
yep, just don't forget to use the backup option first ;)
and to be honest, i just tested downloading it ... and i also get that message from Rapidshare, it seems there're some people downloading this file right now (and this is the first time i get that message from rapidshare)
going to add mirror to megaupload (it'll take 30 minutes ++ because of my slow connection) :)
Thanks, I just dont like alot of errors. :)
One thing I did not mention is that I am still using 2.1.3 dbc,maps,vmaps and plan to stick to 2.1.3 client, if it matters.
RazMaTaz
Do i need to update any of the DBC's, Maps, or vmaps for this update, cause I am on the update you released right before this one.
How can my friend log onto the server what does he have to change on his pc
@Reaper
If u talk to the under city guards or org Or Any the BIG citys mangos locks and crashes
Hey Reaper, thanks for the tutorial I got my server up and I'm loving it. Do you think you could explain to me, how to make custom items, like weapons and armor?
Excuse me but, when i try to configure mangos i get an error saying
error 1045 access denied for user 'root @ 'local host' Please help me i had the same problem everytime please explain thoroughly i really want this thanx-
TJ
the only problem im getting is when there is more then 1 person on the server there are no drops at all
but only when we are in a group
Reaper-x, How did you make a custom item..........
(Here’s a screenshot taken using Unified Database (and yep i almost die there even with Custom Weapon that gives all stats plus 1000 bonus)Here’s a screenshot taken using Unified Database):P)
Dear Nick
maybe this link will help you create your custom items (down side you need to register)
http://www.gamerzplanet.net/forums/wow-emu/107394-making-custom-vendorss-items-please-help.html
sorry for spam
Download links for
MySQLyog :
http://www.webyog.com/en/downloads.php
Navicat :
http://www.navicat.com/download.html
Do this at your own risk
thanks for the great compile Reaper. Always looking forward to try your repacks!
hey how do i get to Emerald Dream ???? what the .go #?
Hey guys!
wonderful guide btw and everything went perfectly . . . until . . . lol. well i get to step 3 and im waiting until finished, and its been idling at
“Please wait, it’ll take a while to import the database”
for about an hour is this bad?
the time isnt what concerns me, its that my comp shows no hard drive access during this time . . . hmmmm
hey great job again but when i go in to ogrimar i get teleported too some strange place
tried several chars bt all end up same way
any tips :D greets mark
o and btw siggy do u have have the database running :P
ok nvm my post /duh seen fix
Ye! can you fix the bug so everyoe in rgrimmar dont teleports to Ashenvale Crater?
Danne
read the first 3 posts on the teleport issue. Its not a bug. Mangos core does not support 2.2.X yet.
Hi I hate to bother but I did everything exactly right and when I went to install it never gave me a choice for directory I didn't pay it any mind and kept going well I loaded up wow and it said that it couldn't validate game version may be caused by interference of another program or corruption of a file after I enter my accountname and password What should I do oh btw I went to try and install and upgrade my mangos through the comand promt and it said 'mysql' is not regonized as an internal or external comand, operable program or a batch file. please help
@ mark, what do you mean is the database running?
and do you have any idea how to fix my problem? or even what's going wrong? that would help too.
Using configuration file mangosd.conf.
MaNGOS daemon /Reaper-X R4577 0.8-SVN http://www.reaper-x.com (Win32)
to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM
Reaper-X R4577 SD2-140 http://www.reaper-x.com
World Database: 127.0.0.1;3306;mangos;mangos;mangos
Login Database: 127.0.0.1;3306;mangos;mangos;realmd
Realm running as realm ID 1
Using UDB 0.7.5 (316) with SD2 calls rev.137
SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `accoun
t`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmchar
acters`.`realmid` = '1'
Using DataDir C:\wow\data/
WORLD: VMap support included. LineOfSight:1, getHeight:1
WORLD: VMap data directory is: C:\wow\data/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
SQL ERROR: Table 'realmd.account' doesn't exist
Check existing of map file 'C:\wow\data/maps/0004331.map': not exist!
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 d
irectories or correct the DataDir value in the mangosd.conf file.
Hi I tested the Unified Database 0.7.5 , im running 2,1,3 wow version, and just let me say wow! This has soo much better IMO than the previous silvermoon version i got from 4535. Mobs are no more overpowered, my lock can get soul shards and imp no has working life regen, monster gold drops are inconsistent and not crazy high. I will have to test the silvermoon DB later but first i have some more things to test with the 0.7.5 version.
Thanks Reaper! once again, you have made my day a little brighter.
Hey, I have the same problem as james, how do you change the "/" to a "\"... i think this is the problem :D
# dookie
Thanks a lot, Glad you like it :D
# Magnus
Your welcome, and actually that's why i choose to include both database so you can decided it by yourself :)
# Azrael
Ah you can use the reaper-x-mangos.bat, and when prompted for the datadir, you just need to write it using forward or backslash (i have no problem using them both)
# James
That problem can be caused by several reasons :)
1. You WoW game doesn't have the expansion pack installed
2. You didn't extract the map properly (don't forget that if you interruped the previous process before you'll need to redo the whole extraction process by deleting the previously created map files)
3. You didn't set the correct datadir (use the reaper-x-mangos.bat)
# Siggy
If you're sure the mysql server process is running (look in the task manager -> process list tab)
then you just need to wait for the import process to complete, the import process might take 10 minutes - 2 hours or more depending on your computer specs (especially on RAM .. or free memory left) ;)
# Travis
You can just simply run the reaper-x-mangos.bat again but this time don't forget to use the correct path of your mysql.exe :)
Heya,i got the server running again,but i made it public and renamed now my mangosd says Error in item_template table,probably sql file format was up dated Could you help me again? :P
uhh is there a new land? and how do i get to Emerald Dream ???? what the .go #?
kk i have 2 problems. One is that in SFK the guys are walking into walls and stuff. And 2 is that whenever im in a group there is no loot at all. What could the problem be
For people that get tele in Org....
i use MySQL Administrator to edit my data base
1. go to data base mangos
2. look for areatrigger_template
3. hit ctrl and F put in 4801
follow what i have down below
make sure it the same that i have below u want to change target NOT trigger
SQL
UPDATE areatrigger_template SET target_map=0,target_position_x=0,target_position_y=0,target_position_z=0,target_orientation=0 WHERE id=4801;
Hey Guy, i found that when i put it on free-for-all the loot will come back. IDK if it will work for you but that solved my problem.
AND i have noticed that some quests are un-doable in 0.7.5, they say i dont have the req, and quest items come w/o charges, etc.
Okay hate to bother again but I got it running except for the part where I can choose directory s it doesn't give me a choice. and when I run wow it says it can't validate my game version what should I do?
# Meh
You'll need to run the batch file provided and choose to install the database first :)
# Travis
Which wow version you're using ?
# oatman
If you've extracted the maps and dbc from 2.2.2 you don't need to run it again :)
@reaper-X
yeah, mysqld-nt.exe is running with 41,000K memory usage, but im going on 10 hrs idling, i think theres still a problem :D
I am using 2.2.3 the version that came out yesterday.
Hello reaper,
I got some problems due the server install. if i want to execute batch file with navicat at realmd, it gives this error:
[Err] 1074 - Column length too big for column 'email' (max = 255); use BLOB or TEXT instead
[Msg] Finished - Unsuccessfully
Could you help me plz???
@Bavomaster
same here use MySQL 5.1 and MySQL Administrator worked for me =]
@Siggy
so your saying u only have 41 MB left on your hard drive?
Has anyone had hunter pet problems after update? I Have a person saying they can no longer feed thier pet.
Anyone else having trouble doing quests with the Unified DB? This is so confusing haha, the Silvermoon one is better than the last version (idk maybe there the same but im doing something defferent) but it still has OP mobs and same gold drops that are a wee bit high for some areas, but atleast more quests are working than the Unified for me.
RazMaTaz, my friend cant even do the pet initial quest with The unified DB. I'm going to try with the Silvermoon one now. The whole pet/minion deal has been kind of weird so far for me.
@ok ill try riggy thnx
@ok ill try rickie thnx
thank you so much i figured out what i did wrong i extracted everything in the wrong spot :D.
@Rickie
no man, im sayin that that's how much page file mysql is using
update . . . going on 12 hrs idle, and still nothing, the other thing, it does this with both databases :'( thought that would fix it :(
ok i know i'v asked this alot and i'm sorry.. but do you have a program or script that i can use to make an automatic account creator? like i have a website and it sends me peoples account names/pass that they want.. and it takes to long to make all those accounts.. so i wanted to make it automatic
ok so i put extracted them all in the enUS is that where there all suppose to be extracted because im getting the same error about the map thing can you help me if you have msn mine is jamessandoval48@msn.com
Hi Reaper-X, tkx for your nice work ! I have a lil question. Can we set MaNGOS as a Windows Service ? If we can, how we can do it ?
Feeding pets is broken.. needs db update.
Ticket is in svn about it.
psdb site is down atm.
Everything is working great except on my friends rogue he uses Merciless Gladiator's Left Ripper which is not displaying correctly, I'm using the psdb
I have mysqlyog so if you can just tell me the corrects display number that would probably work.
yeah the website to see what i have so far is: pvpallday.bravehost.com
for my question: ok i know i’v asked this alot and i’m sorry.. but do you have a program or script that i can use to make an automatic account creator? like i have a website and it sends me peoples account names/pass that they want.. and it takes to long to make all those accounts.. so i wanted to make it automatic
Can anyone please tell me how to update the database?
Do I use the reaper-x-mangos.bat in the reaper-eazy-mangos folder and select my database?
I have notice there is a "Updates" folder as well full of SQL files. Do I need to do anything with these to update the database? And how?
OR is the mangos database already fully updated and I dont need to worry bout updating it myself?
BTW I did a fresh install of this version Mangos 4577 using PSDB
I confirm that the feeding pet don't work with 4577...
is my problem unique then? :'(
FYI-
Food fix (food types) from udb forum works in psdb.
This fixes feeding the pets.
Just installed it freshly AGAIN and still not working properly.
No boss fights are happening as they shld, am i missing something?
OK, so I have extract the maps 3 times using Ad.exe, I still get this error. The folder where the maps are "D:\wow\data\maps" is correct but I did a search for the file there and before I moved the folder and it doesn't exist. I have 2.2.3 wow installed and that's where I am running Ad.exe. Any ideas?
World Database: 127.0.0.1;3306;mangos;mangos;mangos
Login Database: 127.0.0.1;3306;mangos;mangos;realmd
Realm running as realm ID 1
Using UDB 0.7.5 (316) with SD2 calls rev.137
Using DataDir D:\Wow\data/
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: D:\Wow\data/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Check existing of map file 'D:\Wow\data/maps/0004331.map': not exist!
Correct *.map files not found in path 'D:\Wow\data/maps' or *.vmap/*vmdir files
in 'D:\Wow\data/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate d
irectories or correct the DataDir value in the mangosd.conf file.
Hello,
i just want to say something:
Reaper you are the best!!! :D /cheer; /applaud
Hey RazMaTaz
could u link that page, or yeah i dont understand what im looking for and im having a hard time finding it.
thanks
# Rickie
sorry i didnt saw your comment before (that crash thing) btw ... i just tested talking to undercity guards ... without problem .. and mangos still up and running in the background ... so i assume that is not related to mangos itself
what OS you're running ?
# WaLshy
The updates folder is to those who want to update their database manually using mysql command :) .. if you just want the easiest way you can use the batch file included
# Skyler
If you can't locate that file, i guess the extraction process didn't finished, try deleting the maps folder and re-run the ad.exe ;)
# elliott
I believe you can find premade registration template from mangosproject forum :)
# Cyrrus
Try comparing the displayid from psdb with the udb (import the udb dump into another database and compare it) :)
Sigh :<
No matter wat i do, no matter wat database it is, the instances dont work.
Monsters dont aggro rite, dont use their abilites properly - just auto atk basically.
Same goes with ANY boss, phases dont work, they just sit there taking the dmg and auto atking.
WTF going on its so frustrating :<<<<
thx in advanced
# RazMaTaz
could you put a link to the patch.. i searched for it and i did'nt find it...
Thankx
I ran ad.exe from the command prompt, it runs to 100% and exits fine. No errors. I have 3492 map files in my map folder, yet 0004331.map doesn't exist.
..and PS, thanks for responding so quickly :)
Opening ./Data/patch-2.MPQ
Opening ./Data/patch.MPQ
Opening ./Data/common.MPQ
Opening ./Data/expansion.MPQ
Opening ./Data/enUS/patch-enUS-2.MPQ
Opening ./Data/enUS/patch-enUS.MPQ
Opening ./Data/enUS/locale-enUS.MPQ
Processing........................100%
It exists now but still get the same error. I have checked, and double checked the folders and they're there. So, hmm what now?
Nm, I'm retarded.
Hey! My server is running i can login but my friends can't. Help please :S
do u have a link for the premade registration? i'll keep looking but. if u find it before me please let me know
everytime i go to the emerald dream mangos freezes and then crashes after about 10 minutes is that normal? and thanks for the unified database it is much better than the silvermoon one though i do miss having gm island spawned :)
I read in another of your posts where you linked to wow-v for item creation, but I've been completely unable to find (anywhere) a spec for the 48 space delimited fields of the [item_instance.data] field. Would you happen to know where I might find one, or has anyone ever even put one together? Thanks much in advance.
yeah guys, per my last post; im still unable to import my database. it still hangs on
“Please wait, it’ll take a while to import the database”
im getting no hard drive access, and no processor access.
Confirmed enough wait time (9 hrs +)
confirmed that MySQL is running and i have enough free memory :(
Confirmed that it isnt a database issue, for i have tried this with 3 other databases with the same results :(
any suggestions? is this a unique problem?
@metaltildea
HOW do u get to emerald dream? is it
.tele emeralddream or a .go ( x,y,z)?!!
@ Reaper-X
i just went into the data base and change there npcflag so no one cant talk to them =D
but thanks =]
I got so far that i could run mangos.exe and all other things were set up.
But where I did not have any problems before now I get the following message when Mangos is loading items. Message says: Error in 'item_template' table, probably sql format was updated (there should be 138 fiels in sql). What should I do now?
i found one reaper but i have no idea how to get it to work. heres a link to the form page with the download if u have an easier one or could help me set this one up, id be soo very thankfull..
heres link: http://www.mangosproject.org/forum/index.php?showtopic=11235&hl=registration%20website
Hum Reaper :) very nice your build, but I tried with both DB and everytime I walk in orgrimmar, i got teleported to azshara...
I search in the database but i didn't find anything...
Thanks for all your effort
Im pretty sure the 18.5 psdb has the food fix already. I have the db, but havn't had time to update to try. I've been working on compiling on my own both the server and the scripts.
This is what I did to fix the hunter pet problem. (Feeding them)
Look near the bottom.
http://www.udbforums.org/index.php?showtopic=638
thank you for the nice repack, the following is the only questions i have, is there a way to get the voice chat to work? on a couple of foums there has been mention of haveing to enable in the mangosd.cong file, but that file did come with your repack. the other question is, what happened to project silver moon, i have rev 18, i was going to go back to get 18.5 but the site isnt working at the moment, if you have a like to down load rev 18.5 can you please post it.
thank you,
jordavious
hmm did that and they were the same id number... oh and do you know how to copy items and paste them to create like an upgraded version while still keeping the original one, using sqlyog?
Heya i have a couple problems and i raeally need help!
1.It says it cant connect to database or mysql and i put in the right path.
2.When i was 1st setting up and it asked for the password for mysql i didnt have one (( after i dwnloaded mysql it didnt even do anything or run ))
3.im confused and need help..=(
ok, kinda an update; i read the .bat file
reaper-x mangos.bat
and figured out what it was supposed to be doing while it was idling . . . so i tried to do it in SQLyog, but i got this error
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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1
i know this isnt the way it was intended to be done, but i didnt know what else to do . . . is there another way to do it or do i need to reinstall MySQL or what? I have no idea.
i just get a message saying im using an invalid game version -_- im running 2.2.3 any ideas?
dude im confused but for some reason its telling me that i dont have TBC installed?? i went to .tele Honorhold and it comes up saying i have to have TBC expansion installed when i already do......
hmmmmmmmmmmmm..........
hi reaper great job one question is there a way i could set up portals custom from one place to another pleasee help ty again
ok and i have lots of problems with talking to alot the NPCs and i cant seem to kill anything...its like my toon isnt actually on my server......i shot or attack something and the creature stands there and their hp doesnt decrease nor do they move at all....
can you make a list for what sql table for what purpose. So that if there is any bugs comes up in the game then we can modify the mysql db and try to fix it ?
#B
do you have GM mode ON, if that's the case u can talk or kill things unless i pretty much 1 hit em. do .gm off
#B regarding your system tellin you u dont have tBC installed go check the mangosd.exe promt i believe there is a setting there to tell the game if this user has tBC or not. give it a try.
peace
when i run mangosd and realmd mangos tells me thats its missing a vmap file, and when i looked in the vmap folder it was empty, how do i fix??
RazMaTaz, hi sry to be such a pain, i do see feed pet fix now, but i dont know what do to with it. Think you could help me out?
thanks
As far as I can tell the installtion went just fine. After looking at the accounts tables i can see all the accounts listed however when start up the client and attempt to connect it fails giving me the following error.
Accepting connection from '5.42.194.86:4208'
SQL: SELECT `I`,`id`,`locked`,`last_ip`,`online` FROM `account` WHERE `username`
= 'CALAMEAR'
query ERROR: Unknown column 'I' in 'field list'
I have checked the passwords on the restored accounts and even tied to make new accounts with no luck. Has anyone one else had this issue?
# Siggy
Could you tell me which mysql version you're using ? i've tried on both Windows x86 using Mysql 5.0.45 series, Linux x86 5.0.22 and 5.0.45 and it worked just fine :)
# jp
Try make sure that mysql service has been started (look under process list tab via task manager), and has been configured properly
# jordavious
Unfortunately i don't have the 18.5 yet (it seems that PSDB site down and it has been 3 days)
# Balron
The "i" column was used to stored your character password, and btw could you tell me from which revision of mangos you're trying to upgrade your mangos core ?
So I can still upgrade from one of your previous packs to this without danger when I am using the 2.1.3 client? (I just don't want to add issues I did not already have.)
I wonder how switching the databases will work, too. Do you think this will delete my custom items? (I backed them up anyway, so I can re-import, but I am interested.)
I assume upgrading the MaNGOS version will delete all the .tele locations I added, yes?
Sorry for all these questions, and thank you!
nvm to last comment, how to i change the max users?????? btw server works perfectly
Hey Reaper, nice work.
Can you give me some guidance??? Everything seems to load correctly and I can authenticate, but can't access the game server. Any help much appreciated.
PLZ need to know how to change max user, my friends cant access from their pc's, everything works perfect as i can log in no problem
btw your a legend
yeah i hae no clue how to get a regestration to work
# Phen
Phen, yes unfortunately if you have made custom stuff (weapon, etc) it'll be deleted automatically :( because it's database related (as for mangos you dont have to worry about it)
but actually i have anticipated that too :)
for example if you're using my previous 4535 release, all you have to do is just import each sql update file that has any core number above 4535 which is located in originalsql/mangos4577 directory :)
# LordBelial
You can change it by editing the mangosd.conf especially at this line :
PlayerLimit = 100
the above is the default value included, and if your friend having problem to connect to your server, that mean you didn't configure your Realmlist IP address properly (and if you're using / behind router, you also need to set up some port forwarding first)
# Taniwha
Could you tell me are you trying to connect to your server from another computer or the same computer as the server process ?
# elliott
i assume you have configured apache with php in your computer, so all you have to do is just put that registration page in your apache document root directory (to configure the registration page, you'll need to read the readme file included with that template of course)
ok, so im a moron . . . i simply had to reinstall MySQL because my former tries were messing me up, but now im having a different problem :(
when i run mangosd.exe it stops doing anything at
"Loading Item Random Enchantments Table . . ."
Going on hour 7 now . . . what do i do?