break; case "showupload": if (!$user->id) { $app->redirect($url, JText::_('You must login first')); } showUpload(); break; case "upload": batchUpload(); break; case "userpanel": userPanel(); break; case "send2friend": send2friend(); break; case 'captcha': captcha(); break; case 'checkcatname': require_once JPATH_COMPONENT . DS . 'includes' . DS . 'datso.usercategory.php'; break; default: GalleryHeader(); echo dgCategories($catid); GalleryFooter(); break; } $tasks = array('showupload', 'editpic'); $gravity = in_array($task, $tasks) ? 'w' : 's'; echo "<script type=\"text/javascript\">datso(\".dgtip\").dgtooltip({gravity: '" . $gravity . "', fade: true, html: true});</script> ";
function userPanel() { $app = JFactory::getApplication('site'); require JPATH_COMPONENT_ADMINISTRATOR . DS . 'config.datsogallery.php'; $db = JFactory::getDBO(); $user = JFactory::getUser(); $doc = JFactory::getDocument(); $menu = JSite::getMenu(); $ids = $menu->getItems('link', 'index.php?option=com_datsogallery&view=datsogallery'); $itemid = isset($ids[0]) ? '&Itemid=' . $ids[0]->id : ''; $uri = JFactory::getURI(); $return = $uri->toString(); $url = 'index.php?option=com_users&view=login'; $url .= '&return=' . base64_encode($return); if (!$user->id) { $app->redirect($url, JText::_('You must login first')); } $doc->setTitle(JText::_('COM_DATSOGALLERY_USER_PANEL')); $limit = JRequest::getVar('limit', 15, '', 'int'); $limitstart = JRequest::getVar('limitstart', 0, '', 'int'); $filter_order = $app->getUserStateFromRequest('com_datsogallery.filter_order', 'filter_order', 'a.id', 'cmd'); $filter_order_Dir = $app->getUserStateFromRequest('com_datsogallery.filter_order_Dir', 'filter_order_Dir', '', 'word'); $where = array(); if (!in_array($filter_order, array('a.id', 'a.imgtitle', 'a.imgdate', 'a.approved', 'a.notify', 'category'))) { $filter_order = 'a.id'; } if (!in_array(strtoupper($filter_order_Dir), array('ASC', 'DESC'))) { $filter_order_Dir = ''; } $orderby = ' ORDER BY ' . $filter_order . ' ' . $filter_order_Dir; $db->setQuery('SELECT count(*) FROM #__datsogallery as a WHERE a.owner_id = ' . $user->id); $total = $db->loadResult(); jimport('joomla.html.pagination'); $pagination = new JPagination($total, $limitstart, $limit); GalleryHeader(); echo "<div class=\"datso_pgn\">"; echo $pagination->getPagesLinks(); echo "</div><div style=\"clear:both\"></div>"; echo "<form method=\"post\" name=\"adminForm\">"; echo "<table class=\"dguserpanel\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\">\n"; echo " <thead><tr>"; echo " <th width=\"1%\" nowrap=\"nowrap\">" . str_replace('Joomla.tableOrdering', 'tableOrdering', JHTML::_('grid.sort', JText::_('COM_DATSOGALLERY_ID'), 'a.id', $filter_order_Dir, $filter_order)) . "</th>\n"; echo " <th class=\"title\">" . str_replace('Joomla.tableOrdering', 'tableOrdering', JHTML::_('grid.sort', JText::_('COM_DATSOGALLERY_PIC_NAME') . ' ', 'a.imgtitle', $filter_order_Dir, $filter_order)) . "</th>\n"; echo " <th class=\"title\">" . str_replace('Joomla.tableOrdering', 'tableOrdering', JHTML::_('grid.sort', JText::_('COM_DATSOGALLERY_CATEGORY') . ' ', 'category', $filter_order_Dir, $filter_order)) . "</th>\n"; echo " <th width=\"16%\" nowrap=\"nowrap\">" . str_replace('Joomla.tableOrdering', 'tableOrdering', JHTML::_('grid.sort', JText::_('COM_DATSOGALLERY_DATE_ADD') . ' ', 'a.imgdate', $filter_order_Dir, $filter_order)) . "</th>\n"; if ($ad_approve) { echo " <th width=\"6%\" nowrap=\"nowrap\">" . str_replace('Joomla.tableOrdering', 'tableOrdering', JHTML::_('grid.sort', JText::_('COM_DATSOGALLERY_APPROWED') . ' ', 'a.approved', $filter_order_Dir, $filter_order)) . "</th>\n"; } if ($ad_comment_notify) { echo " <th width=\"6%\" nowrap=\"nowrap\">" . str_replace('Joomla.tableOrdering', 'tableOrdering', JHTML::_('grid.sort', JText::_('COM_DATSOGALLERY_COMMENT_NOTIFY') . ' ', 'a.notify', $filter_order_Dir, $filter_order)) . "</th>\n"; } echo " <th colspan=\"2\" width=\"10%\" nowrap=\"nowrap\">" . JText::_('COM_DATSOGALLERY_ACTION') . "</th>\n"; echo " </tr>\n"; echo "</thead>\n"; echo "<tbody>\n"; $where[] = 'a.catid = cc.cid'; $where[] = 'a.owner_id = ' . $user->id; $pics = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $query = "SELECT a.*, cc.name AS category FROM #__datsogallery AS a, #__datsogallery_catg AS cc" . $pics . $orderby; $db->setQuery($query, $pagination->limitstart, $pagination->limit); $rows = $db->loadObjectList(); $k = 0; if (count($rows)) { foreach ($rows as $row) { $k = 1 - $k; $kp = $k + 1; $imgprev = resize($row->imgoriginalname, 120, 120, $ad_crop, $ad_cropratio, 0, $row->catid); $db->setQuery("SELECT COUNT(cmtid) FROM #__datsogallery_comments WHERE cmtpic = " . $row->id); $comments = $db->loadResult(); $overlib = '<table>'; $overlib .= '<tr>'; $overlib .= '<td>'; $overlib .= JText::_('COM_DATSOGALLERY_DATE_ADD'); $overlib .= '</td>'; $overlib .= '<td>: '; $overlib .= strftime($ad_datef, $row->imgdate); $overlib .= '</td>'; $overlib .= '</tr>'; $overlib .= '<tr>'; $overlib .= '<td>'; $overlib .= JText::_('COM_DATSOGALLERY_HITS'); $overlib .= '</td>'; $overlib .= '<td>: '; $overlib .= $row->imgcounter; $overlib .= '</td>'; $overlib .= '</tr>'; $overlib .= '<tr>'; $overlib .= '<td>'; $overlib .= JText::_('COM_DATSOGALLERY_DOWNLOADS'); $overlib .= '</td>'; $overlib .= '<td>: '; $overlib .= $row->imgdownloaded; $overlib .= '</td>'; $overlib .= '</tr>'; if ($row->imgvotes > 0) { $fimgvotesum = number_format($row->imgvotesum / $row->imgvotes, 2, ",", "."); $dgvotes = "{$fimgvotesum} / {$row->imgvotes}"; } else { $dgvotes = JText::_('COM_DATSOGALLERY_NO_VOTES'); } $overlib .= '<tr>'; $overlib .= '<td>'; $overlib .= JText::_('COM_DATSOGALLERY_RATING'); $overlib .= '</td>'; $overlib .= '<td>: '; $overlib .= $dgvotes; $overlib .= '</td>'; $overlib .= '</tr>'; $overlib .= '<tr>'; $overlib .= '<td>'; $overlib .= JText::_('COM_DATSOGALLERY_COMMENT1'); $overlib .= '</td>'; $overlib .= '<td>: '; $overlib .= $comments; $overlib .= '</td>'; $overlib .= '</tr>'; $overlib .= '</table>'; echo " <tr class=\"row" . $k . "\">\n"; echo " <td align=\"center\">" . $row->id . "</td>\n"; echo " <td><a href=\"" . JRoute::_('index.php?option=com_datsogallery&task=editpic&uid=' . $row->id . $itemid) . "\" id=\"<strong>" . jsspecialchars($row->imgtitle) . "</strong><br /><br /><div style='text-align:center'><img src='" . $imgprev . "' class='dgimg' /></div><br />" . $overlib . "\" class=\"dgtip\">" . $row->imgtitle . "</a></td>\n"; echo " <td>" . catNameById($row->catid) . "</td>\n"; echo " <td align=\"center\" style=\"font-size: 10px\">" . strftime($ad_datef, $row->imgdate) . "</td>\n"; if ($ad_approve) { $a_pic = $row->approved ? dgTip(JText::_('COM_DATSOGALLERY_PIC_APPROVED'), 'dg-accept-icon.png') : dgTip(JText::_('COM_DATSOGALLERY_PIC_PENDING'), 'dg-pending-icon.png'); echo " <td align=\"center\">" . $a_pic . "</td>\n"; } if ($ad_comment_notify) { $notify = $row->notify ? dgTip(JText::_('COM_DATSOGALLERY_COMMENT_NOTIFY_EMAIL_ICON'), 'email.png') : dgTip(JText::_('COM_DATSOGALLERY_COMMENT_NOTIFY_NO_EMAIL_ICON'), 'no_email.png'); echo " <td align=\"center\">" . $notify . "</td>\n"; } echo " <td align=\"center\">"; echo "<a href='" . JRoute::_("index.php?option=com_datsogallery&task=editpic&uid=" . $row->id . $itemid) . "'>"; echo "<img src='" . JURI::base(true) . "/components/com_datsogallery/images/" . $dg_theme . "/edit.png' width='16' height='16' border='0' title='" . JText::_('COM_DATSOGALLERY_EDIT') . "' /></a>"; echo " </td>\n"; echo " <td align=\"center\">"; echo "<a href=\"javascript:if (confirm('" . JText::_('COM_DATSOGALLERY_SURE_DELETE_SELECT_ITEM') . "')){ location.href='" . JRoute::_("index.php?option=com_datsogallery&task=deletepic&uid=" . $row->id . $itemid) . "';}\" title='" . JText::_('COM_DATSOGALLERY_DELETE') . "'>"; echo "<img src='" . JURI::base(true) . "/components/com_datsogallery/images/" . $dg_theme . "/dg-delete-image-icon.png' width='16' border='0' /></a>\n"; echo " </td>\n"; echo " </tr>\n"; } } else { echo " <tr class=\"row" . $k . "\">"; echo " <td colspan=\"7\">" . JText::_('COM_DATSOGALLERY_NOT_HAVE_PIC') . "</td>\n"; echo " </tr>\n"; } echo "</tbody>\n"; echo "</table>\n"; echo "<input type=\"hidden\" name=\"filter_order\" value=\"" . $filter_order . "\" />\n"; echo "<input type=\"hidden\" name=\"filter_order_Dir\" value=\"" . $filter_order_Dir . "\" />"; echo JHTML::_('form.token'); echo "</form>\n"; echo '<div class="datso_pgn">'; echo $pagination->getPagesLinks(); echo "</div>"; GalleryFooter(); }