The Arcive of Official vBulletin Modifications Site.

Roody · #1 12-05-2002, 12:47 PM

I have made two posts about this, but havent received any help so far, so Im providing those posts in here. Here is my situation. I am currently running a hack that shows the number of threads/posts since a persons last visit. The problem with the hack is, that it isnt done at member level meaning people who dont have permission to see certain forums are still having the hack tell them that posts are there to be seen when they arent.

Naturally this is a bit confusing, and I could use any help that someone could provide. Here is the link where I have been trying to obtain help. Thanks

Link

N9ne · #2 12-05-2002, 03:08 PM

I don't understand...do you want something that will cut out the new posts and threads of a private forum which the user cannot access?

NTLDR · #3 12-05-2002, 03:50 PM

If you have moderation on for forums or users then this is why, you need to add:

[SQL]AND visible=1[/SQL]

To the WHERE clause of both the queries you add to index.php

Roody · #4 12-05-2002, 04:14 PM

ok here is what I mean. lets say you are a basic member on my boards. When you click on the new posts/new thread hack which lists exactly how many are new since your last visit if your permissions arent set to see all the forums then even if it lists posts as being new it may come up saying that their is no more new ones.

My questions is, is there a way to incorporate this hack on the member level so the hack correctly shows new posts and threads based on a person's permissions?

As for your post NTDLR..im not sure I follow if what you showed me will do this? Does it?

Erwin · #5 12-06-2002, 02:37 AM

In your query, put what NTLDR wrote after the WHERE section of that query, so that only posts visible to the user is counted.

Roody · #6 12-06-2002, 11:32 AM

ok thanks Erwin for clearing that up for me. I was a little confused with what NTDLR was saying.

Roody · #7 12-08-2002, 05:43 PM

ok guys i finally got this up and running, but i got the following error when I ran that query:

Error

SQL-query :

AND visible = 1

MySQL said:

You have an error in your SQL syntax near 'AND visible = 1' at line 1

Dean C · #8 12-08-2002, 06:11 PM

[sql]
AND visible = '1'
[/sql]

That should be part of the query

You shouldn't have the apostrophes in those positions

- miSt

Roody · #9 12-08-2002, 07:08 PM

I actually did it without apostrophes also Mist, and received the same error. Any other ideas?

NTLDR · #10 12-08-2002, 07:15 PM

Can you post the entire query from the PHP file here?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04552 seconds Memory Usage 2,246KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!