Mellow Guest

UPDATE ERROR
"); } function getbookmysql( $b_name ){ $query = mysql_query("SELECT data FROM GUEST WHERE name = '$b_name'") or die("
REF QUERY ERROR
"); $row = mysql_fetch_row( $query ); return $row[0]; } function getcssmysql(){ $query = mysql_query("SELECT * FROM BRUTEBOOK WHERE id = '1'") or die("
REF QUERY ERROR
"); $row = mysql_fetch_row( $query ); return $row[2]; } // M A K E E N T R Y M A K E E N T R Y M A K E E N T R Y M A K E E N T R Y // Denne funktion laver en entry form, således at folk kan skrive i bogen. function mkentry($ed_entry, $ed_name, $ed_email, $ed_homep, $actual, $tok_num, $html, $_self, $action, $admin, $adminname, $adminpass) { $feltsize = "40"; // Her angives feltsize. $maxmsglen = 256; // Her angives den maximale beskedlængde. if ( !$html ) { $ed_entry = strip_tags($ed_entry); $ed_name = strip_tags($ed_name); } $adminx = "action=noshow"; $nameoruser = "Navn*"; $mailorpass = "Email"; $button = "Send indslag"; $input1 = "name"; $input2 = "email"; $required = "* er påkrævet."; $htmlchk = ""; // "HTML indslag."; $txtarea = "

Indslag*

"; $homeparea = "

Homepage

"; if ( $action == "login" ) { $button = "Log ind"; $adminx = "action=adminview"; $txtarea = ""; $nameoruser = "Navn"; $mailorpass = "Password"; $input1 = "user"; $input2 = "passwrd"; $htmlchk = ""; $homeparea = ""; $required = ""; } if ( $action == "adminedit" && $admin == 1 ) { $button = "Opdater"; $adminx = "action=adminupdate&user=".$adminname."&passwrd=".$adminpass."&editvalue=".($tok_num-$actual); $htmlchk = "

Indslag ".$actual.".

"; } $entry_box = "
"; return $entry_box; } // M A K E H T M L M A K E H T M L M A K E H T M L M A K E H T M L M A K E H T M L // Denne funktion laver de flotte tabeler med indslagene i m.m. function mkhtml($entry_array, $tok_num, $admin, $begin, $show, $_self, $adminname, $adminpass, $actual, $action, $shortentry) { $end = $begin + $show; if ( $end > ($tok_num*6) ) { $end = ($tok_num*6); } if ( $action == "adminread" && $admin == 1) { $adminonly1 = "action=adminread&user=".$adminname."&passwrd=".$adminpass."&"; } elseif ( $action == "adminview" && $admin == 1) { $adminonly1 = "action=adminview&user=".$adminname."&passwrd=".$adminpass."&"; } else $adminonly1 = "action=read&"; if ( $action == "adminview" && $admin == 1 || $action == "adminread" && $admin == 1) { if ( $show > ($tok_num*6) ) { $viewbegin = 0; } else { $viewbegin = (($tok_num-($tok_num-($end/6)))-($show/6)); } $adminonly2 = "

Normal Oversigt

"; } else { $adminonly2 = ""; } $html_file = "

Viser nu : [ ".(($tok_num-($end/6))+1)."-".($tok_num-($begin/6))." ]

"; if ( $begin < $end ) { $div = (($tok_num*6)/$show); $div = (int) $div; for ( $i=0 ; $i < $div ; $i++ ) { $tmp .= "[ ".(($i*($show/6))+1)."-".(($i+1)*($show/6))." ] "; } if ( (($tok_num*6)%$show) != 0 ) { $tmp .= "[ ".(($div*($show/6))+1)."-".((($div*($show/6))+1)+($tok_num-(($div*($show/6))+1)))." ]"; } $html_file .= "

Vis ".$tmp."

".$adminonly2."

"; if ( $action == "adminview" && $admin == 1 ) { $html_file .= " "; } } for ( $i=$begin ; $i < $end ; $i=($i+6) ) { if ( $admin == 1 ) { $adminonly1 = "

Ip-nummer logget : ".$entry_array[($i+5)]."

Slet? Ændre?

"; } else { $adminonly1 = ""; } if( $action != "adminview" ) { $htmle = "
Email : "; } if( $entry_array[($i+2)] != "" ) { $addemail = $htmle."".$entry_array[($i+2)].""; } else { $addemail = ""; } if( $action != "adminview" ) { $htmle = "
Homepage : "; } if( $entry_array[($i+3)] != "" ) { $addhomep = $htmle."".$entry_array[($i+3)].""; } else { $addhomep = ""; } if ( $action == "adminview" && $admin == 1 ) { $entry_array[$i] = strip_tags($entry_array[$i]); $entry_array[$i] = substr($entry_array[$i], 0, $shortentry); $html_file .= " "; } else $html_file .= " "; } return $html_file; } // W R I T E B O O K W R I T E B O O K W R I T E B O O K W R I T E B O O K // Denne funktion skriver bogen i en fil på disken. function writebook($whole_file, $name, $email, $homep, $entry, $html, $bookfile, $maxentrys, $REMOTE_ADDR, $action, $editvalue, $admin) { setlocale("LC_TIME", "da_DK"); if( $html == 0 ) { $name = htmlspecialchars($name); $entry = htmlspecialchars($entry); $homep = htmlspecialchars($homep); $entry = nl2br($entry); } $homep = strtolower($homep); $homep = ereg_replace( "http://", "", $homep ); if ( $action == "adminupdate" || $action == "admindelete" ) { $entry_array = explode("\f", $whole_file); $array_size = sizeof($entry_array); $editvalue = ($editvalue*6); for ( $i=0 ; $i < ($array_size-1) ; $i++) { if ( $i == $editvalue ) { if ( $action == "adminupdate" ) { $file_entry .= "\r$entry\f$name\f$email\f$homep\f"; $i = $i+3; } else { $i = ($i+5); } } else { $file_entry .= $entry_array[$i]."\f"; } } } else { $file_entry .= "\r$entry\f$name\f$email\f$homep\f".date("H:i d-m-Y")."\f ".gethostbyaddr($REMOTE_ADDR)."\f"; $file_entry .= $whole_file; } putinmysql( $bookfile, $file_entry ); return $file_entry; } // EXEC STARTS HERE ------------------------------------ E X E C U T E E X E C U T E // Her starter selve eksekveringen. $whole_file = getbookmysql( $bookfile ); $entry_array = explode("\f", $whole_file); $tok_num = ((sizeof($entry_array)-1)/6); if( !$begin ) { $begin = 0; } else { $begin = ( $begin*6 ); } if ( !$action ) { $action = "read"; } if( $action == "adminedit" && $user == $adminname && $passwrd == $adminpass ) $admin = 1; if( $action == "admindelete" && $user == $adminname && $passwrd == $adminpass ) $admin = 1; if( $action == "adminread" && $user == $adminname && $passwrd == $adminpass ) $admin = 1; if( $action == "adminupdate" && $user == $adminname && $passwrd == $adminpass ) $admin = 1; if( $action == "adminview" && $user == $adminname && $passwrd == $adminpass ) $admin = 1; // make entry if( $action == "adminedit" && $admin == 1 ) { $actual = $value; $value = $tok_num-($value); $ed_entry = $entry_array[($value*6)]; $ed_name = $entry_array[(($value*6)+1)]; $ed_email = $entry_array[(($value*6)+2)]; $ed_homep = $entry_array[(($value*6)+3)]; $entry_box = mkentry($ed_entry, $ed_name, $ed_email, $ed_homep, $actual, $tok_num, $html, $_self, $action, $admin, $user, $passwrd); } if( $action == "write" && ($tok_num < $maxentrys) || $action == "login" ) { $entry_box = mkentry( "", "", "", "", 0, $actual, $tok_num, $_self, $action, $admin, $user, $passwrd); } if( $action == "read" ) { $entry_box = ""; } // write book if( $name && $entry || $action == "admindelete" ) { $name = stripslashes($name); $email = stripslashes($email); $homep = stripslashes($homep); $entry = stripslashes($entry); $whole_file = writebook($whole_file, $name, $email, $homep, $entry, $html, $bookfile, $maxentrys, $REMOTE_ADDR, $action, $editvalue, $admin); $entry_array = explode("\f", $whole_file); $tok_num = ((sizeof($entry_array)-1)/6); $tak = "

Dit indslag er modtaget.

Tak ".$name." fordi du skrev.

Tilbage

"; } elseif( $name || $entry && !$admin ) { $tak = "

Du skal angive Navn og besked.

Tilbage

"; } // make html - her bliver html_file til. if( $action == "read" || $action == "adminread" && $admin == 1 || $action == "adminview" && $admin == 1 ) { if ( $action == "adminview" || $action == "adminread") { $show = $adminshow ; } $html_file = mkhtml($entry_array, $tok_num, $admin, $begin, $show, $_self, $user, $passwrd, $actual, $action, $shortentry ); } elseif ( $action == "adminread" || $action == "adminview" ) { $tak = "

"; } // et par sidste strenge if ( $action == "adminupdate" ) $tak = "

Opdateret!

Tilbage

"; if ( $action == "admindelete" ) $tak = "

Slettet!

Tilbage

"; if ( $action == "write" && $tok_num > $maxentrys ) $tak = "

Desværre er gæstebogen fyldt op! ".$maxentrys." er det
maksimale antal indslag den kan indeholde.

Du kan gøre gæstebogens ejer opmærksom
på fejlen ved at sende en email. Klik her.

Tilbage

"; // H T M L H T M L H T M L H T M L H T M L H T M L H T M L // Her bliver det hele samlet til den færdige HTML side. $header = " Mellow Guest

Navn

Email / Homepage

IP / Tid

Forkortet indslag

Handling

".($tok_num-($i/6))."

".$entry_array[($i+1)]."

".$addemail."
".$addhomep."

".$entry_array[($i+5)]."
".$entry_array[($i+4)]."

\"".$entry_array[$i]."\"

Slet?
Se / Ændre?

".($tok_num-($i/6))."

Indslag :	".$entry_array[$i]."
Navn : ".$entry_array[($i+1)].$addemail.$addhomep." Indslag ".($tok_num-($i/6))." fra ".$entry_array[($i+4)]." ".$adminonly1."

$\"\"$ $\"\"$ $\"\"$

".$bookfile."

".$tak." "; $footer = "

Ialt $tok_num opslag.

"; echo $header; echo $entry_box; echo $html_file; echo $footer; ?>

".$nameoruser."
".$mailorpass."
	".$htmlchk." ".$required."