<?php

error_reporting(E_ALL ^ E_NOTICE ^ 8192);

define('THIS_SCRIPT', 'viewprovider');
define('CSRF_PROTECTION', true);

$globaltemplates  = array(
    'GENERIC_SHELL',
    'viewprovider',
    'viewprovider_review'
);
$actiontemplates  = array();
$specialtemplates = array();
$phrasegroups     = array();

require('./global.php');

$id = $vbulletin->input->clean_gpc('g', 'id', TYPE_UINT);
if (!$provider = $db->query_first("SELECT * FROM eccie_anonymous_provider WHERE id = $id")) {
    standard_error('Could not find the requested provider.');
}

$pp   = 25;
$page = max(1, $vbulletin->input->clean_gpc('g', 'page', TYPE_UINT));

$count = $db->query_first("
    SELECT COUNT(*) AS total
      FROM eccie_review
     WHERE anonymousid = $id
     
");

$offset = ($page - 1) * $pp;
$total  = $count['total'];

$result = $db->query_read("
    SELECT review.*
         , thread.*
         , COALESCE(review.title, thread.title, 'Review') AS title
         , postusername AS username
         , post.pagetext
         , moderator.username AS mod_username
      FROM eccie_review AS review
    LEFT OUTER
      JOIN thread
        ON thread.threadid = review.threadid
    LEFT OUTER
      JOIN post
        ON thread.firstpostid = post.postid
    LEFT OUTER
      JOIN user AS moderator
        ON moderator.userid = review.mod_userid
     WHERE review.anonymousid = $id
     LIMIT $offset, $pp
");

$reviews = '';
while ($review = $db->fetch_array($result)) {
    $color = $color == 'alt1' ? 'alt2' : 'alt1';
    $review['date'] = vbdate($vbulletin->options['dateformat'], $review['dateline'], true);
    $review['forum'] = $vbulletin->forumcache[$review['forumid']]['title'];
    
    $m = null;
    if ($review['url']) {
        $review['recommendation'] = '';
    
    } else if (preg_match('/\[B\]\s*Recommendation\s*\[\/B\]\s*\: (.*)/i', $review['pagetext'], $m)) {
        $review['recommendation'] = $m[1];      
    }
    
    eval('$reviews .= "' . fetch_template('viewprovider_review') . '";');
}

$pageNavigation = construct_page_nav(
    $page,
    $pp,
    $total,
    'viewprovider.php?id=' . $id,
    '&amp;pp=' . $pp
);

$navbits = construct_navbits(array($provider['name']));
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('$HTML = "' . fetch_template('viewprovider') . '";'); 
eval('print_output("' . fetch_template('GENERIC_SHELL') . '");');