Просмотр архива Акул сайт


<?php
defined('_VALID') or die('Restricted Access!');
class VComponent_Admin_main_dashboard
{
    public function __construct()
    {
    }
    
    public function render()
    {
        $db         = VF::factory('database');
        $tpl         = VF::factory('template');
        $warnings    = array();
        
        $tpl->videos            = $db->get_field("SELECT COUNT(*) AS total_videos FROM #__video", 'total_videos');
        $tpl->online_videos        = $db->get_field("SELECT COUNT(*) AS total_videos
                                                  FROM #__video
                                                  WHERE status = 1", 'total_videos');
        $tpl->suspended_videos    = $db->get_field("SELECT COUNT(*) AS total_videos
                                                  FROM #__video
                                                  WHERE status = 0", 'total_videos');
        $tpl->approve_videos    = $db->get_field("SELECT COUNT(*) AS total_videos
                                                  FROM #__video
                                                  WHERE status = 2", 'total_videos');
        $tpl->queued_videos        = $db->get_field("SELECT COUNT(*) AS total_videos
                                                  FROM #__video
                                                  WHERE status = 6", 'total_videos');
        $tpl->flagged_videos    = $db->get_field("SELECT COUNT(*) AS total_videos
                                                  FROM #__video
                                                  WHERE flagged = '1'", 'total_videos');
        
        $tpl->adv_clicks        = $db->get_field("SELECT COUNT(*) AS total_clicks
                                                  FROM #__adv_clicks", 'total_clicks');
        $tpl->adv_clicks_t        = $db->get_field("SELECT COUNT(*) AS total_clicks
                                                  FROM #__adv_clicks
                                                  WHERE DATE_FORMAT(click_date, '%y-%m-%d') = DATE_FORMAT(NOW(), '%y-%m-%d')",
                                                  'total_clicks');
        $tpl->adv_clicks_m        = $db->get_field("SELECT COUNT(*) AS total_clicks
                                                  FROM #__adv_clicks
                                                  WHERE DATE_FORMAT(click_date, '%y-%m') = DATE_FORMAT(NOW(), '%y-%m')",
                                                  'total_clicks');
        
        $tpl->users                = $db->get_field("SELECT COUNT(*) AS total_users
                                                  FROM #__user", 'total_users');
        $tpl->users_t            = $db->get_field("SELECT COUNT(*) AS total_users
                                                  FROM #__user
                                                  WHERE DATE_FORMAT(join_date, '%y-%m-%d') = DATE_FORMAT(NOW(), '%y-%m-%d')",
                                                  'total_users');
        $tpl->users_m            = $db->get_field("SELECT COUNT(*) AS total_users
                                                  FROM #__user
                                                  WHERE DATE_FORMAT(join_date, '%y-%m') = DATE_FORMAT(NOW(), '%y-%m')",
                                                  'total_users');        
        
        $tpl->comments            = $db->get_field("SELECT COUNT(*) AS total_comments
                                                  FROM #__video_comments", 'total_comments');
        
        $start_time                = strtotime('today');
        $end_time                = $start_time+86400;                                                  
        $tpl->comments_t        = $db->get_field("SELECT COUNT(*) AS total_comments
                                                  FROM #__video_comments
                                                  WHERE add_time > ".$start_time." AND add_time < ".$end_time,
                                                  'total_comments');
        
        $start_time                = mktime(0, 0, 0, date("n"), 1);
        $tpl->comments_m        = $db->get_field("SELECT COUNT(*) AS total_comments
                                                  FROM #__video_comments
                                                  WHERE add_time > ".$start_time,
                                                  'total_comments');
        $tpl->comments_s        = $db->get_field("SELECT COUNT(*) AS total_comments
                                                  FROM #__spam", 'total_comments');
        
        $date                    = date('Y-m-d');                                          
        $tpl->adv_expire        = $db->get_field("SELECT COUNT(*) AS total_expire
                                                  FROM #__adv
                                                  WHERE expire > ".$date,
                                                  'total_expire');
        $tpl->adv_expire_p        = $db->get_field("SELECT COUNT(*) AS total_expire
                                                  FROM #__adv_player
                                                  WHERE expire > ".$date,
                                                  'total_expire');
        
        $return = $this->check_for_updates();
        if (is_string($return)) {
            $warnings[] = 'Adult Script Pro '.$return.' has been released! Please email support@adultscriptpro.com to get the latest version!';
        }

        if ($tpl->flagged_videos > 0) {
            $warnings[] = 'You have '.$tpl->flagged_videos.' flagged video(s)!';
        }
        
        $tpl->menu               = 'main';
        $tpl->submenu         = 'main_dashboard';
        $tpl->meta_title    = 'Admin::Dashboard';
        $tpl->warnings        = $warnings;
        $tpl->load(array('header', 'main_dashboard', 'footer'));
        $tpl->display();
    }

    private function check_for_updates()
    {
        $h  = md5(VF::cfg_item('license_key').VF::cfg_item('license_domain').VF::cfg_item('secret'));
        $u  = 'http://www.adultscriptpro.com/version.php?h='.$h;
        if ($retval = @file_get_contents($u)) {
        } else {
            $retval = VCurl::string($u);
        }

        if ($retval == 'RESEND') {
            if ($this->register_installation()) {
                return $this->check_for_updates();
            }
        } elseif (preg_match('/^(d+\.)?(d+\.)?(\*|d+)$/', $retval)) {
            $v          = require BASE_DIR.'/config/version.php';
            $version    = $v['major'].'.'.$v['minor'].'.'.$v['patch'];

            if (version_compare($version, $retval) >= 0) {
                return true;
            } else {
                return $retval;
            }
        }

        return false;
    }

    private function register_installation()
    {
        $r  = array(
            'k' => VF::cfg_item('license_key'),
            'd' => VF::cfg_item('license_domain'),
            's' => VF::cfg_item('secret')
        );

        $u  = 'http://www.adultscriptpro.com/register.php?'.http_build_query($r);
        if ($retval = @file_get_contents($u)) {
        } else {
            $retval = VCurl::string($u);
        }
        
        if ($retval == 'OK') {
            return true;
        }
        
        return false;
    }
}
?>