$_REQUEST['score'] = $_REQUEST['score'] * 2; } $query = array('INSERT' => 'comment_id, rating, ip', 'INTO' => 'guestbook_votes', 'VALUES' => intval($_REQUEST['rate']) . ',' . intval($_REQUEST['score']) . ',"' . $db->escape($_SERVER['REMOTE_ADDR']) . '"'); $db->query_build($query) or error("Could not use insert sql for votes", __FILE__, __LINE__); } } //collect all display sql $query = array('SELECT' => ($settings['guestbook_use_comment_titles'] == 'Y' ? 'title, ' : '') . 'description, name, date_submitted, id, ip', 'FROM' => 'guestbook_comments', 'ORDER BY' => $settings['guestbook_comments_sorted_by']); if ($settings['guestbook_display_unaccepted_comments'] == 'N') { $query['WHERE'] = 'active=1'; } $comments_sql = $db->query_build($query) or error(__FILE__, __LINE__); //display comments if ($db->num_rows($comments_sql) > 0) { //paginate comments $start_limit = $settings['guestbook_comments_per_page'] * (isset($_REQUEST['page']) ? intval($_REQUEST['page']) - 1 : 0); $query['LIMIT'] = $start_limit . ',' . $settings['guestbook_comments_per_page']; $comments_sql_limit = $db->query_build($query) or error("Could not build coment limit sql", __FILE__, __LINE__); $page_number = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : '1'; $num_rows = $db->num_rows($comments_sql); $num_pages = ceil($num_rows / $settings['guestbook_comments_per_page']); $pages_string = paginate($num_pages, $page_number, 'index.php?display=guestbook&page=#p'); require OPENLD_ROOT . '/extensions/guestbook/vote_html.php'; $vh = new Vote_HTML($settings['guestbook_use_comment_rating'] == 'N' ? false : true); } require ext_theme_include('guestbook', 'guestbook.php');
require ext_theme_include('guestbook', 'admin/edit_reportet_comment.php'); } else { $query = array('SELECT' => 'title, id, description AS comment, name, date_submitted AS date, active AS active', 'FROM' => 'guestbook_comments', 'ORDER BY' => 'id DESC'); $comments_sql = $db->query_build($query) or error(__FILE__, __LINE__); //paginate comments $req_page = isset($_REQUEST['page']) ? is_numeric($_REQUEST['page']) ? $_REQUEST['page'] : '1' : '1'; $comments_per_page = 20; $start_limit = $comments_per_page * ($req_page - 1); $query['LIMIT'] = $start_limit . ',' . $comments_per_page; $comments_sql_limit = $db->query_build($query) or error(__FILE__, __LINE__); $page_number = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : '1'; $num_rows = $db->num_rows($comments_sql); $num_pages = ceil($num_rows / $comments_per_page); $pages_string = paginate($num_pages, $page_number, 'admin_plugins.php?extension=guestbook&page=#p'); switch ($settings['guestbook_use_comment_rating']) { case '-2': case '1-2': case '5-2': case '10-2': $edit_reported = '<br /><br /><a href="admin_plugins.php?extension=guestbook&reported_comments=1">Edit reported comments</a>'; break; default: $edit_reported = ''; } require ext_theme_include('guestbook', 'admin/admin_edit.php'); }
<?php $topsite_sql = $topsite_sql_limit = array('SELECT' => 'id, title, url, description, date_submitted, hits', 'FROM' => 'links', 'WHERE' => 'hits>0', 'ORDER BY' => 'hits DESC, date_submitted DESC'); $topsite_sql = $db->query_build($topsite_sql) or error(__FILE__, __LINE__); $req_page = isset($_GET['page']) ? $_GET['page'] : 1; //number of links per page $link_limit = 20; $topsite_sql_limit['ORDER BY'] = 'hits DESC, date_submitted DESC'; $topsite_sql_limit['LIMIT'] = $link_limit * (intval($req_page) - 1) . ', ' . $link_limit; $topsite_sql_limit = $db->query_build($topsite_sql_limit) or error(__FILE__, __LINE__); //pagination $num_rows = $db->num_rows($topsite_sql); $num_pages = ceil($num_rows / $link_limit); $pagination = paginate($num_pages, $req_page, 'index.php?display=topsites&page=#p'); require ext_theme_include('top_sites', 'topsite_html.php');
//detail sql $query = array('SELECT' => 'l.title, l.description, l.name, l.date_submitted, l.category_id, l.url, c.title', 'FROM' => 'links AS l', 'JOINS' => array(array('INNER JOIN' => 'categories AS c', 'ON' => 'l.category_id=c.id')), 'WHERE' => 'l.id=' . intval($_REQUEST['comments']) . ($settings['display_unaccepted_links'] == 'N' ? ' AND l.active=1' : '')); $detail_sql = $db->query_build($query) or error("Could not the link joined with it's category", __FILE__, __LINE__); $details = $db->fetch_row($detail_sql); $query = array('SELECT' => ($settings['use_comment_titles'] == 'Y' ? 'title, ' : '') . 'description, name, date_submitted, id, ip', 'FROM' => 'comments', 'WHERE' => 'link_id=' . intval($_REQUEST['comments']) . ($settings['display_unaccepted_comments'] == 'N' ? ' AND active=1' : ''), 'ORDER BY' => $settings['comments_sorted_by']); $comments_sql = $db->query_build($query) or error(__FILE__, __LINE__); //display comments if ($db->num_rows($comments_sql) > 0) { //paginate comments $start_limit = $settings['comments_per_page'] * (isset($_REQUEST['page']) ? intval($_REQUEST['page']) - 1 : 0); $query['LIMIT'] = $start_limit . ',' . $settings['comments_per_page']; $comments_sql_limit = $db->query_build($query) or error("Could not build coment limit sql", __FILE__, __LINE__); $page_number = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : '1'; $num_rows = $db->num_rows($comments_sql); $num_pages = ceil($num_rows / $settings['comments_per_page']); $pages_string = paginate($num_pages, $page_number, 'index.php?comments=' . $_REQUEST['comments'] . '&page=#p'); require OPENLD_ROOT . '/extensions/link_comments/vote_html.php'; $vh = new Vote_HTML($settings['use_comment_rating'] == 'N' ? false : true); } require ext_theme_include('link_comments', 'comments.php');
function ext_theme_page($ext_name, $short_path) { global $page, $settings, $db; $page = ExtensionPaths::get_theme_page_filepath(ext_theme_include($ext_name, $short_path)); return true; }