|
You last visited: Today at 18:52
Advertisement
Rappelz server files
Discussion on Rappelz server files within the Rappelz Private Server forum part of the Rappelz category.
05/07/2011, 12:52
|
#541
|
elite*gold: 0
Join Date: Feb 2011
Posts: 597
Received Thanks: 174
|
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:
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:
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:
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:
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:
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:
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
|
#542
|
elite*gold: 0
Join Date: Jan 2008
Posts: 122
Received Thanks: 24
|
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
|
#543
|
elite*gold: 0
Join Date: Dec 2009
Posts: 33
Received Thanks: 4
|
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:
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
|
#544
|
elite*gold: 0
Join Date: Dec 2009
Posts: 33
Received Thanks: 4
|
oh ok
|
|
|
05/07/2011, 14:24
|
#545
|
elite*gold: 0
Join Date: Feb 2011
Posts: 597
Received Thanks: 174
|
plz i have error when captinharlock connect to db
|
|
|
05/07/2011, 14:47
|
#546
|
elite*gold: 0
Join Date: Feb 2011
Posts: 597
Received Thanks: 174
|
i have this error any one can help plzzzzzzzzz
click the photo to get big size
|
|
|
05/07/2011, 15:02
|
#547
|
elite*gold: 0
Join Date: Aug 2008
Posts: 358
Received Thanks: 34
|
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
|
#548
|
elite*gold: 0
Join Date: Dec 2010
Posts: 663
Received Thanks: 191
|
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
|
#549
|
elite*gold: 0
Join Date: Oct 2010
Posts: 205
Received Thanks: 8
|
pets are placed in the forms. beings?
|
|
|
05/07/2011, 15:18
|
#550
|
elite*gold: 0
Join Date: Feb 2011
Posts: 597
Received Thanks: 174
|
RoflcopterGoesSoiSoiSoi
can u help me with this error
|
|
|
05/07/2011, 15:43
|
#551
|
elite*gold: 0
Join Date: Sep 2010
Posts: 9
Received Thanks: 1
|
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
|
#552
|
elite*gold: 0
Join Date: May 2009
Posts: 4
Received Thanks: 0
|
host file
Quote:
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
|
|
|
05/07/2011, 15:45
|
#553
|
elite*gold: 0
Join Date: Apr 2011
Posts: 232
Received Thanks: 70
|
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
|
#554
|
elite*gold: 0
Join Date: Jan 2008
Posts: 122
Received Thanks: 24
|
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
|
#555
|
elite*gold: 0
Join Date: May 2008
Posts: 339
Received Thanks: 69
|
All questions regarding how to setup the server/get it to working, post on the " Post that come here are only progress / fixes
|
|
|
Similar Threads
|
Rappelz Server-Files
02/17/2012 - Rappelz - 10 Replies
Hy,
Here the Server-Files From Rappelz.
The Files are From Gpotato
and the Language is german.
This Downloads has all Information
witch i have .
I can't give support for this Files .
Thanks For Understanding
And
|
Is there anyone there has the Rappelz server files?
04/08/2011 - Rappelz - 4 Replies
Is there anyone there has the Rappelz server files?
I just wanna know becouse I relly need them..
If nobody have them cant we just "grab" the data? we got the ip's?
|
All times are GMT +2. The time now is 18:52.
|
|