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

[Krobelus]

sorry but this is true?, pryd repack the now supports 3.3.0?, because it says on the first page so I wanted to know if pryd repack 3.3.0 supports now and I would also ask if the new band and works with aggregates monsters and other things?, this is true forgiveness?
11. WOTLK 330 Items such as T9 / T10!!

[rb2crens]

any heroic item doesnt show gem socket in its tooltip, but still can be socketed..
the mall still filled with ulduar gear, not toc gear..
and there's no bot patch in this core
(hope those can be fixed soon)
anyway is toc working here??

[mitfry]

To arushima:

Well it's not as difficult as it might look,

let's take this part for example:

------------------------------------
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------
DROP TABLE IF EXISTS `account_data`; delete here ?????
CREATE TABLE `account_data` (
`account` int(11) unsigned NOT NULL DEFAULT '0',
`type` int(11) unsigned NOT NULL DEFAULT '0',
`time` bigint(11) unsigned NOT NULL DEFAULT '0',
`data` longtext NOT NULL,
PRIMARY KEY (`account`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

------------------------------------------

just delete the part in red, so you'll only have lines that say ''insert data to bla bla''

I hope you understand it now, if not just let me know!

Regards,


Mitchell

[Scoooby]

I use your server , is a great one but i have a probelm : When i wana create a char i cant create blood elf and daranei idk why if u can help me please help me

[mitfry]

To Scoooby:

Hey man!

Well, i've been testing this database aswell and the blood elf/draenei creation works perfectly.

What you can check is if your account has enabled both TBC and WOTLK in your realm database =]

Otherwhise ill suggest you to make a clean database and import the SQL's provided by Pryd's Repack.

Regards,


Mitch

[Scoooby]

To mitfry :


One more question how can i check my account ?? if is embled for Wotkl or TBC ?? i realy dont find if u can tell me ...is great

[mitfry]

@ Scooby

Well m8,

if you open the realm database with all the accounts inside etc, there is a table called Accounts, open that table and find the row that's called Expansion, change the value of the account to 2 under the expansion row.

that's basicly it.

feel free to ask any other questions.


Good luck!


Mitch

[Scoooby]

To mitch !
Look what are my settings:# Expansion
# Allow server use content from expansion
# Default: 2 - check expansion 2 maps existence, and if client support expansion 2 and account have
# expansion 2 setting then allow visit expansion 2 maps, allow create new class character)
# 1 - check expansion 1 maps existence, and if client support expansion 1 and account have
# expansion 1 setting then allow visit expansion 1 maps, allow create new races character)
# 0 - not check expansion maps existence, not allow wisit its, not allow create new race or new class

And i have the number 2 .. i'm gonna idk why

[mitfry]

@ Scooby

Well there you can see you should use option 2, but
may I know which program you're using to open the files? You should use something like Navicat or HeidiSQL and make a connection to your database using those programs so you can edit them.

If you really can't find out where to check it you may add me on msn then i'll help you further. my email is: [email protected]

Regards,


Mitch

[dagreg]

Hi,

I'm kinda new to all this and maybe kanda a noob. Let me just start by saying thanks man, thanks for your hard work.

Now I just followed your tutorial on youtube and got my TC runnning, till that no problems at all, got to create account and give it the level 4 GM status. My problem comes when I launch WOW and try to connect to my own server. It sais unable to connect and I can't understand why this happens. I've tried lots of realmlists like localhost 127.0.0.1, my private IP address, I even disconnected from the internet to try and connect the game to the emu.

If anyone has this problem or knows what maybe causing this problem pls help me.

Thanks again to every dev, moderator and user that has helped to create this community.

[mitfry]

@ dagred

IF you're sure that you have configured the server World and Realms well and forwarded ports also you should check on which address your realms are running in the realmlist table in Trinnrealm. that should be 127.0.01 aswell (if you play local) or otherwise your external IP.

Regards,


Mitch

[Urashima]

thank you, thank you, thank you, thank you mitfry

thank you for the help

but it not work, I'm probably doing it wrong

i am using navicat to export, to export i go in dump sql file and the file is saved as sql, and to import i go in Execute Batch File


I will describe how I'm doing

* 1 First i export the old database, i export char18.sql is the name of my old database

* 2 After i open the char18.sql with a text editor notepad

* 3 Then i do what you say and i did like this

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------

-- ----------------------------
-- Table structure for arena_team
-- ----------------------------

-- ----------------------------
-- Table structure for arena_team_member
-- ----------------------------

-- ----------------------------
-- Table structure for arena_team_stats
-- ----------------------------

-- ----------------------------
-- Table structure for auctionhouse
-- ----------------------------

-- ----------------------------
-- Table structure for auctionhousebot
-- ----------------------------

or i need to put SET FOREIGN_KEY_CHECKS=0; inside the lines

------------------------------------
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------

* 4 Then i import the old char18.sql into char322a, and i get some errors, but i put to ignore it to complete otherwise this will no complete

* 5 But i realized that my character not appear after login in trinity, then i quit emulator and wow, and i go to navicat in char322 database and table characters and characters table the id of my character is 6,
then i go to realmd322 database and account table i put id 6,
after that i started trinity againg and enter in wow, i did the login and i got it to enter, my character appear in the screen of creation of characters and i click in enter the world, after the loading in the end i get the desconected from the server

perhapes i need to modify something inside the realmd322 database too or not ?????????????

i don´t know what to do


and thank you very much to help me

[homiebrah]

2009-12-21 16:57:11 ERROR: SQL: UPDATE version SET core_version = 'TrinityCore2 Rev: Archive Release Hash: 61f9deb27ed0 (Win32,little-endian)', core_revision = 'Archive'
2009-12-21 16:57:11 ERROR: SQL ERROR: Table 'world.version' doesn't exist
2009-12-21 16:57:11 
2009-12-21 16:57:11 Loading Trinity strings...
2009-12-21 16:57:11 ERROR: SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM trinity_string
2009-12-21 16:57:11 ERROR: query ERROR: Table 'world.trinity_string' doesn't exist
2009-12-21 16:57:11 
2009-12-21 16:57:11 ERROR: >> Loaded 0 trinity strings. DB table `trinity_string` is empty. Cannot continue.

Anyone getting something similar to this and can provide assistance?

Using the ytdb527_trin6676_fun.sql.

ETA: Resolved problem.

[dagreg]

Thx for the reply mitch.

I just corrected some things and now I am able to enter the server. Thing is that now it stays on connected and nothing happens.
http://img20.imageshack.us/i/connectedj.png/

Ports 3724, 3306 and 8085 are all open and being forwarded. Tested on http://www.canyouseeme.org/.

Hope someone knows how to fix this.

Thanks again for your help.

[dagreg]

OK I restarted everything and now I can connect and play in my own server. My only problem now is that other people can't connect to my server.

Thx for ur help