vb.org Archive - vBJournal Lite 1.1b

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - vBJournal Lite 1.1b (https://vborg.vbsupport.ru/showthread.php?t=43717)

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...

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

EThan

any idea when this is coming out of beta?

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

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 finally installs...:)

nexdog u have a copy of it ?

Quote:

Originally posted by NexDog
* NexDog has indeed.

whats this?

anyone know how to change the color of the links?

thanks

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?

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.

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

Quote:

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?

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

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!

Quote:

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

Quote:

Originally posted by Elvis

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

Elvis

Uploaded and just got errors.... :confused:

Quote:

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.

Quote:

Originally posted by indiamike

Uploaded and just got errors.... :confused:

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.

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

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

Would this page http://www.devarticles.com/art/1/110/ help anyone that understands php to create multiple pages for the journals?

Well, I finally used this. Was a breeze. Anyone who needs the templates (for the template backup import) instead of hacking the journal.php see the attached file (it has all templates used in this hack).

i've searched this thread and basically altho i saw a half answer i'm looking for a full answer (meaning not firefly's hack lol)

basically i'd like it so that when you view online.php is says who's journal you're viewing, is that possible at all?

There's no other way, but firefly's hack is fast, easy, and will work for you for many other hacks. I have soooo many different hacks installed on my board and now, with FireFly's hack. everyone knows where and what others are doing. :)

i think i'll have to try writing it myslef then :-S

been having a few problems with that idea, but i'll muster on

new thing tho' how do you add smilies to the addentry page and add comments page 0_o

oh and is there a way to only allow members to view journals?

Fantastic hack! Just what I was looking for. :) Is there a way to let users include html or VB code in their entries?

Quote:

Originally posted by Koss
just a suggestion, maybe add a column on the member page (members.php) with a link of all the members with a journal

Here's how to do this:

In memberlist.php find:

Code:

if ($userinfo[receivepm]) {

      eval("\$userinfo[pmlink] = \"".gettemplate("postbit_sendpm")."\";");

    } else {

      $userinfo[pmlink] = "&nbsp;";

    }

and add after:

Code:

// vBJournal Hack by Ryangel

        if($userinfo[journal]==1){

                $journal = '<a href="journal.php?s=&journalid='.$userinfo[userid].'&action=view"><img src="images/journal.gif" alt="View '.$userinfo[username].'\'s Journal" border="0"/></a>';

        }

        else {

                $journal = '';

        }

// vBJournal Hack End

In memberlist template, find

Code:

<td bgcolor="{categorybackcolor}" colspan=

Your columnspan needs to be increased by one, so if it's 7, make it 8.

In same template, find:

Code:

</tr>

$memberlistbits

Beneath that add:

Code:

<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}">Journal</smallfont></td>

In the memberlistbit template find:

Code:

</tr>

Right above that add:

Code:

<td bgcolor="{firstaltcolor}">$journal</td>

That should do it :)

OK I deleted the first entry and I got "Deathsttryke's Journal Entries : -1"

I posted my own and my entries equalled 0 - [ makes sense]

Can you make so that either a] you can delete the welcome message or b] you can delete it but it doesn't change?

Thanks

Other than that, wicked hack!

Great hack ... anyone know a way of showing a list of all user journals?

Does anyone know if the page linking has been added yet?
Just noticed that afterlab has this feature working here.. Is this his own journal system or is he using this one?

I'd love to have a journal system running at Umbrella Online, but for me there seem to be a few bugs and features missing with this version from reading other people's posts.. I could be wrong.. ;)

Quote:

Originally posted by ChurchMedia
Fantastic hack! Just what I was looking for. :) Is there a way to let users include html or VB code in their entries?

my users all have the ability to use vBcode, dunno about html tho'

Never could get the installer to make the changes in the database. Too bad too! :hurt:

any news on the follow up version with the additional features like

+ mood
+ listening too
+ smilie box on add entry & add reply

OK, I installed it on vB 2.2.9.

1) There should be an option to delete one's own journal, and also for an administrator to delete journals. If I delete users their journals are still on record and naturally you get a database error when you click on a deleted user's journal.

2) As has been said (and as I know Gamingforce has on his forums), there should be a profile link to the user's journal with a different message if they have no journal.

3) What's the deal with private entries? I assume that's so only people on your buddy list can view the entry (like at Gamingforce) but none of my buddies can read my private entries.

I'll also recap on what else is initially needed;

- 'Maximum replies per page' setting.
- Admins should be able to edit/delete replies (just in case the system gets abused).
- Word wrap is needed. If someone puts a load of ........... s with no spaces it should automatically wrap at so many characters so the tables aren't broken (a solution has been discussed for this but it needs incorporating in the hack).

Those are the 'musts' in my opinion. Now a suggestion.

Personally I would like at least an option so guests can't even VIEW journals unless the usergroup is manually permitted (I wouldn't want banned people seeing journals).

On top of that, outstanding work!

Installed...

Quick question...

I would like to make the comments linkable the same as the discuss button. Its just confusing for people to view comments by clicking the discuss button. Essentially its the same thing, but just for UI purposes.

How would do I do that?

thanks!

Quote:

Originally posted by Elvis

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.

I didn't alter anything and I have the same problem;

Database error in vBulletin 2.2.9:

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 = 14
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: Tuesday 25th of February 2003 03:18:48 AM
Script: http://www.gamercrossfire.net/bb/bb/...14&action=view
Referer:

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

Quote:

Originally posted by ChurchMedia

Here's how to do this:

In memberlist.php find:

Code:

if ($userinfo[receivepm]) { eval("\$userinfo[pmlink] = \"".gettemplate("postbit_sendpm")."\";"); } else { $userinfo[pmlink] = " "; }

and add after:

Code:

// vBJournal Hack by Ryangel if($userinfo[journal]==1){ $journal = '<a href="journal.php?s=&journalid='.$userinfo[userid].'&action=view"><img src="images/journal.gif" alt="View '.$userinfo[username].'\'s Journal" border="0"/></a>'; } else { $journal = ''; } // vBJournal Hack End

In memberlist template, find

Code:

<td bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" colspan=

Your columnspan needs to be increased by one, so if it's 7, make it 8.

In same template, find:

Code:

</tr> $memberlistbits

Beneath that add:

Code:

<td bgcolor="#1D6AA0" align="center"><smallfont color="#EEEEFF">Journal</smallfont></td>

In the memberlistbit template find:

Code:

</tr>

Right above that add:

Code:

<td bgcolor="#13486D">$journal</td>

That should do it :)

Much appreciated. I used this. A few notes though;

In memberlist.php use

PHP Code:


		
			
// vBJournal Hack by Ryangel

    if($userinfo[journal]==1){

        $journal = '<a href="journal.php?s=&journalid='.$userinfo[userid].'&action=view"><img src="images/journal.gif" alt="View '.$userinfo[username].'\'s Journal" border="0"/></a>';

    }

    else {

        $journal = '';

instead of

PHP Code:


		
			
// vBJournal Hack by Ryangel

    if($userinfo[journal]==1){

        $journal = '<a href="journal.php?s=&journalid='.$userinfo[userid].'&action=view"><img src="images/journal.gif" alt="View '.$userinfo[username].'\'s Journal" border="0"/></a>';

    }

    else {

        $journal = '';

// vBJournal Hack by Ryangel

In the memberlist template add;

Code:

<td bgcolor="{*tableheadbgcolor*}" align="center"><smallfont color="{*tableheadtextcolor*}"><b>Journal</b></smallfont></td>

above

Code:

$memberlistbits

rather than putting

Code:

<td bgcolor="#1D6AA0" align="center"><smallfont color="#EEEEFF">Journal</smallfont></td>

below it.

In the memberlistbit template use;

Code:

<td bgcolor="{*firstaltcolor*}">$journal</td>

rather than

Code:

<td bgcolor="#13486D">$journal</td>

Most of this isn't your fault. I noticed when you put something like {*tableheadbgcolor*} (without the *s) it's replaced with the tableheadbgcolor HTML for this board.

Remove all the *s in my coding for it to work.

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

Now, I'm trying to put a journal link in user profiles. Now where in the member.php would I insert

Code:

// vBJournal Hack by Ryangel

        if($userinfo[journal]==1){

                $journal = '<a href="journal.php?s=&journalid='.$userinfo[userid].'&action=view"><img src="images/journal.gif" alt="View '.$userinfo[username].'\'s Journal" border="0"/></a>';

        }

        else {

                $journal = '';

        }

?

I stuck it under

Code:

  $referrals = $refcount[count];

    eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");

  } else {

                $referrals = '';

        }

but when I put $journal in the 'getinfo' template it takes no notice if someone has a journal. For example, if I put something like

Code:

 // 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 = 'No journal enabled';

        }

in member.php, their profile shows 'No journal enabled' regardless in spite of the same hack working in admin/functions.php and memberlist.php.

Quote:

Originally posted by limey
Installed...

Quick question...

I would like to make the comments linkable the same as the discuss button. Its just confusing for people to view comments by clicking the discuss button. Essentially its the same thing, but just for UI purposes.

How would do I do that?

thanks!

edit the template 0_o

The correct template is journal_entrybits

Basically copied the discuss link and wrapped it around the "comments" in the template.

Installed!! My USERS Love this Hack!!

Thanks!! No problems whatsoever!

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01565 seconds Memory Usage 1,869KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (22)bbcode_code_printable (2)bbcode_php_printable (11)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: