/**
* @desc Formulario de creación/edición de usuarios
**/
function formUsers($edit = 0)
{
global $xoopsModule, $xoopsModuleConfig;
$mc =& $xoopsModuleConfig;
$id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;
$page = isset($_REQUEST['pag']) ? $_REQUEST['pag'] : '';
$limit = isset($_REQUEST['limit']) ? intval($_REQUEST['limit']) : 15;
$search = isset($_REQUEST['search']) ? $_REQUEST['search'] : '';
$ruta = "pag={$page}&search={$search}";
if ($edit) {
//Verificamos que el usuario sea válido
if ($id <= 0) {
redirectMsg('./users.php?' . $ruta, __('User id is not valid!', 'galleries'), 1);
die;
}
//Verificamos que el usuario exista
$user = new GSUser($id);
if ($user->isNew()) {
redirectMsg('./users.php?' . $ruta, __('Specified user does not exists!', 'galleries'), 1);
die;
}
}
GSFunctions::toolbar();
xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » <a href='./users.php'>" . __('Users management', 'galleries') . "</a> » " . ($edit ? __('Edit User', 'galleries') : __('New User', 'galleries')));
RMTemplate::get()->assign('xoops_pagetitle', $edit ? __('Edit User', 'galleries') : __('New User', 'galleries'));
xoops_cp_header();
$form = new RMForm($edit ? __('Edit User', 'galleries') : __('New User', 'galleries'), 'frmuser', 'users.php');
$form->addElement(new RMFormUser(__('Xoops User', 'galleries'), 'uid', 0, $edit ? array($user->uid()) : '', 30));
$ele = new RMFormText(__('Max Quota', 'galleries'), 'quota', 10, 10, $edit ? $user->quota() / 1024 / 1024 : $mc['quota']);
$ele->setDescription(__('This value determines the total disc quota to be used for user and must be specified in megabytes.', 'galleries'));
$form->addElement($ele, true);
$form->addElement(new RMFormYesno(__('Blocked', 'galleries'), 'block', $edit ? $user->blocked() : 0));
$form->addElement(new RMFormHidden('op', $edit ? 'saveedit' : 'save'));
$form->addElement(new RMFormHidden('id', $id));
$form->addElement(new RMFormHidden('page', $page));
$form->addElement(new RMFormHidden('search', $search));
$buttons = new RMFormButtonGroup();
$buttons->addButton('sbt', $edit ? __('Save Changes', 'galleries') : __('Create User', 'galleries'), 'submit');
$buttons->addButton('cancel', __('Cancel', 'galleries'), 'button', 'onclick="window.location=\'users.php?' . $ruta . '\'"');
$form->addElement($buttons);
$form->display();
xoops_cp_footer();
}
/**
* @desc Determina la página para la imágen especificada
*/
public function pageFromPic(GSImage &$pic, GSUser &$user, $set = 0)
{
global $xoopsModuleConfig;
$db =& Database::getInstance();
$mc =& $xoopsModuleConfig;
if ($pic->isNew()) {
return;
}
if ($set > 0) {
} else {
// Determinar en que págona se ubica la imágen
$result = $db->query("SELECT id_image FROM " . $db->prefix('gs_images') . " WHERE owner='" . $user->uid() . "' AND public='1' ORDER BY created DESC, modified DESC");
$num = $db->getRowsNum($result);
for ($i = 0; $i < $num; ++$i) {
list($cur_id) = $db->fetchRow($result);
// echo $cur_id."<br />";
if ($cur_id == $pic->id()) {
break;
}
}
++$i;
// we started at 0
$limit = $mc['user_format_mode'] ? $mc['user_format_values'][3] : $mc['limit_pics'];
return ceil($i / $limit);
}
}
/**
* Load images according to given parameters.
* Util for images inclusion
* @param int Set ID
* @param int Number of results per page
* @param
* @return array
*/
public function load_images($set, $limit, $page)
{
global $xoopsUser;
if ($set <= 0) {
return;
}
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/gstag.class.php';
$set = new GSSet($set);
if ($set->isNew()) {
return;
}
$user = new GSUser($set->owner());
if (!$set->ispublic()) {
if (!$xoopsUser || $xoopsUser->uid() != $set->owner()) {
return;
}
} else {
if (!$xoopsUser && $set->isPublic() == 1 && !$user->isFriend($xoopsUser->uid())) {
return;
}
}
//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'";
}
}
$db = XoopsDatabaseFactory::getDatabaseConnection();
$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() . "'";
list($num) = $db->fetchRow($db->query($sql));
$start = $page * $limit - $limit;
$sql = str_replace("COUNT(*)", '*', $sql);
$sql .= " ORDER BY a.id_image ASC, a.modified DESC LIMIT {$start}, {$limit}";
$result = $db->query($sql);
if ($db->getRowsNum($result) <= 0) {
return;
}
$ret['images'] = self::process_image_data($result);
$ret['total'] = $num;
$ret['start'] = $start;
$ret['limit'] = $limit;
$ret['current'] = $page;
$ret['set'] = array('id' => $set->id(), 'title' => $set->title(), 'link' => $set->url());
return $ret;
}
/**
* @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';
}
/**
* @desc Visualiza todas las imágenes de la etiqueta especificada
**/
function imgsTag()
{
global $tpl, $xoopsOption, $xoopsUser, $xoopsConfig, $xoopsModuleConfig, $db, $page, $tag, $usr, $hits;
$xoopsOption['template_main'] = 'gs_imagestag.html';
$xoopsOption['module_subpage'] = 'exploretags';
include 'header.php';
$mc =& $xoopsModuleConfig;
GSFunctions::makeHeader();
//Verificamos si la etiqueta existe
$tag = new GSTag($tag);
if ($tag->isNew()) {
redirect_header(GSFunctions::get_url(), 1, __('Specified tag does not exists!', 'galleries'));
die;
}
//Incrementamos el número de hits de la etiqueta
if (!isset($_SESSION['vtags'])) {
$tag->addHit();
$_SESSION['vtags'] = array($tag->id());
} elseif (!in_array($tag->id(), $_SESSION['vtags'])) {
$tag->addHit();
$_SESSION['vtags'][] = $tag->id();
}
//Verificamos si el usuario existe
if (isset($usr)) {
$user = new GSUser($usr);
if ($user->isNew()) {
redirect_header(GSFunctions::get_url(), 1, __('Specified user does not exists!', 'galleries'));
die;
}
$users[$user->uid()] = $user;
}
//Barra de Navegación
$sql = "SELECT COUNT(*) FROM " . $db->prefix('gs_tagsimages') . " a INNER JOIN " . $db->prefix('gs_images');
$sql .= " b ON (a.id_tag=" . $tag->id() . " AND a.id_image=b.id_image AND b.public=2";
$sql .= $usr ? " AND b.owner=" . $user->uid() . ") " : ")";
$limit = $xoopsModuleConfig['num_imgstags'];
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/tags/tag/' . $tag->getVar('nameid') . '/';
$urlnav .= $usr ? 'usr/' . $user->uname() . '/' : '';
} else {
$urlnav = '?xplore=tags&tag=' . $tag->getVar('nameid');
$urlnav .= $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('tagsNavPage', $nav->render(false));
}
$showmax = $start + $limit;
$showmax = $showmax > $num ? $num : $showmax;
$tpl->assign('lang_showing', sprintf(__('Showing photos %u to %u from %u.', 'galleries'), $start + 1, $showmax, $num));
$tpl->assign('limit', $limit);
$tpl->assign('pag', $pactual);
//Fin de barra de navegación
//Obtenemos las imágenes pertenecientes a la etiqueta
$sql = "SELECT b.* FROM " . $db->prefix('gs_tagsimages') . " a INNER JOIN " . $db->prefix('gs_images');
$sql .= " b ON (a.id_tag=" . $tag->id() . " AND a.id_image=b.id_image AND b.public=2";
$sql .= $usr ? " AND b.owner=" . $user->uid() . ") " : ")";
$sql .= " GROUP BY b.id_image";
$sql .= " ORDER BY `created` DESC LIMIT {$start}, {$limit}";
$result = $db->query($sql);
$tpl->assign('images', GSFunctions::process_image_data($result));
$tpl->assign('lang_picstag', $usr ? sprintf(__('%s: tagged as %s', 'galleries'), $user->uname(), $tag->tag()) : sprintf(__('Images tagged as "%s"', 'galleries'), $tag->tag()));
$tpl->assign('tagname', $tag->tag());
$tpl->assign('usr', $usr);
if ($usr) {
$tpl->assign('pics_link', GS_URL . '/' . ($mc['urlmode'] ? "usr/" . $user->uname() : "user.php?id=usr/" . $user->uname() . "/"));
$tpl->assign('tags_link', GS_URL . '/' . ($mc['urlmode'] ? "explore/tags/usr/" . $user->uname() . "/" : "explore.php?by=explore/tags/usr/" . $user->uname() . "/"));
$tpl->assign('sets_link', GS_URL . '/' . ($mc['urlmode'] ? "explore/sets/usr/" . $user->uname() . "/" : "explore.php?by=explore/sets/usr/" . $user->uname() . "/"));
$tpl->assign('bmark_link', GS_URL . '/' . ($mc['urlmode'] ? "cpanel/booksmarks/" : "cpanel.php?s=cpanel/bookmarks"));
}
include 'footer.php';
}
