Thread: How to setup trinitycore2 for WINDOWS

THIS GUIDE IS OBSELETE AND WILL BE UPDATED IN THE NEAR FUTURE

--=}HOW TO SETUP TRINITY AND HOW TO UPDATE DB AND CORE{=--
--=}WINDOWS ONLY{=--
version 6.1
THE LATEST TRINITYCORE2 REV (3000+)
WOW Client 3.0.9

YOU WILL NEED
:WOW 3.0.9
:A web server (XAMPP is great get it [Only registered and activated users can see links. ])
:SQLYOG (Get it [Only registered and activated users can see links. ] just fill in short form)
:TortoiseHG (Get it [Only registered and activated users can see links. ])
:Visual C++2008
:.NET framework 3.5
:A Compiled version of trinity (How to in the guide)
:A Database for trinity (This guide uses TDB_0.0.3 get it [Only registered and activated users can see links. ])
BC,MAPS and VMAPS (Made during this guide)

THIS GUIDE ASSUMES YOU HAVE INSTALLED THESE ALREADY

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

CONTENTS
-----------------------------------------------------------------------

00 - CONVERTING 2.4.3 to 3.0.9
01 - FIRST TIME SETUP
02 - HOW TO COMPILE IN VC++ 2008
03 - MAPS,DBC AND VMAPS EXTRACTION
04 - PREPARING TRINITY
05 - SETTING UP YOUR DATABASE
06 - HOW TO UPDATE YOUR DATABASE
07 - HOW TO USE UPDATE PACKS
08 - DB QUICK INSTALL USING UPDATEPACKS
09 - CREATE ACCOUNT
10 - EXPANSIONS
11 - GM ACCOUNT
12 - HOW TO UPDATE YOUR CORE

-----------------------------------------------------------------------
00 CONVERTING 2.4.3 to 3.0.9
-----------------------------------------------------------------------
For now i will link to other guides on this topic please read them all as they contain different infomation on different revs etc
[Only registered and activated users can see links. ]

This is how to use the converter included in TC2

Code:

Convert DB from 2.4.3 to 3.0.x:
 
1. BACKUP your old db!
2. Run TBC-WLK_characters.sql in "characters" database.
3. Run TBC-WLK_world_run_only_once.sql in "world" database.
4. Run TBC-WLK_world.sql in "world" database.
 
After that you need to manually apply all sqls starting from 805_world_scripts.sql (in sql/updates)
!IMPORTANT! If your professions' tools aren't detected in inventory after upgrade to 3.0.x, please delete your "Cache" directory in client's one.
Ask your testers to do so no matter what, too. !IMPORTANT!

-----------------------------------------------------------------------
01 FIRST TIME SETUP
-----------------------------------------------------------------------
Ok now create a new folder in C:/ and name it TRINITY (EG: C:/TRINITY)
then inside that folder create a folder called DATA (EG: C:/TRINITY/DATA)
now right click on the folder C:/TRINITY and choose TORTOISEHG
then choose CLONE A REPOSITORY

fill in SOURCE PATH with this [Only registered and activated users can see links. ]

fill in DESTINATION PATH with this C:/TRINITY/CORE
uncheck the box next to USE UNCOMPRESSED TRANSFER
and check the box next to USE PULL PROTOCOL TO COPY METADATA
also make sure that CLONE ALL REVSIONS is checked

now click the CLONE button at the top right
this will now download the newest core files

you will now need to COMPILE the core.


-----------------------------------------------------------------------
02 HOW TO COMPILE IN Visual C++ 2008
-----------------------------------------------------------------------

Ok first make sure you have intalled VC++ 2008 and SP1 for it

browse to C:\Trinity\core\win and double click TrinityCore&Script VC90

(if this dosnt open the file then right click TrinityCore&Script VC90 and choose open with C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\VCExpress.exe )

Once open click Build then Configuration Manager under Active Soulution configuration change it from DEBUG to RELEASE and click close

now click BUILD then click BUILD SOULTION this will start the building process
when its done it will show this at bottom of window

12>TrinityScript - 0 error(s), 0 warning(s)
========== Build: 12 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

( Please dont PM me with build errors instead search the forums and if nothing post a topic on it)

once you have compiled the core copy all the files from C:/TRINITY/CORE/win/bin/win_32 release into C:/TRINITY

(Some files are not needed but its easier to copy all of them for arguements sake)

-----------------------------------------------------------------------
03 MAPS,DBC AND VMAPS EXTRACTION
-----------------------------------------------------------------------
To get MAPS and DBC goto "C:/TRINITY/CORE/contrib/extractor/ad.exe" and copy it (ad.exe) into WOW directory (Default is C:/program files/World of Warcraft) and run it then copy "MAPS" and "DBC" folders that ad.exe makes into C:/TRINITY/DATA

To get VMAPS goto "C:/TRINITY/CORE/contrib/vmap_extract_assembler_bin/" and run makevmaps_simple.bat copy created "VMAPS" folder into C:/TRINITY/DATA.

-----------------------------------------------------------------------
04 PREPARING TRINITY
-----------------------------------------------------------------------
now copy REALMD and CHARACTERS sql from C:/TRINITY/CORE/sql/ to C:/TRINITY

Next open Trinitycore.conf also in C:/TRINITY and change these line now change this line
(DataDir = ".")
to this
(DataDir = "C:/Trinity/data")

if you want to use VMAPS change the following lines from

vmap.enableLOS = 0
vmap.enableHeight = 0

to this

vmap.enableLOS = 1
vmap.enableHeight = 1

save the file and exit it

Now your server is almost ready to go so lets populate it!

-----------------------------------------------------------------------
05 SETING UP YOUR DATABASE
-----------------------------------------------------------------------

THIS PART OF THE GUIDE USES SQLYOG AND ASSUMES YOU HAVE
DOWNLOADED TDB_0.0.3 ALREADY

Ok now extract TDB_0.0.3.rar to C:/TRINITY

open SQLYOG and connect then press CTRL+U this will open the add new user window. Fill in the window the same as below:

Username: trinity
Host:%
Password:trinity
Retype password:trinity

then click SELECT ALL and click CREATE
(this will give your server accses to the Database)

now click DB and then Create Database now name the Database "world" and click CREATE now repeat this to create 2 more new Database's called realmd and characters for a total of 3 DBs

once you have done this press F5 this will refresh SQLYOG

Now right click on the "world" DB and choose RESTORE FROM SQL DUMP and choose TDB_0.0.3.sql located in C:/TRINITY then click execute when finished click close

Now right click on the "realmd" DB and choose RESTORE FROM SQL DUMP and choose realmd located in C:/TRINITY then click execute when finished click close

Now right click on the "characters" DB and choose RESTORE FROM SQL DUMP and choose characters located in C:/TRINITY then click execute when finished click close

once again press F5 to refresh SQLYOG

Now click the little + next to realmd then the + next to Tables right click on realmlist and choose VIEW DATA

now click where it says NULL and type in 1 then click next to it and type in trinity then next to that leave the IP as 127.0.0.1 then click the little blue disk icon just above ID this will save your changes then close SQLYOG

now go to your WOW install directery
(Default is C:/program files/World of Warcraft)
and open realmlist with notepad change it to this

set realmlist 127.0.0.1 save and close it


-----------------------------------------------------------------------
06 HOW TO UPDATE YOUR DATABASE
-----------------------------------------------------------------------

IT IS YOUR CHOICE TO USE UPDATEPACKS OR NOT
BUT THEY ARE STRONGLY ADVISED TO USE
IF YOU WOULD LIKE TO USE THEM SKIP TO STEP 7

IMPORTANT: Only use if you have not installed a UPDATE PACK if you have ONLY use updates higher than your update pack EG UPDATE PACK 11 is rev 2734+ only use updates over rev 2734
IT IS YOUR CHOICE TO USE UPDATEPACKS OR NOT
BUT THEY ARE STRONGLY ADVISED TO USE

ok open SQLYOG and connect
(remeber to start your MYSQL server first!!)

Now right click on the "world" DB and choose RESTORE FROM SQL DUMP browse to this folder C:\TRINITY\CORE\sql\updates
and choose ** world.sql then execute repeat this for all the SQL's that have "WORLD" in there name
(**=nuber of update EG.54,84 etc)

Now right click on the "realmd" DB and choose RESTORE FROM SQL DUMP browse to this folder C:\TRINITY\CORE\sql\updates
and choose ** realmd.sql then execute repeat this for all the SQL's that have "REALMD" in there name
(**=nuber of update EG.54,86 etc)

Now right click on the "charaters" DB and choose RESTORE FROM SQL DUMP browse to this folder C:\TRINITY\CORE\sql\updates
and choose ** characters.sql then execute repeat this for all the SQL's that have "CHARACTERS" in there name
(**=nuber of update EG.54,86 etc)


In the future only do this for NEW sqls that appear in the folders
(EG: if the last update for world you did was 94 only apply updates above this like 95,96,105 etc)

-----------------------------------------------------------------------
07 HOW TO USE UPDATE PACKS
-----------------------------------------------------------------------

Only use the updatepacks if your sure your on the right rev first or you will get errors

ok first go HERE and download the latest update pack MAKE SURE YOU GET ALL THE FILES for the update pack (EG UPDATE PACK 11 has 4 files)
11_corepatch_realmd_1733 to 2832.sql

11_corepatch_characters_1733 to 2832.sql
11_corepatch_world_1733 to 2832.sql
11_updatepack_world.sql

make sure you get them all
save the files to here C:\Trinity\core\sql

ok open SQLYOG and connect
(remeber to start your MYSQL server first!!)

Now right click on the "world" DB and choose RESTORE FROM SQL DUMP browse to this folder C:\TRINITY\CORE\sql\Updates
and choose *_corepatch_world_***_to_*** then execute
(*=number of update )

Now right click on the "realmd" DB and choose RESTORE FROM SQL DUMP browse to this folder C:\TRINITY\CORE\sql\updates
and choose *_corepatch_realmd_***_to_*** then execute
(*=number of update )

Now right click on the "charaters" DB and choose RESTORE FROM SQL DUMP browse to this folder C:\TRINITY\CORE\sql\updates
and choose *_corepatch_characters_***_to_*** then execute repeat this for all the SQL's that have "CHARACTERS" in there name
(*=number of update )

Make sure you run the "updatepack_world_***_to_***" file last!!!

Now right click on the "world" DB and choose RESTORE FROM SQL DUMP browse to this folder C:\TRINITY\CORE\sql\updates
and choose *_updatepack_world_***_to_*** then execute
(*=number of update)

-----------------------------------------------------------------------
08 DB QUICK INSTALL USING UPDATEPACKS
-----------------------------------------------------------------------
THIS A QUICK GUIDE ONLY IF YOU HAVE ALREADY DONE THE ABOVE STEPS SKIP THIS STEP AND CONTINUE

You can get the UPDATEPACKS [Only registered and activated users can see links. ] and TDB 0.0.3 [Only registered and activated users can see links. ]

TDB 0.0.3.sql

11_corepatch_realmd_1733 to 2832.sql

11_corepatch_characters_1733 to 2832.sql
11_corepatch_world_1733 to 2832.sql
11_updatepack_world.sql

Every update over rev 2832 in your CORE\sql\updates folder

-----------------------------------------------------------------------
09 CREATE ACCOUNT
-----------------------------------------------------------------------
open C:/TRINITY and run TRINITYREALM and also run TRINITYCORE
wait for a beep sound

Once you hear the beep click the TRINITYCORE screen and type in the following ACCOUNT CREATE USER PASSWORD

change USER to the login name you would like
change PASSWORD to the password you would like
then press enter

-----------------------------------------------------------------------
10 EXPANSIONS
-----------------------------------------------------------------------
WOTLK type in the following

ACCOUNT SET ADDON USER 2

TBC type in the following

ACCOUNT SET ADDON USER 1
-----------------------------------------------------------------------
11 GM ACCOUNT
-----------------------------------------------------------------------
TO MAKE A GM ACCOUNT TYPE IN THIS AND THE ACCOUNT WILL BE A LEVEL 3 GM
(1 being lowest 3 being highest)

account set gmlevel USER 3

-----------------------------------------------------------------------
12 HOW TO UPDATE YOUR CORE
-----------------------------------------------------------------------
Go to C:/TRINITY/CORE and right click on it and choose TortoiseHG then choose Synchronize then click the PULL to update your CORE files to the newest CORE REV once this has finished updatingclick UPDATE TO TIP you then need to COMPILE THE CORE AGAIN
Once you have finished compiling update your database (use the above guide)

now your core is upto date!

Now start WOW , login and enjoy!!!!

CREDITS
The Entire DEV team!
The Entire TDB team!
THE WHOLE TRINITY COMMUNITY!!

Nice instruction, good job!