Rappelz server files

05/06/2011 01:43 XavierDeFawks#451
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.
05/06/2011 01:50 wisp66#452
Quote:
Originally Posted by cannon0011 View Post
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

Quote:
Originally Posted by axmadz View Post
hi look here (SQL SERVER 2008 R2 datacenter edition) prumiem edition :D

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

or torrent

[Only registered and activated users can see links. Click Here To Register...]
while we appriecate u help plz becareful posting stuff like this before people start bitching o.0:rolleyes:
Quote:
Originally Posted by xXExiledXx View Post
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
05/06/2011 02:17 XavierDeFawks#453
item ids r in the itemresource table
05/06/2011 03:55 wisp66#454
Quote:
Originally Posted by xXExiledXx View Post
item ids r in the itemresource table
i thought so i must have over looked it yep i did god its been along day
Quote:
Originally Posted by axmadz View Post
loooooooool hack in rappelz arabic bug sql look

[Only registered and activated users can see links. Click Here To Register...]
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
05/06/2011 05:39 XavierDeFawks#455
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


Code:
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
05/06/2011 06:21 darkside4125#456
demon is there a dev website/forums, ive playied since epic 1 beta korean, and can help with programing/db/ingame information
05/06/2011 07:02 XavierDeFawks#457
Wow nice O.O.
If u don't mind me asking though how will you playing longer help you understand the servers better??
05/06/2011 07:04 wisp66#458
Quote:
Originally Posted by xXExiledXx View Post
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
Quote:
Originally Posted by tiger_td View Post
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
05/06/2011 07:07 XavierDeFawks#459
There is one problem with that :P
Most db entrys are stored in rdb files inside the data.00x files :P
05/06/2011 07:19 darkside4125#460
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
05/06/2011 07:33 jw988#461
Quote:
Originally Posted by darkside4125 View Post
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.
05/06/2011 07:42 XavierDeFawks#462
I think this is how the AllowedCommandsForPermission table should go. I found the colum names in the CaptianHerlockServer.pdb

Code:
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
05/06/2011 11:17 khshe#463
Quote:
Originally Posted by jw988 View Post
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
05/06/2011 13:03 RoflcopterGoesSoiSoiSoi#464
Use unsigned columns - they won't go below zero. Instead, the positive range will double.
05/06/2011 14:41 khshe#465
Quote:
Originally Posted by jw988 View Post
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