##############################################################
## MOD Title: tarb abuse control
## MOD Author: Karlg < karlg@email.net > (Karl Grindley)
## MOD Description: Highly effective abuse control
## over your users.  (Tarb stands for Brat, backwards)
## MOD Version: 0.0.4
##
## Installation Level: (easy)
## Installation Time: 45 Minutes
## Files To Edit: includes/functions_post.php
##                admin/admin_users.php
##                templates/subSilver/admin/user_edit_body.tpl
##                posting.php
##                viewforum.php
##                viewtopic.php
## Included Files: N/A
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/
##############################################################
## Author Notes:
##   The theory behind this is to discourage cronic abusers,
##      spammers and rule breakers from using your forums,
##      and make them just go away.  The theory behind this mod
##      allows you the admin, to flag a user without their
##      knowledge, allow them to use the board, but all posts/
##      topics are flagged.  Any flagged topic/post is only view
##      able to the abusive user, and the administrator, but invisible
##      to everyone else. 
##
##      When you ban or delete an account, the user is immidiately aware
##      of this, which usually results in (attempted) retaliation.
##      This mod lets you secreatly flag their account and
##      lets the abuser waste their time, while leaving your
##      community alone.
##
##   To flag an abusive account, use the admin panel to edit
##      the uesr's account. Set the Tarb flag, and and all posts/
##      topics posted by that user are invisible to all other users,
##   but appears completely normal to the abusive user. All
##   tarbed posts/topics are visable to the Administarator
##   with a note next to the post/topic title.
##
## ToDo:
##   - Add PM support
##   - Add support for moderators to tarb users
##   - Add easy topic/post tarb pruning
##   - Add reports from the admin panel so an admin can see
##     all tarbed posts/topics
##   - Post/Topic tarb toggle (untarb/tarb a post/topic)
##   - Add cookie support, so when a user logs out, his/her
##     post is still viewable only to themselves
##   - Add (seperate Mod?) viral mode (so a tarbed user
##     creates/logs into another account, it will auto tarb
##     the dupe account based on the browser cookie)
##
##  NOTE: BACKUP YOUR DATABASE BEFORE PREFORMING THE BELOW
##        SQL STATEMENTS
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ SQL ]------------------------------------------
#
alter table phpbb_users add user_tarb tinyint(1) default 0 not null;
alter table phpbb_posts add post_tarb tinyint(1) default '0' not null after post_username;
alter table phpbb_topics add topic_tarb tinyint(1) default '0' not null after topic_poster;


#
#-----[ OPEN ]------------------------------------------
#
admin/admin_users.php

#
#-----[ FIND ]------------------------------------------
#
                $user_avatar = ( empty($user_avatar_loc) ) ? $this_userdata['user_avatar'] : '';
                $user_avatar_type = ( empty($user_avatar_loc) ) ? $this_userdata['user_avatar_type'] : '';


#
#-----[ AFTER, ADD ]------------------------------------------
#
                $user_tarb = ( !empty($HTTP_POST_VARS['user_tarb']) ) ? intval( $HTTP_POST_VARS['user_tarb'] ) : 0;


#
#-----[ IN-LINE FIND ]------------------------------------------
#
user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status,


#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
user_tarb = $user_tarb,

#
#-----[ FIND ]------------------------------------------
#
                $user_timezone = $this_userdata['user_timezone'];
                $user_dateformat = $this_userdata['user_dateformat'];


#
#-----[ AFTER, ADD ]------------------------------------------
#
      $user_tarb = $this_userdata['user_tarb'];


#
#-----[ FIND ]------------------------------------------
#
                        $s_hidden_fields .= '<input type="hidden" name="timezone" value="' . $user_timezone . '" />';
                        $s_hidden_fields .= '<input type="hidden" name="dateformat" value="' . str_replace("\"", "&", $user_dateformat) . '" />';

#
#-----[ AFTER, ADD ]------------------------------------------
#
         $s_hidden_fields .= '<input type="hidden" name="user_tarb" value="' . $user_tarb . '" />';


#
#-----[ FIND ]------------------------------------------
#
                        'ALLOW_AVATAR_YES' => ($user_allowavatar) ? 'checked="checked"' : '',
                        'ALLOW_AVATAR_NO' => (!$user_allowavatar) ? 'checked="checked"' : '',

#
#-----[ AFTER, ADD ]------------------------------------------
#
                        'USER_TARB_YES' => ($user_tarb) ? 'checked="checked"' : '',
                        'USER_TARB_NO' => (!$user_tarb) ? 'checked="checked"' : '',


#
#-----[ FIND ]------------------------------------------
#
                        'L_SPECIAL' => $lang['User_special'],
                        'L_SPECIAL_EXPLAIN' => $lang['User_special_explain'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
                        'L_USER_TARB' => $lang['User_tarb'],


#
#-----[ OPEN ]------------------------------------------
#
includes/functions_post.php

#
#-----[ IN-LINE, FIND ]------------------------------------------
#
$sql  = ( $mode != "editpost" ) ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id
, topic_status, topic_type, topic_vote

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, topic_tarb

#
#-----[ IN-LINE, FIND ]------------------------------------------
# Same line as above...
) VALUES ('$post_subject', " . $userdata['user_id'] . ", $current_time, $forum_id,
" . TOPIC_UNLOCKED . ", $topic_type, $topic_vote

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, " . $userdata['user_tarb'] . "

#
#-----[ IN-LINE, FIND ]------------------------------------------
#
$sql = ( $mode != "editpost" ) ? "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, post_username, post_time,
poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, post_tarb

#
#-----[ IN-LINE, FIND ]------------------------------------------
#
) VALUES ($topic_id, $forum_id, " . $userdata['user_id']
. ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, " . $userdata['user_tarb'] . "

#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_admin.php

#
#-----[ FIND ]------------------------------------------
#
$lang['User_status'] = 'User is active';

#
#-----[ AFTER, ADD ]------------------------------------------
#
$lang['User_tarb'] = 'User is tarbed';


#
#-----[ OPEN ]------------------------------------------
#
posting.php

#
#-----[ IN-LINE, FIND ]------------------------------------------
#
# After this line:
#submit_post($mode, $post_data, $return_message, $return_meta, $forum_id, $topic_id, $post_id, $poll_
#id, $topic_type, $bbcode_on, $html_on, $smilies_on, $attach_sig, $bbcode_uid, str_replace("\'", "''", $username), str_replace("\'",
#"''", $subject), str_replace("\'", "''", $message), str_replace("\'", "''", $poll_title), $poll_options, $poll_length);
if ( $error_msg == ''

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
&& $userdata['user_tarb'] != "1"


#
#-----[ OPEN ]------------------------------------------
#
viewtopic.php

#
#-----[ FIND ]------------------------------------------
#
//
// Go ahead and pull all data for this topic
//

#
#-----[ AFTER, ADD ]------------------------------------------
#
if ( $userdata['user_rank'] != "1" )
{
  $ignore_tarbed = "AND (p.post_tarb = '0' OR (p.poster_id = '" . $userdata['user_id'] . "'))";
}

#
#-----[ FIND ]------------------------------------------
#
                AND pt.post_id = p.post_id
                AND u.user_id = p.poster_id

#
#-----[ AFTER, ADD ]------------------------------------------
#
                $ignore_tarbed

#
#-----[ FIND ]------------------------------------------
#
        $post_subject = ( $postrow[$i]['post_subject'] != '' ) ? $postrow[$i]['post_subject'] : ''; : '';

#
#-----[ AFTER, ADD ]------------------------------------------
#
        if ( $userdata['user_rank'] == "1" )
        {
                if ( $postrow[$i]['post_tarb'] == 1)
                        {
                                $post_subject .= " <font color=\"#AA5555\">(tarbed post)</font>" ;
                        }
                }

#
#-----[ OPEN ]------------------------------------------
#
viewforum.php

#
#-----[ FIND ]------------------------------------------
#
// Grab all the basic data (all topics except announcements)
// for this forum
//

#
#-----[ AFTER, ADD ]------------------------------------------
#
if ( $userdata['user_rank'] != "1" )
{
  $ignore_tarbed = "AND (t.topic_tarb = '0' OR (t.topic_poster = '" . $userdata['user_id'] . "'))";
}


#
#-----[ FIND ]------------------------------------------
#
                AND u2.user_id = p2.poster_id
                AND t.topic_type <> " . POST_ANNOUNCE . "
                $limit_topics_time

#
#-----[ AFTER, ADD ]------------------------------------------
#
                $ignore_tarbed


#
#-----[ FIND ]------------------------------------------
#
...$topic_rowset[$i]['topic_title']) : $topic_rowset[$i]['topic_title'];

#
#-----[ AFTER, ADD ]------------------------------------------
#
                if ( $userdata['user_rank'] == "1" )
                {
                        if ( $topic_rowset[$i]['topic_tarb'] == 1)
                        {
                                $topic_title .= " <font color=\"#AA5555\">(tarbed topic)</font>" ;
                        }
                }

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/admin/user_edit_body.tpl


#
#-----[ FIND ]------------------------------------------
#
          <td class="row1" colspan="2"><span class="gensmall">{L_SPECIAL_EXPLAIN}</span></td>
        </tr>
        <tr>

#
#-----[ AFTER, ADD ]------------------------------------------
#
          <td class="row1"><span class="gen">{L_USER_TARB}</span></td>
          <td class="row2">
                <input type="radio" name="user_tarb" value="1" {USER_TARB_YES} />
                <span class="gen">{L_YES}</span>&&
                <input type="radio" name="user_tarb" value="0" {USER_TARB_NO} />
                <span class="gen">{L_NO}</span></td>
        </tr>
        <tr>

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM