vBJournal for vBulletin 3.5

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.

[Andreas]

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

[Omega Prime]

Originally Posted by 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]

Originally Posted by KirbyDE

@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]

Originally Posted by KirbyDE

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:

PHP 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_successfully'); 


it should be:

PHP Code:

$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_successfully'); 


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.