[Release] TRM's Cthulhu Ftagn Dual-Database MaNGOS Repack (3.3.5.12340) - 32 & 64-bit

[Avidgamer]

Extremely good as always, keep up the good work mate.

[Abyss]

I'm here again to help out again to fix the little problems I find on here
Trying to make it more Blizzlike, anyways I found that the player-like NPCs in Dalaran didn't have the correct plain Alliance or Horde faction ID, so I changed em..

Horde Code

UPDATE `creature_template` SET `faction_A` = 1801, `faction_H` = 1801 WHERE `entry` = 32697; 
UPDATE `creature_template` SET `faction_A` = 1801, `faction_H` = 1801 WHERE `entry` = 32702; 
UPDATE `creature_template` SET `faction_A` = 1801, `faction_H` = 1801 WHERE `entry` = 32709;
UPDATE `creature_template` SET `faction_A` = 1801, `faction_H` = 1801 WHERE `entry` = 32719;

Alliance Code

UPDATE `creature_template` SET `faction_A` = 1802, `faction_H` = 1802 WHERE `entry` = 32695;  
UPDATE `creature_template` SET `faction_A` = 1802, `faction_H` = 1802 WHERE `entry` = 32700; 
UPDATE `creature_template` SET `faction_A` = 1802, `faction_H` = 1802 WHERE `entry` = 32708;
UPDATE `creature_template` SET `faction_A` = 1802, `faction_H` = 1802 WHERE `entry` = 32716;
UPDATE `creature_template` SET `faction_A` = 1802, `faction_H` = 1802 WHERE `entry` = 32720;
UPDATE `creature_template` SET `faction_A` = 1802, `faction_H` = 1802 WHERE `entry` = 32712

EDIT: All of the Player-like NPCs are supposed to patroll around Dalaran, entering shops and what not. I'll begin work on this paths today, post when I'm done , peace.

Regards,
Abyss

[Dimman]

I'm here again to help out again to fix the little problems I find on here
Trying to make it more Blizzlike, anyways I found that the player-like NPCs in Dalaran didn't have the correct plain Alliance or Horde faction ID, so I changed em..

Its always great to see people helping

[Abyss]

This is a SQL to make Drog Skullbreaker patroll around Dalaran.
He will visit a shop and chat it up with a few ladies.

UPDATE `creature` SET `movementtype` = '2' WHERE `guid` = '88642';
REPLACE INTO `creature_movement` (`id`, `point`, `position_X`, `position_Y`, `position_Z`, `waittime`, `emote`) VALUES 
('88642', '1', '5910.47', '648.23', '644.24', '0', '0'),
('88642', '2', '5906.45', '659.24', '643.80', '0', '0'),
('88642', '3', '5909.55', '661.96', '643.78', '0', '0'),
('88642', '4', '5914.57', '667.16', '643.50', '0', '0'),
('88642', '5', '5916.58', '665.38', '643.50', '0', '0'),
('88642', '6', '5906.72', '675.19', '643.50', '90000', '234'),
('88642', '7', '5911.11', '677.38', '643.50', '0', '0'),
('88642', '8', '5901.10', '684.66', '643.58', '0', '0'),
('88642', '9', '5894.92', '689.41', '642.03', '0', '0'),
('88642', '10', '5868.46', '653.60', '645.65', '0', '0'),
('88642', '11', '5863.92', '660.02', '645.65', '0', '0'),
('88642', '12', '5857.29', '666.49', '647.51', '0', '0'),
('88642', '13', '5849.77', '660.37', '647.51', '0', '0'),
('88642', '14', '5851.80', '641.05', '647.51', '0', '0'),
('88642', '15', '5848.23', '636.50', '647.51', '25000', '378'),
('88642', '16', '5855.41', '637.12', '647.51', '0', '0'),
('88642', '17', '5867.15', '631.21', '647.67', '0', '0'),
('88642', '18', '5893.75', '641.69', '646.04', '0', '0'),
('88642', '19', '5907.88', '631.23', '646.05', '0', '0'),
('88642', '20', '5906.09', '628.48', '646.47', '5000', '24'),
('88642', '21', '5911.80', '638.14', '645.31', '0', '0')

I will work on the others on my spare, I am going on a trip out of state in the morning, but I will work on it during the slow points of the vacation and will release my progress when I return.

See you in a week MMOpro,
Abyss

[CthulhuFtagn]

Thanks Abyss, I'll put this into the next update. I'll add the two semi-colons that you forgot

Update Available:

MaNGOS updated to 10403 (required_10400_01_mangos_mangos_string)
ScriptDev2 updated to 1795
Dalaran NPC update by Abyss

CU_0009.zip (10.65 MB)

[GrandpaJohn]

@TRM:
update 0009 executed flawlessly, as expected your work is well appreciated keep it up.

[CthulhuFtagn]

Yep, follow the directions.


Update Available:

ScriptDev2 updated to 1800

CU_0010.zip (10.65 MB)

[hertslad]

i started form scratch it works but how do i upgrade it i might sound a noob but upgradeing is new to me when i did it the first time i think i did it wrong thx for getting back to me so fast

[CthulhuFtagn]

Tutorial Post

[GrandpaJohn]

@TRM:
on update 0010 had a problem with mangos, unsecessful(to use near 'UPDATE creature_template SET ScriptName='npc_kroshius' WHERE entry=14467' at line 3
[Err] UPDATE gameobject_template SET ScriptName='go_scourge_enclosure' WHERE entry=191548

UPDATE creature_template SET ScriptName='npc_kroshius' WHERE entry=14467;
[Msg] Finished - Unsuccessfully),

scripdev2 went in sucessful no problem