vb.org Archive - Administrative and Maintenance Tools

Page 16 of 16

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)

HossMon

01-07-2009 02:11 PM

I'm just upgrading my forums to v3.6 from 3.5 (not going to 3.7 just yet)
I had this installed and working on v3.5. After installing on 3.6 I now get this database error when selecting "Statistics - Warnings Per User" in the ACP

Quote:

Invalid SQL:
SELECT COUNT(*) AS users FROM user WHERE warns > 0 OR alerts > 0 OR warning_bans > 0;

MySQL Error : Unknown column 'warns' in 'where clause'

Any ideas?
As this is just a test upgrade and not my live board, I have time to work thru this problem, but...

sv1cec

01-07-2009 02:38 PM

Try changing that statement to:

Code:

SELECT COUNT(*) AS users FROM user WHERE warnings > 0 OR alerts > 0 OR warning_bans > 0;

HossMon

01-07-2009 04:03 PM

Should I run it as a query or thru PHPmyAdmin?
Also, if I'm reading correctly this is in the User table, correct?

HossMon

01-07-2009 04:12 PM

Actually after further examination I think I see the problem. Though what the "proper" solution is, I'm not so sure of.

From the AWS xml file there is this

Quote:

$install[] = "ALTER TABLE " . TABLE_PREFIX . "user
ADD COLUMN warns INT(5) DEFAULT '0',
ADD COLUMN warning_level INT(15) DEFAULT '0',
ADD COLUMN warning_bans INT(2) DEFAULT '0',
ADD COLUMN alerts INT(5) DEFAULT '0',
ADD COLUMN warn_notes SMALLINT DEFAULT '0'

However in my user table I have a column named warnings
But none named warns

Solved!
SHould anyone else run into this...
In phpmyadmin > select the user table > look for column named warns > tick the box and select/click the "change" operation > rename to warnings and save.

HossMon

01-08-2009 06:46 PM

Hey sv1cec if your around today.
I had all sorts of problems with this version. DB errors and way too many items to list. I'm not complaining, as I love AWS, but I uninstalled it and went back to the 3.5.4 version.
Which I did get to work using TMS and modifying a few of the template edits to work with vB 3.6.9

I have 1 problem that I've found so far. I'm getting the

Quote:

The administrator has not specified any groups that contain banned users.

Please do so using the usergroup editor.

Error in ACP when trying to "View Banned Users". Which after reading thru the 3.5.4 thread I never did see a way to resolve. Is there a solution?

And before I run off, I'd just like to say thanks to both you and Delphi for all the work you two have put into this mod! :tup:

sv1cec

01-08-2009 07:06 PM

Well, I am not sure, there is no such message in the code I've written. so I guess:

1. Make sure there is at least one banned users usergroup.
2. Make sure you enter that usergroup in the appropriate area in the Warning Options, in the Admin CP.

HossMon

01-09-2009 02:53 AM

Thanks John
As it turns out... as in an old thread by yourself that I read after posting this... The link in the ACP > AWS area does not work.
However, the lin in the ACP Users > View Banned Users does!
I can live with that. :D

Thanks again

sv1cec

01-09-2009 07:03 AM

See?! How bright of me to write new code for viewing banned users, when there was already a script doing it? LoRL.

Just go into your admincp and change the link, in the AWS menu to the one that the Users menu points to.

tehPARADOX

01-17-2009 12:42 PM

Does anybody have a working kill_warns script that actually removes matured warnings?

ViciousCode

01-18-2009 05:16 PM

is there a mod like this for 3.7x?

tehPARADOX

02-13-2009 04:03 AM

Edit #2: Nvm

tehPARADOX

08-23-2009 07:35 AM

Hi guys, it's me again.

This modification has always been semi-working on my 3.8+ installation. The only problem that I noticed is the cron job that is set to automatically remove expired warnings, wasn't doing it at all. The job would run, but the warnings weren't removed. Tried running manually and I noticed the first error. After I fixed that error, I encountered another error. And one more after that.

Since then I've been going through Admincp > Advanced Warning System > View Warnings Log. And removing the expired warnings individually. As you can tell, this is quite troublesome. But I diligently kept up with it for a year because I felt this modification was much more useful than the default infraction system.

Well anyways, I managed to be able to find and fix all the errors regarding the cron to successfully remove expired warnings like it should.

Open "kill_warns.php"

1. Line 45
Find:

Code:

LEFT JOIN " . TABLE_PREFIX . "warningype wt ON(wt.warningtypeid = w.warned_warning_id)

Replace with:

Code:

LEFT JOIN " . TABLE_PREFIX . "warningtype wt ON(wt.warningtypeid = w.warned_warning_id)

2. Line 114
Find:

Code:

$user = array_merge($user,convert_array_to_bits($user['options'],$vbulletin->bf_misc_useroptions));

Replace with:

Code:

$user = array_merge((array)$user,convert_bits_to_array($user['options'],$vbulletin->bf_misc_useroptions));

3. Line 163
Find:

Code:

                $warnerdata = $vbulletin->db->query_read("SELECT username, email FROM " . TABLE_PREFIX . "user WHERE userid = $vbulletin->options[warn_warner]");

Replace with:

Code:

                $warnerdata = $vbulletin->db->query_read("SELECT username, email FROM " . TABLE_PREFIX . "user WHERE userid = '{$vbulletin->options['warn_warner']}'");

maxie

09-02-2009 11:14 AM

Hope this mode will update into 3.8.x or 3.8.4

puddlove

03-25-2010 04:18 PM

Would it be at all possible for this to be updated to work on 3.8.4? Looks really useful.

puddlove

07-08-2012 03:27 PM

Quote:

Originally Posted by TSR (Post 1384589)

Delphiprogrammi, i tried reporting this to the site in the txt, it was down for me.
Here is 1 the 1 main error i have seen through some testing.

1) on warning, the site admin username shows up in the private message listing area. However, when you open the pm the selected hidden warner id appears correctly.
So again, in pm the correct hidden warner id is working, but if you view all the pms in your box, it shows who it came from.

If i remove the warning via admincp, the hidden warner id works in private message listing and in the private message.

* 2 images attached*

I'm having the same problem as TSR here. Apart from that, everything works fine.

If you warn a user, in the User CP PM area it shows the admin username rather than the username of the hidden warner account. When you click to read the actual PM, the hidden warner username is shown correctly as it should be. It's only in the main User CP PM area that the incorrect admin username is shown instead of the hidden warner account.

Anyone know how to fix this? It can be done - I managed to fix it 2 years ago to always show the hidden warner account in all areas. I think I edited the Warn.php file. But unfortunately, I can't remember how I did it, and I lost the edit. Someone please help! :(

Elixar

03-11-2014 11:30 PM

Any chance of this being upgraded to 4x? :)

ozzy47

03-11-2014 11:33 PM

Quote:

Originally Posted by Elixar (Post 2486556)

Any chance of this being upgraded to 4x? :)

Can't you use the infraction system to do this?

sv1cec

03-12-2014 09:12 AM

While I am not the author of this hack, I am the original author of the Advanced Warning System, back when vB was at 3.0.xx.

Believe me, the infractions system that vB currently has, leaves a lot to be desired, compared to AWS.

I have managed to implement most of the AWS features in vB 4.2.2, but I didn't spend the time to make it an installable hack. My moderators were all over me, when we moved from 3.0.xx to 4.2.xx, so I had to do my best to give them a working version of AWS. I also don't have the faintest idea of how to make an installable package. So yes, I have it working in 4.2.2 (at least 80% of the original hack) but no, I can't release any of it.

Sorry!

Delphiprogrammi

01-03-2015 06:38 PM

Hi,

Well this has not been ported because i thought everybody whas using the infraction system which is much more advanced.

I still have a /testvb/ where i can try things out i'm on 4.4.2 PL 3 not planning to go vb 5 .

I'm not promosing anything yet but i'll see what i can do i just didn't realize people where still using this .

I've had a quick look and there are a few things changed since vb 3.x.x

fetch_template calls must be replaced with the vB_Template class

the template syntax changed so all templates must be adjusted accordingly

sv1cec

01-04-2015 09:42 AM

Hey Erik, good to see you back here!

I have some templates that I can send you, in case you are interested in continuing the development of AWS. Just let me know.

As I said, I have it working on my site, but not in a condition I can release to the puclic.

Delphiprogrammi

01-04-2015 10:25 AM

Quote:

Originally Posted by sv1cec (Post 2530389)

Sure send those templates all help welcome.The templates in the download here will not work and to be honest the "new template syntax" confuses me

M.C.	02-10-2015 06:29 AM

well, 4.2 infraction is quite good, all I miss there is default messages for each infraction/warning level - that would be great have that feature there

and If AWS is better than vb I will definetly install it ;)

Thanks!

Delphiprogrammi

08-27-2015 01:29 PM

it is working but not as it should i hate to release work that is not done and working properly

All times are GMT. The time now is 08:36 PM.

Page 16 of 16

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01794 seconds Memory Usage 1,795KB 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 (7)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (23)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
Messages: