40 lines
		
	
	
		
			1.5 KiB
		
	
	
	
		
			PHP
		
	
	
	
		
		
			
		
	
	
			40 lines
		
	
	
		
			1.5 KiB
		
	
	
	
		
			PHP
		
	
	
	
| 
								 | 
							
								<?php
							 | 
						||
| 
								 | 
							
								  require 'lib/function.php';
							 | 
						||
| 
								 | 
							
								  require 'lib/layout.php';
							 | 
						||
| 
								 | 
							
								  print $header;
							 | 
						||
| 
								 | 
							
								  if(!$page) $page=0;
							 | 
						||
| 
								 | 
							
								  if(!$ppp) $ppp=50;
							 | 
						||
| 
								 | 
							
								  $min=$ppp*$page;
							 | 
						||
| 
								 | 
							
								  $posts=mysql_query("SELECT p.id,thread,ip,date,num,t.title,minpower FROM posts p,threads t,forums f WHERE p.user=$id AND thread=t.id AND t.forum=f.id ORDER BY p.id DESC");
							 | 
						||
| 
								 | 
							
								  $posttotal=mysql_num_rows($posts);
							 | 
						||
| 
								 | 
							
								  $pagelinks=$smallfont.'Pages:';
							 | 
						||
| 
								 | 
							
								  for($i=0;$i<($posttotal/$ppp);$i++){
							 | 
						||
| 
								 | 
							
								    if($i==$page) $pagelinks.=' '.($i+1);
							 | 
						||
| 
								 | 
							
								    else $pagelinks.=" <a href=postsbyuser.php?id=$id&ppp=$ppp&page=$i>".($i+1).'</a>';
							 | 
						||
| 
								 | 
							
								  }
							 | 
						||
| 
								 | 
							
								  $postlist="
							 | 
						||
| 
								 | 
							
									$tccellhs width=50>Post id</td>
							 | 
						||
| 
								 | 
							
									$tccellhs width=50>Post#</td>
							 | 
						||
| 
								 | 
							
									$tccellhs width=130>Posted on</td>
							 | 
						||
| 
								 | 
							
									$tccellhs>Thread</td>
							 | 
						||
| 
								 | 
							
								  ";
							 | 
						||
| 
								 | 
							
								  if($isadmin) $postlist.="$tccellhs width=110>IP address</td>";
							 | 
						||
| 
								 | 
							
								  for($i=0;$post=mysql_fetch_array($posts);$i++){
							 | 
						||
| 
								 | 
							
								    if($i>=$min and $i<($min+$ppp)){
							 | 
						||
| 
								 | 
							
									if($post[minpower]<=$power or !$post[minpower]) $threadlink="<a href=thread.php?id=$post[thread]>".str_replace('<','<',$post[title]).'</a>';
							 | 
						||
| 
								 | 
							
									else $threadlink='(restricted)';
							 | 
						||
| 
								 | 
							
									if(!$post[num]) $post[num]='?';
							 | 
						||
| 
								 | 
							
									$postlist.="
							 | 
						||
| 
								 | 
							
									  <tr>
							 | 
						||
| 
								 | 
							
									  $tccell1s>#$post[0]</td>
							 | 
						||
| 
								 | 
							
									  $tccell1s>$post[num]</td>
							 | 
						||
| 
								 | 
							
									  $tccell1s>".date($dateformat,$post[3]+$tzoff)."</td>
							 | 
						||
| 
								 | 
							
									  $tccell1ls>#$post[1] - $threadlink";
							 | 
						||
| 
								 | 
							
									if($isadmin) $postlist.="</td>$tccell1s>$post[2]";
							 | 
						||
| 
								 | 
							
								    }
							 | 
						||
| 
								 | 
							
								  }
							 | 
						||
| 
								 | 
							
								  $user=mysql_fetch_array(mysql_query("SELECT name FROM users WHERE id=$id"));
							 | 
						||
| 
								 | 
							
								  print $fonttag."Posts by $user[name] on the board: ($posttotal posts found)
							 | 
						||
| 
								 | 
							
									$tblstart$postlist$tblend$pagelinks$footer";
							 | 
						||
| 
								 | 
							
								  printtimedif($startingtime);
							 | 
						||
| 
								 | 
							
								?>
							 |