document.title='Lost::MikeGTN";
if (array_key_exists("page",$_REQUEST)) {
$page = mysqli_real_escape_string($link,$_REQUEST["page"]);
$page = preg_replace("/[^0-9]/", "", $page);
} else {
$page = 1;
}
$query = "SELECT * FROM story WHERE";
if (array_key_exists("id",$_REQUEST)) {
$query .= " id='" . mysqli_real_escape_string($link,$_REQUEST["id"]) . "'";
if (! array_key_exists("preview",$_REQUEST)) $query .= "AND";
} else if (array_key_exists("category",$_REQUEST)) {
$query .= " category='" . mysqli_real_escape_string($link,$_REQUEST["category"]) . "' AND";
} else if (array_key_exists("month",$_REQUEST) && array_key_exists("year",$_REQUEST)) {
$query .= " (YEAR(date)='" . mysqli_real_escape_string($link,$_REQUEST["year"]) . "' AND MONTHNAME(date)='" . mysqli_real_escape_string($link,$_REQUEST["month"]) . "') AND";
} else if (array_key_exists("search",$_REQUEST)) {
$search_str=mysqli_real_escape_string($link,$_REQUEST["search"]);
$query .= " (content RLIKE \"" . $search_str . "\" OR title RLIKE \"" . $search_str . "\") AND";
}
if (array_key_exists("date",$_REQUEST)) {
$query .= " DATE_FORMAT(date,'%Y-%m-%d')='" . $_REQUEST["date"] . "' AND";
}
if (array_key_exists("otd",$_REQUEST)) {
$query .= " MONTH(now())=MONTH(date) AND DAY(now())=DAY(date) AND";
}
if (! array_key_exists("preview",$_REQUEST)) {
$query .= " hide='N'";
}
$query .= " ORDER BY date DESC";
if (array_key_exists("random",$_REQUEST)) {
$query = "SELECT * from story ORDER BY RAND() LIMIT 1";
}
/* DEBUG
echo "
$query
"; */ $result = $link->query($query); $rows = mysqli_num_rows($result); $page_rows = 4; $last = ceil($rows/$page_rows); if ($page < 1) { $page = 1; } elseif ($page > $last) { $page = $last; } $start = ($page - 1) * $page_rows; if (! array_key_exists("id",$_REQUEST)) { $query .= ' LIMIT ' . $start . ',' .$page_rows; } else { $query .= " LIMIT 1"; } $count = 0; if ($result = $link->query($query)) { while($row = mysqli_fetch_assoc($result)) { $phpdate = strtotime($row['date']); $display_date = date( 'l jS F Y \a\t g:ia', $phpdate ); $nav_date = $row["date"]; $title = $row["title"]; if (array_key_exists("search",$_REQUEST)) { $row["content"]=search_highlight($_REQUEST["search"],$row["content"]); $row["title"]=search_highlight($_REQUEST["search"],$row["title"]); $page_title = $page_title_base . " - Search Results'"; } if (array_key_exists("otd",$_REQUEST)) { if (date('Y') != date('Y',$phpdate)) { $yearsago = date('Y') - date('Y',$phpdate); $row['title'] = $row['title'] . " $yearsago years ago "; $page_title = $page_title_base . " - On This Day'"; } } echo "";
// echo "![" . $row[](" . $row[)
\n";
} else {
echo "![](" . $cat_icons[$row["category"]] . ")
\n";
}
echo "
\n"; echo "
\n";
echo "" . $row['title'] . "
"; if ($row["image"]) { echo "" . $row['title'] . "
"; $cat_display = $row["category"]; if ($row["subcat"]) { $cat_display .= ", " . $row["subcat"]; } if (array_key_exists("category",$_REQUEST)) { $page_title = $page_title_base . " - " . $cat_display . "'"; } echo "Posted in " . $cat_display . " on ". $display_date; echo "
\n"; echo "\n"; echo "
".$row['content']."
"; echo "";
/* restore movebook_link on individual story */
$mbl_date = substr($row['date'],0,10);
$mbl_query = "SELECT id FROM moves WHERE date='" . $mbl_date . "'";
$mbl_link = mysqli_connect("localhost","mike","shrimper","movebook");
$mbl_result = $mbl_link->query($mbl_query);
if (mysqli_num_rows($mbl_result) > 0) {
echo "Movebook Link";
}
/* fb share link */
echo "";
echo "
\n"; echo "
";
$count = $count+1;
}
# prev/next on single id only
if ($count==1) {
$page_title = $page_title_base . " - " . $title . "'";
echo "\n"; echo "
";
$next_query = "SELECT id FROM story WHERE date>'" . $nav_date . "' AND hide='N' ORDER BY date ASC LIMIT 1";
$next_result = $link->query($next_query);
$next_row = mysqli_fetch_assoc($next_result);
if ($next_row['id']) echo " Next Post";
$prev_query = "SELECT id FROM story WHERE date<'" . $nav_date . "' AND hide='N' AND id ORDER BY date DESC LIMIT 1";
$prev_result = $link->query($prev_query);
$prev_row = mysqli_fetch_assoc($prev_result);
if ($prev_row['id']) echo "Previous Post ";
echo "
";
$prev_result->close();
$next_result->close();
}
$result->close();
// if ($cat_display) { echo ""; };
// if ($row['otd']) { echo ""; };
unset($row);
unset($query);
$page_title = $page_title . "";
echo $page_title;
} else {
echo "There's a problem...
"; echo "I couldn't find anything to show you here. Perhaps you should start at the beginning?
"; //echo "$query"; } /* pagination stuff */ if ($last>1) { echo ""; } /* end of pagination stuff */ /* extra comment */ ?>