[RELEASE] Loads of php scripts for DK servers!

12/14/2009 14:52 janvier123#16
Quote:
Originally Posted by gedimazs View Post
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
12/15/2009 00:45 Nosferatu.#17
Quote:
Originally Posted by janvier123 View Post
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.
12/15/2009 08:21 janvier123#18
Reported! Keep your comments to yourself and dont start to flame !
01/29/2010 23:04 d0s3#19
Janvier123 Reported! You are Boosted Ripper!
01/29/2010 23:35 Decima#20
Quote:
Originally Posted by d0s3 View Post
Janvier123 Reported! You are Boosted Ripper!
[Only registered and activated users can see links. Click Here To Register...]

and ur an idiot!
01/30/2010 04:50 =Warmonger=#21
Quote:
Originally Posted by gedimazs View Post
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.
Code:
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.
01/30/2010 09:39 Decima#22
Quote:
Originally Posted by Warmonger1337 View Post
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:

Code:
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.