ineed scroll to change weapon to weapon like ( spear to Bow )
Guys i need 2 things
1. i made the equip system but i doesn't work because my _addlogitem is damaged
please can you give me one
2. i need scroll to change weapon from weapon
like spear to blade
bow to spear
blade to sword
Re: ineed scroll to change weapon to weapon like ( spear to Bow )
1 >
Code:
USE [SRO_VT_SHARDLOG] --- Change db's name to your own.GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 6/12/2015 4:30:46 PM ******/
DROP PROCEDURE [dbo].[_AddLogItem]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 6/12/2015 4:30:46 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log
CREATE procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@operation tinyint,
@slot_From tinyint,
@slot_To tinyint,
@eventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ðÀÔ
as
if( not ((@ItemRefID>3674 AND @ItemRefID<3707) OR (@ItemRefID>6246 AND @ItemRefID<7063) OR (@ItemRefID>25872 AND @ItemRefID<26063) OR @operation=30 OR @operation=114 ))
BEGIN
declare @len_pos int
declare @len_desc int
declare @CharName varchar (150)
set @len_pos = len @eventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @operation, @slot_From, @slot_To, @eventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @operation, @slot_From, @slot_To, @eventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @operation, @slot_From, @slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @operation, @slot_From, @slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
-- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if @operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end
--DELETE TOP (2) FROM _LogCashItem WHERE EventTime < DATEADD(week, -2, GETDATE())
--DELETE TOP (2) FROM _LogEventItem WHERE EventTime < DATEADD(week, -2, GETDATE())
2 > Its called Upgrade system as i remember and you can change depends on your ideas/changes.
Re: ineed scroll to change weapon to weapon like ( spear to Bow )
thx man i will edit it
and if i make it i will realize it soon