Enjayce's Ultimate 3.1.3 Trinity Repack

[Kiskaa]

Opps sorry my bad :P
I copied the wrong config file sorry. ( I use a few different repacks across different patch versions of wow for my Video making )
THe file you want is the Trinitycore.conf file located within the Trinitycore folder.

In there you want to scroll down too the rates section of there and make sure it has the following rates

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 = 1
Rate.Drop.Item.Normal = 1
Rate.Drop.Item.Uncommon = 1
Rate.Drop.Item.Rare = 1
Rate.Drop.Item.Epic = 1
Rate.Drop.Item.Legendary = 1
Rate.Drop.Item.Artifact = 1
Rate.Drop.Item.Referenced = 1
Rate.Drop.Money = 1
Rate.XP.Kill = 1
Rate.XP.Quest = 1
Rate.XP.Explore = 1
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 = 1
Rate.Reputation.LowLevel.Kill = 1
Rate.Reputation.LowLevel.Quest = 1
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


( Again sorry about posting the wrong config file )
Ive just loaded this repack and checked the rates on a none GM character on this pack and im getting blizz like rates of XP gains and loot.
I also used an 80 none GM char to also do some mob killing etc to double check drops and they all seem like what i get on my wotlk retail wow. ( Couldnt check raid boss drops tho without a level l80 raid of a stupid high char with silly gear, but based on all the other tests i carried out, im guessing they`ll be within normal rates of drop etc too )

[Willis626]

Yeah I assumed they were all on by default but I guess I got an edited config. real goofy. Still have to relevel to 19 and see if I get hossed by level 12's again. (might have been i had no time to level my defense)

[Heru1]

I read all 35 pages and now i shouldn't have to ask any questions. Reading is useful folks.

[Heru1]

I have been getting errors using the vmap extractor, Even after changing the Ad.exe suggested throughout this thread. I decided to use a previous 3.1.3 extractor set from someone else repack and it works now. I believe there is a problem with the version of extractor Enjayce's used. It looks like it couldn't grab all the files it needed to compile all the vmaps. To be clear I changed all of the extractor files, not just Ad.exe. Even a good Ad.exe run would give errors using the vmaps extractor included in Enjayce's Repack.

I ran AD.exe, then, makevmaps_simple.bat


Filebeam - Free Fast File Hosting


After extracting, you'll need to copy the maps and vmaps folders from your WoW Directory into your TC folder as normal.

I've found that even though I got errors with Enjayce's extractors, I did not delete the folders it had created. I simply ran the previous versions of the extractor tools and it added in what was missing. So do not delete the folders, dbc, buildings, maps, vmaps.

[nirracca]

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

Kiskaa Realy Thanks Found all stuff direct Thanks =)

[Martindd]

Hmmm strange when i want to execute batch file 4292_8072_01_characters_characters.sql and 4292_8072_02_characters_characters.sql in trincharacters DB it shows me 2 errors

[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
--------------------------------------------------

Any ideas ? ... Btw is that really nessesary to extract those two?

[bujon]

hi i get this error


2009-07-29 13:22:38 ERROR: Map file './maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.
2009-07-29 13:22:38 ERROR: Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the Trinityd.conf file.


can anyone help me pls ?

[Heru1]

Ok seriously this was posted two posts up lol. If you're still getting an error after this regarding map folder location or directory then look in your TrinityCore.conf file and review the DataDir entry. It should be the same as your trin core directory.

BUJON this will fix your vmap and map problem. You'll need to rextract the files but if you keep your previous maps,vmaps and buildings folders the new extractor tools from this link will fill in what files are missing so if you keep old ones it will go faster now.

I have been getting errors using the vmap extractor, Even after changing the Ad.exe suggested throughout this thread. I decided to use a previous 3.1.3 extractor set from someone else repack and it works now. I believe there is a problem with the version of extractor Enjayce's used. It looks like it couldn't grab all the files it needed to compile all the vmaps. To be clear I changed all of the extractor files, not just Ad.exe. Even a good Ad.exe run would give errors using the vmaps extractor included in Enjayce's Repack.

I ran AD.exe, then, makevmaps_simple.bat


Filebeam - Free Fast File Hosting


After extracting, you'll need to copy the maps and vmaps folders from your WoW Directory into your TC folder as normal.

I've found that even though I got errors with Enjayce's extractors, I did not delete the folders it had created. I simply ran the previous versions of the extractor tools and it added in what was missing. So do not delete the folders, dbc, buildings, maps, vmaps.

[nirracca]

Now i think im have done almoste all things done
but i don't know what to do with this Error:


TC>Max allowed socket connections 4096
SQL: SELECT guid, data, name, position_x, position_y, position_z, map, totaltime, leveltime, at_login, zona, level FROM characters WHERE guid = '9'
query ERROR: Unknown column 'level' in 'field list'


someone knows what i shall do ?

[Heru1]

Now i think im have done almoste all things done
but i don't know what to do with this Error:


TC>Max allowed socket connections 4096
SQL: SELECT guid, data, name, position_x, position_y, position_z, map, totaltime, leveltime, at_login, zona, level FROM characters WHERE guid = '9'
query ERROR: Unknown column 'level' in 'field list'


someone knows what i shall do ?

I can only think, did you update the characters table with those two sql files?

Filebeam - Free Fast File Hosting

read the files names carefully. You'll see two files, one is ends in 01 and the other 02. Update 01 first, then 02

[Martindd]

Pls can anybody help me with this when i want to execute batch file 4292_8072_01_characters_characters.sql and 4292_8072_02_characters_characters.sql to TrinCharacters it shows me 2 errors:

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
--------------------------------------------------

Pls somebody help me ... Btw is it really necessary to execute those two?

[damir84]

Tnx man.

After one hour of thinking i maked it to work.

+Rep

[Sazs]

Thanks for a great repack, but why is northrend so bugged? almost every quest doesn't work!

I need something to fix this, can someone help me? please...

[nirracca]

I can only think, did you update the characters table with those two sql files?

Filebeam - Free Fast File Hosting

read the files names carefully. You'll see two files, one is ends in 01 and the other 02. Update 01 first, then 02

i have done that

But this is the first server that i have done i don't know if i put those 2 SQL files in the right folder. I don't remember what folder, but i put them in a folder that already had 2 files like those with same name so i replaced them.

i hope that i did that right.

[Duci96]

Hello,

When I Start apache I get this error:


******************************************
_______ ______ __ __ ______ _______
/\ __ \ /\ ___\ ____ /\ \ /\ \ /\ ___\ /\ __ \
\ \ \_\ \\ \ \__/ /\___\\ \ \ __\ \ \ \ \ \__ \ \ \_\ \
\ \ ___ \\ \ \ \/___/ \ \ \/\ \\ \ \ \ \ _\ \ \ __ \
\ \ \\ \ \\ \ \____ \ \ \_\ \\_\ \ \ \ \____\ \ \_\ \
\ \_\\ \_\\ \_____\ \ \__________\ \ \_____\\ \______\
\/_/ \/_/ \/_____/ \/__________/ \/_____/ \/______/
___________________________________________________
/\_________________www.ac-web.org___________________\
\/___________AC Web Ultimate Repack 7.8_____________/
Please close this command only for Shutdown
Apache 2 is running, don't close this window.
(OS 1004Elk socketadres (protocol/netwerkadres/poort) kan normaal slechts ÚÚn
keer worden gebruikt. : make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs

Apache konnte nicht gestartet werden
Apache could not be started
Druk op een toets om door te gaan. . .
Someone knows the simpel solution to fix this? =]

Thanks in advance!