vBJournal Lite 1.1b

ATM, this hack would work with ALL versions of vB unless they renamed the 'user' table :speechless:


README.txt (can be found in the zip)


README.txt
New in 1.1b
- Edit journal.php (2 lines). New journal.php here, for 1.1a users

================================================== ===================================
================================================== ===================================
=== vBJournal Lite version 1.1b =============================================
================================================== ===================================
================================================== ===================================
This is an addon to vBulletin and acts as an online journal/diary. Users can add entries, either

making them private or public(for all to see). For the public entries, users can comment on them.

Thats about it. You should be able to get a better idea viewing a live demo at

http://sgstudents.com/forum/journal.php. The GUI was modeled after gamingforces journal at

http://www.gamingforce.com/forums/journal.php .
-------------------------------------------------------------------------------------
=== This being my first hack, i am SURE that there are going to be =======
=== some bugs, and problems, so just to warn you first =======
=== :: BACKUP YOUR DATABASE ! =======
-------------------------------------------------------------------------------------

Now thats over with lets start... I will list the steps of what needs to be done...
NOW :

1) Edit the images to suit your site.
2) Upload the images to the forum's /images folder.

3) Upload install_journal.php to your admin directory.
4) Run install_journal.php and follow instructions... shouldn't be a problem. but i only tested

it once .

5) Run this query (using phpmyadmin,or use this hack

https://vborg.vbsupport.ru/show...&threadid=26272 , etc)

ALTER TABLE user ADD journal SMALLINT NOT NULL

[note this will add a column in your 'user' table, but i think that shouldnt be a problem ...]

6) Upload journal.php to your forum's root directory.
7) goto journal.php page and click on the button ... (should say "Get a journal" or "Unlock

Journal" Cant rem which
... bad memory. lol) this will enable the admin journal (userid=1) and show the first default

welcome msg.

8) Link to journal in postbit.
------------------------------

- open admin/functions.php

FIND

/////////////////////////////////////////////////////

$datecut = time() - $cookietimeout;

if ($counter%2==0) {
$post[backcolor]="#13486D";
$post[bgclass] = "alt1";
} else {

/////////////////////////////////////////////////////

Add ABOVE THIS


/////////////////////////////////////////////////////

// vBJournal Hack by Ryangel
if($post[journal]==1){
$journal = '<a href="journal.php?s=&journalid='.$post[userid].'&action=view"><img

src="https://vborg.vbsupport.ru/images/journal.gif" alt="View '.$post[username].'\'s Journal" border="0"/></a>';
}
else {
$journal = '';
}

/////////////////////////////////////////////////////


save and upload admin/functions.php.

9) open your postbit template and add $journal to where you want the link to show.


You are done ! The journal should be able to work now

FEW THINGS TO NOTE
------------------------------------------
- private entries can only be viewed by the owner or admin.
- erm... did i say a few? ok thats the main thing to note.... I'll edit this as it comes to my

mind. lol :laugh:

IN WORKS FOR NEXT VERSION
------------------------------------------
- incooperate moods
- better interface ( but that you can do now by editing the templates yourself )
- Admin interface -> from admin cp.
- New user option to choose whether buddies/admin can view private entries.
- anything else that might come up from discussions.


Version Update Log
------------------

1.1a
- Fixed some table color code.
- Added template txt for manual install.

DEMO: http://sgstudents.com/forum/journal.php

[Oblivion Knight]

Thanks very much for that addon joeboo..

[Frozen Dreams]

very cool add ons .. think I will install the mood and now playing one


but could someone please try to get this to work with avatar categories ... I have tried about everything and cant get it to work ... and users are alredy asking why their avs dont show

please could someone try ...

[midnightz]

Nice addon

[Gutspiller]

How can I get the latest journals to appear on a non-vb page? I have nothing that links to the journals so nobody knows when they've been updated unless they go into the journal section.

Can somebody please help me on getting the latest journals that have been updated onto a non-vb page?

Please.

Thanks.

[FleaBag]

Nice hack! Just what I was looking for...

Templates said they automatically installed, but they didn't. Manually added them and everything works fine... Thanks for the fixes too. As I become more savvy with PHP I might work on this - see how it goes.

[D-Orange]

02-25-03 at 11:34 AM Zelda-King said this in Post #157
[B]I didn't alter anything and I have the same problem;

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT u.username, e.entryid, e.journalid, e.title, e.entry, e.timestamp, e.userid, e.private, e.displayorder, e.comments
FROM journal_entry e
LEFT JOIN user u ON e.userid = u.userid
WHERE e.journalid = 14
ORDER BY e.timestamp DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Tuesday 25th of February 2003 03:18:48 AM
Script: http://www.gamercrossfire.net/bb/bb/...14&action=view
Referer:

-------------------------------

Much appreciated. I used this. A few notes though;

In memberlist.php use

PHP Code:

// vBJournal Hack by Ryangel
    if($userinfo[journal]==1){
        $journal = '<a href="journal.php?s=&journalid='.$userinfo[userid].'&action=view"><img src="images/journal.gif" alt="View '.$userinfo[username].'\'s Journal" border="0"/></a>';
    }
    else {
        $journal = ''; 


instead of

PHP Code:

// vBJournal Hack by Ryangel
    if($userinfo[journal]==1){
        $journal = '<a href="journal.php?s=&journalid='.$userinfo[userid].'&action=view"><img src="images/journal.gif" alt="View '.$userinfo[username].'\'s Journal" border="0"/></a>';
    }
    else {
        $journal = '';
// vBJournal Hack by Ryangel 


In the memberlist template add;

<td bgcolor="{*tableheadbgcolor*}" align="center"><smallfont color="{*tableheadtextcolor*}"><b>Journal</b></smallfont></td>

above

$memberlistbits

rather than putting

<td bgcolor="#1D6AA0" align="center"><smallfont color="#EEEEFF"><b>Journal</b></smallfont></td>

below it.

In the memberlistbit template use;

<td bgcolor="{*firstaltcolor*}">$journal</td>

rather than

<td bgcolor="#13486D">$journal</td>

Most of this isn't your fault. I noticed when you put something like {*tableheadbgcolor*} (without the *s) it's replaced with the tableheadbgcolor HTML for this board.

Remove all the *s in my coding for it to work.

[/i]

I've done this, however I get a Parse error: parse error in /home/guforum/public_html/test/memberlist.php on line 202

version is 2.3.0

any thoughts what's wrong?

[Intex]

Great hack - a nice addition. I've installed it and it appears to work fine with the exception of when you view a users journal, which produces an error at the top of the screen:

'Query could not be executed'

I'm able to create journal entries and they display no problems (public and private). So I'm not sure what's actually missing.

Anybody?

[midnightz]

Ok I have decided to take on the task of adding on some options, I am adding on the ability for new comments and entries to appear in New Posts, since this is something I have been wanting for a quite sometime. Give me about a week to pull this together.

I need a break, I just added a hivemail de-limiter so you need a minimum of posts to have access and I need to finish three websites, then I'm on it.

Cheers all - This is great hack and needs to evolve.

midnightz

[Oblivion Knight]

I hope the avatar issue is eventually solved (showing custom avs only)..
I've had a go myself on a couple of occasions to fix this and just can't get it to work.

[midnightz]

what post # was the list of stuff to be fixed and added?