Rappelz server files

[khshe]

A créé la base de données, a lancé le jeu et auth le serveur tout que faut a introduit même files "rl" a ajouté au classeur "D:\movamp\mnt\var\www \"

Mais comment créer accounts ? M'expliquez ou nous contacterons par TeamViewer et montrerez[hr]
Voici comme je fais

[Gangxtar1]

my auth server works normally.
i tried to start the auth server, then start gameserver and use the command CONNECT AUTH.
gameserver could not connect to DB but to my authserver, BUT with the ip 192.168.0.84

why this IP?
how can i change it?
maybe this is the problem that the gamserver cant connect to my db?

[nam0]

Originally Posted by Gangxtar1

my auth server works normally.
i tried to start the auth server, then start gameserver and use the command CONNECT AUTH.
gameserver could not connect to DB but to my authserver, BUT with the ip 192.168.0.84

why this IP?
how can i change it?
maybe this is the problem that the gamserver cant connect to my db?

Demonroro found a solution to allow any ip to connect to the server. PM him!

[kamdil15]

Uploaded with


why i get this error and why is the ip not 127.0.0.1 :S:S
my gameserver opt

 Spoiler

S app.name:game001
S auth.server_idx:1
S auth.server_name:Testserver
T game.exp_rate:20
T exp_rate:20
N Game_exp_rate:20

my authserver opt

 Spoiler

S db.auth.connection_string:Provider=sqloledb;Persis t Security Info=True;Initial Catalog=Telecaster;Data Source=KAMILKORKMAZ-PC\SQLEXPRESS;User id=sa;Password=
S db.c.connection_string:Provider=sqloledb;Persist Security Info=True;Initial Catalog=Telecaster;Data Source=KAMILKORKMAZ-PC\SQLEXPRESS;User id=sa;Password=
S db.user.connection_string:Provider=sqloledb;Persis t Security Info=True;Initial Catalog=Telecaster;Data Source=KAMILKORKMAZ-PC\SQLEXPRESS;User id=sa;Password=
S game_server.connection_string:Provider=sqloledb;Pe rsist Security Info=True;Initial Catalog=Telecaster;Data Source=KAMILKORKMAZ-PC\SQLEXPRESS;User id=sa;Password=
S db.auth.name:Auth
S db.auth.server:127.0.0.1
S db.auth.thread:4
S db.auth.account:sa
S db.auth._password:
S console.port:4502
N auth.version:200701120
S db.c._password:
S db.c.account:sa
S db.c.name: Arcadia
S db.c.server:127.0.0.1
S db.user.name:Arcadia
S db.user.server:127.0.0.1
S db.user.account:sa
S db.user.thread:4
S db.user._password:
S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.c.account:sa
S db.c._password:
S game_server.addr:127.0.0.1
S game_server.port:4502
S io.game_server.addr:127.0.0.1
S io.game_server.port:4502
N db.auth.use_webauth:1
S db.auth.gamecode:10
S db.auth.webserver:192.168.1.5
S db.auth.weburl:rl.php?id=%UID&p=%PASS&ip=%IP
S db.auth.webreferer:biteme
S db.auth.webtimeout:500

[Link404]

Figured out that you can set the md5 hash by yourself...
Send the following command to the auth server:

set db.auth.md5_key YOURSALTHERE

Example:

set db.auth.md5_key OMGrappelz

Then you generate the md5 hash code for your password like this:
OMGrappelzmypassword

So you could log in with "mypassword"

Before you can use this, you have to add manually a new column to the table "Account" found in database "Auth". I used nchar(50) as type for this column. In this column, you can input your md5 hash code.

However, I'm pretty sure, there's also a command for allowing character creation.

[jw988]

If you remove the rows from char table, GUILD_SID
Down you can make a char withe the client i posted
But the stored procedures are playing up after that
And will just crash game server. Smp.read_character_list
Is one of them.

The epic 6 part 2 client is not compatible with these files

[Link404]

Originally Posted by jw988

If you remove the rows from char table, GUILD_SID
Down you can make a char withe the client i posted
But the stored procedures are playing up after that
And will just crash game server. Smp.read_character_list
Is one of them.

The epic 6 part 2 client is not compatible with these files

There must be an easier way..

[aviate22]

what about e6 p1 client i posted?

[jw988]

The rows are no longer used by the epic 6 client so they are
Stoping the char creation so they have to be removed.
There is only about 6 rows to remove it's easy, the ones in
Capitals down the bottom.

if you cant do it, delete the dbo.character and then run this:

 Spoiler

USE [Telecaster]
GO

/****** Object: Table [dbo].[Character] Script Date: 04/12/2011 07:23:08 ******/
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

The stored procedure to make char changed in later parts
Of epic 6 that's why those clients don't work.

[nam0]

Hy all,
Make Forum for dev Rappelz is online all welcome


English, Deutsch and French language... Serverfiles, launcher...

[Link404]

We get more and more to the finishing line which is our goal...
DB COM ERROR: smp_web_nflavor_accept missing

Does anyone have this?

[leduan]

good job

[khshe]

At me too most why it is impossible to create the character?

[khshe]

hjsplit

[khshe]