Advanced Warning System (Beta Version)

[Delphiprogrammi]

first quesiton:

all the postbit modifications...should i be altering the postbit_legacy also???

also the instructions say:



when i look in my postbit_legacy i see:

<if condition="$post['signature'] AND !$vboptions['shownsigs'][$post[userid]] AND $vboptions['shownsigs'][$post[userid]] = true">

what do i do?

if you use postbit_legacy then yes ...... postbit is the "default" template in 3.5.x .The code sample you posted above tells me you have some other hack installed that involves signatures as that's not "standard" vb's template code.I don't have the time nor the patience to support third party hacks

[GoTTi]

I don't have the time nor the patience to support third party hacks

good thing im not asking you to support third party hacks. im asking you how do i fit the AWS code into the code i currently have. what should it look like? do i NEED to replace the code? can i add it to the postbit_legacy?

[Delphiprogrammi]

good thing im not asking you to support third party hacks. im asking you how do i fit the AWS code into the code i currently have. what should it look like? do i NEED to replace the code? can i add it to the postbit_legacy?

you could try it like this


<if condition="$post['signature'] AND !$vboptions['shownsigs'][$post[userid]] AND $vboptions['shownsigs'][$post[userid]] = true"
AND (($vboptions[warn_sig_thresshold]<0 AND $post[warning_level]>=$vboptions[warn_sig_thresshold]) OR $vboptions[warn_sig_thresshold]==0)">


but i suggest you make you a note there in the code so if it causes errors you can easly find it back


<!-- aws signatures -->
<if condition="$post['signature'] AND !$vboptions['shownsigs'][$post[userid]] AND $vboptions['shownsigs'][$post[userid]] = true
AND (($vboptions[warn_sig_thresshold]<0 AND $post[warning_level]>=$vboptions[warn_sig_thresshold]) OR $vboptions[warn_sig_thresshold]==0)">
<!--end off aws signatures -->


that should get both things working

[Marcus Lau]

Is it good for 3.5.4?

[GoTTi]

my users can see the warning levels and points for other users. is that suppose to be that way?

[GoTTi]

Is it good for 3.5.4?

yea this works perfect for 354

[Delphiprogrammi]

my users can see the warning levels and points for other users. is that suppose to be that way?

there is a setting that controls that however it's default value is 'mgm' which means managment team (your mods supermods or admins) can see it normal users cannot(unless there own warnings offcource) it's in the warning options page

[GoTTi]

yea its set to mgm, but there are users seeing warnings for others in the postbit.

i use the legacy style.

on the left side, some people are seeing warnings for a user and some arent seeing the warnings.

[Delphiprogrammi]

people,

I have been playing with vbulletin 3.6.0 and i can tell you aws will not work on 3.6.0 and i feel it is pretty useless to port it why ?

well 3.6.0 includes a system called "infractions" which is much more advanced ... also ....

all users who use the aws hack and are planning (or already did) upgrade to 3.6.0 please read this

you'll probably want to uninstall this hack.When you do it will erase all the database settings used BUT VBULLETIN 3.6.0 USES A FIELD WITH THE SAME NAME so ... if this has happend to you run


ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL default '0';


keep tableprefixes in mind ...

[Hornstar]

people,

I have been playing with vbulletin 3.6.0 and i can tell you aws will not work on 3.6.0 and i feel it is pretty useless to port it why ?

well 3.6.0 includes a system called "infractions" which is much more advanced ... also ....

all users who use the aws hack and are planning (or already did) upgrade to 3.6.0 please read this

you'll probably want to uninstall this hack.When you do it will erase all the database settings used BUT VBULLETIN 3.6.0 USES A FIELD WITH THE SAME NAME so ... if this has happend to you run


ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL default '0';


keep tableprefixes in mind ...


I plan on updating to 3.6 like most when it is in final

so, explain again what steps should be done to totally uninstall this hack so nothing goes wrong with 3.6.

I didnt fully understand the above.

Thanks

[peterska2]

If you are upgrading to 3.6.0 you need to UNINSTALL this modification before starting the upgrade, otheriwse it deletes the field with the same name in the user table.

[GoTTi]

that sucks i just installed this mod to....

why is 3.6 coming so soon?????doesnt make sense.

[EdQ]

3.6 beta is already out

[GoTTi]

delphi what should i do?

the usergroup setting is set to MGM and some users are able to see warning points.

[Delphiprogrammi]

delphi what should i do?

the usergroup setting is set to MGM and some users are able to see warning points.

normal users ? eg without any special rights like mod supermod etc ...

i restored my live site to 3.5.4 cause some of the scripts i was using need updated to work with 3.6 (beta 1) i will check that under a normal account

but right now i need a break

[Delphiprogrammi]

If you are upgrading to 3.6.0 you need to UNINSTALL this modification before starting the upgrade, otheriwse it deletes the field with the same name in the user table.

you're right that's better

[Syrupymonkey]

How do I install it? :(!

[GoTTi]

more of my users are reporting to see other users points.

[GoTTi]

i warned a user and got this display on the postbt afterwards:

[Delphiprogrammi]

i warned a user and got this display on the postbt afterwards:

that looks like a messed up templates. hmmmz i don't have that here......

as for the points viewable by normal members problem i cannot reproduce it you need to ask that reporting members how they do it (precise)

[Delphiprogrammi]

How do I install it? :(!

1)download the latest zip
2)upload the needed files to there default locations
3)goto your admincp directory => plugin system => products => add a new product
4)import product-aws.xml
5)edit templates as explained in /docs/readme.txt of the zip file
6) all done

[oberheimhaven]

Warning: Unknown(/home/niceman/public_html/forums/includes/functions_warning.php): failed to open stream: No such file or directory in /global.php(349) : eval()'d code on line 7

Fatal error: (null)(): Failed opening required '/home/niceman/public_html/forums/includes/functions_warning.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/niceman/public_html/forums/global.php(349) : eval()'d code on line 7

I cant even get on anyone wanting to make some money contact me asap to get this fixed I cant get in my forums at all

[Delphiprogrammi]

Warning: Unknown(/home/niceman/public_html/forums/includes/functions_warning.php): failed to open stream: No such file or directory in /global.php(349) : eval()'d code on line 7

Fatal error: (null)(): Failed opening required '/home/niceman/public_html/forums/includes/functions_warning.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/niceman/public_html/forums/global.php(349) : eval()'d code on line 7

I cant even get on anyone wanting to make some money contact me asap to get this fixed I cant get in my forums at all

no money needed /includes/functions_warning.php is not where the system aspects
to find that file upload it to your vbulletin includes folder in acii mode

[oberheimhaven]

no money needed /includes/functions_warning.php is not where the system aspects
to find that file upload it to your vbulletin includes folder in acii mode

Thxs now I went to viewsytem setting and it banned all my users???? And one i cant un ban!! Oh lord any suggestions would be priceless at this point I sent letters to all my members telling them so sorry it was a feature and Im new LOL

thx

also it has this is my member list
User Name Posts Avatar
admn
Administrator 0 d class="alt1">
dylansue
Administrator 0 d class="alt1">
Muffy
Administrator 1 d class="alt1">
oberheimhaven
Administrator 58 d class="alt1">
Treadwell
Junior Member 0 d class="alt1">
wenrac1970
Administrator 1 d class="alt1">
?? HELP me PLEASEEEEEEEEEEEEEEEE

[oberheimhaven]

everytime i add a user it bans them think Im going to un install anyone here wantto make a few bucks e mail me
Niceman626@aol.com
I give up

[oberheimhaven]

1)download the latest zip
2)upload the needed files to there default locations
3)goto your admincp directory => plugin system => products => add a new product
4)import product-aws.xml
5)edit templates as explained in /docs/readme.txt of the zip file
6) all done


However is whacked bans members when added?

[Delphiprogrammi]

However is whacked bans members when added?

there is no way this hack would do that unless you have so strong limits .... please check your warning limit options and in the warningtypes did you activated permanent ban ?

[barca4ever]

Great mod ;) installed

1. Is there's a way to soft-delete the thread/post automatically after the warning?
2. Why the thread's link in the automatic PM is not clickable?
3. Is there's a way to give a specif moderator the premission to issue warnings instead of giving the permission to the whole moderator's group?

[Bubble #5]

3. Is there's a way to give a specif moderator the premission to issue warnings instead of giving the permission to the whole moderator's group?
An 'if' statement should fix this ;)

[sv1cec]

1. No, vB provides tools for that, or you can install the In-Line Moderation hack, which helps you do that.
2. Most probably a mistake in the corresponding template.
3. Put that moderator in his own group and set that group as moderator group in the Warning System Options.

[Gujulvr]

Hi, this ads-on works great, i installed it and everythin and edited the template but however i dont see users warning leavel points in user postbit (users info in his every post like) yaa i have edited the template. then how come it doesnt shows up?

[barca4ever]

1. No, vB provides tools for that
Thanks sv1cec for your reply ;) can you point for me where in the code I can add the soft-delete command.

Is it possible to include in the PM to to the warned users the (thread's title and forum's name) in addition to the thread's links?

[sv1cec]

Hi, this ads-on works great, i installed it and everythin and edited the template but however i dont see users warning leavel points in user postbit (users info in his every post like) yaa i have edited the template. then how come it doesnt shows up?

Only if a user has warning points, they will show. Users with no warning points show nothing.

[sv1cec]

Thanks sv1cec for your reply can you point for me where in the code I can add the soft-delete command.

Is it possible to include in the PM to to the warned users the (thread's title and forum's name) in addition to the thread's links?


If you implement such a thing, every post that receives a warning, will be deleted. You do not want to do that, some posts can be warned for reasons which do not guarantee their deletion.

Everything is possible, but with the link provided, the user can click on it and see where his post was, in which forum and in which thread.

[barca4ever]

If you implement such a thing, every post that receives a warning, will be deleted. You do not want to do that, some posts can be warned for reasons which do not guarantee their deletion.
Yes, I know, this is my aim.

So can you guide me where I can place the delete code for the warned post or thread?

Everything is possible, but with the link provided, the user can click on it and see where his post was, in which forum and in which thread.
Since I'm manulay deleting the post after warning the poster, the poster will not be able to see the deleted post.

So, can you guide me on how I can put the thread's title in the PM?

I'LL APRECIATE YOUR HELP ;)

[sv1cec]

Sorry, I just do not have the time to help you on that.

If you want the poster to see the warned post, activate the option, which includes the warned post, in the PM send to the warned member. Even if you then delete the post, it will be included in the send PM.

[Delphiprogrammi]

hi people,

I'm still alive.My site is upgraded to 3.6 but i don't understand how the "infractions" system works to complacated if you ask me.SOw i'm thingking of getting aws to 3.6 some changes needed for this through

[phiber]

I don't understand.. I have installed the product, but it didn't modificate the postbit_legacy template.. for example:

5. Edit your postbit_legacy template and find:

<if condition="THIS_SCRIPT=='showthread' AND $buttons=='Text'">
<if condition="$showwarnlink==1">

Below that, add:

<if condition="$vbulletin->options['warn_allownotes']==1">
<a href='Warn.php?do=NoteUser&id=$post[userid]&post=$post[postid]'>Add Note for $post[username]</a>&nbsp;</if>

In the same template find:

<if condition="THIS_SCRIPT=='showthread' AND $buttons=='Buttons'">
<if condition="$showwarnlink==1">

I don't find that in my postbit.. what should I do?
Thanks and sorry for my english!

[outlaw621]

hi people,

I'm still alive.My site is upgraded to 3.6 but i don't understand how the "infractions" system works to complacated if you ask me.SOw i'm thingking of getting aws to 3.6 some changes needed for this through
If you decide to do this, I will gladly help you with the beta testing as this is a mod I will miss having.

[AzzidReign]

Thanks! I've been issueing verbal warnings...but lost track of who I was warning and who I wasnt! :)

Also, I'm getting a weird thing going with the posts...they are being centered or something.... anyone else having this problem? Is there a fix?

Check attachment:

[sv1cec]

Phiber, you are not reading the proper instructions. The part that you posted above, is from the instructions on how to add the Notes capability, in an already installed AWS. Check the instructions included in the AWS zip file.

[AzzidReign]

I think I figured out my problem...I just dont know how to fix it. There is a glitch with the signature tag (at least in firefox, I havent tested in IE). When there is no signature, the post will be made centered vertically.

Do you know how to fix them sv1cec?

[sv1cec]

Start with a new template and edit it according to the instructions.

[phiber]

sv1cec thanks for your previous answer!

And now another... xD, yesterday I had a "problem" with a Moderator because he remove accidentaly my warn to a user... How can I avoid that? How can only a Mod remove their own? And SMods their own and Moderators ones, and Admins all? or SMods and Admins all...

Thanks in advance!

Edit: Oh, I have just seen and answer for that problem, but for unable the remove warning to mods and smods... How to remove only for mods? And there you said only "fake" remove, but not delete... How to restore a Warn removed by a Mod?

Thanks again, and sorry my English!

[sv1cec]

It's doable, but you have to run an SQL query, and since this can mess up your database, I would not like to give you more details. You'd better remove the warning all together, and explain the member that if he does the same, he is doomed.

[phiber]

LOL, Ok, Thanks ^^

[Delphiprogrammi]

how about a permission control the admin can set "can issue warnings" to yes and "can remove warnings" to no .... that would solve his problem

Restoring a removed warning is possible but like John already said it's kind of risky.

1)open /includes/xml/bitfield_aws.xml and find


<bitfield name="canviewwarnings" group="awspermissions" phrase="canview_warnings">8</bitfield>


below that add


<bitfield name="canremovewarnings" group="awspermissions" phrase="canremove_warns">16</bitfield>


save this file and upload it to /includes/xml folder

2)go into your admincp and add a new phrase

varname:canremove_warns
text:can remove warnings ?
phrasetype:permissions
product:aws

save the phrase

3)open Warn.php and find


if($_GET['do'] == "RemoveWarning")
{
$vbulletin->input->clean_array_gpc('g',array(
'id' => TYPE_INT,
'post' => TYPE_INT,
'do' => TYPE_STR,
'return' => TYPE_STR,
));


just below that


if (!($vbulletin->userinfo['permissions']['awspermissions'] & $vbulletin->bf_ugp_awspermissions['canremovewarnings']))
{
RunErrorAws("you do not have permission to remove warnings");
}


4) edit your usergroups where you want to enable / disable the new permission usergroups => edit also remember to rebuild the vbulletin bitfieldcache you can do this by pointing your browser to

www.yourserver.com/forums/admincp/index.php?do=buildbitfields

that should do it if not give me a yell

[barca4ever]

Is there's a way to prevent super-moderators and moderators from removing warnings?

In other words, I want only administrators can remove a warning

Thanks in advance ;)

[bigM]

I have forgotten to refresh the AdminCP. Problem has been fixed ;)

[Delphiprogrammi]

Is there's a way to prevent super-moderators and moderators from removing warnings?

In other words, I want only administrators can remove a warning

Thanks in advance ;)

here (https://vborg.vbsupport.ru/showpost.php?p=1031548&postcount=1048) hint set that permission to no for moderators and supermoderators

[FatalBreeze]

i like your hack very much thanks :)
i just have a little comment: in the install file (txt), in a template modification, you spelled $vbphase[...] instead of $vbphrase.
im sorry but i dont remember exactly where it is, but use ctrl+f.

[GoTTi]

for some reason, when a user gets warned, the post they are warned on gets all wierd looking.

attached is a example.

what is causing this?

[EdQ]

hi people,

I'm still alive.My site is upgraded to 3.6 but i don't understand how the "infractions" system works to complacated if you ask me.SOw i'm thingking of getting aws to 3.6 some changes needed for this through


That would be great! I am still using your Mod on 3.6.0

[Delphiprogrammi]

for some reason, when a user gets warned, the post they are warned on gets all wierd looking.

attached is a example.

what is causing this?

yes you edited that template incorrectly ... or does it only happen when you use the this hack ? then i would check the code involved on postbit & postbit_legacy template

[shockx5]

So I have 3.5.4 and am using the version before the current AWS...do i just upload all the files again and the product to update? Or do I need to uninstall the product and reinstall the new one along with uploading the new files. The original version has been acting screwy with people not being banned when the correct number of warnings is reached etc.

[Gaileypoo]

I tried a test run on a regsitered user account, and when i tried to view my warnings it came up with this "You do not have permissions to view warnings information"

What happened? :\ I set it to "ALL" to viewing warnings.

[Delphiprogrammi]

I tried a test run on a regsitered user account, and when i tried to view my warnings it came up with this "You do not have permissions to view warnings information"

What happened? :\ I set it to "ALL" to viewing warnings.

A normal user cannot view warnings unless the warning issued to themself the setting you refer to is for mods and up

[Gaileypoo]

Oh.. I see. Thank you.

I have another problem though. =\ I set up "auto warns" for obscene words , but for some reason, it's not working. I set up the right ID and everything. Created a warning type "ObsceneWords" I did a test on this too and the warning didn't show up on me.

Also.. if I uninstall and reinstall AWS, will I lose all warnings and bans made through AWS?

Thanks for the info~

[Delphiprogrammi]

Oh.. I see. Thank you.

I have another problem though. =\ I set up "auto warns" for obscene words , but for some reason, it's not working. I set up the right ID and everything. Created a warning type "ObsceneWords" I did a test on this too and the warning didn't show up on me.

Also.. if I uninstall and reinstall AWS, will I lose all warnings and bans made through AWS?

Thanks for the info~

did you enable automatic warnings ? also did you enable your forum censor and enter some words to be censored for example enter "++++" "pussy" into that box when a user trys to use one of these words in a post (and automatic warnings are on) then he is busted ....

you will not loose the warnings information if you create a backup of it through phpMyAdmin

Also make sure 'ObsceneWords' warningtype is set to "Auth"(short for automatic)

[engedi05]

in the readme text.. it said, Upload the Files in Folder upload to the appropriate Directories.

what is the appropriate Directories?

[engedi05]

excuse me.. how do i import the xml detail? is this a plug in xml?

[Delphiprogrammi]

in the readme text.. it said, Upload the Files in Folder upload to the appropriate Directories.

what is the appropriate Directories?

just follow the vbulletin directory structory upload the contents from /includes to /forum/includes etc :knockedout:

[Delphiprogrammi]

excuse me.. how do i import the xml detail? is this a plug in xml?

admincp => plugins & products => manage products => add (as a product)

[Delphiprogrammi]

news,

aws is running on my 3.6.0 RC 3 system.Since these are my first tests the system isn't quite ready ready "enough" for a public release nut it's running good so far

[sv1cec]

Great news Delphi! Great news.

[outlaw621]

Yes. Great news indeed. Cant wait for an updated release. This was the most valuable hack I had installed.

[Delphiprogrammi]

hi people,

I am building the admincp interface.I gotta start all over and build a product file in 3.6.x format (jelsoft changed some stuff in the products system)The phrases part needs some changes to since the phrasetypeid field is removed(phrases are identified through there fieldname)So far it's running good a MySQL error here and there but therefor i am doing tests to catch and fix them

i changed the warnings field in the user table to warns because vbulletin's new infraction system also uses a field called warnings there (avoid conflicts)

the sourcefiles will need to be updated to use the new field

/me goes of to have a beer

updated
John,

Wouldn't it be beter to just leave the "warnings" in place in the user table (and remove the code from the install / uninstall )

vbulletin only uses that field if you use the infraction system so to save some work (and have a system ready earlier) i'm *thinking* about this don't know if this is good through need some advise

[eilrahC]

will this work on 3.5.4 ? or is there another Warnign system for 3.5.4 ?

[sv1cec]

Well, if vB is using one of AWS columns, you'd better create new ones. You never know if a user will activate both the AWS and vB's infractions together.

Also, maybe it is a good time to change the names in the program. I have found that some people get frustrated when "warned". Those types who ask you "Are you threatening me?" when you just tell them they did something silly or against the rules. Maybe we should change the "warning" to "ticket" ? I do not know, I can't think of another word.

Also, one more thing.

In the admin_warn.php, there is a small bug. Consider this situation:

- a member has received a warning for 4 points.
- the moderator who warned him made a mistake and issued the wrong warning type.
- since the moderator is not very experienced he "removes" the warning and then issues a new one let's say for 3 points.
- the administrator sees that and decides to completely remove the first warning, since it shouldn't be in the user's record.
- The "Complete Remove" code removes the first warning, but also removes 4 more points from the user, thus the user ends up with zero points. In other words, the Complete Remove code does not separate between deleting an active warning and an inactive one.

A small piece of code in the form of:


if ($warn['warned_status']=='A')
{
$level=($warn['warning_level']-$warn['warn_points']);
}
elseif ($warn['warned_status']=='I')
{
$level=($warn['warning_level']);
}


is needed in the "completeremove" section of admin_warn.php, to separate between removing active and inactive warnings.

Another good idea is to change the wording for remove and complete remove. Maybe the "Remove Warning" should be renamed to "Mature Warning"??

Email me if you want to discuss these further.

Rgds

[Delphiprogrammi]

will this work on 3.5.4 ? or is there another Warnign system for 3.5.4 ?

Yes it will work but be advised jelsoft released 3.5.5 because 3.5.4 contains a hole

[Delphiprogrammi]

hi people,

If you use this system availible right now on a vbulletin 3.6.x system (whatever version) the "view banned users" in the aws menu will not work

reason = jelsoft changed the isbannedgroup permission to isnotbannedgroup

I fixed this already...

[Delphiprogrammi]

Well, if vB is using one of AWS columns, you'd better create new ones. You never know if a user will activate both the AWS and vB's infractions together.


Allright that will mean new fields because the infractions system cannot be disabled.You can only take away permissions to give or view them.Jelsoft stole our field lol

[MajorFm.com]

Ok small problem, just installed, i had the previous version already installed on my previous version of vb, so i want to keep all existing warn data, so i assume i don't delete existing tables etc...

I got this error when importing the product:

Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'warn_hierarchical',
'warning',
'1',
'1',
'free',
'yesno',
2,
0,
1,
'aws'
),
(
'warn_automatic',
'warning',
'0',
'1',
'free',
'yesno',
3,
0,
1,
'aws'
),
(
'warn_automaticpm',
'warning',
'0',
'0',
'free',
'yesno',
4,
0,
1,
'aws'
),
(
'warn_autocomments',
'warning',
'0',
'0',
'free',
'yesno',
5,
0,
1,
'aws'
),
(
'warn_automatic_warner',
'warning',
'11223',
'1',
'free',
'',
6,
0,
1,
'aws'
),
(
'warn_warner',
'warning',
'0',
'0',
'free',
'',
7,
0,
1,
'aws'
),
(
'warn_collector',
'warning',
'1',
'1',
'free',
'',
8,
0,
1,
'aws'
),
(
'warn_banned_limit',
'warning',
'7',
'7',
'free',
'',
9,
0,
1,
'aws'
),
(
'warn_points_before_banned',
'warning',
'90',
'10',
'free',
'',
10,
0,
1,
'aws'
),
(
'warn_warnings_before_banned',
'warning',
'3',
'10',
'free',
'',
11,
0,
1,
'aws'
),
(
'warn_banned_usergroup_id',
'warning',
'8',
'8',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
12,
0,
1,
'aws'
),
(
'warn_protected_usergroups',
'warning',
'6',
'',
'free',
'',
13,
0,
1,
'aws'
),
(
'warn_troll_usergroup_id',
'warning',
'8',
'9',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
14,
0,
1,
'aws'
),
(
'warn_restore_groupid',
'warning',
'0',
'2',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
15,
0,
1,
'aws'
),
(
'warn_incr_ban_days',
'warning',
'1',
'1',
'free',
'yesno',
16,
0,
1,
'aws'
),
(
'warn_max_no_bans',
'warning',
'3',
'3',
'free',
'',
17,
0,
1,
'aws'
),
(
'warn_bans_mature',
'warning',
'0',
'0',
'free',
'',
18,
0,
1,
'aws'
),
(
'warn_viewoption',
'warning',
'Mgm',
'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,
'aws'
),
(
'warn_multiple_per_post',
'warning',
'0',
'1',
'free',
'yesno',
20,
0,
1,
'aws'
),
(
'warn_send_em_warning',
'warning',
'1',
'1',
'free',
'yesno',
21,
0,
1,
'aws'
),
(
'warn_send_pm_warning',
'warning',
'1',
'0',
'free',
'yesno',
22,
0,
1,
'aws'
),
(
'warn_email_on_ban',
'warning',
'1',
'1',
'free',
'yesno',
23,
0,
1,
'aws'
),
(
'warn_historical',
'warning',
'1',
'1',
'free',
'yesno',
24,
0,
1,
'aws'
),
(
'warn_allowoffpost',
'warning',
'1',
'1',
'free',
'yesno',
25,
0,
1,
'aws'
),
(
'warn_warnings_per_page',
'warning',
'0',
'15',
'free',
'',
26,
0,
1,
'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,
'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,
'aws'
),
(
'warn_sig_thresshold',
'warning',
'0',
'0',
'free',
'',
29,
0,
1,
'aws'
),
(
'warn_avatar_thresshold',
'warning',
'0',
'0',
'free',
'',
30,
0,
1,
'aws'
),
(
'warn_aprotected_usergroups',
'warning',
'',
'',
'free',
'',
31,
0,
1,
'aws'
),
(
'warn_pmcutoff',
'warning',
'0',
'0',
'free',
'',
32,
0,
1,
'aws'
),
(
'warn_admingroups',
'warning',
'6',
'',
'free',
'',
33,
0,
1,
'aws'
),
(
'warn_smodgroups',
'warning',
'5',
'',
'free',
'',
34,
0,
1,
'aws'
),
(
'warn_modgroups',
'warning',
'7',
'',
'free',
'',
35,
0,
1,
'aws'
),
(
'warn_includepost',
'warning',
'1',
'0',
'free',
'yesno',
36,
0,
1,
'aws'
),
(
'warn_savecopy',
'warning',
'1',
'0',
'free',
'yesno',
37,
0,
1,
'aws'
),
(
'warn_savecopyalert',
'warning',
'1',
'0',
'free',
'yesno',
38,
0,
1,
'aws'
),
(
'warn_savecopyforum',
'warning',
'166',
'',
'free',
'',
39,
0,
1,
'aws'
),
(
'warn_allowalerts',
'warning',
'1',
'0',
'free',
'yesno',
40,
0,
1,
'aws'
),
(
'warn_allowalertscomment',
'warning',
'1',
'0',
'free',
'yesno',
41,
0,
1,
'aws'
),
(
'warn_alertslifetime',
'warning',
'30',
'0',
'free',
'',
42,
0,
1,
'aws'
),
(
'warn_allownotes',
'warning',
'1',
'1',
'free',
'yesno',
43,
0,
1,
'aws'
),
(
'warn_version',
'warning',
'3.4.16',
'3.5.4',
'free',
'',
44,
0,
1,
'aws'
);

MySQL Error : Duplicate entry 'warn_hierarchical' for key 1
Error Number : 1062
Date : Saturday, August 5th 2006 @ 11:16:40 AM
Script : http://www.majorfm.com/forum/admincp/plugin.php
Referrer : http://www.majorfm.com/forum/admincp/plugin.php?do=productadd
IP Address : 82.25.***.***
Username : AJ
Classname : vb_database

Please advise what do to, in done everything else but see no changes on my forum!

[Hornstar]

I've now upgraded to VB3.6 uninstalled this hack to use the infractions (may install this again if it becomes supported for 3.6 but until then am trying to get used to infractions lol.)

however I just got a database error and i think part of the code is not removed in the database. How do I uninstall it completely?

Thanks

[Delphiprogrammi]

Ok small problem, just installed, i had the previous version already installed on my previous version of vb, so i want to keep all existing warn data, so i assume i don't delete existing tables etc...

I got this error when importing the product:



Please advise what do to, in done everything else but see no changes on my forum!

previous version ? the vb 3 version ? then you must run uninstall.php before you install the 3.5.x version.You must create a back from this tables


user
warnings
warning_types
pmtext_warned
warn_notes
ban_dates
post


then you can restore this later on .....I suggest you start with clean 3.5.x files you can try to run this


SELECT * FROM " . TABLE_PREFIX . "setting WHERE varname like 'warn_%';


that will return all the settings used by the system.If you don't want them any longer


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


allthrough be carefull with this and keep tableprefixex in mind

[Delphiprogrammi]

I've now upgraded to VB3.6 uninstalled this hack to use the infractions (may install this again if it becomes supported for 3.6 but until then am trying to get used to infractions lol.)

however I just got a database error and i think part of the code is not removed in the database. How do I uninstall it completely?

Thanks

and what would the database error be ?

[d2sector]

I have un-installed it to use the vb 3.6.0 infraction system and im getting this error. ?



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, options + 32),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
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 - 64, options),
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 = 'GFX Freak and SuperMod',
customtitle = 2,
username = 'FrogMan',
email = '',
languageid = 0,
homepage = '',
birthday_search = '1983-08-16',
birthday = '08-16-1983',
showbirthday = 2,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
referrerid = 0,
ipaddress = '196.25.255.210',
posts = 1979,
usergroupid = 6,
displaygroupid = 0,
reputationlevelid = 5,
reputation = 32,
warnings = 0,
infractions = 0,
ipoints = 0,
autosubscribe = 0,
threadedmode = 0,
showvbcode = 2,
styleid = 0,
timezoneoffset = '2',
daysprune = 0,
joindate = 1125867720,
lastactivity = 1154904420,
lastpost = 1154904360,
membergroupids = ''
WHERE userid = 10184;

MySQL Error : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date : Monday, August 7th 2006 @ 04:08:00 AM

[Delphiprogrammi]

I have un-installed it to use the vb 3.6.0 infraction system and im getting this error. ?



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, options + 32),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
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 - 64, options),
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 = 'GFX Freak and SuperMod',
customtitle = 2,
username = 'FrogMan',
email = '',
languageid = 0,
homepage = '',
birthday_search = '1983-08-16',
birthday = '08-16-1983',
showbirthday = 2,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
referrerid = 0,
ipaddress = '196.25.255.210',
posts = 1979,
usergroupid = 6,
displaygroupid = 0,
reputationlevelid = 5,
reputation = 32,
warnings = 0,
infractions = 0,
ipoints = 0,
autosubscribe = 0,
threadedmode = 0,
showvbcode = 2,
styleid = 0,
timezoneoffset = '2',
daysprune = 0,
joindate = 1125867720,
lastactivity = 1154904420,
lastpost = 1154904360,
membergroupids = ''
WHERE userid = 10184;

MySQL Error : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date : Monday, August 7th 2006 @ 04:08:00 AM


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


ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';


keep TABLE_PREFIX in mind.....

this error will be gone now

[Hornstar]

That was the database error I have above.

I tried
ALTER TABLE user ADD vb3_warnings INT UNSIGNED NOT NULL DEFAULT '0';


But got this error


An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'gamerzne_backup.user' doesn't exist


What should I try now?

[Hornstar]

ALTER TABLE vb3_user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0'; I had the table prefix in the wrong spot.

Thanks.

[sv1cec]

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

Let me know.

[Delphiprogrammi]

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

Let me know.

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

[sv1cec]

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

[RMS-Chef]

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


ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';


keep TABLE_PREFIX in mind.....

this error will be gone now

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

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

[Delphiprogrammi]

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

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

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

[Tayeb]

Hello,

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

Database error in vBulletin 3.5.5:

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

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

Any idea? I have just installed the warning system.

I'll appreciate any help.

Tayeb

[Delphiprogrammi]

Hello,

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

Database error in vBulletin 3.5.5:

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

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

Any idea? I have just installed the warning system.

I'll appreciate any help.

Tayeb

you do not have a warnings field in your user table


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


keep tableprefixes in mind ...

[Delphiprogrammi]

hi people,

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

[dutchbb]

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

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

[dutchbb]

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

[Delphiprogrammi]

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

you need a slightly different query for the infraction system


ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';


*= don't forget table prefixes

[Tayeb]

Dear Delphi,

On permanent banning I got the following error:

Database error in vBulletin 3.5.5:

Invalid SQL:

UPDATE user SET
usergroupid = 4,
displaygroupid = 4,
warnings=2,
warning_bans = 1,
usertitle = 'Permanently Banned'
WHERE userid = 1571;

MySQL Error : Unknown column 'warning_bans' in 'field list' Error Number : 1054
Date : Monday, August 14th 2006 @ 10:07:12 AM
Script : http://myiwc.com/forums/Warn.php
Referrer : http://myiwc.com/forums/Warn.php?do=WarnUser&id=1571&post=25317
IP Address : xx.xxx.xx.xx
Username : xxx
Classname : vb_database

Can you help please? The other problem got sorted out with your help.

Tayeb

[Delphiprogrammi]

Dear Delphi,

On permanent banning I got the following error:

Database error in vBulletin 3.5.5:

Invalid SQL:

UPDATE user SET
usergroupid = 4,
displaygroupid = 4,
warnings=2,
warning_bans = 1,
usertitle = 'Permanently Banned'
WHERE userid = 1571;

MySQL Error : Unknown column 'warning_bans' in 'field list' Error Number : 1054
Date : Monday, August 14th 2006 @ 10:07:12 AM
Script : http://myiwc.com/forums/Warn.php
Referrer : http://myiwc.com/forums/Warn.php?do=WarnUser&id=1571&post=25317
IP Address : xx.xxx.xx.xx
Username : xxx
Classname : vb_database

Can you help please? The other problem got sorted out with your help.

Tayeb

you don't have a warning_bans field in the user table ? try this


DESCRIBE user;


if the warning_bans field is not there


ALTER TABLE user ADD warning_bans INT(2) DEFAULT '0';


*=keep table prefixes in mind or the queries won't work

[UZFRED]

How can I fully uninstall this modification so I'm sure nothing is left in my database?

[Delphiprogrammi]

How can I fully uninstall this modification so I'm sure nothing is left in my database?

uninstall the product.All associated settings & phrases & templates will be deleted (don't forget to delete the files from your webspace)If you are still able to find database entries that belong to this system then you have a verry old version installed which you have never deleted ?

if you used a version from before 3.5.x (thus before the product system was introduced) and you didin't run the uninstaller before installing the 3.5.x port then that stuff will be still in your databse

[dutchbb]

you need a slightly different query for the infraction system


ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';


*= don't forget table prefixes
Oops! Already done the query that was posted earlyer (ALTER TABLE user ADD warnings INT(5) DEFAULT '0'; ), when i try it again with the query you posted I got


ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';

#1060 - Duplicate column name 'warnings'

What should I do?
Thank you

[Delphiprogrammi]

Oops! Already done the query that was posted earlyer (ALTER TABLE user ADD warnings INT(5) DEFAULT '0'; ), when i try it again with the query you posted I got




What should I do?
Thank you

if the warning_bans field is in the user table MySQL should not tell you the field is missing ..

[Delphiprogrammi]

3.6.0 is running on my live board :D we are getting there ....

[dutchbb]

if the warnings field is in the user table MySQL should not tell you the field is missing ..
I know... the warning field is there, but I used a slightly different query to make it. See my posts. Is that a problem?

[Delphiprogrammi]

I know... the warning field is there, but I used a slightly different query to make it. See my posts. Is that a problem?

yes that can cause database errors run this


ALTER TABLE user DROP warning_bans;
ALTER TABLE user ADD COLUMN warning_bans INT(2) DEFAULT '0';


now i would test it.Define a warningtype that would cause a ban when it get's issued and see what happends

[dutchbb]

I think you mean "warnings" instead of "warning_bans" ?

Because with the last SQL you gave I got
#1091 - Can't DROP 'warning_bans'; check that column/key exists

[Delphiprogrammi]

I think you mean "warnings" instead of "warning_bans" ?

Because with the last SQL you gave I got

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

this is your error message from the first post you posted about it.MySQL says it doesn't know the "warning_bans" column.This field is used when warningtypes are issued that cause a ban (temprary or permanent) that column is in the standard vbulletin user table.To see if the field is missing


DESCRIBE user;


this will show you the "raw" table SQL.If the field it is indeed missing


ALTER TABLE user ADD COLUMN warning_bans INT(2) DEFAULT '0';

[dutchbb]

Strange...I never posted that error, I think you have confused me with another user?

[Delphiprogrammi]

Strange...I never posted that error, I think you have confused me with another user?

oeps your right you upgraded to 3.6 and you did have a problem with the warnings field beinng removed from the vbulletin 3.6 infraction system.The correct query for the warnings field from the infraction system is


ALTER TABLE user ADD COLUMN warnings INT UNSIGNED NOT NULL DEFAULT '0';


you can see this in your vbulletin zip package at upload/install/mysql-schema.php line 1816

i'm verry sorry about the confusion i'm an idiot

[dutchbb]

Thanks

[Mysticales]

Hey all, for 3.5.4 with alot of mods, and patched with those two 3.5.5 files. Was wondering, I saw this is kinda just been sitting here and so, was wondering, is this still worth installing or should something else be used?

Just wondering how stable it is for a large forum and how secure youd feel installing it. Or if someone can fill me in. =)

[sv1cec]

Version 3.5.x is pretty stable by now and pretty secure.

Delphi is almost finished with the new version for vB 3.6.0. It should be released soon. An announcement will be posted here, on where you can download it and where to get support.

Thanks Delphi!

[Mysticales]

Ok cool, and just to make sure.. This thread is the current release for 3.5, not that there is another or edits elsewhere I should know of?

[jdk10]

3.6.0 version https://vborg.vbsupport.ru/showthread.php?t=124477

[jacks0_0]

How to show Comments in Post ? Who Can help me ?

[Delphiprogrammi]

How to show Comments in Post ? Who Can help me ?

you need to enable the comments system if you want that under warning options.Also download "warn_notes_update_instructions"

[doopz]

nm misreaded.

loving the mod :)

[jacks0_0]

How to show Comments in Post ? Who Can help me ?
Anyone ?

[Delphiprogrammi]

Anyone ?

https://vborg.vbsupport.ru/showpost.php?p=1095290&postcount=1112

also i don't have the time nor the patience to answer the same question multiple times

[iamnofear]

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>',
'',
'[QUOT' at line 4


I got this error, How can I fix it >?

[SnapOff Racing]

everything works PERFECT for me except look what it did to my postbit!

http://i6.photobucket.com/albums/y214/blind26/untitled.jpg

can anyone please help me to get things where they should be?

[SnapOff Racing]

the add not and warn links should be above the post...i have no idea why everything got jumbled...prompt assistance would be greatly appreciated :)

[sv1cec]

I can answer that. You are using a custom set of templates. Obviously the instructions refer to the standard set.

Also, please keep in mind that the instructions in this thread are for those of you running vB 3.5. If you are running vB 3.6, there is a dedicated thread for this hack under that vB version. Here it is:

https://vborg.vbsupport.ru/showthread.php?t=124477

[SnapOff Racing]

please disregard, i found the issue...couple lines of code were off in the postbit legacy :)

[wcbryant]

I recently uninstalled this add-on through the product manager, as I've been having some slow load issues, and I've been going out of my way to cut down on the number of hacks I use. After doing so, when admins try to create new user accounts through admincp, they're getting this error;


Database error in vBulletin 3.6.4:

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 & 131072, options - 131072, options),
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 = 'Newbie',
customtitle = 0,
username = '*',
email = '*@yahoo.com',
languageid = 0,
homepage = '',
birthday_search = '',
birthday = '',
showbirthday = 2,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
referrerid = 0,
ipaddress = '164.62.*.*',
posts = 6,
vbookie_cash = 500,
usergroupid = 2,
membergroupids = '22',
reputationlevelid = 2,
reputation = -750,
warnings = 0,
infractions = 0,
ipoints = 0,
pmpopup = 1,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 2,
styleid = 0,
timezoneoffset = '-5',
daysprune = -1,
joindate = 1102184940,
lastactivity = 1165522680,
lastpost = 1165522140,
vbp_receivespoints = 1,
vbp_storeaccess = 1,
vbbux = 993.911,
vbbank = 0,
vbp_nextbankinterest = 0,
vbp_genericperm = 0,
vbp_modperm = 0,
vbp_adminperm = 0,
vbp_nametextcolor = '',
vbp_nameglowcolor = '',
vbp_nameshadowcolor = '',
vbp_namefonttype = '',
vbp_titletextcolor = '',
vbp_titleglowcolor = '',
vbp_titleshadowcolor = '',
vbp_titlefonttype = '',
vbp_changealwaysitems = '',
### Bitfield: user.vbp_displayflags ###
vbp_displayflags = IF(vbp_displayflags & 1, vbp_displayflags - 1, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 2, vbp_displayflags - 2, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 4, vbp_displayflags - 4, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 8, vbp_displayflags - 8, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 16, vbp_displayflags - 16, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 32, vbp_displayflags - 32, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 64, vbp_displayflags - 64, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 128, vbp_displayflags - 128, vbp_displayflags),
### Bitfield: user.vbp_otherflags ###
vbp_otherflags = IF(vbp_otherflags & 1, vbp_otherflags - 1, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 2, vbp_otherflags - 2, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 4, vbp_otherflags - 4, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 8, vbp_otherflags - 8, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 16, vbp_otherflags - 16, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 32, vbp_otherflags - 32, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 64, vbp_otherflags - 64, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 256, vbp_otherflags - 256, vbp_otherflags),
### Bitfield: user.vbp_immunity ###
vbp_immunity = IF(vbp_immunity & 1, vbp_immunity - 1, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 2, vbp_immunity - 2, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 4, vbp_immunity - 4, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 8, vbp_immunity - 8, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 16, vbp_immunity - 16, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 32, vbp_immunity - 32, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 64, vbp_immunity - 64, vbp_immunity),
displaygroupid = '2'
WHERE userid = 1719;

MySQL Error : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date : Thursday, December 7th 2006 @ 01:18:30 PM
Script : http://www.buckeyeplanet.com/forum/admincp/user.php?do=update
Referrer : http://www.buckeyeplanet.com/forum/admincp/user.php?do=edit&u=1719
IP Address : 165.166.*.*
Username : (admin-name)
Classname : vB_Database_MySQLi


I've read through the archive I used to download, and tried to page through these 75 pages as best I can looking for a clear cut solution, but if one exists, I've over looked it.

Is this as easy as running a couple queries to complete the uninstall, and if so, where might I find those (I have no real comfort level with mysql myself), either way, will any change I make interfere with vB's built in warning system?

Thanks in advance for any help. I probably should have just left AWS disabled instead of flat uninstalling it, but like I said, trying to slim down.

[Delphiprogrammi]

I recently uninstalled this add-on through the product manager, as I've been having some slow load issues, and I've been going out of my way to cut down on the number of hacks I use. After doing so, when admins try to create new user accounts through admincp, they're getting this error;


Database error in vBulletin 3.6.4:

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 & 131072, options - 131072, options),
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 = 'Newbie',
customtitle = 0,
username = '*',
email = '*@yahoo.com',
languageid = 0,
homepage = '',
birthday_search = '',
birthday = '',
showbirthday = 2,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
referrerid = 0,
ipaddress = '164.62.*.*',
posts = 6,
vbookie_cash = 500,
usergroupid = 2,
membergroupids = '22',
reputationlevelid = 2,
reputation = -750,
warnings = 0,
infractions = 0,
ipoints = 0,
pmpopup = 1,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 2,
styleid = 0,
timezoneoffset = '-5',
daysprune = -1,
joindate = 1102184940,
lastactivity = 1165522680,
lastpost = 1165522140,
vbp_receivespoints = 1,
vbp_storeaccess = 1,
vbbux = 993.911,
vbbank = 0,
vbp_nextbankinterest = 0,
vbp_genericperm = 0,
vbp_modperm = 0,
vbp_adminperm = 0,
vbp_nametextcolor = '',
vbp_nameglowcolor = '',
vbp_nameshadowcolor = '',
vbp_namefonttype = '',
vbp_titletextcolor = '',
vbp_titleglowcolor = '',
vbp_titleshadowcolor = '',
vbp_titlefonttype = '',
vbp_changealwaysitems = '',
### Bitfield: user.vbp_displayflags ###
vbp_displayflags = IF(vbp_displayflags & 1, vbp_displayflags - 1, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 2, vbp_displayflags - 2, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 4, vbp_displayflags - 4, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 8, vbp_displayflags - 8, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 16, vbp_displayflags - 16, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 32, vbp_displayflags - 32, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 64, vbp_displayflags - 64, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 128, vbp_displayflags - 128, vbp_displayflags),
### Bitfield: user.vbp_otherflags ###
vbp_otherflags = IF(vbp_otherflags & 1, vbp_otherflags - 1, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 2, vbp_otherflags - 2, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 4, vbp_otherflags - 4, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 8, vbp_otherflags - 8, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 16, vbp_otherflags - 16, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 32, vbp_otherflags - 32, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 64, vbp_otherflags - 64, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 256, vbp_otherflags - 256, vbp_otherflags),
### Bitfield: user.vbp_immunity ###
vbp_immunity = IF(vbp_immunity & 1, vbp_immunity - 1, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 2, vbp_immunity - 2, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 4, vbp_immunity - 4, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 8, vbp_immunity - 8, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 16, vbp_immunity - 16, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 32, vbp_immunity - 32, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 64, vbp_immunity - 64, vbp_immunity),
displaygroupid = '2'
WHERE userid = 1719;

MySQL Error : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date : Thursday, December 7th 2006 @ 01:18:30 PM
Script : http://www.buckeyeplanet.com/forum/admincp/user.php?do=update
Referrer : http://www.buckeyeplanet.com/forum/admincp/user.php?do=edit&u=1719
IP Address : 165.166.*.*
Username : (admin-name)
Classname : vB_Database_MySQLi


I've read through the archive I used to download, and tried to page through these 75 pages as best I can looking for a clear cut solution, but if one exists, I've over looked it.

Is this as easy as running a couple queries to complete the uninstall, and if so, where might I find those (I have no real comfort level with mysql myself), either way, will any change I make interfere with vB's built in warning system?

Thanks in advance for any help. I probably should have just left AWS disabled instead of flat uninstalling it, but like I said, trying to slim down.

the warnings field belongs the vbulletin infractions system.Hoever if you used the system on a 3.5.x (any release) then this would cause that field to be deleted when you uninstalled this hack.This problem can be solved by


ALTER TABLE user ADD COLUMN warnings INT UNSIGNED NOT NULL DEFAULT '0';


Your problem is most likely caused by running vb 3.5.x then you upgraded to 3.6 and you uninstalled the 3.5.x version of this hack which would delete the warnings field.Run the query and that error should be gone

[wcbryant]

Thanks so much, Delphi, that did the trick. Felt silly asking, and figured it would be something simple like that, but didn't want to make anything worse.

[tank14]

In the advanced warning system, I get an error, when I try to add a number here...Warnings Number LimitMembers are also banned when they accumulate this number of warnings....I would much rather use this, but when I change it, it goes completely BLANK...LOL Please help I love this hack system =P

[tank14]

I noticed something else, I dont even get a little question mark on it.

[tank14]

I also have this???

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE user SET warning_level='10', warnings='1' WHERE userid='2';

MySQL Error : Unknown column 'warning_level' in 'field list'
Error Number : 1054
Date : Sunday, December 31st 2006 @ 04:53:29 PM
Script : http://xboxcrave.com/vb/Warn.php
Referrer : http://xboxcrave.com/vb/Warn.php?do=WarnUser&id=2&post=18
IP Address : 69.243.173.129
Username : Jagged X sL4Sh
Classname : vb_database

[tank14]

Sorry, I went to vb 3.6.x for the version I need..Thanks!

[kofoid]

None of the template edits work when I import the product. I have tried 3 times now, both overwrite and fresh install. Any ideas??

[Delphiprogrammi]

None of the template edits work when I import the product. I have tried 3 times now, both overwrite and fresh install. Any ideas??

that's normal.You need to edit each template seperatly.We are not allowed to distrubute anything that's part of vbulletin.So you need to goto your style manager and edit this vBulletin templates


postbit & postbit_legacy
MEMBERINFO
memberinfo_resultbits
navbar
pm_newpm


if you do not understand howto do this give me a yell and i will explain in detail