vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - New posts and reputation comments. (https://vborg.vbsupport.ru/showthread.php?t=123931)

Paul M 10-18-2007 12:55 PM

vBulletin Options > Display New Posts and Reputation.

Kamakazy 10-18-2007 01:20 PM

aaah, great...

your a gem... thanks...

Paul M 10-18-2007 03:21 PM

Version 3.23

Since it's been asked about a number of times, I have updated the New Posts count to exclude forums that a member does not have permission to view (similar to the Unread Posts modification).

deezelpope 10-18-2007 03:39 PM

Oh dear!:( Everything was running great, then I updated and now I'm getting this:

Database error in vBulletin 3.6.4:Invalid SQL: SELECT COUNT(post.dateline) AS pcount FROM post AS post FORCE INDEX (dateline) INNER JOIN thread AS thread USING (threadid) WHERE dateline > 1192722160 AND thread.forumid IN (03,59,5,44,52,7,14,54,53,49,47,48,55,43,32,41,31, 42,6,56,57,58,8,15,16,17,26,9,18,20,50,46,19,10,40 ,22,21,12,34,35,13,36,37,38);MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Thursday, October 18th 2007 @ 04:32:28
PMScript : http://www.badgirljammieclub.com/community/private.php
Referrer : http://www.badgirljammieclub.com/community/private.php?do=newpm&pmid=4321
IP Address :
Username : GilferKnight
Classname : vb_database

Canis Firebrand 10-18-2007 03:45 PM

I can't recall if I or someone else asked this before.

Can this and the Display Unread Posts add-on be used together?

The reason I ask and what my users want would be satisfied if they can.

Currently, I use the Display Unread Posts one to have it display any unread posts since their last visit. Other uses want a total count of all unread posts, not just since their last visit. Since there isn't an option to let them choose which way to have the product display, I thought of adding this one as well.

Then, I could set the Display New Posts addon to show all posts since their last login. Then use the Unread Posts addon to display the count of all unread posts.

As long as both addons would display the code, would there be any clashes in the two running at the same time? Would both addons display the code?

I'd like to have it read something like

You have 5 New Posts since your last visit and 20 unread posts total.

I know I'd have to edit the phrasing myself to fix, but aside from that, would what I am looking to be achieve be possible with these two add-ons installed?

Paul M 10-18-2007 04:05 PM

Quote:

Originally Posted by deezelpope (Post 1363129)
Oh dear!:( Everything was running great, then I updated and now I'm getting this:

Database error in vBulletin 3.6.4:Invalid SQL: SELECT COUNT(post.dateline) AS pcount FROM post AS post FORCE INDEX (dateline) INNER JOIN thread AS thread USING (threadid) WHERE dateline > 1192722160 AND thread.forumid IN (03,59,5,44,52,7,14,54,53,49,47,48,55,43,32,41,31, 42,6,56,57,58,8,15,16,17,26,9,18,20,50,46,19,10,40 ,22,21,12,34,35,13,36,37,38);MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Thursday, October 18th 2007 @ 04:32:28
PMScript : http://www.badgirljammieclub.com/community/private.php
Referrer : http://www.badgirljammieclub.com/community/private.php?do=newpm&pmid=4321
IP Address :
Username : GilferKnight
Classname : vb_database


Hmm, odd that I don't get that, but it's easily fixed, just re-download and install.

Paul M 10-18-2007 04:09 PM

Quote:

Originally Posted by Canis Firebrand (Post 1363138)
Can this and the Display Unread Posts add-on be used together?


I bit of an odd thing to do, but you can run them both together if you want, you should disable the reputation section of one of them, otherwise that will run twice.

deezelpope 10-18-2007 04:25 PM

Quote:

Originally Posted by Paul M (Post 1363153)
Hmm, odd that I don't get that, but it's easily fixed, just re-download and install.

Oh, I know, isn't it? Alrighty, I'll try it. Kinda freaked out again and shaking...*sigh*

I did the overwrite with the 3.23...seems ok now. Thank you, Paul.

subnet_rx 10-22-2007 02:54 PM

This seems to now make auto template edits and negates the manual old template edits. Can this be turned back on? I don't display the new posts and rep at the top of the info box, I display them at the bottom.

SBlueman 10-23-2007 02:57 AM

I have a bit of a problem....

I modified my site some and got rid of the usual vbulletin section where you'd normally see this. I added a login menu at the top of the site and when people are logged in they would see all this information. Now the new posts information is showing up underneath the Welcome, [username] section and the reputation part of this mod is not showing up at all. This is my code:

Code:

<table width="880" border="0" cellpadding="1" cellspacing="1" background="http://img150.imageshack.us/img150/3619/cellpic13702babzk1.png">
    <tr>
        <td>&nbsp;</td>
      <td><font color="#000000" size="1"><phrase 1="$bbuserinfo[username]"><strong>$vbphrase[welcome_x]</strong></phrase></font></td>
      <td><div align="center"><if condition="$show[pcount]"><font color="#000000" size="1"><strong>$bbuserinfo[pcount]</strong></font></if>
        </div></td>
      <td><div align="center"><font size="1"><phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]"><font color="#000000"><strong>$vbphrase[last_visited_x_at_y]</strong></font></phrase></font></div></td>
      <td><div align="center"><font size="1"><if condition="$show['pmstats']"><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]"><font color="#000000"><strong>$vbphrase[private_messages_nav]</strong></font></phrase></if></font></div></td>
      <td><div align="center"><font size="1"><if condition="$show['pmwarning']"><strong><phrase 1="$vbphrase[pmpercent_nav_compiled]"><font color="#000000">$vbphrase[your_pm_box_is_x_full]</font></phrase></strong></if></font></div></td>
      <td><div align="center"><font size="1"><if condition="$show[npr_reputation]"><font color="#000000"><strong>$vbphrase[npr_reputation]</strong></font></if></font></div></td>
      <td class="vbmenu_control"><a href="login.php?$session[sessionurl]do=logout&amp;logouthash=$bbuserinfo[logouthash]" onclick="return log_out('$vbphrase[sure_you_want_to_log_out]')"><strong><font size="1">$vbphrase[log_out]</font></strong></a></td>
    </tr>
  </table>

Is there anything I can do to keep this on my site? Or do I have to give it up because it won't work with my custom setup?

This is my site: http://gridironfans.com/


All times are GMT. The time now is 09:47 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.01457 seconds
  • Memory Usage 1,752KB
  • 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_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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