[Bouken]

أعتقد الكويرى ده يساعدك
إن شاء الله

use/**/[sro_vt_shard]/**/
--credits to hean
/*edited by bouken*/
go
declare @mob varchar(max),@item varchar(max),@monsterid int,@itemid int,@dropratio real, @dropamountmin int, @dropamountmax int
--------------------------------------------------------------------------
set @mob = 'mob_tq_whitesnake'/*monster code*/
set @item = 'item_mall_global_chatting'/*item code*/
set @dropamountmin = 10 /*drop min*/
set @dropamountmax = 50 /*drop max*/
set @dropratio = 0.9 /*0.5 = '50%' */
--------------------------------------------------------------------------
set @monsterid = (select id from [dbo].[_refobjcommon] where codename128 = @mob)/**/
set @itemid = (select id from [dbo].[_refobjcommon] where codename128 = @item)/**/
insert [dbo].[_refmonster_assigneditemdrop]/**/
(refmonsterid,refitemid,dropgrouptype,optlevel,dro pamountmin,dropamountmax,dropratio,refmagicoptioni d1,customvalue1,refmagicoptionid2,customvalue2,ref magicoptionid3,customvalue3,refmagicoptionid4,cust omvalue4,refmagicoptionid5,customvalue5,refmagicop tionid6,customvalue6,refmagicoptionid7,customvalue 7,refmagicoptionid8,customvalue8,refmagicoptionid9 ,customvalue9,rentcodename)/**/
values(@monsterid,@itemid,0,0,@dropamountmin,@drop amountmax,@dropratio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,'xxx')/**/