[Legendary Release] Elder Repack (previously TRM Repack) 3.3.2.11403 - 32 & 64 bit

**wowzero** · 02-03-10, 09:47 AM

Congratulations on the success of this new repack, I hope you are all well. My query is this, I wanted to know if there is any way to export the database that previously had in evoxlogon and evoxcharacter (TRM) for import to realmd and characters of (Elder Repack). Because when I try to export and import the new server I get errors when loading my pj in the game when you load the mangosd not.

mangos> SQL: SELECT FROM group_member WHERE groupId memberGuid = '1 '

query ERROR: Unknown column 'groupId' in 'field list'

SQL: SELECT spec, slot, character glyphs glyph FROM WHERE guid = '1 '

query ERROR: Unknown column 'slot' in 'field list'

Creature <Entry:90002> have 250,015 but have empty UNIT_NPC_FLAG_TRAINER trainer spell list.

**CthulhuFtagn** · 02-03-10, 10:03 AM

Calous, read my previous post.

wowzero, inject this into your characters database:

Code:

ALTER TABLE groups
  ADD COLUMN `groupId` int(11) unsigned NOT NULL FIRST;

UPDATE groups
  SET `groupId` = `leaderGuid`;

ALTER TABLE groups
  DROP PRIMARY KEY,
  ADD PRIMARY KEY (`groupId`),
  ADD UNIQUE KEY (`leaderGuid`);

ALTER TABLE group_member
  CHANGE COLUMN `leaderGuid` `groupId` int(11) unsigned NOT NULL;
  
ALTER TABLE `character_action` DROP PRIMARY KEY, ADD PRIMARY KEY(`guid`,`spec`,`button`);

DROP TABLE IF EXISTS `character_glyphs`;
CREATE TABLE `character_glyphs` (
  `guid` int(11) unsigned NOT NULL,
  `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `glyph` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`guid`,`spec`,`slot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Extract values from data blob fields and insert them into character_glyphs
INSERT INTO `character_glyphs` SELECT `guid`, 0, 0, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1319),  ' ', -1) AS UNSIGNED)) AS `glyph` FROM `characters`;
INSERT INTO `character_glyphs` SELECT `guid`, 0, 1, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1320),  ' ', -1) AS UNSIGNED)) AS `glyph` FROM `characters`;
INSERT INTO `character_glyphs` SELECT `guid`, 0, 2, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1321),  ' ', -1) AS UNSIGNED)) AS `glyph` FROM `characters`;
INSERT INTO `character_glyphs` SELECT `guid`, 0, 3, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1322),  ' ', -1) AS UNSIGNED)) AS `glyph` FROM `characters`;
INSERT INTO `character_glyphs` SELECT `guid`, 0, 4, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1323),  ' ', -1) AS UNSIGNED)) AS `glyph` FROM `characters`;
INSERT INTO `character_glyphs` SELECT `guid`, 0, 5, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1324),  ' ', -1) AS UNSIGNED)) AS `glyph` FROM `characters`;

DELETE FROM character_glyphs WHERE glyph = 0;

ALTER TABLE `character_action` ADD `spec` tinyint(3) unsigned NOT NULL default 0 AFTER `guid`;

**CthulhuFtagn** · 02-03-10, 10:13 AM

Inject into your elder database

Code:

DELETE FROM creature_template WHERE entry = "90002";
DELETE FROM creature WHERE id = "90002";

**Calous** · 02-03-10, 10:15 AM

Thank you sir!

**CthulhuFtagn** · 02-03-10, 10:16 AM

Not a problem.

**Absoluto** · 02-03-10, 11:57 AM

I will test it!

Tnx for share!

**oshey** · 02-03-10, 12:46 PM

Hi all

,
I have problem with RoSPORA V1.4.4.1 acc creation page:

Notice: Undefined offset: 1432 in C:\wamp\www\lang.php on line 1401

Notice: Undefined index: pending_honor in C:\wamp\www\lang.php on line 1401

Notice: Undefined index: character_data in C:\wamp\www\index.php on line 383

Notice: Undefined variable: data in C:\wamp\www\index.php on line 383

Any ideas?

Thanks a lot.

**wowzero** · 02-03-10, 12:46 PM

do not know if anyone would step but wanting to go more than 6 characters, at 7 tells you that this waiting, and so on. And the error that throws me is this.

SESSION: recived unexpected opcode DMSG_CANCEL_TRADE <0x011c> the player has not logged in yet and not recently logout

Someone can give me any suggestions?

Thank you very much in advance

**viking_** · 02-03-10, 02:22 PM

Originally Posted by wowzero

do not know if anyone would step but wanting to go more than 6 characters, at 7 tells you that this waiting, and so on. And the error that throws me is this.

SESSION: recived unexpected opcode DMSG_CANCEL_TRADE <0x011c> the player has not logged in yet and not recently logout

Someone can give me any suggestions?

Thank you very much in advance

Change PlayerLimit = 5 in mangosd.conf