Rappelz server files

Page 37 of 154

05/07/2011 12:52 lilnani#541

Quote:
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 [Only registered and activated users can see links. Click Here To Register...] 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:
Code:
[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

05/07/2011 13:44 Muumiarmor#542

Quote:

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.

05/07/2011 14:11 nathanmuntz#543

Quote:

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

05/07/2011 14:22 nathanmuntz#544

oh ok

05/07/2011 14:24 lilnani#545

plz i have error when captinharlock connect to db

05/07/2011 14:47 lilnani#546

i have this error any one can help plzzzzzzzzz
[Only registered and activated users can see links. Click Here To Register...]

click the photo to get big size

05/07/2011 15:02 leduan#547

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) :)

05/07/2011 15:14 RoflcopterGoesSoiSoiSoi#548

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...)

05/07/2011 15:17 khshe#549

pets are placed in the forms. beings?

05/07/2011 15:18 lilnani#550

RoflcopterGoesSoiSoiSoi

can u help me with this error

[Only registered and activated users can see links. Click Here To Register...]

05/07/2011 15:43 djqstyle#551

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 ^^

05/07/2011 15:45 tiger_td#552

Quote:

Originally Posted by lilnani

RoflcopterGoesSoiSoiSoi

can u help me with this error

[Only registered and activated users can see links. Click Here To Register...]

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

add
127.0.0.1 localhost
127.0.0.1 cadb.nflavor.com

05/07/2011 15:45 katalin21k#553

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!!!

05/07/2011 15:56 Muumiarmor#554

Quote:

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.

05/07/2011 16:09 kaizoku801#555

All questions regarding how to setup the server/get it to working, post on the "[Only registered and activated users can see links. Click Here To Register...] Post that come here are only progress / fixes

Page 37 of 154

« First

137

Last »