$date = date('d.m.Y', strtotime($date));
echo "<div class=\"ticketb_m\"><b>Date</b><br>{$date}</div>";
echo "<div class=\"ticketb_r\"><b>Category</b><br>{$cat_out}</div>";
echo "</div><div id=\"answerbox\" style=\"display:none;\">";
// get username from ticket
$userticketname = $row["ufrom"];
// connect to db
$mysqli_getun = getConnected("account");
$res_getun = mysqli_query($mysqli_getun, "SELECT login FROM account WHERE id='" . $userticketname . "'");
while ($row_getun = mysqli_fetch_array($res_getun)) {
$userticketname = $row_getun["login"];
}
mysqli_close($mysqli_getun);
$date2 = date('d-m-Y h:i A', strtotime($row["time"]));
echo "<b>by " . $userticketname . " on {$date2}:</b><br>";
$bb = new bbParser();
echo $bb->getHtml($row["message"]) . "<br><br>";
// answers
$mysqli3 = getConnected("account");
$res3 = mysqli_query($mysqli3, "SELECT * FROM cms_answers WHERE messageid='" . $form_id . "' ORDER BY id ASC");
while ($row3 = mysqli_fetch_array($res3)) {
$ansermessage = $row3["message"];
// get username from ticket
$useranswername = $row3["ufrom"];
// connect to db
$mysqli4 = getConnected("account");
$res4 = mysqli_query($mysqli4, "SELECT login FROM account WHERE id='" . $useranswername . "'");
while ($row4 = mysqli_fetch_array($res4)) {
$useranswername = $row4["login"];
}
mysqli_close($mysqli4);
$bb[] = "#\\[i\\](.*?)\\[/i\\]#si";
$html[] = "<i>\\1</i>";
$bb[] = "#\\[u\\](.*?)\\[/u\\]#si";
$html[] = "<u>\\1</u>";
$bb[] = "#\\[quote\\](.*?)\\[/quote\\]#si";
$html[] = "<center><div class='epboxc' width='80%' align='left'><b><i>Quote</i></b><br><b>“</b><i>\\1</i><b>”</b></div></center>";
$bb[] = "#\\[youtube\\](.*?)\\[/youtube\\]#si";
$html[] = '<center><iframe width="300" height="169" src="//www.youtube.com/embed/\\1" frameborder="0" allowfullscreen></iframe></center>';
$bb[] = "#\\[hr\\]#si";
$html[] = "<hr>";
$bb[] = "#\\[code\\](.*?)\\[/code\\]#si";
$html[] = "<center><div class='epboxc' width='80%' align='left'><b><i><font size=0.5>Code</font></i></b><hr><div class=php><pre class=\"code\">\\1</pre></div></div></center>";
$str = str_replace('http://youtu.be/', '', $str);
$str = preg_replace($bb, $html, $str);
$patern = "#\\[url href=([^\\]]*)\\]([^\\[]*)\\[/url\\]#i";
$replace = '<a href="\\1" target="_blank" rel="nofollow">\\2</a>';
$str = preg_replace($patern, $replace, $str);
$patern = "#\\[img\\]([^\\[]*)\\[/img\\]#i";
$replace = '<img src="\\1" alt="" style="max-height:400px;max-width:500px"/>';
$str = preg_replace($patern, $replace, $str);
//$str=nl2br($str);
return $str;
}
}
if (!empty($_GET["bbcode"])) {
$bb = new bbParser();
echo $bb->getHtml($_GET["bbcode"]);
}
?>
if (ip_is_baned($_SERVER[REMOTE_ADDR])) {
$error .= '<li>' . __('Вы забанены на данном сайте') . ', ' . __('Вам запрещено писать комментарии') . '</li>';
}
print_r($error);
echo '-----------------' . $cattcha;
$search_bad_words = array("'хуй'siU", "'пизд'siU", "'ёб'siU", "'сука'siU", "'суки'siU", "'дроч'siU", "'хуя'siU", "'ссуч'siU");
$replace = array("*", "*", "*", "*", "*", "*", "*", "*");
$msg = strip_tags($msg);
$msg = preg_replace($search_bad_words, $replace, $msg);
$yourname = preg_replace($search_bad_words, $replace, $yourname);
if (empty($error)) {
$msg = nl2br($msg);
$msg = str_replace("\n", " ", $msg);
$msg = str_replace("\r", " ", $msg);
require_once CODE . 'bbParser.php';
$bbcode = new bbParser($disableURL);
$msg = $bbcode->getHtml($msg);
addcomments((int) $idmess, $commentsfilename, $msg, $yourname, $email);
$msg = '';
@setcookie('flood_news', $newsflood, time() + $newsflood);
}
}
if (empty($yourname)) {
$yourname = $_SESSION['name'];
}
if (file_exists($commentsfilename)) {
$commentpage = isset($_GET['commentpage']) ? (int) $_GET['commentpage'] : 0;
$arrcomments = getcomments($commentsid, $commentsfilename, $moder_comments);
$arrcomments = array_reverse($arrcomments);
$countcomments = getcountcomments($commentsid, $commentsfilename, $moder_comments);
echo '<br /><br /><div class="comment_head"><a name="comment_begin"></a><h3>' . __('Комментарии') . ':</h3></div><hr>';
$res2 = mysqli_query($mysqli2, "SELECT * FROM cms_cat WHERE catid='{$getcat}'");
while ($row2 = mysqli_fetch_array($res2)) {
$cat_out = $row2["name"];
}
mysqli_close($mysqli2);
// Output
echo "<div id=\"box\" class=\"toggle\">{$statusc} <div class=\"ticketsub\">" . $row["subject"] . "</div>";
echo "<hr>";
echo "<div class=\"ticketb_l\"><b>Ticket ID</b><br>" . $row["ticketid"] . "</div>";
echo "<div class=\"ticketb_m\"><b>Priority</b><br>{$priorityc}</div>";
// get date
$date = date('d-m-Y', strtotime($row["time"]));
echo "<div class=\"ticketb_m\"><b>Date</b><br>{$date}</div>";
echo "<div class=\"ticketb_r\"><b>Category</b><br>{$cat_out}</div>";
echo "</div><div id=\"answerbox\" style=\"display:none;\">";
$bb = new bbParser();
echo $bb->getHtml($row["message"]) . "<br><br>";
// answers
$mysqli3 = getConnected("account");
$res3 = mysqli_query($mysqli3, "SELECT * FROM cms_answers WHERE messageid='" . $row["id"] . "' ORDER BY id DESC");
while ($row3 = mysqli_fetch_array($res3)) {
$ansermessage = $row3["message"];
echo "<div id=\"box\">";
$date2 = date('d-m-Y h:i A', strtotime($row3["time"]));
echo "<b>by Administrator on {$date2}:</b><br>" . $bb->getHtml($ansermessage);
echo "</div>";
}
mysqli_close($mysqli3);
// if on hold - show answer link
if ($row["status"] == "2") {
echo "<form method=\"post\" action=\"" . $PHP_SELF . "\">";
// Show user main pic
$ID02 = $rf_p_user_id;
echo "<br><a href='{$site_url_link}member/{$rf_p_user_id}/'>{$rf_p_user_name}</a> ";
//Show user's membership status
$up_get_mem_status = get_up_info_mem_status($rf_p_user_id);
echo "<br> {$up_get_mem_status} ";
// Display how long ago this was posted
$timestart = "{$rf_p_timestamp}";
//Time of post
require_once "models/timediff.php";
echo "<br><font color=green> " . dateDiff("now", "{$timestart}", 1) . " ago</font> ";
echo "</td></tr></table>";
echo "</td><td class='forum_title_body' valign='top'>";
//Format the content with bbcode
require_once 'models/bbParser.php';
$parser = new bbParser();
$rf_p_content_bb = $parser->getHtml($rf_p_content);
echo "<pre class='forum'>{$rf_p_content_bb}</pre>";
echo "</td><td class='forum_title_body' valign='top' width='100'>";
echo "<table width='100%' border='0' cellspacing='0' cellpadding='0'><tr><td align='center' valign='top'>";
if ($rf_p_edit_date != NULL) {
// Display how long ago this was posted
$timestart = "{$rf_p_edit_date}";
//Time of post
require_once "models/timediff.php";
echo "<font color=red>Edited</font><br><font color=red> " . dateDiff("now", "{$timestart}", 1) . " ago</font> <br><br>";
}
echo "</td></tr><tr><td align='center' valign='bottom'>";
// If user owns this content show forum buttons for edit and delete
if (isUserLoggedIn()) {
global $userIdme;
//For Testing
echo "List of users that have posted in this topic along with thier emails<br><br>";
//Get User Ids based on forum topic id
//Only sends one email per user except the user currently posting
//Use Join to get the original posters email
$query_get_uids = "\n\t\t\t\t\tSELECT * FROM (\n\t\t\t\t\t\t(\n\t\t\t\t\t\tSELECT fpr_user_id AS F_UID\n\t\t\t\t\t\tFROM " . $db_table_prefix . "forum_posts_replys \n\t\t\t\t\t\tWHERE fpr_post_id = '{$f_topic_id}' \n\t\t\t\t\t\tAND subcribe_email = 'YES'\n\t\t\t\t\t\tAND NOT fpr_user_id = '{$f_cur_usr_id}'\n\t\t\t\t\t\tGROUP BY fpr_user_id\n\t\t\t\t\t\tORDER BY fpr_timestamp DESC\n\t\t\t\t\t\t)\n\t\t\t\t\t\tUNION ALL\n\t\t\t\t\t\t(\n\t\t\t\t\t\tSELECT forum_user_id AS F_UID\n\t\t\t\t\t\tFROM " . $db_table_prefix . "forum_posts\n\t\t\t\t\t\tWHERE forum_post_id = '{$f_topic_id}'\n\t\t\t\t\t\tAND subcribe_email = 'YES'\n\t\t\t\t\t\tAND NOT forum_user_id = '{$f_cur_usr_id}'\n\t\t\t\t\t\tGROUP BY forum_user_id\n\t\t\t\t\t\tORDER BY forum_timestamp DESC\n\t\t\t\t\t\t) \n ) AS uniontable\n\t\t\t\t\tGROUP BY `F_UID`\n ORDER BY `F_UID` ASC\n\t\t\t\t";
if ($result_get_uids = $mysqli->query($query_get_uids)) {
$arr_get_uids = $result_get_uids->fetch_all(MYSQLI_BOTH);
foreach ($arr_get_uids as $row_get_uids) {
$f_topic_get_user_id = $row_get_uids['F_UID'];
$f_topic_get_user_name = get_user_name_2($f_topic_get_user_id);
$f_topic_get_email = get_user_email($f_topic_get_user_id);
$f_cur_user_name = get_user_name_2($userIdme);
//Format the content with bbcode
require_once 'models/bbParser.php';
$parser = new bbParser();
$forum_content = $parser->getHtml($forum_content);
echo "Username: {$f_topic_get_user_name} AND UserID: {$f_topic_get_user_id} AND UserEmail: OK";
//Send user an email notification
//Start of mail
$adminmail = $f_topic_get_email;
$usersub = "{$websiteName} - Forum - {$f_cur_user_name} replied to {$f_cur_topic_title}";
$usermsg = "{$websiteName} - Forum Notification\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<br><br>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tCategory: {$f_cur_topic_cat}\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<br>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tTopic: {$f_cur_topic_title}\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<br>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tReply by: {$f_cur_user_name}\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<br><br>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tReply Content:\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<br>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t************************<br>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$forum_content}\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<br>************************";
$usermsg2 = " You may check the reply at <a href={$redir_link_url}>{$redir_link_url}</a>";
$username = "******";
//Mail file that setup the email and sends it based on input above
require "models/mail.php";
//End of mail
echo "<br>";
}
} else {
