4
This is what it shows under my every review
\n"; //Start with the Review Display //Do the overall rating Display first //$formatted_date = formatTimestamp($reviewtimestamp); $review = $myts->makeTareaData4Show($review,1); //$reviewuname = XoopsUser::getUnameFromId($reviewuser); $resulttot=$xoopsDB->query("SELECT rating FROM ".$xoopsDB->prefix("myReviews_votedata")." WHERE lid = $lid"); $totalraw=0; $totalint=0; $totaltotal=0; $totbar=0; $totalstuff=0; $q=0; while(list($total)=$xoopsDB->fetchRow($resulttot)) { $totalstuff+=$total; $q++; }//End while if ($q==0) { $totalraw=0; $totalint=1; } else { $totalraw=$totalstuff/$q; $totalint=intval($totalstuff/$q)+.5; }//End if if ($totalraw>$totalint) { $totaltotal=intval($totalraw)+1; } else { $totaltotal=intval($totalraw); }//End if $totbar=(($totaltotal/$myReviews_totrate)*$myReviews_categorybarwidth-15); $emptybar=$myReviews_categorybarwidth-15-$totbar; $fullmarks=0; if ($totaltotal==$myReviews_totrate) { $fullmarks=1; }//End if //Check if there has been any reviews to display if ($q>0) { echo ""; echo "
"; echo " "; //Logic to display the different review bar types if ($myReviews_reviewbartype==1)//Bars { echo " "; for ($e=1;$e<$myReviews_catnum+1;$e++) { $resultcat[$e]=$xoopsDB->query("SELECT rating FROM ".$xoopsDB->prefix("myReviews_votecat")." WHERE lid=$lid AND ratingcat=$e"); $x=0; $tottotcatrate[$e]=0; $catstarbartot[$e]=0; while(list($totcatrate[$e])=$xoopsDB->fetchRow($resultcat[$e])) { $x++; $tottotcatrate[$e]+=$totcatrate[$e]; }//End while if ($x == 0) { $totalcatrateraw[$e]=0; $totalcatrateint[$e]=1; } else { $totalcatrateraw[$e]=$tottotcatrate[$e]/$x; $totalcatrateint[$e]=intval($tottotcatrate[$e]/$x)+.5; }//End if if ($totalcatrateraw[$e]>$totalcatrateint[$e]) { $catrate[$e]=intval($totalcatrateraw[$e])+1; } else { $catrate[$e]=intval($totalcatrateraw[$e]); }//End if $catbar[$e]=($catrate[$e]/$myReviews_maxrate)*$myReviews_categorybarwidth-15; $catemptybar[$e]=$myReviews_categorybarwidth-15-$catbar[$e]; $catstarbartot[$e]=round((($catrate[$e]/($myReviews_maxrate/10))),0); $catfullmarks[$e]=0; if ($catrate[$e]==$myReviews_maxrate) { $catfullmarks[$e]=1; }//End if $tottotcatrate[$e]=0; }//End for //Now Display the Category Reviews for ($e=1;$e<$myReviews_catnum+1;$e++) { if ($catrate[$e] != 0) { echo ""; //Logic to display the different review bar types if ($myReviews_reviewbartype==1)//Bars { echo " "; $catrate[$e]=0; $catbar[$e]=0; }//End if }//End for echo "
"._MD_AVERAGE.": (1) ($myReviews_totrate)
"._MD_TOTNAME_TITLE.": "._MD_FEATURES_TITLE.": $totaltotal"._MD_FEATURES_TITLE.": $totaltotal"._MD_FEATURES_TITLE.": $rating"; }//End if if ($myReviews_reviewbartype==2)//Stars { $starbartot=round((($totaltotal/($myReviews_totrate/10))),0); switch ($starbartot) { default: $starbar='stars_0.gif'; break; case 1: $starbar='stars_0_5.gif'; break; case 2: $starbar='stars_1.gif'; break; case 3: $starbar='stars_1_5.gif'; break; case 4: $starbar='stars_2.gif'; break; case 5: $starbar='stars_2_5.gif'; break; case 6: $starbar='stars_3.gif'; break; case 7: $starbar='stars_3_5.gif'; break; case 8: $starbar='stars_4.gif'; break; case 9: $starbar='stars_4_5.gif'; break; case 10: $starbar='stars_5.gif'; break; }//End switch echo " "._MD_FEATURES_TITLE.": $totaltotal"; }//End if if ($myReviews_reviewbartype==3)//Full Bars { if ($fullmarks) { $totbar+=6; echo " "._MD_FEATURES_TITLE.": $totaltotal"._MD_FEATURES_TITLE.": $totaltotal"._MD_FEATURES_TITLE.": $rating"; } else { echo " "._MD_FEATURES_TITLE.": $totaltotal"._MD_FEATURES_TITLE.": $totaltotal"._MD_FEATURES_TITLE.": $rating"._MD_FEATURES_TITLE.": $totaltotal"._MD_FEATURES_TITLE.": $totaltotal"._MD_FEATURES_TITLE.": $rating"; } }//End if echo " $rating
$myReviews_catname[$e]: $myReviews_catname[$e]: $catrate[$e]$myReviews_catname[$e]: $catrate[$e]$myReviews_catname[$e]: $catrate[$e]"; }//End if if ($myReviews_reviewbartype==2)//Stars { switch ($catstarbartot[$e]) { default: $catstarbar='stars_0.gif'; break; case 1: $catstarbar='stars_0_5.gif'; break; case 2: $catstarbar='stars_1.gif'; break; case 3: $catstarbar='stars_1_5.gif'; break; case 4: $catstarbar='stars_2.gif'; break; case 5: $catstarbar='stars_2_5.gif'; break; case 6: $catstarbar='stars_3.gif'; break; case 7: $catstarbar='stars_3_5.gif'; break; case 8: $catstarbar='stars_4.gif'; break; case 9: $catstarbar='stars_4_5.gif'; break; case 10: $catstarbar='stars_5.gif'; break; }//End switch echo " $myReviews_catname[$e]: $catrate[$e]"; }//End if if ($myReviews_reviewbartype==3)//Full Bars { if ($catfullmarks[$e]) { $catbar[$e]+=6; echo " $myReviews_catname[$e]: $catrate[$e]$myReviews_catname[$e]: $catrate[$e]$myReviews_catname[$e]: $catrate[$e]"; } else { echo " $myReviews_catname[$e]: $catrate[$e]$myReviews_catname[$e]: $catrate[$e]$myReviews_catname[$e]: $catrate[$e]$myReviews_catname[$e]: $catrate[$e]$myReviews_catname[$e]: $catrate[$e]$myReviews_catname[$e]: $catrate[$e]"; }//End if }//End if echo " $catrate[$e]
"; echo " "; //echo ""; echo "
" ._MD_DATE." $datetime
"._MD_DESCRIPTION." : $description
"; echo "
"; } else //There was no ratings done so far { echo ""; echo "
"; echo "
"; echo " "; //echo ""; echo "
" ._MD_DATE." $datetime
"._MD_DESCRIPTION." : $description
"; echo "
"; }//End if echo "
"; $q=0; echo "
"; //echo ""._MD_BACKSTEP.""; //echo " | "._MD_READEXCERPT.""; //echo " | "._MD_RATETHISFILE.""; $result300=$xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("myReviews_reviews")." WHERE lid=$lid"); list($reviewuserDB) = $xoopsDB->fetchRow($result300); $result350=$xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("myReviews_editorials")." WHERE lid=$lid"); list($editorialuserDB) = $xoopsDB->fetchRow($result350); if ($reviewuserDB || $editorialuserDB) { echo ""._MD_DETAILS." | "; }//End if // echo ""._MD_DETAILS." | "; // echo ""._MD_RATETHISFILE.""; echo ""._MD_TELLAFRIEND." | "; global $xoopsUser; if ($xoopsUser) { $submitter = $xoopsUser->uid(); $result240=$xoopsDB->query("SELECT submitter FROM ".$xoopsDB->prefix("myReviews_downloads")." WHERE lid=$lid AND submitter=$submitter"); list($submitterDB) = $xoopsDB->fetchRow($result240); if ($submitterDB) { echo ""._MD_REVIEWEDIT." | "; } else { }//End if }//End if if ( $xoopsUser ) { //$submitter = $xoopsUser->uid(); if ( $xoopsUser->isAdmin($xoopsModule->mid()) ) { $result3000=$xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("myReviews_editorials")." WHERE lid=$lid AND editorialuser=$submitter"); list($editorialuserDB) = $xoopsDB->fetchRow($result3000); if ($editorialuserDB) { echo ""._MD_EDITORIALEDIT." | "; } else { echo ""._MD_EDITORIAL." | "; }//End if echo ""._MD_EDIT." | "; //echo " | "._MD_VSCOMMENTS.""; }//End if }//End if if ( $xoopsUser ) { //$submitter = $xoopsUser->uid(); if ( $xoopsUser->isAdmin($xoopsModule->mid()) ) { $result3000=$xoopsDB->query("SELECT loveit, recommendit FROM ".$xoopsDB->prefix("myReviews_downloads")." WHERE lid=$lid"); list($loveitDB, $recommenditDB) = $xoopsDB->fetchRow($result3000); if ($loveitDB==0) { echo ""._MD_LOVEIT." | "; } else { echo ""._MD_UNLOVEIT." | "; }//End if if ($recommenditDB==0) { echo ""._MD_RECOMMENDIT." | "; } else { echo ""._MD_UNRECOMMENDIT." | "; }//End if }//End if }//End if if ( $xoopsUser ) { $submitter = $xoopsUser->uid(); $result3000=$xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("myReviews_reviews")." WHERE lid=$lid AND reviewuser=$submitter"); list($editreviewDB) = $xoopsDB->fetchRow($result3000); //echo " | "._MD_EDIT.""; if ($editreviewDB) { echo ""._MD_REVIEWEDITIT." | "; } else { echo ""._MD_VSCOMMENTS." | "; }//End if }//End if echo ""._MD_REPORTBROKEN.""; echo "
"; //voting & comments stats if ($comments != 0) { if ($comments == 1) { $poststring = _MD_ONEPOST; } else { $poststring = sprintf(_MD_NUMPOSTS,$comments); } echo ""._MD_COMMENTSC."$poststring"; } echo "
" ?>