MastersForum

Source code

[QUOTE]<?php

if($act == "add"){
	include("add_guestbook_entry.php");
}
elseif($act == "submit" && $action == "Abschicken") {
	if(trim($author) == "" || trim($content) == "") {
		redirectTo("?page=guestbook&act=add". $config['session_id'],$page,0);		
	}
	else {
		$author = addslashes($author);
		$email = addslashes($email);
		$homepage = addslashes($homepage);
		$title = addslashes($title);
		$content = addslashes($content);
		mysql_query("INSERT INTO $tab_gb (timestamp, author, email, homepage, title, content, ip) VALUES ('$timestamp', '$_REQUEST[author]', '$_REQUEST[email]', '$_REQUEST[homepage]', '$_REQUEST[title]', '$_REQUEST[content]', '$ip')");
		redirectTo("?page=guestbook". $config['session_id'],$page,1);
	}
}
else {
	##get_pagination($entriesperpage,$tab_gb,"guestbook");

$linesperpage = $entriesperpage;
$tab = $tab_gb;
$section = "guestbook";

		$offset = $HTTP_GET_VARS['offset'];

		$counter = mysql_query("SELECT Count(*) as total FROM $tab");

		$lines = mysql_fetch_array($counter);

		if(!$HTTP_GET_VARS['offset']) {
			$offset = 0;
		}
		else {
			$offset = $HTTP_GET_VARS['offset'];
		}

		$thisentry = $offset;

		$offset = "0";
		$page = "1";

		$page_output = "";
		$offset = $thisentry;

		$current_site = ($thisentry+$linesperpage)/$linesperpage;
		$page = $current_site-$maxsites;
		if($page < 1) {
			$page = 1;   
		}  
		$offset = ($page*$linesperpage)-$linesperpage;
		if($page < 1) {
			$page = 1;   
		}  
		if($page > 1) { 
			$page_output = $page_output."<a href="?page=".$section."&offset=0". $config['session_id'] ."" title='Seite 1'>1</a> << \n";
		}
		while($offset < $lines['total']) {
			if($offset == $thisentry) {
				$page_output = $page_output." <b>[".$page."]</b> ";
			}
			else {    
				$page_output = $page_output." <a href="?page=".$section."&offset=".$offset."". $config['session_id'] ."" title='Seite ".$page."'>$page</a>\n";
			}
			$offset = ($offset+$linesperpage);
			$page = $page+1;
			if($page > ($current_site+$maxsites)) {
				$page_output = $page_output." >> ";
				break;
			}   
		}
		$offset = $thisentry;
		$page_prev = $offset-$linesperpage;
		$page_prev_link = "<a href="?page=".$section."&offset=".$page_prev."". $config['session_id'] ."" title='Vorherige Seite'>«</a>\n";
		$page_next = $offset+$linesperpage;
		$page_next_link = "<a href="?page=".$section."&offset=".$page_next."". $config['session_id'] ."" title='Nächste Seite'>»</a>\n";





echo "		  <p align="center"><b>[ <a href="?page=guestbook&act=add". $config['session_id'] ."" title="Hier klicken um einen Eintrag in das Gästebuch zu machen.">Ins Gästebuch eintragen</a> ]</b></p>\n";
echo "		  <table border="0" cellpadding="3" cellspacing="0" width="100%" align="center" class='table_in_content'>
		    <tr class='cat_head'>
		      <td height="15" width="150" class='brightbottom'>
			<b>Autor</b>
		      </td>
		      <td height="15" class='bbottom'>
			<b>Eintrag</b>
		      </td>
		    </tr>\n";

if(isset($id) && $id != "") {
	$querystring = "SELECT * FROM $tab_gb WHERE id=$id";
}
else {
	$querystring = "SELECT * FROM $tab_gb ORDER BY timestamp DESC LIMIT $offset,$entriesperpage";
}
$get_gbentries = mysql_query($querystring);
if(mysql_num_rows($get_gbentries) == 0) {
	if(isset($id) && $id != "") {
		echo "<p align="center">Der Gästebuch-Eintrag mit der ID <b>".$id."</b> existiert nicht.</p>\n";	
	}
	else {
		echo "<p align="center">Noch keine Gästebuch-Einträge vorhanden.</p>\n";
	}
}
while($gb = mysql_fetch_array($get_gbentries)) {
	if($bgcolor == "#ffffff") {
		$bgcolor = "#f9f9f9";
	}
	else {
		$bgcolor = "#ffffff";
	}
	echo "		    <tr bgcolor='".$bgcolor."'>
		      <td width="150" valign="top" class='bright'>\n";
	if($gb[email] != "") {
		echo "		        <a href="mailto:".formatpost($gb[email])."" title="Hier klicken um '".formatpost($gb[author])."' eine Email zu schicken.">".formatpost($gb[author])."</a>\n";
	}
	else {
		echo "		        <b>".formatpost($gb[author])."</b>\n";
	}
	echo "		      </td>
		      <td valign="top" height="15" class='bbottom'>
			<small><b>» ";
	if(trim($gb[title]) == "")
	  echo "</b>kein Titel<b>";
        else
	  echo formatpost($gb[title]);

echo "</b></small>
		      </td>
		    </tr>
		    <tr bgcolor='".$bgcolor."'>
		      <td width="150" valign="top" class='brightbottom'>
			<small>".formatdate(date("d. F Y, H:i",$gb[timestamp]))."<br><br>
			".$gb[ip]."<br><br>
			#".$gb[id]."<br><br>";
	if($gb[homepage] != "" && $gb[homepage] != "http://") {
		echo "			<a href="?page=redirect&url=".formatpost($gb['homepage']).$config['session_id']."" target="_blank" title="Hier klicken um die Homepage von '".formatpost($gb[author])."' anzusehen.">Homepage</a><br><br>\n";
		$show = "redirect";

	}

echo "</small>
		      </td>
		      <td valign="top" class='bbottom'>
		        ".convert_bb_code(formatpost($gb[content]))."
		      </td>
		    </tr>\n";
}

echo "		  </table>";
echo "<p align="left">";
if(!isset($id)) {
  if(mysql_num_rows(mysql_query("SELECT * FROM $tab_gb")) > $entriesperpage) {
    output_pagination();
  }
}
else {
	echo "<img src='images/arrow.gif' height='8' width='5' alt=''> <a href="?page=guestbook". $config['session_id'] ."">Alle Einträge anzeigen</a>";
}
echo "<br><br></p>";

}

?>