function Joom_DeleteComment_HTML() { $config = Joom_getConfig(); $user =& JFactory::getUser(); $mainframe =& JFactory::getApplication('site'); $database =& JFactory::getDBO(); Joom_GalleryHeader(); // Main Part of Subfunction if ($user->get('gid') == 20 || $user->get('gid') == 24 || $user->get('gid') == 25) { if (isset($_REQUEST['submit']) && $_REQUEST['submit'] != '') { $database->setQuery(" DELETE\n FROM \n #__joomgallery_comments\n WHERE \n cmtid = '" . $this->cmtid . "'\n "); $database->query(); $mainframe->redirect(JRoute::_('index.php?option=com_joomgallery&func=detail&id=' . $this->cmtpic . _JOOM_ITEMID, false), JText::_('JGS_ALERT_COMMENT_DELETED')); } else { ?> <div class="jg_clearboth"></div> <div class="sectiontableheader jg_cmtl"> <?php echo JText::_('JGS_AUTHOR'); ?> </div> <div class="sectiontableheader jg_cmtr"> <?php echo JText::_('JGS_COMMENT'); ?> </div> <?php $database->setQuery(" SELECT \n cmtid, \n cmtip, \n userid, \n cmtname, \n cmttext, \n cmtdate, \n cmtpic, \n username\n FROM \n #__joomgallery_comments AS cm\n LEFT JOIN \n #__users AS u ON cm.userid=u.id\n WHERE \n cmtid = '" . $this->cmtid . "'\n "); $result1 = $database->LoadRow(); list($cmtid, $cmtip, $userid, $cmtname, $cmttext, $cmtdate, $cmtpic, $username) = $result1; ?> <div class="sectiontableentry1"> <div class="jg_cmtl"> <b> <?php if ($userid > 0) { ?> <?php echo $username; ?> <?php } else { ?> <?php echo $cmtname; ?> <?php } ?> </b> <br /> <a href="http://openrbl.org/query?i=<?php echo $cmtip; ?> "> <img src="<?php echo _JOOM_LIVE_SITE; ?> components/com_joomgallery/assets/images/ip.gif" alt="<?php echo $cmtip; ?> " title="<?php echo $cmtip; ?> " hspace="3" border="0" /> </a> </div> <?php $signtime = strftime($config->jg_dateformat, $cmtdate); $origtext = $cmttext; ?> <div class="jg_cmtr small"> <?php echo JText::_('JGS_COMMENT_ADDED') . ": " . $signtime; ?> <hr> <?php echo $origtext; ?> </div> </div> <div class="jg_cmtronly"> <form action="<?php echo JRoute::_('index.php?option=com_joomgallery&func=deletecomment&cmtid=' . $cmtid . '&cmtpic=' . $cmtpic . _JOOM_ITEMID); ?> " method="post"> <input class="button" type="submit" name="submit" value="<?php echo JText::_('JGS_DELETE_COMMENT'); ?> " /> </form> </div> <?php } } else { ?> <p /> <a href="<?php echo JRoute::_('index.php?option=com_joomgallery' . _JOOM_ITEMID); ?> "> <?php echo JText::_('JGS_BACK'); ?> </a> <?php } }
function Joom_Favourites($func, $id, $catid) { $mainframe =& JFactory::getApplication('site'); $database = JFactory::getDBO(); $user =& JFactory::getUser(); $config = Joom_getConfig(); $this->showfavourites_url = 'index.php?option=com_joomgallery&func=showfavourites'; $this->viewcategory_url = 'index.php?option=com_joomgallery&func=viewcategory&catid='; $this->details_url = 'index.php?option=com_joomgallery&func=detail&id='; $access = true; if ($func == 'addpicture') { $database->setQuery(" SELECT \n id\n FROM \n #__joomgallery AS a\n LEFT JOIN \n #__joomgallery_catg AS c ON a.catid = c.cid\n WHERE \n a.id= '" . $id . "' \n AND a.approved = '1' \n AND a.published = '1'\n AND c.access <= '" . $user->get('aid') . "' \n AND c.published = '1'\n "); if (!$database->loadResult()) { $access = false; } } // Berechtigung ueberpruefen if ($config->jg_showdetailfavourite == 0 && $user->get('aid') < 1 || $config->jg_showdetailfavourite == 1 && $user->get('aid') < 2 || $config->jg_usefavouritesforpubliczip == 1 && $user->get('id') < 1 || $config->jg_favourites == 0 || $access == false) { $mainframe->redirect(JRoute::_('index.php?option=com_joomgallery' . _JOOM_ITEMID, false), JText::_('JGS_ALERT_NOT_ALLOWED_VIEW_PICTURE')); } // Ueberpruefung, ob mit der Datenbank oder mit der Session gearbeitet wird if ($user->get('id') && $config->jg_usefavouritesforzip != 1) { $this->using_database = true; $this->output = 'JGS_FAV_'; $database->setQuery(" SELECT \n uuserid \n FROM \n #__joomgallery_users \n WHERE \n uuserid = '" . $user->get('id') . "'\n "); if ($database->loadResult()) { $this->user_exists = true; $database->setQuery(" SELECT \n piclist,\n layout \n FROM \n #__joomgallery_users \n WHERE \n uuserid = '" . $user->get('id') . "'\n "); $row = $database->loadObject(); $this->piclist = $row->piclist; $this->layout = $row->layout; } else { $this->user_exists = false; $this->piclist = NULL; $this->layout = 0; } } else { $this->using_database = false; $this->output = 'JGS_ZIP_'; $this->piclist = $mainframe->getUserState('joom.favourites.pictures'); $this->layout = $mainframe->getUserState('joom.favourites.layout'); } switch ($func) { case 'addpicture': $this->Joom_Favourites_AddPicture($id, $catid); break; case 'removepicture': $this->Joom_Favourites_RemovePicture($id); break; case 'removeall': $this->Joom_Favourites_RemoveAll(); break; case 'switchlayout': $this->Joom_Favourites_SwitchLayout(); break; case 'createzip': Joom_GalleryHeader(); $this->Joom_Favourites_CreateZip(); break; case 'showfavourites': Joom_GalleryHeader(); $this->Joom_ShowFavourites(); break; } }
case 'joomplu': include JPATH_COMPONENT . DS . 'includes' . DS . 'joom.viewminijoom.php'; $minijoom = new Joom_ShowMiniJoom(); return; // nothing else matters because the outputs above are usually shown in a popup window break; default: // include dTree script, dTree styles and treeview styles, if neccessary if ($config->jg_showsubsingalleryview) { $document->addStyleSheet(_JOOM_LIVE_SITE . 'components/com_joomgallery/assets/js/dTree/css/jg_dtree.css'); $document->addStyleSheet(_JOOM_LIVE_SITE . 'components/com_joomgallery/assets/js/dTree/css/jg_treeview.css'); $document->addScript(_JOOM_LIVE_SITE . 'components/com_joomgallery/assets/js/dTree/js/jg_dtree.js'); } $func = ''; // for some pollings later on Joom_GalleryHeader(); // set default page title $document->setTitle(JText::_('JGS_GALLERY')); if (!$config->jg_showrmsmcats) { $access = "AND access <= '" . $user->get('aid') . "'"; } else { $access = ''; } # Feststellen der Anzahl der darstellbaren Kategorien $database->setQuery(" SELECT\n COUNT(cid)\n FROM\n #__joomgallery_catg\n WHERE\n published = '1'\n AND parent='0'\n {$access}\n "); $count2 = $database->loadResult(); # Berechnen der Gesamtseiten if ($config->jg_catperpage == 0) { $config->jg_catperpage = 10; } $gesamtseiten = floor($count2 / $config->jg_catperpage);