vb.org Archive

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)

mcyates 12-06-2004 10:21 PM

Quote:

Originally Posted by sv1cec
The following tables are used by this hack (and Zero's):

warning_options
warning_types
warnings

If you had installed version 2.0 and above, you would also have a table named pmtext_warned.

Zero was using another table for banned users, called banned_members. All these should be in your database, and should be useable again.

If you want to delete them and start from scratch, just make sure you do not use a TABLE_PREFIX. If you do, add that in the installation script.

I would suggest that you do not start with Zero's hack, go directly to the installation of this one, the installation procedure is much easier.

Let me know if that helps.

Rgds

I removed the following tables

warning_options
warning_types
warnings

And from the "user" table i removed:

warnings
warning_level
warning_bans

I then started the install scripts, it installed the templates but then I get this error:

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO `warning_options` values ('1','Yes', 'No', '','0','7','10','8','6','8','0','Yes','3','All','Yes','Yes','No','Yes','Yes','15')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Tuesday 07th of December 2004 12:21:14 AM

What's the problem?

sv1cec 12-07-2004 03:42 AM

Quote:

Originally Posted by rh2004
Okie I have re done the whole mod anyway and its working, I found another error
though, when you have send PM to user (when warned) it gives you the error:

Code:

Fatal error: Call to undefined function: sendpm() in /home/username/public_html/dis/Warn.php on line 357
If its turned of you don't get the error

Another one I found is:

My adminpanel is called adminpanel instead of admincp so when I click
Complete Removal user it gives me

Code:

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

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Can you help me fix these :D

Thanks :)

Please download the latest zip, the Warn.php file I had in the previous one was using a wrong required file, so it was not locating the functions_warning.php file. Let me know if you still have problems.

As for the adminpanel, and find this in your admin_warn.php file:

PHP Code:

$cy="<a href='{$vboptions[bburl]}/admincp/admin_warn.php?act=completeremove 

Replace it with:

PHP Code:

$cy="<a href='{$vboptions[bburl]}/adminpanel/admin_warn.php?act=completeremove 

Rgds

sv1cec 12-07-2004 03:45 AM

Quote:

Originally Posted by Celtic_Mad
I have made a usergroup called 'Site Owner' which I am in and it has everything an adminstrator has but administrators and moderators are still able to warn me, how can I make it that neither of them can warn this usergroup?

A whole usergroup for yourself!!!

Why didn't you just add yourself in the admins?

Just add that group in the "Protected Usergroups" option, in the Warning Options.

Rgds

sv1cec 12-07-2004 03:48 AM

Quote:

Originally Posted by mcyates
I removed the following tables

warning_options
warning_types
warnings

And from the "user" table i removed:

warnings
warning_level
warning_bans

I then started the install scripts, it installed the templates but then I get this error:

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO `warning_options` values ('1','Yes', 'No', '','0','7','10','8','6','8','0','Yes','3','All','Yes','Yes','No','Yes','Yes','15')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Tuesday 07th of December 2004 12:21:14 AM

What's the problem?

Download and use the latest install_warn.php file. Darn, I have to rewrite that insert so it works with the column names, I always seem to have a mistake there. A couple of people had that problem yesterday, so I hope I have corrected the insert.

Let me know if it works.

Rgds

mcyates 12-07-2004 09:32 AM

Quote:

Originally Posted by sv1cec
Download and use the latest install_warn.php file. Darn, I have to rewrite that insert so it works with the column names, I always seem to have a mistake there. A couple of people had that problem yesterday, so I hope I have corrected the insert.

Let me know if it works.

Rgds

ok thanks mate,i'll try now. Your doing a fantastic job. Thanks again

I'll let you know if it works.

mcyates 12-07-2004 09:48 AM

Quote:

Originally Posted by mcyates
ok thanks mate,i'll try now. Your doing a fantastic job. Thanks again

I'll let you know if it works.

I'm still getting the same error:

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO `warning_options` values ('1','Yes', 'No', '','0','7','10','8','6','8','0','Yes','3','All','Yes','Yes','No','Yes','Yes','15')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

You'll get it right one day!! :up:

bold 12-07-2004 05:14 PM

i get this error

Code:

Fatal error: Cannot redeclare sendpm() (previously declared in /home/blah/public_html/forums/includes/functions_warning.php:12) in /home/blah/public_html/forums/includes/functions_newpost.php on line 15

bold 12-07-2004 05:27 PM

i removed the sendpm function in functions_newpost.php and it's working. you should include that in the upgrade txt.

sv1cec 12-07-2004 06:03 PM

I just copied this below, from the installation file. I am sure I have it right there.

PHP Code:

$install[]="INSERT INTO `".TABLE_PREFIX."warning_options` values ('1','Yes', 'Yes','No', '','0','7','10','8','6', '6','8','0','Yes','3','All','Yes','Yes','No','Yes','Yes','15')"

Try this!

sv1cec 12-07-2004 06:06 PM

Quote:

Originally Posted by bold
i removed the sendpm function in functions_newpost.php and it's working. you should include that in the upgrade txt.

You are right, I forgot to add the instructions for that, I just updated the file.

Tnx


All times are GMT. The time now is 10:58 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01713 seconds
  • Memory Usage 1,756KB
  • 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
  • (6)bbcode_code_printable
  • (3)bbcode_php_printable
  • (7)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