Follow along with the video below to see how to install our site as a web app on your home screen.
Примечание: This feature may not be available in some browsers.
<?php
// +------------------------------------------------------------------------+
// | PHP Melody ( www.phpsugar.com )
// +------------------------------------------------------------------------+
// | PHP Melody IS NOT FREE SOFTWARE
// | If you have downloaded this software from a website other
// | than www.phpsugar.com or if you have received
// | this software from someone who is not a representative of
// | PHPSUGAR, you are involved in an illegal activity.
// | ---
// | In such case, please contact: support@phpsugar.com.
// +------------------------------------------------------------------------+
// | Developed by: PHPSUGAR (www.phpsugar.com) / support@phpsugar.com
// | Copyright: (c) 2004-2013 PHPSUGAR. All rights reserved.
// +------------------------------------------------------------------------+
session_start();
require('config.php');
require_once('include/functions.php');
require_once('include/user_functions.php');
require_once('include/islogged.php');
require_once('include/rating_functions.php');
$modframework->trigger_hook('category_top');
   
    $resync = 0;
        $i = 0;
    $category = array();
    $total_items = 0;
    $videos = $cats = array();
        $children = array();
        $parentid = $parent_ids = array();
    $categories = load_categories(array('db_table' => 'pm_categories'));
    foreach ($categories as $c)
    {
        if ($c['parent_id'] == 0)
        {
            $parents[] = $c;
            $parent_ids[] = $c['id'];
        }
        else
        {
            $children[$c['parent_id']][] = $c;
        }
               
                //$test = $parent_ids[$c['id']] ;
    }       
 
    foreach ($parents as $c_id => $c)
    {
            $cats[$i] = $c;   
           
                //if ($c['parent_id'] == 0)
        //{                 
                    //$smarty->assign('gv_category_name', $c['name']);
                   
                    //$parentid[$c_id] = $c['parent_id'];
                    $cats[$i]['gv_category_name'] = $c['name'];
                    $cats[$i]['gv_category_name_id'] = $children;
       
                   
               
        //'.implode(",", $Query).'
    $sql = 'SELECT * FROM pm_videos WHERE category IN(1,2,4,5,6,7,8,9,10,11) ORDER BY added DESC ';//WHERE category IN(1,2,4,5,6,7,8,9,10,11)
   
    $result = mysql_query($sql);
    while ($row = mysql_fetch_assoc($result))
    {
        $videos[$i] = $row;
           
        $sql_date = date('Y-m-d', $row['added']);
        $date_diff = round( abs(strtotime(date('Y-m-d'))-strtotime($sql_date)) / 86400, 0 );
       
        $videos[$i]['attr_alt'] = htmlspecialchars(stripslashes($row['video_title']));
        $videos[$i]['excerpt'] = generate_excerpt($row['description'], 255);
        if ($date_diff < _ISNEW_DAYS)
        {
            $videos[$i]['mark_new'] = true;
        }
       
        if ($row['site_views'] > _ISPOPULAR)
        {
            $videos[$i]['mark_popular'] = true;
        }
        if (function_exists('bin_rating_get_item_meta'))
        {
            $rating_meta = bin_rating_get_item_meta($row['uniq_id']);
            $balance = bin_rating_calc_balance($rating_meta['up_vote_count'], $rating_meta['down_vote_count']);
            $videos[$i]['up_vote_count'] = (int) $rating_meta['up_vote_count'];
            $videos[$i]['likes'] = $videos[$i]['up_vote_count'];
            $videos[$i]['down_vote_count'] = (int) $rating_meta['down_vote_count'];
            $videos[$i]['dislikes'] = $videos[$i]['down_vote_count'];
           
            $videos[$i]['up_vote_count_formatted'] = pm_number_format($videos[$i]['up_vote_count']);
            $videos[$i]['down_vote_count_formatted'] = pm_number_format($videos[$i]['down_vote_count']);
            $videos[$i]['up_vote_count_compact'] = pm_compact_number_format($videos[$i]['up_vote_count']);
            $videos[$i]['down_vote_count_compact'] = pm_compact_number_format($videos[$i]['down_vote_count']);
           
            $videos[$i]['likes_formatted'] = $videos[$i]['up_vote_count_formatted'];
            $videos[$i]['dislikes_formatted'] = $videos[$i]['down_vote_count_formatted'];
            $videos[$i]['likes_compact'] = $videos[$i]['up_vote_count_compact'];
            $videos[$i]['dislikes_compact'] = $videos[$i]['down_vote_count_compact'];
           
            $videos[$i] = array_merge($videos[$i], $balance);
        }
       
        $author_data = fetch_user_info($row['submitted']);
        $videos[$i]['duration'] = sec2hms($row['yt_length']);
        $videos[$i]['video_href'] = makevideolink($row['uniq_id'], $row['video_title'], $row['category']);
        $videos[$i]['thumb_img_url'] = show_thumb($row['uniq_id'], 1, $row);
        $videos[$i]['author_username'] = $row['submitted'];
                $videos[$i]['CAT_NAME'] = $category['title'][$row['category']];
        $videos[$i]['author_user_id'] = $author_data['id'];
        $videos[$i]['author_power'] = $author_data['power'];
        $videos[$i]['author_name'] = $author_data['name'];
        $videos[$i]['author_avatar_url'] = $author_data['avatar_url'];
        $videos[$i]['author_profile_href'] = ($row['submitted'] != 'bot') ? _URL .'/profile.'. _FEXT .'?u='. $row['submitted'] : '#';
       
        $videos[$i]['html5_datetime'] = date('Y-m-d\TH:i:sO', $row['added']); // ISO 8601
        $videos[$i]['full_datetime'] = date('l, F j, Y g:i A', $row['added']);
        $videos[$i]['time_since_added'] = time_since($row['added']);
        $videos[$i]['views_compact'] = pm_compact_number_format($row['site_views']);
        //$videos[$i]['comments'] = 0; // EDITME @todo
        //$videos[$i]['comments_compact'] = pm_compact_number_format(0); // EDITME @todo
        $i++;
    }
        mysql_free_result($result); }
    //}           
       
//$smarty->assign('cat_id', $cats);
$smarty->assign('problem', $problem);
//$smarty->assign('gv_category_name', $category_name);
//$smarty->assign('gv_cat', $cat_name);
$smarty->assign('gv_pagenumber', $page);
$smarty->assign('gv_sortby', $sortby);
//$smarty->assign('gv_category_description', $category['description']);
$smarty->assign('page_count_info', $page_count_info);
$smarty->assign('pag_left', $pag_left);
$smarty->assign('pag_right', $pag_right);
$smarty->assign('resultscats', $cats);
$smarty->assign('results', $videos);
// --- DEFAULT SYSTEM FILES - DO NOT REMOVE --- //
$smarty->assign('template_dir', $template_f);
$smarty->display('video-category-all.tpl');
?>
	session_start();
require('config.php');
require_once('include/functions.php');
require_once('include/user_functions.php');
require_once('include/islogged.php');
require_once('include/rating_functions.php');
$modframework->trigger_hook('category_top');
  
   $resync = 0;
  $i = 0;
   $category = array();
   $total_items = 0;
   $videos = $cats = array();
  $parents = $parent_ids = $children = array();
   $categories = load_categories(array('db_table' => 'pm_categories'));
   foreach ($categories as $c_id => $c)
   {
     if ($c['parent_id'] == 0)
     {
       $parents[] = $c;
       $parent_ids[] = $c['id'];
     }
     else
     {
       $children[$c['parent_id']][] = $c;
     }
   }
  
  
  
   foreach ($parents as $k => $p)
   {
  $cats[$i] = $p;
  
  $cats[$i]['gv_category_name'] = $p['name'];
  
  
  foreach ($children[$p['id']] as $c_id => $child)
  {
  $pod_cats = implode(",", $child['id']);//implode(",", $c_id);//implode(",", $children[$c['id']]);
  }  
  $sql = 'SELECT * FROM pm_videos WHERE category IN('.$pod_cats.') ORDER BY added DESC ';//WHERE category IN(1,2,4,5,6,7,8,9,10,11)
  $result = mysql_query($sql);
  while ($row = mysql_fetch_assoc($result))
  {
  $videos[$i] = $row;
  $sql_date = date('Y-m-d', $row['added']);
  $date_diff = round( abs(strtotime(date('Y-m-d'))-strtotime($sql_date)) / 86400, 0 );
  $videos[$i]['attr_alt'] = htmlspecialchars(stripslashes($row['video_title']));
  $videos[$i]['excerpt'] = generate_excerpt($row['description'], 255);
  if ($date_diff < _ISNEW_DAYS)
  {
  $videos[$i]['mark_new'] = true;
  }
  if ($row['site_views'] > _ISPOPULAR)
  {
  $videos[$i]['mark_popular'] = true;
  }
  if (function_exists('bin_rating_get_item_meta'))
  {
  $rating_meta = bin_rating_get_item_meta($row['uniq_id']);
  $balance = bin_rating_calc_balance($rating_meta['up_vote_count'], $rating_meta['down_vote_count']);
  $videos[$i]['up_vote_count'] = (int) $rating_meta['up_vote_count'];
  $videos[$i]['likes'] = $videos[$i]['up_vote_count'];
  $videos[$i]['down_vote_count'] = (int) $rating_meta['down_vote_count'];
  $videos[$i]['dislikes'] = $videos[$i]['down_vote_count'];
  $videos[$i]['up_vote_count_formatted'] = pm_number_format($videos[$i]['up_vote_count']);
  $videos[$i]['down_vote_count_formatted'] = pm_number_format($videos[$i]['down_vote_count']);
  $videos[$i]['up_vote_count_compact'] = pm_compact_number_format($videos[$i]['up_vote_count']);
  $videos[$i]['down_vote_count_compact'] = pm_compact_number_format($videos[$i]['down_vote_count']);
  $videos[$i]['likes_formatted'] = $videos[$i]['up_vote_count_formatted'];
  $videos[$i]['dislikes_formatted'] = $videos[$i]['down_vote_count_formatted'];
  $videos[$i]['likes_compact'] = $videos[$i]['up_vote_count_compact'];
  $videos[$i]['dislikes_compact'] = $videos[$i]['down_vote_count_compact'];
  $videos[$i] = array_merge($videos[$i], $balance);
  }
  $author_data = fetch_user_info($row['submitted']);
  $videos[$i]['duration'] = sec2hms($row['yt_length']);
  $videos[$i]['video_href'] = makevideolink($row['uniq_id'], $row['video_title'], $row['category']);
  $videos[$i]['thumb_img_url'] = show_thumb($row['uniq_id'], 1, $row);
  $videos[$i]['author_username'] = $row['submitted'];
  $videos[$i]['author_user_id'] = $author_data['id'];
  $videos[$i]['author_power'] = $author_data['power'];
  $videos[$i]['author_name'] = $author_data['name'];
  $videos[$i]['author_avatar_url'] = $author_data['avatar_url'];
  $videos[$i]['author_profile_href'] = ($row['submitted'] != 'bot') ? _URL .'/profile.'. _FEXT .'?u='. $row['submitted'] : '#';
  $videos[$i]['html5_datetime'] = date('Y-m-d\TH:i:sO', $row['added']); // ISO 8601
  $videos[$i]['full_datetime'] = date('l, F j, Y g:i A', $row['added']);
  $videos[$i]['time_since_added'] = time_since($row['added']);
  $videos[$i]['views_compact'] = pm_compact_number_format($row['site_views']);
  //$videos[$i]['comments'] = 0; // EDITME @todo
  //$videos[$i]['comments_compact'] = pm_compact_number_format(0); // EDITME @todo
  $i++;
  }
  mysql_free_result($result);
  
  }  
//$smarty->assign('cat_id', $cats);
$smarty->assign('problem', $problem);
//$smarty->assign('gv_category_name', $category_name);
//$smarty->assign('gv_cat', $cat_name);
$smarty->assign('gv_pagenumber', $page);
$smarty->assign('gv_sortby', $sortby);
//$smarty->assign('gv_category_description', $category['description']);
$smarty->assign('page_count_info', $page_count_info);
$smarty->assign('pag_left', $pag_left);
$smarty->assign('pag_right', $pag_right);
$smarty->assign('resultscats', $cats);
$smarty->assign('results', $videos);
// --- DEFAULT SYSTEM FILES - DO NOT REMOVE --- //
$smarty->assign('template_dir', $template_f);
$smarty->display('video-category-all.tpl');