vb.org Archive
Page 49 of 105 « First 394748 49 50515999 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)

sv1cec 01-01-2005 09:42 AM
Quote:
Originally Posted by nubian
when i tried going running the 3.0.2 on my REAL LIVE forum i got this error when running the install_warn.php

Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE `vb3_userban`
add `reason` mediumtext;
mysql error: Duplicate column name 'reason'

mysql error number: 1060
Nubian,

Please do not say that the install script does not work, just because it didn't work in your case. I just installed vB 3.0.3 on my test site, from scratch, and did the hack installation. The install script did everything it is supposed to do.

I would appreciate if you can tell me what your problems were, so that I can assist you.

As for your issue with the 'reason' column in the userban table, it just means it is already there. Maybe it was added by another hack, or by your installation attempts, but that column is not there in a new database, and it should be created by the hack.

If you loaded 2.3.5, and want to use 3.0.2 you have to do all the steps described in UpgradeToLatestVersion.txt, from 2.3.5 to 3.0 then to 3.0.1 then to 3.0.2.

Rgds

sv1cec 01-01-2005 09:46 AM
Quote:
Originally Posted by bahawolf
How would I go about that if the user doesn't have any warning points, it'd appear as "0" for the value because a div in my postbit is being unused when their not warned and it looks bad.
If this is something you have changed from the standard hack code, I can't help unless I know what you have changed. Also, typically in the postbit templates the things which show the points and the bans should not appear if there are no points in the user's account.

This is accomplished by the:

HTML Code:
<if condition="$post[warning_level]>0">
statement, which allows the warning points to be viewable only if they exist.

Show me that part of your template and I'll try to adapt it to your needs.

Rgds and HAPPY NEW YEAR to all

bahawolf 01-01-2005 03:19 PM
Quote:
<-- Points System -->
<if condition="$bbuserinfo['usergroupid'] == '6'"><div class="info"><a href="ushop.php?do=a&shortname=admindonate&userid= $post[userid]" target="_blank">$vbphrase[ucs_points]</a><else />$vbphrase[ucs_points]</if>: $points (<a href="ushop.php?do=a&shortname=donate&userid=$post[userid]" target="_blank">Donate</a>)
< / -- Points System -- \ >

<div class="info"><if condition="$viewoption=='All'">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if>

<if condition="$viewoption=='Mgm' AND $hierarchical=='Yes'">
<if condition="($bbuserinfo[usergroupid]!=7 AND $bbuserinfo[usergroupid]!=6 AND $bbuserinfo[usergroupid]!=5 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==7 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==5 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==7 AND $post[usergroupid]!=6 AND $post[usergroupid]!=5 AND $post[usergroupid]!=7)
OR
($bbuserinfo[usergroupid]==5 AND $post[usergroupid]!=6 AND $post[usergroupid]!=5)
OR
($bbuserinfo[usergroupid]==6)
">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if>
</if>

<if condition="$viewoption=='Mgm' AND $hierarchical=='No' AND
(($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==5 OR
$bbuserinfo[usergroupid]==6) OR ($bbuserinfo[usergroupid]!=7 AND $bbuserinfo[usergroupid]!=6 AND $bbuserinfo[usergroupid]!=5 AND $post[userid]==$bbuserinfo[userid]))">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if></div>
Here it is.. I didn't have reputation display, so I put that as the points value is the last in the postbit.

sv1cec 01-01-2005 03:36 PM
Quote:
Originally Posted by bahawolf
Here it is.. I didn't have reputation display, so I put that as the points value is the last in the postbit.
The only thing I can see missing is an </if> right after < / -- Points System -- \ >

The code for AWS is OK, so it shouldn't display any info if the user has no warning points.

Rgds

bahawolf 01-01-2005 03:42 PM
Do you know of any way I could go about fixing this..? Even giving you AdminCP access?

sv1cec 01-01-2005 04:10 PM
E-mail me with the details of your forum, I want to see what it's doing. Because, as it is in the code you posted above, it should NOT show anything for users with no warning points.

Rgds

bahawolf 01-01-2005 04:13 PM
Oh I think you've taken my question wrong..

Say a user is warned with 1 point and it says:
Warning Points: 1

I want it so if they have none, it says:
Warning Points: 0

nubian 01-01-2005 04:16 PM
Quote:
Originally Posted by sv1cec
Nubian,

Please do not say that the install script does not work, just because it didn't work in your case. I just installed vB 3.0.3 on my test site, from scratch, and did the hack installation. The install script did everything it is supposed to do.

I would appreciate if you can tell me what your problems were, so that I can assist you.

As for your issue with the 'reason' column in the userban table, it just means it is already there. Maybe it was added by another hack, or by your installation attempts, but that column is not there in a new database, and it should be created by the hack.

If you loaded 2.3.5, and want to use 3.0.2 you have to do all the steps described in UpgradeToLatestVersion.txt, from 2.3.5 to 3.0 then to 3.0.1 then to 3.0.2.

Rgds
i'm deeply sorry.
i didn't want it to come out like that.
it was the new years liquor talking. :)
i'm not saying this out of frustration.

i have one hack installed on my board and that's a portal.
the portal did altered a few tables in the db.
if i were to reload a db that i have backed up and run the install_warn.php file it gives me this after the 2nd step:

Database error in vBulletin 3.0.3:

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

mysql error number: 1136

prior to running your install_warn.php script there was never a vb3_warning_options table. :ermm:

sv1cec 01-01-2005 05:59 PM
Quote:
Originally Posted by nubian
i'm deeply sorry.
i didn't want it to come out like that.
it was the new years liquor talking. :)
i'm not saying this out of frustration.

i have one hack installed on my board and that's a portal.
the portal did altered a few tables in the db.
if i were to reload a db that i have backed up and run the install_warn.php file it gives me this after the 2nd step:

Database error in vBulletin 3.0.3:

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

mysql error number: 1136

prior to running your install_warn.php script there was never a vb3_warning_options table. :ermm:
Please download the latest zip file. Run the uninstaller, and then re-install from scratch.

I tried it this morning and it works fine.

Rgds

nubian 01-01-2005 07:17 PM
weird....
that one works just fine.
thanks!


All times are GMT. The time now is 04:58 PM.
Page 49 of 105 « First 394748 49 50515999 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.01732 seconds
  • Memory Usage 1,759KB
  • 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
  • (1)bbcode_html_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