|
|
|
Welcome to our
motorcycle reviews section. Feel free to rate
and review any motorcycle - let us have your views.
We are using the forum database as a means of
registering reviewers. This does not imply that
you need to use the forum or become a member as
such. Similarly forums members who want to review
and rate can use the same logon. We require this
registration because we believe that the reviews
and ratings should be credible, that one person
should rate a Bike only once and that reviewers
should be bona-fide users of the Bikes.
|
|
Bike Review Categories |
$mysql = mysql_connect("localhost","402441_adminbr","NuvvMJ..");
mysql_select_db( "402441_bikereview" );
$query = "SELECT * FROM brcat where active order by catname";
$result = mysql_query($query) or die('Error!!!!!!, query failed 1');
$iSpan=0;
while ( $DOC = mysql_fetch_object( $result ) )
{ $iSpan=$iSpan + 1;
If ($iSpan>3){echo ' ' ; $iSpan=1;}
$iCategoryID= "$DOC->category";
$sCategoryName= "$DOC->catname";
echo '
'.$sCategoryName.' ';
$querycnt = "SELECT COUNT(Item) AS numrows FROM brrev WHERE category =".$iCategoryID." and active";
$resultant = mysql_query($querycnt) or die('Error!!!!!!, query failed 2');
$rowing = mysql_fetch_array($resultant, MYSQL_ASSOC);
$iRecordcount = $rowing['numrows'];
if ($iRecordcount > 0) {
echo '(';
echo $iRecordcount;
echo ' reviews) '; }
echo ' ';
if ($BlnShowCategoryDescriptions=1)
{echo $sCategoryDescription;};
echo ' | ';
}
?>
|
$sSQL="SELECT * FROM brrev WHERE active ORDER BY date DESC limit 5;";
$iRecordcount = 10;
if ($iRecordcount <= 0 ) {
echo '';
'';
' <<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";
$iCategoryID="$DOC->category";
$iRating="$DOC->editorsrating";
$sLinkDescription="$DOC->summary";
$dDate_Added="$DOC->date";
$sURL="$DOC->URL";
$simage="$DOC->image";
$sSQLcat="SELECT * FROM brcat WHERE category = $iCategoryID ;";
$Resultcat = mysql_query($sSQLcat);
while ( $DOCcat = mysql_fetch_object( $Resultcat )) {
$sCategoryName = $DOCcat->catname;
} ?>
$linkextra = "&Sort=$iSortby&Filter=$iFilter";
echo '
';
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 '
';
}
}
?>
| |