[RELEASE] DSLM (Dekaron Server Live Maps) [PHP package for ServerOwners]

12/17/2010 14:52 pieter#1
Dekaron Server Live Maps
DSLM is a webbased PHP script which allows you to display all players on each map ingame live.
This gives admins an insight of players ingame when they don't have chance to go ingame.

[Only registered and activated users can see links. Click Here To Register...]
Old screenshot, watch video for current layout

Video of DSLM in action:

File information and download:
[Only registered and activated users can see links. Click Here To Register...]

Online virusscans
Jotti: [Only registered and activated users can see links. Click Here To Register...]
Virustotal: [Only registered and activated users can see links. Click Here To Register...]

After installation please take time to read the readme, and the comments in the php code!
:pimp:
12/17/2010 17:13 l2zeo#2
wow!! how about that!
nice job pieter!! ;-)
12/17/2010 17:40 MMOPerfectionİ#3
Very nice release bro, keep it up you and janvier.
12/17/2010 17:46 NewKnight#4
yea thats nice! good job ceep it up!
12/17/2010 17:56 [GM]Death#5
pieter all i can say is DAMN!!!!!!!!!!
way to go, damn good work!!!!!!!!
12/17/2010 20:49 Deadman88#6
really2 nice man..thx alot..:D
12/18/2010 06:00 Decima#7
is this actually "Live" or is this "they were there 60-180 seconds ago" ?? i know we were talking about it on the other thread, wondering if you figured out how to actually make it live, or if you are misleading in your title . . . .
12/18/2010 10:50 pieter#8
its live from the database, so the title is correct.
offcourse the database can't controll when dekaron updates the char coords since that is client-sided if the client doesnt trigger sp_char_update the server cant help it ;)

after some testing we found out that most players update coords every 5/15 seconds depending on their connection speed and/or lag.
12/18/2010 10:53 janvier123#9
iam busy with the DB response time at: [Only registered and activated users can see links. Click Here To Register...]
Thx to gedimazs who is running it for me :D
12/19/2010 00:31 [DEV]Pwner#10
+1 for that , awesome !
12/19/2010 19:33 Decima#11
Quote:
Originally Posted by pieter View Post
after some testing we found out that most players update coords every 5/15 seconds depending on their connection speed and/or lag.
im not trying to sound like a douche, but this is incorrect, not one aspect of the DB coords are updated short of logging in/out are updated every 15 seconds, so either ur test results are inaccurate, or u have a magical exe ur running on. i would suggest taking a look at janviers results as they seem to be wat more accurate then urs, altho it does seem even his is even longer then i have experienced my self, its hard to argue with his results tho as they are being tested against a live connection in real time, so i dunno

its rather interesting tbh, but 15 seconds <--- lmfao ERRRRRRRRRR try again :P

oh, and to add, the "client" doesnt call any of the procs, the server does, which means it isnt dependent on anything to do with the speed of the clients connection, if someone could prove me wrong, i am all ears . . .
12/19/2010 20:18 janvier123#12
i want to try my test again, but only if i have a live connection with the database
huh ?
in short words i need to access the database with username and password
mean while i would like to have a GM account that can teleport

but!
this is unlikely going to happen, but possible
i can run my script at any given time: ms, sec, min, hour

The job for me is to dive in the logs created and give a perfect result how fast the db is updated

If anyone is willing to help me out with this ... pm me
12/19/2010 20:35 pieter#13
Quote:
Originally Posted by Decima View Post
im not trying to sound like a douche, but . . .
then don't..

Janvier allready has a thread about db responce. I don't see any use on continueing that discussion here asswell.

You've allready stated your oppinion on this release in the WIP thread.
There is no need to keep bashing it.

This is one of the main reasons im never releasing my full recoded osds v2 here..
12/20/2010 22:32 Decima#14
you got me wrong man

im just trying to get you to see the inaccuracy of what u are saying, which u can take as an insult, but its intended to help you establish some accuracy, im not bashing anything, its pretty cool, just trying to get you to see whats wrong with it so u can make it better

if you dont plan to make things u make better, then my bad ;)
12/30/2010 11:17 janvier123#15
try this: Create Job or SP
when CHECK_IN is called from dekaronserver.exe
Fetch X and Y and put in a table

for each fetch, make a new line
so when you want a "TRACE" where the char has been ...