vb.org Archive - Advanced Warning System (AWS)

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Advanced Warning System (AWS) (https://vborg.vbsupport.ru/showthread.php?t=71992)

Quote:

Originally Posted by sifuhall

Thanks for the reply.

I do not see the templates. I did a search all templates for the word warn and it only returned board_inactive_warning, memberinfo, navbar, polloptionn_table, postbit, and postbit_legacy (the seach was in all styles and search titles only was set to no).

The blank page occurs when I try to warn from a post or from the memberinfo page.

And yes, my default style is a child style

Stupid question, but when you upgraded from ZT's hack, did you run the upgrade script? This script should create all your templates for you. However, I have no idea what happens if you are not using the default style, I think this has been covered somewhere in the beginning of this thread. Also, I think ZT has a hack out which allows you to copy the templates to all styles or something. If the problem comes from this issue, I cannot help, I do not know how that works.

Sorry! :-(

Quote:

Originally Posted by Akex

Well it's not inserted, because the request contains 27 values instead of 28 in the table. ;)

John's red with shame!!!!!!

Runs to update the instructions!!!!

Buhooooooooooo!

Thanks for catching it Akex, or .... Merci Beaucoup Monsieur!

Quote:

Originally Posted by Akex

Well i had a problem to save my options too and i found why. After installing the hack the warning_options table remained empty with no records. So, when the script tries to update the table where oid = 1, it can't.

Fix for me : I added a record in this table with oid = 1 with phpmyadmin. Now it works well :).

the question is what to add ? sorry dumb question but i'm totally confused :s

i alread did

Code:

UPDATE vb3_warning_options SET VERSION='3.0.8' WHERE oid=1

that worked fine but still no warning links

regards

Quote:

Originally Posted by Delphiprogrammi

the question is what to add ? sorry dumb question but i'm totally confused :s

i alread did

Code:

UPDATE vb3_warning_options SET VERSION='3.0.8' WHERE oid=1

that worked fine but still no warning links

regards

Delphi,

Do you have one line of data in your warning_options table? If you do, then you can save your warning options. Then, if you define you want non-post-related warnings, the links will appear.

Rgds

Quote:

Originally Posted by sv1cec

I sure did run the upgrade script.

I think I have found the problem as well.

I completely redid the hack just a few moments ago (whew!) and when running the upgrade script I run step 1, everything is fine, I run step 2 and TADA! I have the templates, then I run step 3 and poof! the templates are gone.

I have got around this by running the upgrade all the way through (to get the database updates), then re-running it and stopping after step 2 so the templates are not removed.

Now no blank pages!

hi sv1cec ,

no seems i can't save my AWS options i hit that button but the options i set aren't saved i got this line of SQL from a database backup dump

Code:

INSERT INTO `vb_3warning_options` VALUES (1, '3.0.8', 'Yes', 'Yes', 'Yes', 'Yes', 2, 2, NULL, 14, 30, 8, '6|6', '6', '8', 2, 'Yes', 2, 0, 'All', 'Yes', 'Yes', 'No', 'No', 'Yes', 'Yes', 15);

but MySQL is giving me errors

#1136 - Column count doesn't match value count at row 1

rgds

Quote:

Originally Posted by sv1cec

That's easy. Edit your admin_warn.php file and find:

PHP Code:


		
			
if ($_GET['act'] == "viewstats2") 

{

    $get_warns=$DB_site->query("select wt.userid, wt.username, wt.usergroupid  from

    ".TABLE_PREFIX."user wt WHERE (usergroupid=5 OR usergroupid=6 OR usergroupid=7) ORDER BY userid");

Replace that with:

PHP Code:


		
			
if ($_GET['act'] == "viewstats2") 

{

    $get_warns=$DB_site->query("select wt.userid, wt.username, wt.usergroupid  from

    ".TABLE_PREFIX."user wt WHERE (usergroupid=5 OR usergroupid=6 OR usergroupid=7 OR usergroupid=13 OR usergroupid=21 OR usergroupid=20 ) ORDER BY userid");

As for the other changes, what you should do, is make sure that wherever there is a reference to group 6, there is also a reference to the equivalent group. Typically, the two references should be OR-ed and even better put them in a parenthesis like ($bbuserinfo[usergroupidi]==6 OR $bbuserinfo[usergroupid]==13 ). Same with the rest.

Let me know how you are progressing.

Rgds

Okay, this is weird. I copied and pasted the code, and got this warning:

Parse error: parse error, unexpected T_VARIABLE in /home/pkrwud/public_html/vbulletin/admincp/admin_warn.php on line 1837

So, I copy and pasted the original code from the same post (quoted above), and got the same error again. In fact, I got that error when I clicked on any of the options in the Warning System portion of the Admin CP. So, I opened the original copy of that file on my hard drive, and copied and pasted from there, and now it's back to normal.

Maybe I'm missing it, but I'm not seeing any real difference between the two.

Why did I get that error? BTW, line 1837 is the one that starts with: $get_warns

And, I have another question (lucky you). In that same file, just below the code mentioned above, it says:

PHP Code:


		
			
        $cell = array();

        $id=$warn['userid'];

        if ($warn['usergroupid']==5)

        {

            $usergrp="Super Moderator";

        }

        else if ($warn['usergroupid']==6)

        {

            $usergrp="Administrator";

        }

        else if ($warn['usergroupid']==7)

        {

            $usergrp="Moderator";

        }

Will I need to make changes here too?

Quote:

Originally Posted by Delphiprogrammi

hi sv1cec ,

no seems i can't save my AWS options i hit that button but the options i set aren't saved i got this line of SQL from a database backup dump

Code:

INSERT INTO `vb_3warning_options` VALUES (1, '3.0.8', 'Yes', 'Yes', 'Yes', 'Yes', 2, 2, NULL, 14, 30, 8, '6|6', '6', '8', 2, 'Yes', 2, 0, 'All', 'Yes', 'Yes', 'No', 'No', 'Yes', 'Yes', 15);

but MySQL is giving me errors

#1136 - Column count doesn't match value count at row 1

rgds

run this query in phpmyadmin.

Code:

INSERT INTO `".TABLE_PREFIX."warning_options` values ('1','3.0.8', 'No', 'No','No','No','','','','7','10','10','8','','','8','','No','3','0','All','No','No','No','No','No','No','15')

ps : replace ".TABLE_PREFIX." by the prefix you have for vb3.

Quote:

Originally Posted by PKRWUD

PHP Code:


		
			
        $cell = array();

        $id=$warn['userid'];

        if ($warn['usergroupid']==5)

        {

            $usergrp="Super Moderator";

        }

        else if ($warn['usergroupid']==6)

        {

            $usergrp="Administrator";

        }

        else if ($warn['usergroupid']==7)

        {

            $usergrp="Moderator";

        }

Will I need to make changes here too?

For the record, I've taken care of all of this, and it works great, but I'm still curious why I got that error when I copied and pasted the code from your reply.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (4)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02790 seconds Memory Usage 1,777KB 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 (5)bbcode_code_printable (4)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: