vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Collapsable forums on forum home (https://vborg.vbsupport.ru/showthread.php?t=33961)

globalwin 06-19-2002 07:48 PM

I get this error when inserting it into the db..

SQL-query: [Edit]

ALTER TABLE forum ADD collapsed SMALLINT DEFAULT '0' NOT NULL
ALTER TABLE user ADD forumviewset varchar(250) NOT NULL default ':'
MySQL said: You have an error in your SQL syntax near 'ALTER TABLE user ADD forumviewset varchar(250) NOT NULL default ':'' at line 2

The automated file thing cX_install.php doesnt work...

dabean 06-19-2002 08:37 PM

Quote:

Originally posted by globalwin
I get this error when inserting it into the db..

SQL-query: [Edit]

ALTER TABLE forum ADD collapsed SMALLINT DEFAULT '0' NOT NULL
ALTER TABLE user ADD forumviewset varchar(250) NOT NULL default ':'
MySQL said: You have an error in your SQL syntax near 'ALTER TABLE user ADD forumviewset varchar(250) NOT NULL default ':'' at line 2


The automated file thing cX_install.php doesnt work...

The error you've posted looks suspiciously like a phpmyadmin error message, so what is wrong with cx_install.php?

As stated in the readme you can either manually change the database or use cx_install to do it for you.

As for the error you've reported you need to put a semi-colon at the end of the first line.

FleaBag 06-20-2002 10:11 AM

Working great on 2.2.6. I did notice though in the install guide it mentioned 'add the bits in red', but there were no red bits. Maybe it's just me though. :)

Birdie501 06-25-2002 12:49 PM

Hi,

it works for me. But if i contract the forums in one category only the category is shown. That is ok, but if i reload the page it is still contracted but now there are also the headlines like Forum, Date, Posts, etc... under the category.?

If i expand it and contract it again it is without that headlines?

How to fix that?
Thanks! :cross-eyed:

dabean 06-25-2002 02:03 PM

Quote:

Originally posted by Birdie501
Hi,

installed it, works fine, but what does this mean?

now
find the template you added the the Forum Posts Threads Last Post Moderator repeats per forum to and alter
<tr align="center">
<td bgcolor="

to read
<tr id="f$forum[forumid]z" align="center">
<td bgcolor="

which template???

That instruction is contained in the "template_option" file which is only to be used when you've modified the display to repeat the "forum, posts... etc" header for each group of forums. Now depending on how you've done that modification the template will be either forumhome_forumbit_level1_nopost or forumhome_forumbit_level2_nopost. If you are not using a template mod to repeat the header carrying out the instructions in template_option WILL stop the hack from working correctly.

Birdie501 06-25-2002 02:04 PM

upps i just edited my post! :-)

dabean 06-25-2002 02:08 PM

The solve the problem you have modify forumhome_forumbit_level1_nopost to include the fragment you pasted.

Birdie501 06-25-2002 02:15 PM

yes but how to do that? can give more details? Thanks!

dabean 06-25-2002 03:14 PM

Quote:

Originally posted by Birdie501
yes but how to do that? can give more details? Thanks!
As mentioned in the template_option instructions...
PHP Code:

templateforumhome_forumbit_level1_nopost
find 
and alter 
<tr align="center"
<
td bgcolor=

to read 
<tr id="
f$forum[forumid]z$fhomeexpandstyle align="center">  
<td bgcolor=" 

You also need to have made all of the other changes mentioned in the file.

Birdie501 06-25-2002 03:36 PM

ok this is my template:

PHP Code:

<tr align="middle">
            <
td valign="center" bgColor="#d3e5fa" colSpan=5>&nbsp</td>
</
tr>

<
tr id="cat">

 <
TD bgcolor="#1960CA" background="{ imagesfolder }/cat_backing.gif" colSpan=10 align=center align=middle valign="middle">
 <
table width="100%" border="0" cellspacing="0" cellpadding="0">
<
tr
    <
td align="left" width="15%" valign="middle">
$expandcontract   
    
<img src="{ imagesfolder }/cat_image.gif" width="23" height="15" align="absmiddle">
    </
td>
<
td width="70%" align="center" valign="middle">
  <
b><img src="{ imagesfolder }/cat_sideleft.gif" width="30" height="15" align="middle"></b
 
<
a href="forumdisplay.php?s=$session[sessionhash]&forumid=$forum[forumid]">
    <
normalfont color="#FFFFFF"><b>$forum[title]</b></normalfont></a
    <
img src="{ imagesfolder }/cat_sideright.gif" width="30" height="15" border="0" align="middle">
  

</
td>
    <
td width="15%" valign="middle">&nbsp;</td>
  </
tr>
</
table>
</
td>
</
tr>
<
tr id="f$forum[forumid]z" align="center"
  <
td background="{ imagesfolder }/col_backing.gif" width="5%"><smallfont>&nbsp;</smallfont></td>
  <
td background="{ imagesfolder }/col_backing.gif" width="65%" align="left"><smallfont color="{tableheadtextcolor}"><b>Forum</b></smallfont></td>
  <
td background="{ imagesfolder }/col_backing.gif"><smallfont color="{tableheadtextcolor}"><b>Beitr?ge</b></smallfont></td>
  <
td background="{ imagesfolder }/col_backing.gif"><smallfont color="{tableheadtextcolor}"><b>Themen</b></smallfont></td>
  <
td background="{ imagesfolder }/col_backing.gif" nowrap><smallfont color="{tableheadtextcolor}"><b>Letzter Beitrag</b></smallfont></td></tr

What is wrong?
As i said before: if i ctract it, it is ok and i can only see the category!
but if i reload the page you see the category and this part:

PHP Code:

<td background="{ imagesfolder }/col_backing.gif" width="5%"><smallfont>&nbsp;</smallfont></td>
  <
td background="{ imagesfolder }/col_backing.gif" width="65%" align="left"><smallfont color="{tableheadtextcolor}"><b>Forum</b></smallfont></td>
  <
td background="{ imagesfolder }/col_backing.gif"><smallfont color="{tableheadtextcolor}"><b>Beitr?ge</b></smallfont></td>
  <
td background="{ imagesfolder }/col_backing.gif"><smallfont color="{tableheadtextcolor}"><b>Themen</b></smallfont></td>
  <
td background="{ imagesfolder }/col_backing.gif" nowrap><smallfont color="{tableheadtextcolor}"><b>Letzter Beitrag</b></smallfont></td></tr

???


All times are GMT. The time now is 03:55 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.01489 seconds
  • Memory Usage 1,777KB
  • 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_php_printable
  • (3)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
  • (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