Register for your free account! | Forgot your password?

You last visited: Today at 17:38

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

[Release]Auto Equipment

Discussion on [Release]Auto Equipment within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2014
Posts: 93
Received Thanks: 22
[Release]Auto Equipment

First of all, i've seen too much threads that released this system,but all links are deleted, the only one which is working is that one via coupon .. but i didn't like it, while i was searching in one of my friend db's, i've found auto equipment system, and i decided to release it.
Let's go ..


1- Add This to SRO_VT_SHARDLOG . _AddLogChar
Quote:
IF (@EventID = 22)
begin
exec dbo.AUTO_EQUIP
end

2- Create this procedure

Quote:
USE [SRO_VT_SHARDlog]
GO
/****** Object: StoredProcedure [dbo].[AUTO_EQUIP] Script Date: 10/9/2014 2:32:41 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



Create procedure [dbo].[AUTO_EQUIP]
@CharID int,
@Data2 int

as


DECLARE @CharGender int =(select RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
if (@CharGender between 1920 and 1932 or @CharGender between 14888 and 14900)
begin
-- female
SET @CharGender = 0
end
if (@CharGender between 1907 and 1919 or @CharGender between 14875 and 14887)
begin
-- male
SET @CharGender = 1
end

-- Auto Mastery Level
-- Declare And Set some important thing !
Declare @OptLevel int = '5'
If (@Data2 between 8 and 101)
begin


-- Item ID !
DECLARE @CurCharHeadID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 0 and inv.CharID = @CharID)
,@CurCharChestID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 1 and inv.CharID = @CharID)
,@CurCharShoulderID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 2 and inv.CharID = @CharID)
,@CurCharHandID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 3 and inv.CharID = @CharID)
,@CurCharLegsID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 4 and inv.CharID = @CharID)
,@CurCharFootID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 5 and inv.CharID = @CharID)
,@CurCharWepID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 6 and inv.CharID = @CharID)
,@CurCharShiledID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 7 and inv.CharID = @CharID)
-- slot 8 unknown atm
,@CurCharEaringID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 9 and inv.CharID = @CharID)
,@CurCharNeckID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 10 and inv.CharID = @CharID)
,@CurCharLEFTRINGID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 11 and inv.CharID = @CharID)
,@CurCharRIGHTRINGID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 12 and inv.CharID = @CharID)
-- item type
DECLARE @TypeID1_Wep int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharWepID),@TypeID2_Wep int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharWepID),@TypeID3_Wep int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharWepID),@TypeID4_Wep int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharWepID)
, @TypeID1_Head int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHeadID),@TypeID2_Head int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHeadID),@TypeID3_Head int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHeadID),@TypeID4_Head int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHeadID)
, @TypeID1_Chest int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharChestID),@TypeID2_Chest int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharChestID),@TypeID3_Chest int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharChestID),@TypeID4_Chest int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharChestID)
, @TypeID1_Shoulder int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShoulderID),@TypeID2_Shoulder int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShoulderID),@TypeID3_Shoulder int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShoulderID),@TypeID4_Shoulder int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShoulderID)
, @TypeID1_Hand int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHandID),@TypeID2_Hand int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHandID),@TypeID3_Hand int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHandID),@TypeID4_Hand int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHandID)
, @TypeID1_Legs int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLegsID),@TypeID2_Legs int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLegsID),@TypeID3_Legs int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLegsID),@TypeID4_Legs int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLegsID)
, @TypeID1_Foot int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharFootID),@TypeID2_Foot int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharFootID),@TypeID3_Foot int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharFootID),@TypeID4_Foot int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharFootID)
, @TypeID1_Shiled int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShiledID),@TypeID2_Shiled int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShiledID),@TypeID3_Shiled int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShiledID),@TypeID4_Shiled int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShiledID)
, @TypeID1_Earing int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharEaringID),@TypeID2_Earing int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharEaringID),@TypeID3_Earing int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharEaringID),@TypeID4_Earing int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharEaringID)
, @TypeID1_Neck int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharNeckID),@TypeID2_Neck int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharNeckID),@TypeID3_Neck int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharNeckID),@TypeID4_Neck int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharNeckID)
, @TypeID1_LEFTRING int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID2_LEFTRING int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID3_LEFTRING int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID4_LEFTRING int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLEFTRINGID)
, @TypeID1_RIGHTRING int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID2_RIGHTRING int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID3_RIGHTRING int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID4_RIGHTRING int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharRIGHTRINGID)


-- Next Item ID !
DECLARE @NextItemID_Wep int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_Wep and TypeID2 = @TypeID2_Wep and TypeID3 = @TypeID3_Wep and TypeID4 = @TypeID4_Wep Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_Head int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Head and TypeID2 = @TypeID2_Head and TypeID3 = @TypeID3_Head and TypeID4 = @TypeID4_Head Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_Chest int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Chest and TypeID2 = @TypeID2_Chest and TypeID3 = @TypeID3_Chest and TypeID4 = @TypeID4_Chest Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_Shoulder int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Shoulder and TypeID2 = @TypeID2_Shoulder and TypeID3 = @TypeID3_Shoulder and TypeID4 = @TypeID4_Shoulder Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_Hand int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Hand and TypeID2 = @TypeID2_Hand and TypeID3 = @TypeID3_Hand and TypeID4 = @TypeID4_Hand Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_Legs int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Legs and TypeID2 = @TypeID2_Legs and TypeID3 = @TypeID3_Legs and TypeID4 = @TypeID4_Legs Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_Foot int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Foot and TypeID2 = @TypeID2_Foot and TypeID3 = @TypeID3_Foot and TypeID4 = @TypeID4_Foot Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_Shield int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_Shiled and TypeID2 = @TypeID2_Shiled and TypeID3 = @TypeID3_Shiled and TypeID4 = @TypeID4_Shiled Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_Earing int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_Earing and TypeID2 = @TypeID2_Earing and TypeID3 = @TypeID3_Earing and TypeID4 = @TypeID4_Earing Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_Neck int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_Neck and TypeID2 = @TypeID2_Neck and TypeID3 = @TypeID3_Neck and TypeID4 = @TypeID4_Neck Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_LEFTRING int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_LEFTRING and TypeID2 = @TypeID2_LEFTRING and TypeID3 = @TypeID3_LEFTRING and TypeID4 = @TypeID4_LEFTRING Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)
,@NextItemID_RIGHTRING int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_RIGHTRING and TypeID2 = @TypeID2_RIGHTRING and TypeID3 = @TypeID3_RIGHTRING and TypeID4 = @TypeID4_RIGHTRING Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc)

-- Update Items !
if (@NextItemID_Head is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Head , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '6',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '1932735283349',[MagParam5] = '1932735283361',[MagParam6] = '25769803847',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '0' And CharID = @CharID)
end
if (@NextItemID_Chest is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Chest , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '6',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '1932735283349',[MagParam5] = '1932735283361',[MagParam6] = '25769803847',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '1' And CharID = @CharID)
end
if (@NextItemID_Shoulder is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Shoulder , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '4',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '21474836551',[MagParam5] = '0',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '2' And CharID = @CharID)
end
if (@NextItemID_Hand is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Hand , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '4',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '21474836551',[MagParam5] = '0',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '3' And CharID = @CharID)
end
if (@NextItemID_Legs is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Legs , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '6',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '1932735283349',[MagParam5] = '1932735283361',[MagParam6] = '25769803847',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '4' And CharID = @CharID)
end
if (@NextItemID_Foot is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Foot , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '4',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '21474836551',[MagParam5] = '0',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '5' And CharID = @CharID)
end
if (@NextItemID_Wep is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Wep , OptLevel = @OptLevel , Variance = '1524020653', [MagParamNum] = '5',[MagParam1] = '257698037849',[MagParam2] = '214748364913',[MagParam3] = '128849018981',[MagParam4] = '21474836557',[MagParam5] = '21474836551',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '6' And CharID = @CharID)
end
if (@NextItemID_Shield is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Shield , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '4',[MagParam1] = '257698037849',[MagParam2] = '21474836557',[MagParam3] = '21474836551',[MagParam4] = '257698037885',[MagParam5] = '0',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '7' And CharID = @CharID)
end
if (@NextItemID_Earing is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Earing , OptLevel = @OptLevel , Variance = '429', [MagParamNum] = '7',[MagParam1] = '21474836557',[MagParam2] = '21474836551',[MagParam3] = '85899346099',[MagParam4] = '85899346087',[MagParam5] = '85899346105',[MagParam6] = '85899346093',[MagParam7] = '85899346111',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '9' And CharID = @CharID)
end
if (@NextItemID_Neck is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Neck , OptLevel = @OptLevel , Variance = '429', [MagParamNum] = '7',[MagParam1] = '21474836557',[MagParam2] = '21474836551',[MagParam3] = '85899346099',[MagParam4] = '85899346087',[MagParam5] = '85899346105',[MagParam6] = '85899346093',[MagParam7] = '85899346111',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '10' And CharID = @CharID)
end
if (@NextItemID_LEFTRING is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_LEFTRING , OptLevel = @OptLevel , Variance = '429', [MagParamNum] = '7',[MagParam1] = '21474836557',[MagParam2] = '21474836551',[MagParam3] = '85899346099',[MagParam4] = '85899346087',[MagParam5] = '85899346105',[MagParam6] = '85899346093',[MagParam7] = '85899346111',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '11' And CharID = @CharID)
end
if (@NextItemID_RIGHTRING is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_RIGHTRING , OptLevel = @OptLevel , Variance = '429', [MagParamNum] = '7',[MagParam1] = '21474836557',[MagParam2] = '21474836551',[MagParam3] = '85899346099',[MagParam4] = '85899346087',[MagParam5] = '85899346105',[MagParam6] = '85899346093',[MagParam7] = '85899346111',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '12' And CharID = @CharID)
end

I think it's too easy to understand/edit this procedure , so don't say it's not working..


Regards
Tyr*
Tyr* is offline  
Thanks
4 Users
Old 01/17/2015, 16:09   #2
 
xaladim's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2011
Posts: 106
Received Thanks: 3
PHP Code:
Msg 102, Level 15, State 1, Procedure AUTO_EQUIP, Line 121
Incorrect syntax near 'end'. 
xaladim is offline  
Old 01/17/2015, 16:26   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2014
Posts: 11
Received Thanks: 5
Quote:
Originally Posted by xaladim View Post
PHP Code:
Msg 102, Level 15, State 1, Procedure AUTO_EQUIP, Line 121
Incorrect syntax near 'end'. 
last line write again "end" after execute again :-)
The_Devilman is offline  
Old 01/17/2015, 18:13   #4
 
xaladim's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2011
Posts: 106
Received Thanks: 3
Quote:
Originally Posted by The_Devilman View Post
last line write again "end" after execute again :-)
thx

As I leave to 8 Degree?
xaladim is offline  
Old 01/18/2015, 06:04   #5
 
KingDollar's Avatar
 
elite*gold: 857
The Black Market: 10/0/0
Join Date: Dec 2013
Posts: 857
Received Thanks: 679
hhh
it's my old proc
with some **** edits
or yea you have just used my declars like to getting the char gender and current items and the next items id

but i don't care
because it was totally full **** i was just test the system with it
and i just do it when i have learned sql from like 2 years maybe
so it's the first ver

and w/e in the end it's auto ****
KingDollar is offline  
Old 01/19/2015, 01:45   #6
 
Eslam Galull's Avatar
 
elite*gold: 85
The Black Market: 2/0/0
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
Nice try , but !!

did you even think about the times this procedure will be called ?!
it will cuz a lag . & some problems
Eslam Galull is offline  
Old 06/06/2015, 21:32   #7
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2014
Posts: 5
Received Thanks: 0
help

i tested this system and i isnt working
i really need it
can any one give me a solation
or give me a vaild one ?
GM Offander is offline  
Old 12/09/2016, 05:33   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2016
Posts: 21
Received Thanks: 0
Help.

The module '_AddLogChar' depends on the missing object 'dbo.AUTO_EQUIP'. The module will still be created; however, it cannot run successfully until the object exists.

HELP


But I do not see that it automatically gives me clothes and weapons
I stay the same.

HELP.

But I do not see that it automatically gives me clothes and weapons
I stay the same.
GMCreative is offline  
Old 12/09/2016, 08:39   #9
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2009
Posts: 944
Received Thanks: 403
Quote:
Originally Posted by GMCreative View Post
Help.

The module '_AddLogChar' depends on the missing object 'dbo.AUTO_EQUIP'. The module will still be created; however, it cannot run successfully until the object exists.

HELP


But I do not see that it automatically gives me clothes and weapons
I stay the same.

HELP.

But I do not see that it automatically gives me clothes and weapons
I stay the same.
execute this querry
leo2111 is offline  
Old 02/15/2017, 13:23   #10
 
SymbolofeviL's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 67
Received Thanks: 6
The module '_AddLogChar' depends on the missing object 'SRO_VT_LOG.dbo._Wanted'. The module will still be created; however, it cannot run successfully until the object exists.
help
SymbolofeviL is offline  
Old 02/15/2017, 14:26   #11
 
silkroadbotter's Avatar
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Aug 2007
Posts: 438
Received Thanks: 181
Quote:
Originally Posted by SymbolofeviL View Post
The module '_AddLogChar' depends on the missing object 'SRO_VT_LOG.dbo._Wanted'. The module will still be created; however, it cannot run successfully until the object exists.
help
Your blind.. did you even read the thread? the person above you posted the fix to this..

Quote:
Originally Posted by GMCreative View Post
Help.

The module '_AddLogChar' depends on the missing object 'dbo.AUTO_EQUIP'. The module will still be created; however, it cannot run successfully until the object exists.
Quote:
Originally Posted by leo2111 View Post
execute this querry
silkroadbotter is offline  
Old 02/24/2017, 16:11   #12
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2013
Posts: 480
Received Thanks: 314
up
therock2007e is offline  
Old 03/06/2017, 01:30   #13
 
fiction online's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2017
Posts: 43
Received Thanks: 0
Not Working, Help me Please
fiction online is offline  
Reply

« teSTE | Top Players Get Reward »

Similar Threads Similar Threads
[Epic Release] Auto Equipment
12/06/2016 - SRO PServer Guides & Releases - 50 Replies
Hello , its the auto equipment system which most of the people searching for , here you go There is a guide about how to setup , execute query's , read it as well , its kind a easy. The rar file including setup guide text. PS ; The current system gives +6 sun items between 5-9d , with str -int blues , you can change it to anything you want as well Have fun =)
[Release] Auto-equipment
08/30/2013 - SRO PServer Guides & Releases - 18 Replies
delete, Luke* is creating a full auto-equipment thread.
Auto Equipment
08/14/2013 - SRO Private Server - 12 Replies
Any one finish this service please release it if done :)



All times are GMT +2. The time now is 17:38.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.