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); echo "<div id=\"box\">";
$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"]); } ?>
$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>'; if (count($arrcomments) == 0) {
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 . "\">"; echo "<div id=\"box\"><label>" . lang('ADMIN_ANSWER') . ":</label><br><textarea id=\"message\" name=\"message\" style=\"width:445px; height: 100px;\">{$f_message}</textarea>";
$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; if ($rf_p_user_id == $userIdme) {
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 { if ($debug_website == 'TRUE') {