<?php
/**
 * Created by JetBrains PhpStorm.
 * User: Ira
 * Date: 11.08.11
 * Time: 9:34
 */

define('cn_SearchNotExistingImagesSearchNotExistingImages', 'SearchNotExistingImages');
require_once('class/DB/FileDB.php');
require_once ('class/DB/DBObj.php');
class SearchNotExistingImages extends DBObj
{
    var $userfilesDirectory =  'userfile';
    var $id;
    function SearchNotExistingImages($id = NULL)
	{
		$this->tableName = 'Member';
        $this->userfilesDirectory = WWW_PATH . '/' . $this->userfilesDirectory . '/';
        $this->DBObj($id);
	}

    function getNotExistingProfileImages()
    {
        $sql = 'SELECT `id`, `img` FROM ' . $this->tableNameDB . ' where `img` NOT LIKE ""';
        $arrayMemberImages = $this->db->queryAll($sql);
        $notExistingProfileImages = array();
        foreach ($arrayMemberImages as $key => $value ) {
            if (!file_exists($this->userfilesDirectory . $value['img']) ) {
                $notExistingProfileImages[] = $value;
            }
        }
        return $notExistingProfileImages;
    }

    function deleteMemberPhotoRecord($id)
    {
        $this->id = $id;
        return $this->update(array('img' => ''));
    }
}