Rappelz server files

[XavierDeFawks]

heres the 1 i found in the update files that were released on ******** a while back

-- smp_read_item_equip_info
CREATE PROCEDURE dbo.smp_read_item_equip_info
@IN_SID			INT
AS
SET NOCOUNT ON

SELECT wear_info, code, enhance, level FROM dbo.Item WITH (NOLOCK, INDEX(IDX_Item_Account_Id_Owner_Id_Auction_Id_Keeping_Id)) WHERE account_id = 0 AND owner_id = @IN_SID AND summon_id = 0 AND auction_id = 0 AND keeping_id = 0 AND wear_info > -1 AND wear_info < 22 ORDER BY update_time

RETURN @@ERROR

GO
-- smp_read_item_equip_info

and btw heres the unpacked exes the ingame commands can be found in sframe.exe

[Link404]

Thanks a lot. Is this the epic 6.1 SFrame.exe? Did you remove the gameguard loading procedure?

[XavierDeFawks]

I don't know and no I didn't. I didn't even unpack them. During a update a while back i noticed the exe's were unusually larger so when i checked it out turned out the GMs forgot to pack them before releasing the update.

[vaitomanucu10vezes]

Problem SOLVED .. THK you very much Jaws988 and soleil for doing this possible


Forum NICK name has changed to : DragonMaxBR

[soleil]

Originally Posted by vaitomanucu10vezes

Problem SOLVED .. THK you very much Jaws988 and soleil for doing this possible

vaitomanucu10vezes,

Welcome Sir

[Link404]

Ok, demonroro and me, we were able to move forward. Demonroro alias NCarbon re-wrote the Character table because some of the columns were missing. And also, some of the datatypes were wrong. With this Character table, you'll be able to create characters without getting the error "You may not create a character". Works with Neviwhatever (6.1) client. Credits to him!

 Spoiler

USE [Telecaster]
GO

/****** Object: Table [dbo].[Character] Script Date: 04/20/2011 23:21:50 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Character]') AND type in (N'U'))
DROP TABLE [dbo].[Character]
GO

USE [Telecaster]
GO

/****** Object: Table [dbo].[Character] Script Date: 04/20/2011 23:21:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Character](
[sid] [nchar](10) NULL,
[name] [nvarchar](31) NULL,
[account] [varchar](61) NULL,
[account_id] [int] NULL,
[slot] [int] NULL,
[max_reached_level] [int] NULL,
[guild_id] [int] NULL,
[party_id] [int] NULL,
[PARTY_SID] [int] NULL,
[GUILD_SID] [int] NULL,
[PREV_GUILD_SID] [int] NULL,
[X] [int] NULL,
[Y] [int] NULL,
[Z] [int] NULL,
[LAYER] [int] NULL,
[race] [int] NULL,
[sex] [int] NULL,
[LV] [int] NULL,
[EXP] [bigint] NULL,
[LAST_DECREASED_EXP] [bigint] NULL,
[HP] [int] NULL,
[MP] [int] NULL,
[STAMINA] [int] NULL,
[HAVOC] [int] NULL,
[permission] [int] NULL,
[model_00] [int] NULL,
[model_01] [int] NULL,
[model_02] [int] NULL,
[model_03] [int] NULL,
[model_04] [int] NULL,
[DEFAULT_WEAPON_SID] [bigint] NULL,
[DEFAULT_WEAPON_CODE] [int] NULL,
[DEFAULT_ARMOR_SID] [bigint] NULL,
[DEFAULT_ARMOR_CODE] [int] NULL,
[DEFAULT_BAG_SID] [bigint] NULL,
[DEFAULT_BAG_CODE] [int] NULL,
[JOB] [int] NULL,
[JOB_DEPTH] [int] NULL,
[JLV] [int] NULL,
[JP] [int] NULL,
[TOTAL_JP] [int] NULL,
[JOB_0] [int] NULL,
[JOB_1] [int] NULL,
[JOB_2] [int] NULL,
[JLV_0] [int] NULL,
[JLV_1] [int] NULL,
[JLV_2] [int] NULL,
[immoral_point] [int] NULL,
[IP] [real] NULL,
[CHA] [int] NULL,
[PKC] [int] NULL,
[DKC] [int] NULL,
[HUNTAHOLIC] [int] NULL,
[huntaholic_point] [int] NULL,
[GOLD] [bigint] NULL,
[CHAOS] [int] NULL,
[SKIN_COLOR] [int] NULL,
[FLAG_LIST] [varchar](4000) NULL,
[SUMMON_0] [int] NULL,
[SUMMON_1] [int] NULL,
[SUMMON_2] [int] NULL,
[SUMMON_3] [int] NULL,
[SUMMON_4] [int] NULL,
[SUMMON_5] [int] NULL,
[create_time] [datetime] NULL,
[delete_time] [datetime] NULL,
[login_time] [datetime] NULL,
[logout_time] [datetime] NULL,
[login_count] [datetime] NULL,
[play_time] [datetime] NULL,
[BELT_0] [bigint] NULL,
[BELT_1] [bigint] NULL,
[BELT_2] [bigint] NULL,
[BELT_3] [bigint] NULL,
[BELT_4] [bigint] NULL,
[BELT_5] [bigint] NULL,
[MAIN_SUMMON] [int] NULL,
[SUB_SUMMON] [int] NULL,
[REMAIN_SUMMON_TIME] [int] NULL,
[PET] [int] NULL,
[REMAIN_CHAT_BLOCK_TIME] [int] NULL,
[LOGOUT_DURATION] [int] NULL,
[OUT_NAME_CHANGED] [int] NULL,
[ADV_CHAT_COUNT] [int] NULL,
[AUTO_USED] [int] NULL,
[GUILD_BLOCK_TIME] [bigint] NULL,
[PKMODE] [tinyint] NULL,
[belt_00] [int] NULL,
[belt_01] [int] NULL,
[belt_02] [int] NULL,
[belt_03] [int] NULL,
[belt_04] [int] NULL,
[belt_05] [int] NULL,
[prev_guild_id] [int] NULL,
[otp_value] [int] NULL,
[otp_date] [datetime] NULL,
[chat_block_time] [int] NULL,
[client_info] [varchar](2048) NULL,
[name_changed] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EDIT: Forgot to tell you that: You'll be able to create characters, but you'll stuck at loading the characters.

[jw988]

all that has done is made it have nulls in the sids, if you look now when it makes items it gives the owner id as null if you followed my info it would fill in the items table correct, you will also find that all the info you put back in to the char table shows as null as it is old unused data.

Btw there is 3 epic 6 parts but it went epic 6.0 then 6.1 then 6.2 or by name Navislamia, Solus Aurum, Resurrection

Originally Posted by Link404

Ok, demonroro and me, we were able to move forward. Demonroro alias NCarbon re-wrote the Character table because some of the columns were missing. And also, some of the datatypes were wrong. With this Character table, you'll be able to create characters without getting the error "You may not create a character". Works with Neviwhatever (6.1) client. Credits to him!

 Spoiler

USE [Telecaster]
GO

/****** Object: Table [dbo].[Character] Script Date: 04/20/2011 23:21:50 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Character]') AND type in (N'U'))
DROP TABLE [dbo].[Character]
GO

USE [Telecaster]
GO

/****** Object: Table [dbo].[Character] Script Date: 04/20/2011 23:21:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Character](
[sid] [nchar](10) NULL,
[name] [nvarchar](31) NULL,
[account] [varchar](61) NULL,
[account_id] [int] NULL,
[slot] [int] NULL,
[max_reached_level] [int] NULL,
[guild_id] [int] NULL,
[party_id] [int] NULL,
[PARTY_SID] [int] NULL,
[GUILD_SID] [int] NULL,
[PREV_GUILD_SID] [int] NULL,
[X] [int] NULL,
[Y] [int] NULL,
[Z] [int] NULL,
[LAYER] [int] NULL,
[race] [int] NULL,
[sex] [int] NULL,
[LV] [int] NULL,
[EXP] [bigint] NULL,
[LAST_DECREASED_EXP] [bigint] NULL,
[HP] [int] NULL,
[MP] [int] NULL,
[STAMINA] [int] NULL,
[HAVOC] [int] NULL,
[permission] [int] NULL,
[model_00] [int] NULL,
[model_01] [int] NULL,
[model_02] [int] NULL,
[model_03] [int] NULL,
[model_04] [int] NULL,
[DEFAULT_WEAPON_SID] [bigint] NULL,
[DEFAULT_WEAPON_CODE] [int] NULL,
[DEFAULT_ARMOR_SID] [bigint] NULL,
[DEFAULT_ARMOR_CODE] [int] NULL,
[DEFAULT_BAG_SID] [bigint] NULL,
[DEFAULT_BAG_CODE] [int] NULL,
[JOB] [int] NULL,
[JOB_DEPTH] [int] NULL,
[JLV] [int] NULL,
[JP] [int] NULL,
[TOTAL_JP] [int] NULL,
[JOB_0] [int] NULL,
[JOB_1] [int] NULL,
[JOB_2] [int] NULL,
[JLV_0] [int] NULL,
[JLV_1] [int] NULL,
[JLV_2] [int] NULL,
[immoral_point] [int] NULL,
[IP] [real] NULL,
[CHA] [int] NULL,
[PKC] [int] NULL,
[DKC] [int] NULL,
[HUNTAHOLIC] [int] NULL,
[huntaholic_point] [int] NULL,
[GOLD] [bigint] NULL,
[CHAOS] [int] NULL,
[SKIN_COLOR] [int] NULL,
[FLAG_LIST] [varchar](4000) NULL,
[SUMMON_0] [int] NULL,
[SUMMON_1] [int] NULL,
[SUMMON_2] [int] NULL,
[SUMMON_3] [int] NULL,
[SUMMON_4] [int] NULL,
[SUMMON_5] [int] NULL,
[create_time] [datetime] NULL,
[delete_time] [datetime] NULL,
[login_time] [datetime] NULL,
[logout_time] [datetime] NULL,
[login_count] [datetime] NULL,
[play_time] [datetime] NULL,
[BELT_0] [bigint] NULL,
[BELT_1] [bigint] NULL,
[BELT_2] [bigint] NULL,
[BELT_3] [bigint] NULL,
[BELT_4] [bigint] NULL,
[BELT_5] [bigint] NULL,
[MAIN_SUMMON] [int] NULL,
[SUB_SUMMON] [int] NULL,
[REMAIN_SUMMON_TIME] [int] NULL,
[PET] [int] NULL,
[REMAIN_CHAT_BLOCK_TIME] [int] NULL,
[LOGOUT_DURATION] [int] NULL,
[OUT_NAME_CHANGED] [int] NULL,
[ADV_CHAT_COUNT] [int] NULL,
[AUTO_USED] [int] NULL,
[GUILD_BLOCK_TIME] [bigint] NULL,
[PKMODE] [tinyint] NULL,
[belt_00] [int] NULL,
[belt_01] [int] NULL,
[belt_02] [int] NULL,
[belt_03] [int] NULL,
[belt_04] [int] NULL,
[belt_05] [int] NULL,
[prev_guild_id] [int] NULL,
[otp_value] [int] NULL,
[otp_date] [datetime] NULL,
[chat_block_time] [int] NULL,
[client_info] [varchar](2048) NULL,
[name_changed] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EDIT: Forgot to tell you that: You'll be able to create characters, but you'll stuck at loading the characters.

[>_>*Eistee*<_<]

Now it works ?

[soleil]

hello people,
the server works fine until the creation of personal after the creation of personal blocker ... I am working I always have problem

[DragonMaxBR]

needing RappelzUS_v1.4.405.exe (Solus Aurum US) any good links out there ??

[soleil]

Originally Posted by DragonMaxBR

needing RappelzUS_v1.4.405.exe (Solus Aurum US) any good links out there ??

DrogonMaxBR,

This is good for you ?


Link: )

[demonroro]

Lastest work on Character Table, SMP_INSERT_CHARACTER, Item Table

Character Table

 Spoiler

USE [Telecaster]
GO

/****** Object: Table [dbo].[Character] Script Date: 04/24/2011 01:05:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO
DROP TABLE Character
CREATE TABLE [dbo].[Character](
[sid] INT IDENTITY(1,1),
[name] [nvarchar](31) NULL,
[account] [varchar](61) NULL,
[account_id] [int] NULL,
[slot] [int] NULL,
[max_reached_level] [int] NULL,
[guild_id] [int] NULL,
[party_id] [int] NULL,
[PARTY_SID] [int] NULL,
[GUILD_SID] [int] NULL,
[PREV_GUILD_SID] [int] NULL,
[X] [int] NULL,
[Y] [int] NULL,
[Z] [int] NULL,
[layer] [int] NULL,
[race] [int] NULL,
[sex] [int] NULL,
[lv] [int] NULL,
[exp] [bigint] NULL,
[last_decreased_exp] [bigint] NULL,
[hp] [int] NULL,
[mp] [int] NULL,
[stamina] [int] NULL,
[havoc] [int] NULL,
[permission] [int] NULL,
[model_00] [int] NULL,
[model_01] [int] NULL,
[model_02] [int] NULL,
[model_03] [int] NULL,
[model_04] [int] NULL,
[default_weapon_sid] [bigint] NULL,
[default_weapon_code] [int] NULL,
[default_armor_sid] [bigint] NULL,
[default_armor_code] [int] NULL,
[default_bag_sid] [bigint] NULL,
[default_bag_code] [int] NULL,
[job] [int] NULL,
[job_depth] [int] NULL,
[jlv] [int] NULL,
[jp] [int] NULL,
[total_jp] [int] NULL,
[job_0] [int] NULL,
[job_1] [int] NULL,
[job_2] [int] NULL,
[jlv_0] [int] NULL,
[jlv_1] [int] NULL,
[jlv_2] [int] NULL,
[immoral_point] [int] NULL,
[ip] [real] NULL,
[cha] [int] NULL,
[pkc] [int] NULL,
[dkc] [int] NULL,
[huntaholic] [int] NULL,
[huntaholic_point] [int] NULL,
[gold] [bigint] NULL,
[chaos] [int] NULL,
[skin_color] [int] NULL,
[flag_list] [varchar](4000) NULL,
[summon_0] [int] NULL,
[summon_1] [int] NULL,
[summon_2] [int] NULL,
[summon_3] [int] NULL,
[summon_4] [int] NULL,
[summon_5] [int] NULL,
[create_time] [datetime] NULL,
[delete_time] [datetime] NULL,
[login_time] [datetime] NULL,
[logout_time] [datetime] NULL,
[login_count] [datetime] NULL,
[play_time] [datetime] NULL,
[main_summon] [int] NULL,
[sub_summon] [int] NULL,
[remain_summon_time] [int] NULL,
[pet] [int] NULL,
[remain_chat_block_time] [int] NULL,
[logout_duration] [int] NULL,
[out_name_changed] [int] NULL,
[adv_chat_count] [int] NULL,
[auto_used] [int] NULL,
[guild_block_time] [bigint] NULL,
[pkmode] [tinyint] NULL,
[belt_00] [int] NULL,
[belt_01] [int] NULL,
[belt_02] [int] NULL,
[belt_03] [int] NULL,
[belt_04] [int] NULL,
[belt_05] [int] NULL,
[prev_guild_id] [int] NULL,
[otp_value] [int] NULL,
[otp_date] [datetime] NULL,
[chat_block_time] [int] NULL,
[client_info] [varchar](2048) NULL,
[name_changed] [int] NULL,
)

GO
SET ANSI_PADDING OFF
GO

SMP_INSERT_CHARACTER

 Spoiler

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_insert_character] Script Date: 04/22/2011 00:41:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: NCarbon Develop
-- Create date: 21/04/11
-- Description: Character Inserting Procedure
-- =============================================
-- start of smp_insert_character

ALTER PROCEDURE [dbo].[smp_insert_character]
--@IN_SID INT OUTPUT,
@OUT_SID NCHAR(10) 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_MAX_REACHED_LEVEL INT,
@IN_LV INT,
@IN_HP INT,
@IN_MP INT,
@IN_JLV INT,
@IN_JP INT,
@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_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 -- <<<<--- Bugged Param |
---------------*
AS
--SET IDENTITY_INSERT Character ON -- <<< Trying to set SIDs on Character Table
SET NOCOUNT ON
DECLARE @RET INT
SET @RET = 0
BEGIN TRANSACTION
--DECLARE @IN_SID INT
--SET @IN_SID = 2
--BEGIN TRANSACTION --.------------------------------------------------------------.
--DECLARE @IN_DEFAULT_BAG_CODE INT --| <<< Uncomment that when @IN_DEFAULT_BAG_CODE brings errors |
--SET @IN_DEFAULT_BAG_CODE = 1 --| |
--BEGIN TRANSACTION --|_________________________________________________ ___________|

SELECT @RET = COUNT(*) FROM 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 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
job_0, -- 22
job_1, -- 23
job_2, -- 24
jlv_0, -- 25
jlv_1, -- 26
jlv_2, -- 27
immoral_point, -- 28
cha, -- 29
pkc, -- 30
dkc, -- 31
huntaholic_point, -- 32
create_time, -- 33
delete_time, -- 34
login_time, -- 35
logout_time, -- 36
login_count, -- 37
play_time, -- 38
belt_00, -- 39
belt_01, -- 40
belt_02, -- 41
belt_03, -- 42
belt_04, -- 43
belt_05, -- 44
permission, -- 45
skin_color, -- 46
model_00, -- 47
model_01, -- 48
model_02, -- 49
model_03, -- 50
model_04, -- 51
job, -- 52
gold, -- 53
party_id, -- 54
guild_id, -- 55
prev_guild_id, -- 56
flag_list, -- 57
client_info, -- 58
job_depth, -- 59
summon_0, -- 60
summon_1, -- 61
summon_2, -- 62
summon_3, -- 63
summon_4, -- 64
summon_5, -- 65
main_summon, -- 66
sub_summon, -- 67
remain_summon_time, -- 68
pet, -- 69
chaos, -- 70
adv_chat_count, -- 71
name_changed, -- 72
auto_used, -- 73
guild_block_time, -- 74
pkmode, -- 75
otp_value, -- 76
otp_date, -- 77
chat_block_time, -- 78
default_weapon_sid, -- 79-- BEGIN OF NCarbon Patch --
default_weapon_code, -- 80
default_armor_sid, -- 81
default_armor_code, -- 82
default_bag_sid, -- 83
default_bag_code, -- 84
ip, -- 85
huntaholic, -- 86
remain_chat_block_time, -- 87
logout_duration, -- 88
out_name_changed -- 89 -- END OF NCarbon Patch --

)
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
@IN_CHA, -- 29
0, -- 30
0, -- 31
0, -- 32
GETDATE(), -- 33
CONVERT( DATETIME, '9999-12-31', 120 ), -- 34
0, -- 35
GETDATE(), -- 36
0, -- 37
0, -- 38
0, -- 39
0, -- 40
0, -- 41
0, -- 42
0, -- 43
0, -- 44
0, -- 45
@IN_SKIN_COLOR, -- 46
@IN_MODEL_00, -- 47
@IN_MODEL_01, -- 48
@IN_MODEL_02, -- 49
@IN_MODEL_03, -- 50
@IN_MODEL_04, -- 51
0, -- 52
0, -- 53
0, -- 54
0, -- 55
0, -- 56
'', -- 57
'QS=0,0,2,0|QS=0,1,2,2|QS=0,11,2,1|', -- 58
0, -- 59
0, -- 60
0, -- 61
0, -- 62
0, -- 63
0, -- 64
0, -- 65
0, -- 66
0, -- 67
0, -- 68
0, -- 69
0, -- 70
0, -- 71
1, -- 72
0, -- 73
0, -- 74
0, -- 75
0, -- 76
GETDATE(), -- 77
0, -- 78
@IN_DEFAULT_WEAPON_SID, -- 79 -- BEGIN OF NCarbon Patch --
@IN_DEFAULT_WEAPON_CODE, -- 80
@IN_DEFAULT_ARMOR_SID, -- 81
@IN_DEFAULT_ARMOR_CODE, -- 82
@IN_DEFAULT_BAG_SID, -- 83
@IN_DEFAULT_BAG_CODE, -- 84
0, -- 85
0, -- 86
0, -- 87
0, -- 88
0 -- 89 -- END OF NCarbon Patch --
);



IF @@ERROR <> 0
BEGIN
SET @RET = -1
ROLLBACK TRANSACTION
GOTO ON_END
END
--SET IDENTITY_INSERT Character OFF
--SET IDENTITY_INSERT dbo.Item ON --<<< Appears to be not necessary
SET @OUT_SID = SCOPE_IDENTITY();


-- ±âº» ¹«±â Áö±Þ
INSERT INTO dbo.Item
(
sid, -- 0
account_id, -- 1
owner_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
idx, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
endurance, -- 12
gcode, -- 13
create_time, -- 14
wear_info, -- 15
socket_0, -- 16
socket_1, -- 17
socket_2, -- 18
socket_3, -- 19
--socket_4, -- 20 Added
--socket_5, -- 21 Added
remain_time, -- 22
elemental_effect_type, -- 23
elemental_effect_expire_time, -- 24
elemental_effect_attack_point, -- 25
elemental_effect_magic_point, -- 26
update_time -- 27
)
VALUES
(
@IN_DEFAULT_WEAPON_SID, -- 0
0, -- 1
@OUT_SID, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@IN_DEFAULT_WEAPON_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
50, -- 12
6, -- 13
GETDATE(), -- 14
0, -- 15
0, -- 16
0, -- 17
0, -- 18
0, -- 19
--0, -- 20 Added
--0, -- 21 Added
0, -- 22
0, -- 23
CONVERT( DATETIME, '2000-01-01', 120 ), -- 24
0, -- 25
0, -- 26
GETDATE() -- 27
);

-- ±âº» ¾Æ¸Ó Áö±Þ
INSERT INTO dbo.Item
(
sid, -- 0
account_id, -- 1
owner_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
idx, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
endurance, -- 12
gcode, -- 13
create_time, -- 14
wear_info, -- 15
socket_0, -- 16
socket_1, -- 17
socket_2, -- 18
socket_3, -- 19
--socket_4, -- 20 Added
--socket_5, -- 21 Added
remain_time, -- 22
elemental_effect_type, -- 23
elemental_effect_expire_time, -- 24
elemental_effect_attack_point, -- 25
elemental_effect_magic_point, -- 26
update_time -- 27
)
VALUES
(
@IN_DEFAULT_ARMOR_SID, -- 0
0, -- 1
@OUT_SID, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@IN_DEFAULT_ARMOR_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
50, -- 12
6, -- 13
GETDATE(), -- 14
2, -- 15
0, -- 16
0, -- 17
0, -- 18
0, -- 19
--0, -- 20 Added
--0, -- 21 Added
0, -- 22
0, -- 23
CONVERT( DATETIME, '2000-01-01', 120 ), -- 24
0, -- 25
0, -- 26
GETDATE() -- 27
);

-- ±âº» °¡¹æ Áö±Þ
INSERT INTO dbo.Item
(
sid, -- 0
account_id, -- 1
owner_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
idx, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
endurance, -- 12
gcode, -- 13
create_time, -- 14
wear_info, -- 15
socket_0, -- 16
socket_1, -- 17
socket_2, -- 18
socket_3, -- 19
--socket_4, -- 20 Added
--socket_5, -- 21 Added
remain_time, -- 22
elemental_effect_type, -- 23
elemental_effect_expire_time, -- 24
elemental_effect_attack_point, -- 25
elemental_effect_magic_point, -- 26
update_time -- 27
)
VALUES
(
@IN_DEFAULT_BAG_SID, -- 0
0, -- 1
@OUT_SID, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@IN_DEFAULT_BAG_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
50, -- 12
6, -- 13
GETDATE(), -- 14
23, -- 15
0, -- 16
0, -- 17
0, -- 18
0, -- 19
--0, -- 20 Added
--0, -- 21 Added
0, -- 22
0, -- 23
CONVERT( DATETIME, '2000-01-01', 120 ), -- 24
0, -- 25
0, -- 26
GETDATE() -- 27
);
--SET IDENTITY_INSERT Item OFF
ON_SUCCESS:
COMMIT TRANSACTION

ON_END:
RETURN @RET

-- end of smp_insert_character

Item Table

 Spoiler

USE [Telecaster]
GO

/****** Object: Table [dbo].[Item] Script Date: 04/29/2011 01:36:32 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Item]') AND type in (N'U'))
DROP TABLE [dbo].[Item]
GO

USE [Telecaster]
GO

/****** Object: Table [dbo].[Item] Script Date: 04/29/2011 01:36:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Item](
[sid] [int] NOT NULL,
[account_id] [int] NOT NULL,
[owner_id] [int] NOT NULL,
[summon_id] [int] NOT NULL,
[auction_id] [int] NULL,
[keeping_id] [int] NOT NULL,
[idx] [int] NOT NULL,
[code] [int] NOT NULL,
[flag] [int] NOT NULL,
[cnt] [int] NOT NULL,
[level] [int] NOT NULL,
[enhance] [int] NOT NULL,
[endurance] [int] NOT NULL,
[gcode] [int] NOT NULL,
[create_time] [datetime] NOT NULL,
[wear_info] [int] NOT NULL,
[socket_0] [int] NOT NULL,
[socket_1] [int] NOT NULL,
[socket_2] [int] NOT NULL,
[socket_3] [int] NOT NULL,
[remain_time] [int] NULL,
[update_time] [datetime] NULL,
[COUNT] [bigint] NULL,
[elemental_effect_type] [tinyint] NOT NULL,
[elemental_effect_expire_time] [datetime] NOT NULL,
[elemental_effect_attack_point] [int] NOT NULL,
[elemental_effect_magic_point] [int] NOT NULL,
[KEEPING_ITEM_OWNER_UID] [int] NULL,
[RESULT_ITEM_ID] [bigint] NULL,
[RESULT_ITEM_COUNT] [bigint] NULL
) ON [PRIMARY]

GO

Characters are now created with SIDs, items are now created too.
Server crashes now with those following procedures :
smp_read_character_list and smp_read_item_equip_info

** EDIT : Updated

[DragonMaxBR]

Originally Posted by soleil

DrogonMaxBR,

This is good for you ?


Link: FilePlanet: Rappelz Client - Epic VI: Solus Aurum (Free MMO))

--------------------------------------------------------------------------------

this is rappelz epic 7 LOST
but i apreciate thks

[DragonMaxBR]

Originally Posted by pyrok

you won't be able to create an account unless you either have an epic 6.1 client (aor is 6.2) or you modify the gameserver itself (not recommended unless you know asm fairly well). The modification to allow character creation is easy (1 byte) but then you run into a bunch of issues with the character selection screen (it is blank). Even if you manage to get past that part (MANY changes needed to do so, including adding some code, not just changing offsets),

if it need to be patched for full working , i believe that will take long to release something.

[katalin21k]

dragonmaxbr here its what u need...solus aurum client

(its torrent file...if u cant dl...soon ill post mu link)