Help Need Help

[dievas]

how to set 24 hour active player to my website?

[Tessa]

Some more details about what exactly you want?

Edited January 24, 2015 by Tessa

[dievas]

$time=time() + 24*60*60;

 

$active=@mysql_numrows(mysql_query("SELECT * FROM characters WHERE lastAccess<$time",$link));

 

dont work i dont know why, iwant to add how many player logged in in 24 hours show in my website

please help

Edited January 24, 2015 by dievas

[Tessa]

Something like this:

<?php
$con = mysqli_connect("localhost","root","","l2jdb") or die("Error " . mysqli_error($con));

$date = date(strtotime("-1 day"));

$query = "SELECT char_name, lastAccess FROM characters WHERE lastAccess / 1000 > $date ORDER BY char_name" or die("Something went wrong.." . mysqli_error($con));

$result = $con->query($query);

while($row = mysqli_fetch_array($result)) {
    echo $row["char_name"] . " - " . date("d/m/Y H:i:s", $row["lastAccess"] / 1000) . "<br>";
}
?>

Edited January 24, 2015 by Tessa

[dievas]

works. thanks (y) i implemented and modified a little see www.l2kill.com

Edited January 24, 2015 by dievas

[Tessa]

Looks fine :)

[MeVsYou]

locked