All pastes #979120 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-04-10 02:18 UTC
rendered paste body
<?php
$inc = "./include/";
include("config.php");
include($inc."functions.php");
$sid = getsid($_GET['sid']); //Fetch sid from GET or create a new one, if it's non-exsistant.
include($inc."header.php");

$address = sidaddr();


$storyid = $_GET['st'];

if($_GET['login'] == "1") {
	if($_GET['sent'] == "1") {
		
	}
	else {
	?>
<div class="main_centerbox">
<form class="loginform" action="<?php echo sidaddr("&login=1&sent=1") ?>" method="POST" >
<br />
Login:<br />
<br />
Username: <input class="loginformbg" type="text" name="uname"></input>&nbsp;&nbsp;
Password: <input class="loginformbg" type="text" name="pwd"></input><br /></br />
<input class="loginformbg" type="submit" value="Login" name="loginsubmit"></input>
</form>
</div>
	<?php
	}
}
else{
if(empty($storyid)){
	$q = mysql_query("SELECT * FROM icarus_stories ORDER BY posted DESC LIMIT 1;") or die('Query failed: ' . mysql_error());
	while ($row = mysql_fetch_array($q)) {
    	$storytitle = $row['title'];
		$storytext = $row['content'];
		$posterid = $row['poster'];
		$storydate = date($dateformat." - ".$timeformat, $row['posted']);
		$storycat = $row['category'];
		$storytags = $row['tags'];
		$lastid = $row['id'];

	}
	$q = mysql_query("SELECT uname FROM icarus_users WHERE id='$posterid' LIMIT 1;") or die('Query failed: ' . mysql_error());
		while ($row = mysql_fetch_array($q)) {
			$storyposter = $row['uname'];
		}
	
	$q = mysql_query("SELECT id FROM icarus_stories WHERE id < $lastid ORDER BY id DESC LIMIT 1;") or die('Query failed: ' . mysql_error());
		while ($row = mysql_fetch_array($q)) {
			$previd = $row['id'];
		}
    $nextid = "grey";
}
else{
	$q = mysql_query("SELECT id FROM icarus_stories WHERE id < $storyid ORDER BY id DESC LIMIT 1;") or die('Query failed: ' . mysql_error());
		while ($row = mysql_fetch_array($q)) {
			$previd = $row['id'];
		}
	
	$q = mysql_query("SELECT id FROM icarus_stories WHERE id > $storyid ORDER BY id ASC LIMIT 1;") or die('Query failed: ' . mysql_error());
		while ($row = mysql_fetch_array($q)) {
			$nextid = $row['id'];
		}
	
	$q = mysql_query("SELECT * FROM icarus_stories WHERE id='$storyid' ORDER BY id DESC LIMIT 1;") or die('Query failed: ' . mysql_error());

	while($row = mysql_fetch_array($q)){
		if($row['title'] == false) $nostory = true;
		else {
			$tom = "";
		}
	}
}



?>

<div class="main_centerbox">
<div class="main_optionbox">
<a href="<?php echo $address ?>">Start</a><br />
<a href="<?php sidaddr("&st=".$previd) ?>">&lt; Previous</a><br />
<a href="<?php if($nextid == "grey") echo ""; else echo sidaddr("&st=".$nextid) ?>">&gt; Next</a><br />
<a href="<?php echo $address ?>">List</a>
</div>
<div class="story_title"><?php echo $storytitle ?> </div>

<div class="story_text">
<?php echo nl2br($storytext); ?>
</div>



<div class="story_end">&nbsp;</div>
<div class="story_footer"><?php echo "Posted $storydate by $storyposter."; ?></div>
<!--<div class="bottom_centerbox"></div>-->
</div>



<?php
}
include($inc."footer.php");
?>