4images Gallery 1.7

A lot of people, both here and at 4homepages.de have been requesting for a mod/hack that would integrate vBulletin 3 RCX with 4images 1.7 lately. The solutions are scattered around the forums, but nobody has it all in one page.

So I've decided put them all togather, and release it, so it will be easier for people to do the intigration successfully.

Please note that all the codes in this hack/mod are property of Jan and mtha.
http://www.4homepages.de/forum/viewtopic.php?t=1659
http://www.4homepages.de/forum/viewt...tart=165#32514

I have tested this on vBulletin 3.0.0 RC3 and it worked successfully.

Features:

• Uses your existing vBulletin powered forum's login account for authentication.
• Uses your existing vBulletin powered forum's whos online feature
• Can be modified to display any information from your existing vBulletin database, perticularly from the "user" table, which means you can display any information about the logged in user.
• Since it is integrated with the database, you can display any gallery information such as latest picture, how many pictures a member have submitted etc... on your vBulletin powered forum.
• Extra modifications can be found here

Screenshot:
Attached

Demo:
http://www.randomforum.com/forums/gallery *NEW
(Please note the gallery sports a custom style, not the default)
http://www.vb-es.com/galeria/ (Non-English)

[mtha]

Originally Posted by vBFreak

hmmm yes, worked without any problems

hmmm couldn't the problem with the email-field be, that the user is hiding his mailadress?

I wanted to test this, but it seems that in vB3 the mailaddress is hidden by default, I couldn't find an option in my profile settings like it was in vB 2 for this...

This option is combined in value "options" in vB's userfield table. You need to de-compile the value, in order to get this showemail value.
I'm not interested in showing email nor showing useronline in album, so I cant help you right now.

That's my code now, I had to change the paths a bit, because my forums are in /, is there an error now?

is this a question of an answer?

[mtha]

FIX to SHOW MEMBERS who are browsing album to show in forum's whoisonline page

in album's sessions.php

FIND

PHP Code:

 $sql = "UPDATE ".SESSIONS_TABLE." 
SET lastactivity = $this->current_time 
WHERE sessionhash = '$this->session_id' 
AND host = '$this->user_ip'"; 


REPLACE BY

PHP Code:

    $sql = "UPDATE ".SESSIONS_TABLE." 
            SET lastactivity = $this->current_time, location = '$this->user_location'
            WHERE sessionhash = '$this->session_id' 
            AND host = '$this->user_ip'"; 


[vBFreak]

where can I add this then to my Who's online list? It shows only that the user is on the forums-index...

[mtha]

Originally Posted by vBFreak

where can I add this then to my Who's online list? It shows only that the user is on the forums-index...

add in album's sessions.php

it should show in your FORUM's who's online list. open your who'sonline list, then open another windows, browse to your album to test.


btw, check your sessions.php and see if you have this part correct

function Session() {
global $cookietimeout;
$this->session_timeout = $cookietimeout;
$this->user_ip = $this->get_user_ip();
$this->user_location = '/album/'.$this->get_user_location();
$this->current_time = time();
$this->demand_session();


change /album/ to what it should be in your case

[CreedFeed]

For those of you having problems with this script, download the zip file here:

https://vborg.vbsupport.ru/showpost....&postcount=161

and follow the instructions one by one. It is very easy and works perfectly with vb3.0.1 and 4Images 1.7

I've run into ZERO bugs with this. Everything works perfectly.

[mtha]

Well, after the whole bunch of changes and fixes, I decided to re-release this integration, which would work for vB 3.0.1, giving as much support as I can.
Hope MatrixGL wouldnt mind. (if you do, then update your first post, and let me know, I will delete the other )

https://vborg.vbsupport.ru/showthread.php?t=66335

[BlackxRam]

Check that, its nto working now, whenever i close my browser i am logged off 4images. Anything?

[mtha]

Here's the UPDATED version. I CANNOT support an out_of_date version.

https://vborg.vbsupport.ru/showthread.php?t=66335

[mrcancel]

When i integration 4images with vbulletin , i have a error :

DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM user WHERE user_id <> 0
Unknown column 'user_id' in 'where clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.username FROM music_images i, music_categories c LEFT JOIN user u ON (u.userid = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY DESC LIMIT 1
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 'DESC LIMIT 1' at line 5

[mtha]

Originally Posted by mrcancel

When i integration 4images with vbulletin , i have a error :

DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM user WHERE user_id <> 0
Unknown column 'user_id' in 'where clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.username FROM music_images i, music_categories c LEFT JOIN user u ON (u.userid = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY DESC LIMIT 1
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 'DESC LIMIT 1' at line 5

from the error, you DID NOT setup field names for user table right. You may have installed an OUT OF DATE version of this integration.

Here is my post right above yours, I hope you dont mind reading it again:

Here's the UPDATED version. I CANNOT support an out_of_date version.

https://vborg.vbsupport.ru/showthread.php?t=66335