Jump to content


Photo

[slovenian] Guest Book


  • Please log in to reply
1 reply to this topic

#1 carli

carli

    Etomite Forum Newbie

  • Member
  • 30 posts

Posted 23 February 2006 - 07:06 AM

// Variables you may want to change



$defaultadmin = "msg"; // 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: #FFFFFF;'"; // Css style for message box

$dateformat = "%d.%m.%y ob %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 = 21600; // number of seconds for timezone difference



// English language for guestbook



$_lang_guestbook["write_new_message"] = "NapiÅ¡i novo sporočilo.";

$_lang_guestbook["messages"] = "Sporočila";

$_lang_guestbook["name_or_alias"] = "Ime ali vzdevek";

$_lang_guestbook["send"] = "Pošlji";

$_lang_guestbook["reset"] = "Briši";

$_lang_guestbook["next_page"] = "Naslednja stran";

$_lang_guestbook["previous_page"] = "Predhodna stran";

$_lang_guestbook["message"] = "Sporočilo";

$_lang_guestbook["date_and_time"] = "Datum in čas";

$_lang_guestbook["sender"] = "Pošiljalev";

$_lang_guestbook["cancel"] = "Prekliči";

$_lang_guestbook["error"] = "Preveri svoje nastavitve!";



// 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='&laquo; ".$_lang_guestbook["previous_page"]." [$previouspage/$pages]' onClick=\"window.location.href='$pageurl&page=$previouspage'\"></form>";

//    $previouspage_text = "<a href='?page=$previouspage'>&laquo; ".$_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] &raquo;' onClick=\"window.location.href='$pageurl&page=$nextpage'\"></form>";

//    $nextpage_text = "<a href='?page=$nextpage'>".$_lang_guestbook["next_page"]." [$nextpage/$pages] &raquo;</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=#CCCCCC><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;


#2 jetmuzer

jetmuzer

    Etomite Forum Newbie

  • Member
  • 1 posts

Posted 24 November 2007 - 07:24 PM

That's what i searched for
Nice translate ;)
Thanks carli!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users