Integration 4images 1.7 / vBulletin 2.x

[Koutaru]

worked great on a clean install of 4images!

[Surfer]

Hi,

I have a few questions...

Will this integration hack become a standard feature of 4images?

Your installation note says that 4images and vBulletin tables must be in the same database. Is it possible to modify this mod so that I can use a seperate database for 4images?

If I install this mod, will I be able to upgrade to future versions of 4images?

thanks

[Jan]

Will this integration hack become a standard feature of 4images?

No

Your installation note says that 4images and vBulletin tables must be in the same database. Is it possible to modify this mod so that I can use a seperate database for 4images?

Sure, if you have a little bit knowledge of PHP.

If I install this mod, will I be able to upgrade to future versions of 4images?

I hope so...

[Surfer]

Sure, if you have a little bit knowledge of PHP.

Thanks for your reply!

Could you give me some advice on where to start to enable two seperate databases?

Is this integration officially supported? i.e. will you release future version of the integration code for new version of 4images?

Thanks

[Jan]

You should create a new db object, i.e. (global.php)

Code: [Select]

$site_db_vb = new Db('<host_vb>', '<user_vb>', '<pass_vb'>, '<dbname_vb>');
And change $site_db to $site_db_vb wherever something is read fom the session or user database table.

Jan

[Surfer]

Thanks I will use your method!

Is changing $site_db to $site_db_vb only required in session.php? or are there other files as well?

Thanks

[Jan]

Session values are read only in session.php. But user data is read in many other files as well. Maybe you have to split some queries because the query joins for example the comment, image and user table.

Jan

[silver_2000]

Jan

 This is a GREAT product.. I have been using it for some time...

I just upgraded to VB3 beta and am getting erros at the top of the pages

Code: [Select]

DB Error: Bad SQL Query: SELECT s.userid, s.lastactivity, s.host, u.userid, u.usergroupid, u.username, u.invisible FROM session s LEFT JOIN user u ON (u.userid = s.userid) WHERE s.lastactivity >= 1055640484 ORDER BY u.userid ASC, s.host ASC
Unknown column 'u.invisible' in 'field list'

diff error

Code: [Select]

DB Error: Bad SQL Query: SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date, u.usergroupid, u.username, u.email, u.showemail, u.invisible, u.joindate, u.lastactivity, u.homepage, u.icq FROM 4images_comments c LEFT JOIN user u ON (u.userid = c.user_id) WHERE c.image_id = 47 ORDER BY c.comment_date ASC
Unknown column 'u.showemail' in 'field list'


I know its a beta and its brand new...  I just thought I would give you a heads up.  

The 4images is here if you want to look http://www.talonclub.com/4images/index.php

GOOD news is the gallery is still up just slowed down some and pops the error

Thanks in advance
Doug

[Jan]

As you can see in the thread title, the integration is written for vBulletin 2.x. It seems that it needs some modifications for 3.x.  I haven't used vBulletin 3,  so i can't help you...

Jan

[silver_2000]

As you can see in the thread title, the integration is written for vBulletin 2.x. It seems that it needs some modifications for 3.x.  I haven't used vBulletin 3,  so i can't help you...

Jan

Any Plans to do an integration for VB3 ?
If not can you give me a heads up where to look for the fileds missing in the queries ?  Since they dontaffect the display of the pictures perhaps I caqn just remove the queries from the code...

THanks in advance
Doug

[Jan]

No, sorry. As i wrote above, i have no copy of vBulletin 3 and can't help you. Just removing the queries from the code will not work...


Jan

[Hac Nho]

As you can see in the thread title, the integration is written for vBulletin 2.x. It seems that it needs some modifications for 3.x.  I haven't used vBulletin 3,  so i can't help you...

Jan

it shouldnt be too hard, as the way it was for vb2x integration. I will give it a shot when I get back home .

Will let you know the result.

[ashzqo]

I just wanna know how to Integrate 4images 1.7.1 with vBulletin 3.x  : please help me with this.

[dopegirlfresh]

I have 3.0.7- lookin to add 4images... any news?

[Hac Nho]

I just wanna know how to Integrate 4images 1.7.1 with vBulletin 3.x  : please help me with this.

This might be what you are looking for.

http://www.vbulletin.org/forum/showthread.php?t=66335


still need some more bugfix, but it worked fine with 1.7