Real life warcrafters request help w/ their virtual avatars :)

[yellowd]

Alrighto, here goes:

RapidShare: 1-CLICK Web hosting - Easy Filehosting

For some mysterious reason, all chars are gone except this one. Maybe my friend dumped the database and reloaded only this one while trying to fix the game. But you can just incorporate this one, i'll work it out from there.

We're looking forward to finally playing!
Thanx again! RLTW!
Jay

[grandmst20]

The database structure between Trinity and ArcEmu are so different it would be very hard to convert it without a script. Sorry, I didn't know it would be so different. However, on the good side, I have some files for you. :P

You need a 3.1.3 client for this.

TrinityCore2 4497 (includes 3.1.3 enUS DBC files)
TrinityCore2 4497.rar

UDB 381 (converted to Trinity structure)
TC2 UDB 381.rar

Map/DBC Extractor
3.1.3 Extractor.rar - , Mangos

========================================================
Instructions
========================================================

1. Download and extract TrinityCore2 4497.

2. Download and extract TC2 UDB 381.

3. Create 3 databases in your SQL client.
tdb_realmd
tdb
tdb_characters

4. Import the 3 files you extracted from TC2 UDB 381 into the database with the same name.
ealmd > tdb_realmd
tdb > tdb
characters > tdb_characters

5. Download and extract Map/DBC Extractor. Place ad.exe in your World of Warcraft root directory and run, it will extract the maps and DBC files into 2 folders.

6. Copy the maps folder into the Trinity folder. Ignore the DBC folder for now.

7. Configure the 2 files named "trinitycore.conf" and "trinityrealm.conf"

Trinitycore

RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;trinity;trinity;world"
CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

Change to

RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;username;pw;tdb_realmd"
WorldDatabaseInfo = "127.0.0.1;3306;username;pw;tdb_world"
CharacterDatabaseInfo = "127.0.0.1;3306;username;pw;tdb_characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

Change username and pw to your MySQL information.

Trinityrealm

LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;realmd"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"
PidFile = ""
LogLevel = 0
LogFile = "realmd.log"
LogTimestamp = 0
LogFileLevel = 0
UseProcessors = 0
ProcessPriority = 1
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0
LogColors = ""
EnableLogDB = 0
DBLogLevel = 1

Change to

LoginDatabaseInfo = "127.0.0.1;3306;username;pw;tdb_realmd"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"
PidFile = ""
LogLevel = 0
LogFile = "realmd.log"
LogTimestamp = 0
LogFileLevel = 0
UseProcessors = 0
ProcessPriority = 1
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0
LogColors = ""
EnableLogDB = 0
DBLogLevel = 1

Change username and pw to your MySQL information.

8. Once you get everything setup and configured run TrinityCore.exe and TrinityRealm.exe.

9. To create an account, once TrinityCore.exe is loaded, type the following:

account create <username> <password>
account set addon <username> 2
account set gmlevel <username> 3

If you have any questions or need help, let me know.

[yellowd]

Aw, man, i can't believe you went through all this trouble for us! You're the man!

Achievement Reached: You are now Exalted with the 75th Ranger Regiment.

I'll try it first thing once i get my hands on 3.1. Now i need 1,5h shuteye before i hit the dirt again... damn sandbox.


Thanks a million again, RLTW, and talk soon!
Jay

PS: Be not mistaken for we will pay you back for all this, somehow.

[yellowd]

4. Import the 3 files you extracted from TC2 UDB 381 into the database with the same name.
ealmd > tdb_realmd
tdb > tdb
characters > tdb_characters

No can do. msg i get is:

[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`;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Other question. You said "The database structure between Trinity and ArcEmu are so different it would be very hard to convert it without a script."

Is it then safe to assume we have to start our characters from lvl1 again?

RLTW

[grandmst20]

Yeah you have to start over, sorry. Don't delete your character info though, back it up. (ArcEmu)

As for the error is that on a new database? Create a new one (name doesn't matter, but it's easier to stick to the defaults) and try importing. I just looked a the SQL files and they don't have bad syntax. Gimme more details.

Here's a blank up-to-date character database for TrinityCore2:
KingPin / TrinityCore2 / source &mdash; bitbucket.org

[yellowd]

Here's a blank up-to-date character database for TrinityCore2:
KingPin / TrinityCore2 / source &mdash; bitbucket.org

I apparently had you think I know more than i do. I have no idea what to do with that text... :confused:

More info:
Having no Trinity2 server, i downloaded Kezain's latest Trinity repack. Dumped databases and made 3 new ones as you instructed. Trying to import the SQLs you gave me, i got the above message. Be it here noted that i did this before i substituted the contents of Kezain's folders with yours--dunno if that matters at all. Tried to use yours first but couldn't connect.

Doubt i make any sense here, but i'm really clueless.

Got 3 days quarters for a broken rib so i'll be online more often. Hope we can have it running or close, soon!

RLTW

[Sounddead]

If you still don't have luck by tonight my time, I'll make you a repack with a 3 click start up. So then all you have to worry about is clicking a couple programs and you can play

[yellowd]

If you still don't have luck by tonight my time, I'll make you a repack with a 3 click start up. So then all you have to worry about is clicking a couple programs and you can play

:bow: :bow: That would be awesome, man! :bow: :bow:
Would it be on TrinityCore2, i assume?

RLTW

[Sounddead]

Or Arc if you want, doesn't matter to me. They are both 3.1.3 now, but Trinity is far ahead. Its up to you

[yellowd]

*Sigh* Well, all our characters and stuff are on Arcemu, but we have huge issues with it (most likely due to bad repack we use?), so i was proposed TC2. Please take a sec to re-read initial posts to see our bugs. If you think we wouldn't have those issues with your Arc pack, then we'd be grateful to keep our data.

Many thanks
RLTW!

[The-Eradicator]

*Sigh* Well, all our characters and stuff are on Arcemu, but we have huge issues with it (most likely due to bad repack we use?), so i was proposed TC2. Please take a sec to re-read initial posts to see our bugs. If you think we wouldn't have those issues with your Arc pack, then we'd be grateful to keep our data.

Many thanks
RLTW!

ArcEmu characters can be converted to TC2, someone posted a converter around, I think on the UDB website.

[yellowd]

ArcEmu characters can be converted to TC2, someone posted a converter around, I think on the UDB website.

Looked but didn't find; not that i'd be able to tell it was it. That TC2 site is way too l33t for me. :confused: Grandmstr dispatched me there yesterday and i couldn't understand a word there, lol!

But if you knew where it was and were so kind as to point it out to Sounddead so he could included in his repack, i'd be most obliged. If not, and if he could lose our bugs in an Arc repack of his own, then we'd rather go for Arc.

Be that as it may, even if all this doesn't eventually work out, i'm very grateful for all the support and help anyway!

Thanks a million!
RLTW!

[grandmst20]

Sounddead if you need any help from me let me know, I have experience in all the current cores and databases.

[Sounddead]

Lol, so do I my friend.

[Sounddead]

Sorry for double post, but the pack is gonna have to wait till tomorrow. Work is pretty hectic atm, sorry.