<?PHP
/******************************************************
    images class

- images class
******************************************************/

class images {
    
    function images(){
        
    }
    
    function recent($count = 21){
        $data = array();
        
        $sql = "SELECT package_image.*, package_title, category_title 
                FROM package_image, package, category 
                WHERE category_p = category_f AND package_p = package_f 
                ORDER BY `_added` DESC 
                LIMIT 0,{$count}";
        $results= mysql_query($sql) or die(mysql_error());
        while($row = mysql_fetch_assoc($results)){
            $data[] = $row;
        }
        
        return $data;
    }
    
    function random($count = 21){
        $data = array();
        
        $sql = "SELECT package_image.*, package_title, category_title 
                FROM package_image, package, category 
                WHERE category_p = category_f AND package_p = package_f 
                ORDER BY RAND() 
                LIMIT 0,{$count}";
        $results= mysql_query($sql) or die(mysql_error());
        while($row = mysql_fetch_assoc($results)){
            $data[] = $row;
        }
        
        return $data;
    }
    
    function user($id, $count = 200){
        $data = array();
        
        $sql = "SELECT package_image.*, package_title, category_title 
                FROM package_image, package, category 
                WHERE category_p = category_f AND package_p = package_f AND login_f = ".intval($id)."
                ORDER BY `_added` DESC 
                LIMIT 0,{$count}";
        $results= mysql_query($sql) or die(mysql_error());
        while($row = mysql_fetch_assoc($results)){
            $data[] = $row;
        }
        
        return $data;
    }
}

?>