Mike's Warning System 1.0

Hello all. This is a sort of alternative to g-force2k2's Warnings System Hack. He gets all credit for the idea.

Before anyone starts to accuse me of trying to steal his glory, let me explain. The admin of a well sized board that I super-mod asked me to revise g-force2k2's warning system (it was already installed). I downloaded it, looked through it, and decided that I couldn't: he requested that people respect his hack, and not modify it. So, I didn't, and decided to take a swing at it. Since people don't like change, I made it look the same as the original, but work differently.

Features:

• Expireable warnings. Each warning type has a default length and value. (can turn this off too)
• Warning values can be selected by issuer as per severity of the offense. This can be disabled by the administrator; the default value of warning will be used.
• Warning lengths can be selected by issuer as per severity of the offense. This can be disabled by the administrator; the default length of warning will be used.
• Relatively quick install: a few file mods, template mods, and then running a script.
• Email on warning option (Never, Issuer's choice, Always)
• PM on warning option (Never, Issuer's choice, Always)
• Email on banning option (yes, no)
• Changeable banning threshold
• Which usergroups can warn, which can view the sum, which can view all the warnings
• Mostly template driven
• Add, remove, edit warnings
• Add, remove, edit warning types
• Stronger admin interface.

That's all I can think of now....

Stats:

• Queries added per page: 0
• Queries modified: 3 (indirectly: $templatesused needs to be modified)
• Queries extra per day: 3+ceil(TheNumberOfUsersWithPointsExpiringToday/10)
• Files to modify: 3
• Files to add: 3
• Install time: 10-15 minutes

Stipulations

• Support requests will take a bit (a day or two) to reply due to a somewhat tight schedule.
• Please click Install if you use it
• DO NOT install this if you have g-force2k2's hack in place. USE THE UPGRADE if you have g-force2k2's hack installed

The package is attached. Screenshots are zipped next. Please click install if you use it.

If you are upgrading from g-force2k2's verison, use MWS-Upgrade.txt, and warn-upgrade.php.

[Kaelon]

Thanks, but this option allows users to see all warnings, not just their own. I did fix this manually, however, and people interested in the fix can do the following:

Change line 111 in warn.php to:

		if((!in_array($bbuserinfo['usergroupid'],$canview)) AND ($bbuserinfo['userid'] != $userid)) {

Question -- does anyone know of a modification that will allow "generic" warnings, unrelated to posts? (For example, to assign warning based upon conduct over IMs or IRC?)

[msimplay]

this is one of the hacks that makes me wanna go back to vb2

[Kaelon]

I'm getting the same error that C.Birch described below. Can anyone comment on how this is fixed?

More importantly, I removed the warning that had put someone in banning range, in an attempt to move them away from that usergroup onto a standard usergroup so that I could edit some user details - but I was still getting the error. Any thoughts?

Thanks,
Kaelon

Originally Posted by C.Birch

i get a database error when i try to edit someones usergroup that as been banned by the system, also can it be made so when a warning runs out that puts them back under the banning total there auto unbanned?

the error i get is below btw:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='1983-03-24',options='15',usergroupid='2',username='~*~Vick y_Bob~*~',email='psychadelicwildchild@hotmail.com' ,styleid='1',parentemail='',coppauser=0,homepage=' http://',icq='',aim='',yahoo='',signature='[movel]:angel: See my halo,bright \'n\' shiney,mess wiv me, \'n\' I\'ll kick you\'re hiney :bum:[/movel]
:bum:\"We are the Cheeky Girls-Touch My Bum\":bum:

Bah! As if you\'d wanna touch their asses!
~~~~~~~~~~~~~~~~~~~~~~~~
:wave: To Lil Miss No Pea\'s :augh:[sig=954]

[sig=874]
[movel]:banana: Nev \'n\' Norma,Fab \'n\' groovy,The only narna\'s that can boogie!:banana:[/movel]',adminemail=1,showemail=0,invisible=0,usertitle=' <img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\"> Northern Nutter! <img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\">',customtitle=1,joindate=UNIX_TIMESTAMP(' 2003-05-15 05:32:23'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-11-11 21:44:05'),lastactivity=UNIX_TIMESTAMP('2003-11-11 22:22:48'),lastpost=UNIX_TIMESTAMP('2003-11-11 20:41:05'),posts='4170',timezoneoffset='0',emailno tification=0,receivepm='1',emailonpm='0',ipaddress ='80.194.33.204',pmpopup=IF(pmpopup=2 AND =1,pmpopup,'') WHERE userid=1997
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 '=1,pmpopup,'') WHERE userid=1997' at line 1

mysql error number: 1064

Date: Tuesday 11th of November 2003 10:35:36 PM
Script: http://forums.lisascottlee.com/admin/user.php
Referer:

[Kaelon]

This appears to be a malformed query:

Invalid SQL: UPDATE user SET birthday='1971-05-23',options='15',usergroupid='10',username='Melega unt Tanthul',email='Bevin_van_liempt@hotmail.com',styl eid='0',parentemail='',coppauser=0,homepage='http://s3.invisionfree.com/The_Grand_Realms/',icq='309268104',aim='Whiterose1234321',yahoo='', signature='White pants, white shirt , white gloves, white boots, white hair, and white eyes (glowing). His beloved warlord sword, \"Demonslayer\" is elven steel, white, glittering, and bears the likeness of a whiterose. It\'s sheath is white elven steel. Its hilt is sweat absorbant.',adminemail=1,showemail=1,invisible=0,u sertitle='The Noble Elf of Trelore',customtitle=2,joindate=UNIX_TIMESTAMP('20 03-12-24 03:18:11'),cookieuser=1,nosessionhash=1,daysprune= '1000',lastvisit=UNIX_TIMESTAMP('2004-01-25 20:15:18'),lastactivity=UNIX_TIMESTAMP('2004-01-25 20:43:15'),lastpost=UNIX_TIMESTAMP('2004-01-25 15:22:19'),posts='97',timezoneoffset='-8',emailnotification=0,receivepm='1',emailonpm='1' ,ipaddress='206.116.243.178',pmpopup=IF(pmpopup=2 AND =1,pmpopup,'') WHERE userid=12221
mysql error: You have an error in your SQL syntax near '=1,pmpopup,'') WHERE userid=12221' at line 1

Any thoughts?

[Meirion]

Hi, firstly thanks for these wicked ammendments Mike, that makes a near perfect warnings hack!

However I'm having a few problems after having it installed for a few weeks.

Someone was warned on our forum and recieved 12 points (automatic ban) for a post. However a week later it shows their points has dropped down to 0 and the warning expiry date has set itself to 31/12/1969!?
Their warning list is here... http://www.gurn.net/forums/warn.php?...er&userid=7885
Another mod has since re-added the points to this user.
It is only on people who've received a 12 point automatic-ban that it's happened to. another one - http://www.gurn.net/forums/warn.php?...r&userid=10880

Any ideas?

One thing is that our instant ban (12 points) warning we set an expiry date of 99999 days - because "-1" was confusing people. I noticed this had changed to 32767, presumablably because of the column size in mySQL, so I changed them to 9999 days.

Additional features...
would it be possible to make the 'View Warnings' list in the admin section be sortable by the column headings? In-particular by date.

automatically CC another email address every time a warnings email is sent to a board member?

[Barto]

I have the same problem whit the version 2.3.4.
Please help me.

I get a database error when i try to edit someones usergroup that as been banned by the system, also can it be made so when a warning runs out that puts them back under the banning total there auto unbanned?

the error i get is below btw:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='1983-03-24',options='15',usergroupid='2',username='~*~Vick y_Bob~*~',email='psychadelicwi ldchild@hotmail.com',styleid='1',parentemail='',coppauser=0,homepage= 'http://',icq='',aim='',yahoo='',signature='[movel]:angel: See my halo,bright \'n\' shiney,mess wiv me, \'n\' I\'ll kick you\'re hiney :bum:[/movel]
:bum:\"We are the Cheeky Girls-Touch My Bum\":bum:

Bah! As if you\'d wanna touch their asses!
~~~~~~~~~~~~~~~~~~~~~~~~
:wave: To Lil Miss No Pea\'s :augh:[sig=954]

[sig=874]
[movel] Nev \'n\' Norma,Fab \'n\' groovy,The only narna\'s that can boogie![/movel]',adminemail=1,showemail=0,invisible=0,usertitle=' <img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\"> Northern Nutter! <img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\">',customtitle=1,joindate=UNIX_TIMESTAMP(' 2003-05-15 05:32:23'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-11-11 21:44:05'),lastactivity=UNIX_TIMESTAMP('2003-11-11 22:22:48'),lastpost=UNIX_TIMESTAMP('2003-11-11 20:41:05'),posts='4170',timezoneoffset='0',emailno tification=0,receivepm='1',ema ilonpm='0',ipaddress='80.194.33.204',pmpopup=IF(pm popup=2 AND =1,pmpopup,'') WHERE userid=1997
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 '=1,pmpopup,'') WHERE userid=1997' at line 1

mysql error number: 1064

Date: Tuesday 11th of November 2003 10:35:36 PM
Script: http://forums.lisascottlee.com/admin/user.php
Referer:

[Meirion]

I forgot to mention, I am using VB version 2.3.2

[Barto]

Someone to help us?????

[Barto]

Up

Please it's important

[Meirion]

The Author agreed to give support for this hack!

C'mon Mike!