vb.org Archive
Page 16 of 27 « First 61415 16 171826 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-08-2005 05:39 AM
Quote:
Originally Posted by Revan
Okay Im gonna start remaking this version now, to work with $vboptions
sv1, I seem to remember some guy saying that he wasn't gonna release new versions every 3 days *sees 2 update emails in his inbox just today*
*cough*
XD
Well, one of the updates was a bug fix, and it was a serious bug, which made me turn red! So what was I supposed to do? Keep the fix for next month?

Gentlemen, I can withhold any updates and release them once a month. I've asked you in the past, what's your prefered way and got no anwers. It looks as if I have one vote for delayed releases, so that I do not send out new versions every two days (or sometimes every day). If I have no opposite views from you guys on this subject, I'll keep all the updates and release them once a month.

Viol8or 01-08-2005 07:14 AM
Feature updates don't have to be there in 2 days for, I'm happy you are willing to incorporate them and can wait a few days/weeks if necessary.
However, bugfixes should not be delayed, is my opinion.

j_86 01-08-2005 05:03 PM
This hack is VB3.05 compatiable, bar one very small code change related to the instructions, which isn't a big problem because most people who edit PHP files don't have mutiline search boxes and will search for the first line of code to change. I forgot which instruction it was, i'll find it again soon.

Viol8or 01-08-2005 05:42 PM
I think this is the one ... global $DB_site, $vboptions, $vbphrase, $bbuserinfo, $forumperms, $usergroupcache, $wehavecensoredwords, $weneedacounter, $newpostid, $_REQUEST;

But was stated a few post ago.

Revan 01-08-2005 05:45 PM
Quote:
Originally Posted by sv1cec
Well, one of the updates was a bug fix, and it was a serious bug, which made me turn red! So what was I supposed to do? Keep the fix for next month?
I was kidding, mate... :p

Viol8or 01-08-2005 07:01 PM
I've encountered an error when trying to change something in the 'Manage Warning Options' page:

Database error in vBulletin 3.0.5:

Invalid SQL: update gf_warning_options set hierarchical='Yes', automatic='Yes', automaticpm='No', autocomments='No', warner='0', automatic_warner='1', collector='1', banned_limit='7', points_before_banned='10', banned_usergroup_id='16', troll_usergroup_id='8', protected_usergroups='6|6', aprotected_usergroups='6', restore_groupid='0', incr_ban_days='Yes', max_no_bans='4', bans_mature='31', 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='20'
where oid='1'
mysql error: Unknown column 'autocomments' in 'field list'

mysql error number: 1054

Date: Saturday 08th of January 2005 10:00:11 PM
Script: http://mysite.org/admincp/admin_warn.php
Referer: http://mysite.org/admincp/admin_warn...=manageoptions

Did an install from scratch to latest version of AWS
If I look at the table it is indeed not there.

Rhoads 01-08-2005 07:23 PM
Hello sv1cec

When I look at the users (View Banned Users) in the mod of adminCP I get the next error.

HTML Code:
Parse error: parse error in /var/www/html/forum/modcp/banning.php on line 518
It's a edit file of the warning system, what can I do.

vb 3.0.5 file :
PHP Code:
print_table_header("$vbphrase[banned_users]: $vbphrase[temporary_ban] <span class=\"normal\">$vbphrase[usergroups]: " . implode(', ', 
$querygroups) . "</span>", 7); 
Edited file :
PHP Code:
print_table_header("$vbphrase[banned_users]: $vbphrase[temporary_ban] <span class=\"normal\">$vbphrase[usergroups]: " . implode(', ', 
$querygroups) . "</span>", 8);$querygroups) . "</span>", 7); 
Thnx, it's the only problem for me with 3.0.7 and vb3.0.5 ;)

Delphiprogrammi 01-08-2005 07:25 PM
hi,

updated to the latest release all works fine except for the new feature with that "stop" sign like image i don't see it and i am logged into my administrator account & did all the template modifications and uploaded the images to /images/misc/Warn.gif all is ee is a read line with the users warning level

Viol8or you need to add that colum to your database run

Code:
ALTER TABLE `".TABLE_PREFIX."warning_options ADD COLUMN autocomments char(3)
drop TABLE_PREFIX if MySQL complains about it and replace it by your table name

Delphiprogrammi 01-08-2005 07:28 PM
Quote:
Originally Posted by drl2005
Hello sv1cec

When I look at the users (View Banned Users) in the mod of adminCP I get the next error.

HTML Code:
Parse error: parse error in /var/www/html/forum/modcp/banning.php on line 518
It's a edit file of the warning system, what can I do.

vb 3.0.5 file :
PHP Code:
print_table_header("$vbphrase[banned_users]: $vbphrase[temporary_ban] <span class=\"normal\">$vbphrase[usergroups]: " . implode(', ', 
$querygroups) . "</span>", 7); 
Edited file :
PHP Code:
print_table_header("$vbphrase[banned_users]: $vbphrase[temporary_ban] <span class=\"normal\">$vbphrase[usergroups]: " . implode(', ', 
$querygroups) . "</span>", 8);$querygroups) . "</span>", 7); 
Thnx, it's the only problem for me with 3.0.7 and vb3.0.5 ;)

look carefully that you didn't forgot a ( { ) } or quotes parse error is php syntax related error you should look in the line number php tells you OR in the lines of code above it

Rhoads 01-08-2005 08:18 PM
Quote:
Originally Posted by Delphiprogrammi
look carefully that you didn't forgot a ( { ) } or quotes parse error is php syntax related error you should look in the line number php tells you OR in the lines of code above it
Thnx Delphiprogrammi

It's fixed, I forget to delete $querygroups) . "</span>", 7); after replacing that with $querygroups) . "</span>", 8); :ermm:

drumsy 01-09-2005 12:31 AM
I seem to having a template problem when upgrading postbit_legacy. The instructions say to look for this:

Code:
        <td class="alt1">
        <if condition="$show['messageicon'] OR $post['title']">
                        <!-- icon and title -->
                        <div class="smallfont">
                                <if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
                                <if condition="$post['title']"><strong>$post[title]</strong></if>
                        </div>
                        <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
And replace with this:

Code:
        <td class="alt1">
        <TABLE width=100%><TR>
                <TD width=90%><if condition="$show['messageicon'] OR $post['title']">
                        <!-- icon and title -->
                        <div class="smallfont">
                                <if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
                                <if condition="$post['title']"><strong>$post[title]</strong></if>
                        </div>
</td><TD width=10% align="$stylevar[right]">
<if condition="THIS_SCRIPT=='showthread' AND ($bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7) AND $post[warn_flag]>0">
                      <A HREF="Warn.php?do=ViewPostWarnings&post=$post[postid]"  onclick="window.open('Warn.php?do=ViewPostWarnings&post=$post[postid]','','width=1000, height=500, resizable=yes, scrollbars=yes'); return false;" target="_blank"><img src="images/misc/warn.gif" border=0></a>
</if>
</td></tr></table>
                        <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
However when I do so, and I refresh a thread, the first post looks fine, but the second and so on start nesting inside each other.

Any pointers?

Rhoads 01-09-2005 12:44 AM
Quote:
Originally Posted by drumsy
I seem to having a template problem when upgrading postbit_legacy. The instructions say to look for this:

Code:
        <td class="alt1">
        <if condition="$show['messageicon'] OR $post['title']">
                        <!-- icon and title -->
                        <div class="smallfont">
                                <if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
                                <if condition="$post['title']"><strong>$post[title]</strong></if>
                        </div>
                        <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
And replace with this:

Code:
        <td class="alt1">
        <TABLE width=100%><TR>
                <TD width=90%><if condition="$show['messageicon'] OR $post['title']">
                        <!-- icon and title -->
                        <div class="smallfont">
                                <if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
                                <if condition="$post['title']"><strong>$post[title]</strong></if>
                        </div>
</td><TD width=10% align="$stylevar[right]">
<if condition="THIS_SCRIPT=='showthread' AND ($bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7) AND $post[warn_flag]>0">
                      <A HREF="Warn.php?do=ViewPostWarnings&post=$post[postid]"  onclick="window.open('Warn.php?do=ViewPostWarnings&post=$post[postid]','','width=1000, height=500, resizable=yes, scrollbars=yes'); return false;" target="_blank"><img src="images/misc/warn.gif" border=0></a>
</if>
</td></tr></table>
                        <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
However when I do so, and I refresh a thread, the first post looks fine, but the second and so on start nesting inside each other.

Any pointers?
I have the same problem :cry:

nubian 01-09-2005 03:57 AM
is this hack 3.0.5 compliant?

sv1cec 01-09-2005 06:04 AM
Answers to all good people who wrote with problems (if I forget someone, it's not intentional, I just got my first sip of coffee):

Delphiporogrammer: Stop Sign: Did you upload the image in your images/misc directory? It looks as if you have it named Warn.gif. I think it should be warn.gif (caps are critical in a Unix system, I do not know what you are running your server on).

Others with nested threads: Guys, you are lucky, because your system CAN show you the classic layout, even if it shows it nested! LoL, I think I've screwed up my files somewhere, and even though I select the "Classic" layout, I still do not get it, in my active site. Checking my test site now. Yeap. it does the same, so I think I have to look into it. I need to find which file is creating this problem. Give me some time.

Nubian, yes, it works OK with 3.0.5, apart from the problem with the Classic view.

Rgds

sv1cec 01-09-2005 06:27 AM
Gentlemen,

Those of you who can see the Classic view of your posts, please try the following:

In the postbit.legacy template, I suggested that you make the following change, in order to show the Warn Sign.

HTML Code:
        <td class="alt1">
        <TABLE width=100%><TR>
                <TD width=90%><if condition="$show['messageicon'] OR $post['title']">
                        <!-- icon and title -->
                        <div class="smallfont">
                                <if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
                                <if condition="$post['title']"><strong>$post[title]</strong></if>
                        </div>
</td><TD width=10% align="$stylevar[right]">
<if condition="THIS_SCRIPT=='showthread' AND ($bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7) AND $post[warn_flag]>0">
                      <A HREF="Warn.php?do=ViewPostWarnings&post=$post[postid]"  onclick="window.open('Warn.php?do=ViewPostWarnings&post=$post[postid]','','width=1000, height=500, resizable=yes, scrollbars=yes'); return false;" target="_blank"><img src="images/misc/warn.gif" border=0></a>
</if>
</td></tr></table>
                        <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
                        <!-- / icon and title -->
                </if>
Please replace that part of the code with the one listed below, and tell me if the nested thingy stopped.

HTML Code:
<td class="alt1">
        <TABLE width=100%><TR>
                <TD width=90%>
                <if condition="$show['messageicon'] OR $post['title']">
                        <!-- icon and title -->
                        <div class="smallfont">
                                <if condition="$show['messageicon']">
                                        <img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" />
                                </if>
                                <if condition="$post['title']">
                                        <strong>$post[title]</strong>
                                </if>
                        </div>
                </if>
                </td>
                <TD width=10% align="$stylevar[right]">
                <if condition="THIS_SCRIPT=='showthread' AND ($bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7) AND $post[warn_flag]>0">
                      <A HREF="Warn.php?do=ViewPostWarnings&post=$post[postid]"  onclick="window.open('Warn.php?do=ViewPostWarnings&post=$post[postid]','','width=1000, height=500, resizable=yes, scrollbars=yes'); return false;" target="_blank"><img src="images/misc/warn.gif" border=0></a>
                </if>
                </td>
                </tr></table>
                        <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
                        <!-- / icon and title -->
Please let me know if that works, because I can't test it. Both my test and active site, refuse to change from the Modern Look to the Classic one, talk about big time mess!

Rgds

Rhoads 01-09-2005 10:28 AM
Quote:
Originally Posted by sv1cec
Gentlemen,

Please let me know if that works, because I can't test it. Both my test and active site, refuse to change from the Modern Look to the Classic one, talk about big time mess!

Rgds
It's works sv1cec :up:
Thnx you

Dennis B 01-09-2005 10:38 AM
sv1cec,

Just tested the new postbit_legacy above in 3.0.5, working well. :)

Thanks.

sv1cec 01-09-2005 11:14 AM
Quote:
Originally Posted by Dennis B
sv1cec,

Just tested the new postbit_legacy above in 3.0.5, working well. :)

Thanks.
Hey guys,

Let me know something, because after installing all those patches and hacks on my server, I begun loosing control.

From where do you select if a user will use the postbit or the postbit legacy template? In other words, where does a user declares if he wants the modern or the classic layout?

I've re-installed this functionality on my system, I had forgotten to compare a file and it was that single one, where I needed to change something, but this (in my system) was implemented with a hack.

Can you please tell me what is the standard way of doing it?

Rgds

Dennis B 01-09-2005 11:35 AM
sv1cec,

Read this. ;)

Dennis B 01-09-2005 11:42 AM
sv1cec,

If I may, here's an alternative idea for the postbit_legacy layout, where the warn sign gets displayed in the left box, where the username, avatar and other icons are.

Revert postbit_legacy to its default text concerning the warn sign part (post above by sv1cec).

Then find:
Code:
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon]</div>
And right above it insert:

Code:
<!-- AWS stop sign hack -->
<if condition="THIS_SCRIPT=='showthread' AND ($bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7) AND $post[warn_flag]>0">
<br />
<div>
<a href="Warn.php?do=ViewPostWarnings&post=$post[postid]"  onclick="window.open('Warn.php?do=ViewPostWarnings&post=$post[postid]','','width=1000, height=500, resizable=yes, scrollbars=yes'); return false;" target="_blank"><img src="images/misc/warn.gif" border=0></a>
</div>
</if>
<!-- hack end -->

sv1cec 01-09-2005 11:54 AM
Quote:
Originally Posted by Dennis B
sv1cec,

If I may, here's an alternative idea for the postbit_legacy layout, where the warn sign gets displayed in the left box, where the username, avatar and other icons are.

Revert postbit_legacy to its default text concerning the warn sign part (post above by sv1cec).

Then find:
Code:
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon]</div>
And right above it insert:

Code:
<!-- AWS stop sign hack -->
<if condition="THIS_SCRIPT=='showthread' AND ($bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7) AND $post[warn_flag]>0">
<br />
<div>
<a href="Warn.php?do=ViewPostWarnings&post=$post[postid]"  onclick="window.open('Warn.php?do=ViewPostWarnings&post=$post[postid]','','width=1000, height=500, resizable=yes, scrollbars=yes'); return false;" target="_blank"><img src="images/misc/warn.gif" border=0></a>
</div>
</if>
<!-- hack end -->
Dennis,

Thanks for that link, that is what I have done (mostly). But for the name of God, I couldn't remember where that was in the standard vB. I guess it is a general setting, applicable to all users, all posts. Thanks for the heads-up though, appreciated.

As for your alternative position for the Warn Sign (I have to come up with a better name for it), it's fine with me, users can easily move that around, wherever they want, I just have too many things in that part of the legacy template (warning links, user away info etc), so I thought I'd place it there. But of course, users can move it wherever they see fit.

Again, thanks and rgds

Dennis B 01-09-2005 12:04 PM
no problem, and thank you for such great support on this hack. :up:

sv1cec 01-09-2005 03:54 PM
Quote:
Originally Posted by Dennis B
no problem, and thank you for such great support on this hack. :up:
Doing my best Dennis, doing my best.

Rgds

j_86 01-09-2005 04:00 PM
sv1cec you should ask for your own Premium forum.

sajjid 01-09-2005 04:33 PM
i have edited all the files but have not run the install script because i cannot figure the following:
in your instructions it says
In the same template find:(postbit)
Code:
<if condition="$show['reputation']">$post[reputationdisplay]</if>
closes i can find in the templete is
Code:
<if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: $post[reppower] </if><div>$post[reputationdisplay]</div></if>
Also

3. NAVBAR TEMPLATE
In your navbar template, find:
Code:
<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
i can only find this in header tamplete please shed some light.
i am using vb 3.0.5

ok i have installed it but now i get pharse error if i replace this code in the ./includes/functions_newpost.php
Code:
global $DB_site, $vboptions, $vbphrase, $bbuserinfo, $forumperms, $usergroupcache, $_REQUEST;
to this
Code:
global $DB_site, $vboptions, $vbphrase, $bbuserinfo, $forumperms, $usergroupcache, $wehavecensoredwords, $weneedacounter, $newpostid, $_REQUEST
but if i dont make this change everything is ok i think

sv1cec 01-09-2005 07:01 PM
Quote:
Originally Posted by sajjid
i have edited all the files but have not run the install script because i cannot figure the following:
in your instructions it says
In the same template find:(postbit)
Code:
<if condition="$show['reputation']">$post[reputationdisplay]</if>
closes i can find in the templete is
Code:
<if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: $post[reppower] </if><div>$post[reputationdisplay]</div></if>
Also

3. NAVBAR TEMPLATE
In your navbar template, find:
Code:
<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
i can only find this in header tamplete please shed some light.
i am using vb 3.0.5

ok i have installed it but now i get pharse error if i replace this code in the ./includes/functions_newpost.php
Code:
global $DB_site, $vboptions, $vbphrase, $bbuserinfo, $forumperms, $usergroupcache, $_REQUEST;
to this
Code:
global $DB_site, $vboptions, $vbphrase, $bbuserinfo, $forumperms, $usergroupcache, $wehavecensoredwords, $weneedacounter, $newpostid, $_REQUEST
but if i dont make this change everything is ok i think
The installation instructions were all based on vB 3.0.3, so expect to find some differences. I just upgraded to 3.0.5 too, so I didn't have the time to redo them for this release.

First point, yeah that looks ok to use as the closest equivalent to my instructions.

In the NAVBAR template, if you check the Quick Links menu, it should say something like "Miscellaneous". I am not sure, but I do not think NAVBAR was changed from 3.0.3 to 3.0.5. Check where it has the drop down menus.

As for the last issue, you have to make that change. And that statement is not responsible for any parse error, unless you didn't put the semi-colon at the end. Maybe I forgot to put the semicolon in the instructions? No, it's there, but I do not see it in the code you posted. Check that there is a semicolor at the end of that statement, when you change it.

Rgds

sv1cec 01-09-2005 07:05 PM
Quote:
Originally Posted by JimpsEd
sv1cec you should ask for your own Premium forum.
I am not sure I even know what a premium forum is, my friend.

Rgds

sajjid 01-09-2005 07:10 PM
Quote:
Originally Posted by sv1cec
The installation instructions were all based on vB 3.0.3, so expect to find some differences. I just upgraded to 3.0.5 too, so I didn't have the time to redo them for this release.

First point, yeah that looks ok to use as the closest equivalent to my instructions.

In the NAVBAR template, if you check the Quick Links menu, it should say something like "Miscellaneous". I am not sure, but I do not think NAVBAR was changed from 3.0.3 to 3.0.5. Check where it has the drop down menus.

As for the last issue, you have to make that change. And that statement is not responsible for any parse error, unless you didn't put the semi-colon at the end. Maybe I forgot to put the semicolon in the instructions? No, it's there, but I do not see it in the code you posted. Check that there is a semicolor at the end of that statement, when you change it.

Rgds
yes it was the semi-colon me maybe sleepy thanks well spotted also Quick Links menu is in the header
thanks

Delphiprogrammi 01-09-2005 08:43 PM
Quote:
Originally Posted by sv1cec
Delphiporogrammer: Stop Sign: Did you upload the image in your images/misc directory? It looks as if you have it named Warn.gif. I think it should be warn.gif (caps are critical in a Unix system, I do not know what you are running your server on).
Rgds
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

rh2004 01-09-2005 11:06 PM
Hey how do I show the Warnings: (level) to everyone that is displayed in postbit...

Just the Warning: (level)

Not how many times banned

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 08:09 AM.
Page 16 of 27 « First 61415 16 171826 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.02112 seconds
  • Memory Usage 1,955KB
  • 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
  • (19)bbcode_code_printable
  • (6)bbcode_html_printable
  • (4)bbcode_php_printable
  • (20)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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