function page($theme) { include "includes/smileyparse.php"; if (isset($_GET['page'])) { $page = $_GET['page']; $query = "SELECT * FROM pages WHERE id_string = '{$page}'"; $result = mysql_query($query); $num = mysql_numrows($result); if ($num == 0) { echo '<div class="entry">No such page!</div>'; } else { $id = mysql_result($result, 0, "id"); $title = mysql_result($result, 0, "title"); $page = mysql_result($result, 0, "page"); $page = parseSmiley($page); $page = stripslashes($page); echo '<div class="entry"><h3>'; echo $title; echo '</h3><p>'; echo $page; echo '</div>'; } } else { echo '<div class="entry">You must specify a page!</div>'; } }
function comments($id, $title) { $query = "SELECT * FROM comments WHERE article = {$id} ORDER BY id"; $result = mysql_query($query); $num = mysql_numrows($result); $i = 0; while ($i < $num) { $comment_id = mysql_result($result, $i, "id"); $username = mysql_result($result, $i, "username"); $comment = mysql_result($result, $i, "comment"); $comment = parseSmiley($comment); $comment = stripslashes($comment); echo "<div class=\"comments\">"; echo "<span class=\"posttime\"><b>#{$comment_id}, Re: {$title}</b>, by {$username}</span><br /><br />"; echo "{$comment}"; echo "</div>"; $i++; } echo "<br /><a href=\"index.php?module=postcomment&article_id={$id}\">Post a comment...</a>"; }
function news($theme) { include "modules/getcomments.php"; include "includes/smileyparse.php"; if (isset($_GET["article"])) { $article_id = $_GET["article"]; $query = "SELECT * FROM news WHERE id = '{$article_id}'"; $result = mysql_query($query); $num = mysql_numrows($result); if ($num == 0) { echo '<div class="entry">No such article!</div>'; } else { $id = mysql_result($result, 0, "id"); $title = mysql_result($result, 0, "title"); $title = stripslashes($title); $details = mysql_result($result, 0, "details"); $article = mysql_result($result, 0, "short_article"); $article = parseSmiley($article); $article = stripslashes($article); $extended_article = mysql_result($result, 0, "extended_article"); $extended_article = parseSmiley($extended_article); $extended_article = stripslashes($extended_article); ?> <div class="entry"> <h1><a href="index.php?module=news&article=<?php echo $id; ?> " class="h1"><?php echo $title; ?> </a></h1> <?php echo $article; ?> <br /> <?php if ($extended_article != "") { echo "<br />{$extended_article}"; } ?> <hr> <span class="posttime"><?php echo $details; ?> </span><br /> <?php include "modules/comments.php"; comments($id, $title); ?> </div> <?php } } else { $query = "SELECT * FROM news ORDER BY id DESC LIMIT 5"; $result = mysql_query($query); $num = mysql_numrows($result); if ($num == 0) { echo '<div class="entry">No posts in database</div>'; } else { $i = 0; while ($i < $num) { $id = mysql_result($result, $i, "id"); $title = mysql_result($result, $i, "title"); $details = mysql_result($result, $i, "details"); $article = mysql_result($result, $i, "short_article"); $article = parseSmiley($article); $extended_article = mysql_result($result, $i, "extended_article"); ?> <div class="entry"> <h1><a href="index.php?module=news&article=<?php echo $id; ?> " class="h1"><?php echo $title; ?> </a></h1> <span class="posttime"><?php echo $details; ?> </span><br /> <?php echo $article; ?> <br /> <?php if ($extended_article != "") { ?> <br /><a href="index.php?module=news&article=<?php echo $id; ?> ">Read More >></a> <?php } ?> <hr> <span class="rightalign"><?php getcomments($id); ?> </span><br /> </div> <?php $i++; } } } }