Consulta sobre PHP y URLs amigables

<?php
if (!defined('BASE_URL')) {
    exit ('No direct script access allowed');
}

/**
 *-----------------------------------------------------------------------------------
 * === CLASS BLOG_MODEL ===
 *-----------------------------------------------------------------------------------
 * Blog Controller
 *
 * @category   E-Blog
 * @package    Application
 * @subpackage Models
 * @filename   blog_model.php
 * @author     Solutii Soft <office@solutiisoft.ro>
 * @copyright  2013 Solutii Soft
 * @license    2013 Solutii Soft
 * @link       http://www.eblog.solutiisoft.com
 * @since      File available since Release 1.0
 */
class Blog_Model extends Database
{
    private $_numbers;

    /**
     * Execute function _showResultsModules
     *
     * @function __construct
     * @access   public
     * @return   void
     */
    public function __construct()
    {
        parent::__construct();
        $this->_showResultsModules();
    }

    /* === POSTS === */

    /**
     * Execute queries to retrieve the settings for the first page
     *
     * @function firstPagePosts
     * @access   public
     * @return   array or false
     */
    public function firstPagePosts()
    {
        if (!$this->emptyTable('settings')) {
            $this->query(
                "SELECT `setting_show_posts`
                    FROM `settings`"
            );
            $limit = $this->oneResult()->setting_show_posts;

            $this->query(
                "SELECT `posts`.*, `categories`.`category_name`, `categories`.`category_url`
                    FROM `posts`
                    JOIN `categories` ON `categories`.`category_id` = `posts`.`category_id`
                    WHERE `posts`.`post_status` = '1'
                    ORDER BY `posts`.`post_id` DESC
                    LIMIT :limit"
            );
            $this->bind(':limit', intval($limit));
            $posts = $this->allResults();

            if ($posts) {
                foreach ($posts as $post) {
                    $return[] = $this->_postContent($post);
                }
                return $return;
            }
            return false;
        }
        return false;
    }

    /**
     * Execute a query which returns all the information about a post by the name given
     *
     * @param string $url post URL
     *
     * @function postByName
     * @access   public
     * @return   array or false if the query returns zero results
     */
    public function postByName($url)
    {
        if ($url) {
            $this->query(
                "SELECT `posts`.*, `categories`.`category_name`, `categories`.`category_url`
                    FROM `posts`
                    JOIN `categories` ON `categories`.`category_id` = `posts`.`category_id`
                    WHERE `posts`.`post_status` = '1' AND `posts`.`post_url` = :url"
            );
            $this->bind(':url', Solutii_Soft::cleanXSS($url));
        } else {
            $this->query(
                "SELECT `posts`.*, `categories`.`category_name`, `categories`.`category_url`
                    FROM `posts`
                    JOIN `categories` ON `categories`.`category_id` = `posts`.`category_id`
                    WHERE `posts`.`post_status` = '1'
                    ORDER BY `posts`.`post_date` DESC
                    LIMIT 1"
            );
        }
        $post = $this->oneResult();

        if (!$post) {
            return false;
        }
        return $this->_postContent((array) $post);
    }

    /**
     * Execute queries to obtain precent post and next post from the given
     *
     * @param string $url post URL
     *
     * @function postByName
     * @access   public
     * @return   array or false
     */
    public function prevNextPost($url)
    {
        if ($url) {
            $this->query(
                "SELECT `post_id`
                    FROM `posts`
                    WHERE `post_url` = :val"
            );
            $this->bind(':val', Solutii_Soft::cleanXSS($url));
        } else {
            $this->query(
                "SELECT `post_id`
                    FROM `posts`
                    ORDER BY `post_id` DESC
                    LIMIT 1"
            );
        }
        $post = $this->oneResult();

        if (!$post) {
            return false;
        }

        $this->query(
            "SELECT `post_id`, `post_url`
                FROM `posts`
                WHERE `post_id` < :ids
                ORDER BY `post_id` DESC
                LIMIT 1"
        );
        $this->bind(':ids', $post->post_id);
        $prev = $this->oneResult()
                ? $this->oneResult()->post_url
                : false;

        $this->query(
            "SELECT `post_id`, `post_url`
                FROM `posts`
                WHERE `post_id` > :ids
                LIMIT 1"
        );
        $this->bind(':ids', $post->post_id);
        $next = $this->oneResult()
                ? $this->oneResult()->post_url
                : false;

        return array(
            'prev'  => $prev,
            'next'  => $next
        );
    }

    /* === END POSTS === */


/* === COMMENTS === */

/**
 * Execute queries which returns all comments and answers of a post
 *
 * @param int $id comment ID
 *
 * @function postCommentsAnswers
 * @access   public
 * @return   array or false if the post does not exists
 */
public function postCommentsAnswers($id)
{
    $this->query(
        "SELECT `comments`.*, `authors`.`author_name`
            FROM `comments`
            JOIN `authors` ON `authors`.`author_id` = `comments`.`author_id`
            WHERE `comments`.`post_id` = :ids AND `comments`.`comment_aproved` = '1'"
    );
    $this->bind(':ids', filter_var($id, FILTER_SANITIZE_NUMBER_INT));
    $comments           = $this->allResults();
    $commentsAndAnswers = array();

    if ($comments) {
        $this->query(
            "SELECT `posts_answers`.*, `answers`.`comment_id`, `answers`.`answer_content`, `answers`.`answer_date`
                FROM `posts_answers`
                JOIN `answers` ON `answers`.`answer_id` = `posts_answers`.`answer_id`
                JOIN `posts` ON `posts`.`post_id` = `posts_answers`.`post_id`
                WHERE `posts_answers`.`post_id` = :ids"
        );
        $this->bind(':ids', filter_var($id, FILTER_SANITIZE_NUMBER_INT));
        $answers = $this->allResults();

        foreach ($comments as $comment) {
            $commentsAndAnswers[$comment['comment_id']] = $comment;

            if ($answers) {
                foreach ($answers as $answer) {
                    if ($comment['comment_id'] == $answer['comment_id']) {
                        $commentsAndAnswers[$comment['comment_id']]['reply'][] = $answer;
                    }
                }
            }
        }
        return $commentsAndAnswers;
    }
    return false;
}

/**
 * Execute a query that inserts a comment in table comments
 *
 * @function addCommentToPost
 * @access   public
 * @return   void
 */
public function addCommentToPost()
{
    $this->beginTransaction();

    $this->query(
        "SELECT `author_id`
            FROM `authors`
            WHERE `authors`.`author_email` = :email"
    );
    $this->bind(':email', trim(Solutii_Soft::cleanXSS($_POST['email'])));
    $author = $this->oneResult();

    if ($author) {
        $authorID = $author->author_id;
    } else {
        // insert in authors table
        $insetAuthor = array(
            'author_id'         => null,
            'author_name'       => trim(Solutii_Soft::cleanXSS($_POST['author'])),
            'author_email'      => trim(Solutii_Soft::cleanXSS($_POST['email'])),
            'author_website'    => trim(Solutii_Soft::cleanXSS($_POST['website']))
        );

        $this->query(
            "INSERT INTO `authors`
                VALUES (:". implode(", :", array_keys($insetAuthor)) . ")"
        );
        foreach ($insetAuthor as $field => $value) {
            $this->bind(':' . $field, $value);
        }
        $this->execute();

        $authorID = $this->lastInsertId();
    }

    // insert in comments table
    $insertComment = array(
        'comment_id'        => null,
        'post_id'           => filter_var($_POST['post_id'], FILTER_SANITIZE_NUMBER_INT),
        'author_id'         => $authorID,
        'comment'           => trim(Solutii_Soft::cleanXSS($_POST['comment'])),
        'comment_aproved'   => 0,
        'comment_date'      => date('Y-m-d H:i:s')
    );

    $this->query(
        "INSERT INTO `comments`
            VALUES (:". implode(", :", array_keys($insertComment)) . ") "
    );
    foreach ($insertComment as $field => $value) {
        $this->bind(':' . $field, $value);
    }
    $this->execute();

    $this->endTransaction();
    
    $this->query(
        "SELECT `user_email`
            FROM `users`
            WHERE `user_id` = '1'"
    );
    
    global $_EBLOG_name;
    $emailAdmin     = $this->oneResult()->user_email;
    $emailSubject   = 'New comment on Blog';
    $emailHeader    = 'MIME-Version: 1.0' . "\r\n";
    $emailHeader    .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    $emailHeader    .= 'From: ' . $_EBLOG_name . "\r\n";
    $emailBody      = 'You have a new comment on Blog';
    
    if (@mail($emailAdmin, $emailSubject, $emailBody, $emailHeader)) {
        return true;
    }
    return false;        
}

/* === END COMMENTS === */


/* === CATEGORY === */

/**
 * Execute a query then in an array send categories and number of posts for each category
 *
 * @function categories
 * @access   public
 * @return   array
 */
public function categories()
{
    $this->query(
        "SELECT *
            FROM `categories`
            ORDER BY `category_name`"
    );
    return $this->allResults();
}

/**
 * Execute querys that returns all posts grouped by given category
 *
 * @param string $category category name
 *
 * @function postByCategorie
 * @access   public
 * @return   array or false
 */
public function postByCategorie($category)
{
    $this->query(
        "SELECT `category_id`
            FROM `categories`
            WHERE `category_url` = :name"
    );
    $this->bind(':name', Solutii_Soft::cleanXSS($category));
    $post = $this->oneResult();

    if ($post) {
        $this->query(
            "SELECT `post_title`, `post_url`
                FROM `posts`
                WHERE `post_status` = '1' AND `category_id` = :id"
        );
        $this->bind(':id', $post->category_id);
        return $this->allResults();
    }
    return false;
}

/* === END CATEGORY === */


/* === ARCHIVES === */

/**
 * Execute a query that returns all posts grouped by date
 *
 * @function archives
 * @access   public
 * @return   array or false
 */
public function archives()
{
    $this->query(
        "SELECT `post_title`, `post_url`, year(`posts`.`post_date`) as xyear, month(`posts`.`post_date`) as xmonth, day(`posts`.`post_date`) as xday
            FROM `posts`
            WHERE `post_status` = '1'
            ORDER BY `post_date` DESC"
    );
    $posts = $this->allResults();

    if (!$posts) {
        return false;
    }

    foreach ($posts as $post) {
        $return[$post['xyear']][$post['xmonth']][$post['xday']][] = array(
            'title' => $post['post_title'], 'url' => $post['post_url']
        ) ;
    }
    return $return;
}

/* === END ARCHIVES === */


/* === TAGS === */

/**
 * Execute a query that return all related post with given tag
 *
 * @param string $tag  tag name
 * @param int    $page number of page
 *
 * @function tags
 * @access   public
 * @return   array
 */
public function tags($tag, $page)
{
    $this->query(
        "SELECT COUNT(*) as total
            FROM `posts`
            JOIN `categories` ON `categories`.`category_id` = `posts`.`category_id`
            WHERE FIND_IN_SET (:string, `posts`.`post_tags`)"
    );
    $this->bind(':string', Solutii_Soft::cleanXSS($tag));
    $total = $this->oneResult()->total;

    $this->query(
        "SELECT `setting_show_tags`
            FROM `settings`"
    );
    $limit  = $this->oneResult()->setting_show_tags;
    $offset = filter_var($page, FILTER_SANITIZE_NUMBER_INT) * $limit;

    $this->query(
        "SELECT *
            FROM `posts`
            JOIN `categories` ON `categories`.`category_id` = `posts`.`category_id`
            WHERE FIND_IN_SET (:string, `posts`.`post_tags`)
            LIMIT :limit OFFSET :offset"
    );
    $this->bind(':string', Solutii_Soft::cleanXSS($tag));
    $this->bind(':limit', intval($limit));
    $this->bind(':offset', $offset);

    $posts = $this->allResults();

    if (!$posts) {
        return false;
    }

    foreach ($posts as $post) {
        $this->query(
            "SELECT `setting_author`
                FROM `settings`"
        );
        $writer = $this->oneResult()->setting_author;

        $this->query(
            "SELECT `". $writer . "`
                FROM `users`
                WHERE `user_id` = :ids"
        );
        $this->bind('ids', $post['user_id']);
        $author = $this->oneResult()->$writer;

        $this->query(
            "SELECT COUNT(*) as num
                FROM `comments`
                JOIN `posts` ON `posts`.`post_id` = `comments`.`post_id`
                WHERE `posts`.`post_id` = :ids"
        );
        $this->bind(':ids', $post['post_id']);
        $comments = $this->oneResult()->num;

        $this->query(
            "SELECT `setting_letters`
                FROM `settings`"
        );
        $letters = $this->oneResult()->setting_letters;

        $return[] = array(
            'post'      => $post,
            'author'    => $author,
            'comments'  => $comments,
            'letters'   => $letters
        );
    }

    return array(
        'total'     => $total,
        'results'   => $return,
        'limit'     => $limit
    );
}

/* === END TAGS === */


/* === MODULES === */

/* === Popular Posts === */

/**
 * Execute a query that returns popular posts
 *
 * @function popularPosts
 * @access   public
 * @return   array
 */
public function popularPosts()
{
    $this->query(
        "SELECT count(*) as popular, `posts`.`post_id`, `posts`.`post_title`, `posts`.`post_url`
            FROM `comments`
            JOIN `posts` ON `posts`.`post_id` = `comments`.`post_id`
            WHERE `posts`.`post_status` = '1' AND `comments`.`comment_aproved` = '1'
            GROUP BY `comments`.`post_id`
            ORDER BY popular desc LIMIT :number"
    );
    $this->bind(':number', intval($this->numbers['popular_posts']));
    return $this->allResults();
}

/* === End Popular Posts === */


/* === Recent Posts === */

/**
 * Execute a query that returns recent posts
 *
 * @function recentPosts
 * @access   public
 * @return   array
 */
public function recentPosts()
{
    $this->query(
        "SELECT `posts`.`post_title`, `posts`.`post_url`
            FROM `posts`
            WHERE `posts`.`post_status` = '1'
            ORDER BY `posts`.`post_date` DESC
            LIMIT :number"
    );
    $this->bind(':number', intval($this->numbers['recent_posts']));
    return $this->allResults();
}

/* === End Recent Posts === */


/* === Recent Comments === */

/**
 * Execute a query that returns recent comments
 *
 * @function recentComments
 * @access   public
 * @return   array
 */
public function recentComments()
{
    $this->query(
        "SELECT `comments`.`comment_id`, `posts`.`post_title`, `posts`.`post_url`, `authors`.`author_name`
            FROM `comments`
            JOIN `posts` ON `posts`.`post_id` = `comments`.`post_id`
            JOIN `authors` ON `authors`.`author_id` = `comments`.`author_id`
            WHERE `comments`.`comment_aproved` = '1'
            ORDER BY `comments`.`comment_date` DESC
            LIMIT :number"
    );
    $this->bind(':number', intval($this->numbers['recent_comments']));
    return $this->allResults();
}

/* === End Recent Comments === */


/* === Blogroll === */

/**
 * Execute a query that returns all details from table blogrolls
 *
 * @function blogrolls
 * @access   public
 * @return   array
 */
public function blogrolls()
{
    $this->query(
        "SELECT *
            FROM `blogrolls`"
    );
    return $this->allResults();
}

/* === End Blogroll === */


/* === Search === */

/**
 * Execute querys that looking in DataBase the given element
 *
 * @param string $string seeking text
 * @param int    $page   number of page
 *
 * @function search
 * @access   public
 * @return   array or false
 */
public function search($string, $page)
{
    $search = Solutii_Soft::cleanXSS($string);

    $this->query(
        "SELECT COUNT(`posts`.`post_id`) as total
            FROM `posts`
            JOIN `categories` ON `categories`.`category_id` = `posts`.`category_id`
            WHERE `posts`.`post_title` LIKE :string OR `posts`.`post_content` LIKE :string"
    );
    $this->bind(':string', trim("%$search%"));
    $total = $this->oneResult()->total;

    if (!$total) {
        return false;
    } else {
        $this->query(
            "SELECT `setting_show_results`
                FROM `settings`"
        );
        $limit  = $this->oneResult()->setting_show_results;
        $offset = filter_var($page, FILTER_SANITIZE_NUMBER_INT) * $limit;

        $this->query(
            "SELECT *
                FROM `posts`
                JOIN `categories` ON `categories`.`category_id` = `posts`.`category_id`
                WHERE `posts`.`post_title` LIKE :string OR `posts`.`post_content` LIKE :string
                LIMIT :limit OFFSET :offset"
        );
        $this->bind(':string', trim("%$search%"));
        $this->bind(':limit', intval($limit));
        $this->bind(':offset', $offset);
        $posts = $this->allResults();

        if (!$posts) {
            return false;
        }

        foreach ($posts as $post) {
            $this->query(
                "SELECT `setting_author`
                    FROM `settings`"
            );
            $writer = $this->oneResult()->setting_author;

            $this->query(
                "SELECT `". $writer . "`
                    FROM `users`
                    WHERE `user_id` = :ids"
            );
            $this->bind('ids', $post['user_id']);
            $author = $this->oneResult()->$writer;

            $this->query(
                "SELECT COUNT(*) as num
                    FROM `comments`
                    JOIN `posts` ON `posts`.`post_id` = `comments`.`post_id`
                    WHERE `posts`.`post_id` = :ids"
            );
            $this->bind(':ids', $post['post_id']);
            $comments = $this->oneResult()->num;

            $this->query(
                "SELECT `setting_letters`
                    FROM `settings`"
            );
            $letters = $this->oneResult()->setting_letters;

            $return[] = array(
                'post'      => $post,
                'author'    => $author,
                'comments'  => $comments,
                'letters'   => $letters
            );
        }

        return array(
            'total' => $total,
            'results' => $return,
            'limit' => $limit
        );
    }
}

/* === End Search === */


/* === Newsletter === */

/**
 * Execute a query that inserts an email in table subscribers
 *
 * @function addSubscriber
 * @access   public
 * @return   void
 */
public function addSubscriber()
{
    $insert = array(
        'subscriber_id'     => null,
        'subscriber_email'  => trim(strtolower(Solutii_Soft::cleanXSS($_POST['email'])))
    );

    $this->query(
        "INSERT INTO `subscribers`
            VALUES (:". implode(", :", array_keys($insert)) . ")"
    );
    foreach ($insert as $field => $value) {
        $this->bind(':' . $field, $value);
    }
    $this->execute();
}

/**
 * Execute a query to check if the subscriber is already in the table subscribers
 *
 * @param string $email user email
 *
 * @function existsSubscriber email address
 * @access   public
 * @return   void
 */
public function existsSubscriber($email)
{
    $this->query(
        "SELECT COUNT(*) as nr
            FROM `subscribers`
            WHERE `subscriber_email` = :email"
    );
    $this->bind(':email', Solutii_Soft::cleanXSS($email));

    if ($this->oneResult()->nr == 1) {
        return true;
    }
    return false;
}

/* === End Newsletter === */


/* === Contact Page === */

/**
 * Execute a query that returns the email address of the administrator, then sends the information from the form to that address
 *
 * @param string $htmlPage path to email template
 *
 * @function sendEmail
 * @access   public
 * @return   array or false
 */
public function sendEmail($htmlPage)
{
    ob_start();
        include_once $htmlPage;
        $emailBody = ob_get_contents();
    ob_end_clean();

    $this->query(
        "SELECT `user_email`
            FROM `users`
            WHERE `user_id` = '1'"
    );
    
    global $_EBLOG_name;
    $emailAdmin     = $this->oneResult()->user_email;
    $emailSubject   = 'Message from my blog';
    $emailHeader    = 'MIME-Version: 1.0' . "\r\n";
    $emailHeader    .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    $emailHeader    .= 'From: ' . $_EBLOG_name . "\r\n";

    if (@mail($emailAdmin, $emailSubject, $emailBody, $emailHeader)) {
        return true;
    }
    return false;
}

/* === End Contact Page === */

/* === MODULES === */


/* === DISPLAY OPTIONS */

/**
 * Execute a query to see the display order for "small"and "big"
 *
 * @function displaySettings
 * @access   public
 * @return   int
 */
public function displaySettings()
{
    if (!$this->emptyTable('settings')) {
        $this->query(
            "SELECT `setting_display`
                FROM `settings`"
        );

        if ($this->oneResult()->setting_display == 1) {
            return 1;
        }
    }
    return 0;
}

/**
 * Execute a query to retrieve the order for modules
 *
 * @function modulesOrder
 * @access   public
 * @return   void
 */
public function modulesOrder()
{
    $this->query(
        "SELECT `module_name`
            FROM `modules`
            WHERE `module_status` = '1'
            ORDER BY module_order"
    );
    return $this->allResults();
}

/**
 * Execute a query to see if the logo is text or image
 *
 * @function displayLogo
 * @access   public
 * @return   array or false
 */
public function displayLogo()
{
    $this->query(
        "SELECT *
            FROM `logos`"
    );
    $logo = $this->oneResult();

    if (!$logo) {
        return false;
    }

    $image = $logo->logo_display == 1
             ? $logo->logo_image
             : false;

    list($width, $height) = getimagesize(PUBLIC_URL . 'upload/' . $image);
    return array(
        'image'     => $image,
        'width'     => $width,
        'height'    => $height,
        'text'      => $logo->logo_text,
        'tag'       => $logo->logo_tag
    );
}
/* === END DISPLAY OPTIONS === */


/* === CAROUSEL === */

/**
 * Execute a query indicating whether or not the carousel will be displayed
 *
 * @function carousel
 * @access   public
 * @return   void
 */
public function carouselSettings()
{
    $this->query(
        "SELECT `setting_carousel`
            FROM `settings`"
    );
    $carousel = $this->oneResult();

    if ($carousel) {
        return $carousel->setting_carousel;
    }
    return false;
}

/**
 * Execute a query then in an array send all images from table carousels
 *
 * @function showCarousel
 * @access   public
 * @return   array
 */
public function showCarousel()
{
    $this->query(
        "SELECT *
            FROM `carousels`"
    );
    $images = $this->allResults();

    if (!$images) {
        return false;
    }

    foreach ($images as $index => $info) {
        list($width, $height)       = getimagesize(PUBLIC_URL . 'upload/thumbs/' . $info['carousel_name']);
        $images[$index]['width']    = $width;
        $images[$index]['height']   = $height;
        $images[$index]['alt']      = Solutii_Soft::altOfImage($info['carousel_name']);
    }
    return $images;
}

/* === END CAROUSEL === */


/* === SOCIALS & ANALITICS === */

/**
 * Execute a query to retrieve the information about social pages
 *
 * @function getSocials
 * @access   public
 * @return   void
 */
public function getSocials()
{
    $this->query(
        "SELECT `social_name`, `social_page`
            FROM `socials`"
    );
    return $this->allResults();
}

/**
 * Execute a query to retrieve the information about facebook like & share, tweets, google +
 *
 * @function getSocialsLike
 * @access   public
 * @return   void
 */
public function getSocialsLike()
{
    $this->query(
        "SELECT `social_name`, `social_like`
            FROM `socials`"
    );
    return $this->allResults();
}


/**
 * Execute a query to retrieve the settings for google analitcis
 *
 * @function getAnalitics
 * @access   public
 * @return   void
 */
public function getAnalitics()
{
    $this->query(
        "SELECT `google_analitics`
            FROM `google`"
    );
    $google = $this->oneResult();

    if ($google) {
        return $google->google_analitics;
    }
    return false;
}

/**
 * Execute a query to retrieve the settings for facebook like box
 *
 * @function getFacebook
 * @access   public
 * @return   void
 */
public function getFacebook()
{
    $this->query(
        "SELECT `facebook_like_box`
            FROM `facebook`"
    );
    $facebook = $this->oneResult();

    if ($facebook) {
        return $facebook->facebook_like_box;
    }
    return false;
}

/* === END SOCIALS & ANALITICS === */


/* === reCAPCHTA === */

/**
 * Get information from configs/recaptcha.php
 *
 * @function getCaptha
 * @access   public
 * @return   array
 */
public function reCaptcha()
{
    $this->query(
        "SELECT `setting_capchta`
            FROM `settings`"
    );
    $captcha = $this->oneResult();

    if (!$captcha) {
        return false;
    } else {
        if ($captcha->setting_capchta == 1) {
            include_once 'public/vendor/recaptcha-php-1.11/recaptchalib.php';
            global $_EBLOG_reCaptcha;

            if (    (trim($_EBLOG_reCaptcha['public']) != '')
                &&  (trim($_EBLOG_reCaptcha['private']) != '')
            ) {
                return array(
                    'publickey'     => $_EBLOG_reCaptcha['public'],
                    'privatekey'    => $_EBLOG_reCaptcha['private']
                );
            }
            return false;
        }
    }
}

/* === END reCAPCHTA === */


/* === OTHER FUNCTIONS === */

/**
 * Execute a query that insert default information in the table modules if table is empty
 *
 * @function checkTableUsers
 * @access   public
 * @return   void
 */
public function checkTableUsers()
{
    if ($this->emptyTable('users')) {
        $this->query(
            "INSERT INTO `users` (`user_id`, `user_email`, `user_password`, `user_name`, `user_nickname`, `user_registred`)
                VALUES
                (null, 'admin@demo.demo', '". Solutii_Soft::hashPassword('demo') . "', 'admin', 'admin', '". date('Y-m-d h:m') . "')"
        );
        $this->execute();
    }
}

/**
 * Execute a query that checks if form data match those in table users
 *
 * @param string $user     user to be verified
 * @param string $password password of user
 *
 * @function matchUserAndPassword
 * @access   public
 * @return   true or false    (true for data match)
 */
public function matchUserAndPassword($user, $password)
{
    $this->query(
        "SELECT COUNT(*) as nr
            FROM `users`
            WHERE `user_email` = :email AND `user_password` = :pass"
    );
    $this->bind(':email', Solutii_Soft::cleanXSS($user));
    $this->bind(':pass', Solutii_Soft::hashPassword(Solutii_Soft::cleanXSS($password)));

    if ($this->oneResult()->nr == 1) {
        return true;
    }
    return false;
}

/**
 * Execute a query which extracts the necessary data for SEO for the current page
 *
 * @param string $url post URL
 *
 * @function seoBlog
 * @access   public
 * @return   array
 */
public function seoBlog($url)
{
    global $_EBLOG_meta;

    $title          = $_EBLOG_meta['title'];
    $description    = $_EBLOG_meta['description'];
    $author         = $_EBLOG_meta['author'];

    if ($url[0]) {
        $this->query(
            "SELECT `posts`.`post_title`, `posts`.`post_content`
                FROM `posts`
                WHERE `posts`.`post_status` = '1' AND `posts`.`post_url` = :url"
        );
        $this->bind(':url', Solutii_Soft::cleanXSS($url[0]));
        $post = $this->oneResult();

        if ($post) {
            $title          = substr(ucfirst(strtolower($post->post_title)), 0, 70);
            $description    = substr(strtolower($post->post_content), 0, 155);
        }

        if (in_array($url[0], $this->listPages())) {
            $title          = substr($_EBLOG_meta[$url[0]]['title'], 0, 70);
            $description    = substr(strtolower($_EBLOG_meta[$url[0]]['description']), 0, 155);
        }

        $method             = '_' . str_replace('-', '', $url[0]);
        $existsMethod       = method_exists('Blog', $method);
        
        if ($existsMethod) {
            if (($url[0] == 'categories')) {
                if (!isset($url[1])) {
                    $title          = substr($_EBLOG_meta['categories']['title'], 0, 70);
                    $categories     = $this->categories();
                    $cat            = array();
                    
                    foreach ( $categories as $category ) {
                        $cat[] = $category['category_name'];
                    }
                    $description    = substr(implode(', ', $cat), 0, 155);
                } else {
                    $title          = substr($_EBLOG_meta['categories']['title'] . ' ' . str_replace('-', ' ', $url[1]), 0, 70);
                    $categories     = $this->postByCategorie($url[1]);
                    $cat            = array();

                    foreach ( $categories as $category ) {
                        $cat[] = $category['post_title'];
                    }
                    $description    = substr(implode(', ', $cat), 0, 155);
                };
            }

            if (($url[0] == 'archives')) {
                if (!isset($url[1])) {
                    $content    = $this->postByName(null);
                    $title      = substr($_EBLOG_meta['archives']['title'], 0, 70);
                } else {
                    $content    = $this->postByName($url[1]);
                    $title      = substr($_EBLOG_meta['archives']['title'] . ' ' . $content['post_title'], 0, 70);
                }
                
                $description    = $content['post_title'] . ' ' . substr($content['content']['post_content'], 0, 155);
            }

            if (($url[0] == 'search')) {
                $title          = substr(str_replace("#string#", Solutii_Soft::cleanXSS($_POST['search']), $_EBLOG_meta['search']['title']), 0, 70);
                $result         = $this->search($_POST['search'], 0);
                $description    = $result['results'][0]['post']['post_title'] . ' ' . substr($result['results'][0]['post']['post_content'], 0, 155);
            }

            if (($url[0] == 'tag')) {
                $title          = substr(str_replace("#tag#", Solutii_Soft::cleanXSS($url[1]), $_EBLOG_meta['tag']['title']), 0, 70);
                $result         = $this->tags(str_replace("-", " ", $url[1]), 0);
                $description    = $result['results'][0]['post']['post_title'] . ' ' . substr($result['results'][0]['post']['post_content'], 0, 155);
            }
        }
    }
    
    return array(
        'title'         => $title,
        'description'   => strip_tags($description),
        'author'        => $author
    );
}

/**
 * Lists all .php files in a given directory
 *
 * @function listPages
 * @access   public
 * @return   array
 */
public function listPages()
{
    $dir = BLOG . 'pages';

    if ($handle = opendir($dir)) {
        while (false !== ($entry = readdir($handle))) {
            if (is_file($dir . DIRECTORY_SEPARATOR . $entry)) {
                $file = pathinfo($dir . DIRECTORY_SEPARATOR . $entry);

                if ($file['extension'] == 'php') {
                    $pages[] = $file['filename'];
                }
            }
        }
        closedir($handle);
    }
    return $pages;
}

/* === OTHER FUNCTIONS === */


/* === PRIVATE FUNCTIONS === */

/**
 * Execute multiple queries that return the entire content of a post (photos, video, their position, etc.)
 *
 * @param array $post information from required post
 *
 * @function _postContent
 * @access   private
 * @return   array
 */
private function _postContent($post)
{
    $this->query(
        "SELECT `setting_author`
            FROM `settings`"
    );
    $writer = $this->oneResult()->setting_author;

    $this->query(
        "SELECT `". $writer . "`
            FROM `users`
            WHERE `user_id` = :ids"
    );
    $this->bind('ids', $post['user_id']);
    $author = $this->oneResult()->$writer;

    $this->query(
        "SELECT COUNT(*) as num
            FROM `comments`
            JOIN `posts` ON `posts`.`post_id` = `comments`.`post_id`
            WHERE `comments`.`comment_aproved` = '1' AND `posts`.`post_id` = :ids"
    );
    $this->bind(':ids', $post['post_id']);
    $comments = $this->oneResult()->num;

    $this->query(
        "SELECT *
            FROM `images`
            WHERE `post_id` = :id"
    );
    $this->bind(':id', $post['post_id']);
    $images = $this->allResults();

    $this->query(
        "SELECT *
            FROM `videos`
            WHERE `post_id` = :id"
    );
    $this->bind(':id', $post['post_id']);
    $video = $this->allResults();

    $this->query(
        "SELECT `setting_letters`
            FROM `settings`"
    );
    $letters = $this->oneResult()->setting_letters;

    $span = 'span3';

    if ($images) {
        foreach ($images as $image) {
            foreach ($images as $index => $info) {
                list($width, $height)       = getimagesize(PUBLIC_URL . 'upload/thumbs/' . $info['image_name']);
                $images[$index]['width']    = $width;
                $images[$index]['height']   = $height;
                $images[$index]['alt']      = Solutii_Soft::altOfImage($info['image_name']);
            }
        }

        $dim = sizeof($images);
        if ($dim == 1) {
            $span = 'span12';
        }

        if ($dim == 2) {
            $span = 'span6';
        }

        if ($dim == 3) {
            $span = 'span4';
        }
    }

    $details = array(
        'post_id'               => $post['post_id'],
        'post_title'            => html_entity_decode($post['post_title'], ENT_QUOTES, "UTF-8"),
        'post_url'              => $post['post_url'],
        'post_tags'             => explode(',', $post['post_tags']),
        'post_permision'        => $post['post_permision'],
        'post_last_modified'    => $post['post_last_modified'],
        'post_images_position'  => $post['post_images_position'],
        'post_videos_position'  => $post['post_videos_position'],
        'category_name'         => $post['category_name'],
        'category_url'          => $post['category_url'],
        'author'                => $author,
        'comments'              => $comments,
        'letters'               => $letters,
        'span'                  => $span
    );

    $postContent = html_entity_decode($post['post_content'], ENT_QUOTES, "UTF-8");

    $content['content'] = array(
        'post_content'  => $postContent,
        'videos'        => $video,
        'images'        => $images
    );

    if (    (($post['post_videos_position'] == 0) || ($post['post_videos_position'] == 1))
        &&  (($post['post_images_position'] == 1) || ($post['post_images_position'] == 3))
    ) {
        $content['content'] = array(
            'videos'        => $video,
            'images'        => $images,
            'post_content'  => $postContent
        );
    }

    if (    (($post['post_videos_position'] == 0) || ($post['post_videos_position'] == 1))
        &&  (($post['post_images_position'] == 2) || ($post['post_images_position'] == 4))
    ) {
        $content['content'] = array(
            'videos'        => $video,
            'post_content'  => $postContent,
            'images'        => $images
        );
    }

    if (    ($post['post_videos_position'] == 1)
        &&  ($post['post_images_position'] == 0)
    ) {
        $content['content'] = array(
            'videos'        => $video,
            'post_content'  => $postContent,
            'images'        => $images
        );
    }

    if (    ($post['post_videos_position'] == 2)
        &&  (($post['post_images_position'] == 1) || ($post['post_images_position'] == 3))
    ) {
        $content['content'] = array(
            'images'        => $images,
            'post_content'  => $postContent,
            'videos'        => $video
        );
    }

    if (    ($post['post_videos_position'] == 2)
        &&  ($post['post_images_position'] == 0)
    ) {
        $content['content'] = array(
            'images'        => $images,
            'post_content'  => $postContent,
            'videos'        => $video
        );
    }

    if (    (($post['post_videos_position'] == 0) || ($post['post_videos_position'] == 1))
        &&  ($post['post_images_position'] == 5)
    ) {
        $content['content'] = array(
            'videos'        => $video,
            'images'        => $images,
            'post_content'  => $postContent
        );
    }

    if (    (($post['post_videos_position'] == 0) || ($post['post_videos_position'] == 2))
        &&  ($post['post_images_position'] == 5)
    ) {
        $content['content'] = array(
            'images'        => $images,
            'post_content'  => $postContent,
            'videos'        => $video
        );
    }

    if (    (($post['post_videos_position'] == 0) || ($post['post_videos_position'] == 1))
        &&  ($post['post_images_position'] == 6)
    ) {
        $content['content'] = array(
            'videos'        => $video,
            'images'        => $images,
            'post_content'  => $postContent
        );
    }

    if (    (($post['post_videos_position'] == 0) || ($post['post_videos_position'] == 2))
        &&  ($post['post_images_position'] == 6)
    ) {
        $content['content'] = array(
            'images'        => $images,
            'post_content'  => $postContent,
            'videos'        => $video
        );
    }

    if ($post['post_videos_position'] == 0) {
        unset($content['content']['videos']);
    }

    if ($post['post_images_position'] == 0) {
        unset($content['content']['images']);
    }

    return array_merge($details, $content);
}

/**
 * Return number of recent posts, recent comments, popular post
 *
 * @function _showResultsModules
 * @access   private
 * @return   array
 */
private function _showResultsModules()
{
    $this->query(
        "SELECT
            (SELECT `module_nr`
                FROM `modules`
                WHERE `module_name` = 'recent_posts') as recent_posts,
            (SELECT `module_nr`
                FROM `modules`
                WHERE `module_name` = 'recent_comments') as recent_comments,
            (SELECT `module_nr`
                FROM `modules`
                WHERE `module_name` = 'popular_posts') as popular_posts"
    );
    $modules = $this->oneResult();

    $this->numbers['recent_posts']      = $modules->recent_posts;
    $this->numbers['recent_comments']   = $modules->recent_comments;
    $this->numbers['popular_posts']     = $modules->popular_posts;
}

/* === END PRIVATE FUNCTIONS === */

}

/* end of file blog_model.php */