الموقع العربي الاول للعبة Silkroad Online

Unique Title Auto system
SRO_VT_SHARDLOG
Addlogchar
كود:
  if @EventID = '11' 

        BEGIN

Declare @Mobname Varchar(128)

Declare @Charname varchar (30)

Declare @Amount tinyint -- 255 kills max

/* Declare TitleCursor cursor for

Select top 1 Charname, MobName 

from SRO_VT_ACCOUNT.dbo.srZor_uniques

where MobName in (

'MOB_CH_TIGERWOMAN',

 'MOB_OA_URUCHI',

 'MOB_KK_ISYUTARU',

 'MOB_TK_BONELORD',

 'MOB_RM_TAHOMET',

 'MOB_EU_KERBEROS',

 'MOB_AM_IVY',

 'MOB_SHADOW_MORGOTH',

 'MOB_RM_ROC',

 'MOB_RM_BONEROC'

) order by time desc



Open TitleCursor

FETCH NEXT FROM TitleCursor 

INTO @Charname,@Mobname

While @@FETCH_STATUS=0

 

*/



Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT.dbo.srZor_uniques Where mobname like 'MOB_CH_TIGERWOMAN' order by time desc)



Update SRO_VT_SHARD.dbo._Char Set HwanLevel=40 where (CharName16 = @Charname AND HwanLevel <= 13) OR (NickName16 = @Charname AND HwanLevel <= 13)   --AND MaxLevel between 1 AND 80

 

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT.dbo.srZor_uniques Where mobname like 'MOB_OA_URUCHI' order by time desc) 



Update SRO_VT_SHARD.dbo._Char Set HwanLevel=41 where (CharName16 = @Charname AND HwanLevel <= 13) OR (NickName16 = @Charname AND HwanLevel <= 13)   --AND MaxLevel between 1 AND 80

 

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT.dbo.srZor_uniques Where mobname like 'MOB_KK_ISYUTARU' order by time desc) 



Update SRO_VT_SHARD.dbo._Char Set HwanLevel=42 where (CharName16 = @Charname AND HwanLevel <= 13) OR (NickName16 = @Charname AND HwanLevel <= 13)   --AND MaxLevel between 1 AND 89

 

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT.dbo.srZor_uniques Where mobname like 'MOB_TK_BONELORD' order by time desc) 



Update SRO_VT_SHARD.dbo._Char Set HwanLevel=43 where (CharName16 = @Charname AND HwanLevel <= 13) OR (NickName16 = @Charname AND HwanLevel <= 13)  

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT.dbo.srZor_uniques Where mobname like 'MOB_RM_TAHOMET' order by time desc) 

 

Update SRO_VT_SHARD.dbo._Char Set HwanLevel=44 where (CharName16 = @Charname AND HwanLevel <= 13) OR (NickName16 = @Charname AND HwanLevel <= 13)  

 

 Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT.dbo.srZor_uniques Where mobname like 'MOB_EU_KERBEROS' order by time desc) 

 

Update SRO_VT_SHARD.dbo._Char Set HwanLevel=45 where (CharName16 = @Charname AND HwanLevel <= 13) OR (NickName16 = @Charname AND HwanLevel <= 13)--AND MaxLevel between 1 AND 40

 

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT.dbo.srZor_uniques Where mobname like 'MOB_AM_IVY' order by time desc) 

 

Update SRO_VT_SHARD.dbo._Char Set HwanLevel=46 where ((CharName16 = @Charname AND HwanLevel <= 13) OR (NickName16 = @Charname AND HwanLevel <= 13)) --AND MaxLevel between 1 AND 40

 

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT.dbo.srZor_uniques Where mobname like 'MOB_SHADOW_MORGOTH' order by time desc)

 

Update SRO_VT_SHARD.dbo._Char Set HwanLevel=47 where (CharName16 = @Charname AND HwanLevel <= 15) OR (NickName16 = @Charname AND HwanLevel <= 15)

 

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT.dbo.srZor_uniques Where mobname like 'MOB_RM_ROC' order by time desc)

Update SRO_VT_SHARD.dbo._Char Set HwanLevel=47 where CharName16 = @Charname AND HwanLevel <= 15 OR (NickName16 = @Charname AND HwanLevel <= 15)

 END
Have Fun
.....................