I have installed the VBJ mod and the CMPS Journal mod, but I can't seem to get the journal body to show up on the main page. Any ideas would be great!!
TIA,
Bill Bensen
All respect to Bolas for this module!!
Simple mods to this for a center module "blog" type entry
journalentries.php
<?php
// ######################### Latest Forum Topics #########################
$getlateste= $DB_site->query("SELECT journal_entries.entrytitle,journal_entries.entrydate,
journal_entries.entry_id,journal_entries.entrytext ,
journal_entries.journal_id,journals.journalist,journals.journalist_id, journals.commentcount
FROM ".TABLE_PREFIX."journal_entries AS journal_entries
LEFT JOIN ".TABLE_PREFIX."journals AS journals ON (journal_entries.journal_id=journals.journal_id)
WHERE journal_entries.entry_active=1 AND journal_entries.private!=1 AND journals.private!=1 and journals.journalist_id = 1
ORDER BY journal_entries.entrydate DESC
LIMIT 5
");
$countlatest= $DB_site->num_rows($getlateste);
$latestentrybits = "";
if($countlatest>0)
{
while($latest= $DB_site->fetch_array($getlateste))
{
$latestentrydate= vbdate($vboptions['dateformat'], $latest['entrydate'], 1);
$latestentrytime= vbdate($vboptions['timeformat'], $latest['entrydate']);
exec_switch_bg();
if(strlen($latest[entrytitle])>20)
{
$latest[entrytitle]= "".substr($latest[entrytitle],0,20)."...";
}
if(strlen($latest[entrytext])>150)
{
$latest[entrytext]= "".substr($latest[entrytext],0,200)."<div class='smallfont'><a href='$vboptions[bburl]/journal.php?do=showentry&e=$latest[entry_id]' title='$latest[entrytext]'>more...</a>";
}
eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";');
}
$DB_site->free_result($latest);
}
else
{
$latestentrybits=$vbphrase['adv_no_entries'];
}
eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('adv_portal_latestjournalentry') . '";');
$DB_site->free_result($getlateste);
unset($latestentrybits,$latest,$latestentrytime,$l atestentrydate,$countlatest);
?>
journal_latestentrybits
<tr>
<td class="$bgclass"><div class="smallfont">$latestentrydate </br><a href="$vboptions[bburl]/journal.php?do=showentry&e=$latest[entry_id]" title="$latest[entrytext]"><b>$latest[entrytitle]</b></a> <br /></div></td>
<tr><td class="$bgclass"><blockquote><div class="smallfont">$latest[entrytext]</div></blockquote><span style="cursor:pointer" onclick="window.open('member.php?u=$latest[journalist_id]')">Posted by: $latest[journalist] </span>at <span class="time">$latestentrytime</span> ($latest[commentcount] comments)</td></tr>
</tr>
1. you have a weird space in the code you pasted "jou rnals"
Fixed that one, cut n paste from terminal sessions does wiggy things once in a while.
2. Have you tried the standard code and template before your own modifications?
I have and it's also working on my live site. Surf this... photography (http://www.surfthisphotography.com)
3. Your template at least worked for me
4. Did you add and activate the module?
Glad to hear it! Thanks again for the feedback. Check the link above for the live module.
Regards,
Bill Bensen