Enjayce's Ultimate 3.1.3 Trinity Repack

[nirracca]

@ Nirracca



PREPARE YOURSELVES NEWCOMERS. WE'RE GOING DEEP HERE.

Did you copy/paste the actual sql files into a folder?
( i'm assuming you did this) ^

or

Did you use a SQL GUI program to update the actual logical database called 'Trinncharacters' ?

------

OKAY now if you did just copy/paste the files thats not going to work.

SQL and Trinity work in a logical form with some physical pieces. SQL files, Trinity core.exe and even the .dll files are physical if you will. Together with the help of programs they create the Logical portion of the server. Like Databases and the actual server world.

The Logical part is the Databases, The actually Server core. When you run Trinitycore.exe Trinity Realm .exe and even Apache and MySQL..they all create and assemble the Logical portion.

SO when you are dealing with updates to a database, You need a physical SQL file and a way to access this Logical part (database)...Download
Navicat-Lite
Navicat Free MySQL GUI Lite - Free software downloads and reviews - CNET Download.com
ITs free.

You use this to update the Trinncharacters database using those two SQL files you have.

Now if you need a step by step navicat setup, I'll do one tonight, a quickie for you

First turn on MySQL, so open this repacks Server folder and double click on the MySQL.exe application


NOW in NAVICAT Lite

Basically, create a new connection,

set the IP address as 127.0.0.1
*this is your internal IP of your machine*

User: root
Password: ascent

*note* the password is most likely ascent as it was for this repack but you would know had you changed it*

Thats it. Accept the changes (Hit OK)


Now double click the 127.0.0.1 that is on the left side of Navicat.
If you did install the server and such properly you should see 6 (six) new items in that list.

These are your database tables. (Databases) The server core reads these among other files to create the game world.

Back to the update at hand ok... You should see in the list of 6 (six) the name Trinncharacters. Double click it to expand the list. Now on the left you see more new options and on the right a LOAD of tables (data the game is made of)

Now ignore the right side for now..focus on the left and RIGHT-click on the Trinncharacters and click on Execute Batch File. Now a new window appears. Dont touch anything besides the 3 ... to select the file. Browse to the 01 sql character file you downloaded and select it. Then hit Start.

Repeat for 02 SQL file.

There. All is good and the character DB is updated.

I hope this helps you Nirracca. Welcome to the WoW emulation community!! It's very fun and an interesting hobby. I enjoy it a lot and there is a wealth of knowledge about it here at mmowned.com. Moreso than other sites.:wave:

Realy Thanks it worked =) THANKS!

[Martindd]

@ Nirracca



PREPARE YOURSELVES NEWCOMERS. WE'RE GOING DEEP HERE.

Did you copy/paste the actual sql files into a folder?
( i'm assuming you did this) ^

or

Did you use a SQL GUI program to update the actual logical database called 'Trinncharacters' ?

------

OKAY now if you did just copy/paste the files thats not going to work.

SQL and Trinity work in a logical form with some physical pieces. SQL files, Trinity core.exe and even the .dll files are physical if you will. Together with the help of programs they create the Logical portion of the server. Like Databases and the actual server world.

The Logical part is the Databases, The actually Server core. When you run Trinitycore.exe Trinity Realm .exe and even Apache and MySQL..they all create and assemble the Logical portion.

SO when you are dealing with updates to a database, You need a physical SQL file and a way to access this Logical part (database)...Download
Navicat-Lite
Navicat Free MySQL GUI Lite - Free software downloads and reviews - CNET Download.com
ITs free.

You use this to update the Trinncharacters database using those two SQL files you have.

Now if you need a step by step navicat setup, I'll do one tonight, a quickie for you

First turn on MySQL, so open this repacks Server folder and double click on the MySQL.exe application


NOW in NAVICAT Lite

Basically, create a new connection,

set the IP address as 127.0.0.1
*this is your internal IP of your machine*

User: root
Password: ascent

*note* the password is most likely ascent as it was for this repack but you would know had you changed it*

Thats it. Accept the changes (Hit OK)


Now double click the 127.0.0.1 that is on the left side of Navicat.
If you did install the server and such properly you should see 6 (six) new items in that list.

These are your database tables. (Databases) The server core reads these among other files to create the game world.

Back to the update at hand ok... You should see in the list of 6 (six) the name Trinncharacters. Double click it to expand the list. Now on the left you see more new options and on the right a LOAD of tables (data the game is made of)

Now ignore the right side for now..focus on the left and RIGHT-click on the Trinncharacters and click on Execute Batch File. Now a new window appears. Dont touch anything besides the 3 ... to select the file. Browse to the 01 sql character file you downloaded and select it. Then hit Start.

Repeat for 02 SQL file.

There. All is good and the character DB is updated.

I hope this helps you Nirracca. Welcome to the WoW emulation community!! It's very fun and an interesting hobby. I enjoy it a lot and there is a wealth of knowledge about it here at mmowned.com. Moreso than other sites.:wave:

I did all of this stuff but when i want to execute batch file ... those two files that i downloaded it into Trincharacters it says me :[Err] 1146 - Table 'characters.characters' doesn't exist
[Err] -- ALTER TABLE character_db_version CHANGE COLUMN required_8072_01_characters_characters required_8072_02_characters_characters bit;

UPDATE characters SET
gender = (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 23), ' ', -1) AS UNSIGNED) & 0xFF0000) >> 16,
level = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 54), ' ', -1) AS UNSIGNED),
xp = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 609), ' ', -1) AS UNSIGNED),
money = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 1145), ' ', -1) AS UNSIGNED),
playerBytes = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 154), ' ', -1) AS UNSIGNED),
playerBytes2 = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 155), ' ', -1) AS UNSIGNED),
playerFlags = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 151), ' ', -1) AS UNSIGNED)
WHERE LENGTH(SUBSTRING_INDEX(data, ' ', 1294)) < LENGTH(data) && LENGTH(data) <= LENGTH(SUBSTRING_INDEX(data, ' ', 1295));
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Err] 1054 - Unknown column 'gender' in 'field list'
[Err] -- ALTER TABLE character_db_version CHANGE COLUMN required_8072_01_characters_characters required_8072_02_characters_characters bit;

UPDATE characters SET
gender = (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 23), ' ', -1) AS UNSIGNED) & 0xFF0000) >> 16,
level = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 54), ' ', -1) AS UNSIGNED),
xp = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 609), ' ', -1) AS UNSIGNED),
money = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 1145), ' ', -1) AS UNSIGNED),
playerBytes = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 154), ' ', -1) AS UNSIGNED),
playerBytes2 = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 155), ' ', -1) AS UNSIGNED),
playerFlags = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 151), ' ', -1) AS UNSIGNED)
WHERE LENGTH(SUBSTRING_INDEX(data, ' ', 1294)) < LENGTH(data) && LENGTH(data) <= LENGTH(SUBSTRING_INDEX(data, ' ', 1295));
[Msg] Finished - Unsuccessfully
-------------------------------------------------- and i try to play WoW and log-in But i am logging in like 1000 years always when i click on login it says loging into the game server .... it shows a bar and there is written enjayce trinity server pls can somebody help me with this ? Otherwise i would me most glad to +Rep

[Heru1]

@ Martindd

It looks as if you're just missing a simple Characters table.

DOWNLOAD NOW!

Then just 'Execute Batch' file from Navicat into the trinncharacters DB.

[Carluvi]

Hi enjayce, my name is Carlos from Venezuela, this one is a great job. thank for post to us.
A couple o things, the paladins, Druids, Mages, Priest and Rogues appears with all class spells learned in GM´s and normal player´s accounts. I was alter the starting level for GM
to lvl 1, but it´s still happening. Thanks for any idea to solve it.
Sorry for my poor english, I hope you can understand. see you friend.

[Martindd]

Still won t work

[klinkers]

[IMG ... Wtf... how the hell do i post a picture?? -.-'

Uhm.. can someone please help me? I didnt want to look through the whole tread ... Well I can't start my MySQL. Earlier i had an ArchEmu 3.0.9, could that have affected my new MySQL? Please need aswer anic2:

ah now i got it

[nirracca]

Anyone knows how to add custom items to this server ?
i know to do it some Query but no table is namned Item where i shall put it ?

[johnbigi]

i am running a mangos 3.09 server with about 10 players on it and i was wondering
if there is anyway to import the mangos char. sql into the trinity char sql and get it to work so i dont loose my characters on my server anyone know if this is possible

[CellPunk]

How do you add boss scripting into this?

[7yp4imb0t]

Trying this out as soon as my wow is reinstalled

[Heru1]

@ Klinkers
I gave two possible solutions to this, but as with all my posts I try to instruct also. Share the knowledge and this community will succeed.


I dont see how having a previous server core would affect this repack. This repack is independent of previous installs...sorta..let me explain.

This repack and many like it, use the structure of the folders they come in as the installation and data folders. This is done to simplify the install process and avoid big messy database or other errors.

Now the Sorta part is here. If you have MySQL, PhP, Apache already installed in your system directory and the Service(s) is or are started/running you might run into problems. Be sure to open Services (or Ctrl+Alt+Del) and close/stop the MySQL + Apache + PhP... PhP and Apache are for the websites so they do not need to be running for the WoW server to work.

Once those are closed / stopped try running the MySQL from this repack again. Test this first and see what happens. If they are already close/stopped/ not even installed READ ON >>
``
``
Open the repack's download file the actual .rar file you downloaded. Go to this folder

AC Web Ultimate Repack.rar\AC Web Ultimate Repack\Server\mysql\share\english

extract the errmsg.sys to the Server\mysql\share\english in your repacks folder. See if that works.

Good luck.

[strongsoldat]

OK for those having problems connecting to their db and need help installing/setting up navicat.

Download and install ( Non Commercical cos its free )
Navicat -MySQL

Once that is installed, Run Navicat ( Assuming the SQL service is running )

1) Click on "Connection" then "MySql"
2) Give it a connection name, i use "WoW Server DB"
3) Under hostname put either "localhost" or "127.0.0.1" either should work.
4) Under port use default 3306 ( If you have a router / firewall you might need to allow this port )
5) Username: root Password: ascent
6) Select Save Password

[Screen Shots]
http://img444.imageshack.us/i/step1y.jpg/
Imageshack - step2

This should now let you access your DB from Navicat

YOU MUST HAVE SQL SERVER RUNNING TO BE ABLE TO CONNECT.
This is \AC Web Ultimate Repack\Server\MySql.bat


Once you are in your DB using Navicat, this is where you access the table called Trinrealm as per my previous post.
Which was:

Locate the Part called Trinrealm then open the table called account.
Now the account you created you need to edit 2 parts.

One has the table header "gmlevel" (which you set too 5)
The other has the table header "expansion" (set this too 2 for wotlk)

[Screen Shots]
Imageshack - step3p
Imageshack - step4o

Hope this helps you guys getting into your DB.
Regarding getting the actual SQL server running im not that great at that kinda thing, it just worked out of the box for me.


[EDIT] Also for those having issues actually running the mysql.bat program, make sure you have downloaded and installed .Net framework 3.5, which solved the issues i had with it crashing at first.
Download details: .NET Framework 3.5

Yeah thats the Navicat part, tyvm for that.. What i need help with is setting up the Mysql part!! Should be easy but I keep getting an error.

Could you PM me through the website or give me an AIM or MSN screen name so i could to with you about it? Not to croud up the thread? Ty man

PS. PM me your info, don't do it up here

[Duci96]

@Duci96

I had that also, I found i had to STOP apache. So..

1. Open task manager and close the Apache program open. Even though your window is closed it sometimes is still registered in Process tab.

2. Open Services for your PC and STOP the Apache service.

3. Just double click the Apache-STOP file in the Repack Server Folder.

4. Final option is to just reinstall the Apache folder from the repacks .rar

HOPE IT HELPS!!

Thanks but it still dont work

[Fredag]

Anyone knows how to add custom items to this server ?
i know to do it some Query but no table is namned Item where i shall put it ?

This site will make item creation rather easy, there are of course lots of other ways. But this one is beginner friendly.

You put the item query in the item_template table

[xpoe]

getting the error msg

2009-07-31 15:46:41 Using configuration file TrinityCore.conf.
2009-07-31 15:46:41 TrinityCore2 Rev: Archive Hash: be0323f8a37f (Win32,little-endian) (core-daemon)
2009-07-31 15:46:41 <Ctrl-C> to stop.

2009-07-31 15:46:41 ______ __
2009-07-31 15:46:41 /\__ _\ __ __/\ \__
2009-07-31 15:46:41 \/_/\ \/ _ __ /\_\ ___ /\_\ \ ,_\ __ __
2009-07-31 15:46:41 \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
2009-07-31 15:46:41 \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
2009-07-31 15:46:41 \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
2009-07-31 15:46:41 \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
2009-07-31 15:46:41 C O R E /\___/
2009-07-31 15:46:41 Trinity Core MMo Server Framework - Powered by vBulletin \/__/

2009-07-31 15:46:41 MySQL client library: 5.0.56
2009-07-31 15:46:41 MySQL server ver: 5.0.45-community-nt
2009-07-31 15:46:41 ERROR: Could not connect to MySQL database at 127.0.0.1: Access denied for user 'ascent'@'localhost' (using password: YES)

2009-07-31 15:46:41 ERROR: Cannot connect to Character database 127.0.0.1;root;ascent;trinncharacters

no clue what to do here