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; } }