The Arcive of Official vBulletin Modifications Site.

Advanced Warning System 3.6.7 · **Released**: 08-19-2006

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 https://vborg.vbsupport.ru/misc.php?...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

Quote:

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

PHP Code:


			
$quicklinks["../Warn.php?" . $vbulletin->session->vars['sessionurl'] . "do=WarnUserNoPost&amp;id=" . $vbulletin->GPC['userid']] = $vbphrase['aws_warn_user_admin'];

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)

Delphiprogrammi · #**112** 09-26-2006, 08:57 AM

Quote:

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)

wrestlepower · #**113** 09-27-2006, 11:47 PM

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

valuemdsupport · #**114** 09-28-2006, 04:37 AM

Quote:

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.

Delphiprogrammi · #**115** 09-28-2006, 04:56 PM

Quote:

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

valuemdsupport · #**116** 09-29-2006, 09:40 AM

Quote:

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.

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??
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.

Delphiprogrammi · #**117** 09-29-2006, 10:18 AM

Quote:

Originally Posted by valuemdsupport

Oh, no. That's not what i need from your help. I have 2 problem now.

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??
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

Delphiprogrammi · #**118** 09-29-2006, 01:03 PM

Quote:

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)

PHP Code:


			
$user['warnings']; // vbulletin infraction system

$user['warns']; // aws

$userinfo['warnings']; //vbulletin infraction (MEMBERINFO template)

$userinfo['warns']; //aws (MEMBERINFO template)

badboyz · #**119** 10-01-2006, 02:55 PM

there is no read me how do i edit the templetes?

Delphiprogrammi · #**120** 10-01-2006, 03:31 PM

Quote:

Originally Posted by badboyz

there is no read me how do i edit the templetes?

the readme is there /docs .....

nir · #**121** 10-12-2006, 03:41 PM

it works to the version 3.6.2?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04728 seconds Memory Usage 2,338KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_php (8)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!