Thread: {Epic}Make TrinityCore2 Server ALL DETAILS INCLUDED

CREDITS: heldragoniv

Hello.Yes I'm new and I've spelled helldragoniv incorrect xD but I want to help the community with what I can.So here's my first tut hope there will be more too come.
I wanted to make them user friendly and also funny if you are bored xD.

I request STICKY!I will update it after I'm back!

DO NOT FLAME ME IF I DID A MISTAKE.POST IT HERE BECAUSE I'M TIRED.BTW I'M OFF FOR ONE WEEK.
INTRODUCTION of the core,the database and the rest.

Well TrinityCore2 has it's bases on the first one,one of the best cores for any server(Oh and there is also TrinityZero which has support for Original WoW).It has advantages and disadvantages like any other cores.It has the best built-in scripts you've seen.Yes they're working on Ulduar but most are scripted.It won't support your LUA codes but C++ is always better so don't be sorry for it.The core grown as a leaf from a growing tree:MANGOS.Some guys who didn't like alll ideas from MANGOS went out of developer team and formed their stronger and better core.Anyways everybody has it's opinion.Yes you won't use GIT to download some things but Trinity is more user friendly.BUT you can use most of the MANGOS scripts so that's good.I'm not going to tell you how to modify them but that is not even needed.As I said it has built-in scripts,and not buggy ones.At the moment the thing that would interest you will be DUAL-Talent specialization.Yeah that's not scripted well but in a good day it will be fixed.Now let's get back to the subject.
TrinityCore started out with a usual database made by their own dev team(TrinityDev) called TDB.They expanded their DB until they've seen that it is better to change some things so they picked up UDB(Unified Data Base).UDB is for Mangos but with it's converter you will have it for Trinity and it will give 110% of what it can.The DB is updated frequently so you don't have to worry about upcoming bugs.They have most of things working.And if not then here comes the other DB.YTDB is a russian database(Don't be sorry it's in english) that is out for some time.Yes it hasnt got yet a converter but you can try using the TDB one and with succes you should merge the great things from both DB and form the ultimate database for your server.Try to get the quests,items,loots and spawns from YTDB.This is it now the official thread begins.

ALL PROGRAMS NEEDEDBONUSES not here)

NET Framework 3.5 SP1 : [Only registered and activated users can see links. ]

MICROSOFT Visual C++ 2008 Express Edition : [Only registered and activated users can see links. ]

SQLyog : [Only registered and activated users can see links. ]

MySQL Community Edition-Zipped version : [Only registered and activated users can see links. ]

TortoiseSVN : [Only registered and activated users can see links. ]
-----------------------------------------------------------------------

I.The beginning of the universe-THE CORE

1.Getting the core
2.Compiling the core.
3.Extra scripts.
4.Some extra scripts for you to use.
5.MAPS,DBC,VMAPS Extraction and setting it up.

II.The worlds collide-THE MYSQL
1.Downloading

III.Human are being borned-THE DATABASE
-THE CHOICE OF A DB-
1.Setting up the database.
2.Some extra info.
3.ACID scripts(ScriptDEV2 for TrinityCore2)
4.Hensei scripts(All scripted)

IV.The end is NEAR-THE CONFIGURATIONS
1.Setting up base config files.
2.Making your server public with NO HAMACHI+Renaming your realm
3.Changing server informations about DBs.

V.Pretty girl,huh ?-SETTING UP FAST SERVER STARTUP AND OTHERS.
1.Using an Server starter with shortcut for lazy guys(like me ) and girls
2.Setting up your own WEBSITE.Teh ownage xD
3.Setting up your own ARMORY.
4.ADs and server publicity/VOTE Tops.


This week's episode of What's a server has starring Helldragoniv xD.
And now the show begins.Hello dear ppl.Let's begin creation of a WoW server.Oooh,shiny!
Parapaparam...........:

I.The core
1.Getting the core.
After you downloaded and installed succesfully all the programs listed above begin compiling the core.

Go to the drive you want and make a new folder called TrinityCore2 and inside that folder make another one named Data.
Right click the folder TrinityCore2 then select TortoiseHG->Clone a repository.Fill Source Path with this one [Only registered and activated users can see links. ] and destination path X:/TrinityCore2/Core where X is letter for your drive.Uncheck the box named USE UNCOMPRESSED TRANSFER and check the box USE PULL PROTOCOL TO COPY METADATA and also be sure that CLONE ALL Revisions is checked.Now just click clone and wait untill all the files are downloaded.

2.Compiling the core
Now that you have the latest source downloaded we're going to compile the core.Like .DLL to .EXE.It's just an example.Now start.
Open Visual C++ 2008 Express Edition
Press FILE,OPEN then Project/Solution then go to Core folder then WIN folder and select TrinityCore&Script VC90.sln
Press BUILD then CONFIGURATION MANAGER and change DEBUG to RELEASE and press CLOSE.Now press F7 and start building your core.
It should finish like this
========== Build: 11 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

When it's ready go to TrinityCore2/Core/bin/Win32_Release,copy all the things inside it and paste them to TrinityCore2 folder.
3.Adding scripts

METHOD 1.To add new scripts for your server download a cpp then open again TrinityCore&Script VC90.sln and let's say you download a creature script for ulduar.Example razorscale,if it is a text then save it as .cpp file and then go to TrinityScript->Zone->Northrend->Dungeon->Ulduar->Ulduar then right click it Add->Existing Item then you should add boss_razorscale.cpp
This is for one script.You should be figuring out other things,it's just not that hard.

METHOD 2.To add new scripts for your server go to CHAPTER 3 to part 3 and 4.


4.Some recommended scripts
before this remember that there could be scripts for other emus to be modified

Get from here most of the scripts this is specially for trinitycore so you don't have to modify nothing)

[Only registered and activated users can see links. ]
including ah bot and whatever,rename them to cpp and do the same thing from step 3.

[Only registered and activated users can see links. ]
Creds QQROFL

[Only registered and activated users can see links. ]
Creds tekkeryole

[Only registered and activated users can see links. ]
Creds QQROFL+Sdyess94

[Only registered and activated users can see links. ]
Creds tekkeryole

[Only registered and activated users can see links. ]
Creds spasm

[Only registered and activated users can see links. ]
Creds tekkeryole

[Only registered and activated users can see links. ]
Creds lollardo


[Only registered and activated users can see links. ]
Creds Zellcorp


[Only registered and activated users can see links. ]
Creds Alvanaar

[Only registered and activated users can see links. ]
Creds Benny93


[Only registered and activated users can see links. ]
Creds mattias9410

[Only registered and activated users can see links. ]
Creds Plexx

[Only registered and activated users can see links. ]
Creds Alvanaar

[Only registered and activated users can see links. ]
Creds QQROFL

[Only registered and activated users can see links. ]
Creds Charlie9809S

Creds Gnoppy
[Only registered and activated users can see links. ]


5.MAPS,DBC,VMAPS Extraction and setting it up.

Go to TrinityCore2/Core/contrib/extractor/ad.exe and copy it into the WoW directory then let it run.It will make DBC and MAPS folders which you will copy and paste to TrinityCore2 folder(inside it).

Then go to TrinityCore2/Core/contrib/vmap_extract_assembler_bin/makevmaps_simple.bat and run it.Then copy vmaps folder and paste it to TrinityCore2(inside it)

To use VMAPS go to TrinityCore2/trinitycore.conf(it may be trinitycore.conf.dist rename it to .conf) and then go to vmap.enableLOS and change it from 0 to 1 and do the same thing for vmap.enableheight.Then save the file and exit.


II.MySQL
1.Downloading and installing
Go to [Only registered and activated users can see links. ] select Windows or Windows x64 then Windows Essentials.Press No thanks just take me to the downloads.Then select a mirror.
So run it and press custom then next then next then install.When it's ready uncheck box Register the Mysql Server now and then press finish.
Press next when a box appears->Detailed Configuration->Server Machine->Multifunctional Database->For InnoDB select any Installation Path and driver->Online Transaction Processing->Check box Add firewall exception for this port and next->Standard Character Set->Install as Windows Service and for Service Name select a random one like TrinityServer and be sure the box Launch the MySQL Server automatically is checked->Check box Modify Security Settings and write at Current root password : root then at new root password and confirm put a password that you and your developers will have to know to access your DB and also check box Enable root acess from remote machines and press execute.When it works your ready.Launch the mysql and put your password then press enter and it's ready.



III.The Database
The choice of a DB
There are 2 available DBs for TrinityCore2.
UDB and YTDB->Both are good and mixing them is even better.
BUT they are for mangos so after you'll be setting them up you'll have to run a CONVERTER from MANGOS to TRINITYCORE2.It's not hard stuff.
This time I'll choose UDB.
So first go into TrinityCore2/Core/Sql and start up your MySQL.Then open SQLyog and import create_mysql.sql,realmd.sql and character.sql.How?Well after u open SQLyog put the account and password you've selected at MySQL configuration screen and let hostname the same.Click root@localhost then Database then Import then Restore from SQL Dump and then Execute them one by one.

Now you need Tortoise SVN.Make a new folder somewhere let's name it UDB the right click it TortoiseSVN->Export then insert this at URL of repository
[Only registered and activated users can see links. ]
Now start the download.
After it is finished go here
[Only registered and activated users can see links. ]
And right click UDB_381_to_TDB_TC2_4067_Converter.sql and press Save as then save it as SQL.
Now go to UDB folder then trunk then FULL DB and extract UDB_0.11.5_Core_7681_SD2_1012.rar and then go to SQLyog Database->Import->Restore from SQL DUMP and select UDB_0.11.5_Core_7681_SD2_1012.sql from the folder you extracted.
Now go to UDB->trunk->Updates->o.11.5_additions and Restore from SQL DUMP the following files 380_corepatch_mangos_7682_to_7894.sql | 380_updatepack_mangos.sql | 381_corepatch_mangos_7895_to_8029.sql.sql | 381_updatepack_mangos.sql RIGHT IN THIS ORDER.After That DATABASE->Restore from SQL DUMP UDB_381_to_TDB_TC2_4067_Converter.sql and execute it.
After that you're OK.

2.Some extra info
Just bored so I write this.Discover the wonderful world of the DB.You can mod it how you want it's YOUR WORLD so have fun.Remember always backup your DB before you apply a patch.Oooh and if you wanna do the same thing with YTDB(conversion) then get the convertor from here : [Only registered and activated users can see links. ] Creds to DRAHY from TrinityCore.org


3.ACID Scripts(ScriptDEV2 for TrinityCore2)
Download from here [Only registered and activated users can see links. ] right click the 3.0.0_acid.sql and press Save as then execute it into your DB.This will help you have all the scripts including Ulduar.Also ACID brings you EventAI which lets you make scripts as big as C++ ones from your OWN DATABASE.No C++ involved.Get it here [Only registered and activated users can see links. ]


4.Heisei scripts(All scripts)
My favourite project for scripting.Yep it's good,these guys wanted to make the best EventAI scripting project so they eventually made it.Now it has all the scripts from blizzard(all creatures) and they're upgrading fast so better get it while it's hot.


[Only registered and activated users can see links. ]



IV.The configurations
1.Setting up base config files

So you've compiled your source,you've made your database and now it's time to setup your own configurations files.Don't worry it's very easy.I'll paste you here some base things you want to modify.


TrinityCore.conf(if it's .conf.dist rename it) :

DON'T MODIFY THESE:

RealmID = 1
DataDir = "."
LogsDir = "."
LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;trinnrealm"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;ytdb"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;trinncharacters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"


AND MODIFY THESE FOR YOUR PLEASURE


AllowTwoSide.Accounts = 0
AllowTwoSide.Interaction.Chat = 0
AllowTwoSide.Interaction.Channel = 0
AllowTwoSide.Interaction.Group = 0
AllowTwoSide.Interaction.Guild = 0
AllowTwoSide.Interaction.Auction = 0
AllowTwoSide.Interaction.Mail = 0
AllowTwoSide.WhoList = 0
AllowTwoSide.AddFriend = 0
AllowTwoSide.Trade = 0
TalentsInspecting = 1



GameType = 1
RealmZone = 1
Expansion = 2
DBC.Locale = 255
DeclinedNames = 0
StrictPlayerNames = 0
StrictCharterNames = 0
StrictPetNames = 0
MaxWhoListReturns = 49
CharactersCreatingDisabled = 0
CharactersPerAccount = 50
CharactersPerRealm = 10
HeroicCharactersPerRealm = 1
MinLevelForHeroicCharacterCreating = 55
SkipCinematics = 0
MaxPlayerLevel = 80
StartPlayerLevel = 1
StartHeroicPlayerLevel = 55
StartPlayerMoney = 0
MaxHonorPoints = 75000
StartHonorPoints = 0
MaxArenaPoints = 5000
StartArenaPoints = 0
InstantLogout = 1
DisableWaterBreath = 4
AllFlightPaths = 0
AlwaysMaxSkillForLevel = 0
ActivateWeather = 1
CastUnstuck = 1
Instance.IgnoreLevel = 0
Instance.IgnoreRaid = 0
Instance.ResetTimeHour = 4
Instance.UnloadDelay = 1800000
Quests.LowLevelHideDiff = 4
Quests.HighLevelHideDiff = 7
MaxPrimaryTradeSkill = 2
MinPetitionSigns = 9
MaxGroupXPDistance = 74
MailDeliveryDelay = 3600
SkillChance.Prospecting = 0
SkillChance.Milling = 0
OffhandCheckAtTalentsReset = 0
Event.Announce = 0
BeepAtStart = 1
Motd = "Welcome to a Trinity Core server."
Server.LoginInfo = 0



Rate.Health = 1
Rate.Mana = 1
Rate.Rage.Income = 1
Rate.Rage.Loss = 1
Rate.RunicPower.Income = 1
Rate.RunicPower.Loss = 1
Rate.Focus = 1
Rate.Loyalty = 1
Rate.Skill.Discovery = 1
Rate.Drop.Item.Poor = 15
Rate.Drop.Item.Normal = 15
Rate.Drop.Item.Uncommon = 15
Rate.Drop.Item.Rare = 15
Rate.Drop.Item.Epic = 15
Rate.Drop.Item.Legendary = 15
Rate.Drop.Item.Artifact = 15
Rate.Drop.Item.Referenced = 1
Rate.Drop.Money = 15
Rate.XP.Kill = 15
Rate.XP.Quest = 15
Rate.XP.Explore = 15
Rate.XP.PastLevel70 = 1
Rate.Rest.InGame = 1
Rate.Rest.Offline.InTavernOrCity = 1
Rate.Rest.Offline.InWilderness = 1
Rate.Damage.Fall = 1
Rate.Auction.Time = 1
Rate.Auction.Deposit = 1
Rate.Auction.Cut = 1
Rate.Honor = 1
Rate.Mining.Amount = 1
Rate.Mining.Next = 1
Rate.Talent = 1
Rate.Reputation.Gain = 15
Rate.Reputation.LowLevel.Kill = 15
Rate.Reputation.LowLevel.Quest = 15
Rate.InstanceResetTime = 1
SkillGain.Crafting = 1
SkillGain.Defense = 1
SkillGain.Gathering = 1
SkillGain.Weapon = 1
SkillChance.Orange = 100
SkillChance.Yellow = 75
SkillChance.Green = 25
SkillChance.Grey = 0
SkillChance.MiningSteps = 0
SkillChance.SkinningSteps = 0
DurabilityLossChance.Damage = 0.5
DurabilityLossChance.Absorb = 0.5
DurabilityLossChance.Parry = 0.05
DurabilityLossChance.Block = 0.05
Death.SicknessLevel = 11
Death.CorpseReclaimDelay.PvP = 1
Death.CorpseReclaimDelay.PvE = 0
Death.Bones.World = 1
Death.Bones.BattlegroundOrArena = 1




Battleground.CastDeserter = 1
Battleground.QueueAnnouncer.Enable = 0
Battleground.QueueAnnouncer.PlayerOnly = 0
Battleground.InvitationType = 0
BattleGround.PrematureFinishTimer = 300000
BattleGround.PremadeGroupWaitForMatch = 1800000






Arena.MaxRatingDifference = 150
Arena.RatingDiscardTimer = 600000
Arena.AutoDistributePoints = 0
Arena.AutoDistributeInterval = 7
Arena.QueueAnnouncer.Enable = 0
Arena.QueueAnnouncer.PlayerOnly = 0
Arena.ArenaSeason.ID = 1
Arena.ArenaSeason.InProgress = 1




PlayerStart.AllReputation = 0
PlayerStart.AllSpells = 0
PlayerStart.MapsExplored = 0
MusicInBattleground = 0
HonorPointsAfterDuel = 0
AlwaysMaxWeaponSkill = 0
PvPToken.Enable = 0
PvPToken.MapAllowType = 4
PvPToken.ItemID = 29434
PvPToken.ItemCount = 1
OutdoorPvP.Wintergrasp.StartTime = 30
OutdoorPvP.Wintergrasp.BattleTime = 30
OutdoorPvP.Wintergrasp.Interval = 150
NoResetTalentsCost = 0
ShowKickInWorld = 0
RecordUpdateTimeDiffInterval = 60000
MinRecordUpdateTimeDiff = 10
PlayerStart.String = ""
CheckDB = 1

2.Making your server public with NO HAMACHI+Renaming your realm



Go at no-ip server.Make yourself a FREE account then download NO-IP DUC.
At the site make a domain let's say extremicuswow.no-ip.biz And after that go to NO-IP DUC and check the box with your hostname.
After that go to SQLYog then realmd ->Tables->realmlist->Columns->Right click and then manage columns.At adress where you see 127.0.0.1 change it to your Dynamic IP(NO-IP DUC ->extremicuswow.no-ip.org) and change the name from '' to 'Extremicus PVP realm'.Then press alter and exit SQLyog




3.Modifying database access.If you want to modify it for local access go to TrinityCore.conf

LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;trinnrealm"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;ytdb"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;trinncharacters"

And change root to X username.
And change ascent to Y password.

V.Setting up fast server startup and other things


1.Using an server starter:

Download Control Panel from here [Only registered and activated users can see links. ]
CREDS to ProphetX


2.Setting up your own WEBSITE Teh ownage

Download latest blizzlike website from here [Only registered and activated users can see links. ]

Here's the best blizzlike forum:
[Only registered and activated users can see links. ]

3.Setting up your OWN ARMORY.
Here is it: [Only registered and activated users can see links. ]
At the moment it supports all 3.1.3 things it isn't bugged but let's see 3.2 release xD.

4.ADs and server publicity/VOTE Tops.
Get your server faster on vote tops so you'll have a lot of users coming to your servers.Add donations and vote gear but never make them overpowered.Again make custom content but not overpowered.Advertise through other sites like Google ADSense and Adword.You're getting a lot of ppl from that.And try to make custom websites.Get a little population first then from donations and other money making guides for server hire some people,you need GMs you need Developers.And first of all the greatest method to catch people is to get on a lot of buggy realms.Yes do it.


BONUS TIPS:
For beginning host the server on your computer.You want to get money so this is the cheapest method.Or you could buy a VPN(Virtual Private Network),it's cheap and you got a lot of web speed.Be sure your upload speed is greater than 10mbps so that you can support more players.And for testing get some friends try the basic things:Ulduar,DK quests and other.Fix the most in the DB and also get fixes from the providers site.

BONUS PROGRAMS:


[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]

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

ULTIMATE BONUS:
AREA TABLE EDITOR:
[Only registered and activated users can see links. ]
Virus scan: [Only registered and activated users can see links. ]
Screenshot
[Only registered and activated users can see links. ]

Use of:Area Table Editor
This program is for editing the AreaTable.dbc file. It's mainly for editing the serverside files but editing the clientside files is also posible. This program can make your mall a Sanctuary or forbid flying mounts in your Outland/Northrend Event Zone. Why don't you take a look at the screenshot below

CREDS to namelessgnome from mmowned

Lol I writed this in a lot of time.I was making the tut at the same time with working on a server.It's a lot of stress.I made the tut with absolutely all needed for a great server.NO reply?And 122 views.Nvm I might remove it if nobody cares posting a reply.It's just not that easy to write all of this.

hi jerry i am "new" to the forums but i find that your posts seem to be the most helpful in alot of cases.thank you for you help and for the time youve put into this site.im sure i will thank you more in the near future

Originally Posted by ofdeath

hi jerry i am "new" to the forums but i find that your posts seem to be the most helpful in alot of cases.thank you for you help and for the time youve put into this site.im sure i will thank you more in the near future

Thank you dude :)

Hey guys... i seem to be stuck at the database part... when i try to import the 3 sql files in SQLyog it gives me an error statement and i can't import them.. any ideas?

Originally Posted by DannyClaudio

Hey guys... i seem to be stuck at the database part... when i try to import the 3 sql files in SQLyog it gives me an error statement and i can't import them.. any ideas?

What error you got ?

nice job guis i will try this.

thanks

thanks for me to i new at trinity but have experience with antrix/ascent/arc