Importante para recién llegados: en este hilo están las normas, sugerencias y políticas para escribir en los foros: https://aprenderaprogramar.com/foros/index.php?topic=1460.0 ¡Léelo antes de escribir!
Mostrar Mensajes
Esta sección te permite ver todos los posts escritos por este usuario. Ten en cuenta que sólo puedes ver los posts escritos en zonas a las que tienes acceso en este momento.
<?php
/**
* @version SVN: $Id$
* @package mod_topratedcontentmodule
* @author Mathias Hortig {@link http://tuts4you.de/}
* @license GNU/GPL
*/
// No direct access
defined( '_JEXEC' ) or die( 'Restricted access' );
// Require the base controller
require_once(dirname(__FILE__).DS.'mod_topratedcontentmodulehelper.php');
echo mod_topratedcontentmodulehelper::GetRatedArticlesList($params);
<?php
/**
* @version SVN: $Id$
* @package mod_topratedcontentmodule
* @author Mathias Hortig {@link http://tuts4you.de/}
* @license GNU/GPL
*/
// No direct access
defined( '_JEXEC' ) or die( 'Restricted access' );
jimport( 'joomla.application.component.model' );
jimport( 'joomla.html.parameter' );
class mod_topratedcontentmodulehelper
{
function GetRatedArticlesList(&$params)
{
require_once JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php';
$db =& JFactory::getDBO();
$query = "SELECT cc.title AS category, a.id, a.title, DATE_FORMAT(a.created,'%d.%m.%Y') as created,
u.username, a.hits, cc.id as catid, format((r.rating_sum / r.rating_count), 2) as averagerating
FROM #__content AS a
LEFT JOIN #__categories AS cc ON a.catid = cc.id
LEFT JOIN #__users AS u ON u.id = a.created_by
LEFT JOIN #__content_rating as r ON a.id = r.content_id
WHERE r.rating_count is not null";
if($params->get('showOnlyPublicPosts') == 0)
{
$query .= " and a.access = 1 ";
}
$query .= "
ORDER BY (r.rating_sum / r.rating_count) desc, rating_count desc";
if($params->get('articleCount') != 0)
{
$query .= " LIMIT 0, " . $params->get('articleCount');
}
$db->setQuery( $query );
$table = $db->loadObjectList();
$html .= '<ul id="topratedcontentmodule">';
foreach($table as $row)
{
$html .= '<li>';
$html .= '<a title="' . JText::_('MOD_TOPRATEDCONTENTMODULE_AVERAGERATING') . ': ' . $row->averagerating . '" href="' . JRoute::_(ContentHelperRoute::getArticleRoute($row->id, $row->catid)) . '">'.$row->title.'</a>';
$html .= '</li>';
}
$html .= '</ul>';
return $html;
}
}
<?php
/**
* @version SVN: $Id$
* @package mod_topratedcontentmodule
* @author Mathias Hortig {@link http://tuts4you.de/}
* @license GNU/GPL
*/
// No direct access
defined( '_JEXEC' ) or die( 'Restricted access' );
jimport( 'joomla.application.component.model' );
jimport( 'joomla.html.parameter' );
class mod_topratedcontentmodulehelper
{
function GetRatedArticlesList(&$params)
{
require_once JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php';
$db =& JFactory::getDBO();
$query = "SELECT cc.title AS category, a.id, a.title, DATE_FORMAT(a.created,'%d.%m.%Y') as created,
u.username, a.hits, cc.id as catid, format((r.rating_sum / r.rating_count), 2) as averagerating
FROM #__content AS a
LEFT JOIN #__categories AS cc ON a.catid = cc.id
LEFT JOIN #__users AS u ON u.id = a.created_by
LEFT JOIN #__content_rating as r ON a.id = r.content_id
WHERE r.rating_count is not null";
if($params->get('showOnlyPublicPosts') == 0)
{
$query .= " and a.access = 1 ";
}
$query .= "
ORDER BY (r.rating_sum / r.rating_count) desc, rating_count desc";
if($params->get('articleCount') != 0)
{
$query .= " LIMIT 0, " . $params->get('articleCount');
}
$db->setQuery( $query );
$table = $db->loadObjectList();
$html .= '<ul id="topratedcontentmodule">';
foreach($table as $row)
{
$html .= '<li>';
$html .= '<a title="' . JText::_('MOD_TOPRATEDCONTENTMODULE_AVERAGERATING') . ': ' . $row->averagerating . '" href="' . JRoute::_(ContentHelperRoute::getArticleRoute($row->id, $row->catid)) . '">'.$row->title.'</a>';
$html .= '</li>';
}
$html .= '</ul>';
return $html;
}
}
function GetRatedArticlesList(&$params)
{
require_once JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php';
$db =& JFactory::getDBO();
$query = "SELECT cc.title AS category, a.id, a.title, DATE_FORMAT(a.created,'%d.%m.%Y') as created,
u.username, a.hits, cc.id as catid, format((r.rating_sum / r.rating_count), 2) as averagerating
FROM #__content AS a
LEFT JOIN #__categories AS cc ON a.catid = cc.id
LEFT JOIN #__users AS u ON u.id = a.created_by
LEFT JOIN #__content_rating as r ON a.id = r.content_id
WHERE r.rating_count is not null";
{
"46a4ee50-9d88-4142-9acf-3b5169833a57": {
"votes": "2",
"value": "3.5000"
},
"1cc21c78-250d-482f-aa93-54983d2923ce": {
"value": "1"
},
"f117218a-c831-452e-a8bc-850a6ee9ec0a": {
"option": {
"0": "boeing"
},
"select": "1"
},
"701cb971-8956-4aea-8c19-4bf201f25cdc": {
"0": {
"value": ""
}
},
"008a8be7-365e-4dfd-9a32-691227f1eced": {
"0": {
"value": "60-0350"
}
},
"d4704df9-558c-4beb-9d27-203af1bfc7fa": {
"0": {
"value": "USAF"
}
},
"4f65435d-7454-4fdb-9b8f-bdd2816a09fb": {
"0": {
"value": "Espa\u00f1a"
}
},
"64b17c0e-e3d5-41f6-b57c-0a8bb5827b50": {
"0": {
"value": "Gran Canaria - Gando (LPA\/GCLP) "
}
},
"dfb68bc5-0f33-4fbc-978e-1a8e0b6c62f3": {
"0": {
"value": ""
}
},
"d7455e43-f654-49b0-bd65-d8bb84f61e21": {
"file": "images\/03-spotting\/galeria_spotting\/watermark\/0350-2.jpg",
"title": "",
"link": "images\/03-spotting\/galeria_spotting\/watermark\/0350-2.jpg",
"target": "0",
"rel": "",
"lightbox_image": "",
"spotlight_effect": "",
"caption": "",
"width": 1024,
"height": 683
},
"f001e203-1af8-455a-ad2f-a3c3abce2b09": {
},
"fe50247a-0bd5-4620-8798-bb8f7fb90a27": {
"0": {
"value": ""
}
}
}
{
"46a4ee50-9d88-4142-9acf-3b5169833a57": {
"votes": "1",
"value": "4.0000"
},
"1cc21c78-250d-482f-aa93-54983d2923ce": {
"value": "1"
},
"f117218a-c831-452e-a8bc-850a6ee9ec0a": {
"option": {
"0": ""
},
"select": "1"
},
"701cb971-8956-4aea-8c19-4bf201f25cdc": {
"0": {
"value": ""
}
},
"008a8be7-365e-4dfd-9a32-691227f1eced": {
"0": {
"value": "EC-JQQ"
}
},
"d4704df9-558c-4beb-9d27-203af1bfc7fa": {
"0": {
"value": "Air Europa"
}
},
"4f65435d-7454-4fdb-9b8f-bdd2816a09fb": {
"0": {
"value": "Espa\u00f1a"
}
},
"64b17c0e-e3d5-41f6-b57c-0a8bb5827b50": {
"0": {
"value": "Madrid - Barajas (MAD\/LEMD)"
}
},
"dfb68bc5-0f33-4fbc-978e-1a8e0b6c62f3": {
"0": {
"value": "<p>Entrando en pista 15R para despegue inmediato v\u00eda LimaAlfa. Impresionantes los 60.30m de envergadura de esta m\u00e1quina.<\/p>"
}
},
"d7455e43-f654-49b0-bd65-d8bb84f61e21": {
"file": "images\/03-spotting\/galeria_spotting\/watermark\/EC-JQQ-A330-203-AIR-EUROPA5.jpg",
"title": "",
"link": "images\/03-spotting\/galeria_spotting\/watermark\/EC-JQQ-A330-203-AIR-EUROPA5.jpg",
"target": "0",
"rel": "",
"lightbox_image": "",
"spotlight_effect": "",
"caption": "",
"width": 1024,
"height": 683
},
"f001e203-1af8-455a-ad2f-a3c3abce2b09": {
},
"fe50247a-0bd5-4620-8798-bb8f7fb90a27": {
"0": {
"value": ""
}
}
}
{
"metadata.title": "",
"metadata.description": "",
"metadata.keywords": "",
"metadata.robots": "",
"metadata.author": "",
"config.enable_comments": "1",
"config.primary_category": "738"
}
require_once JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php';
$db =& JFactory::getDBO();
$query = "SELECT cc.title AS category, a.id, a.title, DATE_FORMAT(a.created,'%d.%m.%Y') as created,
u.username, a.hits, cc.id as catid, format((r.rating_sum / r.rating_count), 2) as averagerating
FROM #__content AS a
LEFT JOIN #__categories AS cc ON a.catid = cc.id
LEFT JOIN #__users AS u ON u.id = a.created_by
LEFT JOIN #__content_rating as r ON a.id = r.content_id
WHERE r.rating_count is not null";
Sobre la educación, sólo puedo decir que es el tema más importante en el que nosotros, como pueblo, debemos involucrarnos.
Abraham Lincoln (1808-1865) Presidente estadounidense.
aprenderaprogramar.com: Desde 2006 comprometidos con la didáctica y divulgación de la programación
RSS -
WAP2