The Arcive of Official vBulletin Modifications Site.

vB Journal for vBulletin 3.0.3(v1.0.1) · **Released**: 09-16-2004

vB Journal v1.0.1
By Antonbomb22(Anthony Scudese)

vB Journal 1.5 Beta 1 is now available, click here.

Features:

Full vBulletin 3.0.3 intergration
Install file for SQL queries
Comment System
"GoToMyJournal"
link from postbit to journal
link from profile to journal
link from memberlist to journal
usergroup permissions
journal buddy system(by Wonko)
Journal Search Engine
journal highlight
bbcode parsing
smilie parsing
Admin Cp Support Section
Journal Status Icons
Who is viewing
most recent journal entries and journals
Who Can View for journals and entries
Complete journal and entry privacy
Comment on entries or journals
Journal Moderation(Like Post and Thread Moderation)
Entry Moderation(Like Post and Thread Moderation)
Pagination
Rating System
Lock System
Moods
"Can Have Journal" on a per user basis
Ip Logging
Journalists can name their journals
Export entries in TXT or XML format
Flood System
Administrators have absolute permissions
Search in Journal
Last Entry on Journal Index
Numerous AdminCp Settings
Unique Standard vB Images for vB Journal
View Single Entry
and so much more...

Version 1.0.1:

Many parts of vB Journal 1.0.0 were rewritten to cap security holes lurking within the code.

Features for later versions:

journalists can specify colors for their journal
attachments
subscriptions
journal moderators
report system
more administration options
complete phrasing

Demos:

Add-Ons(I Will not give support for these because i did not create them):

Side Credits:

Journal Buddy System ~ WonkotheSane
Closed Beta Tester ~ Pitman
Closed Beta Tester ~ DantX
Helpful Person ~ Oblivion Knight

And to all those who helped me find my mistakes and encourage me

Notes:

The WOL(Who's Online) is not yet finished but will be released shortly due to some bugs and flaws
You may not remove the copyright notice!
An import script for Ryangle's ported Journal will be made so dont install this hack for now if you have the vb3 port of Ryangle's

Support:
~READ FIRST POST COMPLETELY BEFORE POSTING PROBLEMS AND MAKE SURE YOU DID ALL EDITS AND REQUIREMENTS!~

Support may be denied if provided files are edited/modified and support may be stopped at any time due to any circumstances.

If you should run into any errors, problems, confusion, or maybe even a suggestion please
foward them to one of the following places:

Official vB Journal Support&Suggestion Forum
AIM: Antonbomb22
Email: antonbomb22@animationation.net
Or this thread

Contents of Zip:

install.txt
journal.php
journaladmin.php
journalinstall.php
images

I have also provided several screenshots

Please click install

If you are missing phrases or blank spaces in the usergroup manager click here.

Updates/Fixes:

Updated zip and journalinstall.php due to a typo(click here for fix:https://vborg.vbsupport.ru/showpost....9&postcount=11)
fixed a missing " in install.txt, it doesnt cause an error but its a fix (Click here for fix: https://vborg.vbsupport.ru/showpost....8&postcount=16)
updated zip and journal.php, fixed sql queries that caused problems(Click here for fix: https://vborg.vbsupport.ru/showpost....4&postcount=25)
fixed a type in journal.php, zip and file updated(Click here for fix:https://vborg.vbsupport.ru/showpost....4&postcount=31)
updated zip,updated journalinstall.php, and uploaded phrasefix.php to fix the usergroup phrase problem(click here for fix: https://vborg.vbsupport.ru/showpost....9&postcount=36)(09/16/04)
for those who may be experiencing problems due to conflicts with the articles hack follow these following changes: https://vborg.vbsupport.ru/showpost....&postcount=114(09/18/04)
for those experiencing blanks or missing descriptions for usergroup permissions use this fix until further notice(for /admincp/usergroup.php): https://vborg.vbsupport.ru/showpost....8&postcount=56(09/18/04)
updated zip and journal.php for more compatiability with vb and more likeness with vb (use the following fix: https://vborg.vbsupport.ru/showpost....&postcount=120)(09/18/04)
updated zip and install.txt due to a mistake in functions.php file edit(use the following fix: https://vborg.vbsupport.ru/showpost....&postcount=122)(09/18/04)
updated zip and journaladmin.php for moderate entries due to an sql error(use this fix: https://vborg.vbsupport.ru/showpost....&postcount=130)(09/19/04)
updated zip and journal.php for beefed up privacy in journals and their entries(use this fix: https://vborg.vbsupport.ru/showpost....&postcount=292)(10/04/04)
update zip and journal.php, this fix fixes the permission troubles and mood problems occuring( https://vborg.vbsupport.ru/showpost....&postcount=391)(10/23/04)
updated zip and journal.php, this fix will provide a new update system which hopefully weeds out any potential problems!(https://vborg.vbsupport.ru/showpost....&postcount=574)(11/17/04)
updated zip and journal.php, fixing some guest loop holes(https://vborg.vbsupport.ru/showpost....&postcount=645)(12/13/04)
updated zip and journal.php, fixes possible sql injection problem(https://vborg.vbsupport.ru/showpost....&postcount=902)(3/12/05)
updated zip and journal.php, fixes LEFT JOIN typo(https://vborg.vbsupport.ru/showpost....&postcount=948)(3/23/05)
vB Journal Upgraded to v.1.0.1 with many security holes patched.(7/1/05)
Security Update: a XSS vulnerability was found within journal.php, to patch this see this post, the zip has been updated as well.(9/23/05)

AN-net · #**1112** 05-01-2005, 12:38 PM

ylp 819 is a free result which should not cause an error, have you modified the file?

Paul M · #**1113** 05-01-2005, 01:15 PM

Quote:

Originally Posted by YLP1

Hi Paul M

I attached my Journal page because what appears to be line 819 to me could be something else based on monitor rez.

Line 819 in that file is this ;

PHP Code:


			
$jbuddies= explode(' ', $jpermissions['jbuddylist']);

Which makes no sense as far as that error is concerned - are you sure this is the actual journal.php you are using ?

AN-net · #**1114** 05-01-2005, 01:19 PM

he most have added something cause that is not line 819 in my default file on my comp>_>

T3MEDIA · #**1115** 05-01-2005, 06:09 PM

Quote:

Originally Posted by AN-net

he most have added something cause that is not line 819 in my default file on my comp>_>

Ok... last request ignored... nevermind...
Hey AN-net or ANYONE that knows... is there a way or workaround to have at least admins be able to delete comments?
I have on user that posted into his own comments. I cant even delete it.

Thanks to anyone that helps.

Paul M · #**1116** 05-01-2005, 06:13 PM

Admins can delete comments on my system - do you have the correct permissions set ?

YLP1 · #**1117** 05-01-2005, 08:40 PM

Quote:

Originally Posted by Paul M

Line 819 in that file is this ;

PHP Code:


			
$jbuddies= explode(' ', $jpermissions['jbuddylist']);

Which makes no sense as far as that error is concerned - are you sure this is the actual journal.php you are using ?

This journal is the exact journal file from a fresh download of the mod. The only alteration was the delete user avatar fix.

Edited to add:

I just compared the journal.php from a current mod d/l against what I had on the server.

There are many differences between the two. I have no idea what version the the journal.php I was using but for some reason the fresh upload of the journal.php didn't take.

I have uploaded for sure the latest avialable journal.php and am checking to see if I get the same line errors.

I still have the problem of putting back the journal data from backup in to the current db.

I swear I have a thousand gray hairs over this error and now compounded by the uninstall and reinstall and losing the journal data from current db.

I can tell ya that we women don't like gray hair!!!! LOL LOL

I will test and see if the error occurs again. Any quick and easy way to put my journal data back into the db?

Thanks in advance.

PixelFx · #**1118** 05-01-2005, 10:55 PM

is it possible to get an update for the journal system for v3.0.7 or is it stable enough to install as is? I've been wanting to put this on my production forum but wonder how stable this is with the version number saying 3.0.3 ...

Polo · #**1119** 05-01-2005, 11:02 PM

I use this on vbulletin 3.0.7 and it works great.

T3MEDIA · #**1120** 05-02-2005, 03:13 PM

Quote:

Originally Posted by PixelFx

is it possible to get an update for the journal system for v3.0.7 or is it stable enough to install as is? I've been wanting to put this on my production forum but wonder how stable this is with the version number saying 3.0.3 ...

It works but there is no way to delete comments.
In other words I can go on your blog and say you suck eggs for dinner and it will stay there forever.

Besides that... its cool.

Paul M · #**1121** 05-02-2005, 03:47 PM

Quote:

Originally Posted by T3MEDIA

It works but there is no way to delete comments.

I'm curious, how many times do you need telling that an administrator can delete comments before it actually sinks in ?

T3MEDIA · #**1122** 05-02-2005, 04:23 PM

I guess when it actually works.

Paul M · #**1123** 05-02-2005, 05:01 PM

Quote:

Originally Posted by T3MEDIA

I guess when it actually works.

It works fine as you have previously been told a number of times - are you actually an administrator on your site (as your primary usergroup) ?

PixelFx · #**1124** 05-02-2005, 07:43 PM

Thanks for Reply Paul ..

ok for the most part got this working on 3.0.7

question: I'm having a brain fart, what do I need to add to show whos online when someone is viewing the journal system on my site, rather than it giving an ugly url..?

YLP1 · #**1125** 05-03-2005, 05:43 PM

I think I may have found what is causing this error. BUT I am not that familiar with PHP or VB so I have to rely on you php/vb gurus to help a girl out on this.

Here are the DB errors I receive from several vb pages:

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: 
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM vb3_user AS user
LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5

mysql error number: 1064

Date: Sunday 01st of May 2005 09:39:30 PM
Script: http://www.yourlincolnpark.com/lpsforum/lpsforum.php
Referer: http://yourlincolnpark.com/lpsforum/index.php


Error occurs on these pages as well:

Date: Monday 02nd of May 2005 04:33:37 PM
Script: http://www.yourlincolnpark.com/lpsforum/lpsforum.php
Referer: http://www.yourlincolnpark.com/LPSForum/private.php?

mysql error number: 1064

Date: Sunday 01st of May 2005 09:37:57 PM
Script: http://www.yourlincolnpark.com/lpsforum/lpsforum.php
Referer: 

mysql error number: 1064

Date: Friday 29th of April 2005 01:20:16 PM
Script: http://www.yourlincolnpark.com/LPSForum/lpsforum.php
Referer: http://www.yourlincolnpark.com/LPSForum/showthread.php?t=5206

mysql error number: 1064

Date: Friday 29th of April 2005 06:41:57 PM
Script: http://www.yourlincolnpark.com/LPSForum/lpsforum.php
Referer: http://www.yourlincolnpark.com/LPSForum/search.php?searchid=

mysql error number: 1064

Date: Saturday 30th of April 2005 01:05:47 AM
Script: http://www.yourlincolnpark.com/LPSForum/lpsforum.php
Referer: http://www.yourlincolnpark.com/LPSForum/forumdisplay.php?f=22

After many hours or researching the error code and all vb sites this is what I found:

In showthead.php the journal code looks like below. However, this is something that I did not add so I am thinking the install script installed this??? The journal instructions indicate that this:
should be added to the memberlist.php which I did do.

Notice the word "journal" that was added (again by the Install script as I did not add this to my showthread.php file)

Code:

LEFT JOIN " . TABLE_PREFIX . "journals AS journal ON(journal.journalist_id = user.userid)

The instructions for the Journal say to add the below code to the Memberlist.php file:

Code:

LEFT JOIN " . TABLE_PREFIX . "journals AS journals ON(journals.journalist_id=user.userid)

Notice that the word "journal" in this code is journals (plural).

Since I am very new to PHP and VB, is this plural word of journal causing the error as indicated above?

If it isn't that ...can someone help me fix this error as I have tried everything.

U have attached my showthread file (I hope this is ok to do) in hopes that someone can help me fix this issue.

Thanks in advance.
Robin

Paul M · #**1126** 05-03-2005, 07:08 PM

The install script does not (cannot) make file edits, you must have. I suggest you re-edit it to what the instructions say.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10686 seconds Memory Usage 2,392KB Queries Executed 31 (?)
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 (3)bbcode_code (2)bbcode_php (6)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 (4)pagenav_pagelink (3)pagenav_pagelinkrel (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)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!