Ultimate Queries

Topicuri inchise / vechi / care incalca regulile forumului.

Re: Ultimate new blabla

Postby Vladymirov » 31 Jan 2011, 18:19

[15:17:09] Vladymirov: am modificat learn all gm
[15:17:13] Vladymirov: la rank 5


UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'cast back';



UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'cast dist';

UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'cast self';

UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'cast target';

UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'cast';

UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'damage';



UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'learn all my talents';

UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'learn all my spells';

UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'learn all my pettalents';

UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'learn all my class';

UPDATE `world`.`command` SET `security` = '5' WHERE `command`.`name` = 'learn all';




UPDATE `world`.`command` SET `security` = '4' WHERE `command`.`name` = 'possess';

UPDATE `world`.`command` SET `security` = '4' WHERE `command`.`name` = 'reload all';
Image

-P.S.T *Professional Spamming Team* Owner-
User avatar
Vladymirov
[ Pwnage!!! ]
[ Pwnage!!! ]
 
Posts: 4099
Joined: 26 May 2008, 11:11
Location: Bucuresti/Ploiesti

Re: Ultimate new blabla

Postby Juhziz » 31 Jan 2011, 21:20

Skinning Loot Template - L-am pus pe cel din vechiul db. Nu pot sa postez query-ul ca e prea lung.( oricum merge cum trebuie )
Pentru toate fetele care spun: "Toţi bărbaţii sunt la fel".
Dacă ai fi fost o fată cuminte, nu ai fi cunoscut toţi bărbaţii...

-Away-
User avatar
Juhziz
[Most Valuable Player]
[Most Valuable Player]
 
Posts: 5498
Joined: 29 Aug 2009, 17:21
Location: Destination Unknown

Re: Ultimate new blabla

Postby Vladymirov » 02 Feb 2011, 02:16

UPDATE `world`.`quest_template` SET `RewRepFaction1` = '0' WHERE `quest_template`.`entry` =24876;

UPDATE `world`.`quest_template` SET `RewRepFaction1` = '0' WHERE `quest_template`.`entry` =24871;

UPDATE `world`.`quest_template` SET `RewRepFaction1` = '0' WHERE `quest_template`.`entry` =24870;

UPDATE `world`.`quest_template` SET `RewRepFaction1` = '0' WHERE `quest_template`.`entry` =24877;


-scos ashen rep de la Securing the Ramparts'
-fos/pos faction bugs fixed
-random world mobs fixed
-ulduar faction change and fixed random mobs + phasemask fixed, -masinutze fixed
(pana la xt totul e ok, apoi no scripts bosi/loot etc)
Image

-P.S.T *Professional Spamming Team* Owner-
User avatar
Vladymirov
[ Pwnage!!! ]
[ Pwnage!!! ]
 
Posts: 4099
Joined: 26 May 2008, 11:11
Location: Bucuresti/Ploiesti

Re: Ultimate new blabla

Postby Juhziz » 02 Feb 2011, 10:23

Roduri enchant Dash:

Code: Select all
INSERT INTO `npc_vendor` ( `entry` , `slot` , `item` , `maxcount` , `incrtime` , `ExtendedCost` )
VALUES ( 19573, 0, 25843, 0, 0, 0 ) , ( 19573, 0, 25844, 0, 0, 0 ) , ( 19573, 0, 25845, 0, 0, 0 ) ;
Pentru toate fetele care spun: "Toţi bărbaţii sunt la fel".
Dacă ai fi fost o fată cuminte, nu ai fi cunoscut toţi bărbaţii...

-Away-
User avatar
Juhziz
[Most Valuable Player]
[Most Valuable Player]
 
Posts: 5498
Joined: 29 Aug 2009, 17:21
Location: Destination Unknown

Re: Ultimate new blabla

Postby Juhziz » 02 Feb 2011, 21:38

DarkPunk wrote:The Champion of Anguish - nu vine NPC-u care trebuie omorat ... e din chainu questurilor de la arena din Zul'Drak.


Fix'ed:

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
(12948, 2, 66, 0, 75, 0, 78, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 130, 0, 0, 0, 0, 0, 12936, 0, 0, 0, 7, 0, 0, 0, 'The Champion of Anguish', 'This is the end, my friend! Your last opponent is going to be your greatest challenge. He''s a vrykul champion from the steppes of Icecrown and he''s out for blood! Defeat him and you''ll be crowned the champion of the Amphitheater of Anguish! This fight is going to make us both rich!$B$BLet me know when you''re ready and we''ll start.', 'Get in the arena at the Amphitheater of Anguish and defeat Vladof the Butcher! Return to Wodin the Troll-Servant to redeem your reward.', 'You did it, $N! That was the most exciting fight yet! What are you going to do with your winnings? Me? I''m going to Dalaran and blowing it all in the Underbelly. Lot of hot action going on down there!', NULL, 'Vladof the Butcher Defeated', 'Return to Wodin the Troll-Servant at Amphitheater of Anguish in Zul''Drak.', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30022, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 41815, 41821, 41825, 41816, 41822, 41824, 1, 1, 1, 1, 1, 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, 204000, 194400, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 12948, 0, 11723);
Pentru toate fetele care spun: "Toţi bărbaţii sunt la fel".
Dacă ai fi fost o fată cuminte, nu ai fi cunoscut toţi bărbaţii...

-Away-
User avatar
Juhziz
[Most Valuable Player]
[Most Valuable Player]
 
Posts: 5498
Joined: 29 Aug 2009, 17:21
Location: Destination Unknown

Re: Ultimate new blabla

Postby Juhziz » 02 Feb 2011, 21:45

Wmb wrote:Scourge Tactics - http://old.wowhead.com/quest=13008 - Nu se pun atunci cand ii eliberezi din cocon,de fapt coconu` e gol :/


Fix'ed.

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
(13008, 2, 210, 0, 77, 0, 78, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 0, 13036, 13044, -13008, 0, 5, 0, 0, 0, 'Scourge Tactics', 'We had the element of surprise on our side! We blew a hole in the side of the mountain and charged into Scourgeholme. Scourge opposition was fierce and it wasn''t long until we were overwhelmed. We fell back to the valley and began raining artillery down on the Scourge that followed. This held them back for awhile until... Those monsters began using crusaders as living shields. We had to stop shelling for fear of killing our own soldiers.$B$BFree our crusaders trapped on the field outside the base, $c!', 'Crusade Commander Entari at the Argent Vanguard in Icecrown has asked that you free 8 Webbed Crusaders.', 'There are still many Argent Crusade soldiers out on that field and in Scourgeholme, $n. While your help is appreciated, there is still much left to be done.', 'Have you freed the webbed crusaders?', '', 'Return to Crusade Commander Entari at the Argent Vanguard in Icecrown.', 'Webbed Crusader Freed', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30273, 0, 0, 0, 8, 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, 1106, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68000, 129600, 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, 11723);
Pentru toate fetele care spun: "Toţi bărbaţii sunt la fel".
Dacă ai fi fost o fată cuminte, nu ai fi cunoscut toţi bărbaţii...

-Away-
User avatar
Juhziz
[Most Valuable Player]
[Most Valuable Player]
 
Posts: 5498
Joined: 29 Aug 2009, 17:21
Location: Destination Unknown

Re: Ultimate new blabla

Postby Juhziz » 02 Feb 2011, 22:22

http://www.wowhead.com/quest=14077( dai chestia aia pe mobi si nu se intampla nimic ,pre wipe mergea)


fix'ed.

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
(14077, 2, -241, 0, 77, 0, 77, 0, 1101, 0, 0, 0, 0, 0, 1094, 42000, 0, 0, 0, 0, 4224, 1, 0, 0, 0, 0, 13700, 0, 14152, 0, 5, 46870, 1, 0, 'The Light''s Mercy', 'I''ve been listening to Confessor Paletress speak, and I must tell you, her words have given me much to consider. It is not enough to fight beside the crusaders; we must take up their mission.$B$BOff the north coast is Hrothgar''s Landing, where the seagoing Kvaldir have overrun an old tuskarr settlement and slain the villagers. Take this book and read the rites for the dead near the corpses of the villagers. It will allow their spirits to escape the mists engulfing the island and find peace.', 'Use the Confessor''s Prayer Book to perform last rites for 8 Slain Tualiq Villagers and then return to Narasi Snowdawn at the Argent Tournament Grounds.', '<Narasi accepts the prayer book from you.>$b$bThank you. The book was a gift from Confessor Paletress herself. She would be honored to know that you have used it to bring tranquility to the slain.', NULL, '', 'Return to Narasi Snowdawn in Icecrown.', 'Last Rites administered', '', '', '', 0, 46870, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 34852, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 44990, 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, 74000, 132300, 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, 11723);
Pentru toate fetele care spun: "Toţi bărbaţii sunt la fel".
Dacă ai fi fost o fată cuminte, nu ai fi cunoscut toţi bărbaţii...

-Away-
User avatar
Juhziz
[Most Valuable Player]
[Most Valuable Player]
 
Posts: 5498
Joined: 29 Aug 2009, 17:21
Location: Destination Unknown

Re: Ultimate new blabla

Postby Juhziz » 03 Feb 2011, 22:13

prospecting_loot_template

fix'ed

nu pot sa postez query-ul , e prea lung.
Pentru toate fetele care spun: "Toţi bărbaţii sunt la fel".
Dacă ai fi fost o fată cuminte, nu ai fi cunoscut toţi bărbaţii...

-Away-
User avatar
Juhziz
[Most Valuable Player]
[Most Valuable Player]
 
Posts: 5498
Joined: 29 Aug 2009, 17:21
Location: Destination Unknown

Re: Ultimate new blabla

Postby Vladymirov » 04 Feb 2011, 20:24

UPDATE `world`.`item_template` SET `name` = 'Area 52 Special(Disabled Item)',
`RequiredLevel` = '90',
`spellid_1` = '0',
`spellcategory_1` = '0',
`spellcategorycooldown_1` = '0' WHERE `item_template`.`entry` =28132;


http://www.wowhead.com/item=28132 - exploit item
Image

-P.S.T *Professional Spamming Team* Owner-
User avatar
Vladymirov
[ Pwnage!!! ]
[ Pwnage!!! ]
 
Posts: 4099
Joined: 26 May 2008, 11:11
Location: Bucuresti/Ploiesti

Re: Ultimate new blabla

Postby Vladymirov » 04 Feb 2011, 20:42

653213695 immunity_mask added @ fos/pos
Image

-P.S.T *Professional Spamming Team* Owner-
User avatar
Vladymirov
[ Pwnage!!! ]
[ Pwnage!!! ]
 
Posts: 4099
Joined: 26 May 2008, 11:11
Location: Bucuresti/Ploiesti

Re: Ultimate new blabla

Postby Vladymirov » 06 Feb 2011, 06:02

UPDATE `world`.`item_template` SET `name` = 'Nigh Invulnerability Belt(use disabled,bafta)',
`spellid_1` = '0',
`spellcooldown_1` = '0',
`description` = 'Fuck off, mai baga o fisa.' WHERE `item_template`.`entry` =23825;


:joker:
Image

-P.S.T *Professional Spamming Team* Owner-
User avatar
Vladymirov
[ Pwnage!!! ]
[ Pwnage!!! ]
 
Posts: 4099
Joined: 26 May 2008, 11:11
Location: Bucuresti/Ploiesti

Re: Ultimate new blabla

Postby Juhziz » 06 Feb 2011, 14:39

Disabled Ritual Summonig in Arathi Basin:

Code: Select all
INSERT INTO `disables` VALUES (0, 698, (1+16+32), "529", "3358", "Disabled Ritual Summonig in Arathi Basin");
Pentru toate fetele care spun: "Toţi bărbaţii sunt la fel".
Dacă ai fi fost o fată cuminte, nu ai fi cunoscut toţi bărbaţii...

-Away-
User avatar
Juhziz
[Most Valuable Player]
[Most Valuable Player]
 
Posts: 5498
Joined: 29 Aug 2009, 17:21
Location: Destination Unknown

Re: Ultimate new blabla

Postby Juhziz » 06 Feb 2011, 15:08

Si in EOTS:
Code: Select all
INSERT INTO `disables` VALUES (0, 698, (1+16+32), "529,566", "3358,3820", "Disabled Ritual Summonig in Arathi Basin/EOTS");
Pentru toate fetele care spun: "Toţi bărbaţii sunt la fel".
Dacă ai fi fost o fată cuminte, nu ai fi cunoscut toţi bărbaţii...

-Away-
User avatar
Juhziz
[Most Valuable Player]
[Most Valuable Player]
 
Posts: 5498
Joined: 29 Aug 2009, 17:21
Location: Destination Unknown

Re: Ultimate new blabla

Postby Vladymirov » 06 Feb 2011, 17:17

UPDATE `world`.`creature_template` SET `RegenHealth` = '0' WHERE `creature_template`.`entry` =33109;


Regen ulduar masinutze, merge perfect repair objectul
Image

-P.S.T *Professional Spamming Team* Owner-
User avatar
Vladymirov
[ Pwnage!!! ]
[ Pwnage!!! ]
 
Posts: 4099
Joined: 26 May 2008, 11:11
Location: Bucuresti/Ploiesti

Re: Ultimate new blabla

Postby Vladymirov » 08 Feb 2011, 01:56

SELECT *
FROM `item_template`
WHERE `name` LIKE 'Crafty''s Ultra-Advanced Proto-Typical Shortening Blaster'



UPDATE `world`.`item_template` SET `name` = 'Gauntlets of the Sea(Disabled)',
`spellid_1` = '0',
`spellcooldown_1` = '0',
`ScriptName` = 'Mai baga o fisa,hai salut' WHERE `item_template`.`entry` =8346;




use scos fmm
Image

-P.S.T *Professional Spamming Team* Owner-
User avatar
Vladymirov
[ Pwnage!!! ]
[ Pwnage!!! ]
 
Posts: 4099
Joined: 26 May 2008, 11:11
Location: Bucuresti/Ploiesti

Next

Return to Trash

Who is online

Users browsing this forum: No registered users and 1 guest