function widget($args, $instance)
{
global $post, $wpdb;
$post_in_block = $instance['post_in_block_latest_apps'];
if (is_single()) {
$info_cat_post = info_category_post($post->ID);
$lasted_posts = new WP_Query(array('post_type' => 'apps', 'posts_per_page' => $post_in_block, 'order' => 'DSC', 'cat' => $info_cat_post['term_id']));
?>
<div class="sidebar-widget">
<h3 class="widget-head">latest <?php
echo $info_cat_post['parent_cat_name'];
?>
</h3>
<ul class = "sb-tabs-wrap" >
<?php
while ($lasted_posts->have_posts()) {
$lasted_posts->the_post();
?>
<li>
<div class="sb-post-thumbnail">
<a href="<?php
the_permalink();
?>
" title="<?php
the_title();
?>
">
<?php
the_post_thumbnail(array(80, 80), array('alt' => get_the_title()));
?>
</a>
</div>
<div class="sb-post-list-title">
<h4><a href="<?php
the_permalink();
?>
" title="<?php
the_title();
?>
"><?php
the_title();
?>
</a></h4>
<div class="sb-post-meta">
<p><?php
the_modified_time('F jS, Y');
?>
</p>
</div>
<div class="sb-post-meta">
<a href="<?php
the_permalink();
?>
" title="<?php
the_title();
?>
">Download APK</a>
</div>
</div>
</li>
<?php
}
wp_reset_query();
?>
</ul>
</div>
<?php
}
?>
<?php
}
function widget($args, $instance)
{
global $post, $wpdb;
$post_in_block = $instance['post_in_block_hot_apps'];
if (is_category()) {
$cat_ID = get_query_var('cat');
$title = get_query_var('category_name');
$q_obj = get_queried_object();
$query = "SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE parent={$cat_ID}";
$res = $wpdb->get_results($query, 'ARRAY_N');
if ($res) {
for ($i = 0; $i < count($res); $i++) {
$list_ids[] = $res[$i][0];
}
$list_ids = implode(',', $list_ids);
}
if ($list_ids) {
$query = "SELECT p.ID, p.post_title, p.guid FROM wp_posts p \n\t\t\t\t\t\t\t INNER JOIN wp_data_post_views dpw ON \n\t\t\t\t\t\t\t \tp.ID=dpw.post_id \n\t\t\t\t\t\t\t INNER JOIN wp_term_relationships tr ON \n\t\t\t\t\t\t\t \tp.ID=tr.object_id \n\t\t\t\t\t\t\t WHERE tr.term_taxonomy_id IN (" . $list_ids . ") ORDER BY dpw.views DESC LIMIT " . $post_in_block;
} else {
$query = "SELECT p.ID, p.post_title, p.guid FROM wp_posts p \n\t\t\t\t\t\t\tINNER JOIN wp_data_post_views dpw ON \n\t\t\t\t\t\t\t \tp.ID=dpw.post_id\n\t\t\t\t\t\t\tINNER JOIN wp_term_relationships tr ON\n\t\t\t\t\t\t\t\t\tp.ID=tr.object_id\n\t\t\t\t\t\t\tWHERE tr.term_taxonomy_id=" . $q_obj->term_taxonomy_id . " ORDER BY dpw.views DESC LIMIT " . $post_in_block;
}
}
if (is_page()) {
$cat = get_the_category();
$title = $cat[0]->cat_name;
if ($cat) {
$query = "SELECT p.ID, p.post_title, p.guid FROM wp_posts p \n\t\t\t\t\t\t\tINNER JOIN wp_data_post_views dpw ON \n\t\t\t\t\t\t\t \tp.ID=dpw.post_id\n\t\t\t\t\t\t\tINNER JOIN wp_term_relationships tr ON\n\t\t\t\t\t\t\t\t\tp.ID=tr.object_id\n\t\t\t\t\t\t\tWHERE tr.term_taxonomy_id=" . $cat[0]->term_taxonomy_id . " ORDER BY dpw.views DESC LIMIT " . $post_in_block;
} else {
$title = 'Apps & Games';
$cat = get_categories('parent=0');
if ($cat) {
foreach ($cat as $term_id) {
$list_ids[] = $term_id->term_taxonomy_id;
}
}
$list_ids = implode(',', $list_ids);
$query = "SELECT p.ID, p.post_title, p.guid FROM wp_posts p \n\t\t\t\t\t\t\t INNER JOIN wp_data_post_views dpw ON \n\t\t\t\t\t\t\t \tp.ID=dpw.post_id \n\t\t\t\t\t\t\t INNER JOIN wp_term_relationships tr ON \n\t\t\t\t\t\t\t \tp.ID=tr.object_id \n\t\t\t\t\t\t\t WHERE tr.term_taxonomy_id IN (" . $list_ids . ") ORDER BY dpw.views DESC LIMIT " . $post_in_block;
}
}
if (is_front_page()) {
$title = 'Apps & Games';
$query = "SELECT term_id FROM wp_term_taxonomy WHERE parent != 0";
$res = $wpdb->get_results($query, 'ARRAY_N');
if ($res) {
for ($i = 0; $i < count($res); $i++) {
$list_ids[] = $res[$i][0];
}
$list_ids = implode(',', $list_ids);
}
$query = "SELECT p.ID, p.post_title, p.guid FROM wp_posts p \n\t\t\t\t\t\t\t INNER JOIN wp_data_post_views dpw ON \n\t\t\t\t\t\t\t \tp.ID=dpw.post_id \n\t\t\t\t\t\t\t INNER JOIN wp_term_relationships tr ON \n\t\t\t\t\t\t\t \tp.ID=tr.object_id \n\t\t\t\t\t\t\t WHERE tr.term_taxonomy_id IN (" . $list_ids . ") GROUP BY p.ID ORDER BY dpw.views DESC LIMIT " . $post_in_block;
}
if (is_single()) {
$info_cat_post = info_category_post($post->ID);
$query = "SELECT p.ID, p.post_title, p.guid FROM wp_posts p \n\t\t\t\t\t\tINNER JOIN wp_data_post_views dpw ON \n\t\t\t\t\t\t\tp.ID=dpw.post_id\n\t\t\t\t\t\tINNER JOIN wp_term_relationships tr ON\n\t\t\t\t\t\t\tp.ID=tr.object_id\n\t\t\t\t\t\tWHERE tr.term_taxonomy_id=" . $info_cat_post['current_tax_id'] . " ORDER BY dpw.views DESC LIMIT " . $post_in_block;
$title = 'Hot ' . $info_cat_post['cat_name'] . ' ' . $info_cat_post['parent_cat_name'];
}
$res = $wpdb->get_results($query);
?>
<div class="sidebar-widget">
<h3 class="widget-head"> <?php
echo 'Hot ' . $title;
?>
</h3>
<div class=" popular-rec">
<ul class = "top-list" >
<?php
foreach ($res as $post) {
setup_postdata($post);
?>
<li class="wpp-list">
<a href="<?php
the_permalink();
?>
"> <?php
the_title();
?>
</a>
</li>
<?php
}
?>
</ul>
</div>
</div>
<div class=" clearfix" > </div>
<?php
}
<?php
get_header();
set_post_views(get_the_ID());
$info_cat_post = info_category_post($post->ID);
if ($info_cat_post['parent_cat_name'] == 'Apps') {
?>
<?php
if (has_nav_menu('sub_cat_menu_a')) {
?>
<div id="catnav" class="secondary">
<?php
wp_nav_menu(array('theme_location' => 'sub_cat_menu_a', 'container' => '', 'menu_id' => 'sub_catmenu', 'menu_class' => 'catnav container clearfix', 'fallback_cb' => 'false', 'depth' => 3));
?>
</div>
<?php
}
?>
<?php
} elseif ($info_cat_post['parent_cat_name'] == 'Games') {
?>
<?php
if (has_nav_menu('sub_cat_menu_g')) {
?>
