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 · #**512** 11-11-2004, 01:07 AM

Quote:

Originally Posted by Lionel

When you mess up with sessions, you should warn people. For 6 weeks my online was messed up. I finally found out the reason. Your 'injournal' code does not belong in there!!!!!

-------------------------------
Open: /includes/functions.php
-------------------------------
Find:
global $bbuserinfo, $session, $foruminfo, $threadinfo, $calendarinfo, $permissions, $vboptions;
-------------------------------
Replace Above With:
global $bbuserinfo, $session, $foruminfo, $threadinfo, $calendarinfo, $journalinfo, $permissions, $vboptions;
-------------------------------

-------------------------------
Find:
$shutdownqueries['sessionupdate'] = str_replace('###REPLACE###', ',inforum = ' . intval($foruminfo['forumid']) . ', inthread = ' . intval($threadinfo['threadid']) . ', incalendar = ' . intval($calendarinfo['calendarid']) . ', badlocation = ' . intval($bbuserinfo['badlocation']), $shutdownqueries['sessionupdate']);
-------------------------------
Replace Above with:
$shutdownqueries['sessionupdate'] = str_replace('###REPLACE###', ',inforum = ' . intval($foruminfo['forumid']) . ', injournal = ' . intval($journalinfo['journal_id']) . ', inthread = ' . intval($threadinfo['threadid']) . ', incalendar = ' . intval($calendarinfo['calendarid']) . ', badlocation = ' . intval($bbuserinfo['badlocation']), $shutdownqueries['sessionupdate']);
-------------------------------

-------------------------------
Find:
$replace = array(
',inforum, inthread, incalendar, badlocation',
',' . intval($foruminfo['forumid']) . ', ' . intval($threadinfo['threadid']) . ', ' . intval($calendarinfo['calendarid']) . ',' . intval($bbuserinfo['badlocation'])
);
-------------------------------
Replace above with:
$replace = array(
',inforum, injournal, inthread, incalendar, badlocation',
',' . intval($foruminfo['forumid']) . ', ' . intval($journalinfo['journal_id']) . ', ' . intval($threadinfo['threadid']) . ', ' . intval($calendarinfo['calendarid']) . ',' . intval($bbuserinfo['badlocation'])
);
------------------------------
Save and upload /includes/functions.php

what are you talking about?

Lionel · #**513** 11-11-2004, 01:13 AM

I am sorry if I sounded rude, but I am really upset. The table structure for session is different in 3.01 and the location of the journal code did not belong. As a result, my table format changed from dynamic to fixed, guest could not show as the code in funcions.php was misplaced.

For six weeks, I basically dissected every inch of vbulletin code to find out that the problem was in sessions update as per above code. The injournal alter table was last in the table, so of course the 'update' session became out of line with the newly added location of injournal in the shutdown query.

Again, I am sorry as I used your codes and know that you are a good coder.

Lionel · #**514** 11-11-2004, 01:20 AM

This is the original vbulletin 3.01 table structure for session

PHP Code:


			
CREATE TABLE `session` (

  `sessionhash` varchar(32) NOT NULL default '',

  `userid` int(10) unsigned NOT NULL default '0',

  `host` varchar(15) NOT NULL default '',

  `useragent` varchar(100) NOT NULL default '',

  `lastactivity` int(10) unsigned NOT NULL default '0',

  `location` varchar(255) NOT NULL default '',

  `styleid` smallint(5) unsigned NOT NULL default '0',

  `badlocation` smallint(5) unsigned NOT NULL default '0',

  `inforum` smallint(5) unsigned NOT NULL default '0',

  `inthread` int(10) unsigned NOT NULL default '0',

  `incalendar` int(10) unsigned NOT NULL default '0',

  `loggedin` smallint(5) unsigned NOT NULL default '0',

  `idhash` varchar(32) NOT NULL default '',

  `bypass` smallint(6) NOT NULL default '0',

  PRIMARY KEY  (`sessionhash`)

) TYPE=HEAP;

Lionel · #**515** 11-11-2004, 01:22 AM

notice where idhash is?

PHP Code:


			
CREATE TABLE `session` (

  `sessionhash` char(32) NOT NULL default '',

  `userid` int(10) unsigned NOT NULL default '0',

  `host` char(15) NOT NULL default '',

  `idhash` char(32) NOT NULL default '',

  `lastactivity` int(10) unsigned NOT NULL default '0',

  `location` char(255) NOT NULL default '',

  `useragent` char(100) NOT NULL default '',

  `styleid` smallint(5) unsigned NOT NULL default '0',

  `loggedin` smallint(5) unsigned NOT NULL default '0',

  `inforum` smallint(5) unsigned NOT NULL default '0',

  `inthread` int(10) unsigned NOT NULL default '0',

  `incalendar` smallint(5) unsigned NOT NULL default '0',

  `badlocation` smallint(5) unsigned NOT NULL default '0',

  `bypass` tinyint(4) NOT NULL default '0',

  PRIMARY KEY  (`sessionhash`)

) TYPE=HEAP;

AN-net · #**516** 11-11-2004, 01:27 AM

Quote:

Originally Posted by Lionel

I am sorry if I sounded rude, but I am really upset. The table structure for session is different in 3.01 and the location of the journal code did not belong. As a result, my table format changed from dynamic to fixed, guest could not show as the code in funcions.php was misplaced.

For six weeks, I basically dissected every inch of vbulletin code to find out that the problem was in sessions update as per above code. The injournal alter table was last in the table, so of course the 'update' session became out of line with the newly added location of injournal in the shutdown query.

Again, I am sorry as I used your codes and know that you are a good coder.

the code works for me, if you can further explain the problem or the conflict i will assist

Lionel · #**517** 11-11-2004, 01:29 AM

AN net, look at above post and you will see the two tables for sessions are different. So when your code based on 3.03 was trying to update sessions, it could not.

AN-net · #**518** 11-11-2004, 01:32 AM

Quote:

Originally Posted by Lionel

AN net, look at above post and you will see the two tables for sessions are different. So when your code based on 3.03 was trying to update sessions, it could not.

i am sry for the mistake, if someone could provide me with vb3.0.1 functions.php file i will gladly fix this error, i did not realize the code and database change since 3.0.1

Lionel · #**519** 11-11-2004, 01:35 AM

I know it's not your fault. I am actually blaming vbulletin in my mind. There was no reasons for that change. At least that I could see.

Where could I send you the file?

AN-net · #**520** 11-11-2004, 01:35 AM

lionel could use [sql] tags and [php] tags around the code you posted so guests will not be able to view this vb code, thank you and i am deeply sry for not being aware of that change and any stress it may have caused you

send the file via my aim or email

Lionel · #**521** 11-11-2004, 01:56 AM

I am trying to send via aim, but it says you are idle

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.11353 seconds Memory Usage 2,347KB Queries Executed 26 (?)
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_php (3)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 (4)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)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!