[Help Thread] Please post your questions here.

[Modamer9]

Originally Posted by TheOnlyOneRaskim

Btw if you want to correct me, than do it right.

The Wear info flags wich were written down from me, weren't correct.

It's like that:
gcode: 0 or 3 = player equip

one more notice ... i have item with remain_time <> 0 and i wear (player) and gcode =1 not 3 or 0
so if item has remain_time then gcode = 1 and flag =0 ????

[TheOnlyOneRaskim]

Originally Posted by Modamer9

one more notice ... i have item with remain_time <> 0 and i wear (player) and gcode =1 not 3 or 0
so if item has remain_time then gcode = 1 and flag =0 ????

Just edit the above written Query...

[bertie2008]

Originally Posted by ismokedrow

Issue this as a query into your SQL (targeting your telecaster) and paste me the screenie of results plz. I don't have anything in my paiditem table, so I can't reproduce at the moment.

Getting the same error as this other dude

Msg 8115, Level 16, State 2, Procedure smp_check_purchased_item, Line 43
Arithmetic overflow error converting expression to data type int.

Thing is a soon as I delete the master class character, all the other characters on the same account work perfectly again

[ismokedrow]

I don't have this same issue as my server and can't reproduce it, the line it is giving an error on is like I quoted above. Maybe someone else can weigh in on this?

[ThunderNikk]

Bertie...

Could you do a "script stored procedure as create to" and choose new query window on your dbo.smp_check_purchased_item and post the results here so we can compare them to our smp.

[bertie2008]

Originally Posted by ismokedrow

I don't have this same issue as my server and can't reproduce it, the line it is giving an error on is like I quoted above. Maybe someone else can weigh in on this?

Thanks for trying, I really don't know what to do

Originally Posted by thndr

Bertie...

Could you do a "script stored procedure as create to" and choose new query window on your dbo.smp_check_purchased_item and post the results here so we can compare them to our smp.

script stored procedure result, am really hoping you see something in this lot

 Spoiler

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

Other things that I have done on the server that hopefully helps sort out this problem

Lua's

 Spoiler

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

Things I do on master class character,
Using GM commands, I give D3 +20 lvl 10 gear and weapon
I play around with belt pets to see results
I use buffs, know it all, and hp regen to look around underground and circus without getting killed

That's all that I can think of that I do differently on the master class that I don't do on lower lever characters.

Looking through the sq profiler results, does the date in this result look right

 Spoiler

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

[ThunderNikk]

Try...

//item 910000 1

On the character you are having the master class issue with and see if you still have the same issues.

[bertie2008]

Originally Posted by thndr

Try...

//item 910000 1

On the character you are having the master class issue with and see if you still have the same issues.

I run the script, character gets the travel pass to hidden village for 30 days, nothing happens, however when i run the script add state 9004,2 31536000000, i get "you have gained the skill effect Travel Pass to Hidden Village" so looks like something is cancelling the script in the server ini lua function jts_server_hv()
add_state(9004,2,31536000000)

I am thinking of making another account, max leveling a character without master class to see if the problem pops up there as well, I would like to see if it is a level problem or a master class problem, or am I wasting my time

[ismokedrow]

I do not have the 'jts_server_hv' in any of my scripts, then again I only used the BARE MINIMUM scripts from the pack to ensure 9.1 content operated properly.

[bertie2008]

Originally Posted by thndr

Try...

//item 910000 1

On the character you are having the master class issue with and see if you still have the same issues.

Originally Posted by ismokedrow

I do not have the 'jts_server_hv' in any of my scripts, then again I only used the BARE MINIMUM scripts from the pack to ensure 9.1 content operated properly.

OK now i feel like a pawpaw, I made a new account, new character, he gets the Pass to Hidden Village, i look at the time and its valid for four hours and fifty three minutes, could this be my problem? I didn't look at the time before because I assumed that it was taking the hv pass that I put into the server ini lua "add_state(9004,2,31536000000)" my previous servers seemed to work fine with that in the lua, do I have to do it differently for 9.1

really sorry guys if this has been the problem all along

[ThunderNikk]

Well you see the .lua script is adding the state the HV buff...it does not add the HV item the pass.

So now you have a character that has the HV buff but the check_purchased_item is looking for the pass = 0 but on a player with the buff is_premium I think you are confusing the check_purchased_item script.

If you get what I mean.

[nimoht]

Hy it is not the lua who give 5h hv pass it 's your smp check_purchased_item . Look my thread : "small contribution " full hv pass 9.1

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

This is the part of the smp who give you auto hv pass before lvl 30 for 5h . Read my thread apply all my smp and create an market for 910000 hv pass like i explain . If you have modified "is_premium ()" function on your lua , restore the original

Link of my thread :

[ismokedrow]

That was so silly of me not to have seen that, good catch nimoht. I will add a corrected version to the guide for future usage.

[Domesday Brock]

Originally Posted by nimoht

Hy it is not the lua who give 5h hv pass it 's your smp check_purchased_item . Look my thread : "small contribution " full hv pass 9.1

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

This is the part of the smp who give you auto hv pass before lvl 30 for 5h . Read my thread apply all my smp and create an market for 910000 hv pass like i explain . If you have modified "is_premium ()" function on your lua , restore the original

Link of my thread :

I had done pretty much the same as Bertie "set premium is true" in the lua, I have replaced the lua with the original one.
I had already run all of ismokedrow's paid item fixes so I don't want to mess things up by running your scripts as well, I will insert the item into Arcadia market resource, add the item to an NPC and see what happens as soon as I get back home

[colonelx]

Originally Posted by Aurorauser

Sql viev player guild table and guild table and character table inner join function

i mean in lua or inside the game