-=/PryDevServer-4TC:\=- Trinity Core!

[zerolevel]

hmm I get this error

[johnbigi]

im using this 3.1.3 repack and im trying to run the 3 realms the fun realm, the pvp realm and the blizz like realm but iom having a problem with the characters. When i create a character in one realm it logs into the other two realms also and then they all 3 crash. anyone know of a multiple realm setup guide for trinity please help

[KoNsoLa]

where can i edit dk for that missing talent points at lvl 55

[DarkKnight1713]

This is my first time setting up a private server for myself and I must say Trinity is awesome so far. Great job with it.

Now for the problem I have... When I log in to my server, I don't have access to TBC or WOTLK content. I'm guessing this is just an account issue, but I'm not positive. I looked in the account table of the realmd database and found an "expansion" column. My account shows that as 0. Does this need to be changed to access TBC and WOTLK content? If so, what value do I need to use? Or is there something else I need to do?

Edit: Ok, I changed the value from 0 to 2 and it works perfectly now. Disregard my questions!

[pryd]

Database / Core has been updated.

PVP Server / Custom server now have full malls.
Will make a video when I get a chance

Enjoy

[DarkFever]

Nice work +rep

[Namexx]

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.

---

I know i have to setup MySQL first (i guess), but i don't know how to set it up? Pryd, im kinda new to this so can you please tell me how to configure MySQL?

Thx

-Namexx

[lorac]

tnx for getting it to 3.1.3! i personally like mangos the most,but its rly getting old,so its a good thing moving to trinity...also since its just an reworked mangos core xD
+Rep now for the work,and +Rep if i can get it running :P

lol,forgot about spreading rep around 1st :\

Ok in a nut shell heres what you do

1.Get Navicat

2.Make a new SQL directory ie
.custom_world
.blizz_world
.pvp_world

3. batch the sql you want your world to be in your newly created sql directory

****IMPORTANT****
Next if you are on mangos already and your just testing out trinity but not sure yet
make a new realmd directory
Call it like
trealmd

Im going to assume you did such for the rest of this help

now batch the realmd.sql in the newly created trealmd

Ok now go in to the new Trealmd
Look for realmlist
Open it
Name your realm what you want it be
IMPORTANT!!!!!
If you are making it live
replace 127.0.0.1 with your external ip address or no one will connect!
Ok your done

Ok now for your char directory
Create a new characters called tcharacters

and then batch the character.sql in that directory

Now
If you are using the core supplied with his repack you should be ready to go
With the db

If you are not
We have more work to do

***if not***
Go to your world directory in the db ie custom_world
Click on version
Look at the number for core
should be a number like 5288 or lower
Now
go to batch
Now your wanting to go to your Trinity source directory and batch all the updates up to your core revision you are using
note
you will also have to apply the changes to your char table
as theres 2 of them
1 being a channel update
and the other being the duel spec update
ok once done your done with the DB
now
Configing
open your trinitycore.conf

Im assuming you are using the examples for this

 
RealmID = 1
DataDir = "C:\location of your \Data"
LogsDir = "C:\location of your\Logs"
LoginDatabaseInfo     = "127.0.0.1;3306;yourusername;yourpassword;trealmd"
WorldDatabaseInfo     = "127.0.0.1;3306;yourusername;yourpassword;custom_world"
CharacterDatabaseInfo = "127.0.0.1;3306;yourusername;yourpassword;tcharacters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

Im already going to assume you know what the rest of the config stuff is
since its all self explanitory

Now go to your TrinityRealm.conf

 LoginDatabaseInfo     = "127.0.0.1;3306;yourusername;yourpassword;trealmd"

Note Do not Log to db!!!! it will add so much to your db and eventually throw so much lag on you and you will crash!

Ok now I am assuming you have your maps made and your dbcs made and in your directory
If not do a search on it theres plenty of tutorials here its something we dont need to cover

On assuming you have everything the way you want it
TURN OFF auction house bot at this moment
0

ok now launch core launch realm
once loaded

create your ahbot account
.account create ahbot ahbotpass youremail
Log into ahbot
and go ingame
ok your done with the bot you can now exit game and turn it on

Now do same for your account
now theres 2 ways of setting your permissions to gm
One the console
or 2 going into trealmd and set permissions to 1-5

Anyways if you go in to db make sure your expantions are set to 2

Now you should be up and going
Play in your configs till you get everything the way you want it
Make a copy of your configs incase you mess them up

Good luck

I think you will find that Pyrds pack is amaising and you wont have much to work on

I hope this huge post helps Someone out there
Lorac

Oh I Almost forgot
Auto Broadcaster
Its a nice tool but a pain if not set right it will spam you every min by default
AutoBroadcast.Timer = 1200000 should be every 20 mins Give or take
its in Millisecs

And if your tired of the Green and pink text

Open your db look for trinity strings
entry 11000
you will see the color codes
BACK UP DB FIRST!!!!!!!
below is a list of color codes

GREY "|cff888888"
WHITE  "|cffffffff"
SUBWHITE "|cffbbbbbb"
MAGENTA  "|cffff00ff"
YELLOW  "|cffffff00"
CYAN   "|cff00ffff"
LIGHTRED "|cffff6060"
LIGHTBLUE  "|cff00ccff"
BLUE  "|cff0000ff"
GREEN  "|cff00ff00"
RED  "|cffff0000"
GOLD  "|cffffcc00"
ALICEBLUE"|cFFF0F8FF"
ANTIQUEWHITE"|cFFFAEBD7"
AQUA  "|cFF00FFFF"
AQUAMARINE  "|cFF7FFFD4"
AZURE "|cFFF0FFFF"
BEIGE "|cFFF5F5DC"
BISQUE"|cFFFFE4C4"
BLACK "|cFF000000"
BLANCHEDALMOND "|cFFFFEBCD"
BLUE  "|cFF0000FF"
BLUEVIOLET  "|cFF8A2BE2"
BROWN "|cFFA52A2A"
BURLYWOOD"|cFFDEB887"
CADETBLUE"|cFF5F9EA0"
CHARTREUSE  "|cFF7FFF00"
CHOCOLATE"|cFFD2691E"
CORAL "|cFFFF7F50"
CORNFLOWERBLUE "|cFF6495ED"
CORNSILK "|cFFFFF8DC"
CRIMSON  "|cFFDC143C"
CYAN  "|cFF00FFFF"
DARKBLUE "|cFF00008B"
DARKCYAN "|cFF008B8B"
DARKGOLDENROD  "|cFFB8860B"
DARKGRAY "|cFFA9A9A9"
DARKGREEN"|cFF006400"
DARKKHAKI"|cFFBDB76B"
DARKMAGENTA "|cFF8B008B"
DARKOLIVEGREEN "|cFF556B2F"
DARKORANGE  "|cFFFF8C00"
DARKORCHID  "|cFF9932CC"
DARKRED  "|cFF8B0000"
DARKSALMON  "|cFFE9967A"
DARKSEAGREEN"|cFF8FBC8B"
DARKSLATEBLUE  "|cFF483D8B"
DARKSLATEGRAY  "|cFF2F4F4F"
DARKTURQUOISE  "|cFF00CED1"
DARKVIOLET  "|cFF9400D3"
DEEPPINK "|cFFFF1493"
DEEPSKYBLUE "|cFF00BFFF"
DIMGRAY  "|cFF696969"
DODGERBLUE  "|cFF1E90FF"
FIREBRICK"|cFFB22222"
FLORALWHITE "|cFFFFFAF0"
FORESTGREEN "|cFF228B22"
FUCHSIA  "|cFFFF00FF"
GAINSBORO"|cFFDCDCDC"
GHOSTWHITE  "|cFFF8F8FF"
GOLD  "|cFFFFD700"
GOLDENROD"|cFFDAA520"
GRAY  "|cFF808080"
GREEN "|cFF008000"
GREENYELLOW "|cFFADFF2F"
HONEYDEW "|cFFF0FFF0"
HOTPINK  "|cFFFF69B4"
INDIANRED"|cFFCD5C5C"
INDIGO"|cFF4B0082"
IVORY "|cFFFFFFF0"
KHAKI "|cFFF0E68C"
LAVENDER "|cFFE6E6FA"
LAVENDERBLUSH  "|cFFFFF0F5"
LAWNGREEN"|cFF7CFC00"
LEMONCHIFFON"|cFFFFFACD"
LIGHTBLUE"|cFFADD8E6"
LIGHTCORAL  "|cFFF08080"
LIGHTCYAN"|cFFE0FFFF"
LIGHTGRAY"|cFFD3D3D3"
LIGHTGREEN  "|cFF90EE90"
LIGHTPINK"|cFFFFB6C1"
LIGHTRED "|cFFFF6060"
LIGHTSALMON "|cFFFFA07A"
LIGHTSEAGREEN  "|cFF20B2AA"
LIGHTSKYBLUE"|cFF87CEFA"
LIGHTSLATEGRAY "|cFF778899"
LIGHTSTEELBLUE "|cFFB0C4DE"
LIGHTYELLOW "|cFFFFFFE0"
LIME  "|cFF00FF00"
LIMEGREEN"|cFF32CD32"
LINEN "|cFFFAF0E6"
MAGENTA  "|cFFFF00FF"
MAROON"|cFF800000"
MEDIUMAQUAMARINE  "|cFF66CDAA"
MEDIUMBLUE  "|cFF0000CD"
MEDIUMORCHID"|cFFBA55D3"
MEDIUMPURPLE"|cFF9370DB"
MEDIUMSEAGREEN "|cFF3CB371"
MEDIUMSLATEBLUE"|cFF7B68EE"
MEDIUMSPRINGGREEN "|cFF00FA9A"
MEDIUMTURQUOISE"|cFF48D1CC"
MEDIUMVIOLETRED"|cFFC71585"
MIDNIGHTBLUE"|cFF191970"
MINTCREAM"|cFFF5FFFA"
MISTYROSE"|cFFFFE4E1"
MOCCASIN "|cFFFFE4B5"
NAVAJOWHITE "|cFFFFDEAD"
NAVY  "|cFF000080"
OLDLACE  "|cFFFDF5E6"
OLIVE "|cFF808000"
OLIVEDRAB"|cFF6B8E23"
ORANGE"|cFFFFA500"
ORANGERED"|cFFFF4500"
ORCHID"|cFFDA70D6"
PALEGOLDENROD  "|cFFEEE8AA"
PALEGREEN"|cFF98FB98"
PALETURQUOISE  "|cFFAFEEEE"
PALEVIOLETRED  "|cFFDB7093"
PAPAYAWHIP  "|cFFFFEFD5"
PEACHPUFF"|cFFFFDAB9"
PERU  "|cFFCD853F"
PINK  "|cFFFFC0CB"
PLUM  "|cFFDDA0DD"
POWDERBLUE  "|cFFB0E0E6"
PURPLE"|cFF800080"
RED"|cFFFF0000"
ROSYBROWN"|cFFBC8F8F"
ROYALBLUE"|cFF4169E1"
SADDLEBROWN "|cFF8B4513"
SALMON"|cFFFA8072"
SANDYBROWN  "|cFFF4A460"
SEAGREEN "|cFF2E8B57"
SEASHELL "|cFFFFF5EE"
SIENNA"|cFFA0522D"
SILVER"|cFFC0C0C0"
SKYBLUE  "|cFF87CEEB"
SLATEBLUE"|cFF6A5ACD"
SLATEGRAY"|cFF708090"
SNOW  "|cFFFFFAFA"
SPRINGGREEN "|cFF00FF7F"
STEELBLUE"|cFF4682B4"
TAN"|cFFD2B48C"
TEAL  "|cFF008080"
THISTLE  "|cFFD8BFD8"
TOMATO"|cFFFF6347"
TRANSPARENT "|c00FFFFFF"
TURQUOISE"|cFF40E0D0"
VIOLET"|cFFEE82EE"
WHEAT "|cFFF5DEB3"
WHITE "|cFFFFFFFF"
WHITESMOKE  "|cFFF5F5F5"
YELLOW"|cFFFFFF00"
YELLOWGREEN "|cFF9ACD32"

change to your likings reload trinity strings and walaa new colors

that can be fixed. Edit the dk quests.

The most annoying problem I have with trinity is the 0% crit bug. I hope this is fixed soon then I will switch to trinity.

0% crit bug?
I dont believe thats a trinity bug
as all our crit % work just fine on our server
As for dk tps
That should be fixed look in your configs also I believe theres a setting for the hero class
With Trin implimenting duel spec now you will have to worry about to much tp lol

Pyrd 5224 had a bit of issues you might want update to newest one to showcase your db better

[Dominatrixx]

I get an error with my Characters DB can someone help. It doesn't add all the tables only some of them.

Thanks this is the error i get:

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*

--
-- Table structure for table `character_db_version`
--

DROP TABLE IF EXI' at line 7
[Err] /*

--
-- Table structure for table `character_db_version`
--

DROP TABLE IF EXISTS `character_db_version`;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/

--
-- Table structure for table `account_data`
--

DROP TABLE IF EXISTS `acc' at line 1
[Err] */

--
-- Table structure for table `account_data`
--

DROP TABLE IF EXISTS `account_data`;

[KoNsoLa]

any one can tell me where i can fix dk talents cos i have 0 at lvl 55

[Namexx]

Hey, can anyone tell me how to setup/configure MySQL, because i keep getting errors when i finish configuring , thank you

[KoNsoLa]

Hey, can anyone tell me how to setup/configure MySQL, because i keep getting errors when i finish configuring , thank you

what kind of error u get when u finish installing

[Namexx]

what kind of error u get when u finish installing

Nvm its already fixed although it still gave errors, now i imported all DB's but when i try to run TrinCore.Exe and TrinRealm.exe it gives an error saying: The Version of this File is not compatible with the Version of Windows you're running.

[lorac]

Nvm its already fixed although it still gave errors, now i imported all DB's but when i try to run TrinCore.Exe and TrinRealm.exe it gives an error saying: The Version of this File is not compatible with the Version of Windows you're running.

1 make sure your launching 64 bit for a 64 bit cup
and 32 bit for a 32 bit cpu
2 you will need .net 3.5 framework to run

any one can tell me where i can fix dk talents cos i have 0 at lvl 55

See your DK trainer BUY Duel spec and switch
you wont complain about to little anymore
you will have too many

[Upmar]

Nvm its already fixed although it still gave errors, now i imported all DB's but when i try to run TrinCore.Exe and TrinRealm.exe it gives an error saying: The Version of this File is not compatible with the Version of Windows you're running.

Same error, ohwell, wasted half of my day

EDIT: is there anyway i can use a batch file instead of the exe?