Hide threads by usergroup

[hamed]

Thank you Xenon. But if I do that then the banned user notices something is wrong.
Is there any way to hide the secret banned user group's pms for everyone?

[Xenon]

yes, just don't save em to the db

open private.php find this:

PHP Code:

$DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title,message,dateline,showsignature,iconid,messageread,folderid,receipt) VALUES (NULL,$touserinfo[userid],$touserinfo[userid],$bbuserinfo[userid],'".addslashes(htmlspecialchars($title))."','".addslashes($message)."',".time().",'$signature','$iconid',0,0,$receipt)"); 


and change it to:

PHP Code:

if($bbuserinfo[usergroupid]!=16) $DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title,message,dateline,showsignature,iconid,messageread,folderid,receipt) VALUES (NULL,$touserinfo[userid],$touserinfo[userid],$bbuserinfo[userid],'".addslashes(htmlspecialchars($title))."','".addslashes($message)."',".time().",'$signature','$iconid',0,0,$receipt)"); 


it should work

[hamed]

Thank you. But still I can send pms with my test ban user

[Xenon]

i've edited it, a bit, it was a little typing error

also your banned group id is 16 wasn't it`?

[hamed]

Tanx ever so much. It is working now.
Just the popup and email notification are still working for the person that the pm is sent to.

[Xenon]

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]

Thanks many thanks. It is perfect now!
Thank you

[Xenon]

no problem, you're welcome

[Martin64]

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]

feel free to use the additions from this thread here

[Martin64]

Great, and thanks for all your help.

[Xenon]

no problem

you're welcome

[catbaba]

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:

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]

Hello
It is nice idea
May you make it hack please for v.2.3.0 ?

Tahnck you