vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Advanced Warning System (Beta Version) (https://vborg.vbsupport.ru/showthread.php?t=95921)

sv1cec 08-08-2006 07:26 AM

Hey Delphi, since the Premium Modification Forum of AWS is not used any more, what you think if we ask the moderators to purge that forum from all previous messages and start using that forum for support of AWS 3.5 and 3.6?

Let me know.

Delphiprogrammi 08-08-2006 08:55 AM

Quote:

Originally Posted by sv1cec
Hey Delphi, since the Premium Modification Forum of AWS is not used any more, what you think if we ask the moderators to purge that forum from all previous messages and start using that forum for support of AWS 3.5 and 3.6?

Let me know.

I see some questions are being asked about this system in the premium forum while support for the 3.5.x port is being provided here in this thread.So yes that will be a good idea if a mod wants todo that

sv1cec 08-08-2006 09:00 AM

I've already PMed a moderator and asked if it is possible to delete all previous threads from there. If not, we can just post an announcement here, that this hack will be supported in the Premium forum and work like that.

RMS-Chef 08-09-2006 04:35 AM

Quote:

Originally Posted by Delphiprogrammi
that's normal since both systems use a database field called "warnings" and when you uninstall aws that field will be deleted ...... run

Code:

ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';
keep TABLE_PREFIX in mind.....

this error will be gone now

So I should be OK if I uninstall this before the upgrade to v3.6?
This uninstall should drop the table but running the upgrade script should recreate it, yes?

I do love this hack but I would like to keep my board as default as possible. Perhaps if the infractions system does not work out for me and this becomes stable on v3.6 I would install it again but for the initial upgrade I plan to drop it.

Delphiprogrammi 08-10-2006 09:50 AM

Quote:

Originally Posted by RMS-Chef
So I should be OK if I uninstall this before the upgrade to v3.6?
This uninstall should drop the table but running the upgrade script should recreate it, yes?

I do love this hack but I would like to keep my board as default as possible. Perhaps if the infractions system does not work out for me and this becomes stable on v3.6 I would install it again but for the initial upgrade I plan to drop it.

if you plan to upgrade to 3.6 uninstall aws.The "thing" with the database fields is fixed by now i'm just having a verry strange problem where the warning counter isn't updating itself sow i can't release a system that doesn't work properly he.For now uninstall it and you won't have a problem with that warnings database field

Tayeb 08-10-2006 08:50 PM

Hello,

In Admin CP Statistics Warning per User I am getting the following error:

Database error in vBulletin 3.5.5:

Invalid SQL:
SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0;

MySQL Error : Unknown column 'warnings' in 'where clause'
Error Number : 1054
Date : Thursday, August 10th 2006 @ 10:47:21 PM
Script : http://mysite/admin/admin_warn.php?d...&type=warnings
Referrer : http://mysite/admin/index.php?do=nav
IP Address : xxx xxxx ssss
Username : xxxxxx
Classname : vb_database

Any idea? I have just installed the warning system.

I'll appreciate any help.

Tayeb

Delphiprogrammi 08-11-2006 10:17 AM

Quote:

Originally Posted by Tayeb
Hello,

In Admin CP Statistics Warning per User I am getting the following error:

Database error in vBulletin 3.5.5:

Invalid SQL:
SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0;

MySQL Error : Unknown column 'warnings' in 'where clause'
Error Number : 1054
Date : Thursday, August 10th 2006 @ 10:47:21 PM
Script : http://mysite/admin/admin_warn.php?d...&type=warnings
Referrer : http://mysite/admin/index.php?do=nav
IP Address : xxx xxxx ssss
Username : xxxxxx
Classname : vb_database

Any idea? I have just installed the warning system.

I'll appreciate any help.

Tayeb

you do not have a warnings field in your user table

Code:

ALTER TABLE user ADD warnings INT(5) DEFAULT '0';
keep tableprefixes in mind ...

Delphiprogrammi 08-12-2006 09:44 AM

hi people,

Just to keep users informed here are 5 screengrabs where this system runs on 3.6.0(gold)

dutchbb 08-12-2006 06:11 PM

Ok, I uninstalled this product after the upgrade to vbulletin 3.6, now the uninstaller has removed tables from the new infractions system!

Ii think it's the table 'warnings' but I'm not sure what else got removed or changed :s Is there a way to restore this, do a re-upgrade to 3.6 to rebuild the tables or something?

dutchbb 08-12-2006 06:16 PM

I'm sorry the answer was already posted above my post, please ignore it.


All times are GMT. The time now is 01:40 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.02099 seconds
  • Memory Usage 1,746KB
  • 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