View Single Post
  #344  
Old 04-19-2008, 06:09 PM
mred mred is offline
 
Join Date: Nov 2006
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

there is an error in the logic. At the properties you can limit displaying referrers what will be necessary to prevent from loosing your footer. If you limit to e.g. 100 referrers the amount of referrers will also be limited to 100. See the bit of code below:

Code:
	if ($vbulletin->options['referrers_last_x_referrers'])
	{
		// Pull all the referrers and counts from the db, limiting the retrieval count if necessary
		$get_referrers = $vbulletin->db->query_read("
			SELECT " . $referrers_db_select . "
			FROM " . TABLE_PREFIX . "referrers
			ORDER BY url DESC
			LIMIT " . $vbulletin->options['referrers_last_x_referrers'] . "
		");
	}
	else
	{
		// Pull all the referrers and counts from the db
		$get_referrers = $vbulletin->db->query_read("
			SELECT " . $referrers_db_select . "
			FROM " . TABLE_PREFIX . "referrers
			ORDER BY url DESC
		");
	}

	// Count the entries, wouldn't usually bother with an sql instead of just $i++ but it's used in several places plus the template.
	$url_count = mysql_num_rows($get_referrers);
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01299 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete