vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   New Reputation Comments (and Posts) Since Your Last Visit. (https://vborg.vbsupport.ru/showthread.php?t=91146)

divided_by_fear 11-07-2005 10:32 PM

does anyone know how to get this to work with vBadvanced CMPS v2.0

Matt_270581 11-09-2005 09:45 AM

After installing this on 3.51 I just receive a blank page after uploading the file via product manager. Any ideas?

Matt_270581 11-09-2005 10:13 AM

The one you had for 3.5 Beta where it was necessary to run the queries on the tables before installing works on another site I have. Just this one doesn't work on 3.51.

Paul M 11-09-2005 05:15 PM

Quote:

Originally Posted by Matt_270581
After installing this on 3.51 I just receive a blank page after uploading the file via product manager. Any ideas?

Did you do the template edits ?

sHORTYWZ 11-12-2005 12:33 AM

This product will not install with 3.51 - I click on upload and get a blank page in the product manager.

Paul M 11-12-2005 12:09 PM

I think this is a bit of poor feedback from the vb product install system.

This hacks install code adds an index to the post table. If you have a lot of posts, this can take time, during which nothing is displayed. Just leave it to install and it should be okay.

Matt_270581 11-20-2005 02:56 PM

It fully hoses my server, Memory & CPU when trying to import this, even though it just shows a blank page it's obviously trying to do something.

Threads: 37,696, Posts: 525,031
PHP 5
MYSQL 5

Edit: Hoses the server when running just SQL statement too. Guess there is too many posts to alter the table.

Paul M 11-20-2005 03:42 PM

Quote:

Originally Posted by Matt_270581
It fully hoses my server, Memory & CPU when trying to import this, even though it just shows a blank page it's obviously trying to do something.

Threads: 37,696, Posts: 525,031
PHP 5
MYSQL 5

Quote:

Originally Posted by Paul M
This hacks install code adds an index to the post table. If you have a lot of posts, this can take time, during which nothing is displayed.

Check your mysql process list while it's importing, what do they show ?.

Matt_270581 11-20-2005 03:49 PM

Just blows out the Memory of MYSQL and you know what this can do when memory is up near maximum level.

Tried running ALTER TABLE post ADD INDEX (dateline) from MYSQL Control Centre. Same thing.

Worked fine on my board with 9000 posts.

Matt_270581 11-20-2005 03:55 PM

I should really take my forum offline and try lol. Will take it offline later and try it and see what happens.

One question though, if I run the queries:

1. ALTER TABLE post ADD INDEX (dateline) ; - This will speed up the new posts query.

2. ALTER TABLE user ADD lastrepcheck INT(10) UNSIGNED NOT NULL ; - Required for new reputation check.

3. UPDATE user SET lastrepcheck = lastvisit ; - Initilise the new field above.

Then I import the new XML file will it try to rebuild the index? or will it just check and skip that part?

Paul M 11-20-2005 04:24 PM

Quote:

Originally Posted by Matt_270581
Then I import the new XML file will it try to rebuild the index? or will it just check and skip that part?

It will try again. It actually deletes any existing index and re-adds a new one.

To prevent it you will need to edit the xml and remove these lines ;

PHP Code:

$db->query_write("ALTER TABLE " TABLE_PREFIX "post DROP INDEX dateline");
$db->query_write("ALTER TABLE " TABLE_PREFIX "post ADD INDEX dateline (dateline)");
$db->query_write("ALTER TABLE " TABLE_PREFIX "user ADD lastrepcheck INT(10) UNSIGNED NOT NULL");
$db->query_write("UPDATE " TABLE_PREFIX "user SET lastrepcheck = lastvisit"); 


Matt_270581 11-22-2005 04:33 AM

Cheers Paul. Will give it a go and let you know how I go. Keep up the good work :)

Matt_270581 11-22-2005 05:57 AM

Worked well when forum was offline. 425 secs to Alter the posts table :)

Imported the new Modified XML file and it worked like a dream.

Cheers.

Mark.B 12-15-2005 03:54 PM

Only thing I've found with this on my test board is that if doing a getnew or getdaily search, if the search returns no results, the hack doesn't appear. It's fine if there ARE results though.

Paul M 12-15-2005 04:25 PM

Yes - I blame vB for that ;) - the variables values are not carried over into the error page, I expect a global statement in the right place would cure it.

Mark.B 12-15-2005 04:35 PM

Quote:

Originally Posted by Paul M
Yes - I blame vB for that ;) - the variables values are not carried over into the error page, I expect a global statement in the right place would cure it.

Thanks Paul.

You mentioned in the original post being able to switch off the new posts bit and just have the rep...I'd quite like to do this as, certainly on my main board (which is still on 3.0.10 while I work on a test board for upgrading), I have always found the new posts thing a bit too intensive on the server.

However, I'm still new to the whole plugin thing, where do I turn that bit off, or would I need to edit the code out of the XML file and re-import it?

Paul M 12-15-2005 04:50 PM

In the plugin manager, just untick the "active" box for the relevant plugin and click save.

ryuji 01-12-2006 06:02 AM

great mod, makes it much easier to keep tabs on what has happened without looking at the dates/times of all the threads(and still miss some)

apollooooooo 01-12-2006 12:05 PM

thanks just what i have been looking for cheers

jilly 01-13-2006 03:38 AM

I would like to see a modification where that message shows up only if they HAVE rec;'d new reputation - if nothing new has been given, then no message would appear.

Paul M 01-13-2006 04:02 AM

Quote:

Originally Posted by jilly
I would like to see a modification where that message shows up only if they HAVE rec;'d new reputation - if nothing new has been given, then no message would appear.

Just set the phrase "no_new_reputation" to nothing.

jilly 01-13-2006 02:09 PM

would it be possible to display only if there are new comments? So that people don't see the 'no new reputation comments'. It will only show up if there ARE new ones..

Paul M 01-13-2006 03:48 PM

Quote:

Originally Posted by jilly
would it be possible to display only if there are new comments? So that people don't see the 'no new reputation comments'. It will only show up if there ARE new ones..

Erm, I just told you how to do that in the post above. :)

jilly 01-14-2006 03:37 AM

LOL - old lady brain - i forgot that I already asked..lol

HO3R 01-15-2006 01:47 PM

Nice little addon !!

Installing this
Tnx a lot bro

Greetz

hendri 01-18-2006 11:38 AM

awesome ! installed !

lazytown 01-18-2006 11:59 PM

Quote:

Originally Posted by Paul M
Just set the phrase "no_new_reputation" to nothing.

You can't set a phrase replacement to "nothing." It has to at least have one character in it (space is ok I guess). however, it still ads in the newline <br> which causes the box to be one line larger than necessary.

-vissa

lazytown 01-19-2006 12:07 AM

If you have enabled true post read detection (not on by default) where VB remembers all new posts you've read and ones you haven't, then will the "new rep" count still be accurate since the last visit?

-vissa

Paul M 01-19-2006 12:11 AM

The new reputation comments has nothing to do with read posts (or actually, with your last visit). It's new reputation comments since you last viewed them in the usercp - and new posts since your last visit.

MB Dreamz 01-19-2006 01:47 AM

Any way to make it work with vba cmps?

Paul M 01-19-2006 02:25 AM

Quote:

Originally Posted by MB Dreamz
Any way to make it work with vba cmps?

What do you mean exactly ?

MB Dreamz 01-19-2006 02:39 AM

Everything works perfectly in the forums. But in my homepage (CMPS), the new posts count dissappears.

Paul M 01-19-2006 02:48 AM

Try adding $pcount and $rcount to the CMPS global variables list (in it's settings).

MB Dreamz 01-19-2006 02:53 AM

I just tried that, with and without "$", but neither worked. :(

Paul M 01-19-2006 02:59 AM

Dunno atm then.

One forum I'm an Admin on has recently install CMPS so if I get time I'll have a look.

MB Dreamz 01-19-2006 03:21 AM

Found this thread:
http://www.vbadvanced.com/forum/showthread.php?t=12593

Now everything works! I'm not sure why it didn't work for me the 1st time.

Paul M 01-19-2006 04:58 AM

Ah good, I just came back to post that I tried it and it worked, but I see you're okay now. :)

lazytown 01-19-2006 05:22 AM

Quote:

Originally Posted by Paul M
The new reputation comments has nothing to do with read posts (or actually, with your last visit). It's new reputation comments since you last viewed them in the usercp - and new posts since your last visit.

Ah ok thanks for clearing that up. Since I'm only using the rep part, it would appear to work perfectly.

Thanks -vissa

Paul M 01-19-2006 07:11 AM

Quote:

Originally Posted by vissa
Thanks -vissa

NP - Feel free to click install :)

lazytown 01-20-2006 02:10 AM

Clicked! (this is the only mod of about 20 that I forgot to click!)

-vissa

Quote:

Originally Posted by Paul M
NP - Feel free to click install :)



All times are GMT. The time now is 04:07 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.01451 seconds
  • Memory Usage 1,818KB
  • 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
  • (1)bbcode_php_printable
  • (12)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