function &gs_rssshow($limit)
{
global $util, $mc;
$db =& Database::getInstance();
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsimage.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsset.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsuser.class.php';
foreach ($_GET as $k => $v) {
${$k} = $v;
}
$feed = array();
// Información General
$items = array();
$mc =& $util->moduleConfig('galleries');
if ($show == 'imgs') {
$feed['title'] = htmlspecialchars(_MI_GS_RSSNAME);
$feed['link'] = htmlspecialchars(XOOPS_URL . '/modules/galleries/' . ($mc['urlmode'] ? 'explore/photos/' : 'explore.php?by=explore/photos'));
$feed['description'] = htmlspecialchars(_MI_GS_RSSIMGS_DESC);
$sql = "SELECT * FROM " . $db->prefix("gs_images") . " WHERE public='2' ORDER BY created DESC LIMIT 0,15";
$result = $db->query($sql);
$users = array();
while ($row = $db->fetchArray($result)) {
$pic = new GSImage();
$pic->assignVars($row);
if (!isset($users[$pic->owner()])) {
$users[$pic->owner()] = new GSUser($pic->owner(), 1);
}
$user =& $users[$pic->owner()];
$rtn = array();
$rtn['title'] = htmlspecialchars($pic->title());
$rtn['link'] = $user->userURL() . 'img/' . $pic->id() . '/';
$rtn['description'] = htmlspecialchars('<img src="' . $user->filesURL() . '/ths/' . $pic->image() . '" alt="" /><br />' . sprintf(_MI_GS_RSSIMGDESC, $pic->desc(), formatTimestamp($pic->created(), 'string'), $user->uname(), $pic->views()));
$rtn['date'] = formatTimestamp($pic->created());
$items[] = $rtn;
}
} elseif ($show == 'sets') {
$feed['title'] = htmlspecialchars(_MI_GS_RSSSETS);
$feed['link'] = htmlspecialchars(XOOPS_URL . '/modules/galleries/' . ($mc['urlmode'] ? 'explore/sets/' : 'explore.php?by=explore/sets'));
$feed['description'] = htmlspecialchars(_MI_GS_RSSSETS_DESC);
$sql = "SELECT * FROM " . $db->prefix("gs_sets") . " WHERE public='2' ORDER BY date DESC LIMIT 0,15";
$result = $db->query($sql);
$users = array();
while ($row = $db->fetchArray($result)) {
$set = new GSSet();
$set->assignVars($row);
if (!isset($users[$set->owner()])) {
$users[$set->owner()] = new GSUser($set->owner(), 1);
}
$user =& $users[$set->owner()];
$rtn = array();
$rtn['title'] = htmlspecialchars($set->title());
$rtn['link'] = $user->userURL() . 'set/' . $set->id() . '/';
$rtn['description'] = htmlspecialchars(sprintf(_MI_GS_RSSSETDESC, $user->uname(), formatTimestamp($set->date(), 'string'), $set->pics()));
$rtn['date'] = formatTimestamp($set->date());
$items[] = $rtn;
}
}
$ret = array('feed' => $feed, 'items' => $items);
return $ret;
}
/**
* @desc Visualiza todos los albums
**/
function showAlbums()
{
global $tpl, $xoopsModule, $mc, $xoopsSecurity;
define('RMSUBLOCATION', 'sets');
$db = Database::getInstance();
$page = isset($_REQUEST['page']) ? $_REQUEST['page'] : 1;
$limit = 15;
$sort = isset($_REQUEST['sort']) ? $_REQUEST['sort'] : 'id_set';
$mode = isset($_REQUEST['mode']) ? $_REQUEST['mode'] : 1;
$search = isset($_REQUEST['search']) ? $_REQUEST['search'] : '';
$query = "search={$search}&page={$page}&sort={$sort}&mode={$mode}";
//Barra de Navegación
$sql = "SELECT COUNT(*) FROM " . $db->prefix('gs_sets');
$sql1 = '';
$words = array();
if ($search) {
//Separamos en palabras
$words = explode(" ", $search);
foreach ($words as $k) {
$k = trim($k);
if (strlen($k) <= 2) {
continue;
}
$sql1 .= $sql1 == '' ? " WHERE (title LIKE '%{$k}%' OR uname LIKE '%{$k}%')" : " OR (title LIKE '%{$k}%' OR uname LIKE '%{$k}%')";
}
}
list($num) = $db->fetchRow($db->query($sql . $sql1));
$start = $num <= 0 ? 0 : ($page - 1) * $limit;
$tpages = ceil($num / $limit);
$nav = new RMPageNav($num, $limit, $page, 5);
$nav->target_url("sets.php?page={PAGE_NUM}&sort={$sort}&mode={$mode}&search={$search}");
//Fin de barra de navegación
$sql = str_replace('COUNT(*)', '*', $sql);
$sql2 = $sort ? " ORDER BY {$sort} " . ($mode ? "DESC" : "ASC ") : '';
$sql2 .= " LIMIT {$start},{$limit}";
$result = $db->query($sql . $sql1 . $sql2);
$sets = array();
while ($rows = $db->fetchArray($result)) {
foreach ($words as $k) {
$rows['title'] = eregi_replace("({$k})", "<span class='searchResalte'>\\1</span>", $rows['title']);
$rows['uname'] = eregi_replace("({$k})", "<span class='searchResalte'>\\1</span>", $rows['uname']);
}
$set = new GSSet();
$set->assignVars($rows);
$sets[] = array('id' => $set->id(), 'title' => $set->title(), 'owner' => $set->uname(), 'public' => $set->isPublic(), 'date' => formatTimeStamp($set->date(), 'c'), 'pics' => $set->pics(), 'url' => $set->url());
}
GSFunctions::toolbar();
xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » " . __('Albums Management', 'galleries'));
RMTemplate::get()->assign('xoops_pagetitle', 'Albums Management');
RMTemplate::get()->add_script(RMCURL . '/include/js/jquery.checkboxes.js');
RMTemplate::get()->add_head("<script type='text/javascript'>\n\n var delete_warning='" . __('Do you really wish to delete selected albums?', 'galleries') . "';\n\n var delete_formats='" . __('Do you really wish to delete all images formats for this album?\\nOnly deletes formats for albums, search and others, except normal thumbnails.', 'galleries') . "';\n\n </script>");
RMTemplate::get()->add_script('../include/js/gsscripts.php?file=sets');
$cHead = '<link href="' . XOOPS_URL . '/modules/galleries/styles/admin.css" media="all" rel="stylesheet" type="text/css" />';
xoops_cp_header($cHead);
include RMTemplate::get()->get_template('admin/gs_albums.php', 'module', 'galleries');
xoops_cp_footer();
}
/**
* @desc Mostramos el contenido de un Álbum
*/
function showSetContent()
{
global $usr, $db, $xoopsModule, $mc, $xoopsModuleConfig, $xoopsConfig, $xoopsUser, $xoopsOption, $tpl, $page;
global $pag, $set;
$mc =& $xoopsModuleConfig;
$user = new GSUser($usr);
if ($user->isNew()) {
redirect_header(GSFunctions::get_url(), 0, __('Specified users does not exists!', 'galleries'));
die;
}
$set = new GSSet($set);
if ($set->isNew()) {
redirect_header(GSFunctions::get_url(), 0, __('Specified album does not exists!', 'galleries'));
die;
}
//Verificamos la privacidad del album
if (!$set->ispublic()) {
if (!$xoopsUser || $xoopsUser->uid() != $set->owner()) {
redirect_header(GSFunctions::get_url(), 1, __('You can not view this private album!', 'galleries'));
die;
}
} else {
if (!$xoopsUser && $set->isPublic() == 1 && !$user->isFriend($xoopsUser->uid())) {
redirect_header(GSFunctions::get_url(), 1, sprintf(__('You must be a friend of %s in order to see this album!', 'galleries'), $user->uname()));
die;
}
}
//Incrementamos el número de hits del album
if (!isset($_SESSION['vsets'])) {
$set->addHit();
$_SESSION['vsets'] = array($set->id());
} elseif (!in_array($set->id(), $_SESSION['vsets'])) {
$set->addHit();
$_SESSION['vsets'][] = $set->id();
}
$xoopsOption['template_main'] = $mc['set_format_mode'] ? 'gs_setpics.html' : 'gs_userpics.html';
$xoopsOption['module_subpage'] = 'userset';
include 'header.php';
GSFunctions::makeHeader();
// Información del Usuario
$tpl->assign('lang_picsof', sprintf(__('Pictures in %s'), $set->title()));
$tpl->assign('user', array('id' => $user->uid(), 'uname' => $user->uname(), 'avatar' => RMEvents::get()->run_event('rmcommon.get.avatar', $user->userVar('email'), 0, $user->userVar('user_avatar')), 'link' => $user->userURL()));
$tpl->assign('set', array('title' => $set->title(), 'description' => $set->getVar('description', 's')));
// Lenguaje
$tpl->assign('lang_bmark', __('Favorites', 'galleries'));
$tpl->assign('lang_pics', __('Pictures', 'galleries'));
$tpl->assign('sets_link', GSFunctions::get_url() . ($mc['urlmode'] ? "explore/sets/usr/" . $user->uname() . '/' : "?explore=sets&usr="******"explore/tags/usr/" . $user->uname() . '/' : "?explore=tags&usr="******"cp/bookmarks/" : "?cp=bookmarks"));
$tpl->assign('xoops_pagetitle', sprintf(__('Pictures in %s'), $set->title()) . ' » ' . $mc['section_title']);
$tpl->assign('lang_numpics', sprintf(__('Pictures: %s', 'galleries'), $set->pics()));
$tpl->assign('lang_numviews', sprintf(__('Hits: %s'), $set->hits()));
global $xoTheme;
if ($set->getVar('description') != '') {
$xoTheme->addMeta('meta', 'description', TextCleaner::clean_disabled_tags($set->getVar('description')));
}
//Verificamos la privacidad de las imágenes
if ($xoopsUser && $xoopsUser->uid() == $user->uid()) {
$public = '';
} else {
if ($xoopsUser && $user->isFriend($xoopsUser->uid())) {
$public = " AND public<>0";
} else {
$public = "AND public='2'";
}
}
$tbl1 = $db->prefix("gs_images");
$tbl2 = $db->prefix("gs_setsimages");
$sql = "SELECT COUNT(*) FROM {$tbl1} a, {$tbl2} b WHERE b.id_set='" . $set->id() . "' AND a.id_image=b.id_image {$public} AND owner='" . $user->uid() . "'";
$page = $page > 0 ? $page : 1;
/**
* @desc Formato para el manejo de las imágenes
*/
if ($mc['set_format_mode']) {
$format = $mc['set_format_values'];
$crop = $format[0];
// 0 = Redimensionar, 1 = Cortar
$width = $format[1];
$height = $format[2];
$limit = $format[3];
$cols = $format[4];
@($showdesc = $format[5]);
// Imágenes Grandes
$format = $mc['setbig_format_values'];
$bcrop = $format[0];
$bwidth = $format[1];
$bheight = $format[2];
$blimit = $format[3];
$bcols = $format[4];
@($bshowdesc = $format[5]);
// Medidas
$tpl->assign('big_width', $bwidth + 15);
} else {
$limit = $mc['limit_pics'];
$cols = $mc['cols_pics'];
$showdesc = 0;
}
list($num) = $db->fetchRow($db->query($sql));
if ($page > 0) {
$page -= 1;
}
$start = $page * $limit;
$tpages = (int) ($num / $limit);
if ($num % $limit > 0) {
$tpages++;
}
$pactual = $page + 1;
if ($pactual > $tpages) {
$pactual = $tpages;
$start = ($tpages - 1) * $limit;
}
$urlnav = '';
if ($tpages > 1) {
$urlnav .= $mc['urlmode'] ? 'usr/' . $user->uname() . '/set/' . $set->id() : '?usr='******'&set=' . $set->id();
$nav = new RMPageNav($num, $limit, $pactual, 5);
$nav->target_url(GSFunctions::get_url() . $urlnav . ($mc['urlmode'] ? '/pag/{PAGE_NUM}/' : '&pag={PAGE_NUM}'));
$tpl->assign('upNavPage', $nav->render(false));
}
$showmax = $start + $limit;
$showmax = $showmax > $num ? $num : $showmax;
$tpl->assign('lang_showing', sprintf(__('Showing pictures %u to %u out of %u.', 'galleries'), $start + 1, $showmax, $num));
$tpl->assign('limit', $limit);
$tpl->assign('pag', $pactual);
//Fin de barra de navegación
$sql = str_replace("COUNT(*)", '*', $sql);
$sql .= " ORDER BY a.id_image ASC, a.modified DESC LIMIT {$start}, {$limit}";
$result = $db->query($sql);
while ($row = $db->fetchArray($result)) {
$img = new GSImage();
$img->assignVars($row);
$imglink = $user->userURL() . ($mc['urlmode'] ? 'img/' . $img->id() . '/set/' . $set->id() . '/' : '&img=' . $img->id() . '&set=' . $set->id());
$imgfile = $user->filesURL() . '/' . ($mc['set_format_mode'] ? 'formats/set_' : 'ths/') . $img->image();
// Conversion de los formatos
if (!$img->setFormat() && $mc['set_format_mode']) {
GSFunctions::resizeImage($crop, $user->filesPath() . '/' . $img->image(), $user->filesPath() . '/formats/set_' . $img->image(), $width, $height);
$img->setSetFormat(1, 1);
}
$tpl->append('images', array('id' => $img->id(), 'title' => $img->title(), 'thumbnail' => $imgfile, 'link' => $imglink, 'bigimage' => $user->filesURL() . '/' . $img->image()));
}
// Imagen grande del album
$sql = "SELECT * FROM {$tbl1} a, {$tbl2} b WHERE b.id_set='" . $set->id() . "' AND a.id_image=b.id_image {$public} AND owner='" . $user->uid() . "' \n\t\t\tORDER BY a.id_image DESC LIMIT 0,{$blimit}";
$result = $db->query($sql);
$bi = 0;
$tf = new RMTimeFormatter(0, __('%m%/%d%/%Y% %h%:%i%', 'galleries'));
// cremos la imagen grande para los albumes
while ($row = $db->fetchArray($result)) {
$img = new GSImage();
$img->assignVars($row);
if ($mc['set_format_mode'] && !$img->bigSetFormat()) {
GSFunctions::resizeImage($bcrop, $user->filesPath() . '/' . $img->image(), $user->filesPath() . '/formats/bigset_' . $img->image(), $bwidth, $bheight);
$img->setBigSetFormat(1, 1);
}
if ($mc['set_format_mode']) {
list($ancho, $altura, $tipo, $atr) = getimagesize($user->filesPath() . '/formats/bigset_' . $img->image());
$tpl->assign('big_width', $ancho);
}
$imglink = $user->userURL() . 'img/' . $img->id() . '/set/' . $set->id() . '/';
// ASignamos las imagenes grandes para los albumes
$imgfile = $user->filesURL() . '/' . ($mc['set_format_mode'] ? 'formats/bigset_' : 'ths/') . $img->image();
if ($bi == 0) {
$tpl->assign('lang_updated', sprintf(__('Updated on %s', 'galleries'), $tf->format($img->created())));
}
$tpl->append('bigs', array('id' => $img->id(), 'title' => $img->title(), 'image' => $imgfile, 'link' => $imglink));
}
RMFunctions::get_comments('galleries', 'set=' . $set->id());
// Comments form
RMFunctions::comments_form('galleries', 'set=' . $set->id(), 'module', GS_PATH . '/class/galleriescontroller.php');
// Datos para el formato
$tpl->assign('max_cols', $cols);
include 'footer.php';
}
function gs_sets_show($options)
{
global $xoopsUser, $xoopsModuleConfig;
$db = Database::getInstance();
$wo = '';
$tsets = $db->prefix("gs_sets");
$tfriends = $db->prefix("gs_friends");
$mc = RMUtilities::module_config('galleries');
$format = $mc['set_format_values'];
$crop = $format[0];
// 0 = Redimensionar, 1 = Cortar
$width = $format[1];
$height = $format[2];
if ($xoopsUser) {
$wo = "{$tsets}.owner='" . $xoopsUser->uid() . "' OR";
}
$sql = "SELECT * FROM {$tsets} WHERE owner='1' OR public='2' ORDER BY `date` DESC LIMIT 0,{$options['0']}";
$result = $db->query($sql);
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsset.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsuser.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsimage.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsfunctions.class.php';
$block = array();
$users = array();
$tf = new RMTimeFormatter(0, '%T% %d%, %Y%');
while ($row = $db->fetchArray($result)) {
$rtn = array();
$set = new GSSet();
$set->assignVars($row);
if (!isset($users[$set->owner()])) {
$users[$set->owner()] = new GSUser($set->owner(), 1);
}
// Si se ha seleccionado la opción para mostrar imágenes entonces...
if ($options[1]) {
//Obtenemos una imagen del album
$sql = "SELECT b.* FROM " . $db->prefix('gs_setsimages') . " a, " . $db->prefix('gs_images') . " b WHERE";
$sql .= " a.id_set='" . $set->id() . "' AND b.id_image=a.id_image AND b.public=2 AND b.owner='" . $set->owner() . "' ORDER BY b.created DESC LIMIT 0,1";
$resimg = $db->query($sql);
if ($db->getRowsNum($resimg) > 0) {
$rowimg = $db->fetchArray($resimg);
$img = new GSImage();
$img->assignVars($rowimg);
$urlimg = $users[$set->owner()]->filesURL() . '/' . ($mc['set_format_mode'] ? 'formats/set_' : 'ths/') . $img->image();
// Conversion de los formatos
if (!$img->setFormat() && $mc['set_format_mode']) {
GSFunctions::resizeImage($crop, $users[$set->owner()]->filesPath() . '/' . $img->image(), $users[$set->owner()]->filesPath() . '/formats/set_' . $img->image(), $width, $height);
$img->setSetFormat(1, 1);
}
} else {
$urlimg = '';
}
$rtn['img'] = $urlimg;
}
$rtn['id'] = $set->id();
$rtn['title'] = $set->title();
$rtn['owner'] = $set->owner();
$rtn['link'] = $users[$set->owner()]->userURL() . ($mc['urlmode'] ? 'set/' . $set->id() . '/' : '&set=' . $set->id());
if ($options[2]) {
$rtn['date'] = $tf->format($set->date());
$rtn['pics'] = $set->pics();
$rtn['uname'] = $set->uname();
$rtn['linkuser'] = $users[$set->owner()]->userURL();
}
$block['sets'][] = $rtn;
}
$block['showimg'] = $options[1];
$block['showinfo'] = $options[2];
$block['item_width'] = $options[3];
RMTemplate::get()->add_xoops_style('blocks.css', 'galleries');
RMTemplate::get()->add_local_script('blocks.js', 'galleries');
return $block;
}
/**
* @desc Visualiza todos los albumes existentes del usuario
**/
function showSets($edit = 0)
{
global $xoopsOption, $tpl, $db, $xoopsUser, $xoopsModuleConfig, $page, $xoopsConfig, $id;
$xoopsOption['template_main'] = 'gs_panel_sets.html';
include 'header.php';
$mc =& $xoopsModuleConfig;
$limit = rmc_server_var($_REQUEST, 'limit', 15);
GSFunctions::makeHeader();
$link = GSFunctions::get_url() . ($mc['urlmode'] ? '/cpanel/sets/pag/' . $page : '/cpanel.php?s=cpanel/sets/' . $page);
if ($edit) {
//Verificamos que el album sea válido
if ($id <= 0) {
redirect_header($link, 1, __('Album ID is not valid!', 'galleries'));
die;
}
//Verificamos que el album exista
$set = new GSSet($id);
if ($set->isNew()) {
redirect_header($link, 1, __('Specified album does not exists!', 'galleries'));
die;
}
$tpl->assign('title', $set->title());
$tpl->assign('public', $set->isPublic());
$tpl->assign('edit', $edit);
$tpl->assign('id', $id);
$tpl->assign('action_editset', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/saveeditset/pag/' . $page . '/' : '?cp=saveeditset&pag=' . $page));
}
//Barra de Navegación
$sql = "SELECT COUNT(*) FROM " . $db->prefix('gs_sets') . " WHERE owner='" . $xoopsUser->uid() . "'";
list($num) = $db->fetchRow($db->query($sql));
$page = $page <= 0 ? 1 : $page;
list($num) = $db->fetchRow($db->query($sql));
$start = $num <= 0 ? 0 : ($page - 1) * $limit;
$tpages = ceil($num / $limit);
$nav = new RMPageNav($num, $limit, $page, 5);
$nav->target_url(GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/sets/pag/{PAGE_NUM}/' : '?cp=sets&pag={PAGE_NUM}'));
//Fin de barra de navegación
$sql = "SELECT * FROM " . $db->prefix('gs_sets') . " WHERE owner='" . $xoopsUser->uid() . "'";
$sql .= " LIMIT {$start},{$limit}";
$result = $db->query($sql);
while ($rows = $db->fetchArray($result)) {
$set = new GSSet();
$set->assignVars($rows);
$tpl->append('sets', array('id' => $set->id(), 'name' => $set->title(), 'owner' => $set->owner(), 'uname' => $set->uname(), 'public' => $set->isPublic(), 'date' => formatTimeStamp($set->date(), 's'), 'pics' => $set->pics(), 'link' => $set->url()));
}
$tpl->assign('lang_setexists', __('My Albums', 'galleries'));
$tpl->assign('lang_id', __('ID', 'galleries'));
$tpl->assign('lang_name', __('Name', 'galleries'));
$tpl->assign('lang_date', __('Date', 'galleries'));
$tpl->assign('lang_public', __('Privacy:', 'galleries'));
$tpl->assign('lang_options', _OPTIONS);
$tpl->assign('lang_edit', _EDIT);
$tpl->assign('lang_del', _DELETE);
$tpl->assign('lang_confirm', __('Do you really wish to delete specified album?', 'galleries'));
$tpl->assign('lang_confirms', __('Do you really wish to delete selected albums?', 'galleries'));
$tpl->assign('lang_newset', __('Add Album', 'galleries'));
$tpl->assign('lang_editset', __('Edit Album', 'galleries'));
$tpl->assign('lang_yes', __('Yes', 'galleries'));
$tpl->assign('lang_no', __('No', 'galleries'));
$tpl->assign('lang_pics', __('Pictures', 'galleries'));
$tpl->assign('lang_privateme', __('Private', 'galleries'));
$tpl->assign('lang_privatef', __('Friends', 'galleries'));
$tpl->assign('lang_publicset', __('Public', 'galleries'));
RMTemplate::get()->add_style('panel.css', 'galleries');
$tpl->assign('action_addset', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/saveset/pag/' . $page . '/' : '?cp=saveset'));
$tpl->assign('pag', $page);
$tpl->assign('action_delset', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/deleteset/pag/' . $page . '/' : '?cp=deleteset'));
$tpl->assign('edit_link', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/editset/pag/' . $page . '/id/' : '?cp=editset&pag=' . $page . '&id='));
createLinks();
include 'footer.php';
}
/**
* @desc Visualiza todos los albumes existentes
**/
function sets()
{
global $tpl, $xoopsOption, $xoopsUser, $xoopsConfig, $xoopsModuleConfig, $db, $pag, $usr;
$mc =& $xoopsModuleConfig;
$xoopsOption['template_main'] = 'gs_sets.html';
$xoopsOption['module_subpage'] = 'exploresets';
include 'header.php';
//Verificamos si el usuario proporcionado existe
if ($usr) {
$owner = new GSUser($usr);
if ($owner->isNew()) {
redirect_header(GSFunctions::get_url(), 1, __('Specified user does not exists!', 'galleries'));
die;
}
}
GSFunctions::makeHeader();
//Verificamos si el usuario es dueño o amigo
if ($usr && $xoopsUser) {
if ($owner->uid() == $xoopsUser->uid()) {
$public = '';
} else {
if ($owner->isFriend($xoopsUser->uid())) {
$public = " WHERE public<>'0'";
} else {
$public = " WHERE public='2'";
}
}
} else {
$public = " WHERE public='2'";
}
//Barra de Navegación
$sql = "SELECT COUNT(*) FROM " . $db->prefix('gs_sets') . " {$public} ";
$sql .= isset($usr) ? ($public ? " AND " : " WHERE ") . " uname='" . $usr . "'" : '';
$page = isset($pag) ? $pag : '';
$limit = $mc['limit_sets'];
/**
* @desc Formato para el manejo de las imágenes
*/
if ($mc['set_format_mode']) {
$format = $mc['set_format_values'];
$crop = $format[0];
// 0 = Redimensionar, 1 = Cortar
$width = $format[1];
$height = $format[2];
$limit = $mc['limit_sets'];
$cols = $format[4];
$showdesc = @$format[5];
} else {
$limit = $mc['limit_sets'];
$cols = $mc['cols_sets'];
$showdesc = 0;
$width = $mc['image_ths'][0];
}
list($num) = $db->fetchRow($db->query($sql));
if ($page > 0) {
$page -= 1;
}
$start = $page * $limit;
$tpages = (int) ($num / $limit);
if ($num % $limit > 0) {
$tpages++;
}
$pactual = $page + 1;
if ($pactual > $tpages) {
$rest = $pactual - $tpages;
$pactual = $pactual - $rest + 1;
$start = ($pactual - 1) * $limit;
}
if ($tpages > 1) {
if ($mc['urlmode']) {
$urlnav = 'explore/sets/';
$urlnav .= isset($usr) ? 'usr/' . $usr . '/' : '';
} else {
$urlnav = '?explore=sets';
$urlnav .= isset($usr) ? '&usr='******'';
}
$nav = new RMPageNav($num, $limit, $pactual, 5);
$nav->target_url(GSFunctions::get_url() . $urlnav . ($mc['urlmode'] ? 'pag/{PAGE_NUM}/' : '&pag={PAGE_NUM}'));
$tpl->assign('setsNavPage', $nav->render(false));
}
$showmax = $start + $limit;
$showmax = $showmax > $num ? $num : $showmax;
$tpl->assign('lang_showing', sprintf(__('Albums %u to %u from %u', 'galleries'), $start + 1, $showmax, $num));
$tpl->assign('limit', $limit);
$tpl->assign('pag', $pactual);
//Fin de barra de navegación
$sql = "SELECT * FROM " . $db->prefix('gs_sets') . " {$public}";
$sql .= isset($usr) ? ($public ? " AND " : " WHERE ") . "uname='" . $usr . "'" : '';
$sql .= " ORDER BY date desc";
$sql .= " LIMIT {$start},{$limit}";
$result = $db->query($sql);
$users = array();
$tf = new RMTimeFormatter(0, __("%M% %d%, %Y%", 'galleries'));
while ($rows = $db->fetchArray($result)) {
$set = new GSSet();
$set->assignVars($rows);
//Obtenemos una imagen del album
$sql = "SELECT b.* FROM " . $db->prefix('gs_setsimages') . " a, " . $db->prefix('gs_images') . " b WHERE";
$sql .= " a.id_set='" . $set->id() . "' AND b.id_image=a.id_image AND b.public=2 AND b.owner='" . $set->owner() . "' ORDER BY b.created DESC LIMIT 0,1";
$resimg = $db->query($sql);
if (!isset($users[$set->owner()])) {
$users[$set->owner()] = new GSUser($set->owner(), 1);
}
if ($db->getRowsNum($resimg) > 0) {
$rowimg = $db->fetchArray($resimg);
$img = new GSImage();
$img->assignVars($rowimg);
$urlimg = $users[$set->owner()]->filesURL() . '/' . ($mc['set_format_mode'] ? 'formats/set_' : 'ths/') . $img->image();
// Conversion de los formatos
if (!$img->setFormat() && $mc['set_format_mode']) {
GSFunctions::resizeImage($crop, $users[$set->owner()]->filesPath() . '/' . $img->image(), $users[$set->owner()]->filesPath() . '/formats/set_' . $img->image(), $width, $height);
$img->setSetFormat(1, 1);
}
} else {
$urlimg = '';
}
$tpl->append('sets', array('id' => $set->id(), 'title' => $set->title(), 'date' => $tf->format($set->date()), 'owner' => $set->owner(), 'uname' => $set->uname(), 'pics' => $set->pics(), 'img' => $urlimg, 'link' => $users[$set->owner()]->userURL() . ($mc['urlmode'] ? 'set/' . $set->id() . '/' : '&set=' . $set->id()), 'linkuser' => $users[$set->owner()]->userURL()));
}
$tpl->assign('lang_date', __('Created on:', 'galleries'));
$tpl->assign('lang_by', __('Owned by:', 'galleries'));
$tpl->assign('margin', $width + 20);
$tpl->assign('lang_imgs', __('Images:', 'galleries'));
$tpl->assign('usr', isset($owner) ? 1 : 0);
$tpl->assign('lang_setsexist', __('Existing Albums', 'galleries'));
if (isset($owner)) {
$tpl->assign('user', array('id' => $owner->uid(), 'uname' => $owner->uname(), 'avatar' => RMEvents::get()->run_event('rmcommon.get.avatar', $owner->userVar('email'), 0, $owner->userVar('user_avatar'))));
$tpl->assign('lang_setsof', sprintf(__('Sets of %s', 'galleries'), $owner->uname()));
$tpl->assign('pics_link', GSFunctions::get_url() . ($mc['urlmode'] ? "usr/" . $owner->uname() . '/' : "?usr="******"explore/sets/usr/" . $owner->uname() . '/' : "?explore=sets&usr="******"explore/tags/usr/" . $owner->uname() . '/' : "?explore=tags&usr="******"cp/booksmarks/" : "?cp=bookmarks"));
}
include 'footer.php';
}
