public function latestMacFromIP($ipaddress) { // We limit the selection to a machine that has connected in the last // hour, (this may need to be updated in the future with // CallingStationId for multiple APs) $sql = sprintf("SELECT username from radpostauth\n WHERE FramedIPAddress=%s\n AND username LIKE '__-__-__-__-__-__'\n AND authdate > TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 HOUR))\n\n ORDER BY ID DESC\n LIMIT 1", $this->db->quote($ipaddress)); $mac = $this->db->queryOne($sql); if (PEAR::isError($mac)) { \Grase\ErrorHandling::fatalDatabaseError(T_('Retrieving MAC from IP failed: '), $mac); } // Check its a MAC address?? return $mac; }
public function deleteVoucher($vouchername) { $delete = $this->radmin->prepare("DELETE FROM vouchers WHERE VoucherName=?"); $result = $delete->execute(array($vouchername)); if ($result === false) { ErrorHandling::fatalDatabaseError(T_('Delete Voucher query failed: '), $result); } \AdminLog::getInstance()->log("Voucher {$vouchername} deleted"); return $result; }