Rappelz server files

[XavierDeFawks]

can some1 please tell me how to add creature cards to my inventory it seems to be different then adding regular items and i cant find out how ot do it.

[wisp66]

Originally Posted by cannon0011

link404 salt is actually used to make md5 passwords, for example goto a md5 generator and put in salt<password>, that being saltpassword, they did this method for one of the other private servers around just cant recall which one sorry

flyff does it in that case the salt was kikugalanet or serus depending on the version u had

Originally Posted by axmadz

hi look here (SQL SERVER 2008 R2 datacenter edition) prumiem edition



or torrent

while we appriecate u help plz becareful posting stuff like this before people start bitching o.0

Originally Posted by xXExiledXx

can some1 please tell me how to add creature cards to my inventory it seems to be different then adding regular items and i cant find out how ot do it.

very good question i still havent found a complete listing for item or petcard id's

[XavierDeFawks]

item ids r in the itemresource table

[wisp66]

Originally Posted by xXExiledXx

item ids r in the itemresource table

i thought so i must have over looked it yep i did *** its been along day

Originally Posted by axmadz

loooooooool hack in rappelz arabic bug sql look

thats not a bug or a hack thats a break line it just means there site needs to be reset it hiccuped
its kinda like error 404 which means page missing in this case part of the site graphics is missing

[XavierDeFawks]

Who ever created the rl.php and said it was a complete hack well its not really a hack cuz the official rappelz uses something simial

S db.auth.server:84.203.140.22
S db.auth.name:Auth
S db.auth.account:rappelz_auth
S db.auth._password:3cd89d51701b5a9adcd1b29ca76b6c63
S app.name:auth
S log.ip:84.203.140.22
S db.auth.port:1433
N auth.version:200701120
N auth.max_client_per_ip:30000
N db.auth.use_webauth:1
S db.auth.gamecode:MODE=L&GAMECODE=G004&GPOTATOID=%UID&PASSWORD=%PASS&USERIP=%IP
S db.auth.webserver:spe.gpotato.eu
S db.auth.weburl:/Account/Authentication.Aspx
N db.auth.webtimeout:10000000
N game.user_limit:3500
N auth.max_daily_client_per_ip:30

found this in the .opt file released with the incomplete PrincessAurora source that was released a while back

[darkside4125]

demon is there a dev website/forums, ive playied since epic 1 beta korean, and can help with programing/db/ingame information

[XavierDeFawks]

Wow nice O.O.
If u don't mind me asking though how will you playing longer help you understand the servers better??

[wisp66]

Originally Posted by xXExiledXx

Wow nice O.O.
If u don't mind me asking though how will you playing longer help you understand the servers better??

i wondered same thing
and btw

Originally Posted by tiger_td

database prosedure or client(sframe.exe unpacked ) error? Aof rappelz used.
fail...
How to fix
thanks.

u cant use this sframe to login its unpacked meaning u can uncompile
using ida and find more db entrys,break points etc this is more for the dev side then actual login methods.
to use it to login u would need to repack it
but then its no diffrent then the aor client u already have

[XavierDeFawks]

There is one problem with that :P
Most db entrys are stored in rdb files inside the data.00x files :P

[darkside4125]

playing longer means i know alot more about how the game works, and alot more about database stuff that may be missing, that alot of people didnt know such as items/bug fixes to stuff

[jw988]

Originally Posted by darkside4125

playing longer means i know alot more about how the game works, and alot more about database stuff that may be missing, that alot of people didnt know such as items/bug fixes to stuff

if you can help follow the thread and make your own local server and start looking for bugs.


btw for anyone that wants there empty pet card tamed find it in items table and add this as flag -2147483648.

you dont need the web auth anymore as its been worked out how to log in the right way.

[XavierDeFawks]

I think this is how the AllowedCommandsForPermission table should go. I found the colum names in the CaptianHerlockServer.pdb

USE [Telecaster]
GO

/****** Object:  Table [dbo].[AllowedCommandsForPermission]    Script Date: 05/06/2011 00:34:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AllowedCommandsForPermission]') AND type in (N'U'))
DROP TABLE [dbo].[AllowedCommandsForPermission]
GO

USE [Telecaster]
GO

/****** Object:  Table [dbo].[AllowedCommandsForPermission]    Script Date: 05/06/2011 00:34:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AllowedCommandsForPermission](
	[sid] [int] NULL,
	[permission] [int] NULL,
	[command] [int] NULL,
	[parameter] [int] NULL
) ON [PRIMARY]

GO

[khshe]

Originally Posted by jw988

Here is some data to get pet names to work like real server, i added these strings, as the names are in the database but in Korean, so these ones are in English.

delete whats in StringLocalResource and SummonDefaultNameResource tables and paste the info in the spreadsheet.

the code field is high (190001000+) so it doesnt conflict with other strings

please let me copy backup a database

[RoflcopterGoesSoiSoiSoi]

Use unsigned columns - they won't go below zero. Instead, the positive range will double.

[khshe]

Originally Posted by jw988

Here is some data to get pet names to work like real server, i added these strings, as the names are in the database but in Korean, so these ones are in English.

delete whats in StringLocalResource and SummonDefaultNameResource tables and paste the info in the spreadsheet.

the code field is high (190001000+) so it doesnt conflict with other strings

how to add it? Please make a sql file