PDA

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


Pages : [1] 2 3

Delphiprogrammi
20 Aug 2006, 18:08
Advaned Warning System

This is a port of aws (http://www.vbulletin.org/forum/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 (http://www.vbulletin.org/forum/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 http://www.vbulletin.org/forum/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 (http://www.vbulletin.org/forum/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
20 Aug 2006, 18:52
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
20 Aug 2006, 19:10
dammit, I can;t install this, if someone can help me it would be apprecited.

Delphiprogrammi
20 Aug 2006, 19:29
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
20 Aug 2006, 19:33
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
20 Aug 2006, 19:38
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
20 Aug 2006, 19:46
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
20 Aug 2006, 19:54
I dont know how to install it. I have a 3.6.0 version. I was wondering if someone can help me?

bashy
20 Aug 2006, 20:22
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
21 Aug 2006, 05:51
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
21 Aug 2006, 07:33
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
21 Aug 2006, 08:29
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
21 Aug 2006, 10:42
Anyone has a list of rules for warnings etc? that we could use as example to start.

Thanks!

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

Installed :D


http://www.vbulletin.org/forum/attachment.php?attachmentid=21907&d=1101243281

Delphiprogrammi
21 Aug 2006, 10:45
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
21 Aug 2006, 11:55
Wow thanks a ton!

outlaw621
21 Aug 2006, 15:20
Been waiting on this. Thanks a bunch.

GoTTi
21 Aug 2006, 17:04
nice delphi -

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

/me claps

Mirage Guardian
21 Aug 2006, 17:29
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
21 Aug 2006, 18:39
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
22 Aug 2006, 14:44
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
22 Aug 2006, 15:30
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
22 Aug 2006, 15:59
thanks, Delphi-

nice job > I installed it and everything looks good .

Clicked install

xtreme-mobile
22 Aug 2006, 16:45
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
22 Aug 2006, 16:53
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
22 Aug 2006, 17:39
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
22 Aug 2006, 19:19
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
22 Aug 2006, 19:20
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
22 Aug 2006, 20:59
Fantastic. Just wanted to make sure it was correct. Thanks for your quick reply.

Delphiprogrammi
22 Aug 2006, 22:19
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
23 Aug 2006, 06:41
Great job!

jian
23 Aug 2006, 13:37
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
23 Aug 2006, 18:42
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
23 Aug 2006, 21:09
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
24 Aug 2006, 21:41
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
25 Aug 2006, 18:58
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
25 Aug 2006, 19:59
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
26 Aug 2006, 10:24
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
27 Aug 2006, 00:26
$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
27 Aug 2006, 16:25
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
27 Aug 2006, 16:27
$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
27 Aug 2006, 17:09
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
28 Aug 2006, 05:38
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
28 Aug 2006, 12:04
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
28 Aug 2006, 12:06
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
28 Aug 2006, 18:02
that would be a nice thing to have i'm going to look at it and try

thanks, it would help a lot.

evofile
29 Aug 2006, 04:56
hello, since i installed your hack me and my members can't see the signatures and avatars of all users. why?

CORSO
30 Aug 2006, 04:25
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
30 Aug 2006, 11:49
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
30 Aug 2006, 12:37
Thanks a lot

nir
31 Aug 2006, 17:21
An error has occured, the following message has been left below: :

you do not have permissions to issue non post related warnings

???????

Delphiprogrammi
31 Aug 2006, 17:34
???????

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

sv1cec
31 Aug 2006, 18:51
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
31 Aug 2006, 20:59
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://www.vbulletin.org/forum/

Delphiprogrammi
31 Aug 2006, 21:28
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
31 Aug 2006, 21:31
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
01 Sep 2006, 04:48
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
01 Sep 2006, 16:49
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
01 Sep 2006, 22:25
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
03 Sep 2006, 12:46
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
03 Sep 2006, 17:28
Heh professional? It was my first attempt at learning php and vB. Delphi may be more worth of that compliment than I am.

Delphiprogrammi
03 Sep 2006, 21:57
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
03 Sep 2006, 21:59
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
03 Sep 2006, 22:01
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
04 Sep 2006, 16:34
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
04 Sep 2006, 20:05
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
06 Sep 2006, 17:54
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
07 Sep 2006, 07:32
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
07 Sep 2006, 15:07
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
07 Sep 2006, 15:42
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
08 Sep 2006, 10:29
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
10 Sep 2006, 10:21
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
10 Sep 2006, 13:40
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
10 Sep 2006, 14:32
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
10 Sep 2006, 14:38
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
10 Sep 2006, 15:16
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
10 Sep 2006, 15:37
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
10 Sep 2006, 15:56
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
11 Sep 2006, 19:44
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
11 Sep 2006, 20:22
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
12 Sep 2006, 08:25
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
12 Sep 2006, 21:24
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
12 Sep 2006, 22:36
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 http://www.vbulletin.org/forum/attachment.php?attachmentid=21907&d=1101243281 but how do I add them in the "Warning selection"
Thanks

Luggruff
13 Sep 2006, 03:59
http://www.vbulletin.com/forum/showthread.php?p=1209982

anyone with a clue??
(concerns AWS)

Delphiprogrammi
13 Sep 2006, 12:02
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 http://www.vbulletin.org/forum/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
13 Sep 2006, 12:03
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
13 Sep 2006, 18:07
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
13 Sep 2006, 18:08
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
13 Sep 2006, 20:03
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
14 Sep 2006, 22:32
Looks like you are wrong:
http://www.vbulletin.com/forum/showpost.php?p=1210882&postcount=20

nope

infractions working fine .....

Delphiprogrammi
14 Sep 2006, 22:37
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
14 Sep 2006, 22:39
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
15 Sep 2006, 00:12
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
15 Sep 2006, 00:15
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
15 Sep 2006, 02:08
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
15 Sep 2006, 16:46
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
15 Sep 2006, 19:48
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
17 Sep 2006, 11:06
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
17 Sep 2006, 11:40
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
17 Sep 2006, 11:42
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
18 Sep 2006, 13:58
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
18 Sep 2006, 16:19
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
23 Sep 2006, 17:35
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
24 Sep 2006, 01:33
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
24 Sep 2006, 06:32
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
24 Sep 2006, 23:11
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
25 Sep 2006, 03:04
thx... very nice hack to have!

Delphiprogrammi
25 Sep 2006, 07:38
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
25 Sep 2006, 18:22
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
25 Sep 2006, 19:11
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
26 Sep 2006, 00:01
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
26 Sep 2006, 10:57
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
28 Sep 2006, 01:47
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
28 Sep 2006, 06:37
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
28 Sep 2006, 18:56
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
29 Sep 2006, 11:40
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
29 Sep 2006, 12:18
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
29 Sep 2006, 15:03
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
01 Oct 2006, 16:55
there is no read me how do i edit the templetes?

Delphiprogrammi
01 Oct 2006, 17:31
there is no read me how do i edit the templetes?

the readme is there /docs .....

nir
12 Oct 2006, 17:41
it works to the version 3.6.2?

Delphiprogrammi
12 Oct 2006, 17:59
it works to the version 3.6.2?

yeah

nir
12 Oct 2006, 18:05
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
12 Oct 2006, 18:16
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
12 Oct 2006, 18:21
the version my is 3.5.2
what to do in order installing?

Delphiprogrammi
12 Oct 2006, 18:36
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 (http://www.vbulletin.org/forum/showthread.php?t=95921)

nir
12 Oct 2006, 18:45
i'm sorry my erring
the version my is 3.6.0
unmistakable i registered 5

Delphiprogrammi
12 Oct 2006, 18:58
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
14 Oct 2006, 17:59
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
14 Oct 2006, 18:03
Whats the difference between Infractions and This?
Sorry if this has been asked

Delphiprogrammi
16 Oct 2006, 12:56
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
16 Oct 2006, 12:59
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
18 Oct 2006, 17:50
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
30 Oct 2006, 07:44
My registered users can see everyone's warning points.
How do I hide this?

Delphiprogrammi
31 Oct 2006, 17:00
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
31 Oct 2006, 17:00
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
21 Nov 2006, 16:28
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
21 Nov 2006, 16:42
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
22 Nov 2006, 17:06
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
22 Nov 2006, 17:09
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
22 Nov 2006, 18:37
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
22 Nov 2006, 19:00
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
23 Nov 2006, 23:13
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
25 Nov 2006, 16:35
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
26 Nov 2006, 06:16
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
27 Nov 2006, 23:07
Some users also show warning on the forums. But when I go into their profile. The warnings are zero.

inspiration100
30 Nov 2006, 18:59
we need to have php 5.?

Delphiprogrammi
30 Nov 2006, 20:15
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
30 Nov 2006, 20:16
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
30 Nov 2006, 20:18
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
01 Dec 2006, 09:13
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
04 Dec 2006, 23:25
The only issue i am getting is that i can not view the signatures. Does anyone know how to fix this!?

Thanks,
Matt

EdQ
05 Dec 2006, 02:46
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
07 Dec 2006, 14:34
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
07 Dec 2006, 14:35
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
08 Dec 2006, 21:53
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
15 Dec 2006, 02:34
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
18 Dec 2006, 23:39
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
19 Dec 2006, 16:04
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
22 Dec 2006, 02:34
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
22 Dec 2006, 06:17
Uhh.I need help installing this ;-;

Delphiprogrammi
22 Dec 2006, 13:50
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
22 Dec 2006, 13:51
Uhh.I need help installing this ;-;


Status: Not Installed


why you didn't install it ?

Artificial_Alex
22 Dec 2006, 13:53
I did install it o_o;;;;;;;;;;;;;;;;;

mrpotatohead
22 Dec 2006, 19:26
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
22 Dec 2006, 20:41
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
22 Dec 2006, 20:43
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
31 Dec 2006, 23:44
How come I only see this? Warning Level : 90 I want to see how many warning he or she got ect..

Delphiprogrammi
31 Dec 2006, 23:46
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
01 Jan 2007, 00:40
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
01 Jan 2007, 00:41
btw its in the legacy postbit

tank14
01 Jan 2007, 02:01
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
01 Jan 2007, 15:35
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
01 Jan 2007, 15:37
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
02 Jan 2007, 05:16
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
02 Jan 2007, 08:52
nice hack installed it will do the job that i want

parabat
02 Jan 2007, 15:50
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
02 Jan 2007, 17:23
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
02 Jan 2007, 17:25
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
02 Jan 2007, 20:24
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
03 Jan 2007, 08:05
Please get that auto thing working...What would it take? Would help us all out.

parabat
03 Jan 2007, 14:02
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
03 Jan 2007, 17:45
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
03 Jan 2007, 20:39
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
03 Jan 2007, 20:41
When using the modcp to remove a warning you are redirected to " Viewing Warnings" page instead of going back to the Warning Log.

Brew
03 Jan 2007, 20:46
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
06 Jan 2007, 18:00
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
06 Jan 2007, 19:05
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
08 Jan 2007, 14:40
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
09 Jan 2007, 00:15
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
12 Jan 2007, 13:41
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
12 Jan 2007, 17:41
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
13 Jan 2007, 12:49
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
13 Jan 2007, 14:17
where do i upload the xml file?

Celtkin
13 Jan 2007, 21:23
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
14 Jan 2007, 21:27
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
18 Jan 2007, 21:27
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
18 Jan 2007, 22:22
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
18 Jan 2007, 22:26
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
20 Jan 2007, 09:42
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
20 Jan 2007, 21:28
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
21 Jan 2007, 14:53
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
21 Jan 2007, 20:31
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
22 Jan 2007, 20:52
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
22 Jan 2007, 22:20
lol sure. I'll PM you temp admin details.

Delphiprogrammi
23 Jan 2007, 13:49
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
23 Jan 2007, 16:40
Excellent, thanks for the fix :D

Celtkin
24 Jan 2007, 11:27
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
25 Jan 2007, 06:07
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
26 Jan 2007, 12:15
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
04 Feb 2007, 00:28
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
04 Feb 2007, 08:29
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
04 Feb 2007, 12:29
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
04 Feb 2007, 12:41
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
04 Feb 2007, 13:02
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
04 Feb 2007, 13:17
LoRL, it has happened to all of us, don't worry! Nice work.

NFLfbJunkie
08 Feb 2007, 02:22
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
08 Feb 2007, 13:01
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
08 Feb 2007, 14:05
Thank you so much for the quick reponse. This very useful MOD is working great on my board.

NFLfbJunkie
08 Feb 2007, 15:06
Is there a way to remove the vBulletin "Give Infraction" link that shows in the user's profile and the icon https://www.vbulletin.org/forum/external/2007/02/12.gif that shows in the postbit?

Steeler Nation
08 Feb 2007, 15:18
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
10 Feb 2007, 12:21
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
11 Feb 2007, 20:56
Is there a way to remove the vBulletin "Give Infraction" link that shows in the user's profile and the icon https://www.vbulletin.org/forum/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
11 Feb 2007, 20:59
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
14 Feb 2007, 11:10
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
14 Feb 2007, 11:19
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
14 Feb 2007, 13:29
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
14 Feb 2007, 17:25
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
15 Feb 2007, 19:02
im sure this has been answered...

can we upgrade from 3.5.4 to 3.6.x?

alexhirurg
16 Feb 2007, 14:55
Authors Ignorred My Posts ?

sv1cec
16 Feb 2007, 16:52
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
16 Feb 2007, 17:07
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
16 Feb 2007, 17:09
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
16 Feb 2007, 17:13
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
19 Feb 2007, 22:16
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
24 Feb 2007, 12:40
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
24 Feb 2007, 14:35
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
24 Feb 2007, 22:54
Is it possible to moderators warn other moderators using this hack? If not, would it be possible in a near future?

Delphiprogrammi
25 Feb 2007, 20:09
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
25 Feb 2007, 22:14
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
27 Feb 2007, 16:23
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
08 Mar 2007, 11:46
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
08 Mar 2007, 18:36
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
08 Mar 2007, 18:43
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
31 Mar 2007, 18:39
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
07 Apr 2007, 18:42
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
13 Apr 2007, 17:09
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
14 Apr 2007, 07:56
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
17 Apr 2007, 08:00
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
17 Apr 2007, 09:36
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
17 Apr 2007, 16:05
thank you thats what it was