vBJournal for vBulletin 3.5

[Andreas]

This is a Port of vB Journal by An-Net

A t t e n t i o n
This Hack is unsupported and incompatible with PHP 5.
You are herby advised to not use it.
If you do have this hack installed it is advised to use vBulletin Blog instead.
You can import current entries to vBulletin Blog via Impex and uninstall this hack afterwards.

[nexialys]

No description here yet
oh, nevermind, reputation take the place of a description...

[TTG]

One of the most eagerly awaited conversions for 3.5.0.
Installed and working with no problems .. so far :)

Clicked install

[Paul M]

Ah, finally. :)

This will going on my test system shortly.

[Paul M]

Hmm, actually - how is installing this going to affect my existing journal tables ?

[Andreas]

It will blow them up ^.^
Ok, no joking: Not much, it will add 2 fields to the journals table and 1 field to the journal_entries table.
That's it.

[kall]

Kirby, I love you and I want to have your babies.

*clicks Install*

[kall]

Hmm. Seems the Install thingee didn't Upgrade my existing tables.

Unknown column 'allowedusers' in where clause.

[Andreas]

Hmm, should have been created.
Anyway, just create it yourself :)

[White_Snake]

nice :D

been waiting for this one

[eNforce]

This is really cool.

Some questions and a possible problem.

Where do I edit moods, there's no link in the Journal page in ACP. Can only edit moods after adding one. And when I click edit I get a database error.

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT mood_name,mood_id,mood_image FROM journal_moods WHERE mood_id=;

MySQL Error : 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 '' at line 1
Error Number : 1064
Date : Saturday, September 17th 2005 @ 07:02:21 PM
Script : http://www.areyouserios.com/admincp/journaladmin.php?do=editmood&mid=1
Referrer : http://www.areyouserios.com/admincp/journaladmin.php?do=moderatemoods
IP Address : 137.186.150.120
Username : Brad
Classname : vb_database

[Omega Prime]

I've uploaded the files and the product xml, but I see the following even when the journal's enabled in the admincp:


The journal module has been deactivated.

Any help is appreciated :)

[Andreas]

TBH, I never bothered with moods ^^
Will take a look at it.

[Andreas]

@Omega Prima
If that does appear then it is deactivated.

[hydrostatic]

Thank you you're my hero! *clicks install*

No more manually adding templates!

[Omega Prime]

@Omega Prima
If that does appear then it is deactivated.

As I said earlier, I have it enabled where it says:

Is Journal System Active?

[Andreas]

@Omega Prima
Hit save on this screen

@eNforce
I've updated the ZIP. Overwrite journaladmin.php and cpnav_journalhack.xml
You will envounter "Cound not find Phrase xyz"-Errors.
Those are trivial, don't have any functional effect and will be fixed in later Versions.

[eNforce]

Ooooooo, great! :)

Another mood problem, when I post an entry, in the drop down menu for moods there isn't anything to select. Though there are moods configured via ACP

[Andreas]

Should be there ... and is for me?

[Barakat]

The journal module has been deactivated.

install great but this is what i have on my board

[Andreas]

If this does appear then the Journal is deactivated.

[Zelda-King]

Been looking forward to this. Installing right now!

[Barakat]

its works but nothing inside it ? emm need to add a mood and mood images ?

and when i try to access it a msg appear like that :-

Barakat you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting

[Osterling]

How do I deactivate? Thank you.

Never mind, I forgot to click refresh on the page. Excuse me.

[Zelda-King]

Barakat you do not have permission to access this page. This could be due to one of several reasons:Same problem here actually. And I've hit save on the Journal Settings page. Before that I was getting 'this module has not been enabled' or something like that.

Also, this needs linking to in the navbar, no?

[Andreas]

@Barakat
Where is "nothing inside it"?
Also, when exactly do you get this message?

@exasko
ACP / vB Journal / vB Journal Settings

@Zelda-King
Yeah, the Template-Edits are not included in the readme ... I guess I assumed they magically would appear automatically. LOL
Gonna add them.

[Paul M]

It will blow them up ^.^
Ok, no joking: Not much, it will add 2 fields to the journals table and 1 field to the journal_entries table.
That's it.Actually no it won't since there are no ALTER statements in the install code to do this. You have CREATE statements to create the tables (with the new fields) but these will of course fail if you already have existing journal tables.

I suggest you use CREATE statements to make the tables as they were in the 3.0 version, and then ALTER statements to add the new fields - that way you will cover both new installs and 'upgrades'. :)

[Andreas]

@Paul M
There are ALTER Statements?

[eNforce]

Should be there ... and is for me?

Hmm, Don't know what my problem is then :(

[Omega Prime]

@Omega Prima
Hit save on this screen


Well, that worked :)

Just a side question, but how can you have it so that it shows journals on the index in descending order by the last entry date? I know I can set it myself, but there doesn't seem to be a way to have it set like that for all members (the same goes with journal entries) :ermm:

[Zelda-King]

Just checking something: I'm using MySQL 4.0.24-max-log. Is that adequate for this? (I did read the thing about needing 4.0.4+).

[kall]

Hmm, should have been created.
Anyway, just create it yourself :)

Well obviously. ;)

Just wanted to make the issue known.

[Andreas]

Hmm, Don't know what my problem is then :(
Can you attach a dump of your journal_moods table?

@Zelda-King
Your mySQL-Version should be fine.

I've updated the readme with the Templat Edits. If you still have them from 3.0, there should be no changes necessary except the condition in postbit/postbit legacy.

[Barakat]

upload it for the 3rd time and overwrite it but nothing change ? only the deactive disapear and i dont have permision to enter that journal. :mad:

[Andreas]

Well, do you have Permission according to your Usergroup Permissions?

Btw: Uninstalling will delete all existing Journals/Entries/Moods/etc.
I hope you didn't do that and had existing Data ...

[jesus likes pie]

Invalid Attachment specified. If you followed a valid link, please notify the webmaster

[Andreas]

@jesus likes pie
W00t? Maybe your cache is wrong ... reload page?

[eNforce]

Can you attach a dump of your journal_moods table?

I'm not sure if I did this right, never had to do it before :speechless:

???

[Andreas]

Really strange. I imported this and it shows up for me.

Edit: Ah, OK. There was one Template missing in the XML as it was attached to the wrong product. LOL.
Reimport the XML (1.0.2 Alpha 1 Build 2)

[Barakat]

thanks it works wonderfull thanks thanks thanks

[Andreas]

Well, I thought it was obvious that one has to turn on appropriate Permissions ;)

[Omega Prime]

Well, that worked :)

Just a side question, but how can you have it so that it shows journals on the index in descending order by the last entry date? I know I can set it myself, but there doesn't seem to be a way to have it set like that for all members (the same goes with journal entries) :ermm:

Just thought I'd quote myself since it was on the bottom of the 2nd page and Kirby might've not noticed :)

[Paul M]

@Paul M
There are ALTER Statements?Well yes, there are now, since you've now added them. They wern't there when I downloaded it earlier - I can only report on what I have - esp if you change it without saying anything. :)

FYI, I also had to manually rebuild the bitfields before I could use it (or edit usergroups).

[Daniel]

Set the proper usergroup settings, uploaded everything, but I get it's deactivated when it's not...

[Andreas]

@Paul M
Yeah, in the first ZIP they were missing, but they were already added when you posted that they are not there :)
Hmm, the Bitfields should be rebuilt automatically.
Gonna test why they are not.
Edit: Tested and gets rebuilt for me.

@Danieldude
If it tells you that it is deactivated then it is deactivated.

@Omega Prime
Not possible (yet)

[ged]

I had vbjournal on my 3.0.7, does this hack upgrade it? I don't want to loose my users' journal data.

[Andreas]

It should, unless you uninstall it.
To be 100% safe, I'd suggest to backup your journals, journal_entries, journal_comments, journal_moods and journal_settings tables first.

[hydrostatic]

It should, unless you uninstall it.
To be 100% safe, I'd suggest to backup your journals, journal_entries, journal_comments, journal_moods and journal_settings tables first.

When trying to edit moods, there comes an SQL error.
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
DELETE FROM journal_moods WHERE mood_id=1;

MySQL Error : Table 'blootix_forums.journal_moods' doesn't exist
Error Number : 1146
Date : Sunday, September 18th 2005 @ 02:45:26 AM
Script : http://www.blootix.com/forums/admincp/journaladmin.php?do=killmood&mid=1
Referrer : http://www.blootix.com/forums/admincp/journaladmin.php?do=moderatemoods
IP Address : ***********
Username : Blootix
Classname : vb_database

I think you mistyped something about a TABLE PREFIX. I'll try to find it.

EDIT: Found it. You forgot to do that .TABLE PREFIX. thing with this code:

$mid = $vbulletin->input->clean_gpc('r', 'mid', TYPE_INT);
$db->query("DELETE FROM journal_moods WHERE mood_id=".$mid."");
define('CP_REDIRECT', 'journaladmin.php?do=moderatemoods');
print_stop_message('journal_mood_deleted_successfu lly');
it should be:
$mid = $vbulletin->input->clean_gpc('r', 'mid', TYPE_INT);
$db->query("DELETE FROM ".TABLE_PREFIX."journal_moods WHERE mood_id=".$mid."");
define('CP_REDIRECT', 'journaladmin.php?do=moderatemoods');
print_stop_message('journal_mood_deleted_successfu lly');
Am I right?

[Andreas]

Yes.
People should not use Table-Prefixes ;)
But: Bugs should not be reported here.
That just gets too messy :(

[hydrostatic]

Ops I didn't see that link in the first post. I'll do that next time.

[Zelda-King]

To those getting the "you do not have permission to access this page" message (like I was), you need to go into the usergroup manager journal settings. The settings are all set to no by default.

[Paul M]

It should, unless you uninstall it.
To be 100% safe, I'd suggest to backup your journals, journal_entries, journal_comments, journal_moods and journal_settings tables first.I commented out the DROP TABLE commands since I may be removing/installing it a number of times - maybe you should consider this until it's a stable version. :)

[Andreas]

Sounds like a plan :)

[Daniel]

@Paul M
Yeah, in the first ZIP they were missing, but they were already added when you posted that they are not there :)
Hmm, the Bitfields should be rebuilt automatically.
Gonna test why they are not.
Edit: Tested and gets rebuilt for me.

@Danieldude
If it tells you that it is deactivated then it is deactivated.

@Omega Prime
Not possible (yet)

So how do I activate it?

[john1744]

Daniel I had to deactivate it then then reactiviate it.

[john1744]

Kirby- In the Journal support area of the Admin CP the links are quite outdated. Animationnet isn't even around anymore.

There is also a typo in the admin cp, under Journal settings, is commenting allowd. Minor issues I know, but thats all I've found so far. :)

My users say they would like to be able to have banners for their journal though... Any easy way that could be implemented? Just small banner images at the top of the journal.

[hydrostatic]

Also, there should be a way to delete Recent Comments. Some comments, if they're not associated with an entry, cannot be deleted (as of my knowledge) unless I manually go DB hunting for them. :)

[Daniel]

How do I activate it...?

[Andreas]

@john1744
There won't be any new features until this is stable (eg. out of Alpha/Beta and RC State).

[Daniel]

Anyone... how do I activate this thing?

[Vizionz]

refresh the admincp and go to journal settings - then set up your usergroups to be able to acess it

MY wish was that all these additional hacks were just based on text instead of buttons or you had the option to change from images to text links. ya know how much a pain in the *** it is to make buttons for 12 themes. to match

[Daniel]

There is no Journal Settings - and I installed everything, uploaded plugin...

[Andreas]

It is. ACP / vB Journal

@Vizionz
Buttons look better :)

[Daniel]

I must be blind, because I don't see it.

[Vizionz]

i know they do but usually these hacks do the buttons for white backgrounds and not transparent buttons so then if you use multi themes the buttons never work and then u are stuck doing them for themes. my forum is gonna have a choice of 120 themes so that makes alot of extra buttons i have to do i know its not your problem sinc eyour making the hack for usually default system then its the installers responsibilty to do any graphic changes but i think it should be required to make the buttons with any hacks transparent so they can fit any theme. or the option to choose text links or buttons. but thanks for doing the hack its a great additon.

[Vizionz]

daniel go to usergroups and set user group for your admin group to allow everything then refresh thats what i did and then it showed up

[Andreas]

Templates/Graphics are usually made for the default Style.
So if you use another Style, then it is your Problem ;)

Anyway, I don't have any clue about oing graphics stuff.
If anybody has and can provide alpha-transparency Buttons i'd be more than happy to include them :)

[Daniel]

daniel go to usergroups and set user group for your admin group to allow everything then refresh thats what i did and then it showed up

I did.

[Andreas]

Then it should work if it is activated.

[Daniel]

Still says its deactivated :(

[Daniel]

Nevermind got it to work - thanks.

[Vizionz]

i did the work and redid the xml to remove the buttons and put text links instead :) then reloaded the journal and works good :)

[kylek]

Anyone else get this, tried to delete comment from member;

Invalid SQL:
DELETE FROM vb3_journal_comments WHERE comment_id=;

MySQL Error : 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 '' at line 1
Error Number : 1064
Date : Sunday, September 18th 2005 @ 08:30:00 PM
Script : http://xxxxxxxxxxxx.xx/forum/journal.php?do=deletecom&com=1&j=1
Referrer : http://xxxxxxxxxxxxxxxx.xxx/forum/journal.php?do=showcomments&j=1


Also seem to be missing the moods, drop down area on the journal page has none, yet I see add moods in the admincp.

[???`S?LV?R???`]

Anyone tried this with a lower version of MYSQL? like somewhere in versoin 3?

[jesus likes pie]

I get this:

The journal module has been deactivated.

Yes, usergroup permissions are set up, Yes, vBJournal settings are correct and it IS on.

[hydrostatic]

I think you have to click save on the vBJournal settings page (even though they're turned on). I had the same problem but it went away after I clicked "save".

[ThePimp]

Can someone explain to me how to check if a user has a journal, then to display a link to it in the Postbit?

Basically, I'm looking to make a little icon that displays in the postbit_legacy if the user has a journal, but if they don't have one, it wouldn't display.

Any help would be appreciated.

Thanks

[hydrostatic]

Well, it's already in the user dropdown menu thing when you click on their username.

So:


<if condition="$post[journal_id]"><a href="journal.php?$session[sessionurl]do=showjournal&j=$post[journal_id]"><img src="YOUR ICON URL"></a></if>

Something like that.

[ThePimp]

Well, it's already in the user dropdown menu thing when you click on their username.

So:


<if condition="$post[journal_id]"><a href="journal.php?$session[sessionurl]do=showjournal&j=$post[journal_id]"><img src="YOUR ICON URL"></a></if>

Something like that.

Gotcha... Thanks.

[Andreas]

@kylek
Make sure you are using Version 1.0.2 Alpha 1 Build 2; both Problems should be fixed there.

@´ÀÉ`SÌLVÉR´ÀÉ`
It will work, but the installation does not work 100% if you are upgrading from a 3.0 installation.

@jesues likes pie
If it tells you that it is deactivated then it is deactivated.

[ThePimp]

Kirby, something to maybe consider in a future release...
In the Journal Settings, it might be a good feature to have where you can set the language that is used in the system. Such as "Blog" instead of "Journal", or something similar.

It's not too difficult to Find / Replace, just thinking it may be a slick addition.

The other thing would be maybe an online xml version of the journal, and an RSS syndicate link where people can publish their journal entries elsewhere. (This could easily tie into Zero's RSS system, or one of the other ones out there.)

Hopefully this makes sense.

[Andreas]

@ThePimp
There won't be any new featurss until this is stable.
However, making it fully phrased is planned for the near future.

[ThePimp]

@ThePimp
There won't be any new featurss until this is stable.
However, making it fully phrased is planned for the near future.

Cool, I've got it installed on a 350k+ post / 20k+ user community, and it seems to be working well. No bugs as of yet. I'll let you know if I find any.

[.Tim]

Install went fine, I thought, but I get this when I try and edit permissions:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ucash_paycheck` = '0',
`forumpermissions` = '470810623',
`attachlimit` = '0',
`pmquota` = '65535',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '204472319',
`genericoptions` = '22',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '4294967295',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '200',
`avatarmaxsize` = '4294967295',
`profileviewpermissions` = '15',
`userpagepermissions` = '0',
`imghost` = '3',
`imghostset` = '1024',
`imghost_width` = '1600',
`imghost_height` = '1200',
`imghost_files` = '1000',
`journalpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'userpagepermissions' in 'field list'
Error Number : 1054

:confused:

[Andreas]

Do you have amykhar's Userpage Hack (https://vborg.vbsupport.ru/showthread.php?t=91903 ) installed by any chance?
If so, it is not installed correctly and the cause for this Error.

[.Tim]

I did, thought I removed it but guess not. I'll take a look. Thanks.

[FleaBag]

Excellent work Kirby once again, you work very hard you deserve some credit! On a side note, as I am using an older version of mySQL than 4.0.4 - what exactly will NOT happen if I try to install this?

[Andreas]

Private entries/journals that are allowed to be viewed by Journal Buddies or Users in "Who Can View" will not be updated, so they won't show up even if you are one of the Users who has permission to view unless they are edited (just click edit and save afterwards).
Also, if the last entry of a Journal is private it might show up on the journal index if you do not have permission to view it.

[FleaBag]

Ah that's cool... There was minimal use of private journals on my site so can't see it causing many issues! :)

[jesus likes pie]

@jesues likes pie
If it tells you that it is deactivated then it is deactivated.


Actually it's a bug. It was on, whether you belive me or not. I had to turn it OFF, save, and then turn it BACK on.

That did the trick. I suggest you look into this as I'm sure a lot of people will have issues with this.

[jesus likes pie]

Install went fine, I thought, but I get this when I try and edit permissions:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ucash_paycheck` = '0',
`forumpermissions` = '470810623',
`attachlimit` = '0',
`pmquota` = '65535',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '204472319',
`genericoptions` = '22',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '4294967295',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '200',
`avatarmaxsize` = '4294967295',
`profileviewpermissions` = '15',
`userpagepermissions` = '0',
`imghost` = '3',
`imghostset` = '1024',
`imghost_width` = '1600',
`imghost_height` = '1200',
`imghost_files` = '1000',
`journalpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'userpagepermissions' in 'field list'
Error Number : 1054

:confused:



ALTER TABLE usergroup ADD userpagepermissions CHAR(15) NOT NULL;

Running that query should make the error go away by putting his column back.

[guv2000]

good hack ;)
i install and clicked install.
thnx ;)

[Andreas]

@Jesus likes Pie
It's actually not a Bug but working as designed.

The settings are cached, and this cache needs to be built once which isn't done by the installatin script as I expected the Admin to check/modify the settings anyway.
You don't have to turn it off and on again, just click Save.

Are there really people who don't take a look at the settings first? Strange ...

[Andreas]

ALTER TABLE usergroup ADD userpagepermissions CHAR(15) NOT NULL;

Running that query should make the error go away by putting his column back.
Adding a column to fix errors caused by a Hack that is not even being uses (anymore) does not make much sense, does it?

[???`S?LV?R???`]

@???`S?LV?R???`
It will work, but the installation does not work 100% if you are upgrading from a 3.0 installation. .

what if it's a fresh installation of it? any problems/issues? what about uninstallation?

[Andreas]

A fresh installation will not be affected, as well as uninstall.

[???`S?LV?R???`]

A fresh installation will not be affected, as well as uninstall.

Good to hear, alright well I got 3.5.0 Rc2 installed, will that be a problem at all?

[Andreas]

No. Should work just fine with RC2.
But one of the next Versions will require RC3 at least.

[???`S?LV?R???`]

No. Should work just fine with RC2.
But one of the next Versions will require RC3 at least.

thanks again, good to know, I was just holding off on the install of rc3 until gold came out since it would be easier, btw any time frame the newer version of the journal that will require atleast rc3 will be released?

[Andreas]

Nope, no ETA.

[ged]

It should, unless you uninstall it.
To be 100% safe, I'd suggest to backup your journals, journal_entries, journal_comments, journal_moods and journal_settings tables first.Ok, I will backup, but I have got some more questions, will it reinstall templates? I had to re-create my styles and vbJournal templates are missing on these new templates, will it do that? Second, will it publish all the journals as it did on 3.0.x?

[jesus likes pie]

@Jesus likes Pie
It's actually not a Bug but working as designed.

The settings are cached, and this cache needs to be built once which isn't done by the installatin script as I expected the Admin to check/modify the settings anyway.
You don't have to turn it off and on again, just click Save.

Are there really people who don't take a look at the settings first? Strange ...

kirby, I DID click save...it didnt do anything. I had to turn it off and on to make it work. Obviously I clicked save...who wouldn't.

[Andreas]

@ged
It will install all necessary Templates and all your existing Journalks will be available.

@jesus likes pie
I just tested a fresh installation - clicking save is enough.

[Brinnie]

Demo, anyone?

[Andreas]

Install it and you have a Demo :)

[jesus likes pie]

Demo, anyone?


http://ugforums.org/journal.php

Just one :P

[macshrine]

When I try to update the group permissions I get:

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 627

Running vB 3.5 RC3.

[kylek]

Anyone know what to do to uninstall this, need to try and start over as getting too many errors and problems. I know the issue of deleting comments will be fixed on the next version but I cannot even delete a journal of one of my members, get a syntax error. And have never had mood images, or any moods to edit, etc.
Is there an uninstaller?
What files are added to the database?
Are there supposed to be mood image files included in the download? Cant see any.

[Zelda-King]

There aren't any mood images. I just use the default vBulletin ones, personally.

As for uninstalling, have you tried simply doing it via the products manager in the dropdown?

[kylek]

There aren't any mood images. I just use the default vBulletin ones, personally.

As for uninstalling, have you tried simply doing it via the products manager in the dropdown?

Okay, brain dead right now, Forgot you can uninstall in the product manager's drop down, will give it a try.

[Andreas]

@macshrine
Did you upload the Bitfield XML before importing the Product XML?
Anyway, try admincp/index.php?do=buildbitfields

@kylek
Please note that you will lose all journals if you uninstall this.
Which errors exactly do you get where?
Just telling that you get errors is not that helpful in order to get them fixed.
There are no mood images included.

[Jason McConnell]

* Jason McConnell clicks install :D

Got some questions/suggestions though...

Besides using the moods, is there any way you could add a currently listening to/watching/playing textfield?

Are there any plans for displaying the Most Recently Submitted journals on forumhome or as a portal module?-- that'd be greaaaaaat :)

Possible a WOL location?

Totally a suggestion.... but I'd n00b-ify the install instructions. I'd imagine once this hack is out of Beta, there's going to be some vB admins who have no idea what a plugin is, much less realize that there are far less file and template edits than there used to be in 3.0.x versions.

Thanks for a killer hack :D

[john1744]

Kirby, I have a link to a image uploader. How would I go about adding the link to the add entry page with a brief explanation of the link...

Would this be an easy change?

[john1744]

NM I figured it out.

[Brinnie]

Install it and you have a Demo :)Lose the attitude or I will ban you..

[Brad]

Lose the attitude or I will ban you..

What attitude?

There is nothing saying you can't install this on a test forum if you wish to see exactly what this hack does, I assume you have one like most people who make modifications to their forums.

[john1744]

Ok, only problem I am seeing so far is the display order, it goes from oldest to newest, shouldn't the newest entries be on top?

[Andreas]

@Jason McConnell
There won't be any new features until this is stable enough.
Afterwards, WOL stuff as well as now listening/viewing is already planned.

[ged]

@ged
It will install all necessary Templates and all your existing Journalks will be available.

@jesus likes pie
I just tested a fresh installation - clicking save is enough.

Thanks a lot KirbyDE. :)

[Andreas]

Yes - check the navbar Template Edit as you must have edited it incorrectly :)

[GrendelKhan{TSU]

<< gk clicks install!! :D


ack!! phrases?? I want to update this for another language!! :(

[Andreas]

It's not yet fully phrased, but I am in the process of replacing all hardcoded Text with Phrases.
Will be fully phrased done in Beta 1 at least.

[GrendelKhan{TSU]

It's not yet fully phrased, but I am in the process of replacing all hardcoded Text with Phrases.
Will be fully phrased done in Beta 1 at least.

schwwwweet! :D thanks. that's a HUGE deal for many of us I would imagine.

great work so far though anyway. :)

[Paul M]

Oops ;

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
DELETE FROM journal_comments WHERE comment_id=;

MySQL Error : 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 '' at line 1
Error Number : 1064
Date : Wednesday, September 21st 2005 @ 12:11:44 AM
Script : http://www.xxxxx.xxx/board/journal.php?do=deletecom&com=21&j=4
Referrer : http://www.xxxxx.xxx/board/journal.php?do=showcomments&j=4
IP Address : <you wish>
Username : Paul M
Classname : vb_database

[Andreas]

<a href="http://bugs.kirbydemos.ath.cx/view.php?id=15" target="_blank">Known</a> and fixed already.
A new release should be ready today.

[DS MrSinister]

i am geting this when i edit vBJournal Premissions



Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class)core.php on line 627



any ideas on this one

I just upgrade my site from 3.0.8 to 3.5 rc 3

[Andreas]

Did you upload the Bitfield XML before you imported the Product XML?
Anyway, admincp/index.php?do=buildbitfields should fix the problem.

[DS MrSinister]

Did you upload the Bitfield XML before you imported the Product XML?
Anyway, admincp/index.php?do=buildbitfields should fix the problem.


thank you very much sir. workd like a charm.. one of these days i will get the hang of this stuff..

:banana:

[Paul M]

Did you upload the Bitfield XML before you imported the Product XML?Where does it tell you to do that ?

[Andreas]

* Andreas slaps Paul M around a bit with a large trout
You know exactly that Bitfield XMLs always have to be uploaded before product import ;)

[Paul M]

* KirbyDE slaps Paul M around a bit with a large trout

You know exactly that Bitfield XMLs always have to be uploaded before product import ;)* Paul M slaps KirbyDE back with a very large trout

Yes, that's not the point :p Not everyone who installs it will know .....

[Feckie (Roger)]

Any more slapping and u 2 will need to get a room............lol

[Andreas]

Updated. Details see first post.

[Jason McConnell]

So if we're upgrading, run the query, then do what with the original product xml? Delete it? Uninstall it? Or overwrite?

edit: n/m... uninstall deletes existing journals right? Unfortunately I had to uninstall, because I didn't set it to allow overwrite the first time I uploaded the XML.

[Andreas]

Yes, uninstall deletes existing data.
If you don't tick overwrite that's not a problem as it will just do nothing then.
Just do it again and make sure overwrite is ticked.

[FleaBag]

Latest version working on RC3 with no issues. Thanks for the update Kirby! :)

[Andreas]

Security Warning
A XSS Vulnerbilitie has been discovered in vB Journal Versions prior 1.0.2 Alpha 3.
In order to keep your site safe it is recommended to update immediately.

Fix for vB Journal 1.0.1 (vBulletin 3.0)
FIND

$reccom['coment_text']= htmlspecialchars_uni($reccom['comment_text']);


REPLACE

$reccom['comment_text']= htmlspecialchars_uni($reccom['comment_text']);

[Zelda-King]

Where is the code?

[Andreas]

Obviously journal.php ;)

[Zelda-King]

That's where I initially thought but I don't have that code.

[Andreas]

Fix for vB Journal 1.0.1 (vBulletin 3.0)


Are you using Version 1.0.1 on vBulletin 3.0.x?

[Zelda-King]

No, didn't realise the 3.0.X series was being discussed in the vB3.5 extensions forum. :D

Oops...

[Andreas]

I just included this in the warning as the 3.0 Version is also affected.
For vBulletin 3.5, just upgrade to the latest Version of this Hack.

[Zelda-King]

Good, I should be sorted then. :)

[Cyricx]

Is it just that one line in journal.php that is affected?

So to upgrade do we just need to upload the new journal.php or make the change in the email to correct the bug?

[Andreas]

Just overwrite the existing File if you are using the vBulletin 3.5 Version - or apply the fix if you are using the vBulletin 3.0 Version.

[Omega Prime]

Dunno if it's just me, but after the upgrade to the current build, I'm getting issues with a few users having blank comments. It shows their name and the time they made their comment, but that's about it :(

(Note that it can't be permission issues as I've already checked those)

[Andreas]

Hmm ... how can I reproduce this effect?

[Feckie (Roger)]

Economics is like jacks: If on the side before weakness down falls, the other one slams also on the ass.

So True

[Andreas]

@Omega Prime
Seems like you are using customized journal Templates.
Please revert them.

[Zelda-King]

I get the following SQL error when I try to edit Journal Buddies;

Invalid SQL:

SELECT userid, username FROM user
WHERE userid IN ()
ORDER BY username;

MySQL Error : 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 ')
ORDER BY username' at line 2
Error Number : 1064
(etc)
Classname : vb_database

Using latest version on vB3.5 RC3. Have not customised the journal in any way but have been upgrading it since about Alpha 1 Build 1.

[Zelda-King]

I thought I'd take the opportunity to show a few cosmetic issues I've come across where the system doesn't go seemlessly with my styles (see attachments).
1) Wrong text colour in dropdown.
2) USERCP_SHELL appears to be using the wrong Alt colour;

[Andreas]

As always, please report Bugs @ http://bugs.kirbydemos.ath.cx

Normally this can't happen.
Try
update usertextfield set jbuddylist='' where jbuddylist=' '

[Zelda-King]

Query done. "Affected Rows: 0". Actually I was a little apprehensive about posting on your bugtracker because I wasn't sure it was a bug. But I'll continue this there if you like.

[Andreas]

Hmm, then I don't know how this could happen.

Try editing Plugin vBJournal: Edit jBuddylist, change

if ($vbulletin->userinfo['jbuddylist'])


to


if (trim($vbulletin->userinfo['jbuddylist']))

[Zelda-King]

Still getting the same thing I'm afraid. I'll open the case on your bugtracker, but first I'll try uninstalling/reinstalling from scratch.

EDIT: Uninstalling results in this fatal error: Fatal error: Call to undefined function: fetch_table_info() in /home/root/to/plugin.php(994) : eval()'d code on line 10

So.. guess I'll have to make the thread after all.

[Andreas]

I really wanna know who wrote vB_Database_Alter ... that class doesn't really seem to fit with vB Code standards ;)

As for the buddylist problem: I can't reproduce this effect without intentionally putting corrupted data into the database. But even then the above code prevents the error.

You should also keep in mind that uninstalling deletes all existing journal data.

[HabboForum]

This looks good. Will it work on RC2 and are there any screenshots?

Thank you. :)

[Andreas]

Will not work on RC2.
Currently there are no screenshots, but you can take a look here (http://kirbydemos.ath.cx/forum/journal.php)

[Omega Prime]

@Omega Prime
Seems like you are using customized journal Templates.
Please revert them.

Templates have been reverted, but since they're not vB defaults, they're just erased. The reason why it seemed that I customized it was that I first added the journal back in Sept. 2004 and I guess they haven't been overwritten since the recent 3.5 port of the journal.

At any rate, it's as I noted before with some users showing up with blank comments, while others appear fine :ermm:

[ged]

Is there any fully-phrased version? My forum's language is not English, do I still have to translate them with editing templates?

[Oblivion Knight]

Is there any fully-phrased version? My forum's language is not English, do I still have to translate them with editing templates?Phrases will be done later, this is still in an early beta phase.. ;)

[Andreas]

@Omega Prime
With this 3.5 Version, the Templates are "vB Default", eg in the Master Style.
So as long as you are not operating in Debug Mode you can't delete them.
If they are really deleted (which should, as said, not be possible) you can simply re-import the XML to get them back.
The commetns show up blank simply because they are blank.

@ged
Currently we are in Alpha-Phase (that means pre-Beta).
When this Hack reaches Release Candidate Phase it will be fully phrased.

[rickycc]

newbie question... How do I install VBjournal on 3.5 with cmps 2.0?
thanks,

[Omega Prime]

@Omega Prime
With this 3.5 Version, the Templates are "vB Default", eg in the Master Style.
So as long as you are not operating in Debug Mode you can't delete them.
If they are really deleted (which should, as said, not be possible) you can simply re-import the XML to get them back.
The commetns show up blank simply because they are blank.


I'm a bit late in replying, but yes.. it was indeed the templates from the other styles which I hadn't reverted since using the journal a year ago ;)

[Mayers]

After upgrading to 3.5 gold the settings seem to have been removed. How do I go about adding the settings back so the journal page can be accessed again?

[Rukas]

Im going to update my forum to vB3.5 and then install this; will all the old journal users and entries still work?

[Andreas]

After upgrading to 3.5 gold the settings seem to have been removed. How do I go about adding the settings back so the journal page can be accessed again?
Can't be as the journal settigns are in it's own table.

[Mayers]

Can't be as the journal settigns are in it's own table.

No I mean as far as the permissions and links in the admin cp go.

[Andreas]

Permissions should stay as they were, also the ACP Navigation should stay.

[Mayers]

That's odd because they didn't stay. The plugins still shows, but the nav other stuff didn't.

[Andreas]

You removed the cpnav and bitfield xml files by any chance?

[Mayers]

That very well could be it, I forgot to copy that to the new folder. I'll try that when I get home. Thanks.

[MissKalunji]

You removed the cpnav and bitfield xml files by any chance?


Flawless thank you!!

[plubius]

After doing a fresh install of vbulletin 3.5.0 Gold I installed this hack. I also get nothing in the admin cp as well as nothing in the usergroup settings. I tried to uninstall via the product manager and I get this error:

Fatal error: Call to undefined function: fetch_table_info() in /home/zgozsaxu/public_html/forum/admincp/plugin.php(1025) : eval()'d code on line 10

[plubius]

After doing a fresh install of vbulletin 3.5.0 Gold I installed this hack. I also get nothing in the admin cp as well as nothing in the usergroup settings. I tried to uninstall via the product manager and I get this error:

Fatal error: Call to undefined function: fetch_table_info() in /home/zgozsaxu/public_html/forum/admincp/plugin.php(1025) : eval()'d code on line 10


Disregard this post. My bleddy ftp is a piece of steamin crap. Did not transfer the xml files above.

[JJR512]

Any idea on about when this might go beta or gold?

[Sinistra]

error in admin CP donno if this will work on Final but

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

[Andreas]

You did not upload the bitfield XML before importing the product XML.

[VaaKo]

will this piece of art work on 3.5 Gold? or is it just for RC3?
can you show use some screenshots please?

[.Tim]

Yes, it works on gold.

[Dream]

are there screenshots or a demo anywhere

[Sinistra]

You did not upload the bitfield XML before importing the product XML.
Ah that fixed it thanks ^_^

[Andreas]

@Dream
http://kirbydemos.ath.cx/forum/journal.php

[MissKalunji]

im running gold too : www.dancehallareaz.com/forum/journal.php

[VaaKo]

you might wanna change the version of it
and make it officialy 3.5 compatible
good work

[Andreas]

Why should I change the Version if nothing has changed?

[VaaKo]

@Dream
http://kirbydemos.ath.cx/forum/journal.php
I went there
it gave me "done but with errors"

"require_click" is undefined

[Andreas]

Where exactly (URL) did you get this error?

[VaaKo]

<a href="http://kirbydemos.ath.cx/forum/journal.php?do=showjournal&j=2" target="_blank">http://kirbydemos.ath.cx/forum/journ...howjournal&j=2</a> (The Journal of Oblivion)

[Andreas]

I C. That was the editor JS trying to init, although there was no editor (as guests can't comment).
Should be fixed now.

[VaaKo]

is it alpha 3 or 4?
when I imported the xml file it said: 1.0.2 Alpha 3

[Rukas]

I had the journal installed for 3.0.x, I then updated to 3.5 and of course the old journal doesnt work anymore. When I install this version of the journal, will all the old journals and entries return or will it be a fresh install?

[WNxWakko]

What is this mod?? He makes no comments of its description or any screenshots.

[Andreas]

@Lebanese Forces
Alpha 3

@Rukas
If you did not drop the old data it should be there

@WNxWakko
A Journal/Blog Hack :)

[Cloud-Warrior]

Can you include the RSS 1.0 bit I made for vBJournal 1.0.0/vB 3.0.x?

(That is if it isn't there already.)

https://vborg.vbsupport.ru/showpost.php?p=564200&postcount=384

[T3MEDIA]

Can you include the RSS 1.0 bit I made for vBJournal 1.0.0/vB 3.0.x?

(That is if it isn't there already.)

https://vborg.vbsupport.ru/showpost.php?p=564200&postcount=384Awsome request C.W. I was waiting for someone to request it...
Here are the reasons why...
http://www.google.com/help/about_blogsearch.html

[restless]

apologies if this was covered, but i can't find it....

possiblity of using the WYSIWYG Editor? my users have always clamoured for this journal feature.

[restless]

oh, also... would LOVE to have the option of importing a users LiveJournal RSS feed.


finally... thank you VERY much for updating this system for us.

[dethfire]

Is there a way to get like the top ten more recent entries on a right bar on the main forum page?

[Sinistra]

How would I go about putting the latest entry on the first page of the journal

[Guest190829]

Nice Job Kirby, have been testing this and it's really good. I will install when in the future when I need it for my live site if v2 isn't out by then...

[Andreas]

apologies if this was covered, but i can't find it....

possiblity of using the WYSIWYG Editor? my users have always clamoured for this journal feature.
It's already possible for adding comments and entries, the other parts will be updated as well soon.

[PixelFx]

It's already possible for adding comments and entries, the other parts will be updated as well soon.

is this safe for me to add to vb3.5 gold or should I wait for version update? :) thanks for the hard work on this ..

[akanevsky]

Screenshot please.

[thenetbox]

Working great :D

[thenetbox]

Hi

Is there a way to allow image uploads/attachments with a post?

[The Geek]

Sweet! Installed and loving it.

[The Geek]

Sweet! Installed and loving it.

er. The copyrights looking like its been on steroids. Any way I can shrink it and move it down to the site copyright? Its a bit freaky and massive there.

Great work though. My users are loving it already

[Faden]

Excellent hack, thanks very much, installed however I do have a slight problem, I am unable to find the VB Journal options in the ACP, it's simply not there, any help?

Cheers again =]

Edit: Problem solved, I created a journal entry and its appeared, once again thanks for the hack :)

[Andreas]

Screenshot please.
Request rejected.

[???`S?LV?R???`]

Request rejected.

lol, just like mine that never got answered :ermm:

[kafi]

Is it possible to include journals to vb search?

Once somebody will search in my forum I want them to see that questions are answerd also in journals...

[Bahawolf2]

In an attempt to uninstall vBJournal.. I recieved the following error:

Fatal error: Call to undefined function: fetch_table_info() in /home/gcncx/domains/forum.gcn.cx/public_html/admincp/plugin.php(1025) : eval()'d code on line 10

Uninstalling other products has worked fine and this error has only occured so far with this product.

[Andreas]

lol, just like mine that never got answered :ermm:
Which request?

@bahawolf2
It's a Bug in the installation Code, will be fixed in the next Version.

[Oblivion Knight]

@bahawolf2
It's a Bug in the installation Code, will be fixed in the next Version.Any news on the next version.? ;)

[scabbed]

hello kirby, nice hack

just a question, what you mean by Import product-journalhack.xml, i'm a noob

help me please :)

[eNforce]

In an attempt to uninstall vBJournal.. I recieved the following error:

Fatal error: Call to undefined function: fetch_table_info() in /home/gcncx/domains/forum.gcn.cx/public_html/admincp/plugin.php(1025) : eval()'d code on line 10

Uninstalling other products has worked fine and this error has only occured so far with this product.

I'm having the same problem :ermm:

[sensimilla]

worked just fine :) i just uploaded the files and imported the xml
no file edits were needed , thanks alot

[rickycc]

Where is the xml plugin file?

[bfd21]

This probably isn't the right thread for this but!!

Can someone tell me how to include HTML in journal entries?

Also is it possible to display journal entries as threads in the forum home.

I apologize if this isn;t the proper place, if not can someone point me in the right direction. A search provided no help

Thank You

[Mayers]

I'm getting the allowing error when trying to edit journal permissions in usergroups.

[qoute]
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635[/quote]

I filed a bug report and Mike Sullivan said it was coming from vBJournal.

Details can be found here

http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=1479

How can I go about fixing this?

[Guest190829]

Make sure you upload all files before importing the product, that's why the error is occuring.

[Andreas]

As always:
Bitfield XML Files must be uploaded before Product XMLs are imported, otherwise the Bitfield Cache will not be rebuilt which causes such errors.

Fix
admincp/index.php?do=buildbitfields

[DivisionByZero]

great hack! installed

[dethfire]

great hack! installed

any way to get the five more recent journal entries on a right side bar on the homepage?

[theArchitect]

@john1744
There won't be any new features until this is stable (eg. out of Alpha/Beta and RC State).

Is a stable version on the horizon?

No rush. But I would like to get it running on my board and prefer not to install beta versions of things. Call me fussy, but hey.

[The Geek]

Ive been running this for the past week on www.thenailgeek.com and aside from some cosmetic issues (think the comments positioning is odd) - I cant say that I have seen so much as a peep from a bug.

Maybe I havent driven it into the ground, but theres at least 20 or so Journals with multiple entries and comments.

Oh wait, I did find a bug. I get a broken image next to the title bar when making an entry. I havent been able to be bothered enough to hunt down the root of it yet. An obvious show stopper (not!) ;)

Anyhooo - my heart goes out to those having problems, but Its running pretty sweet here and I recommend it.

[MissKalunji]

Ive been running this for the past week on www.thenailgeek.com and aside from some cosmetic issues (think the comments positioning is odd) - I cant say that I have seen so much as a peep from a bug.

Maybe I havent driven it into the ground, but theres at least 20 or so Journals with multiple entries and comments.

Oh wait, I did find a bug. I get a broken image next to the title bar when making an entry. I havent been able to be bothered enough to hunt down the root of it yet. An obvious show stopper (not!) ;)

Anyhooo - my heart goes out to those having problems, but Its running pretty sweet here and I recommend it.

i second that

[Mr Chad]

Thank you you're my hero! *clicks install*

No more manually adding templates!

Great ^^

[mindfrost82]

Why doesn't this work with older versions of MySQL? Like 3.23? I looked through these threads, but didn't see anything.

[Guest190829]

Why doesn't this work with older versions of MySQL? Like 3.23? I looked through these threads, but didn't see anything.

I'm guessing some syntax in the code is not backwards compatible with old versions of mysql.

[Andreas]

It does work with mySQL 3.23 - just the install code will fail as it uses multi-table updates.
If you are doing a fresh install or you are upgrading an installation that does not have private netries/journals you don't have to worry about that.

[mindfrost82]

Thanks.

*Clicks Install*

[MissKalunji]

where do i get the mood images?

[BLazeD1]

I get this error under my Journal:

Uncached templates: showthread_quickreply (1)

Any ideas?

[Oblivion Knight]

I get this error under my Journal:

Uncached templates: showthread_quickreply (1)

Any ideas?This is fixed in the next version. :)


However, if you want to fix this yourself - in journal.php find:
'journal_top_rated',
'journal_toppage'Replace that with:
'journal_top_rated',
'journal_toppage',
'showthread_quickreply'

[kewl1uk]

Has the zip file been updated? I just downloaded it and I've got Alpha 1.

Edit: No I didn't. I got Alpha 3. It's just the version at the bottom of the journals page that says Alpha 1.

[kewl1uk]

When starting a new journal the title is not saved and the link to the journal is xxxxxx's journal. But a title can be saved through Journal Options > Edit Journal Info.

[Oblivion Knight]

It's just the version at the bottom of the journals page that says Alpha 1.Yeah, the version number in the phrase wasn't updated.

[Zelda-King]

Mine is working on Gold, though if a title/comment/entry window is left blank and you try to submit the message, there is a blank error.

[MissKalunji]

where do i get the mood images?

anyone?

[Zelda-King]

You could try vb.org's Smiley Sets section. :)

[MissKalunji]

You could try vb.org's Smiley Sets section. :)

oh good idea i thought it came in it thanks :)

[Omega Prime]

Not sure if this has been noted here, but I've noticed that entries with quotes appear as quot; , so I'm not sure what's causing that.

[Antiblank]

I'm trying to test out the privacy feature of this hack, with the use of the Journal Buddies.

The problem I'm facing is when I click the link on journal.php to "Show Journal Buddies" it tells me:

You do not have any journal buddies.
Click here to edit your journal buddies.

So I click an it brings me to the Buddy List manager on my profile page for vB. I add in the people I'm testing with, click to update my list, go back to the journal and it still shows me that I have no journal buddies.

Is there something I'm missing here?

[BLazeD1]

This is fixed in the next version. :)


However, if you want to fix this yourself - in journal.php find:
'journal_top_rated',
'journal_toppage'Replace that with:
'journal_top_rated',
'journal_toppage',
'showthread_quickreply'


Cheers for that!

I am also wondering if there is a way to show in a users postbit, if they have a journal going, a link to the journal?

Cheers!

[Jason McConnell]

Cheers for that!

I am also wondering if there is a way to show in a users postbit, if they have a journal going, a link to the journal?

Cheers!

Maybe even an icon indicating a new journal entry... ;) What I was wondering is if anyone had replicated the Latest Entries table for use on a Portal or on Forumhome?

[Schwartz12]

I'm getting a no permission when I run journal.php

I haven't updated the templates but should that matter?

I just want to play around with it first before releasing to my members.

Any idea why?

Running on 3.5 gold, newly installed.

[Andreas]

When starting a new journal the title is not saved and the link to the journal is xxxxxx's journal. But a title can be saved through Journal Options > Edit Journal Info.
Confirmed. Please report it as a Bug.

Mine is working on Gold, though if a title/comment/entry window is left blank and you try to submit the message, there is a blank error.
I don't understand this report.
What exactly is empty/blank? (Screenshot?)

Not sure if this has been noted here, but I've noticed that entries with quotes appear as quot; , so I'm not sure what's causing that.
I can't reproduce this, works fine for me.
http://kirbydemos.ath.cx/forum/journal.php?do=showjournal&j=3


I am also wondering if there is a way to show in a users postbit, if they have a journal going, a link to the journal?

It's there already in the Popup.

@Schwartz12
Check your permissions