How to setup a WoTLK Trinity Server 32 & 64 Bit. All Downloads Included.

This project has switched to Trinity core...



Ok. This is not my tutorial. I used this tutorial and added a few things Prydev forgot.....but all credits go to Prydev for the tutorial.

Hello All!

This server supports WOTLK 313 Client (9947).

Videos in HQ by Pryd

Secrets of Ulduar! WOTLK 3.1.3
IMPORTANT NOTICE: No media files are hosted on these forums. By clicking the link below you agree to view content from an external website. We can not be held responsible for the suitability or legality of this material.
I AGREE



Direct link to Youtube Vids = YouTube - PryDevServer's Channel
Xfire vids for reference at = PryDevServer (prydevserver)

Highlights!!


100 % Working Vehicular combat and destructible objects!!
DK QUEST from start to Finish (no GM needed for regular players)
Full SQLs included for Easy Navicat "execution"
2 worlds, 1 purely blizzlike untouched except for me updating and minor fixes
1 Custom World full of goodies!! Such as over 40+ Custom Armor / Weapons!
Hundreds of Custom NPC vendors, teleporters, trainers ready to be spawned!
All T8 items, mobs, quests, practically 99 % working.
Custom Mounts such as the infamous "dead gryph" "turbo jetplanes"
2 FrostMournes: 1 is the supposed official and the other my personal stats!
Unique weapons / armor that you'll find nowhere else, crafted by me.
A Mangos-To-Trinity2 Character Converter now included!!


Basically this Repack is the first conversion of PryDevServer from Mangos to Trinity2, and a compilation of 50%+ of my previous 3.0.9 work.
NPC credits go to Me, Warren, and one other chap who helped make T8 Vends.

This is: PryDevServer Rev 3b CORE = Trinity2 x64/x32 4803
DATABASE = YTDB rev503 & ACID3/Heisei111

I have also included the extractor tools & mang admin.


These servers sport Northrend Instances and Raids such as Ulduar & Naxx.
Bosses, Mobs, Quests, Game Events spawned and scripted.
Working BGs, achievments, glyphs, professions, & added a few special mounts!
I have also added extra class set items made by me, useful for a GM staff or T9..


Quote:
If you find that you don't like any part of it, feel free to change it as you see fit.

Please note, I am including 2 YTDB worlds. One is a YTDB Blizzlike
The second world is a YTDB FunServer which has been manipulated by me.

That way if you like one aspect from one world you can compare the
two databases and steal pieces from each.

All vendors that you need are in the database. No world has a mall spawned.
It's all ready for you to make your Mall, hundreds of valuable NPC vendors, Teleporter Helpers, Skill Trainers, Ulduar Portal helpers and more.

Credits go to:
Mangos, Trinity, YTDB, and script teams such as ACID / Heisei
ME for compiling cores, updating and adding goodies to the dbc. Making the DK beginner quest work w/out GM intervention. And a few other minor additions.






New Trinity core 3.1.3 Server Repack done by Pyrd!!!

Quote:

---

Originally Posted by Pryd

Hello All

I only have a few days off so here's a repack that I think is seriously worthy and made by me.
Course I couldn't have done it without the dev teams and the community from this forum.
I'm just a middle man.

Included you will find my personal SQL Dumps and compiled core with extras added by me.
Unlike using YTDB's method of install ( SQLyog )

I prefer that you install my database using NAVICAT.

In fact this is a Must!!

One partially customized database that has lots of vendors, a few custom mounts, and a few DK starter quest workarounds so that they can complete the series. Also included are my teleporter quest helpers and other odd helpers.., do take a look around in the creature_template. The Ulduar helpers can be great if the portals aren't working right. Skill Master in there as well.

The other one has no fixes or vendors done by me, but.. I did do the DK work around for the pure blizzlike dbc. Other than those few
minor fixes, nothing of myne has been added, besides their updates, and all the necessary Trin scripts needed for this Trin version.

Included now is a Mangos To Trinity2 Character Converter!

Thank you Borogtech!


This is:

Trinity2 64/32 bit Core Version 4804:
YTDB Version 503 ( The latest )[/b] ( 2 world dbcs, 1 char dbc )

Use your same Realmd!. Or use the one from Trinity2 / Mangos Sources .
Tools for extracting are included but if you were previously using Mangos, keep using the SAME DATA..

Check the videos of my work on Youtube, search for PryDevServer.

http://www.youtube.com/user/PryDevServer



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

Enjoy!

PryDevServer Revision 3b - Trinity x64 / x32 + Full SQLs


Rapidshare Download

Filefront Download

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

PryDevServer Revision 4 - Trinity x64 / x32 + Full SQLs


Please Note
Due to Time constraints
The Official Guide for this Repack is located on MMowned.com

---

Rev 5b

Download


Guide to follow on next post.

Quick & Dirty Install Guide-

Prior Setup Needed but not included in this guide:
MySQL Community Server v 5.1.31 Download
MySQL Server 5.1.31 Install Guide
Xampp Download
Xampp Install Guide
Navicat Lite download


[Monolith]My Addition: Due to the size of the databases...I would recommend using SQLyog rather then Navicat....

Navicat took nearly an hour to install the mangos db while SQLyog took about 15 minutes.

Download that here: SQLyog Download

There are plenty of guides out there for the criteria mentioned above
therefore make sure to have those three working plus .net framework 3.5. You will know if you
are ready to continue my guide if you can connect to your mysql server through Navicat.


[Monolith]My additions:


Setting up Navicat and SQLyog:

Upon running the applications...you get connection set up boxes.....

http://img.photobucket.com/albums/v4...connection.jpg

http://img.photobucket.com/albums/v4...nnection-1.jpg

Just fill in the information you inserted when you installed MySQL.....

Security Tip: Make sure you change at the least the password from the default "root" to something else in MySQL.


Quick & Dirty Install Guide

There are plenty of guides out there for the criteria mentioned above therefore make sure to have mysql, working, your cpu up to date and 3.5 .net framework.
You will know if you are ready to continue my guide if you can connect to your mysql server through Navicat.


Step1
Create a Folder called C:\Trinity

Step2
Unzip all the files from my repack into a folder on your desktop, then go into that folder
and copy everything inside the folder "PDS3\WOTLK9947\TRIN4803_SD1295_ACID3_Heisei111" to "C:\Trinity"

Step3
Create a folder called "data" in Trinity so that you have C:\Trinity\data

Step4
Go into the map extractor tools folder and take Ad.exe and place it in your Main WoW Folder.
Example C:\Program Files (x86)\World of Warcraft or C:\Program Files\World of Warcraft.
Once you run Ad.exe you will get 2 new folders, DBC and MAPS.
Copy these two folders back into C:\Trinity\data

Step5
Go back into Map extractor tools folder in C:\Trinity and copy

vmapextract_v2.exe,
vmap_assembler.exe,
splitConfig.txt,
makevmaps_simple.bat,
make vmaps.bat

into C:\Program Files (x86)\World of Warcraft\Data\enUS or C:\Program Files\World of Warcraft\Data\enUS.
Now run makevmaps_simple.bat and let that run until it is finished which will take some time.
Don't close it too early because it extracts the buildings first.. then makes the vmaps afterward.
You will get VMAPS folder which needs to be copied back into C:\Trinity\data

Step6
While that is extracting let us now open up Navicat and create 3 new databases.
The 3 databases should be Characters, Trinity, Realmd.
Now import/restore/execute batch each of the databases that is supplied in the database folder
inside C:\Mangos\YTDB_503 to its respective counterpart inside your MySQL server.

Please note that you can import PDS_Pure_Blizz, or PDS_Custom_FUN, it's completely your choice.
If you would like to use your old Mangos 313 Character Tables, I have provided a Mangos to Trin2 Character Converter.
Special Thanks to Borgotech at PryDevServer Forums for this.


Step7
Now all that you must do is edit your config files within C:\Trinity.

First be sure to RENAME trinitycore.conf.dist and trinityrealm.conf.dist to just trinitycore.conf, trinityrealm.conf!

First open up trinityrealm.config. Find the line:

Code:

---

LoginDatabaseInfo = "127.0.0.1;3306;root;password;realmd"

---

And change your username, password, and database to match your MySQL Server setup.



Lastly go into trinitycore.config and edit these 4 important lines.

Code:

---

DataDir = "C:\trinity\data"

LoginDatabaseInfo    = "127.0.0.1;3306;root;password;realmd"
WorldDatabaseInfo    = "127.0.0.1;3306;root;password;trinity"
CharacterDatabaseInfo = "127.0.0.1;3306;root;password;characters"

---

Step8
Open up Navicat and go into your Realmd database.
Find the table realmlist and look at the data entries.

Make sure the ID is number 1.
Change the Name to whatever name you want people to see.
Change the address to your external IP example: myserver.dyndns.org
Port should be 8085

This last action is to make the server live to the world,
assuming you have Xampp properly setup and your router ports
are forwarded correctly when you run realmd.exe the program will
connect to your realmd database. If this information is set to 127.0.0.1
then you must set your realmlist.wtf file in WoW to match this.
But if your setup is myserver.dyndns.org then inside realmlist.wtf in WOW
you would use myserver.dyndns.org to connect.


Step9 -- Run TrinityCore.exe
If you did it right prepare to be one happy camper.

Anyhow once the Trinity server loads completely, now is your time to create
a username and password for server access.

If you have the trinity.exe selected you should be able to type commands. Type ? or command / help to see the available commands.

Example:

Code:

---

account create user 123456

---

Step10
Now open up your favorite SQL program and go back into the Realmd database.
Look for the table accounts. You should see under data the new account that you just created.
Find the spot that says GM level and put this at 3.
Now this account is a GM and you will have access to GM commands ingame.


Time to log in.

But before we log in, there is still Mang Admin
That folder belongs in the WOW Interface Addons folder.

Please make sure to Thank or Donate to the Respective Dev Teams for all their continued hard work because without them my repacks would not be possible.

I do not offer official support for my repacks literally: because if you know what you are doing, my repacks run flawlessly.
Though that doesn't mean I won't help, just make sure your issue has been thoroughly researched before posting here.

If you like my repack and want to ask questions related to the dbc, core, etc, or even if you want to help improve the repack;
Feel free to join my forums where PryDevServer repacks originate.

Thank You Dev Teams for All your hard work!!

For a good webpage:

I would recommend using a better looking webpage....

I myself use ReggAcc...which you can find here:

ReggAcc Downloads and Tutorials

It has nice logging, a very nice admin panel and just looks more professional.


For good database editing and adding of custom content

I would recommend you use this link to better understand the database rows and tables and what they require.

I have found this to be an indispensable tool for adding custom content.

Mangos Database Structure Wiki

Guild House Master

Guild Housing and Guild security is a patch written by some very nice people from Script Dev's forums.

The NPC can be found by searching your creature_template for "Pryds Guild" House / Master ( and guild guard )
These things should have been in the last 3.0.9 repack., along w/ tons of other features.

The Guild House NPC currently holds up to about 20 guild houses.

Here's how it works.

The first person to buy a guild house has a ton of choices, once 1 guild buy a guild house that choice is taken off the list
or reserved for only that guild. The houses are varied from GM island to hidden places around Azeroth.

The guild houses cost 100k gold., and only the guild master can buy or sell it.
The feature is to support guild houses that can then be customized, ( by GMs ) for rewards / donations etc.
In the end though it's only as good as you the Owner of the Server intend to make it.

i ave an error.
when i click on mangos.exe or on realmd.exe, it doesn't even start , what's the cause ?

Do you have Microsoft .net 3.5 installed?

What OS are you using?

Added link to 64 bit Manogs Core!!!!

Updated to latest release.

Can I do it all in folder D:\Mangos\ ?

You mean put the entire server there?

Well yes..I guess...why not?

Added link to newest release....

Rev 20.

thank for nice guide :D
can help me to setup server easy.

I got everything setup and it all connects. I run the client and I can log in but when I select the realm it tries to connect to the game server for a couple of seconds then bumps me back to the "select realm" screen.

I'm running Vista Premium 32bit (yes I'm using the 32 bit mangos core).

Quote:

---

Originally Posted by Sadyn

I got everything setup and it all connects. I run the client and I can log in but when I select the realm it tries to connect to the game server for a couple of seconds then bumps me back to the "select realm" screen.

I'm running Vista Premium 32bit (yes I'm using the 32 bit mangos core).

---

In the realmd database did you setup the realmlist table with your IP and server name?

Updated downloads with newest release.

Containing over 50 vendors!

Quote:

---

Originally Posted by Monolith

In the realmd database did you setup the realmlist table with your IP and server name?

---

I'm just connecting on my local computer so i changed the name but left the ip as 127.0.0.1 all the configs are the same.

* Edit: The link to rev.21 isn't working. *

Quote:

---

The key you provided for file download was invalid. This is usually caused because the file is no longer stored on Mediafire. This occurs when the file is removed by the originating user or Mediafire.

---

** Edit: Got it working...my data folder didn't extract properly...a re-extraction fixed it **

I didn't say it before so I'm saying it now. Great job Monolith, this is an excellent repack.

Thank You

Quote:

---

Originally Posted by Sadyn

I didn't say it before so I'm saying it now. Great job Monolith, this is an excellent repack.

Thank You

---

Not mine...just releasing to the RZ public what I found and use on my server....

All credits go to PryDev.....

I agree though...it is the best repack I've found to date.

So you did get it working though?


Edit:

Added Rev. 22 download site...some bugs fixed.

Quote:

---

Originally Posted by Monolith

Not mine...just releasing to the RZ public what I found and use on my server....

All credits go to PryDev.....

I agree though...it is the best repack I've found to date.

So you did get it working though?


Edit:

Added Rev. 22 download site...some bugs fixed.

---

Yeah, got mine working.

Hi friends ,

When I create new character , my inventory has full items Epic . Would you show me why so ? where does them come from ( event , setting in mongos server , script ....)

Thanks all for support
:thumbup1::thumbup1::thumbup1::thumbup1::thumbup1:

There are 2 SQL dumps included....

One is Blizz like where you start with no items and one is Fun Server...where you start with a bag full of items....

Use the Blizz like SQL dump if you want a regular server....

Thanks Monolith for soon respond ,
BTW , Have you got any document about events in wow mangos , how they work ? Have you got a simple examples for events ?

:thumbup1::thumbup1::thumbup1::thumbup1::thumbup1:

Nice, maby this files works

Quote:

---

Originally Posted by pqthanh80

Thanks Monolith for soon respond ,
BTW , Have you got any document about events in wow mangos , how they work ? Have you got a simple examples for events ?

:thumbup1::thumbup1::thumbup1::thumbup1::thumbup1:

---

Events are handled by the database...you can set frequency and all options...

hi...
nice tut...
server set perfectly but when I try to log in into the game
I can log in successfully
but it cannot enter the realm.....

any solution ???

EDIT:

Working... just changing setting.

This is an excellent repack Thank You

Updated original post with newest release....

thx for tutorial.

hey just encountered a problem i hope you can help with, getting this

009-03-31 17:57:05 >> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue.

DB imported was the blizzlike, i went and imported again to be sure - still no joy

i'm so fried out from spending all day setting this up i have no friggin clue where to go anymore lol - other that that its been plain sailing - great guide!

Try this....execute this sql file into your mangos db and see if it fixes it....

change the extension to .sql and use it...

Which revision did you use?
What database manager are you using?
Did you have no errors during executing entire mangos db? I know it takes forever....

Let me know if this fixes your problem.

Quote:

---

Originally Posted by Monolith

Try this....execute this sql file into your mangos db and see if it fixes it....

change the extension to .sql and use it...

Which revision did you use?
What database manager are you using?
Did you have no errors during executing entire mangos db? I know it takes forever....

Let me know if this fixes your problem.

---

yup that did it, using navicat and nope no errors previously, thnk i might of just had a slightly corrupt download of rev23. cheers muchly!

Well..navicat is not really good for big sql imports...best to use sqlyog...

probably missed that table along the way or something...

Dear Monolith,
could you please show us a process for update from old repack to new repack ?
That mean we'll replace all new files by old file and restore all new database ?
Because I use repack 15 , 18 , 20..... now 23 .

Thanks all for support
:thumbup::thumbup::thumbup::thumbup::thumbup:

Updated the original post with the newest release....





Best way to update using these repacks is to copy your mangos and realmd executables somewhere safe.

Overwrite your old executables with the new ones and run it.

If all works fine then there were only changes in the mangos source code...

If database errors were thrown at you...then you have to do some fixing....

The easiest way I have found to do this is to execute the new database under another name...such as update or something...

Then you can simply dump whatever sql you need to a .sql and execute it on the original mangos using the update command.

EX: You copy over the new core and it says..."Missing row respawn_time in creatures table."

In the test database...dump creatures table to a .sql...then use the update command in it...

Execute it on your original mangos and it should update the tables with the new rows....keeping your existing information intact...

Just make sure you remove any commands in the .sql dump such as DROP table...ect ect...


I only use this method because I have ALOT of custom content added into my database....

If you really have a baseline server...the easiest way is to simply backup the player info and install the new database completely....then update the player info into the new database....

my mangosd.exe is giving me this error :
2009-04-02 15:45:51 ERROR:Check existing of map file './maps/0004331.map': not exist!
2009-04-02 15:45:51 ERROR:Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.


my vmap files are in C:/appserv/mangos/data/vmaps


and another thing when i try to connect it only gives me "loging in to game server"

Did you extract your maps?

Did you let it completely extract?

First mistake I have seen people make is they do not let the program completely extract the vmaps....

It will look like it's done...but it's rebuilding the maps.....

Make sure your mangos.conf is pointing to the correct file that you have your maps in....

Make sure you use the map extractor included with the server files...

If you are trying to use your own from a previous version they will not work....things have been altered...

tnx for the info i`ll try :P and i think this is why i cant get in the server....


EDIT:
OOOKKKK i got everything but now i have problems with the db no creatures when create hero and log the hero dissapears can`t find a good db :S help

Which db did you use?

There are 2 different db's made by 2 different developers included...

YTDB and PSDB....

I know for a fact that at least 100+ people have installed this with no such problems...

Being you had the problem with the previous tables....I am thinking alot of your tables did not create correctly...

Download sqlyog and re-execute the db. Navicat does not work correctly on database backup these size.

tnx i have sqlog and i`ll try P.S.
I have used Mangos 7606 3.0.9 + Sdev 978

EDIT:
NOPE still don`t have NPC ;ITEMS;GAME OBJECTS
and the mangos queries are only 671 witch is strange :|

I am at wits end then.....

You can try and say your problem where I got the repack from....the person whom actually compiles the releases and puts it all in one package is on there frequently...

Go here to make a post explaining your problem...

each repack has some changes they relate each other , so we have to update every patches by order , right ?
That mean if I want to use repack 24 and my version is 18 , so I must update step by step repack 19, 20, 21,..24 ?

Thanks & see you soon
Anyway , have you got any chat contact : yahoo message , ICQ , Skype ....
:thumbup1::thumbup1::thumbup1::thumbup1::thumbup1:

Actually each download is the complete working server repack. No updates needed....

Being that was becoming confusing I removed the old downloads and will only keep 2 present....being the new one...and the previous version in case new one contains issues.

I'm not big on the chat scene...you could always pm me here if you have further questions.

Yeah monolith Do you have Any query/script to implent custom npc teleporter?? Thanks alot

I have been working on that myself....for a clean non quest using npc you have to add it to a scriptdev2 core and compile it....for a kind of sloppy quest npc you can simply make quests for each teleport location...and then add them to an npc....I did that on my server.

Yeah I wanna use the non quest npc scriptdev2 way... But I still don't understand the proceding way -.- on some website I saw about a script/scriptdev2 folder in the files but there is none in mine. I can handle C+/C++/C# So it won't be a problem Thanks for the info once again

ScriptDev2 is actually a independently C++ coded project, not affiliated with Mangos source.

They have their own SVN you have to checkout and compile with the source....there are patches to add the clean NPC..I am learning it slowly...haven't had much time lately with my own server and life in general.

WTF, everytime i post a question, i end up finding the answer elsewhere five minutes later.

Yet again. Thanks for a great repack !

I have a simple event like that gamer kill 100 mods and then come back to NPC A to get a gift box. After gamer got a gift in inventory , he right click on gift box and get a ramdom items .
Could we together discuss and step by step build this event .?

Thanks all for support

How did u create forums on your website and can u post a link for the addon pls (Monolith)

They are just phpbb forums you can download here.

Then I added the theme from here.

Simple installation. There are tutorials on the webpage.

After setup server work , I realize my mods are so cruel ( red names ) and attack gamer from long distance . Could you help me this issues ?

Anyway , my question relate to event , no body feel interesting with that one ????

Thanks all for support

Very nice guide, i now have both realms set up :)


about scripting on Mangos - how would i go about doing it?

i am looking to script NPC's, Monsters and possibly Items.

is it done in MySQL through NPC, Monster and Item tables? :S
or what coding does it use and how do i 'install' the scripts?

Quote:

---

Originally Posted by pqthanh80

After setup server work , I realize my mods are so cruel ( red names ) and attack gamer from long distance . Could you help me this issues ?

Anyway , my question relate to event , no body feel interesting with that one ????

Thanks all for support

---

In mangos.conf you want to set the Aggro Distance to a percentage of what it is....

If it's 100% then set it to 75%

Quote:

---

Originally Posted by FPXS

Very nice guide, i now have both realms set up :)





about scripting on Mangos - how would i go about doing it?



i am looking to script NPC's, Monsters and possibly Items.



is it done in MySQL through NPC, Monster and Item tables? :S

or what coding does it use and how do i 'install' the scripts?

---

Scripting is a little beyond me as of right now...I just rely on what scriptdev has done aready....

But a VERY good resource for editing the databases is located here. It explains what every rown in ewach table means and what to put there....


Updated first post with newest release.

Newest release changelog.

Latest Release is PryDevServer Revision 26:

Core:
Mangos Core updated from 7614 to 7642.

Databases:
Both YTDB Fun Server and Blizz have been updated from Revision 145 to 146 aka 482_FIX_(7635).
PSDB has been updated from 171 to 173.
UDB has been added to the database folder rev 370.

YTDB Fun Server Specific Updates:
Class trainers / Haircut spot have been added across from the profession zone.
Glyph Vendors have been added into the profession zone of the mall.
NPC Teleporters Now Exist in game. See below for details.
Portal to Death's Breach / Ebon Hold was replaced by my Teleporter Gryphon Fix.

YTDB Fun / Blizz / PSDB Blizz
All databases now have Pryds NPC Teleporters
Five in Total were added from my repack 25 to 26.

NPC Teleporters
Matrix Northrend - Tele to WOTLK Northrend Zones
Northrend Dungeons - Tele to WOTLK Dungeons
Northrend Raids - Tele to WOTLK Raids
Scourge GryphonX - teleport helper to get to Ebon Hold
Scourge GryhponY - teleport helper to get to Death's Breach

UDB Blizz additions
Scourge Gryphon X - teleport helper to get to Ebon Hold first floor, second floor and Death's Breach.


Previous Patches Included but not limited to:
YTDB Fun Server Specific
Professions
Achievements
Custom Mounts
Map Phasing check
Custom lvl 80 Stats
Custom Weapons & Gear
All hunters able to tame pets
All BGS & Arena Que's Work
Hunter & Warlock Pet spells work
All warlocks able to summon pets
Pyramid Maze with Treasure Chests in GmIsland
WOTLK Instances Scripted with Bosses & Creatures
Death Knight Starting Quest Fully Completable with talents
Class spells added for new toons such as all stances for Warriors, All shapeshift for druids
All players have items added upon login such as gear weapons meant for level 70 starting Fun Servers.

Extras:
Pryd's Mall and Skyway to Heaven. .Tele PrydsMAll
Skyway to Heaven added in repack 25+.
Run directly out of the Fun Server Mall.
Keep running straight and you'll see it.

New Toon Leveling Road From Level 70 to Level 80
To get there .Tele LevelingRoad or .Tele LevelRoad

Misc:
Some quest fixes from these forums also added to the YTDB Fun Server / Blizz databases.
If using YTDB Blizz, PSDB Blizz, UDB Blizz do plan on spawning vendors, portals, teleport helpers, game objects etc as needed.
Blizz databases are straight from the developers with little or no fixes added. Though I often will throw in a vendor / teleport helper / etc.
If you plan on using the bliz databases, do plan on spawning vendors, portals, creatures, npcs, etc.

I have added the wiki link for mangos database structure to the tutorial. I would recommened ANYONE whom attempts to add anything to their server read up on the information supplied there.

Go here to see where I added it.

makevmaps_simple.bat, in step 5 will not work comes up with Problem Event Name: APPCRASH
Application Name: vmapextract_v2.exe

was wandering if i can use the make vmaps.bat not simple version


EDIT: Nevermind my realmlist was not right had to change it back to wow normal one:thumbup1:

mmm repack 26 link broke

i have MySQL but it gives me error 0 when i hit execute but i want to play offline just me was wandering how to do that if i can my internet is super slow

hi i cant put the addons i dont know put all in the /enus/inteface/addon/bue in the game not show nothing -.-
plese need help whit this or a tip

ok i got over the error 0 im completely done i made a account but when i try and login it just says cant connect need help im useing my computer as the server and for me to play at the same time its just me no one else is on my realm was wandering if that the problem

ahh, worked out my problems. no worries.
thanks for the repack!

Rev26 [ x64 /x32 ] w/ Warlock Patch Fix @ over 50+ Vendors! link is broken... please give another one ^^

Quote:

---

Originally Posted by XManiaK

Rev26 [ x64 /x32 ] w/ Warlock Patch Fix @ over 50+ Vendors! link is broken... please give another one ^^

---

Fixed. Darn 10 character limit.

Updated first post with newest release.

Newest release comes with a PVP server with Horde/Ally starting areas included!

Changelog:

Latest Release is PryDevServer Revision 27:

Core:
Mangos Core updated from 7642 to 7665.

Databases:
Both YTDB Fun Server and Blizz are at Revision 146 aka 482_FIX_(7635).
*New* Instant Level 80 PVP Database added this repack!
PSDB has been updated from 173 to 178.
UDB is still at revision 370.
ScriptDev2 is now revision 1003

Updates
PVP Server ready to rock with Ally / Horde specific starting bases.
Some bugs fixed with quests on YTDB Fun Server
Misc items added to Vendors in the Mall.
Look for new items on the Legendary vendors
Shield, Ring, Scroll Vendors had a significant update.
Now possible to use high enchant scrolls like mongoose without becoming an enchanter.

I have a slight problem. Everytime I try to run the server i keep getting this error. Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@localhost' <using password: YES> but I can get into my database just fine with anything else. I have left my password section blank when i set up my connection for mysql and navicat.

Are you connecting from the same computer or is the db on a different computer?

Double check to make sure there are no typo's whatsoever in the realmd.conf,mangos.conf, and scriptdev2.conf, where it asks for passwords.

Hi! Thanks for the wonderful release! I'd be grateful if you could help me with some problems.

In the realmlist column, the Field ID is blank at default. If I try to set it to "1" as mentioned in the process on the first page, it returms an error "Invalid default value for ID"

That being said, when I try to run mangosd.exe from 32 bit core folder, it just opens a dos prompt in a flash and closes it immediately, and nothing else happens.

OS is Windows XP 32 bit. I will be running the server and client both from the same computer.

Thanks in advance for any help,
Sonnu.

Everything runs on one computer here database and all. i have checked 4 typos and found none

nvm fixed it lol

Quote:

---

Originally Posted by X_Marcus_X

Hi! Thanks for the wonderful release! I'd be grateful if you could help me with some problems.

In the realmlist column, the Field ID is blank at default. If I try to set it to "1" as mentioned in the process on the first page, it returms an error "Invalid default value for ID"

That being said, when I try to run mangosd.exe from 32 bit core folder, it just opens a dos prompt in a flash and closes it immediately, and nothing else happens.

OS is Windows XP 32 bit. I will be running the server and client both from the same computer.

Thanks in advance for any help,
Sonnu.

---

Downloadand install Microsoft .Net files...

Should fix the problem....

Asfor the database issue...if you used Navicat to backup extract your db...it's probably a problem with that...use SQLYog...

Thanks for the suggestion! I found out what the thing was. I ran the mangosd executable from command prompt and found that it reported missing config files. Looks like the config files have to be in the core folder too for it to work. Now it loads up perfectly. Still haven't checked with the other steps, so will update on the situation.

And SQLyog refuses to let me alter the ID column with that error. By default the ID field is blank. I hope it's not a big deal? Or is it absolutely necessary? Also, do we have to have SQLyog and Xampp control panel running simultaneously while the server runs? I ask because while processing, near the end mangos reported that it was not connected to MySQL and scriptdev2 database did not exist. It loaded everything else just fine.

Can you please let me know where we are to discuss the config file options?

Oh and I am using release 25...should I overwrite the mangos folder with release 26? I hope I don't have to reimport the database...it took about 26 hours to do that even with SQLyog (my PC is a bit low end)

I believe revisions 26 and 27 were mostly database fixes.....

Yes the config files have to be in the same folder with the executables....

No SQLYog does not have to be running....but XAMMP does if you do not have MySQL and Apache installed as a service...if you do then no..it doesn't have to be.

As for the ID field problem....thats a new one me..I'll do some research on that issue.

Hi Minolith! How's it going?

I finally got eveything to work! Well except that Realm ID thing. For now the Mangos Blizz realm is working without any problems so far. But I still want to know how that SQLyog problem can be solved, because I want to be able to fix anything related to items or borken quests.

Cheers,
Sonnu.

Congratulations to Monolith and PryDev
^^

Thanks for all the hard work is there a fix for Death knight talent points.

hello . i have a question doese anyone knows whats rong at these ... when i enter the 32 bites core. i start mangosd ore realmd it says to me : "these applicatione has failed to start because the aplication configuration is incorect " wtf ?

Monolith I'm using Hamachi... for other people to connect I just have to put my hamachi ip in database realmlist and other people put it in realmlist.wtf? don't I have to change anything on mangos.conf, realmd.conf and scriptdev2.conf ??

I don't know what I did now but I can't do anything on database! I try to do something and it just says

1045- Acess denied for user 'root'@'localhost' (using password: NO)

I need serious help now :S

PS: I'm using Navicat 8 to MySql


EDIT: The connection only has information_schema, when I try to create a database it gives me that error!

EDIT2: I solved the problem... but I still need to know how to make hamachi work for my server :S

Quote:

---

Originally Posted by ZeroV

Thanks for all the hard work is there a fix for Death knight talent points.

---

They are still working on a "good" WoTLK db....I will be updating with them as soon as they are released...

Quote:

---

Originally Posted by arhicon

hello . i have a question doese anyone knows whats rong at these ... when i enter the 32 bites core. i start mangosd ore realmd it says to me : "these applicatione has failed to start because the aplication configuration is incorect " wtf ?

---

Do you have microsoft .net framework?

Quote:

---

Originally Posted by XManiaK

Monolith I'm using Hamachi... for other people to connect I just have to put my hamachi ip in database realmlist and other people put it in realmlist.wtf? don't I have to change anything on mangos.conf, realmd.conf and scriptdev2.conf ??

---

I have never used hamachi...cannot help you there...

oke. thanks the problem is solved . i was needing net framework 3.5 ... thanks again. But now i have a new problem .. i have a desktop pc . and i shared internet from my desktop pc to a notebock . so i have only a real ip. and i instaled the database and all on the notebock .. and now only i can enter the server. : ( anyone knows what can i do so ppl word wide can enter my server ?

thanks Monolith net farmework 3.5 solved the problem. But now i have a new problem.. i instaled the database and all on my notebock . and i only have internet in my desktop pc. so i shared internet from my desktop pc to my notebock so i cand open the server the problem is that now can enter my server . only i in my lan connect desktop pc and notebock. but i want to make my noteboke a dedicated server. and ppl word wide could enter. anyone knows how can i do these ?

thanks Monolith

Quote:

---

Originally Posted by arhicon

thanks Monolith net farmework 3.5 solved the problem. But now i have a new problem.. i instaled the database and all on my notebock . and i only have internet in my desktop pc. so i shared internet from my desktop pc to my notebock so i cand open the server the problem is that now can enter my server . only i in my lan connect desktop pc and notebock. but i want to make my noteboke a dedicated server. and ppl word wide could enter. anyone knows how can i do these ?

---

In the config files make sure you Bind IP To: your WAN.

Make sure in the realmd database under realmlist you enter the WAN IP.

Should fix your problem...also make sure you have either ports forwarded or the server in DMZ if you are using a router.

Updated First post with newest release....

Changelog:

Latest Release is PryDevServer Revision 28:

Core:
Mangos x64 Core updated from 7665 to 7673.
Mangos x32 Core updated from 7665 to 7677.

Databases:
All YTDB databases are at Revision 146 aka 482_FIX_(7635).
ScriptDev2 is now revision 1009
ACID is now 009 revision 28

Updates
x64 Core Has had Major Improvements:
Most notably working Alterac Valley
Different Warlock Pet Fix
Blink Patch, Death Grip,
Mutilate among many other patches only for x64.

PS- I wasn't able to get these patches into the 32 bit core

But to make my server public I just have to put my ip in realmd database?

what about mangos.conf, realmd.conf and scriptdev2.conf ?? don't I have to change 127.0.0.1 to my ip in there?

forget himatchi and get a dns..it doesnt cost anything and its worry free.

Quote:

---

Originally Posted by XManiaK

But to make my server public I just have to put my ip in realmd database?

what about mangos.conf, realmd.conf and scriptdev2.conf ?? don't I have to change 127.0.0.1 to my ip in there?

---

No those are simply for the program to conversate with the database...no need to go outside your lan smply to come back....

Keeps those 127.0.0.1

But change Bind IP to your WAN.

So I changed ip on realmlist database to my hamachi ip and i changed bind ip in mangosd.conf and realmd.conf to my hamachi ip also... the rest is the same! but my friends still can't connect to my server! All my other private servers of fly for fun and wow(burning crusade) worked with this hamachi ip so i don't think the problem is with the hamachi :S

Monolith can you help? And thanks for the suport ^^

Quote:

---

Originally Posted by XManiaK

So I changed ip on realmlist database to my hamachi ip and i changed bind ip in mangosd.conf and realmd.conf to my hamachi ip also... the rest is the same! but my friends still can't connect to my server! All my other private servers of fly for fun and wow(burning crusade) worked with this hamachi ip so i don't think the problem is with the hamachi :S

Monolith can you help? And thanks for the suport ^^

---

Are you behind a router?

Yes I know what you are going to say... I have to do portforwarding... but with Hamachi I don't need that! I just have to use hamachi ip and always worked... I don't understand what's wrong now :S

Hello. my server works nice. i have the fun database. but one more thing Monolith if you can help me please and say where i must configure that all the players who enter the to get instant level 80 .. thank you anticipated ! and good job :D

EDIT : I figred it out*

If Anyone needs help in finding stuff to fix quests in database, let me know...

Cheers!

My friends still can't connect via Hamachi :S

I have a router...

Any help?

Which DB are the "50 Vendors" located? are they only in ytdb_fun.sql ? and if so what are teh IDs or are they already spawned?

Quote:

---

Originally Posted by arhicon

Hello. my server works nice. i have the fun database. but one more thing Monolith if you can help me please and say where i must configure that all the players who enter the to get instant level 80 .. thank you anticipated ! and good job :D

---

In mangos.conf you'll find a listing for Players Starting Level....

Quote:

---

Originally Posted by XManiaK

My friends still can't connect via Hamachi :S

I have a router...

Any help?

---

Sorry..I don't have a clue about hamachi....I've never used it...my server runs without it..

Quote:

---

Originally Posted by Denv0r

Which DB are the "50 Vendors" located? are they only in ytdb_fun.sql ? and if so what are teh IDs or are they already spawned?

---

I have found them in all db's in this repack...the id's start at 555120 or so...they are all named Pry's Dev

NVM I solved the problem! Already works ^^ My friends can connect!

Thanks for everything Monolith ;)

Quote:

---

Originally Posted by XManiaK

NVM I solved the problem! Already works ^^ My friends can connect!

Thanks for everything Monolith ;)

---

No problem...even though I really didn't help much which I apologize for...

I have never used hamachi...never understood the need for it...

Why not simply port foward...use no-ip.com and host it normally...seems like it would be more efficient and easier to me.

It Wont Let Me Start MySql As a Service

Quote:

---

Originally Posted by Monolith

No problem...even though I really didn't help much which I apologize for...

I have never used hamachi...never understood the need for it...

Why not simply port foward...use no-ip.com and host it normally...seems like it would be more efficient and easier to me.

---

Nah I always used Hamachi... and my servers are only for me and like 3 or 4 more friends, so Hamachi it's ok no need to portforward xD

Keep up your good work Monolith! You and PryDev!! :wink: I'm waitting for repack 29 :laugh::laugh:

Not the right place for your post.......take it to your own thread....this is for a tutorial for the repack..thats all.

Quote:

---

Originally Posted by RockStar157

It Wont Let Me Start MySql As a Service

---

Make sure another instance of MySQL is not already running...

Quote:

---

Originally Posted by XManiaK

Nah I always used Hamachi... and my servers are only for me and like 3 or 4 more friends, so Hamachi it's ok no need to portforward xD

Keep up your good work Monolith! You and PryDev!! :wink: I'm waitting for repack 29 :laugh::laugh:

---

I can't wait either...I was reading on the forums he found another webpage of a whole complete new set of people adding fixes to mangos core and listed like 20+ fixes to be added to the next repack....it's going to be awesome!!!

That's awesome =D

I found a bug, on DeathKnight, I can't use the skill that summons a ghoul. But the rest seems working great and bugless xD

Hello

First - Thank You for great tutorial Monolith.

Now my problem :

I have mangosd.conf and realmd.conf with edited BindIP
BindIP = "XXXXX.dyndns.org" (where XXXXX is my DynDns name).
I change realmd database (SQLyog as a tool) in address cell to my XXXXX.dyndns.org
address.

All needed ports are setup correctly on my router.
(necessary ports : 8085,3724
optional ports : 6**** 6881to69*** 3306, 3443, 8129, 8093, 3036, 8050, 3727)

MiniManager for XAMPP works perfectly (locally and from Internet).

Server works grate via Internet - no problem here - but - I can't log-in
to server from my local network.

Each time when I pass login screen, WoW shows Realm Selection windows list
(I can see there are 2 characters for this account) - I press Okay button and client
try to connect to realm, then I have message "Logging to game server" and I get
back to Realm Selection window.

After reading forum for the past 2 days (with little breaks for coffee)
I get general idea it is a problem with logging to realm - so I change
realmd.conf and mangosd.conf for many different IP settings but no success.

I can log in to the realm from my LAN only when I put my local server IP
in to the realmd database, of course I can't log from internet this way.

My question is - do You Have any idea what values and where to put them
to achieve working server for WAN (Internet connection Users) an LAN
(my desktop computer) as well ???

Maybe I should edit hosts file either on the server or client machine ?

One more note : Server Machine for WOW and My Desktop Computer are
to different physical computers.

Looking forward for any helpful information.

Quote:

---

Originally Posted by XManiaK

That's awesome =D

I found a bug, on DeathKnight, I can't use the skill that summons a ghoul. But the rest seems working great and bugless xD

---

Yea...mangos and database teams are stilll working on DK's spawn skills....takes time....

Quote:

---

Originally Posted by leotoro

Hello

First - Thank You for great tutorial Monolith.

Now my problem :

I have mangosd.conf and realmd.conf with edited BindIP
BindIP = "XXXXX.dyndns.org" (where XXXXX is my DynDns name).
I change realmd database (SQLyog as a tool) in address cell to my XXXXX.dyndns.org
address.

All needed ports are setup correctly on my router.
(necessary ports : 8085,3724
optional ports : 6**** 6881to69*** 3306, 3443, 8129, 8093, 3036, 8050, 3727)

MiniManager for XAMPP works perfectly (locally and from Internet).

Server works grate via Internet - no problem here - but - I can't log-in
to server from my local network.

Each time when I pass login screen, WoW shows Realm Selection windows list
(I can see there are 2 characters for this account) - I press Okay button and client
try to connect to realm, then I have message "Logging to game server" and I get
back to Realm Selection window.

After reading forum for the past 2 days (with little breaks for coffee)
I get general idea it is a problem with logging to realm - so I change
realmd.conf and mangosd.conf for many different IP settings but no success.

I can log in to the realm from my LAN only when I put my local server IP
in to the realmd database, of course I can't log from internet this way.

My question is - do You Have any idea what values and where to put them
to achieve working server for WAN (Internet connection Users) an LAN
(my desktop computer) as well ???

Maybe I should edit hosts file either on the server or client machine ?

One more note : Server Machine for WOW and My Desktop Computer are
to different physical computers.

Looking forward for any helpful information.

---

Try setting BIND IP"" to your WAN instead of your DNS....

As in 76.56.47.255 instead of XXXXX.dyndns.org


Revision 29 is here!!!

Changelog:

Latest Release is PryDevServer Revision 29:

Core:
Mangos x64 Core updated from 7665 to 7673.
Mangos x32 Core updated from 7665 to 7677.

Databases:
All YTDB databases have been updated to Revision 147 aka 483_FIX_(7667).
ScriptDev2 is now revision 1012
ACID is now 009 revision 28

Updates
YTDB was updated from 146 to 147 which solves some load errors.
x64 / x32 Core Has had Major Improvements:
Most notably working Alterac Valley
Different Warlock Pet Fix
Blink Patch, Death Grip, DK Gryphon Flight Fix
Mutilate among many other patches

Make sure if you want Blink working to enable LOS for VMAPs / and POS detection.


Rememeber none of this work is mine.

I am simply passing on the awesome repack I myself use.

And:

If you don't like the pumpkins, xmas trees or any other game object that is in the bliz world database.

Simply run this line of code, which should take out the holiday gameobjects

Code:

---

DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 187235;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 180798;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 180796;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 180797;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 180407;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 180406;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 180415;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 181390;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 180411;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 181355;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 180405;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 181401;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 181393;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 181401;
DELETE FROM `mangos`.`gameobject` WHERE `gameobject`.`id` = 180398;

---

This fix was submitted by jimakira:

Thanks
Pry

Thank You for answer.

For me working solution for my problem was here :
http://forum.ragezone.com/f114/mango...server-271443/

One more thing :
I change line
BindIP = "0.0.0.0"
to
# BindIP = "0.0.0.0"
(character [ # ] for those who don't see difference in the string line)
in the mangosd.conf and realmd.conf.


BTW - One more question
Can You implement Auction House Boot to the release ?
or
Can You made tutorial how to do it ?

Much appreciated.