/** * edit categories */ function editgroups($cid) { global $option; $db =& JFactory::getDBO(); $my = & JFactory::getUser(); $row = new hwdvids_group( $db ); $row->load( $cid ); // fail if checked out not by 'me' if ($row->isCheckedOut( $my->id )) { //BUMP needs change for multilanguage support mosRedirect( 'index.php?option='.$option.'&task=categories', 'The categorie $row->catname is currently being edited by another administrator.' ); } $db->SetQuery("SELECT * FROM #__hwdvidsgroups" . "\nWHERE id = $cid"); $db->loadObject($row); if ($cid) { $row->checkout( $my->id ); } else { $row->published = 1; } $query = "SELECT m.*, u.name, u.username" . " FROM #__hwdvidsgroup_membership AS m" . " LEFT JOIN #__users AS u ON u.id = m.memberid" . " WHERE m.groupid = ".$row->id; $db->SetQuery($query); $groupMembers = $db->loadObjectList(); $query = "SELECT v.*, video.title" . " FROM #__hwdvidsvideos AS video" . " LEFT JOIN #__hwdvidsgroup_videos AS v ON v.videoid = video.id" . " WHERE v.groupid = ".$row->id; $db->SetQuery($query); $groupVideos = $db->loadObjectList(); hwdvids_HTML::editgroups($row, $groupMembers, $groupVideos); }
/** * Outputs frontpage HTML * * @return Nothing */ function editGroup() { global $mosConfig_live_site, $mainframe, $Itemid; $c = hwd_vs_Config::get_instance(); $db = & JFactory::getDBO(); $my = & JFactory::getUser(); $acl= & JFactory::getACL(); if (!hwd_vs_access::checkAccess($c->gtree_grup, $c->gtree_grup_child, 4, 0, _HWDVIDS_TITLE_NOACCESS, _HWDVIDS_ALERT_REGISTERFORGRUP, _HWDVIDS_ALERT_GRUP_NOT_AUTHORIZED, "exclamation.png", 0, "core.frontend.group")) {return;} $groupid = JRequest::getInt( 'groupid', 0 ); $row = new hwdvids_group($db); $row->load( $groupid ); //check valid user if ($row->adminid != $my->id) { $mainframe->enqueueMessage(_HWDVIDS_ALERT_NOPERM); $mainframe->redirect( JURI::root() . 'index.php?option=com_hwdvideoshare&task=groups&Itemid='.$Itemid ); } //Videos that are approved(converted) and published in this group $query = 'SELECT user.*, mem.memberid' . ' FROM #__hwdvidsgroup_membership AS `mem`' . ' LEFT JOIN #__hwdvidsgroups AS `group` ON mem.groupid = group.id' . ' LEFT JOIN #__users AS `user` ON user.id = mem.memberid' . ' WHERE mem.groupid = '.$row->id ; $db->SetQuery($query); $grp_members = $db->loadObjectList(); echo $db->getErrorMsg(); hwd_vs_html::editGroupInfo($row, $grp_members); }