public static function addEntry($blid, $aid, $hash, $version, $beta = false, $date = null) { if ($date == null) { $date = time(); } $db = new DatabaseManager(); $res = $db->query($sq = "SELECT COUNT(*) FROM `stats_usage` WHERE `blid`='" . $db->sanitize($blid) . "' AND `aid`='" . $db->sanitize($aid) . "' AND `hash`='" . $db->sanitize($hash) . "' "); $ret = $res->fetch_row(); if (!isset($ret[0]) || $ret[0] == 0) { $res = $db->query($sq = "INSERT INTO `stats_usage` (`blid`, `aid`, `hash`, `version`, `beta`, `reported`) VALUES (\n '" . $db->sanitize($blid) . "',\n '" . $db->sanitize($aid) . "',\n '" . $db->sanitize($hash) . "',\n '" . $db->sanitize($version) . "',\n '" . ($beta ? 1 : 0) . "',\n '" . $db->sanitize(date("Y-m-d H:i:s", $date)) . "')"); } else { $db->update("stats_usage", ["blid" => $blid, "aid" => $aid, "hash" => $hash], ["version" => $version, "beta" => $beta ? 1 : 0, "reported" => date("Y-m-d H:i:s")]); } if ($error = $db->error()) { return array("status" => "error", "error" => $error); } else { return true; } }
public static function acceptReclaim($id, $bool) { $db = new DatabaseManager(); if ($bool) { $db->update("rtb_addons", ["id" => $id], ["approved" => 1]); } else { $db->update("rtb_addons", ["id" => $id], ["approved" => null]); } }