$value) {
if ($key == "passwd") { $query .= "$key=PASSWORD('". addslashes($value) ."'), "; }
else { $query .= "$key='". addslashes($value) ."', "; }
}
$query = substr($query, 0, -2);
if (!empty($id)) { db_query("UPDATE $dbase SET $query WHERE id=$id") or die(mysql_error()); return $id; }
else { db_query("INSERT INTO $dbase SET $query") or die(mysql_error()); return mysql_insert_id(); }
}
function morelink_bytes($theme, $story) {
global $user;
### Compose more-link:
$morelink = "[ ";
if ($story->article) {
$morelink .= "id";
$morelink .= ($user->umode) ? "&mode=$user->umode" : "&mode=threaded";
$morelink .= ($user->uorder) ? "&order=$user->uorder" : "&order=0";
$morelink .= ($user->thold) ? "&thold=$user->thold" : "&thold=0";
$morelink .= "\">hlcolor2\">read more | $bytes bytes in body | ";
}
$morelink .= "id";
$morelink .= ($user->umode) ? "&mode=$user->umode" : "&mode=threaded";
$morelink .= ($user->uorder) ? "&order=$user->uorder" : "&order=0";
$morelink .= ($user->thold) ? "&thold=$user->thold" : "&thold=0";
$morelink .= "\">hlcolor2\">$story->comments comments ]";
return $morelink;
}
function morelink_words($theme, $story) {
// todo
}
function morelink_lines($theme, $story) {
// todo
}
function FixQuotes ($what = "") {
$what = ereg_replace("'","''",$what);
while (eregi("\\\\'", $what)) {
$what = ereg_replace("\\\\'","'",$what);
}
return $what;
}
function check_html($message) {
## TODO
return $message;
}
function filter_text($message, $strip="") {
### TODO
return check_html($text, $strip);
}
function formatTimestamp($time) {
### Should be removed as soon as possible!
global $datetime;
ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $datetime);
$datetime = date("l, F d, Y - h:i A", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
return($datetime);
}
function addRefer($url) {
$query = "SELECT * FROM refer WHERE url = '$url'";
$result = db_query($query);
if ($site = db_fetch_object($result)) {
if ($site->status) {
$site->refers++;
$query = "UPDATE refer SET refers = '$site->refers', access_dt = '". time() ."' WHERE url = '$url'";
$result = db_query($query);
}
}
else {
$query = "INSERT INTO refer (url, name, refers, create_dt, access_dt) VALUES ('$url', '', '1', '". time() ."', '". time() ."')";
$result = db_query($query);
}
}
function displayModerationResults($theme, $story) {
global $user;
if ($user->id && $story->id && $vote = $user->getHistory("s$story->id")) {
$output .= "You voted `$vote'.
\n";
$output .= "\n";
$output .= "Other people voted:
\n";
$result = db_query("SELECT * FROM users WHERE history LIKE '%s$story->id%'");
while ($account = db_fetch_object($result)) {
$output .= "userid\">$account->userid voted `". getHistory($account->history, "s$story->id") ."'.
";
}
$theme->box("Moderation results", $output);
}
}
function displayRelatedLinks($theme, $story) {
### Parse story for -tags:
$text = stripslashes("$story->abstract $story->updates $story->article");
while ($text = stristr($text, "") + 4);
$text = stristr($text, "");
if (!stristr($link, "mailto:")) $content .= "
$link";
}
### Default related links:
$content .= " More about category) ."\">$story->category.";
$content .= " Also by userid) ."\">$story->userid.";
$theme->box("Related links", $content);
}
function displayOldHeadlines($theme, $num = 10) {
global $user;
if ($user->storynum) $result = db_query("SELECT id, subject, timestamp FROM stories WHERE status = 2 ORDER BY timestamp DESC LIMIT $user->storynum, $num");
else $result = db_query("SELECT id, subject, timestamp FROM stories WHERE status = 2 ORDER BY timestamp DESC LIMIT $num, $num");
while ($story = db_fetch_object($result)) {
if ($time != date("F jS", $story->timestamp)) {
$content .= "". date("l, F jS", $story->timestamp) ."
";
$time = date("F jS", $story->timestamp);
}
if ($user->userid) {
$content .= "id";
$content .= ($user->umode) ? "&mode=$user->umode" : "&mode=threaded";
$content .= ($user->uorder) ? "&order=$user->uorder" : "&order=0";
$content .= ($user->thold) ? "&thold=$user->thold" : "&thold=0";
$content .= "\">$story->subject";
}
else {
$content .= "id&mode=threaded&order=1&thold=0\">$story->subject";
}
}
$content .= "[ hlcolor2\">more ]
";
$theme->box("Older headlines", $content);
}
function displayNewHeadlines($theme, $num = 10) {
global $user;
$content = "";
$result = db_query("SELECT id, subject FROM stories WHERE status = 2 ORDER BY id DESC LIMIT $num");
while ($story = db_fetch_object($result)) {
if ($user->userid) {
$content .= "id";
$content .= ($user->umode) ? "&mode=$user->umode" : "&mode=threaded";
$content .= ($user->uorder) ? "&order=$user->uorder" : "&order=0";
$content .= ($user->thold) ? "&thold=$user->thold" : "&thold=0";
$content .= "\">$story->subject";
}
else {
$content .= "id&mode=threaded&order=1&thold=0\">$story->subject";
}
}
$content .= "[ hlcolor2\">more ]
";
$theme->box("Latest headlines", $content);
}
function displayAdminblock($theme) {
$result = db_query("SELECT title, content FROM blocks");
while (list($title, $content) = mysql_fetch_array($result)) {
$theme->box($title, nl2br($content));
}
}
function displayUserblock($theme) {
global $user;
if ($user && $user->ublockon) {
$content .= "[ hlcolor2\">edit | hlcolor2\">Track comments | hlcolor2\">logout]
";
$theme->box("$user->userid's box", $user->content);
}
}
function displayLogin($theme) {
global $user;
if ($user && $user->userid) {
### Display userblock if any:
displayUserblock();
}
else {
$content = "\n";
$content .= "Register as new user.
Forgot your password?
";
$theme->box("Login", $content);
}
}
function displayCalendar($theme, $date) {
include "calendar.class.php";
$calendar = new calendar($date);
$theme->box("Browse archives", $calendar->display());
}
function displayAccount($theme) {
global $user;
if ($user && $user->userid) {
function submission_number() {
$result = db_query("SELECT COUNT(id) FROM stories WHERE status = 1");
return ($result) ? mysql_result($result, 0) : 0;
}
### Display account settings:
$content = "view your information";
$content .= "edit your information";
$content .= "customize your page";
$content .= "track your comments";
$content .= "moderate submissions (". submission_number() .")";
$content .= "logout";
$theme->box("$user->userid's account", "$content");
}
}
function displayReferrals($theme, $number = 10) {
$count = 1;
if ($number) {
$query = "SELECT * FROM refer ORDER BY refers DESC LIMIT $number";
$result = db_query($query);
}
else {
$query = "SELECT * FROM refer ORDER BY refers DESC";
$result = db_query($query);
}
while (($site = db_fetch_object($result)) && ($count <= $number)) {
if ($site->name) $rval .= "$count. url\">$site->name ($site->refers)
";
else $rval .= "$count. url\">$site->url ($site->refers)
";
$count++;
}
$theme->box("Referring sites", "$rval [ hlcolor2\">info | hlcolor2\">more ]
");
}
function displayPoll($theme) {
global $answer, $answer1, $answer2, $answer3, $answer4, $answer5, $answer6, $id, $method, $section, $poll, $question;
// Pass the URI and FORM parameters along to poll.php.
$box = 1;
include "poll.php";
}
?>