vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   New Posts & Threads Since Last visit (https://vborg.vbsupport.ru/showthread.php?t=82774)

Guest210212002 01-25-2006 07:48 PM

[high]* Guest210212002 clicks install
[/high]

Thanks as always bud. :)

Devil006 02-17-2006 11:57 AM

Good Job
Thx

Devil006 Clicks Install

Gemilang 03-14-2006 04:15 PM

I'm getting this error when running the query:
Quote:

#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 03-20-2006 09:54 PM

I highly advise agsint having it show on all pages.

s?dpol 05-11-2006 07:24 PM

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:
    Code:

    <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:
    Code:

    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 05-11-2006 09:52 PM

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 06-12-2006 11:40 PM

bookmarked. :)

Reverend 06-14-2006 10:33 PM

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

Can anyone confirm this still works with 3.6.0 B2.

Zachery 06-15-2006 03:18 AM

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

Reverend 06-15-2006 09:41 AM

Quote:

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.

Reverend 06-15-2006 09:53 AM

Update: tried it this morning and it is now working correctly. :confused:

Zachery 06-15-2006 05:59 PM

Weird.

Reverend 06-15-2006 06:02 PM

Quote:

Originally Posted by Zachery
Weird.

Yep, can only think it may have been a dateline cache issue after i upgraded to 3.6 :confused:

Zachery 06-15-2006 06:04 PM

Maybe.

MuhammadC 07-06-2006 06:41 PM

Good, for smaller forums. My page generation times went from 0.15 seconds to 2.5 with this plugin installed. Neat, but too intensive for my forum. :cool:

Reverend 07-06-2006 08:25 PM

Quote:

Originally Posted by MuhammadC
My page generation times went from 0.15 seconds to 2.5 with this plugin installed.

Yeah of course they did. :rolleyes:

Whats that smell?

Zachery 07-06-2006 08:47 PM

Quote:

Originally Posted by MuhammadC
Good, for smaller forums. My page generation times went from 0.15 seconds to 2.5 with this plugin installed. Neat, but too intensive for my forum. :cool:

pages? maybe you shouldn't have removed the code to only have it run on the forumhome.

Smoothie 07-23-2006 08:13 PM

Hey guys, 2 quick questions. How many extra queries does this add and does this only display on forum home?

Zachery 07-24-2006 12:42 PM

It adds two queries only to the forumhome.

WeArab 08-07-2006 08:47 AM

Hello,

Great add-on, thank you!

When VB 3.6.0 would be supported?

Chris Blount 08-07-2006 11:58 AM

This already works in VB 3.6.

Zachery 08-08-2006 09:41 PM

It is already working for 3.6.

Conspiracy 08-09-2006 10:10 AM

I ran the query and I got this error

Quote:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
ALTER TABLE `thread` ADD INDEX ( `dateline` )' at line 1
why?
I've installed it on another forum and it was fine, I'm not good with MySQL so I wouldn't know where to look for the right syntax, could someone help ?

Zachery 10-06-2006 03:29 AM

uber late response but what version of mysql?

ChopBam 11-13-2006 03:10 AM

I believe I found a problem with this one.
I just noticed that the number of new posts includes posts you don't have the permission to read, and I'm sure this applies to threads too.

Zachery 11-13-2006 03:47 PM

Yea, 9/10 times it shouldn't be a big issue. Adding permissions to the query will only make things more comlicated.

Zachery 03-06-2007 05:44 PM

Anyone using this with MySQL5?

Smoothie 03-06-2007 05:57 PM

any chance of fixing the "you don't have the permission to read"?

Zachery 03-06-2007 06:02 PM

Quote:

Originally Posted by Smoothie (Post 1197369)
any chance of fixing the "you don't have the permission to read"?

Hmmm?

Smoothie 03-06-2007 06:06 PM

Quote:

Originally Posted by ChopBam (Post 1116000)
I believe I found a problem with this one.
I just noticed that the number of new posts includes posts you don't have the permission to read, and I'm sure this applies to threads too.

Quote:

Originally Posted by Zachery (Post 1116368)
Yea, 9/10 times it shouldn't be a big issue. Adding permissions to the query will only make things more comlicated.

That :)

Zachery 03-06-2007 06:10 PM

Like i said, on a normal forum with decent activity it shouldn't be an issue. I'd have to add permissions checks and I'd rather not do that, it makes things more complicated.

Smoothie 03-06-2007 08:16 PM

I haven't installed it yet because of this ever-so-slight problem.

If I do install, is it still necessary to run those 2 queries?

Quote:

Optionally you should add indexes on your post and thread tables for the dateline columns

Zachery 03-07-2007 07:09 AM

Really at best its a minor annoyance TBH. Its not nessary but recomended to help speed the searches up.

Smoothie 03-07-2007 08:40 AM

Thanks.

Sir_Yaro 04-07-2007 03:35 PM

Works on 3.6.5

WebConnection 04-12-2007 05:34 AM

Hi,

Why is it that the link of the new post and new thread are the same? Is there a way that the link of the new thread will just display the new threads?

Thanks.

amir86 04-12-2007 09:28 PM

Installed - Thanks.

Reverend 05-11-2007 09:23 PM

Working on 3.6.6

mcyates 07-15-2007 01:09 PM

Im using vb 3.6.7 PL1 and I want this script to work on my forum as the other script I have been using, the welcome panel one, adds 9 queries to the forumhome.

I'm getting this error:
Code:

There has been Array new posts and 0 new threads since your last visit.
What can I do to get this to work.

Zachery 07-16-2007 04:47 PM

Works fine on my 3.6.7 install, not sure what you could have done.


All times are GMT. The time now is 10:21 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01480 seconds
  • Memory Usage 1,792KB
  • 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_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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