phpBB.de

Code: Alles auswählen

$sql = "SELECT * FROM guestbook";
$result = mysql_query($sql) OR die(mysql_error());
while($row = mysql_fetch_assoc($result)) 
{ 
  $id = $row['id'];
  $name = $row['name'];
  $email = $row['email'];
  $homepage = $row['homepage'];
  $location = $row['location'];
  $beruf = $row['beruf'];
  $icq = $row['icq'];
  $date = $row['date'];
  $message = nl2br($row['message']);

  //BB Codes
  $message = str_replace("[b]","<b>",$message); 
	$message = str_replace("[/b]","</b>",$message);
		
	$message = str_replace("[i]","<i>",$message); 
	$message = str_replace("[/i]","</i>",$message);	
  
	$message = str_replace("[u]","<u>",$message); 
	$message = str_replace("[/u]","</u>",$message);
  
	$message = eregi_replace("\[img\]([^\[]+)\[/img\]","<img src=\"\\1\" border=\"0\">",$message);
  	
	$message = eregi_replace("\[mail\]([^\[]+)\[/mail\]","<a href=\"mailto:\\1\">\\1</a>",$message);
	
  $message = str_replace("[url="","[url=\"",$message);
	$message = str_replace(""]","\"]",$message);
	
	$message = eregi_replace("\[url=\"([^\"]+)\"]([^\[]+)\[/url\]","<a href=\"\\1\" target=\"_blank\">\\2</a>",$message);
  
  $message = str_replace("[url="","[url=\"",$message);
	$message = str_replace(""]","\"]",$message);
	
	$message = eregi_replace("\[url=([^\"]+)]([^\[]+)\[/url\]","<a href=\"\\1\" target=\"_blank\">\\2</a>",$message);		
  

 
 
 ?>
   <div align="right">
	  <table border="0" width="100%" align="right" cellpadding="2">
		  <tr>
			  <td width="99">Eintrag:</td>
			  <td><?=$id?></td>
		  </tr>
		  <tr>
			  <td width="99">Name: </td>
			  <td><? if($email){
  echo "<a href=\"mailto:" . $email . "\"> " . $name . "</a>\n<br>";
  }
  else{

  echo $name . "\n<br>";
  }?></td>
	  	</tr>
		  <tr>
			  <td width="99">Homepage:</td>
			  <td><? if($homepage){
  echo "<a href=\" " . $homepage . "\"> " . $homepage . "</a>\n<br>";
  }

  else{
  } ?></td>
	  	</tr>
		  <tr>
			  <td width="99">Wohnort: </td>
			  <td><?=$location . "\n<br>"; ?></td>
		  </tr>
		  <tr>
			  <td width="99">Beruf:</td>
			  <td><?=$beruf . "\n<br>"; ?></td>
		  </tr>
		  <tr>
			  <td width="99">ICQ:</td>
			  <td><?=$icq . "\n<br>"; ?></td>
		  </tr>
		  <tr>
			  <td width="99" valign="top">Message: </td>
			  <td><?=$message . "\n<br>"; ?></td>
		  </tr>
	  </table>
  </div>
  <?
  
  }