Mikrole

Members
 View profile  See their activity

  • Content count

    115

  • Joined

  • Last visited

Posts posted by Mikrole

  5. Posted 

    -- Making the NPC a vehicle
UPDATE `creature_template` SET `VehicleId`='2273' WHERE  `entry`=62809;
DELETE FROM `creature_template_addon` WHERE `entry` IN (62821,62822);
-- Adding aruas of that parasol? for the NPCs 
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
(62821, 0, 0, 0, 0, 0, 0, 0, 0, '123236'),
(62822, 0, 0, 0, 0, 0, 0, 0, 0, '123240');
-- Making the vehicle (NPC) moutable by other players on click
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=62809;
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
(62809, 122729, 1, 0);
-- Adding the vendors to thier proper seats
DELETE FROM `vehicle_template_accessory` WHERE `entryoraura`=62809;
INSERT INTO `vehicle_template_accessory` (`entryoraura`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES
(62809, 62821, 0, 1, 'Grand Expedition Yak - Transmogrifier',   6, 30000),
(62809, 62822, 1, 1, 'Grand Expedition Yak - Traveling Trader', 6, 30000);

    Needed little corrections but so far the patch is correct, Patch accepted and merged soon into live realm.

    1 person likes this

  9. Posted 

    -- set creature smartAI
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`='41360';

-- SAI
DELETE FROM `smart_scripts` WHERE `entryorguid`='41360';
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
('41360', '0', '0', '0', '8', '0', '100', '0', '78336', '0', '60000', '60000', '33', '41360', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On Spell Hit - Give Quest Credit Jinzils Blessing');

    Patch Accepted, merged soon on live realms.

  11. Posted

    On 14.5.2017 at 2:45 AM, Eisenpanda said:

    Die Gilde Soulbound ist auch als Deutsche Gilde bekannt. 
    Wir laufen regelmäßig Dungeons(NHC/HC/Myth), Raid (7/7 Emerald Nightmare) und laufen gerne des öfteren PvP :)
    Wir haben keine Altereinschränkung, allerdings sollte man ein wenig benehmen mitbringen :D

    @Mikrole: Ja es gibt noch Deutsche :D - Bist Dev aufn falschen Realm :P

    Warum Falscher Realm? Bin für MoP, WoD und Legion. ;)

  16. Posted 

    DELETE FROM `npc_trainer` WHERE ID ='3404';

    entry, not ID.
      

    INSERT INTO `npc_trainer` (`entry`, `Spell`, `Spellcost`,  `ReqSkillValue`, `ReqLevel`) VALUES
('3404', '2366', '10', '0', '1'),
('3404', '2368', '500', '50', '1'),
('3404', '3570', '5000', '125', '1'),
('3404', '11993', '50000', '200', '1'),
('3404', '28695', '100000', '275', '1'),
('3404', '50300', '350000', '350', '1'),
('3404', '74519', '500000', '425', '1'),
('3404', '110413', '600000', '500', '1');

    reqskill is missing. Correct would be :
      

    INSERT INTO `npc_trainer` (`entry`, `Spell`, `Spellcost`,  `reqskill`, `ReqSkillValue`, `ReqLevel`) VALUES
('3404', '2366', '10', '182', '0', '1'),
('3404', '2368', '500', '182', '50', '1'),
('3404', '3570', '5000', '182', '125', '1'),
('3404', '11993', '50000', '182', '200', '1'),
('3404', '28695', '100000', '182', '275', '1'),
('3404', '50300', '350000', '182', '350', '1'),
('3404', '74519', '500000', '182', '425', '1'),
('3404', '110413', '600000', '182', '500', '1');

    But anyways, seems like theres also another problem on this NPC which blocks it's gossip.

  19. Posted

    On 8.2.2017 at 6:36 PM, Herculano said:

    Title: Grizzled Ben
    Bugtracker Link:

    https://firestorm-servers.com/es/report/see_report/30660


    Patch Content:

      

    
-- Grizzled Ben
-- http://www.wowhead.com/npc=50926
UPDATE `creature_template` SET type_flags ='65537' WHERE entry='50926';
SET @CGUID := xxxxxx;

DELETE FROM `creature` WHERE `guid`=@CGUID;

INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID, 50926, 0, 12, 60, 1, 1, 0, 0, 0, -9501.841, 587.4207, 52.40701, 4.33007, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420);

DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
(@CGUID, 0, 0, 3, 0, 0, '');

     

     

    Most Rare NPC's which got added between 5.1 and 5.4 aren't spawned, indeed. But also they got issues with their model. I will look into this.

  20. Posted

    groupid and mincountOrRef is missing, also itemBonuses is wrong spelled.

    Corrected:
      

    DELETE FROM `skinning_loot_template` WHERE `entry`='74508';
INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itemBonuses`) VALUES
('74508', '4235', '56', '1', '0', '1', '1',''),
('74508', '4234', '54', '1', '0', '2', '3',''),
('74508', '2318', '27', '1', '0', '1', '2',''),
('74508', '2319', '7', '1', '0', '1', '2',''),
('74508', '783', '1.8', '1', '0', '1', '1',''),
('74508', '2934', '0.9', '1', '0', '1', '2','');
UPDATE `creature_template` SET `skinloot`='74508' WHERE `entry`='74508';

    Patch Accepted, merged soon on live realm. Thank you.

  25. Posted

    Hello! ofcourse you can help with translations. This stuff get done by the programming language SQL which is used for the database.
    There are tables for locales, like locales_quest, locales_creature and so on.. 
    for an NPC like http://www.wowhead.com/npc=58225/instructor-tong you have to use locales_creature
      

    UPDATE `locales_creature` SET `name_loc10`='Istruttore Tong' WHERE `entry`='58225';

    But there are also NPCs with subnames like http://www.wowhead.com/npc=22917/illidan-stormrage <The Betrayer>
      

    UPDATE `locales_creature` SET `name_loc10`='Illidan Grantempesta',`subname_loc10`='Il Traditore' WHERE `entry`='22917';

    Objects are simple. Like http://www.wowhead.com/object=216314
      

    UPDATE `locales_gameobject` SET `name_loc10`='Barile di Carburante "Distillato"' WHERE `entry`='216314';

    About Quests, at the moment you cant, atleast you cant use the informations from wowhead cause on all their languages there are the quests in english. But heres a lil "empty" patch:
      

    UPDATE `locales_quest` SET 
`Title_loc10`='',
`Details_loc10`='',
`Objectives_loc10`='',
`CompletedText_loc10`=''
WHERE `entry`='';

    If you've done a patch, feel free to post it here: http://us.forum.firestorm-servers.com/index.php?/forum/15-submit-a-patch/
    Or if you have more Questions about it, write me a private messege, i'll try to explain everything about it. :)

    1 person likes this