$_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;
}
