vb.org Archive
Page 3 of 3 12 3
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Hide threads by usergroup (https://vborg.vbsupport.ru/showthread.php?t=47150)

Xenon 01-02-2003 03:57 PM
no problem also

find this in private.php:
PHP Code:
if ($userignored!=1) { 
and change to:
PHP Code:
if ($userignored!=1 and $bbuserinfo[usergroupid]!=16) { 

hamed 01-03-2003 03:11 AM
Thanks many thanks. It is perfect now!
Thank you :)

Xenon 01-03-2003 09:05 PM
:)

no problem, you're welcome

Martin64 01-03-2003 09:36 PM
I plan on releasing a full hack (either that or as an add-on to the secretly banned users hack). If I have Xenon's permission, I will include the additions in this thread as well. :)

So far the additions to the secretly banned users hack are:

- Option for moderators to either set a regular ban or a secret ban in the Mod CP.
- Hide threads started by secretely banned users to everyone but the user himself, admins and mods.
- Ignore private messages by secretely banned users.
- Give an "invalid thread error" when trying to view a thread started by a secretly banned user, unless the viewer is secretely banned, admin or mod. This is to prevent users from searching for posts by secretly banned users and being able to view them.

Xenon 01-04-2003 10:00 AM
feel free to use the additions from this thread here :)

Martin64 01-04-2003 08:39 PM
Great, and thanks for all your help. :)

Xenon 01-04-2003 09:32 PM
no problem

you're welcome :)

catbaba 05-31-2003 06:26 PM
Despite applying the 'thread.lastpost' fix mentioned here, I kept getting the following error every so often (a few times a day, and only when 'power forum users' tried to play with the thread display options at the bottom of the page), when using mySQL 4.0.13 and PHP 4.3.2:

Code:
Database error in vBulletin 2.3.0:

Invalid SQL:
    SELECT
   
        thread.threadid    FROM thread
              LEFT JOIN user ON (thread.postuserid = user.userid)
    WHERE thread.forumid = 18
        AND thread.sticky=0
 
        AND thread.visible=1
    AND thread.lastpost >= 1045766820
   
      ORDER BY sticky DESC, lastpost DESC
      LIMIT 25,25
mysql error: Column: 'lastpost' in order clause is ambiguous

mysql error number: 1052

Date: Saturday 31st of May 2003 07:47:00 PM
Script: http://www.ummah.com/forum/forumdisp...e=100&x=13&y=9
I fixed it by adding the following line of code before the database query:

PHP Code:
if ($sortfield == 'lastpost') {
    $sortfield = 'thread.lastpost';
} 
So now the DB query code block looks like this (my secret ban usergroup is 104):

PHP Code:
// bismillah, add secret ban hack

if ($sortfield == 'lastpost') {
    $sortfield = 'thread.lastpost';
}

$getthreadids=$DB_site->query("
    SELECT
    ".iif($sortfield=="voteavg",$votequery,"")."
        thread.threadid    FROM thread
              LEFT JOIN user ON (thread.postuserid = user.userid)
    WHERE thread.forumid = $foruminfo[forumid]
        AND thread.sticky=0
 ".iif(in_array($bbuserinfo[usergroupid], array(5,6,7,104)), "", "AND user.usergroupid != 104 ") . "
        AND thread.visible=1
    $datecut
    $limitothers
      ORDER BY sticky DESC, $sortfield $sqlsortorder
      LIMIT ".($sel_limitlower-1).",$perpage");

// end secret ban hack 
I just thought I'd post this in case anyone else is getting the same error.

ghroob 06-11-2003 06:16 AM
Hello
It is nice idea
May you make it hack please for v.2.3.0 ?

Tahnck you


All times are GMT. The time now is 11:55 PM.
Page 3 of 3 12 3
Show 40 post(s) from this thread on one page

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.01168 seconds
  • Memory Usage 1,747KB
  • 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
  • (4)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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