Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - tyrwebmaster

Pages: [1]
1
Español / Castellano / Re: Compatir Base de Datos con Foro PHPBB2
« on: March 19, 2005, 10:56:12 PM »
Lo unico que en el 4images me da errores de login y eso... a que puede ser...
probarlo si podeis...

www.tuscanipassion.com/foro
www.tuscanipassion.com/gallery


2
Español / Castellano / Re: Compatir Base de Datos con Foro PHPBB2
« on: March 19, 2005, 10:42:06 PM »
ok.. ya lo tengo resuelto!!!!!

El tema estaba que tenia lo del phpbb_ por foro_
Debes cambiarlo en en sessions.php que te dan el zip de integracion. Cambias todo los phpbb_ por el nombre de las tablas, en mi caso foro_

Y en el includes/constants.php

Change:
define('SESSIONS_TABLE', $table_prefix.'sessions');

to:
define('SESSIONS_TABLE', 'foro_sessions');
(Maybe you should change the table prefix "phpbb_")
---------
Change:
define('USERS_TABLE', $table_prefix.'users');

to:
define('USERS_TABLE', 'foro_users');
(Maybe you should change the table prefix "phpbb_")

Ya esta todo resuelto.. si teneis dudas... yo ya lo tengo claro
Un saludo

3
Español / Castellano / Re: Compatir Base de Datos con Foro PHPBB2
« on: March 19, 2005, 09:58:20 PM »
tengo un problemilla con la instalacion.. sigo los pasos indicados----me sale esto al final

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 foro_sessions s LEFT JOIN foro_users u ON (u.user_id = s.session_user_id) WHERE s.session_lastaction >= 1111265476 ORDER BY u.user_id ASC, s.session_ip ASC
Unknown column 's.session_lastaction' 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 gallery_images i, gallery_categories c LEFT JOIN foro_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 LIMIT 0, 1
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 gallery_images i, gallery_categories c LEFT JOIN foro_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 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 /var/www/vhost/tuscanipassion.com/home/html/gallery/includes/db_mysql.php on line 116




La extension que puse en vez de phpbb_ es foro_  ¿Tiene algo que ver?
Ayudarme
Gracias

4
Español / Castellano / Re: Compatir Base de Datos con Foro PHPBB2
« on: March 19, 2005, 09:19:22 PM »
  ==========================================================
              Integration 4images 1.7 / phpBB 2
  ==========================================================

  Note: Main part in sessions.php is adapted from of phpBB
        (C) 2001 The phpBB Group
        phpBB and the file sessions.php are released under
        the GNU General Public License

  ----------------------------------------------------------
  Installation
  ----------------------------------------------------------

  1. Replace the template user_loginform.html in your templates
     folder with the file in this zip.

  2. Replace the file sessions.php in your includes folder with
     the file in this zip.

  3. Open sessions.php and edit the configuration part at the top
     of the file.

  4. Open includes/constants.php and edit the following parts:
     ---------
    Change:
       define('SESSIONS_TABLE', $table_prefix.'sessions');

    to:
       define('SESSIONS_TABLE', 'phpbb_sessions');
       (Maybe you should change the table prefix "phpbb_")
    ---------
    Change:
       define('USERS_TABLE', $table_prefix.'users');

    to:
       define('USERS_TABLE', 'phpbb_users');
       (Maybe you should change the table prefix "phpbb_")
     ---------
    Change:
       define('GUEST', -1);
       define('USER_AWAITING', 1);
       define('USER', 2);
       define('ADMIN', 9);

     to:
       define('GUEST', -1);
       define('USER_AWAITING', -1);
       define('USER', 0);
       define('ADMIN', 1);
     ---------
    Change:
       define('ADMIN_SAFE_LOGIN', 1);

    to:
       define('ADMIN_SAFE_LOGIN', 0);


  ----------------------------------------------------------
  Installation Notes
  ----------------------------------------------------------

  1. Integration works only if the tables of 4images and
     phpBB are on the same database.

  ---------

  1. We recommend you to use integration only with fresh new
     installations of 4images because of the following reason:
     In the 4images user-table User A has the User-ID "1".
     After integration 4images will use the user-table of phpBB.
     There, the User A has the User-ID "2" and User B the
     User-ID "1".
     All images, comments and usergroup memberships are now
     "owned" by User B.

  ---------

  2. If you run 4images and phpBB under different subdomains,
     for example http://4images.domain.com and http://phpbb.domain.com,
     you should use the following setting for phpBB in
     "General Admin -> Configuration":

       Cookie Domain = .domain.com

     Note the point at the beginning!

  ---------

  3. If you delete users, you should delete the user first over
     the Control Panel of 4images and after that over the
     Administration Panel of phpBB.
     This is neccessary to delete/modify all user-related data
     from the 4images database (images, comments, usergroups).

5
Español / Castellano / Re: Compatir Base de Datos con Foro PHPBB2
« on: March 19, 2005, 09:14:40 PM »
Gracias excited... haber si alguien me lo puede traducir la instalacion...
 :)

6
Español / Castellano / Compatir Base de Datos con Foro PHPBB2
« on: March 19, 2005, 05:55:59 PM »
Pues eso... tengo un foro en phpbb2 y me gustaria que tubiera los mismos usuarios sin que tengan que registrarse dos veces. Como se haria??
Instale 4gallery con el mismo nombre de base de datos pero parece que no comparte usuarios.
Un saludo  8O

Pages: [1]