vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/showthread.php?t=71992)

sv1cec 11-29-2004 08:08 AM

Folks,

A few words about Version 2.0, to open your appetite.

As it is running on my forums now, it is catching words, which are in the censored words list of vBulletin, and it issues automatic warnings to the poster. The censored words are trapped in the following instances:

1. When you create a new thread.
2. When you reply to a post in a thread.
3. When you edit a post you have submitted before.
4. When you send a Private Message.

This is done for both the titles and the text of the posts.

All this is fine and nice, but there are some issues. For example, let's suppose you implement that system and a member posts some nusty words in one of his posts. The warning is issued, however, the original text, before being censored is nowhere to be found, vBulletin does not store it. It just replaces the letters in the bad words with a predefined character, so you end up with a post like "You are an *******". So? If the poster protests, how do you prove him he has actually typed a censored word?

The things get worst in Private Messages. The PMs are stored in the database, and the admin can read them, but again, they are stored with *****. Now, if it's not easy to tell a member that he was warned because he posted a public post, with obsceneties, how will you convince him that his PM (which goes from one member to the other) was obscene?

So, I am thinking if this feature should be released at all. I can always add one option for post-related automatic warnings, and another for PM-related ones, so the admin can select which one he would implement. Would that be satisfactory?

Also shall I add this automatic warning thing, in e-mails (the Contact Us form)?

Your opinion will be greatly appreciated, so please do not hesitate to comment.

As for the suggestion to warn users who post in old threads, I think this is a ... whole project by itself. My original idea, was that an admin would be able to select from a list of automatic warnings, which one he want to use. However, the changes required in the code, make such an effort totally impossible. Imagine that different code is required to trap the censored words in the edit post, than in the new post and totally different in the PM. So, I guess this is not something you will see in the immediate future.

However, keep those ideas coming, something good (and relatively easy) could come up.

And now the funny thing, yesterday evening my system warned several members of my forum, with no reason. Why? Because in the code, the routine which traps the censored words, is sometimes combined with other routines. In my infinite wisdom, when I was comparing the original message with the final one, I didn't do that at the censor routine only, so almost all the PMs that were send last night, got a warning. Say frustrated users again??? LoL

I am listening folks, keep those ideas coming.

----------

John

ptenthus 11-29-2004 12:44 PM

Quote:

Originally Posted by sv1cec
Show me that area of the file, there is no ']' in that line. Show me a few lines before and a few after. Maybe you erased something more than just the quotes.

Rgds

Doh, never mind...found the problem. the " should be not removed, but moved to the end of the line just before the ; (second install[] line)...

Now it runs just fine.

Was:
PHP Code:

$install[]="alter table ".TABLE_PREFIX."warnings
add `warned_status` char(1), add `removed_by` int(15), add `removed_date` int(15)"
;

 
$install[]="alter table ".TABLE_PREFIX."user add `warning_bans` int(2), add `warnings` int(5);

$install[]="alter table ".TABLE_PREFIX."warning_types add `warn_maturityint(5), add `warn_permbanchar(3), add `warn_typechar(3)"; 

Second line should be:

PHP Code:

 $install[]="alter table ".TABLE_PREFIX."user add `warning_bans` int(2), add `warnings` int(5)"


sv1cec 11-29-2004 02:16 PM

Quote:

Originally Posted by ptenthus
Doh, never mind...found the problem. the " should be not removed, but moved to the end of the line just before the ; (second install[] line)...

Now it runs just fine.

Was:
PHP Code:

$install[]="alter table ".TABLE_PREFIX."warnings
add `warned_status` char(1), add `removed_by` int(15), add `removed_date` int(15)"
;

 
$install[]="alter table ".TABLE_PREFIX."user add `warning_bans` int(2), add `warnings` int(5);

$install[]="alter table ".TABLE_PREFIX."warning_types add `warn_maturityint(5), add `warn_permbanchar(3), add `warn_typechar(3)"; 

Second line should be:

PHP Code:

 $install[]="alter table ".TABLE_PREFIX."user add `warning_bans` int(2), add `warnings` int(5)"


Glad you have it working.

Rgds

Torqued 11-29-2004 06:18 PM

Quote:

Originally Posted by sv1cec
Oooops,

This thing is getting too complicated. It's impossible to test every combination!!


Sorry!!!

:) That fixed it. Thanks!

It's not impossible to test all combinations, it's just tedious. Thanks again for your work on this!

Shack Networks 11-30-2004 10:02 AM

Lo M8

First of all thanks for the response, A lesser man would of told me to shut up lol

Anyhow

I dont think PM should be included in the warning system as TBH what people do between themselves is non of my concern as if it does get out of hand I am sure the person on the recieving end would make a complaint.

As for the open forums, that is the bit I would want to concentrate on as in the past people have found it fun to post links to sites that do nothing more than add hundreds of pops up boxes etc, and no matter how many times you tell them to use a pop up blocker none of them actualy listen lol

I also want to use it to filter out links to sites containing Warez or serials and keygens etc so that they can not post links to them and if they do so they will receive a warning. I am sure my site is not the first or the last to be plagued by this problem and in the past I have seen several hosting companys take sites down as the staff have failed to spot links to warez etc.

Like you said when it comes to PM's it is very dodgy ground as the very description of the system contains the word PRIVATE and thats how I think they should remain.

Thanks for all the hard work you have put in on this and I am only to greatfull of anything that helps to make this hack better than it already is.

Small Ideas make Big Hacks.

rh2004 11-30-2004 07:33 PM

Hello, I receive this error when I click confirm of warning a user, it does
warn and email out the user I just seem to get this for some reason the Warn.php file is in place and all the others any ideas what it is... It is a
brand new board...

Code:

Database error in vBulletin 3.0.3:

Invalid SQL:
                            INSERT INTO userban
                            (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate)
                            VALUES
                            (1260, 7, 0, 0, '', 1, 1101849704, 1102454504)
                            // (1260, 7, 0, 0, '', 1, 1101849704, 1102454504)
                       
mysql error: 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 '// (1260, 7, 0, 0, '', 1, 1101849704, 1102454504)' at line 5

mysql error number: 1064

Date: Tuesday 30th of November 2004 04:21:44 PM
Script: http://www.domain.com/community/Warn.php
Referer: http://www.domain.com/community/Warn.php?do=WarnUser&id=1260&post=88319
Username: admin
IP Address: --


chris2707 11-30-2004 07:41 PM

Since the error is caused by a duplicated section that's been commented out, I'd just delete this:

// (1260, 7, 0, 0, '', 1, 1101849704, 1102454504)

rh2004 11-30-2004 09:46 PM

How do I delete that .... :squareeyed:

sv1cec 12-01-2004 04:14 AM

Quote:

Originally Posted by rh2004
How do I delete that .... :squareeyed:

Find that query in the Warn.php file and replace the whole thing with :

PHP Code:

                $DB_site->query("
                    INSERT INTO " 
TABLE_PREFIX "userban
                    (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate)
                    VALUES
                    (
$user[userid]$group$user[displaygroupid]$user[customtitle], '" addslashes($user['usertitle']) . "', $bbuserinfo[userid], " TIMENOW ", $liftdate)"); 

If you do not know how to delete the commented part, just download the new zip file and upload the Warn.php file.

Guys, I still do not receive e-mail from this thread. What's wrong here?

Rgds

rh2004 12-01-2004 08:52 AM

Thanks for the above it worked code change :)

Can smeone tell me how I add this to satellite template which I brought because in
the templates theme I can't find any of the text where I need to add this new text after....


All times are GMT. The time now is 01:57 PM.

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.01930 seconds
  • Memory Usage 1,775KB
  • 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
  • (5)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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