4images Gallery 1.7 + vB 3.0.x (update Oct 30)

Since Matrixgl didnt give much update over his post, so I make this release, with all the changes:
https://vborg.vbsupport.ru/showthread.php?t=62020
Original copyright go to 4images owner Jan Sorgalla

=============================================
Integration 4images 1.7 / vBulletin 3.0.x
=============================================
Copyright: (C) 2002 Jan Sorgalla
Integration to vBulletin 2.x by Jan
Integration to vBulletin 3.0.1 by mtha
Constribution:
Matrixgl for re-organize the hack
d1635d for adding the fix for 3.0.1
all others for comments and suggestions

Hack version: 3.0.1.0625
Compatible vB version: 3.0.1, 3.0.2, 3.0.3. other versions might need minor modifications

FOR integration with vB 3.5.0, check this thread:
https://vborg.vbsupport.ru/showthread.php?t=98640

=============================================
Features:
=============================================
- Use vBulletin's user table instead of 4images.
- Forum's members can access and upload pictures (depends on permissions)
- Forum's admin can administrate the album (unless you do the EXTRA part)
- Display Who is browsing album, in the Forum's WhoisOnline list


=============================================
Changes and modifications
=============================================
4images template to change: 1 (user_loginform.html)
4images file to replace: 1 (sessions.php)
4images file to edit: 3
admin/admin_global.php
includes/constants.php
includes/page_header.php
vBulletin file to edit: 2
forums/includes/functions.php
includes/functions_online.php
Query to run: 0
If you do EXTRA part, there're few queries to run, depends on what you want to do.
=============================================
Requirements:
=============================================
- vBulletin 3.0.x installed and working
- 4images 1.7 fresh installed and working
- 4images and vBulletin are installed to use the SAME database
=============================================
Limitations:
=============================================
- The "Remember username/password?" options only remember sessions for forum. (FIXED 06/22/04 - see update)

- This hack use default usergroup for album level, there're only4levels of Guest, User awaiting, User, Admin. See Extra section attheend for solution
- I didnt look at the "cooke path" and "cookie domain" yet, so it will use the default

Screenshot (thanks to MatrixGL):
https://vborg.vbsupport.ru/attachmen...chmentid=17021

Demo (thanks to MatrixGL):
http://www.randomforum.com/forums/gallery/

NOTE:
You may want to edit your template, in order to have the forum's look and feel .


Previous discussions:
https://vborg.vbsupport.ru/showthread.php?t=62020
http://www.4homepages.de/forum/viewtopic.php?t=10823


Dont forget to click

Update 03/24/2005
If you get error loging out of album:
in page_header.php, line 110

replace

PHP Code:

"url_logout" => (!empty($url_logout)) ? $site_sess->url($url_logout) : $site_sess->url(ROOT_PATH."logout.php"), 


by

PHP Code:

"url_logout" =>(!empty($url_logout))?$site_sess->url($url_logout):$site_sess->url($url_app."login.php?do=logout&u=$user_info[user_id]"), 


Update 10/30/2004
Since meny people have problem with vB usergroup, I've add Usergroups arrays,
Now you can set multiple custom user groups to be USER, USER_WAITING, or ADMIN
By default:

$waitinggroups = array(3, 4); // vB Group should be waiting for moderate. seperate each group by comma
$usergroups = array(2, 7); // Groups that are USERS in album. seperate each group by comma
$admingroups = array(6); // vB groups that are ADMINS in album. seperate each group by comma

Update 10/20/2004
Sincemeny people ignore to config the "VB_TABLE_PREFIX" inconfiguration,I've pull all the prefix into one place, and make STRONGrequest tocheck this one.
If your album works fine, you dont have to update your files.
If you do want to apply the changes, here's where you can check:

constants.php
define('VB_TABLE_PREFIX',''); // your vb tableprefix. vB default is blank
define('SESSIONS_TABLE', VB_TABLE_PREFIX.'session');
define('USERS_TABLE', VB_TABLE_PREFIX.'user');

sessions.php
define('VB_TEMPLATE_TABLE', VB_TABLE_PREFIX.'template');

Update 06/25/2004
Clean up some codes, add some more instructions. Adding constants for Cookie prefix, cookie timeout, album folder ...
If your album works fine, you dont have to update your files.
If you do want to ... work again, just follow all the steps


Update 06/22/04
IF you have "Remember username/password?" problem with album (Album session dont remember your logged in if you go directly to album - installed before 06/22/04)

Edit the attached sessions.php, and replace the VBLICENCE_NUMBER, and upload to your album/include/sessions.php

OR

Manually edit:

In 4images sessions.php

Look for

PHP Code:

 if ($this->read_cookie_data("bbpassword")==$this->user_info['user_password']&&$this->user_info['user_level'] > USER_AWAITING) { 


replace by

PHP Code:

 if ($this->read_cookie_data("bbpassword")==md5($this->user_info['user_password']. 'XXXXXX')&&$this->user_info['user_level'] != USER_AWAITING) { 


CHANGE XXXXXX with your Licence Number, located on top of any of your vB file

NOTE: for those runing into table doesnt exist problem, check your VB_TABLE_PREFIX variable

Table '4images.template' doesn't exist
DB Error: Bad SQL Query: SELECT sessionhash FROM session
Table '4images.session' doesn't exist

[Koutaru]

Originally Posted by mtha

could be something wrong with :login: box or login variable.

Check the template user_loginform.html and login variable in sessions.php file.

I dont have any idea why you get that error yet (unless you did something wrong with your files)


should be posible, but I actually dont use default vB groups, I create another field in their profile for this purpose.



edit template

Look at header and footer template

Hmm but editing the HTML won't do anything if I have conditionals included in the HTML that only work for vbulletin (trust me I've tried and it screws up) Plus the phrases..

Is there something I'm doing wrong? ?_?

[sasjamal]

I am getting some error messages...

DB Error: Bad SQL Query: SELECT template FROM template WHERE title='options'
Table 'gallery.template' doesn't exist

DB Error: Bad SQL Query: SELECT sessionhash, lastactivity, host, userid FROM session WHERE sessionhash = '306bbfc285210bfca0d84486f0fc0145' AND host = '65.60.139.107'
Table 'gallery.session' doesn't exist

DB Error: Bad SQL Query: SELECT sessionhash FROM session
Table 'gallery.session' doesn't exist

DB Error: Bad SQL Query: SELECT u.*, l.* FROM user u, 4images_lightboxes l WHERE u.userid = 142 AND l.user_id = u.userid
Table 'gallery.user' doesn't exist

DB Error: Bad SQL Query: SELECT * FROM user WHERE userid = 142
Table 'gallery.user' doesn't exist

DB Error: Bad SQL Query: SELECT sessionhash FROM session WHERE sessionhash = '952382793777ad4cc61475519bcf7167'
Table 'gallery.session' doesn't exist

DB Error: Bad SQL Query: INSERT INTO session (sessionhash, userid, host, useragent, lastactivity, location, styleid) VALUES ('952382793777ad4cc61475519bcf7167', 1, '65.60.139.107', 'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)', 1090117656, '/gallery/index.php', '0')
Table 'gallery.session' doesn't exist

DB Error: Bad SQL Query: SELECT s.userid, s.lastactivity, s.host, u.userid, u.usergroupid, u.username FROM session s LEFT JOIN user u ON (u.userid = s.userid) WHERE s.lastactivity >= 1090115856 ORDER BY u.userid ASC, s.host ASC
Table 'gallery.session' doesn't exist

DB Error: Bad SQL Query: SELECT DISTINCT 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 4images_images i, 4images_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 RAND()
Table 'gallery.user' doesn't exist

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 4images_images i, 4images_categories c LEFT JOIN user u ON (u.userid = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0) ORDER BY i.image_date DESC LIMIT 3
Table 'gallery.user' doesn't exist

[Koutaru]

It seems like the tables aren't there in your database. I'm guessing your database name is gallery? It should be the name of your vbulletin database

[sasjamal]

my 4images databse name is gallery

should i be using the same db?

Also, i ma using vb 3.0.3 if that makes a difference.

[sasjamal]

uh, im an idiot im suppose to use same db lol

[redlabour]

So i see 3.0.3 is not a problem with this Hack ?

[KTBleeding]

Originally Posted by redlabour

So i see 3.0.3 is not a problem with this Hack ?

So far so good..
Granted, I've only upgraded to 3.0.3 a couple hours ago.

[Tailfeathers]

Originally Posted by mtha

There is NO automatic and safe way to do this, BUT you can try this method (require that you know enough php and SQL in order to do the job)


What you have are:
01 - vB user database with USERSET1 controled by userid (and username), says user.userid and user.username
02 - Album user database with USERSET2, controlled by user_id (and user_name) says 4images_users.user_id and 4images_users.user_name


Step 1:
- Create a new COMPARE table having 3 fields: username, forum_uid, album_uid

Step 2:
- Compare 4images_users.user_name and user.username
if match => fill in the COMPARE table (username, forum_uid, album_uid) for this user.
if not => fillin COMPARE table, with album's username, album_uid, DEFAULTID where DEFAULTID is the ID given for those who does NOT have account in forum or have different username in forum. If you want to assign this to be GUEST, the ID is 0

Do this for ALL ALBUM users

=> you know the id in forum and album for each album user

(if they have the SAME username for both places. if you think email address would be more appropriate, you can compare email instead, or compare both username and email)

Step 3:
Change user_id in album to the new forum's userid based on the above comparision, in the following tables:
4images_comments, 4images_groupmatch, 4images_images, 4images_images_temp, 4images_lightboxes, 4images_users

Step 4:
Test your album and see if everything works correctly (username, login/logout, image's poster)

Step 5: Apply this hack ... and god bless you


good luck.

PS. this will require alot of changes to your database, so Do a FULL BACKUP of your album database first (maybe your files too), and test in a beta version

Finally went to do this and chickened out, lol. Too worried. Maybe someday, it'd be possible to make this an automatic php install thingy or something. I'd probably destroy both my board and gallery trying to do this, hehe...

For now, people will just have to register at both separately, I guess!

[mtha]

Hmm but editing the HTML won't do anything if I have conditionals included in the HTML that only work for vbulletin (trust me I've tried and it screws up) Plus the phrases..

Is there something I'm doing wrong? ?_?

then try to convert to html-understandable header. it's easier and less troublesome than doing anonther script.

if you have conditionals that only work for vBulletin, then you did know it ONLY works for vBulletin, didnt you :> well, my suggestion is, find some similar things in 4images and use it, or simplify the conditions.

Originally Posted by Tailfeathers

Finally went to do this and chickened out, lol. Too worried. Maybe someday, it'd be possible to make this an automatic php install thingy or something. I'd probably destroy both my board and gallery trying to do this, hehe...

For now, people will just have to register at both separately, I guess!

:P I did migrate my album once, (I used another album script), and ... well I accept to remove all album users, and change posters to ... me. it's better to use one user database in one system tho :>

[romanticyao]

hello

i m using vb3.03 and i m having problem with this interantion

I followed all the steps and it was fine untill i changed cookie timeout in 4images to 0 right after the installtion, i was logged out as admin and never have any chance to login again...

i m still being able to login my forum, but when i logout i get a error ask me to click the link again to logout.

i tried to login using a registered member "demo", 4images logged demo into the system and it worked. however after i click logout, i get the same error message. after logout, cookie for demo at forum was cleared but demo still logged into 4image... so i cleared all the cookie in my IE(also checked folder to make sure none of the cookies left) open up IE again and i m still logge in as demo in 4image.

i have my forum and 4images both running on different subdomains...

please help!