[RELEASE] Loads of php scripts for DK servers!

[janvier123]

Originally Posted by gedimazs

What is it ? Showing players online and in what map they are? I don't think this thing is usefull anymore, cause the same script was released long time ago. Or maybe I'm wrong?

your right

playeronline.php
Created on: ‎Saterday ‎4 ‎april ‎2009, ‏‎16:18:56

[Nosferatu.]

Originally Posted by janvier123

your right

playeronline.php
Created on: ‎Saterday ‎4 ‎april ‎2009, ‏‎16:18:56

i have not created this playeronline PHP, i have get it from silkbotter's vmware,mapindex.php and that is an array to view Map name, and yes it is very useful.

[janvier123]

Reported! Keep your comments to yourself and dont start to flame !

[d0s3]

Janvier123 Reported! You are Boosted Ripper!

[Decima]

Originally Posted by d0s3

Janvier123 Reported! You are Boosted Ripper!

and ur an idiot!

[=Warmonger=]

Originally Posted by gedimazs

hey cmon guys you have hided my post with your useless posts.Please don't say anything if you can't answear to the question.So sorry for moderators but I will repeat my question again.
janvier123 is it possible to write a script that you can check to what players was connected with 1 IP.
for example I enter IP address and press find. And it shows me charnames wich were played using that IP.
Is it possible?

Stay away from PHP scripts. PHP is the easiest language to manipulate and exploit. The less, the better. Add a column to your TBL_USER table name it "ClientIP" then alter your login procedure to update it regularly. With something like so.

Update [TBL_USER] Set ClientIP= @ClientIP Where AccountID= @AccountID

This way every time someone logs in even if their IP changes you will always have the last one they used to login from.

[Decima]

Originally Posted by Warmonger1337

Stay away from PHP scripts. PHP is the easiest language to manipulate and exploit. The less, the better.

couldnt disagree more, ur confusing php's abilities with the coders lack of knowledge of the code. its only exploitable if the programmer doesnt take the necessary precautions to secure the code, the biggest mistake being lack of sanitation of user input.

if the code is secured properly, then its no more exploitable then any other web programming language, and far more powerful then most

here is a little code i use to see which characters have been played on by IP, run this in query analyzer, select 'character' from the drop down box in the menu bar:

SELECT     login_time,user_no,wlevel,user_ip_addr, character_name AS Expr2
FROM         user_character
WHERE     (
user_ip_addr
 = 
0x00000000

)
OR
(
character_name
 = 
'CharName'
)

put in the characters name where it says CharName, run query, then select the user_ip_addr once u run it and copy it, and paste that where it says 0x00000000 then run it again, and you will get a list of all characters that have logged in last from that IP address. this is actually a very barbaric way of doing it, but effective still, u could write a simple procedure to automate this, i just havent bothered with it.