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

[Mr. Brian]

I tried, I tried, I've been trying my best stay away from seeking from help. But however I've got no choice but still yet have to do so. Hope u don't mind.

Well, I'm sure that I did follow ur intruction without missing any step yet still getting database error.

Any clue?

[mtha]

Originally Posted by Mr. Brian

I tried, I tried, I've been trying my best stay away from seeking from help. But however I've got no choice but still yet have to do so. Hope u don't mind.

Well, I'm sure that I did follow ur intruction without missing any step yet still getting database error.

Any clue?

what db error did you get?

[Mr. Brian]

Hi thanks for your reply well, here's what I get:-

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

DB Error: Bad SQL Query: SELECT sessionhash, lastactivity, host, userid FROM session WHERE sessionhash = '988299e818dfd386990b236e63f9dee9' AND host = 'xxx.xxx.xx.xx'
Table 'xxx_xxx.session' doesn't exist

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

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

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

DB Error: Bad SQL Query: SELECT sessionhash FROM session WHERE sessionhash = 'aaaaaaaaaaaaaaaa'
Table 'xxx_xxx.session' doesn't exist

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

DB Error: Bad SQL Query: INSERT INTO session (sessionhash, userid, host, useragent, lastactivity, location, styleid) VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 0, '203.120.68.68', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)', 1234567890, '/gallery/index.php', '20')
Table 'xxx_xxx.session' doesn't exist

Warning: Cannot modify header information - headers already sent by (output started at /home/xxx/public_html/forums/gallery/includes/db_mysql.php:188) in /home/soccera/public_html/forums/gallery/includes/sessions.php on line 110

Warning: Cannot modify header information - headers already sent by (output started at /home/xxx/public_html/forums/gallery/includes/db_mysql.php:188) in /home/xxx/public_html/forums/gallery/includes/sessions.php on line 110

Warning: Cannot modify header information - headers already sent by (output started at /home/xxx/public_html/forums/gallery/includes/db_mysql.php:188) in /home/xxx/public_html/forums/gallery/includes/sessions.php on line 110

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 >= 1115970821 ORDER BY u.userid ASC, s.host ASC
Table 'xxx_xxx.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 'xxx_xxx.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 NOT IN (0) ORDER BY i.image_date DESC LIMIT 3
Table ''xxx_xxx.user' doesn't exist

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/forums/gallery/includes/db_mysql.php on line 116

Thanks in advance.

[Marco van Herwaarden]

Looks to me like you are using a table prefix, but the script don't support it.

[mtha]

Looks to me like you are using a table prefix, but the script don't support it.

the intergration does support prefix.

here's my answer:

Originally Posted by Mr. Brian

Hi thanks for your reply well, here's what I get:-

Table 'xxx_xxx.template' doesn't exist
Table 'xxx_xxx.session' doesn't exist
Table 'xxx_xxx.user' doesn't exist

Thanks in advance.

You either did not config your forum prefix and/or did not install 4images and vbulletin in the same database.

If the first is the case, in constants.php, edit this line
define('VB_TABLE_PREFIX',''); // your vb tableprefix. vB default is blank

if the second is the case, then you need to install both of them in the SAME database.

[BlackxRam]

Yes I did upload and do the changes to the vbulletin files as well. I did put in my Liscense number as well, i just removed it in the file I gave you. I also removed the extra ; and it still has done nothing.

I have disabled all firewalls as well, still nothing.

[BlackxRam]

Anyone figure out anything?

[Michaelb.dk]

How can i include the original header and footer from my forum to the gallery?

[Zombie]

I got this hack working ok, but how do I set it so I do not have to validate every image that is uploaded??

[Zombie]

Guess this hack isn't supported

[BlackxRam]

Zombie, that option is in 4images under your settings... its not being answered because I can only guess that, is 4images job.

Which it is there. if you are an admin you don't need to validate a image unless you specify.

[BlackxRam]

Also, if people are having issues getting cookies to stick and login info kept intact and your forums are a subdomain... try making your gallery a subdomain as well. Apparently the cookies will require the same kind of setup with the recent release of vb 3.0.7 from what I understand.

So perhaps putting this into the READ ME file of this hack would benefit those like myself that struggled with forums on a subdomain and a gallery that wasnt after the vb update.

[Tailfeathers]

I posted a question about integrating this over at vB.com:
http://www.vbulletin.com/forum/showthread.php?t=140646

I already posted about this in the first page of this post, but that was over a year ago (and the instructions for how to do it lost me) -- does anyone have any new tips/ideas?

As I said there, the only idea I have is to change all the user IDs of members of my gallery to some really high numbers, and then go back and change them to IDs that match their IDs at the board, but I guess that might be a problem if I'd have to change that on each user's pictures as well if pictures associate with the ID and not username or something.

[Tailfeathers]

Just wanted to say this problem has been solved in the "old fashioned way." I am simply going through and editing every user's full set of pictures individually to match their board ID. It's taken me the last 9 hours so far, but I am a bit over halfway there.

[Mr. Brian]

Originally Posted by mtha

the intergration does support prefix.

here's my answer:



You either did not config your forum prefix and/or did not install 4images and vbulletin in the same database.

If the first is the case, in constants.php, edit this line
define('VB_TABLE_PREFIX',''); // your vb tableprefix. vB default is blank

if the second is the case, then you need to install both of them in the SAME database.

I believe to be the second case. But how am I supposed to have them installed in the same database?