Wrong querry

[Quba 3]

What is wrong in this querry?: https://metin2.download/picture/tYokqsptwiidRFh46U0IWKeb2V6iCwAl/.png
Is a querry for online players.

 

Thank's.

Edited September 2, 2022 by Metin2 Dev
Core X - External 2 Internal

[ondry 365]

    public static function playersOnline()
    {
        $playerdb = Core::getPlayerDatabase();
        $date = new DateTime(date('Y-m-d H:i:s'));
        $interval = new DateInterval('PT5M');
        $interval->invert = 1;
        $date->add($interval);
        $online = $date->format('Y-m-d H:i:s');

        $query = Database::query("SELECT * FROM ".$playerdb.".player WHERE last_play > ?", array($online));
        return $query;
    }

[Quba 3]

3 hours ago, ondry said:

    public static function playersOnline()
    {
        $playerdb = Core::getPlayerDatabase();
        $date = new DateTime(date('Y-m-d H:i:s'));
        $interval = new DateInterval('PT5M');
        $interval->invert = 1;
        $date->add($interval);
        $online = $date->format('Y-m-d H:i:s');

        $query = Database::query("SELECT * FROM ".$playerdb.".player WHERE last_play > ?", array($online));
        return $query;
    }

It did not work.

[ondry 365]

then your datetime on vps / webhosting is not set correctly

[Quba 3]

I set the date vps/webhost and nothing .

Thank you man <3 . Done .

 

Please topic closed .