Files
Testing/include/functions_club.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

541 lines
23 KiB
PHP

<?php
/* $Id: functions_club.php 44 2009-01-30 03:45:23Z john $ */
//
// THIS FILE CONTAINS club-RELATED FUNCTIONS
//
// FUNCTIONS IN THIS CLASS:
// action_privacy_club()
// search_club()
// mediatag_club()
// deleteuser_club()
// club_privacy_levels()
// site_statistics_club()
//
defined('SE_PAGE') or exit();
// THIS FUNCTION ADDS A CLAUSE IN ACTION QUERY TO ACCOUNT FOR club PRIVACY
// INPUT:
// OUTPUT:
function action_privacy_club($args)
{
global $user;
$args['actions_query'] .= " WHEN se_actions.action_object_owner='club' THEN
CASE
WHEN ((se_actions.action_object_privacy & 64) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_actions.action_object_privacy & 128) AND '{$user->user_exists}'=0)
THEN TRUE
"./*WHEN ((se_actions.action_object_privacy & 4) AND (SELECT TRUE FROM se_clubmembers WHERE clubmember_club_id=se_actions.action_object_owner_id AND clubmember_user_id='{$user->user_info['user_id']}' AND clubmember_status='1' LIMIT 1))
THEN TRUE*/"
WHEN ((se_actions.action_object_privacy & 8) AND (SELECT TRUE FROM se_friends JOIN se_clubs ON se_friends.friend_user_id1=se_clubs.club_user_id WHERE se_clubs.club_id=se_actions.action_object_owner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
"/*WHEN ((se_actions.action_object_privacy & 16) AND (SELECT TRUE FROM se_friends JOIN se_clubmembers ON se_friends.friend_user_id1=se_clubmembers.clubmember_user_id WHERE se_clubmembers.clubmember_club_id=se_actions.action_object_owner_id AND clubmember_status='1' AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE*/."
"./*WHEN ((se_actions.action_object_privacy & 32) AND (SELECT TRUE FROM se_clubmembers LEFT JOIN se_friends AS friends_primary ON se_clubmembers.clubmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE clubmember_status='1' AND clubmember_club_id=se_actions.action_object_owner_id AND friends_primary.friend_status='1' AND friends_secondary.friend_status='1' AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE*/"
ELSE FALSE
END";
} // END action_privacy_club() FUNCTION
function action_privacy_club_new($args)
{
global $user;
$args['actions_query'] .= " WHEN bateworldcom_wall.wall.objectowner='club' THEN
CASE
WHEN ((bateworldcom_wall.wall.object_privacy & 64) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((bateworldcom_wall.wall.object_privacy & 128) AND '{$user->user_exists}'=0)
THEN TRUE
"./*WHEN ((se_actions.action_object_privacy & 4) AND (SELECT TRUE FROM se_clubmembers WHERE clubmember_club_id=se_actions.action_object_owner_id AND clubmember_user_id='{$user->user_info['user_id']}' AND clubmember_status='1' LIMIT 1))
THEN TRUE*/"
WHEN ((bateworldcom_wall.wall.object_privacy & 8) AND (SELECT TRUE FROM se_friends JOIN se_clubs ON se_friends.friend_user_id1=se_clubs.club_user_id WHERE se_clubs.club_id=bateworldcom_wall.wall.objectowner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
"/*WHEN ((se_actions.action_object_privacy & 16) AND (SELECT TRUE FROM se_friends JOIN se_clubmembers ON se_friends.friend_user_id1=se_clubmembers.clubmember_user_id WHERE se_clubmembers.clubmember_club_id=se_actions.action_object_owner_id AND clubmember_status='1' AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE*/."
"./*WHEN ((se_actions.action_object_privacy & 32) AND (SELECT TRUE FROM se_clubmembers LEFT JOIN se_friends AS friends_primary ON se_clubmembers.clubmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE clubmember_status='1' AND clubmember_club_id=se_actions.action_object_owner_id AND friends_primary.friend_status='1' AND friends_secondary.friend_status='1' AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE*/"
ELSE FALSE
END";
}
// THIS FUNCTION IS RUN DURING THE SEARCH PROCESS TO SEARCH THROUGH clubS AND club MEDIA
// INPUT:
// OUTPUT:
function search_club($vidsonly="")
{
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results;
// GET club FIELDS
$fields = $database->database_query("SELECT clubfield_id AS field_id, clubfield_type AS field_type, clubfield_options AS field_options FROM se_clubfields WHERE clubfield_type<>'5' AND (clubfield_dependency<>'0' OR (clubfield_dependency='0' AND clubfield_display<>'0'))");
$searchtext=''.$database->database_real_escape_string($search_text).'';
$club_query = "MATCH(se_clubs.club_title, se_clubs.club_desc) AGAINST('".$searchtext."' IN BOOLEAN MODE)";
// LOOP OVER FIELDS
while($field_info = $database->database_fetch_assoc($fields)) {
// TEXT FIELD OR TEXTAREA
if($field_info['field_type'] == 1 || $field_info['field_type'] == 2) {
if($club_query != "") { $club_query .= " OR "; }
$club_query .= "se_clubvalues.clubvalue_".$field_info['field_id']." LIKE '%$search_text%'";
// RADIO OR SELECT BOX
} elseif($field_info['field_type'] == 3 || $field_info['field_type'] == 4) {
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++) {
$cases[] = "WHEN languagevar_id={$options[$i]['label']} THEN {$options[$i]['value']}";
$langids[] = $options[$i]['label'];
}
if(count($cases) != 0) {
if($club_query != "") { $club_query .= " OR "; }
$club_query .= "se_clubvalues.clubvalue_".$field_info['field_id']." IN (SELECT CASE ".implode(" ", $cases)." END AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%$search_text%')";
}
// CHECKBOX
} elseif($field_info['field_type'] == 6) {
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++) {
$cases[] = "WHEN languagevar_id={$options[$i]['label']} THEN ".(pow(2, $i));
$langids[] = $options[$i][label];
}
if(count($cases) != 0) {
if($club_query != "") { $club_query .= " OR "; }
$club_query .= "se_clubvalues.clubvalue_".$field_info['field_id']." & (SELECT sum(CASE ".implode(" ", $cases)." END) AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%$search_text%')";
}
}
}
// CONSTRUCT QUERY
$club_query = "
(
SELECT
'1' AS sub_type,
se_clubs.club_id AS club_id,
se_clubs.club_title AS club_title,
se_clubs.club_datecreated AS time,
se_clubs.club_photo AS club_photo,
'' AS title,
se_clubs.club_desc AS description,
'' AS id,
'' AS extra
FROM
se_clubvalues
LEFT JOIN
se_clubs
ON
se_clubvalues.clubvalue_club_id=se_clubs.club_id
WHERE
se_clubs.club_search='1' AND approved=1
AND
($club_query)
)
UNION ALL
(
SELECT
'3' AS sub_type,
se_clubs.club_id AS club_id,
se_clubs.club_title AS club_title,
se_clubs.club_photo AS club_photo,
se_clubmedia.clubmedia_title AS title,
se_clubmedia.clubmedia_date AS time,
se_clubmedia.clubmedia_desc AS description,
se_clubmedia.clubmedia_id AS id,
se_clubmedia.clubmedia_ext AS extra
FROM
se_clubmedia,
se_clubalbums,
se_clubs
WHERE
se_clubmedia.approved=1 AND se_clubmedia.clubmedia_clubalbum_id=se_clubalbums.clubalbum_id AND
se_clubalbums.clubalbum_club_id=se_clubs.club_id AND
se_clubs.club_search='1' AND club_privacy='127' AND se_clubs.approved=1
AND
(
MATCH(se_clubmedia.clubmedia_title, se_clubmedia.clubmedia_desc) AGAINST('".$searchtext."' IN BOOLEAN MODE)
)
)
UNION ALL
(
SELECT
'2' AS sub_type,
se_clubs.club_id AS club_id,
se_clubs.club_title AS club_title,
se_clubs.club_photo AS club_photo,
se_clubtopics.clubtopic_subject AS title,
se_clubtopics.clubtopic_date AS time,
se_clubposts.clubpost_body AS description,
se_clubtopics.clubtopic_id AS id,
se_clubposts.clubpost_id AS extra
FROM
se_clubposts,
se_clubtopics,
se_clubs
WHERE
se_clubposts.clubpost_clubtopic_id=se_clubtopics.clubtopic_id AND
se_clubtopics.clubtopic_club_id=se_clubs.club_id AND
se_clubs.club_search='1' AND club_privacy='127' AND se_clubs.approved=1
AND
(
MATCH(se_clubposts.clubpost_body) AGAINST('".$searchtext."' IN BOOLEAN MODE) AND se_clubposts.clubpost_deleted=0
)
) ORDER BY sub_type ASC";
// GET TOTAL club RESULTS
$total_clubs = $database->database_num_rows($database->database_query($club_query." LIMIT 201"));
// IF NOT TOTAL ONLY
if($t == "club") {
// MAKE club PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page+1;
// SEARCH clubS
$clubs = $database->database_query($club_query." LIMIT $start, $limit");
while($club_info = $database->database_fetch_assoc($clubs)) {
// SET UP club
$club = new se_club();
$club->club_info['club_id'] = $club_info['club_id'];
$club->club_info['club_photo'] = $club_info['club_photo'];
$thumb_path = $club->club_photo();
// IF DESCRIPTION IS LONG
if(strlen($club_info['description']) > 150) { $club_info['description'] = substr($club_info['description'], 0, 147)."..."; }
if(strlen($club_info['club_desc']) > 150) { $club_info['club_desc'] = substr($club_info['club_desc'], 0, 147)."..."; }
// RESULT IS A club
if($club_info["sub_type"] == 1)
{
$result_url = $url->url_create('club', NULL, $club_info['club_id']);
$result_name = 2000292;
$result_name_1 = $club_info['club_title'];
$result_desc = 2000295;
$result_desc_1 = $club_info['description'];
}
// RESULT IS A PHOTO
elseif($club_info['sub_type'] == 3)
{
$result_url = $url->url_create('club_media', NULL, $club_info['club_id'], $club_info['id']);
$result_name = 2000293;
$result_name_1 = $club_info['title'];
$result_desc = 2000296;
$result_desc_1 = $url->url_create('club', NULL, $club_info['club_id']);
$result_desc_2 = $club_info['club_title'];
$result_desc_3 = $club_info['description'];
// SET THUMBNAIL, IF AVAILABLE
switch($club_info['extra'])
{
case "jpeg": case "jpg": case "gif": case "png": case "bmp": case "JPEG": case "JPG": case "GIF": case "PNG": case "BMP":
$thumb_path = IMAGECDN1.str_replace("./", "", $club->club_dir($club->club_info['club_id']).$club_info['club_photo']);
break;
case "mp3": case "mp4": case "wav":
$thumb_path = "./images/icons/audio_big.gif";
break;
case "mpeg": case "mpg": case "mpa": case "avi": case "swf": case "mov": case "ram": case "rm":
$thumb_path = "./images/icons/video_big.gif";
break;
default:
$thumb_path = "./images/icons/file_big.gif";
}
//if(!file_exists($thumb_path)) { $thumb_path = "./images/icons/file_big.gif"; }
}
// RESULT IS A DISCUSSION POST
else
{
$result_url = $url->url_create('club_discussion_post', NULL, $club_info['club_id'], $club_info['id'], $club_info['extra']);
$result_name = 2000294;
$result_name_1 = $club_info['title'];
$result_desc = 2000297;
$result_desc_1 = $url->url_create('club', NULL, $club_info['club_id']);
$result_desc_2 = $club_info['club_title'];
$result_desc_3 = $club_info['description'];
}
$results[] = Array(
'result_url' => $result_url,
'result_icon' => $thumb_path,
'result_name' => $result_name,
'result_name_1' => $result_name_1,
'result_desc' => $result_desc,
'time' => $club_info['time'],
'result_desc_1' => $result_desc_1,
'result_desc_2' => $result_desc_2,
'result_desc_3' => $result_desc_3
);
}
// SET TOTAL RESULTS
$total_results = $total_clubs;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(2000291, 2000292, 2000293, 2000294, 2000295, 2000296, 2000297);
if($total_clubs > 200) { $total_clubs = "200+"; }
$search_objects[] = Array(
'search_type' => 'club',
'search_lang' => 2000291,
'search_total' => $total_clubs
);
//if(SE_DEBUG1){echo time()."<br>";}
}
// END search_club() FUNCTION
// THIS FUNCTION IS RUN WHEN RETRIEVING PHOTOS OF A USER
// INPUT:
// OUTPUT:
function mediatag_club()
{
global $photo_query, $tag_query, $owner, $user;
if($photo_query != "") { $photo_query .= " UNION ALL "; }
$photo_query .= "(SELECT 'clubmedia' AS type,
'clubmedia_id' AS type_id,
'club' AS type_prefix,
clubmediatag_clubmedia_id AS media_id,
clubmediatag_date AS mediatag_date,
'club.php?club_id=[media_parent_id]&v=photos' AS media_parent_url,
club_id AS media_parent_id,
club_title AS media_parent_title,
club_user_id AS owner_user_id,
0 AS user_id,
'' AS user_username,
'' AS user_fname,
'' AS user_lname,
CONCAT('./uploads_club/', club_id+999-((club_id-1)%1000), '/', club_id, '/') AS media_dir,
clubmedia_date AS media_date,
clubmedia_title AS media_title,
clubmedia_desc AS media_desc,
clubmedia_ext AS media_ext,
clubmedia_filesize AS media_filesize,
CASE
WHEN ((se_clubalbums.clubalbum_tag & 64) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_clubalbums.clubalbum_tag & 128) AND '{$user->user_exists}'=0)
THEN TRUE
WHEN ((se_clubalbums.clubalbum_tag & 1) AND '{$user->user_exists}'<>0 AND club_user_id='{$user->user_info['user_id']}')
THEN TRUE
WHEN ((se_clubalbums.clubalbum_tag & 2) AND (SELECT TRUE FROM se_clubmembers WHERE clubmember_club_id=se_clubalbums.clubalbum_club_id AND clubmember_user_id='{$user->user_info['user_id']}' AND clubmember_status='1' AND clubmember_rank='1' LIMIT 1))
THEN TRUE
WHEN ((se_clubalbums.clubalbum_tag & 4) AND (SELECT TRUE FROM se_clubmembers WHERE clubmember_club_id=se_clubalbums.clubalbum_club_id AND clubmember_user_id='{$user->user_info['user_id']}' AND clubmember_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_clubalbums.clubalbum_tag & 8) AND (SELECT TRUE FROM se_friends JOIN se_clubs AS t1 ON se_friends.friend_user_id1=t1.club_user_id WHERE t1.club_id=se_clubalbums.clubalbum_club_id && friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_clubalbums.clubalbum_tag & 16) AND (SELECT TRUE FROM se_friends JOIN se_clubmembers ON se_friends.friend_user_id1=se_clubmembers.clubmember_user_id WHERE se_clubmembers.clubmember_club_id=se_clubalbums.clubalbum_club_id && clubmember_status='1' AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_clubalbums.clubalbum_tag & 32) AND (SELECT TRUE FROM se_clubmembers LEFT JOIN se_friends AS friends_primary ON se_clubmembers.clubmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE clubmember_status='1' AND clubmember_club_id=se_clubalbums.clubalbum_club_id AND friends_primary.friend_status='1' AND friends_secondary.friend_status='1' AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE
ELSE FALSE
END
AS allowed_to_tag,
CASE
WHEN ((se_clubs.club_comments & 64) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_clubs.club_comments & 128) AND '{$user->user_exists}'=0)
THEN TRUE
WHEN ((se_clubs.club_comments & 1) AND '{$user->user_exists}'<>0 AND club_user_id='{$user->user_info['user_id']}')
THEN TRUE
WHEN ((se_clubs.club_comments & 2) AND (SELECT TRUE FROM se_clubmembers WHERE clubmember_club_id=se_clubs.club_id AND clubmember_user_id='{$user->user_info['user_id']}' AND clubmember_status='1' AND clubmember_rank='1' LIMIT 1))
THEN TRUE
WHEN ((se_clubs.club_comments & 4) AND (SELECT TRUE FROM se_clubmembers WHERE clubmember_club_id=se_clubs.club_id AND clubmember_user_id='{$user->user_info['user_id']}' AND clubmember_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_clubs.club_comments & 8) AND (SELECT TRUE FROM se_friends JOIN se_clubs AS t1 ON se_friends.friend_user_id1=t1.club_user_id WHERE t1.club_id=se_clubs.club_id && friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_clubs.club_comments & 16) AND (SELECT TRUE FROM se_friends JOIN se_clubmembers ON se_friends.friend_user_id1=se_clubmembers.clubmember_user_id WHERE se_clubmembers.clubmember_club_id=se_clubs.club_id && clubmember_status='1' AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_clubs.club_comments & 32) AND (SELECT TRUE FROM se_clubmembers LEFT JOIN se_friends AS friends_primary ON se_clubmembers.clubmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE clubmember_status='1' AND clubmember_club_id=se_clubs.club_id AND friends_primary.friend_status='1' AND friends_secondary.friend_status='1' AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE
ELSE FALSE
END
AS allowed_to_comment
FROM se_clubmediatags
LEFT JOIN se_clubmedia
ON se_clubmediatags.clubmediatag_clubmedia_id=se_clubmedia.clubmedia_id
LEFT JOIN se_clubalbums
ON se_clubmedia.clubmedia_clubalbum_id=se_clubalbums.clubalbum_id
LEFT JOIN se_clubs
ON se_clubalbums.clubalbum_club_id=se_clubs.club_id
WHERE se_clubmediatags.clubmediatag_user_id='{$owner->user_info['user_id']}'
)";
$tag_query['clubmedia'] = "SELECT clubmediatag_id AS mediatag_id, clubmediatag_clubmedia_id AS mediatag_media_id, clubmediatag_user_id AS mediatag_user_id, clubmediatag_x AS mediatag_x, clubmediatag_y AS mediatag_y, clubmediatag_height AS mediatag_height, clubmediatag_width AS mediatag_width, clubmediatag_text AS mediatag_text, clubmediatag_date AS mediatag_date, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname FROM se_clubmediatags LEFT JOIN se_users ON se_clubmediatags.clubmediatag_user_id=se_users.user_id WHERE clubmediatag_clubmedia_id='[media_id]' ORDER BY clubmediatag_id ASC";
} // END mediatag_club() FUNCTION
// THIS FUNCTION IS RUN WHEN A USER IS DELETED
// INPUT: $user_id REPRESENTING THE USER ID OF THE USER BEING DELETED
// OUTPUT:
function deleteuser_club($user_id)
{
global $database;
// INITATE club OBJECT
$club = new se_club($user_id);
// LOOP OVER clubS AND DELETE THEM
$clubs = $database->database_query("SELECT club_id FROM se_clubs WHERE club_user_id='{$user_id}'");
while($club_info = $database->database_fetch_assoc($clubs)) {
$club->club_delete($club_info['club_id']);
}
// DELETE USER FROM ALL clubS
$database->database_query("DELETE FROM se_clubmembers WHERE clubmember_user_id='{$user_id}'");
$database->database_query("DELETE FROM se_clubsubscribes WHERE clubsubscribe_user_id='{$user_id}'");
$database->database_query("UPDATE se_clubmediatags SET clubmediatag_user_id='0' WHERE clubmediatag_user_id='{$user_id}'");
}
// END deleteuser_club() FUNCTION
// THIS FUNCTION RETURNS TEXT CORRESPONDING TO THE GIVEN club PRIVACY LEVEL
// INPUT: $privacy_level REPRESENTING THE LEVEL OF club PRIVACY
// OUTPUT: A STRING EXPLAINING THE GIVEN PRIVACY SETTING
function club_privacy_levels($privacy_level)
{
global $functions_club;
switch($privacy_level)
{
case 255: $privacy = 323; break;
case 127: $privacy = 324; break;
case 63: $privacy = "a55"; break;
case 31: $privacy = "a56"; break;
case 15: $privacy = "a57"; break;
case 7: $privacy = "a58"; break;
case 3: $privacy = "a59"; break;
case 1: $privacy = "a60"; break;
case 0: $privacy = 329; break;
default: $privacy = ""; break;
}
return $privacy;
}
// END club_privacy_levels() FUNCTION
// THIS FUNCTION IS RUN WHEN GENERATING SITE STATISTICS
// INPUT:
// OUTPUT:
function site_statistics_club(&$args)
{
global $database;
$statistics =& $args['statistics'];
// NOTE: CACHING WILL BE HANDLED BY THE FUNCTION THAT CALLS THIS
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(club_id) AS total FROM se_clubs"));
$statistics['clubs'] = array(
'title' => 2000338,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
/*
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(clubcomment_id) AS total FROM se_clubcomments"));
$statistics['clubcomments'] = array(
'title' => 2000339,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(clubtopic_id) AS total FROM se_clubtopics"));
$statistics['clubtopics'] = array(
'title' => 2000340,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(clubpost_id) AS total FROM se_clubposts"));
$statistics['clubposts'] = array(
'title' => 2000341,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(clubmedia_id) AS total FROM se_clubmedia"));
$statistics['clubmedia'] = array(
'title' => 2000342,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(clubmember_id) AS total FROM se_clubmembers WHERE clubmember_approved=1 && clubmember_status=1"));
$statistics['clubmembers'] = array(
'title' => 2000343,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
*/
}
// END site_statistics_club() FUNCTION
?>