9.4 Own server + dbo.Character error

[tchicaba]

Hi everyone,

And thank you for clicking on my thread.
As of today, I tried to make my own 9.4 server with Fear files.

I've done it properly, few years ago, as everything went good.
But for now, when I launch Rappelz, and I try to make a character, whatever the nickname I choose, it always says "You cannot create this character.".

Logic makes me go to the Sherlock to see what's the error and I got this :


"DB COM ERROR(Thread:0, HRESULT:80040E10, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_CreateCharacter(dbo.smp_insert_character) : Procedure or function 'smp_insert_character' expects parameter '@IN_DEFAULT_BAG_CODE', which was not supplied."

Is there any ways to fix it ? Tried several telecaster's, tried to backup and restore everything, but nothing works.

Thank you boys !


p.s : I also tried to lookup on google if there was the same problem to get an answer but infortunely there's no solutions atm.

[ThunderNikk]

Maybe the sframe?

[tchicaba]

Erhh, It could be the problem. I'll try a different sframe.



Edit : While using 3 different "sFrame", the problem still remains.
Any help appreciated ^^

[Exterminator-[Fury]]

Post your smp pls

Originally Posted by tchicaba

Erhh, It could be the problem. I'll try a different sframe.



Edit : While using 3 different "sFrame", the problem still remains.
Any help appreciated ^^

[tchicaba]

can't deal to find them unfortunately ?.. Or where should I find them ?



still not found the solution atm.

[Exterminator-[Fury]]

Sql telecaster/tables/programmability/stored procedues
There is the list of all the smps, sp etc.

Originally Posted by tchicaba

can't deal to find them unfortunately ?.. Or where should I find them ?



still not found the solution atm.

[tchicaba]

Originally Posted by exter16

Sql telecaster/tables/programmability/stored procedues
There is the list of all the smps, sp etc.

There we go :


edit : // There is, actually, a dbo.smp_insert_character.

[Exterminator-[Fury]]

Open the dbo.smp_insert_character and post the code pls

Originally Posted by tchicaba

There we go :


edit : // There is, actually, a dbo.smp_insert_character.

[tchicaba]

I just moved to 9.5.2, everything is working fine. I'm sorry guys for the inconvenience...

[tchicaba]

///UPDATE : I'm still on this problem.

Here is the smp_character :

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_insert_character] Script Date: 12/04/2021 15:28:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_insert_character
ALTER PROCEDURE [dbo].[smp_insert_character]

@OUT_SID INT OUTPUT,
@IN_NAME NVARCHAR(31),
@IN_ACCOUNT VARCHAR(61),
@IN_ACCOUNT_ID INT,
@IN_SLOT INT,
@IN_X INT,
@IN_Y INT,
@IN_Z INT,
@IN_LAYER INT,
@IN_RACE INT,
@IN_SEX INT,
@IN_LV INT,
@IN_MAX_REACHED_LEVEL INT,
@IN_HP INT,
@IN_MP INT,
@IN_JLV INT,
@IN_JP BIGINT,
@IN_CHA INT,
@IN_SKIN_COLOR INT,
@IN_MODEL_00 INT,
@IN_MODEL_01 INT,
@IN_MODEL_02 INT,
@IN_MODEL_03 INT,
@IN_MODEL_04 INT,
@IN_HAIR_COLOR_INDEX INT,
@IN_HAIR_COLOR_RGB INT,
@IN_TEXTURE_ID INT,
@IN_DEFAULT_WEAPON_SID BIGINT,
@IN_DEFAULT_WEAPON_CODE INT,
@IN_DEFAULT_ARMOR_SID BIGINT,
@IN_DEFAULT_ARMOR_CODE INT,
@IN_DEFAULT_BAG_SID BIGINT,
@IN_DEFAULT_BAG_CODE INT

AS
SET NOCOUNT ON

DECLARE @RET INT
SET @RET = 0

BEGIN TRANSACTION

SELECT @RET = COUNT(*) FROM dbo.Character WITH (NOLOCK) where name = @IN_NAME;

IF @RET > 0
BEGIN
ROLLBACK TRANSACTION
SET @OUT_SID = 0;
SET @RET = -1;
GOTO ON_END
END

INSERT INTO dbo.Character
(
-- sid, -- 0
name, -- 1
account, -- 2
account_id, -- 3
slot, -- 4
x, -- 5
y, -- 6
z, -- 7
layer, -- 8
race, -- 9
sex, -- 10
exp, -- 11
last_decreased_exp, -- 12
lv, -- 13
max_reached_level, -- 14
hp, -- 15
mp, -- 16
stamina, -- 17
havoc, -- 18
jlv, -- 19
jp, -- 20
total_jp, -- 21
talent_point, -- 22
job_0, -- 23
job_1, -- 24
job_2, -- 25
jlv_0, -- 26
jlv_1, -- 27
jlv_2, -- 28
immoral_point, -- 29
cha, -- 30
pkc, -- 31
dkc, -- 32
huntaholic_point, -- 33
huntaholic_enter_count, -- 34
ethereal_stone_durability, -- 35
create_time, -- 36
delete_time, -- 37
login_time, -- 38
logout_time, -- 39
login_count, -- 40
play_time, -- 41
belt_00, -- 42
belt_01, -- 43
belt_02, -- 44
belt_03, -- 45
belt_04, -- 46
belt_05, -- 47
permission, -- 48
skin_color, -- 49
model_00, -- 50
model_01, -- 51
model_02, -- 52
model_03, -- 53
model_04, -- 54
hair_color_index, -- 55
hair_color_rgb, -- 56
hide_equip_flag, -- 57
texture_id, -- 58
job, -- 59
gold, -- 60
party_id, -- 61
flag_list, -- 62
-- client_info, -- 63
job_depth, -- 64
summon_0, -- 65
summon_1, -- 66
summon_2, -- 67
summon_3, -- 68
summon_4, -- 69
summon_5, -- 70
main_summon, -- 71
sub_summon, -- 72
remain_summon_time, -- 73
pet, -- 74
main_title, -- 75
sub_title_0, -- 76
sub_title_1, -- 77
sub_title_2, -- 78
sub_title_3, -- 79
sub_title_4, -- 80
remain_title_time, -- 81
arena_point, -- 82
arena_block_time, -- 83
arena_penalty_count, -- 84
arena_penalty_dec_time, -- 85
arena_mvp_count, -- 86
arena_record_0_0, -- 87
arena_record_0_1, -- 88
arena_record_1_0, -- 89
arena_record_1_1, -- 90
arena_record_2_0, -- 91
arena_record_2_1, -- 92
alias, -- 93
chaos, -- 94
adv_chat_count, -- 95
name_changed, -- 96
auto_used, -- 97
pkmode, -- 98
otp_value, -- 99
otp_date, -- 100
chat_block_time, -- 101
belt_06,
belt_07,
play_time_point,
rx,
ry,
hx,
hy
)
VALUES
(
-- @IN_SID, -- 0 DB°، ہعµ؟ ¹ك±ق
@IN_NAME, -- 1
@IN_ACCOUNT, -- 2
@IN_ACCOUNT_ID, -- 3
@IN_SLOT, -- 4
@IN_X, -- 5
@IN_Y, -- 6
@IN_Z, -- 7
@IN_LAYER, -- 8
@IN_RACE, -- 9
@IN_SEX, -- 10
0, -- 11
0, -- 12
@IN_LV, -- 13
@IN_MAX_REACHED_LEVEL, -- 14
@IN_HP, -- 15
@IN_MP, -- 16
0, -- 17
0, -- 18
@IN_JLV, -- 19
@IN_JP, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
0, -- 25
0, -- 26
0, -- 27
0, -- 28
0, -- 29
@IN_CHA, -- 30
0, -- 31
0, -- 32
0, -- 33
12, -- 34
0, -- 35
GETDATE(), -- 36
CONVERT( DATETIME, '9999-12-31', 120 ), -- 37
0, -- 38
GETDATE(), -- 39
0, -- 40
0, -- 41
0, -- 42
0, -- 43
0, -- 44
0, -- 45
0, -- 46
0, -- 47
0, -- 48
@IN_SKIN_COLOR, -- 49
@IN_MODEL_00, -- 50
@IN_MODEL_01, -- 51
@IN_MODEL_02, -- 52
@IN_MODEL_03, -- 53
@IN_MODEL_04, -- 54
@IN_HAIR_COLOR_INDEX, -- 55
@IN_HAIR_COLOR_RGB, -- 56
0, -- 57
@IN_TEXTURE_ID, -- 58
0, -- 59
0, -- 60
0, -- 61
'', -- 62
-- 0, -- 63
0, -- 64
0, -- 65
0, -- 66
0, -- 67
0, -- 68
0, -- 69
0, -- 70
0, -- 71
0, -- 72
0, -- 73
0, -- 74
0, -- 75
0, -- 76
0, -- 77
0, -- 78
0, -- 79
0, -- 80
0, -- 81
0, -- 82
CONVERT( DATETIME, '2000-1-1', 120 ), -- 83
0, -- 84
CONVERT( DATETIME, '2000-1-1', 120 ), -- 85
0, -- 86
0, -- 87
0, -- 88
0, -- 89
0, -- 90
0, -- 91
0, -- 92
N'', -- 93
0, -- 94
0, -- 95
1, -- 96
0, -- 97
0, -- 98
0, -- 99
GETDATE(), -- 100
0, -- 101
0,
0,
0,
0,
0,
0,
0
);

IF @@ERROR <> 0
BEGIN
SET @RET = -1
ROLLBACK TRANSACTION
GOTO ON_END
END

SET @OUT_SID = SCOPE_IDENTITY();

-- ±â؛» ¹«±â ءِ±ق
INSERT INTO dbo.Item
(
sid, -- 0
owner_id, -- 1
account_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
previous_sid, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
ethereal_durability, -- 12
endurance, -- 13
gcode, -- 14
create_time, -- 15
wear_info, -- 16
socket_0, -- 17
socket_1, -- 18
socket_2, -- 19
socket_3, -- 20
awaken_sid, -- 21
random_option_sid, -- 22
remain_time, -- 23
elemental_effect_type, -- 24
elemental_effect_expire_time, -- 25
elemental_effect_attack_point, -- 26
elemental_effect_magic_point, -- 27
appearance_code, -- 28
update_time, -- 29
summon_code -- 30
)
VALUES
(
@IN_DEFAULT_WEAPON_SID, -- 0
@OUT_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@IN_DEFAULT_WEAPON_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
0, -- 12
50, -- 13
6, -- 14
GETDATE(), -- 15
0, -- 16
0, -- 17
0, -- 18
0, -- 19
0, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
CONVERT( DATETIME, '2000-01-01', 120 ), -- 25
0, -- 26
0, -- 27
0, -- 28
GETDATE(), -- 29
0 -- 30
);

-- ±â؛» ¾ئ¸س ءِ±ق
INSERT INTO dbo.Item
(
sid, -- 0
owner_id, -- 1
account_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
previous_sid, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
ethereal_durability, -- 12
endurance, -- 13
gcode, -- 14
create_time, -- 15
wear_info, -- 16
socket_0, -- 17
socket_1, -- 18
socket_2, -- 19
socket_3, -- 20
awaken_sid, -- 21
random_option_sid, -- 22
remain_time, -- 23
elemental_effect_type, -- 24
elemental_effect_expire_time, -- 25
elemental_effect_attack_point, -- 26
elemental_effect_magic_point, -- 27
appearance_code, -- 28
update_time, -- 29
summon_code -- 30
)
VALUES
(
@IN_DEFAULT_ARMOR_SID, -- 0
@OUT_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@IN_DEFAULT_ARMOR_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
0, -- 12
50, -- 13
6, -- 14
GETDATE(), -- 15
2, -- 16
0, -- 17
0, -- 18
0, -- 19
0, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
CONVERT( DATETIME, '2000-01-01', 120 ), -- 25
0, -- 26
0, -- 27
0, -- 28
GETDATE(), -- 29
0 -- 30
);

-- ±â؛» °،¹و ءِ±ق
INSERT INTO dbo.Item
(
sid, -- 0
owner_id, -- 1
account_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
previous_sid, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
ethereal_durability, -- 12
endurance, -- 13
gcode, -- 14
create_time, -- 15
wear_info, -- 16
socket_0, -- 17
socket_1, -- 18
socket_2, -- 19
socket_3, -- 20
awaken_sid, -- 21
random_option_sid, -- 22
remain_time, -- 23
elemental_effect_type, -- 24
elemental_effect_expire_time, -- 25
elemental_effect_attack_point, -- 26
elemental_effect_magic_point, -- 27
appearance_code, -- 28
update_time, -- 29
summon_code -- 30
)
VALUES
(
@IN_DEFAULT_BAG_SID, -- 0
@OUT_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@IN_DEFAULT_BAG_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
0, -- 12
50, -- 13
6, -- 14
GETDATE(), -- 15
23, -- 16
0, -- 17
0, -- 18
0, -- 19
0, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
CONVERT( DATETIME, '2000-01-01', 120 ), -- 25
0, -- 26
0, -- 27
0, -- 28
GETDATE(), -- 29
0 -- 30
);

ON_SUCCESS:
COMMIT TRANSACTION

ON_END:
RETURN @RET

-- end of smp_insert_character