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 Realiza una búsqueda en el módulo desde EXM
*/
function gsSearch($queryarray, $andor, $limit, $offset, $userid)
{
global $db, $myts;
include_once XOOPS_ROOT_PATH . "/modules/galleries/class/gsimage.class.php";
include_once XOOPS_ROOT_PATH . "/modules/galleries/class/gsuser.class.php";
$mc = RMUtilities::get()->module_config('galleries');
$db = XoopsDatabaseFactory::getDatabaseConnection();
$sql = "SELECT DISTINCT c.* FROM " . $db->prefix('gs_tags') . " a INNER JOIN " . $db->prefix('gs_tagsimages') . " b INNER JOIN ";
$sql .= $db->prefix('gs_images') . " c ON (";
$sql .= "a.id_tag=b.id_tag AND b.id_image=c.id_image AND c.public=2 AND (";
$sql1 = '';
foreach ($queryarray as $k) {
$sql1 .= ($sql1 == '' ? "" : "{$andor}") . " (a.tag LIKE '%{$k}%' OR c.title LIKE '%{$k}%') ";
}
$sql1 .= "))";
$sql1 .= " ORDER BY c.created DESC LIMIT {$offset}, {$limit}";
$result = $db->queryF($sql . $sql1);
$ret = array();
$users = array();
while ($row = $db->fetchArray($result)) {
$img = new GSImage();
$img->assignVars($row);
if (!isset($users[$img->owner()])) {
$users[$img->owner()] = new GSUser($img->owner(), 1);
}
$rtn = array();
$rtn['image'] = 'images/images.png';
$link = $mc['urlmode'] ? "usr/" . $users[$img->owner()]->uname() . "/img/" . $img->id() : "user.php?id=" . "usr/" . $users[$img->owner()]->uname() . "/img/" . $img->id();
$rtn['title'] = $img->title();
$rtn['time'] = $img->created();
$rtn['uid'] = $img->owner();
$rtn['desc'] = $img->desc();
$rtn['link'] = $link;
$ret[] = $rtn;
}
return $ret;
}
/**
* Get image data
*/
public function process_image_data($result)
{
$mc = RMUtilities::module_config('galleries');
$users = array();
$ret = array();
$tf = new RMTimeFormatter(0, "%M%/%d%/%Y%");
$db = Database::getInstance();
$i = 0;
while ($row = $db->fetchArray($result)) {
$img = new GSImage();
$img->assignVars($row);
if (!isset($users[$img->owner()])) {
$users[$img->owner()] = new GSUser($img->owner(), 1);
}
$imglink = $users[$img->owner()]->userURL() . ($mc['urlmode'] ? 'img/' . $img->id() . '/' : '&img=' . $img->id());
$ret[$i] = array('id' => $img->id(), 'title' => $img->title(), 'thumbnail' => $users[$img->owner()]->filesURL() . '/ths/' . $img->image(), 'thumbuser' => $users[$img->owner()]->filesURL() . '/' . ($mc['user_format_mode'] ? 'formats/user_' : 'ths/') . $img->image(), 'thumbsrh' => $users[$img->owner()]->filesURL() . '/' . ($mc['search_format_mode'] ? 'formats/srh_' : 'ths/') . $img->image(), 'image' => $users[$img->owner()]->filesURL() . '/' . $img->image(), 'by' => sprintf(__('by %s', 'galleries'), '<a href="' . $users[$img->owner()]->userUrl() . '">' . $users[$img->owner()]->uname() . '</a>'), 'link' => $imglink, 'created' => $tf->format($img->created()), 'public' => $img->isPublic(), 'desc' => $img->desc());
// Format resize
if (!$img->userFormat() && $mc['user_format_mode']) {
$format = $mc['user_format_values'];
GSFunctions::resizeImage($format[0], $users[$img->owner()]->filesPath() . '/' . $img->image(), $users[$img->owner()]->filesPath() . '/formats/user_' . $img->image(), $format[1], $format[2]);
$img->setUserFormat(1, 1);
}
if (!$img->searchFormat() && $mc['search_format_mode']) {
$format = $mc['search_format_values'];
GSFunctions::resizeImage($format[0], $users[$img->owner()]->filesPath() . '/' . $img->image(), $users[$img->owner()]->filesPath() . '/formats/srh_' . $img->image(), $format[1], $format[2]);
$img->setSearchFormat(1, 1);
}
if ($mc['search_format_mode']) {
$ret[$i]['viewmore'] = sprintf(__('Ver <a href="%s">más fotos</a>.', 'galleries'), $users[$img->owner()]->userURL());
$ret[$i]['avatar'] = RMEvents::get()->run_event('rmcommon.get.avatar', $users[$img->owner()]->userVar('email'), 0, $users[$img->owner()]->userVar('user_avatar'));
$tags = $img->tags(true);
$tagurl = self::get_url() . ($mc['urlmode'] ? 'explore/tags/tag/' : '?explore=tags&tag=');
$strtag = '';
foreach ($tags as $tag) {
$strtag .= $strtag == '' ? "<a href=\"{$tagurl}" . $tag->getVar('nameid') . "\">" . $tag->tag() . "</a>" : ", <a href=\"{$tagurl}" . $tag->getVar('nameid') . "\">" . $tag->tag() . "</a>";
}
$ret[$i]['tags'] = $strtag;
}
$i++;
}
RMTemplate::get()->add_local_script('photos.js', 'galleries');
if (!$mc['quickview']) {
return $ret;
}
if (RMFunctions::plugin_installed('lightbox')) {
RMLightbox::get()->add_element('.pic_qview a');
RMLightbox::get()->render();
}
return $ret;
}
$rss_channel['lastbuild'] = formatTimestamp(time(), 'rss');
$rss_channel['webmaster'] = checkEmail($xoopsConfig['adminmail'], true);
$rss_channel['editor'] = checkEmail($xoopsConfig['adminmail'], true);
$rss_channel['category'] = __('Pictures', 'galleries');
$rss_channel['generator'] = 'MyGalleries 3';
$rss_channel['language'] = RMCLANG;
$users = array();
$rss_items = array();
while ($row = $db->fetchArray($result)) {
$img = new GSImage();
$img->assignVars($row);
if (!isset($users[$img->owner()])) {
$users[$img->owner()] = new GSUser($img->owner(), 1);
}
$imglink = $users[$img->owner()]->userURL() . ($mc['urlmode'] ? 'img/' . $img->id() . '/' : '&img=' . $img->id());
$desc = '<a href="' . $imglink . '"><img src="' . $users[$img->owner()]->filesURL() . '/ths/' . $img->image() . '" alt="' . $img->title() . '" /></a><br />' . ($img->desc() != '' ? $img->desc() . '<br />' : '');
$desc .= sprintf(__('By: <strong>%s</strong>', 'galleries'), $users[$img->owner()]->uname());
$item = array();
$item['title'] = $img->title();
$item['link'] = $imglink;
$item['description'] = XoopsLocal::convert_encoding(htmlspecialchars($desc, ENT_QUOTES));
$item['pubdate'] = formatTimestamp($img->created(), 'rss');
$item['guid'] = $imglink;
$rss_items[] = $item;
}
break;
case 'albums':
$rss_channel['title'] = $xoopsModule->name();
$rss_channel['link'] = GSFunctions::get_url();
$rss_channel['description'] = __('These are the recent albums created on our galleries.', 'galleries');
$rss_channel['lastbuild'] = formatTimestamp(time(), 'rss');
/**
* @desc Mostramos los detalles de una imágen
*/
function showImageDetails()
{
global $usr, $set, $img, $db, $xoopsModule, $mc, $xoopsModuleConfig, $xoopsConfig, $xoopsUser, $xoopsOption, $tpl;
$user = new GSUser($usr);
if ($user->isNew()) {
redirect_header(GSFunctions::get_url(), 0, __('Specified user does not exists!', 'galleries'));
die;
}
$image = new GSImage($img);
if ($image->isNew()) {
redirect_header(GSFunctions::get_url(), 0, __('Specified image does not exists!', 'galleries'));
die;
}
$user = new GSUser($image->owner(), 1);
//Verificamos la privacidad de la imagen
if (!$image->isPublic()) {
//Privada, Verificamos si el usuario es el dueño de la imagen
if (!$xoopsUser || $xoopsUser->uid() != $image->owner()) {
redirect_header(GSFunctions::get_url(), 1, __('You can not view this image!', 'galleries'));
die;
}
} else {
if ($image->isPublic() == 1) {
//Privada y amigos
if (!$xoopsUser || $xoopsUser->uid() != $image->owner()) {
//Verificamos si es un amigo
if (!$xoopsUser || !$user->isFriend($xoopsUser->uid())) {
redirect_header(GSFunctions::get_url(), 1, __('You are not authorized to view this image!', 'galleries'));
die;
}
}
}
}
//Incrementamos las vistas de la imagen
$image->addViews();
if (isset($set)) {
$set = new GSSet($set);
if ($set->isNew()) {
redirect_header(GSFunctions::get_url(), 0, __('Specified album does not exists!', 'galleries'));
die;
}
}
if ($image->desc() != '') {
global $xoTheme;
$xoTheme->addMeta('meta', 'description', $image->desc());
}
$xoopsOption['template_main'] = 'gs_imgdetails.html';
$xoopsOption['module_subpage'] = 'picsdetails';
include 'header.php';
GSFunctions::makeHeader();
$tpl->assign('user', array('id' => $user->id(), 'uname' => $user->uname(), 'link' => $user->userURL(), 'avatar' => $user->userVar('user_avatar') != '' ? XOOPS_URL . '/uploads/avatars/' . $user->userVar('user_avatar') : GS_URL . '/images/avatar.png'));
$tpl->assign('user_link', $user->userURL());
$tpl->assign('lang_alsobelong', __('Also belongs to:', 'galleries'));
$tpl->assign('lang_postcards', __('Send postcard', 'galleries'));
$tpl->assign('lang_bookmark', __('+ Bookmark', 'galleries'));
$tpl->assign('lang_photos', __('Pictures', 'galleries'));
$tpl->assign('lang_toset', __('+ to Album', 'galleries'));
$tpl->assign('lang_lastpic', __('This is the last picture', 'galleries'));
$tpl->assign('lang_firstpic', __('This is the first picture', 'galleries'));
$tpl->assign('toset_link', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/toset/ids/' . $image->id() . '/referer/' . base64_encode(RMFunctions::current_url()) . '/' : '?cp=toset&ids=' . $image->id() . '&referer=' . base64_encode(RMFunctions::current_url())));
$tpl->assign('edit_link', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/edit/id/' . $image->id() . '/referer/' . base64_encode(RMFunctions::current_url()) . '/' : '?cp=edit&id=' . $image->id() . '&referer=' . base64_encode(RMFunctions::current_url())));
$tpl->assign('bookmark_link', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/bookmarks/add/' . $image->id() . '/referer/' . base64_encode($_SERVER['REQUEST_URI']) : '?cpanel=bookmarks&add=' . $image->id() . '&referer=' . base64_encode($_SERVER['REQUEST_URI'])));
$tpl->assign('postcard_link', GSFunctions::get_url() . ($mc['urlmode'] ? 'postcard/new/img/' . $image->id() . '/' : '?postcard=new&img=' . $image->id()));
$tpl->assign('delete_link', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/delete/referer/' . base64_encode(RMFunctions::current_url()) . '/ids/' : '?cpanel=delete&referer=' . base64_encode(RMFunctions::current_url()) . '&ids='));
$tpl->assign('lang_confirmdel', sprintf(__('Dow you really want to delete this picture?\\n(%s)', 'galleries'), $image->title()));
if ($xoopsUser && $xoopsUser->uid() == $image->owner()) {
$tpl->assign('lang_edit', __('Edit', 'galleries'));
$tpl->assign('lang_delete', __('Delete', 'galleries'));
$tpl->assign('isowner', 1);
}
$tpl->assign('postcards', $mc['postcards']);
$data = getimagesize($user->filesURL() . '/' . $image->image());
$tpl->assign('image', array('title' => $image->title(), 'id' => $image->id(), 'file' => $user->filesURL() . '/' . $image->image(), 'desc' => $image->desc(), 'width' => $data[0] + 2, 'height' => $data[1] + 2));
unset($data);
//Verificamos si el usuario es dueño o amigo
if ($xoopsUser && $xoopsUser->uid() == $user->uid()) {
$public = '';
} else {
if ($xoopsUser && $user->isFriend($xoopsUser->uid())) {
$public = " AND public<>'0'";
} else {
$public = " AND public='2'";
}
}
// Imágenes anterior y siguiente
if (!isset($set)) {
// Navigation as images
if ($xoopsModuleConfig['navimages']) {
$limit_n = $xoopsModuleConfig['navimages_num'];
$limit_p = $xoopsModuleConfig['navimages_num'];
// Count images
$sql = "SELECT * FROM " . $db->prefix("gs_images") . " WHERE id_image>'" . $image->id() . "' AND owner='" . $user->uid() . "' {$public} ORDER BY id_image ASC LIMIT 0," . $xoopsModuleConfig['navimages_num'];
$resultn = $db->query($sql);
if ($db->getRowsNum($resultn) < $xoopsModuleConfig['navimages_num']) {
$limit_p = $limit_p + ($xoopsModuleConfig['navimages_num'] - $db->getRowsNum($resultn));
}
$sql = "SELECT * FROM " . $db->prefix("gs_images") . " WHERE id_image<'" . $image->id() . "' AND owner='" . $user->uid() . "' {$public} ORDER BY id_image DESC, created DESC LIMIT 0," . $limit_p;
$resultp = $db->query($sql);
if ($db->getRowsNum($resultp) < $xoopsModuleConfig['navimages_num']) {
$limit_n = $limit_n + ($xoopsModuleConfig['navimages_num'] - $db->getRowsNum($resultp));
}
if ($limit_n > $db->getRowsNum($resultn) && $limit_p == $xoopsModuleConfig['navimages_num']) {
$sql = "SELECT * FROM " . $db->prefix("gs_images") . " WHERE id_image>'" . $image->id() . "' AND owner='" . $user->uid() . "' {$public} ORDER BY id_image ASC LIMIT 0," . $limit_n;
$resultn = $db->query($sql);
}
// Previous Images
while ($row = $db->fetchArray($resultp)) {
$pn = new GSImage();
$pn->assignVars($row);
$previous_images[] = array('link' => $user->userURL() . ($xoopsModuleConfig['urlmode'] ? 'img/' . $pn->id() . '/' : '&img=' . $pn->id()), 'id' => $pn->id(), 'title' => $pn->title(), 'file' => $user->filesURL() . '/ths/' . $pn->image());
}
// Next Images
while ($row = $db->fetchArray($resultn)) {
$pn = new GSImage();
$pn->assignVars($row);
$next_images[] = array('link' => $user->userURL() . ($xoopsModuleConfig['urlmode'] ? 'img/' . $pn->id() . '/' : '&img=' . $pn->id()), 'id' => $pn->id(), 'title' => $pn->title(), 'file' => $user->filesURL() . '/ths/' . $pn->image());
}
}
$tpl->assign('prevnext_title', sprintf(__('Pictures of %s'), $user->uname()));
$tpl->assign('xoops_pagetitle', $image->title() . ' » ' . sprintf(__('Pictures of %s'), $user->uname()) . ' » ' . $xoopsModuleConfig['section_title']);
$tpl->assign('title_link', $user->userURL());
$result = $db->query("SELECT COUNT(*) FROM " . $db->prefix("gs_images") . " WHERE owner='" . $user->uid() . "' {$public}");
list($num) = $db->fetchRow($result);
$tpl->assign('pics_count', $num);
// Tambien pertenece
$tbl1 = $db->prefix("gs_sets");
$tbl2 = $db->prefix("gs_setsimages");
$sql = "SELECT a.* FROM {$tbl1} a, {$tbl2} b WHERE b.id_image='" . $image->id() . "' AND a.id_set=b.id_set";
$result = $db->query($sql);
while ($row = $db->fetchArray($result)) {
$oset = new GSSet();
$oset->assignVars($row);
//Verificamos la privacidad del album
if (!$oset->ispublic()) {
if (!$xoopsUser) {
continue;
}
if ($xoopsUser->uid() != $oset->owner()) {
continue;
}
} else {
if (!$xoopsUser && $oset->isPublic() == 1 && !$user->isFriend($xoopsUser->uid())) {
continue;
}
}
$tpl->append('sets', array('id' => $oset->id(), 'title' => $oset->title(), 'link' => $user->userURL() . ($xoopsModuleConfig['urlmode'] ? 'set/' . $oset->id() . '/' : '&set=' . $oset->id())));
}
} else {
// Imágen Siguiente
$tbl1 = $db->prefix("gs_images");
$tbl2 = $db->prefix("gs_setsimages");
// Navigation as images
if ($xoopsModuleConfig['navimages']) {
$limit_n = $xoopsModuleConfig['navimages_num'];
$limit_p = $xoopsModuleConfig['navimages_num'];
// Count images
$sql = "SELECT a.* FROM {$tbl1} a, {$tbl2} b WHERE b.id_set='" . $set->id() . "' AND a.id_image=b.id_image AND a.id_image>'" . $image->id() . "' AND a.owner='" . $user->uid() . "' {$public} ORDER BY a.id_image ASC LIMIT 0," . $xoopsModuleConfig['navimages_num'];
$resultn = $db->query($sql);
if ($db->getRowsNum($resultn) < $xoopsModuleConfig['navimages_num']) {
$limit_p = $limit_p + ($xoopsModuleConfig['navimages_num'] - $db->getRowsNum($resultn));
}
$sql = "SELECT a.* FROM {$tbl1} a, {$tbl2} b WHERE b.id_set='" . $set->id() . "' AND a.id_image=b.id_image AND a.id_image<'" . $image->id() . "' AND a.owner='" . $user->uid() . "' {$public} ORDER BY a.id_image DESC LIMIT 0,{$limit_p}";
$resultp = $db->query($sql);
if ($db->getRowsNum($resultp) < $xoopsModuleConfig['navimages_num']) {
$limit_n = $limit_n + ($xoopsModuleConfig['navimages_num'] - $db->getRowsNum($resultp));
}
if ($limit_n > $db->getRowsNum($resultn) && $limit_p == $xoopsModuleConfig['navimages_num']) {
$sql = "SELECT a.* FROM {$tbl1} a, {$tbl2} b WHERE b.id_set='" . $set->id() . "' AND a.id_image=b.id_image AND a.id_image>'" . $image->id() . "' AND a.owner='" . $user->uid() . "' {$public} ORDER BY a.id_image ASC LIMIT 0," . $limit_n;
$resultn = $db->query($sql);
}
// Previous Images
while ($row = $db->fetchArray($resultp)) {
$pn = new GSImage();
$pn->assignVars($row);
$previous_images[] = array('link' => $user->userURL() . ($xoopsModuleConfig['urlmode'] ? 'img/' . $pn->id() . '/set/' . $set->id() . '/' : '&img=' . $pn->id() . '&set=' . $set->id()), 'id' => $pn->id(), 'title' => $pn->title(), 'file' => $user->filesURL() . '/ths/' . $pn->image());
}
// Next Images
while ($row = $db->fetchArray($resultn)) {
$pn = new GSImage();
$pn->assignVars($row);
$next_images[] = array('link' => $user->userURL() . ($xoopsModuleConfig['urlmode'] ? 'img/' . $pn->id() . '/set/' . $set->id() . '/' : '&img=' . $pn->id() . '&set=' . $set->id()), 'id' => $pn->id(), 'title' => $pn->title(), 'file' => $user->filesURL() . '/ths/' . $pn->image());
}
}
$tpl->assign('prevnext_title', sprintf(__('Pictures in %s', 'galleries'), $set->title()));
$tpl->assign('xoops_pagetitle', $image->title() . ' » ' . sprintf(__('Pictures in %s'), $set->title()) . ' » ' . $xoopsModuleConfig['section_title']);
$tpl->assign('title_link', $user->userURL() . ($xoopsModuleConfig['urlmode'] ? 'set/' . $set->id() . '/' : '&set=' . $set->id()));
$result = $db->query("SELECT COUNT(*) FROM {$tbl1} a, {$tbl2} b WHERE b.id_set='" . $set->id() . "' AND a.id_image=b.id_image AND a.owner='" . $user->uid() . "' {$public}");
list($num) = $db->fetchRow($result);
$tpl->assign('pics_count', $num);
// Tambien pertenece
$tbl1 = $db->prefix("gs_sets");
$sql = "SELECT a.* FROM {$tbl1} a, {$tbl2} b WHERE b.id_set<>'" . $set->id() . "' AND b.id_image='" . $image->id() . "' AND a.id_set=b.id_set";
$result = $db->query($sql);
$tpl->append('sets', array('id' => 0, 'title' => sprintf(__('Galleries of %s', 'galleries'), $user->uname()), 'link' => $user->userURL()));
while ($row = $db->fetchArray($result)) {
$oset = new GSSet();
$oset->assignVars($row);
//Verificamos la privacidad del album
if (!$oset->ispublic()) {
if (!$xoopsUser) {
continue;
}
if ($xoopsUser->uid() != $oset->owner()) {
continue;
}
} else {
if (!$xoopsUser && $oset->isPublic() == 1 && !$user->isFriend($xoopsUser->uid())) {
continue;
}
}
$tpl->append('sets', array('id' => $oset->id(), 'title' => $oset->title(), 'link' => $user->userURL() . 'set/' . $oset->id(), '/'));
}
}
if (!empty($previous_images)) {
$tpl->assign('prev', $previous_images[0]);
$tpl->assign('previous_images', array_reverse($previous_images));
} else {
$tpl->assign('is_first', 1);
}
if (!empty($next_images)) {
$tpl->assign('next', $next_images[0]);
$tpl->assign('next_images', $next_images);
} else {
$tpl->assign('is_last', 1);
}
$tpl->assign('current_image', array('title' => $image->title(), 'file' => $user->filesURL() . '/ths/' . $image->image()));
// Etiquetas
$tags = $image->tags(true, '*');
$link = GSFunctions::get_url() . ($mc['urlmode'] ? 'explore/tags/tag/' : "?explore=tags&tag=");
foreach ($tags as $tag) {
$tpl->append('tags', array('id' => $tag->id(), 'tag' => $tag->tag(), 'link' => $link . $tag->getVar('nameid')));
}
// Comentarios
$tpl->assign('users_link', GSFunctions::get_url() . ($mc['urlmode'] ? 'usr/' : '?usr='******'galleries', 'image=' . $image->id());
// Comments form
RMFunctions::comments_form('galleries', 'image=' . $image->id(), 'module', GS_PATH . '/class/galleriescontroller.php');
include 'footer.php';
}
/**
* @desc Visualiza todas la imágenes de favoritos
**/
function showBookMarks()
{
global $xoopsOption, $tpl, $db, $xoopsUser, $xoopsModuleConfig, $pag, $xoopsConfig;
$xoopsOption['template_main'] = 'gs_panel_bookmarks.html';
include 'header.php';
$mc =& $xoopsModuleConfig;
GSFunctions::makeHeader();
//Barra de Navegación
$sql = "SELECT COUNT(*) FROM " . $db->prefix('gs_favourites') . " a INNER JOIN " . $db->prefix('gs_images') . " b ON (";
$sql .= " a.id_image=b.id_image AND a.uid='" . $xoopsUser->uid() . "')";
$page = isset($pag) ? $pag : '';
$limit = 10;
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 = 'cpanel/bookmarks/';
} else {
$urlnav = '?cpanel=bookmarks';
}
$nav = new RMPageNav($num, $limit, $pactual, 5);
$nav->target_url(GSFunctions::get_url() . $urlnav . ($mc['urlmode'] ? 'pag/{PAGE_NUM}/' : '&pag={PAGE_NUM}'));
$tpl->assign('bookmarksNavPage', $nav->render(false));
}
$showmax = $start + $limit;
$showmax = $showmax > $num ? $num : $showmax;
if ($num > 0) {
$tpl->assign('lang_showing', sprintf(__('Showing pictures %u to %u from %u'), $start + 1, $showmax, $num));
}
$tpl->assign('limit', $limit);
$tpl->assign('pag', $pactual);
//Fin de barra de navegación
$sql = "SELECT * FROM " . $db->prefix('gs_favourites') . " a INNER JOIN " . $db->prefix('gs_images') . " b ON (";
$sql .= " a.id_image=b.id_image AND a.uid='" . $xoopsUser->uid() . "')";
$sql .= " LIMIT {$start},{$limit}";
$result = $db->query($sql);
$users = array();
while ($rows = $db->fetchArray($result)) {
$img = new GSImage();
$img->assignVars($rows);
if (!isset($users[$img->owner()])) {
$users[$img->owner()] = new GSUser($img->owner(), 1);
}
$urlimg = $users[$img->owner()]->filesURL() . '/ths/' . $img->image();
$link = $users[$img->owner()]->userURL() . 'img/' . $img->id() . '/';
$tpl->append('images', array('id' => $img->id(), 'title' => $img->title(false), 'desc' => $img->desc(), 'public' => $img->isPublic(), 'image' => $urlimg, 'created' => formatTimeStamp($img->created(), 's'), 'owner' => $img->owner(), 'uname' => $users[$img->owner()]->uname(), 'link' => $link));
}
$tpl->assign('lang_exist', __('Existing Bookmarks', 'galleries'));
$tpl->assign('lang_id', __('ID', 'galleries'));
$tpl->assign('lang_title', __('Title', 'galleries'));
$tpl->assign('lang_date', __('Created', 'galleries'));
$tpl->assign('lang_owner', __('by user', 'galleries'));
$tpl->assign('lang_image', __('Picture', 'galleries'));
$tpl->assign('lang_public', __('Public', 'galleries'));
$tpl->assign('lang_options', __('Options', 'galleries'));
$tpl->assign('lang_edit', __('Edit', 'galleries'));
$tpl->assign('lang_del', __('Delete', 'galleries'));
$tpl->assign('lang_confirm', __('Do you really wish to deleted selected favorite?', 'galleries'));
$tpl->assign('lang_confirms', __('Do you really wish to deleted selected favorites?', 'galleries'));
$tpl->assign('delete_link', GSFunctions::get_url() . $xoopsModuleConfig['urlmode'] ? 'cp/delbookmarks/' : '?cp=delbookmarks');
RMTemplate::get()->add_style('panel.css', 'galleries');
createLinks();
include 'footer.php';
}
/**
* @desc Formulario de creación/edición de imágenes
**/
function formImages($edit = 0)
{
global $xoopsModule, $mc, $xoopsUser, $db;
$id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;
$page = isset($_REQUEST['page']) ? $_REQUEST['page'] : 1;
$limit = isset($_REQUEST['limit']) ? intval($_REQUEST['limit']) : 10;
$search = isset($_REQUEST['search']) ? $_REQUEST['search'] : '';
$owner = isset($_REQUEST['owner']) ? $_REQUEST['owner'] : '';
$uid = isset($_REQUEST['uid']) ? intval($_REQUEST['uid']) : 0;
$sort = isset($_REQUEST['sort']) ? $_REQUEST['sort'] : 'created';
$mode = isset($_REQUEST['mode']) ? $_REQUEST['mode'] : 0;
$ruta = "page={$page}&limit={$limit}&search={$search}&owner={$owner}&sort={$sort}&mode={$mode}";
if ($edit) {
//Verificamos si la imagen es válida
if ($id <= 0) {
redirectMsg('./images.php?' . $ruta, __('Image ID not valid!', 'galleries'), 1);
die;
}
//Verificamos si la imagen existe
$img = new GSImage($id);
if ($img->isNew()) {
redirectMsg('./images.php?' . $ruta, __('Specified image does not exists!', 'galleries'), 1);
die;
}
}
GSFunctions::toolbar();
xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » <a href='./images.php'>" . __('Images', 'galleries') . "</a> » " . ($edit ? __('Edit image', 'galleries') : __('Add image', 'galleries')));
xoops_cp_header();
$form = new RMForm($edit ? __('Editing image', 'galleries') : __('Add image', 'galleries'), 'frmimg', 'images.php');
$form->setExtra("enctype='multipart/form-data'");
if (!$edit) {
$ele = new RMFormUser(__('User', 'galleries'), 'uid', 0, $uid ? array($uid) : ($edit ? array($img->owner()) : array($xoopsUser->uid())), 50);
$ele->onChange("\$('op').value='" . ($edit ? 'edit' : 'new') . "'; \$('frmimg').submit();");
$form->addElement($ele);
} else {
$xu = new XoopsUser($img->owner());
$form->addElement(new RMFormLabel(__('User', 'galleries'), $xu->uname()));
$form->addElement(new RMFormHidden('uid', $img->owner()));
}
$form->addElement(new RMFormText(__('Title', 'galleries'), 'title', 50, 100, $edit ? $img->title() : ''));
$form->addElement(new RMFormFile(__('Image file', 'galleries'), 'image', 45, $mc['size_image'] * 1024));
if ($edit) {
$user = new GSUser($img->owner(), 1);
$url = $user->filesURL();
$form->addElement(new RMFormLabel(__('Current image', 'galleries'), "<img src='" . $url . "/ths/" . $img->image() . "' />"));
}
$form->addElement(new RMFormTextArea(__('Description', 'galleries'), 'desc', 4, 50, $edit ? $img->desc() : ''));
$ele = new RMFormSelect(__('Privacy', 'galleries'), 'public');
$ele->addOption(0, __('Private', 'galleries'), $edit ? $img->isPublic() == 0 ? 1 : 0 : 0);
$ele->addOption(1, __('Visible for friends', 'galleries'), $edit ? $img->isPublic() == 1 ? 1 : 0 : 0);
$ele->addOption(2, __('Visible for all', 'galleries'), $edit ? $img->isPublic() == 2 ? 1 : 0 : 1);
$form->addElement($ele, true);
$db = Database::getInstance();
//Albumes
if ($edit) {
$albums = $img->sets(false);
foreach ($albums as $k => $v) {
$sets[] = $v['id_set'];
}
}
$ele = new RMFormSelect(__('Albums', 'galleries'), 'albums[]', 1, $edit ? $sets : '');
$sql = "SELECT * FROM " . $db->prefix('gs_sets') . " WHERE owner='" . ($uid ? $uid : ($edit ? $img->owner() : $xoopsUser->uid())) . "'";
$result = $db->query($sql);
while ($rows = $db->fetchArray($result)) {
$ele->addOption($rows['id_set'], $rows['title']);
}
$form->addElement($ele);
$ele = new RMFormText(__('Tags', 'galleries'), 'tags', 50, 100, $edit ? implode(", ", $img->tags(false, 'tag')) : '');
$ele->setDescription(__('Separate each tag with a comma (,)', 'galleries'));
$form->addElement($ele, true);
$form->addElement(new RMFormHidden('op', $edit ? 'saveedit' : 'save'));
if ($edit) {
$form->addElement(new RMFormHidden('id', $id));
}
$form->addElement(new RMFormHidden('page', $page));
$form->addElement(new RMFormHidden('limit', $limit));
$form->addElement(new RMFormHidden('search', $search));
$form->addElement(new RMFormHidden('owner', $owner));
$form->addElement(new RMFormHidden('sort', $sort));
$form->addElement(new RMFormHidden('mode', $mode));
$buttons = new RMFormButtonGroup();
$buttons->addButton('sbt', $edit ? __('Save changes', 'galleries') : __('Add image', 'galleries'), 'submit');
$buttons->addButton('cancel', __('Cancel', 'galleries'), 'button', 'onclick="window.location=\'images.php?' . $ruta . '\'"');
$form->addElement($buttons);
$form->display();
xoops_cp_footer();
}
/**
* @desc Almacena el título y descripción de las imágenes
**/
function saveAll()
{
$names = isset($_REQUEST['names']) ? $_REQUEST['names'] : null;
$desc = isset($_REQUEST['descs']) ? $_REQUEST['descs'] : null;
$page = isset($_REQUEST['pag']) ? $_REQUEST['pag'] : '';
$errors = '';
foreach ($names as $k => $v) {
//Verificamos si la imagen es válida
if ($k <= 0) {
$errors .= sprintf(__('Picture %s is not valid!', 'galleries'), $k);
continue;
}
//Verificamos si la imagen existe
$img = new GSImage($k);
if ($img->isNew()) {
$errors .= sprintf(__('Picture %s does not exists', 'galleries'), $k);
continue;
}
$band = false;
if ($v != $img->title()) {
$img->setTitle($v);
$band = true;
}
if ($desc[$k] != $img->desc()) {
$img->setDesc($desc[$k]);
$band = true;
}
if ($band) {
$img->setModified(time());
if (!$img->save()) {
$errors .= sprintf(__('Picture %s could not be saved!', 'galleries'), $img->title());
}
}
}
if ($errors != '') {
redirect_header('./cpanel.php?pag=' . $page, 2, __('Errors ocurred while trying to save changes.', 'galleries') . $errors);
die;
} else {
redirect_header('./cpanel.php?pag=' . $page, 2, __('Changes applied successfully!', 'galleries'));
die;
}
}
