• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Solved Gesior forum bug! (help!)

Oscar Lyis

Oscar Lyis

Donator
Joined
May 30, 2008
Messages
633
Reaction score
1
Location
Sweden
This is how it looks:

fotrm.jpg

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>";
?>
htdocs/forum/tread.php:

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:
Sort by date Sort by votes

Similar threads

Czorcik
  • Question
Problem with Gesior Acc HIGHSCORE (offline player)
Replies
2
Views
484
Czorcik
Czorcik
ghunalma
  • Question
AAC [Znote AAC] admin_news dont upload images
Replies
3
Views
335
ghunalma
ghunalma
V
  • Question
AAC reset system geisor
Replies
0
Views
293
vitorelias1
V
O
  • Question
help name of the invisible towns in myacc
Replies
2
Views
411
tobi132
T
blokerzinha
  • Question
Problem with the wrong player appearing as top even though he is not. Znote
Replies
1
Views
350
blokerzinha
blokerzinha
3221920
  • Question
AAC [HELP] MyAAC Headline not work
Replies
4
Views
517
3221920
3221920
Back
Top