My Repacks, no additional SQL Server needed!

[Triplex987]

Mangos rev3908 with SDB 197!

Mangos Revision: 3908
SDB Changeset: 197
Download:

To view the content, you need to sign in or register

WoW Version: Works best with 2.0.12, but it's possible to use it with 2.1.0 too.

Changelog:
Updated with Mangos rev3908
Updated with SDB Changeset 197
Fixed the registration in minimanager


--------------

Mangos rev 3884 with SDB 196!


Mangos Revision: 3884
SDB Changeset: 196
Download:

To view the content, you need to sign in or register

WoW Version: Works best with 2.0.12, but it's possible to use it with 2.1.0 too

Changelog
Updated with Mangos rev3884
Added some fixed to the DB


------------------

Mangos rev3880 with SDB 196!


Mangos revision: 3880
SDB Changeset: 196
Download:

To view the content, you need to sign in or register

Fun Server Version:

To view the content, you need to sign in or register

WoW Version: Works best with 2.0.12, but it's possible to use it with 2.1.0 too

Changelog:
Updated with Mangos rev3880
Added jail
Fixed the forum in minimanager
Fixed the registration in minimanager

----------------
Mangos rev3876 with SDB 196!

Mangos revision: 3876
SDB Changeset: 196
Download:

To view the content, you need to sign in or register

WoW Version: Works best with 2.0.12, but it's possible to use it with 2.1.0 too

__________________________________________________ ______________

How to setup the server​

First, make sure that any other SQL Server, apache server and skype is SHUTTED DOWN.
Then follow this simple steps to get your server up and running:

1, Download Mangos.rar and extract it to C:\

2, Extract the map files (Copy ad.exe into your WoW-folder and create a folder named "maps", then run ad.exe) and copy the files into the Mangos folder. (Additional: Download the map files from the bottom of this post)

3, Run start.bat, a website will pop up, but just close it.

4, Start realmd.exe, then start mangosd.exe, you can start playing when it's done loading.

It's all tested...and it works. If it doesnt work for you, your doing something wrong.

No other SQL server needed, all is included in the package.

--------------------

How to make your server online.
​

1, First, download SQLyog (From the bottom of this post), connect with the following info (make sure MySQL is running, use start.bat):

Connection Name: *Anything*
MySQL Host Address: localhost
User name: root
Password: mangos
port: 3306
Database(s): mangosd;realmd

2, Then, go into your realmd database, and find the table called "realmlist", right click it and choose "view data".

3, Change the address column to your IP address or your no-ip (

To view the content, you need to sign in or register

.

4, Save and close.

5, change your realmlist to your IP or no-ip and connect!

PS: If your behind a router, make sure the following ports are opened:

8085
3724

---------------------

How to open minimanager to others​

1, Go to

To view the content, you need to sign in or register

and create a host. (Example: server.dyndns.org)

2, Go to your hosts file (C:\Windows\system32\drivers\etc\hosts)

3, To the bottom of your hosts file add the following:

127.0.0.1 server.dyndns.org (or whatever you chose as your host name)

4, make sure apache is running (use start.bat) and try to connect to server.dyndns.org (or whatever you chose as your hostname)

PS: Make sure to change the IP addresses of config.php in W:\www\scripts

PSS: If your behind a router, open port 80.

-----------------

Tools​

Since im such a great guy, i've decided to add a list of some Usefull Tools, credits to the makers of each tool.

To view the content, you need to sign in or register

(credits to jerq]

To view the content, you need to sign in or register

(credits to povertas)

To view the content, you need to sign in or register

(credits to mnus)

To view the content, you need to sign in or register

(Credits to DJRavine)

----------------

Additional Downloads:

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

[Edit]: If your planning on running a fun server, i've made a customized version of SDB v196, it got portals in all the main citys, it also got Tier1 vendors in all the main citys.
It also got a spawned Hyjal and levelstats from level 1 to level 255, so it's great if your planning to have a level cap thats above 70. You can download it

To view the content, you need to sign in or register

.

PS: If your using the Fun Server version,

To view the content, you need to sign in or register

is a file with all the Tier and Weapon vendor spawns.

 

[nullbock]

Re: [Release] Mangos Rev.3876 with SDB Changeset 196!

I wonder which Database you use for this one.

SDB-TBC 0.6.4 FULL!

+ Changeset 196 doesnt really work, theres always that

ERROR:Error in `gameobject_template` table, probably sql file format was updated (there should be 32 fields in sql).

error. Maybe i missed something...?

 

[Triplex987]

Re: [Release] Mangos Rev.3876 with SDB Changeset 196!

Works great for me...
And i didnt just apply changeset 196 to a full SDB... -.-
I applied all changesets in between too....
Changeset 171-196
​

 

[nullbock]

Re: [Release] Mangos Rev.3876 with SDB v196!

Could you repack your current Database or tell me your release youre using?

I applied all changesets in between too....
Changeset 171-196

Doesnt work since 183+ cause different errors with my database?

 

[Triplex987]

Re: [Release] Mangos Rev.3876 with SDB v196!

Just download the files i've provided...Works like a charm.

Btw, updating with Mangos rev 3880 soon, got it ready, just gotta upload it.
​

 

[nullbock]

Re: [Release] Mangos Rev.3876 with SDB v196!

Your 362K SQL-DB doesnt work, import-error? Ive downloaded it a few times, always the same problem at line 351 (69K).

With other Databases i cant use the updates. Any idea? u.u;

 

[Triplex987]

Re: [Release] Mangos Rev.3876 with SDB v196!

Don't import anything, the SQL server is already added and pre-configured.
Just Download or extract the maps, put it in your Mangos folder, run start.bat and start the server and your done!

 

[nullbock]

Re: [Release] Mangos Rev.3880 with SDB v196!

but eh... you need to re-import the sql-files into my localhost mySQL Server ...?!

 

[Triplex987]

Re: [Release] Mangos Rev.3880 with SDB v196!

Jeez...
i'll tell you what to do STEP BY STEP

1, Download Mangos.rar

2, Open Mangos.rar with Winrar and extract it to C:\

3, Either download the maps files or create your own by using ad.exe

4, Put your map files in C:\Mangos

5, Run start.bat

6, Start Realmd.exe, then start mangosd.exe

7, When it's done loading, you can play!

Follow this steps exactly and it works, don't do anything that it dont says, In the Mangos.rar there already is a SQL server with all the needed files execute in to it, you dont have to execute ANYTHING into the SQL server.

 

[howie]

Re: [Release] Mangos Rev.3880 with SDB v196!

I have managed up to the point of installing MYSQL 5.0, it installs ok then i select "standard configuration" then click install as Windows service, service name "MySQL5" launch the mysql server automatically, then next, modify security password as "mangos" then next and execute.


I then run SQLyog, localhost, user:root, pass:mangos, port 3306, add databases:mangosd;realmd

there are only 3 folders in each of the databases shown in SQLyog thatere are NO tables there to alter the realmlist.

Do i import the databases ?

if i run start.bat it executes very quicly and closes, as do realmd.exe and mangosd.exe.

My main Mangos folder is intact with all the maps in.

 

[Triplex987]

Re: [Release] Mangos Rev.3880 with SDB v196!

the reason start.bat closes very quickly is that you got another SQL server running on your comp.YOU DONT NEED ANY OTHER MYSQL SERVER!! EVERYTHING IS INCLUDED IN THE PACKAGE!!

 

[nullbock]

Re: [Release] Mangos Rev.3880 with SDB v196!

Ahh sorry. I just didnt get it that Start & Stop.bat are the included SQL-Application. Its works now! Thanks alot!

 

[Triplex987]

Re: [Release] Mangos Rev.3880 with SDB v196!

Np, im glad to help!

 

[nullbock]

Re: [Release] Mangos Rev.3880 with SDB v196!

Just caus of curriousity... how

 

[Triplex987]

Re: [Release] Mangos Rev.3880 with SDB v196!

You can make all those kinda stuff with the Mangos minimanager.

To view the content, you need to sign in or register

 

[hamzie]

Re: [Release] Mangos Rev.3880 with SDB v196!

If your planning on running a fun server, i've made a customized version of SDB v196, it got portals in all the main citys, it also got Tier1 vendors in all the main citys.
It also got a spawned Hyjal and levelstats from level 1 to level 255, so it's great if your planning to have a level cap thats above 70.

This is what im looking for. I'll give this a try. Thanks for sharing this package.

Questions:
1)I was using older version before with only mangos and realmd database. This newer version have more database w/c are mangos, mangos_bc, mangosd, realmd, and realmd_bc. Can u kindly give me a short description as to what this databases for so i can know what to edit in future problems on my server?
2)What client version in needed? On my previous mangos i was running, I was using client 2.0.12, with this newer mangos version i cant enter the realm.

 

[hamzie]

Re: [Release] Mangos Rev.3880 with SDB v196!

question 2 already solved. Realm selection problem was solve by server reboot.

 

[nullbock]

Re: [Release] Mangos Rev.3880 with SDB v196!

If your planning on running a fun server, i've made a customized version of SDB v196, it got portals in all the main citys, it also got Tier1 vendors in all the main citys.
It also got a spawned Hyjal and levelstats from level 1 to level 255, so it's great if your planning to have a level cap thats above 70.

Thanks alot :3
Umn... how do i use the CustomDB ? >>;

*** @ ADMIN, please kill these Spambot Posts!

 

[Triplex987]

Re: [Release] Mangos Rev.3880 with SDB v196!

Empty your current mangos database, then execute this one.
(Choose Restore file from SQL DUmp and choose the DB)

 

[nullbock]

Empty your current mangos database, then execute this one.

I cleaned "mangosd" and tried to restore with SQLyog, but i get an error at line 133 while restoring... *blinks*

Looks like the Databases have been renamed with _bc ?