Integration 4images 1.7.x / phpBB

[Leitha]

Fixed it now. Appears there were hidden characters carried over when I pasted the additional code in. Re-wrote by hand and is now working.

[ScatMan]

Hello!
I followed the instructions: in 4images I can see phpBB users and they don't need to login it, but when they hit "log out" they see phpBB warning message "Invalid_session"... what's my mistake?
I've a domain and forum.mydomain.com and 4images.mydomain.com and I set in phpBB to use ".domain.com" as cookie domain...
thanks!

[andersen]

Dear all,

Nice day.

I had mod this in my site done. for the moment, I had meet a few problem, I had trying to searching out about my problem go through 15 pages. but I can't find any source with my problem.

I had downloaded with  integration_phpbb.zip and follow 100% process on the instruction.

Problem:-
=======
1. When I log on with phpbb or 4image, the user are not logon together.
2. When I trying to log out 4image, it will bring me to phpbb main site.

any source? Do any one have a complete .zip ?

Thanks

[kundera]

hi all, so i have a quick question :
when i am on phpbb, i want to have a box with the catégories names of my 4images cat for direct link to the 4images part

i have already do this "menu" box in 4images, and it look like this :
(in my 4images pages header)

Code: [Select]

$sql = mysql_db_query("$db_name","select * from ".CATEGORIES_TABLE." WHERE cat_parent_id='0'");  
  while($row = mysql_fetch_array($sql)) {
$cat_id1=$row["cat_id"];
$cat_name1=$row["cat_name"];  

$build_menu .="$ico_arrow <a href=\"categories.php?cat_id=$cat_id1\" class=\"link_low\">$cat_name1</a><br>";

}
$site_template->register_vars(array(
    "build_menu" => $build_menu
  ));

i have try to do the same sql query, and i have define the categori table in the constant phpbb files, but it doesn't run, cause se sql query have to be written differently.

I have try this but it seems to have a bug :

Code: [Select]

$sql = "select * from ".CATEGORIES_TABLE_PICS." WHERE cat_parent_id='0'";  
  while($row = $db->sql_fetchrow($result)) {
$cat_id1=$row["cat_id"];
$cat_name1=$row["cat_name"];  

$build_menu .="$ico_arrow <a href=\"categories.php?cat_id=$cat_id1\" class=\"link_low\">$cat_name1</a><br>";

}
$template->assign_vars(array(
'build_menu' => $build_menu)
);

have somebody an idea what is wrong?

[Jan]

You forgot to execute the query:

Code: [Select]

$result = $db->sql_query($sql);
Jan

[devance]

um diese integration auch mit einem wbb2 board zu verwenden, muss ich da noch etwas außer die namen der tables ändern ???

oder ist dies gar nicht möglich???

- mfg dev

[Jan]

Nein, das ist nicht möglich.

Jan

[blauwiese]

Hallo alle ,

habe nun 2 mal versucht 4images und phpbb zu integrieren   , bin jedesmal der Anleitung gefolgt, habe diesen Tread gelesen und die entsprechenden Modifikationen durchgeführt. Leider, leider    bekomme ich es nicht ganz hin, Login bei 4images und ich lande im phpbb. Logout in 4images und ich lande im Forum. Im Forum geht alles normal... Ist das so :  oder mach ich etwas falsch  

Danke

[Jaap12]

Hi,

First of all great mod! (4images and phpbb) it sounds very nice. But i have 120 users with my photogallery.
My question is:
Is it nessesery to delete all my 120 users before installing the phpbb mod? if yes, the admin account to?

If so .... after the upgrade is it possible to restore all my members? 120 is much to do it all by hand, but that's no problem i think.

I need then only restore the:
-username
-email
-password
?

Password is a big problem, i have looked in the mysql backup from my site and i saw that all the passwords a encrypted? how can i restore the passwords of all the usernames?

I hope somebody can answer al my questions.

Thank you very much.

Bas

[kundera]

hello all
if i want that only one group of users acces to the gallery, what i have to do

thinks need to change something  in include/constant  (4images files)

Code: [Select]

// Permission levels
define('AUTH_ALL', 0);
define('AUTH_USER', 2);
define('AUTH_ACL', 3);
define('AUTH_ADMIN', 9);


// Group types
define('GROUPTYPE_GROUP', 1);
define('GROUPTYPE_SINGLE', 2);

thanks (and sorry if the ansered was allready done, but not an expert in deutch   )

[Jan]

Ja, das ist leider so weil die Funktionen des phpBB genutzt werden und dieses halt immer auf die eigenen Seiten weiterleitet.

Jan

[mantra]

Is there any way of keeping the old members ? for this integrations.

Could you make the scripts that can import all user data Jan :    

[Feppa]

How do i make a link in phpbb to 4images?

Please help me

[Keichi]

DB Error: Bad SQL Query: DELETE FROM phpbb_sessions WHERE session_lastaction < 1054758980
Unknown column 'session_lastaction' in 'where clause'

Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site67/fst/var/www/html/scans/includes/db_mysql.php:188) in /home/virtual/site67/fst/var/www/html/scans/includes/sessions.php on line 85

DB Error: Bad SQL Query: INSERT INTO phpbb_sessions (session_id, session_user_id, session_lastaction, session_location, session_ip) VALUES ('6588806c8e98915453e33bc397106cb1', -1, 1054759880, 'index.php', '24.114.157.66')
Unknown column 'session_lastaction' in 'field list'

Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site67/fst/var/www/html/scans/includes/db_mysql.php:188) in /home/virtual/site67/fst/var/www/html/scans/includes/sessions.php on line 85

Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site67/fst/var/www/html/scans/includes/db_mysql.php:188) in /home/virtual/site67/fst/var/www/html/scans/includes/sessions.php on line 85

Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site67/fst/var/www/html/scans/includes/db_mysql.php:188) in /home/virtual/site67/fst/var/www/html/scans/includes/sessions.php on line 85

DB Error: Bad SQL Query: SELECT s.session_user_id, s.session_lastaction, s.session_ip, u.user_id, u.user_level, u.user_name, u.user_invisible FROM phpbb_sessions s LEFT JOIN phpbb_users u ON (u.user_id = s.session_user_id) WHERE s.session_lastaction >= 1054759580 ORDER BY u.user_id ASC, s.session_ip ASC
Unknown column 's.session_lastaction' 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.user_name FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_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.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, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_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.user_name' in 'field list'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site67/fst/var/www/html/scans/includes/db_mysql.php on line 116

need help -.-

[Jan]

It seems that you did not replaced sessions.php