32
Well i made the categories and added a product to see how it is. I went to myreview from main menu where the actegories are, and there was the most recent product, that product and the review is fine, also it is showing the picture fine, but at the bottom it shows some strange codes and not the details bar with rating bar, also when i press to go to the product it shows the review without any code and without the rating bar...
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 "
" ?>
some of these codes have links...
