vb.org Archive
Page 75 of 105 « First 25657374 75 767785 Last »
Show 40 post(s) from this thread on one page

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 01-15-2005 12:05 PM
hello, i'm getting this error:

Code:
Database error in vBulletin 3.0.5:

Invalid SQL: update warning_options set
        hierarchical='Yes',
        automatic='No',
        automaticpm='No',
        autocomments='No',
        warner='0',
        automatic_warner='0',
        collector='',
        banned_limit='7',
        points_before_banned='15',
        warnings_before_banned='',
        banned_usergroup_id='8',
        troll_usergroup_id='14',
        protected_usergroups='6|6|7',
        aprotected_usergroups='6|7',
        restore_groupid='0',
        incr_ban_days='No',
        max_no_bans='2',
        bans_mature='',
        viewoption='All',
        multiple_per_post='Yes',
        send_pm_warning='Yes',
        send_em_warning='Yes',
        email_on_ban='No',
        historical='Yes',
        allowoffpost='Yes',
        warnings_per_page='15'
        where oid='1'
mysql error: Unknown column 'collector' in 'field list'

mysql error number: 1054

Date: Saturday 15th of January 2005 01:58:42 PM
Script: http://www.myfootballforum.com/admincp/admin_warn.php
Referer: http://www.myfootballforum.com/admincp/admin_warn.php?act=manageoptions

MentaL 01-15-2005 12:27 PM
Hi im getting this error im mod/banning.php

Quote:
Parse error: parse error, unexpected T_STRING in /home/ragezone/public_html/forum/mod/banning.php on line 258
Why? eveyrthing else works fine. pm me answer please?

properclone 01-15-2005 12:34 PM
Great hack.
Whats annoying is that say someone PMed you with a blocked word in, they get a warning point thing.
If you reply which automatically quotes it will give you a warning point thing yet you didnt swear it was the person who you quoted.

sv1cec 01-15-2005 12:44 PM
Quote:
Originally Posted by mcyates
hello, i'm getting this error:

Code:
Database error in vBulletin 3.0.5:

Invalid SQL: update warning_options set
        hierarchical='Yes',
        automatic='No',
        automaticpm='No',
        autocomments='No',
        warner='0',
        automatic_warner='0',
        collector='',
        banned_limit='7',
        points_before_banned='15',
        warnings_before_banned='',
        banned_usergroup_id='8',
        troll_usergroup_id='14',
        protected_usergroups='6|6|7',
        aprotected_usergroups='6|7',
        restore_groupid='0',
        incr_ban_days='No',
        max_no_bans='2',
        bans_mature='',
        viewoption='All',
        multiple_per_post='Yes',
        send_pm_warning='Yes',
        send_em_warning='Yes',
        email_on_ban='No',
        historical='Yes',
        allowoffpost='Yes',
        warnings_per_page='15'
        where oid='1'
mysql error: Unknown column 'collector' in 'field list'

mysql error number: 1054

Date: Saturday 15th of January 2005 01:58:42 PM
Script: http://www.myfootballforum.com/admincp/admin_warn.php
Referer: http://www.myfootballforum.com/admincp/admin_warn.php?act=manageoptions
Check that you have a collector column in warning_options. If not, added with the following query:

ALTER TABLE warning_options ADD COLUMN collector int(10) unsigned AFTER warner

Remember to add any table prefix if you are using one.

sv1cec 01-15-2005 12:45 PM
Quote:
Originally Posted by mentalrz
Hi im getting this error im mod/banning.php



Why? eveyrthing else works fine. pm me answer please?
Check that you haven't missed a ';' before that line somewhere.

Rgds

sv1cec 01-15-2005 01:11 PM
Quote:
Originally Posted by properclone
Great hack.
Whats annoying is that say someone PMed you with a blocked word in, they get a warning point thing.
If you reply which automatically quotes it will give you a warning point thing yet you didnt swear it was the person who you quoted.
No, this should not happen, because the censored word is replaced by **** in the pm you got. So when you reply, the bad word is not there. However, your post made me find a small problem in that area of the instructions, so please make sure you apply the following edit:

In your private.php file, find:

PHP Code:
                $signature = intval($pm['signature']);
                $iconid = intval($pm['iconid']);
                $disablesmilies = iif($pm['disablesmilies'], 0, 1); 
Right after that, add:

[php]
$pm_message=$message;

Then find:

PHP Code:
// insert private message text
                $DB_site->query("INSERT INTO " . TABLE_PREFIX . "pmtext\n\t(fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie)\nVALUES\n\t($bbuserinfo[userid], '" . addslashes($bbuserinfo['username']) . "', '$title', '$message', '" . addslashes(serialize($tostring)) . "', $iconid, " . TIMENOW . ", $signature, $disablesmilies)"); 
Right before that, add:

PHP Code:
    $message=$pm_message; 
I'll update the instructions, but all who is using the Automatic Private Warnings from PMs, should do this update.

Rgds

MentaL 01-15-2005 01:26 PM
Thanks, Fixed!

Delphiprogrammi 01-15-2005 07:54 PM
Quote:
Originally Posted by sv1cec
No, this should not happen, because the censored word is replaced by **** in the pm you got. So when you reply, the bad word is not there. However, your post made me find a small problem in that area of the instructions, so please make sure you apply the following edit:

In your private.php file, find:

PHP Code:
                $signature = intval($pm['signature']);
                $iconid = intval($pm['iconid']);
                $disablesmilies = iif($pm['disablesmilies'], 0, 1); 
Right after that, add:

[php]
$pm_message=$message;

Then find:

PHP Code:
// insert private message text
                $DB_site->query("INSERT INTO " . TABLE_PREFIX . "pmtext\n\t(fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie)\nVALUES\n\t($bbuserinfo[userid], '" . addslashes($bbuserinfo['username']) . "', '$title', '$message', '" . addslashes(serialize($tostring)) . "', $iconid, " . TIMENOW . ", $signature, $disablesmilies)"); 
Right before that, add:

PHP Code:
    $message=$pm_message; 
I'll update the instructions, but all who is using the Automatic Private Warnings from PMs, should do this update.

Rgds

updated right now and don't forget our coffee sv1cec :up:

Delphiprogrammi 01-16-2005 04:02 PM
well,

the bancheck is in /modcp/banning.php instead of the default "print_stop_message()" we could

PHP Code:
<?php
Header("Location:banned.php");
?>
but it would require a custom template i have no experience with developing that also sv1cec where is the "mail on banned" feature i don't find it :speechless: not in user banning options nor in e-mail options

rgds

sv1cec 01-16-2005 06:33 PM
Quote:
Originally Posted by Delphiprogrammi
well,

the bancheck is in /modcp/banning.php instead of the default "print_stop_message()" we could

PHP Code:
<?php
Header("Location:banned.php");
?>
but it would require a custom template i have no experience with developing that also sv1cec where is the "mail on banned" feature i don't find it :speechless: not in user banning options nor in e-mail options

rgds
Are you sure it is in banning.php? Because I checked and there is no code which checks whether a user who tries to log in, is in the banned user groups. Unless I am too sleepy right now.

What I am looking for, is the code which accepts the user name, possibly converts it to a user id and then checks whether this id exists in userban. No matter where I looked, I can't find it.

No worries about the message, I can handle that, if only I can find the place where the ban check is made.

As for the Mail when banned, it is in the Member Notification Options, in the AdminCP/Warning System Options.


All times are GMT. The time now is 11:23 AM.
Page 75 of 105 « First 25657374 75 767785 Last »
Show 40 post(s) from this thread on one page

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.02162 seconds
  • Memory Usage 1,783KB
  • 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
  • (2)bbcode_code_printable
  • (8)bbcode_php_printable
  • (6)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