vb.org Archive - Deferred Threadviews v1.00 (to reduce server load)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Deferred Threadviews v1.00 (to reduce server load) (https://vborg.vbsupport.ru/showthread.php?t=40137)

I've decided to keep this hack installed. But have not decided to keep the original settings.

I have removed the line which tells it to work under a certain server usage. And have just got it running so it moves them to the database periodically.

I've attached a text file which is a downloaded post from my admin forum on my forums, this contains over 50 e-mails sent by this hack.

I have now commented out the e-mail lines because I'm happy with it's performance at these settings.

Have some problem......when I find this code....

PHP Code:


		
			
    if ($noshutdownfunc) {

      $DB_site->query("UPDATE thread SET views=views+1 WHERE threadid='$threadid'");

    } else {

      $shutdownqueries[]="UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='$threadid'";

    }

I can't fiind it since I have lesane Store hack installed..so the code becomes...

PHP Code:


		
			
if ($noshutdownfunc) {

  $DB_site->query("UPDATE thread SET views=views+1 WHERE threadid='$threadid'");

  

  // Store hack by Lesane



  $storeview=$DB_site->query_first("select views, postuserid from thread WHERE threadid='$threadid'");

  $views=$storeview[views];

  $postuserid=$storeview[postuserid];



  $storeadmin = $DB_site->query_first("SELECT * FROM storeadmin");

  $view1=$storeadmin[view1];

  $view2=$storeadmin[view2];

  $view3=$storeadmin[view3];

  $view4=$storeadmin[view4];

  $view5=$storeadmin[view5];

  $viewpoint1=$storeadmin[vpoint1];

  $viewpoint2=$storeadmin[vpoint2];

  $viewpoint3=$storeadmin[vpoint3];

  $viewpoint4=$storeadmin[vpoint4];

  $viewpoint5=$storeadmin[vpoint5];



  if ($views == $view1) 

  {

    $DB_site->query("UPDATE user SET storep=storep+$viewpoint1 where userid='$postuserid'");

  }

  elseif ($views == $view2) 

  {

    $DB_site->query("UPDATE user SET storep=storep+$viewpoint2 where userid='$postuserid'");

  }

  elseif ($views == $view3) 

  {

    $DB_site->query("UPDATE user SET storep=storep+$viewpoint3 where userid='$postuserid'");

  }

  elseif ($views == $view4) 

  {

    $DB_site->query("UPDATE user SET storep=storep+$viewpoint4 where userid='$postuserid'");

  }

  elseif ($views == $view5) 

  {

    $DB_site->query("UPDATE user SET storep=storep+$viewpoint5 where userid='$postuserid'");

  }

  

} else {

  $shutdownqueries[]="UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='$threadid'";

Any idea what I should do?

I'm the only one with a problem.. :)

After I installed this hack I got 200 Email errors in ~ 5 min :o

Quote:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Too many connections

mysql error number: 1040

I'm using Vb 2.2.2 witht A LOT of hacks :o

Update! This is going to be uninstalled from my boards. Last nights busy period was very busy and all went well. Then it got to about 1am when the visitors start to go down and BOOM - the board was killed for 5mins. I kept trying to enter and when I eventually did the server stats said that usage had been:

10.40 7.00

This caused massive problems and also (I believe) all the view counts were lost.

It seems that when it comes to updating the stats it's such a massive undertaking that it kills the server pc.

I have reinstalled this.

Now have it functioning correctly.

My 'normal users online' is around 100-150 at once. Peaking maybe at 250 at times. A lot of guests visit and a lot of people read threads and don't post, let me know if anyone wants to see my settings for it...

Errr... can someone shed some light on the reason every time I try to download this hack i get v0.91 instead of v0.92?

having installed it I am getting the emails but without the ratio bit added to v0.92.

Looks like it will be a great hack as i have over 50,000 registered users and at least twice that many guests with an average of 250-350 users on at any one time peaking to about 550 every day.

Dedicated server with average load at around 1.5-2.5 but can peak to about 6 or 7 and ocassionally even more.

Quote:

Originally posted by stilger
Hello.. Im thinking about installing this hack on a site that I support that averages about 400 users logged in at a time. Sometimes peaking to around 2000 (well vbulletin reports the most ever as being 2410 I don't know how much you can trust this though). We currently spread our load over 2 servers using Round Robin DNS and have a separate server for all database functions. Will this hack work on multiple server site? I am thinking because of how this hack works there should be no problem but I wanted to make sure. It sounds like this hack would help with the occasional To Many Connections messages we get..... Thanks for the info.

Doh! I stopped getting notification emails... sorry for the long delay. :rolleyes:

I don't see why this wouldn't work with multiple web servers, but I can't be 100% without intimate knowledge of your setup. (that's me covering my ass :p )

The hack makes cumulative updates to the db, so while the two webservers would update the db at different times, it should still work. You'll probably have to tweak the update frequency to get it to your liking, but otherwise, I don't forsee a problem.

Quote:

Originally posted by FFMania
Have some problem......when I find this code....

PHP Code:

if ($noshutdownfunc) { $DB_site->query("UPDATE thread SET views=views+1 WHERE threadid='$threadid'"); } else { $shutdownqueries[]="UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='$threadid'"; }

I can't fiind it since I have lesane Store hack installed..so the code becomes...
<snip>
Any idea what I should do?

I'm not familiar with the Lesane hack, but it looks way more complicated than this hack. Maybe you could ask them...

I just installed this. Tweaking now.

I would like to see your settings....

Quote:

Originally posted by Tim Wheatley
I have reinstalled this.

Now have it functioning correctly.

My 'normal users online' is around 100-150 at once. Peaking maybe at 250 at times. A lot of guests visit and a lot of people read threads and don't post, let me know if anyone wants to see my settings for it...

Hmmm... thank you. Just installed and should do wonders for our forums :cool:.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01352 seconds Memory Usage 1,767KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: