| Server IP : 51.89.169.208 / Your IP : 3.148.107.92 Web Server : Apache System : Linux ns3209505.ip-198-244-202.eu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Tue Nov 5 04:50:16 EST 2024 x86_64 User : yellowleaf ( 1019) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/yellowleaf/public_html/pages/ |
Upload File : |
<?php
session_start();
header('Content-Type: text/html; charset=utf-8');
$path = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';
include_once('compiler.php');
$adid=(int)addslashes($_GET['adid']);
/////// TABLES ///////
// advert table
$r4 = $connect->query("SELECT * FROM `ads` WHERE `adid` = '{$adid}'") or die($connect->error);
if(!$r4->num_rows){header('Location: /');}
$a4 = $r4->fetch_assoc();
$town_name = $a4['town_name'];
if(!$town_name) {$town_name = $a4['county_name'].' Area'; }
// validation for advert
$r_ad_name=strtolower($a4['companyname']);
$r_ad_name = preg_replace("/[^A-Za-z 0-9]/", "", $r_ad_name);
$r_ad_name=str_replace(" "," ",$r_ad_name);
$mad_name=str_replace(" ","-",$r_ad_name);
if(addslashes($_GET['ad_name'])!=$mad_name){header('Location: /');}
// opening time table
$r5 = $connect->query("SELECT * FROM `opening_hours` WHERE `opadid` ='{$adid}'") or die($connect->error);
$opening_row = $r5->fetch_assoc();
$opening_num_row = $r5->num_rows;
// promotions table
$r6 = $connect->query("SELECT * FROM promotions WHERE ad_id = '{$adid}' ORDER BY prom_valid DESC") or die($connect->error);
$promo_num_row = $r6->num_rows;
if($a4['review_on']=='1'){
// reviews table
$r7 = $connect->query("SELECT * FROM `reviews` WHERE `rev_ad_id` = '{$adid}' AND `rev_spam`='0' ORDER BY rev_id DESC") or die($connect->error);
// $r7 = $connect->query("SELECT * FROM `reviews` WHERE `rev_ad_id` = '{$adid}' AND `rev_confirm`='1' AND `rev_spam`='0' ORDER BY rev_id DESC") or die($connect->error);
$rev_num_row = $r7->num_rows;
}
// social table
$r8 = $connect->query("SELECT * FROM `social_links` WHERE `so_ad_id` ='{$adid}'") or die($connect->error);
$social_row = $r8->fetch_assoc();
$mcategory=$a4['mcategory'];
$long=$a4['longitude'];
$lat=$a4['latitude'];
$memberid=$a4['memberid'];
$photo1 = $a4["photo_1"];
$photo2 = $a4["photo_2"];
$photo3 = $a4["photo_3"];
$photo4 = $a4["photo_4"];
$more_photos = "";
if (!empty($photo1) && $photo1 != "0") {
$more_photos .= '<div class="active">
<img src="/members/uploads/1/'.$photo1.'" alt="">
</div>';
}
if (!empty($photo2) && $photo2 != "0") {
$more_photos .= '<div>
<img src="/members/uploads/2/'.$photo2.'" alt="">
</div>';
}
if (!empty($photo3) && $photo3 != "0") {
$more_photos .= '<div>
<img src="/members/uploads/3/'.$photo3.'" alt="">
</div>';
}
if (!empty($photo4) && $photo4 != "0") {
$more_photos .= '<div>
<img src="/members/uploads/4/'.$photo4.'" alt="">
</div>';
}
$company_name=strip_tags($a4['companyname']);
if(!$a4['street2']){$street=rtrim(trim($a4['street1']), ','); $street=strip_tags($street.', ');}
if($a4['street2']){$street11=rtrim(trim($a4['street1']), ','); $street22=rtrim(trim($a4['street2']), ','); $street=strip_tags(trim($street11.', '.$street22.', '));}
$county_name=strip_tags($town_name.', '.$a4['county_name'].', ');
$town_name=$town_name;
$postcode=$a4['postcode'].'.';
if($a4['district_name']){$district_name=', '.$a4['district_name'];}
$address = preg_replace('/\.$/', '', "$street $county_name $postcode");
$tel_no= '<div>
<svg>
<use xlink:href="index.svg#phone-line"></use>
</svg>
'.preg_replace('/^(\+44|44)/', '0', strip_tags($a4['tel'])).'
</div>';
$company_desc=strip_tags($a4['description']);
// $company_desc=nl2br(utf8_encode($company_desc));
$company_desc=nl2br($company_desc);
$services_offered=strip_tags($a4['services_products']);
$company_postcode=str_replace(' ','+',strip_tags($a4['postcode']));
$company_postcode_main=strip_tags($a4['postcode']);
function short_title_converter($string){
$short_title = "";
$split_string = explode(" ", $string);
foreach ($split_string as $key => $value) {
if ($key <= 2) {
$word = trim($value);
if (!preg_match('/[\'^£$%&*()}{@#~?><>,|=_+¬-]/', $word[0]))
{
$first_char = ucwords($word[0]);
}else if(!preg_match('/[\'^£$%&*()}{@#~?><>,|=_+¬-]/', $word[1])){
$first_char = ucwords($word[1]);
}else{
$first_char = "";
}
$short_title .= $first_char;
}
}
return $short_title;
}
$short_title = short_title_converter($company_name);
$business_logo_placeholder = '<div class="business-placeholder-image-big" title="'.$a4['companyname'].'">'.$short_title.'</div>';
// if fax exists show
if($a4['fax']){
$fax_no='<div>
<svg>
<use xlink:href="index.svg#fax-line"></use>
</svg>
'.strip_tags($a4['fax']).'
</div>';
}
// if logo exists
$logo_url =($a4['image'] ? '<img itemprop="photo" class="photo" src="/members/uploads/logo/'.$a4['image'].'" border="0">' : '<a href="/members/edit_2.html?adid='.$adid.'"><img itemprop="photo" class="photo" src="/img/no_logo_lrg.png" border="0"></a>');
// $logo = $a4['image'] && file_exists($path.'/members/uploads/logo/'.$a4['image']) ? '<img alt="Listing" src="/members/uploads/logo/'.$a4['image'].'">' : $business_logo_placeholder;
$check_img_field = 0;
for($im = 1; $im <= 4; $im++){
$img_field = "photo_".$im;
if(!empty($a4[$img_field]) && $check_img_field==0){
$logo = $a4[$img_field] && file_exists($path.'/members/uploads/'.$im.'/'.$a4[$img_field]) ? '<img title="'.$a4['companyname'].'" alt="'.$a4['companyname'].'" src="/members/uploads/'.$im.'/'.$a4[$img_field].'">' : $business_logo_placeholder;
$check_img_field = 1;
}
}
$logo_title = $a4['image'] && file_exists($path.'/members/uploads/logo/'.$a4['image']) ? '<img class="logo-header" title="'.$a4['companyname'].'" alt="'.$a4['companyname'].'" src="/members/uploads/logo/'.$a4['image'].'">' : $business_logo_placeholder;
$url_display = '';
if($a4['url']){
$chk = preg_match('/^https?:\/\//', $a4['url'], $url_check);
if(!$chk){
$url_display = "http://".$a4['url'];
} else{
$url_display = $a4['url'];
}
$website_url='<div>
<svg>
<use xlink:href="index.svg#links-line"></use>
</svg>
<a rel="nofollow" target="_blank" href="'.$url_display.'">'.preg_replace('/https:\/\/|http:\/\/|\/$/', '', strip_tags($a4['url'])).'</a>
</div>';
// $website_url='<a rel="nofollow" target="_blank" href="'.$a4['url'].'">'.strip_tags($a4['url']).'</a>';
// $a4['url'] = str_replace(array('http://','https://'),'',$a4['url']);
$website_button='
<div style="margin-top:0px" class="cn_shaddow cont_cn"><span class="subhead">Visit Our Website<br><br>
<table>
<tr>
<td valign="middle">
</td>
<td valign="middle" style="padding-left:15px">
<div><span style="color:#0A0A0A;font-size:20px;">'.$company_name.' Website..</span> </div>
<div style="color:#5a9a47;font-size:11pt;">'.$a4['url'].'</div>
<div style="margin-top:10px">
<a href="http://'.$a4['url'].'" rel="nofollow" target="_blank">
<div style="float:left;font-size:14pt;font-weight:bold;"><u>Click here to visit our website</u></div>
<img src="/img/link_next.png" style="float:left;margin:-2px 5px 0;border:0;cursor:pointer;">
</a>
</div>
</td>
</tr>
</table>
</div>
';
$website_button='<div class="listing-info">
<h2 class="listing-info-title">Visit Our Website</h2>
<h5 class="listing-info-website-title">'.$company_name.' Website..</h5>
<div class="listing-info-website-url">'.$a4['url'].'</div>
<a href="http://'.$a4['url'].'" rel="nofollow" target="_blank" class="btn btn-yellow">
Click here to visit our website
<svg viewBox="0 0 24 20" fill="none" xmlns="http://www.w3.org/2000/svg">
<path d="M14.8885 19.5L13.3456 17.841L19.3736 11.2048H0.5V8.83472H19.3736L13.3097 2.15904L14.8526 0.5L23.5 10.0197L14.8885 19.5Z"/>
</svg>
</a>
</div>';
//<img src="http://open.thumbshots.org/image.aspx?url='.$a4['url'].'" style="border:1px solid #eee;" />
}
// if products exists
if($a4['products']){
$services=explode(" || ",substr_replace(strip_tags($a4['products']),'',-4));
// removing first array field
unset($services[0]);
if(count($services)>20){$company_products.='<div style="font-size:9pt;color:#555;">Showing the first 20 products & services only</div>';}
$company_products.='<div class="horiz_list prod" style="margin:0;padding:0;overflow:hidden">';
foreach($services as $serv_key => $service){
if($serv_key<=20){
$company_products.='<div style="font-size:13pt;color:#111111;margin:3px;"><b>'.ucwords($service).'</b></div>';
}
}
$company_products.='</div>';
}else{
$company_products.='<div>Currently no products or services provided by '.$company_name.' <a rel="nofollow" href="/members/products.html?adid='.$adid.'">Click here to add products or services >></a></div><br>';
}
// if photos exists
if($a4['photo_1']!='0'||$a4['photo_2']!='0'||$a4['photo_3']!='0'||$a4['photo_4']!='0'){
if($a4['photo_1']!='0'){
$photos_big.='<img id="bigP" class="tbwdth bpic" src="/members/uploads/1/'.$a4['photo_1'].'">';
}elseif($a4['photo_2']!='0'){
$photos_big.='<img id="bigP" class="tbwdth bpic" src="/members/uploads/2/'.$a4['photo_2'].'">';
}elseif($a4['photo_3']!='0'){
$photos_big.='<img id="bigP" class="tbwdth bpic" src="/members/uploads/3/'.$a4['photo_3'].'">';
}elseif($a4['photo_4']!='0'){
$photos_big.='<img id="bigP" class="tbwdth bpic" src="/members/uploads/4/'.$a4['photo_4'].'">';
}
$photo_count=0;
if($a4['photo_1']!='0'){$pic_small.='<img id="p_1" class="smpic_cn" onclick="changePic(\'1\',\''.$a4['photo_1'].'\');" src="/members/uploads/1/'.$a4['photo_1'].'">';$photo_count++;}
if($a4['photo_2']!='0'){$pic_small.='<img id="p_2" class="smpic_cn" onclick="changePic(\'2\',\''.$a4['photo_2'].'\');" src="/members/uploads/2/'.$a4['photo_2'].'">';$photo_count++;}
if($a4['photo_3']!='0'){$pic_small.='<img id="p_3" class="smpic_cn" onclick="changePic(\'3\',\''.$a4['photo_3'].'\');" src="/members/uploads/3/'.$a4['photo_3'].'">';$photo_count++;}
if($a4['photo_4']!='0'){$pic_small.='<img id="p_4" class="smpic_cn" style="margin-right:0" onclick="changePic(\'4\',\''.$a4['photo_4'].'\');" src="/members/uploads/4/'.$a4['photo_4'].'">';$photo_count++;}
// photo thumbnails
if($photo_count>1){
$photos_row.='<tr>';
$photos_row.='<td valign="top" width="175" align="center">'.$pic_small.'</td>';
$photos_row.='</tr>';
}
$photos='<div class="cn_shaddow cont_cn" style="margin-top:40px;padding:0;">
<table class="photos_tbl" width="100%">
<tr>
<td valign="top">'.$photos_big.'</td>
</tr>
'.$photos_row.'
</table>
</div>';
}
// if promotions exists
if($promo_num_row!=0){
while($promo_row = $r6->fetch_assoc()){
if($promo_row['prom_title']){
$promo_bg = ($i++ & 1) ? '#fff' : '#fafafa'; // background alternator
$promo.='<div style="padding:15px;background:'.$promo_bg.';"><div style="font-size:14pt;">'.strip_tags($promo_row['prom_title']).'</div>
<div style="margin-top:5px;font-size:11pt;line-height:22px">'.htmlentities(strip_tags($promo_row['prom_desc'])).'</div>
<div style="margin-top:10px;font-size:10pt;color:#444;"><b>Valid from: </b>'.date('d/m/Y',$promo_row['prom_valid']).' <b>Expires at: </b>'.date('d/m/Y',$promo_row['prom_expiry']).'</div></div>';
}
}
$promotions.='<div class="cn_shaddow cont_cn" style="padding:0px;">
<div class="subhead_bar" style="background:#c6534b;margin:10px;position:relative;height:39px;padding:0px;line-height:39px;">Promotions & Offers<img src="/img/promo_tag.png" style="position:absolute;top:0px;left:-50px" /></div>
<div class="subname" style="margin:15px 15px">Current Offers & Promotions at '.$company_name.'</div>
'.$promo.'
</div>';
}
// establishment
if($a4['establishment']){
$company_established='<span class="subhead">Business Establishment</span>'.strip_tags($a4['establishment']);
}
// if refund policy exists
if($a4['refund']){
$refund_policy.='<br><br><span class="subhead">Our Quarantees & Refund Policies</span><br>'.$a4['refund'].'.. ';
}
// if categories exists
if($a4['category']){
$categories=explode(" || ",substr_replace(strip_tags($a4['category']),'',-4));
// removing first array field
unset($categories[0]);
if(count($categories)>20){$company_categories.='<br><div style="font-size:9pt;color:#555;">Showing the first 20 categories only</div>';}
$company_categories.='<br><div class="horiz_list cats" style="margin:5px 0 0;padding:0;overflow:hidden">';
foreach($categories as $cat_key => $category){
if($cat_key<=20){
$company_categories.='<div style="font-size:11pt">'.ucwords($category).'</div>';
}
}
$company_categories.='</div>';
}else{
$company_categories.='<div>Currently no categories provided by '.$company_name.' <a rel="nofollow" href="/members/category.html?adid='.$adid.'">Click here to add categories >></a></div>';
}
if($a4['areas_cover']){
// areas covered
$areas_covered='<span class="subhead">Areas We Serve</span>';
$lngth = 500;
$subDesc=substr(strip_tags($a4['areas_cover']),0,$lngth);
if(strlen($a4['areas_cover'])>$lngth){$areas_covered.=$subDesc.'...';}else{$areas_covered.=strip_tags($a4['areas_cover']);}
}
// opening times
if($opening_num_row!=0){
$opSelMon = (date('l') == 'Monday' ? 'class="active"' : ' ');
$opSelTue = (date('l') == 'Tuesday' ? 'class="active"' : ' ');
$opSelWed = (date('l') == 'Wednesday' ? 'class="active"' : ' ');
$opSelThu = (date('l') == 'Thursday' ? 'class="active"' : ' ');
$opSelFri = (date('l') == 'Friday' ? 'class="active"' : ' ');
$opSelSat = (date('l') == 'Saturday' ? 'class="active"' : ' ');
$opSelSun = (date('l') == 'Sunday' ? 'class="active"' : ' ');
$monday_optime = ($opening_row['monday'] ? $opening_row['monday'] : '<span >N/A</span>');
$tuesday_optime = ($opening_row['tuesday'] ? $opening_row['tuesday'] : '<span >N/A</span>');
$wednesday_optime = ($opening_row['wednesday'] ? $opening_row['wednesday'] : '<span >N/A</span>');
$thursday_optime = ($opening_row['thursday'] ? $opening_row['thursday'] : '<span >N/A</span>');
$friday_optime = ($opening_row['friday'] ? $opening_row['friday'] : '<span >N/A</span>');
$saturday_optime = ($opening_row['saturday'] ? $opening_row['saturday'] : '<span >N/A</span>');
$sunday_optime = ($opening_row['sunday'] ? $opening_row['sunday'] : '<span >N/A</span>');
$opening_times='<table class="listing-time">
<tbody>
<tr '.$opSelMon.'>
<td>Monday</td>
<td>'.$monday_optime.'</td>
</tr>
<tr '.$opSelTue.'>
<td>Tuesday</td>
<td>'.$tuesday_optime.'</td>
</tr>
<tr '.$opSelWed.'>
<td>Wednesday</td>
<td>'.$wednesday_optime.'</td>
</tr>
<tr '.$opSelThu.'>
<td>Thursday</td>
<td>'.$thursday_optime.'</td>
</tr>
<tr '.$opSelFri.'>
<td>Friday</td>
<td>'.$friday_optime.'</td>
</tr>
<tr '.$opSelSat.'>
<td>Saturday</td>
<td>'.$saturday_optime.'</td>
</tr>
<tr '.$opSelSun.'>
<td>Sunday</td>
<td>'.$sunday_optime.'</td>
</tr>
</tbody>
</table>';
}
// social links
if($social_row['facebook']||$social_row['linkedin']||$social_row['twitter']||$social_row['googleplus']||$social_row['youtube']){
$social_links.='<div class="cn_shaddow cont_cn">
<span class="subhead">'.$company_name.' Links</span><br><br>';
if($social_row['facebook']){
$social_links.='<table width="60%" rel="nofollow" onclick="window.open(\'http://'.$social_row['facebook'].'\',\'_blank\');" class="cn_shaddow socialTbl fb_social"><tr><td width="28"><img src="/img/fb_ico.png" width="7" height="21"/></td><td>View our Facebook Page >></td></tr></table>';
}
if($social_row['linkedin']){
$social_links.='<table width="60%" rel="nofollow" onclick="window.open(\'http://'.$social_row['linkedin'].'\',\'_blank\');" class="cn_shaddow socialTbl lkdin_social"><tr><td width="28"><img src="/img/lnkdin_ico.png" width="20" height="21"/></td><td>View our LinkedIn Pag >></td></tr></table>';
}
if($social_row['twitter']){
$social_links.='<table width="60%" rel="nofollow" onclick="window.open(\'http://'.$social_row['twitter'].'\',\'_blank\');" class="cn_shaddow socialTbl twit_social"><tr><td width="28"><img src="/img/twit_ico.png" width="20" height="21"/></td><td>View our Twitter Page >></td></tr></table>';
}
if($social_row['googleplus']){
$social_links.='<table width="60%" rel="nofollow" onclick="window.open(\'http://'.$social_row['googleplus'].'\',\'_blank\');" class="cn_shaddow socialTbl ggl_social"><tr><td width="28"><img src="/img/ggl_ico.png" width="24" height="21"/></td><td>View our Google+ Page >></td></tr></table>';
}
if($social_row['youtube']){
$social_links.='<table width="60%" rel="nofollow" onclick="window.open(\'http://'.$social_row['youtube'].'\',\'_blank\');" class="cn_shaddow socialTbl ytube_social"><tr><td width="28"><img src="/img/ytube_ico.png" width="18" height="20"/></td><td>View our YouTube Page >></td></tr></table>';
$social_links.='<table width="60%" rel="nofollow" onclick="window.open(\'http://'.$social_row['youtube'].'\',\'_blank\');" class="cn_shaddow socialTbl ytube_social"><tr><td width="28"><img src="/img/ytube_ico.png" width="18" height="20"/></td><td>View our YouTube Page >></td></tr></table>';
}
$social_links.='</div>';
}
if($a4['review_on']==1){
// $review .='<div class="cn_shaddow cont_cn" style="padding:0px;">';
// $review .='<div class="heading" style="margin:10px 15px 10px;">'.$company_name.' Reviews</div>';
$average_rating = 0;
$average_rating_html ='';
if($rev_num_row!=0){
/** count rating category */
$rating_bar[1] = 0;
$rating_bar[2] = 0;
$rating_bar[3] = 0;
$rating_bar[4] = 0;
$rating_bar[5] = 0;
$reviews = '';
$review_display = "";
$check = 0;
// reviews to be display
while($rev_row = mysqli_fetch_array($r7)){
/** counting */
if($rev_row['rev_rating']==5){
$rating_bar[5] += 1;
}elseif($rev_row['rev_rating']==4){
$rating_bar[4] += 1;
}elseif($rev_row['rev_rating']==3){
$rating_bar[3] += 1;
}elseif($rev_row['rev_rating']==2){
$rating_bar[2] += 1;
}else{
$rating_bar[1] += 1;
}
$ratings[] .= $rev_row['rev_rating'];
// $rating_html.= '<img class="rate_'.$rev_row['rev_rating'].'" style="margin-bottom:-3px;border:0" src="/img/img_trans.gif" width="1" height="1" />';
// $rev_bg = ($i++ & 1) ? '#fff' : '#fafafa'; // background alternator
// $review.='<div style="background-color:'.$rev_bg.';padding:10px 15px;">
// <div style="color:#00578d;font-weight:bold;">'.$rev_row['rev_name'].' '.$rating_html.'</div>
// <div style="color:#555;font-size:13px;margin-bottom:7px;">Review given on: '.date('d/m/Y',$rev_row['rev_date']).'</div>
// <div style="font-size:13px;line-height:21px">'.htmlentities(strip_tags($rev_row['rev_comment'])).'</div>';
// //response
// if($rev_row['rev_reply']!=''){
// $review.='<div style="padding:10px 10px 10px 40px;">
// <div style="color:#00578d;font-weight:bold;font-size:16px">Response from '.$company_name.'</div>
// <div style="font-size:13px;line-height:21px">'.htmlentities(strip_tags($rev_row['rev_reply'])).'</div>
// </div>';
// }
// $review.='</div>';
// $rating_html='';// resetting ratings div
$indevidual_rating = '';
for($i=1; $i<=5; $i++ ){
if($i <= $rev_row['rev_rating']){
$indevidual_rating .= '<svg fill="#FFCC22">
<use xlink:href="index.svg#star-fill"></use>
</svg>';
} else{
$indevidual_rating .= '<svg fill="#EEE">
<use xlink:href="index.svg#star-fill"></use>
</svg>';
}
}
$check_submit_review_query = $connect->query("SELECT * FROM `reviews` WHERE `rev_id` = '{$rev_row['rev_id']}' AND `rev_member_id`='{$memberid}'") or die($connect->error);
$member_rev_num_row = $check_submit_review_query->num_rows;
if($member_rev_num_row){
$display = "";
$check = 1;
} else{
$display = "display: none;";
}
// <a href="#" style="'.$display.'" type="button" id="review-edit-button" data-review-id="'.$rev_row['rev_id'].'" class="review-edit-button">Edit</a>
$reviews .= '<div class="listing-review-content">
<div style="display: flex">
<h2>'.$rev_row['rev_name'].'</h2>
</div>
<div class="listing-rating-box">
<div class="listing-rating">';
// $reviews .= '<div class="listing-review-content"><h2>'.$rev_row['rev_name'].'</h2>
// <div class="listing-rating-box">
// <div class="listing-rating">';
$reviews .= $indevidual_rating;
$reviews .= '</div>
<div class="review-date">
'.date("d F, Y", $rev_row['rev_date']).'
</div>
</div>
<p>'.$rev_row['rev_comment'].'</p>';
if(!empty($rev_row['rev_reply'])){
$reviews .='
<div class="review-reply-box">
<div class="review-reply">
<div class="review-reply-head">
<div class="review-reply-user">Admin</div>
</div>
<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Sunt odit nobis voluptas sed labore iure
iusto, atque doloribus provident illum?</p>
</div>
</div>';
}
$reviews .= '</div>';
}
// if($check){
// $review_display = '<div class="listing-box">
// <h2 class="listing-section-title">Add Your Review</h2>
// <p id="review-success" class="alert-success"
// style="padding: 10px; font-weight: bold; border: 1px solid green; font-size: 20px;">Reviewed
// successfully.</p>
// <p id="review-error" class="alert-error"
// style="padding: 10px; font-weight: bold; border: 1px solid red; font-size: 20px;">Oops!
// something went wrong.</p>
// <form action="" class="review-form" id="review">
// <input type="hidden" name="adid" value="'.$adid.'">
// <input type="hidden" name="memberid" value="'.$memberid.'">
// <div class="rating">
// <div>
// <label for="rating-1">
// <svg>
// <use xlink:href="index.svg#star-fill"></use>
// </svg>
// </label>
// <input type="radio" value="1" name="rating" id="rating-1">
// </div>
// <div>
// <label for="rating-2">
// <svg>
// <use xlink:href="index.svg#star-fill"></use>
// </svg>
// </label>
// <input type="radio" value="2" name="rating" id="rating-2">
// </div>
// <div>
// <label for="rating-3">
// <svg>
// <use xlink:href="index.svg#star-fill"></use>
// </svg>
// </label>
// <input type="radio" value="3" name="rating" id="rating-3">
// </div>
// <div>
// <label for="rating-4">
// <svg>
// <use xlink:href="index.svg#star-fill"></use>
// </svg>
// </label>
// <input type="radio" value="4" name="rating" id="rating-4">
// </div>
// <div>
// <label for="rating-5">
// <svg>
// <use xlink:href="index.svg#star-fill"></use>
// </svg>
// </label>
// <input type="radio" value="5" name="rating" id="rating-5" checked>
// </div>
// </div>
// <div class="form-box">
// <div class="form-group">
// <label for="name">
// <svg>
// <use xlink:href="index.svg#user-smile-line"></use>
// </svg>
// </label>
// <input required type="text" name="name" id="name" placeholder="Enter your name">
// </div>
// </div>
// <div class="form-box">
// <div class="form-group">
// <label for="email">
// <svg>
// <use xlink:href="index.svg#mail-line"></use>
// </svg>
// </label>
// <input required type="email" name="email" id="email" placeholder="Enter your email">
// </div>
// </div>
// <div class="form-box">
// <div class="form-group">
// <label for="message">
// <svg>
// <use xlink:href="index.svg#chat-1-line"></use>
// </svg>
// </label>
// <textarea cols="30" rows="5" name="message" id="message" placeholder="Your message"></textarea>
// </div>
// </div>
// <button type="submit" id="submit-button" class="button button-yellow" name="submit">Submit</button>
// </form>
// </div>';
// }
for($i=1; $i<=5; $i++){
if($rating_bar[$i]!=0){
$rating_bar[$i] = ceil(($rating_bar[$i]/$rev_num_row*100));
}
}
$rating_bar = '<div class="listing-rating-process-box"><ul><li>
<span>1</span>
<div class="process-bar" style="width: '.$rating_bar[1].'%"></div>
</li>
<li>
<span>2</span>
<div class="process-bar" style="width: '.$rating_bar[2].'%"></div>
</li>
<li>
<span>3</span>
<div class="process-bar" style="width: '.$rating_bar[3].'%"></div>
</li>
<li>
<span>4</span>
<div class="process-bar" style="width: '.$rating_bar[4].'%"></div>
</li>
<li>
<span>5</span>
<div class="process-bar" style="width: '.$rating_bar[5].'%"></div>
</li></ul></div>';
// company overall review rating
$arr_sum = array_sum($ratings);
$mean = $arr_sum / $rev_num_row;
$average_rating = round($mean, 1);
$average = round($mean*2)/2; // round to the nearest half
for($i=1; $i<=5; $i++){
if($i <= $average){
$average_rating_html .= '<svg fill="#FFCC22">
<use xlink:href="index.svg#star-fill"></use>
</svg>';
} else{
$average_rating_html .= '<svg fill="#EEE">
<use xlink:href="index.svg#star-fill"></use>
</svg>';
}
}
$averageCss=str_replace(".","-",$average);
$advert_rating='<img class="rate_'.$averageCss.'" src="/img/img_trans.gif" width="1" height="1" /><meta itemprop="rating" content="'.$average.'" /> ';
$company_rating.='<div style="margin:5px 0;overflow:hidden;"><div style="float:left;clear:left;">'.$advert_rating.'</div>
<div style="float:left;margin-left:7px;font-size:10pt;color:#444;" itemprop="rating" itemscope itemtype="http://data-vocabulary.org/Rating">
<span itemprop="average">Rating '.$average.'</span> out of <span itemprop="best">5</span>. Based on <span itemprop="count">'.$rev_num_row.'</span> user reviews.</div></div>';
}else{
$average_rating_html = '<svg fill="#EEE">
<use xlink:href="index.svg#star-fill"></use>
</svg>
<svg fill="#EEE">
<use xlink:href="index.svg#star-fill"></use>
</svg>
<svg fill="#EEE">
<use xlink:href="index.svg#star-fill"></use>
</svg>
<svg fill="#EEE">
<use xlink:href="index.svg#star-fill"></use>
</svg>
<svg fill="#EEE">
<use xlink:href="index.svg#star-fill"></use>
</svg>';
$rating_bar = '<div class="listing-rating-process-box">
<ul>
<li>
<span>1</span>
<div class="process-bar" style="width: 0%"></div>
</li>
<li>
<span>2</span>
<div class="process-bar" style="width: 0%"></div>
</li>
<li>
<span>3</span>
<div class="process-bar" style="width: 0%"></div>
</li>
<li>
<span>4</span>
<div class="process-bar" style="width: 0%"></div>
</li>
<li>
<span>5</span>
<div class="process-bar" style="width: 0%"></div>
</li>
</ul>
</div>';
$reviews .='<div style="padding:20px;margin-top:20px;background-color:#fafafa;color:#444;text-align:center;font-weight:bold;">There are no reviews, be the first to submit a review for '.$a4['companyname'].'</div>';
}
$review .='
<div id="review_form"><!-- anchor for scroll --></div>
<div id="rate_form" style="display:none;margin-top:20px;background:#fafafa;padding:10px 0">
<form method="POST" name="rate_form" onsubmit="return CheckForm();" action="/review_confirmation/new_review.html">
<div class="heading" style="margin:10px 15px 0;">Submit a review for '.$company_name.'</div>
<table width="100%" style="margin:10px 15px">
<tr>
<td style="padding:5px;"><b>Your Name*</b><br><input style="padding:5px" type="text" name="rev_name" size="15"></td>
<td style="padding:5px;"><b>Your Email*</b><br><input style="padding:5px" type="text" name="rev_email" size="15"></td>
<td style="padding:5px;"><b>Your Rating*</b><br><select style="padding:5px" size="1" name="rev_rating">
<option value selected>Select Rating</option>
<option>1 out of 5</option>
<option>2 out of 5</option>
<option>3 out of 5</option>
<option>4 out of 5</option>
<option>5 out of 5</option>
</select>
<input value="'.$adid.'" type="hidden" name="adid" size="15">
<input value="'.$memberid.'" type="hidden" name="mid" size="15">
<input value="'.$company_name.'" type="hidden" name="companyname" size="15">
</td>
</tr>
<tr>
<td style="padding:5px;" colspan="3">
<b>Your Comment*</b><br>
<textarea style="padding:5px;width:95%;box-sizing:border-box" rows="7" id="rev_comment" name="rev_comment" cols="49" onkeydown="textCounter(\'rev_comment\',\'remLen1\',250)"></textarea><br>
<div style="margin:5px 0 15px 0;"><input readonly="" type="text" id="remLen1" name="remLen1" size="3" maxlength="3" value="250" style="background-color:#fcfcfc;border:1px solid # ;padding:5px;">
Characters left</div>
<b>Word Verification</b><br>
<div style="margin:3px 0 16px">
Word Verification prevents automated systems from adding accounts to YellowLeaf. <br><br>Please enter the 4 letters you see on the left into the box on the right:
</div>
<div style="margin-top:5px;margin-left:2px;"><img src="captcha.jpg" alt="CAPTCHA image" align="top" /> >
<input type="text" class="txbox" name="validator" id="validator" maxlength="4" size="4" value /></div>
<input class="blueBtn fancyBtn" style="border:0px;float:none;margin-top:10px;padding:6px 16px" type="submit" value="Submit Review" name="rate">
<input class="redBtn fancyBtn" onclick="hideRateAdd()" style="border:0px;float:none;margin-top:10px;padding:6px 16px" type="button" value="Hide Form" name="hide">
<span style="font-size:9pt;color:#666;">* mandatory fields that must be filled in.</span>
</td>
</tr>
</table>
</form>
</div>
<div style="padding:15px;overflow:hidden">
<button type="button" style="overflow:hidden;float:right;" id="addrev_btn" onclick="showRateAdd()" class="blueBtn fancyBtn">Add Your Review for '.$company_name.' >></button>
</div>
</div>';
$review_display = '<div class="listing-box">
<h2 class="listing-section-title">Add Your Review</h2>
<p id="review-success" class="alert-success review-message"
style="padding: 10px; font-weight: bold; border: 1px solid green; font-size: 20px;">Reviewed
successfully.</p>
<p id="review-error" class="alert-error review-message"
style="padding: 10px; font-weight: bold; border: 1px solid red; font-size: 20px;">Oops!
something went wrong.</p>
<form action="" class="review-form" id="review">
<input type="hidden" name="adid" value="'.$adid.'">
<input type="hidden" name="memberid" value="'.$memberid.'">
<div class="rating">
<div>
<label for="rating-1">
<svg>
<use xlink:href="index.svg#star-fill"></use>
</svg>
</label>
<input type="radio" value="1" name="rating" id="rating-1">
</div>
<div>
<label for="rating-2">
<svg>
<use xlink:href="index.svg#star-fill"></use>
</svg>
</label>
<input type="radio" value="2" name="rating" id="rating-2">
</div>
<div>
<label for="rating-3">
<svg>
<use xlink:href="index.svg#star-fill"></use>
</svg>
</label>
<input type="radio" value="3" name="rating" id="rating-3">
</div>
<div>
<label for="rating-4">
<svg>
<use xlink:href="index.svg#star-fill"></use>
</svg>
</label>
<input type="radio" value="4" name="rating" id="rating-4">
</div>
<div>
<label for="rating-5">
<svg>
<use xlink:href="index.svg#star-fill"></use>
</svg>
</label>
<input type="radio" value="5" name="rating" id="rating-5" checked>
</div>
</div>
<div class="form-box">
<div class="form-group">
<label for="name">
<svg>
<use xlink:href="index.svg#user-smile-line"></use>
</svg>
</label>
<input required type="text" name="name" id="name" placeholder="Enter your name">
</div>
</div>
<div class="form-box">
<div class="form-group">
<label for="email">
<svg>
<use xlink:href="index.svg#mail-line"></use>
</svg>
</label>
<input required type="email" name="email" id="email" placeholder="Enter your email">
</div>
</div>
<div class="form-box">
<div class="form-group">
<label for="message">
<svg>
<use xlink:href="index.svg#chat-1-line"></use>
</svg>
</label>
<textarea cols="30" rows="5" name="message" id="message" placeholder="Your message"></textarea>
</div>
</div>
<button type="submit" id="submit-button" class="button button-yellow" name="submit">Submit</button>
</form>
</div>';
}
//--- related businesses
include_once('related.php');
//// boz title
$rcounty = $a4['county_name'];
if ($a4['category'] && !$a4['seo_title']) {
$bcategories=explode(" || ",substr_replace(strip_tags($a4['category']),'',-4));
$rand_key = array_rand($bcategories);
$rand_value = ucwords(trim($bcategories[$rand_key]));
if($rand_value) {
$connect->query("UPDATE ads SET seo_title='{$rand_value}' WHERE adid = '{$adid}'");
} else {$rand_value = ucwords(trim($bcategories[$rand_key])); $connect->query("UPDATE ads SET seo_title='{$rand_value}' WHERE adid = '{$adid}'");}
}
//--- page details
if ($rand_value) {
$title=$a4['companyname'].' - Reviews & Opening Times';
// $title=$rand_value.' in '.$town_name.', '.$a4['companyname'].' Reviews Opening Times UK';
//$title=$a4['companyname'].' Reviews Opening Times, .'$tempbcategory.' in '.$town_name.', UK';
$page_title_h1=$a4['companyname'];
// $page_title_h1=$rand_value.' in '.$town_name;
$page_title_h2='<h2 style="text-shadow:1px 1px 0px rgba(135,135,135,0.5);color:rgb(27, 133, 197)">'.$a4['companyname'].'</h2>';
} else {
if($a4['seo_title']){
$tempbcat = ucwords($a4['seo_title']);
$title=$a4['companyname'].' - Reviews & Opening Times';
// $title=$a4['companyname'].' in '.$town_name.' Reviews Opening Times '.$tempbcat.' UK';
// $title=$tempbcat.' in '.$town_name.', '.$a4['companyname'].' Reviews Opening Times UK';
$page_title_h1=$a4['companyname'];
// $page_title_h1=$tempbcat.' in '.$town_name;
$page_title_h2='<div style="text-shadow:1px 1px 0px rgba(135,135,135,0.5);color:rgb(27, 133, 197);font-size:25pt;margin-bottom:10px;line-height:30px;">'.$a4['companyname'].'</div>';
} else {
$title=$a4['companyname'].' - Reviews & Opening Times';
// $title=$a4['companyname'].' in '.$town_name.', Reviews Opening Times UK';
$page_title_h1=$a4['companyname'];
// $page_title_h1=$a4['companyname'].' in '.$town_name;
$page_title_h2='<div style="text-shadow:1px 1px 0px rgba(135,135,135,0.5);color:rgb(27, 133, 197);font-size:25pt;margin-bottom:10px;line-height:30px;">'.$a4['companyname'].'</div>';
}
}
$description=preg_replace("/\n+/i", "", strip_tags($a4['description']));
$description=substr($description, 0, 200).'...';
// $description='Welcome to '.$company_name.' '.$a4['tel'].', '.trim($a4['postcode']).'.';
// $description='Welcome to '.$company_name.' '.$a4['tel'].'. '.$title.', '.trim($a4['postcode']).'.';
/*
// for menu
$today_date=date('l jS F Y');
if(isset($_SESSION['ename'])||isset($_COOKIE['yl_user'])){
$loggedin_nav.='<a href="/members">Members Area</a>';
}else{
$loggedin_nav.='<a href="/login">Login</a>';
$loggedin_nav.='<a href="/advertise">Advertise</a>';
}
*/
// for search
$cat_eg="Taxi, Restaurant or Company Name";
$loc_eg="Town e.g London or E14";
$txt_eg_color="#888";
// if logged change button URL
if(isset($_SESSION['ename'])||isset($_COOKIE['yl_user'])){$yleaf_url='/members/';}else{$yleaf_url='/advertise/';}
$provided_by_btn='<a style="border:0px;outline:none;" href="'.$yleaf_url.'">
<img src="/img/providedby.png" onmouseover="this.src=\'/img/providedby_hover.png\'" onmouseout="this.src=\'/img/providedby.png\'" style="border:0;outline:none;">
</a>';
//-- page details end
if($services_offered){
$services_offered = explode(' || ', $services_offered);
$serv = '<ul class="listing-services">';
foreach($services_offered as $sa){
$sa = trim($sa);
if (!empty($sa)) {
if($sa!='.'){
$serv .= '<li>
<svg>
<use xlink:href="index.svg#checkbox-circle-line"></use>
</svg>'.ucfirst($sa).'</li>';
}
}
}
$serv .= '</ul>';
}
// compile
// similer listings
$similer_listings = "";
$similer_listings_sql = $connect->query("SELECT *,
(6371 * acos(cos(radians(latitude)) * cos(radians('51.3758')) * cos(radians('$lat') - radians(longitude)) + sin(radians(latitude)) * sin(radians('$long')))) AS distance
FROM ads
WHERE active = 1 AND town_name = '$town_name' AND business_type = '".$a4['business_type']."' OR ((`cat1` LIKE '".$a4['cat1']."' OR `cat2` LIKE '".$a4['cat2']."' OR `cat3` = '".$a4['cat3']."') AND adid != ".$a4['adid'].")
ORDER BY distance
LIMIT 4;");
while ($similer_listings_row = $similer_listings_sql->fetch_assoc()) {
$b_name = $similer_listings_row['companyname'];
$b_county_name = $similer_listings_row['county_name'];
$b_image = $similer_listings_row['image'];
$r_ad_name=strtolower($b_name);
$r_ad_name = preg_replace("/[^A-Za-z 0-9]/", "", $r_ad_name); $r_ad_name=str_replace(" "," ",$r_ad_name);
$ad_name=str_replace(" ","-",$r_ad_name);
$b_adid = $similer_listings_row['adid'];
if ($row["aspect_ratio"] == 1) {
$aspect_ratio_class = 'aspect-square';
}else{
$aspect_ratio_class = '';
}
$short_title = short_title_converter($b_name);
$business_logo_placeholder = '<div class="business-placeholder-image">'.$short_title.'</div>';
if($b_image){
if(file_exists('./members/uploads/logo/'.$b_image)){
$src = '/members/uploads/logo/'.$b_image;
$similer_business_image = '<img class="'.$aspect_ratio_class.'" src="'.$src.'"
alt="tshirt photo">';
}else{
$similer_business_image = $business_logo_placeholder;
}
}else{
$similer_business_image = $business_logo_placeholder;
}
$s_listing_url = '/pages/'.$b_adid.'-'.$ad_name.'.html';
$similer_listings .= '<div class="listing-item">
<div class="listing-header">
<a style="text-decoration: none;" href="'.$s_listing_url.'" class="listing-similar-image">
'.$similer_business_image.'
</a>
</div>
<div class="listing-info">
<a href="'.$s_listing_url.'" class="listing-title">
'.$b_name.'
</a>
<div class="listing-location">
<svg>
<use xlink:href="/homepage/index.svg#location-fill"></use>
</svg>
'.$b_county_name.'
</div>
<div class="listing-action">
<div class="listing-rating-star">
<svg>
<use xlink:href="/homepage/index.svg#star-fill"></use>
</svg>
<svg>
<use xlink:href="/homepage/index.svg#star-fill"></use>
</svg>
<svg>
<use xlink:href="/homepage/index.svg#star-fill"></use>
</svg>
<svg>
<use xlink:href="/homepage/index.svg#star-fill"></use>
</svg>
<svg>
<use xlink:href="/homepage/index.svg#star-fill"></use>
</svg>
</div>
</div>
</div>
</div>';
}
// similer listings end
$header= file_get_contents($path.'/header-footer/header.php');
$footer= file_get_contents($path.'/header-footer/footer.php');
$template = new Template;
$template->load("pages.html");
$template->replace("top_bar", $top_bar);
$template->replace("similer_listings", $similer_listings);
$template->replace("adid", $adid);
$template->replace("memberid", $memberid);
$template->replace("provided_by_btn", $provided_by_btn);
$template->replace("page_title_h1", $page_title_h1);
$template->replace("page_title_h2", $page_title_h2);
$template->replace("company_name", $company_name);
$template->replace("mcategory", $mcategory);
$template->replace("lat", $lat);
$template->replace("long", $long);
$template->replace("town_name", $town_name);
$template->replace("address", $address);
$template->replace("tel_no", $tel_no);
$template->replace("fax_no", $fax_no);
$template->replace("website_url", $website_url);
$template->replace("website_button", $website_button);
$template->replace("logo", $logo);
$template->replace("logo_title", $logo_title);
$template->replace("more_photos", $more_photos);
$template->replace("company_desc", $company_desc);
$template->replace("display_company_desc", $company_desc ? '' : 'hidden');
$template->replace("company_products", $company_products);
$template->replace("photos", $photos);
$template->replace("services_offered", $serv);
$template->replace("display_services_offered", $serv ? '' : 'hidden');
$template->replace("company_postcode", $company_postcode);
$template->replace("company_postcode_main", $company_postcode_main);
$template->replace("refund_policy", $refund_policy);
$template->replace("promotions", $promotions);
$template->replace("areas_covered", $areas_covered);
$template->replace("company_categories", $company_categories);
$template->replace("reviews", $reviews);
$template->replace("review_display", $review_display);
$template->replace("total_reviews", $rev_num_row);
$template->replace("average_rating", $average_rating);
$template->replace("average_rating_html", $average_rating_html);
$template->replace("advert_rating", $advert_rating);
$template->replace("rating_bar", $rating_bar);
$template->replace("related", $related);
$template->replace("opening_times", $opening_times);
$template->replace("company_established", $company_established);
$template->replace("social_links", $social_links);
$template->replace("today_date", $today_date);
$template->replace("loggedin_nav", $loggedin_nav);
$template->replace("cat_eg", $cat_eg);
$template->replace("loc_eg", $loc_eg);
$template->replace("txt_eg_color", $txt_eg_color);
$template->replace("header", $header);
$template->replace("footer", $footer);
$template->replace("title", $title);
$template->replace("description", $description);
$template->replace("taglink", $taglink);
$template->replace("company_rating", $company_rating);
$template->publish();
?>