PDA

View Full Version : Administrative and Maintenance Tools - Advanced Warning System 3.6.7


Pages : 1 2 [3]

Bellardia
09-30-2007, 05:23 PM
What code causes the buttons/text for mods and admins to warn a user appear? I viewed a user's profile to test the new warning system and the link didn't appear. I viewed a post and the link didn't appear there either. I don't think I missed anything in the readme, but it very well could have happened. Everything else appears fine (for now), just need to be able to have these buttons appear. Otherwise, I can only view the user's options and perform a non-post related warning.

I thought I was just going crazy. Yeah, that's the same for me, the buttons don't show up. Not only that, but my vB is going nuts with a bunch of errors that disappear after I disable the AWS.

Delphiprogrammi
09-30-2007, 05:26 PM
What code causes the buttons/text for mods and admins to warn a user appear? I viewed a user's profile to test the new warning system and the link didn't appear. I viewed a post and the link didn't appear there either. I don't think I missed anything in the readme, but it very well could have happened. Everything else appears fine (for now), just need to be able to have these buttons appear. Otherwise, I can only view the user's options and perform a non-post related warning.

read this

jmurrayhead
09-30-2007, 05:50 PM
read this

Thanks for that, but it still doesn't display a link or button. I'm using a separate style other than vB's default, not sure if that is causing the problem. If you could point out what code will display the links/buttons, I'll see if I can figure it out.

(Times like these I wish I learned php, unfortunately I'm only a Classic ASP/ASP.Net programmer ;))

Bellardia
09-30-2007, 08:31 PM
I'm guessing AWS 3.6.9 isn't compatible with vB 3.6.8? Because I just installed a fresh new vBulletin and immediately installed AWS.

I get the

This post is a duplicate of a post that you have posted in the last five minutes. You will be redirected to that thread.

right away.

jmurrayhead
09-30-2007, 08:35 PM
I'm guessing AWS 3.6.9 isn't compatible with vB 3.6.8? Because I just installed a fresh new vBulletin and immediately installed AWS.

I get the

This post is a duplicate of a post that you have posted in the last five minutes. You will be redirected to that thread.

right away.

Strange, I have the same version and everything seems to work so far except for displaying the links to view warning and give warnings. These links don't appear in either the user profile or the post. However, I can see the Give Warning (Non-Post related) and View Warnings links from the User Options link.:confused:

Delphiprogrammi
10-01-2007, 04:38 AM
you still need to apply the fix i mentioned earlier and you have to add at least one warningtype of each kind before the links / buttons will show up (post related / non post related) also remember the tms system only works on templates that have custimized you will have to manually edit the templates for each style you use if you can't get this to work

Delphiprogrammi
10-01-2007, 04:40 AM
I'm guessing AWS 3.6.9 isn't compatible with vB 3.6.8? Because I just installed a fresh new vBulletin and immediately installed AWS.

I get the

This post is a duplicate of a post that you have posted in the last five minutes. You will be redirected to that thread.

right away.

No idea why it shows you that error :mad: it's do that in here on my board

jmurrayhead
10-01-2007, 12:00 PM
you still need to apply the fix i mentioned earlier and you have to add at least one warningtype of each kind before the links / buttons will show up (post related / non post related) also remember the tms system only works on templates that have custimized you will have to manually edit the templates for each style you use if you can't get this to work

I applied the fix as you suggested, but still no luck. I do have warnings of both types as well.

What I did notice, however, is that when I go to Admin CP -> VBulletin Options -> vBulletin Advanced Warning System and I scroll way to the bottom, where it says "Use textual links of buttons", it displays "Error" where the radio buttons would be.

So perhaps if I can get that fixed, then I will stop having these issues. But, when I go to Admin CP -> Advanced Warning System -> Manage Warning Options, the drop down box with Text/Button properly appears.

So it looks correct in one section (after the fix was applied) but not in the other.

Delphiprogrammi
10-02-2007, 08:32 PM
damn it looks like that tms system is causing more trouble then it offers advantages i will look into that

Delphiprogrammi
10-03-2007, 11:12 AM
hi folks,

I found the problem with the missing warning controls that is fixed and i will the update the package when i'm done updatig the instructions.

The tms system has been removed from this hack as it whas causing a lot more problems then advantages ... The downside is that you will have to manually edit each template(s) for all style(s) you use on your forum

bosal
10-05-2007, 11:29 AM
is this hack better than included in vb infraction system ?

jmurrayhead
10-08-2007, 02:40 PM
hi folks,

I found the problem with the missing warning controls that is fixed and i will the update the package when i'm done updatig the instructions.

The tms system has been removed from this hack as it whas causing a lot more problems then advantages ... The downside is that you will have to manually edit each template(s) for all style(s) you use on your forum

Cool, I'd like to begin using this since I went through all the work of modifying the templates. I'll keep checking back for the update. Thanks

Delphiprogrammi
10-10-2007, 10:05 PM
is this hack better than included in vb infraction system ?

No i just find it easier to work with but that's my personal opinion you can use both if you like doesn't make much sense but they will not conflict

Delphiprogrammi
10-10-2007, 10:06 PM
Cool, I'd like to begin using this since I went through all the work of modifying the templates. I'll keep checking back for the update. Thanks

The zip package has been updated

jmurrayhead
10-11-2007, 12:28 AM
The zip package has been updated


Thanks, mate! Everything seems to be working fine so far :up:

jmurrayhead
10-11-2007, 12:49 AM
Wait, found something...I set all of the "Additional Restrictions" to 2 warnings before avatars, signatures, etc begin to be cut off, and it cuts if off for everyone, regardless if they have warnings or not.

EDIT:

Just a request: currently, when you're using the AWS, it doesn't update the user's last activity. It states, "Unknown Location:" and then the URL. Perhaps you could make it say something like "Using Advanced Warning System" or something like that.

Magnumutz
10-14-2007, 10:47 AM
I also found a bug i could say... I've added the code in the postbit_legacy, to show the warned posts, but it doesn't show them.

This post was supposed to be warned, and i can't see it... if i remove this <if>, i can see ALL the posts like they were warned:
<if condition="$showwarnsignmgm==1">

http://haste-network.net/guild-hall-25/paranoia-5283.html#post30993

Delphiprogrammi
10-16-2007, 09:54 AM
you must choose who can see that in the settings

Delphiprogrammi
10-16-2007, 09:58 AM
Wait, found something...I set all of the "Additional Restrictions" to 2 warnings before avatars, signatures, etc begin to be cut off, and it cuts if off for everyone, regardless if they have warnings or not.

EDIT:

Just a request: currently, when you're using the AWS, it doesn't update the user's last activity. It states, "Unknown Location:" and then the URL. Perhaps you could make it say something like "Using Advanced Warning System" or something like that.

it should already do that


if($filename == 'Warn.php')
{
$userinfo['activity'] = 'warning_area';
}



if ($userinfo['activity'] == 'warning_area')
{
$userinfo['where'] = "<a href=\"Warn.php{$vbulletin->session->vars['sessionurl_q']}\">" . $vbphrase['aws_warning'] . "</a>";
$userinfo['action'] = $vbphrase['aws_usingaws'];
$handled = true;
}

jmurrayhead
10-16-2007, 07:50 PM
it should already do that


Where should that code be? I've attached what mine looks like.

McMendo
10-20-2007, 10:55 PM
Installed. Works great so far, after I managed to figure out things.

But it should be noticed that the install instructions are a mess and a little misguiding in the modification of templates. A couple of times it instructs you replace part of a text code that it had instructed you to add before. Then one time it tells you to search for a text code that is slightly different on 3.6.8.

Sorry that I didn't take note of the exact details. Too little sleep and too much work load this week.

Thank You

Bellardia
10-22-2007, 11:20 PM
When I updated to the newest version, it flushed my templates away.

However, in my old templates, I made it so that all users could view warnings and their comments.

Unfortunately, I wasn't the one who coded that part, and the person is no longer around.

Is it possible to revert back to before I installed this, or can you provide me with a code to allow ALL users to view warning details and not just Warnings on postbit?

Delphiprogrammi
10-24-2007, 07:44 AM
When I updated to the newest version, it flushed my templates away.

However, in my old templates, I made it so that all users could view warnings and their comments.

Unfortunately, I wasn't the one who coded that part, and the person is no longer around.

Is it possible to revert back to before I installed this, or can you provide me with a code to allow ALL users to view warning details and not just Warnings on postbit?

you can select that but warning details are restricted to mods and up you are however free to try and modify it yourself to suite your needs that's the advantage of open source.If you uninstall the product it will indeed wipe the templates and no there is no way back.You could simply remove the permissions checks from the templates and everyone will see it

Bellardia
10-24-2007, 04:23 PM
you can select that but warning details are restricted to mods and up you are however free to try and modify it yourself to suite your needs that's the advantage of open source.If you uninstall the product it will indeed wipe the templates and no there is no way back.You could simply remove the permissions checks from the templates and everyone will see it

Can you guide me on which permission checks to remove?

Delphiprogrammi
10-25-2007, 08:47 AM
Can you guide me on which permission checks to remove?

the warn_view... templates


<if condition="is_member_of($bbuserinfo, 5) OR is_member_of($bbuserinfo, 6) OR is_member_of($bbuserinfo, 7)">


a line like this indicates that the content is restricted to members from usergroupids 5,6,7

5=supermods
6= administrators
7 = mods

be carefull when removing / editing those lines you do not remove this line on the delete function because you don't want anybody being able to mark warnings as being inactive do you ?

wrestlepower
10-29-2007, 08:39 PM
getting an SQL error when trying to modify a user.

MySQL Error : Unknown column 'warn_notes' in 'field list'

Had look through the thread but cant see a fix posted for that yet.

Charuvils
10-30-2007, 10:07 AM
thx a lot man

Delphiprogrammi
10-30-2007, 04:51 PM
getting an SQL error when trying to modify a user.

MySQL Error : Unknown column 'warn_notes' in 'field list'


Had look through the thread but cant see a fix posted for that yet.


ALTER TABLE user ADD warn_notes SMALLINT DEFAULT '0';


keep table prefixes in mind if you have one for example if you table table prefix is "vb" the query becomes


ALTER TABLE vb_user ADD warn_notes SMALLINT DEFAULT '0';

under_takers
11-02-2007, 03:28 PM
well, i update this scripts and i face this error and get time by time error

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT w.*, wt.*, u.* FROM vb_warnings w
LEFT JOIN vb_warningype wt ON(wt.warningtypeid = w.warned_warning_id)
LEFT JOIN vb_user u ON(u.userid = w.warned_user) WHERE warned_status =
'L';

MySQL Error : Table 'ibp.vb_warningype' doesn't exist
Error Number : 1146
Date : Friday, November 2nd 2007 @ 07:59:35 AM
Script : http://www.xxxxxx-xxxx.com/vb/cron.php?rand=860392
Referrer : http://www.xxxx-xxxxx.com/vb/forumdisplay.php?f=19
IP Address : 58.186.205.61
Username : Unregistered
Classname : vb_database

Bellardia
11-11-2007, 12:07 AM
I've installed a completely clean board. Everything is fine until I warn someone :

This post is a duplicate of a post that you have posted in the last five minutes. You will be redirected to that thread.

I think the problem lies within the add-on and not anything else, because there simply isn't anything else. =\

ymy
11-15-2007, 01:58 PM
I want users read the moderators note in the post ?

Can I do this ?

Thanks

YmY

MDK-Indy
11-17-2007, 12:38 PM
Salü,

where i must insert the Code for the Buttons that i can Warn Users in the post at the vBulletin Project Tools?

Sorry for my english ;-)

greeting Indy

b00k
11-17-2007, 07:59 PM
-----------

Delphiprogrammi
11-18-2007, 09:51 AM
i have shutdown my website and my vBulletin licence is sold and pending for a Licence transfer to the new owner.

Feel free to take the code and modify it yourself that after all is the advantage of open source scripts.I no longer have a hosting account to test the changes i could make.

The vBulletin story has come to an end here for me

b00k
11-18-2007, 07:31 PM
-----------

jmurrayhead
11-20-2007, 09:52 PM
i have shutdown my website and my vBulletin licence is sold and pending for a Licence transfer to the new owner.

Feel free to take the code and modify it yourself that after all is the advantage of open source scripts.I no longer have a hosting account to test the changes i could make.

The vBulletin story has come to an end here for me

This is horrible news :(

tehPARADOX
11-20-2007, 09:59 PM
i have shutdown my website and my vBulletin licence is sold and pending for a Licence transfer to the new owner.

Feel free to take the code and modify it yourself that after all is the advantage of open source scripts.I no longer have a hosting account to test the changes i could make.

The vBulletin story has come to an end here for me

I hope another talented coder takes over this project because this mod is definitely very useful.

This is really bad news for me, since I heavily rely on your mod. Thanks for all your efforts.

ymy
11-22-2007, 06:30 PM
i have shutdown my website and my vBulletin licence is sold and pending for a Licence transfer to the new owner.

Feel free to take the code and modify it yourself that after all is the advantage of open source scripts.I no longer have a hosting account to test the changes i could make.

The vBulletin story has come to an end here for me


Really it`s bad news for me :(

YmY

GrandHolyKing
12-01-2007, 04:31 PM
Can anyone help me with this? I get this error in the main admincp

Fatal error: Call to undefined function: construct_nav_option() in /homepages/3/d225023830/htdocs/wsb4718874101/admincp/index.php on line 604

Any help at all would be greatly appreciated.

jmurrayhead
12-01-2007, 07:07 PM
hmm...now I'm having all sorts of bugs with this thing...can't protect groups, it doesn't work for custom moderator groups, parser errors left and right. I hope the person who takes over this project can fix it up, I'm probably going to have to uninstall it until then :(

onehost
12-01-2007, 08:27 PM
it would be nice if the coder placed a description of what AWS is, and what it does...warning system for what? Global World wide destruction? Warning tornado system?? it would be nice to know what it does....

jewropa
12-02-2007, 10:16 AM
it would be nice if the coder placed a description of what AWS is, and what it does...warning system for what? Global World wide destruction? Warning tornado system?? it would be nice to know what it does....

What do you think, what kind of warning system could it be? SPAM warning :)

marcjd
12-22-2007, 09:39 PM
Does anyone have this working with 3.7 beta 3? Thanks!

marcjd
12-29-2007, 05:35 PM
Just in case nobody saw this the first time...any conflicts with this working in 3.7 Beta 3?

I am on 3.6.4 right now and it takes a lot to update the forum and I don't have a lot of time...I just assume do it once and like all of the features in 3.7 and know my admins and mods would like them too. The only thing holding me back is this mod as they rely on it.

Thanks!

EdQ
01-15-2008, 05:16 AM
Time to uninstall and switch to the infraction system

gbox master
01-30-2008, 05:42 PM
i have like 1200 emails now
i just edit some settings in the admin pannel
now i get this error all the time

Database error in vBulletin 3.6.8: Invalid SQL:SELECT w.*, wt.*, u.* FROM warnings w LEFT JOIN warningype wt ON(wt.warningtypeid = w.warned_warning_id) LEFT JOIN user u ON(u.userid = w.warned_user) WHERE warned_status = 'L'; MySQL Error : Table 'vbb-dev.warningype' doesn't existError Number : 1146

gbox master
01-30-2008, 06:10 PM
ok i found this with the search funtion and i excecute it on my database

CREATE TABLE IF NOT EXISTS warningype (
warningtypeid INT(15) NOT NULL AUTO_INCREMENT,
title varCHAR(255) NOT NULL,
warn_points INT(15) NOT NULL DEFAULT '0',
warn_desc text NOT NULL,
warn_maturity INT(5),
warn_permban tinyint(1),
warn_type tinyint(3),
warn_alert tinyint(1),
warn_alertcomment MEDIUMTEXT,
PRIMARY KEY (warningtypeid));

the mails seem to stop now so thats looks good
however i did loose my trust in this modification
so maybe some one can give me my peace ofmind back by comment on this
and maybe some one can fx this mod

please look at the picture also
i find in the database some strange things
so maybe this is all based on 1 type error in the xml
and then tell me if i can delete the incorrect one please

tables
warningype
warningtype

Conner85
02-01-2008, 10:42 PM
I'm an admin at my site, but my mods pointed this out to me when they view a user's profile in the modcp..

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /modcp/user.php(352) : eval()'d code on line 3

I'll post a screen shot in a minute..

TheInsaneManiac
02-04-2008, 03:03 AM
Wow little too advanced for me =\.

DaFlameking
02-09-2008, 09:17 PM
At many other vbulletin forums, I see them having (Show ABC's Warnings) in the threads for each user and I can view warnings that were given to them as well.

How would I go about doing this. I already set "Who can view warnings" to all and registered users in the usergroup category. Ive even read previous posts from way back and havent gotten a clear cut response.

Any help?

comicus
02-26-2008, 01:13 AM
i take it this mod has been abandoned and is perma-broken for 3.6.8 users? very sad...this was very useful.

sv1cec
02-26-2008, 04:07 AM
The warningype table is not needed.

How would I go about doing this. I already set "Who can view warnings" to all and registered users in the usergroup category. Ive even read previous posts from way back and havent gotten a clear cut response.


If everything in the latest version is working like in my original hack, if you have the "Who can view warnings" set to "All", every post which has been entered by a member who has received a warning, should have the links or the buttons on top of it. Clicking on these buttons will show you the warnings/alerts that particular member has received. If you can't see them, let me know.

sbarbz
03-24-2008, 12:28 PM
There is possibility to do an intellect thatall a reason of warning by post Tihia possibility also not by post ?

sv1cec
03-24-2008, 01:09 PM
Yes, you can (well, you should be able to) issue warnings which are not post-related. From a user profile, you can issue non-post-related warnings. At least you could in the version I used to maintain. I do not think that this has been changed though.

marcjd
03-25-2008, 02:12 AM
Does anyone have this working successfully with 3.7? Thanks!

comicus
04-11-2008, 11:31 AM
Does anyone have this working successfully with 3.7? Thanks!

does anyone even have this working with 3.6.8* anymore? if so, please let me know. i definitely miss/need it!

OscarJohansson
04-26-2008, 07:16 AM
Great mod but I have a problem with the warnings. They don't seem to mature at all. How would I fix this?

A +5 points warning with the maturity of 5 would have expired after 5 days right? In this case it has not.

Currently running vb 3.6.9

SupermanInNY
05-03-2008, 12:50 AM
any porting to 3.7.0?

I'm still runnig 3.6.8, it works fine, but now the move to 3.7.0 should be a dramatic move.
any chance anyone is looking at it and releasing an updated version?

-Sup.

GoldenChaos
05-03-2008, 01:32 AM
It works fine in 3.7 Gold for me, although I think there's a problem with it auto-unbanning members. I haven't seen many issues with it, though, if any at all. It works with the new profile pages as well.

sv1cec
05-03-2008, 07:28 AM
Good to know. I may be forced to upgrade my site from 3.0.xx to 3.7 because of the CSRF vulnerability and my moderators would go berserk if they do not have the AWS.

GoldenChaos
05-04-2008, 02:14 PM
That vulnerability was fixed in 3.6.10, I believe, if you're reluctant to upgrade to 3.7.0.

Magnumutz
05-19-2008, 04:46 PM
Would be great if anyone could take-over this modification in the absence of the author and successfully port it into 3.7 and even improve it.

sv1cec
05-19-2008, 06:16 PM
I am reluctant to upgrade to anything. I do not need the extra functionality of newer releases, but I've been paying Jelsoft annual subscription because of one reason only: I wanted to be sure that in case a security issue was found, I would have the necessary fix for my site. I've been paying them all those years, just for that.

When this vulnerability was announced (and the vulnerability was fixed with vB 3.6.10 and vB 3.7) I contacted Jelsoft complaining about the fact that they didn't issue a security fix for 3.0. Guess what? Next day they announced the end of life of vB 3.0. So no more support. As if this was not a security issue but a simple bug fix. That's how Jelsoft treats its customers.

In any case, if I decide to upgrade my site to 3.7, I might work on AWS again. I'll need it for my site and over the years since I stopped working on it, I've improved it greatly. Unfortunately, this will take some time, since I need to first familiarize myself with the new coding acrhitecture of vB, as it has been implemented in vB 3.5 and later releases.

So folks, please do not hold your breath.

pedroenf
06-03-2008, 10:25 AM
Yes!! Can't wait for the release! :D

chennairam
06-29-2008, 10:00 AM
Good mood.. but any update for Vb 3.7.0 ? it s better good

sv1cec
06-29-2008, 02:35 PM
Sorry, not from my side. I still do not have a site with 3.7.x to start working on it.
If someone can provide me access to a test site with the latest release of vB, I could start working on this.

pnosko31
07-08-2008, 01:36 AM
I was looking over this mod as i was thinking of using it and discovered in mysql it creates a table called vb_warningtype and in the file in some spots it tries to use the database vb_warning_types - that may cause some problems you are having

sv1cec
07-08-2008, 04:40 AM
The Warning Types table should be named "warning_types". If it is created with "warningtypes" as a name, the hack will NOT work.

chennairam
08-03-2008, 09:05 AM
@sv1cec

contact me true yahoo messenger bro.... i will provide you test forum..

my yahoo messenger: maxie1172000..

sv1cec
08-05-2008, 05:59 AM
@sv1cec


contact me true yahoo messenger bro.... i will provide you test forum..

my yahoo messenger: maxie1172000..

Thank you. :)

I am currently on vacations, I'll contact you next week, when I'll return home.

jmurrayhead
08-17-2008, 12:06 PM
@sv1cec


contact me true yahoo messenger bro.... i will provide you test forum..

my yahoo messenger: maxie1172000..

Thank you! I was about to provide one myself :) This hack definitely needs to be updated for 3.7 I even had issues running it in 3.8. For example, I couldn't get custom moderator groups to be able to use in, only the default.

sv1cec
08-17-2008, 08:45 PM
Folks, I am back from vacation, but it would be impossible for me to do anything about this until the kids are back to school, which is around September 13, if I am not mistaken. If one of you can provide me with the test environment, I can start familiarizing myself with the new coding structure, until the kids are back to school and I have the tranquility to work on the actual AWS code. You can either PM me or email me with the details. Obviously I'll need admin and ftp access to the server.

Many thanks

jmurrayhead
08-18-2008, 09:16 PM
I've provided the test environment to sv1cec. Really looking forward to the finished product :)

sv1cec
08-18-2008, 10:03 PM
Thanks to Jmurrayhead, I have a working test environment. Don't hold your breath out though, as I said I have lots of thing to learn before I can come up with the code for AWS for vB 3.7.

Thanks Jmurrayhead, appreciated.

jmurrayhead
08-18-2008, 10:09 PM
Thanks to Jmurrayhead, I have a working test environment. Don't hold your breath out though, as I said I have lots of thing to learn before I can come up with the code for AWS for vB 3.7.

Thanks Jmurrayhead, appreciated.

You're very welcome!

students_forum
09-06-2008, 09:22 PM
I am looking forward to the 3.7.2 :D

Greek76
09-06-2008, 10:00 PM
I am waiting for this to.

Magnumutz
09-06-2008, 10:56 PM
Me 3.

gbox master
09-24-2008, 06:58 PM
i had it working once up on a time
but after a complete template revert and a new install i can't get it to work again

when i give the usergroups permisions then i get the databas error :
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderators',
`description` = '',
`usertitle` = 'Moderator',
`opentag` = '<font color=\"#00CC66\"><b>',
`closetag` = '</font></a></b>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`awspermissions` = '15',
`profileviewpermissions` = '0',
`forumpermissions` = '786431',
`genericpermissions` = '506404559',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '0',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`bumpthreadspermissions` = '0',
`bumpthreadslimit` = '0',
`ecdownloadpermissions` = '3871',
`ecexcludecatlist` = '',
`ecdownloadsmaxuploadtotal` = '-1',
`ecdownloadsmaxdailydl` = '-1',
`ecdownloadsmaxdailyfiles` = '-1',
`ecdownloaddelaygrp` = '-1'
WHERE usergroupid=7;

MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 1054
Date : Wednesday, September 24th 2008 @ 09:56:47 PM

maybe some one knows how to fix this ?
thnx

sv1cec
09-25-2008, 04:23 AM
I do not think that AWS is touching that table. Unless Delphi has added something I am not aware of, that doesn't come from AWS.

gbox master
09-25-2008, 09:35 PM
I do not think that AWS is touching that table. Unless Delphi has added something I am not aware of, that doesn't come from AWS.

so it could be that another modification causes this error ?
because i can install the mod
but when i give the moderator group or admin group the permissions i get this error

any help is apriciated in this matter

gbox master
09-25-2008, 09:51 PM
uninstalled some mods
deleted some xml files in the includes/xml
and now it works again

youre answer made me think :up:

sv1cec
09-26-2008, 04:34 AM
Sorry if I was not too specific, but I haven't touched the AWS code since vB 3.0.xx, but I know it doesn't touch the usergroup table.

SnapOff Racing
09-28-2008, 09:57 AM
another waiting for 3.7 release.

Magnumutz
09-30-2008, 09:23 PM
Delphiprogrammi has started being active again, let's hope he can update this wonderful mod !

jmurrayhead
09-30-2008, 11:00 PM
Delphiprogrammi has started being active again, let's hope he can update this wonderful mod !

I don't care if it's Delphiprogrammi or the original author...just as long as SOMEONE does it, I'll be happy! My mods really want this implemented...and so do I :)

Delphiprogrammi
10-02-2008, 12:47 PM
hi folks,

I have some spare over the weekend and i will install this on my 37.3 testboard and see what happens

jmurrayhead
10-02-2008, 01:18 PM
hi folks,

I have some spare over the weekend and i will install this on my 37.3 testboard and see what happens

Much appreciated :)

Delphiprogrammi
10-02-2008, 03:48 PM
hi,

Things i can see right.The profile stuff aws adds there will need a rewrite.Vbulletin changed the profile look between 3.6.x and 3.7.x allot so i will need to figure out how those tabs work.I also received a pm telling me that aws no longer autobans (doesn't work anymore) one more thing to be added is the CSRF protection.

Delphiprogrammi
10-03-2008, 11:55 AM
hi,

I received a report that autobanning does not work.I just checked and it is working please note the requirements for this feature

if you want to have a warning to cause a ban once issued you must assign the warningtype the same amount of points as your warning_limit then it should work

I have readed through the pages in this thread and i will check the protected usergroups and the unbanning (cron) feature(s)

please do not look at the content of my testpost :D :D

students_forum
10-04-2008, 07:19 PM
Delphiprogrammi has started being active again, let's hope he can update this wonderful mod !

cyber stalking I see ... you must be desperate!

jmurrayhead
10-06-2008, 05:27 PM
hi folks,

I have some spare over the weekend and i will install this on my 37.3 testboard and see what happens


Mr. Delphi, how was your weekend? Any progress? :D

Delphiprogrammi
10-06-2008, 05:55 PM
Mr. Delphi, how was your weekend? Any progress? :D

Yes the protected usergroups feature is indeed not working finding the problem cause will be quite impossible as that would require me to digg through more then 3800 lines of PHP code so this is not the news you all wanted to hear but i guess it's time for a switch to the vBulletin infraction system

jmurrayhead
10-06-2008, 06:08 PM
Yes the protected usergroups feature is indeed not working finding the problem cause will be quite impossible as that would require me to digg through more then 3800 lines of PHP code so this is not the news you all wanted to hear but i guess it's time for a switch to the vBulletin infraction system


This is horrible news... :(

Magnumutz
11-14-2008, 03:03 PM
Oh NO !!
Switching to the infraction system is such a great loss :(

sv1cec
11-14-2008, 04:17 PM
Delphi, welcome back.

The protected user groups should work fine, the check is made near the top of Warn.php in the function check_user. The function itself is located in functions_warning.php.

Delphiprogrammi
11-16-2008, 07:22 PM
hi,

I'll be honest here.I just cannot understand how the new profile pages work i mean there is some explanation here but it's still not clear to me and aws that ....

sv1cec
11-17-2008, 08:29 AM
Now you know why I hate the new coding scheme that vB is using these days?

Sorry buddy, I wish I could help. However, I think there are ways around it. Maybe you can add a block at the end of profile page with the warning buttons and the warning information. I do not know. It seems that vB is trying to make our lives more difficult, rather than facilitating coders.

tehPARADOX
01-05-2009, 11:07 PM
I was looking over this mod as i was thinking of using it and discovered in mysql it creates a table called vb_warningtype and in the file in some spots it tries to use the database vb_warning_types - that may cause some problems you are having

Can anyone possibly help me with this situation?

I have recently noticed old warnings are not getting removed automatically via Cron.

EDIT:
Manually executing the cron job: kill_warns, shows that warningype table doesn't exist. Looking over mysql, the table is named warningtype.

So I edited kill_warns.php:
LEFT JOIN " . TABLE_PREFIX . "warningype wt ON(wt.warningtypeid = w.warned_warning_id) to:
LEFT JOIN " . TABLE_PREFIX . "warningtype wt ON(wt.warningtypeid = w.warned_warning_id)

Tried running the cron again, this time I received the following error:
AWS - Kill warnings

Fatal error: Call to undefined function convert_array_to_bits() in /home/xxxxx/public_html/forum/includes/cron/kill_warns.php on line 114

Line 114 shows this code:
$user = array_merge($user,convert_array_to_bits($user['options'],$vbulletin->bf_misc_useroptions));

Any help would be appreciated.

sv1cec
01-06-2009, 03:40 PM
Unless DelphiProgramming has changed the names of the tables, the name for the Warning Types table should be "warning_types".

If that's not the case, I would suggest you contact Delphi.

As for the unvalid function call, at the top of the kill_warns.php file you have to see the following lines:


require_once('./global.php');
require_once('./includes/functions_user.php');
require_once('./includes/functions_newpost.php');
require_once('./includes/functions_warning.php');


Please note that this is from the old AWS (for vB 3.0.xx) I haven't worked on the code after that, Delphi has.


That part of the code you quote (the one with convert_array_to_bits) doesn't exist in my code.

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


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:

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


$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

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:
LEFT JOIN " . TABLE_PREFIX . "warningype wt ON(wt.warningtypeid = w.warned_warning_id)Replace with:
LEFT JOIN " . TABLE_PREFIX . "warningtype wt ON(wt.warningtypeid = w.warned_warning_id) 2. Line 114
Find:
$user = array_merge($user,convert_array_to_bits($user['options'],$vbulletin->bf_misc_useroptions));Replace with:
$user = array_merge((array)$user,convert_bits_to_array($us er['options'],$vbulletin->bf_misc_useroptions));3. Line 163
Find:
$warnerdata = $vbulletin->db->query_read("SELECT username, email FROM " . TABLE_PREFIX . "user WHERE userid = $vbulletin->options[warn_warner]");Replace with:
$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
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
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
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.

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