Файл: community.php
Строк: 98
<?php
define('_VALID', true);
require 'include/config.php';
require 'include/function_global.php';
require 'include/function_smarty.php';
$sql = "SELECT UID, username, photo, gender, rate FROM signup WHERE account_status = 'Active'
ORDER BY popularity DESC LIMIT 12";
$rs = $conn->execute($sql);
$popular_users = $rs->getrows();
$sql = "SELECT UID, username, photo, gender, rate FROM signup WHERE account_status = 'Active' AND gender = 'Male'
ORDER BY addtime DESC LIMIT 12";
$rs = $conn->execute($sql);
$male_users = $rs->getrows();
$sql = "SELECT UID, username, photo, gender, rate FROM signup WHERE account_status = 'Active' AND gender = 'Female'
ORDER BY addtime DESC LIMIT 12";
$rs = $conn->execute($sql);
$female_users = $rs->getrows();
$sql = "SELECT s.UID, s.username, s.photo, s.gender, s.rate FROM signup AS s, users_online AS u
WHERE s.account_status = 'Active' AND u.online > " .(time()-300). "
AND s.gender = 'Male' AND s.UID = u.UID
ORDER BY s.addtime DESC LIMIT 8";
$rs = $conn->execute($sql);
$online_m_users = $rs->getrows();
$sql = "SELECT s.UID, s.username, s.photo, s.gender, s.rate FROM signup AS s, users_online AS u
WHERE s.account_status = 'Active' AND u.online > " .(time()-300). "
AND s.gender = 'Female' AND s.UID = u.UID
ORDER BY s.addtime DESC LIMIT 8";
$rs = $conn->execute($sql);
$online_f_users = $rs->getrows();
$smarty->assign('errors',$errors);
$smarty->assign('messages',$messages);
$smarty->assign('menu', 'community');
$smarty->assign('community', true);
$smarty->assign('male_users', $male_users);
$smarty->assign('total_musers', count($male_users));
$smarty->assign('female_users', $female_users);
$smarty->assign('total_fusers', count($female_users));
$smarty->assign('online_male_users', $online_m_users);
$smarty->assign('total_omusers', count($online_m_users));
$smarty->assign('online_female_users', $online_f_users);
$smarty->assign('total_ofusers', count($online_f_users));
$smarty->assign('popular_users', $popular_users);
$smarty->assign('total_pusers', count($popular_users));
$smarty->assign('self_title', $seo['community_title']);
$smarty->assign('self_description', $seo['community_desc']);
$smarty->assign('self_keywords', $seo['community_keywords']);
$smarty->loadFilter('output', 'trimwhitespace');
$smarty->display('header.tpl');
$smarty->display('community.tpl');
$smarty->display('footer.tpl');
?>