Great Work!!!! Keep it Up!!!!

[Skamorzo]

I am trying to code a php5 decode/encode functions to get a readable
filename from the Resource folder and other stuff like the item_shop's $_GET['id'] field coming from the client (as in the previous post).

16EE69E8CEFAEEC68BC69FC027F593DA697554C8

Can someone tell me what the above hash looks like once decoded?

Regards,
Ska...

[Skamorzo]

Back from holidays.
And back to the decoding stuff... be back soon...

Have a nice day,
Skamorzo.

[Skamorzo]

Still stucked with the 16EE69E8CEFAEEC68BC69FC027F593DA697554C8 string encoding.

Uhm...
Have a nice day,
Skamorzo.

[Skamorzo]

Just want to thank all the ppl for the latest rappelz 7.4 private server, release.

And an update on what I am doing...

1. playing with jQuery;
2. Suceeded in Logging-in using the Auth Database;
3. Trying to give a better look to all the Tables;
4. Wanna code a 'Rappelz Private Server Studio'.

For point 4, this WEB UI will show/edit/repack everything needed to the game client.

By the way I am still stucked in the string encoding... ;-)

Regards,
Skamorzo.

[ismokedrow]

Skamorzo, finally someone else who codes on the SQLSRV api, it's so useful, I am building a tool called rACP it's mostly done already but could use some outside idea's and finishing touchups, if you're interested just contact me on Skype. I'm also working with a friend creating a Rappelz Integrated Social Site (Like a Facebook based on a Rappelz Server) coded from scratch. Hit me up.

[Skamorzo]

Good to read from you ismokedrow...

Sure I will contact you later in the evening (my time, it should be afternoon your time) once at home.

Have a nice day,
Skamorzo.

[Skamorzo]

My web interface to Rappelz is growing fast:

What is really nice with sqlsrv php extention is the possibility to use Stored Procedure (I will let you do your consideations)...

In these days I did:

1. Take a jQuery tour;
2. Take a jQueryui tour;
3. Take a jEditable tour;
4. Take a jDatagrid tour.

Now think what you can do by merging Stored Procedure + jQuery (Drad & Drop) + jEditable + Rappelz DBs using Php...

Attached a closer look at the login page...

Regards,
Skamorzo...

[Skamorzo]

PS. The page plays the music from the dumped client.

(I will never stop to thank who have developed the Resource Dumper)... Thank you soo much!

[glandu2]

a new client made in php soon ?
AH/inventory viewing should be possible, as using rappelz chat, all in web page

[gr4ph0s]

That already exist I don't know if i can find it but i know ncarbon have developped an CMS for manage Rappelz but it is never released and i don't know if i have it on my pc or if i delete it ^^'

[Skamorzo]

To Gr4ph0s: it would be very cool if I can gain access to my Warehouse and do staff like placing item in the Auction House; as well as do some Item Enchantments and so on... by accessing a Web Page instead of loggin into the game. This will let me play even on my spear time.

:-)

Ok I think I have all the knowledge I need for now... (except the unpack/decode + pack/encode for the .dat files).

This how i will proceed with my experimentation:

1. Read the .rdb files and populate right db table.
For now I have discovered (I hope) the db_string(ascii).rdb structure:

/* Done with structorian */
filemask="db_string(ascii).rdb"]

struct HEADER {
str [len=128, id=date] "date";
u32 [id=records] "records";
child ENTRY;
}

struct ENTRY {
u32 group_id;
u32 code;
cstr [id=name_id] "name_id";
cstr [id=value] "value";
u32 [id="data_1"] data_1;
u32 [id="data_2"] data_2;
u32 [id="data_3"] data_3;
u32 [id="data_4"] data_4;
u32 [id="data_5"] data_5;
u32 [id="data_6"] data_6;
if (CurOffset < FileSize) {
sibling;
}
}

I am playing with php to create a sort of Bynary File Read/Write class... in order to get these data in a better way.

Because this is the php code I am using:

/* Author: Skamorzo */
/* To: ElitePVPers - Rappelz Private Server Teams */
/* This is for educational use, all the trademarks and copyrights belong to the respective owners */

<?php
$handle = fopen("db_string(ascii).rdb", "rb");
$contents = '';
if (!feof($handle)) {
$contents = fread($handle, 128);
echo "/* Data :". unpack("a128date", $contents)['date']. " */\n";
}
if (!feof($handle)) {
$contents = fread($handle, 4);
echo "/* Records :". unpack("Irecords", $contents)['records']. " */\n";
}
while(!feof($handle)) {
$contents = fread($handle, 4);
echo unpack("Icode", $contents)['code']. "|";
$contents = fread($handle, 4);
echo unpack("Igroup_id", $contents)['group_id']. "|";
$string = "";
while(unpack("cname_id", $char = fread($handle, 1))['name_id'] != "\0") {
$string .= $char;
}
echo "\"". $string. "\"|";
$string = "";
while(unpack("cvalue", $char = fread($handle, 1))['value'] != "\0") {
$string .= $char;
}
echo "\"". $string. "\"|";
$contents = fread($handle, 4);
echo unpack("Idato_1", $contents)['dato_1']. "|";
$contents = fread($handle, 4);
echo unpack("Idato_2", $contents)['dato_2']. "|";
$contents = fread($handle, 4);
echo unpack("Idato_3", $contents)['dato_3']. "|";
$contents = fread($handle, 4);
echo unpack("Idato_4", $contents)['dato_4']. "|";
$contents = fread($handle, 4);
echo unpack("Idato_5", $contents)['dato_5']. "|";
$contents = fread($handle, 4);
echo unpack("Idato_6", $contents)['dato_6']. "\n";
}
fclose($handle);
?>

Stay tuned...
Skamorzo.

PS. This structure is related to a 6.2 game client db_string(ascii).rdb file.

[c1ph3r]

Originally Posted by Skamorzo

To Gr4ph0s: it would be very cool if I can gain access to my Warehouse and do staff like placing item in the Auction House; as well as do some Item Enchantments and so on... by accessing a Web Page instead of loggin into the game. This will let me play even on my spear time.

:-)
...blablabla...

hmmm...you want to create a tool that is possible to edit ingame items,charactes etc via a Web Page...

Do you mean something like this:



Don't get me wrong i'm with everyone who is trying to create something on his own but i think it's better to create something new instead of rebuilding present things.

[Skamorzo]

To c1ph3r: I am trying to gain as much knowledge as I can. I have started late in playing with this files, compared to you all. That's the main reason why I am re-inventing the wheel.

I was not aware of this tool, btw. Cool!!!! :-)

Is the structure I found the right one for db_string(ascii).rdb ?

Regards,
Ska...

[c1ph3r]

No there are two counts at the beginning of each record. First two int32 are bytecnt name and value.

[Skamorzo]

Wow nice hint... thanks a lot c1ph3r.

Have a nice day,
Skamorzo...

 Spoiler

/* Done with structorian */
[filemask="db_string(ascii).rdb"]

struct HEADER {
str [len=128] date;
u32 records;
child ENTRY;
}

struct ENTRY {
u32 [id="cnt_name_id"] cnt_name_id;
u32 [id="cnt_value"] cnt_value;
str [len=cnt_name_id] name_id;
str [len=cnt_value] value;
u32 code;
u32 group_id;
u32 unknown_1;
u32 unknown_2;
u32 unknown_3;
u32 unknown_4;
if (CurOffset < FileSize) {
sibling;
}
}