setQuery("SELECT * FROM #__gj_options");
if (!$result=$database->query()) {
echo $database->stderr();
return;
}
$rows=$database->loadObjectList();
$row=&$rows[0];
define ('ONPAGE',$row->onpage); //number of groups on page
define ('ONPAGE_MEMBERS',$row->onpage_members); //number of users on page
define('BLOGM',$row->blogm);//number message on group frontpage
define ('NOPHOTO',$row->nophoto); //This is the URL of the image used for user who have no image :)
define ('ADMINEMAIL',$row->admin_email); //This is the email address of the admin for Notifications
define ('SEND_ADMIN_EMAILS',$row->send_admin_emails);
define ('ALLOWCREATEGROUPS',$row->create_groups);
define('NEEDAPPROVAL',$row->approval);// write 1 - to approval, or 0 - group will not premoderated
define('NOTIFY',$row->notify);
define('NOTIFYJOIN',$row->notifyjoin);
define('VERSION',$row->version);
define('JB',$row->jb);
//If we are using the forum integration, are we using Joomlaboard or Fireboard?
if(JB) {
if (file_exists('components/com_fireboard/fireboard.php')) {
define('PREFIX','fb');
define('FORUMPATH','com_fireboard');
} else {
define('PREFIX','sb');
define('FORUMPATH','com_joomlaboard');
}
}
//define('EVENTLIST',$row->eventlist);
define('EVENTLIST','1');
define('WYSIWYG',$row->wysiwyg);//Use the global wysiwyg editor if true
define('DEFAULT_LOGO',$row->nophoto_logo);
define('NONREG',$row->nonreg);
define('REAL_NAMES',$row->real_names);
define('BUL_CREATOR',$row->bul_creator);
define('HIDEPRIVATE',$row->hideprivate);
define('WYSIWYG_WIDTH',$row->wysiwyg_width);
define('WYSIWYG_HEIGHT',$row->wysiwyg_height);
define('WYSIWYG_ROWS',$row->wysiwyg_rows);
define('WYSIWYG_COLS',$row->wysiwyg_cols);
define('AJAX_ACTIVE', $row->ajax_active);
define('AJAX_ACCESS', $row->ajax_access);
define('AJAX_MESSAGE', $row->ajax_message);
define('TEMPLATE', $row->template);
//Users without avatars cannot see other users avatars, CBE only
if (file_exists('administrator/components/com_comprofiler/enhanced_admin/enhanced_config.php')) {
include_once('administrator/components/com_comprofiler/enhanced_admin/enhanced_config.php');
define('PIC2PIC',$enhanced_Config['pic2pic']);
} else {
define('PIC2PIC','0');
}
if (PIC2PIC) {
$query="SELECT COUNT(id) FROM #__comprofiler WHERE user_id=".$my->id." AND avatar IS NOT NULL AND avatarapproved='1'";
$database->setQuery($query);
$mypic = $database->loadResult();
}
$pms = $row->pms;
$logosize = $row->logosize. "px";
$date_format = $row->date_form;
$jb_cat = $row->jb_cat;
$todo = mosGetParam( $_REQUEST ,'task', 0 ) ;
$exgroup = intval( mosGetParam( $_REQUEST, 'groupid',0));
$groupname = mosGetParam( $_REQUEST, 'groupname',0);
$mainframe->setPageTitle(GJ_TITLE);
// put the stylesheet in the head-section
$csslink = '';
//echo 'link:
';
return $links;
}
function checkuser($groupid,$userid) {
global $database;
$query="SELECT COUNT(*) FROM #__gj_users "
. "WHERE id_user='$userid' "
. "AND id_group='$groupid'";
$database->setQuery($query);
if(!$result=$database->query()) {
echo $database->stderr();
return;
}
$exist = $database->loadResult();
if (!$exist==0)
return 1;
else return 0;
}
function checkuseractive($groupid,$userid) {
global $database;
$query="SELECT COUNT(*) FROM #__gj_users "
. "WHERE id_user='$userid' "
. "AND id_group='$groupid' "
. "AND status='active'";
$database->setQuery($query);
if(!$result=$database->query()) {
echo $database->stderr();
return;
}
$exist = $database->loadResult();
if (!$exist==0)
return 1;
else return 0;
}
function ismoder($groupid,$userid) {
//Check to see if the user viewing is the moderator
global $database;
$query="SELECT COUNT(*) FROM #__gj_groups "
. "WHERE id='$groupid' "
. "AND user_id='$userid'";
$database->setQuery($query);
if(!$result=$database->query()) {
echo $database->stderr();
return;
}
$exist = $database->loadResult();
if (!$exist==0)
return 1;
else return 0;
}
function groupusercount($groupid) {
// Here is where I find out how many members are in a group
//for display on the category pages
global $database;
$query="SELECT COUNT(*) FROM #__gj_users "
. "WHERE id_group='$groupid' "
. "AND status='active'";
$database->setQuery($query);
if(!$result=$database->query()) {
echo $database->stderr();
return;
}
$usercount= $database->loadResult();
//return the user count for group
return $usercount;
}
function latestmembers($gid) {
global $database,$mosConfig_lang,$mypic ;
$query="SELECT b.name, b.username, b.id, c.avatar "
. "FROM #__gj_users AS a INNER JOIN #__users AS b "
. "ON a.id_user = b.id "
. "INNER JOIN #__comprofiler AS c "
. "ON b.id = c.user_id "
. "WHERE a.id_group ='".$gid
. "' AND a.status = 'active' ORDER BY a.date DESC LIMIT 3";
$database->setQuery($query);
if(!$result=$database->query()) {
echo $database->stderr();
return;
}
$rows=$database->loadObjectList();
echo "
";
}
function latestforumposts($catid) {
global $database;
// check if joomlaboard is installed
if (!file_exists('components/'.FORUMPATH) || !JB) {
return;
}
$query="SELECT * FROM #__".PREFIX."_messages "
. "WHERE catid='".$catid."' ORDER BY time DESC LIMIT 5";
$database->setQuery($query);
if(!$result=$database->query()) {
echo $database->stderr();
return;
}
$rows=$database->loadObjectList();
$total=count($rows);
echo "
".$row->author_name;
} else {
echo GJ_NO_MESSAGE;
}
}
function checkImage($avatar) {
$mosConfig_absolute_path = $mainframe->getCfg('absolute_path');
if (substr($avatar, 0, 7) == 'gallery') {
$thumbnail = "/images/comprofiler/".$avatar;
} else if ($avatar != '') {
$thumbnail = "/images/comprofiler/tn".$avatar;
} else {
$thumbnail = "/components/com_comprofiler/plugin/language/".$fileLang."/images/tnnophoto.jpg";
}
// check if thumbnails exists
if (file_exists($mosConfig_absolute_path.$thumbnail))
{
// image exists
$image=$mosConfig_live_site.$thumbnail;
} else {
// image not found
$thumbnail="/components/com_comprofiler/plugin/language/".$fileLang."/images/tnnophoto.jpg";
// check if default image exists in specific language
if (file_exists($mosConfig_absolute_path.$thumbnail))
{
$image=$mosConfig_live_site.$thumbnail;
} else {
$image=$mosConfig_live_site."/components/com_comprofiler/plugin/"
."language/default_language/images/tnnophoto.jpg";
}
}
}
function transfer($owner_name, $group_id) {
global $database;
$query = "SELECT a.id FROM #__users AS a, #__gj_users AS b WHERE a.name = '".$owner_name."' OR a.username = '".$owner_name."' AND b.id_group = ".$group_id." AND a.id = b.id_user";
$database->setQuery($query);
$owner_id = $database->loadResult();
if($owner_id) {
$query = "UPDATE #__gj_groups SET creator = '".$owner_name."', user_id = '".$owner_id."' WHERE id = ".$group_id;
$database->setQuery($query);
$database->query();
mosRedirect(sefRelToAbs("index.php?option=com_groupjive&task=showgroup&groupid=".$group_id), GJ_TRANSFERED);
} else {
mosRedirect(sefRelToAbs("index.php?option=com_groupjive&task=showgroup&groupid=".$group_id), "Sorry, must be a member of the group");
}
}
?>