Rappelz server files

[lilnani]

Originally Posted by 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:



And you set the md5 key just like below:


Then you have to get the md5 hash of:


The result is:

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.

how i can put this: 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[/spoiler]

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

[Muumiarmor]

Originally Posted by insaneblade87

copy it to desktop , reopen and paste what ya needed inside & recopy/paste the file over the one where it was located its what i do lol

Or you can change the security to Read&Write.

[nathanmuntz]

Originally Posted by jw988

Ok here is the data for the jobslevelbonus table, all info taken from the rappelz wiki website, as 5% of the data was missing parts had to be made up, but based on the class.

note this table only shows the jlv extra stats as the base stats are built into the server. btw only copy and paste the data from the white parts to the table.

use this to make the table to paste into:

 Spoiler

USE [Arcadia]
GO
/****** Object: Table [dbo].[JobLevelBonus] Script Date: 05/04/2011 00:08:00 ******/
DROP TABLE [dbo].[JobLevelBonus]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[JobLevelBonus](
[job_id] [int] NOT NULL,
[strength_0] [decimal](10, 3) NOT NULL,
[vital_0] [decimal](10, 3) NOT NULL,
[dexterity_0] [decimal](10, 3) NOT NULL,
[agility_0] [decimal](10, 3) NOT NULL,
[intelligence_0] [decimal](10, 3) NOT NULL,
[mentality_0] [decimal](10, 3) NOT NULL,
[luck_0] [decimal](10, 3) NOT NULL,
[strength_1] [decimal](10, 3) NOT NULL,
[vital_1] [decimal](10, 3) NOT NULL,
[dexterity_1] [decimal](10, 3) NOT NULL,
[agility_1] [decimal](10, 3) NOT NULL,
[intelligence_1] [decimal](10, 3) NOT NULL,
[mentality_1] [decimal](10, 3) NOT NULL,
[luck_1] [decimal](10, 3) NOT NULL,
[strength_2] [decimal](10, 3) NOT NULL,
[vital_2] [decimal](10, 3) NOT NULL,
[dexterity_2] [decimal](10, 3) NOT NULL,
[agility_2] [decimal](10, 3) NOT NULL,
[intelligence_2] [decimal](10, 3) NOT NULL,
[mentality_2] [decimal](10, 3) NOT NULL,
[luck_2] [decimal](10, 3) NOT NULL,
[strength_3] [decimal](10, 3) NOT NULL,
[vital_3] [decimal](10, 3) NOT NULL,
[dexterity_3] [decimal](10, 3) NOT NULL,
[agility_3] [decimal](10, 3) NOT NULL,
[intelligence_3] [decimal](10, 3) NOT NULL,
[mentality_3] [decimal](10, 3) NOT NULL,
[luck_3] [decimal](10, 3) NOT NULL
) ON [PRIMARY]
GO

just wanted to let u know still didnt fix the stat bugg after first job change

[nathanmuntz]

oh ok

[lilnani]

plz i have error when captinharlock connect to db

[lilnani]

i have this error any one can help plzzzzzzzzz


click the photo to get big size

[leduan]

das problem ist offensichtlich da steht es doch testet nach ob euer sql server aktive ist, ich habe es noch nicht geschaft denn server zu machen da ich probleme hab mit der software aber wieso testet ihr nicht ob ihr mit navicat sehen könnt ob euer server on ist halt mit localhost connecten (127.0.0.1)

[RoflcopterGoesSoiSoiSoi]

So what's up with the monster spawns?

(PS: Anyone have the Item ID# of E-Angel/E-Kenta? Too lazy to scrounge around DB...)

[khshe]

pets are placed in the forms. beings?

[lilnani]

RoflcopterGoesSoiSoiSoi

can u help me with this error

[djqstyle]

so now my problem i need to restor the .bak from pyrok why my acount cretion not work so the problem is SQL Server 2008 Expresse with tools say the restor is from server version 10.50.1600 and i use 10.00.1600 any have idea how can i fix that i need to use tha .bak from pyrok ^^

[tiger_td]

Originally Posted by lilnani

RoflcopterGoesSoiSoiSoi

can u help me with this error

c:\windows\system32\drivers\etc\host
open edit

add
127.0.0.1 localhost
127.0.0.1 cadb.nflavor.com

[katalin21k]

stop fk double posting and read the error... u need r2 to restore db. i posted there link to download and stop spaming and READ!!!

[Muumiarmor]

Originally Posted by tiger_td

c:\windows\system32\drivers\etc\host
open edit

add
127.0.0.1 localhost
127.0.0.1 cadb.nflavor.com

Didn't work for me.

[kaizoku801]

All questions regarding how to setup the server/get it to working, post on the " Post that come here are only progress / fixes