function showcontent($id) { global $admin, $NPDS_Prefix; include 'header.php'; settype($id, "integer"); sql_query("UPDATE " . $NPDS_Prefix . "reviews SET hits=hits+1 WHERE id='{$id}'"); $result = sql_query("SELECT * FROM " . $NPDS_Prefix . "reviews WHERE id='{$id}'"); echo '<h2>' . translate("Reviews") . '</h2>'; echo '[ <a href="reviews.php">' . translate("Back to Reviews Index") . '</a> ]'; echo '<div class="card card-block">'; $myrow = sql_fetch_assoc($result); $id = $myrow["id"]; $fdate = f_date($myrow["date"]); $title = $myrow["title"]; $text = $myrow["text"]; $cover = $myrow["cover"]; $reviewer = $myrow["reviewer"]; $email = $myrow["email"]; $hits = $myrow["hits"]; $url = $myrow["url"]; $url_title = $myrow["url_title"]; $score = $myrow["score"]; echo ' <div class="card-text text-muted text-xs-right small"> ' . translate("Added:") . ' ' . $fdate . '<br /> </div> <h3>' . $title . '</h3><br />'; if ($cover != '') { echo '<img class="img-fluid" src="images/reviews/' . $cover . '" align="right" hspace="10" vspace="10" />'; } echo $text; echo '<hr noshade="noshade" />'; if ($admin) { echo ' <p class="text-xs-right"><b>' . translate("Admin:") . '</b> <a href="reviews.php?op=mod_review&id=' . $id . '" title="' . translate("Edit") . '" data-toggle="tooltip"><i class="fa fa-lg fa-edit"></i></a> <a href="reviews.php?op=del_review&id_del=' . $id . '" title="' . translate("Delete") . '" data-toggle="tooltip"><i class="fa fa-lg fa-trash-o"></i></a> </p>'; } if ($reviewer != '') { echo '<strong>' . translate("Reviewer") . ' :</strong> <a href="mailto:' . $email . '" >' . $reviewer . '</a><br />'; } if ($score != '') { echo '<strong>' . translate("Score:") . '</strong>'; } echo '<span class="text-success">'; display_score($score); echo '</span>'; if ($url != '') { echo "<br /><strong>" . translate("Related Link") . " :</strong> <a href=\"{$url}\" target=\"_blank\">{$url_title}</a>"; } echo '<br /><strong>' . translate("Hits:") . '</strong><span class="label label-pill label-default">' . $hits . '</span> </div>'; sql_free_result($result); global $anonpost, $moderate, $user; if (file_exists("modules/comments/reviews.conf.php")) { include "modules/comments/reviews.conf.php"; include "modules/comments/comments.php"; } include "footer.php"; }
function showcontent() { global $uimages, $prefix, $db, $module_name; if (!isset($_GET['id'])) { URL::redirect(URL::index()); } $id = intval($_GET['id']); $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $result = $db->sql_query("SELECT * FROM " . $prefix . "_reviews \n\tWHERE id='{$id}'"); if ($db->sql_numrows($result) < 1) { URL::redirect(URL::index()); } if ($page == 1 || $page == '') { $db->sql_query("UPDATE " . $prefix . "_reviews \n\t\tSET hits=hits+1 \n\t\tWHERE id='{$id}'"); } require_once 'header.php'; OpenTable(); $myrow = $db->sql_fetchrow($result); $id = $myrow['id']; $date = $myrow['date']; $year = substr($date, 0, 4); $month = substr($date, 5, 2); $day = substr($date, 8, 2); $fdate = date('F jS Y', mktime(0, 0, 0, $month, $day, $year)); $title = $myrow['title']; $text = $myrow['text']; $text = decode_bbcode($text, 1); $cover = $myrow['cover']; $reviewer = $myrow['reviewer']; $email = $myrow['email']; $hits = $myrow['hits']; $url = $myrow['url']; $url_title = $myrow['url_title']; $score = $myrow['score']; $language = $myrow['language']; $contentpages = explode('<!--pagebreak-->', $text); $pageno = count($contentpages); if ($page == '' || $page < 1) { $page = 1; } if ($page > $pageno) { $page = $pageno; } $arrayelement = (int) $page; $arrayelement--; echo '<table align="center"><tr><td>'; if ($cover != '') { echo "<img src=\"images/reviews/{$cover}\" align=\"right\" border=\"1\" hspace=\"5\" alt=\"\" />"; } echo "<span class=\"title\"><i><b>{$title}</b></i></span><br />"; echo '<div style="text-align:justify;"><blockquote>' . $contentpages[$arrayelement]; echo '</blockquote></div>'; if (can_admin(strtolower($module_name))) { echo '<b>' . _ADMIN . '</b> [ <a href="' . URL::index('&rop=mod_review&id=' . $id) . '">' . _EDIT . '</a> | <a href="' . URL::index('&rop=del_review&id_del=' . $id) . '">' . _DELETE . '</a> ]<br />'; } echo '<b>' . _ADDED . "</b> {$fdate}<br />"; if ($reviewer != '') { echo '<b>' . _REVIEWER . "</b> <a href=\"mailto:{$email}\">{$reviewer}</a><br />"; } if ($score != '') { echo '<b>' . _SCORE . '</b> '; } display_score($score); if ($url != '') { echo '<br /><b>' . _RELATEDLINK . ":</b> <a href=\"{$url}\" target=\"new\">{$url_title}</a>"; } echo '<br /><b>' . _HITS . ":</b> {$hits}"; echo '<br /><b>' . _LANGUAGE . ":</b> {$language}</td></tr></table>"; echo '<div style="text-align:center;">'; if ($pageno > 1) { echo '<br /><b>' . _PAGE . ":</b> {$page}/{$pageno}<br />"; } // $title = urlencode($title); if ($page >= $pageno) { $next_page = ''; } else { $next_pagenumber = $page + 1; if ($page != 1) { $next_page .= '<img src="images/spacer.gif" width="10" height="2" alt="" /> '; } $next_page .= ' <a href="' . URL::index("&rop=showcontent&id={$id}&page={$next_pagenumber}") . '">' . _NEXTPAGE . " ({$next_pagenumber}/{$pageno})</a>\n <a href=\"" . URL::index("&rop=showcontent&id={$id}&page={$next_pagenumber}") . '">►</a>'; } if ($page <= 1) { $previous_page = ''; } else { $previous_pagenumber = $page - 1; $previous_page = ' <a href="' . URL::index("&rop=showcontent&id={$id}&page={$previous_pagenumber}") . '">◄</a> <a href="' . URL::index("&rop=showcontent&id={$id}&page={$previous_pagenumber}") . '">' . _PREVIOUSPAGE . " ({$previous_pagenumber}/{$pageno})</a>"; } echo '' . $previous_page . " {$next_page}<br /><br />" . '[ <a href="' . URL::index() . '">' . _RBACK . '</a> | <a href="' . URL::index("&rop=postcomment&id={$id}") . '">' . _REPLYMAIN . '</a> ]</div>'; CloseTable(); if ($page == 1 || $page == '') { echo '<br />'; r_comments($id, $title); } }
function showcontent($id) { global $admin, $NPDS_Prefix; include 'header.php'; settype($id, 'integer'); sql_query("UPDATE " . $NPDS_Prefix . "reviews SET hits=hits+1 WHERE id='{$id}'"); $result = sql_query("SELECT * FROM " . $NPDS_Prefix . "reviews WHERE id='{$id}'"); $myrow = sql_fetch_assoc($result); $id = $myrow['id']; $fdate = f_date($myrow['date']); $title = $myrow['title']; $text = $myrow['text']; $cover = $myrow['cover']; $reviewer = $myrow['reviewer']; $email = $myrow['email']; $hits = $myrow['hits']; $url = $myrow['url']; $url_title = $myrow['url_title']; $score = $myrow['score']; echo ' <h2>' . translate("Reviews") . '</h2> <a href="reviews.php">' . translate("Back to Reviews Index") . '</a> <div class="card card-block"> <div class="card-text text-muted text-xs-right small"> ' . translate("Added:") . ' ' . $fdate . '<br /> </div> <hr /> <h3>' . $title . '</h3><br />'; if ($cover != '') { echo '<img class="img-fluid" src="images/reviews/' . $cover . '" />'; } echo $text; echo ' <br /><br /> <div class="card card-block">'; if ($reviewer != '') { echo '<strong>' . translate("Reviewer") . ' :</strong> <a href="mailto:' . $email . '" >' . $reviewer . '</a><br />'; } if ($score != '') { echo '<strong>' . translate("Score:") . ' : </strong>'; } echo '<span class="text-success">'; display_score($score); echo '</span>'; if ($url != '') { echo '<br /><strong>' . translate("Related Link") . ' : </strong> <a href="' . $url . '" target="_blank">' . $url_title . '</a>'; } echo '<br /><strong>' . translate("Hits:") . '</strong><span class="tag tag-pill tag-default">' . $hits . '</span> </div>'; if ($admin) { echo ' <nav class="text-xs-center"> <ul class="pagination pagination-sm"> <li class="page-item disabled"> <a class="page-link" href="#"><i class="fa fa-cogs fa-lg"></i> ' . translate("Administration Tools") . '</a> </li> <li class="page-item"> <a class="page-link" role="button" href="reviews.php?op=mod_review&id=' . $id . '" title="' . translate("Edit") . '" data-toggle="tooltip" ><i class="fa fa-lg fa-edit" ></i></a> </li> <li class="page-item"> <a class="page-link text-danger" role="button" href="reviews.php?op=del_review&id_del=' . $id . '" title="' . translate("Delete") . '" data-toggle="tooltip" ><i class="fa fa-lg fa-trash-o" ></i></a> </li> </ul> </nav>'; } echo '</div>'; sql_free_result($result); global $anonpost, $moderate, $user; if (file_exists("modules/comments/reviews.conf.php")) { include "modules/comments/reviews.conf.php"; include "modules/comments/comments.php"; } include "footer.php"; }
function showcontent($id, $page) { global $admin, $uimages, $prefix, $db, $module_name; $id = intval($id); $page = intval($page); include 'header.php'; OpenTable(); if ($page == 1 or empty($page)) { $db->sql_query("UPDATE " . $prefix . "_reviews SET hits=hits+1 WHERE id='{$id}'"); } $result = $db->sql_query("SELECT * FROM " . $prefix . "_reviews WHERE id='{$id}'"); $myrow = $db->sql_fetchrow($result); $id = intval($myrow['id']); $date = $myrow['date']; $year = substr($date, 0, 4); $month = substr($date, 5, 2); $day = substr($date, 8, 2); $fdate = date("F jS Y", mktime(0, 0, 0, $month, $day, $year)); $title = $myrow['title']; $title = filter($title, "nohtml"); $text = urldecode(filter($myrow['text'])); $cover = filter($myrow['cover'], "nohtml"); $reviewer = filter($myrow['reviewer'], "nohtml"); $email = filter($myrow['email'], "nohtml"); $hits = intval($myrow['hits']); $url = filter($myrow['url'], "nohtml"); $url_title = filter($myrow['url_title'], "nohtml"); $score = intval($myrow['score']); $rlanguage = $myrow['rlanguage']; $contentpages = explode("[--pagebreak--]", $text); $pageno = count($contentpages); if ($page == "" || $page < 1) { $page = 1; } if ($page > $pageno) { $page = $pageno; } $arrayelement = (int) $page; $arrayelement--; echo "<p><i><b><font class=\"title\">{$title}</b></i></font><br>"; echo "<BLOCKQUOTE><p align=justify>"; if (!empty($cover)) { echo "<img src=\"images/reviews/{$cover}\" align=right border=1 vspace=2 alt=\"\">"; } echo "{$contentpages[$arrayelement]}\r\n </BLOCKQUOTE><p>"; if (is_admin($admin)) { echo "<b>" . _ADMIN . "</b> [ <a href=\"modules.php?name={$module_name}&rop=mod_review&id={$id}\">" . _EDIT . "</a> | <a href=modules.php?name={$module_name}&rop=del_review&id_del={$id}>" . _DELETE . "</a> ]<br>"; } echo "<b>" . _ADDED . "</b> {$fdate}<br>"; if (!empty($reviewer)) { echo "<b>" . _REVIEWER . "</b> <a href=mailto:{$email}>{$reviewer}</a><br>"; } if (!empty($score)) { echo "<b>" . _SCORE . "</b> "; } display_score($score); if (!empty($url)) { echo "<br><b>" . _RELATEDLINK . ":</b> <a href=\"{$url}\" target=new>{$url_title}</a>"; } echo "<br><b>" . _HITS . ":</b> {$hits}"; echo "<br><b>" . _LANGUAGE . ":</b> {$rlanguage}"; if ($pageno > 1) { echo "<br><b>" . _PAGE . ":</b> {$page}/{$pageno}<br>"; } echo "</font>"; echo "</CENTER>"; if ($page >= $pageno) { $next_page = ""; } else { $next_pagenumber = $page + 1; if ($page != 1) { $next_page .= "<img src=\"images/blackpixel.gif\" width=\"10\" height=\"2\" border=\"0\" alt=\"\"> "; } $next_page .= "<a href=\"modules.php?name={$module_name}&rop=showcontent&id={$id}&page={$next_pagenumber}\">" . _NEXT . " ({$next_pagenumber}/{$pageno})</a> <a href=\"modules.php?name={$module_name}&rop=showcontent&id={$id}&page={$next_pagenumber}\"><img src=\"images/right.gif\" border=\"0\" alt=\"" . _NEXT . "\"></a>"; } if ($page <= 1) { $previous_page = ""; } else { $previous_pagenumber = $page - 1; $previous_page = "<a href=\"modules.php?name={$module_name}&rop=showcontent&id={$id}&page={$previous_pagenumber}\"><img src=\"images/left.gif\" border=\"0\" alt=\"" . _PREVIOUS . "\"></a> <a href=\"modules.php?name={$module_name}&rop=showcontent&id={$id}&page={$previous_pagenumber}\">" . _PREVIOUS . " ({$previous_pagenumber}/{$pageno})</a>"; } echo "<center>" . "{$previous_page} {$next_page}<br><br>" . "[ <a href=\"modules.php?name={$module_name}\">" . _RBACK . "</a> | " . "<a href=\"modules.php?name={$module_name}&rop=postcomment&id={$id}&title={$title}\">" . _REPLYMAIN . "</a> ]"; CloseTable(); if ($page == 1 or empty($page)) { echo "<br>"; r_comments($id, $title); } include "footer.php"; }