/**
* 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);
}