vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Administrative and Maintenance Tools - Advanced Warning System 3.6.7 (https://vborg.vbsupport.ru/showthread.php?t=124477)

chipet 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 :p

seg 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 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 :p

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

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


All times are GMT. The time now is 09:13 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.01432 seconds
  • Memory Usage 1,788KB
  • 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
  • (5)bbcode_code_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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