public function get_item_url($params, $com)
{
static $cimgs;
static $csets;
$params = urldecode($params);
parse_str($params);
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsfunctions.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsimage.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gstag.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsset.class.php';
if (isset($set) && $set > 0) {
if (isset($csets[$set])) {
$ret = $csets[$set]->url() . '#comment-' . $com->id();
return $ret;
}
$sobj = new GSSet($set);
if ($sobj->isNew()) {
return '';
}
$ret = $sobj->url() . '#comment-' . $com->id();
$csets[$set] = $sobj;
return $ret;
} elseif (isset($image) && $image > 0) {
if (isset($cimgs[$image])) {
$ret = $cimgs[$image]->permalink() . '#comment-' . $com->id();
return $ret;
}
$img = new GSImage($image);
if ($img->isNew()) {
return '';
}
$ret = $img->permalink() . '#comment-' . $com->id();
$cimgs[$image] = $img;
return $ret;
}
}
public function get_item($params, $com, $url = false)
{
static $cimgs;
static $csets;
$params = urldecode($params);
parse_str($params);
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsfunctions.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsimage.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gstag.class.php';
include_once XOOPS_ROOT_PATH . '/modules/galleries/class/gsset.class.php';
if (isset($set) && $set > 0) {
if (isset($csets[$set])) {
$ret = '<a href="' . $csets[$set]->url() . '#comment-' . $com->id() . '">' . $csets[$set]->title() . '</a>';
return $ret;
}
$sobj = new GSSet($set);
if ($sobj->isNew()) {
return __('Unknow element', 'galleries');
}
$ret = '<a href="' . $sobj->url() . '#comment-' . $com->id() . '">' . $sobj->title() . '</a>';
$csets[$set] = $sobj;
return $ret;
} elseif (isset($image) && $image > 0) {
if (isset($cimgs[$image])) {
$ret = '<a href="' . $cimgs[$image]->permalink() . '#comment-' . $com->id() . '">' . $cresources[$res]->getVar('title') . '</a>';
return $ret;
}
$img = new GSImage($image);
if ($img->isNew()) {
return __('Unknow element', 'docs');
}
$ret = '<a href="' . $img->permalink() . '#comment-' . $com->id() . '">' . $img->title(true) . '</a>';
$cimgs[$image] = $img;
return $ret;
}
}
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');
$rss_channel['webmaster'] = checkEmail($xoopsConfig['adminmail'], true);
$rss_channel['editor'] = checkEmail($xoopsConfig['adminmail'], true);
$rss_channel['category'] = __('Pictures Albums', 'galleries');
$rss_channel['generator'] = 'MyGalleries 3';
$rss_channel['language'] = RMCLANG;
$sql = "SELECT * FROM " . $db->prefix('gs_sets') . " WHERE public='2' ORDER BY `date` DESC LIMIT 0, 10";
$result = $db->query($sql);
$users = array();
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 RAND() LIMIT 0,4";
$resimg = $db->query($sql);
if (!isset($users[$set->owner()])) {
$users[$set->owner()] = new GSUser($set->owner(), 1);
}
$imgs = '<a href="' . $users[$set->owner()]->userURL() . ($mc['urlmode'] ? 'set/' . $set->id() . '/' : '&set=' . $set->id()) . '">';
while ($rowimg = $db->fetchArray($resimg)) {
$img = new GSImage();
$img->assignVars($rowimg);
$urlimg = $users[$set->owner()]->filesURL() . '/' . ($config['set_format_mode'] ? 'formats/set_' : 'ths/') . $img->image();
// Conversion de los formatos
if (!$img->setFormat() && $config['set_format_mode']) {
/**
* @desc Busca la posición exacta de una etiqueta
*/
function browsePic()
{
global $usr, $mc, $xoopsModuleConfig, $xoopsConfig, $xoopsUser, $pag, $set, $browse;
$mc =& $xoopsModuleConfig;
$user = new GSUser($usr);
if ($user->isNew()) {
redirect_header(XOOPS_URL . '/modules/galleries', 0, _MS_GS_ERRUSR);
die;
}
$image = new GSImage($browse);
if ($image->isNew()) {
redirect_header(XOOPS_URL . '/modules/galleries', 0, _MS_GS_ERRIMG);
die;
}
if (isset($set)) {
$set = new GSSet($set);
if ($set->isNew()) {
redirect_header(XOOPS_URL . '/modules/galleries', 0, _MS_GS_ERRSET);
die;
}
}
$page = GSFunctions::pageFromPic($image, $user, $set > 0 ? $set : 0);
header('location: ' . $user->userURL() . 'pag/' . $page);
}
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;
}
/**
* 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 Devuelve los albumes a los que pertenece una imágen
* @param bool $obj Determina si se obtienen los objetos GSSet
* @return array
*/
public function sets($obj = true)
{
$db =& $this->db;
if (empty($this->_sets) || $this->_settype != $obj) {
$this->_sets = array();
$tbl1 = $db->prefix("gs_sets");
$tbl2 = $db->prefix("gs_setsimages");
$sql = "SELECT a.* FROM {$tbl1} a, {$tbl2} b WHERE b.id_image='" . $this->id() . "' AND a.id_set=b.id_set";
$result = $db->query($sql);
while ($row = $db->fetchArray($result)) {
if ($obj) {
$set = new GSSet();
$set->assignVars($row);
$this->_sets[] = $set;
} else {
$this->_sets[] = $row;
}
}
}
return $this->_sets;
}
public function delete()
{
//Eliminamos las imágenes
$sql = "SELECT * FROM " . $this->db->prefix('gs_images') . " WHERE owner='" . $this->uid() . "'";
$result = $this->db->query($sql);
while ($rows = $this->db->fetchArray($result)) {
$img = new GSImage();
$img->assignVars($rows);
$img->delete();
}
RMUtilities::delete_directory($this->filesPath());
//Eliminamos los albumes
$sql = "SELECT * FROM " . $this->db->prefix('gs_sets') . " WHERE owner='" . $this->uid() . "'";
$result = $this->db->query($sql);
while ($rows = $this->db->fetchArray($result)) {
$set = new GSSet();
$set->assignVars($rows);
$set->delete();
}
return $this->deleteFromTable();
}
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);
}
$tpl->append('other_sets', array('id' => $set->id(), 'title' => $set->title(), '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)));
}
RMTemplate::get()->add_style('index.css', 'galleries');
include 'footer.php';
/**
* @desc Elimina de la base de datos la información del album especificado
**/
function deleteSets()
{
global $util, $xoopsModule, $db, $xoopsModuleConfig, $page;
$ids = isset($_REQUEST['ids']) ? $_REQUEST['ids'] : 0;
$mc =& $xoopsModuleConfig;
$link = GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/sets/pag/' . $pag . '/' : '?cp=sets&pag=' . $pag);
//Verificamos si nos proporcionaron al menos un imagen para eliminar
if (!is_array($ids)) {
redirect_header($link, 2, __('You must selecte one album at least!', 'galleries'));
die;
}
$errors = '';
foreach ($ids as $k) {
//Verificamos si el album es válido
if ($k <= 0) {
$errors .= sprintf(__('Album id %u is not valid!', 'galleries'), $k);
continue;
}
//Verificamos si el album existe
$set = new GSSet($k);
if ($set->isNew()) {
$errors .= sprintf(__('Album with id %u does not exists!', 'galleries'), $k);
continue;
}
if (!$set->delete()) {
$errors .= sprintf(__('Album "%s" could not be deleted!', 'galleries'), $set->title());
}
}
if ($errors != '') {
redirect_header($link, 2, __('Errors ocurred while trying to delete albums', 'galleries') . '<br />' . $errors);
die;
} else {
redirect_header($link, 1, __('Abums deleted successfully!', 'galleries'));
die;
}
}
/**
* @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';
}
/**
* @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;
}
}
function saveBulkImages()
{
$mc = RMUtilities::module_config('galleries');
XoopsLogger::getInstance()->activated = false;
XoopsLogger::getInstance()->renderingEnabled = false;
set_time_limit(0);
$security = TextCleaner::getInstance()->decrypt(rmc_server_var($_POST, 'rmsecurity', 0), true);
$data = explode("|", $security);
$xoopsUser = new XoopsUser($data[1]);
if (!isset($data[1]) || $data[1] != XOOPS_URL . '/modules/galleries/admin/images.php') {
send_error(__('You are not allowed to do this action', 'galleries'));
}
foreach ($_POST as $k => $v) {
${$k} = $v;
}
$ruta = "page={$page}&search={$search}&owner={$uid}&sort={$sort}&mode={$mode}";
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()) {
send_error(__('User owner could not be created!', 'galleries') . "<br />" . $user->errors());
die;
} else {
mkdir($mc['storedir'] . "/" . $user->uname());
mkdir($mc['storedir'] . "/" . $user->uname() . "/ths");
mkdir($mc['storedir'] . "/" . $user->uname() . "/formats");
}
} else {
@mkdir($mc['storedir'] . "/" . $user->uname());
@mkdir($mc['storedir'] . "/" . $user->uname() . "/ths");
@mkdir($mc['storedir'] . "/" . $user->uname() . "/formats");
}
// Insertamos las etiquetas
$tgs = explode(",", $tags);
/**
* @desc Almacena los ids de las etiquetas que se asignarán a la imágen
*/
$ret = array();
foreach ($tgs as $k) {
$k = trim($k);
if ($k == '') {
continue;
}
// Comprobamos que la palabra tenga la longitud permitida
if (strlen($k) < $mc['min_tag'] || strlen($k) > $mc['max_tag']) {
continue;
}
// Creamos la etiqueta
$tag = new GSTag(TextCleaner::getInstance()->sweetstring($k));
if (!$tag->isNew()) {
// Si ya existe nos saltamos
$ret[] = $tag->id();
continue;
}
$tag->setTag($k);
if ($tag->save()) {
$ret[] = $tag->id();
}
}
$errors = '';
$k = 1;
include_once RMCPATH . '/class/uploader.php';
$updir = $mc['storedir'] . "/" . $xu->uname();
$upths = $mc['storedir'] . "/" . $xu->uname() . "/ths";
// Cargamos la imágen
if (!file_exists($updir)) {
mkdir($updir, 511);
}
if (!file_exists($upths)) {
mkdir($upths, 511);
}
$uploader = new RMFileUploader($updir, $mc['size_image'] * 1024, array('gif', 'jpg', 'jpeg', 'png'));
$err = array();
if (!$uploader->fetchMedia('Filedata')) {
send_error($uploader->getErrors());
}
if (!$uploader->upload()) {
send_error($uploader->getErrors());
}
// Insertamos el archivo en la base de datos
$img = new GSImage();
$img->setTitle($uploader->savedFileName);
$img->setOwner($uid);
$img->setPublic(2);
$img->setCreated(time());
$img->setImage($uploader->getSavedFileName());
if (!$img->save()) {
unlink($uploader->savedDestination);
send_error(__('File could not be inserted to database!', 'galleries'));
}
$user->addPic();
$img->setTags($ret);
//Albumes
$sets = explode(",", $sets);
if (!empty($sets)) {
foreach ($sets as $k => $v) {
$album = new GSSet($v);
$album->addPic($img->id());
}
}
$ret['message'] = '1';
$ret['id'] = $img->id();
echo json_encode($ret);
die;
}
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;
}
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;
}
/**
* This function deletes all image formats, except thumbnails, for specified albums.
* This is useful when you need to regenerate images
*/
function delete_formats()
{
global $xoopsModuleConfig;
$id = rmc_server_var($_GET, 'id', 0);
$page = rmc_server_var($_GET, 'page', 1);
if ($id <= 0) {
redirectMsg("sets.php?page={$page}", __('Sorry, this is not a valid album!', 'galleries'), 1);
die;
}
$set = new GSSet($id);
if ($set->isNew()) {
redirectMsg("sets.php?page={$page}", __('Specified Album does not exists!', 'galleries'), 1);
die;
}
$db = Database::getInstance();
$t1 = $db->prefix("gs_images");
$t2 = $db->prefix("gs_setsimages");
$sql = "SELECT a.image FROM {$t1} a, {$t2} b WHERE b.id_set={$id} AND a.id_image=b.id_image";
$result = $db->query($sql);
$dir = rtrim($xoopsModuleConfig['storedir'], '/');
if ($set->uname() == '') {
$user = new XoopsUser($set->owner());
$uname = $user->uname();
} else {
$uname = $set->uname();
}
if ($uname == '') {
redirectMsg('sets.php?page=' . $page, __('Sorry, we were unable to find the album owner!', 'galleries'), 1);
break;
}
$dir .= '/' . $uname . '/formats';
if (!is_dir($dir)) {
redirectMsg('sets.php?page=' . $page, __('There are not image formats for this album.', 'galleries'), 0);
die;
}
while (list($image) = $db->fetchRow($result)) {
@unlink($dir . '/bigset_' . $image);
@unlink($dir . '/set_' . $image);
@unlink($dir . '/user_' . $image);
@unlink($dir . '/srh_' . $image);
}
$pics = $set->getPics();
$sql = "UPDATE {$t1} SET user_format=0, set_format=0, bigset_format=0, search_format=0 WHERE id_image IN (" . implode(",", $pics) . ")";
$db->queryF($sql);
redirectMsg('sets.php?page=' . $page, __('Image formats deleted!', 'galleries'), 0);
}
/**
* @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;
}
}
