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

07/26/2012 14:24 Skamorzo#31
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).

Code:
16EE69E8CEFAEEC68BC69FC027F593DA697554C8
Can someone tell me what the above hash looks like once decoded?

Regards,
Ska...
08/30/2012 09:54 Skamorzo#32
Back from holidays.
And back to the decoding stuff... be back soon...

Have a nice day,
Skamorzo.
09/24/2012 11:18 Skamorzo#33
Still stucked with the 16EE69E8CEFAEEC68BC69FC027F593DA697554C8 string encoding.

Uhm...
Have a nice day,
Skamorzo.
10/17/2012 19:30 Skamorzo#34
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.
10/17/2012 19:54 ismokedrow#35
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.
10/18/2012 09:17 Skamorzo#36
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.
11/28/2012 15:37 Skamorzo#37
;) 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)... :D

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...
11/28/2012 15:41 Skamorzo#38
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!
12/01/2012 00:39 glandu2#39
a new client made in php soon ? :p
AH/inventory viewing should be possible, as using rappelz chat, all in web page
12/01/2012 12:41 gr4ph0s#40
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 ^^'
01/24/2013 15:46 Skamorzo#41
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.
01/24/2013 16:41 c1ph3r#42
Quote:
Originally Posted by Skamorzo View Post
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...:D
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:

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

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.
01/24/2013 17:03 Skamorzo#43
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...
01/24/2013 17:19 c1ph3r#44
No there are two counts at the beginning of each record. First two int32 are bytecnt name and value.
01/24/2013 17:44 Skamorzo#45
Wow nice hint... thanks a lot c1ph3r.

Have a nice day,
Skamorzo...