Miscellany

function usercheck($id){$str = "SELECT user_type FROM swat_cod4_tw_tlink WHERE user_id = {$id}";$qry = mysql_query($str) or die(mysql_error());$userrank = 3;	if($qry)	{		while($row=mysql_fetch_assoc($qry))		{		$userrank = $row['user_type'];		}			return $userrank;	}	else	{	$userrank = 3;	return $userrank;	}}case 'twblog':$teamidq = mysql_query("SELECT team_id FROM swat_cod4_tw_tlink WHERE user_id = ".$_SESSION['user_id']);while($row = mysql_fetch_row($teamidq)){$teamid = $row[0];}$MAXPOSTSPERPAGE = 4;				$pageQuery = mysql_query("SELECT * FROM swat_cod4_tw_blog WHERE `post_team`={$teamid} ORDER BY `post_timestamp` DESC");				$rows = mysql_num_rows($pageQuery);				if (!isset($_GET["st"]))				{	$st=0;	}				else				{	$st = (int)$_GET["st"];					if ($_GET["st"] < 0)					{	$st = 0;	}					}				if ($st > $rows)				{	$st = $rows-1;	}				$result = mysql_query("SELECT a.*,b.user_name FROM swat_cod4_tw_blog a, swat_xbox_users b WHERE a.post_team={$teamid} AND a.post_author = b.user_id ORDER BY a.post_timestamp ASC LIMIT $st, $MAXPOSTSPERPAGE");				if ($rows - $st < $MAXPOSTSPERPAGE)				{$rows = ($rows - $st) % $MAXPOSTSPERPAGE;}				else				{$rows = $MAXPOSTSPERPAGE;}								$namestring = "SELECT team_name FROM swat_cod4_tw_teams WHERE team_id={$teamid} LIMIT 1";				$namequery = mysql_query($namestring);				$name = mysql_fetch_row($namequery);				echo '<table width ="466" cellspacing="2" cellpadding="0"><tr><td class="profile_header">Viewing '.$name['0'].'\'s Blog</td></tr><tr><td class="blog_content">';				for ($i = 0; $i < $rows; $i++)					{				$options='';				$post = mysql_fetch_assoc($result);					if(usercheck($_SESSION['user_id']) == 1 || usercheck($_SESSION['user_id']) == 2)					{ 					$options ='<span class="headerlinks"><a href="?action=edittwpost">Edit Post</a> | <a href="?action=deletetwpost">Delete Post</a></span>';					}					elseif($_SESSION['user_id'] = $post['post_author'])					{					$options ='<span class="headerlinks"><a href="?action=edittwpost">Edit Post</a> | <a href="?action=deletetwpost">Delete Post</a></span>';					}					elseif(usercheck($_SESSION['user_id']) == 0){$options='';}?>	  	<table width="100%" class="title_header">  <tr>     <td align="left" valign="center"><?php echo $post['post_title']; //shows the title of a post ?></td>  </tr></table>  	  	    <table width="100%" border="0" cellpadding="0" cellspacing="0" class="timestamp_header">      <tr>        <td height="20" align="left" valign="middle">Posted on <?php echo date('l, F jS (g:i A)', $post['post_timestamp'])." by ".$post['user_name']; //shows date and time of post ?></td>      </tr>    </table>    <table width="100%" class="event_description">      <tr>        <td align="left" valign="top"><?php echo $post['post_content']."<br><br>".usercheck($_SESSION['user_id'])."<center>".$options."</center>";  ?></td>      </tr>    </table><?				}			$pages = mysql_num_rows($pageQuery);		if ($pages > $MAXPOSTSPERPAGE)		{			echo "<span class='text12'>";			echo "Page: ";			$inc = 0;			for ($i=1; $pages > 0; $i++)			{				echo "<a href=\"?action=viewBlog&id={$_GET['id']}&st={$inc}\">";				if (($st >= $inc) && ($st < $inc+$MAXPOSTSPERPAGE))	{	echo " <b>".$i." </b>";	}				else {	echo $i." ";	}				echo "</a>";				$inc+=$MAXPOSTSPERPAGE;				$pages-=$MAXPOSTSPERPAGE;			}			echo "</span>";		}	echo '</td></tr></table>';	break;