[g-force2k2]

dontpanic,

Instead of making a new table and having to JOIN the table info I just added fields to the forum TABLE.

Queries To Run ( 3 )
If you have table prefixes don't forget to add it to the 'forum' in the sqls below.

ALTER TABLE forum ADD usedefbk TINYINT ( 1 ) UNSIGNED NOT NULL DEFAULT '0'
ALTER TABLE forum ADD bktitle VARCHAR ( 100 ) NOT NULL
ALTER TABLE forum ADD bkcontent MEDIUMTEXT NOT NULL

File Modifications ( 3 )
Note that I did not vb phrase the data below.

Open admincp/forum.php ( 3 )

Find: ( 1 )

PHP Code:

            'warnall' => 0 


Under It Add:

PHP Code:

            , 'usedefbk' => 1 


Find: ( 2 )

PHP Code:

    print_yes_no_row($vbphrase['show_forum_on_forum_jump'], 'options[showonforumjump]', $forum['showonforumjump']); 


Under It Add:

PHP Code:

    print_table_header ( "Forum Book Content Information" ) ;

    print_yes_no_row ( "Use Default Book Info", 'forum[usedefbk]', $forum['usedefbk'] ) ;
    print_input_row ( "Book Title", 'forum[bktitle]', $forum['bktitle'] ) ;
    print_textarea_row ( "Book Content", 'forum[bkcontent]', $forum['bkcontent'] ) ; 


Find: ( 3 )

PHP Code:

    $forum['description'] = convert_to_valid_html($forum['description']); 


Under It Add:

PHP Code:

    $forum['bktitle'] = convert_to_valid_html ( $forum['bktitle'] ) ;
    $forum['bkcontent'] = convert_to_valid_html ( $forum['bkcontent'] ) ; 


Open SHOWTHREAD Template

Replace Your Code Of Conditionals Relating To Forumids With Something Similar To This:

<!-- book content -->
<div align="center">
  <center>

<table class="tborder" cellpadding="0" cellspacing="$stylevar[cellspacing]" border="0" width="100%" style="border-collapse: collapse" bordercolor="#111111">

<tbody>
	<tr>
		<td class="thead" colspan="5" width="100%" align="left" valign="top">
			<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_poparticles')"><img id="collapseimg_forumhome_poparticles" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_poparticles].gif" alt="" border="0" /></a>MCSE 
            World Recommended Reading</td>
	</tr>
</tbody>
<tbody id="collapseobj_forumhome_poparticles" style="$vbcollapse[collapseobj_forumhome_poparticles]">
    <tr>
        <td class="alt1Active" width="100%" align="left" valign="top" colspan="5">
        <span class="smallfont"><b>
		<if condition="$foruminfo['usedefbk']==1">
		$foruminfo[bktitle]
		<else />
		<!-- default book title goes here -->
		</if>
	  </b></span></td>
    </tr>
        <tr>
        <td class="alt1Active" width="20%" align="center" valign="top">
		<if condition="$foruminfo['usedefbk']==1">
		$foruminfo[bkcontent]
		<else />
		<!-- default book content goes here -->
		</if>
	  </td>
    	</tr>
        <tr>
        <td class="alt1Active" width="100%" align="center" valign="top" colspan="5"><div class="smallfont">
        <b>Please help support MCSE World by purchasing your study materials 
        through these links to Amazon.com.</b></div></td>
    </tr>
</tbody>
</table>
  </center>
</div>
<br>
<!-- book content -->

Cheers,
g-force2k2