المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : mobs 111+ مبتنزلش item في query ليها ؟

hero_000
17-04-2013, 10:56 AM
mobs 111+ مبتنزلش item في query ليها ؟
hero_000
17-04-2013, 10:58 AM
اي query تنزل d12 items
Mahmoud Rashwan
17-04-2013, 10:25 PM
USE SRO_VT_SHARD /* Query To Drop D13 By ™BaZzZoKa™ */
GO
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='130'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='130'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='130'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup34='0.000403' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup34='0.000403' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup34='0.000403' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup36='0.000433' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup36='0.000433' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup36='0.000433' where MonLevel='130'