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