View Full Version : Ban Ignored/Specified Users from Replying v2.0
magnus
01-27-2004, 10:00 PM
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! (https://vborg.vbsupport.ru/showpost.php?p=484715&postcount=50)
Planned Features
v3.0
- Who knows? You tell me. :)
If you use this, please click https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=60844)
eXtremeTim
01-28-2004, 12:07 AM
This hack sounds wicked. I will install it shortly.
NTLDR
01-28-2004, 12:44 AM
Please include the Text instructions for non-HTL installs as per vB.org's rules, otherwise your hack will have to be removed.
Thanks.
Merjawy
01-28-2004, 02:31 AM
Please include the Text instructions for non-HTL installs as per vB.org's rules, otherwise your hack will have to be removed.
Thanks.
newbie question :) what does HTL stand for?
oops.. I read the book :)
I just found out what I needed to know :)
Sadie Frost
01-28-2004, 07:15 AM
It's KuraFire's Hack Tracking Log hack :) Kind of like vbhacker, but not :D
LeeCHeSSS
01-28-2004, 08:14 AM
Is this similar to the thread banning hack made by John for vB2 (https://vborg.vbsupport.ru/showpost.php?p=370828&postcount=1) ?
magnus
01-28-2004, 10:02 AM
Is this similar to the thread banning hack made by John for vB2 (https://vborg.vbsupport.ru/showpost.php?p=370828&postcount=1) ?
Hrm, I've never seen that one before. It's similar in the fact that there is banning, but with that one it's an administrative option. With mine, it's at the original thread author's discretion as to who shouldn't be allowed to reply.
For instance, if I have a problem with {user x} who is always trolling my threads and flamebaiting me, I can put {user x} in the "Banned Posters" field when I create my thread, and he will be unable to reply.
This is purely at a user level, not administrative.
magnus
01-28-2004, 11:16 AM
Quick edit for aesthetic purposes:
In newthread template,
Find:
$vbphrase[banned_users_desc]
Replace with:
$vbphrase[banned_users_desc]<br />
This has been updated in the zip file, so this is only necessary for previous installations. Nothing else has changed.
FleaBag
01-28-2004, 11:19 AM
Looks good - will probably use. Cheers. :)
magnus
01-28-2004, 05:43 PM
Version 1.01 Upgrade Instructions:
File: postings.php
Find:
$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread SET
visible = $visible,
open = $open,
sticky = $sticky ,
title = '" . addslashes(htmlspecialchars_uni($title)) . "',
iconid = $iconid,
notes = '" . addslashes($notes) . "'
WHERE threadid = $threadid
");
Replace with:
$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread SET
visible = $visible,
open = $open,
sticky = $sticky ,
title = '" . addslashes(htmlspecialchars_uni($title)) . "',
iconid = $iconid,
notes = '" . addslashes($notes) . "',
bannedposters = '" . addslashes($bannedposters) ."'
WHERE threadid = $threadid
");
File: postings.php
Find:
'title' => STR
Replace with:
'title' => STR,
'bannedposters' => STR
Template: threadadmin_editthread
Find:
<div class="fieldset">
$vbphrase[moderator_notes] / $vbphrase[thread_summary]:<br />
<input type="text" class="bginput" name="notes" value="$threadinfo[notes]" size="50" maxlength="250" />
</div>
Below, add:
<div class="fieldset">
$vbphrase[banned_users]:<br />
<input type="text" class="bginput" name="bannedposters" value="$threadinfo[bannedposters]" size="50" maxlength="250" />
</div>
Allan
01-29-2004, 01:07 PM
After this :
################################################## ############
ALTER TABLE " . TABLE_PREFIX . "thread ADD bannedposters VARCHAR( 250 ) NOT NULL ;
################################################## ############
this sql error
requ?te SQL :
ALTER TABLE " . TABLE_PREFIX . "thread ADD bannedposters VARCHAR( 250 ) NOT NULL
MySQL a r?pondu:
#1064 - Erreur de syntaxe pr?s de '" . TABLE_PREFIX . "thread ADD bannedposters VARCHAR( 250 ) NO' ? la ligne 1
[Documentation] ? [Retour]
an idea (on RC3) ?
bluecat
01-29-2004, 03:52 PM
Is it possible that only certain usergroups (who I specify) can use the hack?
magnus
01-29-2004, 07:52 PM
After this :
################################################## ############
ALTER TABLE " . TABLE_PREFIX . "thread ADD bannedposters VARCHAR( 250 ) NOT NULL ;
################################################## ############
this sql error
requ?te SQL :
ALTER TABLE " . TABLE_PREFIX . "thread ADD bannedposters VARCHAR( 250 ) NOT NULL
MySQL a r?pondu:
#1064 - Erreur de syntaxe pr?s de '" . TABLE_PREFIX . "thread ADD bannedposters VARCHAR( 250 ) NO' ? la ligne 1
[Documentation] ? [Retour]
an idea (on RC3) ?
Hrm, are you including the ";" at the end? There's no reason for that query not to work, you can try removing the " . TABLE_PREFIX ." portion (provided you don't actually use a table prefix).
magnus
01-29-2004, 07:54 PM
Is it possible that only certain usergroups (who I specify) can use the hack?
Sure, encompass the template edits with:
<if condition="$bbuserinfo[usergroupid]==XX">
<!-- TEMPLATE, BLAH CRAP... -->
</if>
Of course, replace "XX" with the usergroup you wish to allow.
Allan
01-30-2004, 06:10 AM
Hrm, are you including the ";" at the end? There's no reason for that query not to work, you can try removing the " . TABLE_PREFIX ." portion (provided you don't actually use a table prefix).
idem :(
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "thread ADD bannedposters VARCHAR( 250 ) NO' ? la ligne 1
on a RC3 coldly to install :surprised:
Allan
01-30-2004, 08:36 AM
idem :(
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "thread ADD bannedposters VARCHAR( 250 ) NO' ? la ligne 1
on a RC3 coldly to install :surprised:
veiled the solution :)
ALTER TABLE thread ADD bannedposters VARCHAR( 250 ) NOT NULL ;
thank at Pithchoume ;)
magnus
01-30-2004, 11:17 AM
Hrm, are you including the ";" at the end? There's no reason for that query not to work, you can try removing the " . TABLE_PREFIX ." portion (provided you don't actually use a table prefix).
veiled the solution :)
ALTER TABLE thread ADD bannedposters VARCHAR( 250 ) NOT NULL ;
thank at Pithchoume ;)
That's what I said to do, heh. Seems RC3 doesn't like " . TABLE_PREFIX . " .. odd.
magnus
01-30-2004, 09:47 PM
BUGFIX!
With the existing preg_split() statement, users with spaces in their name could cause problems for other users which share a common world. For example, if the user "BIG BAD GUY" is banned from a thread, inherently the user "BIG BOY" would be banned because of the shared word, "BIG". With the following fix, that will be fixed:
In newreply.php:
Find: ** NOTE, THERE ARE TWO INSTANCES OF THIS, REPLACE BOTH! **
$usernames = preg_split('/( )+/', trim(strtolower($threadinfo['bannedposters'])), -1, PREG_SPLIT_NO_EMPTY);
Replace with:
$usernames = preg_split('/,+/', trim(strtolower($threadinfo['bannedposters'])), -1, PREG_SPLIT_NO_EMPTY);
The only drawback to this fix, is now users are comma delimited instead of space. So, you'll need to update the phrase (bannd_users_desc) to reflect this, personally, I use List of users, separated by commas, who cannot reply to this thread. (ie. user1,user2).
This has been updated in the attachment in the first post, only existing users need to concern themselves with this.
Allan
01-31-2004, 02:45 PM
I have to install 2 times the hack, I have a sql error when I click on the button "newthread", I specify that I am in rc3, year idea on the problem?
Error Sql:
There seems to have been a slight problem with the Local Rc3 database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience
another thing about the bugfix, this line does not exist in the RC3 In "newthread.php":
$usernames = preg_split('/( )+/', trim(strtolower($threadinfo['bannedposters'])), -1, PREG_SPLIT_NO_EMPTY);
magnus
01-31-2004, 04:47 PM
another thing about the bugfix, this line does not exist in the RC3 In "newthread.php":
$usernames = preg_split('/( )+/', trim(strtolower($threadinfo['bannedposters'])), -1, PREG_SPLIT_NO_EMPTY);
Yikes! I meant newreply.php, sorry for the confusion. I fixed that in the post above.
As for the other problem, you'll need to show me the error. View the source of the HTML page when that error is generated, and post it here.
msimplay
02-01-2004, 11:50 PM
can this be turned on and off via usergroups ?
magnus
02-02-2004, 02:21 PM
can this be turned on and off via usergroups ?
Sure, encompass the template edits with:
<if condition="$bbuserinfo[usergroupid]==XX">
<!-- TEMPLATE, BLAH CRAP... -->
</if>
Of course, replace "XX" with the usergroup you wish to allow.
Allan
02-02-2004, 03:25 PM
I took again your txt file, to install and I have always the same problems sql as front
here, the erruer that I have when I click on the button "nexthread"
There seems to have been a slight problem with the Local RC3 database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
I will like that you installs your hack well while following your txt file on a version rod of all hack and in RC3 Please :devious:
magnus
02-02-2004, 03:29 PM
I took again your txt file, to install and I have always the same problems sql as front
here, the erruer that I have when I click on the button "nexthread"
There seems to have been a slight problem with the Local RC3 database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
I will like that you installs your hack well while following your txt file on a version rod of all hack and in RC3 Please :devious:
That error doesn't tell me anything, unfortunately. When you get that error, right click and select View Source. The actual error should be in the source, if you could post that here I could fix it.
Or, give me a link to your site so I can see for myself. I'm sure this is a very simple fix. ;)
Allan
02-02-2004, 03:44 PM
yes, here the sql error:
Database error in vBulletin 3.0.0 Release Candidate 3:
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_postingbans AS phrasegroup_postingbans,
language.phrasegroup_posting AS phrasegroup_posting,
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
after many test, I am realized that that comes from the moment or I replace this:
// get special phrase groups
$phrasegroups = array('threadmanage', 'posting', 'postingbans');
in the "newthread.php" file
magnus
02-02-2004, 05:52 PM
Man, life would be so much easier if I understood French.. in any event, run the following SQL query:
SELECT * FROM `phrasetype` WHERE fieldname = 'postingbans';
It should return the "User-Defined Posting Bans" phrasetype entry. If not, you skipped this step in the instructions:
INSERT INTO `phrasetype` VALUES (152, 'postingbans', 'User-Defined Posting Bans', 3);
Catch-22|BL
02-16-2004, 06:34 AM
[Expired--removed to avoid confusion]
magnus
02-16-2004, 12:02 PM
That sounds like a Hack Tracking Log error, actually. Have you been able/tried to install other HTL hacks?
Catch-22|BL
02-16-2004, 12:57 PM
[expired--removed to avoid confusion]
magnus
02-16-2004, 04:29 PM
Hrm, the only variable here is that you're running RC4. I developed that hack on RC2, although that should be irrelevant. I just finished upgrading to RC4 about 15 minutes ago, so I'll know for sure soon since I have to re-hack everything.
Catch-22|BL
02-16-2004, 10:28 PM
Take your time and thanks for your efforts.
If nothing else, I can wait to see someone else with RC4 give it a try. :)
Allan
02-17-2004, 06:57 AM
Take your time and thanks for your efforts.
If nothing else, I can wait to see someone else with RC4 give it a try. :)
I am on RC4!
It misses a sentence one would say (see screen) another thing, at the time of the edition of a station or the user was banished, one cannot nothing to modify (screen2)
magnus
02-17-2004, 09:37 AM
I am on RC4!
It misses a sentence one would say (see screen) another thing, at the time of the edition of a station or the user was banished, one cannot nothing to modify (screen2)
You're missing a sentence because either a phrase is missing, more specifically:
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);
or you forgot to add 'postingbans' to the $phrasegroup variable in newthread.php.
Also, you cannot modify the banned users by simply editing the first post -- you must edit the thread itself via "Thread Tools" -> "Edit Thread".
Allan
02-17-2004, 10:04 AM
not, I have to check I have to add this request sql well
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);
indeed, I had to forget to add:
'postingbans'
veiled, after addition of that, I obtains this when I click on "newthread":
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
AND, you known as to find this:
'title' => STR
But there are 2 text of this: ligne 472 and ligne 987, is it necessary to make the changes 2 times or right at the first ?
magnus
02-17-2004, 04:40 PM
Database error in vBulletin 3.0.0 Release Candidate 4:
mysql error: Champ 'language.phrasegroup_postingbans' inconnu dans field list
You didn't run all the queries in the .txt file, you need to run:
INSERT INTO `phrasetype` VALUES (152, 'postingbans', 'User-Defined Posting Bans', 3);
AND, you known as to find this:
'title' => STR
But there are 2 text of this: ligne 472 and ligne 987, is it necessary to make the changes 2 times or right at the first ?
Search for:
'reason' => STR,
'title' => STR
Replace with:
'reason' => STR,
'title' => STR,
'bannedposters' => STR
Allan
02-17-2004, 05:57 PM
You didn't run all the queries in the .txt file, you need to run:
INSERT INTO `phrasetype` VALUES (152, 'postingbans', 'User-Defined Posting Bans', 3);
Search for:
'reason' => STR,
'title' => STR
Replace with:
'reason' => STR,
'title' => STR,
'bannedposters' => STR
I remake the installation supplements 2 times, while checking well to have executer all the requests on virgin Rc4 of hack and your hack does not function, I always have same error SQL.
Then, please, take your txt file, to install Rc4 new locally and known as moa if you arrived has to make it function bus me, I do not arrive there !
magnus
02-17-2004, 06:51 PM
I remake the installation supplements 2 times, while checking well to have executer all the requests on virgin Rc4 of hack and your hack does not function, I always have same error SQL.
Then, please, take your txt file, to install Rc4 new locally and known as moa if you arrived has to make it function bus me, I do not arrive there !
I just installed this on my recently upgraded RC4 install, in fact, I was so confident I did it on my live forum. I followed my instructions, step-by-step, and it works flawlessly.
I would be glad to help you fix this, if you'd like. I'm sure it's a simple mistake. Could you create a temporary login/pass so I could check the edited files?
Allan
02-17-2004, 08:12 PM
I just installed this on my recently upgraded RC4 install, in fact, I was so confident I did it on my live forum. I followed my instructions, step-by-step, and it works flawlessly.
I would be glad to help you fix this, if you'd like. I'm sure it's a simple mistake. Could you create a temporary login/pass so I could check the edited files?
the problem, I work locally for the moment, I waits left the version Gold de Vbulletin :)
I will test once again because the doubt takes to me, thank you has you to grant your time to me, I appreciate Socrate friendship :)
Allan
02-17-2004, 08:55 PM
I see that you have to modify your joined file, you should still checking it because the request which follows does not exist, this:
// get special phrase groups
$phrasegroups = array('threadmanage');
does not exist in the template "newthread.php" :rolleyes:
your texte :
*** File: newthread.php
Find:
################################################## ############
// get special phrase groups
$phrasegroups = array('threadmanage');
################################################## ############
Replace with:
################################################## ############
// get special phrase groups
$phrasegroups = array('threadmanage', 'postingbans');
################################################## ############
magnus
02-17-2004, 11:23 PM
I see that you have to modify your joined file, you should still checking it because the request which follows does not exist, this:
// get special phrase groups
$phrasegroups = array('threadmanage');
does not exist in the template "newthread.php" :rolleyes:
your texte :
*** File: newthread.php
Find:
################################################## ############
// get special phrase groups
$phrasegroups = array('threadmanage');
################################################## ############
Replace with:
################################################## ############
// get special phrase groups
$phrasegroups = array('threadmanage', 'postingbans');
################################################## ############
Man, I need to stop drinking early in the afternoon. Yes, I modified the file earlier. That should be 'postings.php' -- not 'newthread.php'. It's fixed now. The added line, however, has no effect on functionality. It simply allows phrases to be used when editing the thread via Thread Tools.
Allan
02-18-2004, 05:13 AM
veiled, always similar, to install on a virgin rc4 and always the same error, to afflict :ermm:
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
02-18-2004, 10:06 AM
Socrate, do me a favor. Run this query:
SELECT * FROM `phrasetype` WHERE phrasetypeid=152;
Tell me what it returns, I have a sneaking feeling this is the culprit..
Allan
02-18-2004, 11:18 AM
Socrate, do me a favor. Run this query:
SELECT * FROM `phrasetype` WHERE phrasetypeid=152;
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:
'postingbans'
to
// 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
02-18-2004, 12:28 PM
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:
INSERT INTO `phrasetype` VALUES (152, 'postingbans', 'User-Defined Posting Bans', 3);
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
02-18-2004, 12:37 PM
not, I do not employ a table prefixed
the request mentions above passed well, it are similar :(
Allan
02-23-2004, 01:10 AM
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
02-24-2004, 11:11 AM
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
03-06-2004, 11:50 PM
Socrate, it just dawned on me what the problem was.
Run this query:
ALTER TABLE `language` ADD `phrasegroup_postingbans` MEDIUMINT NOT NULL;
That will fix your problem. I've gone ahead and updated the .TXT file.
Allan
03-07-2004, 07:29 AM
Socrate, it just dawned on me what the problem was.
Run this query:
ALTER TABLE `language` ADD `phrasegroup_postingbans` MEDIUMINT NOT NULL;
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 :
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
03-12-2004, 05:01 PM
UPGRADE FROM 1.0 INSTRUCTIONS
In NEWTHREAD.PHP:
Find:
$posticons = construct_icons(intval($newpost['iconid']), $foruminfo['allowicons']);
Add BELOW:
// 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>
Dark Shogun
03-22-2004, 02:16 PM
When I was trying to install this the installer kept saying that the tables and rows already there. I checked but I saw the first parts but not the VALUES parts. Now on when you make a thread the part where you choose who can't see the thread doesn't have any text.
Dark Shogun
Dark Shogun
03-26-2004, 09:45 AM
Anyone still supporting this hack?
Dark Shogun
magnus
04-07-2004, 02:15 AM
Anyone still supporting this hack?
Dark Shogun
Yikes! I'm sorry for the incredibly late reply, but for some reason I wasn't getting e-mail updates on this thread!
As for the text not showing up, go to your Phrases Manager, and select "edit" on any random phrase. Then, click "save". You don't actually have to make any changes, but for some reason this sort of "re-synchs" the database.
SternFan
04-13-2004, 04:48 PM
When I run the following:
SELECT * FROM `phrasetype` WHERE phrasetypeid=152;
I get the shoutbox hack that I installed.
When I run this one:
SELECT * FROM `phrasetype` WHERE phrasetypeid=153;
I get no queries. Is it possible for me to put it at location 153 without affecting the hack?
magnus
04-14-2004, 12:39 PM
When I run the following:
SELECT * FROM `phrasetype` WHERE phrasetypeid=152;
I get the shoutbox hack that I installed.
When I run this one:
SELECT * FROM `phrasetype` WHERE phrasetypeid=153;
I get no queries. Is it possible for me to put it at location 153 without affecting the hack?
Yes. In fact, I went ahead and removed the added phrasegroup altogether now. You can simply insert the phrases into the GLOBAL phrasegroup instead.
Catch-22|BL
04-15-2004, 06:16 AM
Okay, thanks! v1.2 is now successfully running. It worked fine without all the HTL business.
The only problem (and it might be my fault) is that the box where people input the list in newthread is not explained (see attached). If it is my problem, feel free to tell me to bug off....but if I am the first person to install since v1.2, then I want to report this potential issue just to be fair. Either way, nice work and thanks for the effort.
magnus
04-15-2004, 08:24 PM
Okay, thanks! v1.2 is now successfully running. It worked fine without all the HTL business.
The only problem (and it might be my fault) is that the box where people input the list in newthread is not explained (see attached). If it is my problem, feel free to tell me to bug off....but if I am the first person to install since v1.2, then I want to report this potential issue just to be fair. Either way, nice work and thanks for the effort.
When did you install? If it was in the past day, chances are you need to go to the Phrase Manager in AdminCP. Then, select any random phrase, click Edit, then click Save. You don't need to make any changes, this just synchronizes the Phrase database.
That should do it for you. Let me know. :)
Catch-22|BL
04-16-2004, 04:04 AM
That solved the issue. Thank you!
Anon47
10-05-2005, 10:05 PM
Not sure if this hack is still being supported, but I'm having a hard time getting it to work. Mainly, ignored users can still post in threads that they shouldn't be able to.
SternFan
11-05-2005, 06:58 AM
Just wondering if someone was thinking about porting this to version 3.5 If not I might take a crack at it :nervous:
Thanks....
home9000
11-04-2008, 11:42 AM
is it workink in 3.6.X
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.