<?php
class sys
{
var $Error=array();
var $ErrNo=0;
var $PicErrNo=0;
var $PicError=array();
//*****************************************************
function CountJunkImages()
{
	include ($_SERVER['DOCUMENT_ROOT']."/libs/my_par_lib.php");
	require ($_SERVER['DOCUMENT_ROOT']."/system/tblpref.php");
	if ($handle =@opendir('../admin/listings/pics')) 
	{
		$ImageFile=array();
		$i=0;
   		while (false !== ($file =@readdir($handle))) 
		{ 
			if ($file != "." && $file != ".." && $file != "default.gif" && $file != "default2.gif")
			{
				$ImageFile[$i]=$file;
				$i++;
			}
    	}
    	closedir($handle); 
	}
	else
	{
		include_once($_SERVER['DOCUMENT_ROOT']."/libs/error_handler.php");
		$this->ErrorNo++;
		$ErrorMessage="Cannot read listing image folder";
		$ErrorDescription="Check your permissions";
		$ErrorGeneratedBy="System";
		$aErrHandler=new ErrorHandler($ErrorDescription,$ErrorGeneratedBy);
		$this->Error[$this->ErrorNo]['Message']=$ErrorMessage;
		$this->Error[$this->ErrorNo]['Description']=$ErrorDescription;
		$this->Error[$this->ErrorNo]['GeneratedBy']=$ErrorGeneratedBy;
		user_error($ErrorMessage, E_USER_ERROR);
		return false;
	}
	include_once ($_SERVER['DOCUMENT_ROOT']."/libs/my_par_lib.php");
	require ($_SERVER['DOCUMENT_ROOT']."/system/tblpref.php");
	$aMyCon=new MySqlConnection;
	$aMyCon->Open();
	$Query="SELECT 
			PicPath1,
			PicPath2,
			PicPath3,
			PicPath4,
			PicPath5,
			PicPath6,
			PicPath7,
			PicPath8,
			PicPath9,
			PicPath10
			FROM
			".$TABLE_PREFIX."listing
			";
	if(!$aRes=$aMyCon->Query($Query))
	{
		include_once($_SERVER['DOCUMENT_ROOT']."/libs/error_handler.php");
		$this->ErrorNo++;
		$ErrorMessage=mysql_errno()." : ".mysql_error();
		$ErrorDescription="SQL query failed, cannot fetch picpath list";
		$ErrorGeneratedBy="MySql";
		$aErrHandler=new ErrorHandler($ErrorDescription,$ErrorGeneratedBy);
		$this->Error[$this->ErrorNo]['Message']=$ErrorMessage;
		$this->Error[$this->ErrorNo]['Description']=$ErrorDescription;
		$this->Error[$this->ErrorNo]['GeneratedBy']=$ErrorGeneratedBy;
		user_error($ErrorMessage, E_USER_ERROR);
		return false;
	}
	$ImageDatabaseFile=array();
	$i=0;
	while ($aRow=mysql_fetch_row($aRes))
	{
		foreach ($aRow as $k => $v)
		{
			if ($v != NULL)
			{
				$ImageDatabaseFile[$i]=$v;
				$i++;
			}
		}
	}
	$DiffImage=array_diff($ImageFile,$ImageDatabaseFile);
	foreach ($DiffImage as $k => $v)
	{
		unlink($_SERVER['DOCUMENT_ROOT']."/admin/listings/pics/".$v);
	}
	return true;
}
function FlushCache()
{
	$Dir=$_SERVER['DOCUMENT_ROOT']."/cache/";
	$handle = @opendir($Dir);
	while (false !== ($file = @readdir($handle))) 
	{ 
		if ($file != "." && $file != "..") 
		{
			if(!@unlink($Dir.$file))
			{
				include_once($_SERVER['DOCUMENT_ROOT']."/libs/error_handler.php");
				$this->ErrorNo++;
				$ErrorMessage="Cannot remove ".$file."' file";
				$ErrorDescription="Check your permissions";
				$ErrorGeneratedBy="System";
				$aErrHandler=new ErrorHandler($ErrorDescription,$ErrorGeneratedBy);
				$this->Error[$this->ErrorNo]['Message']=$ErrorMessage;
				$this->Error[$this->ErrorNo]['Description']=$ErrorDescription;
				$this->Error[$this->ErrorNo]['GeneratedBy']=$ErrorGeneratedBy;
				user_error($ErrorMessage, E_USER_ERROR);
				closedir($handle);
				return false;
			}
		}
	}
	closedir($handle);
	return true;
}
function CheckNoOfListings()
{
	include_once ($_SERVER['DOCUMENT_ROOT']."/libs/my_par_lib.php");
	require ($_SERVER['DOCUMENT_ROOT']."/system/tblpref.php");
	$aMyCon=new MySqlConnection;
	$aMyCon->Open();
	$Query="SELECT COUNT(*) FROM ".$TABLE_PREFIX."listing";
	if(!$aRes=$aMyCon->Query($Query))
	{
		include_once($_SERVER['DOCUMENT_ROOT']."/libs/error_handler.php");
		$this->ErrorNo++;
		$ErrorMessage=mysql_errno()." : ".mysql_error();
		$ErrorDescription="Cannot check no of listings";
		$ErrorGeneratedBy="MySql";
		$aErrHandler=new ErrorHandler($ErrorDescription,$ErrorGeneratedBy);
		$this->Error[$this->ErrorNo]['Message']=$ErrorMessage;
		$this->Error[$this->ErrorNo]['Description']=$ErrorDescription;
		$this->Error[$this->ErrorNo]['GeneratedBy']=$ErrorGeneratedBy;
		user_error($ErrorMessage, E_USER_ERROR);
		return false;
	}
	$aRow=mysql_fetch_row($aRes);
	return $aRow[0];
}
}