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

Update Available:

Code:

MaNGOS updated to 10396
ScriptDev2 updated to 1785

CU_0008.zip (10.65 MB)

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

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

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

Originally Posted by 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..

Its always great to see people helping

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

Code:

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

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

Update Available:

Code:

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)

Yep, follow the directions.


Update Available:

Code:

ScriptDev2 updated to 1800

CU_0010.zip (10.65 MB)