vB Journal | vba CMPS module: latest entries

This hack is for [vB 3.0.3] - vB Journal for vBulletin 3.0.3(v1.0.0) and [vB 3.0.3]

Hi,
this is the Brahm's vbindex conversion for vba CMPS: this module will show latest journal entries in a box in your CMPS system.

demo:
http://www.wellage.net



Here we go:

touch /path_to_your_forum_dir/modules/journalentries.php
-----------------------------------------

PHP Code:

<?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
            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
            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,150)."...";
                    }
                    eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";');
                }
                $DB_site->free_result($lastest);
            }
            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,$latestentrydate,$countlatest);

?>

then create template 'adv_portal_latestjournalentry'
-----------------------------------------

<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
<thead>
 <tr>
  <td class="tcat">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('cmps_pagesmenu')"><img id="collapseimg_cmps_pagesjournal" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_cmps_pagesjournal].gif" alt="" border="0" /></a>
    <span class="smallfont"><strong>$vbphrase[adv_latest_journalentries]</strong></span>
  </td>
 </tr>
</thead>
<tbody id="collapseobj_cmps_pagesjournal" style="$vbcollapse[collapseobj_cmps_pagesjournal];text-align:$stylevar[left]">
$latestentrybits
</tbody>
</table>
<br />

Now add 2 GLOBAL phrases:
$vbphrase[adv_latest_journalentries] = "Latest Journal Entries"
$vbphrase[adv_no_entries] = "No Journal Entries"



Then create a new module:
Module Title: Journal Latest Entries
File to include: journalentries.php
Active: yes... -.-'
Column: right|left
Templates Used: adv_portal_latestjournalentry, journal_latestentrybits


Have fun and don't forget to :-)





UPDATE (10/17/2004):
- added 2 modified version of 'journal_latestentrybits' for right|left or center block (thanx to Billbensen for center version) - see attachments [ billbensen__centered_block.txt]
- Valentino Rossi Wins! :devious:

UPDATE (10/20/2004):
- patched template collapse id, please change your old template with new version. (thx to memobug for debugging)




thx to
AN-net for his Journal hack
Brahm for the vBindex version of this module.
Billbensen for modified version of journal_latestentrybits template

[Roms]

Installed, works great! Thanks.

*Clicks Install

[docvader]

Aaarrgh. I've tried installing this many times, and for some reason, it's the only CMPS module I can't get to show up on my main page, http://x.russbo.com/index.php
Vb3 Journal works fine, at http://x.russbo.com/vb/index.php
I don't understand why the journal works fine in the forums, but I can't get it to visualize on the CMPS page. I've followed the directions implicitly many a time.

Any idea where there might be a problem? No doubt it's something simple. Can I have a database problem which is causing this not to show, even though the Journal works fin in the forum???

[docvader]

Aaarrgh. I've tried installing this many times, and for some reason, it's the only CMPS module I can't get to show up on my main page, http://x.russbo.com/index.php
Vb3 Journal works fine, at http://x.russbo.com/vb/index.php
I don't understand why the journal works fine in the forums, but I can't get it to visualize on the CMPS page. I've followed the directions implicitly many a time.

Any idea where there might be a problem? No doubt it's something simple. Can I have a database problem which is causing this not to show, even though the Journal works fin in the forum??? I'm completely baffled.

Thanks!

[Lionel]

I have a small problem. At the end of my page I show a tag that is not closed: </html
And sometimes when I click on any link from that page, I get a blank page with >
When I refresh then it is fine.

I disabled the module and the tag disappeared. I re enabled, it came back....

I really need to use this. Any suggestions?

[Bolas]

Have you modified the content of my module?

[Lionel]

No not at all. It's pretty straight forward. I encounter a mysql issue twice: I am still at 3.23. I don't know if this has any relation whatsoever.

[Bolas]

I installed again that hack, and it works fine.. and I don't know if to be happy or not for that :/
Is your vbAdvanced clean? Have you installed some plugin or hack for it?
It seems that a function cut 1 char.. and I'm not able to find the problem without have all the system under my hand!

[Lionel]

clean? there is nothing to do in there, it's allmodules... :-)

if you want, I could pm you my info to see...

[Bolas]

Yes, if you trust me.
I will debug it in your system.

[Zacharicus]

I'm assuming it doesn't work for 3.0.7? I can't get it to show up.