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

[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!

[romanticyao]

nevermind problem sloved for no reason...thank you anyways..

[clio]

Should we be posting here or on 4images website?

Anyhow, I had a redirection problem with the login form from the 4images site. For some reason, it would redirect to my domains index page instead of the gallery, so in user_loginform.html:

I took:

<input type="hidden" name="url" value="{self_full}" />

and replaced it with:

<input type="hidden" name="url" value="http://www.mydomain.com/path/to/my/4images/folder/" />

Before I did that it was redirecting to: http://www.mydomain.com./index.php?

Any idea why? And YES, I bolded the period after the domain. Cause that's what it says. My guess is that the {self_full} variable is messed up.

Other than that, it seems to be working perfectly with vB 3.0.3

[mtha]

did you have this in constants.php setup correct?

  // If 4images has problems to find out the right URL, define it here.
  define('SCRIPT_URL', 'http://www.yourforum.com/album'); //no trailing slash

remember to put the correct URL for your 4images album

page_header.php: "self_full" => $site_sess->url($script_url."/".$self_url),

[pjk]

First of all sorry for my broken english.

After I implemented hacked to integrated vb and 4images - onething I'm found that when you click at user name it alway re-direct to vb profile page and it difficult to show all photo uploaed by someone specialy. so I did more modified user profile link to 2 different function..

As see in attached image. if user click at name under a photo (highlight with yellow) 4images won't re-direct you to vB user profile but it will search and show all photos uploaded by that user but if user click at name on "curent active users" (highlight with magenta) it will re-direct and show vb profile page. (see live action at http://www.thaidphoto.com/gallery/ )

if someone interest in this I will post the hack here.

Just want to give something to this hack.

[mtha]

not bad, but come to the point of profile, I'd add a link in profile (when you view someone profile), something like "Find All Images by xxx", and link back to your search.

You can also integrate a images count for user profile, so that you can know how many images someone has uploaded.

I've heard that 4images 1.8 is on the way, so I wouldnt touch too much for right now

[Blam Forumz]

I'm getting this error :

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

DB Error: Bad SQL Query: SELECT sessionhash, lastactivity, host, userid FROM session WHERE sessionhash = '499eb95af60bba8a0622fc347dafbe04' AND host = '81.155.5.216'
Table 'blamina_4Img1.session' doesn't exist

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

DB Error: Bad SQL Query: SELECT sessionhash FROM session WHERE sessionhash = '133a211366c69ffd6dbfbcca5837c3ee'
Table 'blamina_4Img1.session' doesn't exist

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/blamina/public_html/forum/album/includes/db_mysql.php on line 164

DB Error: Bad SQL Query: INSERT INTO session (sessionhash, userid, host, useragent, lastactivity, location, styleid) VALUES ('133a211366c69ffd6dbfbcca5837c3ee', 1, '81.155.5.216', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040626 Firefox/0.9.1', 1091649604, '/album/index.php', '0')
Table 'blamina_4Img1.session' doesn't exist

Warning: Cannot modify header information - headers already sent by (output started at /home/blamina/public_html/forum/album/includes/db_mysql.php:188) in /home/blamina/public_html/forum/album/includes/sessions.php on line 111

Warning: Cannot modify header information - headers already sent by (output started at /home/blamina/public_html/forum/album/includes/db_mysql.php:188) in /home/blamina/public_html/forum/album/includes/sessions.php on line 111

Warning: Cannot modify header information - headers already sent by (output started at /home/blamina/public_html/forum/album/includes/db_mysql.php:188) in /home/blamina/public_html/forum/album/includes/sessions.php on line 111

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 >= 1091647804 ORDER BY u.userid ASC, s.host ASC
Table 'blamina_4Img1.session' doesn't exist

Parse error: parse error, unexpected '<' in /home/blamina/public_html/forum/album/includes/page_header.php on line 274

Help please, I use vBulletin 3.0.2 and I use the latest 4Images

[Steph2k]

Hi, this is a question for those who have installed 4images. Do you have any cookies issues? That was my biggest complaint with photopost. Never could get the cookies to work with vB. I tried to get help on the photopost forums but it just never worked (they made suggestions but nada). People would have to relogin to the gallery, and then when they got back to the forums relogin there. And then some folks could not even log into the gallery (forum members), which makes the gallery pointless for those people.

So any known cookies/session issues ?

Feedback appreciated. Thanks.

[Vega]

Never had any problems with that.
Works just fine.

[clio]

Hi mtha, I ended up just hard coding the URL in and removing the variable from the template.

But now, I have another problem, a cookie problem.

It's recognizing that I've logged in. But I can't get into the admin.

This was working a when I just installed it about a week ago.

Now, I goto my album:
http://www.learntoquestion.com/class/travels/photos/

and when I login, the form doesn't recognize that I've already logged in and continues to display the login form. It does the same when I try to get into the admin.

Any ideas?

Edit:
This is really weird. Right now it's not working in Safari (1.2.2), a browser for the Mac. I just tried it in Netscape 7.1 for the Mac and it works perfectly fine. WEIRD. Any ideas why?

[edeab220]

I'm a little confused about 4images...

It says in the requirements that prior to installing 4images from this thread I need 4images 1.7 installed. Where do I get this other version, and is that really necessary?