|
|
| Motorcycle Community
 |
| Motorcycle Competitions
|
| Motorcycle Galleries
|
| Motorcycles General
|
|
|
|
|
 Custom Search
|
|
|
';
' ';
' <<Home -- <%=sCategoryName%>';
' | There are currently no external links listed. | | ';}
Else
{
echo '';
$Result = mysql_query($sSQL);
$my_var = 0;
$mystr = 999999;
$sFeatured = "ZZZ";
$j = 0;
while ( $DOC = mysql_fetch_object( $Result )) {
$iLinkID="$DOC->primkey";
$sLinkName="$DOC->Item";
$iRating="$DOC->editorsrating";
$sLinkDescription="$DOC->summary";
$dDate_Added="$DOC->date";
$sURL="$DOC->URL";
$simage="$DOC->image";
$suppress = "NR"; ?>
| '.$sLinkName.' | MSE Ratings | | ';
echo '
 | '.$sLinkDescription.'
';
echo '';
if ($suppress != "NR"){
echo '';
echo '
| ';
echo 'Read the full review
| ';
}
if ($DOC->Price < 0.01 ) { echo ' | '.$DOC->pricequal.' | '; }
else
{
echo ' | £'.$DOC->Price.' '.$DOC->pricequal.' | ';}
$dayear = substr($dDate_Added,0,4);
$damonth = substr($dDate_Added,5,2);
$daday = substr($dDate_Added,8,2);
$maydatets = mktime(0,0,0,$damonth,$daday,$dayear);
$maydate = date("jS F Y", $maydatets);
echo ' | ';
echo 'Date Added: '. $maydate.' |  |
Source: '.$sURL.' |  |
Rate this item |
 |
Review this item | ';
echo '
|
 | Contributors rating:- '.$iRating.' | ';
$ir10 = $iRating * 10;
$counter = 1;
while ( $counter <= $ir10 ) {
if ($counter == 10 || $counter == 20 || $counter == 30 || $counter == 40){
echo ' ';}
else
{
echo ' ';}
$counter = $counter + 1;
}
echo ' | ';
// user rating
$iratcnt = 0;
$itotal = 0.0;
$query3 = "SELECT * FROM brrat WHERE itempk =".$iLinkID." ";
$result3 = mysql_query($query3) or die('Error!!!!!!, query failed');
while ( $DOC3 = mysql_fetch_object( $result3 )) {
$iratcnt = $iratcnt + 1;
$itotal = $itotal + $DOC3->rating;
}
$daverage = number_format ($itotal / $iratcnt , 2);
echo ' | ';
if ($iratcnt > 0){
echo 'Members rating:- '.$daverage.'';}
else {
echo 'No votes';}
echo ' | ';
$ir10 = $daverage * 10;
$counter = 1;
while ( $counter <= $ir10 ) {
if ($counter == 10 || $counter == 20 || $counter == 30 || $counter == 40){
echo ' ';}
else
{
echo ' ';}
$counter = $counter + 1;
}
echo ' | ';
if ($iratcnt > 0)
{ echo ' | From '.$iratcnt.' votes | | ';}
if ($iratcnt < 1)
{ echo '| Be the first to rate this item | ';}
$query4 = "SELECT * FROM brurev WHERE ID =".$iLinkID." ";
$iratcnt = 0;
$result4 = mysql_query($query4) or die('Error!!!!!!, query failed');
while ( $DOC4 = mysql_fetch_object( $result4 )) {
$iratcnt = $iratcnt + 1;
}
echo ' | Total member reviews | '.$iratcnt.' | ';
if ($iratcnt > 0)
{
if ($suppress != "NR"){
echo '| Read the full review | ';
}
}
else
{ echo '| Be the first to review this item | ';}
echo '
';
echo ' | '; ?>
';
echo '';
echo ' | Contributor's Review |
| ';
echo '| '.$DOC->review.' | ';
$sSQLu="SELECT * FROM brurev WHERE active and ID ='".$iID."' ;";
$Resultu = mysql_query($sSQLu);
while ( $DOCu = mysql_fetch_object( $Resultu )) {
echo '
';
echo '';
$dDated="$DOCu->rdate";
$dayear = substr($dDated,0,4);
$damonth = substr($dDated,5,2);
$daday = substr($dDated,8,2);
$maydatets = mktime(0,0,0,$damonth,$daday,$dayear);
$maydate = date("jS F Y", $maydatets);
echo ' | Member review by '.$DOCu->rname.' on '.$maydate.' |
| ';
echo '| '.$DOCu->review.' | ';
echo ' ';
}
echo '
';
}
}
?>
| |
