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)

DS MrSinister 12-19-2004 06:01 AM

When I run this i get a error..

how would i get this to work right?

PHP Code:

ALTER TABLE `".TABLE_PREFIX."warning_optionsADD COLUMN `versionchar(10AFTER oid 


sv1cec 12-19-2004 06:29 AM

Quote:

Originally Posted by DS MrSinister
When I run this i get a error..

how would i get this to work right?

PHP Code:

ALTER TABLE `".TABLE_PREFIX."warning_optionsADD COLUMN `versionchar(10AFTER oid 


If you are not using a special TABLE_PREFIX in your database, delete the part saying ".TABLE_PREFIX." . I have to assume that this is the error you are getting, because you didn't say what it was.

Rgds

hello 12-19-2004 06:55 AM

just try this ALTER TABLE `warning_options` ADD COLUMN `version` char(10) AFTER oid

Delphiprogrammi 12-19-2004 10:33 AM

hi,

open up config.php and look for

PHP Code:

Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix ''

if this setting is empty do not worry about it if it isn't then replace the "TABLE_PREFIX" with the setting you have in $tableprefix


note DO NOT EDIT THIS SETTING unless vbulletin tells you todo it your vbulletin installing will stop to work !

DS MrSinister 12-19-2004 03:58 PM

THanks but i have another problem here....


this what i get when i click on View Warned Users in the admin Panel.

PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQLSELECT COUNT(*) AS users FROM user AS user where warnings>0
mysql error
Unknown column 'warnings' in 'where clause'

mysql error number1054 

Maybe i miss adding a table or something!.. any ideas...

mcyates 12-20-2004 10:13 AM

Is it possible to remove the logging of bans after say 6 months? I'm just thinking if a member gets banned and the first ban is 7 day the 2nd ban is permanent. Say he got a ban within 1 months of joining, then he becomes a quality member and 2 years later gets banned again (due to multiple warnings) he'll be banned permanently and i think theis might be a little harsh. Could you add an option like:

Delete ban history if older than 6 months? YES / NO

Tell me what you think?

ArAb4NoKiA 12-20-2004 12:41 PM

ThAnXxXxX

SamirDarji 12-20-2004 04:42 PM

Quote:

Originally Posted by mcyates
Is it possible to remove the logging of bans after say 6 months? I'm just thinking if a member gets banned and the first ban is 7 day the 2nd ban is permanent. Say he got a ban within 1 months of joining, then he becomes a quality member and 2 years later gets banned again (due to multiple warnings) he'll be banned permanently and i think theis might be a little harsh. Could you add an option like:

Delete ban history if older than 6 months? YES / NO

Tell me what you think?

Not a bad idea. I like. :D

sv1cec 12-20-2004 05:21 PM

Gentlemen,

please forgive my absence, but yesterday, rain got through an open window, into my PC's monitor.

At this time, my Internet access is done through an old Sun server, with a very old
version of Netscape browser. Unfortunatelly, this version crashes, every
time I go into a message composition screen. I just downloaded and installed a beta
version of Mozilla, hoping,that I'll be able to send this message to you.

As you understand, I am unable to provide support, until my normal access is restored
hopefully tomorrow. Until then:

1. DR MrSinister's problem originates from the fact that he has not added the three new
columns, in his user table, during one of the upgrades (I do not have access to the
Versions file, so I do not remember in which version they were added). Check the
UpgradeToLatestVersion.txt file and fine the query that adds these in the table.
2. Deleting the bans is more troublesome that it initially appears, because I do
not store the ban date anywhere, at this time. If this feature is to be included,
I'll have to have at least the date of the last ban, stored in the user table, so that
a cron job can then remove it. Also, a parameter has to be added in the warning_options
table, to specify after how many days the bans will be erased.

I assume you will have to wait for after the Holidays for this.

Sorry for not being here yesterday or today, but I was trying to have my monitor fixed.
I didn't, so I have to get a new one, and this is not the best of times for such
expenditure.

Rgds

just to see if that would allow me to

rh2004 12-21-2004 12:58 AM

I don't know what version I have lol you are creating them so fast..

Anyway I got a suggestion, when I warned someone and then disactived it (removed)
just removed not completely, how can I re-active it... without having to send out a
nother warning to the user... I think that would be a good add-on :)


All times are GMT. The time now is 07:03 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.02057 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
  • (4)bbcode_php_printable
  • (2)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