| Register | Members | Blogs | Chat |
| World of Warcraft Discuss, [MaNGOS] Latest binaries and SDB (With no support questions! Only files) at Server Developments forum; .code{font-family: Courier, Courier New, Verdana, Arial; color: #465584; background-color: #FAFCFE; border: 1px dotted #000; padding: 2px; width:98%; margin: 0px auto ... |
|
 |
| LinkBack (57) | Thread Tools |
| It's Me
Rank: Member  |
Quote: Originally Posted by tr4shm4n Windows Version compilled by bogie : [Only Registered and Activated Users Can See Links. Click Here To Register...] Linix version compilled by Whiroph : MaNGOS 2652 [Only Registered and Activated Users Can See Links. Click Here To Register...] DBC: 1.12.1 [Only Registered and Activated Users Can See Links. Click Here To Register...] DATABASE: silver db 0.5.0 full [Only Registered and Activated Users Can See Links. Click Here To Register...] silver db 0.5.1 svn patches [Only Registered and Activated Users Can See Links. Click Here To Register...] silver db 0.5.2 svn patches [Only Registered and Activated Users Can See Links. Click Here To Register...] silver db 0.5.3 svn patches [Only Registered and Activated Users Can See Links. Click Here To Register...] New MAPS: 1.12.1 [Only Registered and Activated Users Can See Links. Click Here To Register...] New ad.exe [Only Registered and Activated Users Can See Links. Click Here To Register...] [Only Registered and Activated Users Can See Links. Click Here To Register...] Quote: Linux guide easy way to get it running - 1 Week Ago ok, u have problem - try it this way 10 steps - it's easy hehheeh 1. install svn (subversion) (debian e.g.) sudo apt-get install subversion 2. create dir for mangos: lala:/opt# mkdir mangos 3. download newest ver by exec this: notice - there is a link to svn, but you need to type it the as it is. lala:/opt# svn checkout [Only Registered and Activated Users Can See Links. Click Here To Register...] /opt/mangos If all went ok go to to next one 6. run this one and have a cup of coffe -> it'll take some time lala:/opt/mangos# make 7. ok, so you'r not sleeping - good now it's time to install it lala:/opt/mangos# sudo make install so - it's installed now - great but, it's not done yet. u have to download maps -> link and extract them into maps dir (in this archive is maps folder, so just copy&paste it in mangos dir. and you need one more tihng DBC -> link extract it into mangos dir (u have dbc dir in this archive so just copy&paste it into mangos dir). 8. ok, you can start the server. go to mangos/bin directory and from first shell (or term window) start ./realmd by typing ./realmd now start mangos from second shell or term window (also from your bin directory) type ./mangosd it will end like this (if all went ok) Loading Teleport Coords... Loading Game Object Templates... >> Loaded 180105 game object templates Scripts Library was successfully loaded. Initializing Scripts... Reference thread created. 1 reference-thread added. Grid compression apply on creatures.... Grid compression apply on gameobjects.... WORLD: SetInitialWorldSettings done WORLD: Starting Event System Setting Grid clean up delay to 300 seconds. Setting map update interval to 100 milli-seconds. User thread created. pollPendingThreads() 1 user-thread added. User thread created. Thread starting... pollPendingThreads() 1 user-thread added. Thread starting... mangos> 9. so now u have a server. you can download acc creation page -> here and if you want to add new realm (i've done that from phpmyadmin - open database realmd, click on realmlist - on left side, then on the right side click on insert. Fill in the field "name" and address (if you want to allow your network clients to connect) with your IP address of the "mangos" computer. 10. patch your W*W to 1.12.1 or 1.12.2 and you can play. ------------------------------------------------------------------------------------------------------------------------------------------- ok, one little update!!!!! IF you download mangos via svn, it can be ver 0.6, and then u need maps 1.12.2 and u can find them here (usualy, u get error that maps are outdated, then just download 1.12.2 maps and place them in /maps dir and play it again Sam ) -------------------------------------------------------------------------------------------------------------------- MySql tutorial MySql is required for mangos to work, optional is PHPMyAdmin and PHP. i.e. (debian) apt-get install mysql-server phpmyadmin php5 (to be able to install php5 and mysql 5 maybe you'll need to modify your apt source list - but that's way out of this tutor). When you install MySql, download newest SDB (HERE - SDB forum - registration needed). Ok, you have latest database, now let's create database. If you installed phpmyadmin, point your browser to i.e. [Only Registered and Activated Users Can See Links. Click Here To Register...] login to your mysql server with usrname & passwd, and you'll see a field - Create new database, there create database called mangos and once again create database realmd. Becouse phpmyadmin has a limitation of filesize to import, got to shell/terminal and type: lala:/where/u/xtracted/sdb/ mysql -p mangos < name-of-sql.sql (i.e. lala:/opt/mangos/sql# mysql -p mangos < mangosdb.sql) It will take some time to import about 100-120mb of data. Repeat the same action for realmd.sql (i.e. lala:/opt/mangos/sql# mysql -p realmd < realmd.sql ). So you have your databases up and running. You need to edit realmd database table realmlist to set it the way you want (realmname, ip .. . .). In case that it is needed, update your mangos db (in your mangos dir, there is dir sql, and inside is dir updates. There are located updates for mangos and realmd. So, point your browser to [Only Registered and Activated Users Can See Links. Click Here To Register...] login and on the left side select database mangos, then go to import, click browse and navigate to your mangos/sql/updates dir. select the update you want (recommended is to exec ALL UPDATES newer than your DB release) and hit go. If you get error, in most cases it means that the update you'r trying to do is already included in your database, but read the error output. So, this is really short mysql tutorial, i'll try to add some more things later. ------------------------------------------------------------------------------------------------------------------ To update your mangos (core and sql) you can do it this way: lala:/# svn up [Only Registered and Activated Users Can See Links. Click Here To Register...] /opt/mangos it will download all updated files newer than your release, but you have to read a bit to figure out if some major update has been made (like transports.sql) becouse transports.sql needs transports.cpp and transports.h to work fine. That's just an example, I hope this can help someone. ------------------------------------------------------------------------------------------------------------------------------------------ TESTING REALMD: UploadTemple.COM - Free File Hosting up to 30MB! TESTING MANGOS: UploadTemple.COM - Free File Hosting up to 30MB! (for acc usernames and passwords open realmd.sql, mangos.sql is patched to 2633_character_spell_cooldown.sql, that's the last patch). Quote: Windows setup guide 1. What you need: - Patch to 1.12.1 or 1.12.2 > [Only Registered and Activated Users Can See Links. Click Here To Register...] - MaNGOS maps & DBC files - [Only Registered and Activated Users Can See Links. Click Here To Register...] & [Only Registered and Activated Users Can See Links. Click Here To Register...] - [Only Registered and Activated Users Can See Links. Click Here To Register...] & [Only Registered and Activated Users Can See Links. Click Here To Register...] - MaNGOS ver. 2639 - [Only Registered and Activated Users Can See Links. Click Here To Register...] warning! this is ONLY for new installation!!! - MySQL 5 > [Only Registered and Activated Users Can See Links. Click Here To Register...] - SQLyog Free > [Only Registered and Activated Users Can See Links. Click Here To Register...] 2. Installation - install MYSQL5 for user root with password mangos then install SQLyog - open SQLyog, first connect (do not enter databases in conection dialog!!!) and then create two databases: MANGOS and REALMD - run mangos_maps1.exe and then mangos_maps2.exe and extract them to C:/MANGOS/ -extract argief to C:/MANGOS/ - NOW BACKUP YOUR DATABASE FIRST!!!! - open SQLyog and right click on REALMD, then select IMPORT BATCH FILE and select REALMD.SQL from C:/MANGOS/SQL/ and import it (just click OK) - right click on MANGOS database in SQLyog, then select IMPORT BATCH FILE and select SDB.SQL from C:/MANGOS/SQL/ and import it (just click OK) - open SQLyog and click on + next to REALMD, then right click REALMLIST and select VIEW DATA, then edit NAME and ADDRESS columns. Name = name of your server ADDRESS = IP or DNS address like 192.168.0.100 or private-test.dyndns.org 3. Config files - configure MANGOS.CONF & REALMD.CONF for your needs, but they are already configured for default 4. Accounts - You can create account with this command in mangosd.exe window: create USERNAME PASSWORD 5. Starting server - click realmd.exe - click mangosd.exe 6. Update - Deinstall old updates - Backup your database - Download update - Install new update - Check mangosd.conf and realmd.conf becouse they might have changed. - IMPORT realmd_update.sql to your REAMLD database and then sdb_update.sql to your MANGOS database, if you got errors while importing then import all sql files from SQL/partial/ - that's it Enjoy!
Quote: Originally Posted by kennythekid MANGOS SETUP GUIDE FOR WIN32: I - BASIC NEEDS: 1. Mangos Latest Bins: 1st link: [Only Registered and Activated Users Can See Links. Click Here To Register...] (by bogie) 2nd link: [Only Registered and Activated Users Can See Links. Click Here To Register...] (official mangos forum) 2. Mangos DBc and map packs: *Dbcs 1.12.1: [Only Registered and Activated Users Can See Links. Click Here To Register...] *New maps: [Only Registered and Activated Users Can See Links. Click Here To Register...] 3. Mangos Database SDB: 1st link: [Only Registered and Activated Users Can See Links. Click Here To Register...] (and find there) 2nd link: [Only Registered and Activated Users Can See Links. Click Here To Register...] ------------------------------------------------- SDB Database 0.5.2 for MaNGOS rev. 2641 ------------------------------------------------- -Full SDB -All SQL Mangos Updates -Rev 277 4. Mysql and Navicat | and other software that u might need (for Database needs) Navicat download link: [Only Registered and Activated Users Can See Links. Click Here To Register...] conTEXT download link: [Only Registered and Activated Users Can See Links. Click Here To Register...] Apache 2.0.59 win32 source: [Only Registered and Activated Users Can See Links. Click Here To Register...] PhP-5.1.6-Win32.zip source: PHP: Get Download (choose a mirror) mySQL Download Link: [Only Registered and Activated Users Can See Links. Click Here To Register...] II - INSTALATION 1. Extract your latest mangos rev. in (i'll take for example C:/mangos) 2. Get Maps and Dbc files (in case u don't know allready how to extract them) 3. Extract dbc in C:/mangos/dbc/ and maps in C:/mangos/maps 4. Get Mysql and Navicat 5. Install and configure them (if u don't know this part search someware else) 6. Open Navicat create a new connection open it then right click on connection - NEW DATABASE - name it mangos and set charset utf-8 then click OK create another database named realmd 7. Get SDB 052 unpack it and go into Navicat right click on mangos db and - Execute batch file - browse the file then OK wait untill it finishes to get all data (be sure to not get any error) 8. Open Navicat again go to realmd db right click on it execute batch file and browse C:/mangos/sql/realmd.sql, Open it wait until it finishes to get data 9. With Navicat now go into realmd db and edit realmlist table change ip and name 10. Go into C:/mangos/ and open mangos.conf and configure it with db name user name and pass otherwise mangos will not connect to mysql and it will crash same goes for reamld.conf u will have there some little help about what does every entry 11. After you configure it all save and open mangos.exe then realmd.exe if it doesn't crash that means u have configure it good same goes for realmd.exe 12. Open Navicat go to realmd db open account table create an account and try to connect UPDATE: As u can see now u have Mangos 2641 with SDB rev 277 - when a new mangos or SDB rev goes public downlaod it from the links i provided you - what do u have to do : Mangos REV: Changelog: [Only Registered and Activated Users Can See Links. Click Here To Register...] copy all files and folders in C:/mangos/ except the config files (just check them for new entries if they have just copy them to your config files and save) check C:/mangos/sql/updates/ for a new sql files that is higher then 2641 and then inport it in your database using navicat (check the .sql files before inport to see if u have a entry like DELETE 'tablename' if so backup table context then apply the update other wise you will loose all data stored there then import the data back it) SDB REV: Link: [Only Registered and Activated Users Can See Links. Click Here To Register...] (folder 0.52) Import with Navicat all new files in mangos db (its better to use a program called 'TurtoiseSDV' to know what new changes have been made in the sql files cuz they don't post others they update the existing ones) If u don't know how to use TurtoiseSDV then u have to download all the files if the Rev changes and check for new lines inside the .sql files I WILL UPDATE THIS WITH NEW THINGS IF YOU ASK FOR THEM OR THERE IS SOMETHING WRONG IN IT Cheerz, KEn! Last edited by [lexx]; 11-27-2006 at 03:57 PM.. | | |||||||||
 permalink | |||||||||||
 RaGEZONE is proudly sponsored by |
 |
|
| Thread Tools | |
| |
| Register | FAQ | Members List | Calendar |
please keep this post as clean as possible. error reportings and questions are not welcome here. No support at all in this thread. Anyone posts here not binaries will be given an infraction.
