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

[redd]

We've been using this hack for a few months without any problems. Now, all of a sudden, we've been receiving error messages:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number:

Date: Tuesday 24th of December 2002 09:40:46 AM
Script: /forum/journal.php?s=&journalid=12338&action=view

We ONLY receive errors regarding connecting to view the journals, not the rest of the forum, and we've received at least 30 in the last week.

Has anyone else been having problems?

[EcpHosting]

NOTE: please during setup of the new version, allow the user to SELECT which STYLE to install to. The installation installed to my default style and didnt go to my CUSTOM style.

Just a note, and i may have missed something, but if you are getting a blank screen AND are using a custom style, you will need to move templates over from default to your style.

[EcpHosting]

I am getting the following error when users attempt to create a journal entry:

Database error in vBulletin 2.2.9:

Invalid SQL: UPDATE user SET journal=1 WHERE userid=1
mysql error: Unknown column 'journal' in 'field list'

mysql error number: 1054

Date: Sunday 29th of December 2002 07:14:32 PM
Script: http://bigfish.truewalk.com/journal....=createjournal
Referer:

However, if the user REFRESHES the page, it says the journal already exists and it acts flawless from there.

Also, the "$forums" in the postbit is not working for the user who has an entry. Any ideas for either?

[Brahm]

Yeah when I try to install in 2.29 I get to step 3 and get a MySQL error,

Database error in vBulletin Control Panel 2.2.9:

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: Wednesday 01st of January 2003 12:10:56 AM
Script: http://www.ashkins.net/forum/forum/a...nal.php?step=3
Referer: http://www.ashkins.net/forum/admin/i...nal.php?step=2

[Brahm]

Man oh man. With a little manual database entry I managed to push past the above error message. I created the tables and did the inserts manually through the end of the install, and it now works. Thanks a bunch Ryangel. It works, it really works!

[Elvis]

Originally posted by Willard Reece
But basicly my only prob with it is I wish a admin could delete post made in any journal or what ever.
I didn't see that as a option. and also the error page.

I've done it.... it was annoying the crap outta me too....

this file will:

display 20 of each of the 3 columns on the Journal jump page, and will also allow admins to edit/delete journal entries and comments.

Just download and rename this file to journal.php
then upload to your main directory

Enjoy,

Elvis

[indiamike]

Originally posted by Elvis

I've done it.... it was annoying the crap outta me too....

Elvis

Uploaded and just got errors....

Database error in vBulletin 2.2.5:

Invalid SQL: SELECT u.username, e.entryid, e.journalid, e.title, e.entry, e.timestamp, e.userid, e.private, e.displayorder, e.comments
FROM journal_entry e
LEFT JOIN user u ON e.userid = u.userid
WHERE e.journalid = 81
ORDER BY e.timestamp DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Sunday 12th of January 2003 11:12:23 AM
Script: http://www.indiamike.com/india/india...81&action=view
Referer: http://www.indiamike.com/india/journal.php

Seems to be requesting the wrong url.

[Elvis]

Originally posted by indiamike


Uploaded and just got errors....

Seems to be requesting the wrong url.

Well, I just verified that the file I uploaded is exactly like the one I currently have in use - it is.

Also... from the error, it looks as though you may be missing a line of an SQL statement - did you edit this file AT ALL?

and finally, I dont understand how you could be requesting a wrong URL, every instance of the goto starts like:

$goto="journal.php?s=

it's referring to itself - there are no directory changes at all.

[indiamike]

hmmm...I didn't alter it it in anyway and just uploaded it to try it out to see what it would do.

I uninstalled it but the error showed up when I would click on a members name to view their journal.

Has anyone else tried this yet?

Mike

[sabret00the]

i got multiple stylesets but your installer will only install to the default is their a fix available?