/** * Insert a new comment into the database * * @param array */ function new_comment($comment) { $created = date("Y-m-d H:i:s", utc_time()); $sql = "INSERT\n\t\t\t\tINTO comments (\n\t\t\t\t\tthread_id,\n\t\t\t\t\tuser_id,\n\t\t\t\t\tcontent,\n\t\t\t\t\toriginal_content,\n\t\t\t\t\tcreated\n\t\t\t\t) VALUES (?, ?, ?, ?, ?)"; $this->db->query($sql, array($comment->thread_id, $comment->user_id, $comment->content, $comment->original_content, $created)); $sql = "UPDATE\n\t\t\t\tthreads\n\t\t\tSET\n\t\t\t\tlast_comment_id = ?,\n\t\t\t\tlast_comment_created = ?\n\t\t\tWHERE thread_id = ?"; $this->db->query($sql, array($this->db->insert_id(), $created, $comment->thread_id)); $sql = "UPDATE\n\t\t\t\tcategories \n\t\t\tSET\n\t\t\t\tlast_comment_created = ?\n\t\t\tWHERE category_id = (\n\t\t\t\tSELECT category\n\t\t\t\tFROM threads\n\t\t\t\tWHERE thread_id = ?)"; $this->db->query($sql, array($created, $comment->thread_id)); }
/** * Insert a new comment into the database * * @param array * @return void */ function new_comment($data) { $whattime = date("Y-m-d H:i:s", utc_time()); $sql = "INSERT INTO comments (thread_id, user_id, content, original_content, " . "created) VALUES (?, ?, ?, ?, ?)"; $this->db->query($sql, array($data['thread_id'], $data['user_id'], $data['content'], $data['original_content'], $whattime)); $sql = "UPDATE threads SET last_comment_id = ?,last_comment_created = ? " . "WHERE thread_id = ?"; $this->db->query($sql, array($this->db->insert_id(), $whattime, $data['thread_id'])); $sql = "UPDATE categories SET last_comment_created = ? WHERE " . "category_id = (SELECT category FROM threads WHERE thread_id = ?)"; $this->db->query($sql, array($whattime, $data['thread_id'])); }
exit; } if ($argv[1] == "--delete") { delete_mysql($argv[2]); exit; } if ($argv[1] == "--run-mysql") { run_mysql(); exit; } if ($argv[1] == "--test") { tests_import(); exit; } if ($argv[1] == "--utctime") { utc_time(); exit; } if ($argv[1] == "--deleteall") { delete_mysql_all(); exit; } $GLOBALS["PROGRESS"] = true; Scan($argv[1]); function delete_mysql($md5file) { $q = new mysql_squid_builder(); $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM import_srclogs WHERE md5file='{$md5file}'")); $path = $ligne["path"]; @unlink($path); $q->QUERY_SQL("DELETE FROM import_srclogs WHERE md5file='{$md5file}'");
/** * Update user login info, such as IP-address or login time, and * clear previously generated (but not activated) passwords. * * @param int * @return void */ function update_login_info($user_id) { $sql = "\n\t\t\tUPDATE users\n\t\t\tSET\n\t\t\t\tlast_ip = ?,\n\t\t\t\tlast_login = ?\n\t\t\tWHERE id = ?"; $this->db->query($sql, array($this->input->ip_address(), date("Y-m-d H:i:s", utc_time()), $user_id)); }
$available_languages = available_languages(); } $available_languages = array_merge(array('' => $strDefault), $available_languages); if (!empty($user->i18n)) { $selectedlang = $user->i18n; } else { $selectedlang = $_SESSION['lang']; } echo array_drop_down($available_languages, 'vari18n', $selectedlang, '', TRUE); echo "</td></tr>\n"; if ($user->utc_offset == '') { $user->utc_offset = 0; } echo "<tr><th>{$strUTCOffset}</th><td>"; foreach ($availabletimezones as $offset => $tz) { $tz = $tz . ' (' . ldate('H:i', utc_time($now) + $offset * 60) . ')'; $availtz[$offset] = $tz; } echo array_drop_down($availtz, 'utcoffset', $user->utc_offset, '', TRUE) . "</td></tr>\n"; echo "<tr><th>{$strInterfaceStyle}</th><td>" . interfacestyle_drop_down('style', $user->style) . "</td></tr>\n"; echo "<tr><th>{$strIncidentRefresh}</th>"; echo "<td><input maxlength='10' name='incidentrefresh' size='3' type='text' value=\"{$user->incident_refresh}\" /> {$strSeconds}</td></tr>\n"; echo "<tr><th>{$strIncidentLogOrder}</th><td>"; echo "<select name='updateorder'>"; echo "<option "; if ($user->update_order == "desc") { echo "selected='selected'"; } echo " value='desc'>{$strNewestAtTop}</option>\n"; echo "<option "; if ($user->update_order == "asc") {
/** * Returns a localised and translated date * @author Ivan Lucas * @param string $format. date() format * @param int $date. UNIX timestamp. Uses 'now' if ommitted * @param bool $utc bool. Is the timestamp being passed as UTC or system time TRUE = passed as UTC FALSE = passed as system time * @returns string. An internationised date/time string * @todo th/st and am/pm maybe? */ function ldate($format, $date = '', $utc = TRUE) { if ($date == '') { $date = $GLOBALS['now']; } if ($_SESSION['utcoffset'] != '') { if (!$utc) { // Adjust the date back to UTC $date = utc_time($date); } // Adjust the display time to the users local timezone $useroffsetsec = $_SESSION['utcoffset'] * 60; $date += $useroffsetsec; } $datestring = gmdate($format, $date); // Internationalise date endings (e.g. st) if (strpos($format, 'S') !== FALSE) { $endings = array('st', 'nd', 'rd', 'th'); $i18nendings = array($GLOBALS['strst'], $GLOBALS['strnd'], $GLOBALS['strrd'], $GLOBALS['strth']); $datestring = str_replace($endings, $i18nendings, $datestring); } // Internationalise full day names if (strpos($format, 'l') !== FALSE) { $days = array('Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday'); $i18ndays = array($GLOBALS['strMonday'], $GLOBALS['strTuesday'], $GLOBALS['strWednesday'], $GLOBALS['strThursday'], $GLOBALS['strFriday'], $GLOBALS['strSaturday'], $GLOBALS['strSunday']); $datestring = str_replace($days, $i18ndays, $datestring); } // Internationalise abbreviated day names if (strpos($format, 'D') !== FALSE) { $days = array('Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun'); $i18ndays = array($GLOBALS['strMon'], $GLOBALS['strTue'], $GLOBALS['strWed'], $GLOBALS['strThu'], $GLOBALS['strFri'], $GLOBALS['strSat'], $GLOBALS['strSun']); $datestring = str_replace($days, $i18ndays, $datestring); } // Internationalise full month names if (strpos($format, 'F') !== FALSE) { $months = array('January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'); $i18nmonths = array($GLOBALS['strJanuary'], $GLOBALS['strFebruary'], $GLOBALS['strMarch'], $GLOBALS['strApril'], $GLOBALS['strMay'], $GLOBALS['strJune'], $GLOBALS['strJuly'], $GLOBALS['strAugust'], $GLOBALS['strSeptember'], $GLOBALS['strOctober'], $GLOBALS['strNovember'], $GLOBALS['strDecember']); $datestring = str_replace($months, $i18nmonths, $datestring); } // Internationalise short month names if (strpos($format, 'M') !== FALSE) { $months = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'); $i18nmonths = array($GLOBALS['strJanAbbr'], $GLOBALS['strFebAbbr'], $GLOBALS['strMarAbbr'], $GLOBALS['strAprAbbr'], $GLOBALS['strMayAbbr'], $GLOBALS['strJunAbbr'], $GLOBALS['strJulAbbr'], $GLOBALS['strAugAbbr'], $GLOBALS['strSepAbbr'], $GLOBALS['strOctAbbr'], $GLOBALS['strNovAbbr'], $GLOBALS['strDecAbbr']); $datestring = str_replace($months, $i18nmonths, $datestring); } // Internationalise am/pm if (strpos($format, 'a') !== FALSE) { $months = array('am', 'pm'); $i18nmonths = array($GLOBALS['strAM'], $GLOBALS['strPM']); $datestring = str_replace($months, $i18nmonths, $datestring); } return $datestring; }
function new_message($data) { $sql = "\n\t\t\tINSERT INTO pm_content\n\t\t\t\t(subject, content, created)\n\t\t\tVALUES\n\t\t\t(?, ?, ?)"; $this->db->query($sql, array($data['subject'], $data['content'], date("Y-m-d H:i:s", utc_time()))); return $this->db->insert_id(); }