10-15-2021, 01:27 PM
3
[img]Registrate o inicia tu sesión para ver este contenido[/img]
Debes agradecer para ver el contenido...
En c.posts.php --> inc --> class --> c.posts.php
Buscar:
Código PHP: ( Seleccionar Todo )
$query = db_exec(array(__FILE__, __LINE__), 'query', 'SELECT p.post_id, p.post_user, p.post_category, p.post_title, p.post_date, p.post_comments, p.post_puntos, p.post_private, p.post_sponsored, p.post_status, p.post_sticky, u.user_id, u.user_name, u.user_activo, u.user_baneado, c.c_nombre, c.c_seo, c.c_img FROM p_posts AS p LEFT JOIN u_miembros AS u ON p.post_user = u.user_id '.($tsUser->is_admod && $tsCore->settings['c_see_mod'] == 1 ? '' : ' && u.user_activo = \'1\' && u.user_baneado = \'0\'').' LEFT JOIN p_categorias AS c ON c.cid = p.post_category WHERE '.($tsUser->is_admod && $tsCore->settings['c_see_mod'] == 1 ? 'p.post_id > 0' : 'p.post_status = \'0\' && u.user_activo = \'1\' && u.user_baneado = \'0\'').' '.$c_where.' '.$s_where.' GROUP BY p.post_id ORDER BY '.$s_order.' DESC LIMIT '.$start);
$lastPosts['data'] = result_array($query);
//
return $lastPosts;
}
Reemplazar por:
Código PHP: ( Seleccionar Todo )
$query = db_exec(array(__FILE__, __LINE__), 'query', 'SELECT p.post_id, p.post_user, p.post_category, p.post_title, p.post_date, COUNT(p_c.c_post_id) as post_comments, p.post_puntos, p.post_private, p.post_sponsored, p.post_status, p.post_sticky, u.user_id, u.user_name, u.user_activo, u.user_baneado, c.c_nombre, c.c_seo, c.c_img FROM p_posts AS p LEFT JOIN u_miembros AS u ON p.post_user = u.user_id '.($tsUser->is_admod && $tsCore->settings['c_see_mod'] == 1 ? '' : ' && u.user_activo = \'1\' && u.user_baneado = \'0\'').' LEFT JOIN p_categorias AS c ON c.cid = p.post_category LEFT JOIN p_comentarios AS p_c ON p.post_id = p_c.c_post_id AND p_c.c_status = \'0\' LEFT JOIN u_miembros AS uc ON p_c.c_user = uc.user_id '.($tsUser->is_admod && $tsCore->settings['c_see_mod'] == 1 ? '' : ' && uc.user_activo = \'1\' AND uc.user_baneado = \'0\'').' WHERE u.user_rango != \'3\' AND '.($tsUser->is_admod && $tsCore->settings['c_see_mod'] == 1 ? 'p.post_id > 0' : 'p.post_status = \'0\' && u.user_activo = \'1\' && u.user_baneado = \'0\'').' '.$c_where.' '.$s_where.' GROUP BY p.post_id ORDER BY '.$s_order.' DESC LIMIT '.$start);
$lastPosts['data'] = result_array($query);
//
return $lastPosts;
}
function getLastNovatosPosts($category = NULL, $subcateg = NULL, $sticky = false)
{
global $tsCore, $tsUser;
/**********/
// TIPO DE POSTS A MOSTRAR
if(!empty($category)){
// EXISTE LA CATEGORIA?
$cat = db_exec('fetch_assoc', db_exec(array(__FILE__, __LINE__), 'query', 'SELECT cid FROM p_categorias WHERE c_seo = \''.$tsCore->setSecure($category).'\' LIMIT 1'));
if($cat['cid'] > 0) {
$c_where = 'AND p.post_category = \''.(int)$cat['cid'].'\''; // SUBCATEGORIA EN ESPECIAL
$p_where = ' && post_category = \''.(int)$cat['cid'].'\'';
}
}
// Stickys
if($sticky) {
$s_where = 'AND p.post_sticky = \'1\'';
$s_order = 'p.post_sponsored';
$start = '0, 10';
} else {
$s_where = 'AND p.post_sticky = \'0\'';
$s_order = 'p.post_id';
// TOTAL DE POSTS
$posts['total'] = db_exec('num_rows', db_exec(array(__FILE__, __LINE__), 'query', 'SELECT p.post_id FROM p_posts AS p LEFT JOIN u_miembros AS u ON p.post_user = u.user_id WHERE '.($tsUser->is_admod && $tsCore->settings['c_see_mod'] == 1 ? ' p.post_id > \'0\' ' : ' u.user_activo = \'1\' && u.user_baneado = \'0\' && p.post_status = \'0\'').' '.$p_where.' '.$s_where));
//
$start = $tsCore->setPageLimit($tsCore->settings['c_max_posts'],false,$posts['total']);
$lastPosts['pages'] = $tsCore->getPages($posts['total'], $tsCore->settings['c_max_posts']);
}
/*********/
$query = db_exec(array(__FILE__, __LINE__), 'query', 'SELECT p.post_id, p.post_user, p.post_category, p.post_title, p.post_date, COUNT(p_c.c_post_id) as post_comments, p.post_puntos, p.post_private, p.post_sponsored, p.post_status, p.post_sticky, u.user_id, u.user_name, u.user_activo, u.user_baneado, c.c_nombre, c.c_seo, c.c_img FROM p_posts AS p LEFT JOIN u_miembros AS u ON p.post_user = u.user_id '.($tsUser->is_admod && $tsCore->settings['c_see_mod'] == 1 ? '' : ' && u.user_activo = \'1\' && u.user_baneado = \'0\'').' LEFT JOIN p_categorias AS c ON c.cid = p.post_category LEFT JOIN p_comentarios AS p_c ON p.post_id = p_c.c_post_id AND p_c.c_status = \'0\' LEFT JOIN u_miembros AS uc ON p_c.c_user = uc.user_id '.($tsUser->is_admod && $tsCore->settings['c_see_mod'] == 1 ? '' : ' && uc.user_activo = \'1\' AND uc.user_baneado = \'0\'').' WHERE u.user_rango = \'3\' AND '.($tsUser->is_admod && $tsCore->settings['c_see_mod'] == 1 ? 'p.post_id > 0' : 'p.post_status = \'0\' && u.user_activo = \'1\' && u.user_baneado = \'0\'').' '.$c_where.' '.$s_where.' GROUP BY p.post_id ORDER BY '.$s_order.' DESC LIMIT '.$start);
$lastPosts['data'] = result_array($query);
//
return $lastPosts;
}
En c.tops.php --> inc --> class --> c.tops.php
Buscar:
Código PHP: ( Seleccionar Todo )
//
return $segundos;
}
Arriba agregar:
Código PHP: ( Seleccionar Todo )
/* TOp Posts de Novatos*/
function getHomeTopNovPosts(){
// AYER
$data['ayer'] = $this->getHomeTopNovPostsQuery($this->setTime(2));
// SEMANA
$data['semana'] = $this->getHomeTopNovPostsQuery($this->setTime(3));
// MES
$data['mes'] = $this->getHomeTopNovPostsQuery($this->setTime(4));
// HISTÓRICO
$data['historico'] = $this->getHomeTopNovPostsQuery($this->setTime(5));
//
return $data;
}
/* getHomeTopNovUsersQuery*/
function getHomeTopNovUsers(){
// AYER
$data['ayer'] = $this->getHomeTopNovUsersQuery($this->setTime(2));
// SEMANA
$data['semana'] = $this->getHomeTopNovUsersQuery($this->setTime(3));
// MESInstalación de la Sección Novatos Por Manuel Absalón
$data['mes'] = $this->getHomeTopNovUsersQuery($this->setTime(4));
// HISTÓRICO
$data['historico'] = $this->getHomeTopNovUsersQuery($this->setTime(5));
//
return $data;
//
print_r($data);
die;
}
/* getHomeTopNovPostsQuery($data)*/
function getHomeTopNovPostsQuery($date){
//
$query = db_exec(array(__FILE__, __LINE__), 'query', "SELECT p.post_id, p.post_category,
p.post_title, p.post_puntos, c.c_seo FROM p_posts AS p LEFT JOIN
u_miembros AS u ON p.post_user = u.user_id RIGHT JOIN p_categorias AS c
ON c.cid = p.post_category WHERE u.user_rango = 3 AND p.post_status = 0
AND p.post_date BETWEEN {$date['start']} AND {$date['end']} ORDER BY
p.post_puntos DESC LIMIT 15");
$data = result_array($query);
//
return $data;
}
function getHomeTopNovUsersQuery($date){
// PUNTOS
$query = db_exec(array(__FILE__, __LINE__), 'query', "SELECT SUM(p.post_puntos) AS total,
u.user_id, u.user_name FROM p_posts AS p LEFT JOIN u_miembros AS u ON
p.post_user = u.user_id WHERE u.user_rango = 3 and p.post_status = 0 AND
p.post_date BETWEEN {$date['start']} AND {$date['end']} GROUP BY
p.post_user ORDER BY total DESC LIMIT 15");
$data = result_array($query);
//
return $data;
}
En posts.php --> inc --> php --> posts.php
Buscar:
Código PHP: ( Seleccionar Todo )
// IMAGENES
Arriba agregar:
Código PHP: ( Seleccionar Todo )
// ULTIMOS POSTS Novatos
if($_GET['nov'] == true){
$smarty->assign("tsNovs",1);
$tsLastPosts = $tsPosts->getLastNovatosPosts($category, $subcateg);
$smarty->assign("tsPosts",$tsLastPosts['data']);
$smarty->assign("tsPages",$tsLastPosts['pages']);
// ULTIMOS POSTS Novatos FIJOS
if($tsLastPosts['pages']['current'] == 1){
$tsLastStickys = $tsPosts->getLastNovatosPosts($category,
$subcateg, true);
$smarty->assign("tsPostsStickys",$tsLastStickys['data']);
}
// TOP POSTS Novatos
$smarty->assign("tsTopPosts",$tsTops->getHomeTopNovPosts());
// TOP USERS Novatos
$smarty->assign("tsTopUsers",$tsTops->getHomeTopNovUsers());
}
En .htaccess
Buscar:
Código PHP: ( Seleccionar Todo )
RewriteRule ^mi/$ index.php?do=portal [QSA,L]
Debajo agregar:
Código PHP: ( Seleccionar Todo )
RewriteRule ^posts/novatos/$ index.php?do=posts&nov=true [QSA,L]
RewriteRule ^posts/novatos/pagina([0-9]+)$ index.php?do=posts&page=$1&nov=true [QSA,L]
RewriteRule ^posts/novatos/([A-Za-z0-9_-]+)/([0-9]+)/(.*).html$ index.php?do=posts&cat=$1&post_id=$2&title=$3&nov=true [QSA,L]
En head_submenu.tpl --> themes --> default --> templates --> sections --> head_submenu.tpl
Buscar:
Código PHP: ( Seleccionar Todo )
<li{if $tsPage == 'home' || $tsPage == 'portal'} class="here"{/if}><a class=vctip title="Inicio" href="{$tsConfig.url}/{if $tsPage == 'home' || $tsPage == 'posts'}posts/{/if}">Inicio</a></li>
Reemplazar por:
Código PHP: ( Seleccionar Todo )
<li{if $tsPage == 'home' || $tsPage == 'portal' && $tsNovs != 1} class="here"{/if}><a class=vctip title="Inicio" href="{$tsConfig.url}/{if $tsPage == 'home' || $tsPage == 'posts'}posts/{/if}">Inicio</a></li> <li{if $tsPage == 'posts' && $tsNovs == 1} class="here"{/if}><a title="Novatos" href="{$tsConfig.url}/posts/novatos/">Novatos</a>
Creditos: Debes agradecer para ver el contenido...
Facebook
Twitter
Reddit
Digg
del.icio.us
Tumblr
Pinterest
Blogger
Fark
LinkedIn
Mix
Google