مــجــمــوعــه كــبــيــر جــدا مــن الـ Queries - الموقع العربي الاول للعبة Silkroad Online

**GoldMonkey** · 13-07-2013, 09:10 AM

 
            

---------- SebekPrg - add silks with charname -----
Declare @nick varchar (128)
Declare @silk int
-----------------Settings---------------------------
Set @nick = 'nick' -- char nick
set @silk = 0 -- how many silks to add
----------------------------------------------------
USE SRO_VT_ACCOUNT -- change to u'r
select JID, StrUserID from TB_User where JID in(select UserJID from SR_ShardCharNames where Charname like @nick)
Update SK_Silk
set silk_own = silk_own+@silk
where JID in(select UserJID from SR_ShardCharNames where Charname like @nick)
--Check
select Jid, silk_own from SK_Silk where JID in(select UserJID from SR_ShardCharNames where Charname like @nick)
-----------SebekPrg -- add silks with charname ----[B]<b><font face="Comic Sans MS"><font color="Navy"><font face="Calibri Light"><font color="DarkRed"><font size="4"><b><font face="Calibri Light"><font color="DarkRed"><font size="4"><b><font face="Calibri Light"><font color="DarkRed"><font size="4"><b><font size="2"><font face="Tahoma"><font color="Red"><font size="3">[IMG]http://www3.0zz0.com/2012/12/26/15/187243625.gif[/IMG]

[IMG]http://www14.0zz0.com/2012/11/24/23/360045942.png[/IMG]

[IMG]http://imageshack.us/a/img21/5166/80162578.png[/IMG]

<font color="DarkOrange">اهــلا وسـهـلا بـكـل زوار . اعـضـاء الـمـنـتـدي الـكـرامـ </font>

[IMG]http://www12.0zz0.com/2012/11/25/00/240653786.png[/IMG]</font></font></font></font></b></font></font></font></b></font></font></font></b></font></font></font>

مــجــمــوعــه كــبــيــر جــدا مــن الـ <font color="Red">Queries</font>
</font></font>
<b>         <font size="3"><font color="Blue">50 Immortals On Weapons</font></font>     </b>

[SPOILER]
<table cellpadding="6" cellspacing="0"  border="0" width="620" style="border: 1px dotted #499c00; margin: 10px;  width: 620px;"> 

<tr> 

<td style="background: #e7ffd9  url(http://img834.imageshack.us/img834/4213/php.gif) no-repeat top  left; height: 20px;"> 

</td> 

</tr> 

<tr> 

<td> 

 

<div dir="ltr" style="width: 620px; height: 498px; text-align: left; overflow: auto"> 

        <code style="white-space:nowrap"> 

            <!-- php buffer start --><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #007700">USE&nbsp;[</span><span style="color: #0000BB">SRO_VT_ROYAL</span><span style="color: #007700">]</span><span style="color: #0000BB">GO</span><span style="color: #FF8000">/******&nbsp;Object:&nbsp;&nbsp;StoredProcedure&nbsp;[dbo].[_ItemForge]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Script&nbsp;Date:&nbsp;06/10/2013&nbsp;06:41:18&nbsp;******/</span><span style="color: #0000BB">SET&nbsp;ANSI_NULLS&nbsp;ONGOSET&nbsp;QUOTED_IDENTIFIER&nbsp;ONGOALTER&nbsp;procedure&nbsp;</span><span style="color: #007700">[</span><span style="color: #0000BB">dbo</span><span style="color: #007700">].[</span><span style="color: #0000BB">_ItemForge</span><span style="color: #007700">]@</span><span style="color: #0000BB">CharID&nbsp;INT</span><span style="color: #007700">asIF&nbsp;((</span><span style="color: #0000BB">Select&nbsp;RefItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Items&nbsp;where&nbsp;ID64&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">Select&nbsp;ItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Inventory&nbsp;where&nbsp;CharID</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CharID&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">14</span><span style="color: #007700">))&nbsp;=&nbsp;</span><span style="color: #0000BB">6855</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">Declare&nbsp;@</span><span style="color: #0000BB">Amount&nbsp;tinyint&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">Select&nbsp;Data&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Items&nbsp;where&nbsp;ID64&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(</span><span style="color: #0000BB">Select&nbsp;ItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Inventory&nbsp;where&nbsp;CharID</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CharID&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">14</span><span style="color: #007700">)&nbsp;AND&nbsp;</span><span style="color: #0000BB">RefItemID&nbsp;</span><span style="color: #007700">=</span><span style="color: #0000BB">6855</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(@</span><span style="color: #0000BB">Amount&nbsp;</span><span style="color: #007700">>=</span><span style="color: #0000BB">50</span><span style="color: #007700">)--&nbsp;</span><span style="color: #0000BB">Immortal&nbsp;checking&nbsp;amount</span><span style="color: #007700">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Begin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">--&nbsp;</span><span style="color: #0000BB">Wep&nbsp;checking&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">Declare&nbsp;@</span><span style="color: #0000BB">T1&nbsp;tinyint</span><span style="color: #007700">,@</span><span style="color: #0000BB">T2&nbsp;tinyint</span><span style="color: #007700">,@</span><span style="color: #0000BB">T3&nbsp;Tinyint</span><span style="color: #007700">;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Set&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">T1</span><span style="color: #007700">=(</span><span style="color: #0000BB">Select&nbsp;TypeID1&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_RefObjCommon&nbsp;where&nbsp;ID&nbsp;</span><span style="color: #007700">=(</span><span style="color: #0000BB">Select&nbsp;RefItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Items&nbsp;where&nbsp;ID64&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(</span><span style="color: #0000BB">Select&nbsp;ItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Inventory&nbsp;where&nbsp;CharID</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CharID&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">13</span><span style="color: #007700">)))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Set&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">T2</span><span style="color: #007700">=(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Select&nbsp;TypeID2&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_RefObjCommon&nbsp;where&nbsp;ID&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(</span><span style="color: #0000BB">Select&nbsp;RefItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Items&nbsp;where&nbsp;ID64&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(</span><span style="color: #0000BB">Select&nbsp;ItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Inventory&nbsp;where&nbsp;CharID</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CharID&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">13</span><span style="color: #007700">)))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Set&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">T3</span><span style="color: #007700">=(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Select&nbsp;TypeID3&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_RefObjCommon&nbsp;where&nbsp;ID&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(</span><span style="color: #0000BB">Select&nbsp;RefItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Items&nbsp;where&nbsp;ID64&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(</span><span style="color: #0000BB">Select&nbsp;ItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Inventory&nbsp;where&nbsp;CharID</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CharID&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">13</span><span style="color: #007700">)))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(@</span><span style="color: #0000BB">T1</span><span style="color: #007700">=</span><span style="color: #0000BB">3&nbsp;</span><span style="color: #007700">AND&nbsp;@</span><span style="color: #0000BB">T2&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1&nbsp;</span><span style="color: #007700">AND&nbsp;@</span><span style="color: #0000BB">T3&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">6</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Update&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Items&nbsp;set&nbsp;MagParamNum</span><span style="color: #007700">=</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam1&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam2</span><span style="color: #007700">=</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam3</span><span style="color: #007700">=</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam4</span><span style="color: #007700">=</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam5</span><span style="color: #007700">=</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam6</span><span style="color: #007700">=</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam7</span><span style="color: #007700">=</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam8</span><span style="color: #007700">=</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam9</span><span style="color: #007700">=</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">MagParam10</span><span style="color: #007700">=</span><span style="color: #0000BB">0&nbsp;where&nbsp;ID64&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(</span><span style="color: #0000BB">select&nbsp;itemid&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Inventory&nbsp;where&nbsp;CharID&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CharID&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">13</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Update&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Items&nbsp;set&nbsp;MagParam1&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">214748364851&nbsp;where&nbsp;ID64&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(</span><span style="color: #0000BB">select&nbsp;itemid&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Inventory&nbsp;where&nbsp;CharID&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CharID&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">13</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(@</span><span style="color: #0000BB">Amount&nbsp;</span><span style="color: #007700">>&nbsp;</span><span style="color: #0000BB">50</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Begin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Update&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Items&nbsp;set&nbsp;Data</span><span style="color: #007700">-=@</span><span style="color: #0000BB">Amount&nbsp;where&nbsp;ID64&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(</span><span style="color: #0000BB">Select&nbsp;ItemID&nbsp;from&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Inventory&nbsp;where&nbsp;CharID</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CharID&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">14</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">End&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">Amount&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">50</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Begin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Update&nbsp;SRO_VT_SHARD</span><span style="color: #007700">.</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Inventory&nbsp;Set&nbsp;ItemID</span><span style="color: #007700">=</span><span style="color: #0000BB">0&nbsp;where&nbsp;Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">14&nbsp;</span><span style="color: #007700">and&nbsp;</span><span style="color: #0000BB">CharID</span><span style="color: #007700">=@</span><span style="color: #0000BB">CharID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;END&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">Else&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">--&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">RAISERROR</span><span style="color: #007700">(</span><span style="color: #DD0000">'Somethings&nbsp;Gone&nbsp;Wrong'</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">16</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">)--Print&nbsp;</span><span style="color: #DD0000">'Something&nbsp;has&nbsp;gone&nbsp;wrong,&nbsp;Contact&nbsp;Royalblade&nbsp;(Akasch)&nbsp;at&nbsp;Skype:Akasch93'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">END&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">Else&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">--</span><span style="color: #0000BB">RAISERROR</span><span style="color: #007700">(</span><span style="color: #DD0000">'Wep&nbsp;or&nbsp;Immo&nbsp;insufficient'</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">16</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">)--Print&nbsp;</span><span style="color: #DD0000">'You&nbsp;either&nbsp;Don`t&nbsp;have&nbsp;a&nbsp;Weapon&nbsp;(most&nbsp;likely)&nbsp;in&nbsp;InventorySlot&nbsp;1&nbsp;or&nbsp;you&nbsp;don`t&nbsp;have&nbsp;50&nbsp;or&nbsp;more&nbsp;Immortals&nbsp;in&nbsp;InventorySlot2'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">END&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">ELSE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;</span><span style="color: #0000BB">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">RAISERROR</span><span style="color: #007700">(</span><span style="color: #DD0000">'Immo&nbsp;Insufficient'</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">16</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--PRINT&nbsp;</span><span style="color: #DD0000">'You&nbsp;Do&nbsp;not&nbsp;have&nbsp;more&nbsp;than&nbsp;or&nbsp;equal&nbsp;to&nbsp;50&nbsp;Immortals&nbsp;in&nbsp;InventorySlot&nbsp;2'</span><span style="color: #0000BB">END</span><span style="color: #007700">Else&nbsp;return&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">--</span><span style="color: #0000BB">RAISERROR</span><span style="color: #007700">(</span><span style="color: #DD0000">'Immo&nbsp;Insufficient&nbsp;OQE?'</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">16</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">)--</span><span style="color: #0000BB">exec&nbsp;_itemforge&nbsp;25501&nbsp;
</span>
</span>
</code><!-- php buffer end --> 

        </code> 

</div> 

</div> 

</td> 

</tr> 

</table>[/SPOILER]<font face="Comic Sans MS"><font color="Navy"><font size="4">

</font></font></font>
<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS">[IMG]http://www9.0zz0.com/2013/02/21/19/982803167.gif[/IMG]
</font></font></font></font></font></font>
<b><font size="3"><font color="Blue">Check For Buggy Items That Crash The Shardmanager</font></font>     </b>

<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS">[SPOILER]
<table cellpadding="6" cellspacing="0"  border="0" width="620" style="border: 1px dotted #499c00; margin: 10px;  width: 620px;"> 

<tr> 

<td style="background: #e7ffd9  url(http://img834.imageshack.us/img834/4213/php.gif) no-repeat top  left; height: 20px;"> 

</td> 

</tr> 

<tr> 

<td> 

 

<div dir="ltr" style="width: 620px; height: 210px; text-align: left; overflow: auto"> 

        <code style="white-space:nowrap"> 

            <!-- php buffer start --><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #007700">--&nbsp;</span><span style="color: #0000BB">to&nbsp;see&nbsp;</span><span style="color: #007700">if&nbsp;</span><span style="color: #0000BB">there&nbsp;is&nbsp;a&nbsp;disabled&nbsp;item&nbsp;somewhereselect&nbsp;A</span><span style="color: #007700">.*,&nbsp;</span><span style="color: #0000BB">b</span><span style="color: #007700">.*&nbsp;</span><span style="color: #0000BB">from&nbsp;</span><span style="color: #007700">[</span><span style="color: #0000BB">SRO_VT_SHARD</span><span style="color: #007700">].</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_items&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000BB">aright&nbsp;join&nbsp;</span><span style="color: #007700">[</span><span style="color: #0000BB">SRO_VT_SHARD</span><span style="color: #007700">].</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_RefObjCommon&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000BB">b&nbsp;on&nbsp;b</span><span style="color: #007700">.</span><span style="color: #0000BB">ID&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">a</span><span style="color: #007700">.</span><span style="color: #0000BB">RefItemIDwhere&nbsp;Service&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0&nbsp;</span><span style="color: #007700">and&nbsp;</span><span style="color: #0000BB">ID64&nbsp;is&nbsp;not&nbsp;null</span><span style="color: #007700">--&nbsp;</span><span style="color: #0000BB">to&nbsp;see&nbsp;</span><span style="color: #007700">if&nbsp;</span><span style="color: #0000BB">items&nbsp;exists&nbsp;in&nbsp;_inventory&nbsp;but&nbsp;not&nbsp;in&nbsp;itemsselect&nbsp;d</span><span style="color: #007700">.</span><span style="color: #0000BB">charname16</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">a</span><span style="color: #007700">.*,</span><span style="color: #0000BB">c</span><span style="color: #007700">.</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">b</span><span style="color: #007700">.*&nbsp;</span><span style="color: #0000BB">from&nbsp;</span><span style="color: #007700">[</span><span style="color: #0000BB">SRO_VT_SHARD</span><span style="color: #007700">].</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_inventory&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000BB">aright&nbsp;join&nbsp;</span><span style="color: #007700">[</span><span style="color: #0000BB">SRO_VT_SHARD</span><span style="color: #007700">].</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Items&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000BB">b&nbsp;on&nbsp;b</span><span style="color: #007700">.</span><span style="color: #0000BB">ID64&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">a</span><span style="color: #007700">.</span><span style="color: #0000BB">ItemIDleft&nbsp;join&nbsp;</span><span style="color: #007700">[</span><span style="color: #0000BB">SRO_VT_SHARD</span><span style="color: #007700">].</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_RefObjCommon&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000BB">c&nbsp;on&nbsp;c</span><span style="color: #007700">.</span><span style="color: #0000BB">ID&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">b</span><span style="color: #007700">.</span><span style="color: #0000BB">RefItemIDright&nbsp;join&nbsp;</span><span style="color: #007700">[</span><span style="color: #0000BB">SRO_VT_SHARD</span><span style="color: #007700">].</span><span style="color: #0000BB">dbo</span><span style="color: #007700">.</span><span style="color: #0000BB">_Char&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000BB">d&nbsp;on&nbsp;a</span><span style="color: #007700">.</span><span style="color: #0000BB">CharID&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">d</span><span style="color: #007700">.</span><span style="color: #0000BB">CharID&nbsp;where&nbsp;b</span><span style="color: #007700">.</span><span style="color: #0000BB">ID64&nbsp;is&nbsp;null&nbsp;
</span>
</span>
</code><!-- php buffer end --> 

        </code> 

</div> 

</div> 

</td> 

</tr> 

</table>[/SPOILER]

</font></font></font></font></font></font>
<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS">[IMG]http://www9.0zz0.com/2013/02/21/19/982803167.gif[/IMG]</font></font></font></font></font></font>
<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Red">
<font color="Blue">Add New Npc</font></font></font></font></font>

قبل استخدام هذه الـ Query</font></font></font></font></font></font>
<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Red"><font color="Black"><font color="Indigo">SQL</font> > <font color="Indigo">Tools </font>> <font color="Indigo">Options </font>> <font color="Indigo">Designers </font>><font color="DarkRed"> Perevnt Saving Changes the require table re-creation </font></font></font></font></font></font><font color="DarkRed">
<font color="SlateGray">و اشيل الـ صح من ع  </font></font></font></font></font></font></font></font>
<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font color="DarkRed"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Red"><font color="Black"><font color="DarkRed"> Perevnt Saving Changes the require table re-creation
</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>
<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font color="DarkRed"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Red"><font color="Black"><font color="DarkRed"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Red"><font color="Black"><font color="Purple">RefObjCommon</font> > <font color="Purple">Design </font>> <font color="Purple">right click</font> ID <font color="Purple">Column Set a primary key</font>  > Column Properties > <font color="Purple">Indetity Spercification</font> > <font color="Red">(Is Indetity)  set "Yes"
و اعمل كدة مع </font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>
<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font color="DarkRed"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Red"><font color="Black"><font color="DarkRed"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Red"><font color="Black"><font color="Red"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Purple"><font color="Lime">Tab_RefHive and Tab_RefNest ب</font><font color="Lime">س OF</font>
ممكن تشغال الـ َQuery Now

</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>[SPOILER]
<table cellpadding="6" cellspacing="0"  border="0" width="620" style="border: 1px dotted #499c00; margin: 10px;  width: 620px;"> 

<tr> 

<td style="background: #e7ffd9  url(http://img834.imageshack.us/img834/4213/php.gif) no-repeat top  left; height: 20px;"> 

</td> 

</tr> 

<tr> 

<td> 

 

<div dir="ltr" style="width: 620px; height: 498px; text-align: left; overflow: auto"> 

        <code style="white-space:nowrap"> 

            <!-- php buffer start --><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">CHARNAME&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">NPCNAME&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">ADDNEW&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">GAMEWORDID&nbsp;INT&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">CHARNAME&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Frebs'&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">U&nbsp;Char&nbsp;Name&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">NPCNAME&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Name&nbsp;NPC'&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">U&nbsp;NPC&nbsp;NAME&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GAMEWORDID&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">IMPORTANT</span><span style="color: #007700">!&nbsp;</span><span style="color: #0000BB">GET&nbsp;GAMEWORLD&nbsp;ID&nbsp;FROM&nbsp;THE&nbsp;LOCALY&nbsp;U&nbsp;WANT&nbsp;ADD&nbsp;THE&nbsp;NPC&nbsp;NORMAL&nbsp;CITYs&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">ADDNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'NPC'&nbsp;</span><span style="color: #007700">--&nbsp;IF&nbsp;@</span><span style="color: #0000BB">ADDNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'NPC'&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">MAXLINK&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefObjChar</span><span style="color: #007700">)+</span><span style="color: #0000BB">1&nbsp;</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">MAXCOMMONID&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefObjCommon</span><span style="color: #007700">)+</span><span style="color: #0000BB">1&nbsp;SET&nbsp;IDENTITY_INSERT&nbsp;_RefObjCommon&nbsp;ON&nbsp;INSERT&nbsp;INTO&nbsp;_RefObjCommon&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,</span><span style="color: #0000BB">ID</span><span style="color: #007700">,</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,</span><span style="color: #0000BB">ObjName128</span><span style="color: #007700">,</span><span style="color: #0000BB">OrgObjCodeName128</span><span style="color: #007700">,</span><span style="color: #0000BB">NameStrID128</span><span style="color: #007700">,</span><span style="color: #0000BB">DescStrID128</span><span style="color: #007700">,</span><span style="color: #0000BB">CashItem</span><span style="color: #007700">,</span><span style="color: #0000BB">Bionic</span><span style="color: #007700">,</span><span style="color: #0000BB">TypeID1</span><span style="color: #007700">,</span><span style="color: #0000BB">TypeID2</span><span style="color: #007700">,</span><span style="color: #0000BB">TypeID3</span><span style="color: #007700">,</span><span style="color: #0000BB">TypeID4</span><span style="color: #007700">,</span><span style="color: #0000BB">DecayTime</span><span style="color: #007700">,</span><span style="color: #0000BB">Country&nbsp;</span><span style="color: #007700">,</span><span style="color: #0000BB">Rarity</span><span style="color: #007700">,</span><span style="color: #0000BB">CanTrade</span><span style="color: #007700">,</span><span style="color: #0000BB">CanSell</span><span style="color: #007700">,</span><span style="color: #0000BB">CanBuy</span><span style="color: #007700">,</span><span style="color: #0000BB">CanBorrow</span><span style="color: #007700">,</span><span style="color: #0000BB">CanDrop</span><span style="color: #007700">,</span><span style="color: #0000BB">CanPick</span><span style="color: #007700">,</span><span style="color: #0000BB">CanRepair</span><span style="color: #007700">,</span><span style="color: #0000BB">CanRevive</span><span style="color: #007700">,</span><span style="color: #0000BB">CanUse</span><span style="color: #007700">,</span><span style="color: #0000BB">CanThrow</span><span style="color: #007700">,</span><span style="color: #0000BB">Price</span><span style="color: #007700">,</span><span style="color: #0000BB">CostRepair</span><span style="color: #007700">,</span><span style="color: #0000BB">CostRevive</span><span style="color: #007700">,</span><span style="color: #0000BB">CostBorrow</span><span style="color: #007700">,</span><span style="color: #0000BB">KeepingFee</span><span style="color: #007700">,</span><span style="color: #0000BB">SellPrice</span><span style="color: #007700">,</span><span style="color: #0000BB">ReqLevelType1</span><span style="color: #007700">,</span><span style="color: #0000BB">ReqLevel1</span><span style="color: #007700">,</span><span style="color: #0000BB">ReqLevelType2</span><span style="color: #007700">,</span><span style="color: #0000BB">ReqLevel2</span><span style="color: #007700">,</span><span style="color: #0000BB">ReqLevelType3</span><span style="color: #007700">,</span><span style="color: #0000BB">ReqLevel3</span><span style="color: #007700">,</span><span style="color: #0000BB">ReqLevelType4</span><span style="color: #007700">,</span><span style="color: #0000BB">ReqLevel4</span><span style="color: #007700">,</span><span style="color: #0000BB">MaxContain</span><span style="color: #007700">,</span><span style="color: #0000BB">RegionID</span><span style="color: #007700">,</span><span style="color: #0000BB">Dir</span><span style="color: #007700">,</span><span style="color: #0000BB">OffsetX</span><span style="color: #007700">,</span><span style="color: #0000BB">OffsetY</span><span style="color: #007700">,</span><span style="color: #0000BB">OffsetZ</span><span style="color: #007700">,</span><span style="color: #0000BB">Speed1</span><span style="color: #007700">,</span><span style="color: #0000BB">Speed2</span><span style="color: #007700">,</span><span style="color: #0000BB">Scale</span><span style="color: #007700">,</span><span style="color: #0000BB">BCHeight</span><span style="color: #007700">,</span><span style="color: #0000BB">BCRadius&nbsp;</span><span style="color: #007700">,</span><span style="color: #0000BB">EventID</span><span style="color: #007700">,</span><span style="color: #0000BB">AssocFileObj128</span><span style="color: #007700">,</span><span style="color: #0000BB">AssocFileDrop128</span><span style="color: #007700">,</span><span style="color: #0000BB">AssocFileIcon128</span><span style="color: #007700">,</span><span style="color: #0000BB">AssocFile1_128</span><span style="color: #007700">,</span><span style="color: #0000BB">AssocFile2_128</span><span style="color: #007700">,</span><span style="color: #0000BB">Link</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,@</span><span style="color: #0000BB">MAXCOMMONID</span><span style="color: #007700">,</span><span style="color: #DD0000">'NPC_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,</span><span style="color: #DD0000">'SN_NPC_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">2</span><span style="color: #007700">,</span><span style="color: #0000BB">2</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">5000</span><span style="color: #007700">,</span><span style="color: #0000BB">3</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">100</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #DD0000">'npc\npc\chinawoman_Noblegirl_event.bsr'</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,@</span><span style="color: #0000BB">MAXLINK</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefObjCommon&nbsp;OFF&nbsp;SET&nbsp;IDENTITY_INSERT&nbsp;_RefObjChar&nbsp;ON&nbsp;INSERT&nbsp;INTO&nbsp;_RefObjChar&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">,</span><span style="color: #0000BB">Lvl</span><span style="color: #007700">,</span><span style="color: #0000BB">CharGender</span><span style="color: #007700">,</span><span style="color: #0000BB">MaxHP</span><span style="color: #007700">,</span><span style="color: #0000BB">MaxMP</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistFrozen</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistFrostbite</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistBurn</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistEShock</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistPoison</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistZombie</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistSleep</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistRoot</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistSlow</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistFear&nbsp;</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistMyopia</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistBlood</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistStone</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistDark</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistStun</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistDisea</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistChaos</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistCsePD</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistCseMD</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistCseSTR</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistCseINT</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistCseHP</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistCseMP</span><span style="color: #007700">,</span><span style="color: #0000BB">Resist24</span><span style="color: #007700">,</span><span style="color: #0000BB">ResistBomb</span><span style="color: #007700">,</span><span style="color: #0000BB">Resist26&nbsp;</span><span style="color: #007700">,</span><span style="color: #0000BB">Resist27</span><span style="color: #007700">,</span><span style="color: #0000BB">Resist28</span><span style="color: #007700">,</span><span style="color: #0000BB">Resist29</span><span style="color: #007700">,</span><span style="color: #0000BB">Resist30</span><span style="color: #007700">,</span><span style="color: #0000BB">Resist31</span><span style="color: #007700">,</span><span style="color: #0000BB">Resist32</span><span style="color: #007700">,</span><span style="color: #0000BB">InventorySize</span><span style="color: #007700">,</span><span style="color: #0000BB">CanStore_TID1</span><span style="color: #007700">,</span><span style="color: #0000BB">CanStore_TID2</span><span style="color: #007700">,</span><span style="color: #0000BB">CanStore_TID3</span><span style="color: #007700">,</span><span style="color: #0000BB">CanStore_TID4</span><span style="color: #007700">,</span><span style="color: #0000BB">CanBeVehicle</span><span style="color: #007700">,</span><span style="color: #0000BB">CanControl</span><span style="color: #007700">,</span><span style="color: #0000BB">DamagePortion</span><span style="color: #007700">,</span><span style="color: #0000BB">MaxPassenger</span><span style="color: #007700">,</span><span style="color: #0000BB">AssocTactics</span><span style="color: #007700">,</span><span style="color: #0000BB">PD</span><span style="color: #007700">,</span><span style="color: #0000BB">MD</span><span style="color: #007700">,</span><span style="color: #0000BB">PAR</span><span style="color: #007700">,</span><span style="color: #0000BB">MAR</span><span style="color: #007700">,</span><span style="color: #0000BB">ER</span><span style="color: #007700">,</span><span style="color: #0000BB">BR</span><span style="color: #007700">,</span><span style="color: #0000BB">HR</span><span style="color: #007700">,</span><span style="color: #0000BB">CHR&nbsp;</span><span style="color: #007700">,</span><span style="color: #0000BB">ExpToGive</span><span style="color: #007700">,</span><span style="color: #0000BB">CreepType</span><span style="color: #007700">,</span><span style="color: #0000BB">Knockdown</span><span style="color: #007700">,</span><span style="color: #0000BB">KO_RecoverTime</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_1</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_2</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_3</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_4</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_5</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_6</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_7</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_8</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_9</span><span style="color: #007700">,</span><span style="color: #0000BB">DefaultSkill_10</span><span style="color: #007700">,</span><span style="color: #0000BB">TextureType</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_1&nbsp;</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_2</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_3</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_4</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_5</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_6</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_7</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_8</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_9</span><span style="color: #007700">,</span><span style="color: #0000BB">Except_10</span><span style="color: #007700">,</span><span style="color: #0000BB">Link</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(@</span><span style="color: #0000BB">MAXLINK</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">336860180</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefObjChar&nbsp;OFF&nbsp;SET&nbsp;IDENTITY_INSERT&nbsp;_RefShop&nbsp;ON&nbsp;</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">ShopID&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefShop</span><span style="color: #007700">)+</span><span style="color: #0000BB">1&nbsp;INSERT&nbsp;INTO&nbsp;_RefShop&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,</span><span style="color: #0000BB">Country</span><span style="color: #007700">,</span><span style="color: #0000BB">ID</span><span style="color: #007700">,</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,</span><span style="color: #0000BB">Param1</span><span style="color: #007700">,</span><span style="color: #0000BB">Param1_Desc128</span><span style="color: #007700">,</span><span style="color: #0000BB">Param2</span><span style="color: #007700">,</span><span style="color: #0000BB">Param2_Desc128</span><span style="color: #007700">,</span><span style="color: #0000BB">Param3</span><span style="color: #007700">,</span><span style="color: #0000BB">Param3_Desc128</span><span style="color: #007700">,</span><span style="color: #0000BB">Param4</span><span style="color: #007700">,</span><span style="color: #0000BB">Param4_Desc128</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">15</span><span style="color: #007700">,@</span><span style="color: #0000BB">ShopID</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefShop&nbsp;OFF&nbsp;SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopGroup&nbsp;ON&nbsp;</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">ShopGroupID&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefShopGroup</span><span style="color: #007700">)+</span><span style="color: #0000BB">1&nbsp;INSERT&nbsp;INTO&nbsp;_RefShopGroup&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,</span><span style="color: #0000BB">Country</span><span style="color: #007700">,</span><span style="color: #0000BB">ID</span><span style="color: #007700">,</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,</span><span style="color: #0000BB">RefNPCCodeName</span><span style="color: #007700">,</span><span style="color: #0000BB">Param1</span><span style="color: #007700">,</span><span style="color: #0000BB">Param1_Desc128</span><span style="color: #007700">,</span><span style="color: #0000BB">Param2</span><span style="color: #007700">,</span><span style="color: #0000BB">Param2_Desc128</span><span style="color: #007700">,</span><span style="color: #0000BB">Param3</span><span style="color: #007700">,</span><span style="color: #0000BB">Param3_Desc128</span><span style="color: #007700">,</span><span style="color: #0000BB">Param4</span><span style="color: #007700">,</span><span style="color: #0000BB">Param4_Desc128</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">15</span><span style="color: #007700">,@</span><span style="color: #0000BB">ShopGroupID</span><span style="color: #007700">,</span><span style="color: #DD0000">'GROUP_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">,</span><span style="color: #DD0000">'NPC_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,-</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopGroup&nbsp;OFF&nbsp;SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopItemGroup&nbsp;ON&nbsp;</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">ShopItemID&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">GROUPID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefShopItemGroup</span><span style="color: #007700">)+</span><span style="color: #0000BB">1&nbsp;INSERT&nbsp;INTO&nbsp;_RefShopItemGroup&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,</span><span style="color: #0000BB">GroupID</span><span style="color: #007700">,</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,</span><span style="color: #0000BB">StrID128_Group</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,@</span><span style="color: #0000BB">ShopItemID</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1'</span><span style="color: #007700">,</span><span style="color: #DD0000">'SN_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1'</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopItemGroup&nbsp;OFF&nbsp;SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopTab&nbsp;ON&nbsp;</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">ShopTabID&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefShopTab</span><span style="color: #007700">)+</span><span style="color: #0000BB">1&nbsp;INSERT&nbsp;INTO&nbsp;_RefShopTab&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,</span><span style="color: #0000BB">Country</span><span style="color: #007700">,</span><span style="color: #0000BB">ID</span><span style="color: #007700">,</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,</span><span style="color: #0000BB">RefTabGroupCodeName</span><span style="color: #007700">,</span><span style="color: #0000BB">StrID128_Tab</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">15</span><span style="color: #007700">,@</span><span style="color: #0000BB">ShopTabID</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_TAB1'</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1'</span><span style="color: #007700">,</span><span style="color: #DD0000">'SN_TAB_Stones'</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopTab&nbsp;OFF&nbsp;SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopTabGroup&nbsp;ON&nbsp;</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">ShopTabGroupID&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefShopTabGroup</span><span style="color: #007700">)+</span><span style="color: #0000BB">1&nbsp;INSERT&nbsp;INTO&nbsp;_RefShopTabGroup&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,</span><span style="color: #0000BB">Country</span><span style="color: #007700">,</span><span style="color: #0000BB">ID</span><span style="color: #007700">,</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,</span><span style="color: #0000BB">StrID128_Group</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">15</span><span style="color: #007700">,@</span><span style="color: #0000BB">ShopTabGroupID</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1'</span><span style="color: #007700">,</span><span style="color: #DD0000">'SN_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1'</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopTabGroup&nbsp;OFF&nbsp;INSERT&nbsp;INTO&nbsp;_RefMappingShopGroup&nbsp;VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">15</span><span style="color: #007700">,</span><span style="color: #DD0000">'GROUP_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">INSERT&nbsp;INTO&nbsp;_RefMappingShopWithTab&nbsp;VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">15</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1'</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">TACTICSID&nbsp;INT&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">TACTICSID&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">dwTacticsID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;Tab_RefTactics</span><span style="color: #007700">)+</span><span style="color: #0000BB">10&nbsp;INSERT&nbsp;INTO&nbsp;Tab_RefTactics&nbsp;VALUES&nbsp;</span><span style="color: #007700">(@</span><span style="color: #0000BB">TACTICSID</span><span style="color: #007700">,@</span><span style="color: #0000BB">MAXCOMMONID</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #DD0000">'NPC_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">BEGIN</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">HIVEID&nbsp;INT&nbsp;&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">HIVEID&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">dwHiveID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;Tab_RefHive</span><span style="color: #007700">)+</span><span style="color: #0000BB">1&nbsp;INSERT&nbsp;INTO&nbsp;Tab_RefHive&nbsp;VALUES&nbsp;</span><span style="color: #007700">(@</span><span style="color: #0000BB">HIVEID</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,@</span><span style="color: #0000BB">GAMEWORDID</span><span style="color: #007700">,</span><span style="color: #0000BB">2</span><span style="color: #007700">,</span><span style="color: #DD0000">'NPC_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">ENDBEGIN</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">REGION&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">REGION&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">LatestRegion</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_Char&nbsp;WHERE&nbsp;CharName16&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CHARNAME</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">POSX&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">POSX&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">POSX</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_Char&nbsp;WHERE&nbsp;CharName16&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CHARNAME</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">POSY&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">POSY&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">POSY</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_Char&nbsp;WHERE&nbsp;CharName16&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CHARNAME</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">POSZ&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">POSZ&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">POSZ</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_Char&nbsp;WHERE&nbsp;CharName16&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CHARNAME</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">NESTID&nbsp;INT&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">NESTID&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">dwNestID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;Tab_RefNest</span><span style="color: #007700">)+</span><span style="color: #0000BB">1&nbsp;INSERT&nbsp;INTO&nbsp;Tab_RefNest&nbsp;VALUES&nbsp;</span><span style="color: #007700">(@</span><span style="color: #0000BB">NESTID</span><span style="color: #007700">,@</span><span style="color: #0000BB">HIVEID</span><span style="color: #007700">,@</span><span style="color: #0000BB">TACTICSID</span><span style="color: #007700">,@</span><span style="color: #0000BB">REGION</span><span style="color: #007700">,@</span><span style="color: #0000BB">POSX</span><span style="color: #007700">,@</span><span style="color: #0000BB">POSY</span><span style="color: #007700">,@</span><span style="color: #0000BB">POSZ</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">,</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">0</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">END</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'add&nbsp;this&nbsp;line&nbsp;to&nbsp;characterdata_45000&nbsp;@&nbsp;server_dep\silkroad\textdata'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">MAXCOMMONID</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'SN_NPC_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;5000&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;100&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;npc\npc\chinawoman_Noblegirl_event.bsr&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;336860180&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;0'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Add&nbsp;this&nbsp;line&nbsp;to&nbsp;refshop.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">SHOPID</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;xxx'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Add&nbsp;this&nbsp;line&nbsp;to&nbsp;refshopgroup.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">SHOPGROUPID</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'GROUP_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'NPC_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;xxx&nbsp;&nbsp;&nbsp;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;xxx'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Add&nbsp;this&nbsp;line&nbsp;to&nbsp;shopgroupdata.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">SHOPITEMID</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'SN_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Add&nbsp;this&nbsp;line&nbsp;to&nbsp;refshoptab.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">SHOPTABID</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_TAB1&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SN_TAB_Stones'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Add&nbsp;this&nbsp;line&nbsp;to&nbsp;refshoptabgroup.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">SHOPTABGROUPID</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'SN_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Add&nbsp;this&nbsp;line&nbsp;to&nbsp;refmappingshopgroup.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'GROUP_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Add&nbsp;this&nbsp;line&nbsp;to&nbsp;refmappingshopwithtab.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'_GROUP1'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'A&nbsp;New&nbsp;NPC&nbsp;Has&nbsp;ADD&nbsp;Succesfuly&nbsp;Restart&nbsp;U&nbsp;Server&nbsp;and&nbsp;Login&nbsp;in&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">CHARNAME&nbsp;END&nbsp;
</span>
</span>
</code><!-- php buffer end --> 

        </code> 

</div> 

</div> 

</td> 

</tr> 

</table>[/SPOILER]

<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS">[IMG]http://www9.0zz0.com/2013/02/21/19/982803167.gif[/IMG]
</font></font></font></font></font></font></font></font></font></font></font></font><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4">
<font color="Black"><font color="Blue"> Add New Group</font>
</font></font></font></font>
[SPOILER]
<table cellpadding="6" cellspacing="0"  border="0" width="620" style="border: 1px dotted #499c00; margin: 10px;  width: 620px;"> 

<tr> 

<td style="background: #e7ffd9  url(http://img834.imageshack.us/img834/4213/php.gif) no-repeat top  left; height: 20px;"> 

</td> 

</tr> 

<tr> 

<td> 

 

<div dir="ltr" style="width: 620px; height: 498px; text-align: left; overflow: auto"> 

        <code style="white-space:nowrap"> 

            <!-- php buffer start --><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">CHARNAME&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">NPCNAME&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">ADDNEW&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">GROUPNEW&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">CHARNAME&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Frebs'&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">U&nbsp;Char&nbsp;NameSET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">NPCNAME&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'STATIC'&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">U&nbsp;NPC&nbsp;NAMESET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">2SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">ADDNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'GROUP'</span><span style="color: #007700">--IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">2&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP2'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">3&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP3'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">4&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP4'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">5&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP5'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">6&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP6'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">ADDNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'GROUP'&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopTabGroup&nbsp;ON</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">ShopTabGroupID&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">ShopTabGroupID&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefShopTabGroup</span><span style="color: #007700">)+</span><span style="color: #0000BB">1INSERT&nbsp;INTO&nbsp;_RefShopTabGroup&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,</span><span style="color: #0000BB">Country</span><span style="color: #007700">,</span><span style="color: #0000BB">ID</span><span style="color: #007700">,</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,</span><span style="color: #0000BB">StrID128_Group</span><span style="color: #007700">)</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">15</span><span style="color: #007700">,@</span><span style="color: #0000BB">ShopTabGroupID</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">GROUPNEW</span><span style="color: #007700">,</span><span style="color: #DD0000">'SN_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">GROUPNEW</span><span style="color: #007700">)</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopTabGroup&nbsp;OFFINSERT&nbsp;INTO&nbsp;_RefMappingShopWithTab&nbsp;VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">15</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">GROUPNEW</span><span style="color: #007700">)PRINT&nbsp;</span><span style="color: #DD0000">''</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'New&nbsp;Group&nbsp;Added&nbsp;Succesfully&nbsp;'</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'add&nbsp;this&nbsp;new&nbsp;line&nbsp;to&nbsp;refshoptabgroup.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">SHOPTABGROUPID</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">GROUPNEW</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;SN_STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">GROUPNEW</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'add&nbsp;this&nbsp;new&nbsp;line&nbsp;to&nbsp;refmappingshopwithtab.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">GROUPNEWEND&nbsp;
</span>
</span>
</code><!-- php buffer end --> 

        </code> 

</div> 

</div> 

</td> 

</tr> 

</table>[/SPOILER]

</font></font></font></font></font></font></font></font></font></font></font></font>
<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS">[IMG]http://www9.0zz0.com/2013/02/21/19/982803167.gif[/IMG]

</font></font></font></font></font></font></font></font></font></font></font></font><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="SeaGreen">
</font><font color="SeaGreen">Add New Tab</font>

[SPOILER]
<table cellpadding="6" cellspacing="0"  border="0" width="620" style="border: 1px dotted #499c00; margin: 10px;  width: 620px;"> 

<tr> 

<td style="background: #e7ffd9  url(http://img834.imageshack.us/img834/4213/php.gif) no-repeat top  left; height: 20px;"> 

</td> 

</tr> 

<tr> 

<td> 

 

<div dir="ltr" style="width: 620px; height: 498px; text-align: left; overflow: auto"> 

        <code style="white-space:nowrap"> 

            <!-- php buffer start --><code><span style="color: #000000">
<span style="color: #0000BB">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">CHARNAME&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">NPCNAME&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">ADDNEW&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">TABNAME&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">TABNUMBER&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">TABNEW&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;DECLARE&nbsp;@</span><span style="color: #0000BB">GROUPNEW&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)--</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">ADDNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'TAB'&nbsp;</span><span style="color: #007700">--&nbsp;</span><span style="color: #DD0000">'NPC'&nbsp;</span><span style="color: #0000BB">to&nbsp;add&nbsp;a&nbsp;</span><span style="color: #007700">new&nbsp;</span><span style="color: #0000BB">npc</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'TAB'&nbsp;</span><span style="color: #007700">for&nbsp;</span><span style="color: #0000BB">add&nbsp;a&nbsp;</span><span style="color: #007700">new&nbsp;</span><span style="color: #0000BB">Tab</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'GROUP'&nbsp;</span><span style="color: #007700">for&nbsp;</span><span style="color: #0000BB">add&nbsp;a&nbsp;</span><span style="color: #007700">new&nbsp;</span><span style="color: #0000BB">group</span><span style="color: #007700">!</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">CHARNAME&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Frebs'&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">U&nbsp;Char&nbsp;NameSET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">NPCNAME&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Devils&nbsp;Sro&nbsp;Shop'&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">U&nbsp;NPC&nbsp;NAMESET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">TABNUMBER&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">2SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">TABNAME&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Euro'</span><span style="color: #007700">--IF&nbsp;@</span><span style="color: #0000BB">TABNUMBER&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">2&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">TABNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_TAB2'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">TABNUMBER&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">3&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">TABNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_TAB3'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">TABNUMBER&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">4&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">TABNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_TAB4'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP1'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">2&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP2'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">3&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP3'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">4&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP4'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">5&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP5'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">GROUPNUMBER&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">6&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">GROUPNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'_GROUP6'</span><span style="color: #007700">IF&nbsp;@</span><span style="color: #0000BB">ADDNEW&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'TAB'&nbsp;</span><span style="color: #0000BB">BEGINSET&nbsp;IDENTITY_INSERT&nbsp;_RefShopTab&nbsp;ON</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">ShopTabID&nbsp;VARCHAR&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">30</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">ShopTabID&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;MAX&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefShopTab</span><span style="color: #007700">)+</span><span style="color: #0000BB">1INSERT&nbsp;INTO&nbsp;_RefShopTab&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,</span><span style="color: #0000BB">Country</span><span style="color: #007700">,</span><span style="color: #0000BB">ID</span><span style="color: #007700">,</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,</span><span style="color: #0000BB">RefTabGroupCodeName</span><span style="color: #007700">,</span><span style="color: #0000BB">StrID128_Tab</span><span style="color: #007700">)</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,</span><span style="color: #0000BB">15</span><span style="color: #007700">,@</span><span style="color: #0000BB">ShopTabID</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">TABNEW</span><span style="color: #007700">,</span><span style="color: #DD0000">'STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">GROUPNEW</span><span style="color: #007700">,</span><span style="color: #DD0000">'SN_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">TABNAME</span><span style="color: #007700">)</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefShopTab&nbsp;OFF</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">''</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'New&nbsp;Tab&nbsp;added&nbsp;Sucessfully&nbsp;add&nbsp;this&nbsp;new&nbsp;line&nbsp;to&nbsp;refshoptab.txt&nbsp;@&nbsp;server_dep\silkroad\textdata'&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'1&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;'</span><span style="color: #007700">+@</span><span style="color: #0000BB">SHOPTABID</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">TABNEW</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;STORE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">NPCNAME</span><span style="color: #007700">+@</span><span style="color: #0000BB">GROUPNEW</span><span style="color: #007700">+</span><span style="color: #DD0000">'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SN_TAB_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">TABNAMEEND&nbsp;
</span>
</span>
</code><!-- php buffer end --> 

        </code> 

</div> 

</div> 

</td> 

</tr> 

</table>[/SPOILER]
</font></font></font>
<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS">[IMG]http://www9.0zz0.com/2013/02/21/19/982803167.gif[/IMG]

</font></font></font></font></font></font></font></font></font></font></font></font><font face="Comic Sans MS"><font color="Navy"><font size="4">
<font color="SeaGreen">Add items to npc</font></font></font></font>

<table cellpadding="6" cellspacing="0"  border="0" width="620" style="border: 1px dotted #ff9c00; margin: 10px;  width: 620px;"> 

<tr> 

<td style="background: #fffbc3  url(http://img705.imageshack.us/img705/962/quotey.gif) no-repeat top  left; height: 20px;"> 

</td> 

</tr> 

 

<tr> 

<td> 

 

<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Black">
طريقة تشغيل ال Query ..

<font color="Purple">SQL</font> ==> <font color="Purple">SRO_VT_SHARD</font> ==> <font color="Purple">Tables</font> 
<font color="Red">  RefPackageItem</font></font>
<font color="Purple">Design</font> ==> <font color="Purple">right click ID Column Set a primary key</font> ==> <font color="Purple">Column Properties</font> ==> <font color="Purple">Indetity Spercification</font> ==> <font color="Red">Set it Off</font>

وبعدين

 <font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Black"><font color="Purple">SQL </font>==> <font color="Purple">SRO_VT_SHARD</font> ==> <font color="Purple">Tables</font> 
<font color="Red">  RefScrapOfPackageItem</font></font>
<font color="Purple">Design</font> ==> <font color="Purple">right click ID Column Set a primary key</font> ==> <font color="Purple">Column Properties</font> ==> <font color="Purple">Indetity Spercification</font> ==> <font color="Purple">[ Index ]</font> ==> <font color="Red">Set it Off</font></font></font></font>
</font></font></font> 

 

</td> 

</tr> 

</table>By Eljoker

[SPOILER]
<table cellpadding="6" cellspacing="0"  border="0" width="620" style="border: 1px dotted #499c00; margin: 10px;  width: 620px;"> 

<tr> 

<td style="background: #e7ffd9  url(http://img834.imageshack.us/img834/4213/php.gif) no-repeat top  left; height: 20px;"> 

</td> 

</tr> 

<tr> 

<td> 

 

<div dir="ltr" style="width: 620px; height: 498px; text-align: left; overflow: auto"> 

        <code style="white-space:nowrap"> 

            <!-- php buffer start --><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #007700">USE&nbsp;</span><span style="color: #0000BB">SRO_VT_SHARDGO</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">ID&nbsp;int</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">INDEX&nbsp;int</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">CodeName&nbsp;varchar</span><span style="color: #007700">(</span><span style="color: #0000BB">128</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">PackageName&nbsp;varchar</span><span style="color: #007700">(</span><span style="color: #0000BB">128</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">DescSTRID&nbsp;varchar</span><span style="color: #007700">(</span><span style="color: #0000BB">128</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">File&nbsp;varchar</span><span style="color: #007700">(</span><span style="color: #0000BB">128</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">Price&nbsp;int</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">SilkPrice&nbsp;int</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">Slot&nbsp;tinyint</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">TAB&nbsp;varchar</span><span style="color: #007700">(</span><span style="color: #0000BB">128</span><span style="color: #007700">)DECLARE&nbsp;@</span><span style="color: #0000BB">Data&nbsp;int</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">SkipScrapOfPackageItem&nbsp;int&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">SkipPackageItem&nbsp;int&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">DECLARE&nbsp;@</span><span style="color: #0000BB">SkipPricePolicyOfItem&nbsp;int&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">---&nbsp;</span><span style="color: #0000BB">Set&nbsp;VariablesSET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">CodeName&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'ITEM_EU_SHIELD_08_C_RARE'&nbsp;</span><span style="color: #007700">--&nbsp;</span><span style="color: #0000BB">Item&nbsp;CodeName&nbsp;in&nbsp;RefObjCommonSET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">Price&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">5000000&nbsp;</span><span style="color: #007700">--&nbsp;</span><span style="color: #0000BB">Set&nbsp;0&nbsp;</span><span style="color: #007700">if&nbsp;</span><span style="color: #0000BB">you&nbsp;don</span><span style="color: #DD0000">'t&nbsp;want&nbsp;to&nbsp;set&nbsp;Gold&nbsp;PriceSET&nbsp;@SilkPrice&nbsp;=&nbsp;256&nbsp;--&nbsp;Set&nbsp;0&nbsp;if&nbsp;you&nbsp;don'</span><span style="color: #0000BB">t&nbsp;want&nbsp;to&nbsp;set&nbsp;Silk&nbsp;PriceSET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">TAB&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'STORE_Honor_TAB1'&nbsp;</span><span style="color: #007700">--&nbsp;</span><span style="color: #0000BB">Tab&nbsp;name&nbsp;in&nbsp;NPC</span><span style="color: #007700">,&nbsp;For&nbsp;</span><span style="color: #0000BB">_RefShopGoodsSET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">PackageName&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'PACKAGE_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">CodeName&nbsp;</span><span style="color: #007700">--&nbsp;Do&nbsp;</span><span style="color: #0000BB">not&nbsp;edit&nbsp;</span><span style="color: #007700">if&nbsp;</span><span style="color: #0000BB">you&nbsp;don</span><span style="color: #DD0000">'t&nbsp;know&nbsp;what&nbsp;are&nbsp;you&nbsp;doing.---&nbsp;you&nbsp;don'</span><span style="color: #0000BB">t&nbsp;need&nbsp;to&nbsp;touch&nbsp;here</span><span style="color: #007700">...IF&nbsp;(@</span><span style="color: #0000BB">CodeName&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">''</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'You&nbsp;have&nbsp;to&nbsp;edit&nbsp;CodeName..!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'FAILED.'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN</span><span style="color: #0000BB">END</span><span style="color: #007700">IF&nbsp;((</span><span style="color: #0000BB">SELECT&nbsp;COUNT</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefObjCommon&nbsp;WHERE&nbsp;CodeName128&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CodeName</span><span style="color: #007700">)&nbsp;<&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'There&nbsp;is&nbsp;no&nbsp;item&nbsp;with&nbsp;this&nbsp;CodeName..!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'FAILED.'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN</span><span style="color: #0000BB">END</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">Price&nbsp;</span><span style="color: #007700"><&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Price&nbsp;is&nbsp;not&nbsp;VALID..!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'FAILED.'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN</span><span style="color: #0000BB">END</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">SilkPrice&nbsp;</span><span style="color: #007700"><&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Silk&nbsp;Price&nbsp;is&nbsp;not&nbsp;VALID..!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'FAILED.'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN</span><span style="color: #0000BB">END</span><span style="color: #007700">IF&nbsp;((</span><span style="color: #0000BB">SELECT&nbsp;COUNT</span><span style="color: #007700">(</span><span style="color: #0000BB">ID</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefShopTab&nbsp;WHERE&nbsp;CodeName128&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">TAB</span><span style="color: #007700">)&nbsp;<&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'TAB&nbsp;VALUE&nbsp;IS&nbsp;NOT&nbsp;VALID..!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'FAILED.'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN</span><span style="color: #0000BB">END</span><span style="color: #007700">IF&nbsp;((</span><span style="color: #0000BB">SELECT&nbsp;COUNT&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">RefPackageItemCodeName</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefShopGoods&nbsp;WHERE&nbsp;RefPackageItemCodeName&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">PackageName&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">RefTabCodeName&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">TAB</span><span style="color: #007700">)&nbsp;>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'There&nbsp;is&nbsp;already&nbsp;same&nbsp;item&nbsp;in&nbsp;same&nbsp;tab..!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'FAILED.'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN</span><span style="color: #0000BB">END</span><span style="color: #007700">IF&nbsp;((</span><span style="color: #0000BB">SELECT&nbsp;COUNT&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">RefPackageItemCodeName</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefScrapOfPackageItem&nbsp;WHERE&nbsp;RefPackageItemCodeName&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">PackageName</span><span style="color: #007700">)&nbsp;>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'There&nbsp;is&nbsp;already&nbsp;an&nbsp;entry&nbsp;for&nbsp;this&nbsp;item,&nbsp;skipping&nbsp;@_RefScrapOfPackageItem&nbsp;table..!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">SkipScrapOfPackageItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1END</span><span style="color: #007700">IF&nbsp;((</span><span style="color: #0000BB">SELECT&nbsp;COUNT&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefPackageItem&nbsp;WHERE&nbsp;CodeName128&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">PackageName</span><span style="color: #007700">)&nbsp;>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'There&nbsp;is&nbsp;already&nbsp;an&nbsp;entry&nbsp;for&nbsp;this&nbsp;item,&nbsp;skipping&nbsp;@_RefPackageItem&nbsp;table..!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">SkipPackageItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1END</span><span style="color: #007700">IF&nbsp;((</span><span style="color: #0000BB">SELECT&nbsp;COUNT&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">PaymentDevice</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefPricePolicyOfItem&nbsp;WHERE&nbsp;RefPackageItemCodeName&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">PackageName&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">PaymentDevice&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'1'</span><span style="color: #007700">)&nbsp;>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'There&nbsp;is&nbsp;already&nbsp;an&nbsp;entry&nbsp;for&nbsp;this&nbsp;item&nbsp;with&nbsp;same&nbsp;PaymentDevice,&nbsp;skipping&nbsp;@_RefPricePolicyOfItem&nbsp;table..!&nbsp;(Gold)'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">SkipPricePolicyOfItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1END</span><span style="color: #007700">IF&nbsp;((</span><span style="color: #0000BB">SELECT&nbsp;COUNT&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">PaymentDevice</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefPricePolicyOfItem&nbsp;WHERE&nbsp;RefPackageItemCodeName&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">PackageName&nbsp;</span><span style="color: #007700">AND&nbsp;</span><span style="color: #0000BB">PaymentDevice&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'2'</span><span style="color: #007700">)&nbsp;>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'There&nbsp;is&nbsp;already&nbsp;an&nbsp;entry&nbsp;for&nbsp;this&nbsp;item&nbsp;with&nbsp;same&nbsp;PaymentDevice,&nbsp;skipping&nbsp;@_RefPricePolicyOfItem&nbsp;table..!&nbsp;(Silk)'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">SkipPricePolicyOfItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">SkipPricePolicyOfItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">3&nbsp;&nbsp;&nbsp;&nbsp;END&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">ELSE&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">SkipPricePolicyOfItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">2&nbsp;&nbsp;&nbsp;&nbsp;ENDEND</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">SilkPrice&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)&nbsp;AND&nbsp;(@</span><span style="color: #0000BB">Price&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'You&nbsp;need&nbsp;to&nbsp;set&nbsp;a&nbsp;price,&nbsp;at&nbsp;least&nbsp;one&nbsp;!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'FAILED.'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN</span><span style="color: #0000BB">ENDSELECT&nbsp;TOP&nbsp;1&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">ID&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">ID&nbsp;FROM&nbsp;_RefPackageItem&nbsp;ORDER&nbsp;BY&nbsp;ID&nbsp;DESCSET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">ID&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">ID&nbsp;</span><span style="color: #007700">+&nbsp;</span><span style="color: #0000BB">1SELECT&nbsp;TOP&nbsp;1&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">INDEX&nbsp;</span><span style="color: #007700">=&nbsp;[</span><span style="color: #0000BB">Index</span><span style="color: #007700">]&nbsp;</span><span style="color: #0000BB">FROM&nbsp;_RefScrapOfPackageItem&nbsp;ORDER&nbsp;BY&nbsp;</span><span style="color: #007700">[</span><span style="color: #0000BB">Index</span><span style="color: #007700">]&nbsp;</span><span style="color: #0000BB">DESCSET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">INDEX&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">INDEX&nbsp;</span><span style="color: #007700">+&nbsp;</span><span style="color: #0000BB">1SELECT&nbsp;TOP&nbsp;1&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">SlotIndex&nbsp;FROM&nbsp;_RefShopGoods&nbsp;WHERE&nbsp;RefTabCodeName&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">TAB&nbsp;ORDER&nbsp;BY&nbsp;SlotIndex&nbsp;DESC</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">+&nbsp;</span><span style="color: #0000BB">1END</span><span style="color: #007700">ELSE&nbsp;IF&nbsp;(@</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">+&nbsp;</span><span style="color: #0000BB">1END</span><span style="color: #007700">ELSE</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">Slot&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0ENDSET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">DescSTRID&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'SN_'&nbsp;</span><span style="color: #007700">+&nbsp;@</span><span style="color: #0000BB">CodeName&nbsp;</span><span style="color: #007700">+&nbsp;</span><span style="color: #DD0000">'_TT_DESC'</span><span style="color: #0000BB">SELECT&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">File&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">AssocFileIcon128&nbsp;FROM&nbsp;_RefObjCommon&nbsp;WHERE&nbsp;CodeName128&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CodeName</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">CodeName&nbsp;LIKE&nbsp;</span><span style="color: #DD0000">'%RING%'&nbsp;</span><span style="color: #007700">OR&nbsp;@</span><span style="color: #0000BB">CodeName&nbsp;LIKE&nbsp;</span><span style="color: #DD0000">'%NECKLACE%'&nbsp;</span><span style="color: #007700">OR&nbsp;@</span><span style="color: #0000BB">CodeName&nbsp;LIKE&nbsp;</span><span style="color: #DD0000">'%ARCHEMY%'</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;SET&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">Data&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1END</span><span style="color: #007700">ELSE</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;SELECT&nbsp;</span><span style="color: #007700">@</span><span style="color: #0000BB">Data&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">Dur_U&nbsp;FROM&nbsp;_RefObjItem&nbsp;WHERE&nbsp;ID&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">SELECT&nbsp;Link&nbsp;FROM&nbsp;_RefObjCommon&nbsp;WHERE&nbsp;CodeName128&nbsp;</span><span style="color: #007700">=&nbsp;@</span><span style="color: #0000BB">CodeName</span><span style="color: #007700">)</span><span style="color: #0000BB">ENDBEGIN&nbsp;TRANSACTION</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">SkipPackageItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefPackageItem&nbsp;ON&nbsp;&nbsp;&nbsp;&nbsp;INSERT&nbsp;_RefPackageItem&nbsp;</span><span style="color: #007700">([</span><span style="color: #0000BB">Service</span><span style="color: #007700">],&nbsp;</span><span style="color: #0000BB">Country</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">ID</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">CodeName128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">SaleTag</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">ExpandTerm</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">NameStrID</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">DescStrID</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">AssocFileIcon</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4_Desc128</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">15</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">ID</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">PackageName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'EXPAND_TERM_ALL'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'SN_'</span><span style="color: #007700">+@</span><span style="color: #0000BB">CodeName</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">DescSTRID</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">File</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(@@</span><span style="color: #0000BB">ERROR&nbsp;</span><span style="color: #007700"><>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'AN&nbsp;ERROR&nbsp;HAPPENED&nbsp;WHILE&nbsp;ADDING&nbsp;TO&nbsp;_RefPackageItem,&nbsp;Rolling&nbsp;back...'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">ROLLBACK&nbsp;TRANSACTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">END&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Added&nbsp;to&nbsp;_RefPackageItem&nbsp;!'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">--</span><span style="color: #0000BB">SET&nbsp;IDENTITY_INSERT&nbsp;_RefPackageItem&nbsp;OFFEND</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">SkipScrapOfPackageItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;INSERT&nbsp;_RefScrapOfPackageItem&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Country</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">RefPackageItemCodeName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">RefItemCodeName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">OptLevel</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Variance</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Data</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParamNum</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam2</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam3</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam4</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam5</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam6</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam7</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam8</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam9</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam10</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam11</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">MagParam12</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4_Desc128</span><span style="color: #007700">,&nbsp;[</span><span style="color: #0000BB">Index</span><span style="color: #007700">])&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">15</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">PackageName</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">CodeName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">Data</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">INDEX</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(@@</span><span style="color: #0000BB">ERROR&nbsp;</span><span style="color: #007700"><>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'AN&nbsp;ERROR&nbsp;HAPPENED&nbsp;WHILE&nbsp;ADDING&nbsp;TO&nbsp;_RefScrapOfPackageItem,&nbsp;Rolling&nbsp;back...'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">ROLLBACK&nbsp;TRANSACTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">END&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Added&nbsp;to&nbsp;_RefScrapOfPackageItem&nbsp;!'</span><span style="color: #0000BB">END</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">SkipPricePolicyOfItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">2&nbsp;</span><span style="color: #007700">OR&nbsp;@</span><span style="color: #0000BB">SkipPricePolicyOfItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0&nbsp;</span><span style="color: #007700">AND&nbsp;@</span><span style="color: #0000BB">Price&nbsp;</span><span style="color: #007700">>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;INSERT&nbsp;_RefPricePolicyOfItem&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Country</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">RefPackageItemCodeName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">PaymentDevice</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">PreviousCost</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Cost</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4_Desc128</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">15</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">PackageName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">Price</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(@@</span><span style="color: #0000BB">ERROR&nbsp;</span><span style="color: #007700"><>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'AN&nbsp;ERROR&nbsp;HAPPENED&nbsp;WHILE&nbsp;ADDING&nbsp;TO&nbsp;_RefPricePolicyOfItem,&nbsp;Rolling&nbsp;back...'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">ROLLBACK&nbsp;TRANSACTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">END&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Added&nbsp;to&nbsp;_RefPricePolicyOfItem,&nbsp;PaymentDevice&nbsp;=&nbsp;1&nbsp;(Gold)'</span><span style="color: #0000BB">END</span><span style="color: #007700">IF&nbsp;(@</span><span style="color: #0000BB">SkipPricePolicyOfItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1&nbsp;</span><span style="color: #007700">OR&nbsp;@</span><span style="color: #0000BB">SkipPricePolicyOfItem&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0&nbsp;</span><span style="color: #007700">AND&nbsp;@</span><span style="color: #0000BB">SilkPrice&nbsp;</span><span style="color: #007700">>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;INSERT&nbsp;_RefPricePolicyOfItem&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Country</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">RefPackageItemCodeName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">PaymentDevice</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">PreviousCost</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Cost</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4_Desc128</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">15</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">PackageName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">2</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">SilkPrice</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(@@</span><span style="color: #0000BB">ERROR&nbsp;</span><span style="color: #007700"><>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'AN&nbsp;ERROR&nbsp;HAPPENED&nbsp;WHILE&nbsp;ADDING&nbsp;TO&nbsp;_RefPricePolicyOfItem,&nbsp;Rolling&nbsp;back...'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">ROLLBACK&nbsp;TRANSACTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">END&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Added&nbsp;to&nbsp;_RefPricePolicyOfItem,&nbsp;PaymentDevice&nbsp;=&nbsp;2&nbsp;(Silk)'</span><span style="color: #0000BB">END</span><span style="color: #007700">ELSE</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'There&nbsp;is&nbsp;already&nbsp;silk&nbsp;/&nbsp;gold&nbsp;price,&nbsp;skipping&nbsp;_RefPricePolicyOfItem&nbsp;table...'</span><span style="color: #0000BB">ENDINSERT&nbsp;_RefShopGoods&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">Service</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Country</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">RefTabCodeName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">RefPackageItemCodeName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">SlotIndex</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param1_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param2_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param3_Desc128</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">Param4_Desc128</span><span style="color: #007700">)&nbsp;</span><span style="color: #0000BB">VALUES&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">15</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">TAB</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">PackageName</span><span style="color: #007700">,&nbsp;@</span><span style="color: #0000BB">Slot</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">,&nbsp;-</span><span style="color: #0000BB">1</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'xxx'</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(@@</span><span style="color: #0000BB">ERROR&nbsp;</span><span style="color: #007700"><>&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'An&nbsp;error&nbsp;happened&nbsp;while&nbsp;adding&nbsp;to&nbsp;_RefShopGoods&nbsp;table'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'FAILED.'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">ROLLBACK&nbsp;TRANSACTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">RETURN&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">END&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">PRINT&nbsp;</span><span style="color: #DD0000">'Added&nbsp;to&nbsp;_RefShopGoods,&nbsp;DONE!'</span><span style="color: #0000BB">COMMIT&nbsp;TRANSACTION&nbsp;
</span>
</span>
</code><!-- php buffer end --> 

        </code> 

</div> 

</div> 

</td> 

</tr> 

</table>[/SPOILER]


<font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS"><font face="Comic Sans MS"><font color="Navy"><font size="4"><font color="Blue"><font size="4"><font face="Comic Sans MS">[IMG]http://www9.0zz0.com/2013/02/21/19/982803167.gif[/IMG]


Add Silks With CharName
</font></font></font></font></font></font></font></font></font></font></font></font><b>[SPOILER]
[/SPOILER]</b>[SPOILER]</b>

[/SPOILER]

Add New Reverse Certain Poin
[SPOILER]
[/SPOILER][SPOILER]

 
            

DECLARE @Charname VARCHAR (max) = 'Frebs' /**CharName**/
DECLARE @minlvl VARCHAR (max) = '2' /**Minimum Level which can use the teleport**/
DECLARE @maxlvl VARCHAR (max) = '3' /**Maximum Level which can use the teleport**/
DECLARE @SN_ZONE VARCHAR (max) = 'SN_ZONE_25018_1' /**Zone Name (u can add it in textdata_object) example.**/



DECLARE @Region VARCHAR (max) = (Select LatestRegion From _Char Where CharName16 = @Charname)
DECLARE @X VARCHAR (max) = (Select PosX From _Char Where CharName16 = @Charname)
DECLARE @Y VARCHAR (max) = (Select PosY From _Char Where CharName16 = @Charname)
DECLARE @Z VARCHAR (max) = (Select PosZ From _Char Where CharName16 = @Charname)
DECLARE @MAXID VARCHAR (max) = (SELECT MAX (ID) FROM _RefOptionalTeleport)+1
Insert INTO _RefOptionalTeleport (Service,ID,ObjName128,ZoneName128,RegionID,Pos_X,Pos_Y,Pos_Z,WorldID,RegionIDGroup,MapPoint,LevelMin,LevelMax,Param1,Param1_Desc_128,Param2,Param2_Desc_128,Param3,Param3_Desc_128)
Values(1,@MAXID,'??????',@SN_ZONE,@Region,@X,@Y,@Z,1,1,1,@minlvl,@maxlvl,-1,'xxx',-1,'xxx',-1,'xxx')

print 'ADD THAT LINE IN media.pk2->Server_dep->silkroad->textdata->refoptionalteleport.txt'
Print '1 '+@MAXID+' ?????? '+@SN_ZONE+' '+@Region+' '+@X+' '+@Y+' '+@Z+' 1 1 1'+' '+@minlvl+' '+@maxlvl+' -1 xxx -1 xxx -1 xxx'[B][/B]

[/SPOILER]

Add New Unique spot

[SPOILER]

 
            
USE SRO_VT_SHARD 

DECLARE @UNIQUE VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @RADIUS int
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1

/* put your settings here */
SET @UNIQUE = 'MOB_TK_BONELORD' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'Frebs' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60  -- Minimum time before appears in seconds
SET @maxdelay = 120  -- Maximum time before appears in seconds
SET @INITRADIUS = 100  -- Radius around spot unique can generated at
SET @RADIUS = 200  -- Radius around spot Unique can move in
/* end of settings area */

/* get ID of mob by code name */
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)

--SET IDENTITY_INSERT Tab_RefTactics ON
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE)
--SET IDENTITY_INSERT Tab_RefTactics OFF

--SET IDENTITY_INSERT Tab_RefHive ON
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)
--SET IDENTITY_INSERT Tab_RefHive OFF

/* get position coordinates of your character */

DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)

--SET IDENTITY_INSERT Tab_RefNest ON
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)
--SET IDENTITY_INSERT Tab_RefNest OFF


print ''
print ''
print 'Done!'

[/SPOILER]

Add New Teleport

[SPOILER]

 
            
USE SRO_VT_SHARD 


DECLARE @Teleport VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE @OwnTeleport INT
DECLARE @Fee INT
DECLARE @RequiredLVL INT

/* Put your settings here */
SET @Teleport = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE
SET @CHARNAME1 = 'CHARNAME1' -- Teleport position
SET @CHARNAME2 = 'CHARNAME2' -- Spawn position after teleport
SET @OwnTeleport = 1  -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET @Fee = 50000  -- Gold amount to Pass the teleport
SET @RequiredLVL = 0  -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport
/* settings area end here */

IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_'+@Teleport)
 BEGIN
  raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport);
  RETURN;
 END
    
    DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
    DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1
     
    SET IDENTITY_INSERT _RefObjCommon ON
    INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
    (1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,'quest\teleport01.bsr','xxx','xxx','xxx','xxx',@link)
    SET IDENTITY_INSERT _RefObjCommon OFF
    
    print ''
    print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder'
    print '1    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'STORE_'+@Teleport+'    '+@Teleport+'    xxx    '+'SN_STORE_'+@Teleport+'    xxx    0    0    4    1    1    0    0    3    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    '+CONVERT(varchar(max),@REGION1)+'    0    '+CONVERT(varchar(max),@POSX1)+'    '+CONVERT(varchar(max),@POSY1)+'    '+CONVERT(varchar(max),@POSZ1)+'    0    0    50    50    30    0    quest\teleport01.bsr    xxx    xxx    xxx    xxx    '+CONVERT(varchar(max),@link)
    print ''
    print 'Add the following line to textdata_object.txt @server_dep\silkroad\textdata folder'
    print ''
    print '1    '+'SN_STORE_'+@Teleport+'                                '+@Teleport
    print ''
      print ''

  SET IDENTITY_INSERT _RefObjStruct ON
  INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES
  (@LINK,0)
  SET IDENTITY_INSERT _RefObjStruct OFF
  
  DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1
  DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)
  DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)
  DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)
  DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)
  DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2)

  INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES
  (1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport,@MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POSY2,@POSZ2,30,0,0,@WORLDID,1,0)
  
  print ''
  print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder'
  print '1    '+CONVERT(varchar(max),@MAXTELID)+'    '+'GATE_'+@Teleport+'    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'SN_STORE_'+@Teleport+'    '+CONVERT(varchar(max),@REGION2)+'    '+CONVERT(varchar(max),@POSX2)+'    '+CONVERT(varchar(max),@POSY2)+'    '+CONVERT(varchar(max),@POSZ2)+'    30    0    0    '+CONVERT(varchar(max),@WORLDID)+'    1    0'
  print ''
  print ''

  IF @RequiredLVL = 0
  BEGIN
    INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
    (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
    (1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    
print ''
    print 'Add the following lines to teleportlink.txt @server_dep\silkroad\textdata folder'
    print '1    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0'
    print '1    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0'
    print ''
  END
  ELSE BEGIN
    INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
    (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLVL,999,0,0,0,0,0,0,0,0,0,0,0,0)
    
    print ''
    print ''
    print 'Add the following line to teleportlink.txt @server_dep\silkroad\textdata folder'
    print '1    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    1    '+CONVERT(varchar(max),@RequiredLVL)+'    999    0    0    0    0    0    0    0    0    0    0    0    0'
    print ''

  END

print ''
print 'Done!'

[/SPOILER]

Add Silk To all Registered users

[SPOILER]

 
            
USE SRO_VT_ACCOUNT;
GO
INSERT INTO SK_SILK 
(JID,
silk_own,
silk_gift,
silk_point) 
SELECT JID,
'0',
'0',
'0'
FROM TB_User 
WHERE not exists (select * from SK_Silk 
WHERE SK_SILK.JID = TB_User.JID);
UPDATE SK_Silk SET silk_own=silk_own+10

[/SPOILER]

هتغير الـ 10 لـ الـ انت عايزو

Pick Up Any Item
[SPOILER]

se SRO_VT_SHARD UPDATE [dbo].[_RefObjCommon] SET CanPick = 1 WHERE CodeName128 like '%ITEM_ETC_AVATAR_M_GM_UNIFORM%' UPDATE [dbo].[_RefObjCommon] SET CanPick = 1 WHERE CodeName128 like '%ITEM_ETC_AVATAR_W_GM_UNIFORM%'

[/SPOILER]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

Check All Char Item By Charname

[SPOILER]

 
            
Select INV.CharID, CH.CharName16, INV.ItemID, IT.OptLevel, IT.RefItemID, INV.Slot, REF.ReqGender, REFC.AssocFileICon128, REF.Dur_L, REF.Dur_U, REF.PD_L, REF.PD_U, REF.MD_L, REF.MD_U, REF.ER_L, REF.ER_U, REF.PDStr_L, REF.PDStr_U, REF.MDInt_L, REF.MDInt_U, REF.MaxMagicOptCount, REF.PAttackMin_L, REF.PAttackMin_U, REF.PAttackMax_L, REF.PAttackMin_U, REF.MAttackMin_L, REF.MAttackMin_U, REF.MAttackMax_L, REF.MAttackMin_U, REF.Range, REF.HR_L, REF.HR_U, REF.CHR_L, REF.CHR_U, REF.PAStrMin_L, REF.PAStrMin_U, REF.PAStrMax_L, REF.PAStrMax_U, REF.MAInt_Min_L, REF.MAInt_Min_U, REF.MAInt_Max_L, REF.MAInt_Max_U, REF.PAR_L, REF.PAR_U, REF.MAR_L, REF.MAR_U, REFC.ReqLevel1, REFC.CodeName128 From _Inventory As INV  
Right Join _Items As IT On INV.ItemID = IT.ID64
Right Join _RefObjItem As REF On IT.RefItemID = REF.ID
Right Join _RefObjCommon As REFC On REFC.ID = REF.ID
Right Join _Char As CH On CH.CharID = INV.CharID
Where CH.CharName16 = 'Frebs'
Order By Slot Asc

[/SPOILER]

Create Guild Lvl 5

[SPOILER]

 
            
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Guild_Create] Script Date: 08/16/2012 23:40:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

--
ALTER PROCEDURE [dbo].[_Guild_Create]
@GuildName varchar(64),
@CreaterID int
as
if (exists (select id from _Guild where Name = @GuildName))
begin
         return -1000
end
if (exists (select CharID from _GuildMember where CharID = @CreaterID))
begin
         return -1001
end
begin transaction

declare @GuildID int
declare @FoundationDate smalldatetime

set @FoundationDate = GetDate()
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values(@GuildName, 5, 123456, @FoundationDate,0,0)
set @GuildID = @@identity

if (@@error <> 0 or @@rowcount = 0 or @GuildID = 0)
begin
         rollback transaction
         return -5
end


--???? ???? 0xffffffff !!
declare @rvalue int
exec @rvalue = _Guild_FnAddMember @GuildID, @CreaterID, 0, @FoundationDate,0xffffffff
if (@@error <> 0 or @rvalue <= 0)
begin
         rollback transaction
         return @rvalue
end

-- ?? ??? ????
exec @rvalue = _Guild_CreateChest_NoTX @GuildID
if (@@error <> 0 or @rvalue <= 0)
begin
         rollback transaction
         return @rvalue
end


commit transaction
return @GuildID

[/SPOILER]

Delete Drop items from Mobs & Uniques

[SPOILER]

 
            
USE SRO_VT_SHARD_INIT
delete _RefDropItemAssign
from _RefDropItemAssign Drops
left join _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID)
WHERE CodeName128 like '%ITEM_CH_%_09_%

[/SPOILER]

Add New Drops in Mob & Unique

[SPOILER]

 
            
USE SRO_VT_SHARD 
GO

DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real



SET @MonsterID = 3810 <-------- Mob,Unique ID you want Add Drop in
SET @DropRatio = 1 <-------- Drop Ration 1=100% , 0.5 = 50%
SET @ItemID = 24165 <-------- ITEM ID You want Add in Drop


INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')

[/SPOILER]

Ban Player with Char Name

[SPOILER]

 
            
USE [SRO_VT_SHARD]           
GO
--------------------------------                           
DECLARE @ChrID INT;            
DECLARE @CharName VARCHAR(64); 
DECLARE @AccJID INT;           
---------------------------------
SET @CharName =    'CharNameHere'---
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
-----------------------------------------------------------------
USE SRO_VT_ACCOUNT
DECLARE @ID VARCHAR (64)
DECLARE @Reason VARCHAR(128)
DECLARE @Begin DATETIME
DECLARE @End DATETIME
SET @ID = (Select STRuserID FROM TB_User Where JID = @AccJID)

---------------------------------
SET @Reason    =    'Ban Reason Here'
SET @Begin    =    '2012-05-01 00:00:00.000' --    Time Begin    --
SET @End    =    '2040-01-01 00:00:00.000' --    Time End    --
---------------------------------
---------------------------

INSERT [dbo].[_Punishment]
(
[UserJID],
[Type],
[Executor],
[Shard],
[CharName],
[CharInfo],
[PosInfo] ,
[Guide],
[Description],
[RaiseTime],
[BlockStartTime],
[BlockEndTime],
[PunishTime],
[Status]
)
VALUES 
(
@AccJID,
1,
1,
0,
@CharName,
1,
1,
@Reason,
@Reason,
@Begin,
@Begin,
@End,
@End,
0);
----------------------------------------------------------
DECLARE @ReasonID INT
SET @ReasonID =
(Select SerialNo FROM _Punishment Where UserJID = @AccJID)
----------------------------------------------------------
INSERT [dbo].[_BlockedUser]
(
[UserJID],
[UserID],
[Type],
[SerialNo],
[TimeBegin],
[TimeEnd])
VALUES
(
@AccJID,
@ID,
1,
@ReasonID,
@Begin,
@End);

-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
-----------------------------------------------------------------
--By Leandro ( nukertube ) --

[/SPOILER]

Change Alchemy Rate To 1.5X
[SPOILER]

USE [SRO_VT_SHARD] UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2033' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2034' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2035' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2036' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2037' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2038' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2039' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2040' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2041' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2042' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2043' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2044'

[/SPOILER]

لسي Queries كتير
Will Add[/B]

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
كــثــيــر مــن الــنــاس يــحــتــقــر مــن يــخــدمــه ويــحــتــرمـ مــن يــهــيــنــه	Senior007	بـعـيـدآ عـن سـيـلـك رود	11	09-07-2013 09:07 PM
كــلام مــن هــنــا وكــلام مــن هـنـاك [الجزاء الثاني]	CError	بـعـيـدآ عـن سـيـلـك رود	8	23-04-2013 12:57 AM
اكـتــشــف مــن يـتــحــدث مـعـك مــن تــصــرفــاتــه . . .	!! Prince World !!	بـعـيـدآ عـن سـيـلـك رود	19	14-01-2013 12:14 AM
طلب queries	Xeno	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	2	10-12-2012 02:06 AM
وحــشـــتـــونــى جــدا جــدا جــدا جــدا	MịηaTσ	قـسـم الـتـرحـيـب و الـتـعـارف	22	09-11-2012 12:04 AM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)