getValue("guestbook_siteurl");
$localtz = $oSystem->getValue("sys_timezone");
$localtime = $localtz==""?time():getLocalTime($localtz);
$curr_datetime=date("Y-m-d H:i:s",$localtime);
if($oSystem->getValue("guestbook_timeformat")=="12"){ $timeformat="%l:%i %p"; $lbltimeformat="h:i A"; }else{ $timeformat="%k:%i"; $lbltimeformat="H:i"; }
$dateformat = $oSystem->getValue("guestbook_dateformat");
if ($dateformat=="%Y-%m-%d"){
$lbldateformat="Y-m-d";
} else if ($dateformat=="%m-%d-%Y"){
$lbldateformat="m-d-Y";
} else if ($dateformat=="%d-%m-%Y"){
$lbldateformat="d-m-Y";
} else if ($dateformat=="%d %b %Y"){
$lbldateformat="d M Y";
} else if ($dateformat=="%b %d, %Y"){
$lbldateformat="M d, Y";
} else if ($dateformat=="%d %M, %Y"){
$lbldateformat="d F, Y";
} else if ($dateformat=="%M %d, %Y"){
$lbldateformat="F d, Y";
} else if ($dateformat=="%W, %d %M %Y"){
$lbldateformat="l, d F Y";
}
$lbl_currdate=date("$lbldateformat $lbltimeformat",$localtime);
$bordercolor=$oSystem->getValue("guestbook_bordercolor");
$topbackcolor=$oSystem->getValue("guestbook_topbackcolor");
$contentbackcolor=$oSystem->getValue("guestbook_contentbackcolor");
echo "
";
/***** Play Background Midi *****/
$guestbook_sound=$oSystem->getValue("guestbook_sound");
if($guestbook_sound!=""){
echo "
";
}
/***** View Guestbook *****/
if($post_id=="" && $pageaction!="addpost" && $pageaction!="makechanges" && $pageaction!="preview" && $pageaction!="post" && $pageaction!="postfrmview" && $pageaction!="writecomment"){
/*****Navigation Link Calculation*****/
$pageno = $oSystem->getValue("guestbook_pageno");
$oGuestbook->data=array("post_id","date_format(datepost,'$dateformat $timeformat')","comment");
$oGuestbook->where="status='Approve' and private!='yes' and display='Yes' and filterpost<>'Yes'";
$result = $oGuestbook->getList();
$total = mysql_num_rows($result);
mysql_free_result($result);
if($start=="" || $start==0){ $start=0; }
$prev=$start-$pageno; $next=$start+$pageno; $from=$start+1; $to=$pageno+$from-1;
if($to>=$total){ $to=$total; }if($to<$from){ $from=0; }
/*****Previous and Next Navigation. Modify To Match Your Display*****/
if($prev>=0){ $prevlink="".$lang['guestbook']['prev'].""; }
if($next<$total){ $nextlink="".$lang['guestbook']['next'].""; }
echo "
".$lang['guestbook']['guestbook']."
|
| ".$lbl_currdate." |
| ".stripslashes(nl2br($oSystem->getValue("guestbook_titledescp")))." |
| ".$lang['guestbook']['signguestbook']." |
".$lang['guestbook']['totalrecords']." $total
| ".$lang['guestbook']['showing']." $from - $to ".$lang['guestbook']['of']." $total
|
";
$total_page=ceil($total/$pageno);
/*** Plug-in the drop down menu ***/
if ($total_page>1){
echo "
";
} else {
echo" ";
}
echo"
| ";
$oGuestbook->order="datepost desc limit ".($start?"$start":"0 ") . ", $pageno";
$result=$oGuestbook->getList();
if(mysql_num_rows($result)!=0){
while($myrow=mysql_fetch_row($result)){
echo"
".$lang['guestbook']['name']."
| ".$lang['guestbook']['comments']."
|
";
$oGuestbook_Field->data = array("fieldname", "fieldtext");
$oGuestbook_Field->where = "display='Yes'";
$oGuestbook_Field->order = "sequence asc";
$result1 = $oGuestbook_Field->getList();
$fieldname=array(); $fieldtext=array();
while($myrow1=mysql_fetch_row($result1)){
$fieldname[]= $myrow1[0]; $fieldtext[]= $myrow1[1];
}
mysql_free_result($result1);
echo "
";
$oGuestbook->data = $fieldname;
$result1=$oGuestbook->getDetail($myrow[0]);
if ($myrow1=mysql_fetch_row($result1)){
for($i=0; $i| ".stripslashes($fieldtext[$i])." | : ".stripslashes(nl2br($myrow1[$i]))." | "; }
}
}
mysql_free_result($result1);
if ($oSystem->getValue("guestbook_posteditor")=="HTML"){
$myrow[2]=stripslashes($myrow[2]);
} else {
$myrow[2]=stripslashes(nl2br($myrow[2]));
}
if ($oSystem->getValue("guestbook_enablecomment")=="Yes"){
$lblcomment="".$lang['guestbook']['writecomment']." ";
} else {
$lblcomment=" ";
}
echo "
|
| $myrow[1] | $lblcomment |
| |
| $myrow[2] |
";
$i_count=0;
$comlimit=$oSystem->getValue("guestbook_nocommentlist");
/*** get the comment here ***/
$oGuestbook_Comment->data = array("author","commentcontent");
$oGuestbook_Comment->where = "post_id='$myrow[0]'";
$oGuestbook_Comment->order = "date_poster desc limit 0,$comlimit";
$resultcom=$oGuestbook_Comment->getList();
if(mysql_num_rows($resultcom)!=0){
echo"
";
while($myrowcom=mysql_fetch_row($resultcom)){
$i_count++;
echo"| | ";
if ($i_count>1){
echo"
";
}
echo"
".stripslashes($myrowcom[0])." ".$lang['guestbook']['write']." : |
| | ".stripslashes(nl2br($myrowcom[1]))."
|
";
}
mysql_free_result($resultcom);
echo" | ";
}
echo"
|
";
}
mysql_free_result($result);
}else{
echo "
".$lang['guestbook']['nopostfound']."
";
}
echo " |
";
}
/***** Preview Post *****/
if($pageaction=="preview"){
if ($oSystem->getValue("guestbook_enableimage")=="Yes"){
$status_message = $oSystem->valAuthCode($lang['common']['validcode'],$validationcode,$_SESSION['image_value']);
}
if($status_message=="" || $pageaction=="postfrmview"){
$vFCKeditor=stripslashes($FCKeditor);
echo "
";
} else {
$pageaction="addpost";
$comment=stripslashes($FCKeditor);
}
}
/***** Post Guestbook *****/
if ($pageaction=="post" || $pageaction=="postfrmview"){
if ($oSystem->getValue("guestbook_enableimage")=="Yes"){
$status_message = $oSystem->valAuthCode($lang['common']['validcode'],$validationcode,$_SESSION['image_value']);
}
/*** Block IP ***/
if($oSystem->getValue("guestbook_enableblockip")=="Yes"){
$ipaddress=$_SERVER['REMOTE_ADDR'];
if($oGuestbook_Block->IPExists(addslashes($ipaddress))){
$status_message="".$lang['guestbook']['guestbooksignfail']." ".$lang['guestbook']['ipinblocklist']."
";
}
}
/*** Filter Stop Word ***/
$detect="";
if($oSystem->getValue("guestbook_enablefilter")=="Yes"){
$commment_con=stripslashes($FCKeditor);
$oGuestbook_Block->data = array("keyword");
$oGuestbook_Block->where = "";
$oGuestbook_Block->order = "keyword";
$result=$oGuestbook_Block->getWordList();
while($myrow=mysql_fetch_row($result)){
$stopword1=""; $stopword2=""; $stopword3="";
$stopword1=stripslashes($myrow[0])." ";
$stopword2=" ".stripslashes($myrow[0]);
$stopword3=" ".stripslashes($myrow[0])." ";
if ($myrow[0]!=""){
if ( eregi( $stopword1, $commment_con ) ){
$detect="Yes";
} else if ( eregi( $stopword2, $commment_con ) ){
$detect="Yes";
} else if ( eregi( $stopword3, $commment_con ) ){
$detect="Yes";
}
}
} mysql_free_result($result);
if ($detect=="Yes"){
if($oSystem->getValue("guestbook_filtertype")=="Yes"){
$status_message="".$lang['guestbook']['guestbooksignfail']." ".$lang['guestbook']['stopwordinlist']."
";
} else {
$filterpost="Yes";
}
} else {
$filterpost="No";
}
}
if($status_message==""){
echo "
";
$comment = $FCKeditor;
if(substr($comment,0,3)==""){$comment=addslashes(substr_replace($FCKeditor,'',0,3));}else{$comment=addslashes($FCKeditor);}
$oGuestbook->data = array("ip","datepost","private","comment","status","display","filterpost");
$oGuestbook->value = array($_SERVER['REMOTE_ADDR'], $curr_datetime, $private, $comment, $status,"Yes",$filterpost);
$oGuestbook_Field->data = array("fieldname","fieldtext");
$oGuestbook_Field->order = "sequence";
$result = $oGuestbook_Field->getList();
while($myrow=mysql_fetch_row($result)){
$oGuestbook->data[]= $myrow[0];
$oGuestbook->value[]= addslashes($$myrow[0]);
$message.=stripslashes($myrow[1])." : ".stripslashes($$myrow[0])."\n";
}
mysql_free_result($result);
$message.=$lang['guestbook']['comment']." : ".strip_tags($comment);
$oGuestbook->add();
$lastID=$oGuestbook->getLastID();
if ($oSystem->getValue("guestbook_approve")=="Yes"){
$emailfrom = $oUser->getAdminEmail();
$emailto=$oSystem->getValue("guestbook_adminemail");
$subject = stripslashes($oSystem->getValue("guestbook_notifysubject"));
$subject = str_replace("[[post_id]]",$lastID,$subject);
$body = stripslashes($oSystem->getValue("guestbook_notifymessage"));
$body = str_replace("[[approvemessage]]",$lang['guestbook']['approvemessage'],$body);
$body = str_replace("[[message]]",$message,$body);
$subject = stripslashes($subject);
$body = stripslashes($body);
if(!empty($emailfrom) && !empty($emailto)){ $oSystem->mail($emailto,$subject,$body,$emailfrom); }
else { $warning="".$lang['guestbook']['emailfail']."
"; }
} else if ($oSystem->getValue("guestbook_notify")=="Yes"){
$emailfrom = $oUser->getAdminEmail();
$emailto=$oSystem->getValue("guestbook_adminemail");
$subject = stripslashes($oSystem->getValue("guestbook_notifysubject"));
$subject = str_replace("[[post_id]]",$lastID,$subject);
$body = stripslashes($oSystem->getValue("guestbook_notifymessage"));
$body = str_replace("[[approvemessage]]","",$body);
$body = str_replace("[[message]]",$message,$body);
$subject = stripslashes($subject);
$body = stripslashes($body);
if(!empty($emailfrom) && !empty($emailto)){ $oSystem->mail($emailto,$subject,$body,$emailfrom); }
else { $warning="".$lang['guestbook']['emailfail']."
"; }
}
} else {
$pageaction="addpost"; $status_message=$status_message."
"; $comment=stripslashes($FCKeditor);
}
}
/***** Sign Guestbook *****/
if($pageaction=="addpost" || $pageaction=="makechanges"){
echo "
".$warning."".$status_message."
|
";
}
/***** Write Guestbook Comment *****/
if($post_id!="" && $pageaction=="writecomment" && $oSystem->getValue("guestbook_enablecomment")=="Yes"){
if ($pageaction2=="postwritecommment"){
if ($oSystem->getValue("guestbook_enableimage")=="Yes"){
$status_message = $oSystem->valAuthCode($lang['common']['validcode'],$validationcode,$_SESSION['image_value']);
}
$oGuestbook->validate($lang['guestbook']['name'],$author,"NotEmpty");
$oGuestbook->validate($lang['guestbook']['comment'],$commentcontent,"NotEmpty");
if ($status_message==""){
$oGuestbook_Comment->data = array("post_id","date_poster","author","commentcontent");
$oGuestbook_Comment->value = array($post_id, $curr_datetime, addslashes($author), addslashes($commentcontent));
$oGuestbook_Comment->add();
$author=""; $commentcontent="";
$status_message=$lang['guestbook']['commentadded']."
";
} else {
$author=stripslashes($author);
$commentcontent=stripslashes($commentcontent);
}
echo "";
} else if ($pageaction2=="reset") {
$author=""; $commentcontent="";
}
$oGuestbook->data=array("post_id","date_format(datepost,'$dateformat $timeformat')","comment");
$result=$oGuestbook->getDetail($post_id);
if($myrow=mysql_fetch_row($result)){
echo "
".$lang['guestbook']['name']."
| ".$lang['guestbook']['comments']."
|
";
$oGuestbook_Field->data = array("fieldname", "fieldtext");
$oGuestbook_Field->where = "display='Yes'";
$oGuestbook_Field->order = "sequence asc";
$result1 = $oGuestbook_Field->getList();
$fieldname=array(); $fieldtext=array();
while($myrow1=mysql_fetch_row($result1)){
$fieldname[]= $myrow1[0]; $fieldtext[]= $myrow1[1];
}
mysql_free_result($result1);
echo "
";
$oGuestbook->data = $fieldname;
$result1=$oGuestbook->getDetail($myrow[0]);
if ($myrow1=mysql_fetch_row($result1)){
for($i=0; $i| ".stripslashes($fieldtext[$i])." | : ".stripslashes(nl2br($myrow1[$i]))." | "; }
}
}
mysql_free_result($result1);
if ($oSystem->getValue("guestbook_posteditor")=="HTML"){
$myrow[2]=stripslashes($myrow[2]);
} else {
$myrow[2]=stripslashes(nl2br($myrow[2]));
}
echo "
|
| $myrow[1] | |
| |
| $myrow[2] |
";
$i_count=0;
$comlimit=$oSystem->getValue("guestbook_nocommentlist");
/*** get the comment here ***/
$oGuestbook_Comment->data = array("author","commentcontent");
$oGuestbook_Comment->where = "post_id='$myrow[0]'";
$oGuestbook_Comment->order = "date_poster desc limit 0,$comlimit";
$resultcom=$oGuestbook_Comment->getList();
if(mysql_num_rows($resultcom)!=0){
echo"
";
while($myrowcom=mysql_fetch_row($resultcom)){
$i_count++;
echo"| | ";
if ($i_count>1){
echo"
";
}
echo"".stripslashes($myrowcom[0])." ".$lang['guestbook']['write']." : |
| | ".stripslashes(nl2br($myrowcom[1]))."
|
";
}
mysql_free_result($resultcom);
echo" | ";
}
echo" | |
";
echo"
";
} else {
echo "
".$lang['guestbook']['nopostfound']."
";
}
mysql_free_result($result);
}
?>