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)

Lionel · #**887** 03-09-2005, 02:53 PM

Can someone please tell me what is wrong with the below? That module is causing an unclosed tag at the bottom of the page </html and when you click on any link in front page, it sometimes takes you to a blank page with only the rest of the tag > at the top

PHP Code:


			
 $getlateste= $DB_site->query(" 
            SELECT journal_entries.entrytitle,journal_entries.entrydate, 
            journal_entries.entry_id,journal_entries.entrytext, 
            journal_entries.journal_id,journals.journalist,journals.journalist_id 
            FROM ".TABLE_PREFIX."journal_entries AS journal_entries 
            LEFT JOIN ".TABLE_PREFIX."journals AS journals ON (journal_entries.journal_id=journals.journal_id) 
            WHERE journal_entries.entry_active=1 AND journal_entries.private!=1 AND journals.private!=1 
            ORDER BY journal_entries.entrydate DESC 
            LIMIT 5 
            "); 
            $countlatest= $DB_site->num_rows($getlateste); 
            $latestentrybits = ""; 
            if($countlatest>0) 
            { 
                while($latest= $DB_site->fetch_array($getlateste)) 
                { 
                    $latestentrydate= vbdate($vboptions['dateformat'], $latest['entrydate'], 1); 
                    $latestentrytime= vbdate($vboptions['timeformat'], $latest['entrydate']); 
                    exec_switch_bg(); 
                    if(strlen($latest[entrytitle])>20) 
                    { 
                        $latest[entrytitle]= "".substr($latest[entrytitle],0,20)."..."; 
                    } 
                    if(strlen($latest[entrytext])>150) 
                    { 
                        $latest[entrytext]= "".substr($latest[entrytext],0,150)."..."; 
                    } 
                    eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";'); 
                } 
                $DB_site->free_result($latest); 
            } 
            else 
            { 
                $latestentrybits=$vbphrase['adv_no_entries']; 
            } 
 
    eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('adv_portal_latestjournalentry') . '";'); 
unset($latestentrybits,$latest,$latestentrytime,$latestentrydate,$countlatest);

Reeve of shinra · #**888** 03-10-2005, 03:05 AM

Tried the importer that was posted a few pages back and ran into some problems with it which Wonko the Sane corrected and you will find reflected in the attached file.

1. Run this query in php my admin to rename your original ryangel journal tables so we still have them in case something goes wrong. If your using a table prefix, you'll need to add that to the query below.

PHP Code:


			
ALTER TABLE journal RENAME old_journal;

ALTER TABLE journal_comments RENAME old_journal_comments;

ALTER TABLE journal_entry RENAME old_journal_entry;

2. Upload file in admincp and run it. It's already set to use the "old_" prefix we set above.

Thanks to nsanden who made the importer in the first place.

#**889** 03-10-2005, 04:03 AM

Quote:

Originally Posted by Lionel

Can someone please tell me what is wrong with the below? That module is causing an unclosed tag at the bottom of the page </html and when you click on any link in front page, it sometimes takes you to a blank page with only the rest of the tag > at the top

PHP Code:


			
 $getlateste= $DB_site->query(" 

            SELECT journal_entries.entrytitle,journal_entries.entrydate, 

            journal_entries.entry_id,journal_entries.entrytext, 

            journal_entries.journal_id,journals.journalist,journals.journalist_id 

            FROM ".TABLE_PREFIX."journal_entries AS journal_entries 

            LEFT JOIN ".TABLE_PREFIX."journals AS journals ON (journal_entries.journal_id=journals.journal_id) 

            WHERE journal_entries.entry_active=1 AND journal_entries.private!=1 AND journals.private!=1 

            ORDER BY journal_entries.entrydate DESC 

            LIMIT 5 

            "); 

            $countlatest= $DB_site->num_rows($getlateste); 

            $latestentrybits = ""; 

            if($countlatest>0) 

            { 

                while($latest= $DB_site->fetch_array($getlateste)) 

                { 

                    $latestentrydate= vbdate($vboptions['dateformat'], $latest['entrydate'], 1); 

                    $latestentrytime= vbdate($vboptions['timeformat'], $latest['entrydate']); 

                    exec_switch_bg(); 

                    if(strlen($latest[entrytitle])>20) 

                    { 

                        $latest[entrytitle]= "".substr($latest[entrytitle],0,20)."..."; 

                    } 

                    if(strlen($latest[entrytext])>150) 

                    { 

                        $latest[entrytext]= "".substr($latest[entrytext],0,150)."..."; 

                    } 

                    eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";'); 

                } 

                $DB_site->free_result($latest); 

            } 

            else 

            { 

                $latestentrybits=$vbphrase['adv_no_entries']; 

            } 

 

    eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('adv_portal_latestjournalentry') . '";'); 

unset($latestentrybits,$latest,$latestentrytime,$latestentrydate,$countlatest);

It's the template we need, not the php file.

Omega Prime · #**890** 03-11-2005, 01:05 AM

Quote:

Originally Posted by Reeve of shinra

Tried the importer that was posted a few pages back and ran into some problems with it which Wonko the Sane corrected and you will find reflected in the attached file.

1. Run this query in php my admin to rename your original ryangel journal tables so we still have them in case something goes wrong. If your using a table prefix, you'll need to add that to the query below.

PHP Code:


			
ALTER TABLE journal RENAME old_journal;

ALTER TABLE journal_comments RENAME old_journal_comments;

ALTER TABLE journal_entry RENAME old_journal_entry;

2. Upload file in admincp and run it. It's already set to use the "old_" prefix we set above.

Thanks to nsanden who made the importer in the first place.

I tried it out, but here's what happens:

I ran step one with no problem. For step 2, I ran the script and it shows "--Finished" with no errors. But... doesn't the script supposed to make new tables such as "journal_entries", etc? I don't use any prefix for my journal, and I didn't alter the script you provided, so I'm not sure if I'm missing anything

Reeve of shinra · #**891** 03-11-2005, 01:20 AM

I should edit those instructions. Rename the tables using the query I gave, use the journal installer from this hack, then use the importer.

Edit: in your case, install the journal as you would on a clean install, then run the importer again.

Omega Prime · #**892** 03-11-2005, 10:59 AM

Quote:

Originally Posted by Reeve of shinra

I should edit those instructions. Rename the tables using the query I gave, use the journal installer from this hack, then use the importer.

Edit: in your case, install the journal as you would on a clean install, then run the importer again.

Thanks! After installing (and having a few problems along the way), I installed it and can currently view the entries. Just a few problems remain:

1. When installing, I saw this:

Code:

Invalid SQL: INSERT INTO phrase (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'journalmodulenotactive', 'The journal module has been deactivated.', 1000)
mysql error: Duplicate entry 'journalmodulenotactive-0-1000' for key 2

I assume it's probably because of the previous journal setup, so I dunno if you (or AN, or anyone else) could perhaps find a way to either install the missing phrases or make a phrase-uninstall script so I can try this again.

2. While it did import the entries and such, certain words like "I've" appear as "I/'ve" and whatnot, so I'm not sure if there's a way to fix this (other than editing each entry)

Thanks in advance for anyone's help

AN-net · #**893** 03-11-2005, 04:59 PM

Quote:

Originally Posted by Omega Prime

Thanks! After installing (and having a few problems along the way), I installed it and can currently view the entries. Just a few problems remain:

1. When installing, I saw this:

Code:

Invalid SQL: INSERT INTO phrase (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'journalmodulenotactive', 'The journal module has been deactivated.', 1000)
mysql error: Duplicate entry 'journalmodulenotactive-0-1000' for key 2

I assume it's probably because of the previous journal setup, so I dunno if you (or AN, or anyone else) could perhaps find a way to either install the missing phrases or make a phrase-uninstall script so I can try this again.

2. While it did import the entries and such, certain words like "I've" appear as "I/'ve" and whatnot, so I'm not sure if there's a way to fix this (other than editing each entry)

Thanks in advance for anyone's help

you must uninstall the phrases and then reinstall them

boysmom · #**894** 03-11-2005, 07:28 PM

Is there a way to turn off or remove the ratings feature?

Thanks!

AN-net · #**895** 03-11-2005, 07:39 PM

you can set permissions for can rate journals to no foreveryone and then no one can rate journals

boysmom · #**896** 03-11-2005, 08:29 PM

Thanks AN-net - that was so simple that it went by me! LOL.

Thanks again.
Mari

T3MEDIA · #**897** 03-12-2005, 11:13 AM

Quote:

Originally Posted by T3MEDIA

would some one be so kind to make a cron job to delete users no longer on the site? I have too many users and too many have journals.
thanks.

bump just in case...

AN-net · #**898** 03-12-2005, 01:23 PM

Ok this update will fix a possible Sql injection problem and all are encouraged to upgrade!!

To fix this flaw without overwriting find this line in journal.php:

PHP Code:


			
                $DB_site->query("UPDATE ".TABLE_PREFIX."journals 

                SET lastentry='".$lastentry['entrytitle']."', entrycount=entrycount-1, lastentry_date='".$lastentry['entrydate']."', 

                lastentry_id='".$lastentry['entry_id']."' 

                WHERE journal_id='".$j."'

                ");

replace that with:

PHP Code:


			
                $DB_site->query("UPDATE ".TABLE_PREFIX."journals 

                SET lastentry='".addslashes($lastentry['entrytitle'])."', entrycount=entrycount-1, lastentry_date='".$lastentry['entrydate']."', 

                lastentry_id='".$lastentry['entry_id']."' 

                WHERE journal_id='".$j."'

                ");

I will update the zip shortly. I have also attached an updated journal.php

Blootix · #**899** 03-12-2005, 11:51 PM

Quote:

Originally Posted by AN-net

Ok this update will fix a possible Sql injection problem and all are encouraged to upgrade!!

To fix this flaw without overwriting find this line in journal.php:

PHP Code:


			
                $DB_site->query("UPDATE ".TABLE_PREFIX."journals 

                SET lastentry='".$lastentry['entrytitle']."', entrycount=entrycount-1, lastentry_date='".$lastentry['entrydate']."', 

                lastentry_id='".$lastentry['entry_id']."' 

                WHERE journal_id='".$j."'

                ");

replace that with:

PHP Code:


			
                $DB_site->query("UPDATE ".TABLE_PREFIX."journals 

                SET lastentry='".addslashes($lastentry['entrytitle'])."', entrycount=entrycount-1, lastentry_date='".$lastentry['entrydate']."', 

                lastentry_id='".$lastentry['entry_id']."' 

                WHERE journal_id='".$j."'

                ");

I will update the zip shortly. I have also attached an updated journal.php

Hey!

Very nice hack. I'm going to sign up at your website just to show support in addtion to posting here.

There is a problem with the installer. It does not add the phrase "can_report_entries". Also, I had to "rebuild" all languages in able to see the phrases used in the ACP. Just to let you know if these hasn't been reported before.

AN-net · #**900** 03-13-2005, 01:21 AM

Quote:

Originally Posted by Blootix

Hey!

Very nice hack. I'm going to sign up at your website just to show support in addtion to posting here.

There is a problem with the installer. It does not add the phrase "can_report_entries". Also, I had to "rebuild" all languages in able to see the phrases used in the ACP. Just to let you know if these hasn't been reported before.

yeah that is an issue i will hopefully resolve in version 2. also thanks for registering on my website

Blootix · #**901** 03-13-2005, 01:53 AM

Quote:

Originally Posted by AN-net

yeah that is an issue i will hopefully resolve in version 2. also thanks for registering on my website

NP.

However, I have one more question: I don't know why, but when I upload an avatar, the avatar on journalpage doesn't change. However, when I give the URL to the avatar, it does change. Any fixes for this?

Thanks.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07272 seconds Memory Usage 2,460KB 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 (2)bbcode_code (8)bbcode_php (8)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 (15)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!