Guys, din pacate ramanem fara hosting moca la forum :( As dori sa tinem forumul in picioare, eventual sa-l "resuscitam". Rog sa donati 1 euro, sau cat puteti, sa ne luam hosting.

Alte metode de a ajuta: cand cumparati ceva de pe EMAG, dati click pe orice produs de aici.. E echivalentul unei mici donatii.
Also, la PcGarage.ro aplicati codul "3L6L3REE" in cos (1% reducere). pentru alte magazine, click pe LOGO de aici: elefant.ro, CEL.ro, evoMAG.ro , QuickMobile.ro sau cautati magazinul aici. Thanks!

Ultimate Queries

Topicuri inchise / vechi / care incalca regulile forumului.

Re: Ultimate new blabla

Postby ZenitH » 09 Feb 2011, 11:53

Global Skinning Problem Fix :

Code: Select all
UPDATE creature_template SET skinloot=entry WHERE skinloot!=0;


//updated
Image
User avatar
ZenitH
[Ultimate Spammer]
[Ultimate Spammer]
 
Posts: 1111
Joined: 02 Aug 2010, 13:04
Location: Psi Realms

Re: Ultimate new blabla

Postby ZenitH » 09 Feb 2011, 21:57

Battered Hilt + Frozen Halls FULL FIXES !

Echoes of Tortured Souls
Code: Select all
INSERT INTO `world`.`creature_involvedrelation` (`id`, `quest`) VALUES ('38161', '24511');


Crucible of Souls
Code: Select all
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(37094, 49750, -100, 1, 0, 1, 1);


Code: Select all
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
(37094, 3709401, 0, 0, 0, 0, 28988, 28988, 28988, 0, 'Crucible of Souls', '', '', 0, 80, 80, 2, 31, 31, 0, 1, 1.14286, 1, 0, 420, 630, 0, 642, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 0, 37094, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 2.35867, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 2, '', 11723),
(3709401, 0, 0, 0, 0, 0, 28988, 28988, 28988, 0, 'Crucible of Souls', 'Quel''Delar Temperer', NULL, 0, 80, 80, 2, 31, 31, 0, 1, 1.14286, 1, 0, 420, 630, 0, 642, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 0, 3709401, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 6.35867, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 2, '', 11723);


Subdued Quel'Delar

Code: Select all
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
(37158, 13004, 0, 0, 0, 0, 30547, 30547, 30547, 0, 'Quel''Delar', '', '', 0, 80, 80, 2, 31, 31, 0, 1, 1.14286, 1, 1, 422, 586, 0, 642, 7.5, 0, 0, 1, 0, 8, 0, 0, 0, 0, 0, 345, 509, 103, 10, 0, 37158, 0, 0, 0, 0, 0, 0, 0, 0, 67541, 29426, 16856, 67716, 0, 0, 0, 0, 0, 0, 0, 0, 'EventAI', 0, 3, 5, 5, 1, 0, 50254, 0, 0, 0, 0, 0, 0, 1, 205, 1, 2, '', 12340);

Thalorien Dawnseeker

Code: Select all
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES
(201718, 10, 9209, 'Thalorien Dawnseeker''s Remains', '', '', '', 0, 0, 1.15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 185579, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 11723);


Battered Hilt Alliance/Horde - Horde/Alliance switch quests @ Dash.

Code: Select all
INSERT INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClassMask`, `MinLevel`, `MaxLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RepObjectiveFaction2`, `RepObjectiveValue2`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `RewardArenaPoints`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `unk0`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES
(250000, 2, 0, 0, 80, 0, 80, 0, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Battered Hilt Exchange', 'Adu-mi un Battered Hilt de la Alianta si ti-l voi prescrie intr-unul de Hoarda !', 'Adu-mi un Battered Hilt de la Alianta si ti-l voi prescrie intr-unul de Hoarda !', 'Adu-mi un Battered Hilt de la Alianta si ti-l voi prescrie intr-unul de Hoarda !', 'Adu-mi un Battered Hilt de la Alianta si ti-l voi prescrie intr-unul de Hoarda !', 'Adu-mi un Battered Hilt de la Alianta si ti-l voi prescrie intr-unul de Hoarda !', 'Adu-mi un Battered Hilt de la Alianta si ti-l voi prescrie intr-unul de Hoarda !', 'Adu-mi un Battered Hilt de la Alianta si ti-l voi prescrie intr-unul de Hoarda ! ', NULL, NULL, NULL, 50379, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 50379, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(250001, 2, 0, 0, 80, 0, 80, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Battered Hilt Exchange', 'Adu-mi un Battered Hilt de la Hoarda si ti-l voi prescrie intr-unul de Alianta !', 'Adu-mi un Battered Hilt de la Hoarda si ti-l voi prescrie intr-unul de Alianta !', 'Adu-mi un Battered Hilt de la Hoarda si ti-l voi prescrie intr-unul de Alianta !', 'Adu-mi un Battered Hilt de la Hoarda si ti-l voi prescrie intr-unul de Alianta !', 'Adu-mi un Battered Hilt de la Hoarda si ti-l voi prescrie intr-unul de Alianta !', 'Adu-mi un Battered Hilt de la Hoarda si ti-l voi prescrie intr-unul de Alianta !', 'Adu-mi un Battered Hilt de la Hoarda si ti-l voi prescrie intr-unul de Alianta !', NULL, NULL, NULL, 50380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 50380, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50379, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
Image
User avatar
ZenitH
[Ultimate Spammer]
[Ultimate Spammer]
 
Posts: 1111
Joined: 02 Aug 2010, 13:04
Location: Psi Realms

Re: Ultimate new blabla

Postby ZenitH » 11 Feb 2011, 17:53

Puneti orice query UTIL executati in db aici ! Veti regreta mai tarziu ca nu le-ati salvat
Image
User avatar
ZenitH
[Ultimate Spammer]
[Ultimate Spammer]
 
Posts: 1111
Joined: 02 Aug 2010, 13:04
Location: Psi Realms

Re: Ultimate Queries

Postby Annaa » 30 Jun 2011, 16:31

Code: Select all
INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
(-50294, 'spell_dru_starfall_aoe'),
(-55428, 'spell_gen_lifeblood'),
( 65917, 'spell_gen_magic_rooster'),
( -2818, 'spell_rog_deadly_poison'),
( 28441, 'spell_item_ashbringer'),
( 64381, 'spell_auriaya_strenght_of_the_pack'),
( 64679, 'spell_auriaya_sentinel_blast'),
( 64392, 'spell_auriaya_sentinel_blast'),
(63018, 'spell_xt002_searing_light_spawn_life_spark'),
( 65121, 'spell_xt002_searing_light_spawn_life_spark'),
( 64234, 'spell_xt002_gravity_bomb_aura'),
( 63024, 'spell_xt002_gravity_bomb_aura'),
( 64233, 'spell_xt002_gravity_bomb_damage'),
( 63025, 'spell_xt002_gravity_bomb_damage'),
( 62791, 'spell_xt002_heart_overload_periodic'),
( 62775, 'spell_xt002_tympanic_tantrum'),
( 37751, 'spell_xt002_submerged'),
( 37752, 'spell_xt002_stand'),
(63720, 'spell_kologarn_stone_shout'),
(64004, 'spell_kologarn_stone_shout'),
( 72868, 'spell_putricide_slime_puddle_aura'),
( 72869, 'spell_putricide_slime_puddle_aura'),
( 71085, 'spell_dreamwalker_mana_void'),
( 70915, 'spell_dreamwalker_decay_periodic_timer'),
( 70912, 'spell_dreamwalker_decay_periodic_timer'),
( 70916, 'spell_dreamwalker_decay_periodic_timer'),
( 70913, 'spell_dreamwalker_decay_periodic_timer'),
( 70921, 'spell_dreamwalker_summoner'),
( 70912, 'spell_dreamwalker_summon_suppresser'),
( 71032, 'spell_dreamwalker_summoner'),
( 71078, 'spell_dreamwalker_summoner'),
( 70933, 'spell_dreamwalker_summoner'),
( 72224, 'spell_dreamwalker_summon_dream_portal'),
( 72480, 'spell_dreamwalker_summon_nightmare_portal'),
( 71970, 'spell_dreamwalker_nightmare_cloud'),
( 70078, 'spell_svalna_caress_of_death'),
( 70053, 'spell_svalna_revive_champion'),
( 71462, 'spell_svalna_remove_spear');


INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES
(5541,11,0,0,'achievement_arena_2v2_kills'),
(5542,11,0,0,'achievement_arena_3v3_kills'),
(5543,11,0,0,'achievement_arena_5v5_kills'),
(7583,11,0,0,'achievement_share_the_love'),
(7317,11,0,0,'achievement_respect_your_elders'),
(4240,11,0,0,'achievement_watch_him_die'),
(7265,11,0,0,'achievement_momma_said_knock_you_out'),
(7549,11,0,0,'achievement_momma_said_knock_you_out'),
(7264,11,0,0,'achievement_safety_dance'),
(7548,11,0,0,'achievement_safety_dance'),
(7316,11,0,0,'achievement_chaos_theory'),
(7573,11,0,0,'achievement_denyin_the_scion'),
(7574,11,0,0,'achievement_denyin_the_scion'),
(10068,11,0,0,'achievement_ignis_shattered'),
(10069,11,0,0,'achievement_ignis_shattered'),
(10173,11,0,0,'achievement_shadowdodger'),
(10306,11,0,0,'achievement_shadowdodger'),
(10451,11,0,0,'achievement_smell_saronite'),
(10462,11,0,0,'achievement_smell_saronite'),
(10447,11,0,0,'achievement_knock_on_wood'),
(10448,11,0,0,'achievement_knock_knock_on_wood'),
(10449,11,0,0,'achievement_knock_knock_knock_on_wood'),
(10459,11,0,0,'achievement_knock_on_wood'),
(10460,11,0,0,'achievement_knock_knock_on_wood'),
(10461,11,0,0,'achievement_knock_knock_knock_on_wood'),
(10445,11,0,0,'achievement_getting_back_to_nature'),
(10758,11,0,0,'achievement_getting_back_to_nature'),
(7318,11,0,0,'achievement_king_dred'),
(7598,11,0,0,'achievement_kings_bane'),
(7587,11,0,0,'achievement_void_dance'),
(12978,11,0,0,'achievement_portal_jockey'),
(12979,11,0,0,'achievement_portal_jockey'),
(12971,11,0,0,'achievement_portal_jockey'),
(12980,11,0,0,'achievement_portal_jockey')

UPDATE `creature_template` SET `ScriptName`='npc_feral_defender' WHERE `entry`=34035;
UPDATE `creature_template` SET `ScriptName`='npc_sanctum_sentry' WHERE `entry`=34014;
UPDATE `creature_template` SET `ScriptName`='npc_auriaya_seeping_trigger' WHERE `entry` =34098;
UPDATE `creature_template` SET `ScriptName`='npc_hodir_priest' WHERE `entry` IN (32897,33326,32948,33330);
UPDATE `creature_template` SET `ScriptName`='npc_hodir_shaman' WHERE `entry` IN (33328,32901,33332,32950);
UPDATE `creature_template` SET `ScriptName`='npc_hodir_druid' WHERE `entry` IN (33325,32900,32941,33333);
UPDATE `creature_template` SET `ScriptName`='npc_hodir_mage' WHERE `entry` IN (32893,33327,33331,32946);
UPDATE `creature_template` SET `ScriptName`='npc_toasty_fire' WHERE `entry`=33342;
UPDATE `creature_template` SET `ScriptName`='npc_flash_freeze' WHERE `entry`=32926;
UPDATE `creature_template` SET `ScriptName`='npc_icicle' WHERE `entry` IN (33169,33173);
UPDATE `creature_template` SET `ScriptName`='npc_snowpacked_icicle' WHERE `entry`=33174;
UPDATE `creature_template` SET `ScriptName`='npc_ice_block' WHERE `entry`=32938;
UPDATE `creature_template` SET `ScriptName`='boss_hodir' WHERE `entry`=32845;
UPDATE `creature_template` SET `ScriptName`='boss_freya' WHERE `entry`=32906;
UPDATE `creature_template` SET `ScriptName`='boss_elder_brightleaf' WHERE `entry`=32915;
UPDATE `creature_template` SET `ScriptName`='boss_elder_ironbranch' WHERE `entry`=32913;
UPDATE `creature_template` SET `ScriptName`='boss_elder_stonebark' WHERE `entry`=32914;
UPDATE `creature_template` SET `ScriptName`='npc_ancient_conservator' WHERE `entry`=33203;
UPDATE `creature_template` SET `ScriptName`='npc_snaplasher' WHERE `entry`=32916;
UPDATE `creature_template` SET `ScriptName`='npc_storm_lasher' WHERE `entry`=32919;
UPDATE `creature_template` SET `ScriptName`='npc_ancient_water_spirit' WHERE `entry`=33202;
UPDATE `creature_template` SET `ScriptName`='npc_detonating_lasher' WHERE `entry`=32918;
UPDATE `creature_template` SET `ScriptName`='npc_sun_beam' WHERE `entry`=33170;
UPDATE `creature_template` SET `ScriptName`='npc_nature_bomb' WHERE `entry`=34129;
UPDATE `creature_template` SET `ScriptName`='npc_eonars_gift' WHERE `entry`=33228;
UPDATE `creature_template` SET `ScriptName`='npc_healthy_spore' WHERE `entry`=33215;
UPDATE `creature_template` SET `ScriptName`='npc_unstable_sun_beam' WHERE `entry`=33050;
UPDATE `creature_template` SET `ScriptName`='npc_iron_roots' WHERE `entry` IN (33088,33168);
UPDATE `creature_template` SET `ScriptName`='boss_valithria_dreamwalker' WHERE `entry`=36789;
UPDATE `creature_template` SET `ScriptName`='npc_green_dragon_combat_trigger' WHERE `entry`=38752;
UPDATE `creature_template` SET `ScriptName`='npc_the_lich_king_controller' WHERE `entry`=16980;
UPDATE `creature_template` SET `ScriptName`='npc_risen_archmage' WHERE `entry`=37868;
UPDATE `creature_template` SET `ScriptName`='npc_blazing_skeleton' WHERE `entry`=36791;
UPDATE `creature_template` SET `ScriptName`='npc_suppresser' WHERE `entry`=37863;
UPDATE `creature_template` SET `ScriptName`='npc_blistering_zombie' WHERE `entry`=37934;
UPDATE `creature_template` SET `ScriptName`='npc_gluttonous_abomination' WHERE `entry`=37886;
UPDATE `creature_template` SET `ScriptName`='npc_dream_portal' WHERE `entry` IN (37945,38430);
UPDATE `creature_template` SET `ScriptName`='npc_dream_cloud' WHERE `entry` IN (37985,38421);
UPDATE `creature_template` SET `ScriptName`='boss_sister_svalna' WHERE `entry`=37126;
UPDATE `creature_template` SET `ScriptName`='npc_crok_scourgebane' WHERE `entry`=37129;
UPDATE `creature_template` SET `ScriptName`='npc_captain_arnath' WHERE `entry`=37122;
UPDATE `creature_template` SET `ScriptName`='npc_captain_brandon' WHERE `entry`=37123;
UPDATE `creature_template` SET `ScriptName`='npc_captain_grondel' WHERE `entry`=37124;
UPDATE `creature_template` SET `ScriptName`='npc_captain_rupert' WHERE `entry`=37125;
UPDATE `creature_template` SET `ScriptName`='npc_frostwing_vrykul' WHERE `entry` IN (37132,38125,37127,37134,37133);
UPDATE `creature_template` SET `ScriptName`='npc_impaling_spear' WHERE `entry`=38248;


INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES
(5616,'at_icc_start_frostwing_gauntlet'),
(5617,'at_icc_start_frostwing_gauntlet'),
(5618,'at_icc_start_frostwing_gauntlet');

Missing scripts_name.

Code: Select all
UPDATE `wotlk_world`.`spell_bonus_data` SET `dot_bonus` = '0.18' WHERE `spell_bonus_data`.`entry` =2944;

Devouring Plague coeff.

Code: Select all
UPDATE gameobject SET spawntimesecs =15 WHERE id =1618
UPDATE gameobject SET spawntimesecs =15 WHERE id =1617
UPDATE gameobject SET spawntimesecs =15 WHERE id =1619
UPDATE gameobject SET spawntimesecs =15 WHERE id =1620
UPDATE gameobject SET spawntimesecs =15 WHERE id =1621
UPDATE gameobject SET spawntimesecs=15 WHERE id=1622
UPDATE gameobject SET spawntimesecs =15 WHERE id =2045
UPDATE gameobject SET spawntimesecs=15 WHERE id=1628
UPDATE gameobject SET spawntimesecs=15 WHERE id=1623
UPDATE gameobject SET spawntimesecs =15 WHERE id =1624

Am modificat putin spawn time la unele plante.
You're unique. Just like everyone else.
User avatar
Annaa
[Ultimate Member]
[Ultimate Member]
 
Posts: 110
Joined: 06 Mar 2009, 00:03
Location: Bucuresti

Re: Ultimate Queries

Postby Annaa » 30 Jun 2011, 16:35

Code: Select all
INSERT INTO `wotlk_world`.`creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('26338', '35723', '50', '1', '0', '1', '1'), ('26338', '54536', '50', '1', '0', '1', '1'), ('26338', '35557', '0', '1', '1', '1', '2'), ('26338', '54805', '0', '1', '1', '1', '1'), ('26338', '54803', '0', '1', '1', '1', '1'), ('26338', '54802', '0', '1', '1', '1', '1'), ('26338', '54804', '0', '1', '2', '1', '1'), ('26338', '54801', '0', '1', '2', '1', '1'), ('26338', '35498', '0', '1', '2', '1', '1'), ('26338', '35720', '0', '1', '2', '1', '6');

INSERT INTO `wotlk_world`.`creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES ('25740', '35723', '50', '1', '0', '1', '1'), ('25740', '54536', '50', '1', '0', '1', '1'), ('25740', '35557', '0', '1', '1', '1', '2'), ('25740', '54805', '0', '1', '1', '1', '1'), ('25740', '54803', '0', '1', '1', '1', '1'), ('25740', '54802', '0', '1', '1', '1', '1'), ('25740', '54804', '0', '1', '2', '1', '1'), ('25740', '54801', '0', '1', '2', '1', '1'), ('25740', '35498', '0', '1', '2', '1', '1'), ('25740, '35720', '0', '1', '2', '1', '6');

Loot Ahune pe hc/normal.

Code: Select all
UPDATE `wotlk_world`.`creature_template` SET `faction_A` = '14',
`faction_H` = '14' WHERE `creature_template`.`entry` =30890;
UPDATE `wotlk_world`.`creature_template` SET `faction_A` = '14',
`faction_H` = '14' WHERE `creature_template`.`entry` =31540;

Faction Twilight whelps(OS) pe normal si hc.

+Prospecting loot, damaged necklace loot, book of glyph mastery loot si random quests, dar nu am query pentru ele sau sunt prea lungi.


Code: Select all
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
('46924', '-13810', '2', 'Bladestorm immune at Frost Trap'),
('46924', '-51514', '2', 'Bladestorm immune at Hex'),
('46924', '-116', '2', 'Bladestorm immune at FrostBolt'),
('46924', '-45524', '2', 'Bladestorm immune at Chains of Ice'),
('46924', '-68766', '2', 'Bladestorm immune at Desecration'),
('46924', '-58617', '2', 'Bladestorm immune at Glyph of Heart Strike');

Slow in Bladestorm.



+Infusion of light fixed.
You're unique. Just like everyone else.
User avatar
Annaa
[Ultimate Member]
[Ultimate Member]
 
Posts: 110
Joined: 06 Mar 2009, 00:03
Location: Bucuresti

Previous

Return to Trash

Who is online

Users browsing this forum: Majestic-12 [Bot], valentiores and 10 guests