No replies to this topic

[Helicopter]

/*

Snippet:        GuestBook3 (based on GuestBook2) - Etomite v0.6.3 - Modified 2005-09-05



Created By:     Ralph A. Dahlgren - rad14701@yahoo.com

Modified By:    Mikko K. Lammi - lammikko@gmail.com - www.parea.fi

Modified By:    Rain R. Visser German Translation by Rainer Vetter



Demo URL GB2:   http://www.parea.fi/raaputuksia/guestbook.html



Usage:          Create an Etomite user or admin as GuestBook owner in Etomite Manager

                Change $defaultadmin variable to match GuestBook owner

                OR

                Messages will be deposited into that mailbox, but only GuestBook

                messages will be displayed within the GuestBook listing.

                Place the .gifs in assets\images

                Place the .JS in assets\site



Variables:      $gbtype - Referenced in GuestBook admin User Messages Subject

                $gbadmin - Etomite User/Admin who will receive this message



Examples:       Use the [!SnippetName!] syntax instead of regular [[SnippetName]]:

                [!GuestBook!] - Will use snippet defaults for $gbtype and $gbadmin

                [!GuestBook?gbtype=GuestBook&gbadmin=guestbook!] - Self Explanatory

                [!GuestBook?gbadmin=someuser!] - Uses $etomite->documentObject['pagetitle'] for $gbtype

                [!GuestBook?bgtype=SomeTopic!] - Uses $defaultadmin for $gbadmin



Note:           $etomite->documentObject['createdby'] was not used for $gbadmin intentionally

                To implement this capability would entail and additonal DB Query before Inserts

*/



// BEGIN SETTINGS -------------------------------------------------------------



// Variables you may want to change



$defaultadmin = "gästebuch"; // Default GuestBook admin to use if $gbadmin not passed

$gap = " :: "; // Separator between $type and $subject in User Messages Subject field

$messages = 10; // Number of messages on one page

$header_style = "style='font-size: medium;'"; // Css style for header

$message_box_style = "style='border: 1px solid #000000; padding: 5px; background-color: #A0C0FF'"; // Css style for message box

$dateformat = "%d.%m.%Y um %H:%M:%S"; // Preferred Date & Time display format, European dateformat is "%d.%m.%Y %H:%M:%S"

$order = "DESC"; // Order of messages by postdate: DESC = descending, ASC = ascending

$server_offset_time = 00000; // number of seconds for timezone difference



// German language for guestbook 



$_lang_guestbook["write_new_message"] = "Neuen Eintrag schreiben";

$_lang_guestbook["messages"] = "Bisherige Einträge";

$_lang_guestbook["name_or_alias"] = "Name";

$_lang_guestbook["send"] = "Senden";

$_lang_guestbook["reset"] = "Zurücksetzen";

$_lang_guestbook["next_page"] = "Nächste Seite";

$_lang_guestbook["previous_page"] = "Vorherige Seite";

$_lang_guestbook["message"] = "Eintrag";

$_lang_guestbook["date_and_time"] = "Datum und Uhrzeit";

$_lang_guestbook["sender"] = "Absender";

$_lang_guestbook["cancel"] = "Löschen";

$_lang_guestbook["error"] = "Gastenboek User/Manager niet gevonden... Check de settings...";

/*



// Dutch language for guestbook 



$_lang_guestbook["write_new_message"] = "Plaats nieuw bericht";

$_lang_guestbook["messages"] = "Berichten";

$_lang_guestbook["name_or_alias"] = "Naam of alias";

$_lang_guestbook["send"] = "Zend";

$_lang_guestbook["reset"] = "Reset";

$_lang_guestbook["next_page"] = "Volgende pagina";

$_lang_guestbook["previous_page"] = "Vorige pagina";

$_lang_guestbook["message"] = "Bericht";

$_lang_guestbook["date_and_time"] = "Datum en tijd";

$_lang_guestbook["sender"] = "Verzender";

$_lang_guestbook["cancel"] = "Annuleren";

$_lang_guestbook["error"] = "Gastenboek User/Manager niet gevonden... Check de settings...";

/*

// English language for guestbook



$_lang_guestbook["write_new_message"] = "Write a new message";

$_lang_guestbook["messages"] = "Messages";

$_lang_guestbook["name_or_alias"] = "Name or alias";

$_lang_guestbook["send"] = "Send";

$_lang_guestbook["reset"] = "Reset";

$_lang_guestbook["next_page"] = "Next page";

$_lang_guestbook["previous_page"] = "Previous page";

$_lang_guestbook["message"] = "Message";

$_lang_guestbook["date_and_time"] = "Date and time";

$_lang_guestbook["sender"] = "Sender";

$_lang_guestbook["cancel"] = "Cancel";

$_lang_guestbook["error"] = "GuestBook User/Manager not found... Check your settings...";



Finnish language for guestbook - Replace English language for guestbook lines



$_lang_guestbook["write_new_message"] = "Kirjoita uusi viesti";

$_lang_guestbook["messages"] = "Viestit";

$_lang_guestbook["name_or_alias"] = "Nimi tai nimimerkki";

$_lang_guestbook["send"] = "Lähetä";

$_lang_guestbook["reset"] = "Tyhjennä";

$_lang_guestbook["next_page"] = "Seuraava sivu";

$_lang_guestbook["previous_page"] = "Edellinen sivu";

$_lang_guestbook["message"] = "Viesti";

$_lang_guestbook["date_and_time"] = "Päiväys";

$_lang_guestbook["sender"] = "Lähettäjä";

$_lang_guestbook["cancel"] = "Annulär";

$_lang_guestbook["error"] = "GuestBook User/Manager not found... Check your settings...";

*/



// END SETTINGS ---------------------------------------------------------------







// Variables you should not need to change

$type = isset($gbtype) ? $gbtype : $etomite->documentObject['pagetitle']; // Set $type field for new entry

$trimtype=substr($type,0,15); // Truncate $type to 15 character limit for field

$guestbookadmin = isset($gbadmin) ? $gbadmin : $defaultadmin; // Set GuestBook admin

$pageid=$etomite->documentIdentifier; // ID of the calling document

$pageurl=$etomite->makeURL($pageid); // URL if you don't have friendly uri

$tbl = $etomite->dbConfig['dbase'].".".$etomite->dbConfig['table_prefix'];

$msgdb = $tbl."user_messages"; // DB.Prefix_user_messages variable



// Function to show smileys

function smile($text) {

    $text = str_replace(":)", "<img src=\"assets/images/smile.gif\">", $text);

    $text = str_replace(":D", "<img src=\"assets/images/biggrin.gif\">", $text);

    $text = str_replace(":haha:","<img src=\"assets/images/laugh.gif\">", $text);

    $text = str_replace(";)","<img src=\"assets/images/wink.gif\">", $text);

    $text = str_replace(":cool:","<img src=\"assets/images/cool.gif\">", $text);

    $text = str_replace(":o","<img src=\"assets/images/blush.gif\">", $text);

    $text = str_replace(":(","<img src=\"assets/images/frown.gif\">", $text);

    $text = str_replace(":foei:","<img src=\"assets/images/nono.gif\">", $text);

    $text = str_replace(":schrik:","<img src=\"assets/images/eek.gif\">", $text);

    $text = str_replace(":boos:","<img src=\"assets/images/mad.gif\">", $text);

    $text = str_replace(":dood:","<img src=\"assets/images/dead.gif\">", $text);

    $text = str_replace(":huil:","<img src=\"assets/images/cry.gif\">", $text);

    $text = str_replace(":kus:", "<img src=\"assets/images/kiss.gif\">", $text);

    $text = str_replace(":love:","<img src=\"assets/images/rose.gif\">", $text);

    $text = str_replace(":stil:", "<img src=\"assets/images/quiet.gif\">", $text);

    $text = str_replace(":kijk:","<img src=\"assets/images/look.gif\">", $text);

    $text = str_replace(":poets:", "<img src=\"assets/images/brushteeth.gif\">", $text);

    $text = str_replace(":proost:","<img src=\"assets/images/cheers.gif\">", $text);

    $text = str_replace(":clown:","<img src=\"assets/images/clown.gif\">", $text);

    $text = str_replace(":td:","<img src=\"assets/images/notgood.gif\">", $text);

    $text = str_replace(":tu:",  "<img src=\"assets/images/perfect.gif\">", $text);

    $text = str_replace(":buig:","<img src=\"assets/images/hail.gif\">", $text);

    $text = str_replace(":spring:","<img src=\"assets/images/bouncey.gif\">", $text);

    $text = str_replace(":nerd:","<img src=\"assets/images/nerd.gif\">", $text);

    $text = str_replace(":idee:","<img src=\"assets/images/idea.gif\">", $text);

    $text = str_replace(":zzz:","<img src=\"assets/images/sleep.gif\">", $text);

    $text = str_replace(":P","<img src=\"assets/images/tongue.gif\">", $text);

    $text = str_replace(":zwaai:","<img src=\"assets/images/wave.gif\">", $text);

    $text = str_replace(":fluit:", "<img src=\"assets/images/whissle.gif\">", $text);

    $text = str_replace(":verbaasd:","<img src=\"assets/images/confused.gif\">", $text);

   return $text;

}





// Function to make hyperlinks

function hyperlink($text) {

    $search = array ("/([\w\.\/\&\=\?\-]+)@([\w\.\/\&\=\?\-]+)/","/((ftp(7?):\/\/)|(ftp\.))([\w\.\/\&\=\?\-]+)/","/((http(s?):\/\/)|(www\.))([\w\.\/\&\=\?\-]+)/");

    $replace = array ("<a href='mailto:$1@$2'>$1@$2</a>","<a href='ftp$3://$4$5' target='_blank'>$4$5</a>","<a href='http$3://$4$5' target='_blank'>$4$5</a>");

    return preg_replace ($search, $replace, $text);

}



// Don't allow unwanted re-posts of messages

if($_POST['submitted'] == "TRUE") header( "Location: index.php?id=$etomite->documentIdentifier" );



// Query for the user ID (id) for the GuestBook owner

$sql = "SELECT id FROM ".$tbl."manager_users WHERE ".$tbl."manager_users.username='$guestbookadmin';";

$rs = $etomite->dbQuery($sql);

$limit = $etomite->recordCount($rs);



// Check to make sure $guestbookadmin has been created and assigned

if($limit == 1) {



    $userrec = $etomite->fetchRow($rs);

    $userid = $userrec['id'];



    // Check to see if a valid message has been submitted

    if(isset($_POST['submit']) && ($_POST['subject'] > "")  && ($_POST['message'] > "")){

        $postdate = time();



        $recipient = $userid;

        $subject = $type . $gap . strip_tags($_POST['subject']);

        $message = strip_tags($_POST['message']);



        // Query to INSERT a new GuestBook message into user_messages

        $sql = "INSERT INTO $msgdb ( id , type , subject , message , sender , recipient , private , postdate , messageread ) VALUES ( '', '$type', '$subject', '$message', '0', '$recipient', '0', '$postdate', '0' );";



        $rs = $etomite->dbQuery($sql);  // Execute the Query

        $submitted="TRUE";

    }

    else $submitted = "TRUE";



    // Display write new message form

    if ($_GET['new_message'] == "TRUE") {

        // Display a Form for submitting a new message

        $output .= "<script language=\"javascript\" type=\"text/javascript\" src=\"assets/site/gb.js\"></script>";

        $output .= "<h2 $header_style>".$_lang_guestbook["write_new_message"]."</h2>";

        $output .= "<table width='100%'><tr><td>";

        $output .= "<form name=\"form\" method='post' action='index.php'>";

        $output .= "<input type='hidden' name='id' value='$pageid' />";

        $output .= "<input type='hidden' name='submitted' value='$submitted' />";

        $output .= $_lang_guestbook["name_or_alias"]."<br /><input name='subject' size='40' />";

        $output .= "<br /><br />".$_lang_guestbook["message"]."<br /><text"."area rows='8' cols='50' name='message'></"."text"."area>";

        $output .= "<button type=\"button\" onclick=\"show_smilies();\"><img src=\"assets/images/smile.gif\"></button><div><div id=\"smilie_box\"></div></div><br /><br />";

        $output .= "<input type='submit' name='submit' value='".$_lang_guestbook["send"]."' />";

        $output .= "  <input type='reset' name='reset' value='".$_lang_guestbook["reset"]."' />";

        $output .= "  <input type='button' value='".$_lang_guestbook["cancel"]."' onClick=\"window.location.href='$pageurl&new_message=FALSE'\">";

        $output .= "</form>";

        $output .= "</td></tr></table>";

    }

  

    // Display write new message link

    else {

        $output .= "<h2 $header_style>".$_lang_guestbook["write_new_message"]."</h2>";

        $output .= "  <form><input type='button' value='".$_lang_guestbook["write_new_message"]."' onClick=\"window.location.href='$pageurl&new_message=TRUE'\"></form>";

    }

  

    $output .= "<h2 $header_style>".$_lang_guestbook["messages"]."</h2>";



    // Query to COUNT existing messages

    $sql = "SELECT * FROM ".$tbl."user_messages

    WHERE ".$tbl."user_messages.recipient=$userid

    AND ".$tbl."user_messages.type='".$trimtype."'

    ORDER BY ".$tbl."user_messages.postdate $order;";



    $rs = $etomite->dbQuery($sql);  // Execute the Query

    $total = $etomite->recordCount($rs);  // Number of messages found



    // Message page number from GET

    if (isset($_GET["page"])) { $page = $_GET["page"]; }

    else { $page = 1; }



    // Index where to start in result set

    $from = 0 + ($page-1)*$messages;



    // Query to SELECT existing messages

    $sql = "SELECT * FROM ".$tbl."user_messages

    WHERE ".$tbl."user_messages.recipient=$userid

    AND ".$tbl."user_messages.type='".$trimtype."'

    ORDER BY ".$tbl."user_messages.postdate $order LIMIT $from, $messages;";



    $rs = $etomite->dbQuery($sql);  // Execute the Query

    $limit = $etomite->recordCount($rs);  // Number of messages found



    // Number of pages

    $pages = ceil($total/$messages);



    // Previous page link

    $previouspage = $page-1;

    $previouspage_text .= "  <form><input type='button' value='« ".$_lang_guestbook["previous_page"]." [$previouspage/$pages]' onClick=\"window.location.href='$pageurl&page=$previouspage'\"></form>";

//    $previouspage_text = "<a href='?page=$previouspage'>« ".$_lang_guestbook["previous_page"]." [$previouspage/$pages]</a>   ";



    // Next page link

    $nextpage = $page+1;

    $nextpage_text = "  <form><input type='button' value='".$_lang_guestbook["next_page"]." [$nextpage/$pages] »' onClick=\"window.location.href='$pageurl&page=$nextpage'\"></form>";

//    $nextpage_text = "<a href='?page=$nextpage'>".$_lang_guestbook["next_page"]." [$nextpage/$pages] »</a>";



    // Previous and next page links at top of the page

    if ($previouspage > 0) { $output .= $previouspage_text; }

    if ($nextpage <= $pages) { $output .= $nextpage_text; }



    // Empty lines

    if ($total > $messages) {

        $output .= "<br /><br />";

    }



    // Loop through each of the messages and format for display

    for ($y = 0; $y < $limit; $y++) {

        if ($order == "DESC") { $number = $total - $from - $y; }

        if ($order == "ASC") { $number = $from + $y + 1; }

        $guestbookrec = $etomite->fetchRow($rs);

        $poster = str_replace($type.$gap,"",$guestbookrec['subject']);

        $message = nl2br($guestbookrec['message']);

        $postdate = strftime($dateformat, $guestbookrec['postdate']+$server_offset_time);

        $output .= "<table $message_box_style width='100%'>";

        $output .= "<tr bgcolor=#FFCC66><td nowrap width='80%'>$poster</td>";

        $output .= "<td nowrap width='20%' align=right>$postdate</td>";

        $output .= "<tr><td colspan=\"2\"> </td>";

        $output .= "<tr><td colspan=\"2\">".hyperlink(smile($message))."</td>";

        $output .= "<tr><td width='80%'> </td>";

        $output .= "<td width='20%' nowrap align=right>".$_lang_guestbook["message"].": $number/$total</td>";

        $output .= "</table><br />";

    }



    // Previous and next page links at bottom of the page

    if ($previouspage > 0) { $output .= $previouspage_text; }

    if ($nextpage <= $pages) { $output .= $nextpage_text; }

}



// If no valid GuestBook owner is found display error message...

else  $output = $_lang_guestbook["error"];



// Output

return $output;