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)

chipet · #72 09-10-2006, 08:21 AM

Where can I reset the Warning levels?
The Warninglevel has a text under the avatar when you are posting, and I wants to reset it to zero

seg · #73 09-10-2006, 11:40 AM

Hi,
I recently upgraded to vb 3.6.0 and now upgraded from an old AWS release to AWS 3.6.0. I am seeing two problems immediately. With my Administrator account, when I try to warn a regular user or add a note to the user's account I get this message:

An error has occured, the following message has been left below: :
You have no permissions to issue warnings

I also visited vBulletin Options -> Warning Hack -> Aws Version and it is reporting 3.5.0. When I visit my Product Manager and do a version check it reports 3.6.0 (there is no 3.5.0 at all).

Do you have any ideas how to resolve these two problems?

Thanks for moving this to 3.6.0, I like this product better than the infraction system

Delphiprogrammi · #74 09-10-2006, 12:32 PM

Quote:

Originally Posted by chipet

Where can I reset the Warning levels?
The Warninglevel has a text under the avatar when you are posting, and I wants to reset it to zero

impossible you will only see something there if those values are greater then 0

Delphiprogrammi · #75 09-10-2006, 12:38 PM

Quote:

Originally Posted by seg

Hi,
I recently upgraded to vb 3.6.0 and now upgraded from an old AWS release to AWS 3.6.0. I am seeing two problems immediately. With my Administrator account, when I try to warn a regular user or add a note to the user's account I get this message:

An error has occured, the following message has been left below: :
You have no permissions to issue warnings

I also visited vBulletin Options -> Warning Hack -> Aws Version and it is reporting 3.5.0. When I visit my Product Manager and do a version check it reports 3.6.0 (there is no 3.5.0 at all).

Do you have any ideas how to resolve these two problems?

Thanks for moving this to 3.6.0, I like this product better than the infraction system

you did not set permissions .... usergroups => edit and for the versionnumber hmmz did you used the correct product ?

Code:

<setting varname="warn_version" displayorder="44">
    <datatype>free</datatype>
    <defaultvalue>3.6.0</defaultvalue>
   </setting>

is in my product file

chipet · #76 09-10-2006, 01:16 PM

Quote:

Originally Posted by Delphiprogrammi

impossible you will only see something there if those values are greater then 0

yeah, but we reinstalled the aws system, and all the warnings disappeard, but the counter still ticking, so one person have 15 warnings, but they are deleted

seg · #77 09-10-2006, 01:37 PM

Quote:

Originally Posted by Delphiprogrammi

you did not set permissions .... usergroups => edit and for the versionnumber hmmz did you used the correct product ?

My installed products show version 3.6.0 - it is only the vBulletin options that shows 3.5.0 - to tell you the truth, I never had version 3.5.0 installed. Where would vBulletin options be pulling this from?

Thank you about the permissions reminder - I assumed that they remained the same, but I should never assume. For option "Can View Warnings" - are these the warnings that appear in the profile or are these the detailed warnings with descriptions. I only want other members to see the number of Alerts/Warnings/Bans.

Delphiprogrammi · #78 09-10-2006, 01:56 PM

Quote:

Originally Posted by chipet

yeah, but we reinstalled the aws system, and all the warnings disappeard, but the counter still ticking, so one person have 15 warnings, but they are deleted

then you could edit it under the usermanager there is a column warnings information set those values all to 0 and submit the form (you will have to do that for each user through)

Luggruff · #79 09-11-2006, 05:44 PM

Quote:

Originally Posted by Delphiprogrammi

then you could edit it under the usermanager there is a column warnings information set those values all to 0 and submit the form (you will have to do that for each user through)

Yeah, for 1500 users. Especially when it won't let you update the userprofiles anymore.
Error as following:

Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE user SET
    ### Bitfield: user.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 1024, options, options + 1024),
        options = IF(options & 16, options, options + 16),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 512, options - 512, options),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 2048, options, options + 2048),
        options = IF(options & 4096, options - 4096, options),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options, options + 2),
        options = IF(options & 4, options, options + 4),
        options = IF(options & 64, options, options + 64),
        options = IF(options & 128, options - 128, options),
        options = IF(options & 32768, options - 32768, options),
    ### Bitfield: user.adminoptions ###
        adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'c.\")',
    customtitle = 2,
    username = 'woicer',
    email = 'woicer@crackinggear.net',
    languageid = 2,
    homepage = 'http://www.habbohotel.se',
    birthday_search = '0000-01-01',
    birthday = '01-01-0000',
    showbirthday = 1,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = '',
    posts = 2270,
    alerts = 0,
    warns = 0,
    warning_level = 0,
    warning_bans = 0,
    isstaffrank = '0',
    staffrank = '',
    staffrank_opentag = '',
    staffrank_closetag = '',
    usergroupid = 5,
    reputationlevelid = 7,
    reputation = 88,
    warnings = 0,
    infractions = 0,
    ipoints = 0,
    pmpopup = 0,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 2,
    styleid = 0,
    timezoneoffset = '2',
    daysprune = 0,
    joindate = 1108033200,
    lastactivity = 1157998800,
    lastpost = 1157952060,
    membergroupids = ''
WHERE userid = 632;

MySQL Error  : Unknown column 'warns' in 'field list'
Error Number : 1054
Date         : Monday, September 11th 2006 @ 02:42:28 PM
Script       : http://www.hlforum.org/admcp/user.php?do=update
Referrer     : http://www.hlforum.org/admcp/user.php?do=edit&u=632
IP Address   : 81.235.17.12
Username     : Luggruff
Classname    : vb_database

A solution is needed. And fast?

Delphiprogrammi · #80 09-11-2006, 06:22 PM

Quote:

Originally Posted by Luggruff

Yeah, for 1500 users. Especially when it won't let you update the userprofiles anymore.
Error as following:

Code:

Database error in vBulletin 3.6.0:
 
Invalid SQL:
UPDATE user SET
    ### Bitfield: user.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 1024, options, options + 1024),
        options = IF(options & 16, options, options + 16),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 512, options - 512, options),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 2048, options, options + 2048),
        options = IF(options & 4096, options - 4096, options),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options, options + 2),
        options = IF(options & 4, options, options + 4),
        options = IF(options & 64, options, options + 64),
        options = IF(options & 128, options - 128, options),
        options = IF(options & 32768, options - 32768, options),
    ### Bitfield: user.adminoptions ###
        adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'c.\")',
    customtitle = 2,
    username = 'woicer',
    email = 'woicer@crackinggear.net',
    languageid = 2,
    homepage = 'http://www.habbohotel.se',
    birthday_search = '0000-01-01',
    birthday = '01-01-0000',
    showbirthday = 1,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = '',
    posts = 2270,
    alerts = 0,
    warns = 0,
    warning_level = 0,
    warning_bans = 0,
    isstaffrank = '0',
    staffrank = '',
    staffrank_opentag = '',
    staffrank_closetag = '',
    usergroupid = 5,
    reputationlevelid = 7,
    reputation = 88,
    warnings = 0,
    infractions = 0,
    ipoints = 0,
    pmpopup = 0,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 2,
    styleid = 0,
    timezoneoffset = '2',
    daysprune = 0,
    joindate = 1108033200,
    lastactivity = 1157998800,
    lastpost = 1157952060,
    membergroupids = ''
WHERE userid = 632;
 
MySQL Error  : Unknown column 'warns' in 'field list'
Error Number : 1054
Date         : Monday, September 11th 2006 @ 02:42:28 PM
Script       : http://www.hlforum.org/admcp/user.php?do=update
Referrer     : http://www.hlforum.org/admcp/user.php?do=edit&u=632
IP Address   : 81.235.17.12
Username     : Luggruff
Classname    : vb_database

A solution is needed. And fast?

Code:

ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';
UPDATE user SET warning_level=0,warns=0;

the first query will add the missing warns field (the errormessage problem) the second query will reset the warning_level and warns fields to 0 FOR ALL users

Luggruff · #81 09-12-2006, 06:25 AM

Quote:

Originally Posted by Delphiprogrammi

Code:

ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';
UPDATE user SET warning_level=0,warns=0;

the first query will add the missing warns field (the errormessage problem) the second query will reset the warning_level and warns fields to 0 FOR ALL users

Thank you! (:

And another thing, how come the whole second table-row in the postbit (for notes) is not accessable from the postbit template? I was just about to re-style the whole thing and I couln't reach that row, due to the fact that it is embedded in $pnotes. Where can I find it? And why make it so complicated for designers?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09529 seconds Memory Usage 2,334KB 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 (5)bbcode_code (1)bbcode_php (9)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 (2)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!