\n";
//sitetop download
$result=dbquery("
SELECT *
FROM ".DB_PDP_DOWNLOADS."
ORDER BY dl_count DESC
LIMIT 0,10
");
if(dbrows($result)!=0){
echo "
\n";
} else {
echo "
".$locale['sip_nodata']."\n";
}
echo "
\n";
//sitetop weblink
$result=dbquery("
SELECT * FROM ".DB_WEBLINKS."
ORDER BY weblink_count DESC
LIMIT 0,10
");
if(dbrows($result)!=0) {
echo "
\n";
} else {
echo "
".$locale['sip_nodata']."\n";
}
echo "
\n";
//sitetop threads
$result = dbquery("
SELECT tf.forum_id, tt.thread_id, tt.thread_subject, COUNT(tp.post_id) as count_posts
FROM ".DB_FORUMS." tf
INNER JOIN ".DB_THREADS." tt USING(forum_id)
INNER JOIN ".DB_POSTS." tp USING(thread_id)
WHERE forum_access<='".iUSER."'
GROUP BY thread_id
ORDER BY count_posts DESC, thread_lastpost DESC
LIMIT 10
");
if (dbrows($result) != 0) {
echo "
\n";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['thread_subject'], 17);
echo "| ".THEME_BULLET." \n";
echo "$itemsubject | \n";
echo "[".($data['count_posts']-1)."] | \n
\n";
}
echo "
\n";
} else {
echo "
".$locale['sip_nodata']."\n";
}
echo "
\n";
//sitetop user
$result=dbquery("
SELECT user_name, user_location, user_id, count(user_id) AS post_count
FROM ".DB_POSTS."
INNER JOIN ".DB_USERS." ON post_author=user_id
GROUP BY user_name
ORDER BY post_count DESC
LIMIT 0,10
");
if(dbrows($result)!=0){
echo "
\n";
} else {
echo "
".$locale['sip_nodata']."\n";
}
echo "
\n";
//sitetop news
$result=dbquery("
SELECT * FROM ".DB_NEWS."
ORDER BY news_reads DESC
LIMIT 0,10
");
if(dbrows($result)!=0){
echo "
\n";
} else {
echo "
".$locale['sip_nodata']."\n";
}
echo "
\n";
//sitetoparticles
$result=dbquery("
SELECT * FROM ".DB_ARTICLES."
ORDER BY article_reads DESC
LIMIT 0,10
");
if(dbrows($result)!=0){
echo "
\n";
} else {
echo "
".$locale['sip_nodata']."\n";
}
echo "