Unique Title Auto system

[che_9299]

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
.....................