/**
* bXpress Forums
* A light weight and easy to use XOOPS module to create forums
*
* Copyright © 2014 Eduardo Cortés https://eduardocortes.mx
* -----------------------------------------------------------------
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
* -----------------------------------------------------------------
* @package bXpress
* @author Eduardo Cortés <*****@*****.**>
* @since 1.2
* @license GPL v2 (http://www.gnu.org/licenses/gpl-2.0.html)
* @link https://github.com/bitcero/bxpress
*/
function bxpress_block_users_show($options)
{
// Add css styles
RMTemplate::get()->add_style('bxpress-blocks.min.css', 'bxpress');
$db = XoopsDatabaseFactory::getDatabaseConnection();
$tbu = $db->prefix("users");
$tbp = $db->prefix("mod_bxpress_posts");
$tbl = $db->prefix("mod_bxpress_likes");
if ('active' == $options['type']) {
$sql = "SELECT DISTINCT posts.uid, users.uid, users.uname, users.email, users.name,\n (SELECT COUNT(*) FROM {$tbp} WHERE uid = posts.uid) as total,\n (SELECT SUM(likes) FROM {$tbp} WHERE uid = posts.uid ) as likes\n FROM {$tbu} as users, {$tbp} as posts WHERE users.uid = posts.uid ORDER BY total DESC LIMIT 0, {$options['limit']}";
}
$result = $db->query($sql);
$users = array();
$user = new RMUser();
while ($row = $db->fetchArray($result)) {
$user->assignVars($row);
$users[] = array('id' => $user->id(), 'name' => '' != $user->name ? $user->name : $user->uname, 'uname' => $user->uname, 'avatar' => RMEvents::get()->run_event("rmcommon.get.avatar", $user->email, 0), 'posts' => $row['total'], 'likes' => $row['likes']);
}
$block['users'] = $users;
return $block;
}
function dt_block_items($options)
{
global $db, $xoopsModule;
include_once XOOPS_ROOT_PATH . '/modules/dtransport/class/dtsoftware.class.php';
include_once XOOPS_ROOT_PATH . '/modules/dtransport/class/dtfunctions.class.php';
$tpl = RMTemplate::get();
$tpl->add_xoops_style('blocks.css', 'dtransport');
$dtfunc = new DTFunctions();
$db = XoopsDatabaseFactory::getDatabaseConnection();
$tbls = $db->prefix("dtrans_software");
$tblc = $db->prefix("dtrans_catsoft");
if ($options[1] > 0) {
$sql = "SELECT s.* FROM {$tbls} as s, {$tblc} as c WHERE c.cat='" . $options[1] . "' AND s.id_soft=c.soft AND s.approved=1 AND s.`delete`=0";
} else {
$sql = "SELECT s.* FROM {$tbls} as s WHERE s.`approved`=1 AND s.`delete`=0 ";
}
if (trim($options[10]) > 0) {
$user = new RMUser(trim($options[10]));
if ($user->isNew()) {
return;
}
$sql .= " AND s.uid='" . $user->id() . "' ";
}
if ($options[11] > 0) {
$sql .= "AND id_cat='{$options['11']}'";
}
switch ($options[0]) {
case 'all':
$sql .= ' ORDER BY RAND() ';
break;
case 'recent':
$sql .= " ORDER BY s.modified DESC, created DESC ";
break;
case 'popular':
$sql .= " ORDER BY s.hits DESC ";
break;
case 'rated':
$sql .= " ORDER BY s.`rating`/s.`votes` DESC ";
break;
case 'featured':
$sql .= " AND featured=1 ORDER BY RAND() ";
break;
case 'daily':
$sql = " AND daily=1 ORDER BY RAND() ";
break;
}
$options[2] = $options[2] > 0 ? $options[2] : 5;
$sql .= " LIMIT 0, {$options['2']}";
$result = $db->query($sql);
$block = array();
while ($row = $db->fetchArray($result)) {
$item = new DTSoftware();
$item->assignVars($row);
$rtn = array();
$rtn['name'] = $item->getVar('name');
$rtn['version'] = $item->getVar('version');
if ($options[3]) {
$img = new RMImage();
$img->load_from_params($item->getVar('image'));
$rtn['image'] = $img->get_version($options[11]);
}
if ($options[4]) {
$rtn['description'] = $item->getVar('shortdesc');
}
if ($options[5]) {
$rtn['hits'] = sprintf(__('Downloaded %s times.', 'dtransport'), '<strong>' . $item->getVar('hits') . '</strong>');
}
if ($options[6]) {
$rtn['urate'] = @number_format($item->getVar('rate') / $item->getVar('votes'), 1);
}
if ($options[7]) {
$rtn['siterate'] = DTFunctions::ratingStars($item->getVar('siterate'));
}
$rtn['link'] = $item->permalink();
$rtn['metas'] = $dtfunc->get_metas('down', $item->id());
if ($options[9]) {
$rtn['author'] = array('name' => $item->getVar('author_name'), 'url' => $item->getVar('author_url'));
}
$block['downs'][] = $rtn;
}
$block['showbutton'] = $options[8];
$block['downlang'] = __('Download', 'dtransport');
$block['lang_urate'] = __('User rating: %s', 'dtransport');
$block['lang_author'] = __('Author: %s', 'dtransport');
$block['langhits'] = _BK_DT_HITSTEXT;
$block['langurate'] = _BK_DT_URATETEXT;
$block['languser'] = _BK_DT_USERBY;
return $block;
}