vb.org Archive - Advanced Warning System (Beta Version)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Advanced Warning System (Beta Version) (https://vborg.vbsupport.ru/showthread.php?t=95921)

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.

Quote:

Originally Posted by sv1cec

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

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.

Quote:

Originally Posted by Delphiprogrammi

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

Code:

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.

Quote:

Originally Posted by RMS-Chef

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

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?d...&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

Quote:

Originally Posted by Tayeb

you do not have a warnings field in your user table

Code:

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

keep tableprefixes in mind ...

hi people,

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

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?

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

Quote:

Originally Posted by Triple_T

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

you need a slightly different query for the infraction system

Code:

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

*= don't forget table prefixes

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=...571&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

Quote:

Originally Posted by Tayeb

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

Code:

DESCRIBE user;

if the warning_bans field is not there

Code:

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

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

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

Quote:

Originally Posted by UZFRED

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

Quote:

Originally Posted by Delphiprogrammi

you need a slightly different query for the infraction system

Code:

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

Quote:

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

#1060 - Duplicate column name 'warnings'

What should I do?
Thank you

Quote:

Originally Posted by Triple_T

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 ..

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

Quote:

Originally Posted by Delphiprogrammi

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?

Quote:

Originally Posted by Triple_T

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

Code:

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

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

Because with the last SQL you gave I got

Quote:

#1091 - Can't DROP 'warning_bans'; check that column/key exists

Quote:

Originally Posted by Triple_T

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

Code:

DESCRIBE user;

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

Code:

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

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

Quote:

Originally Posted by Triple_T

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

Code:

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

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. =)

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!

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?

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

Quote:

Originally Posted by jacks0_0

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"

nm misreaded.

loving the mod :)

Quote:

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

Anyone ?

Quote:

Originally Posted by jacks0_0

Anyone ?

https://vborg.vbsupport.ru/showpost....postcount=1112

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

Quote:

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 >?

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

http://i6.photobucket.com/albums/y21...6/untitled.jpg

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

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 :)

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

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

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;

Code:

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.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02417 seconds Memory Usage 1,880KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (11)bbcode_code_printable (19)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: