Oscar Lyis
Donator
This is how it looks:
How can I fix? i'm using 0.3.5
htdocs/forum/forum.php:
htdocs/forum/tread.php:
htdocs/forum/board.php:
htdocs/forum/functions.php
How can I fix? i'm using 0.3.5
htdocs/forum/forum.php:
Code:
<style>
.top {
background:#505050;
font-size: 7pt;
font-weight: bold;
font-family: Verdana,Arial,Times New Roman,sans-serif;
text-align: center;
color: #EFEFEF;
}
.board {
background-color: #d4c0a1;
text-align: center;
color: #5A2800;
}
.light {
background-color: #f1e0c6;
text-align: center;
color: #5A2800;
}
img {
border: none;
}
</style>
<?
include("forum/config.php");
include("forum/functions.php");
if($install)exit;
$date = timenow();
if(isset($_POST['login'])){
$acc = $_POST['account'];
$pass = $_POST['pass'];
if($acc == $admin_login and $pass == $admin_password) {
$_SESSION['admin'] = 'yes';
$main_content .= "<a href='?subtopic=forum&action=1'>Go to admin</a>";}
else
$main_content .= "Wrong password or login.";
}
$action = (int) $_REQUEST['action'];
if(!empty($action)){
if(!empty($_SESSION['admin'])){
$main_content .= "<a href='?subtopic=forum&action=3'>Create new board.<br></a>";
if($action == 2){
$id = (int)$_GET['id'];
deleteBoard($id);
$main_content .= "Board has been deleted.<br>";
}
else if($action == 3){
if(isset($_POST['new_board'])){
$name = $_POST['name'];
$desc = $_POST['desc'];
$closed = $_POST['closed'];
$access = $_POST['access'];
mysql_query("INSERT INTO `forums` VALUES('', '$name', '$desc', '$closed', '$access');");
$main_content .= "$name has been made.";
}
$main_content .= "<form method='post' action='?subtopic=forum&action=3'>";
$main_content .= "Board name:<br> <input type='text' name='name'><br>";
$main_content .= "Description:<br><textarea name='desc'></textarea><br>";
$main_content .= "Closed:<br> <select name='closed'><option value='0'>No</option><option value='1'>Yes</option></select><br>";
$main_content .= "Min. access to enter: <br><input type='text' value='0' size='2' name='access'><br>";
$main_content .= "<input type='submit' name='new_board' value='Make new board'>";
$main_content .= "</form>";
}
}
else {
$main_content .= "<form action='?subtopic=forum' method='post'>Login:<br><input type='password' name='account'><br>Password:<br><input type='password' name='pass'><br><input name='login' type='submit' value='Login'></form>";
}
}
if(!$logged) $main_content .= "You are <b>not</b> logged in. <a href='?subtopic=accountmanagement'>Log in</a> to post on the forum.<br>";
$main_content .= "<div align='right'>Current time: $date</div>";
$main_content .= "<table cellspacing='1' width='100%'><td width='5%' class='top'></td><td width='50%' class='top'><font color='#EFEFEF'>Board</font></td><td width='10%' class='top'><font color='#EFEFEF'>Posts</font></td><td width='10%' class='top'><font color='#EFEFEF'>Threads</font></td><td width='30%' class='top'><font color='#EFEFEF'>Last Post</font></td><tr></tr>";
$sql = mysql_query("SELECT * FROM `forums`");
$row = mysql_num_rows($sql);
if($row == 0) $main_content .= "<b>No specified forums yet.</b>"; else {
while($cmd = mysql_fetch_array($sql)){
$name = $cmd['name'];
$desc = $cmd['description'];
$access = $cmd['access'];
$closed = $cmd['closed'];
$id = $cmd['id'];
if($closed == 1)$close = "<img src='forum/images/closed.gif'>";
if(!$logged) $user_access = 0; else {
$user = loadAccountById($account_logged);
$user_access = $user['page_access']; }
if($access > $user_access) continue;
$posts = mysql_num_rows(mysql_query("SELECT * FROM `posts` WHERE `board` = '$id'"));
$threads = mysql_num_rows(mysql_query("SELECT * FROM `threads` WHERE `board` = '$id'"));
$last = mysql_query("SELECT * FROM `posts` WHERE `board` = '$id' ORDER BY `id` DESC LIMIT 1");
$row = mysql_num_rows($last);
if($row == 0) $last = "None"; else {
$cmd1 = mysql_fetch_array($last);
$author = $cmd1['author'];
$thread = $cmd1['thread'];
$date = $cmd1['date'];
$last = "<a href='?subtopic=thread&id=$thread'><img src='forum/images/arrow.gif'></a> $date<br>by <a href='?subtopic=characters&name=$author'>$author</a>";
}
if(!empty($_SESSION['admin']))
$admin = "<a href='?subtopic=forum&action=2&id=$id'>Delete this board</a>";
$main_content .= "<td class='board'>$close</td><td class='board' style='text-align: left;'><a href='?subtopic=board&id=$id'>$name</a><br><span style='font-size: 8pt;'>$desc</span><br>$admin</td><td class='light'>$posts</td><td class='board'>$threads</td><td class='light'>$last</td><tr></tr>";
}
}
$main_content .= "</table>";
$main_content .= "<font style='font-size: 8px;'><a href='?subtopic=forum&action=1'>Admin</a></font>";
?>
Code:
<style>
.top {
background:#505050;
font-size: 7pt;
font-weight: bold;
font-family: Verdana,Arial,Times New Roman,sans-serif;
color: #EFEFEF;
padding: 3px;
}
.board {
background-color: #d4c0a1;
color: #5A2800;
font-family: Verdana,Arial,Times New Roman,sans-serif;
}
.light {
background-color: #f1e0c6;
color: #5A2800;
font-family: Verdana,Arial,Times New Roman,sans-serif;
}
img {
border: none;
}
</style>
<?
include("forum/config.php");
include("forum/functions.php");
if($install)exit;
$thread = (int)$_REQUEST['id'];
$row = mysql_num_rows(mysql_query("SELECT * FROM `threads` WHERE `id` = '$thread'"));
if($row == 0){$main_content .= "Could not find topic."; return;}
$sql = mysql_query("SELECT * FROM `threads` WHERE `id` = '$thread'");
$cmd = mysql_fetch_array($sql);
$board = $cmd['board'];
$sql = mysql_query("SELECT * FROM `forums` WHERE `id` = '$board'");
$cmd = mysql_fetch_array($sql);
$access = $cmd['access'];
if($access > 0){
if(!$logged) { $main_content .= "You cannot view this board."; return; }
else{
$user = loadAccountById($account_logged);
$user_access = $user['page_access'];
if($access > $user_access) { $main_content .= "You cannot view this board."; return; }
}
}
$date = timenow();
$action = (int)$_REQUEST['action'];
if(!empty($action)){
if(!empty($_SESSION['admin'])){
if($action == 1){
$id = (int)$_GET['post'];
deletePost($id);
}
else if($action == 2){
mysql_query("UPDATE `threads` SET `stick` = '1' WHERE `id` = '$thread'");
}
else if($action == 3){
mysql_query("UPDATE `threads` SET `stick` = '0' WHERE `id` = '$thread'");
}
}
}
if(!$logged) $main_content .= "You are <b>not</b> logged in. <a href='?subtopic=accountmanagement'>Log in</a> to post on the forum.<br>";
$main_content .= "<div align='right'>Current time: $date</div>";
$sql = mysql_query("SELECT * FROM `threads` WHERE `id` = '$thread'");
$row = mysql_num_rows($sql);
if($row == 0){$main_content .= "Could not find thread."; return;}
$action = (int)$_REQUEST['action'];
if(isset($_POST['add'])){
$icon = (int)$_POST['icon'];
$post = stripslashes(htmlentities($_POST['post']));
$subject = stripslashes(htmlentities($_POST['subject']));
$character = stripslashes(htmlentities($_POST['character']));
$disable = $_POST['disable'];
$signature = $_POST['signature'];
if(empty($disable)) $disable = 0; else $disable = 1;
if(empty($signature)) $signature = 0; else $signature = 1;
$sql = mysql_query("SELECT * FROM `threads` WHERE `id` = '$thread'");
$cmd3 = mysql_fetch_array($sql);
$board = $cmd3['board'];
$closed_thread = $cmd3['closed'];
$sql = mysql_query("SELECT * FROM `forums` WHERE `id` = '$board'");
$cmd4 = mysql_fetch_array($sql);
$access = $cmd4['access'];
$closed = $cmd4['closed'];
$account = loadAccountById($account_logged);
$user_access = $account['page_access'];
if($access > $user_access) {$main_content .= "You don't have permission to post in this thread."; return;}
if($closed == 1 or $closed_thread == 1){ $main_content .= "This board is closed."; return;}
if(empty($post)) {$main_content .= "Your post is empty."; return;}
$sql = mysql_query("SELECT * FROM `players` WHERE `name` = '$character' AND `account_id` = '$account_logged'");
$row = mysql_num_rows($sql);
if($row == 0){ $main_content .= "Could not find character."; return;}
$date = timenow();
$time = time();
if(empty($disable)){
$post = str_replace(":p", "<img src='forum/images/1.gif'>", $post);
$post = str_replace(":eek:", "<img src='forum/images/2.gif'>", $post);
$post = str_replace(":rolleyes:", "<img src='forum/images/3.gif'>", $post);
$post = str_replace(";)", "<img src='forum/images/6.gif'>", $post);
$post = str_replace(":o", "<img src='forum/images/7.gif'>", $post);
$post = str_replace(":D", "<img src='forum/images/8.gif'>", $post);
$post = str_replace(":(", "<img src='forum/images/9.gif'>", $post);
$post = str_replace(":mad:", "<img src='forum/images/10.gif'>", $post);
$post = str_replace(":)", "<img src='forum/images/11.gif'>", $post);
$post = str_replace(":cool:", "<img src='forum/images/12.gif'>", $post);
}
mysql_query("INSERT INTO `posts` VALUES('', '$subject', '$icon', '$date', '$time', '$character', '$board', '$thread', \"$post\", '$signature');");
mysql_query("UPDATE `threads` SET `last` = '$time' WHERE `id` = '$thread'");
$main_content .= "Your reply has been added.";
}
if(!empty($action)){
if($logged){
$main_content .= "<table width='100%'><form method='post' action='?subtopic=thread&id=$thread'>";
$main_content .= "<td class='board' width='20%'>Choose character</td><td class='board'><select name='character'>";
$sql = mysql_query("SELECT * FROM `players` WHERE `account_id` = '$account_logged'");
while($cmd2 = mysql_fetch_array($sql)){
$name = $cmd2['name'];
$main_content .= "<option>$name</option>";
}
$main_content .= "</select></td><tr></tr>";
$main_content .= "<td class='light'><b>Post subject</b></td><td class='light'><input size='60' type='text' name='subject'> (Optional)</td><tr></tr>";
$main_content .= "<td class='board'>Post icon</td><td class='board'>
<input type='radio' value='1' name='icon'><img src='forum/images/1.gif'>
<input type='radio' value='2' name='icon'><img src='forum/images/2.gif'>
<input type='radio' value='3' name='icon'><img src='forum/images/3.gif'>
<input type='radio' value='4' name='icon'><img src='forum/images/4.gif'>
<input type='radio' value='5' name='icon'><img src='forum/images/5.gif'>
<input type='radio' value='6' name='icon'><img src='forum/images/6.gif'>
<input type='radio' value='7' name='icon'><img src='forum/images/7.gif'><br>
<input type='radio' value='8' name='icon'><img src='forum/images/8.gif'>
<input type='radio' value='9' name='icon'><img src='forum/images/9.gif'>
<input type='radio' value='10' name='icon'><img src='forum/images/10.gif'>
<input type='radio' value='11' name='icon'><img src='forum/images/11.gif'>
<input type='radio' value='12' name='icon'><img src='forum/images/12.gif'>
<input type='radio' value='13' name='icon'><img src='forum/images/13.gif'>
<input type='radio' value='14' name='icon'><img src='forum/images/14.gif'><br>
<input type='radio' value='15' name='icon'><img src='forum/images/15.gif'>
<input type='radio' value='16' name='icon'><img src='forum/images/16.gif'>
<input type='radio' value='17' name='icon'><img src='forum/images/17.gif'><br>
<input type='radio' value='0' checked='checked' name='icon'>No icon
</td><tr></tr>";
$main_content .= "<td class='light' valign='top'><b>Message</b><br><br><br>How to use smileys:<br>
<img src='forum/images/1.gif'> :p<br>
<img src='forum/images/2.gif'> :eek:<br>
<img src='forum/images/3.gif'> :rolleyes:<br>
<img src='forum/images/6.gif'> ;)<br>
<img src='forum/images/7.gif'> :o<br>
<img src='forum/images/8.gif'> :D<br>
<img src='forum/images/9.gif'> :(<br>
<img src='forum/images/10.gif'> :mad:<br>
<img src='forum/images/11.gif'> :)<br>
<img src='forum/images/12.gif'> :cool:<br>
</td><td class='light' valign='top'><textarea style='border: 1px groove black; width: 100%; height: 120px;' name='post'>$post</textarea></td><tr></tr>";
$main_content .= "<td class='board'><b>Options</b></td><td class='board'>
<input type='checkbox' name='disable'> Disable smileys in this post.<br>
<input type='checkbox' name='signature' checked> Include signature
</td><tr></tr>";
$main_content .= "<td></td><td><input type='submit' name='add' value='Post reply'></td></form>";
$main_content .= "</table>";
}else $main_content .= "You need to be logged in to add posts";
}
$sql = mysql_query("SELECT * FROM `threads` WHERE `id` = '$thread'");
$cmd = mysql_fetch_array($sql);
$title = $cmd['name'];
$id = $cmd['id'];
$icon = $cmd['icon'];
$closed = $cmd['closed'];
if(!empty($_SESSION['admin'])){
$stick = $cmd['stick'];
if($stick == 0)
$admin = "<a href=?subtopic=thread&id=$thread&action=2'>Stick this thread.</a>";
else
$admin = "<a href=?subtopic=thread&id=$thread&action=3'>UnStick this thread.</a>";
}
$main_content .= $admin;
$board = $cmd['board'];
if($icon != 0 or !empty($icon)) $icon = "<img src='forum/images/$icon.gif'>"; else $icon = '';
$main_content .= "<table width='100%'><td class='light' style='text-align: left;'><font size='4'>$icon $title</font></td></table>";
$main_content .= "<table width='100%'>";
$main_content .= "<td class='top' width='15%'><font color='#EFEFEF'>Author</font></td><td class='top'><font color='#EFEFEF'>Thread #$id</font></td><tr></tr>";
$sql = mysql_query("SELECT * FROM `posts` WHERE `thread` = '$thread'");
$posts = mysql_num_rows($sql);
$page = (int)$_REQUEST['page'];
if(empty($page) or $page == 0) $page = 1;
$max_pages = ceil($posts/$max_posts);
$now = $page*$max_posts-$max_posts;
$turn = 1;
$prev = $page-1;
$next = $page+1;
$last = $_SESSION['last'];
if($last != $thread){
$sql = mysql_query("SELECT * FROM `threads` WHERE `id` = '$thread'");
$cmd5 = mysql_fetch_array($sql);
$views = $cmd5['views'];
$new = $views+1;
mysql_query("UPDATE `threads` SET `views` = '$new' WHERE `id` = '$thread'");
$_SESSION['last'] = $thread;
}
if($page != 1) $main_content .= "<a href='?subtopic=thread&id=$thread&page=$prev'>< Previous page </a>";
if($page < $max_pages) $main_content .= "<a href='?subtopic=thread&id=$thread&page=$next'> Next Page > </a>";
if($closed != 1) $main_content .= "<a href='?subtopic=thread&id=$thread&action=1'><img src='forum/images/reply.gif'></a>";
$main_content .= "<a href='?subtopic=board&id=$board'><br>Go to board</a>";
$sql = mysql_query("SELECT * FROM `posts` WHERE `thread` = '$thread' ORDER BY `id` ASC LIMIT $now, $max_posts");
while($cmd = mysql_fetch_array($sql)){
$author = $cmd['author'];
$date = $cmd['date'];
$post = nl2br($cmd['post']);
$sig = $cmd['signature'];
$player = loadPlayerByName($author);
$vocation = $player['vocation'];
$id = $cmd['id'];
$level = $player['level'];
$icon = $cmd['icon'];
if($sig != 0) { $sig = loadPlayerByName($author); $signature = nl2br($sig['comment']);
if(empty($signature)) $full = ''; else {
if (strlen($signature) > 20) {
$description = substr($description, 0, 20)."...";
}
$full = "<hr>$signature";
}} else $full = '';
$posts = mysql_num_rows(mysql_query("SELECT * FROM `posts` WHERE `author` = '$author'"));
if($turn == 1) { $class = "light"; $turn = 2;} else { $class = "board"; $turn = 1;}
if($icon != 0) $icon = "<img src='forum/images/$icon.gif'>"; else $icon = '';
if($vocation == 0) $voc = "None"; else if($vocation == 1) $voc = "Sorcerer"; else if($vocation == 2) $voc = "Druid"; else if($vocation == 3) $voc = "Paladin"; else if($vocation == 4) $voc = "Knight"; else if($vocation == 5) $voc = "Master Sorcerer"; else if($vocation == 6) $voc = "Elder Druid"; else if($vocation == 7) $voc = "Royal Paladin"; else if($vocation == 8) $voc = "Elite Knight"; else $voc = "Unknown";
if(!empty($_SESSION['admin']))
$admin = "<a href='?subtopic=thread&id=$thread&action=1&post=$id'>Delete this post</a>";
$main_content .= "<td valign='top' class='$class' style='text-align: left;'><a href='?subtopic=characters&name=$author'>$author</a><br><br><font size='1'>Inhabitant of $world_name<br>Profession: $voc<br>Level: $level<br><br>Posts: $posts<br><br>$date<br>$admin</font></td><td class='$class' valign='top' >$icon <b> $title</b><hr>$post $full</td><tr></tr>";
}
$main_content .= "</table>";
?>
htdocs/forum/board.php:
Code:
<style>
.top {
background:#505050;
font-size: 7pt;
font-weight: bold;
font-family: Verdana,Arial,Times New Roman,sans-serif;
text-align: center;
color: #EFEFEF;
}
.board {
background-color: #d4c0a1;
text-align: center;
color: #5A2800;
}
.light {
background-color: #f1e0c6;
text-align: center;
color: #5A2800;
}
img {
border: none;
}
</style>
<?
include("forum/config.php");
include("forum/functions.php");
if($install)exit;
$date = timenow();
if(!$logged) $main_content .= "You are <b>not</b> logged in. <a href='?subtopic=accountmanagement'>Log in</a> to post on the forum.<br>";
$board = (int)$_GET['id'];
$row = mysql_num_rows(mysql_query("SELECT * FROM `forums` WHERE `id` = '$board'"));
if($row == 0){$main_content .= "Could not find board."; return;}
$sql = mysql_query("SELECT * FROM `forums` WHERE `id` = '$board'");
$cmd = mysql_fetch_array($sql);
$access = $cmd['access'];
if($access > 0){
if(!$logged) { $main_content .= "You cannot view this board."; return; }
else{
$user = loadAccountById($account_logged);
$user_access = $user['page_access'];
if($access > $user_access) { $main_content .= "You cannot view this board."; return; }
}
}
$main_content .= "<div align='right'>Current time: $date</div>";
//NEW TOPIC
$action = (int)$_REQUEST['action'];
if(!empty($action)){
if(!empty($_SESSION['admin'])){
if($action == 2){
$id = (int)$_GET['post'];
deleteThread($id);
$main_content .= "Thread has been removed.";
}
}
}
$action = (int)$_REQUEST['action'];
if(isset($_POST['add'])){
$icon = (int)$_POST['icon'];
$post = stripslashes(htmlentities($_POST['post']));
$subject = stripslashes(htmlentities($_POST['subject']));
$character = stripslashes(htmlentities($_POST['character']));
$disable = $_POST['disable'];
$signature = $_POST['signature'];
if(empty($disable)) $disable = 0; else $disable = 1;
if(empty($signature)) $signature = 0; else $signature = 1;
if(empty($subject)) { $main_content .= "Subject cannot be empty."; return;}
if(empty($post)) { $main_content .= "Post cannot be empty."; return;}
$sql = mysql_query("SELECT * FROM `forums` WHERE `id` = '$board'");
$cmd4 = mysql_fetch_array($sql);
$access = $cmd4['access'];
$close = $cmd4['closed'];
$account = loadAccountById($account_logged);
$user_access = $account['page_access'];
if($access > $user_access) {$main_content .= "You don't have permission to post in this thread."; return;}
if($closed == 1){ $main_content .= "This board is closed."; return;}
$sql = mysql_query("SELECT * FROM `players` WHERE `name` = '$character' AND `account_id` = '$account_logged'");
$row = mysql_num_rows($sql);
if($row == 0){ $main_content .= "Could not find character."; return;}
$date = timenow();
$time = time();
if(empty($disable)){
$post = str_replace(":p", "<img src='forum/images/1.gif'>", $post);
$post = str_replace(":eek:", "<img src='forum/images/2.gif'>", $post);
$post = str_replace(":rolleyes:", "<img src='forum/images/3.gif'>", $post);
$post = str_replace(";)", "<img src='forum/images/6.gif'>", $post);
$post = str_replace(":o", "<img src='forum/images/7.gif'>", $post);
$post = str_replace(":D", "<img src='forum/images/8.gif'>", $post);
$post = str_replace(":(", "<img src='forum/images/9.gif'>", $post);
$post = str_replace(":mad:", "<img src='forum/images/10.gif'>", $post);
$post = str_replace(":)", "<img src='forum/images/11.gif'>", $post);
$post = str_replace(":cool:", "<img src='forum/images/12.gif'>", $post);
}
$date = timenow();
$time = time();
mysql_query("INSERT INTO `threads` VALUES('', '$subject', '$icon', '0', '0', '$date', '$time', '$character', \"$board\", '0', '$time');");
$sql = mysql_query("SELECT * FROM `threads` ORDER BY `id` DESC");
$cmd = mysql_fetch_array($sql);
$id = $cmd['id'];
mysql_query("INSERT INTO `posts` VALUES('', '$subject', '$icon', '$date', '$time', '$character', '$board', '$id', \"$post\", '$signature');");
$main_content .= "You have made new thread.";
}
if(!empty($action)){
if($logged){
$main_content .= "<table width='100%'><form method='post' action='?subtopic=board&id=$board'>";
$main_content .= "<td class='board' style='text-align: left;' width='20%'>Choose character</td><td style='text-align: left;' class='board'><select name='character'>";
$sql = mysql_query("SELECT * FROM `players` WHERE `account_id` = '$account_logged'");
while($cmd2 = mysql_fetch_array($sql)){
$name = $cmd2['name'];
$main_content .= "<option>$name</option>";
}
$main_content .= "</select></td><tr></tr>";
$main_content .= "<td style='text-align: left;' class='light'><b>Post subject</b></td><td style='text-align: left;' class='light'><input size='60' type='text' name='subject'></td><tr></tr>";
$main_content .= "<td style='text-align: left;' class='board'>Post icon</td><td style='text-align: left;' class='board'>
<input type='radio' value='1' name='icon'><img src='forum/images/1.gif'>
<input type='radio' value='2' name='icon'><img src='forum/images/2.gif'>
<input type='radio' value='3' name='icon'><img src='forum/images/3.gif'>
<input type='radio' value='4' name='icon'><img src='forum/images/4.gif'>
<input type='radio' value='5' name='icon'><img src='forum/images/5.gif'>
<input type='radio' value='6' name='icon'><img src='forum/images/6.gif'>
<input type='radio' value='7' name='icon'><img src='forum/images/7.gif'><br>
<input type='radio' value='8' name='icon'><img src='forum/images/8.gif'>
<input type='radio' value='9' name='icon'><img src='forum/images/9.gif'>
<input type='radio' value='10' name='icon'><img src='forum/images/10.gif'>
<input type='radio' value='11' name='icon'><img src='forum/images/11.gif'>
<input type='radio' value='12' name='icon'><img src='forum/images/12.gif'>
<input type='radio' value='13' name='icon'><img src='forum/images/13.gif'>
<input type='radio' value='14' name='icon'><img src='forum/images/14.gif'><br>
<input type='radio' value='15' name='icon'><img src='forum/images/15.gif'>
<input type='radio' value='16' name='icon'><img src='forum/images/16.gif'>
<input type='radio' value='17' name='icon'><img src='forum/images/17.gif'><br>
<input type='radio' value='0' checked='checked' name='icon'>No icon
</td><tr></tr>";
$main_content .= "<td style='text-align: left;' class='light' valign='top'><b>Message</b><br><br><br>How to use smileys:<br>
<img src='forum/images/1.gif'> :p<br>
<img src='forum/images/2.gif'> :eek:<br>
<img src='forum/images/3.gif'> :rolleyes:<br>
<img src='forum/images/6.gif'> ;)<br>
<img src='forum/images/7.gif'> :o<br>
<img src='forum/images/8.gif'> :D<br>
<img src='forum/images/9.gif'> :(<br>
<img src='forum/images/10.gif'> :mad:<br>
<img src='forum/images/11.gif'> :)<br>
<img src='forum/images/12.gif'> :cool:<br>
</td><td style='text-align: left;' class='light' valign='top'><textarea style='border: 1px groove black; width: 100%; height: 120px;' name='post'>$post</textarea></td><tr></tr>";
$main_content .= "<td style='text-align: left;' class='board'><b>Options</b></td><td style='text-align: left;' class='board'>
<input type='checkbox' name='disable'> Disable smileys in this post.<br>
<input type='checkbox' name='signature' checked> Include signature
</td><tr></tr>";
$main_content .= "<td></td><td><input type='submit' name='add' value='Post reply'></td></form>";
$main_content .= "</table>";
}else $main_content .= "You need to be logged in to add posts";
}
$main_content .= "<table cellspacing='1' width='100%'><td width='5%' class='top'></td><td width='5%' class='top'></td><td width='50%' class='top'><font color='#EFEFEF'>Thread</font></td><td width='10%' class='top'><font color='#EFEFEF'>Thread Starter</font></td><td width='10%' class='top'><font color='#EFEFEF'>Replies</font></td><td width='10%' class='top'><font color='#EFEFEF'>Views</font></td><td width='30%' class='top'><font color='#EFEFEF'>Last Post</font></td><tr></tr>";
//STICKED THREADS!
$sql = mysql_query("SELECT * FROM `threads` WHERE `board` = '$board' AND `stick` = '1'");
$row = mysql_num_rows($sql);
while($cmd = mysql_fetch_array($sql)){
$title = $cmd['name'];
$author = $cmd['author'];
$views = $cmd['views'];
$icon = $cmd['icon'];
$closed = $cmd['closed'];
$id = $cmd['id'];
$replies = mysql_num_rows(mysql_query("SELECT * FROM `posts` WHERE `thread` = '$id'"));
if($replies > 15) $hot = "<img src='forum/images/hot.gif'>";
if($icon == 0) $close = ""; else $close = "<img src='forum/images/$icon.gif'>";
if($closed == 1)$close = "<img src='forum/images/closed.gif'>";
$last = mysql_query("SELECT * FROM `posts` WHERE `thread` = '$id' ORDER BY `id` DESC LIMIT 1");
$cmd1 = mysql_fetch_array($last);
$last_author = $cmd1['author'];
$last_date = $cmd1['date'];
$last = "<a href='?subtopic=thread&id=$id'><img src='forum/images/arrow.gif'></a> $last_date <br>by <a href='?subtopic=characters&name=$last_author'>$last_author</a>";
if(!empty($_SESSION['admin']))
$admin = "<a href='?subtopic=board&id=$board&action=2&post=$id'>Delete this thread</a>";
$main_content .= "<td class='board'>$close</td><td class='board'>$hot</td><td class='light' style='text-align: left;'><a href='?subtopic=thread&id=$id'><b>Sticked:</b> $title</a><br>$admin</td><td class='board'><a href='?subtopic=characters&name=$author'>$author</a></td><td class='light'>$replies</td><td class='light'>$views</td><td class='light'>$last</td><tr></tr>";
}
$page = (int)$_GET['page'];
//NORMAL THREADS
$sql = mysql_query("SELECT * FROM `threads` WHERE `board` = '$board' AND `stick` = '0'");
$row = mysql_num_rows($sql);
$max_pages = ceil($row/$max_threads);
$page = (int)$_REQUEST['page'];
if(empty($page))$page = 1;
if($page == 0)$page = 1;
$now = $page*$max_threads-$max_threads;
$prev = $page-1;
$next = $page+1;
$main_content .= "<a href='?subtopic=forum'>Go to forums</a><br>";
if($max_pages > 1) $main_content .= "<form method='post' action='index.php?subtopic=board&id=$board'><input type='text' size='1' value='$page' name='page'><input type='submit' value='Go'></form><br>";
if($page != 1) $main_content .= "<br><a href='?subtopic=board&id=$board&page=$prev'>< Previous </a>";
if($page < $max_pages) $main_content .= "<a href='?subtopic=board&id=$board&page=$next'>Next ></a>";
$main_content .= "<a href='?subtopic=board&id=$board&action=1'><img src='forum/images/new.gif'></a>";
$sql = mysql_query("SELECT * FROM `threads` WHERE `board` = '$board' AND `stick` = '0' ORDER BY `last` DESC LIMIT $now, $max_threads");
if($row == 0) $main_content .= "<b>No posts in this board.</b>"; else {
while($cmd = mysql_fetch_array($sql)){
$title = $cmd['name'];
$author = $cmd['author'];
$views = $cmd['views'];
$icon = $cmd['icon'];
$closed = $cmd['closed'];
$id = $cmd['id'];
$replies = mysql_num_rows(mysql_query("SELECT * FROM `posts` WHERE `thread` = '$id'"));
if($replies > 15) $hot = "<img src='forum/images/hot.gif'>"; else $hot = '';
if($icon == 0) $close = ""; else $close = "<img src='forum/images/$icon.gif'>";
if($closed == 1)$close = "<img src='forum/images/closed.gif'>";
$last = mysql_query("SELECT * FROM `posts` WHERE `thread` = '$id' ORDER BY `id` DESC LIMIT 1");
$cmd1 = mysql_fetch_array($last);
$last_author = $cmd1['author'];
$last_date = $cmd1['date'];
$last = "<a href='?subtopic=thread&id=$id'><img src='forum/images/arrow.gif'></a> $last_date <br>by <a href='?subtopic=characters&name=$last_author'>$last_author</a>";
if(!empty($_SESSION['admin']))
$admin = "<a href='?subtopic=board&id=$board&action=2&post=$id'>Delete this thread</a>";
$main_content .= "<td class='board'>$close</td><td class='board'>$hot</td><td class='light' style='text-align: left;'><a href='?subtopic=thread&id=$id'>$title</a><br>$admin</td><td class='board'><a href='?subtopic=characters&name=$author'>$author</a></td><td class='light'>$replies</td><td class='light'>$views</td><td class='light'>$last</td><tr></tr>";
}
}
$main_content .= "</table>";
$main_content .= "Paxton's Web Development";
?>
htdocs/forum/functions.php
Code:
<?
function timenow(){
$day = date("m.d.y");
$time = date("H:i:s");
$fulldate = "$day $time";
return $fulldate;
}
function loadPlayerByName($name) {
$sql = mysql_query("SELECT * FROM `players` WHERE `name` = '$name'");
return mysql_fetch_array($sql);
}
function setPlayer($name, $value, $new){
if(is_numeric($name)){
$sql = mysql_query("SELECT * FROM `players` WHERE `id` = '$name'");
$row = mysql_num_rows($sql);
if($row == 1)
{
$sql = mysql_query("UPDATE `players` SET `$value` = '$new' WHERE `id` = '$name'");
return true;
}else
{
return false;
}
}
else
{
$sql = mysql_query("SELECT * FROM `players` WHERE `name` = '$name'");
$row = mysql_num_rows($sql);
if($row == 1)
{
$sql = mysql_query("UPDATE `players` SET `$value` = '$new' WHERE `name` = '$name'");
return true;
}else
{
return false;
}
}
}
function account($name, $field){
if(is_numeric($name)){
$sql = mysql_query("SELECT * FROM `accounts` WHERE `id` = '$name'");
$row = mysql_num_rows($sql);
if($row >= 1)
{
$cmd = mysql_fetch_array($sql);
return $cmd["$field"];
}
else
{
$sql = mysql_query("SELECT * FROM `accounts` WHERE `name` = '$name'");
$row = mysql_num_rows($sql);
if($row >= 1)
{
$cmd = mysql_fetch_array($sql);
return $cmd["$field"];
}
else
{
return false;
}
}
}
else
{
$sql = mysql_query("SELECT * FROM `accounts` WHERE `name` = '$name'");
$row = mysql_num_rows($sql);
if($row >= 1)
{
$cmd = mysql_fetch_array($sql);
return $cmd["$field"];
}
}
}
function setAccount($name, $field, $new){
if(is_numeric($name)){
$sql = mysql_query("SELECT * FROM `accounts` WHERE `id` = '$name'");
$row = mysql_num_rows($sql);
if($row >= 1)
{
$sql = mysql_query("UPDATE `accounts` SET `$field` = '$new' WHERE `id` = '$name'");
return true;
}
else
{
$sql = mysql_query("SELECT * FROM `accounts` WHERE `name` = '$name'");
$row = mysql_num_rows($sql);
if($row >= 1)
{
$sql = mysql_query("UPDATE `accounts` SET `$field` = '$new' WHERE `name` = '$name'");
return true;
}
else
{
return false;
}
}
}
else
{
$sql = mysql_query("SELECT * FROM `accounts` WHERE `name` = '$name'");
$row = mysql_num_rows($sql);
if($row >= 1)
{
$sql = mysql_query("UPDATE `accounts` SET `$field` = '$new' WHERE `name` = '$name'");
return true;
}
}
}
function loadAccountById($account) {
$sql = mysql_query("SELECT * FROM `accounts` WHERE `id` = '$account'");
return mysql_fetch_array($sql);
}
function deleteBoard($id){
mysql_query("DELETE FROM `posts` WHERE `board` = '$id'");
mysql_query("DELETE FROM `threads` WHERE `board` = '$id'");
mysql_query("DELETE FROM `forums` WHERE `id` = '$id'");
}
function deleteThread($id){
mysql_query("DELETE FROM `posts` WHERE `thread` = '$id'");
mysql_query("DELETE FROM `threads` WHERE `id` = '$id'");
}
function deletePost($id){
mysql_query("DELETE FROM `posts` WHERE `id` = '$id'");
}
?>
Last edited: