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; }
function gs_photos_show($options) { include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsfunctions.class.php'; include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsuser.class.php'; include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsimage.class.php'; $options[0] <= 0 ? 4 : $options[0]; $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT * FROM " . $db->prefix("gs_images"); $order = $options[1] == '0' ? "created DESC" : ($options[1] == '1' ? 'RAND()' : 'views DESC'); $sql .= " ORDER BY {$order} LIMIT 0,{$options['0']}"; $result = $db->query($sql); $mc =& RMUtilities::module_config('galleries'); $block = array(); $tf = new RMTimeFormatter(0, '%T% %d%, %Y%'); 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(); if ($options[3]) { $rtn['title'] = $pic->title(); } $rtn['created'] = $tf->format($pic->created()); $rtn['views'] = $pic->views(); $rtn['by'] = sprintf(__('by %s', 'galleries'), '<a href="' . $user->userURL() . '">' . $user->uname() . '</a>'); $rtn['link'] = $user->userURL() . ($mc['urlmode'] ? 'img/' . $pic->id() . '/' : '&img=' . $pic->id()); $rtn['file'] = $user->filesURL() . '/ths/' . $pic->image(); $block['pics'][] = $rtn; } RMTemplate::get()->add_xoops_style('blocks.css', 'galleries'); RMTemplate::get()->add_local_script('blocks.js', 'galleries'); $block['item_width'] = $options[2]; return $block; }
/** * @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; }
function send_sets() { global $xoopsLogger, $xoopsModuleConfig; $xoopsLogger->renderingEnabled = false; error_reporting(0); $xoopsLogger->activated = false; $mc =& $xoopsModuleConfig; $db = Database::getInstance(); $limit = rmc_server_var($_GET, 'limit', 5); // recent pictures $sql = "SELECT * FROM " . $db->prefix("gs_sets") . " ORDER BY `date` DESC LIMIT 0,{$limit}"; $result = $db->query($sql); $sets = array(); $users = array(); while ($row = $db->fetchArray($result)) { $set = new GSSet(); $set->assignVars($row); $pics = $set->getPics('RAND()'); $img = new GSImage($pics[0]); if (!isset($users[$img->owner()])) { $users[$img->owner()] = new GSUser($img->owner(), 1); } if ($img->isNew()) { $image = array('title' => __('Empty album', 'galleries'), 'link' => '', 'thumbnail' => GS_URL . '/images/empty.jpg'); } else { $image = array('title' => $img->title(), 'link' => $users[$img->owner()]->userURL() . ($mc['urlmode'] ? 'img/' . $img->id() . '/' : '&img=' . $img->id()), 'thumbnail' => $users[$img->owner()]->filesURL() . '/ths/' . $img->image()); } $sets[] = array('title' => $set->title(), 'link' => $set->url(), 'image' => $image); } ob_start(); ?> <?php foreach ($sets as $set) { ?> <a href="<?php echo $set['link']; ?> " target="_blank" title="<?php echo $set['title']; ?> "><img src="<?php echo $set['image']['thumbnail']; ?> " alt="<?php echo $set['title']; ?> " /></a> <?php } ?> <?php $recents = ob_get_clean(); echo $recents; die; }
$result = $db->query($sql); $rss_channel['title'] = $xoopsModule->name(); $rss_channel['link'] = GSFunctions::get_url(); $rss_channel['description'] = __('These are the recent pictures published on our galleries.', 'galleries'); $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':
/** * @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 la postal **/ function viewPostcard() { global $tpl, $xoopsModule, $xoopsModuleConfig, $xoopsModuleConfig, $mc, $xoopsUser, $id; include_once XOOPS_ROOT_PATH . '/class/template.php'; $tpl = new XoopsTpl(); $mc =& $xoopsModuleConfig; if (!$xoopsUser) { redirect_header(XOOPS_URL . '/user.php#register', 1, _MS_GS_ERRUSR); die; } //Verificamos si la postal existe $post = new GSPostcard($id); if ($post->isNew()) { redirect_header(XOOPS_URL . '/modules/galleries/', 1, _MS_GS_ERRPOSTEXIST); die; } $img = new GSImage($post->image()); if ($img->isNew()) { redirect_header(XOOPS_URL . '/modules/galleries/', 1, _MS_GS_ERRIMG); die; } $user = new GSUser($img->owner(), 1); $file = $user->filesPath() . '/' . $img->image(); list($ancho, $alto) = getimagesize($file); $tpl->assign('gs_url', XOOPS_URL . '/modules/galleries'); $tpl->assign('img', array('id' => $img->id(), 'width' => $ancho, 'height' => $alto, 'url' => $user->filesURL() . '/' . $img->image(), 'link' => $user->userURL() . 'img/' . $img->id() . '/')); $tpl->assign('title', $post->title()); $tpl->assign('message', $post->message()); $tpl->assign('lang_says', sprintf(_MS_GS_SAYS, $post->name())); $tpl->assign('xoops_pagetitle', sprintf(_MS_GS_PTITLE, $post->title()) . ' » ' . $mc['section_title']); $tpl->assign('lang_see', _MS_GS_SEE); $tpl->assign('user_link', $user->userURL() . 'browse/' . $img->id() . '/'); $tpl->assign('lang_seeuser', _MS_GS_SEEUSER); $tpl->assign('preview', 0); RMTemplate::get()->add_xoops_style('postcard.css', 'galleries'); //Actualizar datos de postal $post->setViewed(1); $post->save(); echo $tpl->fetch("db:gs_postcard.html"); }
/** * @desc Visualiza la postal **/ function viewPostcard() { global $tpl, $xoopsModule, $xoopsModuleConfig, $xoopsModuleConfig, $mc, $xoopsUser, $id; include_once XOOPS_ROOT_PATH . '/class/template.php'; $tpl = new XoopsTpl(); $mc =& $xoopsModuleConfig; //Verificamos si la postal existe $post = new GSPostcard($id); if ($post->isNew()) { redirect_header(XOOPS_URL . '/modules/galleries/', 1, __('Specified E_Card does not exists!', 'galleries')); die; } $img = new GSImage($post->image()); if ($img->isNew()) { redirect_header(XOOPS_URL . '/modules/galleries/', 1, __('Sorry, there are some problems with this e-card!', 'galleries')); die; } $user = new GSUser($img->owner(), 1); $file = $user->filesPath() . '/' . $img->image(); list($ancho, $alto) = getimagesize($file); $tpl->assign('gs_url', XOOPS_URL . '/modules/galleries'); $tpl->assign('img', array('id' => $img->id(), 'width' => $ancho, 'height' => $alto, 'url' => $user->filesURL() . '/' . $img->image(), 'link' => $user->userURL() . 'img/' . $img->id() . '/')); $tpl->assign('title', $post->title()); $tpl->assign('message', $post->message()); $tpl->assign('lang_says', sprintf(__('%s says:'), $post->name())); $tpl->assign('xoops_pagetitle', sprintf(__('%s, E-Card', 'galleries'), $post->title()) . ' » ' . $mc['section_title']); $tpl->assign('lang_see', __('View Picture', 'galleries')); $tpl->assign('user_link', $user->userURL() . 'browse/' . $img->id() . '/'); $tpl->assign('lang_seeuser', __('View User Pictures', 'galleries')); $tpl->assign('preview', 0); RMTemplate::get()->add_xoops_style('postcard.css', 'galleries'); //Actualizar datos de postal $post->setViewed(1); $post->save(); echo $tpl->fetch("db:gs_postcard.html"); }
/** * @desc Marca Imagen como favorita **/ function addBookMarks() { global $xoopsUser, $add, $xoopsModuleConfig, $referer; $mc =& $xoopsModuleConfig; $referer = base64_decode($referer); if (!$referer) { $referer = GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/bookmarks/' : '?cp=bookmarks'); } //Verificamos que la imagen sea válida if ($add <= 0) { redirect_header($referer, 1, __('Image id is not valid!', 'galleries')); die; } //Verificamos que la imagen exista $img = new GSImage($add); if ($img->isNew()) { redirect_header($referer, 1, __('Specified image does not exists!', 'galleries')); die; } //Verificamos que la imagen sea pública o de amigos if ($img->isPublic() == 0) { redirect_header($referer, 1, __('You don\'t have authorization to view this picture!', 'galleries')); die; } $user = new GSUser($img->owner(), 1); //Verificamos si el usuario es amigo del dueño de la imagen if ($img->isPublic() == 1) { if (!$user->isFriend($xoopsUser->uid())) { redirect_header($referer, 1, __('You must be a friend of this user in order to view this picture!', 'galleries')); die; } } $db = Database::getInstance(); //Verificamos si la imagen se encuentra ya registrada en favoritos $sql = "SELECT COUNT(*) FROM " . $db->prefix('gs_favourites') . " WHERE uid='" . $xoopsUser->uid() . "' AND id_image='" . $img->id() . "'"; list($num) = $db->fetchRow($db->query($sql)); if ($num > 0) { redirect_header($referer, 1, __('This picture already is in your favorites', 'galleries')); die; } //Agregamos la imagen a favoritos $sql = "INSERT INTO " . $db->prefix('gs_favourites') . " (`uid`,`id_image`) VALUES ('" . $xoopsUser->uid() . "','" . $img->id() . "')"; $result = $db->queryF($sql); if (!$result) { redirect_header($referer, 1, __('Picture could not be added to your favorites!', 'galleries')); die; } else { redirect_header($referer, 1, __('Picture added to your favorites successfully!', 'galleries')); die; } }
$set = new GSSet(); $set->assignVars($row); $pics = $set->getPics('RAND()'); $imgs = @array_slice($pics, 0, $xoopsModuleConfig['sets_num_images']); if (!isset($users[$set->owner()])) { $users[$set->owner()] = new GSUser($set->owner(), 1); } $images = array(); if (!empty($imgs)) { // Obtenemos las primeras 4 imágenes foreach ($imgs as $k) { $img = new GSImage($k); if ($img->isPublic() != 2) { continue; } if (!isset($users[$img->owner()])) { $users[$img->owner()] = new GSUser($img->owner(), 1); } $imglink = $users[$img->owner()]->userURL() . 'img/' . $img->id() . '/'; $images[] = array('id' => $img->id(), 'title' => $img->title(), 'thumbnail' => $users[$img->owner()]->filesURL() . '/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); } } $tpl->append('sets', array('id' => $set->id(), 'title' => $set->title(), 'images' => $images, 'link' => $users[$set->owner()]->userUrl() . ($mc['urlmode'] ? 'set/' . $set->id() : '&set=' . $set->id()), 'date' => formatTimestamp($set->date(), 'c'), 'by' => '<a href="' . $users[$set->owner()]->userUrl() . '">' . $users[$set->owner()]->uname() . '</a>', 'picsnum' => count($pics))); } $result = $db->query("SELECT * FROM " . $db->prefix("gs_sets") . " WHERE public='2' ORDER BY date DESC LIMIT {$mc['sets_num']}," . ($mc['sets_num'] > 0 ? $mc['sets_num'] : 5)); while ($row = $db->fetchArray($result)) { $set = new GSSet(); $set->assignVars($row); if (!isset($users[$set->owner()])) { $users[$set->owner()] = new GSUser($set->owner(), 1); }
/** * @desc almacena la información de la imagen **/ function saveImages($edit = 0) { global $mc, $xoopsSecurity, $db, $xoopsUser, $db; foreach ($_POST as $k => $v) { ${$k} = $v; } $ruta = "page={$page}&limit={$limit}&search={$search}&owner={$owner}&sort={$sort}&mode={$mode}"; if (!$xoopsSecurity->check()) { redirectMsg('./images.php?' . $ruta, __('Session token expired!', 'galleries'), 1); die; } if ($edit) { //Verificamos si la imagen es válida if ($id <= 0) { redirectMsg('./images.php?op=edit&id=' . $id . '&' . $ruta, __('Image ID not valid!', 'galleries'), 1); die; } //Verificamos si la imagen existe $img = new GSImage($id); if ($img->isNew()) { redirectMsg('./images.php?op=edit&id=' . $id . '&' . $ruta, __('Specified image does not exists!', 'galleries'), 1); die; } } else { $img = new GSImage(); } $img->setTitle($title); $img->setDesc($desc); $img->isNew() ? $img->setCreated(time()) : $img->setModified(time()); if (!$edit) { $img->setOwner($uid); } $img->setPublic($public); //Insertamos las etiquetas $tgs = array(); $tags = explode(",", $tags); foreach ($tags as $k) { $k = trim($k); if (!$k) { continue; } if (strlen($k) < $mc['min_tag'] || strlen($k) > $mc['max_tag']) { continue; } $tag = new GSTag($k); if (!$tag->isNew()) { $tgs[] = $tag->id(); continue; } $tag->setTag(strtolower($k)); if ($tag->save()) { $tgs[] = $tag->id(); } } if (!$edit) { if ($xoopsUser->uid() == $uid) { $xu =& $xoopsUser; } else { $xu = new XoopsUser($uid); } //Verificamos si el usuario se encuentra registrado $user = new GSUser($xu->uname()); if ($user->isNew()) { //Insertamos información del usuario $user->setUid($uid); $user->setUname($xu->uname()); $user->setQuota($mc['quota'] * 1024 * 1024); $user->setDate(time()); if (!$user->save()) { redirectMsg('./images.php?op=' . ($edit ? 'edit&id=' . $id : 'new') . '&' . $ruta, __('New user owner could not be saved!', 'galleries'), 1); die; } else { mkdir($mc['storedir'] . "/" . $user->uname()); mkdir($mc['storedir'] . "/" . $user->uname() . "/ths"); mkdir($mc['storedir'] . "/" . $user->uname() . "/formats"); } } } else { $user = new GSUser($img->owner(), 1); } //Imagen include_once RMCPATH . '/class/uploader.php'; $folder = $mc['storedir'] . "/" . $user->uname(); $folderths = $mc['storedir'] . "/" . $user->uname() . "/ths"; $up = new RMFileUploader($folder, $mc['size_image'] * 1024, array('jpg', 'png', 'gif')); if ($edit) { $filename = $img->image(); } else { $filename = ''; } if ($up->fetchMedia('image')) { if (!$up->upload()) { redirectMsg('./images.php?op=' . ($edit ? 'edit&id=' . $id : 'new') . '&' . $ruta, $up->getErrors(), 1); die; } if ($edit && $img->image() != '') { @unlink($mc['storedir'] . "/" . $user->uname() . "/" . $img->image()); @unlink($mc['storedir'] . "/" . $user->uname() . "/ths/" . $img->image()); @unlink($mc['storedir'] . "/originals/" . $img->image()); } $filename = $up->getSavedFileName(); $fullpath = $up->getSavedDestination(); $thSize = $mc['image_ths']; $imgSize = $mc['image']; if ($thSize[0] <= 0) { $thSize[0] = 100; } if (!isset($thSize[1]) || $thSize[1] <= 0) { $thSize[1] = $thSize[0]; } if ($imgSize[0] <= 0) { $imgSize[0] = 500; } if (!isset($imgSize[1]) || $imgSize[1] <= 0) { $imgSize[1] = $imgSize[0]; } // Almacenamos la imágen original if ($mc['saveoriginal']) { copy($fullpath, $mc['storedir'] . '/originals/' . $filename); } // Redimensionamos la imagen $redim = new RMImageResizer($fullpath, $fullpath); switch ($mc['redim_image']) { case 0: //Recortar miniatura $redim->resizeWidth($imgSize[0]); $redim->setTargetFile($folderths . "/{$filename}"); $redim->resizeAndCrop($thSize[0], $thSize[1]); break; case 1: //Recortar imagen grande $redim->resizeWidthOrHeight($imgSize[0], $imgSize[1]); $redim->setTargetFile($folderths . "/{$filename}"); $redim->resizeWidth($thSize[0]); break; case 2: //Recortar ambas $redim->resizeWidthOrHeight($imgSize[0], $imgSize[1]); $redim->setTargetFile($folderths . "/{$filename}"); $redim->resizeAndCrop($thSize[0], $thSize[1]); break; case 3: //Redimensionar $redim->resizeWidth($imgSize[0]); $redim->setTargetFile($folderths . "/{$filename}"); $redim->resizeWidth($thSize[0]); break; } } else { echo $up->getErrors(); } //Fin de Imagen $img->setImage($filename); $db = Database::getInstance(); $new = $img->isNew(); if (!$img->save()) { redirectMsg('./images.php?op=' . ($edit ? 'edit&id=' . $id : 'new') . '&' . $ruta, __('Errors ocurred while trying to save image.', 'galleries') . $img->errors(), 1); die; } else { $user->addPic(); $img->setTags($tgs); $sets = ''; $tbl1 = $db->prefix("gs_sets"); $tbl2 = $db->prefix("gs_setsimages"); foreach ($albums as $k => $v) { // Si el album existe no incrementamos el numero de imagenes $sets .= $sets == '' ? "{$tbl2}.id_set<>'{$v}'" : " AND {$tbl2}.id_set<>'{$v}'"; if ($img->inSet($v)) { continue; } $album = new GSSet($v); $album->addPic($img->id()); } // Actualizamos los valores de los ignorados $sql = "UPDATE {$tbl1}, {$tbl2} SET {$tbl1}.pics={$tbl1}.pics-1 WHERE ({$tbl2}.id_image='" . $img->id() . "'" . ($sets != '' ? ' AND ' . $sets : '') . ") AND {$tbl1}.id_set={$tbl2}.id_set"; $db->queryF($sql); $sets = str_replace($tbl2 . '.', '', $sets); $sql = "DELETE FROM " . $db->prefix("gs_setsimages") . " WHERE id_image='" . $img->id() . "' " . ($sets != '' ? " AND ({$sets})" : ''); $db->queryF($sql); redirectMsg('./images.php?' . $ruta, __('Database updated successfully!', 'galleries'), 0); die; } }
/** * Resize images */ function gs_resize_images() { global $xoopsUser, $xoopsLogger, $xoopsSecurity; set_time_limit(0); $mc = RMUtilities::module_config('galleries'); $params = rmc_server_var($_GET, 'data', ''); $id = rmc_server_var($_GET, 'img', 0); if ($params == '') { send_error(__('Unauthorized!', 'galleries')); } if ($id <= 0) { send_error(__('Invalid image!', 'galleries')); } $params = TextCleaner::decrypt($params); $data = explode('|', $params); if ($data[0] != $xoopsUser->uid()) { send_error(__('Unauthorized!', 'galleries')); } if ($data[1] != GS_URL . '/admin/images.php') { send_error(__('Unauthorized!', 'galleries')); } if (!$xoopsSecurity->check(false, $data[2])) { send_error(__('Unauthorized!', 'galleries')); } $image = new GSImage($id); if ($image->isNew()) { send_error(__('Image not found!', 'galleries')); } $thSize = $mc['image_ths']; $imgSize = $mc['image']; if ($thSize[0] <= 0) { $thSize[0] = 100; } if (!isset($thSize[1]) || $thSize[1] <= 0) { $thSize[1] = $thSize[0]; } if ($imgSize[0] <= 0) { $imgSize[0] = 500; } if (!isset($imgSize[1]) || $imgSize[1] <= 0) { $imgSize[1] = $imgSize[0]; } $xu = new GSUser($image->owner(), 1); $updir = rtrim($mc['storedir'], '/') . "/" . $xu->uname(); $upurl = str_replace(XOOPS_ROOT_PATH, XOOPS_URL, $updir); $upths = rtrim($mc['storedir'], '/') . "/" . $xu->uname() . "/ths"; $width = 0; $tfile = ''; // Almacenamos la imágen original if ($mc['saveoriginal']) { copy($updir . '/' . $image->image(), $mc['storedir'] . '/originals/' . $image->image()); } $fd = pathinfo($updir . '/' . $image->image()); $filename = $image->image(); $redim = new RMImageResizer($updir . '/' . $image->image(), $updir . '/' . $image->image()); switch ($mc['redim_image']) { case 0: //Recortar miniatura $redim->resizeWidth($imgSize[0]); $redim->setTargetFile($upths . "/{$filename}"); $redim->resizeAndCrop($thSize[0], $thSize[1]); break; case 1: //Recortar imagen grande $redim->resizeWidthOrHeight($imgSize[0], $imgSize[1]); $redim->setTargetFile($upths . "/" . $image->image()); $redim->resizeWidth($thSize[0]); break; case 2: //Recortar ambas $redim->resizeWidthOrHeight($imgSize[0], $imgSize[1]); $redim->setTargetFile($upths . "/{$filename}"); $redim->resizeAndCrop($thSize[0], $thSize[1]); break; case 3: //Redimensionar $redim->resizeWidth($imgSize[0]); $redim->setTargetFile($upths . "/{$filename}"); $redim->resizeWidth($thSize[0]); break; } $tfile = $upurl . '/ths/' . $image->image(); $ret['message'] = sprintf(__('%s done!', 'galleries'), $image->image()); $ret['done'] = 1; $ret['file'] = $tfile; $ret['title'] = $image->image(); echo json_encode($ret); die; }
/** * @desc Almacena la asignación de albumes a las imágenes **/ function saveSets() { global $db, $xoopsUser, $xoopsConfig; foreach ($_POST as $k => $v) { ${$k} = $v; } $errors = ''; foreach ($ids as $k) { //Verificamos si la imagen es válida if ($k <= 0) { $errors .= sprintf(__('Picture with id %u is not valid!', 'galleries'), $k); continue; } //Verificamos si la imagen existe $img = new GSImage($k); if ($img->isNew()) { $errors .= sprintf(__('Picture with id %u does not exists!', 'galleries'), $k); continue; } if ($img->owner() != $xoopsUser->uid()) { $errors = sprintf(__('You don\'t have authorization!', 'galleries'), $k); continue; } $db = XoopsDatabaseFactory::getDatabaseConnection(); $sets = ''; $tbl1 = $db->prefix("gs_sets"); $tbl2 = $db->prefix("gs_setsimages"); foreach ($albums as $k => $v) { // Si el album existe no incrementamos el numero de imagenes if ($img->inSet($v)) { continue; } $album = new GSSet($v); $album->addPic($img->id()); } // Actualizamos los valores de los ignorados $sql = "UPDATE {$tbl1}, {$tbl2} SET {$tbl1}.pics={$tbl1}.pics-1 WHERE ({$tbl2}.id_image='" . $img->id() . "'" . ($sets != '' ? ' AND ' . $sets : '') . ") AND {$tbl1}.id_set={$tbl2}.id_set"; $db->queryF($sql); } if (!$referer) { $referer = GSFunctions::get_url(); } if ($errors != '') { redirect_header($referer, 2, __('Errors ocurred while trying to update picture!', 'galleries') . $errors); die; } else { redirect_header($referer, 2, __('Pictures updated successfully!', 'galleries')); die; } }