Remove 1 Query Per Page

[CENTER]Remove 1 Database Query Per Page
Reduce your forums query usage !

Summary: (Quoted From Original Hack for vb3)

Removes 1 Query Per Page.

Instructions:

1. Open includes/class_core.php
2. Go to about line 2538 and look for

PHP Code:

$this->set('location', WOLPATH); 


3. Above that, paste the following.

PHP Code:

$this->set('old_location', $session['location']); 


4. Go to about line 2818 and look for the following:

PHP Code:

            // registered user
            if (!SESSION_BYPASS)
            {
                if (TIMENOW - $this->userinfo['lastactivity'] > $this->registry->options['cookietimeout'])
                {
                    // see if session has 'expired' and if new post indicators need resetting
                    $this->registry->db->shutdown_query("
                        UPDATE " . TABLE_PREFIX . "user
                        SET
                            lastvisit = lastactivity,
                            lastactivity = " . TIMENOW . "
                        WHERE userid = " . $this->userinfo['userid'] . "
                    ", 'lastvisit');

                    $this->userinfo['lastvisit'] = $this->userinfo['lastactivity'];
                }
                else
                {
                        $this->registry->db->shutdown_query("
                            UPDATE " . TABLE_PREFIX . "user
                            SET lastactivity = " . TIMENOW . "
                            WHERE userid = " . $this->userinfo['userid'] . "
                            ", 'lastvisit');
                }
            } 


5. Replace that with the following:

PHP Code:

            // registered user
            if (!SESSION_BYPASS)
            {
                if (TIMENOW - $this->userinfo['lastactivity'] > $this->registry->options['cookietimeout'])
                {
                    // see if session has 'expired' and if new post indicators need resetting
                    $this->registry->db->shutdown_query("
                        UPDATE " . TABLE_PREFIX . "user
                        SET
                            lastvisit = lastactivity,
                            lastactivity = " . TIMENOW . "
                        WHERE userid = " . $this->userinfo['userid'] . "
                    ", 'lastvisit');

                    $this->userinfo['lastvisit'] = $this->userinfo['lastactivity'];
                }
                elseif ($this->vars['old_location'] != WOLPATH || THIS_SCRIPT == 'misc' || THIS_SCRIPT == 'online')
                {
                    $this->registry->db->shutdown_query("
                        UPDATE " . TABLE_PREFIX . "user
                        SET lastactivity = " . TIMENOW . "
                        WHERE userid = " . $this->userinfo['userid'] . "
                        ", 'lastvisit');
                }
            } 


[Corriewf]

Awesome! Thanks!

[Trigunflame]

Originally Posted by Corriewf

Awesome! Thanks!

Welcomez

[Protoman]

think the vB team will add this to the next version??

[Zia]

[high]* Zia kliks install
[/high]

Trigunflame what is next tremendious idea to make page laod faster & fatser ?

[Kihon Kata]

INstalled! Thanks! but I am running ministats and I am not seeing a decrease on queries listed in there during page loads.

[Trigunflame]

Because if you would look at the query:

$this->registry->db->shutdown_query()

It is a shutdown query that is run as the script is ending, and is not shown in any query counters. Nevertheless it is still sending that query to your forums mysql database which affects the system.

I didnt say this would necessarily make your forum "Faster", I just said it would reduce a query, lol.

Go read my thread in vb3 if you dont believe me...

[GenSec]

/me cliks install

Thank you, very usefull!

[GenSec]

/me cliks install

Thank you, very usefull!

[Trigunflame]

Originally Posted by GenSec

[high]* GenSec cliks install
[/high]

Thank you, very usefull!

Doublepost, might wanna delete one; lol.