-
Content count
115 -
Joined
-
Last visited
Posts posted by Mikrole
-
-
Patch accepted, Thanks.
-
Patch accepted, thanks.
-
Works fine on PTR but i'll let it test some QAs to be sure.
Patch Accepted, merged soon on live realms. Thanks! -
-- 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 -
Invalid.
-
-
Patch Accepted, merged soon to live realms.
-
-- 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.
-
Patch Accepted, merged soon on live realms.
-
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
@Mikrole: Ja es gibt noch Deutsche - Bist Dev aufn falschen RealmWarum Falscher Realm? Bin für MoP, WoD und Legion.
-
The NPC is already fixed.
-
Schön zusehen dass es noch aktive Deutsche hier gibt!
-
UPDATE `creature_template` SET `minlevel`='110',`maxlevel`='110' WHERE `entry`='47649'; UPDATE `creature_template` SET `unit_flags`='520' WHERE `entry`='47649';
Accepted, Thanks.
-
Hi, the issue was just about ExtendedCost. (old values for honor points). But thanks anyways!
-
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.
-
I'll check this.
The items: http://www.wowhead.com/item=143842/trashy http://www.wowhead.com/item=142531/crate-of-bobbers-squeaky-duck and http://www.wowhead.com/item=142532/crate-of-bobbers-murloc-head are from patches 7.1 and 7.1.5. They'll be added when Firestorm goes 7.1.5.1 person likes this -
Patch accepted, merged soon on live realm. Thanks!
-
On 8.2.2017 at 6:36 PM, Herculano said:Title: Grizzled Ben
Bugtracker Link:
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.
-
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.
-
Patch Accepted, merged soon on Live Realm. Thanks!
-
Patch Accepted, Merged soon on Live Realm. Thanks!
-
Patch accepted, merged soon to the live realm. Thanks.
1 person likes this -
Accepted, thanks.
-
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
in Declined
Posted
@Hearts