Simple forum script

widnet · Nov 10, 2009

small fix
*Topic's in messanege
*Added page list in down page

PHP:

<?PHP
/*
CREATE TABLE `z_forum` (
  `id` int(11) NOT NULL auto_increment,
  `first_post` int(11) NOT NULL default '0',
  `last_post` int(11) NOT NULL default '0',
  `section` int(3) NOT NULL default '0',
  `replies` int(20) NOT NULL default '0',
  `views` int(20) NOT NULL default '0',
  `author_aid` int(20) NOT NULL default '0',
  `author_guid` int(20) NOT NULL default '0',
  `post_text` text NOT NULL,
  `post_topic` varchar(255) NOT NULL,
  `post_smile` tinyint(1) NOT NULL default '0',
  `post_date` int(20) NOT NULL default '0',
  `last_edit_aid` int(20) NOT NULL default '0',
  `edit_date` int(20) NOT NULL default '0',
  `post_ip` varchar(32) NOT NULL default '0.0.0.0',
  PRIMARY KEY  (`id`),
  KEY `section` (`section`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
*/
// CONFIG
$level_limit = 30; // minimum 1 character with 50 lvl on account to post
$post_interval = 20; // 30 seconds between posts
$group_not_blocked = 1; // group id of player that can always post, remove post, remove threads
$posts_per_page = 20;
$threads_per_page = 20;
$sections = array(1 => 'News', 2 => '<b>Skargi na obsluge</b>', 3 => 'Poradniki', 4 => 'Pictures', 5 => 'Bug Report', 6 => 'Hyde Park');
$sections_desc = array(1 => 'Tutaj mozna komentowac newsy.', 2 => 'Tu mozesz zglaszac skargi na obsluge', 3 => 'Poradniki np.Jak kupic domek', 4 => 'Tematy z zdjeciami z gry', 5 => 'Raporty bledow w grze/na stronie', 6 => 'O wszystkim i o niczym');
// END
function canPost($account)
{
	if($account->isLoaded())
		if(!$account->isBanned())
		{
			$SQL = $GLOBALS['SQL'];
			$level_limit = $GLOBALS['level_limit'];
			$player = $SQL->query("SELECT `level` FROM `players` WHERE `account_id` = ".$SQL->quote($account->getId())." ORDER BY `level` DESC")->fetch();
			if($player['level'] >= $level_limit)
				return true;
		}
	return false;
}

function replaceSmile($text, $smile)
{
	$smileys = array(';D' => 1, ':D' => 1, ':cool:' => 2, ';cool;' => 2, ':ekk:' => 3, ';ekk;' => 3, ';o' => 4, ';O' => 4, ':o' => 4, ':O' => 4, ':(' => 5, ';(' => 5, ':mad:' => 6, ';mad;' => 6, ';rolleyes;' => 7, ':rolleyes:' => 7, ':)' => 8, ';d' => 9, ':d' => 9, ';)' => 10);
	if($smile == 1)
		return $text;
	else
	{
		foreach($smileys as $search => $replace)
			$text = str_replace($search, '<img src="images/smile/'.$replace.'.gif" />', $text);
		return $text;
	}
}

function replaceAll($text, $smile)
{
	$rows = 0;
	while(stripos($text, '[code]') !== false && stripos($text, '[/code]') !== false )
	{
		$code = substr($text, stripos($text, '[code]')+6, stripos($text, '[/code]') - stripos($text, '[code]') - 6);
		if(!is_int($rows / 2)) { $bgcolor = 'ABED25'; } else { $bgcolor = '23ED25'; } $rows++;
		$text = str_ireplace('[code]'.$code.'[/code]', '<i>Code:</i><br /><table cellpadding="0" style="background-color: #'.$bgcolor.'; width: 480px; border-style: dotted; border-color: #CCCCCC; border-width: 2px"><tr><td>'.$code.'</td></tr></table>', $text);
	}
	$rows = 0;
	while(stripos($text, '[quote]') !== false && stripos($text, '[/quote]') !== false )
	{
		$quote = substr($text, stripos($text, '[quote]')+7, stripos($text, '[/quote]') - stripos($text, '[quote]') - 7);
		if(!is_int($rows / 2)) { $bgcolor = 'AAAAAA'; } else { $bgcolor = 'CCCCCC'; } $rows++;
		$text = str_ireplace('[quote]'.$quote.'[/quote]', '<table cellpadding="0" style="background-color: #'.$bgcolor.'; width: 480px; border-style: dotted; border-color: #007900; border-width: 2px"><tr><td>'.$quote.'</td></tr></table>', $text);
	}
	$rows = 0;
	while(stripos($text, '[url]') !== false && stripos($text, '[/url]') !== false )
	{
		$url = substr($text, stripos($text, '[url]')+5, stripos($text, '[/url]') - stripos($text, '[url]') - 5);
		$text = str_ireplace('[url]'.$url.'[/url]', '<a href="'.$url.'" target="_blank">'.$url.'</a>', $text);
	}
	while(stripos($text, '[player]') !== false && stripos($text, '[/player]') !== false )
	{
		$player = substr($text, stripos($text, '[player]')+8, stripos($text, '[/player]') - stripos($text, '[player]') - 8);
		$text = str_ireplace('[player]'.$player.'[/player]', '<a href="?subtopic=characters&name='.urlencode($player).'">'.$player.'</a>', $text);
	}
	while(stripos($text, '[img]') !== false && stripos($text, '[/img]') !== false )
	{
		$img = substr($text, stripos($text, '[img]')+5, stripos($text, '[/img]') - stripos($text, '[img]') - 5);
		$text = str_ireplace('[img]'.$img.'[/img]', '<img src="'.$img.'">', $text);
	}
	while(stripos($text, '[b]') !== false && stripos($text, '[/b]') !== false )
	{
		$b = substr($text, stripos($text, '[b]')+3, stripos($text, '[/b]') - stripos($text, '[b]') - 3);
		$text = str_ireplace('[b]'.$b.'[/b]', '<b>'.$b.'</b>', $text);
	}
	while(stripos($text, '[i]') !== false && stripos($text, '[/i]') !== false )
	{
		$i = substr($text, stripos($text, '[i]')+3, stripos($text, '[/i]') - stripos($text, '[i]') - 3);
		$text = str_ireplace('[i]'.$i.'[/i]', '<i>'.$i.'</i>', $text);
	}
	while(stripos($text, '[u]') !== false && stripos($text, '[/u]') !== false )
	{
		$u = substr($text, stripos($text, '[u]')+3, stripos($text, '[/u]') - stripos($text, '[u]') - 3);
		$text = str_ireplace('[u]'.$u.'[/u]', '<u>'.$u.'</u>', $text);
	}
	return replaceSmile($text, $smile);
}
function codeLower($text)
{
	return str_ireplace(array('[b]', '[i]', '[u]', '[/b]', '[/i]', '[/u]', '[url]', '[player]', '[img]', '[code]', '[quote]', '[/url]', '[/player]', '[/img]', '[/code]', '[/quote]'), array('[b]', '[i]', '[u]', '[/b]', '[/i]', '[/u]', '[url]', '[player]', '[img]', '[code]', '[quote]', '[/url]', '[/player]', '[/img]', '[/code]', '[/quote]'), $text);
}
function showPost($topic, $text, $smile)
{
	$text = nl2br($text);
	$post = '';
	if(!empty($topic))
		$post .= '<b>'.replaceSmile($topic, $smile).'</b><hr />';
	$post .= replaceAll($text, $smile);
	return $post;
}
if(!$logged)
	$main_content .=  'You are not logged in. <a href="?subtopic=accountmanagement">Log in</a> to post on the forum.<br /><br />';

if($action == '')
{
	$main_content .= '<b>Boards</b>';
	$main_content .= '<table width="100%"><tr bgcolor="'.$config['site']['vdarkborder'].'"><td><font color="white" size="1"><b>Board</b></font></td><td><font color="white" size="1"><b>Posts</b></font></td><td><font color="white" size="1"><b>Threads</b></font></td><td align="center"><font color="white" size="1"><b>Last Post</b></font></td></tr>';
	$info = $SQL->query("SELECT `section`, COUNT(`id`) AS 'threads', SUM(`replies`) AS 'replies' FROM `z_forum` WHERE `first_post` = `id` GROUP BY `section`")->fetchAll();
	foreach($info as $data)
		$counters[$data['section']] = array('threads' => $data['threads'], 'posts' => $data['replies'] + $data['threads']);
	foreach($sections as $id => $section)
	{
		$last_post = $SQL->query("SELECT `players`.`name`, `z_forum`.`post_date` FROM `players`, `z_forum` WHERE `z_forum`.`section` = ".(int) $id." AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 1")->fetch();
		if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
		$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><a href="?subtopic=forum&action=show_board&id='.$id.'">'.$section.'</a><br /><small>'.$sections_desc[$id].'</small></td><td>'.(int) $counters[$id]['posts'].'</td><td>'.(int) $counters[$id]['threads'].'</td><td>';
		if(isset($last_post['name']))
			$main_content .= date('d.m.y H:i:s', $last_post['post_date']).'<br />by <a href="?subtopic=characters&name='.urlencode($last_post['name']).'">'.$last_post['name'].'</a>';
		else
			$main_content .= 'No posts';
		$main_content .= '</td></tr>';
		
	}
	$main_content .= '</table>';
}

if($action == 'show_board')
{
	$section_id = (int) $_REQUEST['id'];
	$page = (int) $_REQUEST['page'];
	$threads_count = $SQL->query("SELECT COUNT(`z_forum`.`id`) AS threads_count FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`section` = ".(int) $section_id." AND `z_forum`.`first_post` = `z_forum`.`id`")->fetch();
	for($i = 0; $i < $threads_count['threads_count'] / $threads_per_page; $i++)
	{
		if($i != $page)
			$links_to_pages .= '<a href="?subtopic=forum&action=show_board&id='.$section_id.'&page='.$i.'">'.($i + 1).'</a> ';
		else
			$links_to_pages .= '<b>'.($i + 1).' </b>';
	}
	$main_content .= '<a href="?subtopic=forum">Boards</a> >> <b>'.$sections[$section_id].'</b><br /><br /><a href="?subtopic=forum&action=new_topic&section_id='.$section_id.'"><img src="images/topic.gif" border="0" /></a><br /><br />Page: '.$links_to_pages.'<br />';
	$last_threads = $SQL->query("SELECT `players`.`name`, `z_forum`.`post_text`, `z_forum`.`post_topic`, `z_forum`.`id`, `z_forum`.`last_post`, `z_forum`.`replies`, `z_forum`.`views`, `z_forum`.`post_date` FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`section` = ".(int) $section_id." AND `z_forum`.`first_post` = `z_forum`.`id` ORDER BY `z_forum`.`last_post` DESC LIMIT ".$threads_per_page." OFFSET ".($page * $threads_per_page))->fetchAll();
	if(isset($last_threads[0]))
	{
		$main_content .= '<table width="100%"><tr bgcolor="'.$config['site']['vdarkborder'].'" align="center"><td><font color="white" size="1"><b>Thread</b></font></td><td><font color="white" size="1"><b>Thread Starter</b></font></td><td><font color="white" size="1"><b>Replies</b></font></td><td><font color="white" size="1"><b>Views</b></font></td><td><font color="white" size="1"><b>Last Post</b></font></td></tr>';
		foreach($last_threads as $thread)
		{
			if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
			$main_content .= '<tr bgcolor="'.$bgcolor.'"><td>';
			if($logged && $group_id_of_acc_logged >= $group_not_blocked)
				$main_content .= '<a href="?subtopic=forum&action=remove_post&id='.$thread['id'].'" onclick="return confirm(\'Are you sure you want remove thread > '.$thread['post_topic'].' <?\')"><font color="red">[REMOVE]</font></a>  ';
			$main_content .= '<a href="?subtopic=forum&action=show_thread&id='.$thread['id'].'">'.htmlspecialchars($thread['post_topic']).'</a><br /><small>'.htmlspecialchars(substr($thread['post_text'], 0, 50)).'...</small></td><td><a href="?subtopic=characters&name='.urlencode($thread['name']).'">'.$thread['name'].'</a></td><td>'.(int) $thread['replies'].'</td><td>'.(int) $thread['views'].'</td><td>';
			if($thread['last_post'] > 0)
			{
				$last_post = $SQL->query("SELECT `players`.`name`, `z_forum`.`post_date` FROM `players`, `z_forum` WHERE `z_forum`.`first_post` = ".(int) $thread['id']." AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 1")->fetch();
				if(isset($last_post['name']))
					$main_content .= date('d.m.y H:i:s', $last_post['post_date']).'<br />by <a href="?subtopic=characters&name='.urlencode($last_post['name']).'">'.$last_post['name'].'</a>';
				else
					$main_content .= 'No posts.';
			}
			else
				$main_content .= date('d.m.y H:i:s', $thread['post_date']).'<br />by <a href="?subtopic=characters&name='.urlencode($thread['name']).'">'.$thread['name'].'</a>';
			$main_content .= '</td></tr>';
		}
		$main_content .= '</table><br /><a href="?subtopic=forum&action=new_topic&section_id='.$section_id.'"><img src="images/topic.gif" border="0" /></a>';
	}
	else
		$main_content .= '<h3>No threads in this board.</h3>';
}
if($action == 'show_thread')
{
	$thread_id = (int) $_REQUEST['id'];
	$page = (int) $_REQUEST['page'];
	$thread_name = $SQL->query("SELECT `players`.`name`, `z_forum`.`post_topic` FROM `players`, `z_forum` WHERE `z_forum`.`first_post` = ".(int) $thread_id." AND `z_forum`.`id` = `z_forum`.`first_post` AND `players`.`id` = `z_forum`.`author_guid` LIMIT 1")->fetch();
	if(!empty($thread_name['name']))
	{
		$posts_count = $SQL->query("SELECT COUNT(`z_forum`.`id`) AS posts_count FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`first_post` = ".(int) $thread_id)->fetch();
		for($i = 0; $i < $posts_count['posts_count'] / $threads_per_page; $i++)
		{
			if($i != $page)
				$links_to_pages .= '<a href="?subtopic=forum&action=show_thread&id='.$thread_id.'&page='.$i.'">'.($i + 1).'</a> ';
			else
				$links_to_pages .= '<b>'.($i + 1).' </b>';
		}
		$threads = $SQL->query("SELECT `players`.`name`, `players`.`account_id`, `players`.`world_id`, `players`.`rank_id`, `players`.`vocation`, `players`.`promotion`, `players`.`level`, `z_forum`.`id`,`z_forum`.`first_post`, `z_forum`.`section`,`z_forum`.`post_text`, `z_forum`.`post_topic`, `z_forum`.`post_date`, `z_forum`.`post_smile`, `z_forum`.`author_aid`, `z_forum`.`author_guid`, `z_forum`.`last_edit_aid`, `z_forum`.`edit_date` FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`first_post` = ".(int) $thread_id." ORDER BY `z_forum`.`post_date` LIMIT ".$posts_per_page." OFFSET ".($page * $posts_per_page))->fetchAll();
		if(isset($threads[0]['name']))
			$SQL->query("UPDATE `z_forum` SET `views`=`views`+1 WHERE `id` = ".(int) $thread_id);
		$main_content .= '<a href="?subtopic=forum">Boards</a> >> <a href="?subtopic=forum&action=show_board&id='.$threads[0]['section'].'">'.$sections[$threads[0]['section']].'</a> >> <b>'.$thread_name['post_topic'].'</b>';
		$main_content .= '<br /><br /><a href="?subtopic=forum&action=new_post&thread_id='.$thread_id.'"><img src="images/post.gif" border="0" /></a><br /><br />Page: '.$links_to_pages.'<br /><table width="100%"><tr bgcolor="'.$config['site']['lightborder'].'" width="100%"><td colspan="2"><font size="4"><b>'.htmlspecialchars($thread_name['post_topic']).'</b></font><font size="1"><br />by <a href="?subtopic=characters&name='.urlencode($thread_name['name']).'">'.$thread_name['name'].'</a></font></td></tr><tr bgcolor="'.$config['site']['vdarkborder'].'"><td width="200"><font color="white" size="1"><b>Author</b></font></td><td>&nbsp;</td></tr>';
		foreach($threads as $thread)
		{
			if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
			$main_content .= '<tr bgcolor="'.$bgcolor.'"><td valign="top"><a href="?subtopic=characters&name='.urlencode($thread['name']).'">'.$thread['name'].'</a><br /><br /><font size="1">Profession: '.$vocation_name[$thread['world_id']][$thread['promotion']][$thread['vocation']].'<br />Level: '.$thread['level'].'<br />';
			$rank = new OTS_GuildRank();
			$rank->load($thread['rank_id']);
			if($rank->isLoaded())
			{
				$guild = $rank->getGuild();
				if($guild->isLoaded())
					$main_content .= $rank->getName().' of <a href="?subtopic=guilds&action=show&guild='.$guild->getId().'">'.$guild->getName().'</a><br />';
			}
			$posts = $SQL->query("SELECT COUNT(`id`) AS 'posts' FROM `z_forum` WHERE `author_aid`=".(int) $thread['account_id'])->fetch();
			$main_content .= '<br />Posts: '.(int) $posts['posts'].'<br /></font></td><td valign="top">'.showPost(htmlspecialchars($thread['?']), htmlspecialchars($thread['post_text']), $thread['post_smile']).'</td></tr>
			<tr bgcolor="'.$bgcolor.'"><td><font size="1">'.date('d.m.y H:i:s', $thread['post_date']);
			if($thread['edit_date'] > 0)
			{
				if($thread['last_edit_aid'] != $thread['author_aid'])
					$main_content .= '<br />Edited by moderator';
				else
					$main_content .= '<br />Edited by '.$thread['name'];
				$main_content .= '<br />on '.date('d.m.y H:i:s', $thread['edit_date']);
			}
			$main_content .= '</font></td><td>';
			if($logged && $group_id_of_acc_logged >= $group_not_blocked)
				if($thread['first_post'] != $thread['id'])
					$main_content .= '<a href="?subtopic=forum&action=remove_post&id='.$thread['id'].'" onclick="return confirm(\'Are you sure you want remove post of '.$thread['name'].'?\')"><font color="red">REMOVE POST</font></a>';
				else
					$main_content .= '<a href="?subtopic=forum&action=remove_post&id='.$thread['id'].'" onclick="return confirm(\'Are you sure you want remove thread > '.$thread['post_topic'].' <?\')"><font color="red">REMOVE THREAD</font></a>';
			if($logged && ($thread['account_id'] == $account_logged->getId() || $group_id_of_acc_logged >= $group_not_blocked))
				$main_content .= '<br/><a href="?subtopic=forum&action=edit_post&id='.$thread['id'].'">EDIT POST</a>';
			if($logged)
				$main_content .= '<br/><a href="?subtopic=forum&action=new_post&thread_id='.$thread_id.'&quote='.$thread['id'].'">Quote</a>';
			$main_content .= '</td></tr>';
		}
		$main_content .= '</table><br /><a href="?subtopic=forum&action=new_post&thread_id='.$thread_id.'"><img src="images/post.gif" border="0" /></a><br /><center>Pages:<br />'.$links_to_pages.'<br /></center>';
	}
	else
		$main_content .= 'Thread with this ID does not exits.';

}
if($action == 'remove_post')
{
	if($logged && $group_id_of_acc_logged >= $group_not_blocked)
	{
		$id = (int) $_REQUEST['id'];
		$post = $SQL->query("SELECT `id`, `first_post`, `section` FROM `z_forum` WHERE `id` = ".$id." LIMIT 1")->fetch();
		if($post['id'] == $id)
		{
			if($post['id'] == $post['first_post'])
			{
				$SQL->query("DELETE FROM `z_forum` WHERE `first_post` = ".$post['id']);
				header('Location: ?subtopic=forum&action=show_board&id='.$post['section']);
			}
			else
			{
				$post_page = $SQL->query("SELECT COUNT(`z_forum`.`id`) AS posts_count FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`id` < ".$id." AND `z_forum`.`first_post` = ".(int) $post['first_post'])->fetch();
				$page = (int) ceil($post_page['posts_count'] / $threads_per_page) - 1;
				$SQL->query("DELETE FROM `z_forum` WHERE `id` = ".$post['id']);
				header('Location: ?subtopic=forum&action=show_thread&id='.$post['first_post'].'&page='.(int) $page);
			}
		}
		else
			$main_content .= 'Post with ID '.$id.' does not exist.';
	}
	else
		$main_content .= 'You are not logged in or you are not moderator.';
}
if($action == 'new_post')
{
	if($logged)
	{
		if(canPost($account_logged) || $group_id_of_acc_logged >= $group_not_blocked)
		{
			$players_from_account = $SQL->query("SELECT `players`.`name`, `players`.`id` FROM `players` WHERE `players`.`account_id` = ".(int) $account_logged->getId())->fetchAll();
			$thread_id = (int) $_REQUEST['thread_id'];
			$thread = $SQL->query("SELECT `z_forum`.`post_topic`, `z_forum`.`id`, `z_forum`.`section` FROM `z_forum` WHERE `z_forum`.`id` = ".(int) $thread_id." AND `z_forum`.`first_post` = ".(int) $thread_id." LIMIT 1")->fetch();
			$main_content .= '<a href="?subtopic=forum">Boards</a> >> <a href="?subtopic=forum&action=show_board&id='.$thread['section'].'">'.$sections[$thread['section']].'</a> >> <a href="?subtopic=forum&action=show_thread&id='.$thread_id.'">'.$thread['post_topic'].'</a> >> <b>Post new reply</b><br /><h3>'.$thread['post_topic'].'</h3>';
			if(isset($thread['id']))
			{
				$quote = (int) $_REQUEST['quote'];
				$text = stripslashes(trim(codeLower($_REQUEST['text'])));
				$char_id = (int) $_REQUEST['char_id'];
				$post_topic = stripslashes(trim($_REQUEST['topic']));
				$smile = (int) $_REQUEST['smile'];
				$saved = false;
				if(isset($_REQUEST['quote']))
				{
					$quoted_post = $SQL->query("SELECT `players`.`name`, `z_forum`.`post_text`, `z_forum`.`post_date` FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`id` = ".(int) $quote)->fetchAll();
					if(isset($quoted_post[0]['name']))
						$text = '[i]Originally posted by '.$quoted_post[0]['name'].' on '.date('d.m.y H:i:s', $quoted_post[0]['post_date']).':[/i][quote]'.$quoted_post[0]['post_text'].'[/quote]';
				}
				elseif(isset($_REQUEST['save']))
				{
					$lenght = 0;
					for($i = 0; $i <= strlen($text); $i++)
					{
						if(ord($text[$i]) >= 33 && ord($text[$i]) <= 126)
							$lenght++;
					}
					if($lenght < 1 || strlen($text) > 15000)
						$errors[] = 'Too short or too long post (short: '.$lenght.' long: '.strlen($text).' letters). Minimum 1 letter, maximum 15000 letters.';
					if($char_id == 0)
						$errors[] = 'Please select a character.';
					$player_on_account == false;
					if(count($errors) == 0)
					{
						foreach($players_from_account as $player)
							if($char_id == $player['id'])
								$player_on_account = true;
						if(!$player_on_account)
							$errors[] = 'Player with selected ID '.$char_id.' doesn\'t exist or isn\'t on your account';
					}
					if(count($errors) == 0)
					{
						$last_post = $account_logged->getCustomField('last_post');
						if($last_post+$post_interval-time() > 0 && $group_id_of_acc_logged < $group_not_blocked)
							$errors[] = 'You can post one time per '.$post_interval.' seconds. Next post after '.($last_post+$post_interval-time()).' second(s).';
					}
					if(count($errors) == 0)
					{
						$saved = true;
						$account_logged->setCustomField('last_post', time());
						$SQL->query("INSERT INTO `z_forum` (`id` ,`first_post` ,`last_post` ,`section` ,`replies` ,`views` ,`author_aid` ,`author_guid` ,`post_text` ,`post_topic` ,`post_smile` ,`post_date` ,`last_edit_aid` ,`edit_date`, `post_ip`) VALUES ('NULL', '".$thread['id']."', '0', '".$thread['section']."', '0', '0', '".$account_logged->getId()."', '".(int) $char_id."', ".$SQL->quote($text).", ".$SQL->quote($post_topic).", '".(int) $smile."', '".time()."', '0', '0', '".$_SERVER['REMOTE_ADDR']."')");
						$SQL->query("UPDATE `z_forum` SET `replies`=`replies`+1, `last_post`=".time()." WHERE `id` = ".(int) $thread_id);
						$post_page = $SQL->query("SELECT COUNT(`z_forum`.`id`) AS posts_count FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`post_date` <= ".time()." AND `z_forum`.`first_post` = ".(int) $thread['id'])->fetch();
						$page = (int) ceil($post_page['posts_count'] / $threads_per_page) - 1;
						header('Location: ?subtopic=forum&action=show_thread&id='.$thread_id.'&page='.$page);
						$main_content .= '<br />Thank you for posting.<br /><a href="?subtopic=forum&action=show_thread&id='.$thread_id.'">GO BACK TO LAST THREAD</a>';
					}
				}
				if(!$saved)
				{
					if(count($errors) > 0)
					{
						$main_content .= '<font color="red" size="2"><b>Errors occured:</b>';
						foreach($errors as $error)
							$main_content .= '<br />* '.$error;
						$main_content .= '</font><br />';
					}
					$main_content .= '<form action="?" method="POST"><input type="hidden" name="action" value="new_post" /><input type="hidden" name="thread_id" value="'.$thread_id.'" /><input type="hidden" name="subtopic" value="forum" /><input type="hidden" name="save" value="save" /><table width="100%"><tr bgcolor="'.$config['site']['vdarkborder'].'"><td colspan="2"><font color="white"><b>Post New Reply</b></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="180"><b>Character:</b></td><td><select name="char_id"><option value="0">(Choose character)</option>';
					foreach($players_from_account as $player)
					{
						$main_content .= '<option value="'.$player['id'].'"';
						if($player['id'] == $char_id)
							$main_content .= ' selected="selected"';
						$main_content .= '>'.$player['name'].'</option>';
					}
					$main_content .= '</select></td></tr><tr bgcolor="'.$config['site']['lightborder'].'"><td><b>Topic:</b></td><td><input type="text" name="topic" value="'.htmlspecialchars($post_topic).'" size="40" maxlength="60" /> (Optional)</td></tr>
					<tr bgcolor="'.$config['site']['darkborder'].'"><td valign="top"><b>Message:</b><font size="1"><br />You can use:<br />[player]Nick[/player]<br />[url=http://address.com/]Address Search - Find Email and Addresses @ Address.com[/url]<br />[img]http://images.com/images3.gif[/img]<br />[code]Code[/code]<br />[b]<b>Text</b>[/b]<br />[i]<i>Text</i>[/i]<br />[u]<u>Text</u>[/u]<br />and smileys:<br />;) , :) , :D , :( , :rolleyes:<br />:cool: , :eek: , :o , :p</font></td><td><textarea rows="10" cols="60" name="text">'.htmlspecialchars($text).'</textarea><br />(Max. 15,000 letters)</td></tr>
					<tr bgcolor="'.$config['site']['lightborder'].'"><td valign="top">Options:</td><td><label><input type="checkbox" name="smile" value="1"';
					if($smile == 1)
						$main_content .= ' checked="checked"';
					$main_content .= '/>Disable Smileys in This Post </label></td></tr></table><center><input type="submit" value="Post Reply" /></center></form>';
					$threads = $SQL->query("SELECT `players`.`name`, `z_forum`.`post_text`, `z_forum`.`post_topic`, `z_forum`.`post_smile` FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`first_post` = ".(int) $thread_id." ORDER BY `z_forum`.`post_date` DESC LIMIT 10")->fetchAll();
					$main_content .= '<table width="100%"><tr bgcolor="'.$config['site']['vdarkborder'].'"><td colspan="2"><font color="white"><b>Last 5 posts from thread: '.$thread['post_topic'].'</b></font></td></tr>';
					foreach($threads as $thread)
					{
						if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
						$main_content .= '<tr bgcolor="'.$bgcolor.'"><td>'.$thread['name'].'</td><td>'.showPost($thread['post_topic'], $thread['post_text'], $thread['post_smile']).'</td></tr>';
					}
					$main_content .= '</table>';
				}
			}
			else
				$main_content .= 'Thread with ID '.$thread_id.' doesn\'t exist.';
		}
		else
			$main_content .= 'Your account is banned, deleted or you don\'t have any player with level '.$level_limit.' on your account. You can\'t post.';
	}
	else
		$main_content .= 'Login first.';
}

if($action == 'edit_post')
{
	if($logged)
	{
		if(canPost($account_logged) || $group_id_of_acc_logged >= $group_not_blocked)
		{
			$post_id = (int) $_REQUEST['id'];
			$thread = $SQL->query("SELECT `z_forum`.`author_guid`, `z_forum`.`author_aid`, `z_forum`.`first_post`, `z_forum`.`post_topic`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`post_smile`, `z_forum`.`id`, `z_forum`.`section` FROM `z_forum` WHERE `z_forum`.`id` = ".(int) $post_id." LIMIT 1")->fetch();
			if(isset($thread['id']))
			{
				$first_post = $SQL->query("SELECT `z_forum`.`author_guid`, `z_forum`.`author_aid`, `z_forum`.`first_post`, `z_forum`.`post_topic`, `z_forum`.`post_text`, `z_forum`.`post_smile`, `z_forum`.`id`, `z_forum`.`section` FROM `z_forum` WHERE `z_forum`.`id` = ".(int) $thread['first_post']." LIMIT 1")->fetch();
				$main_content .= '<a href="?subtopic=forum">Boards</a> >> <a href="?subtopic=forum&action=show_board&id='.$thread['section'].'">'.$sections[$thread['section']].'</a> >> <a href="?subtopic=forum&action=show_thread&id='.$thread['first_post'].'">'.$first_post['post_topic'].'</a> >> <b>Edit post</b>';
				if($account_logged->getId() == $thread['author_aid'] || $group_id_of_acc_logged >= $group_not_blocked)
				{
					$players_from_account = $SQL->query("SELECT `players`.`name`, `players`.`id` FROM `players` WHERE `players`.`account_id` = ".(int) $account_logged->getId())->fetchAll();
					$saved = false;
					if(isset($_REQUEST['save']))
					{
						$text = stripslashes(trim(codeLower($_REQUEST['text'])));
						$char_id = (int) $_REQUEST['char_id'];
						$post_topic = stripslashes(trim($_REQUEST['topic']));
						$smile = (int) $_REQUEST['smile'];
						$lenght = 0;
						for($i = 0; $i <= strlen($post_topic); $i++)
						{
							if(ord($post_topic[$i]) >= 33 && ord($post_topic[$i]) <= 126)
								$lenght++;
						}
						if(($lenght < 1 || strlen($post_topic) > 60) && $thread['id'] == $thread['first_post'])
							$errors[] = 'Too short or too long topic (short: '.$lenght.' long: '.strlen($post_topic).' letters). Minimum 1 letter, maximum 60 letters.';
						$lenght = 0;
						for($i = 0; $i <= strlen($text); $i++)
						{
							if(ord($text[$i]) >= 33 && ord($text[$i]) <= 126)
								$lenght++;
						}
						if($lenght < 1 || strlen($text) > 15000)
							$errors[] = 'Too short or too long post (short: '.$lenght.' long: '.strlen($text).' letters). Minimum 1 letter, maximum 15000 letters.';
						if($char_id == 0)
							$errors[] = 'Please select a character.';
						if(empty($post_topic) && $thread['id'] == $thread['first_post'])
							$errors[] = 'Thread topic can\'t be empty.';
						$player_on_account == false;
						if(count($errors) == 0)
						{
							foreach($players_from_account as $player)
								if($char_id == $player['id'])
									$player_on_account = true;
							if(!$player_on_account)
								$errors[] = 'Player with selected ID '.$char_id.' doesn\'t exist or isn\'t on your account';
						}
						if(count($errors) == 0)
						{
							$saved = true;
							if($account_logged->getId() != $thread['author_aid'])
								$char_id = $thread['author_guid'];
							$SQL->query("UPDATE `z_forum` SET `author_guid` = ".(int) $char_id.", `post_text` = ".$SQL->quote($text).", `post_topic` = ".$SQL->quote($post_topic).", `post_smile` = ".(int) $smile.", `last_edit_aid` = ".(int) $account_logged->getId().",`edit_date` = ".time()." WHERE `id` = ".(int) $thread['id']);
							$post_page = $SQL->query("SELECT COUNT(`z_forum`.`id`) AS posts_count FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`post_date` <= ".$thread['post_date']." AND `z_forum`.`first_post` = ".(int) $thread['first_post'])->fetch();
							$page = (int) ceil($post_page['posts_count'] / $threads_per_page) - 1;
							header('Location: ?subtopic=forum&action=show_thread&id='.$thread['first_post'].'&page='.$page);
							$main_content .= '<br />Thank you for editing post.<br /><a href="?subtopic=forum&action=show_thread&id='.$thread['first_post'].'">GO BACK TO LAST THREAD</a>';
						}
					}
					else
					{
						$text = $thread['post_text'];
						$char_id = (int) $thread['author_guid'];
						$post_topic = $thread['post_topic'];
						$smile = (int) $thread['post_smile'];
					}
					if(!$saved)
					{
						if(count($errors) > 0)
						{
							$main_content .= '<br /><font color="red" size="2"><b>Errors occured:</b>';
							foreach($errors as $error)
								$main_content .= '<br />* '.$error;
							$main_content .= '</font>';
						}
						$main_content .= '<br /><form action="?" method="POST"><input type="hidden" name="action" value="edit_post" /><input type="hidden" name="id" value="'.$post_id.'" /><input type="hidden" name="subtopic" value="forum" /><input type="hidden" name="save" value="save" /><table width="100%"><tr bgcolor="'.$config['site']['vdarkborder'].'"><td colspan="2"><font color="white"><b>Edit Post</b></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="180"><b>Character:</b></td><td><select name="char_id"><option value="0">(Choose character)</option>';
						foreach($players_from_account as $player)
						{
							$main_content .= '<option value="'.$player['id'].'"';
							if($player['id'] == $char_id)
								$main_content .= ' selected="selected"';
							$main_content .= '>'.$player['name'].'</option>';
						}
						$main_content .= '</select></td></tr><tr bgcolor="'.$config['site']['lightborder'].'"><td><b>Topic:</b></td><td><input type="text" value="'.htmlspecialchars($post_topic).'" name="topic" size="40" maxlength="60" /> (Optional)</td></tr>
						<tr bgcolor="'.$config['site']['darkborder'].'"><td valign="top"><b>Message:</b><font size="1"><br />You can use:<br />[player]Nick[/player]<br />[url=http://address.com/]Address Search - Find Email and Addresses @ Address.com[/url]<br />[img]http://images.com/images3.gif[/img]<br />[code]Code[/code]<br />[b]<b>Text</b>[/b]<br />[i]<i>Text</i>[/i]<br />[u]<u>Text</u>[/u]<br />and smileys:<br />;) , :) , :D , :( , :rolleyes:<br />:cool: , :eek: , :o , :p</font></td><td><textarea rows="10" cols="60" name="text">'.htmlspecialchars($text).'</textarea><br />(Max. 15,000 letters)</td></tr>
						<tr bgcolor="'.$config['site']['lightborder'].'"><td valign="top">Options:</td><td><label><input type="checkbox" name="smile" value="1"';
						if($smile == 1)
							$main_content .= ' checked="checked"';
						$main_content .= '/>Disable Smileys in This Post </label></td></tr></table><center><input type="submit" value="Save Post" /></center></form>';
					}
				}
				else
					$main_content .= '<br />You are not an author of this post.';
			}
			else
				$main_content .= '<br />Post with ID '.$post_id.' doesn\'t exist.';
		}
		else
			$main_content .= '<br />Your account is banned, deleted or you don\'t have any player with level '.$level_limit.' on your account. You can\'t post.';
	}
	else
		$main_content .= '<br />Login first.';
}

if($action == 'new_topic')
{
	if($logged)
	{
		if(canPost($account_logged) || $group_id_of_acc_logged >= $group_not_blocked)
		{
			$players_from_account = $SQL->query("SELECT `players`.`name`, `players`.`id` FROM `players` WHERE `players`.`account_id` = ".(int) $account_logged->getId())->fetchAll();
			$section_id = (int) $_REQUEST['section_id'];
			$main_content .= '<a href="?subtopic=forum">Boards</a> >> <a href="?subtopic=forum&action=show_board&id='.$section_id.'">'.$sections[$section_id].'</a> >> <b>Post new thread</b><br />';
			if(isset($sections[$section_id]))
			{
				if($section_id == 1 && $group_id_of_acc_logged < $group_not_blocked)
					$errors[] = 'Only moderators and admins can post on news board.';
				$quote = (int) $_REQUEST['quote'];
				$text = stripslashes(trim(codeLower($_REQUEST['text'])));
				$char_id = (int) $_REQUEST['char_id'];
				$post_topic = stripslashes(trim($_REQUEST['topic']));
				$smile = (int) $_REQUEST['smile'];
				$saved = false;
				if(isset($_REQUEST['save']))
				{
					$lenght = 0;
					for($i = 0; $i <= strlen($post_topic); $i++)
					{
						if(ord($post_topic[$i]) >= 33 && ord($post_topic[$i]) <= 126)
							$lenght++;
					}
					if($lenght < 1 || strlen($post_topic) > 60)
						$errors[] = 'Too short or too long topic (short: '.$lenght.' long: '.strlen($post_topic).' letters). Minimum 1 letter, maximum 60 letters.';
					$lenght = 0;
					for($i = 0; $i <= strlen($text); $i++)
					{
						if(ord($text[$i]) >= 33 && ord($text[$i]) <= 126)
							$lenght++;
					}
					if($lenght < 1 || strlen($text) > 15000)
						$errors[] = 'Too short or too long post (short: '.$lenght.' long: '.strlen($text).' letters). Minimum 1 letter, maximum 15000 letters.';
					if($char_id == 0)
						$errors[] = 'Please select a character.';
					$player_on_account == false;
					if(count($errors) == 0)
					{
						foreach($players_from_account as $player)
							if($char_id == $player['id'])
								$player_on_account = true;
						if(!$player_on_account)
							$errors[] = 'Player with selected ID '.$char_id.' doesn\'t exist or isn\'t on your account';
					}
					if(count($errors) == 0)
					{
						$last_post = $account_logged->getCustomField('last_post');
						if($last_post+$post_interval-time() > 0 && $group_id_of_acc_logged < $group_not_blocked)
							$errors[] = 'You can post one time per '.$post_interval.' seconds. Next post after '.($last_post+$post_interval-time()).' second(s).';
					}
					if(count($errors) == 0)
					{
						$saved = true;
						$account_logged->setCustomField('last_post', time());
						$SQL->query("INSERT INTO `z_forum` (`id` ,`first_post` ,`last_post` ,`section` ,`replies` ,`views` ,`author_aid` ,`author_guid` ,`post_text` ,`post_topic` ,`post_smile` ,`post_date` ,`last_edit_aid` ,`edit_date`, `post_ip`) VALUES ('NULL', '0', '".time()."', '".(int) $section_id."', '0', '0', '".$account_logged->getId()."', '".(int) $char_id."', ".$SQL->quote($text).", ".$SQL->quote($post_topic).", '".(int) $smile."', '".time()."', '0', '0', '".$_SERVER['REMOTE_ADDR']."')");
						$thread_id = $SQL->lastInsertId();
						$SQL->query("UPDATE `z_forum` SET `first_post`=".(int) $thread_id." WHERE `id` = ".(int) $thread_id);
						header('Location: ?subtopic=forum&action=show_thread&id='.$thread_id);
						$main_content .= '<br />Thank you for posting.<br /><a href="?subtopic=forum&action=show_thread&id='.$thread_id.'">GO BACK TO LAST THREAD</a>';
					}
				}
				if(!$saved)
				{
					if(count($errors) > 0)
					{
						$main_content .= '<font color="red" size="2"><b>Errors occured:</b>';
						foreach($errors as $error)
							$main_content .= '<br />* '.$error;
						$main_content .= '</font><br />';
					}
					$main_content .= '<form action="?" method="POST"><input type="hidden" name="action" value="new_topic" /><input type="hidden" name="section_id" value="'.$section_id.'" /><input type="hidden" name="subtopic" value="forum" /><input type="hidden" name="save" value="save" /><table width="100%"><tr bgcolor="'.$config['site']['vdarkborder'].'"><td colspan="2"><font color="white"><b>Post New Reply</b></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="180"><b>Character:</b></td><td><select name="char_id"><option value="0">(Choose character)</option>';
					foreach($players_from_account as $player)
					{
						$main_content .= '<option value="'.$player['id'].'"';
						if($player['id'] == $char_id)
							$main_content .= ' selected="selected"';
						$main_content .= '>'.$player['name'].'</option>';
					}
					$main_content .= '</select></td></tr><tr bgcolor="'.$config['site']['lightborder'].'"><td><b>Topic:</b></td><td><input type="text" name="topic" value="'.htmlspecialchars($post_topic).'" size="40" maxlength="60" /> (Optional)</td></tr>
					<tr bgcolor="'.$config['site']['darkborder'].'"><td valign="top"><b>Message:</b><font size="1"><br />You can use:<br />[player]Nick[/player]<br />[url=http://address.com/]Address Search - Find Email and Addresses @ Address.com[/url]<br />[img]http://images.com/images3.gif[/img]<br />[code]Code[/code]<br />[b]<b>Text</b>[/b]<br />[i]<i>Text</i>[/i]<br />[u]<u>Text</u>[/u]<br />and smileys:<br />;) , :) , :D , :( , :rolleyes:<br />:cool: , :eek: , :o , :p</font></td><td><textarea rows="10" cols="60" name="text">'.htmlspecialchars($text).'</textarea><br />(Max. 15,000 letters)</td></tr>
					<tr bgcolor="'.$config['site']['lightborder'].'"><td valign="top">Options:</td><td><label><input type="checkbox" name="smile" value="1"';
					if($smile == 1)
						$main_content .= ' checked="checked"';
					$main_content .= '/>Disable Smileys in This Post </label></td></tr></table><center><input type="submit" value="Post Thread" /></center></form>';
				}
			}
			else
				$main_content .= 'Board with ID '.$board_id.' doesn\'t exist.';
		}
		else
			$main_content .= 'Your account is banned, deleted or you don\'t have any player with level '.$level_limit.' on your account. You can\'t post.';
	}
	else
		$main_content .= 'Login first.';
}

?>

widnet · Nov 10, 2009

lol
Gesior can't use preg match o lol
I can use this it's very easy

Elexonic · Nov 10, 2009

Since I can create a new topic:S?

In web Put

Boards >> News

Page:
No threads in this board.

¿??¿

Elexonic · Nov 11, 2009

Have I to modify some file?
To put my database or something?

Sryy for doube ppost don`t wokr EDIT

Gesior.pl · Nov 11, 2009

widnet said:
lol
Gesior can't use preg match o lol
I can use this it's very easy

If preg match is really much faster then PHP functions and easier to use for you fix my forum and post fixed version in new thread/your version of acc. maker. I did not find any good preg match tutorial, so I use easy php functions.
Read post:
http://otland.net/570814-post504.html
Of course my highscores is not the best optimized version of highscores, but load time (level/magic level) is (41.000 characters): '0.0917 seconds' and with 'ban info' it's '0.182 seconds'. It's compromise between performance and utility, but if you are most active acc. maker developer you should think about it (big servers that use your acc. maker). If you have some free time add 'cache' function to highscores/whoisonline/guilds

Tovar · Nov 11, 2009

gesior help fran, he looks like need help hehe!

Elexonic · Nov 12, 2009

Since I can create a new topic:S?

In web Put

Quote:
Boards >> News

Page:
No threads in this board.
¿??¿

Have I to modify some file?
To put my database or something?

Artii · Nov 13, 2009

Good work ges

Elexonic · Nov 13, 2009

Since I can create a new topic:S?

In web Put

Quote:
Boards >> News

Page:
No threads in this board.
¿??¿

Have I to modify some file?
To put my database or something?

Help!

Khanio · Nov 14, 2009

thanks

Tovar · Nov 14, 2009

@fran u need fix the link to the new topic image on forum.php. search with ctrl+f new topic and fix the address to the image.

Elexonic · Nov 14, 2009

Very Thx .

Errors occured:
* Only moderators and admins can post on news board.

Who Fix?

Elexonic · Nov 15, 2009

It might put buttons for for example
Hello [./b]
Images [./img]
[code] Codeee?? [./code]

Since for example here in the forum

[IMG]http://img692.imageshack.us/img692/4097/forummk.png

Thank you very much

pabluuz@o2.pl · Nov 16, 2009

It gives following error:
Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\forum.php on line 128
I've got TFS 0.2 , and I've used your fix for 0.2 , so it should work. Line 128 says:

$info = $SQL->query("SELECT `section`, COUNT(`id`) AS 'threads', SUM(`replies`) AS 'replies' FROM `z_forum` WHERE `first_post` = `id` GROUP BY `section`")->fetchAll();

well... I've got tables 'id' and 'replies' in 'z_forum', so i dunno what's wrong. Any1 can help me?

And btw, Gesior thanks for sharing your scripts.

Gesior.pl · Nov 17, 2009

fran said:
It might put buttons for for example
Hello [./b]
Images [./img]
[code] Codeee?? [./code]

Since for example here in the forum

[IMG]http://img692.imageshack.us/img692/4097/forummk.png

Thank you very much

As thread say, IT IS SIMPLE forum for small otses that need forum integrated with acc. maker system. I think it's better then no-forum or forum with another registration (where players can use fake names).

Tovar · Nov 17, 2009

gesior can u help me with it ? =/

and i want to know if i can open the forum in a single page WITHOUT MENU, "like in the picture." BUT without the menu.

Thanks in advance guys.

eace:

Gesior.pl · Nov 18, 2009

Tovar said:
gesior can u help me with it ? =/

and i want to know if i can open the forum in a single page WITHOUT MENU, "like in the picture." BUT without the menu.

Thanks in advance guys.eace:

Hmmm... maybe at end (before ?> ) of forum.php paste:

PHP:

echo $main_content;
exit;

It should show forum and ignore rest of acc. maker/layout.

Tovar · Nov 18, 2009

hehe nice gesior but is horrible view the forum with white background lol, i cannot put the forum with the background and header but with out the menu??, srry if u are busy and i bother u. ;/

Gesior.pl · Nov 20, 2009

Tovar said:
hehe nice gesior but is horrible view the forum with white background lol, i cannot put the forum with the background and header but with out the menu??, srry if u are busy and i bother u. ;/

EASY VERSION:
in place of:

PHP:

echo $main_content;
exit;

paste:

PHP:

echo '<html><head><title>Forum</title></head><body bgcolor="#aabbcc">here your layout code...'.$main_content.'...end of layout code</body></html>';
exit;

If you know HTML you can add more advanced background, special forum menu (with boards).

Tovar · Nov 20, 2009

thanks, I will add ur code + another things...

Simple forum script

Banned User

Banned User

Well-Known Member

Well-Known Member

Mega Noob&LOL 2012

Brak V

Well-Known Member

Seldora.net

Well-Known Member

New Member

Brak V

Well-Known Member

Well-Known Member

New Member

Mega Noob&LOL 2012

Brak V

Mega Noob&LOL 2012

Brak V

Mega Noob&LOL 2012

Brak V

Similar threads