vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/showthread.php?t=71992)

Rhoads 01-29-2005 09:15 PM

Hi sv1cec

I have installed the warning system (3.1.4) again today on een clean forum (3.0.6). It's amazing how well it works, I had no problems, and it works 100% in 1 time. Very good job.

Only missed 2 gif's for the User Manager (warnuser.gif & viewuserwarnings.gif), but I get that from de older installer and it's working now. Also the warning indicated still the old version 3.1.3, but that I have updated myself to 3.1.4

Well work, and thanks for these fantastic hack.

sv1cec 01-30-2005 04:38 AM

Yep, you are right, I removed those two images from the upload, when I changed the buttons to the "more sophisticated" ones. Don't worry about it, just download the latest 3.1.5 version and apply the update instructions, just a query to run (to set the version) and one file change in admincp/user.php.

rh2004, have you defined if you want buttons or textual links in the Warning Options? Also, you can add that column in your database table, by running the query:

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id

Remember to change TABLE_PREFIX according to your database.

rh2004 01-30-2005 08:15 AM

OK.. can you tell me what TABLE_PREFIX is.. an example please

It was set on text.. when I changed it I received

Code:

Database error in vBulletin 3.0.6:

Invalid SQL: update warning_options set
        hierarchical='No',
        automatic='No',
        automaticpm='No',
        autocomments='No',
        warner='7',
        automatic_warner='0',
        collector='',
        banned_limit='7',
        points_before_banned='10',
        warnings_before_banned='',
        banned_usergroup_id='11',
        troll_usergroup_id='8',
        protected_usergroups='5|6|7|6',
        aprotected_usergroups='6',
        restore_groupid='0',
        incr_ban_days='Yes',
        max_no_bans='3',
        bans_mature='',
        viewoption='All',
        multiple_per_post='Yes',
        send_pm_warning='Yes',
        send_em_warning='Yes',
        email_on_ban='No',
        historical='Yes',
        allowoffpost='Yes',
        warnings_per_page='15',
        textbutoption='Text'
        where oid='1'
mysql error: Unknown column 'autocomments' in 'field list'

mysql error number: 1054

Date: Sunday 30th of January 2005 05:15:05 AM
Script: http:///admincp/admin_warn.php
Referer: http:///admincp/admin_warn.php?act=manageoptions
Username: xx
IP Address: xx


Thanks

sv1cec 01-30-2005 09:17 AM

Run this query:

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id

TABLE_PREFIX is a prefix you have specified, when you installed your vB. It is added in front of each table name. From the message above, you do not seem to need one, so just delete the ".TABLE_PREFIX." from the query above.

You are obviously trying to upgrade to the latest version, form an older one, but not from the previous one. In order to do it, you have to do all the upgrade steps, described in the UpgradeToLatestVersion.txt file, starting from the version you have installed already.

Rgds

rh2004 01-30-2005 05:48 PM

but I don't know what version im running at all, how can I find out...

sv1cec 01-30-2005 06:29 PM

Quote:

Originally Posted by rh2004
but I don't know what version im running at all, how can I find out...

If you didn't have the caused_ban field in that table, you are at around 2.3.1 or something. Lots of changes to get to the latest version. I would suggest that you uninstall and reinstall from scratch.

Rgds

Rhoads 01-30-2005 06:58 PM

Quote:

Originally Posted by rh2004
but I don't know what version im running at all, how can I find out...

When you in the admin and go to the Warning System, push on the Manage Warning Types, then you can see the version number of the hack in the right corner

bahawolf 01-30-2005 07:17 PM

Upgrading from version 3.1.2 it tells me to upload 3 image files:
warnuser.gif, viewuserwarnings.gif and viewyourwarnings.gif

None of which I can find in the zip.


Oh, nevermind.. I see they can be deleted later.. Thanks anyway. :)

bahawolf 01-30-2005 07:34 PM

Database error in vBulletin 3.0.5:

Invalid SQL: update warning_options set
hierarchical='Yes',
automatic='No',
automaticpm='No',
autocomments='Yes',
warner='0',
automatic_warner='1',
collector='',
banned_limit='7',
points_before_banned='10',
warnings_before_banned='',
banned_usergroup_id='13',
troll_usergroup_id='13',
protected_usergroups='6|6',
aprotected_usergroups='6',
restore_groupid='2',
incr_ban_days='Yes',
max_no_bans='3',
bans_mature='0',
viewoption='All',
multiple_per_post='Yes',
send_pm_warning='Yes',
send_em_warning='No',
email_on_ban='Yes',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='15',
textbutoption='Text'
where oid='1'
mysql error: Unknown column 'collector' in 'field list'

mysql error number: 1054

I got that updating my AWS Options after upgrading to version 3.1.5

rh2004 01-30-2005 08:36 PM

Quote:

Originally Posted by sv1cec
If you didn't have the caused_ban field in that table, you are at around 2.3.1 or something. Lots of changes to get to the latest version. I would suggest that you uninstall and reinstall from scratch.

Rgds


Yeah it was around Dec 1ish when I installed it... so how do I un-install it
apart from use the uninstaller... it will be alot easier

Maybe good if you can add the version you are using in the control panel.. :nervous:


I ran the uninstaller.. and now receive this error when I go to /board/

Code:

Database error in vBulletin 3.0.6:

Invalid SQL: select * from warning_options where oid='1'
mysql error: Table 'xx_forums.warning_options' doesn't exist

mysql error number: 1146

Date: Sunday 30th of January 2005 05:41:09 PM
Script: http:///board/
Referer:
Username: xx
IP Address: xx




Quote:

Quote:
Originally Posted by rh2004
but I don't know what version im running at all, how can I find out...


When you in the admin and go to the Warning System, push on the Manage Warning Types, then you can see the version number of the hack in the right corner
Doesn't show me anything...


All times are GMT. The time now is 10:57 AM.

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.02391 seconds
  • Memory Usage 1,751KB
  • 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
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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