Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases

Reply
 
Thread Tools
vBJournal Lite 1.1b Details »»
vBJournal Lite 1.1b
Version: 1.00, by Ryangel Ryangel is offline
Developer Last Online: Sep 2007 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 09-18-2002 Last Update: Never Installs: 71
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #132  
Old 12-24-2002, 02:00 PM
redd redd is offline
 
Join Date: Sep 2002
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #133  
Old 12-29-2002, 09:59 PM
EcpHosting's Avatar
EcpHosting EcpHosting is offline
 
Join Date: Dec 2002
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #134  
Old 12-29-2002, 10:57 PM
EcpHosting's Avatar
EcpHosting EcpHosting is offline
 
Join Date: Dec 2002
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #135  
Old 01-01-2003, 04:49 AM
Brahm Brahm is offline
 
Join Date: Jan 2002
Location: Texas, USA
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #136  
Old 01-01-2003, 07:59 AM
Brahm Brahm is offline
 
Join Date: Jan 2002
Location: Texas, USA
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
  #137  
Old 01-12-2003, 07:13 AM
Elvis Elvis is offline
 
Join Date: Jul 2002
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #138  
Old 01-12-2003, 02:21 PM
indiamike's Avatar
indiamike indiamike is offline
 
Join Date: Oct 2001
Location: New Jersey, India
Posts: 124
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by Elvis

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

Elvis
Uploaded and just got errors....
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.
Reply With Quote
  #139  
Old 01-12-2003, 03:23 PM
Elvis Elvis is offline
 
Join Date: Jul 2002
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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.
Reply With Quote
  #140  
Old 01-12-2003, 06:03 PM
indiamike's Avatar
indiamike indiamike is offline
 
Join Date: Oct 2001
Location: New Jersey, India
Posts: 124
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #141  
Old 01-19-2003, 01:35 PM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:36 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07427 seconds
  • Memory Usage 2,316KB
  • Queries Executed 25 (?)
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
  • (5)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
  • (2)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