Rappelz server files

[Gangxtar1]

^^
mach mal kein doublepost^^
ich weiß der thread is geil aba doublepost muss ned sein^^
sonst klar, wenns bei mir läuft versuch ich anderen zu helfen.
habs bei aion auch gemacht^^
in dem thread für aion-p-server kannste ja mal gucken^^
hab ich auch voll vielen geholfen.
nur kann ichs erst wenn ich selber nen server am laufen hab^^

[DragonMaxBR]

pyrok , your new Captain works great with 6.2

question :
its possible for a regular client like 6.2 to execute GM commands like #@kill_target@# or #@insert_item@#.

[Link404]

Just wanted to report back. Works like a charm, thanks a lot pyrok!
I just fixed demonroro's login so it works with md5 hashes.

Account table:

 Spoiler

USE [Auth]
GO

/****** Object: Table [dbo].[Accounts] Script Date: 05/02/2011 23:19:11 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Accounts]') AND type in (N'U'))
DROP TABLE [dbo].[Accounts]
GO

USE [Auth]
GO

/****** Object: Table [dbo].[Accounts] Script Date: 05/02/2011 23:19:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Accounts](
[account_id] [int] IDENTITY(1,1) NOT NULL,
[login_name] [nvarchar](31) NULL,
[password] [nvarchar](32) NULL,
[block] [int] NULL,
[withdraw_remain_time] [int] NULL,
[age] [int] NULL,
[auth_ok] [int] NULL,
[pcbang] [int] NULL,
[last_login_server_idx] [int] NULL,
[event_code] [int] NULL,
[server_list_mask] [nvarchar](31) NULL,
[result] [int] NULL,
[ip] [int] NULL,
[game_code] [nvarchar](50) NULL,
[gamecode] [varchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[account_id] 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

Account procedure:

 Spoiler

USE [Auth]
GO

/****** Object: StoredProcedure [dbo].[smp_account] Script Date: 05/02/2011 23:20:01 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[smp_account]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[smp_account]
GO

USE [Auth]
GO

/****** Object: StoredProcedure [dbo].[smp_account] Script Date: 05/02/2011 23:20:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- start of smp_insert_character
CREATE PROCEDURE [dbo].[smp_account]
@IN_ACCOUNT nvarchar(31),
@IN_GAMECODE nvarchar(50),
@IN_PASSWORD nvarchar(32)
AS
SET NOCOUNT ON

--IF NOT EXISTS ( SELECT * FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT )
-- INSERT dbo.Accounts( login_name,ip,password ) VALUES( @IN_ACCOUNT,0,@IN_ACCOUNT )

SELECT * FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT --AND password = @IN_PASSWORD
SELECT * FROM dbo.Accounts WHERE password = @IN_PASSWORD

RETURN @@ERROR

GO

Commands to send to the game server:

 Spoiler

set game.use_login_logout_debug 1
set io.port 4514
set io.ip_address 127.0.0.1
set server_name RappelZ
set auth.server_name RappelZ

Commands to send to the auth server:

 Spoiler

start_service
set db.auth.use_md5 1
set db.auth.md5_key rappelz
set db.auth.debug_md5 1
set game.open_external 1

At the end, send the following command to the game server:

 Spoiler

connect auth

You can use any MD5 hash generator to generate your password. I personally prefer one.
For example, if you want to log in with the following credentials:

Name: Link404
Password: ZomG.MD5

And you set the md5 key just like below:

set db.auth.md5_key rappelz

Then you have to get the md5 hash of:

rappelzZomG.MD5

The result is:

aa1dfb7ce49f5131ee5a2dfb073d20cb

In your account table, you insert this md5 hash as your password.

Means, the syntax is:

[B]md5key[/B][U]+password[/U]

Let's start fixing the bugs now.

[jw988]

heres the full data for the LevelResource table delete what is in table then paste this, all 170 levels and the jlv data. if anyone needs

Update: reuploaded with correct table info this time lol

[XavierDeFawks]

hmm I noticed something interesting when i was playing around with the server. In the JobResource db theres a job id 324 when i changed my chars job id to it my class was necromancer. So heres a theory the gms r IN FACT working on 3rd job (or maybe those r for master job) but the r incomplete cuz i got a error saying it could not find skill tree :O

[nathanmuntz]

any idea why no one can connect to my server they can get to the server select page but it say server to busy

[XavierDeFawks]

Weird O.o. Did u restore the dbs correctly?? Cuz i was able to connect just fine.

Can someone tell me how i am able to set myself as a gm so i can use the gm commands??

[Pyrok]

DragonMaxBR - No clue about GM commands, I haven't tried.

jw988 - I could be wrong but I think the levels need to cumulative, not the exp for that single level. I haven't gone higher than 20 so far so I can't say for sure.

Link404 - Nice work on the md5 stuff

xXExiledXx - Yep, there's 3rd jobs in there but no skills, or at least no skill tree. I didn't go through the actual skills to check that out more.

nathanmuntz - hard to say, my best guess is that you aren't setting a port on the game server but without more info...

Quick update... I know why the stats aren't working correctly, just trying to figure out the table for it. It's JobLevelBonus and has a very strange layout from what I can tell.

[jw988]

Originally Posted by Pyrok

jw988 - I could be wrong but I think the levels need to cumulative, not the exp for that single level. I haven't gone higher than 20 so far so I can't say for sure.

Yeah lol the first upload was wrong i reuploaded with the cumulative data to 170 from rappelz wiki

[Link404]

To become a gamemaster, you have to set the permissions of the single character through the character table. There's a column called "permission", set the value 1 in it and you're game master.

From what I've figured out until now, I can tell you that the syntax for the commands is the following:

#@command@#

But it's a little bit strange, the only "working" command we (demonroro and me) could find was the "!" command, which is totally different than the command above. With "!yourtexthere" you can send gamemaster-messages. So far, so good. But the gm commands seem not to work at the moment, and I guess, it has to do with the table "AllowedCommandsForPermission".

However, I'll report back if we get the solution, of course.

[nathanmuntz]

so what ports all need to be open? i do have most of the most open like i said i can connect from a different pc on my network but no one esle can connect

[khshe]

There's not all mobs, horizontal and Lax I just empty, more mobs, and there is no way this is probably the saga in May as there trail after a short time rose as it was in the saga of five

[khshe]

Another question? how to use the shop?

[nathanmuntz]

kk

[manlive]

someone open server beta .. we play there and we tell u all bugs on this server

this best way for fix bugs

(sry 4 my English)