Ban Ignored/Specified Users from Replying v2.0

Ban Ignored/Specified Users from Replying v2.0

Description
This hack will prevent ignored users from replying to your threads, as well as give you the option to ban additional users without adding them to your ignore list.

Information
This hack was previously titled "User-Defined Posting Bans (Ban specified users from replying)"

Tested on RC4, should work on RC1+

Version History
v1.0 - Initial Release
v2.0 - Added auto-ban of ignored users, created installer script for convenience

Click here for upgrade instructions from 1.0!

Planned Features
v3.0
- Who knows? You tell me.

If you use this, please click

[Allan]

veiled, always similar, to install on a virgin rc4 and always the same error, to afflict :ermm:

PHP Code:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: 
        SELECT 
        userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
            language.phrasegroup_threadmanage AS phrasegroup_threadmanage,
            language.phrasegroup_posting AS phrasegroup_posting,
            language.phrasegroup_postingbans AS phrasegroup_postingbans,
            language.phrasegroup_global AS phrasegroup_global,
            language.options AS lang_options,
            language.languagecode AS lang_code,
            language.charset AS lang_charset,
            language.locale AS lang_locale,
            language.imagesoverride AS lang_imagesoverride,
            language.dateoverride AS lang_dateoverride,
            language.timeoverride AS lang_timeoverride,
            language.registereddateoverride AS lang_registereddateoverride,
            language.calformat1override AS lang_calformat1override,
            language.calformat2override AS lang_calformat2override,
            language.logdateoverride AS lang_logdateoverride,
            language.decimalsep AS lang_decimalsep,
            language.thousandsep AS lang_thousandsep
        FROM user AS user
        INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
        INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
        WHERE user.userid = 1
    
mysql error: Champ 'language.phrasegroup_postingbans' inconnu dans field list

mysql error number: 1054

Date: Wednesday 18th of February 2004 08:12:40 AM 


I will like that somebody of other tests it because, I have to install it almost 10 times and I ever succeeded has to make it function ! :tired:

[magnus]

Socrate, do me a favor. Run this query:

[SQL]
SELECT * FROM `phrasetype` WHERE phrasetypeid=152;
[/SQL]

Tell me what it returns, I have a sneaking feeling this is the culprit..

[Allan]

Originally Posted by magnus

Socrate, do me a favor. Run this query:

[SQL]
SELECT * FROM `phrasetype` WHERE phrasetypeid=152;
[/SQL]

Tell me what it returns, I have a sneaking feeling this is the culprit..

veiled, I have executer this request, to install without problem, but the result is the same one, error SQL

Another thing, I have to try to reinstall your hack this morning with the job, even sql error However, if one removes:

PHP Code:

'postingbans' 


to

PHP Code:

// get special phrase groups
$phrasegroups = array('threadmanage', 'posting', 'postingbans'); 


the hack functions put well has share the lack of text has this level (see screen)

[magnus]

Ok, obviously the problem is you haven't created the phrasegroup 'postingbans'. That's what all these errors are telling you.

This SQL query is the one that adds that:
[SQL]INSERT INTO `phrasetype` VALUES (152, 'postingbans', 'User-Defined Posting Bans', 3);[/SQL]

Are you using a prefix for your tables? If so, you may need to adjust the queries. I don't use additional languages on my forum, so I'm not sure if you need to include the "language.*" prefix.

In any event, this is undoubtedly your problem, as I stated before.

[Allan]

not, I do not employ a table prefixed

the request mentions above passed well, it are similar

[Allan]

I have to ask has a friend to test your hack, it also has the same problem as me to know the error sql, I am to afflict, but the hack does not function

[magnus]

Wait, are you asking me to have a friend install the hack? Or, are you telling me that you had a friend install the hack?

In any event, there's not really much more I can do to help unless you can create a temporary account on your system so I can check everything for myself. I'm 99.9% sure it's something simple, SQL related. I've installed this on 3 RC4 forums, and it worked fine.

[magnus]

Socrate, it just dawned on me what the problem was.

Run this query:
[SQL]
ALTER TABLE `language` ADD `phrasegroup_postingbans` MEDIUMINT NOT NULL;
[/SQL]

That will fix your problem. I've gone ahead and updated the .TXT file.

[Allan]

Originally Posted by magnus

Socrate, it just dawned on me what the problem was.

Run this query:
[SQL]
ALTER TABLE `language` ADD `phrasegroup_postingbans` MEDIUMINT NOT NULL;
[/SQL]

That will fix your problem. I've gone ahead and updated the .TXT file.

good, that still does not go (see screen1), the text does not appear.

I have thus to add the sentences in ACP STATE manually (via manager language, screen2) and the text appears (your requests sql for the addition of the sentences does not function apparement)

==================================================

a council, to remove these 4 requests :

PHP Code:

INSERT INTO `phrasetype` VALUES (152, 'postingbans', 'User-Defined Posting Bans', 3);

INSERT INTO `phrase` VALUES (17188, 0, 'banned_users', 'Banned Users', 152);

INSERT INTO `phrase` VALUES (17189, 0, 'banned_users_desc', 'List of users, separated by commas,  who cannot reply to this thread. (ie. user1,user2)', 152);

INSERT INTO `phrase` VALUES (17190, 0, 'banned_from_posting', 'You have been prohibited by the thread author from posting in this thread!', 1000); 


who seems to pose problems, and to replace them by manual installation of the sentences in the ACP

[magnus]

UPGRADE FROM 1.0 INSTRUCTIONS

In NEWTHREAD.PHP:

Find:

PHP Code:

    $posticons = construct_icons(intval($newpost['iconid']), $foruminfo['allowicons']); 


Add BELOW:

PHP Code:

    // get ignore ids
    if ($bbuserinfo['ignorelist'])
    {
        $ignore_ids = explode(' ', trim($bbuserinfo['ignorelist']));
    }
    else
    {
    $ignore_ids = array();
    }

    $listusers = array();
    if (!empty($ignore_ids))
    {
        $users = $DB_site->query("
            SELECT userid, username FROM " . TABLE_PREFIX . "user
            WHERE userid IN (" . implode(',', $ignore_ids) . ")
            ORDER BY username
        ");
        while ($userinfo = $DB_site->fetch_array($users))
        {
            if ($userinfo['userid'] != 0)
            {
                if (in_array($userinfo['userid'], $ignore_ids))
                {
                    $listusers['ignore']["$userinfo[userid]"] = $userinfo['username'];
                }
            }
        }
    }

    $ignore_listbits = '';
    if (!empty($listusers['ignore']))
    {
        $_usercount = 0;
        foreach ($listusers['ignore'] AS $userid => $username)
        {
            $_usercount++;
            if ($_usercount > 1)
            {
                eval('$ignore_listbits .= ",$username";');
            } 
            else
            {
                eval('$ignore_listbits .= "$username";');
                }                
        }
    } 


In (template) NEWTHREAD:

Find:

					<input type="text" class="bginput" size="25" name="bannedposters" id="$bannedposters" tabindex="1" /></label></div>

REPLACE with:

					<input type="text" class="bginput" size="25" name="bannedposters" id="$bannedposters" value="$ignore_listbits" tabindex="1" /></label></div>