vb.org Archive
Page 37 of 63 « First 273536 37 383947 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 07-17-2007 08:47 PM
Quote:
Originally Posted by provedel (Post 1293004)
I am getting this error after install of AWS and wanto to change anything in profile of users...

Code:
Database error in vBulletin 3.6.7:
 
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, options + 512),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 2048, options - 2048, options),
        options = IF(options & 131072, options - 131072, options),
        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, adminoptions + 1),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'Administra??o',
    customtitle = 1,
    username = 'Fabio',
    email = 'fabiosz@ig.com.br',
    languageid = 0,
    homepage = '',
    birthday_search = '0000-01-04',
    birthday = '01-04-0000',
    showbirthday = 3,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = '200.165.254.57',
    posts = 3167,
    alerts = 0,
    warns = 0,
    warning_level = 0,
    warning_bans = 0,
    usergroupid = 6,
    displaygroupid = 0,
    membergroupids = '34',
    reputationlevelid = 12,
    reputation = 180,
    warnings = 0,
    infractions = 0,
    ipoints = 0,
    pmpopup = 0,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 2,
    styleid = 0,
    timezoneoffset = '-3',
    daysprune = -1,
    joindate = 1088773200,
    lastactivity = 1184613480,
    lastpost = 1184349060
WHERE userid = 270;
 
MySQL Error  : Unknown column 'alerts' in 'field list'
Error Number : 1054
Date        : Monday, July 16th 2007 @ 03:41:05 PM
Script      : http://forum.plurall.org/admincp/user.php?do=update
Referrer    : http://forum.plurall.org/admincp/user.php?do=edit&u=270
IP Address  : 201.37.21.114
Username    : Sauron
Classname    : vb_database
Any help?
[SQL]
ALTER TABLE user ADD COLUMN alerts INT(5) DEFAULT '0';
[/SQL]

Delphiprogrammi 07-17-2007 08:50 PM
my server crashed today after looking for the problem for hours my host tech support found and solved it.I corrected the reported problems but i'm taking some time to test the changes as to "speedy" releases are never good

Bravo 07-18-2007 12:37 AM
Quote:
Originally Posted by Delphiprogrammi (Post 1292657)
yes you're right the first is a spelling error the second (the counter thing) is because of not correctly processing phrases that will be updated later today
Hey Delphi, Just wondering if you fixed the counter thing? cause I updated to (B) and it still wont show the counter :confused:

provedel 07-18-2007 03:31 PM
Hey Delphi, where I manage the warnings types?

Delphiprogrammi 07-18-2007 03:35 PM
Quote:
Originally Posted by Bravo2007 (Post 1294162)
Hey Delphi, Just wondering if you fixed the counter thing? cause I updated to (B) and it still wont show the counter :confused:
i have just updated it

Delphiprogrammi 07-18-2007 03:36 PM
Quote:
Originally Posted by provedel (Post 1294703)
Hey Delphi, where I manage the warnings types?
admincp => Advanced Warning System => manage warning types or just type admin_warn.php?do=view

Bravo 07-18-2007 10:20 PM
Quote:
Originally Posted by Delphiprogrammi (Post 1294709)
i have just updated it
Thanks everything works perfect so far :)

BTW it seem this update also took care of the problem I was having eariler
with the BAN COUNT dispearing whenever I checked that Members Profile.
:)

Delphiprogrammi 07-19-2007 08:49 AM
hi,

if a member warningsinfo is greater then 0 (zero) and you warning him again the "current warninginfo" displayed on the warningforms is not working as it should .I corrected this to fetch te update redownload and import product-aws.xml (set allow overwrite to yes) and make sure there is this code

HTML Code:
<phrase 1="{$user['alerts']}">$vbphrase[aws_alerts_npr]</phrase><br>
<phrase 1="{$user['warns']}">$vbphrase[aws_warnings_npr]</phrase><br>
<phrase 1="{$user['warning_level']}">$vbphrase[aws_warnpoints_npr]</phrase><br>
<phrase 1="{$user['warning_bans']}">$vbphrase[aws_bans_npr]</phrase>
in the warn_addwarn and warn_addwarn_nopost templates

that's all folks

:)

provedel 07-19-2007 03:14 PM
Quote:
Originally Posted by Delphiprogrammi (Post 1294711)
admincp => Advanced Warning System => manage warning types or just type admin_warn.php?do=view
Its strange, cannot see Advanced Warning System on admincp... :confused:

I missed anything?:erm:

Delphiprogrammi 07-19-2007 03:18 PM
Quote:
Originally Posted by provedel (Post 1295766)
Its strange, cannot see Advanced Warning System on admincp... :confused:

I missed anything?:erm:
did you uploaded cpnav_aws.xml to /forums/includes/xml and refreshed your admincp ? anyway i found another problem in the current package and i took i temporarly away i will put it back when i fixed it


All times are GMT. The time now is 05:52 AM.
Page 37 of 63 « First 273536 37 383947 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.01753 seconds
  • Memory Usage 1,755KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_html_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