Enjayce's Ultimate 3.1.3 Trinity Repack

[atvboy00]

didnt work still sais unknown path 'world' or whatever

/* Delimiter changed to ;. */
/* Connecting to localhost, username root, using password: Yes ... */
/* Connected. Thread-ID: 7 */
SELECT VERSION() ;
SHOW STATUS LIKE 'Uptime' ;
USE `world` ;
/* SQL Error: Unknown database 'world' */
/* SQL Error: Unknown database 'world' */
USE `world` ;
/* SQL Error: Unknown database 'world' */
/* SQL Error: Unknown database 'world' */
SHOW VARIABLES ;
USE `world` ;
/* SQL Error: Unknown database 'world' */
/* SQL Error: Unknown database 'world' */
USE `world` ;
/* SQL Error: Unknown database 'world' */
/* SQL Error: Unknown database 'world' */

[strongsoldat]

I haven't done any private server stuff for a while and I have a problem with the last step..

"5. I didnt set it for automatic lich king so go to ur navicat sqlyog or w.e you use and change it to expansian 2. and make your self a lv 5 gm."

I forgot how to do this.. ugh

Can someone explainhow to set it up and everything? please

[sarky123]

i have a question. i want to be able to join bgs on my private server without needing any minplayers in queue to join, dont wanna create like 20 accs and log into them just to join a wsg. have tried .tele warsong(for example) but its says "You cannot teleport to a battleground or arena map." so anyone knows how i can fix this? by some command or changing something in the db or in the conf files?
(the reason i want to be able to join bgs on a emty privserver is because i wanna record paths for botting.)

[Kiskaa]

I haven't done any private server stuff for a while and I have a problem with the last step..

"5. I didnt set it for automatic lich king so go to ur navicat sqlyog or w.e you use and change it to expansian 2. and make your self a lv 5 gm."

I forgot how to do this.. ugh

Can someone explainhow to set it up and everything? please

Basically start up the SQL Server
Go into the database using a program like Navicat.
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)

THen save changes.
THis should sort that problem for you.

[bigblue115]

lot of unhandled map chucks, common or am i having a problem

[strongsoldat]

Basically start up the SQL Server
Go into the database using a program like Navicat.
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)

THen save changes.
THis should sort that problem for you.

So far, i have a problem with actually installing SQL.. when i get to the execute part.. it always has an error on #3.
After I install them then i will be able to do it easy i think

But the Installing is screwing me up.. just need help on that

Can anyone help me with setting up navicat and mysql? please

[nirracca]

Im need some help.

this
!
\/

Basically start up the SQL Server.
( done)


Go into the database using a program like Navicat.
(How do i get in to the Database?)

Locate the Part called Trinrealm then open the table called account.
( How do i do that?)

i would be happy for some help

[strongsoldat]

So far, i have a problem with actually installing SQL.. when i get to the execute part.. it always has an error on #3.
After I install them then i will be able to do it easy i think

But the Installing is screwing me up.. just need help on that

Can anyone help me with setting up navicat and mysql? please

The start service bubbe keeps getting an error.. and it won't tel me what

[Willis626]

Why are the xp rates and drop rates (I got 3 pages of drops on my first boar)so dramatically different than blizz servers? Someone said this was the closest retail clone, yet I hit level 5 in 7 boar kills. I am also getting destroyed by a level 7 wolf at level 10.
Is there some sql feature I can edit to fix this?
Also my dns server is doing this:
Error - Can\'t open the database ! (\'udbtrin\')

Other than those 2 things I havn't found anything wrong.

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

Duci96

[Kiskaa]

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/
http://img444.imageshack.us/i/step2.jpg/

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]
http://img268.imageshack.us/i/step3p.jpg/
http://img40.imageshack.us/i/step4o.jpg/

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.
http://www.microsoft.com/downloads/d...displaylang=en

[Kiskaa]

Why are the xp rates and drop rates (I got 3 pages of drops on my first boar)so dramatically different than blizz servers? Someone said this was the closest retail clone, yet I hit level 5 in 7 boar kills. I am also getting destroyed by a level 7 wolf at level 10.
Is there some sql feature I can edit to fix this?
Also my dns server is doing this:
Error - Can\'t open the database ! (\'udbtrin\')

Other than those 2 things I havn't found anything wrong.

Sounds like your arcemu-world.conf file is a bit wrong.
goto \AC Web Ultimate Repack\Arcemu\configs and open up arcemu-world.conf

Scroll down till you see "Rates"

In my conf file it is as follows:
<Rates Health="1"
Power1="1"
Power2="1"
Power3="1"
Power4="1"
QuestReputation="1"
KillReputation="1"
Honor="1"
PvPTimer="300000"
ArenaQueueDiff="150"
Compression="1"
XP="1"
QuestXP="1"
RestXP="1"
ExploreXP="1"
DropGrey="1"
DropWhite="1"
DropGreen="1"
DropBlue="1"
DropPurple="1"
DropOrange="1"
DropArtifact="1"
DropMoney="1"
Save="300000"
SkillChance="1"
SkillRate="1"
ArenaMultiplier2x="1"
ArenaMultiplier3x="1"
ArenaMultiplier5x="1">

Which gives me blizzlike rates, once you made those changes if they are actually different, save them, and restart your servers etc and wow.
This should put them as normal.

Regarding "Error - Can\'t open the database ! (\'udbtrin\')" this part, i came across it somewhere, but cant for the life of me remember where. the problem was that its not actually "udbrin" its "ytdb" but i cant remember where i changed it sorry.

[alex26bv]

nice job +Rep

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

[Willis626]

Sounds like your arcemu-world.conf file is a bit wrong.
goto \AC Web Ultimate Repack\Arcemu\configs and open up arcemu-world.conf

Scroll down till you see "Rates"

In my conf file it is as follows:
<Rates Health="1"
Power1="1"
Power2="1"
Power3="1"
Power4="1"
QuestReputation="1"
KillReputation="1"
Honor="1"
PvPTimer="300000"
ArenaQueueDiff="150"
Compression="1"
XP="1"
QuestXP="1"
RestXP="1"
ExploreXP="1"
DropGrey="1"
DropWhite="1"
DropGreen="1"
DropBlue="1"
DropPurple="1"
DropOrange="1"
DropArtifact="1"
DropMoney="1"
Save="300000"
SkillChance="1"
SkillRate="1"
ArenaMultiplier2x="1"
ArenaMultiplier3x="1"
ArenaMultiplier5x="1">

Which gives me blizzlike rates, once you made those changes if they are actually different, save them, and restart your servers etc and wow.
This should put them as normal.

Regarding "Error - Can\'t open the database ! (\'udbtrin\')" this part, i came across it somewhere, but cant for the life of me remember where. the problem was that its not actually "udbrin" its "ytdb" but i cant remember where i changed it sorry.

My repack didn't come with arcemu >.> Is there something I missed?