Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Advanced Warning System 3.6.7 Details »
Advanced Warning System 3.6.7
Mod Version: 3.6.9(C), by Delphiprogrammi (Member) Delphiprogrammi is offline
Developer Last Online: Aug 2015 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.8 Rating: (8 votes - 4.25 average) Installs: 210
Released: 20 Aug 2006 Last Update: 03 Oct 2007 Downloads: 2114
Not Supported DB Changes Uses Plugins Template Edits Code Changes Additional Files Is in Beta Stage  

Advaned Warning System

This is a port of aws and i release this with permission...(yes i did ask the original author)

This version of the warning includes
  • 1 vbulletin 3.6.x product file (XML)
  • 1 admincp navigation XML
  • 1 functions file(functions_warning.php)
  • 3 images
  • 3 cronjobs
  • 1 modcp file to allow moderators to view warnings information without having to give admincp access(mod_warn.php)
  • 1 admincp file to manage the system options(admin_warn.php)
  • 1 XML to control permissions(bitfield_aws.xml)
For a completer list of the system features you can refer to this

This version will also require vbulletin 3.6.x to run.If you run 3.5.x or any other release then 3.6.x you will see a message.

This system is tested for a long time and i believe it's stable enough for a public release HOWEVER since this is a major hack and i'm just human please consider this first public run still as "beta"

instructions ow howto install can be found in the docs directory within the zip

statistics
  • 25 plugins
  • 27 templates
  • 5 new MySQL tables
  • 3 standard vbulletin tables alterd (user,post,and usergroup)
  • 827 phrases
  • 47 settings
updates

A problem has been found where no link is provided to view your own warnings(normal users) in the member profile only i fixed this.To get the fix you will need to reedit your "MEMBERINFO" template and reimport product-aws.xml (set allow overwrite to yes)

15-9-2006
I moved the cron jobs from the install/uinstall code to the product file.
version check url now uses http://www.vbulletin.org/forum/misc....rsion&t=124477

to upgrade read upgrade.txt in the docs directory

24-9-2006

a product depency whas added the system will no longer install on PHP 5 (in response to continued error reports on that PHP version)

to report a possible bug

please go the system bugtracker here you can use the folowwing account

username:bugreporter
password:awsbug

no need to register yourself


30-11-2006
People on PHP 5 can follow this instructions to avoid the PHP version related error message BUT remember you are on your own if you do this.I won't upgrade my PHP until PHP 5 is there main stable release (www.php.net)


1-1-2007
A bug has been reported in the system.This bug whas causing vbulletin to throw an error when you try to use admincp => users=> add a new user

Fatal error: Call to a member function clean_gpc() on a non-object in class_dm_user.php(2385) : eval()'d code on line 35
Solution

Edit plugin "AWS:warn link in usermanager" and replace all code with this


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

i'll update the package when i get home


Another Bug is fixed

This release includes a fix for the problem "call to member function on a non object class_dm_user.php)" when you try to add a new user manaually (after submitting the form)

Download Now

Only licensed members can download files, Click Here for more information.

Supporters / CoAuthors

Screenshots

Click image for larger version

Name:	warninglog.png
Views:	6491
Size:	35.0 KB
ID:	52367   Click image for larger version

Name:	postbit.png
Views:	5404
Size:	29.4 KB
ID:	52368   Click image for larger version

Name:	addwarn.png
Views:	5081
Size:	27.1 KB
ID:	52369   Click image for larger version

Name:	ban.png
Views:	3046
Size:	13.7 KB
ID:	52370  

Click image for larger version

Name:	ban_view.png
Views:	2604
Size:	14.5 KB
ID:	52371  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Advanced Warning System (AWS) sv1cec vBulletin 3.0 Full Releases 1042 16 Jul 2007 04:50

  #106  
Old 25 Sep 2006, 02:04
V3RT1G0 V3RT1G0 is offline
 
Join Date: Apr 2006
thx... very nice hack to have!
Reply With Quote
  #107  
Old 25 Sep 2006, 06:38
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Real name: Erik
Originally Posted by wrestlepower
nope, 4.4.2 acording to my cpanelx.

Also, dont mean to be rude, but what does that code box actually mean? A lot of the guys asking for help are going to be n00bs like myself, and that means nothing to me. Where do i add the code? do i replace something with that code?
That's SQL code that would "maually" add the things missing (your error messages)todo this you will need to open phpMyAdmin select te database you use hit the "SQL" link paste the code into the textbox and hit go.After that you should get a message like "your query has been excuted successfully"


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #108  
Old 25 Sep 2006, 17:22
valuemdsupport valuemdsupport is offline
 
Join Date: Dec 2005
Hi Delphiprogrammi,

In this new version, the cron jobs are just deactivating warnings? The users will still see that inactive warnings and i have to remove them from admincp completely if i don't want they can see inactive warnings. Is that right? Sorry, this may be a stupid question but i have to know how it works.

Thanks.
Reply With Quote
  #109  
Old 25 Sep 2006, 18:11
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Real name: Erik
Originally Posted by valuemdsupport
Hi Delphiprogrammi,

In this new version, the cron jobs are just deactivating warnings? The users will still see that inactive warnings and i have to remove them from admincp completely if i don't want they can see inactive warnings. Is that right? Sorry, this may be a stupid question but i have to know how it works.

Thanks.
Normal users cannot see inactive warnings and yeah they will still show up in the warning log but only to people who have permissions to view the warning log
Reply With Quote
  #110  
Old 25 Sep 2006, 23:01
wrestlepower wrestlepower is offline
 
Join Date: Apr 2006
Originally Posted by Delphiprogrammi
That's SQL code that would "maually" add the things missing (your error messages)todo this you will need to open phpMyAdmin select te database you use hit the "SQL" link paste the code into the textbox and hit go.After that you should get a message like "your query has been excuted successfully"


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

thanks for explaining that. Anyway, ive run the queries and still get the db error when i try to manage the warning types as well as the second db error when i try to update a user. I've posted the error details again so you dont have to look for them.

When i try to manage warning types, i get;

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:57:42 PM
Script : http://www.wrestlepower.net/admincp/...rn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database

and when i try to manage a user, i get;
Invalid SQL:


MySQL Error : Unknown column 'alerts' in 'field list'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:59:17 PM
Script : http://www.wrestlepower.net/admincp/user.php?do=update
Referrer : http://www.wrestlepower.net/admincp/...do=edit&u=1488
IP Address : My IP
Username : Duff
Classname : vb_database



EDIT: Seem to have figured out the first bit about manage warning types. The SQL code you gave said warning_maturity, yet the error i was getting mentioned warn_maturity, so i simply swapped the warning and replaced it with warn, ran the SQL again and it worked. Still stuck with the user changing problems though.

EDIT2: OK, everything seems to be fine now. Again, just swapped the words from the error message i was getting (alerts) with what you had in the SQL (warns) and it all worked out.





OH FFS, i just cant get this right

Getting an error when i go into the warning log.

Invalid SQL:
SELECT w.*,u.username AS wusername,u.userid AS wuserid,wt.*,wuser.username AS warned_username_v,wuser.userid AS warned_userid_v, ruser.username AS removed_by_v, (w.warned_time+wt.warn_maturity*24*60*60) AS maturitydate FROM
warnings w
LEFT JOIN user wuser ON(wuser.userid=w.warned_user)
LEFT JOIN user u ON(u.userid=w.warned_by)
LEFT JOIN user ruser ON(ruser.userid=w.removed_by)
LEFT JOIN warning_types wt ON(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0, 15;

MySQL Error : Unknown column 'w.removed_by' in 'on clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 06:14:24 PM
Script : http://www.wrestlepower.net/admincp/...hp?do=viewlogs
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : MY IP
Username : Duff
Classname : vb_database

Last edited by wrestlepower; 25 Sep 2006 at 23:30.
Reply With Quote
  #111  
Old 26 Sep 2006, 09:57
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Real name: Erik
Originally Posted by wrestlepower
thanks for explaining that. Anyway, ive run the queries and still get the db error when i try to manage the warning types as well as the second db error when i try to update a user. I've posted the error details again so you dont have to look for them.

When i try to manage warning types, i get;

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:57:42 PM
Script : http://www.wrestlepower.net/admincp/...rn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database

and when i try to manage a user, i get;
Invalid SQL:


MySQL Error : Unknown column 'alerts' in 'field list'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:59:17 PM
Script : http://www.wrestlepower.net/admincp/user.php?do=update
Referrer : http://www.wrestlepower.net/admincp/...do=edit&u=1488
IP Address : My IP
Username : Duff
Classname : vb_database



EDIT: Seem to have figured out the first bit about manage warning types. The SQL code you gave said warning_maturity, yet the error i was getting mentioned warn_maturity, so i simply swapped the warning and replaced it with warn, ran the SQL again and it worked. Still stuck with the user changing problems though.

EDIT2: OK, everything seems to be fine now. Again, just swapped the words from the error message i was getting (alerts) with what you had in the SQL (warns) and it all worked out.





OH FFS, i just cant get this right

Getting an error when i go into the warning log.

Invalid SQL:
SELECT w.*,u.username AS wusername,u.userid AS wuserid,wt.*,wuser.username AS warned_username_v,wuser.userid AS warned_userid_v, ruser.username AS removed_by_v, (w.warned_time+wt.warn_maturity*24*60*60) AS maturitydate FROM
warnings w
LEFT JOIN user wuser ON(wuser.userid=w.warned_user)
LEFT JOIN user u ON(u.userid=w.warned_by)
LEFT JOIN user ruser ON(ruser.userid=w.removed_by)
LEFT JOIN warning_types wt ON(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0, 15;

MySQL Error : Unknown column 'w.removed_by' in 'on clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 06:14:24 PM
Script : http://www.wrestlepower.net/admincp/...hp?do=viewlogs
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : MY IP
Username : Duff
Classname : vb_database
you are getting way to much errors . I don't have them are you sure you run vbulletin 3.6.x with the PHP and MySQL version requirements and the system downloadble here (not in any other thread)
Reply With Quote
  #112  
Old 28 Sep 2006, 00:47
wrestlepower wrestlepower is offline
 
Join Date: Apr 2006
yes, running vB 3.6.0 with PHP 4.42, both of which should be fine

Ive checked back through the thread and cant see where you mentioned what SQL version i should be on, but i'm on 4.1.21-standard
Reply With Quote
  #113  
Old 28 Sep 2006, 05:37
valuemdsupport valuemdsupport is offline
 
Join Date: Dec 2005
Originally Posted by Delphiprogrammi
Normal users cannot see inactive warnings and yeah they will still show up in the warning log but only to people who have permissions to view the warning log
As you said, admin will see all active and inactive alerts, active and inactive warnings of users (absolutely). And users can't see their inactive alerts and inactive warnings, just see their active alerts and active warnings. Right?

My problem is users can see both. How will i fix this? I installed this hack from 3.5.x and just upgraded to aws3.6.1 for vb3.6.1. Did i do somethings wrong?

See attachment you will see my problem. Any helps will be appreciated.

Thank you.
Attached Images
File Type: png testuser.PNG (30.7 KB, 24 views)
File Type: png admin.PNG (24.5 KB, 21 views)
Reply With Quote
  #114  
Old 28 Sep 2006, 17:56
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Real name: Erik
Originally Posted by valuemdsupport
As you said, admin will see all active and inactive alerts, active and inactive warnings of users (absolutely). And users can't see their inactive alerts and inactive warnings, just see their active alerts and active warnings. Right?

My problem is users can see both. How will i fix this? I installed this hack from 3.5.x and just upgraded to aws3.6.1 for vb3.6.1. Did i do somethings wrong?

See attachment you will see my problem. Any helps will be appreciated.

Thank you.
ow that's what you mean that can be hidden to mods only letme construct the condition and test it

edit

look at the two pics that information like the amount of warnings/alerts and the warning level is only viewable to usergroups 5,6,7 (standard vbulletin usergroups) (5 = supermoderators 6=Administrators 7 = moderators)

if that is what you want i will tell you howto do that
Attached Images
File Type: png testuser.png (7.4 KB, 19 views)
File Type: png testuser_admin.png (8.3 KB, 17 views)

Last edited by Delphiprogrammi; 28 Sep 2006 at 18:21.
Reply With Quote
  #115  
Old 29 Sep 2006, 10:40
valuemdsupport valuemdsupport is offline
 
Join Date: Dec 2005
Originally Posted by Delphiprogrammi
ow that's what you mean that can be hidden to mods only letme construct the condition and test it

edit

look at the two pics that information like the amount of warnings/alerts and the warning level is only viewable to usergroups 5,6,7 (standard vbulletin usergroups) (5 = supermoderators 6=Administrators 7 = moderators)

if that is what you want i will tell you howto do that
Oh, no. That's not what i need from your help. I have 2 problem now.
  1. I attempted to completely remove a user's warning via the admin panel choosing "complete removal" as suggested. Although it removed the warning in the admin panel (only 2 warnings show instead of 3), it still shows that the user has 3 warnings??
  2. And another user received 4 warnings on 9-27-06. According to the settings, the user should automatically have a 7 day temporary ban after reaching a warning level of 3. However, this user was able to post today and is not banned??
Those are my problems. Can you please check the script or should we have a maintenance script or a cron job script?

Thank you.
Reply With Quote
  #116  
Old 29 Sep 2006, 11:18
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Real name: Erik
Originally Posted by valuemdsupport
Oh, no. That's not what i need from your help. I have 2 problem now.
  1. I attempted to completely remove a user's warning via the admin panel choosing "complete removal" as suggested. Although it removed the warning in the admin panel (only 2 warnings show instead of 3), it still shows that the user has 3 warnings??
  2. And another user received 4 warnings on 9-27-06. According to the settings, the user should automatically have a 7 day temporary ban after reaching a warning level of 3. However, this user was able to post today and is not banned??
Those are my problems. Can you please check the script or should we have a maintenance script or a cron job script?

Thank you.
1)your not the first talking about that i will spend some hours to see if i can catch that(also remember that warnings removed by cron are still in the warning log but it will mention it is removed by the cron script)
2)that could be possible with dynamically assigned ipadresses (changes every time you connect to the internet)

edit

again i tested that and in here it is working :surprised: :surprised: the system already uses three cron scripts.I did a testpost where the testuser warninglevel should be above the limit and the system should ban and it did banned my testuser.Also the warningcounters work fine.

Create a temporary admin account and pm me the login details so i can take a look at what's happening at your board

Last edited by Delphiprogrammi; 29 Sep 2006 at 13:59.
Reply With Quote
  #117  
Old 29 Sep 2006, 14:03
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Real name: Erik
Originally Posted by wrestlepower
yes, running vB 3.6.0 with PHP 4.42, both of which should be fine

Ive checked back through the thread and cant see where you mentioned what SQL version i should be on, but i'm on 4.1.21-standard
MySQL should be fine but PHP 4.4.2 has known security holes see this for more information

the same comment to you.I'd like to have a look at your board to see what is exactely happening when the reported errors occour

Also ... what do you have in your templates ? (MEMBERINFO,postbit,postbit_legacy)


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Last edited by Delphiprogrammi; 29 Sep 2006 at 20:35.
Reply With Quote
  #118  
Old 01 Oct 2006, 15:55
badboyz badboyz is offline
 
Join Date: May 2006
there is no read me how do i edit the templetes?
Reply With Quote
  #119  
Old 01 Oct 2006, 16:31
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Real name: Erik
Originally Posted by badboyz
there is no read me how do i edit the templetes?
the readme is there /docs .....
Reply With Quote
  #120  
Old 12 Oct 2006, 16:41
nir nir is offline
 
Join Date: Aug 2005
Real name: itzik
it works to the version 3.6.2?
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 05:46.

Layout Options | Width: Wide Color: