Advanced Warning System 3.6.7

[Delphiprogrammi]

Advaned Warning System

This is a port of aws (https://vborg.vbsupport.ru/showthread.php?t=95921) and i release this with permission...(yes i did ask the original author)

This version of the warning includes

1 vbulletin 3.6.x product file (XML)
1 admincp navigation XML
1 functions file(functions_warning.php)
3 images
3 cronjobs
1 modcp file to allow moderators to view warnings information without having to give admincp access(mod_warn.php)
1 admincp file to manage the system options(admin_warn.php)
1 XML to control permissions(bitfield_aws.xml)For a completer list of the system features you can refer to this (https://vborg.vbsupport.ru/showthread.php?p=574374)

This version will also require vbulletin 3.6.x to run.If you run 3.5.x or any other release then 3.6.x you will see a message.

This system is tested for a long time and i believe it's stable enough for a public release HOWEVER since this is a major hack and i'm just human please consider this first public run still as "beta"

instructions ow howto install can be found in the docs directory within the zip

statistics

25 plugins
27 templates
5 new MySQL tables
3 standard vbulletin tables alterd (user,post,and usergroup)
827 phrases
47 settingsupdates

A problem has been found where no link is provided to view your own warnings(normal users) in the member profile only i fixed this.To get the fix you will need to reedit your "MEMBERINFO" template and reimport product-aws.xml (set allow overwrite to yes)

15-9-2006
I moved the cron jobs from the install/uinstall code to the product file.
version check url now uses https://vborg.vbsupport.ru/misc.php?do=checkversion&t=124477

to upgrade read upgrade.txt in the docs directory

24-9-2006

a product depency whas added the system will no longer install on PHP 5 (in response to continued error reports on that PHP version)

to report a possible bug

please go the system bugtracker here (http://www.delphiprogramming.be/forums/project.php?do=issuelist&projectid=1)you can use the folowwing account

username:bugreporter
password:awsbug

no need to register yourself


30-11-2006
People on PHP 5 can follow this (https://vborg.vbsupport.ru/showpost.php?p=1123079&postcount=140) instructions to avoid the PHP version related error message BUT remember you are on your own if you do this.I won't upgrade my PHP until PHP 5 is there main stable release (www.php.net (http://www.php.net))


1-1-2007
A bug has been reported in the system.This bug whas causing vbulletin to throw an error when you try to use admincp => users=> add a new user


Fatal error: Call to a member function clean_gpc() on a non-object in class_dm_user.php(2385) : eval()'d code on line 35


Solution

Edit plugin "AWS:warn link in usermanager" and replace all code with this


$quicklinks["../Warn.php?" . $vbulletin->session->vars['sessionurl'] . "do=WarnUserNoPost&id=" . $vbulletin->GPC['userid']] = $vbphrase['aws_warn_user_admin'];


i'll update the package when i get home ;)


Another Bug is fixed

This release includes a fix for the problem "call to member function on a non object class_dm_user.php)" when you try to add a new user manaually (after submitting the form)

[kru89]

thanks.. first one to install.. the only problem is i can't see the buttons.. look at the attached file.. plz help.. otherwise.. good release!

[Shouzen]

dammit, I can;t install this, if someone can help me it would be apprecited.

[Delphiprogrammi]

thanks.. first one to install.. the only problem is i can't see the buttons.. look at the attached file.. plz help.. otherwise.. good release!

you are using normal textlinks.You can't see both at the same time.You need to make a choice buttons or normal links in the manageoptions page there's a setting that controls this

[Delphiprogrammi]

dammit, I can;t install this, if someone can help me it would be apprecited.

are you trying to install on 3.5.x ? that's impossible

[bashy]

I have just uninstalled this (well the 3.5 one) it worked ok after the upgrade, its just that there is the infraction system now so i didnt see a need for this.

does this differ much from the infraction system that is already built in?

[Delphiprogrammi]

I have just uninstalled this (well the 3.5 one) it worked ok after the upgrade, its just that there is the infraction system now so i didnt see a need for this.

does this differ much from the infraction system that is already built in?

the infraction system is much more complicated.I don't recommend using both as this can cause confusion.You need to make a choice here however installing this (for trying for example) will not mess things up.I have made sure this works completely independent

[Shouzen]

I dont know how to install it. I have a 3.6.0 version. I was wondering if someone can help me?

[bashy]

Cheers for thie info Delphi

Shouzen, there is or will be a readme in the zip file, please read the instructions.

If your new to installing hacks then perhaps you should try a lighter hack 1st to get the hang of things.....Please ALWAYS BACKUP your DATABASE before trying any hacks!!!

[jdk10]

If you use postbit_legacy can you only do the steps for postbit_legacy, or do you have to do both postbit and postbit_legacy steps?

[BETIServices]

Anyone has a list of rules for warnings etc? that we could use as example to start.

Thanks!

Excellent MOD ++++++a Plus +++++

Installed :D

[BETIServices]

o.k after sometime copying and pasting as it was advised it was only one thing I did not find and is as follow:

in template postbit_legacy find
<if condition="$show['reputation']"><div><if condition="$show['reppower']"><span id="reppower_$post[postid]_$post[userid]">$vbphrase[reppower]</span>: $post[reppower]</if><span id="repdisplay_$post[postid]_$post[userid]">$post[reputationdisplay]</span></div></if>
----------------------------------------------------------------------------------
below that
<!-- Show warning points -->
<if condition="$showpoints==1">
<if condition="$post[alerts]>0">
<font color="#ff0000">
<phrase 1="$post[alerts]">$vbphrase[aws_alerts]</phrase>
<font color="#000000">
</if>
<if condition="$post[warns]>0">
<font color="#ff0000">
<phrase 1="$post[warns]">$vbphrase[aws_warnings]</phrase>
<font color="#000000">
</if>
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<phrase 1="$post[warning_level]">$vbphrase[aws_warning_level]</phrase>
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<phrase 1="$post[warning_bans]">$vbphrase[aws_warning_bans]</phrase>
<font color="#000000">
</if>
</if>
<!-- End of show warning points -->

Please let me know if anyone has the same problem or is just me.

[Delphiprogrammi]

Anyone has a list of rules for warnings etc? that we could use as example to start.

Thanks!

Excellent MOD ++++++a Plus +++++

Installed :D


https://vborg.vbsupport.ru/attachment.php?attachmentid=21907&d=1101243281

[Delphiprogrammi]

o.k after sometime copying and pasting as it was advised it was only one thing I did not find and is as follow:

in template postbit_legacy find
<if condition="$show['reputation']"><div><if condition="$show['reppower']"><span id="reppower_$post[postid]_$post[userid]">$vbphrase[reppower]</span>: $post[reppower]</if><span id="repdisplay_$post[postid]_$post[userid]">$post[reputationdisplay]</span></div></if>
----------------------------------------------------------------------------------
below that
<!-- Show warning points -->
<if condition="$showpoints==1">
<if condition="$post[alerts]>0">
<font color="#ff0000">
<phrase 1="$post[alerts]">$vbphrase[aws_alerts]</phrase>
<font color="#000000">
</if>
<if condition="$post[warns]>0">
<font color="#ff0000">
<phrase 1="$post[warns]">$vbphrase[aws_warnings]</phrase>
<font color="#000000">
</if>
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<phrase 1="$post[warning_level]">$vbphrase[aws_warning_level]</phrase>
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<phrase 1="$post[warning_bans]">$vbphrase[aws_warning_bans]</phrase>
<font color="#000000">
</if>
</if>
<!-- End of show warning points -->

Please let me know if anyone has the same problem or is just me.

that code is there but its spread overal several line maybe it's just your editor search function that doesn't find it you could use one of the words like "reputation" to search for and see where you get

I just checked it.The code is there (line 85 on my postbit_legacy) but offcource you could have some other modifications in that template.However it is a little below the infractions stuff

[Snake]

Wow thanks a ton!

[outlaw621]

Been waiting on this. Thanks a bunch.

[GoTTi]

nice delphi -

that infraction system the new forum got is nothing compared to this still.

/me claps

[Mirage Guardian]

instructions ow howto install can be found in the docs directory within the zipSorry, but what about upgrading instructions?

I'm using AWS3.5.0 (with 17 Plugins, 107 Phrases, 26 Templates, 43 Settings)

So, is there any new features?

[apokphp]

I used this back on 3.5. But since using 3.6 I don't understand why this mod is still around. Am I missing out on somethin here?

What is the benefit of using the mod over vb's built in system other than what seems to be a couple different options (that don't seem to be all that important IMO) and the overall "look" of the system?

Is there a significant benefit? Better features?

[Delphiprogrammi]

Sorry, but what about upgrading instructions?

I'm using AWS3.5.0 (with 17 Plugins, 107 Phrases, 26 Templates, 43 Settings)

So, is there any new features?

it says in your profile you are running vbulletin 3.6.0 then it is impossible to use the 3.5.x version of this hack because that will mess up the database ....

admincp => products & plugins => add product => product-aws.xml

allow overwrite=> yes

[Mirage Guardian]

it says in your profile you are running vbulletin 3.6.0 then it is impossible to use the 3.5.x version of this hack because that will mess up the database ....I've upgrade to vB 3.6.0 from a vB 3.5.x and ?AWS? was installed on the old ver.
It is still working like fire without any problem.
Actually I LOVE ?AWS? that much to modify its files for translation (It takes a week to do it) and I?ll never replace it with the built-in infraction system. ?AWS? is much customizable.

about the upgrading, you said:admincp => products & plugins => add product => product-aws.xml
allow overwrite=> yesIs this will keep the current warnings database or would remove the old one?
In addition, what about template modifications? does it different from the old ver? or the old modifications will work fine?
I checked the new ver. And found that you did add many phrases (good work mate)
So, I think the template modifications won?t be the same all the way.
If you add a specific upgrading steps, that would be very helpful for people in my case.

Best Regards

[ymy]

thanks, Delphi-

nice job > I installed it and everything looks good .

Clicked install

[xtreme-mobile]

i cant see the buttons and cant see how many warning points people have got in the postbit thing

ive done the edits as posted before in this thread but nothing works

any ideas or is there instructions missing in zip? this is a clean install by the way :D

cheers

[Delphiprogrammi]

i cant see the buttons and cant see how many warning points people have got in the postbit thing

ive done the edits as posted before in this thread but nothing works

any ideas or is there instructions missing in zip? this is a clean install by the way :D

cheers

did you set the permissions ? also that information in the postbit and MEMBERINFO templates only show up if there values are greater then 0
and keep in mind admincp =>advanced warning system => manage warning options => viewing options =>Who can view the Warning Points and bans? this should be set to mod

[outlaw621]

I did notice that in order for ANY member to see there own warnings you have to set "Can View Warnings" in "aws(Advanced Warning System) Permissions " to yes for each usergroup. Is this correct or is it a bug?
Again, great product.

[Delphiprogrammi]

I've upgrade to vB 3.6.0 from a vB 3.5.x and “AWS” was installed on the old ver.
It is still working like fire without any problem.
Actually I LOVE “AWS” that much to modify its files for translation (It takes a week to do it) and I’ll never replace it with the built-in infraction system. “AWS” is much customizable.

about the upgrading, you said:Is this will keep the current warnings database or would remove the old one?
In addition, what about template modifications? does it different from the old ver? or the old modifications will work fine?
I checked the new ver. And found that you did add many phrases (good work mate)
So, I think the template modifications won’t be the same all the way.
If you add a specific upgrading steps, that would be very helpful for people in my case.

Best Regards

the zipfile is updated and there are instruction on howto upgrade an existing installation

[Delphiprogrammi]

I did notice that in order for ANY member to see there own warnings you have to set "Can View Warnings" in "aws(Advanced Warning System) Permissions " to yes for each usergroup. Is this correct or is it a bug?
Again, great product.

correct but you will not see anything if there are no warnings issued

[outlaw621]

Fantastic. Just wanted to make sure it was correct. Thanks for your quick reply.

[Delphiprogrammi]

Fantastic. Just wanted to make sure it was correct. Thanks for your quick reply.

Seems there is indeed a problem.If you login as a normal user (registerd without any special rights) a link should be provided to view your own warnings and this is missing.I just spotted this bug trying to fix it right now

problem found and fixed updating zip file ...

[rinkrat]

Great job!

[jian]

It doesn't work properly.

Whenever I try to change something in the admincp for a user, it gives.

Invalid SQL:
UPDATE vb3_user SET
### Bitfield: vb3_user.options ###
options = IF(options & 8, options - 8, options),
etc etc etc
MySQL Error : Unknown column 'warns' in 'field list'

[Delphiprogrammi]

It doesn't work properly.

Whenever I try to change something in the admincp for a user, it gives.

Invalid SQL:
UPDATE vb3_user SET
### Bitfield: vb3_user.options ###
options = IF(options & 8, options - 8, options),
etc etc etc
MySQL Error : Unknown column 'warns' in 'field list'

hmmmz your warns field is gone ?


ALTER TABLE vb3_user ADD COLUMN warns INT(5) DEFAULT '0';

[outlaw621]

Seems there is indeed a problem.If you login as a normal user (registerd without any special rights) a link should be provided to view your own warnings and this is missing.I just spotted this bug trying to fix it right now

problem found and fixed updating zip file ...

Thank you. Updated and will advise if there are any problems.

[sv1cec]

Hey Delphi, congratulations on this! Nice work!

From what I read, you also added some permission features, good! One thing I changed in my forum site, was that I made the name of the Automatic Warning variable. As you may remember, the old AWS required you to create a warning type called "ObsceneWords", for the automatic warnings. With a few changes, it is now up to the admin to decide how this warning type should be called.

Again, nice work buddy!

[Mirage Guardian]

I did the upgrade & the old warnings sill ok.
But I got this database error:
Database error in vBulletin 3.6.0:
Invalid SQL:
SELECT COUNT(*) AS users FROM user WHERE warns>0 OR alerts>0;
MySQL Error : Unknown column 'warns' in 'where clause'
Error Number : 1054
now what to do?

[Delphiprogrammi]

I did the upgrade & the old warnings sill ok.
But I got this database error:

now what to do?

you did not reimport the product xml.Wheter you set "allow overwrite to" yes or no my guess is that you didn't touched the products system.Because if you try to add a product that's already there (and allow overwrite is set to no) vbulletin will stop you.....

you need to run


ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';


and you should be up and running again.That error most likely occources when you click the statistics link (warings per user) in the admincp

[valuemdsupport]

Hi,

Can you please look into my problem. The problem is warnings and alerts aren't correct. When i deleted a warning or an alert, the warnings or the alerts didn't decrease. See the attachment, you'll understand my problem. So, can you please tell me how to fix this by myseft or wait for new updates from you.

Thanks.

[chipet]

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - $pagetitle</title>
$headinclude
</head>
<body>
$header
$navbar
<BR>
<if condition="$bbuserinfo[userid]=='0'">


<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" colspan="3">Guest - No Permissions</td>
</tr>
<tr>
<td class="thead">Unable To View</td>
</tr>
<tr>
<td class="alt1" colspan="1">$vbphrase[aws_nopermissions]</td>
</tr>
</table>
<br/>

<else />


$warn_page
<br />
</if>

$footer
</body>
</html>

This is the WARN style templet, whats wrong? Because I cant se the warn person text in the threads. :(
should it look like this in the 3.6.0 version?

[Delphiprogrammi]

Hi,

Can you please look into my problem. The problem is warnings and alerts aren't correct. When i deleted a warning or an alert, the warnings or the alerts didn't decrease. See the attachment, you'll understand my problem. So, can you please tell me how to fix this by myseft or wait for new updates from you.

Thanks.

can i ask ? when you deleted the warnings did you used the checkboxes and click the "complete removal" button or did you did you do it through the confirmation pages all one by one.Seems to be working ok here

[Delphiprogrammi]

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - $pagetitle</title>
$headinclude
</head>
<body>
$header
$navbar
<BR>
<if condition="$bbuserinfo[userid]=='0'">


<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" colspan="3">Guest - No Permissions</td>
</tr>
<tr>
<td class="thead">Unable To View</td>
</tr>
<tr>
<td class="alt1" colspan="1">$vbphrase[aws_nopermissions]</td>
</tr>
</table>
<br/>

<else />


$warn_page
<br />
</if>

$footer
</body>
</html>

This is the WARN style templet, whats wrong? Because I cant se the warn person text in the threads. :(
should it look like this in the 3.6.0 version?

you should only get that error when you are not logged in ... remember to set the proper permissions for each usergroup

[chipet]

you should only get that error when you are not logged in ... remember to set the proper permissions for each usergroup

The permissions are right, the admins do have it, but I cant see the warningstext :/
I do think its something with the style, because when I installed it, I got a message about take care of the warn styles, but i forgott it and took restore instead.

[phatguy88]

Would it be possible to implement a warn mod inside modcp? Say for instance you find a thread awaiting approval that is begging. Would it be possible to add a mod that instead of hitting delete, there is a line under it to warn the user. So you warn the user and delete the spam post at the same time, instead of manually going to the thread and warning the user then deleting it.

[Delphiprogrammi]

The permissions are right, the admins do have it, but I cant see the warningstext :/
I do think its something with the style, because when I installed it, I got a message about take care of the warn styles, but i forgott it and took restore instead.

you need to edit each and every style you have installed if you choose revert (it will remove the code and just use the vbulletin original)

[Delphiprogrammi]

Would it be possible to implement a warn mod inside modcp? Say for instance you find a thread awaiting approval that is begging. Would it be possible to add a mod that instead of hitting delete, there is a line under it to warn the user. So you warn the user and delete the spam post at the same time, instead of manually going to the thread and warning the user then deleting it.

that would be a nice thing to have i'm going to look at it and try

[phatguy88]

that would be a nice thing to have i'm going to look at it and try

thanks, it would help a lot.

[evofile]

hello, since i installed your hack me and my members can't see the signatures and avatars of all users. why?

[CORSO]

Hello i have this error:

Fatal error: Call to undefined function construct_warning_display() in /home/.../forum/includes/class_postbit.php(296) : eval()'d code on line 7

Some help?

[Delphiprogrammi]

Hello i have this error:

Fatal error: Call to undefined function construct_warning_display() in /home/.../forum/includes/class_postbit.php(296) : eval()'d code on line 7

Some help?

AWS does not use a function called construct_warning_display(); so i'm guessing that must be from some other hack you have installed ...

[CORSO]

Thanks a lot

[nir]

An error has occured, the following message has been left below: :

you do not have permissions to issue non post related warnings

???????

[Delphiprogrammi]

???????

what part of that error message is not clear to you ?

[sv1cec]

hello, since i installed your hack me and my members can't see the signatures and avatars of all users. why?

what are your settings for signature cut-off and avatar cut-off limits? Make sure they are set to something higher than zero.

Delphi, I am not sure what's the default action if those limits are not set by the admin. You may want to check this out, i.e. make sure that if those limits are not set, then they do not affect the postbit display.

[phatguy88]

Originally Posted by phatguy88
Would it be possible to implement a warn mod inside modcp? Say for instance you find a thread awaiting approval that is begging. Would it be possible to add a mod that instead of hitting delete, there is a line under it to warn the user. So you warn the user and delete the spam post at the same time, instead of manually going to the thread and warning the user then deleting it.

that would be a nice thing to have i'm going to look at it and try

any luck? https://vborg.vbsupport.ru/

[Delphiprogrammi]

what are your settings for signature cut-off and avatar cut-off limits? Make sure they are set to something higher than zero.

Delphi, I am not sure what's the default action if those limits are not set by the admin. You may want to check this out, i.e. make sure that if those limits are not set, then they do not affect the postbit display.

there default setting is 0 so that features will be disabled

[Delphiprogrammi]

any luck? http://forums.offtopic.com/images/smilies/wiggle.gif

i did try but it didn't worked as i exspected maybe a link "warn user" in the modcp should be a help to ... my templates are all messed up :confused: i do use a testboard so that isn't a real problem.

that stuff is not templated it is within the /modcp/moderation.php and there isn't a hook for it either (at least i can't find one) how about a button nexto ignore "warn user" (or something like that) look at the two screenshots

[phatguy88]

A button would be awesome. Warn the user then get redirected back to the post/thread awaiting moderation.

Edit: CRAP I just realized my board uses vb 3.5, not 3.6. Will your method still work?

[valuemdsupport]

can i ask ? when you deleted the warnings did you used the checkboxes and click the "complete removal" button or did you did you do it through the confirmation pages all one by one.Seems to be working ok hereOh, yeah. Thanks. But can you please provide us some maintenance tools to help us rebuild users' warns, alerts,.... in user profiles and update banlist also. I think i'm having problem with user banning. Some of my users should have been automatically banned for 7 days for reaching 3 warnings but it doesn't work properly.

Any helps would be appreciate. Thanks in advance.

[chipet]

So.. I want to warn this guy for reasons only swedish speakers may hope to understand.. (actually, not, but just took screencap to illustrate the obvious lack of AWS links), and well, since they aren't there, how do I get them back there?

You may also wish to fear my awesome skills of arrow-drawing in photoshop.

[Mirage Guardian]

Everything is working OK now, I just wanna say ?Thanks?

if you have time, I?ll report something it may help:

- The Avatars / Signatures don?t appear after the hack because of this condition: <if condition="$post['signature'] AND (($vboptions[warn_sig_thresshold]<0 AND $post[warning_level]>=$vboptions[warn_sig_thresshold]) OR $vboptions[warn_sig_thresshold]==0)">
I?ve modify it to: <if condition="$post['signature'] AND ($vboptions[warn_sig_thresshold]<=0 OR $post[warning_level] < $vboptions[warn_sig_thresshold])">and I did the same with the Avatar condition syntax

- When I was translating the phrases, I found that you are using about 3 variables for same phrase. I think you may reduce them.
Ex: aws_user_warnings_total, aws_warnings, aws_warnings_member_profile and aws_total_warnings_profile are the same phrase

At last, AWS was such an awesome Professional hack. and you make it much easier to use and customize
Thank you both sv1cec & Delphiprogrammi

Best Regards

[sv1cec]

Heh professional? It was my first attempt at learning php and vB. Delphi may be more worth of that compliment than I am.

[Delphiprogrammi]

So.. I want to warn this guy for reasons only swedish speakers may hope to understand.. (actually, not, but just took screencap to illustrate the obvious lack of AWS links), and well, since they aren't there, how do I get them back there?

You may also wish to fear my awesome skills of arrow-drawing in photoshop.

yeah nice drawing skills .That looks like a custom vbulletin style.You have to edit the template from each style you have installed ... in order for the system to work.There used to be a hack which could copy templates from one style to another but it doesn't work with 3.6.x

[Delphiprogrammi]

A button would be awesome. Warn the user then get redirected back to the post/thread awaiting moderation.

Edit: CRAP I just realized my board uses vb 3.5, not 3.6. Will your method still work?

nope

[Delphiprogrammi]

Oh, yeah. Thanks. But can you please provide us some maintenance tools to help us rebuild users' warns, alerts,.... in user profiles and update banlist also. I think i'm having problem with user banning. Some of my users should have been automatically banned for 7 days for reaching 3 warnings but it doesn't work properly.

Any helps would be appreciate. Thanks in advance.

yes the system should ban when the limit is reached hmmmz that seemsto work fine in here in my testboard i will have another look

[chipet]

yeah nice drawing skills .That looks like a custom vbulletin style.You have to edit the template from each style you have installed ... in order for the system to work.There used to be a hack which could copy templates from one style to another but it doesn't work with 3.6.x

Could you tell me what edits I would need to make for it to work? Do you need the code from my custom template for that?

[Delphiprogrammi]

Could you tell me what edits I would need to make for it to work? Do you need the code from my custom template for that?

those instrunction are in the zip it's the same for all styles you have installed.For the warning controls to showup in the postbits you would need to edit postbit and postbit_legacy

[outlaw621]

Just noticed a small bug (not sure if it is a bug or just on my end). When you click Warn User in the AdminCP you are given the option to search by UserID or name. If you select to search by name you get the "Admin Hash Mismatch" error on a white background.

[SportsZone]

Just noticed a small bug (not sure if it is a bug or just on my end). When you click Warn User in the AdminCP you are given the option to search by UserID or name. If you select to search by name you get the "Admin Hash Mismatch" error on a white background.

I got the same problem. I just reuploaded/overwrote all files and it worked.

[Delphiprogrammi]

Just noticed a small bug (not sure if it is a bug or just on my end). When you click Warn User in the AdminCP you are given the option to search by UserID or name. If you select to search by name you get the "Admin Hash Mismatch" error on a white background.

that's indeed a bug and not on your end.In 3.6.x you need to define the "ADMINHASH" property with forms in the admincp if it is missing or not correct vbulletin throws that error

Confirmed bug and fixed to


Updating the zip package now


The zip package is updated you only need to replace /admincp/admin_warn.php to apply the fix

[valuemdsupport]

yes the system should ban when the limit is reached hmmmz that seemsto work fine in here in my testboard i will have another lookOk, i'm waiting for you :). Thank you very much.

[Delphiprogrammi]

Ok, i'm waiting for you :). Thank you very much.

that seem to work correct in here.If a try it my "testuser" get's temporary banned look at your /includes/functions_warning.php after


//################################################## ################################################## ###########
// Check if we have a ban condition, i.e. points greater than ban limit, or warnings greater than warnings limit.
//################################################## ################################################## ###########


what code you have there ?

[chipet]

Where can I reset the Warning levels?
The Warninglevel has a text under the avatar when you are posting, and I wants to reset it to zero :p

[seg]

Hi,
I recently upgraded to vb 3.6.0 and now upgraded from an old AWS release to AWS 3.6.0. I am seeing two problems immediately. With my Administrator account, when I try to warn a regular user or add a note to the user's account I get this message:

An error has occured, the following message has been left below: :
You have no permissions to issue warnings

I also visited vBulletin Options -> Warning Hack -> Aws Version and it is reporting 3.5.0. When I visit my Product Manager and do a version check it reports 3.6.0 (there is no 3.5.0 at all).

Do you have any ideas how to resolve these two problems?

Thanks for moving this to 3.6.0, I like this product better than the infraction system ;)

[Delphiprogrammi]

Where can I reset the Warning levels?
The Warninglevel has a text under the avatar when you are posting, and I wants to reset it to zero :p

impossible you will only see something there if those values are greater then 0

[Delphiprogrammi]

Hi,
I recently upgraded to vb 3.6.0 and now upgraded from an old AWS release to AWS 3.6.0. I am seeing two problems immediately. With my Administrator account, when I try to warn a regular user or add a note to the user's account I get this message:

An error has occured, the following message has been left below: :
You have no permissions to issue warnings

I also visited vBulletin Options -> Warning Hack -> Aws Version and it is reporting 3.5.0. When I visit my Product Manager and do a version check it reports 3.6.0 (there is no 3.5.0 at all).

Do you have any ideas how to resolve these two problems?

Thanks for moving this to 3.6.0, I like this product better than the infraction system ;)

you did not set permissions .... usergroups => edit and for the versionnumber hmmz did you used the correct product ?


<setting varname="warn_version" displayorder="44">
<datatype>free</datatype>
<defaultvalue>3.6.0</defaultvalue>
</setting>

is in my product file

[chipet]

impossible you will only see something there if those values are greater then 0

yeah, but we reinstalled the aws system, and all the warnings disappeard, but the counter still ticking, so one person have 15 warnings, but they are deleted :(

[seg]

you did not set permissions .... usergroups => edit and for the versionnumber hmmz did you used the correct product ?

My installed products show version 3.6.0 - it is only the vBulletin options that shows 3.5.0 - to tell you the truth, I never had version 3.5.0 installed. Where would vBulletin options be pulling this from?

Thank you about the permissions reminder - I assumed that they remained the same, but I should never assume. For option "Can View Warnings" - are these the warnings that appear in the profile or are these the detailed warnings with descriptions. I only want other members to see the number of Alerts/Warnings/Bans.

[Delphiprogrammi]

yeah, but we reinstalled the aws system, and all the warnings disappeard, but the counter still ticking, so one person have 15 warnings, but they are deleted :(

then you could edit it under the usermanager there is a column warnings information set those values all to 0 and submit the form (you will have to do that for each user through)

[Luggruff]

then you could edit it under the usermanager there is a column warnings information set those values all to 0 and submit the form (you will have to do that for each user through)
Yeah, for 1500 users. Especially when it won't let you update the userprofiles anymore.
Error as following:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE user SET
### Bitfield: user.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 16, options, options + 16),
options = IF(options & 256, options - 256, options),
options = IF(options & 512, options - 512, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options - 4096, options),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 4, options, options + 4),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options - 128, options),
options = IF(options & 32768, options - 32768, options),
### Bitfield: user.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = 'c.\")',
customtitle = 2,
username = 'woicer',
email = 'woicer@crackinggear.net',
languageid = 2,
homepage = 'http://www.habbohotel.se',
birthday_search = '0000-01-01',
birthday = '01-01-0000',
showbirthday = 1,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
referrerid = 0,
ipaddress = '',
posts = 2270,
alerts = 0,
warns = 0,
warning_level = 0,
warning_bans = 0,
isstaffrank = '0',
staffrank = '',
staffrank_opentag = '',
staffrank_closetag = '',
usergroupid = 5,
reputationlevelid = 7,
reputation = 88,
warnings = 0,
infractions = 0,
ipoints = 0,
pmpopup = 0,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 2,
styleid = 0,
timezoneoffset = '2',
daysprune = 0,
joindate = 1108033200,
lastactivity = 1157998800,
lastpost = 1157952060,
membergroupids = ''
WHERE userid = 632;

MySQL Error : Unknown column 'warns' in 'field list'
Error Number : 1054
Date : Monday, September 11th 2006 @ 02:42:28 PM
Script : http://www.hlforum.org/admcp/user.php?do=update
Referrer : http://www.hlforum.org/admcp/user.php?do=edit&u=632
IP Address : 81.235.17.12
Username : Luggruff
Classname : vb_database

A solution is needed. And fast?

[Delphiprogrammi]

Yeah, for 1500 users. Especially when it won't let you update the userprofiles anymore.
Error as following:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE user SET
### Bitfield: user.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 16, options, options + 16),
options = IF(options & 256, options - 256, options),
options = IF(options & 512, options - 512, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options - 4096, options),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 4, options, options + 4),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options - 128, options),
options = IF(options & 32768, options - 32768, options),
### Bitfield: user.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = 'c.\")',
customtitle = 2,
username = 'woicer',
email = 'woicer@crackinggear.net',
languageid = 2,
homepage = 'http://www.habbohotel.se',
birthday_search = '0000-01-01',
birthday = '01-01-0000',
showbirthday = 1,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
referrerid = 0,
ipaddress = '',
posts = 2270,
alerts = 0,
warns = 0,
warning_level = 0,
warning_bans = 0,
isstaffrank = '0',
staffrank = '',
staffrank_opentag = '',
staffrank_closetag = '',
usergroupid = 5,
reputationlevelid = 7,
reputation = 88,
warnings = 0,
infractions = 0,
ipoints = 0,
pmpopup = 0,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 2,
styleid = 0,
timezoneoffset = '2',
daysprune = 0,
joindate = 1108033200,
lastactivity = 1157998800,
lastpost = 1157952060,
membergroupids = ''
WHERE userid = 632;

MySQL Error : Unknown column 'warns' in 'field list'
Error Number : 1054
Date : Monday, September 11th 2006 @ 02:42:28 PM
Script : http://www.hlforum.org/admcp/user.php?do=update
Referrer : http://www.hlforum.org/admcp/user.php?do=edit&u=632
IP Address : 81.235.17.12
Username : Luggruff
Classname : vb_database

A solution is needed. And fast?


ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';
UPDATE user SET warning_level=0,warns=0;


the first query will add the missing warns field (the errormessage problem) the second query will reset the warning_level and warns fields to 0 FOR ALL users

[Luggruff]

ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';
UPDATE user SET warning_level=0,warns=0;

the first query will add the missing warns field (the errormessage problem) the second query will reset the warning_level and warns fields to 0 FOR ALL users

Thank you! (:

And another thing, how come the whole second table-row in the postbit (for notes) is not accessable from the postbit template? I was just about to re-style the whole thing and I couln't reach that row, due to the fact that it is embedded in $pnotes. Where can I find it? And why make it so complicated for designers?

[Delphiprogrammi]

Thank you! (:

And another thing, how come the whole second table-row in the postbit (for notes) is not accessable from the postbit template? I was just about to re-style the whole thing and I couln't reach that row, due to the fact that it is embedded in $pnotes. Where can I find it? And why make it so complicated for designers?

$pnotes are the warn_notes they are embedded into the product (they can be disabled in the settings) you must edit both templates postbit and postbit_legacy if you want them to appaer

[badshah]

how do I add a warning.
I am trying to warn someone but there is nothing to select in "Warning Selection"
I see the attachement https://vborg.vbsupport.ru/attachment.php?attachmentid=21907&d=1101243281 but how do I add them in the "Warning selection"
Thanks

[Luggruff]

<a href="http://www.vbulletin.com/forum/showthread.php?p=1209982" target="_blank">http://www.vbulletin.com/forum/showthread.php?p=1209982</a>

anyone with a clue??
(concerns AWS)

[Delphiprogrammi]

how do I add a warning.
I am trying to warn someone but there is nothing to select in "Warning Selection"
I see the attachement https://vborg.vbsupport.ru/attachment.php?attachmentid=21907&d=1101243281 but how do I add them in the "Warning selection"
Thanks

admincp => advanced Warning System => manage warning types add at least one(1) non post related ...

[Delphiprogrammi]

http://www.vbulletin.com/forum/showthread.php?p=1209982

anyone with a clue??
(concerns AWS)

that's not true AWS does not interfere with infractions

[Luggruff]

that's not true AWS does not interfere with infractions

Looks like you are wrong:
http://www.vbulletin.com/forum/showpost.php?p=1210882&postcount=20

[seg]

I found that a user's warning level was not lowering after 60 day (the maturity date I set. I checked the users account and found that the warning level was at 5, but the warnings were blank (no number). When I tried to correct the issue I received the following db error:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE forumuser SET
### Bitfield: forumuser.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 16, options, options + 16),
options = IF(options & 256, options, options + 256),
options = IF(options & 512, options, options + 512),
options = IF(options & 32, options - 32, options),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options - 4096, options),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 4, options, options + 4),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options - 128, options),
options = IF(options & 32768, options - 32768, options),
### Bitfield: forumuser.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = 'Member',
customtitle = 0,
username = 'private',
email = 'private',
languageid = 0,
homepage = '',
birthday_search = 'private',
birthday = 'private',
showbirthday = 0,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
referrerid = 0,
ipaddress = 'private',
posts = 192,
alerts = 1,
warns = 6,
warning_level = 0,
warning_bans = 0,
usergroupid = 2,
reputationlevelid = 5,
reputation = 10,
warnings = 6,
infractions = 0,
ipoints = 0,
pmpopup = 0,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 1,
styleid = 0,
timezoneoffset = '-8',
daysprune = 0,
joindate = 1140481140,
lastactivity = 1158105360,
lastpost = 1158104940,
membergroupids = '',
genpermoverride = 536870911,
adminignore = ''
WHERE userid = 1283;

MySQL Error : Unknown column 'warns' in 'field list'
Error Number : 1054

I marked private on some of the user's info. What can I do to repair this problem? Do I go directly into MySQL and add the warns amount?

[seg]

I am getting the above error message when ever I try to save anything for any person in the User Manager. Could this be related to the 3.5.0 issue I mentioned earlier (below)? From the above error message does it look like the db tables for the warning system didn't update?

My installed products show version 3.6.0 - it is only the vBulletin options that shows 3.5.0 - to tell you the truth, I never had version 3.5.0 installed. Where would vBulletin options be pulling this from?

Thank you about the permissions reminder - I assumed that they remained the same, but I should never assume. For option "Can View Warnings" - are these the warnings that appear in the profile or are these the detailed warnings with descriptions. I only want other members to see the number of Alerts/Warnings/Bans.

[Delphiprogrammi]

Looks like you are wrong:
http://www.vbulletin.com/forum/showpost.php?p=1210882&postcount=20

nope

infractions working fine .....

[Delphiprogrammi]

I found that a user's warning level was not lowering after 60 day (the maturity date I set. I checked the users account and found that the warning level was at 5, but the warnings were blank (no number). When I tried to correct the issue I received the following db error:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE forumuser SET
### Bitfield: forumuser.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 16, options, options + 16),
options = IF(options & 256, options, options + 256),
options = IF(options & 512, options, options + 512),
options = IF(options & 32, options - 32, options),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options - 4096, options),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 4, options, options + 4),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options - 128, options),
options = IF(options & 32768, options - 32768, options),
### Bitfield: forumuser.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = 'Member',
customtitle = 0,
username = 'private',
email = 'private',
languageid = 0,
homepage = '',
birthday_search = 'private',
birthday = 'private',
showbirthday = 0,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
referrerid = 0,
ipaddress = 'private',
posts = 192,
alerts = 1,
warns = 6,
warning_level = 0,
warning_bans = 0,
usergroupid = 2,
reputationlevelid = 5,
reputation = 10,
warnings = 6,
infractions = 0,
ipoints = 0,
pmpopup = 0,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 1,
styleid = 0,
timezoneoffset = '-8',
daysprune = 0,
joindate = 1140481140,
lastactivity = 1158105360,
lastpost = 1158104940,
membergroupids = '',
genpermoverride = 536870911,
adminignore = ''
WHERE userid = 1283;

MySQL Error : Unknown column 'warns' in 'field list'
Error Number : 1054

I marked private on some of the user's info. What can I do to repair this problem? Do I go directly into MySQL and add the warns amount?

hmmmz since more users complain about this type of errors i need to check the system.why on earth is your warns field missing ????


ALTER TABLE forumuser ADD COLUMN warns INT(5) DEFAULT '0';


i will check that

[Delphiprogrammi]

I am getting the above error message when ever I try to save anything for any person in the User Manager. Could this be related to the 3.5.0 issue I mentioned earlier (below)? From the above error message does it look like the db tables for the warning system didn't update?

normal users can't see anything besides there own warnings (mod and up can see all (if you allow them you can also choose to restrict mods so they can only see warnings they issued themself)

[seg]

normal users can't see anything besides there own warnings (mod and up can see all (if you allow them you can also choose to restrict mods so they can only see warnings they issued themself)

??? :confused:
Was that in response to me?

[seg]

Let me know if I can be of any help in duplicating the error. Right now I can't make any changes to anyones account or warn anyone because of this error. I am going to try to re-upload 3.6.0 files and reinstall the xml file.

hmmmz since more users complain about this type of errors i need to check the system.why on earth is your warns field missing ????


ALTER TABLE forumuser ADD COLUMN warns INT(5) DEFAULT '0';


i will check that

[seg]

I removed all the aws files and re-uploaded the files from a new download of the aws 3.6.0 zip file. I also reimported the xml file and enabled overwrite. Didn't fix my problem. I also went into vBulletin Options and the version still reported 3.5.0. I noticed that this filed could be edited so I changed 3.5.0 to 3.6.0 and clicked save.

Let me know when you figure out the warn field issue. Thanks!

[Delphiprogrammi]

I removed all the aws files and re-uploaded the files from a new download of the aws 3.6.0 zip file. I also reimported the xml file and enabled overwrite. Didn't fix my problem. I also went into vBulletin Options and the version still reported 3.5.0. I noticed that this filed could be edited so I changed 3.5.0 to 3.6.0 and clicked save.

Let me know when you figure out the warn field issue. Thanks!

i have been busy with testing this.The warns field is there every time i install .... I have no idea why yours disappaerd if with database errors on there is no error message

That version number is 3.6.0 by default are you installing the 3.5.x port ? that should be impossible

[UZFRED]

Well since vBulletin 3.6.0 has this sort of "warning system" I won't be using this any more.

However it was very useful to me until. Don't think this will be much used by 3.6.0 users.

[seg]

If it is helpful I can give you access to our message board. Feel free to PM me if this would help.

Otherwise, is there a command I can give the database to set everything up correctly?

i have been busy with testing this.The warns field is there every time i install .... I have no idea why yours disappaerd if with database errors on there is no error message

That version number is 3.6.0 by default are you installing the 3.5.x port ? that should be impossible

[seg]

If it is helpful I can give you access to our message board. Feel free to PM me if this would help.

Otherwise, is there a command I can give the database to set everything up correctly?

Not sure if this makes a difference. We are running PHP 5.1.4 - has this mod/upgrade been tested on PHP 5?

[Delphiprogrammi]

Not sure if this makes a difference. We are running PHP 5.1.4 - has this mod/upgrade been tested on PHP 5?

No i don't have php 5 availible to test it on.I used to be on a dedicated server however that became a little costly so a while back i downgraded back to shared hosting.And yes it is possible your problem is caused by php 5

[puertoblack2003]

beautiful hack love it.Installed..Is there a solution About the avatar i read members talking about it but no one answered...my members wants the avatar to show...but i'll wait for the answer:surprised:

[Delphiprogrammi]

beautiful hack love it.Installed..Is there a solution About the avatar i read members talking about it but no one answered...my members wants the avatar to show...but i'll wait for the answer:surprised:

if you want to ALWAYS allow members to keep there avatar simply set the avatar cut off setting to 0 (zero) and submit the form.This setting is under the "additional restrictions" header in the manage warning options page

[Delphiprogrammi]

no more issues for over a week i have taken away the beta tag ooh well issues i'm able to reproduce anyway i mean.

[wrestlepower]

hi, when i try to manage the warning types, i get the following DB error:

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Saturday, September 23rd 2006 @ 07:25:15 PM
Script : http://www.wrestlepower.net/admincp/admin_warn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database


EDIT: Just noticed i also get a DB error when i try to update a user profile as well. I've uninstalled and re-installed to no avail. Its the same one that has been reported earlier.


Any ideas?

[Delphiprogrammi]

hi, when i try to manage the warning types, i get the following DB error:

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Saturday, September 23rd 2006 @ 07:25:15 PM
Script : http://www.wrestlepower.net/admincp/admin_warn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database


EDIT: Just noticed i also get a DB error when i try to update a user profile as well. I've uninstalled and re-installed to no avail. Its the same one that has been reported earlier.


Any ideas?


ALTER TABLE warning_types ADD COLUM warning_maturity INT(5);
ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';


are you uising by any chance PHP 5 ?

[wrestlepower]

nope, 4.4.2 acording to my cpanelx.

Also, dont mean to be rude, but what does that code box actually mean? A lot of the guys asking for help are going to be n00bs like myself, and that means nothing to me. Where do i add the code? do i replace something with that code?

[V3RT1G0]

thx... very nice hack to have!

[Delphiprogrammi]

nope, 4.4.2 acording to my cpanelx.

Also, dont mean to be rude, but what does that code box actually mean? A lot of the guys asking for help are going to be n00bs like myself, and that means nothing to me. Where do i add the code? do i replace something with that code?

That's SQL code that would "maually" add the things missing (your error messages)todo this you will need to open phpMyAdmin select te database you use hit the "SQL" link paste the code into the textbox and hit go.After that you should get a message like "your query has been excuted successfully"


ALTER TABLE warning_types ADD COLUM warning_maturity INT(5);
ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';

[valuemdsupport]

Hi Delphiprogrammi,

In this new version, the cron jobs are just deactivating warnings? The users will still see that inactive warnings and i have to remove them from admincp completely if i don't want they can see inactive warnings. Is that right? Sorry, this may be a stupid question but i have to know how it works.

Thanks.

[Delphiprogrammi]

Hi Delphiprogrammi,

In this new version, the cron jobs are just deactivating warnings? The users will still see that inactive warnings and i have to remove them from admincp completely if i don't want they can see inactive warnings. Is that right? Sorry, this may be a stupid question but i have to know how it works.

Thanks.

Normal users cannot see inactive warnings and yeah they will still show up in the warning log but only to people who have permissions to view the warning log

[wrestlepower]

That's SQL code that would "maually" add the things missing (your error messages)todo this you will need to open phpMyAdmin select te database you use hit the "SQL" link paste the code into the textbox and hit go.After that you should get a message like "your query has been excuted successfully"


ALTER TABLE warning_types ADD COLUM warning_maturity INT(5);
ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';



thanks for explaining that. Anyway, ive run the queries and still get the db error when i try to manage the warning types as well as the second db error when i try to update a user. I've posted the error details again so you dont have to look for them.

When i try to manage warning types, i get;

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:57:42 PM
Script : http://www.wrestlepower.net/admincp/admin_warn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database

and when i try to manage a user, i get;
Invalid SQL:


MySQL Error : Unknown column 'alerts' in 'field list'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:59:17 PM
Script : http://www.wrestlepower.net/admincp/user.php?do=update
Referrer : http://www.wrestlepower.net/admincp/user.php?do=edit&u=1488
IP Address : My IP
Username : Duff
Classname : vb_database



EDIT: Seem to have figured out the first bit about manage warning types. The SQL code you gave said warning_maturity, yet the error i was getting mentioned warn_maturity, so i simply swapped the warning and replaced it with warn, ran the SQL again and it worked. Still stuck with the user changing problems though.

EDIT2: OK, everything seems to be fine now. Again, just swapped the words from the error message i was getting (alerts) with what you had in the SQL (warns) and it all worked out.





OH FFS, i just cant get this right

Getting an error when i go into the warning log.

Invalid SQL:
SELECT w.*,u.username AS wusername,u.userid AS wuserid,wt.*,wuser.username AS warned_username_v,wuser.userid AS warned_userid_v, ruser.username AS removed_by_v, (w.warned_time+wt.warn_maturity*24*60*60) AS maturitydate FROM
warnings w
LEFT JOIN user wuser ON(wuser.userid=w.warned_user)
LEFT JOIN user u ON(u.userid=w.warned_by)
LEFT JOIN user ruser ON(ruser.userid=w.removed_by)
LEFT JOIN warning_types wt ON(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0, 15;

MySQL Error : Unknown column 'w.removed_by' in 'on clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 06:14:24 PM
Script : http://www.wrestlepower.net/admincp/admin_warn.php?do=viewlogs
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : MY IP
Username : Duff
Classname : vb_database

[Delphiprogrammi]

thanks for explaining that. Anyway, ive run the queries and still get the db error when i try to manage the warning types as well as the second db error when i try to update a user. I've posted the error details again so you dont have to look for them.

When i try to manage warning types, i get;

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:57:42 PM
Script : http://www.wrestlepower.net/admincp/admin_warn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database

and when i try to manage a user, i get;
Invalid SQL:


MySQL Error : Unknown column 'alerts' in 'field list'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:59:17 PM
Script : http://www.wrestlepower.net/admincp/user.php?do=update
Referrer : http://www.wrestlepower.net/admincp/user.php?do=edit&u=1488
IP Address : My IP
Username : Duff
Classname : vb_database



EDIT: Seem to have figured out the first bit about manage warning types. The SQL code you gave said warning_maturity, yet the error i was getting mentioned warn_maturity, so i simply swapped the warning and replaced it with warn, ran the SQL again and it worked. Still stuck with the user changing problems though.

EDIT2: OK, everything seems to be fine now. Again, just swapped the words from the error message i was getting (alerts) with what you had in the SQL (warns) and it all worked out.





OH FFS, i just cant get this right

Getting an error when i go into the warning log.

Invalid SQL:
SELECT w.*,u.username AS wusername,u.userid AS wuserid,wt.*,wuser.username AS warned_username_v,wuser.userid AS warned_userid_v, ruser.username AS removed_by_v, (w.warned_time+wt.warn_maturity*24*60*60) AS maturitydate FROM
warnings w
LEFT JOIN user wuser ON(wuser.userid=w.warned_user)
LEFT JOIN user u ON(u.userid=w.warned_by)
LEFT JOIN user ruser ON(ruser.userid=w.removed_by)
LEFT JOIN warning_types wt ON(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0, 15;

MySQL Error : Unknown column 'w.removed_by' in 'on clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 06:14:24 PM
Script : http://www.wrestlepower.net/admincp/admin_warn.php?do=viewlogs
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : MY IP
Username : Duff
Classname : vb_database

you are getting way to much errors . I don't have them :confused: are you sure you run vbulletin 3.6.x with the PHP and MySQL version requirements and the system downloadble here (not in any other thread)

[wrestlepower]

yes, running vB 3.6.0 with PHP 4.42, both of which should be fine

Ive checked back through the thread and cant see where you mentioned what SQL version i should be on, but i'm on 4.1.21-standard

[valuemdsupport]

Normal users cannot see inactive warnings and yeah they will still show up in the warning log but only to people who have permissions to view the warning log
As you said, admin will see all active and inactive alerts, active and inactive warnings of users (absolutely). And users can't see their inactive alerts and inactive warnings, just see their active alerts and active warnings. Right?

My problem is users can see both. How will i fix this? I installed this hack from 3.5.x and just upgraded to aws3.6.1 for vb3.6.1. Did i do somethings wrong?

See attachment you will see my problem. Any helps will be appreciated.

Thank you.

[Delphiprogrammi]

As you said, admin will see all active and inactive alerts, active and inactive warnings of users (absolutely). And users can't see their inactive alerts and inactive warnings, just see their active alerts and active warnings. Right?

My problem is users can see both. How will i fix this? I installed this hack from 3.5.x and just upgraded to aws3.6.1 for vb3.6.1. Did i do somethings wrong?

See attachment you will see my problem. Any helps will be appreciated.

Thank you.

ow that's what you mean that can be hidden to mods only letme construct the condition and test it

edit

look at the two pics that information like the amount of warnings/alerts and the warning level is only viewable to usergroups 5,6,7 (standard vbulletin usergroups) (5 = supermoderators 6=Administrators 7 = moderators)

if that is what you want i will tell you howto do that

[valuemdsupport]

ow that's what you mean that can be hidden to mods only letme construct the condition and test it

edit

look at the two pics that information like the amount of warnings/alerts and the warning level is only viewable to usergroups 5,6,7 (standard vbulletin usergroups) (5 = supermoderators 6=Administrators 7 = moderators)

if that is what you want i will tell you howto do that Oh, no. That's not what i need from your help. I have 2 problem now.

I attempted to completely remove a user's warning via the admin panel choosing "complete removal" as suggested. Although it removed the warning in the admin panel (only 2 warnings show instead of 3), it still shows that the user has 3 warnings??
And another user received 4 warnings on 9-27-06. According to the settings, the user should automatically have a 7 day temporary ban after reaching a warning level of 3. However, this user was able to post today and is not banned??Those are my problems. Can you please check the script or should we have a maintenance script or a cron job script? :confused:

Thank you.

[Delphiprogrammi]

Oh, no. That's not what i need from your help. I have 2 problem now.

I attempted to completely remove a user's warning via the admin panel choosing "complete removal" as suggested. Although it removed the warning in the admin panel (only 2 warnings show instead of 3), it still shows that the user has 3 warnings??
And another user received 4 warnings on 9-27-06. According to the settings, the user should automatically have a 7 day temporary ban after reaching a warning level of 3. However, this user was able to post today and is not banned??Those are my problems. Can you please check the script or should we have a maintenance script or a cron job script? :confused:

Thank you.

1)your not the first talking about that i will spend some hours to see if i can catch that(also remember that warnings removed by cron are still in the warning log but it will mention it is removed by the cron script)
2)that could be possible with dynamically assigned ipadresses (changes every time you connect to the internet)

edit

again i tested that and in here it is working :surprised: :surprised: the system already uses three cron scripts.I did a testpost where the testuser warninglevel should be above the limit and the system should ban and it did banned my testuser.Also the warningcounters work fine.

Create a temporary admin account and pm me the login details so i can take a look at what's happening at your board

[Delphiprogrammi]

yes, running vB 3.6.0 with PHP 4.42, both of which should be fine

Ive checked back through the thread and cant see where you mentioned what SQL version i should be on, but i'm on 4.1.21-standard

MySQL should be fine but PHP 4.4.2 has known security holes see this (http://www.php.net/ChangeLog-4.php) for more information

the same comment to you.I'd like to have a look at your board to see what is exactely happening when the reported errors occour

Also ... what do you have in your templates ? (MEMBERINFO,postbit,postbit_legacy)


$user['warnings']; // vbulletin infraction system
$user['warns']; // aws
$userinfo['warnings']; //vbulletin infraction (MEMBERINFO template)
$userinfo['warns']; //aws (MEMBERINFO template)

[badboyz]

there is no read me how do i edit the templetes?

[Delphiprogrammi]

there is no read me how do i edit the templetes?

the readme is there /docs .....

[nir]

it works to the version 3.6.2?

[Delphiprogrammi]

it works to the version 3.6.2?

yeah

[nir]

This product is not compatible with version 4.3.10 of PHP. (Compatible starting with 4.4.4 / Incompatible with 5.0.0 Beta 1 and greater)

this is does not work

[Delphiprogrammi]

This product is not compatible with version 4.3.10 of PHP. (Compatible starting with 4.4.4 / Incompatible with 5.0.0 Beta 1 and greater)

this is does not work

your profile says you are using vbulletin 3.5.3 it will not work on that version of vbulletin.Also everything below PHP 4.4.4 have known security holes and i strongly urge you to upgrade

[nir]

the version my is 3.5.2
what to do in order installing?

[Delphiprogrammi]

the version my is 3.5.2
what to do in order installing?

you can't it does not work on 3.5.x however there is a 3.5.x version here (https://vborg.vbsupport.ru/showthread.php?t=95921)

[nir]

i'm sorry my erring
the version my is 3.6.0
unmistakable i registered 5

[Delphiprogrammi]

i'm sorry my erring
the version my is 3.6.2
unmistakable i registered 5

then you will need PHP 4.4.4 see this (http://www.php.net/ChangeLog-4.php) for important updates since your version .... OR you can try the folowwing open product-aws.xml and find


<dependency dependencytype="php" minversion="4.4.4" maxversion="5.0.0 Beta 1" />


and remove that line after that (and you did that correctly) you should be able to import the product XML

however this is not supported if you do this you are on your own

[SupermanInNY]

I've upgraded the board from 3.5.4 to 3.6.2.

I was using AWS 3.5.0 and now I need to upgrade it to the current 3.6.1.

I've uploaded the files (overwrote existing files) and then went to the Plugin and Products --> Manage Products --> Add / Import Products --> Browesed to product-aws.xml + Selected YES to overwrite and pressed the Import button.

It went OK,. but when I wanted to check on the AWS group I noticed it still carried the Advanced Warning System 3.5.0 .

Shouldn't that have shown me 3.6.1 instead of the 3.5.0?

I forgot to mention that when I click on the Check Version in the Plugin and Products System, it shows: Installed version 3.6.1 and latest version 3.6.1

So I think it is just a matter of wrong tag/field that has not been updated?

I believe there is a problem with the following table:

vb3_setting It is the one that has:

defaultvalue 3.6.1
but
value 3.5.0

Any chance this is not updating correctly?

I think I followed the instructions to the letter.
Do I need to do something else?

-Alon.

[Shazz]

Whats the difference between Infractions and This?
Sorry if this has been asked

[Delphiprogrammi]

I've upgraded the board from 3.5.4 to 3.6.2.

I was using AWS 3.5.0 and now I need to upgrade it to the current 3.6.1.

I've uploaded the files (overwrote existing files) and then went to the Plugin and Products --> Manage Products --> Add / Import Products --> Browesed to product-aws.xml + Selected YES to overwrite and pressed the Import button.

It went OK,. but when I wanted to check on the AWS group I noticed it still carried the Advanced Warning System 3.5.0 .

Shouldn't that have shown me 3.6.1 instead of the 3.5.0?

I forgot to mention that when I click on the Check Version in the Plugin and Products System, it shows: Installed version 3.6.1 and latest version 3.6.1

So I think it is just a matter of wrong tag/field that has not been updated?

I believe there is a problem with the following table:

vb3_setting It is the one that has:

defaultvalue 3.6.1
but
value 3.5.0

Any chance this is not updating correctly?


I think I followed the instructions to the letter.
Do I need to do something else?

-Alon.

the warn_version thing is indeed stored in the setting table but that should be autoupdated when you import the new product XML why it doesn't update ??

you should be ready to go now create a testuser and give him a warning ...

[Delphiprogrammi]

Whats the difference between Infractions and This?
Sorry if this has been asked

Well some people call me nuts because i ported this to 3.6.x.I did because i love the system.I'm using this from the day it was born in the old 3.0x series.Vbulletin infractions are far much more complicated.If you want something simple you can take a look at this.

[rinkrat]

When I enable this hack, I get errors from the quickreply box. either it doesn't go to the next page upon submission or it reports a double post.

[Masters]

My registered users can see everyone's warning points.
How do I hide this?

[Delphiprogrammi]

When I enable this hack, I get errors from the quickreply box. either it doesn't go to the next page upon submission or it reports a double post.

impossible this hack does not interfere with QR at all

[Delphiprogrammi]

My registered users can see everyone's warning points.
How do I hide this?

under manage warning options => who can see the warning points and bans => set this to Mgm (this means moderators and up will see it)

[EdQ]

I've upgraded the board from 3.5.4 to 3.6.2.

I was using AWS 3.5.0 and now I need to upgrade it to the current 3.6.1.

I've uploaded the files (overwrote existing files) and then went to the Plugin and Products --> Manage Products --> Add / Import Products --> Browesed to product-aws.xml + Selected YES to overwrite and pressed the Import button.

It went OK,. but when I wanted to check on the AWS group I noticed it still carried the Advanced Warning System 3.5.0 .

Shouldn't that have shown me 3.6.1 instead of the 3.5.0?

I forgot to mention that when I click on the Check Version in the Plugin and Products System, it shows: Installed version 3.6.1 and latest version 3.6.1

So I think it is just a matter of wrong tag/field that has not been updated?

I believe there is a problem with the following table:

vb3_setting It is the one that has:

defaultvalue 3.6.1
but
value 3.5.0

Any chance this is not updating correctly?


I think I followed the instructions to the letter.
Do I need to do something else?

-Alon.

So just inporting the file is all I need to do to upgrade from the older 3.5.x version? Are the templates the same?

Well some people call me nuts because i ported this to 3.6.x.I did because i love the system.I'm using this from the day it was born in the old 3.0x series.Vbulletin infractions are far much more complicated.If you want something simple you can take a look at this.


I like the way it handles incremental bannings. Much better than the infraction system.

[EdQ]

Well my question is moot. I cannot install it. I get an error that my PHP isn't 4.4.4

I currently run 4.3.9

[Delphiprogrammi]

Well my question is moot. I cannot install it. I get an error that my PHP isn't 4.4.4

I currently run 4.3.9

You should always run the latest release security man security ....

[EdQ]

You should always run the latest release security man security ....

I would, but its out of my hands. The ISP isn't upgrading till the end of the year.

[Delphiprogrammi]

I would, but its out of my hands. The ISP isn't upgrading till the end of the year.

Well there is one way around .... open product-aws.xml and find


<dependencies>
<dependency dependencytype="php" minversion="4.4.4" maxversion="5.0.0 Beta 1" />
<dependency dependencytype="vbulletin" minversion="3.6.0" maxversion="" />
</dependencies>


remove the php version check so


<dependencies>
<dependency dependencytype="vbulletin" minversion="3.6.0" maxversion="" />
</dependencies>


then it will import.

[EdQ]

Got it installed :)

Had a few issues, but I got them worked out. ;)

The only issue I can see so far is running the remove bans task

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE ls1_user SET warning_bans=0 where userid=;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Date : Wednesday, November 22nd 2006 @ 10:59:09 AM

[Delphiprogrammi]

Got it installed :)

Had a few issues, but I got them worked out. ;)

The only issue I can see so far is running the remove bans task

Hmmz are you sure the user 'userid' exist ?

[Gbml2u]

I have a problem with character encoding.
When i enter "Bài vi?́t spam" (mean Spam post) in New Warning Type's Name and add new, the Warn name show up Bài vi?́t Spam
I think it's a problem with code

[EdQ]

Hmmz are you sure the user 'userid' exist ?

No it doesn't exist. Why would it? I though it was looking for a userid.

[EdQ]

Some users also show warning on the forums. But when I go into their profile. The warnings are zero.

[inspiration100]

we need to have php 5.?

[Delphiprogrammi]

No it doesn't exist. Why would it? I though it was looking for a userid.

Where userid=number_here so the userid must excist or the query will fail

[Delphiprogrammi]

I have a problem with character encoding.
When i enter "Bài vi?́t spam" (mean Spam post) in New Warning Type's Name and add new, the Warn name show up Bài vi?́t Spam
I think it's a problem with code

you cannot use languages other then english ? hmmmz that could be a MySQL character set problem

[Delphiprogrammi]

we need to have php 5.?

No 4.4.4 is the most recommended release if you have PHP5 you will see an error

[AWJunkies]

Well some people call me nuts because i ported this to 3.6.x.I did because i love the system.I'm using this from the day it was born in the old 3.0x series.Vbulletin infractions are far much more complicated.If you want something simple you can take a look at this.

I am wondering the same thing. If you can build more upon this. I had warning system on phpbb board and was awesome. Your mod is very similar to that. I have not dived into the whole infractions thing yet. Your mod is working perfect by the way on php4.4.4 vbulletin 3.6.4.

[hosttds]

The only issue i am getting is that i can not view the signatures. Does anyone know how to fix this!?

Thanks,
Matt

[EdQ]

Where userid=number_here so the userid must excist or the query will fail

I guess I am confused. Because it say error in the syntax.

Or are you saying a user was banned, and the account was deleted?

[Delphiprogrammi]

The only issue i am getting is that i can not view the signatures. Does anyone know how to fix this!?

Thanks,
Matt

set the signature limit to 0 then you can see all signatures

[Delphiprogrammi]

I guess I am confused. Because it say error in the syntax.

Or are you saying a user was banned, and the account was deleted?

The system does not interfere with deleting accounts when a ban occourcs the user is banned nothing more nothing less i'm checking to see if i can reproduce that error

[EdQ]

The system does not interfere with deleting accounts when a ban occourcs the user is banned nothing more nothing less i'm checking to see if i can reproduce that error

I meant is the problem because the account that was banned is now deleted??

[NFLfbJunkie]

I have PHP 5.1.6, so this mod won't work?

Never mind; saw the November update notes. Will see if this works. Has anyone else tried the fix with positive results?

[nsusa]

Geez. This looks like major surgery to my forum with all the template changes. :( Wish there would be an easier way. I guess I better upgrade to 3.6.4 first (from 3.6.2) to save myself some work.

Nice feature list though.

Chris

[Delphiprogrammi]

hi,

I am still alive and i received a few suggestions from sv1cec to improve the system but to tell the truth i can't get them working an improvement would be a spamtrap where the ipod sellers (and such) post on your forum but there message would never be save into the database and they would be automatically banned.I can assume this is a nice thing to have for the bigger boards out there but all my attempts are failing.No error messages at all but it isn't working as it sepose todo either

[mrpotatohead]

Thanks for this...

...but I recevied this error when trying to install the product:

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'warn_hierarchical',
'warning',
'0',
'1',
'free',
'yesno',
2,
0,
1,
'',
0,
'aws'
),
(
'warn_automatic',
'warning',
'0',
'1',
'free',
'yesno',
3,
0,
1,
'',
0,
'aws'
),
(
'warn_automaticpm',
'warning',
'0',
'0',
'free',
'yesno',
4,
0,
1,
'',
0,
'aws'
),
(
'warn_autocomments',
'warning',
'0',
'0',
'free',
'yesno',
5,
0,
1,
'',
0,
'aws'
),
(
'warn_automatic_warner',
'warning',
'2137',
'1',
'free',
'',
6,
0,
1,
'',
0,
'aws'
),
(
'warn_warner',
'warning',
'0',
'0',
'free',
'',
7,
0,
1,
'',
0,
'aws'
),
(
'warn_collector',
'warning',
'1',
'1',
'free',
'',
8,
0,
1,
'',
0,
'aws'
),
(
'warn_banned_limit',
'warning',
'2147483647',
'7',
'free',
'',
9,
0,
1,
'',
0,
'aws'
),
(
'warn_points_before_banned',
'warning',
'10',
'10',
'free',
'',
10,
0,
1,
'',
0,
'aws'
),
(
'warn_warnings_before_banned',
'warning',
'3',
'10',
'free',
'',
11,
0,
1,
'',
0,
'aws'
),
(
'warn_banned_usergroup_id',
'warning',
'13',
'8',
'number',
'',
12,
0,
1,
'',
0,
'aws'
),
(
'warn_protected_usergroups',
'warning',
'65717',
'',
'free',
'',
13,
0,
1,
'',
0,
'aws'
),
(
'warn_troll_usergroup_id',
'warning',
'13',
'9',
'number',
'',
14,
0,
1,
'',
0,
'aws'
),
(
'warn_restore_groupid',
'warning',
'18',
'2',
'number',
'',
15,
0,
1,
'',
0,
'aws'
),
(
'warn_incr_ban_days',
'warning',
'0',
'1',
'free',
'yesno',
16,
0,
1,
'',
0,
'aws'
),
(
'warn_max_no_bans',
'warning',
'0',
'3',
'free',
'',
17,
0,
1,
'',
0,
'aws'
),
(
'warn_bans_mature',
'warning',
'0',
'0',
'free',
'',
18,
0,
1,
'',
0,
'aws'
),
(
'warn_viewoption',
'warning',
'All',
'Mgm',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n<option value=\\\"Mgm\\\" \" . iif($setting[\'value\']==\'Mgm\',\'selected=\"selected\"\') . \">Mgm</option>\r\n</select>',
19,
0,
1,
'',
0,
'aws'
),
(
'warn_multiple_per_post',
'warning',
'1',
'1',
'free',
'yesno',
20,
0,
1,
'',
0,
'aws'
),
(
'warn_send_em_warning',
'warning',
'1',
'1',
'free',
'yesno',
21,
0,
1,
'',
0,
'aws'
),
(
'warn_send_pm_warning',
'warning',
'1',
'0',
'free',
'yesno',
22,
0,
1,
'',
0,
'aws'
),
(
'warn_email_on_ban',
'warning',
'1',
'1',
'free',
'yesno',
23,
0,
1,
'',
0,
'aws'
),
(
'warn_historical',
'warning',
'1',
'1',
'free',
'yesno',
24,
0,
1,
'',
0,
'aws'
),
(
'warn_allowoffpost',
'warning',
'1',
'1',
'free',
'yesno',
25,
0,
1,
'',
0,
'aws'
),
(
'warn_warnings_per_page',
'warning',
'20',
'15',
'free',
'',
26,
0,
1,
'',
0,
'aws'
),
(
'warn_textbutoption',
'warning',
'Text',
'Text',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Text\\\" \" . iif($setting[\'value\']==\'Text\',\'selected=\"selected\"\') . \">Text</option>\r\n<option value=\\\"Buttons\\\" \" . iif($setting[\'value\']==\'Buttons\',\'selected=\"selected\"\') . \">Buttons</option>\r\n</select>',
26,
0,
1,
'',
0,
'aws'
),
(
'warn_modoption',
'warning',
'All',
'Own',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Own\\\" \" . iif($setting[\'value\']==\'Own\',\'selected=\"selected\"\') . \">Own</option>\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n</select>',
28,
0,
1,
'',
0,
'aws'
),
(
'warn_sig_thresshold',
'warning',
'0',
'0',
'free',
'',
29,
0,
1,
'',
0,
'aws'
),
(
'warn_avatar_thresshold',
'warning',
'0',
'0',
'free',
'',
30,
0,
1,
'',
0,
'aws'
),
(
'warn_pic_thresshold',
'warning',
'0',
'0',
'free',
'',
31,
0,
1,
'',
0,
'aws'
),
(
'warn_pmcutoff',
'warning',
'0',
'0',
'free',
'',
32,
0,
1,
'',
0,
'aws'
),
(
'warn_admingroups',
'warning',
'6',
'',
'free',
'',
33,
0,
1,
'',
0,
'aws'
),
(
'warn_sigpic_thresshold',
'warning',
'0',
'0',
'free',
'',
33,
0,
1,
'',
0,
'aws'
),
(
'warn_smodgroups',
'warning',
'5',
'',
'free',
'',
34,
0,
1,
'',
0,
'aws'
),
(
'warn_aprotected_usergroups',
'warning',
'17',
'',
'free',
'',
34,
0,
1,
'',
0,
'aws'
),
(
'warn_modgroups',
'warning',
'7',
'',
'free',
'',
35,
0,
1,
'',
0,
'aws'
),
(
'warn_includepost',
'warning',
'1',
'0',
'free',
'yesno',
36,
0,
1,
'',
0,
'aws'
),
(
'warn_savecopy',
'warning',
'1',
'0',
'free',
'yesno',
37,
0,
1,
'',
0,
'aws'
),
(
'warn_savecopyalert',
'warning',
'1',
'0',
'free',
'yesno',
38,
0,
1,
'',
0,
'aws'
),
(
'warn_savecopyforum',
'warning',
'38',
'',
'free',
'',
39,
0,
1,
'',
0,
'aws'
),
(
'warn_allowalerts',
'warning',
'1',
'0',
'free',
'yesno',
40,
0,
1,
'',
0,
'aws'
),
(
'warn_allowalertscomment',
'warning',
'1',
'0',
'free',
'yesno',
41,
0,
1,
'',
0,
'aws'
),
(
'warn_alertslifetime',
'warning',
'0',
'0',
'free',
'',
42,
0,
1,
'',
0,
'aws'
),
(
'warn_allownotes',
'warning',
'1',
'1',
'free',
'yesno',
43,
0,
1,
'',
0,
'aws'
),
(
'warn_version',
'warning',
'3.4.11',
'3.6.1',
'free',
'',
44,
0,
1,
'',
0,
'aws'
);

MySQL Error : Duplicate entry 'warn_hierarchical' for key 1
Error Number : 1062
Date : Thursday, December 21st 2006 @ 08:33:11 PM
Script : http://www.bigbrotherwebsite.net/forums/admincp/plugin.php?do=productimport
Referrer : http://www.bigbrotherwebsite.net/forums/admincp/plugin.php?do=productadd
IP Address : 86.149.221.27
Username : Big Brother
Classname : vb_database

Any ideas?!

[Artificial_Alex]

Uhh.I need help installing this ;-;

[Delphiprogrammi]

Thanks for this...

...but I recevied this error when trying to install the product:

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'warn_hierarchical',
'warning',
'0',
'1',
'free',
'yesno',
2,
0,
1,
'',
0,
'aws'
),
(
'warn_automatic',
'warning',
'0',
'1',
'free',
'yesno',
3,
0,
1,
'',
0,
'aws'
),
(
'warn_automaticpm',
'warning',
'0',
'0',
'free',
'yesno',
4,
0,
1,
'',
0,
'aws'
),
(
'warn_autocomments',
'warning',
'0',
'0',
'free',
'yesno',
5,
0,
1,
'',
0,
'aws'
),
(
'warn_automatic_warner',
'warning',
'2137',
'1',
'free',
'',
6,
0,
1,
'',
0,
'aws'
),
(
'warn_warner',
'warning',
'0',
'0',
'free',
'',
7,
0,
1,
'',
0,
'aws'
),
(
'warn_collector',
'warning',
'1',
'1',
'free',
'',
8,
0,
1,
'',
0,
'aws'
),
(
'warn_banned_limit',
'warning',
'2147483647',
'7',
'free',
'',
9,
0,
1,
'',
0,
'aws'
),
(
'warn_points_before_banned',
'warning',
'10',
'10',
'free',
'',
10,
0,
1,
'',
0,
'aws'
),
(
'warn_warnings_before_banned',
'warning',
'3',
'10',
'free',
'',
11,
0,
1,
'',
0,
'aws'
),
(
'warn_banned_usergroup_id',
'warning',
'13',
'8',
'number',
'',
12,
0,
1,
'',
0,
'aws'
),
(
'warn_protected_usergroups',
'warning',
'65717',
'',
'free',
'',
13,
0,
1,
'',
0,
'aws'
),
(
'warn_troll_usergroup_id',
'warning',
'13',
'9',
'number',
'',
14,
0,
1,
'',
0,
'aws'
),
(
'warn_restore_groupid',
'warning',
'18',
'2',
'number',
'',
15,
0,
1,
'',
0,
'aws'
),
(
'warn_incr_ban_days',
'warning',
'0',
'1',
'free',
'yesno',
16,
0,
1,
'',
0,
'aws'
),
(
'warn_max_no_bans',
'warning',
'0',
'3',
'free',
'',
17,
0,
1,
'',
0,
'aws'
),
(
'warn_bans_mature',
'warning',
'0',
'0',
'free',
'',
18,
0,
1,
'',
0,
'aws'
),
(
'warn_viewoption',
'warning',
'All',
'Mgm',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n<option value=\\\"Mgm\\\" \" . iif($setting[\'value\']==\'Mgm\',\'selected=\"selected\"\') . \">Mgm</option>\r\n</select>',
19,
0,
1,
'',
0,
'aws'
),
(
'warn_multiple_per_post',
'warning',
'1',
'1',
'free',
'yesno',
20,
0,
1,
'',
0,
'aws'
),
(
'warn_send_em_warning',
'warning',
'1',
'1',
'free',
'yesno',
21,
0,
1,
'',
0,
'aws'
),
(
'warn_send_pm_warning',
'warning',
'1',
'0',
'free',
'yesno',
22,
0,
1,
'',
0,
'aws'
),
(
'warn_email_on_ban',
'warning',
'1',
'1',
'free',
'yesno',
23,
0,
1,
'',
0,
'aws'
),
(
'warn_historical',
'warning',
'1',
'1',
'free',
'yesno',
24,
0,
1,
'',
0,
'aws'
),
(
'warn_allowoffpost',
'warning',
'1',
'1',
'free',
'yesno',
25,
0,
1,
'',
0,
'aws'
),
(
'warn_warnings_per_page',
'warning',
'20',
'15',
'free',
'',
26,
0,
1,
'',
0,
'aws'
),
(
'warn_textbutoption',
'warning',
'Text',
'Text',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Text\\\" \" . iif($setting[\'value\']==\'Text\',\'selected=\"selected\"\') . \">Text</option>\r\n<option value=\\\"Buttons\\\" \" . iif($setting[\'value\']==\'Buttons\',\'selected=\"selected\"\') . \">Buttons</option>\r\n</select>',
26,
0,
1,
'',
0,
'aws'
),
(
'warn_modoption',
'warning',
'All',
'Own',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Own\\\" \" . iif($setting[\'value\']==\'Own\',\'selected=\"selected\"\') . \">Own</option>\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n</select>',
28,
0,
1,
'',
0,
'aws'
),
(
'warn_sig_thresshold',
'warning',
'0',
'0',
'free',
'',
29,
0,
1,
'',
0,
'aws'
),
(
'warn_avatar_thresshold',
'warning',
'0',
'0',
'free',
'',
30,
0,
1,
'',
0,
'aws'
),
(
'warn_pic_thresshold',
'warning',
'0',
'0',
'free',
'',
31,
0,
1,
'',
0,
'aws'
),
(
'warn_pmcutoff',
'warning',
'0',
'0',
'free',
'',
32,
0,
1,
'',
0,
'aws'
),
(
'warn_admingroups',
'warning',
'6',
'',
'free',
'',
33,
0,
1,
'',
0,
'aws'
),
(
'warn_sigpic_thresshold',
'warning',
'0',
'0',
'free',
'',
33,
0,
1,
'',
0,
'aws'
),
(
'warn_smodgroups',
'warning',
'5',
'',
'free',
'',
34,
0,
1,
'',
0,
'aws'
),
(
'warn_aprotected_usergroups',
'warning',
'17',
'',
'free',
'',
34,
0,
1,
'',
0,
'aws'
),
(
'warn_modgroups',
'warning',
'7',
'',
'free',
'',
35,
0,
1,
'',
0,
'aws'
),
(
'warn_includepost',
'warning',
'1',
'0',
'free',
'yesno',
36,
0,
1,
'',
0,
'aws'
),
(
'warn_savecopy',
'warning',
'1',
'0',
'free',
'yesno',
37,
0,
1,
'',
0,
'aws'
),
(
'warn_savecopyalert',
'warning',
'1',
'0',
'free',
'yesno',
38,
0,
1,
'',
0,
'aws'
),
(
'warn_savecopyforum',
'warning',
'38',
'',
'free',
'',
39,
0,
1,
'',
0,
'aws'
),
(
'warn_allowalerts',
'warning',
'1',
'0',
'free',
'yesno',
40,
0,
1,
'',
0,
'aws'
),
(
'warn_allowalertscomment',
'warning',
'1',
'0',
'free',
'yesno',
41,
0,
1,
'',
0,
'aws'
),
(
'warn_alertslifetime',
'warning',
'0',
'0',
'free',
'',
42,
0,
1,
'',
0,
'aws'
),
(
'warn_allownotes',
'warning',
'1',
'1',
'free',
'yesno',
43,
0,
1,
'',
0,
'aws'
),
(
'warn_version',
'warning',
'3.4.11',
'3.6.1',
'free',
'',
44,
0,
1,
'',
0,
'aws'
);

MySQL Error : Duplicate entry 'warn_hierarchical' for key 1
Error Number : 1062
Date : Thursday, December 21st 2006 @ 08:33:11 PM
Script : http://www.bigbrotherwebsite.net/forums/admincp/plugin.php?do=productimport
Referrer : http://www.bigbrotherwebsite.net/forums/admincp/plugin.php?do=productadd
IP Address : 86.149.221.27
Username : Big Brother
Classname : vb_database

Any ideas?!

that's obvious you already had the system installed and tryed to install again over the existing installation.If you want to delete all settings used by the system you run


"DELETE FROM" . TABLE_PREFIX . "setting WHERE varname LIKE 'warn_%'";

[Delphiprogrammi]

Uhh.I need help installing this ;-;


Status: Not Installed


why you didn't install it ?

[Artificial_Alex]

I did install it o_o;;;;;;;;;;;;;;;;;

[mrpotatohead]

that's obvious you already had the system installed and tryed to install again over the existing installation.If you want to delete all settings used by the system you run


"DELETE FROM" . TABLE_PREFIX . "setting WHERE varname LIKE 'warn_%'";


Thanks, gave that a go running that query and it came up with this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DELETE FROM" . TABLE_PREFIX . "setting WHERE varname LIKE 'warn_%'"' at line 1


Guess it's easy when you know how?! I've deleted all the tables in my database with the prefix warn_ and the warnings ones etc., if that is what the query is meant to achieve... but still no luck!

The error relates to the tables that don't even exist - I had previously installed AWS on my previous server, and had moved the board recently - but stopped using AWS for a while - and now want to reinstall it...


Thanks for your help m8 btw,


- Joe

[Delphiprogrammi]

Thanks, gave that a go running that query and it came up with this:




Guess it's easy when you know how?! I've deleted all the tables in my database with the prefix warn_ and the warnings ones etc., if that is what the query is meant to achieve... but still no luck!

The error relates to the tables that don't even exist - I had previously installed AWS on my previous server, and had moved the board recently - but stopped using AWS for a while - and now want to reinstall it...


Thanks for your help m8 btw,


- Joe


DELETE FROM setting WHERE varname LIKE 'warn_%';


that will remove all settings used by the system.Your MySQL returned an error because "TABLE_PREFIX" is only parsed in vbulletin's PHP files and not when you run a query through PhpMyAdmin (or the tool in the admincp) the above query will work.Deleting the tables added by this hack will not delete all data used.You can perfectly stop using the system but leave it installed by disabling it in the admincp.

[Delphiprogrammi]

I did install it o_o;;;;;;;;;;;;;;;;;

if you want to uninstall the system delete the product and all of it's files (when you do this you will loose all (aws related) database information)

[tank14]

How come I only see this? Warning Level : 90 I want to see how many warning he or she got ect..

[Delphiprogrammi]

How come I only see this? Warning Level : 90 I want to see how many warning he or she got ect..

you got the necesarry rights to view that information ?

[tank14]

you got the necesarry rights to view that information ?
Yup, But I also want all to see it. I am the root admin, but at clantemplates.com they use this and it shows everyone.

[tank14]

btw its in the legacy postbit

[tank14]

Sorry to be a pain but this is what happens when I remove a warning..How do I change this template to fix? It posts double, and the tags is messed up a bit..
Dear Test,

A warning you have received for violating XboxCrave Community Rules has been removed by the Forums team. The removed warning concerned:

Spaming Forums
(Warning Type = Spam)

The post for which you were warned, and whose warning has now been removed, can be seen here:

Warned Post

With this warning being removed, 10 point(s) have been removed from your total.

Your total Warning Level at the moment is: 80 point(s).

Please reply back if you have a dispute.]]></template>
<template name="warn_pm_remove" templatetype="template" date="1155647787" username="Erik" version="3.6.0"><![CDATA[Dear Test,

A warning you have received for violating XboxCrave Community Rules has been removed by the Forums team. The removed warning concerned:

Spaming Forums
(Warning Type = Spam)

The post for which you were warned, and whose warning has now been removed, can be seen here:

Warned Post

With this warning being removed, 10 point(s) have been removed from your total.

Your total Warning Level at the moment is: 80 point(s).

Please reply back if you have a dispute.

[Delphiprogrammi]

Sorry to be a pain but this is what happens when I remove a warning..How do I change this template to fix? It posts double, and the tags is messed up a bit..
Dear Test,

A warning you have received for violating XboxCrave Community Rules has been removed by the Forums team. The removed warning concerned:

Spaming Forums
(Warning Type = Spam)

The post for which you were warned, and whose warning has now been removed, can be seen here:

Warned Post

With this warning being removed, 10 point(s) have been removed from your total.

Your total Warning Level at the moment is: 80 point(s).

Please reply back if you have a dispute.]]></template>
<template name="warn_pm_remove" templatetype="template" date="1155647787" username="Erik" version="3.6.0"><![CDATA[Dear Test,

A warning you have received for violating XboxCrave Community Rules has been removed by the Forums team. The removed warning concerned:

Spaming Forums
(Warning Type = Spam)

The post for which you were warned, and whose warning has now been removed, can be seen here:

Warned Post

With this warning being removed, 10 point(s) have been removed from your total.

Your total Warning Level at the moment is: 80 point(s).

Please reply back if you have a dispute.


ups seems like those templates are messed up the "<template> and </template>" tags should not show up in that messages it means i means i messed up (yes that's my fault) you could fix the problem by editing the warning remove templates warn_em_remove and warn_pm_remove check them

[Delphiprogrammi]

Dear Test,

A warning you have received for violating XboxCrave Community Rules has been removed by the Forums team. The removed warning concerned:

Spaming Forums
(Warning Type = Spam)

The post for which you were warned, and whose warning has now been removed, can be seen here:

Warned Post

With this warning being removed, 10 point(s) have been removed from your total.

Your total Warning Level at the moment is: 80 point(s).

Please reply back if you have a dispute.



here i edited this to give example it should be like this without the "template" tags

[tank14]

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT INTO pmtext_warned
(fromuserid, fromusername, title, before_title, message, before_message, touserarray, dateline)
VALUES
(,
'',
'',
'<i>The user did not enter a title</i>',
'',
'<i><u>++++</u></i>,,,,,,,,,,,,,,,,,,,,,,',
'',
1167714846);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
'',
'',
'<i>The user did not enter a title</i>',
'',
'<i><u' at line 4
Error Number : 1064
Date : Monday, January 1st 2007 @ 11:14:06 PM
Script : http://xboxcrave.com/vb/newreply.php
Referrer : http://xboxcrave.com/vb/newreply.php?do=newreply&noquote=1&p=33
IP Address : 69.243.173.129
Username : Jagged X sL4Sh
Classname : vb_databaseI get this when I curse in forums..Was a test for auto warner which doesn't work

[Terminatoronly]

nice hack installed it will do the job that i want

[parabat]

Well there is one way around .... open product-aws.xml and find


<dependencies>
<dependency dependencytype="php" minversion="4.4.4" maxversion="5.0.0 Beta 1" />
<dependency dependencytype="vbulletin" minversion="3.6.0" maxversion="" />
</dependencies>


remove the php version check so


<dependencies>
<dependency dependencytype="vbulletin" minversion="3.6.0" maxversion="" />
</dependencies>


then it will import.

Delphiprogrammi, I'm in a similar boat running PHP 4.3.11 (Linux). If I remove the PHP check, how will this affect the running of the mod???:confused:

-Parabat

[Delphiprogrammi]

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT INTO pmtext_warned
(fromuserid, fromusername, title, before_title, message, before_message, touserarray, dateline)
VALUES
(,
'',
'',
'<i>The user did not enter a title</i>',
'',
'<i><u>++++</u></i>,,,,,,,,,,,,,,,,,,,,,,',
'',
1167714846);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
'',
'',
'<i>The user did not enter a title</i>',
'',
'<i><u' at line 4
Error Number : 1064
Date : Monday, January 1st 2007 @ 11:14:06 PM
Script : http://xboxcrave.com/vb/newreply.php
Referrer : http://xboxcrave.com/vb/newreply.php?do=newreply&noquote=1&p=33
IP Address : 69.243.173.129
Username : Jagged X sL4Sh
Classname : vb_databaseI get this when I curse in forums..Was a test for auto warner which doesn't work

Disable the automtic warnings feature it doesn't seem to work on *every* board i have had other people complaining that it doesn't work it's in your warning options

[Delphiprogrammi]

Delphiprogrammi, I'm in a similar boat running PHP 4.3.11 (Linux). If I remove the PHP check, how will this affect the running of the mod???:confused:

-Parabat

on that PHP build it should run without a problem.I only picked 4.4.4 because that is the latest supported release in the PHP 4 series

[tank14]

Disable the automtic warnings feature it doesn't seem to work on *every* board i have had other people complaining that it doesn't work it's in your warning options
I wanted to use that feature badly =(

[tank14]

Please get that auto thing working...What would it take? Would help us all out.

[parabat]

on that PHP build it should run without a problem.I only picked 4.4.4 because that is the latest supported release in the PHP 4 series

yahooooo, great, thanx... installed!!!

-Parabat

[EdQ]

I guess I am confused. Because it say error in the syntax.

Or are you saying a user was banned, and the account was deleted?


An update, I reinstalled the product. And it seems to be working fine now.

[Brew]

If you have the option "Add Template Name in HTML Comments" in the General Settings set to YES you get the template info in PM and emails:

<!-- BEGIN TEMPLATE: warn_pm_alert -->

Just a heads up :)

[Brew]

When using the modcp to remove a warning you are redirected to " Viewing Warnings" page instead of going back to the Warning Log.

[Brew]

This is a great mod. I've been having a ball just testing it on a testuser account.

** One thing I would like to see added would be a message sent to the special forum for when a user has his bans/warnings/alerts have been removed/timed out.

Personally I think this mod should be part of the base install of vB. At least something more robust then what they currently have.

Keep up the good work!

[Delphiprogrammi]

hi people,

Well i would be glad to "donate" the code for this hack to vBulletin and i'm pretty sure John (original author) has no problem with that either but i'm afraid that's not going to happen ....

I have a new build of the system ready currently running on my testboard.New features would include


A spamtrap where you enter words in the same format as the vBulletin censor.When the system catches the words defined more times then the (setting for this) it jumps in blocks the post and issues a warning with a permanent ban
An option to autolock threads sended to the copyforum
An option to moderate threads sended to the copyforum


The spamtrap whas suggested to me Sve1cec as he added this to his board
it is meant to catch those spammers who sell ipods, mobile phones etc
I will still need to test for this for a while

[sv1cec]

The spam trap works like a champ in vB 3.0.xx I am using. No more worrying about the spammers. And their posts don't even show. Two pigeons with one shot. And the post doesn't show, and the spammer gets automatically banned!

LoRL, Happy New Year folks.

[Terminatoronly]

this is the best hack :D installed but i want to ask u i am using vb 3.6.4 does it work with it???

[Dr.Viggy]

I installed the old version before on my 3.5.4 boards and it worked fine. I just installed this new one on my 3.6.3 forums and I'm having a bit of an issue. I attached a photo of the problem I'm encountering. I checked all my templates against the instructions twice after the install and can't seem to find it. Any suggestions?

[Unpossible]

I installed the old version before on my 3.5.4 boards and it worked fine. I just installed this new one on my 3.6.3 forums and I'm having a bit of an issue. I attached a photo of the problem I'm encountering. I checked all my templates against the instructions twice after the install and can't seem to find it. Any suggestions?
I presume you mean that the options aren't on the admin postbit.

Go into the settings for AWS and check whether you are using the hierarchy system. If so, no-one of the same level or below can add warnings to that user.

I do, however, have my own problem. I have installed this mod but the options aren't appearing in AdminCP. Any suggestions?

[Dr.Viggy]

I presume you mean that the options aren't on the admin postbit.

Go into the settings for AWS and check whether you are using the hierarchy system. If so, no-one of the same level or below can add warnings to that user.

I do, however, have my own problem. I have installed this mod but the options aren't appearing in AdminCP. Any suggestions?

that's actually not what i mean at all. i'm talking about the gradient thead bar above each post does not stretch the width of the post.

[Celtkin]

We had to uninstall the hack because there were non-staff members who were able to see the warnings, despite all the settings being correct and triple checked.

We uninstalled the product and deleted the associated files, removed the added code but the built-in infraction system doesn't seem to be working now (the infraction icon is not visible). I checked permissions and all are set as they should be.

Does anyone have some advice as to what I may be missing?

Miami Dolphins Message Board (http://www.finheaven.com/boardvb2)

[Naxon]

where do i upload the xml file?

[Celtkin]

where do i upload the xml file?


Go to your admin control panel -> Plugins & Products ->
Manage Products ->[Add/Import Product]

Upload the product-aws.xml file through that interface :)

[SportsZone]

This hack causes an error of

Fatal error: Call to a member function on a non-object in /home/temp/public_html/includes/class_dm_user.php(2385) : eval()'d code on line 1

I have upgraded the hack, but that didn't fix the problem, which is, when a guest registers or I add a new member via admincp, I get the above error. For now, I have disabled the hack.

[Mindwarp]

We had to uninstall the hack because there were non-staff members who were able to see the warnings, despite all the settings being correct and triple checked.

We uninstalled the product and deleted the associated files, removed the added code but the built-in infraction system doesn't seem to be working now (the infraction icon is not visible). I checked permissions and all are set as they should be.

Does anyone have some advice as to what I may be missing?

Miami Dolphins Message Board (http://www.finheaven.com/boardvb2)




anyone have an answer on this?

[Delphiprogrammi]

This hack causes an error of


Fatal error: Call to a member function on a non-object in /home/temp/public_html/includes/class_dm_user.php(2385) : eval()'d code on line 1

I have upgraded the hack, but that didn't fix the problem, which is, when a guest registers or I add a new member via admincp, I get the above error. For now, I have disabled the hack.

that was a bug which is fixed in the latest upload

[Delphiprogrammi]

We had to uninstall the hack because there were non-staff members who were able to see the warnings, despite all the settings being correct and triple checked.

We uninstalled the product and deleted the associated files, removed the added code but the built-in infraction system doesn't seem to be working now (the infraction icon is not visible). I checked permissions and all are set as they should be.

Does anyone have some advice as to what I may be missing?

Miami Dolphins Message Board (http://www.finheaven.com/boardvb2)

are you sure you didn't (by accident) removed that code from postbit , postbit_legacy and MEMBERINFO templates ? you can always revert your templates to the vBulletin's original but note you will loose any modifications you've made to it.For setting up the build in infraction system you can read here (http://www.vbulletin.com/docs/html/main/user_infractions)

[SportsZone]

that was a bug which is fixed in the latest upload

Yep I know. I have re-upgraded the hack and edited the plugin again, and I get the following error, which btw, differs from the error message in your 1st post.

I got this error message while adding a member via admincp:

Fatal error: Call to a member function on a non-object in /home/temp/public_html/includes/class_dm_user.php(2385) : eval()'d code on line 1

[ymy]

This hack causes an error of


Fatal error: Call to a member function on a non-object in /home/temp/public_html/includes/class_dm_user.php(2385) : eval()'d code on line 1

I have upgraded the hack, but that didn't fix the problem, which is, when a guest registers or I add a new member via admincp, I get the above error. For now, I have disabled the hack.

Yes, also me please help us

[Delphiprogrammi]

hi people,

Allright I will investigate this and see if i and see what i can do

I cannot reproduce this please make sure you have the latest code

Edit plugin "AWS:warn link in usermanager" and replace all code with this


$quicklinks["../Warn.php?" . $vbulletin->session->vars['sessionurl'] . "do=WarnUserNoPost&amp;id=" . $vbulletin->GPC['userid']] = $vbphrase['aws_warn_user_admin'];


if you are still getting that error then please tell me exactely what you are trying todo .... You could also disable the plugin which causes the problem (it is only used to provide a link to warn a user in the usermanager)

[SportsZone]

if you are still getting that error then please tell me exactely what you are trying todo .... You could also disable the plugin which causes the problem (it is only used to provide a link to warn a user in the usermanager)

I have re-edited that plugin and I still get this error:

Fatal error: Call to a member function on a non-object in /home/temp/public_html/includes/class_dm_user.php(2385) : eval()'d code on line 1

To get the error I added a new member via admincp > users > add new user

I also disabled the AWS:warn link in usermanager plugin, and tried to add a new member via admincp, and I got the same error messgae:

Fatal error: Call to a member function on a non-object in /home/temp/public_html/includes/class_dm_user.php(2385) : eval()'d code on line 1

[Delphiprogrammi]

I have re-edited that plugin and I still get this error:



To get the error I added a new member via admincp > users > add new user

I also disabled the AWS:warn link in usermanager plugin, and tried to add a new member via admincp, and I got the same error messgae:


do you mind if i look at that at your board ? it is working normally here but as long as there is one user with a problem i'm not happy about my work ;)

[SportsZone]

lol sure. I'll PM you temp admin details.

[Delphiprogrammi]

hi,

That bug is now confirmed here (http://www.delphiprogramming.be/forums/bugtracker.php?do=viewbug&bugtracker_bugid=18) a temporary workaround is disabling he plugin at hook location private_insertpm_process i will see what i cando about it

Problem solved

open plugin at hook location private_insertpm_process at tyhe verry top before any other code add


global $vbulletin;



save enable plugin

done

test users => add a new user

ciao ;)

[SportsZone]

Excellent, thanks for the fix :D

[Celtkin]

are you sure you didn't (by accident) removed that code from postbit , postbit_legacy and MEMBERINFO templates ? you can always revert your templates to the vBulletin's original but note you will loose any modifications you've made to it.For setting up the build in infraction system you can read here (http://www.vbulletin.com/docs/html/main/user_infractions)

Yes, I just reversed the AWS installation instructions. I removed the AWS code and added back the code that was replaced.

Nonetheless, we eliminated the original problem of having non-staff members see the warnings by removing that code from the postbit.

[alexhirurg]

Is it possible to have a 0 points warning type ?
for example 'Congratulations'
i think is possible to remove condition >0 in add type form, but where is it ?

And also about USERCP template - it's not changed by install instructions, but how user can see his warnings in user CP ?

[Delphiprogrammi]

Is it possible to have a 0 points warning type ?
for example 'Congratulations'
i think is possible to remove condition >0 in add type form, but where is it ?

And also about USERCP template - it's not changed by install instructions, but how user can see his warnings in user CP ?

1)That would be pretty useless this is not meant as a "thank you" system
2)The second one (the usercp thing) well it's a good idea and i will see to add it
3) hmmz point 2 that whole information needs tobe queried again from the database that will add a load of querys No i'm not doing that i changed my mind i'm verry sorry

[akanevsky]

Is it possible to have a 0 points warning type ?
for example 'Congratulations'
i think is possible to remove condition >0 in add type form, but where is it ?

And also about USERCP template - it's not changed by install instructions, but how user can see his warnings in user CP ?

That is possible with "Smith" Warning System, you might want to check that out - it's published here at vB.org...

[sv1cec]

And also about USERCP template - it's not changed by install instructions, but how user can see his warnings in user CP ?

The user can see his warnings from his User Profile. There are links in there to show him his warnings. It's a minor job to add a similar link in User CP, and frankly that's a good idea.

[Delphiprogrammi]

The user can see his warnings from his User Profile. There are links in there to show him his warnings. It's a minor job to add a similar link in User CP, and frankly that's a good idea.

Done BUT there is something wrong the warning information is not showing where it should ... look at the pic .I wrote this small plugin for this thing


$user = & $vbulletin->userinfo;
$warn_page = "";
eval('$warn_page .= "' . fetch_template('usercp_warn_view_top') . '";');
$get_warns=$db->query_read("SELECT w.*,u.username as wusername,u.userid as wuserid,wt.* FROM
".TABLE_PREFIX."warnings w
LEFT JOIN ".TABLE_PREFIX."user u ON(u.userid=w.warned_by)
LEFT JOIN ".TABLE_PREFIX."warning_types wt ON(wt.tid=w.warned_warning_id)
WHERE w.warned_user='{$user['userid']}' ORDER BY w.warned_time DESC");
while($warn=$db->fetch_array($get_warns))
{
$warn['date'] = vbdate($vbulletin->options['dateformat'],$warn['warned_time']);
$warn['time'] = vbdate($vbulletin->options['timeformat'],$warn['warned_time']);
$wmessage=stripslashes($warn['warned_reason']);
eval('$warn_page .= "' . fetch_template('usercp_warn_view_row') . '";');
}
eval('$warn_page .= "' . fetch_template('usercp_warn_view_end') . '";');


used hook location "usercp_start" for some reason the template "usercp_warn_view_row" is not being fetched i don't get it

[sv1cec]

Well, I am not sure, but since this user has no warning points, hence no warnings, what did you expect the warn_view_row to show? LoRL, did you try it with a warned user?

[Delphiprogrammi]

Well, I am not sure, but since this user has no warning points, hence no warnings, what did you expect the warn_view_row to show? LoRL, did you try it with a warned user?

:D :D The user i whas testing didn't have a warning :D :D this is something for the "our stupidest mistakes thread" the thing is working ok now

[sv1cec]

LoRL, it has happened to all of us, don't worry! Nice work.

[NFLfbJunkie]

When I click on the "comment" from the admincp warnings log, I get the following:

"The requested URL /forums/admincp/admin_warn.php was not found on this server".

My admin control panel is named something other than 'admincp' so where would I need to replace 'admincp' with what I labeled mine as?

[Delphiprogrammi]

When I click on the "comment" from the admincp warnings log, I get the following:

"The requested URL /forums/admincp/admin_warn.php was not found on this server".

My admin control panel is named something other than 'admincp' so where would I need to replace 'admincp' with what I labeled mine as?

That should be already there but i forgot to add it to that section.To make that work if you have a "custom" admincp directory open admin_warn.php and find (if it is not there add it)


$admincpdir=$vbulletin->config['Misc']['admincpdir'];


then still in the same file (admin_warn.php) around line 714 there is this code


$d="<A HREF=\"{$vbulletin->options[bburl]}/admincp/admin_warn.php?do=showcomment&id=$warn[wid]\" onclick=\"window.open('{$vbulletin->options[bburl]}/admincp/admin_warn.php?do=showcomment&id=$warn[wid]','','width=1024, height=500, resizable=yes, scrollbars=yes'); return false;\" target=\"_blank\">$vbvb</a></font>";


replace that with


$d="<A HREF=\"{$vbulletin->options[bburl]}/$admincpdir/admin_warn.php?do=showcomment&id=$warn[wid]\" onclick=\"window.open('{$vbulletin->options[bburl]}/$admincpdir/admin_warn.php?do=showcomment&id=$warn[wid]','','width=1024, height=500, resizable=yes, scrollbars=yes'); return false;\" target=\"_blank\">$vbvb</a></font>";


to explain more clearly you need to replace "admincp" with $admincpdir this variable contains the correct complete path to your admincp (it reads from /includes/config.php)
save file upload that should do it

[NFLfbJunkie]

Thank you so much for the quick reponse. This very useful MOD is working great on my board.

[NFLfbJunkie]

Is there a way to remove the vBulletin "Give Infraction" link that shows in the user's profile and the icon https://vborg.vbsupport.ru/external/2007/02/12.gif that shows in the postbit?

[Steeler Nation]

I'm getting errors when I try to warn or leave a note:


Fatal error: Call to undefined function: check_user() in /home/www/steelernation/forums/Warn.php on line 605


Fatal error: Call to undefined function: check_user() in /home/www/steelernation/forums/Warn.php on line 120

[Celtkin]

hi,

That bug is now confirmed here (http://www.delphiprogramming.be/forums/bugtracker.php?do=viewbug&bugtracker_bugid=18) a temporary workaround is disabling he plugin at hook location private_insertpm_process i will see what i cando about it

Problem solved

open plugin at hook location private_insertpm_process at tyhe verry top before any other code add


global $vbulletin;



save enable plugin

done

test users => add a new user

ciao ;)

I tried to access the reference link but you registration to your board has been turned off. :(

What was the error that you addressed.

[Delphiprogrammi]

Is there a way to remove the vBulletin "Give Infraction" link that shows in the user's profile and the icon https://vborg.vbsupport.ru/external/2007/02/12.gif that shows in the postbit?

There is no "switch" eg a setting that controls this (so you would be allowed to enable / disable it) but you can always edit the templates and remove that code but personally i would recommend not to touch this or comment it out


<!-- this is a comment --> <- the comment ends here


you would have to edit postbit & postbit_legacy and MEMBERINFO as an example look at the attached picture this is my postbit_legacy template (teststyle) i use this for testing things only.Now where did the infraction icons go ? :D ;) open postbit_legacy and look for


<if condition="$show['infractionlink']"><a href="infraction.php?$session[sessionurl]do=report&amp;p=$post[postid]" rel="nofollow"><img class="inlineimg" src="$stylevar[imgdir_button]/infraction.gif" alt="<phrase 1="$post[username]">$vbphrase[add_infraction_for_x]</phrase>" border="0" /></a></if>


replace that with


<!--<if condition="$show['infractionlink']"><a href="infraction.php?$session[sessionurl]do=report&amp;p=$post[postid]" rel="nofollow"><img class="inlineimg" src="$stylevar[imgdir_button]/infraction.gif" alt="<phrase 1="$post[username]">$vbphrase[add_infraction_for_x]</phrase>" border="0" /></a></if>-->


look for


<if condition="$show['redcard']">
<a href="infraction.php?$session[sessionurl]do=view&amp;p=$post[postid]"><img src="$stylevar[imgdir_button]/redcard.gif" alt="$vbphrase[received_infraction]" border="0" /></a>
<else />
<if condition="$show['yellowcard']">
<a href="infraction.php?$session[sessionurl]do=view&amp;p=$post[postid]"><img src="$stylevar[imgdir_button]/yellowcard.gif" alt="$vbphrase[received_warning]" border="0" /></a>
</if>
</if>


replace with


<!--<if condition="$show['redcard']">
<a href="infraction.php?$session[sessionurl]do=view&amp;p=$post[postid]"><img src="$stylevar[imgdir_button]/redcard.gif" alt="$vbphrase[received_infraction]" border="0" /></a>
<else />
<if condition="$show['yellowcard']">
<a href="infraction.php?$session[sessionurl]do=view&amp;p=$post[postid]"><img src="$stylevar[imgdir_button]/yellowcard.gif" alt="$vbphrase[received_warning]" border="0" /></a>
</if>
</if>-->


look for


<if condition="$show['infraction']"><div>$vbphrase[infractions]: $post[warnings]/$post[infractions] ($post[ipoints])</div></if>


and replace with


<!--<if condition="$show['infraction']"><div>$vbphrase[infractions]: $post[warnings]/$post[infractions] ($post[ipoints])</div></if>-->


postbit_legacy is done now.This is just an example to get you started.This way the code is never removed if you need it later on you can uncomment it and ...

[Delphiprogrammi]

Fatal error: Call to undefined function: check_user() in /home/www/steelernation/forums/Warn.php on line 605

did you uploaded the file functions_warning.php to your vBulletin includes directory ? also make sure it has the correct permissions and your server / host is not in any way disallowing it's execution (openbase_dir PHP protection is known todo this sometimes)

[alexhirurg]

bugreport ! i've not understood the condition - when it happening, but it happening often...

Look at first comma after VALUES - there is strange... no userid, no username. Why it can be ?
this report from one of the administrators account.

Invalid SQL:

INSERT INTO pmtext_warned
(fromuserid, fromusername, title, before_title, message, before_message, touserarray, dateline)
VALUES
(,
'',
'',
'<i>The user did not enter a title</i>',
'B?*um b?*um bambaló \nBambaló og dillidillidó\nMy little friend I lull to rest\nBut outside, a face looms at the window\n\nWhen the mighty mountains\nfill your chest with burning desire,\nI will play the langspil [violin-fiddle-like instrument]\nand soothe your mind\n\nB?*um b?*um bambaló \nBambaló og dillidillidó\nMy little friend I lull to rest\nBut outside, a face looms at the window\n\nWhen the cruel storms rage\nand the dark blizzard crouches above,\nI shall light five candles\nand drive away the winter/twilight shadows',
'B?*um b?*um bambaló \nBambaló og dillidillidó\nMy little friend I lull to rest\nBut outside, a face looms at the window\n\nWhen the mighty mountains\nfill your chest with burning desire,\nI will play the langspil [violin-fiddle-like instrument]\nand soothe your mind\n\nB?*um b?*um bambaló \nBambaló og dillidillidó\nMy little friend I lull to rest\nBut outside, a face looms at the window\n\nWhen the cruel storms rage\nand the dark blizzard crouches above,\nI shall light five candles\nand drive away the winter/twilight shadows',
'',
1171311326);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
'',
'',
'<i>The user did not enter a title</i>',
'B?*um b?*um b' at line 4
Error Number : 1064
Date : Monday, February 12th 2007 @ 12:15:26 PM
Script : http://www.linkinparkforums.com/editpost.php?do=updatepost&postid=463949
Referrer :
IP Address : 194.144.42.227
Username : Friðbjörn
Classname : vB_Database

[alexhirurg]

also i want to ask authors - is it possible to embed manual changes to templates to the xml ?
like as parse_templates plugin, or - i don't know the way to change templates in install/uninstall scripts - may be somebody know ?
only one way that i can invent - get it by fetch_template, change and store directly to the database by SQL query..
Any thinks ?

[chikkoo]

Though I wanted to install AWS in 3.5, since it was in Beta, I was using Inferno Warning System. Now I am still continuing with it, though it is not 100% working (adding warnings but not banning).

Now I am planning to switch to AWS 3.6.1, before that some queries:

1) Can I import the Warning points from Inferno Warning System?
2) Inferno had some warning blocks (green+yellow+red), does your warning levels/points have such blocks/pictures?
3) Does every one can see other members warning points and warning reason?

Thanks for your support.

[sv1cec]

Even though I am no longer directly involved with either the development or the support of AWS, I think I can safely answer your questions. Maybe Delphi can elaborate more on some points, if he feels like it.

1) Can I import the Warning points from Inferno Warning System?

I have no idea how the Inferno Warning System works, but I think it is higlly unlikely. AWS stores the member's warning points in the user table, while the details about each warning are stored in a different table called warnings. Unless the Inferno WS uses the exact same column names in both of these tables, to store the exact same information, there is no way to use the old information you have about your members. Of course, writing a small program to do the import is NOT impossible, but it has to be done by someone who is aware of how the IWS and AWS store their data.

2) Inferno had some warning blocks (green+yellow+red), does your warning levels/points have such blocks/pictures?

Hmm, no AWS doesn't have any "blocks", at least not "visual" blocks, which categorize the member in one of the three categories mentioned. Frankly it's not so difficult to add such a thing, AWS has already some "categories" in the sense that it uses some cut-off limits (avatar cut-off limit, signature cut-off limit, PM cut-off limit).

3) Does every one can see other members warning points and warning reason?

This is a selectable option in AWS. You have the option to allow only Management to see the warning information or everyone, however normal members can NOT see the details for each warning another member has received. Only how many warnings he/she has, how many warning points, how many bans etc.

I hope this helps.

[GoTTi]

im sure this has been answered...

can we upgrade from 3.5.4 to 3.6.x?

[alexhirurg]

Authors Ignorred My Posts ?

[sv1cec]

No, I am not ignoring your question, it's just that I do not have an answer to give you. That obviously should happen when a warning is automatically issued for usage of censored words in a PM. Unformtunately, I do not have a working system to test it and tell you, so you will have to wait for Delphi to check it out.

As for your question about the templates, I am not sure I understand the question. Yes, you can alter a template in the xml file, it's a text file, so you should be able to edit it, but somehow I do not think this is what you are asking.

[Delphiprogrammi]

bugreport ! i've not understood the condition - when it happening, but it happening often...

Look at first comma after VALUES - there is strange... no userid, no username. Why it can be ?
this report from one of the administrators account.

Invalid SQL:

INSERT INTO pmtext_warned
(fromuserid, fromusername, title, before_title, message, before_message, touserarray, dateline)
VALUES
(,
'',
'',
'<i>The user did not enter a title</i>',
'B?*um b?*um bambaló \nBambaló og dillidillidó\nMy little friend I lull to rest\nBut outside, a face looms at the window\n\nWhen the mighty mountains\nfill your chest with burning desire,\nI will play the langspil [violin-fiddle-like instrument]\nand soothe your mind\n\nB?*um b?*um bambaló \nBambaló og dillidillidó\nMy little friend I lull to rest\nBut outside, a face looms at the window\n\nWhen the cruel storms rage\nand the dark blizzard crouches above,\nI shall light five candles\nand drive away the winter/twilight shadows',
'B?*um b?*um bambaló \nBambaló og dillidillidó\nMy little friend I lull to rest\nBut outside, a face looms at the window\n\nWhen the mighty mountains\nfill your chest with burning desire,\nI will play the langspil [violin-fiddle-like instrument]\nand soothe your mind\n\nB?*um b?*um bambaló \nBambaló og dillidillidó\nMy little friend I lull to rest\nBut outside, a face looms at the window\n\nWhen the cruel storms rage\nand the dark blizzard crouches above,\nI shall light five candles\nand drive away the winter/twilight shadows',
'',
1171311326);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
'',
'',
'<i>The user did not enter a title</i>',
'B?*um b?*um b' at line 4
Error Number : 1064
Date : Monday, February 12th 2007 @ 12:15:26 PM
Script : http://www.linkinparkforums.com/editpost.php?do=updatepost&postid=463949
Referrer :
IP Address : 194.144.42.227
Username : Friðbjörn
Classname : vB_Database


that is caused by the automatic warnings future disable it and the errormessages will disappear until i can have a look in fixing that

[Delphiprogrammi]

Though I wanted to install AWS in 3.5, since it was in Beta, I was using Inferno Warning System. Now I am still continuing with it, though it is not 100% working (adding warnings but not banning).

Now I am planning to switch to AWS 3.6.1, before that some queries:

1) Can I import the Warning points from Inferno Warning System?
2) Inferno had some warning blocks (green+yellow+red), does your warning levels/points have such blocks/pictures?
3) Does every one can see other members warning points and warning reason?

Thanks for your support.

1)nope
2)nope
3)No only mods and up and the warned person (his own only)

[Delphiprogrammi]

also i want to ask authors - is it possible to embed manual changes to templates to the xml ?
like as parse_templates plugin, or - i don't know the way to change templates in install/uninstall scripts - may be somebody know ?
only one way that i can invent - get it by fetch_template, change and store directly to the database by SQL query..
Any thinks ?

I think you mean to have the template edits automated ? i think that would be impossible

[Delphiprogrammi]

hi people,

I have added a new thing.Using the new "adminmessage" system that whas introduced by jelsoft in one of 3.6.x beta's don't remember exactely which one.When you install the system (a complete new install not an upgrade) you will see a message on what todo next toget the system working on your board.This is most to help new vBulletin "modding" users to get started quickly and when you uninstall the system you will see a message telling you which file(s) are save to remove from your server

[Puntal]

Thanks for great hack.

I installed it,and works fine,but since installing it,we cannot see avatars or signatures anymore!!!

I am using Postbit and not postbit_legacy

Thanks for help in advance.

[Delphiprogrammi]

Thanks for great hack.

I installed it,and works fine,but since installing it,we cannot see avatars or signatures anymore!!!

I am using Postbit and not postbit_legacy

Thanks for help in advance.

ey don't yell that's completely normal.There is a setting in your warning options that controls this."Avatar Cut Off limit" and "Signature Cutoff Limit" set both to "0" (zero) if you want to ALWAYS allow (regardless off any warnings) members to keep there avatar and signature)

[gusfune]

Is it possible to moderators warn other moderators using this hack? If not, would it be possible in a near future?

[Delphiprogrammi]

Is it possible to moderators warn other moderators using this hack? If not, would it be possible in a near future?

No Not By Default But You Could Try Removing The Moderator's Usergroup From The Protected Usergroups ....

[alexhirurg]

I think you mean to have the template edits automated ? i think that would be impossible

I think that using preg_replace() and other string funcs will help to do it automatically ;)
but i've asked - is this possible to transfer changing templates to the plugin that will hook entry named "parse_templates" ?
I did it in mine 2 plugins w/o any hard work... but your have many changes, of course...

[Delphiprogrammi]

I think that using preg_replace() and other string funcs will help to do it automatically ;)
but i've asked - is this possible to transfer changing templates to the plugin that will hook entry named "parse_templates" ?
I did it in mine 2 plugins w/o any hard work... but your have many changes, of course...

$vbulletin->templatecache[] = str_replace() ...... and so on BUT you have to "give" a comment string on where to insert the changes.Because this system contains many changes this is something you have todo by hand.I think you have to first insert a comment into the template(s) that need to be modified then vBulletin can "parse" them through that hook.I've seen it done in other mods


<!-- this is a comment -->


or a "unique" part of the code will do to

[DiMoNd21]

I installed this product but it seems there is a problem.

I get this error:

An error has occured, the following message has been left below: :

You have no permissions to enter Notes for a user

and this:

An error has occured, the following message has been left below: :

you do not have permissions to issue non post related warnings

Why is this happening?

[Delphiprogrammi]

I installed this product but it seems there is a problem.

I get this error:

An error has occured, the following message has been left below: :

You have no permissions to enter Notes for a user

and this:

An error has occured, the following message has been left below: :

you do not have permissions to issue non post related warnings

Why is this happening?

wel wel "you do not have permissions" what could that mean ? hint (admincp => usergroups => edit -> aws permissions)

[Delphiprogrammi]

hi folks,

I whas ready to bring out a new release while i discoverd a new problem with the system.Users of the premium hack called "hide hack expanded edition" from visionscripts are affected (possible other ones to and also the free version of the hide hack)The problem is when aws is installed a plugin from the aws system is causing the vBulletin function "quickedit" to bring up a white blank page" (when you hit "edit post" in a thread and then in the next page click advanced you'll get a white screen)I have identified which plugin in the system is causing the problem but that code looks correct to me so more research (and delays in new releases) will be needed

Let's make it clear this is not a problem with the visionscripts product.The problem is caused by an aws plugin

[NFLfbJunkie]

When I click on the 'YES' from the 'Alert Comment' column on the "ViewMyWarnings' page, I get the following:

Fatal error: Cannot use object of type mysqli_result as array in /home/fantasyf/public_html/gforums/showcomment.php(22) : eval()'d code on line 35

Is there a way to fix this?

[Delphiprogrammi]

When I click on the 'YES' from the 'Alert Comment' column on the "ViewMyWarnings' page, I get the following:

Fatal error: Cannot use object of type mysqli_result as array in /home/fantasyf/public_html/gforums/showcomment.php(22) : eval()'d code on line 35

Is there a way to fix this?

lemme guess ? you are running on PHP5 that's not supported ... if you are not running on PHP5 but on 4.4.6 and get a MySQLI error you should set that varible in /includes/config.php to use MySQL not MySQLI.PHP 5 is not supported because i do not have it availible to see if it works.And no i won't upgrade before PHP5 is the officially supported release on www.php.net (http://www.php.net)

[NFLfbJunkie]

Will changing MySqli to MySql in the config.php file affect anything else, since I edited the file to mysqli prior to installing vBulletin? I did make the change already, and the error message does not show. Now when I click on the Alert Comment link, a box opens up displaying:

"If you do not like to use this predefined comment, you may type your own, in the Moderator Comments field of the previous form."

Is this what's supposed to show, or should the pre-defined comment that I entered in the advanced warning system control panel for the warning show up? I noticed that there is empty space above the above statement, which is probably where the pre-defined comment displays. Maybe I have my settings incorrect, but I still can't figure it out.

[sv1cec]

No, the predefined comment is not shown, but it will be used if you do not enter anything in that field there. If you do enter a comment yourself, then the predefined one is not send, the one you enter will be send instead.

[DoSe]

after readin all this nobody ran into my problem. My problem is i have the system set to make a post after a warn but it dont say the user being warned or the reason they were warned. This is all that comes up in the post

Warning: User: - Warner: googang - Date: 04-16-2007 at 07:45 PM

--------------------------------------------------------------------------------

User received the following Warning/Alert by googang on 04-16-2007 at 07:45 PM :

[Delphiprogrammi]

after readin all this nobody ran into my problem. My problem is i have the system set to make a post after a warn but it dont say the user being warned or the reason they were warned. This is all that comes up in the post

Warning: User: - Warner: googang - Date: 04-16-2007 at 07:45 PM

--------------------------------------------------------------------------------

User received the following Warning/Alert by googang on 04-16-2007 at 07:45 PM :

For that to work you must have one of the notifications methods enabled either email or pm on warn will do.That thing is made to have a "complete" copy of the warning given but i have found before if you disable pm and email (so no notification method is availible) it does what you describe

[DoSe]

thank you thats what it was