Gimp

lol "kingdoms"

Good time of the day.

I'm stuck at "Setting up the databases".

When i try to connect to MySQL with SQLyog, it says "Error no 2003. Can't connect to MySQL server on 'localhost' (10013)".

Yes, MySQL runs on this machine.

Yes, I can perfectly connect using mysql command line tool.

What can be wrong ?

Forgive me my noobiness.

Make sure you don't name the databases (mangos;characters;realmd) on the sqlyog login screen before you've created them. Leave that line blank, go in, create the databases, then step back out and type their names in.

Fail.........

Too many headaches and compatibility issues with Linux, for what I use Mangos for, Windows Server should suit me fine.

This is why I'm switching to windows server

Well what I did can't really be counted as a proper patch, but atleast people can pull again without much trouble now.

Well I meant all of the patches you're hosting and keeping up to date

Well I found something but not sure, in the sql folder where you find character.sql and realmd.sql,

There is also a mangos.sql, shouldn't I load that, then UDB coz I loaded it now then it just gave me this error

2010-01-27 20:20:15 MaNGOS/0.16.0-DEV (* * Revision 9245 - *) for Win32 (little-endian) [world-daemon]

2010-01-27 20:20:15 <Ctrl-C> 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://getmangos.eu

MMMMMM

2010-01-27 20:20:15 Using configuration file mangosd.conf.

2010-01-27 20:20:15 World Database: 127.0.0.1;3306;root;mangos;mangos

2010-01-27 20:20:15 MySQL client library: 5.0.56

2010-01-27 20:20:15 MySQL server ver: 5.1.42-community

2010-01-27 20:20:15 Character Database: 127.0.0.1;3306;root;mangos;characters

2010-01-27 20:20:15 MySQL client library: 5.0.56

2010-01-27 20:20:15 MySQL server ver: 5.1.42-community

2010-01-27 20:20:15 Login Database: 127.0.0.1;3306;root;mangos;realmd

2010-01-27 20:20:15 MySQL client library: 5.0.56

2010-01-27 20:20:15 MySQL server ver: 5.1.42-community

2010-01-27 20:20:15 Realm running as realm ID 1

2010-01-27 20:20:15 Using World DB: Mangos default database.

2010-01-27 20:20:15 Using creature EventAI: Creature EventAI not provided.

2010-01-27 20:20:16 Using DataDir ./

2010-01-27 20:20:16 WORLD: VMap support included. LineOfSight:0, getHeight:0

2010-01-27 20:20:16 WORLD: VMap data directory is: ./vmaps

2010-01-27 20:20:16 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds

2010-01-27 20:20:16

2010-01-27 20:20:16 Loading MaNGOS strings...

2010-01-27 20:20:16

2010-01-27 20:20:16 >> Loaded 694 MaNGOS strings from table mangos_string

2010-01-27 20:20:16 Initialize data stores...

2010-01-27 20:20:16 ERROR:Found DBC files for build 10505 but mangosd expected DBC for one from builds: 11159 Please extract correct DBC files.

EDIT: Boy AM I stupid, I have to open my eyes lol, nvm this question I know what to do

This is mostly for other people that might read this post and get confused, DO NOT load mangos.sql, only characters.sql and realmd.sql, the mangos.sql data is from UDB.

I'll be modifying AHBot a little so it's easier for people that merge a lot of branches to see what changes belong with which modification (Primarily adding comments) might also clean up a little.

I just found that AHBot adds

Code C++:

if(sWorld.getConfig(CONFIG_ALLOW_TWO_SIDE_INTERACTION_AUCTION))

AH->auctioneer = 23442;

else

AH->auctioneer = GUID_LOPART(auctioneer);

To me this seems unneeded, I see it's for 2 side interaction but why would that need a different auctioneer ID.

BTW Here's the diff with what I changed: http://github.com/xeross/mangos/commit/63d194e8fe5d024518c2bedd2c38c02acc31a235

It's nice to see you taking over some patches Xeross, it seems Kaxias has been too busy to update his repo.

Thanks

If you change the DBC files on the server, does that affect the client (player) data as well?

Do this:

-Step 1: Delate and remake you mangos database

-Step 2: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Full_DB/UDB_0.11.6_Core_8734_SD2_1480.rar?revision=384 And Import to mangos

-Step 2: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/384_corepatch_mangos_8587_to_8734.sql?revision=384 And Import to mangos

-Step 3: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/384_updatepack_mangos.sql?revision=384 And Import to mangos

-Step 4: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/385_corepatch_mangos_8735_to_8798.sql?revision=385 And Import to mangos

-Step 5: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/385_updatepack_mangos.sql?revision=385 And Import to mangos

-Step 6: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/386_corepatch_mangos_8799_to_8994.sql?revision=386 And Import to mangos

-Step 7: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/386_updatepack_mangos.sql?revision=386 And Import to mangos

Once thats done, Apply all sql updates for mangos after the db version you have (everything after 8994 i belive)

hope that gets you somewhere

That's a ton of extra work needlessly, if people download this address through their svn clients they'll have all the patches in one directory: https://unifieddb.svn.sourceforge.net/svnroot/unifieddb/trunk/

Guys How Do I know what db I have to install, and what patch I have my client is 3.2.2a

Mangos has switched to 3.3.0a support, if you download a fresh source it will be 3.3.0a, so update your game client. Rip the dbc files from that.

Install the latest UDB database, it's still for 3.2.2a but will run fine with 3.3.0a Mangos, it just doesn't have the latest 3.3.0a content yet.

If I do this and I run those files I get the followwing error

 -- 8589

ALTER TABLE db_version CHANGE COLUMN required_8573_01_mangos_mangos_string required_8589_01_mangos_creature_template bit;

[Err] 1054 - Unknown column 'required_8573_01_mangos_mangos_string' in 'db_version'

You still need to install the Mangos sql updates found in ..mangos/sql/updates

I did everything the tutorial said but when I run mangosd.exe or realmd I get the following errors

"C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\mangosd.conf"

No such file or directory

Could not find Configuration file mangosd.conf

"C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\realmd.conf"

No such file or directory

Could not find Configuration file realmd.conf

if I look at where those files are I find them at

C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\src\\mangosd\\mangosd.conf

C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\src\\realmd\\realmd.conf

What must I do to fix this error ??

Place the files in your bin folder where your mangosd.exe and realmd.exe is

Dk reputation is bugged, at least with Knights of the Ebon Blade. They need a lot more reputation to buy rep items than what the item calls for. For example, if a tabard requires them to be friendly with the Ebon Blade, and they are, they can't buy the item until they're revered or higher.

I suggest no one even bother trying to compile on Linux until you see something in the changelog regarding the bug, Mangos won't compile on any Linux system right now.

Well you could always type .unlearn all in-game as an admin.

Don't do it though, I did it once by accident because I thought it would only affect me, oh man what a headache

Hmm I don't quite understand, are you saying Rogues are supposed to have more than 1 Stealth rank in 3.3.0?

http://www.wowwiki.com/Stealth

Patch 3.3.0 (2009-12-08): This ability no longer has multiple ranks. While active, the single rank of this ability (available at level 1) allows rogues to move at 70% movement speed.

my ah bot is running but theres still nothing in the AH.

Have you taken the time to fill out the tables in characters_auctionhousebot? That's where you set the minimum/maximum items for each faction's auctionhouse. Otherwise even if AHBOT is running, the AH will be empty!

All Stealths are bugged right now, including rogue.

I haven't tested this patch, but it apparently works:

http://github.com/insider42/mangos/commit/7f5310bdf8bd1cd2f9d6020b391254cb647a12a6

It's only a few lines you need to modify in spellMgr.cpp, so you can easily do it by hand.

When you download the latest Mangos source code there's a folder called updates, inside are the latest sql updates needed to make your database compatible with 3.3.0a. You shouldn't lose any data when applying the updates.

I'm still looking for an effective way to artificially populate a test server with what appear to be real players, 50-60 "players". Is the only way, to currently to load up multiple accounts and spawn their 9 respective bots each throughout the world? Or does anyone have an easier way?

more often than not (although this is not a universal cure I have seen it fail on things such as "Into the realm of shadow".. but if you do the following you can set MOST quests to autocomplete:

1.) in-game open a chatbar and type : .lookup quest <quest name>

2.) record the number of the quest as listed by above command

3.) open your DB and then open the table for QUEST TEMPLATE (I prefer navicat myself but you can use phpmyadmin or many other sql tools). each quest in the template will start with the fields: ENTRY & METHOD. find the quest number you recorded in the ENTRY field and then look in the METHOD field.

4.) in MOST cases if you change the number in the METHOD field to 0 , it will set the quest to autocomplete.

Wow thanks to you dude I was just able to bypass some broken quests that don't have SD2 support, nice!

Epic thread

I just hope it's kept up to date

Any chance on porting over Trinity's AHBot? Almost half of their Trinity config is dedicated to AHBot settings, it's ridiculous how much you can manipulate it.

Naicisum, could you also address the issue of he ahbot loading no enchanting trade materials (besides some lame titanium powders and various enchanting rods) into the ah as well?

Ok thanks! Did you tested if it worked anyway?

The repository has been updated and ahbot now works with the newest Mangos builds, I just checked.