The Arcive of Official vBulletin Modifications Site.

vBJournal Lite 1.1b · **Released**: 09-18-2002

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

Ryangel · #42 09-20-2002, 06:14 AM

Quote:

Originally posted by Riddel
http://www.zanarkand.net/metropolis/journal.php

here. hmm it is a strange error. i think I installed everything correctly

hmm curious. I did try to add a new entry with a new user and that worked. hmmm

omegauk · #43 09-20-2002, 07:42 AM

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.

Hey I am stuck in step 7, I went to journal.php but dont see any button, is blank

indiamike · #44 09-20-2002, 08:34 AM

Quote:

Originally posted by Ryangel

ahhh i think i got it... goto those files again and in the first <tr ...
remove the id="cat" that should do the trick. I'll update the files now...

Sweet...that worked perfect.

Mike

Ryangel · #45 09-20-2002, 10:20 AM

Quote:

Originally posted by omegauk
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.

Hey I am stuck in step 7, I went to journal.php but dont see any button, is blank

did you upload the images?

omegauk · #46 09-20-2002, 10:23 AM

Its fixed now, I forgot to enter the templates.

Riddel · #47 09-20-2002, 01:42 PM

@Ryangel, hmm how strange, no matter what account I try it on, member account or admin account, it still gives me a 404 error page?

Ryangel · #48 09-20-2002, 02:55 PM

Quote:

Originally posted by Riddel
@Ryangel, hmm how strange, no matter what account I try it on, member account or admin account, it still gives me a 404 error page?

for example, my dummy account Danny, password - labrat.

curious .... as you can see in your journal. I've added 2 entries before. I just tried again but i got that 404 error you mentioned. atm i have no idea why this would happen. Maybe if anyone else installed this have the same problem?

Ryangel · #49 09-20-2002, 03:02 PM

hmmm, ok this might be the problem.
I looked at the source of the add entry page and found that your form points to /journal.php?journalid=2&... while mine shows the full url
I've used $bburl in this line. maybe it doesnt work for you ? try replacing the /journal.php with http://www.zanarkand.net/metropolis/journal.php ?

I'm just taking a wild guess here.

Kaelon · #50 09-20-2002, 04:09 PM

This looks great!

Is there any way that you can modify the "View All Entries" display to be multi-paged, for those users that will have hundreds of entries? Thanks!

Kaelon

Gamingforce · #51 09-20-2002, 04:45 PM

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

afterlab · #52 09-20-2002, 05:04 PM

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 · #53 09-20-2002, 06:12 PM

It worked!!! thank you so very much!

Velocd · #54 09-20-2002, 06:21 PM

Quote:

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 · #55 09-20-2002, 07:29 PM

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:

Quote:

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:

Code:

$username = $username_retrieve['username'];

And adding right beneath it:

Code:

$username = addslashes($username);

Hope this helps! Great hack, again!

Chris M · #56 09-20-2002, 08:13 PM

My Journal

Brilliant work m8

Satan

Koss · #57 09-20-2002, 08:31 PM

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

Chris M · #58 09-20-2002, 08:41 PM

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 · #59 09-20-2002, 08:52 PM

Quote:

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 · #60 09-20-2002, 09:03 PM

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

Quote:

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 · #61 09-20-2002, 09:31 PM

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

Koss · #62 09-20-2002, 09:33 PM

for some reason the script points to

Quote:

http://www.mysite.com/forums/forums/admin/install_journal.php?step=3

when it should be:

Quote:

http://www.mysite.com/forums/admin/install_journal.php?step=3

Chris M · #63 09-20-2002, 09:47 PM

@Koss - I said to stop after adding the templates

Thats why you get the errors...

Satan

Riddel · #64 09-20-2002, 09:47 PM

Koss, are you using a journal system already? that error says that the journal table is already taken up by something. Just delete what you have there and you should be okay

afterlab · #65 09-20-2002, 11:28 PM

Does this hack block HTML out from journal entries when submitting and modifying them?

Kaelon · #66 09-21-2002, 12:20 AM

afterlab - from what I can tell, yes.

Any thoughts on the above problems I mentioned?

Kaelon

Ryangel · #67 09-21-2002, 12:42 AM

Quote:

Originally posted by Kaelon
This looks great!

Is there any way that you can modify the "View All Entries" display to be multi-paged, for those users that will have hundreds of entries? Thanks!

Kaelon

ahhhh if you look carafeully into the journal.php code , you'll see alot of commented code of this. I came across a huge bug and i didnt want to spend too much time on it having time constriants.
Will add that it the future though.

Koss · #68 09-21-2002, 12:51 AM

crap I read this too late.....anyhow thanks for your help guys
everything works fine, but I had to add 37x4 templates manually *me tired* :/

Ryangel · #69 09-21-2002, 01:01 AM

Quote:

Originally posted by 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

hmm, I'm working on this now. Wonder why no one on my board has told me about it ...

Ryangel · #70 09-21-2002, 01:11 AM

Quote:

Originally posted by 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

ok got it fixed.

open journal.php

find

PHP Code:


			
$journal = $DB_site->query_first("SELECT u.username, u.userid, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views   

                                FROM journal j

                                LEFT JOIN user u ON j.userid = u.userid

                                AND j.journalid = $journalid");

which is within
/* Journal Add Entry Page */

and change the AND to WHERE or just replace the above with this

PHP Code:


			
$journal = $DB_site->query_first("SELECT u.username, u.userid, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views   

                                FROM journal j

                                LEFT JOIN user u ON j.userid = u.userid

                                WHERE j.journalid = $journalid");

Elanor · #71 09-21-2002, 01:12 AM

Nice addon. I'd like to add the link to the personal journal on my VBIndex (which is outside the forums root). How can I do this?

Ryangel · #72 09-21-2002, 01:18 AM

Quote:

Originally posted by 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?

Working on this now

Quote:

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

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

Code:

$username = $username_retrieve['username'];

And adding right beneath it:

Code:

$username = addslashes($username);

Hope this helps! Great hack, again!

Thanks!

Ryangel · #73 09-21-2002, 01:41 AM

updated journal.php ver1.1b

Ryangel · #74 09-21-2002, 01:47 AM

Quote:

Originally posted by 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?

hmm i cant quite seem to get this to work atm...
not familiar with the avatar code. If anyone knows where to look or can help. It'll be much appreciated

Ryangel · #75 09-21-2002, 01:53 AM

Quote:

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

Done! its in the readme.

Keta · #76 09-21-2002, 04:48 AM

ok i just had a thought how about adding on a buddy list to the journal? so the writer can set their journal to buddy list only...

amsch · #77 09-21-2002, 12:53 PM

I am not getting anything when I go to, this page.
http://20ishparents.com/boards/journal.php

amsch · #78 09-21-2002, 01:13 PM

Ok, I figured out my problems. The install said it installed the templates but didn't. Did it manually at worked great!

amsch · #79 09-21-2002, 01:17 PM

Some suggestions. And maybe some of these things are already in there.

Journal Catagories. I run a parenting community and they like different types of journals. Weight loss, pregnancy ect.

Only certain usergroups able to create journals. (if anyone knows how to do this, I would be forever greatfull!)

ability to view all journals vs the top. I only have one created so now quite sure how this works yet.

Also, journal link in their profile.

That is about all I can think of right now.

amsch · #80 09-21-2002, 01:25 PM

Ok, I noticed it also does not increase post counts. It would be nice to increase board counts and member counts.

Kaelon · #81 09-21-2002, 03:29 PM

Thanks for your work, Ryangel. This is great stuff you've done here!

As I see it, the only pressing issues that really remain, in order of priority:

1. Having multiple pages for the "View All Entries" display, so as to make things legible. Unfortunately, I'm not really sure where to start with this one.

2. Getting all avatars, not just custom ones, to work. I have some experience fooling around with avatars in custom scripts, so I'll give this a try and see what I can do - if anything. I'll let you know what I can do.

Thanks again for this great hack!

Regards,
Kaelon

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08783 seconds Memory Usage 2,649KB Queries Executed 55 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_code (4)bbcode_php (17)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (41)post_thanks_box (41)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (41)post_thanks_postbit_info (40)postbit (41)postbit_onlinestatus (41)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!