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.

[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
[sql]update usertextfield set jbuddylist='' where jbuddylist=' '[/sql]

[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

PHP Code:

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


to

PHP Code:

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

[Omega Prime]

Originally Posted by KirbyDE

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