Remove 1 Database Query Per Page
Mod Version: 1.1, by Trigunflame
This modification is in the archives.
| vB Version: 3.0.7 | Rating:  (0 vote - 0 average) |
Installs: 18 |
| Released: 17 Apr 2005 | Last Update: Never | Downloads: 5 |
 Not Supported
|
||
Remove 1 Database Query Per Page
Intro:
The idea is, lets remove 1 query from each page load, if the person is just refreshing the page. At first this may sound not important or just plain stupid, but on "larger" forums, cutting 1 query is always welcomed I know.
Description:
Basically all this does, is check the current Session Location from the DB against the current WOL path; the Session is already provided by vbulletin, so no extra query there.
All we do, is simply check the Location from the Database against the current WOL, if they don't match then the query is allowed to update the database; if they are the same - it is simply ignored.
Affects:
The only things this will do, is prevent the updating of the "lastactivity", and "location" if a person keeps refreshing the page, IMO that's not really a big deal, vbulletin takes care of deleting and remaking new sessions when they expire anyway. As long as your members are browsing around and such, their lastactivity, location will be updated as per usual.
Updates:
Version 1.1 - Scripts whosonline, misc are allowed to always update.
Version 1.0 - Release
Instructions:
1. [ open includes/sessions.php ]
2. [ go to about line 354, or look for $bypass = intval(SESSION_BYPASS); ]
3. [ replace this block of code ]
PHP Code:
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "session
SET useragent = '" . addslashes(USER_AGENT) . "', lastactivity = " . TIMENOW . $location . ", styleid = $styleid" . iif(VB_AREA !== 'Upgrade', ", bypass = $bypass") . "
###REPLACE###
WHERE sessionhash = '" . addslashes($session['sessionhash']) . "'"
, 'sessionupdate'
);
PHP Code:
/**
* Update Location On Page Change
*
* @author Trigunflame
* @version 1.1
* @copyright Dusty Burns 2005-2006
*/
// Check Script
if ($session['location'] != WOLPATH || THIS_SCRIPT == 'misc' || THIS_SCRIPT == 'online')
{
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "session
SET useragent = '" . addslashes(USER_AGENT) . "', lastactivity = " . TIMENOW . $location . ", styleid = $styleid" . iif(VB_AREA !== 'Upgrade', ", bypass = $bypass") . "
###REPLACE###
WHERE sessionhash = '" . addslashes($session['sessionhash']) . "'"
, 'sessionupdate'
);
}
/**
* End Update Locations On Page Change
*/
Download
No files for download.