offlinestore in dvamp hb dll

anyone know command to offline shop in dvampire dll.

i have the script, but i dont know how to work.-

-------------------------------------------------------------------------------------------------------------------
--- TRADE OFFLINE
--------------------------------------------------------------------------------------------------------------------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[lin_GetUserDataByCharId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[lin_GetUserDataByCharId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[lin_SetOfflineStoreTime]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[lin_SetOfflineStoreTime]
GO

CREATE TABLE [dbo].[offlinestore_users] (
[char_id] [int] NOT NULL,
[start_time] [int] NOT NULL,
[remain_time] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE PROCEDURE dbo.lin_GetUserDataByCharId
(
@char_id INT
)
AS
SET NOCOUNT ON
DECLARE @acc NVARCHAR(50)
set @acc=(select account_name from user_data where char_id=@char_id)

IF @char_id > 0

SELECT
RTRIM(ud.char_name), ud.char_id, RTRIM(ud.account_name), ud.account_id, ud.pledge_id, ud.builder, ud.gender, ud.race, ud.class,
ud.world, ud.xloc, ud.yloc, ud.zloc, ud.IsInVehicle, ud.HP, ud.MP, ud.Max_HP, ud.Max_MP, ud.CP, ud.Max_CP, ud.SP, ud.Exp, ud.Lev, ud.align, ud.PK, ud.duel, ud.pkpardon,
ud.ST_underware, ud.ST_right_ear, ud.ST_left_ear, ud.ST_neck, ud.ST_right_finger, ud.ST_left_finger, ud.ST_head, ud.ST_right_hand, ud.ST_left_hand, ud.ST_gloves, ud.ST_chest, ud.ST_legs, ud.ST_feet, ud.ST_back, ud.ST_both_hand, ud.ST_hair,
ISNULL(YEAR(temp_delete_date),0), ISNULL(MONTH(temp_delete_date),0), ISNULL(DAY(temp_delete_date),0),
ISNULL(DATEPART(HOUR, temp_delete_date),0), ISNULL(DATEPART(mi, temp_delete_date),0), ISNULL(DATEPART(s, temp_delete_date),0),
ISNULL(uas.s1, 0), ISNULL(uas.l1, 0), ISNULL(uas.d1, 0), ISNULL(uas.c1, 0),
ISNULL(uas.s2, 0), ISNULL(uas.l2, 0), ISNULL(uas.d2, 0), ISNULL(uas.c2, 0),
ISNULL(uas.s3, 0), ISNULL(uas.l3, 0), ISNULL(uas.d3, 0), ISNULL(uas.c3, 0),
ISNULL(uas.s4, 0), ISNULL(uas.l4, 0), ISNULL(uas.d4, 0), ISNULL(uas.c4, 0),
ISNULL(uas.s5, 0), ISNULL(uas.l5, 0), ISNULL(uas.d5, 0), ISNULL(uas.c5, 0),
ISNULL(uas.s6, 0), ISNULL(uas.l6, 0), ISNULL(uas.d6, 0), ISNULL(uas.c6, 0),
ISNULL(uas.s7, 0), ISNULL(uas.l7, 0), ISNULL(uas.d7, 0), ISNULL(uas.c7, 0),
ISNULL(uas.s8, 0), ISNULL(uas.l8, 0), ISNULL(uas.d8, 0), ISNULL(uas.c8, 0),
ISNULL(uas.s9, 0), ISNULL(uas.l9, 0), ISNULL(uas.d9, 0), ISNULL(uas.c9, 0),
ISNULL(uas.s10, 0), ISNULL(uas.l10, 0), ISNULL(uas.d10, 0), ISNULL(uas.c10, 0),
ISNULL(uas.s11, 0), ISNULL(uas.l11, 0), ISNULL(uas.d11, 0), ISNULL(uas.c11, 0),
ISNULL(uas.s12, 0), ISNULL(uas.l12, 0), ISNULL(uas.d12, 0), ISNULL(uas.c12, 0),
ISNULL(uas.s13, 0), ISNULL(uas.l13, 0), ISNULL(uas.d13, 0), ISNULL(uas.c13, 0),
ISNULL(uas.s14, 0), ISNULL(uas.l14, 0), ISNULL(uas.d14, 0), ISNULL(uas.c14, 0),
ISNULL(uas.s15, 0), ISNULL(uas.l15, 0), ISNULL(uas.d15, 0), ISNULL(uas.c15, 0),
ISNULL(uas.s16, 0), ISNULL(uas.l16, 0), ISNULL(uas.d16, 0), ISNULL(uas.c16, 0),
ISNULL(uas.s17, 0), ISNULL(uas.l17, 0), ISNULL(uas.d17, 0), ISNULL(uas.c17, 0),
ISNULL(uas.s18, 0), ISNULL(uas.l18, 0), ISNULL(uas.d18, 0), ISNULL(uas.c18, 0),
ISNULL(uas.s19, 0), ISNULL(uas.l19, 0), ISNULL(uas.d19, 0), ISNULL(uas.c19, 0),
ISNULL(uas.s20, 0), ISNULL(uas.l20, 0), ISNULL(uas.d20, 0), ISNULL(uas.c20, 0),
ud.quest_flag, ud.face_index, ud.hair_shape_index, ud.hair_color_index,
ud.nickname, ud.power_flag, ud.pledge_dismiss_time, ud.pledge_ousted_time, ud.pledge_withdraw_time, ud.surrender_war_id, ud.use_time, ud.drop_exp,
ISNULL( ub.status, 0), ISNULL( ub.ban_end , 0), ISNULL(ud.subjob_id , 0),
ud.subjob0_class, ud.subjob1_class, ud.subjob2_class, ud.subjob3_class, ISNULL(ssq_dawn_round, 0),
ISNULL(uun.color_rgb, 0x00ffffff),ISNULL(ud.wedding,0),ud.division,ud.pledge_group,ud.AcademyLev,ud.KarmaOrig,ud.PKdiff,ud.ST_face,ud.CursedTimeEquip,ISNULL(ud.TitleColor,0x00ffffff),ud.WeddingTelTime,
ISNULL(dyn.adena_drop,1),ISNULL(dyn.items_drop,1),ISNULL(dyn.spoil,1),ISNULL(dyn._exp,1),ISNULL(dyn._sp,1),ISNULL(SponsorId,0),
ISNULL(uas.s21, 0), ISNULL(uas.l21, 0), ISNULL(uas.d21, 0), ISNULL(uas.c21, 0),
ISNULL(uas.s22, 0), ISNULL(uas.l22, 0), ISNULL(uas.d22, 0), ISNULL(uas.c22, 0),
ISNULL(uas.s23, 0), ISNULL(uas.l23, 0), ISNULL(uas.d23, 0), ISNULL(uas.c23, 0),
ISNULL(uas.s24, 0), ISNULL(uas.l24, 0), ISNULL(uas.d24, 0), ISNULL(uas.c24, 0),
ud.ST_left_bracelet,ud.ST_right_bracelet,ud.ST_hairall,ud.ST_agathon,ud.souls,ud.transformation_id,ud.talisman1,ud.talisman2,ud.talisman3,ud.talisman4,ud.talisman5,ud.talisman6,
ISNULL(uas.s25, 0), ISNULL(uas.l25, 0), ISNULL(uas.d25, 0), ISNULL(uas.c25, 0),
ISNULL(uas.s26, 0), ISNULL(uas.l26, 0), ISNULL(uas.d26, 0), ISNULL(uas.c26, 0),
ISNULL(uas.s27, 0), ISNULL(uas.l27, 0), ISNULL(uas.d27, 0), ISNULL(uas.c27, 0),
ISNULL(uas.s28, 0), ISNULL(uas.l28, 0), ISNULL(uas.d28, 0), ISNULL(uas.c28, 0),
ISNULL(uas.s29, 0), ISNULL(uas.l29, 0), ISNULL(uas.d29, 0), ISNULL(uas.c29, 0),
ISNULL(uas.s30, 0), ISNULL(uas.l30, 0), ISNULL(uas.d30, 0), ISNULL(uas.c30, 0),
ISNULL(uas.s31, 0), ISNULL(uas.l31, 0), ISNULL(uas.d31, 0), ISNULL(uas.c31, 0),
ISNULL(uas.s32, 0), ISNULL(uas.l32, 0), ISNULL(uas.d32, 0), ISNULL(uas.c32, 0),
ISNULL(uas.s33, 0), ISNULL(uas.l33, 0), ISNULL(uas.d33, 0), ISNULL(uas.c33, 0),
ISNULL(uas.s34, 0), ISNULL(uas.l34, 0), ISNULL(uas.d34, 0), ISNULL(uas.c34, 0),
ISNULL(uas.s35, 0), ISNULL(uas.l35, 0), ISNULL(uas.d35, 0), ISNULL(uas.c35, 0),
ISNULL(uas.s36, 0), ISNULL(uas.l36, 0), ISNULL(uas.d36, 0), ISNULL(uas.c36, 0),
ISNULL(uas.s37, 0), ISNULL(uas.l37, 0), ISNULL(uas.d37, 0), ISNULL(uas.c37, 0),
ISNULL(uas.s38, 0), ISNULL(uas.l38, 0), ISNULL(uas.d38, 0), ISNULL(uas.c38, 0),
ISNULL(uas.s39, 0), ISNULL(uas.l39, 0), ISNULL(uas.d39, 0), ISNULL(uas.c39, 0),
ISNULL(uas.s40, 0), ISNULL(uas.l40, 0), ISNULL(uas.d40, 0), ISNULL(uas.c40, 0),
ISNULL(reputation_point,0),
ISNULL(ous.start_time,0),ISNULL(ous.remain_time,0)
FROM
(SELECT * FROM User_data (nolock) WHERE char_id = @char_id) AS ud
LEFT OUTER JOIN
(SELECT * FROM user_ActiveSkill (nolock) WHERE char_id = @char_id) as uas ON ud.char_id = uas.char_id
left OUTER JOIN
(select * from user_ban (nolock) where char_id = @char_id) as ub on ud.char_id = ub.char_id
left OUTER JOIN
(select * from user_name_color (nolock) where char_id = @char_id) as uun on ud.char_id = uun.char_id
left OUTER JOIN
(select * from dynamic_rates (nolock) where acc_name=@acc) as dyn on @acc=dyn.acc_name
left OUTER JOIN
(select * from offlinestore_users (nolock) where char_id = @char_id) as ous ON ud.char_id = ous.char_id
GO

CREATE PROCEDURE [DBO].[lin_SetOfflineStoreTime]
(
@char_id INT,
@StartTime INT,
@RemainTime INT
)

AS
SET NOCOUNT ON

IF @RemainTime=0
BEGIN
IF exists(SELECT start_time FROM offlinestore_users where char_id = @char_id) DELETE FROM offlinestore_users WHERE char_id = @char_id
END
ELSE
BEGIN
IF exists(SELECT start_time FROM offlinestore_users where char_id = @char_id) UPDATE offlinestore_users SET start_time = @StartTime, remain_time = @RemainTime WHERE char_id = @char_id
ELSE INSERT INTO offlinestore_users (char_id, start_time, remain_time) VALUES (@char_id,@StartTime,@RemainTime)
END
GO

 

maybe command or need botcheck.ini config

 

for my offline store you must have a skill(s) with effect i_offline_store;X where X - time for offline store in minutes. Somehow user must feel this effect, and than when he wrote in chat ~offline, he goes to offline store mode. (sorry for my english)

 

thx so much.- work

 

someone ve the a skill for offlinestore?