H69UNtblNBNpha2dtB1Odn8qYp1Qk5NK2gi7yfceofo9N

/home/ymswebso/public_html/postads/control/

<table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" bgcolor="#FFFFFF">
 <tr>
 <td width="17%" align="center" bgcolor="#006EC6" class="arialWhite">Logo/Image</td>
 <td width="41%" align="left" bgcolor="#006EC6" class="arialWhite">Listing Info. </td>
 <td width="14%" align="center" bgcolor="#006EC6" class="arialWhite">Location</td>
 <td width="14%" align="center" bgcolor="#006EC6" class="arialWhite">Active</td>
 <td width="14%" align="center" bgcolor="#006EC6" class="arialWhite">Actions</td>
 </tr>
 <tr>
 <?php
								$result = mysql_query("select * from business_ads where listing_type = 'business' order by id desc limit 0,10");
								
								while($row = mysql_fetch_array($result))
								{
								$id=$row['id'];
								$rand_value=$row['rand_value'];
								$membership_status=$row['membership_status'];
								
								$business_id=$row['id'];
								$business_name=$row['business_name'];
								$listing_type=$row['listing_type'];
								$business_website=$row['business_website'];
								$business_slogan=$row['business_slogan'];
								$business_name_output = str_replace(" ","-",strtolower($business_name));
								$city=$row['city']." ";
								$city_name_output = str_replace(" ","-",strtolower($row['city']));
								$business_ad_image=$row['business_ad_image'];
								$business_logo = $row['business_logo'];
								$main_category=$row['main_category'];
								$sub_category=$row['sub_category'];
								$description=$row['description'];
								$status=$row['status'];
								$created=$row['created'];
								
								$date_created=explode(' ',$created);
								$date_created1=explode('-',$date_created[0]);
								
								$dateArray_time1=explode(' ',$created);
								$dateArray_time=explode(':',$dateArray_time1[1]);
								
								$day_numeric=$date_created1[2];
								$month_numeric=$date_created1[1];				 
								$year_numeric=$date_created1[0];				 
								$month_listing_created = date( 'M', mktime(0, 0, 0, $month_numeric) );
								$listing_date_format = $month_listing_created."-".$day_numeric."-".$year_numeric." ".date('g:i a', mktime($dateArray_time[0], $dateArray_time[1]));
								/////////// fetching total reviews ///////////////
								$result_totalrating = mysql_query("SELECT SUM(rating_points) as total_rating FROM business_add_rating where product_id = '$id' and status = 'Yes'");
								$result_totalraters = mysql_query("select * from business_add_rating where product_id = '$id' and status = 'Yes'");
								$num_totalrating=mysql_num_rows($result_totalraters);
								while($row_totalrating = mysql_fetch_array($result_totalrating))
								{
								$total_rating = $row_totalrating['total_rating'];					 
								}
								
								if($num_totalrating!=0)
								{
								$averagerating = $total_rating/$num_totalrating;
								$averagerating_output = number_format($averagerating, 2);
								}
								else
								{
								$averagerating_output = 0;
								}				 
								
								
								////////////////////////////////////////////////////////////////
								
								$rating = mysql_query("select * from business_add_rating where product_id = '$listing_review_id' and status = 'Yes' order by id desc LIMIT 0,1");
								$num_rating_listing=mysql_num_rows($rating);				 
								
								while($rating_number= mysql_fetch_assoc($rating))
								{
								$review_desc = $rating_number['review_desc'];			 
								}
								//////////////////////////////////////////////////////////////
								if($row['building_name']!="")
								{
								$building_name=$row['building_name']." ";
								}
								else
								{
								$building_name="";
								}
								
								if($row['unit_level']!="")
								{
								$unit_level=$row['unit_level']." ";
								}
								else
								{
								$unit_level="";
								}
								
								if($row['street_number']!="")
								{
								$street_number=$row['street_number']." ";
								}
								else
								{
								$street_number="";
								}
								
								if($row['street_name']!="")
								{
								$street_name=$row['street_name']." ";
								}
								else
								{
								$street_name="";
								}
								
								if($row['street_type']!="")
								{
								$street_type=$row['street_type']." ";
								}
								else
								{
								$street_type="";
								}
								
								if($row['suberb']!="")
								{
								$suberb=$row['suberb']." ";
								}
								else
								{
								$suberb="";
								}
								
								if($row['city']!="")
								{
								$city=$row['city'].", ";
								$city_name_output = str_replace(" ","-",strtolower($row['city']));
								}
								else
								{
								$city="";
								$city_name_output="";
								}
								
								/////////// fetching the state name ////////////
								$result_state = mysql_query("select * from states_australia where id = '".$row['state']."'");
								while($row_state = mysql_fetch_array($result_state))
								{
									$state_name=$row_state['name'];
									$state_code=$row_state['state_code'];
								}				 
								//////////////////////////////////////////////
								
								if($row['state']!="")
								{
									$state=$state_code." ";
								}
								else
								{
									$state="";
								}
								
								if($row['post_code']!="")
								{
									$post_code=$row['post_code'];
								}
								else
								{
									$post_code="";
								}
								
								$full_address=$building_name.$unit_level.$street_number.$street_name.$street_type.$suberb.$city.$state.$post_code;
								
								$local_phone=$row['local_phone'];
								$national_phone=$row['national_phone'];
								$mobile_phone=$row['mobile_phone'];
								$fax_number=$row['fax_number'];
								
								if($row['preferred_contact_number']=="local_phone")
								{
									$preferred_contact_number=$local_phone;
								}
								elseif($row['preferred_contact_number']=="national_phone")
								{
									$preferred_contact_number=$national_phone;
								}
								elseif($row['preferred_contact_number']=="mobile_phone")
								{
									$preferred_contact_number=$mobile_phone;
								}
								$member_id = $row['member_id'];
								$member_eamil_sql = mysql_query("SELECT email_id FROM members_info WHERE id='".$member_id."'");
								$member_eamil_result = mysql_fetch_assoc($member_eamil_sql);
								$member_email = $member_eamil_result['email_id'];	
								?>
 
 <td align="center" valign="middle" bgcolor="#FFFFFF" class="mainText" style="border-top:1px solid #999999;">
							<?php 
								if($business_logo!='' && $business_ad_image=='')
								{
									$filename = '../imgs/'.$business_logo;
								}elseif($business_logo!='' && $business_ad_image!=''){
									$filename = '../imgs/'.$business_logo;
								}elseif($business_logo=='' && $business_ad_image!=''){
									$filename = '../imgs/'.$business_ad_image;
								}else{
									$filename = 'images/no_image_pic.gif';
								}
							?>
							 	<img src="<?php echo $filename; ?>" alt="" width="78" height="76" />
								</td>
 <td align="left" valign="middle" bgcolor="#FFFFFF" class="mainText" style="border-top:1px solid #999999;"><a href="/business/<?php echo $id; ?>/<?php echo $business_name_output; ?>/<?php echo $city_name_output; ?>" target="_blank"><?php echo $business_name; ?></a> 
 
 <?php
					 $rater_rating = $averagerating_output;					 
					 // Assign star image
						if ($rater_rating <= 0 ){$rater_stars = "<img src='/images/rating0.png' alt='' width='76' height='16' />";$rater_stars_txt="Not Rated";}
						if ($rater_rating >= 0.5){$rater_stars = "<img src='/images/rating05.png' alt='' width='76' height='16' />";$rater_stars_txt="0.5";}
						if ($rater_rating >= 1 ){$rater_stars = "<img src='/images/rating1.png' alt='' width='76' height='16' />";$rater_stars_txt="1";}
						if ($rater_rating >= 1.5){$rater_stars = "<img src='/images/rating1_5.png' alt='' width='76' height='16' />";$rater_stars_txt="1.5";}
						if ($rater_rating >= 2 ){$rater_stars = "<img src='/images/rating2.png' alt='' width='76' height='16' />";$rater_stars_txt="2";}
						if ($rater_rating >= 2.5){$rater_stars = "<img src='/images/rating2_5.png' alt='' width='76' height='16' />";$rater_stars_txt="2.5";}
						if ($rater_rating >= 3 ){$rater_stars = "<img src='/images/rating3.png' alt='' width='76' height='16' />";$rater_stars_txt="3";}
						if ($rater_rating >= 3.5){$rater_stars = "<img src='/images/rating3_5.png' alt='' width='76' height='16' />";$rater_stars_txt="3.5";}
						if ($rater_rating >= 4 ){$rater_stars = "<img src='/images/rating4.png' alt='' width='76' height='16' />";$rater_stars_txt="4";}
						if ($rater_rating >= 4.5){$rater_stars = "<img src='/images/rating4_5.png' alt='' width='76' height='16' />";$rater_stars_txt="4.5";}
						if ($rater_rating >= 5 ){$rater_stars = "<img src='/images/rating5.png' alt='' width='76' height='16' />";$rater_stars_txt="5";}
						echo $rater_stars;
					 ?>
 (<?php echo $num_totalrating; ?> Reviews) 
 <?php echo $business_slogan; ?> 
 <?php if($preferred_contact_number=="'mobile_phone' or 'national_phone' or 'local_phone' ") { ?>
 <img src="../images/contact.png" alt="" width="16" height="16" align="absmiddle" /> <?php echo $preferred_contact_number; ?>
 <?php } ?>
 &nbsp;&nbsp;
 <?php if($business_website=="business_website") { ?>
 <img src="../images/ie.png" alt="" width="16" height="16" align="absmiddle" /> <a href="#">Visit Website </a>
 <?php } ?>
 
 Posted by :&nbsp; <a href="total_listing_user?id=<?php echo $member_id; ?>"><?php echo $member_email; ?></a></td>
 <td align="center" valign="middle" class="mainText" style="border-top:1px solid #999999;"><?php echo $city; ?><?php echo $state_name; ?> 
 
 Date Posted: 
 <?php echo $listing_date_format; ?></td>
 <td align="center" valign="middle" bgcolor="#FFFFFF" class="mainText" style="border-top:1px solid #999999;"><?php
							 if($status=="0")
							 {
							 ?>
 <a href="main?ad_business_id=<?php echo $business_id; ?>&mode=updatestatus&status=1" style="color:#006633">Active</a> | Inactive
 <?php
							 }
							 else
							 {
							 ?>
 Active | <a href="main?ad_business_id=<?php echo $id; ?>&mode=updatestatus&status=0" style="color:#FF0000">Inactive</a>
 <?php
								 }
								 ?>
 <?php
				 
				 				$views = mysql_query("select * from views_listing where listing_id ='$id' and listing_type ='$listing_type'");
				 
								 $views_user=mysql_num_rows($views);
									{
									?>
 Views: <?php echo $views_user; ?></td>
 <?php
							 }

?>
 <td align="center" valign="middle" bgcolor="#FFFFFF" class="mainText" style="border-top:1px solid #999999;"><table width="110" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td align="center"><table border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td align="center" style="padding-left:8px; padding-right:8px;"><a href="/business/<?php echo $id; ?>/<?php echo $business_name_output; ?>/<?php echo $city_name_output; ?>" target="_blank"><img src="../images/view.png" alt="" width="16" height="16" border="0" /></a></td>
 <td align="center"><a href="#" onClick="javascript:window.open('edit-main-admin?id=<?php echo $id; ?>&redirect_page=main','editmaincategory','width=850,height=500,left=260,top=100,toolbar=0,status=0,resizable=yes,scrollbars=yes')"><img src="../images/edit.png" alt="" width="16" height="16" border="0" /></a></td>
 <td align="center" style="padding-left:8px;"><a href="main?id=<?php echo $id; ?>&rand_value=<?php echo $rand_value?>&action=delete&img=<?php echo $business_ad_image; ?>" onClick="javascript:return confirm('Are you sure you want to delete this business listing.');"> <img src="../images/del.png" alt="" width="16" height="16" border="0" /></a></td>
 </tr>
 </table></td>
 </tr>
 <tr>
 <td><input type="button" class="button" value="Manage Images" onclick=window.open("business_images?rand_value=<?php echo $rand_value?>","Ratting","width=685,height=450,left=300,top=100,toolbar=0,status=0,resizable=no,scrollbars=yes"); /></td>
 </tr>
 </table></td>
 </tr>
 <?php
		 }
		 ?>
 </table>

Nama File / Folder	Size	Action
Wp	--	NONE
css	--	NONE
ddlevelsfiles	--	NONE
editor	--	NONE
images	--	NONE
includes	--	NONE
js	--	NONE
Thumbs.db	5.5KB	Hapus Edit Rename
ad_business_listing_search.php	19.885KB	Hapus Edit Rename
as-edit-main-image.php	1.42KB	Hapus Edit Rename
edit-ad_listing.php	24.004KB	Hapus Edit Rename
edit-city-process.php	1.946KB	Hapus Edit Rename
edit-city.php	5.485KB	Hapus Edit Rename
edit-featured_listing.php	22.988KB	Hapus Edit Rename
edit-list-silver-process.php	5.944KB	Hapus Edit Rename
edit-main-image.php	1.417KB	Hapus Edit Rename
edit-states-process.php	1.985KB	Hapus Edit Rename
edit-sub-category.php	6.637KB	Hapus Edit Rename
fckeditor_php4.php	6.037KB	Hapus Edit Rename
feature_ad_edit-process.php	4.382KB	Hapus Edit Rename
gold_deal_update_process.php	2.608KB	Hapus Edit Rename
gold_sub_image_edit.php	1.733KB	Hapus Edit Rename
header.php	7.578KB	Hapus Edit Rename
index.php	4.549KB	Hapus Edit Rename
main-business-list.php	14.005KB	Hapus Edit Rename
main-delite_listing.php	0.502KB	Hapus Edit Rename
manage-city.php	5.684KB	Hapus Edit Rename
manage-expired-featured.php	18.887KB	Hapus Edit Rename
manage-users.php	14.106KB	Hapus Edit Rename
new_business-process.php	4.474KB	Hapus Edit Rename
news-letter-mail.php	2.75KB	Hapus Edit Rename
notfound.php	1.504KB	Hapus Edit Rename
send-customer-email-process.php	0.662KB	Hapus Edit Rename
send-customer-email.php	2.841KB	Hapus Edit Rename
set-expiry-admin.php	3.732KB	Hapus Edit Rename
showmaincategories.php	0.455KB	Hapus Edit Rename
silver_deal_process.php	1.005KB	Hapus Edit Rename
silver_deal_update_process.php	2.641KB	Hapus Edit Rename
silver_images_process.php	1.061KB	Hapus Edit Rename
video-upload-process.php	0.9KB	Hapus Edit Rename