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

[Chrissicom]

Hi guys

I am clicking install too now finally using this hack for my forums after some problems. I have the forum in the folder /forum/ and had the gallery in the folder /sbcgalleries/. I was never logged in in the forum when I went there and the problem was that I had to move the 4images gallery to /forum/sbcgalleries/. Does the 4images gallery always have to be a subfolder in the forums dir? If so I think this wasn't mentioned in the install.txt for this hack.

although my who is online page says Unknow Location instead of viewing galleries....

this is in my functions_online.php file, anything wrong??

PHP Code:

    // Album user online Mod
            case 'sbcgalleries':
                $userinfo['action'] = 'Viewing Galleries';
                $userinfo['where'] = "<a href=\"$userinfo[location]\">$userinfo[location]</a>";
                break;
    // End 


[mtha]

Originally Posted by Chrissicom

Hi guys

I am clicking install too now finally using this hack for my forums after some problems. I have the forum in the folder /forum/ and had the gallery in the folder /sbcgalleries/. I was never logged in in the forum when I went there and the problem was that I had to move the 4images gallery to /forum/sbcgalleries/. Does the 4images gallery always have to be a subfolder in the forums dir? If so I think this wasn't mentioned in the install.txt for this hack.

NO, I even have 4images installed in another account. as long as it can access the same database.

If you have problem, you may did some step wrong. Please check again.

although my who is online page says Unknow Location instead of viewing galleries....

this is in my functions_online.php file, anything wrong??

PHP Code:

     // Album user online Mod
             case 'sbcgalleries':
                $userinfo['action'] = 'Viewing Galleries';
                 $userinfo['where'] = "<a href=\"$userinfo[location]\">$userinfo[location]</a>";
                 break;
     // End 


there's another place to identify the online status being sbcgalleries
you need to check that part too.

[Chrissicom]

Ok, online status is fixed. But now I have another problem. I usually log in to my forum and then go from a forum link to http://www.sandraboards.com/forum/sbcgalleries/ and I am logged in. But when I go directly to http://www.sandraboards.com/forum/sbcgalleries/ although I am logged in at the boards I am not logged in and when I type in my username and password I am re-directed and still not logged in. Any idea what might be wrong?

I used the latest version of this mod and went through all the steps a few times to check if I did something wrong but didn't find anything

Nevermind, fixed the login thing, had a few path set wrong, although changing the path fixed the login problem I have a problem with the Show Online thingy again now lol, it says Unknow location although I fixed this part here to look like this

PHP Code:

    // Album user location
        else if (strpos($token, "/forum/sbcgalleries/") !== false)
        {
            {
                $userinfo['activity'] = 'sbcgalleries';
            }
            return $userinfo;
    } 


[Chrissicom]

I changed the style of the 4images gallery to look like the vBulletin 3.0.3 standard design. If some people want to save time and use my changes as "template" I upload the required files here. The images go in the /gallery/templates/default/images/ folder and the .css file should simply replace with the old one of the default style (Backup your old files first).

There is a little problem with very long gallery names and picture names in the navbar, maybe someone can help me on how to fix this without changing to many template files. ...CSS margin and padding messes up the table so I won't use that as a solution. (Problem: http://www.sandrabullockcentral.com/...hp?image_id=19)

Demo of Style applied: http://www.sandrabullockcentral.com/sbcgalleries/

Note: If your gallery is not a subfolder of yourdomain.com/forum/ you have to change the background: url lines in the .css file

[mtha]

Originally Posted by Chrissicom

I have a problem with the Show Online thingy again now lol, it says Unknow location although I fixed this part here to look like this

PHP Code:

     // Album user location
         else if (strpos($token, "/forum/sbcgalleries/") !== false)
         {
             {
                 $userinfo['activity'] = 'sbcgalleries';
             }
             return $userinfo;
     } 


I have no idea why this happen. it should work if you have everything setup correct. Check your database for sessions table, check the activity column for the location. Put the correct token for it, that all I can think of right now.

[ntwrkguy]

It's perfect, only to log in, users have to make sure to uncheck the remember me box. Any way to fix?

[mtha]

Originally Posted by ntwrkguy

It's perfect, only to log in, users have to make sure to uncheck the remember me box. Any way to fix?

You have a cookie problem.

Make sure you have everything setup correctly. of if you have your board AND your album setting different, try to change the configuration accordingly. (for example cookie prefix). I have no idea how your board is, what's your setting nor configuration, so I cant give detail way to fix it.


My version works fine, with and without checking "remember me" box.

[Chrissicom]

I have cookie prefix 's' and cooke name 'bb' for both and when I login to the galleries I get logged in but the page is still shown with the login box, unless I go to forum for login and click a link to the galleries then, otherwise the login box is always shown although I am logged in.... why is that?

Also is it possible to connect 4images to 5 usergroups from vB instead of just 4? Because I want to differ between Registered and Paying Registered members.

[Koutaru]

The only reason I wanted to include my default vbulletin header and navbar is because it contains certain conditional statements and some phpincludes that I would like to include into the gallery as well

^^; is there any way to inpliment this? Could you show me how/where to look or start?

[mtha]

Originally Posted by Chrissicom

I have cookie prefix 's' and cooke name 'bb' for both and when I login to the galleries I get logged in but the page is still shown with the login box, unless I go to forum for login and click a link to the galleries then, otherwise the login box is always shown although I am logged in.... why is that?

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)

Also is it possible to connect 4images to 5 usergroups from vB instead of just 4? Because I want to differ between Registered and Paying Registered members.

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

The only reason I wanted to include my default vbulletin header and navbar is because it contains certain conditional statements and some phpincludes that I would like to include into the gallery as well

^^; is there any way to inpliment this? Could you show me how/where to look or start?

edit template

Look at header and footer template

[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