Author Topic: Integration 4images 1.7 / vBulletin 2.x  (Read 236992 times)

0 Members and 1 Guest are viewing this topic.

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Integration 4images 1.7 / vBulletin 2.x
« on: August 29, 2002, 05:34:29 PM »
Hier sind nun die angekündigten Dateien für die Integration von 4images 1.7 und vBulletin 2.x. Eine Installationsanleitung ist im Zip enthalten (Wichtig: Die Installations-Hinweise lesen!).
Die Integration ist experimentell. Bugs bitte hier posten.
-------
Here are the files for the integration of 4images 1.7 and vBulletin 2.x. Instructions for installation are included (Important: Please read the installation notes!).
The integration experimental. Please post Bugs here.

Download: integration_vbulletin.zip
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline Arunan

  • Newbie
  • *
  • Posts: 16
    • View Profile
Integration 4images 1.7 / vBulletin 2.x
« Reply #1 on: August 29, 2002, 09:56:57 PM »
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 4i_images i, user u, 4i_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 4i_images i, user u, 4i_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'

I get this Error

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Integration 4images 1.7 / vBulletin 2.x
« Reply #2 on: August 29, 2002, 09:59:39 PM »
Did you replaced "includes/sessions.php"?

Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline Arunan

  • Newbie
  • *
  • Posts: 16
    • View Profile
Integration 4images 1.7 / vBulletin 2.x
« Reply #3 on: August 29, 2002, 10:01:55 PM »
Yes

Offline Arunan

  • Newbie
  • *
  • Posts: 16
    • View Profile
Integration 4images 1.7 / vBulletin 2.x
« Reply #4 on: August 29, 2002, 10:04:31 PM »
Code: [Select]
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 4i_images i, user u, 4i_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 4i_images i, user u, 4i_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/virtual/site2/fst/home/board/public_html/includes/db_mysql.php on line 113


There is the error I get, its at the top, but I am able to login

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Integration 4images 1.7 / vBulletin 2.x
« Reply #5 on: August 29, 2002, 10:06:33 PM »
Are you sure that you use version 1.7 and/or updated it correctly?

Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline Arunan

  • Newbie
  • *
  • Posts: 16
    • View Profile
Integration 4images 1.7 / vBulletin 2.x
« Reply #6 on: August 29, 2002, 10:07:47 PM »
Umm that may be it, Im using 1.6 sorry for wasting your time :roll:

Offline X-Fan

  • Full Member
  • ***
  • Posts: 117
    • View Profile
    • http://www.comixfan.com/xfan/
Integration 4images 1.7 / vBulletin 2.x
« Reply #7 on: August 30, 2002, 03:31:21 AM »
Just found a couple of bugs...  on both my main forums page and the 4images main page its showing an incorrect number of registered users online (about 30 different between 4images' total and the forums' total).

4images is also showing 0 guests online when according to my forums there's about 50 (at the moment).

Also, 4images is declaring that 0 registered users are invisible, when there's around 8 or so online at my site that are.
Eric J. Moreels
ComiX-Fan Editor-in-Chief
e-mail: webmaster@comixfan.cjb.net
Web: http://www.comixfan.com/xfan
AIM: XFan2k

Offline X-Fan

  • Full Member
  • ***
  • Posts: 117
    • View Profile
    • http://www.comixfan.com/xfan/
Integration 4images 1.7 / vBulletin 2.x
« Reply #8 on: September 01, 2002, 10:16:21 AM »
Another possible bug that has arisen... after integrating 4images with my vBulletin forums' database for sessions, it's now taking several minutes for the Add Images page to load up.  It never took that long before, and I'm wondering why it's now taking so long?
Eric J. Moreels
ComiX-Fan Editor-in-Chief
e-mail: webmaster@comixfan.cjb.net
Web: http://www.comixfan.com/xfan
AIM: XFan2k

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Integration 4images 1.7 / vBulletin 2.x
« Reply #9 on: September 01, 2002, 12:48:40 PM »
The first bug should be fixed (user online). Please download the zip again and replace sessions.php.

Quote
it's now taking several minutes for the Add Images page to load up

Where, control panel or upload form in the gallery? Can i try it? I've been registered at our forum with username "jan".

Greets Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline X-Fan

  • Full Member
  • ***
  • Posts: 117
    • View Profile
    • http://www.comixfan.com/xfan/
Integration 4images 1.7 / vBulletin 2.x
« Reply #10 on: September 01, 2002, 03:16:03 PM »
Quote from: Jan
The first bug should be fixed (user online). Please download the zip again and replace sessions.php.


Shall do, thanks Jan!

Quote
Where, control panel or upload form in the gallery? Can i try it? I've been registered at our forum with username "jan".


From the 4images admin control panel.  Whenever I click on Add Images therein, it takes a minute or so to load the screen.  Then when I select 5 from the drop-down list (as I like to upload 5 at a time), it takes several more minutes to load that screen.
Eric J. Moreels
ComiX-Fan Editor-in-Chief
e-mail: webmaster@comixfan.cjb.net
Web: http://www.comixfan.com/xfan
AIM: XFan2k

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Integration 4images 1.7 / vBulletin 2.x
« Reply #11 on: September 01, 2002, 03:32:39 PM »
Ok, i have seen that you have nearly 3000 users registered. I guess that it takes this time to build up the user dropdown.

Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline X-Fan

  • Full Member
  • ***
  • Posts: 117
    • View Profile
    • http://www.comixfan.com/xfan/
Integration 4images 1.7 / vBulletin 2.x
« Reply #12 on: September 01, 2002, 03:33:13 PM »
Jan, I'm using the modified sessions.php file, but it's still showing up 0 for invisible users even though there are currently two users marked with an asterisk, which is the indicator for a user whose status is invisible, in the online list.

Help!
Eric J. Moreels
ComiX-Fan Editor-in-Chief
e-mail: webmaster@comixfan.cjb.net
Web: http://www.comixfan.com/xfan
AIM: XFan2k

Offline X-Fan

  • Full Member
  • ***
  • Posts: 117
    • View Profile
    • http://www.comixfan.com/xfan/
Integration 4images 1.7 / vBulletin 2.x
« Reply #13 on: September 01, 2002, 03:36:23 PM »
Quote from: Jan
Ok, i have seen that you have nearly 3000 users registered. I guess that it takes this time to build up the user dropdown.


Ahhh, of course, that would be why...

Well, since I'm only allowing administrators at my site to upload images, is there any way I can limit the usernames it loads up to just those that are in the Administrators usergroup?
Eric J. Moreels
ComiX-Fan Editor-in-Chief
e-mail: webmaster@comixfan.cjb.net
Web: http://www.comixfan.com/xfan
AIM: XFan2k

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Integration 4images 1.7 / vBulletin 2.x
« Reply #14 on: September 01, 2002, 03:54:57 PM »
I fixed the "bug" concerning the hidden users in the online list. This was not a real bug, because 4images counts this users as visible because you are logged in as admin and the user is visible to you. Download the zip again and replace sessions.php.

Try this for the user dropdown:
Open "admin/admin_functions.php " and change this line in the function show_user_select_row():
Code: [Select]
WHERE ".get_user_table_field("", "user_id")." <> ".GUEST."
to
Code: [Select]
WHERE ".get_user_table_field("", "user_level")." = ".ADMIN."
Greets Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search