/* 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
Code:
/* 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
Code:
/* 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
Code:
/* 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 .
Quote:
Originally Posted by Statiic
easy
here u go
@Topic
InPanic Kev add this to fist post for a complete release
Silkademy 110 Cap - Highrate - Increased Magicpop and Alchemy 08/19/2013 - SRO PServer Advertising - 58 Replies http://img51.imageshack.us/img51/2943/headerust.jp g
Feel free to post feedback, bugs, or whatever.
Current Event:
Free GrabPet for beginners.
Daily Unique and Hide&Seek Events, with prices like Silk, Pandoras, ...
------------------------------------------------- ----------------------
Hello players and epvp community,