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

[mtha]

Originally Posted by thunder1202

Hello,

Since I have integrated my VB 3.0.7 with a fresh copy of 4images 1.7.1 ,,I got my 4images running very very slow, and sometimes it does not load at all. I have double checked that I have done the installation in the right way.
I facethis problem whenever I add a file into the album. (even a single file), you will see that your album is not running or running very slow. "I don't get any error messages" Whenever you delete all images(or files) from the album.. IT WORKS FINE!!
I mean it works fine as long as it is EMPTY !!!

I have another 4images working on my server on the same website since 3 years, working very fine without any troubles. It has more than 500 files, and works very fast.!!!

Really strange!

Any help?

try this:

- save all edited files somewhere
- upload the original files that you have for 4images
- try to run 4images seperately, upload files, test speed (assume that you have some admin account on album)

- re-upload the edited files and see how it works.

I've been using the integration for about 3 years now, having about 20000 images, and it runs fine

[thunder1202]

Originally Posted by mtha

try this:

- save all edited files somewhere
- upload the original files that you have for 4images
- try to run 4images seperately, upload files, test speed (assume that you have some admin account on album)

- re-upload the edited files and see how it works.

I've been using the integration for about 3 years now, having about 20000 images, and it runs fine

I re-downloaded the the files from 4homepages website again, I installed a new clean copy. It worked fine, but once you add a single file to the album, you just get it freezing !!

I tried 4images 1.6.1 .. it worked so fast . but the problem is that your hack is not fully supporting 1.6.1 !! When I uploaded constants.php and sessions.php to 4images 1.6.1 . it worked but I got this error message
===

PHP Code:

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, u.user_name, c.cat_name FROM pda_images i, user u, pda_categories c WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND u.user_id = i.user_id AND c.cat_id = i.cat_id ORDER BY RAND()
Unknown column 'u.user_name' in 'field list'

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, u.user_name, c.cat_name FROM pda_images i, user u, pda_categories c WHERE i.image_active = 1 AND u.user_id = i.user_id AND c.cat_id = i.cat_id AND i.cat_id NOT IN (0) ORDER BY i.image_date DESC LIMIT 3
Unknown column 'u.user_name' in 'field list'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/medkaau/public_html/pda16/includes/db_mysql.php on line 113. 


=====

Also, I don't get the last new imgaes added to the album . I just get "No new images", also the categories are empty from files or images, eventhough the total number of images is counted correctly in the homepage.!

Regards,

[mtha]

Originally Posted by thunder1202

I re-downloaded the the files from 4homepages website again, I installed a new clean copy. It worked fine, but once you add a single file to the album, you just get it freezing !!

it got freezed when you upload to your album WITH or WITHOUT the integration?

I tried 4images 1.6.1 .. it worked so fast . but the problem is that your hack is not fully supporting 1.6.1 !! When I uploaded constants.php and sessions.php to 4images 1.6.1 . it worked but I got this error message

I dont have 1.6.1, and it does work with 1.7.1

PHP Code:

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, u.user_name, c.cat_name FROM pda_images i, user u, pda_categories c WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND u.user_id = i.user_id AND c.cat_id = i.cat_id ORDER BY RAND()
Unknown column 'u.user_name' in 'field list'

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, u.user_name, c.cat_name FROM pda_images i, user u, pda_categories c WHERE i.image_active = 1 AND u.user_id = i.user_id AND c.cat_id = i.cat_id AND i.cat_id NOT IN (0) ORDER BY i.image_date DESC LIMIT 3
Unknown column 'u.user_name' in 'field list'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/medkaau/public_html/pda16/includes/db_mysql.php on line 113. 


=====

you must have not configured the variable for vB database right. check back the variable called USER_NAME in constants.php

Also, I don't get the last new imgaes added to the album . I just get "No new images", also the categories are empty from files or images, eventhough the total number of images is counted correctly in the homepage.!

do you have your "moderating" mode on? did you validate your images?

so, I get lost here. what do you have that is working, what do you have that giving errors? it does seems to me that you have different things installed with different problems?
:speechless:

[flash7]

Hello,

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

this don't work with my vb 3.0.7 :squareeyed:

[mtha]

Originally Posted by flash7

Hello,


this don't work with my vb 3.0.7 :squareeyed:

Here's the quick fix
https://vborg.vbsupport.ru/showpost....&postcount=315

I've been busy working with my awards hack, havent got time to clean up this one. Sorry

[thunder1202]

Originally Posted by mtha

it got freezed when you upload to your album WITH or WITHOUT the integration?



I dont have 1.6.1, and it does work with 1.7.1



you must have not configured the variable for vB database right. check back the variable called USER_NAME in constants.php




do you have your "moderating" mode on? did you validate your images?

so, I get lost here. what do you have that is working, what do you have that giving errors? it does seems to me that you have different things installed with different problems?
:speechless:

No, not different problems. I told you before that 1.7 gives no errors. But I have no explanation why it gets freezing most of the day!!!

The constants.php file configuration is fine, because when I put it with 1.7 it works fine, I just get the above error message with 1.6.1. (possibly the two files are made mainly for 1.7 not for 1.6.1)

There is no moderation to the images, because the images appear with 1.7 but not with 1.6.1.

What I can see that the freezing happens only when adding images or files WITH integration. (N.B. : I'm adding the files through a URL on the same server, not through the upload manager of the 4images program)
One more thing to say,, the admin control panel runs smoothly and never freezes!!. I guess the problem is somewhere in the sessions.php file!!

you can pass by my website and take a look
http://www.medkaau.com/album/index.php (this is my Documents and photos section which is 1.6.1 -NO- integration - its working for 3 years so great.)

http://www.medkaau.com/pda/index.php (my integrated 1.7 - it gets freezing most of the time, but sometimes its WORKING GREAT!!! - installtion is 100% correct) if you are lucky, then it will work with you without freezing.

http://www.medkaau.com/pda16/index.php (this is the inegrated 1.6.1)

I'm really getting crazy!! NO PHOTOS --> NO PROBLEMS !

mmmmm, does this problem has anything to do with the SAFE MODE restrictions?

Regards,

[flash7]

Hi mtha,

I see the fix but don't work :ermm:

Originally Posted by mtha

Here's the quick fix
https://vborg.vbsupport.ru/show...4&postcount=315

[thunder1202]

Hi again Mtha,

I guess my problem is somewhere in the sessions, if you notice in the who's online - the 4images is not showing the # of online members or guests!!
When you replace the original sessions.php file they appear correctly!

I'm using VB 3.0.7 !! Are there any updates for your hack for this VB version?

Regards,

[flash7]

Originally Posted by flash7

Hi mtha,

I see the fix but don't work :ermm:

My mistake,
sorry mtha

Now work GREAT !

Thanks

[Allan]

Thank you for this hack, very nice Mtha


~~~~~~~~~~~~~~~~~~~~~~~~~
Click Install
~~~~~~~~~~~~~~~~~~~~~~~~~