Rappelz server files

sabit · 04/12/2011, 17:04

Yes i know... but i wantet to have the same point then u all^^

sabit · 04/12/2011, 17:08

i dont can do this becouse my captain... exe crashed everytime

and i think i must have the both exe online.... but the on only funcition are the auth server they run perfectly.....^^

Gangxtar1 · 04/12/2011, 17:13

pls one of u guys who got working GS and AuthS create a vid or TUT from beginning.
i cant connect with my gameserver.
i do all things u tell me but cant connect
maybe there are fail configurations of sql, game_bin,hosts ,...
pls create a TUT or VID
VID would be better
and maybe the links of ya files and sql

khshe · 04/12/2011, 17:13

Quote:

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S app.name:TestServer
S log.ip:127.0.0.1
S db.auth.port:1433
N auth.version:200701120
N auth.max_client_per_ip:30000
N db.auth.use_webauth:1
S db.auth.gamecode:MODE=L&GAMECODE=G004&GPOTATOID=%U ID&PASSWORD=%PASS&USERIP=%IP
S db.auth.webserver:spe.gpotato.eu
S db.auth.weburl:/Account/Authentication.Aspx
N db.auth.webtimeout:10000000
N game.user_limit:3500
N auth.max_daily_client_per_ip:30

And it is true options?

khshe · 04/12/2011, 17:24

Commands auth server "List"

sileng · 04/12/2011, 17:47

@sabit dude read the whole post you'll find what you're looking for

sabit · 04/12/2011, 19:06

Ok sry for all the prob i have make the post from begin to the end end now both are runnnign the game server and the auth server i want to say a special thx for alll here^^ plz do it forward hehe^^ im so lucky hehe^^

thx

EDIT: now i having the probleme with "cannnotconnect to the Server" but i wait till you have new message i can only say thy all and wish u have luck and can finish that project thx thx

jw988 · 04/12/2011, 22:45

Really do any of you read my post about fixing char creation,
If you read back you can make the client make are char, also the
Problem is not the login, it the stored procedures after a char
Is made.

jw988 · 04/12/2011, 23:33

the authserver doent need connection to the telecaster database only the auth database, then the gameserver takes over and access the other databases

have this as your authserver.opt: (and it will still all connect)

Spoiler

the other info was for testing

also for info picture below:

jw988 · 04/13/2011, 06:26

backup database first then these will let you make char in client epic 6 (the one i posted) and get you to where i am working.

still cant get char list to show because of other bug

item

Spoiler

Character

Spoiler

list

Spoiler

and this is the error im getting now but atleast game server isnt crashing making char :P
(in picture) working this out atm but got to work till late

Link404 · 04/13/2011, 07:48

Quote:

Originally Posted by jw988

backup database first then these will let you make char in client epic 6 (the one i posted) and get you to where i am working.

still cant get char list to show because of other bug

item

Spoiler

USE [Telecaster]
GO
/****** Object: Table [dbo].[Item] Script Date: 04/13/2011 14:02:14 ******/
DROP Table [dbo].[Item]
GO
/****** Object: Table [dbo].[Item] Script Date: 04/13/2011 14:02:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

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

GO

GO

ALTER TABLE [dbo].[Item] ADD CONSTRAINT [DF_Item_elemental_effect_type] DEFAULT ((0)) FOR [elemental_effect_type]
GO

ALTER TABLE [dbo].[Item] ADD CONSTRAINT [DF_Item_elemental_effect_expire_time] DEFAULT ('2000-1-1') FOR [elemental_effect_expire_time]
GO

ALTER TABLE [dbo].[Item] ADD CONSTRAINT [DF_Item_elemental_effect_attack_point] DEFAULT ((0)) FOR [elemental_effect_attack_point]
GO

ALTER TABLE [dbo].[Item] ADD CONSTRAINT [DF_Item_elemental_effect_magic_point] DEFAULT ((0)) FOR [elemental_effect_magic_point]
GO

Character

Spoiler

USE [Telecaster]
GO
/****** Object: Table [dbo].[Character] Script Date: 04/02/2011 16:01:24 ******/
DROP Table [dbo].[Character]
GO
/****** Object: Table [dbo].[Character] Script Date: 04/13/2011 14:01:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Character](
[sid] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](61) NOT NULL,
[account] [varchar](60) NOT NULL,
[account_id] [int] NOT NULL,
[slot] [int] NOT NULL,
[x] [int] NOT NULL,
[y] [int] NOT NULL,
[z] [int] NOT NULL,
[layer] [int] NOT NULL,
[race] [int] NOT NULL,
[sex] [int] NOT NULL,
[exp] [bigint] NULL,
[last_decreased_exp] [bigint] NULL,
[lv] [int] NOT NULL,
[max_reached_level] [int] NOT NULL,
[hp] [int] NOT NULL,
[mp] [int] NOT NULL,
[stamina] [int] NOT NULL,
[havoc] [int] NOT NULL,
[jlv] [int] NOT NULL,
[jp] [int] NOT NULL,
[total_jp] [int] NOT NULL,
[job_0] [int] NOT NULL,
[job_1] [int] NOT NULL,
[job_2] [int] NOT NULL,
[jlv_0] [int] NOT NULL,
[jlv_1] [int] NOT NULL,
[jlv_2] [int] NOT NULL,
[immoral_point] [int] NOT NULL,
[cha] [int] NOT NULL,
[pkc] [int] NOT NULL,
[dkc] [int] NOT NULL,
[huntaholic_point] [int] NOT NULL,
[create_time] [datetime] NOT NULL,
[delete_time] [datetime] NOT NULL,
[login_time] [datetime] NOT NULL,
[logout_time] [datetime] NOT NULL,
[login_count] [int] NOT NULL,
[play_time] [int] NOT NULL,
[belt_00] [bigint] NOT NULL,
[belt_01] [bigint] NOT NULL,
[belt_02] [bigint] NOT NULL,
[belt_03] [bigint] NOT NULL,
[belt_04] [bigint] NOT NULL,
[belt_05] [bigint] NOT NULL,
[permission] [int] NOT NULL,
[skin_color] [int] NOT NULL,
[model_00] [int] NOT NULL,
[model_01] [int] NOT NULL,
[model_02] [int] NOT NULL,
[model_03] [int] NOT NULL,
[model_04] [int] NOT NULL,
[job] [int] NOT NULL,
[gold] [bigint] NOT NULL,
[party_id] [int] NOT NULL,
[guild_id] [int] NOT NULL,
[prev_guild_id] [int] NOT NULL,
[flag_list] [varchar](4000) NOT NULL,
[client_info] [varchar](2048) NOT NULL,
[job_depth] [int] NOT NULL,
[summon_0] [int] NOT NULL,
[summon_1] [int] NOT NULL,
[summon_2] [int] NOT NULL,
[summon_3] [int] NOT NULL,
[summon_4] [int] NOT NULL,
[summon_5] [int] NOT NULL,
[main_summon] [int] NOT NULL,
[sub_summon] [int] NOT NULL,
[remain_summon_time] [int] NOT NULL,
[pet] [int] NOT NULL,
[chaos] [int] NOT NULL,
[adv_chat_count] [int] NOT NULL,
[name_changed] [int] NOT NULL,
[auto_used] [int] NOT NULL,
[guild_block_time] [bigint] NOT NULL,
[pkmode] [tinyint] NOT NULL,
[otp_value] [int] NOT NULL,
[otp_date] [datetime] NOT NULL,
[chat_block_time] [int] NOT NULL,
CONSTRAINT [PK_IDX_Avatar] PRIMARY KEY NONCLUSTERED
(
[sid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED
(
[name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

list

Spoiler

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_read_character_list] Script Date: 04/13/2011 14:05:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- end of smp_insert_character

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

@IN_ACCOUNT_ID INT

AS
SET NOCOUNT ON

--SET ROWCOUNT 1
--WHILE 1=1
--BEGIN
-- UPDATE CHARACTER SET name = '@' + name + ' '+ SUBSTRING( CONVERT(varchar(40), GETDATE(), 21) , 3, 18 ) WHERE account_id = @IN_ACCOUNT_ID AND delete_time <= GETDATE() and name not like '@%';
-- IF @@ROWCOUNT = 0 BREAK
--END
--SET ROWCOUNT 0

SELECT sid,
name,
race,
sex,
lv,
jlv,
exp,
hp,
mp,
job,
permission,
skin_color,
model_00,
model_01,
model_02,
model_03,
model_04
FROM dbo.Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND name NOT LIKE '@%' ORDER BY sid;

RETURN @@ERROR

and this is the error im getting now but atleast game server isnt crashing making char :P
(in picture) working this out atm but got to work till late

You're missing the item columns in the character table. The server is trying to load the item assigned to your char, that's why this appears in the char screen.

jw988 · 04/13/2011, 08:32

but the item info is created under the item table not the char table when you make a char it adds the 3 default item into the item database for that char.
weapon, armor and bag

and the stored procedure smp_read_item_equip_info looks in the item table to but for some reason
doesnt see the data the char creation made

Link404 · 04/13/2011, 08:56

Well then, try to create an "empty" char without any items. Clear the item table and set the char's item value to 0.

khshe · 04/13/2011, 09:02

Quote:

Originally Posted by jw988

backup database first then these will let you make char in client epic 6 (the one i posted) and get you to where i am working.

still cant get char list to show because of other bug

item

Spoiler

USE [Telecaster]
GO
/****** Object: Table [dbo].[Item] Script Date: 04/13/2011 14:02:14 ******/
DROP Table [dbo].[Item]
GO

/****** Object: Table [dbo].[Item] Script Date: 04/13/2011 14:02:14 ******/
DROP Table [dbo].[Item]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Item](
[sid] [bigint] NULL,
[account_id] [int] NULL,
[owner_id] [int] NULL,
[summon_id] [int] NULL,
[auction_id] [int] NULL,
[keeping_id] [int] NULL,
[idx] [int] NULL,
[code] [int] NULL,
[flag] [int] NULL,
[cnt] [int] NULL,
[level] [int] NULL,
[enhance] [int] NULL,
[endurance] [int] NULL,
[gcode] [int] NULL,
[create_time] [datetime] NULL,
[wear_info] [int] NULL,
[socket_0] [int] NULL,
[socket_1] [int] NULL,
[socket_2] [int] NULL,
[socket_3] [int] NULL,
[remain_time] [int] NULL,
[update_time] [datetime] NULL,
[elemental_effect_type] [tinyint] NULL,
[elemental_effect_expire_time] [datetime] NULL,
[elemental_effect_attack_point] [int] NULL,
[elemental_effect_magic_point] [int] NULL,
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IDX_Item_Account_Id_Owner_Id_Auction_Id_Keeping_Id] ON [dbo].[Item]
(
[account_id] ASC,
[owner_id] ASC,
[auction_id] ASC,
[keeping_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

Character

Spoiler

USE [Telecaster]
GO
/****** Object: Table [dbo].[Character] Script Date: 04/02/2011 16:01:24 ******/
DROP Table [dbo].[Character]
GO
/****** Object: Table [dbo].[Character] Script Date: 04/13/2011 14:01:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Character](
[sid] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](61) NOT NULL,
[account] [varchar](60) NOT NULL,
[account_id] [int] NOT NULL,
[slot] [int] NOT NULL,
[x] [int] NOT NULL,
[y] [int] NOT NULL,
[z] [int] NOT NULL,
[layer] [int] NOT NULL,
[race] [int] NOT NULL,
[sex] [int] NOT NULL,
[exp] [bigint] NULL,
[last_decreased_exp] [bigint] NULL,
[lv] [int] NOT NULL,
[max_reached_level] [int] NOT NULL,
[hp] [int] NOT NULL,
[mp] [int] NOT NULL,
[stamina] [int] NOT NULL,
[havoc] [int] NOT NULL,
[jlv] [int] NOT NULL,
[jp] [int] NOT NULL,
[total_jp] [int] NOT NULL,
[job_0] [int] NOT NULL,
[job_1] [int] NOT NULL,
[job_2] [int] NOT NULL,
[jlv_0] [int] NOT NULL,
[jlv_1] [int] NOT NULL,
[jlv_2] [int] NOT NULL,
[immoral_point] [int] NOT NULL,
[cha] [int] NOT NULL,
[pkc] [int] NOT NULL,
[dkc] [int] NOT NULL,
[huntaholic_point] [int] NOT NULL,
[create_time] [datetime] NOT NULL,
[delete_time] [datetime] NOT NULL,
[login_time] [datetime] NOT NULL,
[logout_time] [datetime] NOT NULL,
[login_count] [int] NOT NULL,
[play_time] [int] NOT NULL,
[belt_00] [bigint] NOT NULL,
[belt_01] [bigint] NOT NULL,
[belt_02] [bigint] NOT NULL,
[belt_03] [bigint] NOT NULL,
[belt_04] [bigint] NOT NULL,
[belt_05] [bigint] NOT NULL,
[permission] [int] NOT NULL,
[skin_color] [int] NOT NULL,
[model_00] [int] NOT NULL,
[model_01] [int] NOT NULL,
[model_02] [int] NOT NULL,
[model_03] [int] NOT NULL,
[model_04] [int] NOT NULL,
[job] [int] NOT NULL,
[gold] [bigint] NOT NULL,
[party_id] [int] NOT NULL,
[guild_id] [int] NOT NULL,
[prev_guild_id] [int] NOT NULL,
[flag_list] [varchar](4000) NOT NULL,
[client_info] [varchar](2048) NOT NULL,
[job_depth] [int] NOT NULL,
[summon_0] [int] NOT NULL,
[summon_1] [int] NOT NULL,
[summon_2] [int] NOT NULL,
[summon_3] [int] NOT NULL,
[summon_4] [int] NOT NULL,
[summon_5] [int] NOT NULL,
[main_summon] [int] NOT NULL,
[sub_summon] [int] NOT NULL,
[remain_summon_time] [int] NOT NULL,
[pet] [int] NOT NULL,
[chaos] [int] NOT NULL,
[adv_chat_count] [int] NOT NULL,
[name_changed] [int] NOT NULL,
[auto_used] [int] NOT NULL,
[guild_block_time] [bigint] NOT NULL,
[pkmode] [tinyint] NOT NULL,
[otp_value] [int] NOT NULL,
[otp_date] [datetime] NOT NULL,
[chat_block_time] [int] NOT NULL,
CONSTRAINT [PK_IDX_Avatar] PRIMARY KEY NONCLUSTERED
(
[sid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED
(
[name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

list

Spoiler

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_read_character_list] Script Date: 04/13/2011 14:05:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- end of smp_insert_character

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

@IN_ACCOUNT_ID INT

AS
SET NOCOUNT ON

--SET ROWCOUNT 1
--WHILE 1=1
--BEGIN
-- UPDATE CHARACTER SET name = '@' + name + ' '+ SUBSTRING( CONVERT(varchar(40), GETDATE(), 21) , 3, 18 ) WHERE account_id = @IN_ACCOUNT_ID AND delete_time <= GETDATE() and name not like '@%';
-- IF @@ROWCOUNT = 0 BREAK
--END
--SET ROWCOUNT 0

SELECT sid,
name,
race,
sex,
lv,
jlv,
exp,
hp,
mp,
job,
permission,
skin_color,
model_00,
model_01,
model_02,
model_03,
model_04
FROM dbo.Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND name NOT LIKE '@%' ORDER BY sid;

RETURN @@ERROR

and this is the error im getting now but atleast game server isnt crashing making char :P
(in picture) working this out atm but got to work till late

It for what change?

khshe · 04/13/2011, 12:50

How advancement in server adjustment? I want to learn as it is possible to create the character on the server =)