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]

Does anyone know if the page linking has been added yet?
Just noticed that afterlab has this feature working here.. Is this his own journal system or is he using this one?

I'd love to have a journal system running at Umbrella Online, but for me there seem to be a few bugs and features missing with this version from reading other people's posts.. I could be wrong..

[sabret00the]

Originally posted by ChurchMedia
Fantastic hack! Just what I was looking for. Is there a way to let users include html or VB code in their entries?

my users all have the ability to use vBcode, dunno about html tho'

[Jitway]

Never could get the installer to make the changes in the database. Too bad too! :hurt:

[sabret00the]

any news on the follow up version with the additional features like

+ mood
+ listening too
+ smilie box on add entry & add reply

[Zelda-King]

OK, I installed it on vB 2.2.9.

1) There should be an option to delete one's own journal, and also for an administrator to delete journals. If I delete users their journals are still on record and naturally you get a database error when you click on a deleted user's journal.

2) As has been said (and as I know Gamingforce has on his forums), there should be a profile link to the user's journal with a different message if they have no journal.

3) What's the deal with private entries? I assume that's so only people on your buddy list can view the entry (like at Gamingforce) but none of my buddies can read my private entries.

I'll also recap on what else is initially needed;

- 'Maximum replies per page' setting.
- Admins should be able to edit/delete replies (just in case the system gets abused).
- Word wrap is needed. If someone puts a load of ........... s with no spaces it should automatically wrap at so many characters so the tables aren't broken (a solution has been discussed for this but it needs incorporating in the hack).

Those are the 'musts' in my opinion. Now a suggestion.

Personally I would like at least an option so guests can't even VIEW journals unless the usergroup is manually permitted (I wouldn't want banned people seeing journals).

On top of that, outstanding work!

[limey]

<font color="red">Installed...</font>

Quick question...

I would like to make the comments linkable the same as the discuss button. Its just confusing for people to view comments by clicking the discuss button. Essentially its the same thing, but just for UI purposes.

How would do I do that?

thanks!

[Zelda-King]

Originally posted by Elvis




Well, I just verified that the file I uploaded is exactly like the one I currently have in use - it is.

Also... from the error, it looks as though you may be missing a line of an SQL statement - did you edit this file AT ALL?

and finally, I dont understand how you could be requesting a wrong URL, every instance of the goto starts like:

$goto="journal.php?s=

it's referring to itself - there are no directory changes at all.

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:

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

Originally posted by ChurchMedia


Here's how to do this:

In memberlist.php find:

if ($userinfo[receivepm]) {
      eval("\$userinfo[pmlink] = \"".gettemplate("postbit_sendpm")."\";");
    } else {
      $userinfo[pmlink] = " ";
    }

and add after:

// 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 End

In memberlist template, find

<td bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" colspan=

Your columnspan needs to be increased by one, so if it's 7, make it 8.

In same template, find:

</tr>
$memberlistbits

Beneath that add:

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

In the memberlistbit template find:

</tr>

Right above that add:

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

That should do it

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.

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

Now, I'm trying to put a journal link in user profiles. Now where in the member.php would I insert

// 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 = '';
	}

?

I stuck it under

  $referrals = $refcount[count];
    eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");
  } else {
		$referrals = '';
	}

but when I put $journal in the 'getinfo' template it takes no notice if someone has a journal. For example, if I put something like

 // 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 = 'No journal enabled';
	}

in member.php, their profile shows 'No journal enabled' regardless in spite of the same hack working in admin/functions.php and memberlist.php.

[sabret00the]

Originally posted by limey
Installed...

Quick question...

I would like to make the comments linkable the same as the discuss button. Its just confusing for people to view comments by clicking the discuss button. Essentially its the same thing, but just for UI purposes.

How would do I do that?

thanks!

edit the template 0_o

[limey]

The correct template is journal_entrybits

Basically copied the discuss link and wrapped it around the "comments" in the template.

[Robink]

Installed!! My USERS Love this Hack!!

Thanks!! No problems whatsoever!