Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 03:33

  • Please register to post and access all features, it's quick, easy and FREE!

 

Rappelz server files

Closed Thread
 
Old   #541
 
elite*gold: 0
Join Date: Feb 2011
Posts: 496
Received Thanks: 107
Quote:
Originally Posted by Link404 View Post
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:

Account procedure:

Commands to send to the game server:

Commands to send to the auth server:

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



lilnani is offline  
Old   #542
 
elite*gold: 0
Join Date: Jan 2008
Posts: 121
Received Thanks: 24
Quote:
Originally Posted by insaneblade87 View Post
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.


Muumiarmor is offline  
Old   #543
 
elite*gold: 0
Join Date: Dec 2009
Posts: 33
Received Thanks: 4
Quote:
Originally Posted by jw988 View Post
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:
just wanted to let u know still didnt fix the stat bugg after first job change
nathanmuntz is offline  
Old   #544
 
elite*gold: 0
Join Date: Dec 2009
Posts: 33
Received Thanks: 4
oh ok


nathanmuntz is offline  
Old   #545
 
elite*gold: 0
Join Date: Feb 2011
Posts: 496
Received Thanks: 107
plz i have error when captinharlock connect to db
lilnani is offline  
Old   #546
 
elite*gold: 0
Join Date: Feb 2011
Posts: 496
Received Thanks: 107
i have this error any one can help plzzzzzzzzz


click the photo to get big size
lilnani is offline  
Old   #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)
leduan is offline  
Old   #548
 
elite*gold: 0
Join Date: Dec 2010
Posts: 664
Received Thanks: 189
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...)
RoflcopterGoesSoiSoiSoi is offline  
Old   #549
 
elite*gold: 0
Join Date: Oct 2010
Posts: 147
Received Thanks: 2
pets are placed in the forms. beings?
khshe is offline  
Old   #550
 
elite*gold: 0
Join Date: Feb 2011
Posts: 496
Received Thanks: 107
RoflcopterGoesSoiSoiSoi

can u help me with this error

lilnani is offline  
Old   #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 ^^
djqstyle is offline  
Old   #552
 
elite*gold: 0
Join Date: May 2009
Posts: 4
Received Thanks: 0
host file

Quote:
Originally Posted by lilnani View Post
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
tiger_td is offline  
Old   #553
 
elite*gold: 0
Join Date: Apr 2011
Posts: 232
Received Thanks: 69
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!!!
katalin21k is offline  
Thanks
2 Users
Old   #554
 
elite*gold: 0
Join Date: Jan 2008
Posts: 121
Received Thanks: 24
Quote:
Originally Posted by tiger_td View Post
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.
Muumiarmor is offline  
Old   #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


kaizoku801 is offline  
Closed Thread



« Previous Thread | Next Thread »

Similar Threads
Rappelz Server-Files
Hy, Here the Server-Files From Rappelz. The Files are From Gpotato and the Language is german. This Downloads has all Information witch i...
10 Replies - Rappelz
Is there anyone there has the Rappelz server files?
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...
4 Replies - Rappelz



All times are GMT +2. The time now is 03:33.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.