vb.org Archive
Page 23 of 27 « First 132122 23 2425 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)

Ganon 02-01-2005 03:51 PM
Quote:
Originally Posted by sv1cec
Can't work without them, can it?

Let me know if you have problems.
I re-ran the installer and double checked the install file and they're still not there..... Is there a way I can manually add them? The installer said it did, but they're not there.

sv1cec 02-01-2005 04:21 PM
Quote:
Originally Posted by Ganon
I re-ran the installer and double checked the install file and they're still not there..... Is there a way I can manually add them? The installer said it did, but they're not there.
That's wierd. Are you sure you are running the install in the standard style? Are you sure you do not have a template category called "Advanced Warning System Templates"? It's towards the end of the list.

Rgds

Ganon 02-01-2005 04:29 PM
It said it added it to all styles, but I guess I can check each individual style to see if for some reason it installed to one but not the others.

EDIT: I found one style that has the group in there, but all that's in the group is a template called warn, which I'm guessing isn't enough, since the install file said there's 20 of them total.

sv1cec 02-01-2005 05:52 PM
Quote:
Originally Posted by Ganon
It said it added it to all styles, but I guess I can check each individual style to see if for some reason it installed to one but not the others.

EDIT: I found one style that has the group in there, but all that's in the group is a template called warn, which I'm guessing isn't enough, since the install file said there's 20 of them total.
I am not sure what to tell you. There should be 22 templates in there. Some how I think it has to do with the fact that you have more than one styles. The hack is designed to install the templates and everything in the style with id equals to $vboptions[styleid]. I am not sure what will happen if that's not the case, or if you have more styles.

I am sure there was a post which explained these issues some time at the beginning of this thread, so I would suggest you find all the patience you can get and start going over the pages, looking for some help. I can't assist you on that, as I have only one style on my system and I am not sure how the styles work.

Rgds

mikexxx 02-01-2005 06:17 PM
This is wat I get if I update form 3.1.1 to 3.1.5 (upgrade_warn.php)

Database error in vBulletin 3.0.6:

Invalid SQL: alter table warnings
add `warned_status` char(1), add `removed_by` int(15), add `removed_date` int(15)
mysql error: Duplicate column name 'warned_status'

mysql error number: 1060

sv1cec 02-02-2005 03:53 AM
Quote:
Originally Posted by mikexxx
This is wat I get if I update form 3.1.1 to 3.1.5 (upgrade_warn.php)

Database error in vBulletin 3.0.6:

Invalid SQL: alter table warnings
add `warned_status` char(1), add `removed_by` int(15), add `removed_date` int(15)
mysql error: Duplicate column name 'warned_status'

mysql error number: 1060
Please read the instructions carefully. Upgrade_warn.php is to upgrade from ZT hack to mine.

Read the UpgradeToLatestVersion.txt file on how to upgrade from one version to the next.

JazzleBug 02-02-2005 06:50 AM
Having a bit of trouble here with...

mysql error: Unknown column 'textbutoption' in 'field list'

Everything is working with the exception of the Manage Warning Options in my ACP.

Code:
Database error in vBulletin 3.0.6:

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

mysql error number: 1054
Anyone have any thoughts?

Steph

JazzleBug 02-02-2005 05:36 PM
Got antsy and worked it out myself. I think it was a little too easy. :o

Code:
ALTER TABLE `warning_options` ADD COLUMN  textbutoption char(10) AFTER  warnings_per_page
Killer script. Thanks so much!

sv1cec 02-02-2005 05:36 PM
Quote:
Originally Posted by JazzleBug
Having a bit of trouble here with...

mysql error: Unknown column 'textbutoption' in 'field list'

Everything is working with the exception of the Manage Warning Options in my ACP.

Code:
Database error in vBulletin 3.0.6:

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

mysql error number: 1054
Anyone have any thoughts?

Steph
Obviously this column does not exist in your database. Why? I have no idea. Did you try installing from scratch? Did you upgrade from an earlier version?

In any case, you can add that column, by using the following query:

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN textbutoption char(10)

Rgds

sv1cec 02-02-2005 05:37 PM
From now on, please use this link to go to AWS special forum.

https://vborg.vbsupport.ru/forumdisplay.php?f=105

Post your questions there, as new threads.

Thank you

The Realist 02-15-2005 10:12 AM
BUT..........

I have 1 member already in my banned section and when I run http://www.yourforumsite.com/admincp..._ban_dates.php it says ban_dates table updated from userban but it does not work?

Also I noticed that when I click in admin cp the view banned users it says "The administrator has not specified any groups that contain banned users. Please do so using the usergroup editor" but I have already done this and changed the settings in the warnings options stating what the banned usergroup is.

Any ideas?

sv1cec 02-15-2005 10:53 AM
Quote:
Originally Posted by The Realist
BUT..........

I have 1 member already in my banned section and when I run http://www.yourforumsite.com/admincp..._ban_dates.php it says ban_dates table updated from userban but it does not work?

Also I noticed that when I click in admin cp the view banned users it says "The administrator has not specified any groups that contain banned users. Please do so using the usergroup editor" but I have already done this and changed the settings in the warnings options stating what the banned usergroup is.

Any ideas?
Which "view banned users" are you using, the one in the Warning System or the one in the Users menu?

Also, for your bandates, what do you mean it does not work. That script will just get info from the userban table and enter it in the ban_dates table. Did you check the ban_dates and there is no entries there, while there are entries in your userban table?

And please do not post questions here. Use our special forum, as noted above.

Rgds

msimplay 02-22-2005 03:01 PM
The queries in the upgrade from 3.1.7 to 3.1.8 don't seem to work

Delphiprogrammi 02-22-2005 05:13 PM
they work fine ....

sv1cec 02-22-2005 05:28 PM
Quote:
Originally Posted by Delphiprogrammi
they work fine ....
Try using :

ALTER TABLE etc. (add the word TABLE, after ALTER)

I've uploaded a new zip with the queries corrected.

Rgds

JazzleBug 02-22-2005 07:30 PM
Quote:
Originally Posted by sv1cec
Obviously this column does not exist in your database. Why? I have no idea. Did you try installing from scratch? Did you upgrade from an earlier version?

In any case, you can add that column, by using the following query:

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN textbutoption char(10)

Rgds
Not sure why it wasn't created. I upgraded and when that didn't work, I dropped the AWS additions and did a clean install. When that didn't work (created everything okay except for a couple of missing fields), I manually created it. That's about all the info I can give you - sorry it isn't more. Haven't had any more trouble, though, and it was easy enough to remedy. Thanks again!

Delphiprogrammi 02-23-2005 07:49 PM
Quote:
Originally Posted by sv1cec
Try using :

ALTER TABLE etc. (add the word TABLE, after ALTER)

I've uploaded a new zip with the queries corrected.

Rgds
that's pretty obvious .... i didn't even noticed that wasn't there

Kruppa 02-24-2005 09:49 PM
Hi, I saw someone posted his error and solved it by adding the missing column. But I<m not sure if mine requires a char(10):

Database error in vBulletin 3.0.6:

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

mysql error number: 1054

So I'm I looking at:

ALTER TABLE `warning_options` ADD COLUMN modoption (then what?)

If anyone has any ideas, please share. It was so long to install all of this to be snipped at the final step.

MicroLinux? 02-24-2005 11:16 PM
Anyone have any feedback in response to this https://vborg.vbsupport.ru/showthrea...957#post616957 ??
Should I just ignore the difference in the 2 lines of code? Thanks, Travis.




EDIT: I just ignored the difference and pasted it where it should have. I dont notice any errors yet. =D


EDIT2: Holy crap these template edits are OFF big TIME!!!!!!



EDIT3: https://vborg.vbsupport.ru/showthrea...990#post616990 please go there and help me. thanks

sv1cec 02-25-2005 04:29 AM
Quote:
Originally Posted by Kruppa
Hi, I saw someone posted his error and solved it by adding the missing column. But I<m not sure if mine requires a char(10):


Database error in vBulletin 3.0.6:

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

mysql error number: 1054



So I'm I looking at:

ALTER TABLE `warning_options` ADD COLUMN modoption (then what?)


If anyone has any ideas, please share. It was so long to install all of this to be snipped at the final step.
modoption is char(3)

Kruppa 02-25-2005 12:46 PM
Thanks so much! :)

But then I got an error for sig_thresshold and saw in the column of the error message I got that I was going to get another error for avatar_thresshold as well. So I looked even more than I did yesterday.

It occured to me there were two install.php files, one for the clean install and one for the upgrade. When I searched the one I used (for the upgrade) for the modoption column it couldn't find anything. That's when I thought that the upgrade php must have omitted entries figuring they were done by Zero Tolerance's hack. So I searched in the clean install file and found it, along with the other two I needed.

So for anyone getting that error message, I bet they were all people upgrading. Simply look in the clean install file and you'll find all the database queries you're missing which you can add manually through PHPMyAdmin.

sv1cec 02-25-2005 01:08 PM
Quote:
Originally Posted by Kruppa
Thanks so much! :)

But then I got an error for sig_thresshold and saw in the column of the error message I got that I was going to get another error for avatar_thresshold as well. So I looked even more than I did yesterday.

It occured to me there were two install.php files, one for the clean install and one for the upgrade. When I searched the one I used (for the upgrade) for the modoption column it couldn't find anything. That's when I thought that the upgrade php must have omitted entries figuring they were done by Zero Tolerance's hack. So I searched in the clean install file and found it, along with the other two I needed.

So for anyone getting that error message, I bet they were all people upgrading. Simply look in the clean install file and you'll find all the database queries you're missing which you can add manually through PHPMyAdmin.
Darn, I always forget to update the script for the upgrade!!!

OK. I'll go do it now!

SaN-DeeP 02-26-2005 04:27 PM
Quote:
Originally Posted by sv1cec
Darn, I always forget to update the script for the upgrade!!!

OK. I'll go do it now!
Hi sv1cec,
I plan to install this addon (with some custom modifications) on our forums, are you planning for a update recently ?
So i can wait for new release. :)

Regards,

sv1cec 02-26-2005 06:06 PM
Quote:
Originally Posted by SaN-DeeP
Hi sv1cec,
I plan to install this addon (with some custom modifications) on our forums, are you planning for a update recently ?
So i can wait for new release. :)

Regards,
No, I have nothing planned. Go ahead and install it.

Rgds

Bolas 02-26-2005 07:01 PM
Quote:
Originally Posted by sv1cec
So, with this release, you get the ability to prevent a user's signature or his avatar from appearing, according to his total warning points. If you want to see something else removed, please let me know.
The possibility to deny post OR access to a list of forumid? Please please please please please :)

sv1cec 02-26-2005 07:16 PM
Quote:
Originally Posted by Bolas
The possibility to deny post OR access to a list of forumid? Please please please please please :)
Let me see if I understand what you mean. You want to deny the capability of posting, if the user exceeds a certain number of warning points?

Or the possibility to forbid access to certain forumids, according to the user's warning points?

Oh, and please use the AWS forum for this suggestions, at:

https://vborg.vbsupport.ru/forumdisplay.php?f=105

Chazz Layne 02-26-2005 07:56 PM
Quote:
Originally Posted by hello
ok i have fixed it lol finally, i had to make all the templates because i have 2 skins and it only put the templates on 1 of them, that is how you fix it :)
Sorry if this has been covered already. Just started having the same problem here when we added a new style. Is there an easier way than copying the templates to the new styles manually? Seems that would take quite some time...


TIA

sv1cec 02-27-2005 05:10 AM
Quote:
Originally Posted by Chazz Layne
Sorry if this has been covered already. Just started having the same problem here when we added a new style. Is there an easier way than copying the templates to the new styles manually? Seems that would take quite some time...


TIA
There is a hack by Zero Tolerance, which can take over your copying chores. You will find it here:

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

It is mentioned in the top, where the description of this hack is.

Rgds

Pickalo 03-01-2005 10:21 PM
Hey... I've been having some problems entering the data for warning types. Every time I try I get this error:
Quote:
Please provide a proper maturity for this warning type.
Thanks.

sv1cec 03-02-2005 04:30 AM
Quote:
Originally Posted by Pickalo
Hey... I've been having some problems entering the data for warning types. Every time I try I get this error:


Thanks.
You are right, I've missed a couple of == and a couple of '' signs.

Please download the new zip and upload admin_warn.php file to your server's admincp directory.

Rgds and tnx

Delphiprogrammi 03-02-2005 04:39 AM
Quote:
Originally Posted by Pickalo
Hey... I've been having some problems entering the data for warning types. Every time I try I get this error:


Thanks.
that's due to a bug in the code that's checks if those propertys are filled in properly to resolve that open the file admin_warn.php and find

PHP Code:
if ($warn_opts['allowoffpost']=='No' AND $_POST['warn_type']=='No')
    {
        define('CP_REDIRECT', 'admin_warn.php?act=view');
        print_stop_message('warning_warn_typeconflict');
    } 

after that add

PHP Code:
if(empty($_POST['warn_name']) OR trim($_POST['warn_name']) == '')
    {
        print_stop_message('warning_warn_emptywarntype');
    }
    if(empty($_POST['warn_desc']) OR trim($_POST['warn_desc']) == '')
    {
        print_stop_message('warning_warn_emptydesc');
    }
    if(empty($_POST['warn_points']) OR trim($_POST['warn_points']) == '')
    {
        print_stop_message('warning_warn_emptypoints');
    }
    if(empty($_POST['warn_maturity']) OR trim($_POST['warn_maturity'])== '')
    {
        print_stop_message('warning_warn_maturity');
    } 
i am verry sorry for making such a stupid mistake that code is mine John is innocent

sv1cec 03-02-2005 05:07 AM
Quote:
Originally Posted by Delphiprogrammi
that's due to a bug in the code that's checks if those propertys are filled in properly to resolve that open the file admin_warn.php and find

PHP Code:
if ($warn_opts['allowoffpost']=='No' AND $_POST['warn_type']=='No')
    {
        define('CP_REDIRECT', 'admin_warn.php?act=view');
        print_stop_message('warning_warn_typeconflict');
    } 

after that add

PHP Code:
if(empty($_POST['warn_name']) OR trim($_POST['warn_name']) == '')
    {
        print_stop_message('warning_warn_emptywarntype');
    }
    if(empty($_POST['warn_desc']) OR trim($_POST['warn_desc']) == '')
    {
        print_stop_message('warning_warn_emptydesc');
    }
    if(empty($_POST['warn_points']) OR trim($_POST['warn_points']) == '')
    {
        print_stop_message('warning_warn_emptypoints');
    }
    if(empty($_POST['warn_maturity']) OR trim($_POST['warn_maturity'])== '')
    {
        print_stop_message('warning_warn_maturity');
    } 
i am verry sorry for making such a stupid mistake that code is mine John is innocent
Delphi, the code you provide is not exactly correct, and since you want the checks, I guess we need to code them properly. The two first fields are character, so the trim function is necessary, the last two are numeric, so the check should be a little different, see below:

PHP Code:
if(empty($_POST['warn_name']) OR trim($_POST['warn_name']) == '')
    {
        print_stop_message('warning_warn_emptywarntype');
    }
    if(empty($_POST['warn_desc']) OR trim($_POST['warn_desc']) == '')
    {
        print_stop_message('warning_warn_emptydesc');
    }
    if(empty($_POST['warn_points']) OR $_POST['warn_points'] == '' OR $_POST['warn_points']<1 OR $_POST['warn_points']>99999)
    {
        print_stop_message('warning_warn_emptypoints');
    }
       if(empty($_POST['warn_maturity']) OR $_POST['warn_maturity']=='' OR $_POST['warn_maturity']<1 OR $_POST['warn_maturity']>99999)
    {
        print_stop_message('warning_warn_maturity');
    } 
If not, the user can enter a maturity of 'abcde' and the check will not stop him.

I've updated the zip file with this.

Rgds

Delphiprogrammi 03-02-2005 05:35 AM
Quote:
Originally Posted by sv1cec
Delphi, the code you provide is not exactly correct, and since you want the checks, I guess we need to code them properly. The two first fields are character, so the trim function is necessary, the last two are numeric, so the check should be a little different, see below:

PHP Code:
if(empty($_POST['warn_name']) OR trim($_POST['warn_name']) == '')
    {
        print_stop_message('warning_warn_emptywarntype');
    }
    if(empty($_POST['warn_desc']) OR trim($_POST['warn_desc']) == '')
    {
        print_stop_message('warning_warn_emptydesc');
    }
    if(empty($_POST['warn_points']) OR $_POST['warn_points'] == '' OR $_POST['warn_points']<1 OR $_POST['warn_points']>99999)
    {
        print_stop_message('warning_warn_emptypoints');
    }
       if(empty($_POST['warn_maturity']) OR $_POST['warn_maturity']=='' OR $_POST['warn_maturity']<1 OR $_POST['warn_maturity']>99999)
    {
        print_stop_message('warning_warn_maturity');
    } 
If not, the user can enter a maturity of 'abcde' and the check will not stop him.

I've updated the zip file with this.

Rgds

agreed daim i feel so ashamed stupid error :dead: :(

sv1cec 03-02-2005 06:00 AM
Quote:
Originally Posted by Delphiprogrammi
agreed daim i feel so ashamed stupid error :dead: :(
Don't worry about it, it was your fault, as much as mine. I didn't really check your code, when you posted it, I was way too busy to check it out, so I just included in the file. So we share the responsibility. LoL

Pickalo 03-02-2005 03:43 PM
Haha, thanks for the help guys :)

Kruppa 03-05-2005 11:22 AM
Hi, I have had this problem when I try to remove warnings (not the complete removal which still works) and haven't been able to resolve it. Can anyone help?




Database error in vBulletin 3.0.6:

Invalid SQL: update user set warning_level='0', warnings=1, warning_bans= where userid='6246'
mysql error: You have an error in your SQL syntax near 'where userid='6246'' at line 1

mysql error number: 1064


Script: admin_warn.php
Referer: admin_warn.php?act=remove&id=14&userid=6246&uname= Dhoffryn&wname=Flaming&postid=966742&ban=N&orderst ring=w.warned_time DESC

Thanks :)

Delphiprogrammi 03-05-2005 11:49 AM
warning_bans doesn't have a value edit your aws options (doesn't matter wich one) and save it again) that might help

Kruppa 03-05-2005 01:08 PM
Nope, hasn't done anything. :(

sv1cec 03-06-2005 05:32 AM
I cannot reproduce your problem, this is something I've tested several times. So I would suggest you upload the admin_warn.php file again.

Rgds

Kruppa 03-06-2005 12:09 PM
It's one of the first thing I tried. :D

If you can't reproduce the problem, it might be because it's confilcting with another hack I've recently installed. I'll keep looking.


All times are GMT. The time now is 03:19 PM.
Page 23 of 27 « First 132122 23 2425 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.02376 seconds
  • Memory Usage 1,911KB
  • 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
  • (3)bbcode_code_printable
  • (6)bbcode_php_printable
  • (23)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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