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)

sv1cec 01-10-2005 04:55 AM

Quote:

Originally Posted by Delphiprogrammi
yes i uploaded that images and true caps is a critical thing on a unix system but if that was the reason why it would result in a death image i don't see *anything* in the postbit besides the red line with the warning level.

gonna check one more time i'm sure i did something wrong :)


my server runs on fedora (redhat ) linux

I am sure you will find a little something that you missed. Oh yes, please keep in mind that the stop sign, appears for admins/mods/supermods only, not for simple users.

Rgds

sv1cec 01-10-2005 05:02 AM

Quote:

Originally Posted by rh2004
Hey how do I show the Warnings: (level) to everyone that is displayed in postbit...

Just the Warning: (level)

Not how many times banned

The way the hack is, these two go together. If you go in the Warning Options, in the Viewing Options, you can select either Mgm (which means management, so only the proper admin/mods/supermods can see the warnings level and bans) or All.

If you want to alter that, go in your post bit template and change the code in the part that begins with :

HTML Code:

<if condition="$viewoption=='All' and $bbuserinfo[userid]>0">
.
.
.
and ends with
.
.
.
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if>

                                        </div>


rh2004 01-10-2005 05:31 AM

Quote:

Originally Posted by sv1cec
The way the hack is, these two go together. If you go in the Warning Options, in the Viewing Options, you can select either Mgm (which means management, so only the proper admin/mods/supermods can see the warnings level and bans) or All.

If you want to alter that, go in your post bit template and change the code in the part that begins with :

HTML Code:

<if condition="$viewoption=='All' and $bbuserinfo[userid]>0">
.
.
.
and ends with
.
.
.
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if>

                                        </div>



Cool I just set it to all in options and it shows now, thanks

rinkrat 01-10-2005 05:50 AM

Just installed and when I save my settings in admincp I get

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


Database error in vBulletin 3.0.5:

Invalid SQL: update warning_options set
hierarchical='Yes',
automatic='No',
automaticpm='No',
autocomments='No',
warner='8040',
automatic_warner='LGKbot',
collector='rinkrat',
banned_limit='14',
points_before_banned='5',
banned_usergroup_id='17',
troll_usergroup_id='16',
protected_usergroups='6|5|6|7',
aprotected_usergroups='5|6|7',
restore_groupid='2',
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='Yes',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='20'
where oid='1'
mysql error: Unknown column 'collector' in 'field list'

mysql error number: 1054

Date: Sunday 09th of January 2005 11:43:33 PM
Script: http://www.letsgokings.com/bbs/admincp/admin_warn.php
Referer: http://www.letsgokings.com/bbs/admin...=manageoptions
Username: RinkRat

sv1cec 01-10-2005 06:17 AM

Quote:

Originally Posted by rinkrat
Just installed and when I save my settings in admincp I get

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


Database error in vBulletin 3.0.5:

Invalid SQL: update warning_options set
hierarchical='Yes',
automatic='No',
automaticpm='No',
autocomments='No',
warner='8040',
automatic_warner='LGKbot',
collector='rinkrat',
banned_limit='14',
points_before_banned='5',
banned_usergroup_id='17',
troll_usergroup_id='16',
protected_usergroups='6|5|6|7',
aprotected_usergroups='5|6|7',
restore_groupid='2',
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='Yes',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='20'
where oid='1'
mysql error: Unknown column 'collector' in 'field list'

mysql error number: 1054

Date: Sunday 09th of January 2005 11:43:33 PM
Script: http://www.letsgokings.com/bbs/admincp/admin_warn.php
Referer: http://www.letsgokings.com/bbs/admin...=manageoptions
Username: RinkRat

Obviously, for some reason that column does not exist in your table. Just add it, with the following SQL query:

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN `collector` int(10) unsigned AFTER warner WHERE oid=1

Remember to remove ".TABLE_PREFIX." if you are not using one.

Also, from your error message, I see that you are not .... following the instructions. The warners and collector are supposed to be user ids not user names.

Also, there is not version column in your table. What version are you trying to install?

Rgds

Delphiprogrammi 01-10-2005 10:15 AM

Quote:

Originally Posted by sv1cec
I am sure you will find a little something that you missed. Oh yes, please keep in mind that the stop sign, appears for admins/mods/supermods only, not for simple users.

Rgds

yes there whas a line of requirerd code missing in the postbit template the stop sign is working fine now but if i click on the image (it is linked) then i see a death image and i have no idea what image should appear there :s attached is Warn.png (showing the stop sign image is working) and error.png is the thing with the death image :confused:

rgds

sv1cec 01-10-2005 11:15 AM

Upload the following two images to your web server, in images/misc.

https://vborg.vbsupport.ru/external/2005/01/4.gif

https://vborg.vbsupport.ru/external/2005/01/5.gif

Use the name closeOFF.gif for the first and closeON.gif for the second.

Don't worry too much about this image though, in the next release, all admin functionality is handled within admin_warn.php, which means that there will be no calls to Warn.php, unless absolutely necessary.

Also, you might try the image below, to see if it works better in your forum. I've adjusted it, so that the grey color around the sign is transparent.

https://vborg.vbsupport.ru/external/2005/01/6.gif

Rgds

Delphiprogrammi 01-10-2005 01:14 PM

thanks sv1cec working

rgds

rinkrat 01-10-2005 02:10 PM

Quote:

Originally Posted by sv1cec
Obviously, for some reason that column does not exist in your table. Just add it, with the following SQL query:

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN `collector` int(10) unsigned AFTER warner WHERE oid=1

Remember to remove ".TABLE_PREFIX." if you are not using one.

Also, from your error message, I see that you are not .... following the instructions. The warners and collector are supposed to be user ids not user names.

Also, there is not version column in your table. What version are you trying to install?

Rgds

I just grabbed the one from this thread and used the script to update from the other warning hack. I ran the script and even ran the complete script and no go. I'll try adding the column from that command.

rinkrat 01-10-2005 02:13 PM

Quote:

SQL-query :

ALTER TABLE `warning_options` ADD COLUMN `collector` int( 10 ) unsigned AFTER warner WHERE oid =1

MySQL said:
#1064 - 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 'WHERE oid=1' at line 1
OK I took off the end bit and it worked after this error.

THANKS!!


All times are GMT. The time now is 05:01 PM.

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.03885 seconds
  • Memory Usage 1,760KB
  • 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_html_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