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

[marko94]

fix Teleport NPC please .... regards ...

---

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

[treetree]

.....

[ZomgEary]

fix Teleport NPC please .... regards ...

What's wrong with it?

[paulwantstoplay]

fix Teleport NPC please .... regards ...

Did you try it with a GM character? I think it only works for GM characters. I didn't try this out yet.
When I get back at home tonight I will try it out. On Falcon Wing there are two NPCs who say they're 'Teleport Dudes', but only for GMs. So I think it doesn't work for normal player characters.
A question from me: how can I change that text? I don't think normal player characters should see those lines of text. It must be somewhere in the database.

Everyone, thanks for the help I got until now. Lets keep this thread alive and kicking.

[Lordcrovax]

Hello to everyone, i'm a long timer wow users and emulator admin. I like very much this repack but i have problems with mediafire. Is so laggy and it just doesn't permit me to download the files. Any solution?alternative download mirrors?
Thanks again

[wjcb1975]

on my server all the tele npcs, when u click on them they ask you if you want to make this your home. then window opens saying accept or decline

[CthulhuFtagn]

Tree, I never said there was no support for the repack. Not sure where you go that idea from.



TeleNPC was removed because I wanted to keep this as blizzlike as possible.

[wowzero]

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.

[Calous]

Did you try it with a GM character? I think it only works for GM characters. I didn't try this out yet.
When I get back at home tonight I will try it out. On Falcon Wing there are two NPCs who say they're 'Teleport Dudes', but only for GMs. So I think it doesn't work for normal player characters.
A question from me: how can I change that text? I don't think normal player characters should see those lines of text. It must be somewhere in the database.

Everyone, thanks for the help I got until now. Lets keep this thread alive and kicking.

This is the only one I tested but it does not work with or without gm. I just offers to set the hearthstone.

teleport_issue..jpg

EDIT: RTM is too fast in answering!

[CthulhuFtagn]

Calous, read my previous post.

wowzero, inject this into your characters database:

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