[2.0.10] View posts since last visit Number

The cleanup is complete. This forum is now read only.

Rating:

Excellent!
15
58%
Very Good
4
15%
Good
3
12%
Fair
1
4%
Poor
3
12%
 
Total votes: 26

Krisiun
Registered User
Posts: 124
Joined: Mon Feb 03, 2003 12:46 pm
Location: Porto Alegre - Brazil
Contact:

Post by Krisiun » Mon Nov 22, 2004 2:58 am

Any demo?!?

Bradman
Registered User
Posts: 84
Joined: Mon Nov 11, 2002 6:39 am
Location: Ledyard, CT
Contact:

Post by Bradman » Tue Nov 23, 2004 2:54 am

Image

Krisiun
Registered User
Posts: 124
Joined: Mon Feb 03, 2003 12:46 pm
Location: Porto Alegre - Brazil
Contact:

Thanks

Post by Krisiun » Sat Nov 27, 2004 9:16 pm

Thanks Bradman. :wink:

mxf80
Registered User
Posts: 2
Joined: Sun Jan 09, 2005 8:15 pm

Post by mxf80 » Sun Jan 09, 2005 8:30 pm

Hello,

There's this MOD ( here: http://www.phpbb.com/phpBB/viewtopic.php?t=222168 ) that shows us in the index page how many new TOPICS we have since the last visit.

So Shof515, since you made this MOD that tells us how many new POSTS we have since the last visit, could you please make another MOD that works together with the MOD linked above to tell us how many new TOPICS there are since the last visit?

Or can someone else make one?

It could be really usefull since POSTS are different from TOPICS.

Thanks a lot in advance!!! :wink:

Noonster
Registered User
Posts: 37
Joined: Thu Jan 20, 2005 9:45 pm
Location: East Yorkshire, UK
Contact:

Post by Noonster » Sun Jan 23, 2005 8:11 pm

I would also like to know how to make it count topics instead of posts.....

Cheers
Daz

wahmiam
Registered User
Posts: 1
Joined: Thu Feb 03, 2005 5:15 am

Post by wahmiam » Thu Feb 03, 2005 5:18 am

I installed this mod the right way, yet, when I click "all forums read" for myself.. it still shows the same number of new posts. :(
Any Ideas?
http://www.wahmiam.com/wahmbb/index.php

User avatar
MoLew
Registered User
Posts: 198
Joined: Fri Jul 05, 2002 7:52 pm
Location: Minnesota, U.S.A.

Post by MoLew » Fri Feb 04, 2005 1:24 pm

A useful little gem, thanks. :)

Would be good to see the new topics number as well... on the surface it seems it shouldn't be too hard to work out.

M. W. I. Prod.
Registered User
Posts: 9
Joined: Wed Jul 14, 2004 3:52 pm

Info : SQL requests added

Post by M. W. I. Prod. » Sun Feb 20, 2005 2:37 am

SQL requests added
  • index : 1
  • viewforum : 0
  • viewtopic with 2 posts : 0
  • viewtopic with 6 posts : 0
  • posting : 0
  • profile : 0
  • memberlist : 0

Zanowin
Registered User
Posts: 19
Joined: Tue Feb 22, 2005 3:17 pm

Post by Zanowin » Fri Feb 25, 2005 4:03 pm

MoLew wrote: A useful little gem, thanks. :)

Would be good to see the new topics number as well... on the surface it seems it shouldn't be too hard to work out.



I agree!!!!


I really like this mod, its very simple to install. Every time I install the other mod mentioned above, I get errors :(
i r kool irl

Lord Raiden
Registered User
Posts: 391
Joined: Sat Jun 26, 2004 11:24 pm
Contact:

Post by Lord Raiden » Sat Mar 12, 2005 1:30 am

I've got a rather odd problem with this mod. No matter how many times I leave and come back the number never resets. It just keeps incrementing for me and for others it is stuck at one number and not incrementing at all. Is there something wrong or something I possibly missed? My forums are at forums.raiden.net if you need to look at my site for any reason.

EDIT: Nevermind, I figured out what it was doing. hehe.
Steve Lake
-Owner/Admin/Author of:
-Raiden's Realm - Bringing Linux to the World

Betialai
Registered User
Posts: 8
Joined: Thu Dec 23, 2004 7:35 pm

Post by Betialai » Fri Mar 18, 2005 10:57 am

Vv. wrote: Does it add the posts in inaccessible/invisible forums too?


Yes, it does. Which is weird because people can see that there are new posts but none is available to them.

Given that it checks the records in the post-table (phpbb_posts if you don't change the prefix) compared to the last visit, it doesn't take into account the permissions.

You can modify the SQL statement so that it doesn't count posts from a given forum or list of forums, like

Code: Select all

	$sql = "SELECT COUNT(post_id) as total 
		FROM " . POSTS_TABLE . " 
		WHERE post_time >= " . $userdata['user_lastvisit'] . "
		AND forum_id <> 10
		AND poster_id != " . $userdata['user_id']; 
instead of the original statement

Code: Select all

	$sql = "SELECT COUNT(post_id) as total 
		FROM " . POSTS_TABLE . " 
		WHERE post_time >= " . $userdata['user_lastvisit'] . " 
		AND poster_id != " . $userdata['user_id']; 
While the forum 10 will appear with the orange icon, it will not show up in the post count. Having the users of forum 10 warned about it should be enough.

Kinsman
Registered User
Posts: 207
Joined: Sun Jan 02, 2005 6:04 am
Contact:

Post by Kinsman » Fri Mar 25, 2005 11:01 am

Ok, first, thanks for another great Mod!, very handy! :D

Next, i am surprised there has been so little interest in seeing if this can be applied to the New Topics Mod? i think thats a fabolous idea, but unfortunately am too much of a PHP noob to be of much assistance! :oops:

I have had a bit of a play, but have only succeeded in getting the brackets to show, with no nuber in the middle so far! :roll:

Is anybody out there able to help with this at all?, you can see what i mean by visiting my board at www.junglewraiths.net

Thanks in advance to any coders out there able to help! :D

Kanon
Registered User
Posts: 72
Joined: Sat Sep 11, 2004 2:53 pm

Post by Kanon » Sat Mar 26, 2005 12:03 pm

Im using the Boyz theme and think the number is too dark. Does any one know how I can change the color of the number?
Doh

Billy2423
Registered User
Posts: 88
Joined: Sun Sep 28, 2003 2:23 pm
Location: USA
Name: Bill Withers
Contact:

Post by Billy2423 » Mon May 30, 2005 3:09 pm

MoLew wrote: A useful little gem, thanks. :)

Would be good to see the new topics number as well... on the surface it seems it shouldn't be too hard to work out.


View new topics since last visit

Fangarr
Registered User
Posts: 10
Joined: Sun Jun 12, 2005 12:13 am

MS Access

Post by Fangarr » Wed Jun 15, 2005 1:26 am

This MOD Doesn't work if you use a MS Access database due to the use of != in the SELECT Query.

MS Access users need to change != to <> to get this to work.

Post Reply

Return to “[2.0.x] MOD Database Cleanup”