New Posts & Threads Since Last visit

Um. I think this one is fairly self explaintiory by now.

It gets a count of the newest posts and threads since their last visit.


Optionally you should add indexes on your post and thread tables for the dateline columns
[sql]
ALTER TABLE `post` ADD INDEX ( `dateline` );
ALTER TABLE `thread` ADD INDEX ( `dateline` );
[/sql]

[high]* Guest210212002 clicks install
[/high]

Thanks as always bud.

[Devil006]

Good Job
Thx

Devil006 Clicks Install

[Gemilang]

I'm getting this error when running the query:

#1146 - Table 'houseboa_vb1.post' doesn't exist

I looked at my tables, and there is a 'post' table.

[high]* Gemilang is confused[/high]

[Zachery]

I highly advise agsint having it show on all pages.

[s?dpol]

Hi,

I just installed this nice plugin. In order to enable the use of the phrase system I modifed it a bit.

If somebody would like to do so as well :

• upload the xml file
• open the template navbar
  find: <strong>$vboptions[bbtitle]</strong>
  add after:
  

  <if condition="$vbulletin->userinfo['userid'] != '0' AND THIS_SCRIPT == 'index'"><br /><span class="smallfont"><a href="search.php?do=getnew"><phrase 1="$newposts" 2="$newthreads">$vbphrase[navbar_sincelastvisit]</phrase></a></span></if>

• add new Phrase
  Variablenname: navbar_sincelastvisit
  Text: {1} neue Themen und {2} neue Beitr?ge seit Ihrem letzten Besuch.
  Deutsch: {1} neue Themen und {2} neue Beitr?ge seit Ihrem letzten Besuch.
  English: {1} new Threads and {2} new Posts since your last visit.
• Execute the following queries in order to add a index on the used table colums:
  

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

[EDIT]
20060618: removed "$vboptions[bburl]/" in the template code - as https doesn't work

[Digital2]

Why am I only getting this text with no numbers plugged into it?

There has been new posts and new threads since your last visit.
( Get New Posts )

Yes, the database fields being queried are the correct ones and are correctly defined in the plugin.

Also, the following query was made succesfully:

ALTER TABLE `vbfpost` ADD INDEX ( `dateline` );
ALTER TABLE `vbfthread` ADD INDEX ( `dateline` );

[GrendelKhan{TSU]

bookmarked.

[Reverend]

Doesn't appear to be working on my 3.6.0 B2. Its showing the wrong totals. Posts 4 Threads 210 since last visit.

Can anyone confirm this still works with 3.6.0 B2.

[Zachery]

I can't see why it wouldn't work.

[Reverend]

Originally Posted by Zachery

I can't see why it wouldn't work.

Thats what i initially thought, but obviously something is screwed on mine. I've reinstalled the plugin and ran the db queries still same issue with the totals.