/**
* Returns all user tags for XTemplate
*
* @param mixed $user_data User Info Array
* @param string $tag_prefix Prefix for tags
* @param string $emptyname Name text if user is not exist
* @param bool $allgroups Build info about all user groups
* @param bool $cacheitem Cache tags
* @return array
* @global CotDB $db
*/
function cot_generate_usertags($user_data, $tag_prefix = '', $emptyname = '', $allgroups = false, $cacheitem = true)
{
global $db, $cot_extrafields, $cot_groups, $cfg, $L, $user_cache, $db_users;
static $extp_first = null, $extp_main = null;
$return_array = array();
if (is_null($extp_first)) {
$extp_first = cot_getextplugins('usertags.first');
$extp_main = cot_getextplugins('usertags.main');
}
/* === Hook === */
foreach ($extp_first as $pl) {
include $pl;
}
/* ===== */
$user_id = is_array($user_data) ? (int) $user_data['user_id'] : (is_numeric($user_data) ? (int) $user_data : 0);
if (isset($user_cache[$user_id])) {
$temp_array = $user_cache[$user_id];
} else {
if (!is_array($user_data) && $user_id > 0) {
$sql = $db->query("SELECT * FROM {$db_users} WHERE user_id = {$user_id} LIMIT 1");
$user_data = $sql->fetch();
} else {
if (!is_array($user_data)) {
$user_data = array();
}
}
if (is_array($user_data) && $user_data['user_id'] > 0 && !empty($user_data['user_name'])) {
$user_data['user_birthdate'] = cot_date2stamp($user_data['user_birthdate']);
$user_data['user_text'] = cot_parse($user_data['user_text'], $cfg['users']['usertextimg']);
$temp_array = array('ID' => $user_data['user_id'], 'NAME' => cot_build_user($user_data['user_id'], htmlspecialchars($user_data['user_name'])), 'NICKNAME' => htmlspecialchars($user_data['user_name']), 'DETAILSLINK' => cot_url('users', 'm=details&id=' . $user_data['user_id'] . '&u=' . htmlspecialchars($user_data['user_name'])), 'DETAILSLINKSHORT' => cot_url('users', 'm=details&id=' . $user_data['user_id']), 'FULL_NAME' => htmlspecialchars(cot_user_full_name($user_data)), 'TITLE' => $cot_groups[$user_data['user_maingrp']]['title'], 'MAINGRP' => cot_build_group($user_data['user_maingrp']), 'MAINGRPID' => $user_data['user_maingrp'], 'MAINGRPNAME' => $cot_groups[$user_data['user_maingrp']]['name'], 'MAINGRPTITLE' => cot_build_group($user_data['user_maingrp'], true), 'MAINGRPSTARS' => cot_build_stars($cot_groups[$user_data['user_maingrp']]['level']), 'MAINGRPICON' => cot_build_groupicon($cot_groups[$user_data['user_maingrp']]['icon']), 'COUNTRY' => cot_build_country($user_data['user_country']), 'COUNTRYFLAG' => cot_build_flag($user_data['user_country']), 'TEXT' => $user_data['user_text'], 'EMAIL' => cot_build_email($user_data['user_email'], $user_data['user_hideemail']), 'THEME' => $user_data['user_theme'], 'SCHEME' => $user_data['user_scheme'], 'LANG' => $user_data['user_lang'], 'GENDER' => $user_data['user_gender'] == '' || $user_data['user_gender'] == 'U' ? '' : $L['Gender_' . $user_data['user_gender']], 'BIRTHDATE' => is_null($user_data['user_birthdate']) ? '' : cot_date('date_full', $user_data['user_birthdate']), 'BIRTHDATE_STAMP' => is_null($user_data['user_birthdate']) ? '' : $user_data['user_birthdate'], 'AGE' => is_null($user_data['user_birthdate']) ? '' : cot_build_age($user_data['user_birthdate']), 'TIMEZONE' => cot_build_timezone(cot_timezone_offset($user_data['user_timezone'], false, false)) . ' ' . str_replace('_', ' ', $user_data['user_timezone']), 'REGDATE' => cot_date('datetime_medium', $user_data['user_regdate']), 'REGDATE_STAMP' => $user_data['user_regdate'], 'LASTLOG' => cot_date('datetime_medium', $user_data['user_lastlog']), 'LASTLOG_STAMP' => $user_data['user_lastlog'], 'LOGCOUNT' => $user_data['user_logcount'], 'POSTCOUNT' => $user_data['user_postcount'], 'LASTIP' => $user_data['user_lastip']);
if ($allgroups) {
$temp_array['GROUPS'] = cot_build_groupsms($user_data['user_id'], FALSE, $user_data['user_maingrp']);
}
// Extra fields
if (isset($cot_extrafields[$db_users])) {
foreach ($cot_extrafields[$db_users] as $exfld) {
$temp_array[strtoupper($exfld['field_name'])] = cot_build_extrafields_data('user', $exfld, $user_data['user_' . $exfld['field_name']]);
$temp_array[strtoupper($exfld['field_name']) . '_TITLE'] = isset($L['user_' . $exfld['field_name'] . '_title']) ? $L['user_' . $exfld['field_name'] . '_title'] : $exfld['field_description'];
$temp_array[strtoupper($exfld['field_name']) . '_VALUE'] = $user_data['user_' . $exfld['field_name']];
}
}
} else {
$temp_array = array('ID' => 0, 'NAME' => !empty($emptyname) ? $emptyname : $L['Deleted'], 'NICKNAME' => !empty($emptyname) ? $emptyname : $L['Deleted'], 'FULL_NAME' => !empty($emptyname) ? $emptyname : $L['Deleted'], 'MAINGRP' => cot_build_group(1), 'MAINGRPID' => 1, 'MAINGRPSTARS' => '', 'MAINGRPICON' => cot_build_groupicon($cot_groups[1]['icon']), 'COUNTRY' => cot_build_country(''), 'COUNTRYFLAG' => cot_build_flag(''), 'TEXT' => '', 'EMAIL' => '', 'GENDER' => '', 'BIRTHDATE' => '', 'BIRTHDATE_STAMP' => '', 'AGE' => '', 'REGDATE' => '', 'REGDATE_STAMP' => '', 'POSTCOUNT' => '', 'LASTIP' => '');
}
/* === Hook === */
foreach ($extp_main as $pl) {
include $pl;
}
/* ===== */
if (is_array($user_data) && isset($user_data['user_id'])) {
$cacheitem && ($user_cache[$user_data['user_id']] = $temp_array);
}
}
foreach ($temp_array as $key => $val) {
$return_array[$tag_prefix . $key] = $val;
}
return $return_array;
}
if ($s == 'usercount') {
$sql1 = $db->query("DROP TEMPORARY TABLE IF EXISTS tmp1");
$sql = $db->query("CREATE TEMPORARY TABLE tmp1 SELECT user_country, COUNT(*) as usercount FROM {$db_users} GROUP BY user_country");
$sql = $db->query("SELECT * FROM tmp1 WHERE 1 ORDER by usercount DESC");
$sql1 = $db->query("DROP TEMPORARY TABLE IF EXISTS tmp1");
} else {
$sql = $db->query("SELECT user_country, COUNT(*) as usercount FROM {$db_users} GROUP BY user_country ASC");
}
$sqltotal = $db->query("SELECT COUNT(*) FROM {$db_users} WHERE 1");
$totalusers = $sqltotal->fetchColumn();
$ii = 0;
while ($row = $sql->fetch()) {
$country_code = $row['user_country'];
if (!empty($country_code) && $country_code != '00') {
$ii = $ii + $row['usercount'];
$t->assign(array('STATISTICS_COUNTRY_FLAG' => cot_build_flag($country_code), 'STATISTICS_COUNTRY_COUNT' => $row['usercount'], 'STATISTICS_COUNTRY_NAME' => cot_build_country($country_code)));
$t->parse('MAIN.ROW_COUNTRY');
}
}
$sql->closeCursor();
if (cot_module_active('forums')) {
require_once cot_incfile('forums', 'module');
$totaldbviews = $db->query("SELECT SUM(fs_viewcount) FROM {$db_forum_stats}")->fetchColumn();
$totaldbposts = $db->countRows($db_forum_posts);
$totaldbtopics = $db->countRows($db_forum_topics);
if ($usr['id'] > 0) {
$sql = $db->query("SELECT COUNT(*) FROM {$db_forum_posts} WHERE fp_posterid='" . $usr['id'] . "'");
$user_postscount = $sql->fetchColumn();
$sql = $db->query("SELECT COUNT(*) FROM {$db_forum_topics} WHERE ft_firstposterid='" . $usr['id'] . "'");
$user_topicscount = $sql->fetchColumn();
$t->assign(array('STATISTICS_USER_POSTSCOUNT' => $user_postscount, 'STATISTICS_USER_TOPICSCOUNT' => $user_topicscount));
