<?
########################################################################
###### Database Setup
########################################################################
/*
CREATE TABLE guestbook_sonic (
  gbid varchar(3) NOT NULL,
  uin varchar(25) NOT NULL,
  timestamp int(11) NOT NULL default '0',
  ip varchar(15) NOT NULL,
  name tinytext NOT NULL,
  mail tinytext,
  www tinytext,
  usercomment text NOT NULL,
  admincomment text,
  PRIMARY KEY (uin),
  KEY uin (uin)
) TYPE=MyISAM;

CREATE TABLE guestbook_sonic_config (
  gbid varchar(3) NOT NULL,
  var tinytext NOT NULL,
  wert tinytext NOT NULL,
  KEY gbid (gbid)
) TYPE=MyISAM;

INSERT INTO guestbook_sonic_config VALUES ('102', 'status', 'online');
INSERT INTO guestbook_sonic_config VALUES ('102', 'sperrstatus', 'online');
INSERT INTO guestbook_sonic_config VALUES ('102', 'title', '..::Sonic Book::.. ..::by yanus.net::.. ..::Sonic Book::..');
INSERT INTO guestbook_sonic_config VALUES ('102', 'limit_name', '50');
INSERT INTO guestbook_sonic_config VALUES ('102', 'limit_mail', '50');
INSERT INTO guestbook_sonic_config VALUES ('102', 'limit_www', '50');
INSERT INTO guestbook_sonic_config VALUES ('102', 'limit_com', '2048');
INSERT INTO guestbook_sonic_config VALUES ('102', 'gbtype', 'hex');
INSERT INTO guestbook_sonic_config VALUES ('102', 'bgcolor', '#000000');
INSERT INTO guestbook_sonic_config VALUES ('102', 'bgimage', 'http://');
INSERT INTO guestbook_sonic_config VALUES ('102', 'rowcolor', 'blue');
INSERT INTO guestbook_sonic_config VALUES ('102', 'font', 'Verdana');
INSERT INTO guestbook_sonic_config VALUES ('102', 'fontcolor', 'blue');
INSERT INTO guestbook_sonic_config VALUES ('102', 'fontsize', '1');
INSERT INTO guestbook_sonic_config VALUES ('102', 'adminfont', 'Verdana');
INSERT INTO guestbook_sonic_config VALUES ('102', 'adminfontcolor', 'red');
INSERT INTO guestbook_sonic_config VALUES ('102', 'adminfontsize', '1');
INSERT INTO guestbook_sonic_config VALUES ('102', 'perpage', '5');
INSERT INTO guestbook_sonic_config VALUES ('102', 'size', '95%');
INSERT INTO guestbook_sonic_config VALUES ('102', 'style', 'canvas');
INSERT INTO guestbook_sonic_config VALUES ('102', 'css_config', 'auto');
INSERT INTO guestbook_sonic_config VALUES ('102', 'css_scrollbar_base', 'disabled');
INSERT INTO guestbook_sonic_config VALUES ('102', 'css_scrollbar_darkshadow', 'disabled');
INSERT INTO guestbook_sonic_config VALUES ('102', 'css_scrollbar_track', 'disabled');
INSERT INTO guestbook_sonic_config VALUES ('102', 'css_scrollbar_face', 'disabled');
INSERT INTO guestbook_sonic_config VALUES ('102', 'css_scrollbar_shadow', 'disabled');
INSERT INTO guestbook_sonic_config VALUES ('102', 'css_scrollbar_highlight', 'disabled');
INSERT INTO guestbook_sonic_config VALUES ('102', 'css_scrollbar_3dlight', 'disabled');
INSERT INTO guestbook_sonic_config VALUES ('102', 'css_scrollbar_arrow', 'disabled');

*/

########################################################################
###### Setting up the Include Variable for Check
########################################################################
$includevaria = "sdfsdu90fu8sf90sdu0f89sdua90fsuad89fuas90dfu8as9duf90asdfu89sduf890uasdf8sdafu90sdfud8909gf87gk7l06lhj789dfh6df78g9asd56f9h8gf5j4hsg6zasdf807g6sdf89g6sdf9g6sdf978g6df89hgf5jfg5jgfh6df89g7asfgt5hgft6jz7fhu89dfgu09df8ug90d8sfug90g5u7845ujtjt84jkg89jr4780gj90sdfg9sdfg7sd89g7s89dfg79d8sf7g90sdf7g890sdfg7sd8f7g90sdf7g089sdfg7s9df8g79sd80fg7s890dg790sdf87g09dfg7sd890fg70sd9fg70sdg9df7sg9sdf7g90sdf7g90sdg7890sdf7g0sdf89g790s794uaw34ioujp4iostgjpeosrtgjp45j4z89e5jgh98j89jg9erj9ge8u98dfjg9sdgu9sdfugsd98gu9sdfgus9dfug98sdfugsj4io6jgh890j89gfsdjg89sjdg98sdjg9sdjgs90d8gudf9gu9sfd8gusdft790h760g786khj95klh9gfzj89090usgr89hujsg89hjg95jg780sdfug9sdfgu8j9se805j90gsud89f0g7dsf90g6df876gh87h68df7g6dasfg7zsdg09jsdfgiosjg0ß4kt9a4we09fskd0ig9df879gh7j68j6d786gf780szug589j890dfgjs9df8gjs0df9gjsd9gjdf98gjdf9sgjsdf9gjfd";

########################################################################
###### Function: Wordslice and Striptags -- Usage: $entry = wordslice($entry);
########################################################################
function striptags($word) {
	$word = ereg_replace("(')","´",$word);
	$word = ereg_replace("(;)",":",$word);
	$word = ereg_replace("(<)","&lt;",$word);
	$word = ereg_replace("(>)","&gt;",$word);
	$word = ereg_replace("(\")","&quot;",$word);
	//$word = htmlspecialchars($word);
	//$word = htmlentities($word);
	return $word;
}
function wordchop($word) {
	$word = chop($word); $word = trim($word);
	return $word;
}
function wordslice($word) {
	$word = preg_replace( "/([^\W]{40})([^\W])/", "\\1 \\2", $word);
	return $word;
}
function createbrakes($word) {
	$word = nl2br($word);
	return $word;
}
function sid() { 
	$sid_temp = array("a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z");
	for($f=1; $f<=25; $f++)	{ $created_sid.=$sid_temp[rand(0,25)]; }				// 25 digits
	unset($f);
	unset($sid_temp);
	return $created_sid;
}
function uin() {
	$created_uin = Date("YmdHis").rand(1000,9999).rand(1000,9999).rand(100,999);	// 2003010123595999999999999 (25 digits)
	return $created_uin;
}
########################################################################
###### Check ob Gästebuch ID gesetzt
########################################################################
if (!$gbid) { $errorcode = "001300"; include("http://www.yanus.net/error.php"); exit; }

########################################################################
###### Check ob Gästebuch ID sinnvoll
########################################################################
if (strlen($gbid) != 3) { $errorcode = "XXXXXX"; include("http://www.yanus.net/error.php"); exit; }

########################################################################
###### MYSQL Connect
########################################################################
include("inc_sql.php");

########################################################################
###### Default Preferences
########################################################################
	$ip = $REMOTE_ADDR;			// Fetching User IP							>> Format: 192.168.000.001   (15 digits)
	$timestamp = time();		// Fetching Unixtimestamp					>> Format: 1067188645        (10 digits)
								// echo date("d.m.Y", $timestamp);			(Datum)
								// echo date("H:i:s", $timestamp);			(Uhrzeit)

########################################################################
###### Config Import aus SQL
########################################################################
	$abfrage = "SELECT var, wert FROM $yanus_worksheet_config WHERE gbid='$gbid'";
	$abfrage = mysql_db_query($yanus_dbname,$abfrage,$id);

    $menge = mysql_num_rows($abfrage);
	if ($menge == '0') { 
		$errorcode = "XXXXXX"; 
		include("http://www.yanus.net/error.php"); 
		if ($id) { mysql_close ($id); } 
		exit; }
	unset ($menge);
	
	while(list($var,$wert) = mysql_fetch_row($abfrage)) { $$var = $wert; }
	unset($abfrage);

	// $status			Status des Gästebuchs (Benutzerseitig)		(online/offline)
	// $sperrstatus		Status des Gästebuchs (Adminseitig)			(online/offline)
	// $title			Überschrift Gästebuch
	// $limit_name		Anzahl Zeichen Name
	// $limit_mail		Anzahl Zeichen Mail Addy
	// $limit_www		Anzahl Zeichen WWW URL
	// $limit_com		Anzahl Zeichen Kommentar
	// $gbtype			Typ des Gästebuchs							(hex/img)
	// $bgcolor			Hintergrundfarbe in Hex						(#000000)
	// $bgimage			Hintergrund als Grafik						(http://...)
	// $rowcolor		Farbe des Randes							(blue)		
	// $font			Kommentar Schriftart						(Verdana)
	// $fontcolor		Kommentar Schriftfarbe						(Blue)
	// $fontsize		Kommentar Schriftgrösse						(1)
	// $adminfont		Adminrecomment Schriftart					(Verdana)
	// $adminfontcolor	Adminrecomment Schriftfarbe					(Blue)
	// $adminfontsize	Adminrecomment Schriftgrösse				(1)
	// $perpage			Anzahl der Beiträge pro Seite				(5)
	// $size			Grösse des Gästebuchs						(pixel/prozent)
	// $style			Style Definition							(canvas/edge)
	// $css_config													(auto/manuell/disabled)
	// $css_scrollbar_base											(disabled/hex)
	// $css_scrollbar_darkshadow									(disabled/hex)
	// $css_scrollbar_track											(disabled/hex)
	// $css_scrollbar_face											(disabled/hex)
	// $css_scrollbar_shadow										(disabled/hex)
	// $css_scrollbar_highlight										(disabled/hex)
	// $css_scrollbar_3dlight										(disabled/hex)
	// $css_scrollbar_arrow											(disabled/hex)

	if ($sperrstatus == 'offline') { 
		$errorcode = "XXXXXX"; 
		include("http://www.yanus.net/error.php"); 
		if ($id) { mysql_close ($id); } 
		exit; }
	if ($status == 'offline') { 
		$errorcode = "XXXXXX"; 
		include("http://www.yanus.net/error.php"); 
		if ($id) { mysql_close ($id); } 
		exit; }

########################################################################
###### Setting up GFX Template
########################################################################
	if($style == "edge") { $style = 'temp01'; }
	if($style == "canvas") { $style = 'temp02'; }

	if($rowcolor == "blue") { $rowhex = '#0080ff'; } 
	if($rowcolor == "yellow") { $rowhex = '#ffff00'; }	
	if($rowcolor == "red") { $rowhex = '#ff0000'; } 
	if($rowcolor == "green") { $rowhex = '#00ff00'; }	
	if($rowcolor == "white") { $rowhex = '#FFFFFF'; } 
	if($rowcolor == "black") { $rowhex = '#000000'; }	
	if($rowcolor == "greydark") { $rowhex = '#808080'; } 
	if($rowcolor == "greylight") { $rowhex = '#C0C0C0'; }	

	if($fontcolor == "blue") { $fonthex = '#0080ff'; } 
	if($fontcolor == "yellow") { $fonthex = '#ffff00'; }	
	if($fontcolor == "red") { $fonthex = '#ff0000'; } 
	if($fontcolor == "green") { $fonthex = '#00ff00'; }	
	if($fontcolor == "white") { $fonthex = '#FFFFFF'; } 
	if($fontcolor == "black") { $fonthex = '#000000'; }	
	if($fontcolor == "greydark") { $fonthex = '#808080'; } 
	if($fontcolor == "greylight") { $fonthex = '#C0C0C0'; }	

	if($adminfontcolor == "blue") { $adminfonthex = '#0080ff'; } 
	if($adminfontcolor == "yellow") { $adminfonthex = '#ffff00'; }	
	if($adminfontcolor == "red") { $adminfonthex = '#ff0000'; } 
	if($adminfontcolor == "green") { $adminfonthex = '#00ff00'; }	
	if($adminfontcolor == "white") { $adminfonthex = '#FFFFFF'; } 
	if($adminfontcolor == "black") { $adminfonthex = '#000000'; }	
	if($adminfontcolor == "greydark") { $adminfonthex = '#808080'; } 
	if($adminfontcolor == "greylight") { $adminfonthex = '#C0C0C0'; }	

	$yanus_sonic_bodyhex = "<body bgcolor='$bgcolor' text='$bgcolor' link='$bgcolor' vlink='$bgcolor' alink='$bgcolor'>";
	$yanus_sonic_bodyimg = "<body background='$bgimage' text='$bgcolor' link='$bgcolor' vlink='$bgcolor' alink='$bgcolor'>";

	$yanus_sonic_meta = '
	<meta name="CREATOR" content="Yanus.net">
	<meta name="CREATOR-WEB" content="http://www.yanus.net">
	<meta name="CREATOR-MAIL" content="alex@yanus.net">
	';

	
	if($css_config == "auto") {
	$yanus_sonic_style = "
	<style>
	<!--
	BODY{
	background-repeat:no-repeat;
	background-attachment:fixed;
	scrollbar-Base-Color:$bgcolor;
	scrollbar-DarkShadow-Color:$bgcolor; 
	scrollbar-Track-Color:$bgcolor; 
	scrollbar-Face-Color:$bgcolor; 
	scrollbar-Shadow-Color:$rowhex; 
	scrollbar-Highlight-Color:$rowhex; 
	scrollbar-3dLight-Color:$bgcolor; 
	scrollbar-Arrow-Color:$rowhex 
	}
	-->
	</style>
	";
	}

	if($css_config == "manuell") {
	$yanus_sonic_style = "
	<style>
	<!--
	BODY{
	background-repeat:no-repeat;
	background-attachment:fixed;
	scrollbar-Base-Color:$css_scrollbar_base;
	scrollbar-DarkShadow-Color:$css_scrollbar_darkshadow; 
	scrollbar-Track-Color:$css_scrollbar_track; 
	scrollbar-Face-Color:$css_scrollbar_face; 
	scrollbar-Shadow-Color:$css_scrollbar_shadow; 
	scrollbar-Highlight-Color:$css_scrollbar_highlight; 
	scrollbar-3dLight-Color:$css_scrollbar_3dlight; 
	scrollbar-Arrow-Color:$css_scrollbar_arrow 
	}
	-->
	</style>
	";
	}

########################################################################
###### Guestbook
########################################################################
if (!$action) { include("inc_view.php"); if ($id) { mysql_close ($id); } exit; }

if ($action == "signup") { include("inc_signup.php"); if ($id) { mysql_close ($id); } exit; }
if ($action == "insert") { include("inc_insert.php"); if ($id) { mysql_close ($id); } exit; }

include("inc_view.php"); if ($id) { mysql_close ($id); } exit;
?>