*
* This file is $Revision: 356 $
* $HeadURL: https://svn.sf.net/svnroot/camranbss/camra/nbss/version2/login/index.php $
**/
$title = 'Login';
include '../includes/base.php';
include DOCROOT . '/skin/header.php';
$form = new Form('nbssv2login');
$form->class = 'neoAdminForm';
$form->validationerrormsg = 'The following fields must be completed:';
if ($form->submitted && $form->submiterrors == 0) {
$user = getUserLogin(md5(strtoupper(trim(ltrim($request->get('post', 'membershipno'), '0')))), md5(strtoupper(str_replace(' ', '', $request->get('post', 'postcode')))));
if ($user !== false) {
Session::set('user', $user);
Session::set('welcomed', false);
getQueryResults('UPDATE ' . $config->get('database', 'tablePrefix') . 'user SET lastlogin='******'YmdHis', time()) . ' WHERE id=' . $user['id']);
header('Location: ' . $config->get('web', 'root') . '/');
exit;
} else {
$form->submiterrormsg .= 'Invalid membership number, postcode or inactive account.';
}
}
$form->addFieldsetOpen('Login');
$form->addField('membershipno', 'text', $request->get('post', 'membershipno'));
$form->addLabel('Membership Number');
$form->addFieldValidation('required');
$form->addHelp('Please use the membership number from your CAMRA membership card.');
$form->addField('postcode', 'text', $request->get('post', 'postcode'));
$form->addLabel('Postcode');
$form->addFieldValidation('required');
$form->addHelp('Enter your postcode from your normal residence (You know, where CAMRA sends your "What\'s Brewing".)');
if (strlen($submission['beername-' . $i . '-' . $j])) {
$beername = $submission['beername-' . $i . '-' . $j];
$rating = intval($submission['rating_id-' . $i . '-' . $j]) - 1;
} elseif (1 == $submission['nora-' . $i]) {
$beername = 'No Real Ale Available';
$rating = '';
print '<input type="hidden" name="nora-' . $i . '" value="1" /';
} else {
if (!strlen($submission['beer_id-' . $i . '-' . $j])) {
if (strlen($submission['beername-' . $i . '-' . $j])) {
$beername = $submission['beername-' . $i . '-' . $j];
} else {
$beername = 'None specified';
}
} else {
$beer = reset(getQueryResults('SELECT brewery.name as brewery, beer.name as beer FROM ' . $config->get('database', 'tablePrefix') . 'brewery brewery, ' . $config->get('database', 'tablePrefix') . 'beer beer WHERE beer.brewery_id=brewery.id AND beer.id=' . $submission['beer_id-' . $i . '-' . $j]));
$beername = $beer['brewery'] . ', ' . $beer['beer'];
}
$rating = intval($submission['rating_id-' . $i . '-' . $j]) - 1;
}
$submission['notes-' . $i . '-' . $j] = htmlentities($submission['notes-' . $i . '-' . $j]);
echo <<<EOT
t<tr>
t\t<td>{$pub['town']}</td>
t\t<td>{$pub['name']}<input type="hidden" name="pub_id-{$i}" value="{$submission['pub_id-' . $i]}" /></td>
t\t<td>{$beername}
t\t\t<input type="hidden" name="rating_id-{$i}-{$j}" value="{$submission['rating_id-' . $i . '-' . $j]}" />
t\t\t<input type="hidden" name="brewery_id-{$i}-{$j}" value="{$submission['brewery_id-' . $i . '-' . $j]}" />
t\t\t<input type="hidden" name="beer_id-{$i}-{$j}" value="{$submission['beer_id-' . $i . '-' . $j]}" />
t\t\t<input type="hidden" name="beername-{$i}-{$j}" value="{$submission['beername-' . $i . '-' . $j]}" />
t\t</td>
**/
$title = 'Results';
$access = array('superreviewer', 'admin', 'sysadmin');
include '../includes/base.php';
include DOCROOT . '/skin/header.php';
$sortcol = isset($_REQUEST['sortcol']) ? $_REQUEST['sortcol'] : 'avg_score';
$sortorder = isset($_REQUEST['sortorder']) && $_REQUEST['sortorder'] == 'asc' ? SORT_ASC : SORT_DESC;
$show = isset($_REQUEST['show']) ? $_REQUEST['show'] : 10;
$start = isset($_REQUEST['start']) ? $_REQUEST['start'] : '';
$stop = isset($_REQUEST['stop']) ? $_REQUEST['stop'] : '';
$town_id = isset($_REQUEST['town_id']) ? $_REQUEST['town_id'] : '';
$min_dates = isset($_REQUEST['min_dates']) ? $_REQUEST['min_dates'] : 0;
$min_reviewers = isset($_REQUEST['min_reviewers']) ? $_REQUEST['min_reviewers'] : 0;
$min_avg = isset($_REQUEST['min_avg']) ? $_REQUEST['min_avg'] : 0;
$stats = getPubStats($sortcol, $sortorder, $show, $start, $stop, $town_id, $min_dates, $min_reviewers, $min_avg);
$towns = getQueryResults('SELECT * FROM ' . $config->get('database', 'tablePrefix') . 'town WHERE active=1 ORDER BY name ASC;');
?>
<form method="post" action="<?php
echo $config->get('web', 'root');
?>
/results/" id="resultform">
<input type="hidden" name="sortcol" value="<?php
print $sortcol;
?>
" />
<input type="hidden" name="sortorder" value="<?php
print $sortorder;
?>
" />
<p>
Show: <select name="show">
}
getQueryResults($sql);
header('Location: ' . $config->get('web', 'root') . $location);
exit;
} elseif ('deleteUser' == $form->submittedaction) {
getQueryResults('DELETE FROM user WHERE id=' . $request->get('post', 'member_id'));
header('Location: ' . $config->get('web', 'root') . '/admin/?msg=User+deleted');
exit;
}
} else {
if (!is_null($member_id) && '' != $member_id && 'new' != $member_id) {
$member = reset(getQueryResults('SELECT * FROM ' . $config->get('database', 'tablePrefix') . 'user WHERE id=' . $member_id));
} elseif ('new' == $member_id) {
$member = array('id' => 'new', 'firstname' => $request->get('post', 'firstname') ? $request->get('post', 'firstname') : '', 'lastname' => $request->get('post', 'lastname') ? $request->get('post', 'lastname') : '', 'type' => 'reviewer', 'camra_number' => $request->get('post', 'camra_number') ? $request->get('post', 'camra_number') : '', 'postcode' => $request->get('post', 'postcode') ? $request->get('post', 'postcode') : '', 'email' => $request->get('post', 'email') ? $request->get('post', 'email') : '', 'active' => $request->get('post', 'active') != 1 ? 0 : 1);
} else {
$members = getQueryResults('SELECT id, CONCAT(lastname, \', \', firstname) as name FROM `' . $config->get('database', 'tablePrefix') . 'user` ORDER BY `lastname`,`firstname`;');
}
}
if (isset($members)) {
$form->addField('member_id', 'select');
$form->addLabel('Select Member');
$form->addOptions(array('new' => 'Add New Member'));
$form->addOptions($members, 'id', 'name');
$form->addField('selectMember', 'submit', 'Select Member');
$form->addInputClass('btnSubmit');
} else {
$form->addField('member_id', 'hidden', $member['id']);
$form->addField('firstname', 'text', $member['firstname']);
$form->addLabel('Firstname');
$form->addFieldValidation('required');
$form->addField('lastname', 'text', $member['lastname']);
//sort date for filename
if (strlen($start) && strlen($stop)) {
if ($start < $stop) {
$tmp = $start;
$start = $stop;
$stop = $tmp;
}
$startdate = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - $start, date('Y')));
$stopdate = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - $stop, date('Y')));
$date = true;
} else {
$date = false;
}
//sort users for filename
if ($reviewer_id > 0) {
$reviewer = getQueryResults('SELECT `lastname`,`firstname` FROM `' . $config->get('database', 'tablePrefix') . 'reviewer` WHERE `id`=' . $reviewer_id);
$filename = $reviewer[0]['lastname'] . '_' . $reviewer[0]['firstname'];
} else {
$filename = 'All';
}
if ($date) {
$filename .= '-' . $startdate . '_to_' . $stopdate;
} else {
$filename .= '-All_Dates';
}
if ($show > 0) {
$filename .= '-Last_' . $show . '_Reviews';
} else {
$filename .= '-All_Reviews';
}
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
break;
case 'getAllQuestionsFromQuiz':
echo getAllQuestionsFromQuiz($_POST['quizname']);
break;
case 'sendResults':
echo sendResults($_POST['username'], $_POST['password'], $_POST['quizname'], $_POST['timetaken'], $_POST['score'], $_POST['date']);
break;
case 'getResults':
echo getResults($_POST['username'], $_POST['password']);
break;
case 'checkPassword':
echo checkPassword($_POST['username'], $_POST['password']);
break;
case 'getAllResults':
echo getAllResults();
break;
case 'getQueryResults':
echo getQueryResults($_POST['fname'], $_POST['lname'], $_POST['quiz'], $_POST['coursecode']);
break;
case 'getQuizzes':
echo getQuizes();
break;
}
}
?>
$form->addField('active', 'checkbox', $pub['active']);
$form->addLabel('Active', null, 'right');
$form->addOptions(array(1, 0));
$form->addField('notes', 'textarea', $pub['notes']);
$form->addLabel('Notes');
if ('new' == $pub_id) {
$form->addField('updatePub', 'submit', 'Create pub');
} else {
$form->addField('updatePub', 'submit', 'Update pub');
}
$form->addInputClass('btnSubmit');
$form->addField('resetForm', 'reset', 'Reset Form');
$form->addInputClass('btnReset');
$form->addContent('<div class="reset"><a class="btnReset fleft" href="' . $config->get('web', 'root') . '/admin/pubs/?town_id=' . $town_id . '">Cancel & Pick another pub</a></div>');
} else {
$pubs = getQueryResults('SELECT * FROM ' . $config->get('database', 'tablePrefix') . 'pub WHERE town_id=' . $town_id);
?>
<div class="reset"><a class="btnReset fleft" href="<?php
echo $config->get('web', 'root');
?>
/admin/pubs/?town_id=<?php
echo $town_id;
?>
&pub_id=new">Add new pub</a></div>
<div class="reset"><a class="btnReset fleft" href="<?php
echo $config->get('web', 'root');
?>
/admin/pubs/">Go back to the town list</a></div>
<p class="clear">Or edit existing pubs:</p>
<?php
print '<ul>';
include '../../includes/base.php';
include DOCROOT . '/skin/header.php';
if ($request->get('post', 'id')) {
$submission_id = $request->get('post', 'id');
} elseif ($request->get('get', 'id')) {
$submission_id = $request->get('get', 'id');
} else {
header('Location: ' . $config->get('web', 'root') . '/history/');
exit;
}
$tablePrefix = $config->get('database', 'tablePrefix');
$sql = <<<EOQ
SELECT beer.name as beer, brewery.name as brewery, town.name as town, pub.name as pub, review.reviewed as date
FROM
{$tablePrefix}review as review,
{$tablePrefix}town as town,
{$tablePrefix}pub as pub
RIGHT JOIN ({$tablePrefix}beer as beer ON review.beer_id = beer.id
INNER JOIN ({$tablePrefix}brewery as brewery ON beer.brewery_id = brewery.id)
)
WHERE review.pub_id = pub.id
AND pub.town_id = town.id
AND review.id = {$submission_id};
EOQ;
print $sql;
$submission = getQueryResults($sql);
?>
<h2>Delete Review</h2>
<?php
print_r($submission);
include DOCROOT . '/skin/footer.php';
$form->addFieldsetOpen('Drink ' . ($drinkIndex + 1) . ' Details');
$brewery_id = $request->get('post', 'brewery_id-' . $pubIndex . '-' . $drinkIndex);
if ('' == $brewery_id) {
/* brewery not selected so show the list */
$form->addField('brewery_id-' . $pubIndex . '-' . $drinkIndex, 'select', $brewery_id);
$form->addLabel('Brewery');
$form->addOptions(array('' => 'Select brewery'));
$form->addOptions($breweries, 'id', 'name');
$form->addField('selectBrewery', 'submit', 'Select this brewery');
$form->addInputClass('btnSubmit');
$beers = array('' => 'Select brewery first');
} else {
/* brewery selected, get beers */
$brewery = getItemFromArray($brewery_id, $breweries);
$beers = array('' => 'Select beer');
$beers = array_merge($beers, getQueryResults('SELECT * FROM ' . $config->get('database', 'tablePrefix') . 'beer WHERE brewery_id=' . $brewery_id . ';'));
$form->addField('brewery_id-' . $pubIndex . '-' . $drinkIndex, 'hidden', $brewery_id);
$form->addContent('<div><p class="fieldSubstitute"><span class="label">Brewery:</span><span class="input">' . $brewery['name'] . '</span></p></div>');
}
$form->addField('beer_id-' . $pubIndex . '-' . $drinkIndex, 'select', $request->get('post', 'beer_id-' . $pubIndex . '-' . $drinkIndex));
$form->addLabel('Beer');
$form->addOptions($beers, 'id', 'name');
$form->addContent('<p class="optionseparator">or</p>');
$form->addField('beername-' . $pubIndex . '-' . $drinkIndex, 'text', $request->get('post', 'beername-' . $pubIndex . '-' . $drinkIndex));
$form->addLabel('Unlisted Brewery/Beer');
$form->addHelp('If your beer cannot be found in the lists above, please include the Brewery and the Name of the beer and we will add popular ones to the list.');
$form->addField('rating_id-' . $pubIndex . '-' . $drinkIndex, 'select', $request->get('post', 'rating_id-' . $pubIndex . '-' . $drinkIndex));
$form->addLabel('Rating');
$form->addOptions($ratings, 'id', 'name');
$form->addHelp($ratingsHelpContent);
$form->addField('notes-' . $pubIndex . '-' . $drinkIndex, 'textarea', $request->get('post', 'notes-' . $pubIndex . '-' . $drinkIndex));
/**
* Get statistics for Reviewer
*
*/
function getReviewerStats($reviewer_id, $sortcol = 'avg_score', $sortorder = SORT_DESC, $limit, $start = '', $stop = '')
{
global $config;
if (strlen($start) && strlen($stop)) {
if ($start < $stop) {
$tmp = $start;
$start = $stop;
$stop = $tmp;
}
$startdate = '\'' . date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - $start, date('Y'))) . '\'';
$stopdate = '\'' . date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - $stop, date('Y'))) . '\'';
$date = true;
} else {
$date = false;
}
$sql = 'SELECT Max(review.reviewed) as lastvisit, town.name AS town, pub.name AS pub, Avg(rating.score) AS avg_score, Max(rating.score) AS max_score, Min(rating.score) AS min_score, variance(rating.score) as var_score, Count(rating.id) AS reviews, Count(distinct review.reviewed) AS dates ';
$sql .= 'FROM ' . $config->get('database', 'tablePrefix') . 'town town, ' . $config->get('database', 'tablePrefix') . 'pub pub, ' . $config->get('database', 'tablePrefix') . 'rating rating, ' . $config->get('database', 'tablePrefix') . 'review review ';
$sql .= 'WHERE rating.id=review.rating_id ';
$sql .= 'AND review.reviewer_id=' . $reviewer_id;
$sql .= ' AND pub.id=review.pub_id ';
$sql .= 'AND town.id=pub.town_id ';
$sql .= $date ? 'AND (review.reviewed BETWEEN ' . $startdate . ' AND ' . $stopdate . ') ' : '';
$sql .= 'AND archived IS NULL ';
$sql .= 'GROUP BY town.name, pub.name';
$results = getQueryResults($sql);
$disporder = array();
foreach ($results as $pub) {
$disporder[] = $pub[$sortcol];
}
array_multisort($disporder, $sortorder, $results);
if ($limit > 0 && sizeof($results) > $limit) {
$results = array_slice($results, 0, $limit);
}
return $results;
}
<?php
/**
* Last updated $Date: 2007-03-13 08:51:52 +0000 (Tue, 13 Mar 2007) $
* by $Author: andybrock $
*
* This file is $Revision: 341 $
* $HeadURL: https://svn.sf.net/svnroot/camranbss/camra/nbss/version2/api/pub/index.php $
**/
define('NOSESSION', true);
include '../../includes/base.php';
$expiresOffset = 3600 * 24 * 10;
header('Content-type: text/plain');
header('Cache-Control: public');
header("Expires: " . gmdate("D, d M Y H:i:s", time() + $expiresOffset) . " GMT");
$query = $_GET['query'];
if (stripos($query, ',')) {
$query = explode(',', $query);
$results = getQueryResults('SELECT town.name as town, pub.name as pub, pub.id FROM ' . $config->get('database', 'tablePrefix') . 'pub pub, ' . $config->get('database', 'tablePrefix') . 'town town WHERE pub.town_id=town.id AND pub.name LIKE \'' . trim($query[1]) . '%\' AND town.name LIKE \'' . trim($query[0]) . '%\' ORDER BY town.name, pub.name');
} else {
$results = getQueryResults('SELECT town.name as town, pub.name as pub, pub.id FROM ' . $config->get('database', 'tablePrefix') . 'pub pub, ' . $config->get('database', 'tablePrefix') . 'town town WHERE pub.town_id=town.id AND (pub.name LIKE \'' . $query . '%\' OR town.name LIKE \'' . $query . '%\') ORDER BY town.name, pub.name');
}
sendResults($query, $results);
function sendResults($query, $results)
{
foreach ($results as $result) {
print "{$result['town']}, {$result['pub']}\t{$result['id']}\n";
}
}
if ('new' == $brewery_id) {
$sql = "INSERT INTO " . $config->get('database', 'tablePrefix') . "brewery (name, location, active) VALUES ('{$brewery['name']}', '{$brewery['location']}', {$brewery['active']});";
} else {
$sql = "UPDATE " . $config->get('database', 'tablePrefix') . "brewery SET name='{$brewery['name']}', location='{$brewery['location']}', active={$brewery['active']} WHERE id={$brewery['id']};";
}
getQueryResults($sql);
}
}
} else {
/* Form has not been submitted */
if (!is_null($brewery_id) && '' != $brewery_id && 'new' != $brewery_id) {
$brewery = reset(getQueryResults('SELECT * FROM ' . $config->get('database', 'tablePrefix') . 'brewery WHERE id=' . $brewery_id));
} elseif ('new' == $brewery_id) {
$brewery = array('id' => 'new', 'name' => '', 'location' => '', 'active' => 1);
} else {
$breweries = getQueryResults('SELECT id, name FROM ' . $config->get('database', 'tablePrefix') . 'brewery WHERE active=1 ORDER BY name;');
}
}
if (isset($breweries)) {
$form->addField('brewery_id', 'select');
$form->addLabel('Select Brewery');
$form->addOptions(array('new' => 'Add New Brewery'));
$form->addOptions($breweries, 'id', 'name');
$form->addField('selectBrewery', 'submit', 'Select Brewery');
$form->addInputClass('btnSubmit');
} else {
$form->addField('brewery_id', 'hidden', $brewery['id']);
$form->addField('name', 'text', $brewery['name']);
$form->addLabel('Brewery Name');
$form->addFieldValidation('required');
$form->addField('location', 'text', $brewery['location']);
<?php
/**
* Last updated $Date: 2007-03-13 08:51:52 +0000 (Tue, 13 Mar 2007) $
* by $Author: andybrock $
*
* This file is $Revision: 341 $
* $HeadURL: https://svn.sf.net/svnroot/camranbss/camra/nbss/version2/api/beer/index.php $
**/
define('NOSESSION', true);
include '../../includes/base.php';
$expiresOffset = 3600 * 24 * 10;
header('Content-type: text/plain');
header('Cache-Control: public');
header("Expires: " . gmdate("D, d M Y H:i:s", time() + $expiresOffset) . " GMT");
$query = $_GET['query'];
if (stripos($query, ',')) {
$query = explode(',', $query);
$results = getQueryResults('SELECT brewery.name as brewery, beer.name as beer, beer.id FROM ' . $config->get('database', 'tablePrefix') . 'beer beer, ' . $config->get('database', 'tablePrefix') . 'brewery brewery WHERE beer.brewery_id=brewery.id AND beer.name LIKE \'' . trim($query[1]) . '%\' AND brewery.name LIKE \'' . trim($query[0]) . '%\' ORDER BY brewery.name, beer.name');
} else {
$results = getQueryResults('SELECT brewery.name as brewery, beer.name as beer, beer.id FROM ' . $config->get('database', 'tablePrefix') . 'beer beer, ' . $config->get('database', 'tablePrefix') . 'brewery brewery WHERE beer.brewery_id=brewery.id AND (beer.name LIKE \'' . trim($query) . '%\' OR brewery.name LIKE \'' . trim($query) . '%\') ORDER BY brewery.name, beer.name');
}
sendResults($query, $results);
function sendResults($query, $results)
{
foreach ($results as $result) {
print "{$result['brewery']}, {$result['beer']}\t{$result['id']}\n";
}
}
$content .= 'Auto Activated: ' . ($member['active'] ? 'Yes' : 'No') . CR;
$content .= 'Signup from IP address: ' . $_SERVER['REMOTE_ADDR'] . CR;
$content .= 'On: ' . date('D jS M Y H:i:s');
$content .= CR . CR . 'Thank you.';
mail($config->get('web', 'signupEmail'), $subject, $content, $headers);
}
$date = gmdate('YmdHis', time());
$camra_number = md5(strtoupper(trim(ltrim($member['camra_number']), '0')));
$postcode = md5(strtoupper(str_replace(' ', '', $member['postcode'])));
$sql = <<<EOQ
INSERT INTO {$prefix}user
(firstname, lastname, type, camra_number, camra_member, postcode, email, active, verified, created, updated)
VALUES
('{$member['firstname']}', '{$member['lastname']}', 'reviewer', '{$camra_number}', {$member['camra_member']}, '{$postcode}', '{$member['email']}', {$member['active']}, {$member['verified']}, {$date}, {$date});
EOQ;
getQueryResults($sql);
$headers = 'From: No Reply <signup@' . $_SERVER['HTTP_HOST'] . '>' . CRLF;
$subject = 'Your account signup at ' . $_SERVER['HTTP_HOST'];
$content = 'Thank you for your request for any account.' . CR . CR;
$content .= 'To validate your signup please follow the link below' . CR;
$content .= 'http://' . $_SERVER['HTTP_HOST'] . $config->get('web', 'root') . '/signup/at8/?v=' . md5($member['camra_number']) . CR;
$content .= CR . CR . 'Thank you.';
mail($member['email'], $subject, $content, $headers);
header('Location: ' . $config->get('web', 'root') . '/signup/thankyou/');
exit;
} else {
$form->submiterrormsg .= '<p class="error">Username/CAMRA Number is already registered.</p><p> Please choose another one or check with your system administrator.</p>';
}
}
$form->addFieldsetOpen('Signup');
$form->addField('firstname', 'text', $member['firstname']);
/**
* Last updated $Date: 2007-03-09 13:02:59 +0000 (Fri, 09 Mar 2007) $
* by $Author: andybrock $
*
* This file is $Revision: 326 $
* $HeadURL: https://svn.sf.net/svnroot/camranbss/camra/nbss/version2/results/raw/index.php $
**/
$title = 'Raw Results';
$access = array('superreviewer', 'admin', 'sysadmin');
include '../../includes/base.php';
include DOCROOT . '/skin/header.php';
$show = isset($_REQUEST['show']) ? $_REQUEST['show'] : 10;
$start = isset($_REQUEST['start']) ? $_REQUEST['start'] : '';
$stop = isset($_REQUEST['stop']) ? $_REQUEST['stop'] : '';
$reviewer_id = $request->get('post', 'reviewer_id') ? $request->get('post', 'reviewer_id') : 0;
$reviewers = getQueryResults('SELECT id, firstname, lastname FROM ' . $config->get('database', 'tablePrefix') . 'user WHERE active=1 ORDER BY lastname, firstname;');
$results = lastSubmissions($show, $reviewer_id, $start, $stop);
?>
<form method="post" action="<?php
echo $config->get('web', 'root');
?>
/results/raw/" id="resultform">
<input type="hidden" name="sortcol" value="<?php
print $sortcol;
?>
" />
<input type="hidden" name="sortorder" value="<?php
print $sortorder;
?>
" />
Show: <select name="show">
* by $Author: andybrock $
*
* This file is $Revision: 326 $
* $HeadURL: https://svn.sf.net/svnroot/camranbss/camra/nbss/version2/results/indepth/index.php $
**/
$title = 'Results';
$access = array('superreviewer', 'admin', 'sysadmin');
include '../../includes/base.php';
include DOCROOT . '/skin/header.php';
$sortcol = isset($_REQUEST['sortcol']) ? $_REQUEST['sortcol'] : 'date';
$sortorder = isset($_REQUEST['sortorder']) && $_REQUEST['sortorder'] == 'asc' ? SORT_ASC : SORT_DESC;
$type = isset($_REQUEST['type']) && $_REQUEST['type'] == 'yoy' ? 'yoy' : 'mom';
$pub_id = isset($_REQUEST['pub_id']) ? $_REQUEST['pub_id'] : 132;
$prevLL = isset($_REQUEST['prevLL']) && $_REQUEST['prevLL'] == '1' ? 1 : 0;
$stats = getPubStatsInDepth($pub_id, $type, $sortcol, $sortorder, $prevLL);
$pub = reset(getQueryResults('SELECT town.name as town_name, pub.name as pub_name FROM ' . $config->get('database', 'tablePrefix') . 'pub pub, ' . $config->get('database', 'tablePrefix') . 'town town WHERE pub.town_id=town.id AND pub.id=' . $pub_id));
?>
<form method="post" action="<?php
echo $config->get('web', 'root');
?>
/results/indepth/" id="resultform">
<input type="hidden" name="sortcol" value="<?php
print $sortcol;
?>
" />
<input type="hidden" name="sortorder" value="<?php
print $sortorder;
?>
" />
<input type="hidden" name="pub_id" value="<?php
print $pub_id;
<p>
<label for="frm_member_id">Member to review</label>
<select name="id" id="frm_member_id">
<option value="">Selected a reviewer</option>
<?php
foreach ($members as $member) {
print '<option value="' . $member['id'] . '">' . $member['lastname'] . ', ' . $member['firstname'] . '</option>';
}
?>
</select>
<input type="submit" class="btnSubmit" value="Review" />
</p>
</form>
<?php
} else {
$reviewer = reset(getQueryResults('SELECT * FROM ' . $config->get('database', 'tablePrefix') . 'user WHERE id=' . $member_id));
$reviews = getReviewerStats($member_id, $sortcol, $sortorder, $show, $start, $stop);
?>
<form method="post" action="<?php
echo $config->get('web', 'root');
?>
/admin/members/review/" id="resultform">
<input type="hidden" name="sortcol" value="<?php
print $sortcol;
?>
" />
<input type="hidden" name="sortorder" value="<?php
print $sortorder;
?>
" />
<input type="hidden" name="id" value="<?php
