Auto Equipment System

**MertKakici** · 11-09-13

Hello , its the auto equipment system what everyone searching for , here you go

There is a guide about how to setup , execute query's , read it as well , its kind a easy.

PS ; The current system gives +6 sun items between 5-9d , with str -int blues , you can change it via the query's

Have fun =)

Download ; File upload and sharing. Upload share folders!

Virustotal ; https://www.virustotal.com/en/file/e...049e/analysis/

Credits goes to DePiedra .

**MentaL**

**F50** · 11-09-13

thank you <3

**Nemo07Back** · 11-09-13

Why PPL dont respect the others ?

**MertKakici** · 11-09-13

Originally Posted by Nemo07Back

Why PPL have no respect for the others ?

what you talking about ? :O

**Nemo07Back** · 11-09-13

Originally Posted by MertKakici

what you talking about ? :O

my words are very clear to understand it ..what I mean: many PPLs are worked hard on this system then some one share it easy..

**mazazekoo** · 11-09-13

Thanks for sharing
it working 100% on Chines characters
on euro not working

**denise456** · 11-09-13

Thank's

**Hex1337** · 11-09-13

Originally Posted by mazazekoo

Thanks for sharing
it working 100% on Chines characters
on euro not working

its created for china server ..

**mazazekoo** · 11-09-13

but i see euro items lines etc

**mazazekoo** · 11-09-13

Any help to make it work for euro too ?

**tristo** · 11-09-13

I see now, im sorry. Trigger caused bug. Delete trigger and execute this procedure.

and add this line to _AddLogChar

Code:

	IF (@EventID = 22 and (@Data2 = 40 or @Data2 = 47 or @Data2 = 57 or @Data2 = 69 or @Data2 = 81))
		BEGIN
    exec SRO_VT_SHARD.dbo._AUTOEQUIP_DEPI @CharID,@Data2   
		END

Procedure

Code:

USE [SRO_VT_SHARD]
GO

/****** Object:  StoredProcedure [dbo].[_AUTOEQUIP_DEPI]    Script Date: 09/11/2013 18:42:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE   procedure [dbo].[_AUTOEQUIP_DEPI]    
@CharID        int,   
@Data2        int   
as   
declare @RefCharID int
declare @CharName varchar(64)
declare @CharLevel tinyint
set @RefCharID = (select RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
set @CharName = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
set @CharLevel = (select CurLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
Declare @RefMail INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @CharID) 
AND Slot ='1')
Declare @RefMailID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @RefMail)
Declare @RefWeapon INT
Declare @Weapon INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @CharID) 
AND Slot ='6')
Declare @RefWeaponID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @Weapon)
Declare @WeaponType Tinyint = (Select Typeid4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @RefWeaponID)
Declare @RefShield INT
Declare @Shield INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @CharID) 
AND Slot ='7')
Declare @RefShieldID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @Shield)
Declare @ShieldType Tinyint = (Select Typeid4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @RefShieldID)
    declare @mail_codename varchar(250)
	declare @chr_gender varchar(250)
	declare @item_level varchar(250)
    declare @itemcodename varchar(250)
	select @mail_codename = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @RefMailID

	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 0
	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 1
	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 2
	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 3
	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 4
	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 5
	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 9
	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 10
	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 11
	Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @CharID and Slot = 12

If ((Select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = (Select top 1 RefItemID from SRO_VT_SHARD.dbo._items where id64 = @Weapon))
                         = @WeaponType ) -- Weapon
Begin
        Set @RefWeapon = (Select top 1 ID from SRO_VT_SHARD.dbo._ItemPoolAutoEquipment where 
                          Service = 1 AND
                        TypeID1=3 AND --- Weapon
                        TypeID2=1 AND
                        TypeID3=6 AND
                        TypeID4=@WeaponType
                        Group by SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.ID,SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.reqlevel1
                        having  (MAX(ReqLevel1)<=@Data2)
                        Order By ReqLevel1 Desc 
                   )
Update SRO_VT_SHARD.dbo._Items set RefItemID= @RefWeapon where ID64= @Weapon
Update SRO_VT_SHARD.dbo._Items set OptLevel= 6,Variance= 34359738367,Data= 200, MagParamNum='2',MagParam1='30064771144',MagParam2= '30064771150' where ID64= @Weapon
END                

If ((Select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = (Select top 1 RefItemID from SRO_VT_SHARD.dbo._items where id64 = @Shield))
                         = @ShieldType ) -- Shield
Begin
        Set @RefShield = (Select top 1 ID from SRO_VT_SHARD.dbo._ItemPoolAutoEquipment WITH (Nolock) where 
                          Service = 1 AND
                        TypeID1=3 AND --- Shield
                        TypeID2=1 AND
                        TypeID3=4 AND
                        TypeID4=@ShieldType
                        Group by SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.ID,SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.reqlevel1
                        having  (MAX(ReqLevel1)<=@Data2)
                        Order By ReqLevel1 Desc 
                   )
Update SRO_VT_SHARD.dbo._Items set RefItemID= @RefShield where ID64= @Shield
Update SRO_VT_SHARD.dbo._Items set OptLevel= 6,Variance= 34359738367,Data= 200, MagParamNum='2',MagParam1='30064771144',MagParam2= '30064771150' where ID64= @Shield
END                

IF (@Data2 = 40)
BEGIN
  set @item_level = '05' --DG
end 	
IF (@Data2 = 47)
BEGIN
  set @item_level = '06' --DG
end 	
IF (@Data2 = 57)
BEGIN
  set @item_level = '07' --DG
end 	
IF (@Data2 = 69)
BEGIN
  set @item_level = '08' --DG
end 	
IF (@Data2 = 81)
BEGIN
  set @item_level = '09' --DG
end 	

 if(@RefCharID between 1907 and 1919 or @RefCharID between 14875 and 14887)
 begin
  set @chr_gender = 'M' --male
 end
 
 if(@RefCharID between 1920 and 1932 or @RefCharID between 14888 and 14900)
 begin
  set @chr_gender = 'W' --female
 end

 if(@RefCharID between 1907 and 1919 or @RefCharID between 1920 and 1932)
 begin
 		set @itemcodename = 'ITEM_CH_RING_' + @item_level + '_C_RARE'
   	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,11,@itemcodename,200
   	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,12,@itemcodename,200
 		set @itemcodename = 'ITEM_CH_EARRING_' + @item_level + '_C_RARE'
   	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,9,@itemcodename,200
 		set @itemcodename = 'ITEM_CH_NECKLACE_' + @item_level + '_C_RARE'
   	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,10,@itemcodename,200
 end
 if(@RefCharID between 14875 and 14887 or @RefCharID between 14888 and 14900)
 begin
 		set @itemcodename = 'ITEM_EU_RING_' + @item_level + '_C_RARE'
   	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,11,@itemcodename,200
   	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,12,@itemcodename,200
 		set @itemcodename = 'ITEM_EU_EARRING_' + @item_level + '_C_RARE'
   	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,9,@itemcodename,200
 		set @itemcodename = 'ITEM_EU_NECKLACE_' + @item_level + '_C_RARE'
   	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,10,@itemcodename,200
 end

--//ARMOR\\--
	if(@mail_codename like 'ITEM_CH_%_LIGHT%')
	begin
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_HA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,0,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_SA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,2,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_BA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,1,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_LA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,4,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_AA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,3,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_FA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,5,@itemcodename,200
	end
	else if(@mail_codename like 'ITEM_CH_%_HEAVY%')
	begin
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_HA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,0,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_SA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,2,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_BA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,1,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_LA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,4,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_AA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,3,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_FA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,5,@itemcodename,200
	end
	else if(@mail_codename like 'ITEM_CH_%_CLOTHES%')
	begin
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_HA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,0,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_SA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,2,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_BA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,1,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_LA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,4,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_AA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,3,@itemcodename,200
		set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_FA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,5,@itemcodename,200
	end
	else if(@mail_codename like 'ITEM_EU_%_LIGHT%')
	begin
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_HA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,0,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_SA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,2,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_BA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,1,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_LA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,4,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_AA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,3,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_FA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,5,@itemcodename,200
	end
	else if(@mail_codename like 'ITEM_EU_%_HEAVY%')
	begin
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_HA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,0,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_SA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,2,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_BA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,1,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_LA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,4,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_AA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,3,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_FA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,5,@itemcodename,200
	end
	else if(@mail_codename like 'ITEM_EU_%_CLOTHES%')
	begin
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_HA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,0,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_SA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,2,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_BA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,1,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_LA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,4,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_AA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,3,@itemcodename,200
		set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_FA_C_RARE'
    	EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @CharName,5,@itemcodename,200
	end
  

GO

**mazazekoo** · 11-09-13

_AddLogChar

at SRO_VT_SHARDLOG ?

**tristo** · 11-09-13

Originally Posted by mazazekoo

_AddLogChar

at SRO_VT_SHARDLOG ?

Yes LOG DB.

**mazazekoo** · 11-09-13

it dosn't work on euro/ch

**tristo** · 11-09-13

Trigger bugged but procedure fully working on eu and ch. Delete old trigger on _Char.

Auto Equipment System

Thread Tools

Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Re: Auto Equipment System

Advertisement