vb.org Archive
Page 9 of 63 « First 78 9 10111959 Last »
Show 40 post(s) from this thread on one page

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)

Delphiprogrammi 09-12-2006 07:24 PM
Quote:
Originally Posted by Luggruff
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?
$pnotes are the warn_notes they are embedded into the product (they can be disabled in the settings) you must edit both templates postbit and postbit_legacy if you want them to appaer

badshah 09-12-2006 08:36 PM
how do I add a warning.
I am trying to warn someone but there is nothing to select in "Warning Selection"
I see the attachement https://vborg.vbsupport.ru/attachmen...7&d=1101243281 but how do I add them in the "Warning selection"
Thanks

Luggruff 09-13-2006 01:59 AM
<a href="http://www.vbulletin.com/forum/showthread.php?p=1209982" target="_blank">http://www.vbulletin.com/forum/showthread.php?p=1209982</a>

anyone with a clue??
(concerns AWS)

Delphiprogrammi 09-13-2006 10:02 AM
Quote:
Originally Posted by badshah
how do I add a warning.
I am trying to warn someone but there is nothing to select in "Warning Selection"
I see the attachement https://vborg.vbsupport.ru/attachmen...7&d=1101243281 but how do I add them in the "Warning selection"
Thanks
admincp => advanced Warning System => manage warning types add at least one(1) non post related ...

Delphiprogrammi 09-13-2006 10:03 AM
Quote:
Originally Posted by Luggruff
that's not true AWS does not interfere with infractions

Luggruff 09-13-2006 04:07 PM
Quote:
Originally Posted by Delphiprogrammi
that's not true AWS does not interfere with infractions
Looks like you are wrong:
http://www.vbulletin.com/forum/showp...2&postcount=20

seg 09-13-2006 04:08 PM
I found that a user's warning level was not lowering after 60 day (the maturity date I set. I checked the users account and found that the warning level was at 5, but the warnings were blank (no number). When I tried to correct the issue I received the following db error:

Code:
Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE forumuser SET
        ### Bitfield: forumuser.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, options + 256),
                options = IF(options & 512, options, options + 512),
                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: forumuser.adminoptions ###
                adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
                adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
        usertitle = 'Member',
        customtitle = 0,
        username = 'private',
        email = 'private',
        languageid = 0,
        homepage = '',
        birthday_search = 'private',
        birthday = 'private',
        showbirthday = 0,
        icq = '',
        aim = '',
        yahoo = '',
        msn = '',
        skype = '',
        parentemail = '',
        referrerid = 0,
        ipaddress = 'private',
        posts = 192,
        alerts = 1,
        warns = 6,
        warning_level = 0,
        warning_bans = 0,
        usergroupid = 2,
        reputationlevelid = 5,
        reputation = 10,
        warnings = 6,
        infractions = 0,
        ipoints = 0,
        pmpopup = 0,
        autosubscribe = -1,
        threadedmode = 0,
        showvbcode = 1,
        styleid = 0,
        timezoneoffset = '-8',
        daysprune = 0,
        joindate = 1140481140,
        lastactivity = 1158105360,
        lastpost = 1158104940,
        membergroupids = '',
        genpermoverride = 536870911,
        adminignore = ''
WHERE userid = 1283;

MySQL Error  : Unknown column 'warns' in 'field list'
Error Number : 1054
I marked private on some of the user's info. What can I do to repair this problem? Do I go directly into MySQL and add the warns amount?

seg 09-13-2006 06:03 PM
I am getting the above error message when ever I try to save anything for any person in the User Manager. Could this be related to the 3.5.0 issue I mentioned earlier (below)? From the above error message does it look like the db tables for the warning system didn't update?

Quote:
Originally Posted by seg
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-14-2006 08:32 PM
Quote:
Originally Posted by Luggruff
nope

infractions working fine .....

Delphiprogrammi 09-14-2006 08:37 PM
Quote:
Originally Posted by seg
I found that a user's warning level was not lowering after 60 day (the maturity date I set. I checked the users account and found that the warning level was at 5, but the warnings were blank (no number). When I tried to correct the issue I received the following db error:

Code:
Database error in vBulletin 3.6.0:
 
Invalid SQL:
UPDATE forumuser SET
    ### Bitfield: forumuser.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, options + 256),
        options = IF(options & 512, options, options + 512),
        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: forumuser.adminoptions ###
        adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'Member',
    customtitle = 0,
    username = 'private',
    email = 'private',
    languageid = 0,
    homepage = '',
    birthday_search = 'private',
    birthday = 'private',
    showbirthday = 0,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = 'private',
    posts = 192,
    alerts = 1,
    warns = 6,
    warning_level = 0,
    warning_bans = 0,
    usergroupid = 2,
    reputationlevelid = 5,
    reputation = 10,
    warnings = 6,
    infractions = 0,
    ipoints = 0,
    pmpopup = 0,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 1,
    styleid = 0,
    timezoneoffset = '-8',
    daysprune = 0,
    joindate = 1140481140,
    lastactivity = 1158105360,
    lastpost = 1158104940,
    membergroupids = '',
    genpermoverride = 536870911,
    adminignore = ''
WHERE userid = 1283;
 
MySQL Error  : Unknown column 'warns' in 'field list'
Error Number : 1054
I marked private on some of the user's info. What can I do to repair this problem? Do I go directly into MySQL and add the warns amount?
hmmmz since more users complain about this type of errors i need to check the system.why on earth is your warns field missing ????

Code:
ALTER TABLE forumuser ADD COLUMN warns INT(5) DEFAULT '0';
i will check that


All times are GMT. The time now is 05:48 PM.
Page 9 of 63 « First 78 9 10111959 Last »
Show 40 post(s) from this thread on one page

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.01247 seconds
  • Memory Usage 1,765KB
  • 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
  • (3)bbcode_code_printable
  • (7)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