/** * Log a new kill. * * @param integer $killid * @param string $note */ public static function logKill($killid, $note = null) { if (is_null($note)) { $note = "IP:" . logger::getip(); } $qry = DBFactory::getDBQuery(true); $qry->execute("INSERT INTO kb3_log (log_kll_id, log_site," . " log_ip_address, log_timestamp) values(" . $killid . ",'" . KB_SITE . "','" . $qry->escape($note) . "', UTC_TIMESTAMP())"); }
/** * Add a comment to a kill. * * The kill id is set when the Comments object is constructed. * @param string $name The name of the comment poster. * @param string $text The text of the comment to post. */ function addComment($name, $text) { $comment = $this->bbencode(trim($text)); $name = trim($name); $qryP = new DBPreparedQuery(); $sql = "INSERT INTO kb3_comments (`kll_id`,`site`, `comment`,`name`,`posttime`, `ip`)\n VALUES (?, ?, ?, ?, ?, ?)"; $qryP->prepare($sql); $site = KB_SITE; $date = kbdate('Y-m-d H:i:s'); $ip = logger::getip(); $params = array('isssss', &$this->id_, &$site, &$comment, &$name, &$date, &$ip); $qryP->bind_params($params); $qryP->execute(); $id = $qryP->getInsertID(); $this->comments_[] = array('time' => kbdate('Y-m-d H:i:s'), 'name' => $name, 'comment' => $comment, 'id' => $id); // create comment_added event event::call('comment_added', $this); }