• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

[Windows] TC2 + Boost guide/core and database download included

frost

Banned
I'll be updating this in a few days when my pc gets here.
dont use this core. i uploaded an older core but updated database. ill update it asap
THANKS




Here we go THE TUTORIAL:


Files you will need to download:
  1. VS2013 <---------yes VS2013
  2. this is the TrinityCore Source
  3. this is the WORLD DATABASE AND UPDATE SQL FILES

  4. First install THIS
  5. second install THIS

    I had to install both the 2008 and 2010 files above.

  6. third install THIS
  7. fourth install THIS
  8. this is the BOOST YOU NEED

    NOTE: DONT install CMAKE UNTILL AFTER YOU RESTART YOUR PC IN THE STEP BELOW
  9. this is the CMAKE 3.0.0

At this point you should install the first 4 items in the order they are listed above^^

Make a folder on your desktop and name it "my_server_source" without the quotes.

Now extract the core from trinitycore.rar into my_server_source folder.
Now make a NEW folder named build in the folder named my_server_source
you should now see 2 folders inside of my_server_source folder!

DONOT ATTEMPT TO USE AN OLD DATABASE WITH CUSTOM EDITS
OR THIS MIGHT FAIL!!! MAKE ALL NEW DATABASES


once you have the source and a build folder made we will want to do a few things like setup our databases
there is 2 files in the rar file they are labeled runmefirst and runmesecond
i named them this way so you know the first one is the database (old as the hills)
and the second one brings the database UPTODATE. RUN them both on an EMPTY database
named world or whatever you want it named...

now go into the folder trinitycore\sql\base there is 2 files there. run them on your auth database and your characters database


NOW install BOOST READ NOTE BELOW BEFOR YOU INSTALL THIS IS THE MOST IMPORTAINT 2 STEPS

NOTE: when you install boost, install it into it's DEFAULT directory make sure when
you install boost it says C:\local\boost_1_55_0
FAILIER TO DO THIS IS GOING TO MAKE IT FAIL AND NOT WORK

Now you need to make a system Enviroment variable like in this image: make a system var and a user var. both on the pc you compile and the pc that runs the server
var name is BOOST_ROOT and the value is C:\local\boost_1_55_0

boost_envs.PNG

notice

Notice

DONOT INSTALL CMAKE YET




DO THIS ON BOTH THE PC YOU COMPILE ON AND THE SERVER PC
if you don't do this step right you will get massive CRASHES and ERRORS and you will hate yourself for NOT BEING ABLE TO READ MY GUIDE!

RESTART your pc after you make the variable.


now that you are back from your restart install the new CMAKE 3.0.0

now continue to run CMAKE to compile your sources. make sure you set the compiler to VS 12 2013.....
if you get errors then you skipped a step in this guide :(((( THIS IS WHEN YOU START OVER

NOTE: DONOT ADD ANYTHING BUT TOOLS after cmake configures. if you add anything else you will get massive errors when compiling in VS 2013

now that CMAKE is done and you generated your source gointo you build directory and load your trinitycore.sln

compile your server. add your maps/vmaps/dbc files etc USE THE NEW CONF files not old ones...

setup your server like normal. if you still get errors then your processor does not support SSE2
use an older source that don't have boost.


end guide. please let me know if this guide helped at all.

OMG i uploaded my custom scripts with the core... oh well enjoy them.
 
Last edited:

Tommy

Founder
Great guide, although, there could be a couple corrections.

DONOT INSTALL CMAKE YET

You can have CMake installed but don't start it.

RESTART your pc after you make the variable.

You do not have to restart your PC after doing this. If CMake isn't started, it will configure and generate fine; HOWEVER, if CMake is opened and you make the variable changes, you will still receive "BOOST_ROOT" error. Restart CMake and you will be fine.
 

Tommy

Founder
For what is this "boost" used for?

Boost is a huge C++ library project and it also replaced ACE Project. Surprisingly, it has been very popular over the past few years. Every time you go look at a reply to a support question on stackoverflow (etc) someone always has a reply on how to do it with boost.
 
Last edited:

bury

Enthusiast
Hello, I have this error in several querys from the database characters:

Error Code: 1071 - Specified key was too long; max key length is 1000 bytes

I'm using SQLyog. I hadn't any problem with Auth and World (runmefirst and runmesecond). I've read that I have to change the prefix or something, but I'm not really sure where.

Thanks!
 

Tommy

Founder
Hello, I have this error in several querys from the database characters:

Error Code: 1071 - Specified key was too long; max key length is 1000 bytes

I'm using SQLyog. I hadn't any problem with Auth and World (runmefirst and runmesecond). I've read that I have to change the prefix or something, but I'm not really sure where.

Thanks!

Which table(s) did you have that error on? Seems like they messed up the query by overcompensating the value for a certain type.
 

bury

Enthusiast
This is one example:

Query:
CREATE TABLE `banned_addons` (
`Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`Name` varchar(255) NOT NULL,
`Version` varchar(255) NOT NULL DEFAULT '',
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`Id`),
UNIQUE KEY `idx_name_ver` (`Name`, `Version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2014-09-02 20:07:14
Line no.:230
Error Code: 1071 - Specified key was too long; max key length is 1000 bytes
 

Tommy

Founder
Have you tried running it as an individual query? The query doesn't error for me in Navicat Lite or Sqlyog.
 

bury

Enthusiast
Query : CREATE TABLE `banned_addons` ( `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `Name` varchar(255) NOT NULL, `Version` v...

Error Code : 1071
Specified key was too long; max key length is 1000 bytes

Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000


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

I dont know what happens :S, maybe the version of SQLyog? but I have just downloaded it and seems like the others i've seen in tutorials....
 

bury

Enthusiast
Okay, with that version of mysql I had no more problems with database (I removed it and started it from 0).

I imported the "runmefirst" and the uptodate files "runmesecond" without problems. The same with the auth, and finally the same with the characters.

No problems with Cmake and compiling with VS 12 2013.

No problems extracting maps and dbc, I disabled vmaps and the authserver started properly:

3HsuAOB.jpg


But now when im going to start the worldserver I get this error:

DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;test1234;world


Ofc I edited the authserver.conf and the worldserver.conf this last one in the three ways:

# Default: "127.0.0.1;3306;trinity;trinity;auth"

LoginDatabaseInfo = "127.0.0.1;3306;root;test1234;auth"

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


Default: "127.0.0.1;3306;trinity;trinity;auth" - (LoginDatabaseInfo)
# "127.0.0.1;3306;trinity;trinity;world" - (WorldDatabaseInfo)
# "127.0.0.1;3306;trinity;trinity;characters" - (CharacterDatabaseInfo)

LoginDatabaseInfo = "127.0.0.1;3306;root;test1234;auth"
WorldDatabaseInfo = "127.0.0.1;3306;root;test1234;world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;test1234;characters"

DBerror:

In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction_A = ?, faction_H = ? WHERE entry = ?"
Unknown column 'faction_A' in 'field list'
In mysql_stmt_prepare() id: 54, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'faction_A' in 'field list'

Thanks!!
 
Last edited:

PrestonParsons

BETA Tester
And dont forget to add

MYSQL_INCLUDE_DIR - C:/mysql_libs/include
MYSQL_LIBRARY - C:/mysql_libs/lib_32/libmysql.lib

(By click on Advanced and scroll down) It's more important to do that to make server work. as MYSQL 5.6 is chipped.
 

Seraphim

Noble Member
And dont forget to add

MYSQL_INCLUDE_DIR - C:/mysql_libs/include
MYSQL_LIBRARY - C:/mysql_libs/lib_32/libmysql.lib

(By click on Advanced and scroll down) It's more important to do that to make server work. as MYSQL 5.6 is chipped.

Whoa, now... I've had problems using that method personally. So I tend to go with:
Code:
C:/Program Files (x86)/MySQL/mysql-5.6.16-win32/include
C:/Program Files (x86)/MySQL/mysql-5.6.16-win32/lib/libmysql.lib
 

kitteyjew

Enthusiast
ok so i followed your steps until i get to the runme parts, where do i get the fresh database? do i use the one you gave me, dont i need to compile it first?
 

frost

Banned
@kittyjew the database is the sql files. runme... this is a version of trinity that i personally got it to work. if you want updated server get it from trinitycore. and yes this was the newest database as soon as they moved to boost. it may be a bit outdated but should work great. i have no isses with it sofar.
 
Top