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

[ohgenki]

only opera browser works with it and i must do a 'repost' IE and Netscape doesn't allow users to post the new entries in the journal...but it allows a creation of one...

[ethank]

I'm having a problem getting IMG tags working with my journal. Anyone know what the problem would be?

EThan

[teenfront]

any idea when this is coming out of beta?

[Jitway]

Any suggestions... I get this error on the install_forum.php
Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: INSERT INTO journal_entry (entryid, title, entry, private, timestamp, userid, journalid, displayorder) VALUES (1, 'Welcome to the Jitway's Gaming/Family! Journal.', 'Version 1.1b Have fun. ', '0', '1027264704', '1', '1', '1')
mysql error: You have an error in your SQL syntax near 's Gaming/Family! Journal.', 'Version 1.1b Have fun. ', '0', '1027264704', '1',' at line 1

mysql error number: 1064

Date: Tuesday 12th of November 2002 02:00:28 PM
Script: http://www.jitway.com/forums/forums/...nal.php?step=3
Referer: http://www.jitway.com/forums/admin/i...nal.php?step=2

[Jitway]

I get this error when I go to the actually forum.php page and click on the get journel button
Database error in vBulletin 2.2.8:

Invalid SQL: SELECT COUNT(commentid) FROM journal_comments where journalid = 1
mysql error: Table 'jitway_xmb2.journal_comments' doesn't exist

mysql error number: 1146

Date: Tuesday 12th of November 2002 02:31:28 PM
Script: http://www.jitway.com/forums/forums/...=1&action=view
Referer:

Also here is the templates all in a folder that you can use to install easier with the template backup system hack.

[NexDog]

/NexDog finally installs...

[ohgenki]

nexdog u have a copy of it ?

[NexDog]

/me has indeed.

[Koss]

Originally posted by NexDog
* NexDog has indeed.

whats this?

[Koss]

anyone know how to change the color of the links?

thanks