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

[Skamorzo]

bwr_62,
What I would like to obtain is a 1 to 1 string reference with the gameserver and the game client... trying to discover a way to automatically generate all the files needed (client & server side) when you add some NEW NPCs.

Regards,
Ska...

[Skamorzo]

Hi all,
are you still here?

Some updates on what is on my mind (for everyone interested, of course)...

1. sqlsrv item_shop version is on the way...
2. auth and gameserver telnet integration for a web page (ongoing)... this will get on the fly all the infoes from the auth and the gameserver...
3. It could/would/should be nice to have a web application to help you play
with every tables in the databases (like phpmyadmin)...

What I am missing is:

1. a working release of 6.2 private-server (fully fixed)...
2. a working release of 7.3/7.4 private-server...

Once I have released all the 3 apps above... I will have a closer look at the DBs.

Stay tuned,
Ska...

PS. What about having the graphics (items graphics mainly) inside a database?

[haxti]

Originally Posted by Skamorzo

2. auth and gameserver telnet integration for a web page (ongoing)... this will get on the fly all the infoes from the auth and the gameserver...

Won't work since the telnetinterface is too slow. The latency is way too high for a webpage and with several simultanious connections you will likely get some bugs. At least those are the points i found with my tool and a php try.

[Skamorzo]

Haxti, thanks for answering.

I am starting to think I am the only one writing into this post.
But I prefer to use the same post to keep ordinated the things I am working
on...

To answering you:
I have coded a small php class, starting from an already available one (google search). What I have now is something that is acting fine... but need some fixes... so I have decided to have a look at the RFC related to Telnet. So I can answer a better Telnet negotiation to the authserver and the gameserver.

Regards,
Ska...

[haxti]

Have you tried with multiple page requests? The last time i tried that i had the feeling, that the telnetengine is singlethreaded and will slow down with several connections. With a webpage you will easily 10-100 cons depending on your sever population. Or you could use a kind of caching system.

[Skamorzo]

Haxti,
Yes the cached system is the last try i will do, before going to release this work. And I think you are right: the telnet engine looks like being single threaded.

Have a nice day,
Ska...

[mexicali2010]

Keep up with the good work... I'am not a dev or anything like that, but I appreciate people that tries to help others, without nothing exchange.

Not like all other devs from here, but at least I appreciate the hard work and the time your spend to do this. (y)

[groos]

Mexican, then stop being a douche on xijezu's topics.

[mexicali2010]

Originally Posted by groos

Mexican, then stop being a douche on xijezu's topics.

Go **** yourself, you are nothing but a user here, you can't use your uber ban hammer like dorkness fight had QQ?

Anyway, ban be lol... Like If i were going to loose anything with value xD.

[Skamorzo]

Here is some php code I am using to extrapolate the PHPTelnet class...
It looks like the telnet engine is quite fast in serving these requests.

Ska...

[Skamorzo]

Hi there...
Just want to say thanks who is releasing the 7.4 pserver (xijezu, and all the others involved in the 7.4 project)... even if on a testing DB... u all are great!!!!

Keep up the good work.

Secondly, I have a question:

when you open the cash_shop the client sends an HTTP GET with two parameters:

GameServer (or what ever) in plain text
id (look like being base64 encoded value)

decoding this "id" I obtain a more friendly value (like what is inside the client's resource folder).

Anyone knows how to decode this to a readable value?

Thanks,
Ska...

[Xijezu]

Yup, I do.
It is released somewhere, but useless since 7.3.

Think about it, maybe you'll know what I mean, I won't support cash shops.

[G1User]

Hey, I am new to the whole private server thing myself. I just installed SQL Server 2012 on a VM OS though. I have not done anything further such as restoring the database backups of 7.4.

However, once I take a look at the stored procedures and the whole database structure along with how Rappelz interfaces with it than I may be of us.

Currently, I am a software developer for banks (I will leave it at that). I know some javascript but mostly C#. Yes, I work with SQL on a daily basis too. Maybe once I get my feet wet I can help you out and we can collaborate.

[Xijezu]

Originally Posted by G1User

Currently, I am a software developer for banks (I will leave it at that). I know some javascript but mostly C#.

 Spoiler

*picks .NET Reflector*

Do yourself a favor and don't work with other people here, the most of them are just leechers which are thinking they are kings.

[Skamorzo]

I know Xijezu,
but the item_shop I am re-coding will not have anything to do with real
money. I am doing it just for a better gameplay. The item shop is part of the game, anyway.

I do not want to make any money from the game, don't worry.

This is what I get...

_REQUEST["server"] Rappelz01 
_REQUEST["id"] 16EE69E8CEFAEEC68BC69FC027F593DA697554C8 
_GET["server"] Rappelz01 
_GET["id"] 16EE69E8CEFAEEC68BC69FC027F593DA697554C8 
_SERVER["QUERY_STRING"] server=Rappelz01&id=16EE69E8CEFAEEC68BC69FC027F593DA697554C8 
_SERVER["REQUEST_URI"] /item_shop/index.php?server=Rappelz01&id=16EE69E8CEFAEEC68BC69FC027F593DA697554C8

16EE69E8CEFAEEC68BC69FC027F593DA697554C8 decoded using ISO-8859-15 CP and base64 gives:

סëÑ<A@@ºðºôPŽÛ±y÷pÀëÞù瀌

16EE69E8CEFAEEC68BC69FC027F593DA697554C8 decoded using Windows-1252 CP and base64 gives:

סëÑ<A@@ºðºôP´Û±y÷pÀëÞù瀼

Ska...