[Release] Since your last visit X posts and X threads. (2.0!)

(This has been upgraded to verson 2.0 )

What this dose:

This will add since your last visit" XX posts and XX threads have been posted to the main page of your vBulletin.

This is based off the hack at vBulletin.org, this one adds it without hacking the index.php file. For reference, the original hack can be found here: https://vborg.vbsupport.ru/showthrea...threadid=31957

Screenshot in the next post.

Download: Here

Upgrading from 1.2 to 2.0

Verson 2.0 has been released, 2.0 will cut down the time it takes to run the querys added by this modification.

To upgrade:

---------------------------------
Run this SQL query:
---------------------------------

ALTER TABLE `post` ADD INDEX(`dateline`) ;

Upgrading from 1.0 to 2.0

Verson 2.0 has been released, 2.0 will cut down the time it takes to run the querys added by this modification.

1.0 also ran the querys on EVERY page generated by vBulletin. 1.2 and 2.0 only run these querys on /root/forum/index.php.

If you have already installed this modification upgrade ASAP.

To upgrade:

---------------------------------
Run this SQL query:
---------------------------------

ALTER TABLE `post` ADD INDEX(`dateline`) ;

----------------------------------
Open template phpinclude
----------------------------------

---------
Find:
---------

$loonewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]'");
$loonewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]'");

-----------------
Replace with:
-----------------

// Start thread and post scence last vist modification
if (strpos($_SERVER['PHP_SELF'], 'index.php') != false)
{
$loonewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]'");
$loonewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]'");
}

[wyzzor]

thanks

[Brad]

Version 2.0 has been released.

This version solves the issues with the time it takes for the querys to run that are added by this modification. It is recomended that you upgrade if you have a older version installed. Upgrade instructions are in the frist post of this thread.

[sonic3d]

how do i remove the query?

l8er
sonic

[Bad Bunny]

You cannot remove the queries and still have the hack work. You can, however, reverse the steps of installation of you want to remove it.

If you clarify yourself better, you may get a decent answer.

[gmarik]

The attachemnt is lost Can you fix that?