function onlinetimegift() {
    global $conn;
    if(!isset($_SESSION['usid'])) return 0;
    $res = $conn->prepare("SELECT * FROM `onlinegift`");
    $res->execute();
    $res_ = $res->fetch(PDO::FETCH_ASSOC);

    $isenabled = $res_["isenabled"];
    $perhours = $res_["perhours"] * 60 * 60;
    $addgp = $res_["gpadd"];

    if($isenabled == 0) return 0;

    $user = $_SESSION['usid'];
    $res = $conn->prepare("SELECT * FROM `db_game`.`t_user` WHERE `accountid` IN (SELECT `accountid` FROM `db_account`.`t_account` WHERE `name` = :panda)");
    $res->bindParam("panda",$user);
    $res->execute();
    if($res->rowCount() == 0) return 0;

    $totaltime = 0;
    foreach($res->fetchAll(PDO::FETCH_ASSOC) as $character) {
        $totaltime += $character["onlinetime"];
        $res = $conn->prepare("UPDATE `db_game`.`t_user` SET `onlinetime` = '0' WHERE `name` = :panda1");
        $res->bindParam("panda1",$character["name"]);
        $res->execute();
    }
    $multiplier = intval($totaltime / $perhours);
    $pointstoadd = $addgp * $multiplier;

    if(intval($pointstoadd) < 1) return 0;

    $res = $conn->prepare("UPDATE `site`.`users` SET `gpoints` = `gpoints` + :panda WHERE `name` = :panda1");
    $res->bindParam("panda",$pointstoadd);
    $res->bindParam("panda1",$user);
    $res->execute();

    $res = $conn->prepare("UPDATE `site`.`users` SET `onlinetime` = `onlinetime` + :panda WHERE `name` = :panda1");
    $res->bindParam("panda",$totaltime);
    $res->bindParam("panda1",$user);
    $res->execute();

    return 1;
}