Cyb - إحصائيات المنتدى المتقدمة 6.5 http://www.algdeer.net/forum/showthread_1205.html hide_errors(); $vbulletin->db->query_write("ALTER TABLE `" . TABLE_PREFIX . "user` ADD showcybstats TINYINT( 1 ) DEFAULT '1' NOT NULL"); $cyb_ind_b = false; $cyb_check_indexes = $vbulletin->db->query_read("SHOW INDEX FROM " . TABLE_PREFIX . "user"); while ($cyb_found_indexes = $vbulletin->db->fetch_array($cyb_check_indexes)) { if ($cyb_found_indexes['Key_name'] == 'post_thanks_thanked_times') { $cyb_ind_b = true; } } if (mysql_query("SELECT post_thanks_thanked_times FROM " . TABLE_PREFIX . "user LIMIT 0") AND !$cyb_ind_b) { $vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD INDEX (post_thanks_thanked_times)"); } $db->show_errors();]]> hide_errors(); $vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP showcybstats"); $db->show_errors();]]> template_groups $only['cyb_'] = 'Cybernetec'; cache_templates options['cybtopstats_enable_global']) { $globaltemplates = array_merge($globaltemplates, array('cyb_topstats_stats', 'cyb_topstats_newposts', 'cyb_topstats_latestnews', 'cyb_topstats_mostviewed', 'cyb_topstats_hottest', 'cyb_topstats_topforums', 'cyb_topstats_classads', 'cyb_topstats_blogs', 'cyb_topstats_groupposts', 'cyb_topstats_member', 'cyb_topstats_poster', 'cyb_topstats_starter', 'cyb_topstats_referrer', 'cyb_topstats_reputation', 'cyb_topstats_thanks', 'cyb_topstats_infractions', 'cyb_topstats_visitors', 'cyb_topstats_groups', 'cyb_topstats_donations', 'cyb_topstats_php', 'cyb_topstats_stats_srow')); }]]> parse_templates options['cybtopstats_vbacmps_loc']!=0) { $cybtopstats_prelocs .= 'adv_index,'; } if ($vbulletin->options['cybtopstats_add_loc']!='') { $cybtopstats_prelocs .= 'misc,'; } else { $cybtopstats_prelocs .= 'misc'; } eval('$cybtopstats_locs = in_array(THIS_SCRIPT, array(' . $cybtopstats_prelocs . $vbulletin->options['cybtopstats_add_loc'] . '));'); if ($vbulletin->options['cybtopstats_enable_global'] AND !is_member_of($vbulletin->userinfo, split(',', $vbulletin->options['cybtopstats_excl_groups'])) AND !isset($_POST['fromquickreply'])) { if ($vbulletin->userinfo['userid']) { if ($vbulletin->userinfo['showcybstats']=='1') { $cybstats_show = true; } else { $cybstats_show = false; } if (!$cybstats_show) { $cyb_topstats_turnonlink = ''.$vbphrase['cyb_afs_turnon_stats'].''; $cyb_topstats_turnonlink_nb = ''.$cyb_topstats_turnonlink.''; $vbulletin->templatecache['navbar'] = str_replace('$vbphrase[miscellaneous]', '$vbphrase[miscellaneous]$cyb_topstats_turnonlink_nb', $vbulletin->templatecache['navbar']); } } else { $cybstats_show = true; } } if ($cybstats_show AND ((($vbulletin->options['cybtopstats_window_loc']!='0') AND (THIS_SCRIPT == "index")) OR in_array(THIS_SCRIPT, array($cybtopstats_locs)))) { $db->hide_errors(); global $vbulletin; $cybstats_latestnews_enabled = false; $cybstats_mostviewedthreads_enabled = false; $cybstats_hottestthreads_enabled = false; $cybstats_hottestforums_enabled = false; $cybstats_classifiedads_enabled = false; $cybstats_latestblogs_enabled = false; $cybstats_groupposts_enabled = false; $cybstats_newestmembers_enabled = false; $cybstats_posters_enabled = false; $cybstats_threadstarters_enabled = false; $cybstats_referrers_enabled = false; $cybstats_reputations_enabled = false; $cybstats_thanked_enabled = false; $cybstats_infractions_enabled = false; $cybstats_visitors_enabled = false; $cybstats_groups_enabled = false; $cybstats_donations_enabled = false; $cybstats_f_enabled = ''; $cybstats_u_enabled = ''; $cybstats_latestposts_enabled = true; if (strstr($vbulletin->options['cybtopstats_enable_items'], 'latestposts_l')) { $cybstats_latestposts_pos = 1; } else { $cybstats_latestposts_pos = 2; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'latestnews') AND ($vbulletin->options['cybtopstats_latestnews_newsforumid']!='')) { $cybstats_latestnews_enabled = true; $cybstats_f_enabled .= ',latestnews'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'mostviewedthreads')) { $cybstats_mostviewedthreads_enabled = true; $cybstats_f_enabled .= ',mostviewedthreads'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'hottestthreads')) { $cybstats_hottestthreads_enabled = true; $cybstats_f_enabled .= ',hottestthreads'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'hottestforums')) { $cybstats_hottestforums_enabled = true; $cybstats_f_enabled .= ',hottestforums'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'classifiedads') AND ($vbulletin->options['cybtopstats_classads_forums']!='')) { $cybstats_classifiedads_enabled = true; $cybstats_f_enabled .= ',classifiedads'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'latestblogs')) { $cybstats_latestblogs_enabled = true; $cybstats_f_enabled .= ',latestblogs'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'groupposts')) { $cybstats_groupposts_enabled = true; $cybstats_f_enabled .= ',groupposts'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'newestmembers')) { $cybstats_newestmembers_enabled = true; $cybstats_u_enabled .= ',newestmembers'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'posters')) { $cybstats_posters_enabled = true; $cybstats_u_enabled .= ',posters'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'threadstarters')) { $cybstats_threadstarters_enabled = true; $cybstats_u_enabled .= ',threadstarters'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'referrers')) { $cybstats_referrers_enabled = true; $cybstats_u_enabled .= ',referrers'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'reputations')) { $cybstats_reputations_enabled = true; $cybstats_u_enabled .= ',reputations'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'thanked') AND $vbulletin->options['post_thanks_on_off']) { $cybstats_thanked_enabled = true; $cybstats_u_enabled .= ',thanked'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'infractions')) { $cybstats_infractions_enabled = true; $cybstats_u_enabled .= ',infractions'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'visitors')) { $cybstats_visitors_enabled = true; $cybstats_u_enabled .= ',visitors'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'groups')) { $cybstats_groups_enabled = true; $cybstats_u_enabled .= ',groups'; } if (strstr($vbulletin->options['cybtopstats_enable_items'], 'donations') AND $vbulletin->options['cybpaypal_enable'] AND is_member_of($vbulletin->userinfo, split(',', $vbulletin->options['cybpaypal_canseelist']))) { $cybstats_donations_enabled = true; $cybstats_u_enabled .= ',donations'; } $cybstats_f_enabled = substr($cybstats_f_enabled, 1); $cybstats_u_enabled = substr($cybstats_u_enabled, 1); if ($vbulletin->options['cybtopstats_switch_fdef']=='random') { if (strstr($cybstats_f_enabled, ',')) { $cybtopstats_enabled_fitems = explode(",",$cybstats_f_enabled); $cybtopstats_renabled_fitem = array_rand($cybtopstats_enabled_fitems,2); $cybtopstats_init_fstat = $cybtopstats_enabled_fitems[$cybtopstats_renabled_fitem[0]]; } else { $cybtopstats_init_fstat = $cybstats_f_enabled; } } else if (strstr($cybstats_f_enabled, $vbulletin->options['cybtopstats_switch_fdef'])) { $cybtopstats_init_fstat = $vbulletin->options['cybtopstats_switch_fdef']; } if (!$cybtopstats_init_fstat) { $cybtopstats_init_fstat = "badadmin"; } if ($vbulletin->options['cybtopstats_switch_udef']=='random') { if (strstr($cybstats_u_enabled, ',')) { $cybtopstats_enabled_uitems = explode(",",$cybstats_u_enabled); $cybtopstats_renabled_uitem = array_rand($cybtopstats_enabled_uitems,2); $cybtopstats_init_ustat = $cybtopstats_enabled_uitems[$cybtopstats_renabled_uitem[0]]; } else { $cybtopstats_init_ustat = $cybstats_u_enabled; } } else if (strstr($cybstats_u_enabled, $vbulletin->options['cybtopstats_switch_udef'])) { $cybtopstats_init_ustat = $vbulletin->options['cybtopstats_switch_udef']; } if (!$cybtopstats_init_ustat) { $cybtopstats_init_ustat = "badadmin"; } $cybstats_latestposts_tcenabled = false; $cybstats_latestnews_tcenabled = false; $cybstats_mostviewedthreads_tcenabled = false; $cybstats_hottestthreads_tcenabled = false; $cybstats_hottestforums_tcenabled = false; $cybstats_classifiedads_tcenabled = false; $cybstats_latestblogs_tcenabled = false; $cybstats_newestmembers_tcenabled = false; $cybstats_posters_tcenabled = false; $cybstats_threadstarters_tcenabled = false; $cybstats_referrers_tcenabled = false; $cybstats_reputations_tcenabled = false; $cybstats_thanked_tcenabled = false; $cybstats_infractions_tcenabled = false; if ($vbulletin->options['cybtopstats_timecut']>0) { $cybtopstats_timecut_start = TIMENOW - ($vbulletin->options['cybtopstats_timecut'] * 86400); if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_latestposts')) { $cybstats_latestposts_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_lastpost = "AND thread.lastpost > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_latestnews')) { $cybstats_latestnews_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_latestnews = "AND dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_mostviewedthreads')) { $cybstats_mostviewedthreads_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_mostviewed = "AND dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_hottestthreads')) { $cybstats_hottestthreads_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_hottest = "AND dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_hottestforums')) { $cybstats_hottestforums_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_topforums = "AND post.dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_classifiedads')) { $cybstats_classifiedads_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_classads = "AND dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_latestblogs')) { $cybstats_latestblogs_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_blogs = "AND dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_newestmembers')) { $cybstats_newestmembers_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_newmem = "AND joindate > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_posters')) { $cybstats_posters_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_toppost = "AND post.dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_threadstarters')) { $cybstats_threadstarters_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_topstarters = "AND thread.dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_referrers')) { $cybstats_referrers_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_topreferrers = "AND refs.joindate > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_reputations')) { $cybstats_reputations_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_rep = "AND reputation.dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_thanked')) { $cybstats_thanked_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_thx = "AND post.dateline > $cybtopstats_timecut_start"; } if (strstr($vbulletin->options['cybtopstats_enable_timecut'], 'tc_infractions')) { $cybstats_infractions_tcenabled = "(".construct_phrase($vbphrase['cybstats_last_x_days'], $vbulletin->options['cybtopstats_timecut']).")"; $cybtopstats_timecut_infractions = "AND infraction.dateline > $cybtopstats_timecut_start"; } } if ($vbulletin->options['cybtopstats_swap_class']) { $cybstats_alt1 = "alt2"; $cybstats_alt2 = "alt1"; } else { $cybstats_alt1 = "alt1"; $cybstats_alt2 = "alt2"; } $cybstatsforumperms = array(); foreach($vbulletin->forumcache AS $cybtsforum) { $cybstatsforumperms[$cybtsforum["forumid"]] = fetch_permissions($cybtsforum['forumid']); if ((!($cybstatsforumperms[$cybtsforum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canview'])) OR (!($cybtsforum['options'] & $vbulletin->bf_misc_forumoptions['active']) AND !$vbulletin->options['showprivateforums'] AND !in_array($vbulletin->userinfo['usergroupid'], array(5,6,7)))) { $cybexclfids .= ','.$cybtsforum['forumid']; } } if ($vbulletin->options['cybtopstats_excl_forums']!='') { $cybexclfids .= ','.$vbulletin->options['cybtopstats_excl_forums']; } $cybexclfids = substr($cybexclfids, 1); if ($cybexclfids!='') { $cybexclforums_lastposts = "AND thread.forumid NOT IN($cybexclfids)"; $cybexclforums_topforums = "AND thread.forumid NOT IN($cybexclfids)"; $cybexclforums = "AND forumid NOT IN($cybexclfids)"; } unset($cybtsforum); if ($vbulletin->options['cybtopstats_excl_groups_listing']!='') { $cybexclgids = ','.$vbulletin->options['cybtopstats_excl_groups_listing']; } $cybexclgids = substr($cybexclgids, 1); if ($cybexclgids!='') { $cybexclgroups_user = "AND user.usergroupid NOT IN ($cybexclgids)"; $cybexclgroups = "AND usergroupid NOT IN ($cybexclgids)"; } if ($_REQUEST['do'] == 'cybstats') { $resultsnr = $vbulletin->input->clean_gpc('r', 'resultsnr', TYPE_UINT); $cyb_rnr_options = explode(',', $vbulletin->options['cybtopstats_amount_more']); foreach ($cyb_rnr_options AS $cyb_rnr_option) { eval('$resultsnrsw .= " '.$cyb_rnr_option.' ";'); } if ($resultsnr < 1) { $resultsnr = intval($vbulletin->options['cybtopstats_amount_more']); } } else { $resultsnr = intval($vbulletin->options['cybtopstats_amount_main']); if ($resultsnr < 1) { $resultsnr = intval($vbulletin->options['cybtopstats_amount_more']); } } $cybtopstats_temptable = ''.str_repeat('', $resultsnr-1).'

'.$vbphrase['cybstats_loading'].'

'; if ($vbulletin->options['cybtopstats_layout']==1) { eval('$cybstats_srow .= "' . $vbulletin->templatecache['cyb_topstats_stats_srow'] . '";'); } $trimthreadtitle = $vbulletin->options['cybtopstats_trim_titles_thread']; if ($trimthreadtitle <= 0) { $trimthreadtitle = $vbulletin->options['lastthreadchars']; } if ($trimthreadtitle == 1) { $trimthreadtitle = 300; } $trimusername = $vbulletin->options['cybtopstats_trim_username']; $trimforumtitles = $vbulletin->options['cybtopstats_trim_titles_forum']; $newpostprefix = ''; $oldpostprefix = ''; $cyb_afs_bpar = array("","","","", "font-weight: bold", "font-weight:bold"); if (!is_member_of($vbulletin->userinfo, split(',', $vbulletin->options['cybtopstats_cant_viewmore']))) { $canviewmore = true; } else { $canviewmore = false; } switch ($vbulletin->options['cybtopstats_window_loc']) { case 0: $cyb_topstats_sr1 = ''; break; case 1: $cyb_topstats_sr1 = '$navbar'; break; case 2: $cyb_topstats_sr1 = ''; break; case 3: $cyb_topstats_sr1 = ''; break; case 4: $cyb_topstats_sr1 = ''; break; } eval('$cybtopstats .= "' . $vbulletin->templatecache['cyb_topstats_stats'] . '";'); if ($vbulletin->options['cybtopstats_window_loc']!='0') { $vbulletin->templatecache['FORUMHOME'] = str_replace($cyb_topstats_sr1, $cyb_topstats_sr1.'$cybtopstats', $vbulletin->templatecache['FORUMHOME']); } $vba_options['portal_outputglobals'] .= "\r\ncybtopstats"; switch ($vbulletin->options['cybtopstats_vbacmps_loc']) { case 0: $cyb_topstats_srp1 = ''; break; case 1: $cyb_topstats_srp1 = '$navbar'; break; case 2: $cyb_topstats_srp1 = '$home[centerblocks]'; break; case 3: $cyb_topstats_srp1 = '$home[centerblocks]'; break; case 4: $cyb_topstats_srp1 = '$footer'; break; } if (($vbulletin->options['cybtopstats_vbacmps_loc']==1) OR ($vbulletin->options['cybtopstats_vbacmps_loc']==3)) { $vbulletin->templatecache['adv_portal'] = str_replace($cyb_topstats_srp1, $cyb_topstats_srp1.'$cybtopstats', $vbulletin->templatecache['adv_portal']); } if (($vbulletin->options['cybtopstats_vbacmps_loc']==2) OR ($vbulletin->options['cybtopstats_vbacmps_loc']==4)) { $vbulletin->templatecache['adv_portal'] = str_replace($cyb_topstats_srp1, '$cybtopstats'.$cyb_topstats_srp1, $vbulletin->templatecache['adv_portal']); } $db->show_errors(); }]]> admin_options_processing 0) AND ($settings['cybtopstats_refresh_interval']<10)) { $settings['cybtopstats_refresh_interval'] = 10; }]]> misc_start options['cybtopstats_enable_global'] AND !is_member_of($vbulletin->userinfo, split(',', $vbulletin->options['cybtopstats_excl_groups']))) { $resultsnr = $vbulletin->input->clean_gpc('r', 'resultsnr', TYPE_UINT); if ($resultsnr < 1) { $resultsnr = intval($vbulletin->options['cybtopstats_amount_more']); } if ($vbulletin->options['cybtopstats_layout']==1) { $resultsnr_lp = $resultsnr; } else { $resultsnr_lp = ($resultsnr * 2) + 1; } if ($_REQUEST['do'] == 'cybstats') { $cybafs_sectok = $vbulletin->userinfo['securitytoken']; if (!$cybafs_sectok) { $cybafs_sectok = 'none'; } require_once('./global.php'); construct_forum_jump(); $navbits = construct_navbits(array('' => $vbphrase['cyb_top_stats'])); eval('$navbar = "' . fetch_template('navbar') . '";'); eval('print_output("' . fetch_template('cyb_topstats_php') . '");'); } if (($_REQUEST['do'] == 'enablestats') AND $vbulletin->userinfo['userid']) { $db->hide_errors(); $vbulletin->db->query_write(" UPDATE " . TABLE_PREFIX . "user SET showcybstats = '1' WHERE userid = " . $vbulletin->userinfo['userid'] . " "); exec_header_redirect($vbulletin->options['forumhome'].'.php#cyb_stats'); $db->show_errors(); } if (($_REQUEST['do'] == 'disablestats') AND $vbulletin->userinfo['userid']) { $db->hide_errors(); $vbulletin->db->query_write(" UPDATE " . TABLE_PREFIX . "user SET showcybstats = '0' WHERE userid = " . $vbulletin->userinfo['userid'] . " "); $db->show_errors(); $cyb_topstats_disabled_note = construct_phrase($vbphrase[cyb_topstats_disabled_note], $vbphrase['cyb_afs_turnon_stats'], $vbphrase['quick_links']); $vbulletin->url = $vbulletin->options['bburl']; eval(print_standard_redirect($cyb_topstats_disabled_note,0,1)); } if (($_REQUEST['show']=='latestposts') AND $cybstats_latestposts_enabled) { $db->hide_errors(); $get_stats_newposts = $vbulletin->db->query_read(" SELECT thread.threadid, thread.title, thread.lastpost, thread.lastpostid, thread.forumid, thread.lastposter, thread.dateline, thread.views, thread.replycount, thread.visible, thread.open, user.username, user.userid, user.usergroupid, user.displaygroupid FROM " . TABLE_PREFIX . "thread AS thread LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' $cybexclforums_lastposts $cybtopstats_timecut_lastpost ORDER BY lastpost DESC LIMIT 0, $resultsnr_lp "); while ($get_new_posts = $db->fetch_array($get_stats_newposts)) { $cybstats_rnr += 1; $get_new_posts[views] = vb_number_format($get_new_posts[views]); $get_new_posts[replycount] = vb_number_format($get_new_posts[replycount]); $get_new_posts[fullthreadtitle] = strip_tags($get_new_posts[title]); if ($trimthreadtitle > 0) { $get_new_posts[titletrimmed] = fetch_trimmed_title($get_new_posts[fullthreadtitle], $trimthreadtitle); } else { $get_new_posts[titletrimmed] = $get_new_posts[fullthreadtitle]; } if ($get_new_posts[lastpost] > $vbulletin->userinfo['lastvisit']) { $get_new_posts[newpost] = true; } $get_new_posts[fullusername] = strip_tags($get_new_posts[username]); if ($trimusername > 0) { $get_new_posts[username] = fetch_trimmed_title($get_new_posts[fullusername], $trimusername); } else { $get_new_posts[username] = $get_new_posts[fullusername]; } $get_new_posts[musername] = fetch_musername($get_new_posts); $get_new_posts_forumtitle = strip_tags($vbulletin->forumcache["$get_new_posts[forumid]"]['title_clean']); $get_new_posts[fullforumtitle] = strip_tags($get_new_posts_forumtitle); if ($trimforumtitles > 0) { $get_new_posts[forumtitle] = fetch_trimmed_title($get_new_posts[fullforumtitle], $trimforumtitles); } else { $get_new_posts[forumtitle] = $get_new_posts[fullforumtitle]; } if ($vbulletin->options['cybtopstats_bold_remove']) { $get_new_posts[musername] = str_replace($cyb_afs_bpar, "", $get_new_posts[musername]); } switch ($vbulletin->options['cybtopstats_lastpost_arrowlink']) { case 0: $cybtopstats_arrowlink = ''; break; case 1: $cybtopstats_arrowlink = '▲'; break; case 2: $cybtopstats_arrowlink = '▼'; break; case 3: $cybtopstats_arrowlink = '►'; break; default: $cybtopstats_arrowlink = '►'; break; } switch ($vbulletin->options['cybtopstats_lastpost_titlelink']) { case 1: $cybtopstats_titlelink = $vbulletin->options['bburl'].'/showthread.php?'.$session['sessionurl'].'t='.$get_new_posts['threadid']; break; case 2: $cybtopstats_titlelink = $vbulletin->options['bburl'].'/showthread.php?'.$session['sessionurl'].'p='.$get_new_posts['lastpostid'].'#post'.$get_new_posts['lastpostid']; break; case 3: $cybtopstats_titlelink = $vbulletin->options['bburl'].'/showthread.php?'.$session['sessionurl'].'goto=newpost&t='.$get_new_posts['threadid']; break; default: $cybtopstats_titlelink = $vbulletin->options['bburl'].'/showthread.php?'.$session['sessionurl'].'t='.$get_new_posts['threadid']; break; } $get_new_postdate = vbdate($vbulletin->options['cybtopstats_date_format'], $get_new_posts[lastpost]); $get_new_posttime = vbdate($vbulletin->options['cybtopstats_time_format'], $get_new_posts[lastpost]); eval('$cybtopstats_newposts .= "' . $vbulletin->templatecache['cyb_topstats_newposts'] . '";'); } $cybtopstats_newposts_colspan = "3"; if ($vbulletin->options['cybtopstats_lastpost_dateline']) { $cybtopstats_newposts_colspan += 1; } if ($vbulletin->options['cybtopstats_lastpost_forums']) { $cybtopstats_newposts_colspan += 1; } if ($vbulletin->options['cybtopstats_lastpost_vrcount']) { $cybtopstats_newposts_colspan += 2; } if ($vbulletin->db->num_rows($get_stats_newposts) < $resultsnr_lp) { $cybtopstats_newposts .= str_repeat(' ', $resultsnr_lp - $vbulletin->db->num_rows($get_stats_newposts)); } unset($get_stats_newposts, $get_new_posts); print_output($cybtopstats_newposts); $db->show_errors(); if (!$cybtopstats_newposts) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='latestnews') AND $cybstats_latestnews_enabled) { $db->hide_errors(); $get_stats_latestnews = $vbulletin->db->query_read(" SELECT threadid, title, forumid, dateline, lastpost, visible, open FROM " . TABLE_PREFIX . "thread AS thread WHERE NOT ISNULL(threadid) AND forumid IN (".$vbulletin->options['cybtopstats_latestnews_newsforumid'].") AND visible = '1' AND open!='10' $cybtopstats_timecut_latestnews ORDER BY dateline DESC LIMIT 0, $resultsnr "); while ($get_latest_news = $db->fetch_array($get_stats_latestnews)) { $cybstats_rnr += 1; $get_latest_news[fullthreadtitle] = strip_tags($get_latest_news[title]); if ($trimthreadtitle > 0) { $get_latest_news[titletrimmed] = fetch_trimmed_title($get_latest_news[fullthreadtitle], $trimthreadtitle); } else { $get_latest_news[titletrimmed] = $get_latest_news[fullthreadtitle]; } if ($get_latest_news[lastpost] > $vbulletin->userinfo['lastvisit']) { $get_latest_news[newpost] = true; } $get_news_postdate = vbdate($vbulletin->options['cybtopstats_date_format'], $get_latest_news[dateline]); eval('$cybtopstats_latestnews .= "' . $vbulletin->templatecache['cyb_topstats_latestnews'] . '";'); } if ($vbulletin->db->num_rows($get_stats_latestnews) < $resultsnr) { $cybtopstats_latestnews .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_latestnews)); } unset($get_stats_latestnews, $get_latest_news); print_output($cybtopstats_latestnews); $db->show_errors(); if (!$cybtopstats_latestnews) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='mostviewedthreads') AND $cybstats_mostviewedthreads_enabled) { $db->hide_errors(); $get_stats_mostviewed = $vbulletin->db->query_read(" SELECT threadid, title, forumid, views, dateline, visible, open FROM " . TABLE_PREFIX . "thread AS thread WHERE NOT ISNULL(threadid) AND visible = '1' AND views > '0' AND open!='10' $cybexclforums $cybtopstats_timecut_mostviewed ORDER BY views DESC LIMIT 0, $resultsnr "); while ($get_most_viewed = $db->fetch_array($get_stats_mostviewed)) { $cybstats_rnr += 1; $get_most_viewed[views] = vb_number_format($get_most_viewed[views]); $get_most_viewed[fullthreadtitle] = strip_tags($get_most_viewed[title]); if ($trimthreadtitle > 0) { $get_most_viewed[titletrimmed] = fetch_trimmed_title($get_most_viewed[fullthreadtitle], $trimthreadtitle); } else { $get_most_viewed[titletrimmed] = $get_most_viewed[fullthreadtitle]; } if ($get_most_viewed[lastpost] > $vbulletin->userinfo['lastvisit']) { $get_most_viewed[newpost] = true; } eval('$cybtopstats_mostviewed .= "' . $vbulletin->templatecache['cyb_topstats_mostviewed'] . '";'); } if ($vbulletin->db->num_rows($get_stats_mostviewed) < $resultsnr) { $cybtopstats_mostviewed .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_mostviewed)); } unset($get_stats_mostviewed, $get_most_viewed); print_output($cybtopstats_mostviewed); $db->show_errors(); if (!$cybtopstats_mostviewed) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='hottestthreads') AND $cybstats_hottestthreads_enabled) { $db->hide_errors(); $get_stats_hottest = $vbulletin->db->query_read(" SELECT threadid, title, lastpost, forumid, replycount, dateline, visible, open FROM " . TABLE_PREFIX . "thread AS thread WHERE NOT ISNULL(threadid) AND visible = '1' AND replycount > '0' AND open!='10' $cybexclforums $cybtopstats_timecut_hottest ORDER BY replycount DESC LIMIT 0, $resultsnr "); while ($get_hottest_threads = $db->fetch_array($get_stats_hottest)) { $cybstats_rnr += 1; $get_hottest_threads[replycount] = vb_number_format($get_hottest_threads[replycount]); $get_hottest_threads[fullthreadtitle] = strip_tags($get_hottest_threads[title]); if ($trimthreadtitle > 0) { $get_hottest_threads[titletrimmed] = fetch_trimmed_title($get_hottest_threads[fullthreadtitle], $trimthreadtitle); } else { $get_hottest_threads[titletrimmed] = $get_hottest_threads[fullthreadtitle]; } if ($get_hottest_threads[lastpost] > $vbulletin->userinfo['lastvisit']) { $get_hottest_threads[newpost] = true; } eval('$cybtopstats_hottest .= "' . $vbulletin->templatecache['cyb_topstats_hottest'] . '";'); } if ($vbulletin->db->num_rows($get_stats_hottest) < $resultsnr) { $cybtopstats_hottest .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_hottest)); } unset($get_stats_hottest, $get_hottest_threads); print_output($cybtopstats_hottest); $db->show_errors(); if (!$cybtopstats_hottest) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='hottestforums') AND $cybstats_hottestforums_enabled) { $db->hide_errors(); if ($cybstats_hottestforums_tcenabled) { $get_stats_topforums = $vbulletin->db->query_read(" SELECT COUNT(post.postid) AS replycount, forum.forumid, forum.title_clean FROM " . TABLE_PREFIX . "post AS post LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid) LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (thread.forumid = forum.forumid) WHERE post.visible='1' AND thread.visible='1' AND (forum.options & 4096) $cybexclforums_topforums $cybtopstats_timecut_topforums GROUP BY thread.forumid ORDER BY replycount DESC LIMIT 0, $resultsnr "); } else { $get_stats_topforums = $vbulletin->db->query_read(" SELECT forumid, title_clean, replycount FROM " . TABLE_PREFIX . "forum AS forum WHERE replycount > '0' $cybexclforums ORDER BY replycount DESC LIMIT 0, $resultsnr "); } while ($get_topforums = $db->fetch_array($get_stats_topforums)) { $cybstats_rnr += 1; $get_topforums[replycount] = vb_number_format($get_topforums[replycount]); $get_topforums[fullforumtitle] = strip_tags($get_topforums[title_clean]); if ($trimforumtitles > 0) { $get_topforums[titletrimmed] = fetch_trimmed_title($get_topforums[fullforumtitle], $trimforumtitles); } else { $get_topforums[titletrimmed] = $get_topforums[fullforumtitle]; } eval('$cybtopstats_topforums .= "' . $vbulletin->templatecache['cyb_topstats_topforums'] . '";'); } if ($vbulletin->db->num_rows($get_stats_topforums) < $resultsnr) { $cybtopstats_topforums .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_topforums)); } unset($get_stats_topforums, $get_topforums); print_output($cybtopstats_topforums); $db->show_errors(); if (!$cybtopstats_topforums) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='classifiedads') AND $cybstats_classifiedads_enabled) { $db->hide_errors(); $get_stats_classads = $vbulletin->db->query_read(" SELECT threadid, title, lastpost, forumid, dateline, visible, open FROM " . TABLE_PREFIX . "thread AS thread WHERE NOT ISNULL(threadid) AND forumid IN (".$vbulletin->options['cybtopstats_classads_forums'].") AND visible = '1' AND open!='10' $cybtopstats_timecut_classads ORDER BY dateline DESC LIMIT 0, $resultsnr "); while ($get_latest_classads = $db->fetch_array($get_stats_classads)) { $cybstats_rnr += 1; $get_latest_classads[fullthreadtitle] = strip_tags($get_latest_classads[title]); if ($trimthreadtitle > 0) { $get_latest_classads[titletrimmed] = fetch_trimmed_title($get_latest_classads[fullthreadtitle], $trimthreadtitle); } else { $get_latest_classads[titletrimmed] = $get_latest_classads[fullthreadtitle]; } $get_latest_classads_forumtitle = strip_tags($vbulletin->forumcache["$get_latest_classads[forumid]"]['title_clean']); $get_latest_classads[fullforumtitle] = strip_tags($get_latest_classads_forumtitle); if ($trimforumtitles > 0) { $get_latest_classads[forumtitle] = fetch_trimmed_title($get_latest_classads[fullforumtitle], $trimforumtitles); } else { $get_latest_classads[forumtitle] = $get_latest_classads[fullforumtitle]; } if ($get_latest_classads[lastpost] > $vbulletin->userinfo['lastvisit']) { $get_latest_classads[newpost] = true; } eval('$cybtopstats_classads .= "' . $vbulletin->templatecache['cyb_topstats_classads'] . '";'); } if ($vbulletin->db->num_rows($get_stats_classads) < $resultsnr) { $cybtopstats_classads .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_classads)); } unset($get_latest_classads, $get_latest_classads); print_output($cybtopstats_classads); $db->show_errors(); if (!$cybtopstats_classads) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='latestblogs') AND $cybstats_latestblogs_enabled) { $db->hide_errors(); $get_stats_blogs = $vbulletin->db->query_read(" SELECT blog.blogid, blog.title, blog.comments_visible, blog.userid, user.username, user.usergroupid, user.displaygroupid, blog.dateline FROM " . TABLE_PREFIX . "blog AS blog LEFT JOIN " . TABLE_PREFIX . "user AS user ON (blog.userid = user.userid) WHERE state = 'visible' $cybtopstats_timecut_blogs ORDER BY dateline DESC LIMIT 0, $resultsnr "); while ($get_latest_blogs = $db->fetch_array($get_stats_blogs)) { $cybstats_rnr += 1; $get_latest_blogs[comments_visible] = vb_number_format($get_latest_blogs[comments_visible]); $get_latest_blogs[fullblogtitle] = strip_tags($get_latest_blogs[title]); if ($trimthreadtitle > 0) { $get_latest_blogs[titletrimmed] = fetch_trimmed_title($get_latest_blogs[fullblogtitle], $trimthreadtitle); } else { $get_latest_blogs[titletrimmed] = $get_latest_blogs[fullblogtitle]; } $get_latest_blogs[fullusername] = strip_tags($get_latest_blogs[username]); if ($trimusername > 0) { $get_latest_blogs[username] = fetch_trimmed_title($get_latest_blogs[fullusername], $trimusername); } else { $get_latest_blogs[username] = $get_latest_blogs[fullusername]; } $get_latest_blogs[musername] = fetch_musername($get_latest_blogs); if ($vbulletin->options['cybtopstats_bold_remove']) { $get_latest_blogs[musername] = str_replace($cyb_afs_bpar, "", $get_latest_blogs[musername]); } if ($get_latest_blogs[dateline] > $vbulletin->userinfo['lastvisit']) { $get_latest_blogs[newpost] = true; } eval('$cybtopstats_blogs .= "' . $vbulletin->templatecache['cyb_topstats_blogs'] . '";'); } if ($vbulletin->db->num_rows($get_stats_blogs) < $resultsnr) { $cybtopstats_blogs .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_blogs)); } unset($get_stats_blogs, $get_latest_blogs); print_output($cybtopstats_blogs); $db->show_errors(); if (!$cybtopstats_blogs) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='groupposts') AND $cybstats_groupposts_enabled) { $db->hide_errors(); $get_stats_groupdisc = $vbulletin->db->query_read(" SELECT discussion.discussionid, discussion.lastpost, discussion.lastpostid, discussion.groupid, groupmessage.title, socialgroup.name FROM " . TABLE_PREFIX . "discussion AS discussion LEFT JOIN " . TABLE_PREFIX . "groupmessage AS groupmessage ON (groupmessage.discussionid = discussion.discussionid) LEFT JOIN " . TABLE_PREFIX . "socialgroup AS socialgroup ON (socialgroup.groupid = discussion.groupid) WHERE groupmessage.state = 'visible' GROUP BY discussionid ORDER BY lastpost DESC LIMIT 0, $resultsnr "); while ($get_latest_groupdisc = $db->fetch_array($get_stats_groupdisc)) { $cybstats_rnr += 1; $get_latest_groupdisc[fullthreadtitle] = strip_tags($get_latest_groupdisc[title]); if ($trimthreadtitle > 0) { $get_latest_groupdisc[titletrimmed] = fetch_trimmed_title($get_latest_groupdisc[fullthreadtitle], $trimthreadtitle); } else { $get_latest_groupdisc[titletrimmed] = $get_latest_groupdisc[fullthreadtitle]; } $get_latest_groupdisc[fullgroupname] = strip_tags($get_latest_groupdisc[name]); if ($trimforumtitles > 0) { $get_latest_groupdisc[nametrimmed] = fetch_trimmed_title($get_latest_groupdisc[fullgroupname], $trimforumtitles); } else { $get_latest_groupdisc[nametrimmed] = $get_latest_groupdisc[fullgroupname]; } if ($get_latest_groupdisc[lastpost] > $vbulletin->userinfo['lastvisit']) { $get_latest_groupdisc[newpost] = true; } $get_latest_groupdisc_time = vbdate($vbulletin->options['cybtopstats_time_format'], $get_latest_groupdisc[lastpost]); eval('$cybtopstats_groupposts .= "' . $vbulletin->templatecache['cyb_topstats_groupposts'] . '";'); } if ($vbulletin->db->num_rows($get_stats_groupdisc) < $resultsnr) { $cybtopstats_groupposts .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_groupdisc)); } unset($get_stats_groupdisc, $get_latest_groupdisc); print_output($cybtopstats_groupposts); $db->show_errors(); if (!$cybtopstats_groupposts) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='newestmembers') AND $cybstats_newestmembers_enabled) { $db->hide_errors(); $get_stats_newmem = $vbulletin->db->query_read(" SELECT userid, usergroupid, displaygroupid, username, joindate, posts FROM " . TABLE_PREFIX . "user AS user WHERE userid > '0' $cybexclgroups $cybtopstats_timecut_newmem ORDER BY joindate DESC LIMIT 0, $resultsnr "); while ($get_new_mem = $db->fetch_array($get_stats_newmem)) { $cybstats_rnr += 1; $get_new_mem[posts] = vb_number_format($get_new_mem[posts]); $get_new_mem[fullusername] = strip_tags($get_new_mem[username]); if ($trimusername > 0) { $get_new_mem[username] = fetch_trimmed_title($get_new_mem[fullusername], $trimusername); } else { $get_new_mem[username] = $get_new_mem[fullusername]; } $get_new_mem[musername] = fetch_musername($get_new_mem); if ($vbulletin->options['cybtopstats_bold_remove']) { $get_new_mem[musername] = str_replace($cyb_afs_bpar, "", $get_new_mem[musername]); } if ($get_new_mem[joindate] > $vbulletin->userinfo['lastvisit']) { $get_new_mem[newuser] = true; } $cybmemberjoined = vbdate($vbulletin->options['cybtopstats_date_format'], $get_new_mem['joindate']); eval('$cybtopstats_members .= "' . $vbulletin->templatecache['cyb_topstats_member'] . '";'); } if ($vbulletin->db->num_rows($get_stats_newmem) < $resultsnr) { $cybtopstats_members .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_newmem)); } unset($get_stats_newmem, $get_new_mem); print_output($cybtopstats_members); $db->show_errors(); if (!$cybtopstats_members) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='posters') AND $cybstats_posters_enabled) { $db->hide_errors(); if ($cybstats_posters_tcenabled) { $get_stats_posters = $vbulletin->db->query_read(" SELECT COUNT(post.postid) AS posts, post.userid, post.dateline, user.usergroupid, user.displaygroupid, user.username FROM " . TABLE_PREFIX . "post AS post LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid) LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid) LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (forum.forumid = thread.forumid) WHERE user.userid > 0 AND posts > 0 AND post.visible= 1 AND (forum.options & 4096) $cybexclgroups $cybtopstats_timecut_toppost GROUP BY post.userid ORDER BY posts DESC LIMIT 0, $resultsnr "); } else { $get_stats_posters = $vbulletin->db->query_read(" SELECT userid, usergroupid, displaygroupid, username, posts FROM " . TABLE_PREFIX . "user AS user WHERE posts > '0' $cybexclgroups ORDER BY posts DESC LIMIT 0, $resultsnr "); } while ($getstats_poster = $db->fetch_array($get_stats_posters)) { $cybstats_rnr += 1; $getstats_poster[posts] = vb_number_format($getstats_poster[posts]); $getstats_poster[fullusername] = strip_tags($getstats_poster[username]); if ($trimusername > 0) { $getstats_poster[username] = fetch_trimmed_title($getstats_poster[fullusername], $trimusername); } else { $getstats_poster[username] = $getstats_poster[fullusername]; } $getstats_poster[musername] = fetch_musername($getstats_poster); if ($vbulletin->options['cybtopstats_bold_remove']) { $getstats_poster[musername] = str_replace($cyb_afs_bpar, "", $getstats_poster[musername]); } eval('$cybtopstats_posters .= "' . $vbulletin->templatecache['cyb_topstats_poster'] . '";'); } if ($vbulletin->db->num_rows($get_stats_posters) < $resultsnr) { $cybtopstats_posters .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_posters)); } unset($get_stats_posters, $getstats_poster); print_output($cybtopstats_posters); $db->show_errors(); if (!$cybtopstats_posters) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='threadstarters') AND $cybstats_threadstarters_enabled) { $db->hide_errors(); $get_stats_starters = $vbulletin->db->query_read(" SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.usergroupid, user.displaygroupid, user.username FROM " . TABLE_PREFIX . "thread AS thread LEFT JOIN " . TABLE_PREFIX . "user AS user ON (thread.postuserid = user.userid) LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (forum.forumid = thread.forumid) WHERE thread.visible='1' AND (forum.options & 4096) AND user.userid > 0 $cybexclgroups_user $cybtopstats_timecut_topstarters GROUP BY thread.postuserid ORDER BY threads DESC LIMIT 0, $resultsnr "); while ($getstats_starter = $db->fetch_array($get_stats_starters)) { $cybstats_rnr += 1; $getstats_starter[threads] = vb_number_format($getstats_starter[threads]); $getstats_starter[fullusername] = strip_tags($getstats_starter[username]); if ($trimusername > 0) { $getstats_starter[username] = fetch_trimmed_title($getstats_starter[fullusername], $trimusername); } else { $getstats_starter[username] = $getstats_starter[fullusername]; } $getstats_starter[musername] = fetch_musername($getstats_starter); if ($vbulletin->options['cybtopstats_bold_remove']) { $getstats_starter[musername] = str_replace($cyb_afs_bpar, "", $getstats_starter[musername]); } eval('$cybtopstats_starters .= "' . $vbulletin->templatecache['cyb_topstats_starter'] . '";'); } if ($vbulletin->db->num_rows($get_stats_starters) < $resultsnr) { $cybtopstats_starters .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_starters)); } unset($get_stats_starters, $getstats_starter); print_output($cybtopstats_starters); $db->show_errors(); if (!$cybtopstats_starters) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='referrers') AND $cybstats_referrers_enabled) { $db->hide_errors(); $get_stats_referrers = $vbulletin->db->query_read(" SELECT COUNT(*) AS refnumber, user.username, user.userid, user.usergroupid, user.displaygroupid, user.referrerid, refs.joindate FROM " . TABLE_PREFIX . "user AS refs LEFT JOIN " . TABLE_PREFIX . "user AS user ON (refs.referrerid = user.userid) WHERE refs.referrerid > 0 AND user.userid > 0 $cybexclgroups_user $cybtopstats_timecut_topreferrers GROUP BY refs.referrerid ORDER BY refnumber DESC LIMIT 0, $resultsnr "); while ($getstats_referrer = $db->fetch_array($get_stats_referrers)) { $cybstats_rnr += 1; $getstats_referrer[refnumber] = vb_number_format($getstats_referrer[refnumber]); $getstats_referrer[fullusername] = strip_tags($getstats_referrer[username]); if ($trimusername > 0) { $getstats_referrer[username] = fetch_trimmed_title($getstats_referrer[fullusername], $trimusername); } else { $getstats_referrer[username] = $getstats_referrer[fullusername]; } $getstats_referrer[musername] = fetch_musername($getstats_referrer); if ($vbulletin->options['cybtopstats_bold_remove']) { $getstats_referrer[musername] = str_replace($cyb_afs_bpar, "", $getstats_referrer[musername]); } eval('$cybtopstats_referrers .= "' . $vbulletin->templatecache['cyb_topstats_referrer'] . '";'); } if ($vbulletin->db->num_rows($get_stats_referrers) < $resultsnr) { $cybtopstats_referrers .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_referrers)); } unset($get_stats_referrers, $getstats_referrer); print_output($cybtopstats_referrers); $db->show_errors(); if (!$cybtopstats_referrers) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='reputations') AND $cybstats_reputations_enabled) { $db->hide_errors(); require_once(DIR . '/includes/functions_reputation.php'); $get_stats_reputation = $vbulletin->db->query_read(" SELECT COUNT(reputation.reputationid) AS clicks, reputation.userid, user.usergroupid, user.displaygroupid, user.username, user.reputation FROM " . TABLE_PREFIX . "reputation AS reputation LEFT JOIN " . TABLE_PREFIX . "user AS user ON (reputation.userid = user.userid) WHERE user.userid > 0 AND reputation.reputation > 0 $cybexclgroups $cybtopstats_timecut_rep GROUP BY reputation.userid ORDER BY user.reputation DESC LIMIT 0, $resultsnr "); while ($getstats_rep = $db->fetch_array($get_stats_reputation)) { $cybstats_rnr += 1; $getstats_rep[clicks] = vb_number_format($getstats_rep[clicks]); $getstats_rep[fullusername] = strip_tags($getstats_rep[username]); if ($trimusername > 0) { $getstats_rep[username] = fetch_trimmed_title($getstats_rep[fullusername], $trimusername); } else { $getstats_rep[username] = $getstats_rep[fullusername]; } $getstats_rep[musername] = fetch_musername($getstats_rep); if ($vbulletin->options['cybtopstats_bold_remove']) { $getstats_rep[musername] = str_replace($cyb_afs_bpar, "", $getstats_rep[musername]); } $user = fetch_userinfo($getstats_rep['userid']); $perms = fetch_permissions(0, $user['userid'], $user); $getstats_rep[reppower] = fetch_reppower($user, $perms); eval('$cybtopstats_reputation .= "' . $vbulletin->templatecache['cyb_topstats_reputation'] . '";'); } if ($vbulletin->db->num_rows($get_stats_reputation) < $resultsnr) { $cybtopstats_reputation .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_reputation)); } unset($get_stats_reputation, $getstats_rep); print_output($cybtopstats_reputation); $db->show_errors(); if (!$cybtopstats_reputation) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='thanked') AND $cybstats_thanked_enabled) { $db->hide_errors(); if ($cybstats_thanked_tcenabled) { $get_stats_thanks = $vbulletin->db->query_read(" SELECT SUM(post.post_thanks_amount) AS post_thanks_thanked_times, post.userid, user.username, user.usergroupid, user.displaygroupid FROM " . TABLE_PREFIX . "post AS post LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid) WHERE post_thanks_amount > 0 AND user.userid > 0 $cybexclgroups $cybtopstats_timecut_thx GROUP BY post.userid ORDER BY post_thanks_thanked_times DESC LIMIT 0, $resultsnr "); } else { $get_stats_thanks = $vbulletin->db->query_read(" SELECT userid, usergroupid, displaygroupid, username, posts, post_thanks_thanked_times FROM " . TABLE_PREFIX . "user AS user WHERE post_thanks_thanked_times > '0' $cybexclgroups ORDER BY post_thanks_thanked_times DESC LIMIT 0, $resultsnr "); } while ($getstats_thx = $db->fetch_array($get_stats_thanks)) { $cybstats_rnr += 1; $getstats_thx[post_thanks_thanked_times] = vb_number_format($getstats_thx[post_thanks_thanked_times]); $getstats_thx[fullusername] = strip_tags($getstats_thx[username]); if ($trimusername > 0) { $getstats_thx[username] = fetch_trimmed_title($getstats_thx[fullusername], $trimusername); } else { $getstats_thx[username] = $getstats_thx[fullusername]; } $getstats_thx[musername] = fetch_musername($getstats_thx); if ($vbulletin->options['cybtopstats_bold_remove']) { $getstats_thx[musername] = str_replace($cyb_afs_bpar, "", $getstats_thx[musername]); } eval('$cybtopstats_thanks .= "' . $vbulletin->templatecache['cyb_topstats_thanks'] . '";'); } if ($vbulletin->db->num_rows($get_stats_thanks) < $resultsnr) { $cybtopstats_thanks .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_thanks)); } unset($get_stats_thanks, $getstats_thx); print_output($cybtopstats_thanks); $db->show_errors(); if (!$cybtopstats_thanks) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='infractions') AND $cybstats_infractions_enabled) { $db->hide_errors(); $get_stats_infractions = $vbulletin->db->query_read(" SELECT COUNT(infraction.infractionid) AS infs, SUM(infraction.points) AS infpoints, user.userid, user.username, user.usergroupid, user.displaygroupid FROM " . TABLE_PREFIX . "infraction AS infraction LEFT JOIN " . TABLE_PREFIX . "user AS user ON (infraction.userid = user.userid) WHERE user.userid > 0 AND infraction.points > 0 $cybexclgroups_user $cybtopstats_timecut_infractions GROUP BY user.userid ORDER BY infpoints DESC LIMIT 0, $resultsnr "); while ($getstats_infraction = $db->fetch_array($get_stats_infractions)) { $cybstats_rnr += 1; $getstats_infraction[infs] = vb_number_format($getstats_infraction[infs]); $getstats_infraction[fullusername] = strip_tags($getstats_infraction[username]); if ($trimusername > 0) { $getstats_infraction[username] = fetch_trimmed_title($getstats_infraction[fullusername], $trimusername); } else { $getstats_infraction[username] = $getstats_infraction[fullusername]; } $getstats_infraction[musername] = fetch_musername($getstats_infraction); if ($vbulletin->options['cybtopstats_bold_remove']) { $getstats_infraction[musername] = str_replace($cyb_afs_bpar, "", $getstats_infraction[musername]); } eval('$cybtopstats_infractions .= "' . $vbulletin->templatecache['cyb_topstats_infractions'] . '";'); } if ($vbulletin->db->num_rows($get_stats_infractions) < $resultsnr) { $cybtopstats_infractions .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_infractions)); } unset($get_stats_infractions, $getstats_infraction); print_output($cybtopstats_infractions); $db->show_errors(); if (!$cybtopstats_infractions) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='visitors') AND $cybstats_visitors_enabled) { $db->hide_errors(); $get_stats_visitors = $vbulletin->db->query_read(" SELECT userid, username, usergroupid, displaygroupid, profilevisits FROM " . TABLE_PREFIX . "user AS user WHERE userid > 0 AND profilevisits > 0 $cybexclgroups ORDER BY profilevisits DESC LIMIT 0, $resultsnr "); while ($getstats_visitor = $db->fetch_array($get_stats_visitors)) { $cybstats_rnr += 1; $getstats_visitor[profilevisits] = vb_number_format($getstats_visitor[profilevisits]); $getstats_visitor[fullusername] = strip_tags($getstats_visitor[username]); if ($trimusername > 0) { $getstats_visitor[username] = fetch_trimmed_title($getstats_visitor[fullusername], $trimusername); } else { $getstats_visitor[username] = $getstats_visitor[fullusername]; } $getstats_visitor[musername] = fetch_musername($getstats_visitor); if ($vbulletin->options['cybtopstats_bold_remove']) { $getstats_visitor[musername] = str_replace($cyb_afs_bpar, "", $getstats_visitor[musername]); } eval('$cybtopstats_visitors .= "' . $vbulletin->templatecache['cyb_topstats_visitors'] . '";'); } if ($vbulletin->db->num_rows($get_stats_visitors) < $resultsnr) { $cybtopstats_visitors .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_visitors)); } unset($get_stats_visitors, $getstats_visitor); print_output($cybtopstats_visitors); $db->show_errors(); if (!$cybtopstats_visitors) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='groups') AND $cybstats_groups_enabled) { $db->hide_errors(); $get_stats_groups = $vbulletin->db->query_read(" SELECT socialgroup.groupid, socialgroup.name, socialgroup.creatoruserid, socialgroup.dateline, user.username, user.usergroupid, user.displaygroupid FROM " . TABLE_PREFIX . "socialgroup AS socialgroup LEFT JOIN " . TABLE_PREFIX . "user AS user ON (socialgroup.creatoruserid = user.userid) WHERE creatoruserid > 0 ORDER BY groupid DESC LIMIT 0, $resultsnr "); while ($getstats_group = $db->fetch_array($get_stats_groups)) { $cybstats_rnr += 1; $getstats_group[fullgrouptitle] = strip_tags($getstats_group[name]); if ($trimforumtitles > 0) { $getstats_group[titletrimmed] = fetch_trimmed_title($getstats_group[fullgrouptitle], $trimforumtitles); } else { $getstats_group[titletrimmed] = $getstats_group[fullgrouptitle]; } $getstats_group[fullusername] = strip_tags($getstats_group[username]); if ($trimusername > 0) { $getstats_group[username] = fetch_trimmed_title($getstats_group[fullusername], $trimusername); } else { $getstats_group[username] = $getstats_group[fullusername]; } $getstats_group[musername] = fetch_musername($getstats_group); if ($vbulletin->options['cybtopstats_bold_remove']) { $getstats_group[musername] = str_replace($cyb_afs_bpar, "", $getstats_group[musername]); } if ($getstats_group[dateline] > $vbulletin->userinfo['lastvisit']) { $getstats_group[newpost] = true; } $getstats_group_date = vbdate($vbulletin->options['cybtopstats_date_format'], $getstats_group[dateline]); eval('$cybtopstats_groups .= "' . $vbulletin->templatecache['cyb_topstats_groups'] . '";'); } if ($vbulletin->db->num_rows($get_stats_groups) < $resultsnr) { $cybtopstats_groups .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_groups)); } unset($get_stats_groups, $getstats_group); print_output($cybtopstats_groups); $db->show_errors(); if (!$cybtopstats_groups) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if (($_REQUEST['show']=='donations') AND $cybstats_donations_enabled) { $db->hide_errors(); $get_stats_donations = $vbulletin->db->query_read(" SELECT cybppdonate.id, cybppdonate.userid, cybppdonate.dateline, cybppdonate.confirmed, user.username, user.usergroupid, user.displaygroupid FROM " . TABLE_PREFIX . "cybppdonate AS cybppdonate LEFT JOIN " . TABLE_PREFIX . "user AS user ON (cybppdonate.userid = user.userid) WHERE confirmed = 1 ORDER BY id DESC LIMIT 0, $resultsnr "); while ($getstats_donation = $db->fetch_array($get_stats_donations)) { $cybstats_rnr += 1; $getstats_donation[fullusername] = strip_tags($getstats_donation[username]); if ($trimusername > 0) { $getstats_donation[username] = fetch_trimmed_title($getstats_donation[fullusername], $trimusername); } else { $getstats_donation[username] = $getstats_donation[fullusername]; } $getstats_donation[musername] = fetch_musername($getstats_donation); if ($vbulletin->options['cybtopstats_bold_remove']) { $getstats_donation[musername] = str_replace($cyb_afs_bpar, "", $getstats_donation[musername]); } $getstats_donation_date = vbdate($vbulletin->options['cybtopstats_date_format'], $getstats_donation[dateline]); eval('$cybtopstats_donations .= "' . $vbulletin->templatecache['cyb_topstats_donations'] . '";'); } if ($vbulletin->db->num_rows($get_stats_donations) < $resultsnr) { $cybtopstats_donations .= str_repeat(' ', $resultsnr - $vbulletin->db->num_rows($get_stats_donations)); } unset($get_stats_donations, $getstats_donation); print_output($cybtopstats_donations); $db->show_errors(); if (!$cybtopstats_donations) { print_output(''.$vbphrase['cybstats_nodata'].''); } exit; } if ($_REQUEST['show']=='badadmin') { print_output(''.$vbphrase['cybstats_badadmin'].''.str_repeat(' ', $resultsnr-1)); exit; } }]]> أعلى الإحصائيات تم تعطيلها بنجاح.

لإعادة فتحها استعمل الخيار "{1}" الموجود في قائمة "{2}".]]> ملاحظة هامة: هذا قد يرفع الضغط على السيرفر]]> صفحة المزيد من النتائج
(ضع الأعداد التي تريد وافصل بينها بفاصلة انجليزية)]]>
Note: اقرأ الملف Info.txt للحصول على توضيحات بشأن هذا الخيار]]> المزيد من النتائج]]> بعض التعديلات بحاجة لـ "%" لتضاف قبل كل عامل في الصيغة]]> بعض التعديلات بحاجة لـ "%" لتضاف قبل كل عامل في الصيغة]]> ملاحظة: هذا قد يزيد وقت التحميل قليلاً]]> free yesno 1 free $vbphrase[cyb_top_forumstats] $vbphrase[cyb_top_userstats] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_news] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_newest_members] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_most_viewed] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_posters] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_hottest_threads] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_starters] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_forums] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_referrers] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_classads] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_reputation] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_blogs] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_thanked_members] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_groupposts] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_infractions]   debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_visitors] debug, " title=\"name="setting[$setting[varname]]"\"") . " /> debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_posts] ($vbphrase[cybstats_left]/$vbphrase[cybstats_right]) debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_groups]   debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_donations] ]]> latestposts_r,mostviewedthreads,hottestthreads,hottestforums,newestmembers,posters,threadstarters,referrers,reputations,infractions,visitors,-1 free hottestforums free posters number 0 number 30 number 5 free 5,10,20,30,50,100,200 free 3 free 0 free free free free yesno 1 free yesno 1 free yesno 1 free 1 free 3 free free free 1,8 free free 2 free free free free free yesno 1 number 40 number 40 number 20 free yesno 0 number 2 number 0 free $vbphrase[cyb_top_forumstats] $vbphrase[cyb_top_userstats] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_posts] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_newest_members] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_news] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_posters] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_most_viewed] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_starters] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_hottest_threads] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_referrers] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_forums] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_reputation] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_classads] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_thanked_members] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_latest_blogs] debug, " title=\"name="setting[$setting[varname]]"\"") . " />$vbphrase[cyb_top_infractions] ]]> newestmembers,posters,threadstarters,referrers,reputations,infractions,mostviewedthreads,hottestthreads,hottestforums,latestposts,-1