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

[afterlab]

In full agreement, Gamingforce. I was going to back you up before you commented, but I was unsure if this was unjust to you. Anyways, thanks for the hack, i'll be installing on my forums some time this week.

[Riddel]

It worked!!! thank you so very much!

[Velocd]

Originally posted by Gamingforce
Good deal, at least you could give credit to my journal which you very closely modeled it after: http://www.gamingforce.com/forums/journal.php

Lol, I thought there was some close comparison in the appearance of both journal systems. It's not an incredibly huge deal though, as long as it's not code manipulated.

[Kaelon]

Great work! Several issues:

1. I noticed that on the Journal Stats block, only a custom avatar appears and not one of the standard avatars. Is there any way to ensure that the avatar is displayed?

2. Users that have apostrophe's (e.g., "Mari'a") or other special characters are unable to add journals. The specific error:

Database error in vBulletin 2.2.7:

Invalid SQL: INSERT into journal (journalid, title, entries, views, enabled, timestamp, userid) values (2633, 'Tantic Bry Try'Kar\'s Journal', 0, 0, 1, '1032551764', 2633)
mysql error:

mysql error number: 0

Date: Friday 20th of September 2002 03:56:04 PM
Script: http://www.....com/forums/forums/jou...=createjournal
Referer: http://www.....com/forums/journal.php?s=

You can fix this by finding the following line in journal.php:

$username = $username_retrieve['username'];

And adding right beneath it:

$username = addslashes($username);

Hope this helps! Great hack, again!

[Chris M]

My Journal

Brilliant work m8

Satan

[Koss]

If I wanted to add this to different styles do I have to do it manually ?/
thanks

[Chris M]

No...

Just edit install_journal.php, and find :

PHP Code:

        $DB_site->query("INSERT INTO template (templateid, title, template, templatesetid) VALUES (NULL,'$key','".addslashes($val)."',1)"); 


Just change that "1" at the end of the line, to the templatesetid of the other style, and upload it...Then just do the first step, and delete the file after that...

Satan

[Koss]

Originally posted by hellsatan
No...

Just edit install_journal.php, and find :

PHP Code:

        $DB_site->query("INSERT INTO template (templateid, title, template, templatesetid) VALUES (NULL,'$key','".addslashes($val)."',1)"); 


Just change that "1" at the end of the line, to the templatesetid of the other style, and upload it...Then just do the first step, and delete the file after that...

Satan

you rule! thanks man :bunny:

[Koss]

ok I changed the file but it screws up on step 3 and I get this error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: CREATE TABLE journal (
journalid int(11) NOT NULL auto_increment,
title text NOT NULL,
description text NOT NULL,
imagename text NOT NULL,
entries int(11) NOT NULL default '0',
views int(11) NOT NULL default '0',
enabled smallint(6) default '0',
timestamp int(11) NOT NULL default '0',
userid int(11) NOT NULL default '0',
PRIMARY KEY(journalid)) TYPE=MyISAM;
mysql error: Table 'journal' already exists

mysql error number: 1050

Date: Friday 20th of September 2002 03:00:46 PM
Script: http://www.mysite.com/forums/forums/...nal.php?step=3
Referer: http://www.mysite.com/forums/admin/i...nal.php?step=2

im not sure whats wrong :surprised:

[Kaelon]

I'm having another problem...

When users go to add an entry to their account, they see on the breadcrumb up top a link to my standard account's Journal, not their journal.

E.g., instead of it saying

Forums > Journal > User's Journal > Add a New Entry

It says

Forums > Journal > My Standard Account's Journal > Add a New Entry

I was able to remove this issue from the template, and when you go to "edit" an entry, the breadcrumb displays properly with links.

Apparently, this is a problem happening on all installations and journals, including your demo one. Is there a way to possibly fix this? Thanks!

Regards,
Kaelon