0){ $listingReviewAverage = intval(($listingReviewTotal / 5) / $listingReviewNumber); $listingReviewAverageStat1 = $listingReviewTotalStat1 / $listingReviewNumber; $listingReviewAverageStat2 = $listingReviewTotalStat2 / $listingReviewNumber; $listingReviewAverageStat3 = $listingReviewTotalStat3 / $listingReviewNumber; $listingReviewAverageStat4 = $listingReviewTotalStat4 / $listingReviewNumber; $listingReviewAverageStat5 = $listingReviewTotalStat5 / $listingReviewNumber; $listingReviewAverageStat6 = $listingReviewTotalStat6 / $listingReviewNumber; $listingReviewAverageStat7 = $listingReviewTotalStat7 / $listingReviewNumber; $listingReviewAverageStat8 = $listingReviewTotalStat8 / $listingReviewNumber; } else { $listingReviewAverage = 0; $listingReviewAverageStat1 = 0; $listingReviewAverageStat2 = 0; $listingReviewAverageStat3 = 0; $listingReviewAverageStat4 = 0; $listingReviewAverageStat5 = 0; $listingReviewAverageStat6 = 0; $listingReviewAverageStat7 = 0; $listingReviewAverageStat8 = 0; } $allListingReviews = getListingReviews($mysqli, $listingId); $totalReviewsCount = count($allListingReviews); if($newReviewAdded){ $newReviewAverage = $listingReviewTotal + $averageTotalScore; $newReviewStatTotal1 = $listingReviewTotalStat1 + $newReviewStat1; $newReviewStatTotal2 = $listingReviewTotalStat2 + $newReviewStat2; $newReviewStatTotal3 = $listingReviewTotalStat3 + $newReviewStat3; $newReviewStatTotal4 = $listingReviewTotalStat4 + $newReviewStat4; $newReviewStatTotal5 = $listingReviewTotalStat5 + $newReviewStat5; $newReviewStatTotal6 = $listingReviewTotalStat6 + $newReviewStat6; $newReviewStatTotal7 = $listingReviewTotalStat7 + $newReviewStat7; $newReviewStatTotal8 = $listingReviewTotalStat8 + $newReviewStat8; $listingReviewNumber = $listingReviewNumber + 1; $listingReviewAverage = intval(($listingReviewTotal / 5) / $listingReviewNumber); $listingReviewAverageStat1 = $newReviewStatTotal1 / $listingReviewNumber; $listingReviewAverageStat2 = $newReviewStatTotal2 / $listingReviewNumber; $listingReviewAverageStat3 = $newReviewStatTotal3 / $listingReviewNumber; $listingReviewAverageStat4 = $newReviewStatTotal4 / $listingReviewNumber; $listingReviewAverageStat5 = $newReviewStatTotal5 / $listingReviewNumber; $listingReviewAverageStat6 = $newReviewStatTotal6 / $listingReviewNumber; $listingReviewAverageStat7 = $newReviewStatTotal7 / $listingReviewNumber; $listingReviewAverageStat8 = $newReviewStatTotal8 / $listingReviewNumber; updateBusinessReviews($mysqli, $listingId, $listingReviewNumber, $newReviewAverage, $newReviewStatTotal1, $newReviewStatTotal2, $newReviewStatTotal3, $newReviewStatTotal4, $newReviewStatTotal5, $newReviewStatTotal6, $newReviewStatTotal7, $newReviewStatTotal8); } updateProfileViewStat($mysqli, $listingId); $listingDateAdded = $listingDetails['date_added']; $listingBusinessRegId = $listingDetails['business_reg_id']; } $chosenPage = $_GET['page']; if ($chosenPage == ""){ $chosenPage = "feed"; } else if ($chosenPage != "details" && $chosenPage != "gallery" && $chosenPage != "videos" && $chosenPage != "reviews" && $chosenPage != "contact" && $chosenPage != "faqs" && $chosenPage != "menu" && $chosenPage != "products" && $chosenPage != "services" && $chosenPage != "facilities" && $chosenPage != "offers" && $chosenPage != "jobs" && $chosenPage != "events" && $chosenPage != "calendar" && $chosenPage != "news" && $chosenPage != "classifieds" && $chosenPage != "meettheteam" && $chosenPage != "store" && $chosenPage != "exhibitions" && $chosenPage != "files" && $chosenPage != "loyalty" && $chosenPage != "rooms"){ $chosenPage = "feed"; } $profilePages = getProfilePages($mysqli, $listingId); $faqsTabEnabledFlag = $profilePages['faq_page_flag']; $menuTabEnabledFlag = $profilePages['menu_page_flag']; $productsTabEnabledFlag = $profilePages['products_page_flag']; $servicesTabEnabledFlag = $profilePages['services_page_flag']; $facilitiesTabEnabledFlag = $profilePages['facilities_page_flag']; $offersTabEnabledFlag = $profilePages['offers_page_flag']; $jobsTabEnabledFlag = $profilePages['jobs_page_flag']; $eventsTabEnabledFlag = $profilePages['events_page_flag']; $calendarTabEnabledFlag = $profilePages['calendar_page_flag']; $classifiedsTabEnabledFlag = $profilePages['classifieds_page_flag']; $meettheteamTabEnabledFlag = $profilePages['meettheteam_page_flag']; $storeTabEnabledFlag = $profilePages['store_page_flag']; $exhibitionsTabEnabledFlag = $profilePages['exhibition_page_flag']; $galleryTabEnabledFlag = $profilePages['gallery_page_flag']; $videosTabEnabledFlag = $profilePages['video_page_flag']; $filesTabEnabledFlag = $profilePages['files_page_flag']; $newsTabEnabledFlag = $profilePages['news_page_flag']; $reviewsTabEnabledFlag = $profilePages['reviews_page_flag']; $loyaltyTabEnabledFlag = $profilePages['loyalty_page_flag']; $roomsTabEnabledFlag = $profilePages['rooms_page_flag']; ?> <? echo $websiteTitle . " | " . $listingName; ?>