vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   4images Gallery 1.7 + vB 3.0.x (update Oct 30) (https://vborg.vbsupport.ru/showthread.php?t=66335)

Koutaru 07-17-2004 04:25 AM

Quote:

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 07-18-2004 01:37 AM

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 07-18-2004 05:19 PM

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 07-18-2004 08:03 PM

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 07-18-2004 08:04 PM

uh, im an idiot im suppose to use same db lol

redlabour 07-18-2004 09:20 PM

So i see 3.0.3 is not a problem with this Hack ?

KTBleeding 07-18-2004 09:28 PM

Quote:

Originally Posted by redlabour
So i see 3.0.3 is not a problem with this Hack ?

So far so good.. :)
Granted, I've only upgraded to 3.0.3 a couple hours ago.

Tailfeathers 07-18-2004 10:27 PM

Quote:

Originally Posted by mtha
There is NO automatic and safe way to do this, BUT you can try this method (require that you know enough php and SQL in order to do the job)


What you have are:
01 - vB user database with USERSET1 controled by userid (and username), says user.userid and user.username
02 - Album user database with USERSET2, controlled by user_id (and user_name) says 4images_users.user_id and 4images_users.user_name


Step 1:
- Create a new COMPARE table having 3 fields: username, forum_uid, album_uid

Step 2:
- Compare 4images_users.user_name and user.username
if match => fill in the COMPARE table (username, forum_uid, album_uid) for this user.
if not => fillin COMPARE table, with album's username, album_uid, DEFAULTID where DEFAULTID is the ID given for those who does NOT have account in forum or have different username in forum. If you want to assign this to be GUEST, the ID is 0

Do this for ALL ALBUM users

=> you know the id in forum and album for each album user

(if they have the SAME username for both places. if you think email address would be more appropriate, you can compare email instead, or compare both username and email)

Step 3:
Change user_id in album to the new forum's userid based on the above comparision, in the following tables:
4images_comments, 4images_groupmatch, 4images_images, 4images_images_temp, 4images_lightboxes, 4images_users

Step 4:
Test your album and see if everything works correctly (username, login/logout, image's poster)

Step 5: Apply this hack ... and god bless you :D


good luck.

PS. this will require alot of changes to your database, so Do a FULL BACKUP of your album database first (maybe your files too), and test in a beta version

Finally went to do this and chickened out, lol. Too worried. Maybe someday, it'd be possible to make this an automatic php install thingy or something. I'd probably destroy both my board and gallery trying to do this, hehe...

For now, people will just have to register at both separately, I guess!

mtha 07-20-2004 05:57 AM

Quote:

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? ?_?
:) then try to convert to html-understandable header. it's easier and less troublesome than doing anonther script.

if you have conditionals that only work for vBulletin, then you did know it ONLY works for vBulletin, didnt you :> well, my suggestion is, find some similar things in 4images and use it, or simplify the conditions.


Quote:

Originally Posted by Tailfeathers
Finally went to do this and chickened out, lol. Too worried. Maybe someday, it'd be possible to make this an automatic php install thingy or something. I'd probably destroy both my board and gallery trying to do this, hehe...

For now, people will just have to register at both separately, I guess!

:P I did migrate my album once, (I used another album script), and ... well I accept to remove all album users, and change posters to ... me. it's better to use one user database in one system tho :>

romanticyao 07-27-2004 12:25 AM

hello

i m using vb3.03 and i m having problem with this interantion

I followed all the steps and it was fine untill i changed cookie timeout in 4images to 0 right after the installtion, i was logged out as admin and never have any chance to login again...

i m still being able to login my forum, but when i logout i get a error ask me to click the link again to logout.

i tried to login using a registered member "demo", 4images logged demo into the system and it worked. however after i click logout, i get the same error message. after logout, cookie for demo at forum was cleared but demo still logged into 4image... so i cleared all the cookie in my IE(also checked folder to make sure none of the cookies left) open up IE again and i m still logge in as demo in 4image.

i have my forum and 4images both running on different subdomains...

please help!


All times are GMT. The time now is 12:03 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01576 seconds
  • Memory Usage 1,758KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete