[Help Thread] Please post your questions here.

USE [telecaster]
GO

/****** Object: StoredProcedure [dbo].[smp_check_purchased_item] Script Date: 2015-04-17 08:07:43 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- smp_read_purchased_item_list

-- start of smp_check_purchased_item 某浆袍 芒绊俊 酒捞袍 乐绰瘤 咯何 八荤
CREATE PROCEDURE [dbo].[smp_check_purchased_item]
@IN_ACCOUNT_ID INT,
@IN_CHARACTER_ID INT,
@OUT_TOTAL_ITEM_COUNT INT OUTPUT,
@OUT_NEW_ITEM_COUNT INT OUTPUT,
@OUT_PREMIUM_TICKET INT OUTPUT,
@OUT_PREMIUM_REST_TIME INT OUTPUT,
@OUT_STAMINA_REGEN_TIME INT OUTPUT


AS
SET NOCOUNT ON

SET @OUT_PREMIUM_TICKET = 0
SET @OUT_PREMIUM_REST_TIME = 0
SET @OUT_STAMINA_REGEN_TIME = 0

SELECT @OUT_PREMIUM_TICKET = COUNT(*), @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() AND isCancel = 0

IF @OUT_PREMIUM_TICKET < 1
BEGIN
SET @OUT_PREMIUM_REST_TIME = 0

DECLARE @LOGOUT_TIME DATETIME
SET @LOGOUT_TIME = GETDATE()

SELECT @LOGOUT_TIME = logout_time FROM Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND sid = @IN_CHARACTER_ID
SELECT @OUT_STAMINA_REGEN_TIME = DATEDIFF( minute, @LOGOUT_TIME, MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > @LOGOUT_TIME AND isCancel = 0

IF @OUT_STAMINA_REGEN_TIME < 1 OR @OUT_STAMINA_REGEN_TIME IS NULL
BEGIN
SET @OUT_STAMINA_REGEN_TIME = 0
END

DECLARE @NO_LV INT
DECLARE @NO_Total_JP INT
SELECT @NO_LV = MAX(lv), @NO_Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'

IF @NO_LV < 30 AND @NO_Total_JP < 100000
BEGIN
SET @OUT_PREMIUM_TICKET = 1
SET @OUT_PREMIUM_REST_TIME = 3600 * 5
END

END

--IF @OUT_PREMIUM_REST_TIME < 3600 * 5
--BEGIN

--DECLARE @LV INT
--DECLARE @Total_JP INT
--SELECT @LV = MAX(lv), @Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'

--IF @LV < 30 AND @Total_JP < 100000
--BEGIN
--SET @OUT_PREMIUM_TICKET = 1
--SET @OUT_PREMIUM_REST_TIME = 3600 * 5
--END
--END


SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0 AND valid_time > GETDATE() AND isCancel = 0
SELECT @OUT_NEW_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0 AND confirmed = 0 AND valid_time > GETDATE() AND isCancel = 0

RETURN @@ERROR
GO

in server ini
function jts_server_hv()
add_state(9004,2,31536000000)

In Ect_Script_Functions
function is_premium()
local lv = get_value("level")
if lv > 10 then
return true
end
end

function is_premium2()

-- ���� �ڵ� �о����
-- get_local_info()�� ��ȯ����
--LOCAL_INFO_KOREA = 1
--LOCAL_INFO_HONGKONG = 2
--LOCAL_INFO_AMERICA = 4
--LOCAL_INFO_GERMANY = 8
--LOCAL_INFO_JAPAN = 16
--LOCAL_INFO_TAIWAN = 32
--LOCAL_INFO_CHINA = 64
--LOCAL_INFO_FRANCE = 128
--LOCAL_INFO_RUSSIA = 256
--�����̽þ� 512, �̰��� 1024, ��Ʈ�� 2048, �±� 4096, �ߵ� 8192, ��Ű 16384

local state_code = get_local_info()


-- �ѱ��� ��� ����/�׼� ��� ��ũ��Ʈ �����н��� ������ true
if state_code == 1 and gv( "premium" ) == 1 then
return true
end
-- ��ũ��Ʈ �����н��� ������ true
if gv( "premium" ) == 1 and scf_is_official_server( get_server_category() ) then
return true
end

-- �׽�Ʈ �����̸� ������ true
if scf_is_official_server( get_server_category() ) == false then
-- return true
end
return false
end

declare @p1 int
set @p1=444219
declare @p2 varchar(60)
set @p2='JustLooking'
declare @p3 int
set @p3=100
declare @p4 int
set @p4=1
declare @p5 int
set @p5=0
declare @p6 int
set @p6=0
declare @p7 tinyint
set @p7=0
declare @p8 int
set @p8=152892
declare @p9 int
set @p9=77239
declare @p10 int
set @p10=0
declare @p11 int
set @p11=0
declare @p12 int
set @p12=5
declare @p13 int
set @p13=2
declare @p14 int
set @p14=165
declare @p15 int
set @p15=165
declare @p16 bigint
set @p16=283937413024
declare @p17 bigint
set @p17=456182848
declare @p18 int
set @p18=35564
declare @p19 int
set @p19=10998
declare @p20 int
set @p20=202170
declare @p21 int
set @p21=0
declare @p22 int
set @p22=321
declare @p23 int
set @p23=0
declare @p24 int
set @p24=56
declare @p25 bigint
set @p25=4783316875
declare @p26 bigint
set @p26=18788825619
declare @p27 int
set @p27=0
declare @p28 int
set @p28=300
declare @p29 int
set @p29=301
declare @p30 int
set @p30=311
declare @p31 int
set @p31=10
declare @p32 int
set @p32=50
declare @p33 int
set @p33=50
declare @p34 numeric(18,4)
set @p34=0
declare @p35 int
set @p35=0
declare @p36 int
set @p36=0
declare @p37 int
set @p37=0
declare @p38 int
set @p38=48827
declare @p39 int
set @p39=12
declare @p40 int
set @p40=98272500
declare @p41 int
set @p41=16
declare @p42 int
set @p42=0
declare @p43 int
set @p43=0
declare @p44 int
set @p44=0
declare @p45 int
set @p45=0
declare @p46 int
set @p46=0
declare @p47 int
set @p47=8487040
declare @p48 int
set @p48=105
declare @p49 int
set @p49=211
declare @p50 int
set @p50=301
declare @p51 int
set @p51=401
declare @p52 int
set @p52=501
declare @p53 int
set @p53=1
declare @p54 bigint
set @p54=0
declare @p55 bigint
set @p55=4177920
declare @p56 int
set @p56=1
declare @p57 bigint
set @p57=1396
declare @p58 bigint
set @p58=1417
declare @p59 bigint
set @p59=1427
declare @p60 bigint
set @p60=1445
declare @p61 bigint
set @p61=1453
declare @p62 bigint
set @p62=1471
declare @p63 bigint
set @p63=7409414248
declare @p64 int
set @p64=500
declare @p65 varchar(1000)
set @p65='alram_count_01:0
alram_count_02:0
alram_count_03:0
rx:153543
alram_count_04:0
ry:77247
warp_num:1
alram_count_05:0
alram_count_06:0
juliet_finding:2
hhp:54411
romeo_finding:2
hmp:37629
hx:38409.000000
hy:118267.000000
'
declare @p66 int
set @p66=17
declare @p67 int
set @p67=16
declare @p68 int
set @p68=0
declare @p69 int
set @p69=0
declare @p70 int
set @p70=4
declare @p71 int
set @p71=0
declare @p72 int
set @p72=0
declare @p73 int
set @p73=0
declare @p74 int
set @p74=0
declare @p75 int
set @p75=0
declare @p76 int
set @p76=0
declare @p77 int
set @p77=0
declare @p78 int
set @p78=0
declare @p79 datetime
set @p79='2000-01-01 00:00:00'
declare @p80 int
set @p80=0
declare @p81 datetime
set @p81='2000-01-01 00:00:00'
declare @p82 int
set @p82=0
declare @p83 int
set @p83=0
declare @p84 int
set @p84=0
declare @p85 int
set @p85=0
declare @p86 int
set @p86=0
declare @p87 int
set @p87=0
declare @p88 int
set @p88=0
declare @p89 nvarchar(31)
set @p89=N''
declare @p90 int
set @p90=0
declare @p91 int
set @p91=0
declare @p92 int
set @p92=2
declare @p93 int
set @p93=25116
declare @p94 int
set @p94=1
declare @p95 int
set @p95=0
declare @p96 datetime
set @p96='2000-01-01 00:00:00'
declare @p97 tinyint
set @p97=0
exec dbo.smp_login_character @p1 output,@p2 output,@p3 output,@p4 output,@p5 output,@p6 output,@p7 output,@p8 output,@p9 output,@p10 output,@p11 output,@p12 output,@p13 output,@p14 output,@p15 output,@p16 output,@p17 output,@p18 output,@p19 output,@p20 output,@p21 output,@p22 output,@p23 output,@p24 output,@p25 output,@p26 output,@p27 output,@p28 output,@p29 output,@p30 output,@p31 output,@p32 output,@p33 output,@p34 output,@p35 output,@p36 output,@p37 output,@p38 output,@p39 output,@p40 output,@p41 output,@p42 output,@p43 output,@p44 output,@p45 output,@p46 output,@p47 output,@p48 output,@p49 output,@p50 output,@p51 output,@p52 output,@p53 output,@p54 output,@p55 output,@p56 output,@p57 output,@p58 output,@p59 output,@p60 output,@p61 output,@p62 output,@p63 output,@p64 output,@p65 output,@p66 output,@p67 output,@p68 output,@p69 output,@p70 output,@p71 output,@p72 output,@p73 output,@p74 output,@p75 output,@p76 output,@p77 output,@p78 output,@p79 output,@p80 output,@p81 output,@p82 output,@p83 output,@p84 output,@p85 output,@p86 output,@p87 output,@p88 output,@p89 output,@p90 output,@p91 output,@p92 output,@p93 output,@p94 output,@p95 output,@p96 output,@p97 output,N'JustLooking',1002
select @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97