Miscellaneous Hacks - VB3 port of Ryangel Journal Hack

This is the VB3 port of the Journal Hack created originally by Ryangel for VB2. It was hacked by Wonko the Sane from www.shinraonline.com for our own needs and further optimized and developed by Aiky, Oblivion Knight, Sabret00the and other members of EverythingVB.com.

EverythingVB.com will be down as it undergoes an upgrade and we hope to continue this project here at vbhacks.us (which opened after we started project).

-----------------------------------------------------------------

Attached is the original journal thread from everythingvb.com for reference should anyone have problems that were previously answered along with the two latest releases of the journal hack files. Oblivion Knight explains the differences between the two as:

Quote:

1.2b contains the "cleanest" code (optimized by Bane), and is based on sabre's templates and also contains a recent MySQL fix done by me (which is why 1.1d was released).

1.1d contains the original templates by myself, but you'd probably be better off using the journal.php file contained in the other zip since there is a lot of redundant code in this one..

-----------------------------------------------------------------

Things to note:

* The journal hack works and has been successfully installed by alot of people, including myself on two clean installs. There are ALOT of manual queries and file edits... just take your time and be thurough about it and you shouldn't have a problem. If you do have an issue, you probably missed one of the edits, go back and check it and read the original evb thread (attached) to see if its been covered. Otherwise feel free to post and we'll see if we can help.

* The phrases and templates currently need to be manaully installed. An automated way of adding them has not yet been currently added. I would suggest adding the multiple phrases hack on vb.org to make your life a little easier.

*blueuniverse* · 07-30-2004, 03:59 AM

When running this bit,

Quote:

Otherwise, these are the tables that the journal needs in order to
exist and function correctly:

--- SQL START ---

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',
'mood' text NOT NULL,
'np' text NOT NULL,
PRIMARY KEY ('journalid')
) TYPE=MyISAM ;

--- SQL END ---

phpmyadmin says

#1064 - 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 ''journalid'int( 11 ) NOT NULL AUTO_INCREMENT ,
'title'text

*Oblivion Knight* · 07-30-2004, 08:16 AM

Run this instead..

[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',
mood text NOT NULL,
np text NOT NULL,
PRIMARY KEY (journalid)
) TYPE=MyISAM ;[/SQL]

*cody* · 07-30-2004, 10:32 PM

Great job, guys. Thanks!

Any progress on pagination of links to Journals? Lots of journals are gonna produce a very long list.

*Matias* · 07-30-2004, 10:59 PM

i think pagination its done...

please check the thread attach at first post.
i got journal pagination on my test forum...
i think u need edit somethin on journal.php but i dont remember what

...
as i say check the thread attach on zip at 1st post of this thread.

Regards

*cody* · 07-31-2004, 12:19 PM

I re-read the thread and I do not think the "issue" is resolved.

What I am referring to is the list of journals. I believe that one version lists them all (l..ong list if many journals) and the other lists 25 with no link to the next batch of 25, etc.

Am I wrong?

*Oblivion Knight* · 08-01-2004, 10:57 AM

Quote:

Originally Posted by cody

What I am referring to is the list of journals. I believe that one version lists them all (l..ong list if many journals) and the other lists 25 with no link to the next batch of 25, etc.

Am I wrong?

Nope, you're 100% correct..
I haven't quite mastered the art of pagination unfortunately..

*cody* · 08-01-2004, 01:31 PM

Quote:

Originally Posted by Oblivion Knight

Nope, you're 100% correct..
I haven't quite mastered the art of pagination unfortunately..

Well, I gather it's a royal pain for most coders. Maybe someone will be inspired to help out with an add-on. You guys have been soooo generous with your work and time already!

Is it possible to add a link to a user's journal on the member list by any chance?

*blueuniverse* · 08-03-2004, 05:49 AM

Do you need to change anything to be able to delete journal entries, because I'm set as an admin, I can edit normal posts, but I can't edit or delete journal entries or comments.

*cody* · 08-13-2004, 01:40 PM

Because some have expressed a desire to port to AN-net's Journal for vB3 when completed ... he is approaching beta ... just a heads-up for those who are interested.

*Paul* · 08-13-2004, 02:35 PM

Well ppl have wanted a journal since v3 came out and I've needed one for quite sometime so this is does exactly what i need

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Install System Part 2	Ken Iovino	Announcements	10	05-19-2005 10:40 AM
Port & Polish Journal Hack, please!	cody	vBulletin Modification Requests	0	04-19-2004 02:40 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)