2 different databases user & dump 2 different databases user & dump
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

2 different databases user & dump

Started by CPG Guru, October 27, 2005, 06:44:57 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

CPG Guru

Hi All

Ive used photopost 5.2.1 & there is an option of if we want to integrate photopost with mambo cms r any forum we can do that with option that we can install photopost standlone in different database & can configure user of mambo database.

This is an excellent Feature whcih will help in messing up two databases , for ur reference im attaching config file of that, please suggest if we have this feature or mod as ivenot found any in forum

<?php
//**************** External Header Configuration ****************//
//
// the isset prevents vB headers from being sent during login/logout -
// do not remove this line as it may cause the vB headers to interfere with the login/logout process
//
// To include the file, edit the header-inc.php
//

if ( !isset($skip_exheader) ) {
    include "header-inc.php";
}

// PhotoPost Pro Version Number
$VERSION "5.21";

// Path to your PhotoPost installation - no end slashes
$PP_PATH "/home/sitename/public_html/gallery";

// All of the .tmpl files are placed into a directory called "templates"; if you wish to change the
// name of the directory to something else to protect your files, you may do so and indicate the name
// of the directory here - this is not a path to the directory, just the directory name; the directory
// cannot be moved from the PhotoPost main directory.
$TMPL_PATH "templates";

//**************** MySQL Database Configuration ****************//

// PhotoPost database host address, or leave as localhost
$host="localhost";

// PhotoPost's database name
$database="PHOTOPOST DEFAULT DATABASE";

// MySQL username and password to access PhotoPost's database
//
// These two variables are for the userid and password needed to access
// the PhotoPost database named above.
$mysql_user="gallery_user";
$mysql_password="xxxxxxx";

// User database host address, or leave as localhost
$host_bb="localhost";

// If you want to use a prefix for your database, enter it here.
// NOTE: This variable can only be set PRIOR to your first installation of PhotoPost;
// existing databases will not be changed and you will be unable to connect if you change
// this variable after performing a default installation.
$pp_db_prefix "pp_";

// User database MySQL database name
//
// This is the variable for the User Database; if you are using Internal
// as your registration system, then these variables are the same as the
// ones above.  If you are linking to a message board system,
// thse variables should be set to the database, user and password for that
// database.
$database_bb="MAMBO DATABASE";

// MySQL username and password to access user database
//
// These two variables are for the userid and password needed to access
// the PhotoPost or BB database.
$user_bb="gallery_user";
$password_bb="xxxxxx";

//
// VB3 License Number required for VB3 integration
// You can find this number by checking your index.php file in your vB3 directory
// The 4th line in the file looks like:
// || # vBulletin 3.0.0 - Licence Number ########
// It is the ######## number you need to place below.
$vblicense "12345678";

//**************** Application Configuration ****************//

// Default Language
// This needs to be set to the name of the directory used inside of the languages directory
$pplang "english";

//////////////////////// Application Configuration ////////////////////////////////
// These variables set the path to the UNZIP, MOGRIFY and JHEAD commands on your system
//
// This only needs to be set if you are allowing ZIP uploads. These are full paths,
// including the name of the executable (.exe extensions for windows)
// The -j option for Info-ZIP's UNZIP tells it to ignore paths in ZIP file
//
// This option is only used in the event the internal UNZIP does not work for you
//$zip_command = "/usr/bin/unzip -j";

// Path to MOGRIFY executable
// There should be no spaces in the directory names, use short names if necessary.
// Examples:
// $mogrify_command = "c:\progra~1\imagemagick\mogrify.exe";
// $mogrify_command = "c:\ImageMagick\mogrify.exe";
$mogrify_command "/usr/bin/mogrify";

?>

Regards
:)




Nibbler

What is your question exactly ? Coppermine can bridge to many forums and cmss

kegobeer

1.3.x has complete instructions on how to bridge with a bbs/cms, and 1.4.x has a bridge wizard that does everything for you.
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

CPG Guru

I know that coppermine can bridge mambo, im having 2 coppermine on my site 1.3.4 & 1.4.1,

1.4.x is bridged with mambo & share same mambo database for both users & picures database.

in photopost we have an option of enter 2 different  databases to share one for datai.e. pics & other for users.

Hope u got it now my attached code is self explantory

Joachim Müller

we will definitely not "borrow" code from a commercial app. Not sure what you're trying to suggest.

CPG Guru

Quote from: GauGau on October 28, 2005, 12:13:59 AM
we will definitely not "borrow" code from a commercial app. Not sure what you're trying to suggest.

Ok i'll tell u  again

If we'vw to install coppermine with mambo cms the whole process is :

1) upload cpg on same site

2) To integrate (bridge) we use same sql database of mambo in cpg , with this automatically all the cpg_ tables are created in mambo database.

3) Now everything is clear if we want to get registered with cpg the user databse is same of mambo or its common database

*** Now in this case in future if i want to delete this database of cpg or want to discontinue mambo cms & want to install any new cms i'll not able to use that immediatly because if i'll delete all the entries of mambo cms or cpg from same database & it can give errors.

   2nd Case  Now when we bridge Photopost with mambo

1) we upload photopost on same site ( like cpg)

2) IN integration process there are two options :-
   
    i) We can use same mambo sql database for sharing users & to install database of
       photopost

     ii) We can use same database for sharing users of mambo but can make new 
         sql database for photopost where al the gallery data will be installed (no users will
        be there in this database,obviously we will set instructions in config of photopost
        from where to get users)

*** Now what the benefit is photopost is only using users from mambo database & all its
      own data is installed in other database, in future if i want to change mambo cms to
      some other,then in photopost ive to change only  shared database name mean to
      say all the gallery database is secure only users will be changed

Sorry if i u cant understand !!!

Please for once read the config code above , there are options written which are self explanable


This is very good feature if u caught what i say



Thanks

Nibbler


CPG Guru

Might be this is a feature request as in cpg forum & script ive not found any option to do this.

Joachim Müller

OK, now I understand. Moving this thread accordingly from "support" to "feature requests".