Integration 4images 1.7.x / phpBB

[Clow Read]

Hello Jan! ^^

i've integrated 4images 1.7 to phpbb 2.0.3 and here's my question...

how can 4images use the session id (sid) of phpbb and vice versa so that ppl won't need to login again ^^

thanx ^_~

[Jan]

If the user has cookies enabled, he should stay logged in. If not, you have to append the session id to the link.

For phpBB, open includes/page_header.php and add this line

Code: [Select]

'U_4IMAGES' => append_sid('<the_url_to_4images>'),
below this line

Code: [Select]

'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),
After that, you can use {U_4IMAGES} in your phpBB templates, i.e.

Code: [Select]

<a href="{U_4IMAGES}">Go to the Gallery</a>

The same now for 4images. Add in includes/page_header.php this line

Code: [Select]

"url_phpbb" => $site_sess->url("<your_url_to_phpBB"),
below this line

Code: [Select]

"url_home" => $site_sess->url(ROOT_PATH."index.php"),
Now you can use {url_phpbb} in the 4images templates, ie

Code: [Select]

<a href="{url_phpbb}">Go to the Forum</a>
Jan

[vnunited]

i got error message, can anyone help me?

http://www.vietvui.net/vnunited/db/index.php

Parse error: parse error in /home/vietvui/vietvui-www/vnunited/db/includes/constants.php on line 41

DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM SETTINGS_TABLE
Table 'vietvui_net.SETTINGS_TABLE' doesn't exist

[Jan]

You've made an error while editing inlcudes/constants.php. Check line 41.

Jan

[vnunited]

line 40 and 41

Code: [Select]

define('SESSIONS_TABLE', 'forum_sessions');
       (Maybe you should change the table prefix "forum_")

forum_ is the proefix of my phpbb database table, could this be the problem because my prefix is not pbpbb ?

[Jan]

No, delete the second line, thats not part of the code.

Jan

[vnunited]

now i got this error:

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 4images_images i, forum_users u, 4images_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 4images_images i, forum_users u, 4images_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 4
Unknown column 'u.user_name' in 'field list'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/vietvui/vietvui-www/vnunited/db/includes/db_mysql.php on line 113


[Jan]

You did something wrong with your installation of the mod. Check each step again.

Jan

[5225]

I am currently getting this error on 4Images index page.  Any ideas?

Warning: Compilation failed: unmatched parentheses at offset 7 in /home/assault/public_html/4images/includes/template.php on line 170

Here are lines 169 through 171 on the above listed file:

   );
    $template = preg_replace($search_array, $replace_array, $template);
    return $template;
  }

Thanks

[tradertt]

Code: [Select]

DB Error: Bad SQL Query: UPDATE 4images_sessions SET session_user_id = -1, session_start = 1042364340, session_time = 1042364340, session_page = 0, session_logged_in = 0 WHERE session_id = '68af76c16d06c36b145cb43f9bc0f7c6' AND session_ip = 'ca9c0252'
Unknown column 'session_start' in 'field list'

DB Error: Bad SQL Query: INSERT INTO 4images_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('5dc5c73eafd5ab78076d581f66ed67e4', -1, 1042364340, 1042364340, 'ca9c0252', 0, 0)
Unknown column 'session_start' in 'field list'

Warning: Cannot add header information - headers already sent by (output started at /home/ahahchen/public_html/tradertt/4images/includes/db_mysql.php:188) in /home/ahahchen/public_html/tradertt/4images/includes/sessions.php on line 325

Warning: Cannot add header information - headers already sent by (output started at /home/ahahchen/public_html/tradertt/4images/includes/db_mysql.php:188) in /home/ahahchen/public_html/tradertt/4images/includes/sessions.php on line 326

DB Error: Bad SQL Query: SELECT u.user_id, u.user_level, u.username, u.user_allow_viewonline, s.session_user_id, s.session_time, s.session_ip FROM 4images_users u, 4images_sessions s WHERE u.user_id = s.session_user_id AND (s.session_time >= 1042364040 OR u.user_session_time >= 1042364040) ORDER BY u.user_id ASC, s.session_ip ASC
Unknown column 'u.username' in 'field list'

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 4images_users u ON (u.user_id = 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()
Unknown column 'u.username' 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, c.cat_name, u.username FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = 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
Unknown column 'u.username' in 'field list'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ahahchen/public_html/tradertt/4images/includes/db_mysql.php on line 116

Can anyone tell me why I get this error? I put both databse under the same DB name and I installed 4images first then phpbb.... did I do anything wrong? I have chg the session.php too...

[Jan]

@all: Please read the installation instructions carefully and follow all steps described there!

Jan

[vnunited]

i can't find this line

Code: [Select]

    Ändere/Change:
       define('ADMIN_SAFE_LOGIN', 1);

in my constants.php file

[Vraxor]

Check line 108, I found it, so it should be there somewhere.

Cheers,
Vraxor

[scherzbold]

Ich habe auch ein Problem mit den Cookies, die beiden wollen einfach nicht zusammenarbeiten, ich muss mich bei beiden immer und immer wieder neu einloggen wenn ich wechsle.

Ich habe auch schon versucht die Daten da zu ändern so das das mit den Links funktioniert, hat bei mir leider auch nicht geholfen. Liegt das an den Cookie Namen? Welche muss ich da nehmen bei phpbb kann ich es ja ändern aber bei 4images weiss ich leider nicht ob das geht oder überhaupt nötig ist.

[Jan]

Liegen phpBB und 4images evtl. unter verschiedenen Subdomains? Lies Dir Punkt 2 der Installations-Hinweise durch.

Jan