Narodigg

EDIT: Well nvm that, I got flustered and did it the detailed way w/ no password... I will not make my server public anyhow so it don't matter. I just want this shizzie to work.. Now I come across another problem. When I try to download a DB, I click on it and it and instead of downloading a file, it downloads a bunch of garbage. I dunno what the heck went wrong, but ya.. Please help. (noob)

Couple questoins, what browser are you using and please post the address that has the link you are downloading. Might just need to right-click and save target as or save link as.

@narodigg

the core sql has to be handled like the mangosd.sql with the mangos database in sqlyog

if you want to update you copy the stuff with notepad, but the sql YOU have is the WHOLE core.

Then I am confused as to what I need to download from these steps.

-Go here to download the newest UDB database (contains all the world stuff)

-Make sure that your MaNGOS core is up-to-date with the database (check your core's revision number, then the compatible revision number within the file title of the UDB database)

-Download the latest UDB update packs here (if that link doesn't work, go here and find the updates folder in /trunk)

My core revision is 7990

How do I know what revision of the DB I already have so I know where to start with update packs?

Maybe this will help all of you in assisting me.

D:\\Projects\\MaNGOS>mangosd.exe

MaNGOS/0.14.0-DEV (* * Revision 7990 - *) for Win32 (little-endian) [world-daemo

n]

<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

Using configuration file mangosd.conf.

OpenSSL 0.9.8k 25 Mar 2009 (Library: OpenSSL 0.9.8k 25 Mar 2009)

World Database: 127.0.0.1;3306;root;(mypass);mangos

Connected to MySQL database at 127.0.0.1

MySQL client library: 5.0.56

MySQL server ver: 6.0.11-alpha-community

AUTOCOMMIT SUCCESSFULLY SET TO 1

Character Database: 127.0.0.1;3306;root;(mypass);characters

Connected to MySQL database at 127.0.0.1

MySQL client library: 5.0.56

MySQL server ver: 6.0.11-alpha-community

AUTOCOMMIT SUCCESSFULLY SET TO 1

Login Database: 127.0.0.1;3306;root;(mypass);realmd

Connected to MySQL database at 127.0.0.1

MySQL client library: 5.0.56

MySQL server ver: 6.0.11-alpha-community

AUTOCOMMIT SUCCESSFULLY SET TO 1

Realm running as realm ID 1

Using World DB: UDB 0.11.0 (371) for MaNGOS 7681 with SD2 SQL for rev. 1012

Using creature EventAI: ACID 0.0.9 - Full Release for Mangos 7673+

Using DataDir ./

WORLD: VMap support included. LineOfSight:0, getHeight:0

WORLD: VMap data directory is: ./vmaps

WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId

s, vmap.ignoreSpellIds

SQL: SELECT MAX(setguid) FROM character_equipmentsets

query ERROR: Table 'characters.character_equipmentsets' doesn't exist

Loading MaNGOS strings...

==================================================== 100%

>> Loaded 645 MaNGOS strings from table mangos_string

Initialize data stores...

==================================================== 100%

You have _outdated_ DBC files. Please extract correct versions from current usin

g client.

D:\\Projects\\MaNGOS>

Thank you for the guide and support.

When following:

Updating your database with .sql batch files

-Open the .sql file you are going to use to update the database in Notepad

-Open SQLyog and connect to your server

-Select the database that is supposed to be updated

-In the textbox to the right of SQLyog at the top of the application (the query textbox), paste the contents of the .sql file

-Select all the text in the textbox, then press the play button in the toolbar at the top of SQLyog

-Parts of the application will become grayed, wait for the query to finish executing

My SQL file for the Mangos db is from:

http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Full_DB/UDB_0.11.5_Core_7681_SD2_1012.rar?view=log

Notepad would not open the file as it is so large it just locked the application. Opening it in wordpad I was able to copy it. However when I selected past into query box it does not appear. I am able to paste it into MS Word, verifying to me that it is on the clipboard.