add Magic Pop D 12

[mmmhhh]

1. Deg 12 SoX Weapon EU / CH

/* Aktiviert die Deg12 SoX Waffen CH EU im Magic Pop */
update [SRO_VT_SHARD].[dbo].[_RefGachaItemSet]
set Service = '1'	  
where RefItemID = '7490' or
	  RefItemID = '7491' or
	  RefItemID = '4083' or
	  RefItemID = '4085' or
	  RefItemID = '4084' or
	  RefItemID = '4157' or
	  RefItemID = '4156' or
	  RefItemID = '4155' or
	  RefItemID = '4191' or
	  RefItemID = '4193' or
	  RefItemID = '4192' or
	  RefItemID = '4121' or
	  RefItemID = '4119' or
	  RefItemID = '4120' or
	  RefItemID = '4228' or
	  RefItemID = '4229' or
	  RefItemID = '4227' or
	  RefItemID = '11615' or
	  RefItemID = '11616' or
	  RefItemID = '11614' or
	  RefItemID = '11292' or
	  RefItemID = '11291' or
	  RefItemID = '11327' or
	  RefItemID = '11326' or
	  RefItemID = '11290' or
	  RefItemID = '11328' or
	  RefItemID = '11544' or
	  RefItemID = '11543' or
	  RefItemID = '11542' or
	  RefItemID = '11470' or
	  RefItemID = '11471' or
	  RefItemID = '11472' or
	  RefItemID = '11399' or
	  RefItemID = '11398' or
	  RefItemID = '11400' or
	  RefItemID = '11254' or
	  RefItemID = '11255' or
	  RefItemID = '11256' or
	  RefItemID = '11506' or
	  RefItemID = '11507' or
	  RefItemID = '11508' or
	  RefItemID = '11435' or
	  RefItemID = '11434' or
	  RefItemID = '11436' or
	  RefItemID = '11364' or
	  RefItemID = '11363' or
	  RefItemID = '11362'

2. Deg12 SoX Equip EU

/* Aktiviert die Deg12 SoX Rüstungen EU im Magic Pop */
update [SRO_VT_SHARD].[dbo].[_RefGachaItemSet]
set Service = '1'	  
where RefItemID = '12928' or
	  RefItemID = '13000' or
	  RefItemID = '13036' or
	  RefItemID = '13072' or
	  RefItemID = '13144' or
	  RefItemID = '13108' or
	  RefItemID = '12676' or
	  RefItemID = '12748' or
	  RefItemID = '12784' or
	  RefItemID = '12820' or
	  RefItemID = '12892' or
	  RefItemID = '12856' or
	  RefItemID = '12424' or
	  RefItemID = '12496' or
	  RefItemID = '12532' or
	  RefItemID = '12568' or
	  RefItemID = '12640' or
	  RefItemID = '12604' or
	  RefItemID = '14440' or
	  RefItemID = '14512' or
	  RefItemID = '14548' or
	  RefItemID = '14584' or
	  RefItemID = '14656' or
	  RefItemID = '14620' or
	  RefItemID = '14188' or
	  RefItemID = '14260' or
	  RefItemID = '14296' or
	  RefItemID = '14332' or
	  RefItemID = '14404' or
	  RefItemID = '14368' or
	  RefItemID = '13936' or
	  RefItemID = '14008' or
	  RefItemID = '14044' or
	  RefItemID = '14080' or
	  RefItemID = '14152' or
	  RefItemID = '14116' or
	  RefItemID = '12929' or
	  RefItemID = '13001' or
	  RefItemID = '13037' or
	  RefItemID = '13073' or
	  RefItemID = '13145' or
	  RefItemID = '13109' or
	  RefItemID = '12677' or
	  RefItemID = '12749' or
	  RefItemID = '12785' or
	  RefItemID = '12821' or
	  RefItemID = '12893' or
	  RefItemID = '12857' or
	  RefItemID = '12425' or
	  RefItemID = '12497' or
	  RefItemID = '12533' or
	  RefItemID = '12569' or
	  RefItemID = '12641' or
	  RefItemID = '12605' or
	  RefItemID = '14441' or
	  RefItemID = '14513' or
	  RefItemID = '14549' or
	  RefItemID = '14585' or
	  RefItemID = '14657' or
	  RefItemID = '14621' or
	  RefItemID = '14189' or
	  RefItemID = '14261' or
	  RefItemID = '14297' or
	  RefItemID = '14333' or
	  RefItemID = '14405' or
	  RefItemID = '14369' or
	  RefItemID = '13937' or
	  RefItemID = '14009' or
	  RefItemID = '14045' or
	  RefItemID = '14081' or
	  RefItemID = '14153' or
	  RefItemID = '14117' or
	  RefItemID = '12930' or
	  RefItemID = '13002' or
	  RefItemID = '13038' or
	  RefItemID = '13074' or
	  RefItemID = '13146' or
	  RefItemID = '13110' or
	  RefItemID = '12678' or
	  RefItemID = '12750' or
	  RefItemID = '12786' or
	  RefItemID = '12822' or
	  RefItemID = '12894' or
	  RefItemID = '12858' or
	  RefItemID = '12426' or
	  RefItemID = '12498' or
	  RefItemID = '12534' or
	  RefItemID = '12570' or
	  RefItemID = '12642' or
	  RefItemID = '12606' or
	  RefItemID = '14442' or
	  RefItemID = '14514' or
	  RefItemID = '14550' or
	  RefItemID = '14586' or
	  RefItemID = '14658' or
	  RefItemID = '14622' or
	  RefItemID = '14190' or
	  RefItemID = '14262' or
	  RefItemID = '14298' or
	  RefItemID = '14334' or
	  RefItemID = '14406' or
	  RefItemID = '14370' or
	  RefItemID = '13938' or
	  RefItemID = '14010' or
	  RefItemID = '14046' or
	  RefItemID = '14082' or
	  RefItemID = '14154' or
	  RefItemID = '14118'

3. Deg12 SoX Equip CH

/* Aktiviert die Deg12 SoX Rüstungen CH im Magic Pop */
update [SRO_VT_SHARD].[dbo].[_RefGachaItemSet]
set Service = '1' 
where RefItemID = '4767' or
	  RefItemID = '4839' or
	  RefItemID = '4875' or
	  RefItemID = '4911' or
	  RefItemID = '4983' or
	  RefItemID = '4947' or
	  RefItemID = '4515' or
	  RefItemID = '4587' or
	  RefItemID = '4623' or
	  RefItemID = '4659' or
	  RefItemID = '4731' or
	  RefItemID = '4695' or
	  RefItemID = '4263' or
	  RefItemID = '4335' or
	  RefItemID = '4371' or
	  RefItemID = '4407' or
	  RefItemID = '4479' or
	  RefItemID = '4443' or
	  RefItemID = '5523' or
	  RefItemID = '5595' or
	  RefItemID = '5631' or
	  RefItemID = '5667' or
	  RefItemID = '5739' or
	  RefItemID = '5703' or
	  RefItemID = '5271' or
	  RefItemID = '5343' or
	  RefItemID = '5379' or
	  RefItemID = '5415' or
	  RefItemID = '5487' or
	  RefItemID = '5451' or
	  RefItemID = '5019' or
	  RefItemID = '5091' or
	  RefItemID = '5127' or
	  RefItemID = '5163' or
	  RefItemID = '5235' or
	  RefItemID = '5199' or
	  RefItemID = '4768' or
	  RefItemID = '4840' or
	  RefItemID = '4876' or
	  RefItemID = '4912' or
	  RefItemID = '4984' or
	  RefItemID = '4948' or
	  RefItemID = '4516' or
	  RefItemID = '4588' or
	  RefItemID = '4624' or
	  RefItemID = '4660' or
	  RefItemID = '4732' or
	  RefItemID = '4696' or
	  RefItemID = '4264' or
	  RefItemID = '4336' or
	  RefItemID = '4372' or
	  RefItemID = '4408' or
	  RefItemID = '4480' or
	  RefItemID = '4444' or
	  RefItemID = '5524' or
	  RefItemID = '5596' or
	  RefItemID = '5632' or
	  RefItemID = '5668' or
	  RefItemID = '5740' or
	  RefItemID = '5704' or
	  RefItemID = '5272' or
	  RefItemID = '5344' or
	  RefItemID = '5380' or
	  RefItemID = '5416' or
	  RefItemID = '5488' or
	  RefItemID = '5452' or
	  RefItemID = '5020' or
	  RefItemID = '5092' or
	  RefItemID = '5128' or
	  RefItemID = '5164' or
	  RefItemID = '5236' or
	  RefItemID = '5200' or
	  RefItemID = '4769' or
	  RefItemID = '4841' or
	  RefItemID = '4877' or
	  RefItemID = '4913' or
	  RefItemID = '4985' or
	  RefItemID = '4949' or
	  RefItemID = '4517' or
	  RefItemID = '4589' or
	  RefItemID = '4625' or
	  RefItemID = '4661' or
	  RefItemID = '4733' or
	  RefItemID = '4697' or
	  RefItemID = '4265' or
	  RefItemID = '4337' or
	  RefItemID = '4373' or
	  RefItemID = '4409' or
	  RefItemID = '4481' or
	  RefItemID = '4445' or
	  RefItemID = '5525' or
	  RefItemID = '5597' or
	  RefItemID = '5633' or
	  RefItemID = '5669' or
	  RefItemID = '5741' or
	  RefItemID = '5705' or
	  RefItemID = '5273' or
	  RefItemID = '5345' or
	  RefItemID = '5381' or
	  RefItemID = '5417' or
	  RefItemID = '5489' or
	  RefItemID = '5453' or
	  RefItemID = '5021' or
	  RefItemID = '5093' or
	  RefItemID = '5129' or
	  RefItemID = '5165' or
	  RefItemID = '5237' or
	  RefItemID = '5201'

4. Deg12 SoX Accesorries

/* Aktiviert den Deg12 SoX Schmuck CH im Magic Pop */
update [SRO_VT_SHARD].[dbo].[_RefGachaItemSet]
set Service = '1' 
where RefItemID = '14800' or
	  RefItemID = '14836' or
	  RefItemID = '14872' or
	  RefItemID = '5847' or
	  RefItemID = '5811' or
	  RefItemID = '5775' or
	  RefItemID = '14801' or
	  RefItemID = '14837' or
	  RefItemID = '14873' or
	  RefItemID = '5848' or
	  RefItemID = '5812' or
	  RefItemID = '5776' or
	  RefItemID = '14802' or
	  RefItemID = '14838' or
	  RefItemID = '14874' or
	  RefItemID = '5849' or
	  RefItemID = '5813' or
	  RefItemID = '5777'

have fun , do same same with client side

http://www.mediafire.com/?vl70e0e1rns8efi

done

__________________________________________________ _____________________