MMORPG Server Files

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 https://svn.sourceforge.net/viewvc/mangos/trunk /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. http://localhost/phpmyadmin/index.php 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 http://localhost/phpmyadmin/index.php 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 https://svn.sourceforge.net/viewvc/mangos/trunk /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).

1. What you need:
- Patch to 1.12.1 or 1.12.2 >
Download
- MaNGOS maps & DBC files - download part1 (50MB) & Mirror - download part2 (300MB) & Mirror
- MaNGOS ver. 2639 - Download warning! this is ONLY for new installation!!!
- MySQL 5 > Download
- SQLyog Free > Download

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!

MANGOS SETUP GUIDE FOR WIN32:
I - BASIC NEEDS:
1. Mangos Latest Bins:
1st link: Mangos-Files.de (by bogie)
2nd link: Board Message (official mangos forum)

2. Mangos DBc and map packs:
*Dbcs 1.12.1: Filebeam!
*New maps: MEGAUPLOAD - The leading online storage and file delivery service

3. Mangos Database SDB:
1st link: Log In (and find there)
2nd link: SendSpace | The Best Free File Sharing Service

————————————————-
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:
http://www.navicat.com/download/navicat_trial.exe
conTEXT download link:
http://www.inet.hr/~edkirin/ConTEXTsetup.exe
Apache 2.0.59 win32 source:
http://apache.org/dist/httpd/binarie…x86-no_ssl.msi
PhP-5.1.6-Win32.zip source:
PHP: Get Download (choose a mirror)
mySQL Download Link:
http://mysql.ran.ro/Downloads/MySQL-….24a-win32.msi

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: http://svn.sourceforge.net/viewvc/ma…runk/?view=log

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: https://opensvn.csie.org/SDB/patch/ (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!