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

[sabret00the]

how can i get the number of comments to show up on the journal-home (journal.php) (where it shows 10 latest entries)

[memobug]

Originally Posted by memobug

I just installed this and embedded BB Code images worked the first time I tried, but subsequently they do not. I tried editing the original post with img tags, and adding more posts, but they appear simply as url-type links.

I think I resolved the problem with the no embedded image display that a couple of people were reporting. The problem appears to be that the bbcode parsing improperly executed. It was called like this:

bbcodeparse($journal[entry]);

Ordinarily there would be additional parameters, $forumid and $allowsmilies, for something like this

$journal[description] = bbcodeparse($journal[entry],$forumid,$allowsmilies);

Then bbcodeparse would lookup the forum's image display flag and decide whether to display html, images and smilies. It would pass those instructions forward as additional argumetns to bbcodeparse2 like this:

bbcodeparse2($bbcode,$dohtml,$dobbimagecode,$dosmi lies,$dobbcode)

Of course the journal doesn't have a valid forum ID, so it was behaving a little strangely and not displaying images on my forum on my server. It worked for some.


The Bottom Line
But if you have this problem, you can make the bbcode call explicit, and tell it absolutely whether to display html, embedded images, smilies and bbcode in your journals:

1. Around line 680 (I have added stuff so the numberings off by +/ 10 lines:

// replace this:
            $journal[description] = bbcodeparse($journal[entry]);
// with this:
            $journal[description] = bbcodeparse2($journal[entry],0,1,1,1);

2. around line 360

// replace this:		
$journal_comment[comment] = bbcodeparse($journal_comment[comment]);
// with this:
		$journal_comment[comment] = bbcodeparse2($journal_comment[comment],0,1,1,1);

That should take care of embedded images. I suppose you could also make it ....1,1,1,1); to enable the display of html in your gallery.


Next step, figure out why URLs are not being hotlinked automatically!

Regards,

Matt

[Red Blaze]

Works pretty good for me so far. THANK YOU!!

Any updates on it though? I'd like for the user's buddies to see the private entries instead of just the admins.

[memobug]

Originally Posted by sabret00the

how can i get the number of comments to show up on the journal-home (journal.php) (where it shows 10 latest entries)

Not sure exactly what you mean. I can see a few useful possibilities, though:

1) Do you want a new table that is something like

Journals with the most Comments
TreeBay's Journal 19 Comments
Lesley's Journal 8 Comments
LivingArt's Journal 3 Comments
BonsaiMon's Journal 2 Comments
pdbbonsai's Journal 2 Comments
waltseed's Journal 2 Comments
buzzy's Journal 1 Comments


2) Do you want a new table that is something like:

Most Recent Comments
2-Oct-2003 07:00 AM | By TreeBay in waltseed's Journal
29-Sep-2003 07:06 PM | By Lesley in BonsaiMon's Journal
23-Sep-2003 10:37 PM | By Lesley in LivingArt's Journal
22-Sep-2003 07:25 PM | By LivingArt in buzzy's Journal
19-Sep-2003 09:02 PM | By TreeBay in Lesley's Journal

or
3) Maybe you want to display the number of comments next to the number of entries in the existing tables without adding tables?

Regards,

Matt

[mariannet]

Hi there

Love this hack - but...

I keep getting this error:

*******************************
Database error in vBulletin 2.3.0:

Invalid SQL: UPDATE user SET journal=0 WHERE userid=1
mysql error: Unknown column 'journal' in 'field list'

mysql error number: 1054

Date: Tuesday 07th of October 2003 06:58:01 PM
Script: http://cgi.dullernes-univers.dk/ms/m...on=lockjournal
Referer:
********************************

The actions actually takes place even though this error happens.

What to dooooo?

[Red Blaze]

I found these problems and some have been mentioned before.

I barely found them. The install went well is what I ment. ^^;;

1) The comment button is broken. I can't make a comment, it'll take me to an unknown page. Tried to fix it, but couldn't.
2) The Avatars won't show. It would give me an "x" or nothing at all. It's a "no avatar selected" type of thing. I added that hack. It's a defult avatar in other words.

[morpheusXIIX]

Originally Posted by mariannet

Hi there

Love this hack - but...

I keep getting this error:

*******************************
Database error in vBulletin 2.3.0:

Invalid SQL: UPDATE user SET journal=0 WHERE userid=1
mysql error: Unknown column 'journal' in 'field list'

mysql error number: 1054

Date: Tuesday 07th of October 2003 06:58:01 PM
Script: http://cgi.dullernes-univers.dk/ms/m...on=lockjournal
Referer:
********************************

The actions actually takes place even though this error happens.

What to dooooo?

looks like the table JOURNAL wasnt added to your database. I would check that.

[Red Blaze]

Can I get any help with making a comment? When a user makes a comment and clicks on "Add comment" button, it can't find the page, and the comment information doesn't go to the database.

EDIT: Ok, I sorta fixed it, but the info STILL doesn't go to the database. It just goes to the main Journal page. This is the link I have in the journal_comments template.

<form action="journal.php?journalid=$journal[journalid]&action=addcomments" method="post" onSubmit="return validate(this)">

This is the form code in the journal_commentnewbit template

<input type="hidden" name="userid" value="$userid" border="0"><input type="hidden" name="journalid" value="$journalid" border="0"><input type="hidden" name="s" value="journal.php?s=$session[sessionhash]&journalid=$journal[journalid]&action=view" border="0"><input class="bginput" type="submit" name="submit_add_comment" value="Add Comment" tabindex="7" accesskey="s" border="0">

What do I have wrong? Yes I did edit it to try to fix it, but no use.

EDIT II: Nevermind, fixed it, I just deleted the templates and reinstalled just the template section. Turned out to be one stupid thing that was missing. >_>;

EDIT III: Working very very very well now, no probs as of yet this time. ^^;

EDIT IV: Just thought of this, (so many EDITs, huh? o.O; ). Is there a way to add attachments to entries? I'd really like that add-on.

[reismarktq2]

Originally Posted by memobug

Not sure exactly what you mean. I can see a few useful possibilities, though:

1) Do you want a new table that is something like

Journals with the most Comments
TreeBay's Journal 19 Comments
Lesley's Journal 8 Comments
LivingArt's Journal 3 Comments
BonsaiMon's Journal 2 Comments
pdbbonsai's Journal 2 Comments
waltseed's Journal 2 Comments
buzzy's Journal 1 Comments


2) Do you want a new table that is something like:

Most Recent Comments
2-Oct-2003 07:00 AM | By TreeBay in waltseed's Journal
29-Sep-2003 07:06 PM | By Lesley in BonsaiMon's Journal
23-Sep-2003 10:37 PM | By Lesley in LivingArt's Journal
22-Sep-2003 07:25 PM | By LivingArt in buzzy's Journal
19-Sep-2003 09:02 PM | By TreeBay in Lesley's Journal

or
3) Maybe you want to display the number of comments next to the number of entries in the existing tables without adding tables?

Regards,

Matt

Matt: I'd like Door Number 3 on this one, PLEASE, ASAP.

[sabret00the]

do you mean like they have over at www.bluelight.nu?