/**
  * Function used to connect to SPIP
  *
  * @return boolean|DoliDB		Boolean of DoliDB
  */
 function connectSpip()
 {
     $resource = getDoliDBInstance('mysql', ADHERENT_SPIP_SERVEUR, ADHERENT_SPIP_USER, ADHERENT_SPIP_PASS, ADHERENT_SPIP_DB, ADHERENT_SPIP_PORT);
     if ($resource->ok) {
         return $resource;
     }
     dol_syslog('Error when connecting to SPIP ' . ADHERENT_SPIP_SERVEUR . ' ' . ADHERENT_SPIP_USER . ' ' . ADHERENT_SPIP_PASS . ' ' . ADHERENT_SPIP_DB, LOG_ERR);
     return false;
 }

    else $dolibarr_main_db_pass = dol_decode($dolibarr_main_db_encrypted_pass);
}

// $conf is already instancied inside inc.php
$conf->db->type = $dolibarr_main_db_type;
$conf->db->host = $dolibarr_main_db_host;
$conf->db->port = $dolibarr_main_db_port;
$conf->db->name = $dolibarr_main_db_name;
$conf->db->user = $dolibarr_main_db_user;
$conf->db->pass = $dolibarr_main_db_pass;

// For encryption
$conf->db->dolibarr_main_db_encryption	= isset($dolibarr_main_db_encryption)?$dolibarr_main_db_encryption:'';
$conf->db->dolibarr_main_db_cryptkey	= isset($dolibarr_main_db_cryptkey)?$dolibarr_main_db_cryptkey:'';

$db=getDoliDBInstance($conf->db->type,$conf->db->host,$conf->db->user,$conf->db->pass,$conf->db->name,$conf->db->port);

if ($db->connected)
{
    print '<tr><td class="nowrap">';
    print $langs->trans("ServerConnection")." : $dolibarr_main_db_host</td><td align=\"right\">".$langs->trans("OK")."</td></tr>";
    dolibarr_install_syslog("repair: " . $langs->transnoentities("ServerConnection") . ": " . $dolibarr_main_db_host . $langs->transnoentities("OK"));
    $ok = 1;
}
else
{
    print "<tr><td>".$langs->trans("ErrorFailedToConnectToDatabase",$dolibarr_main_db_name)."</td><td align=\"right\">".$langs->transnoentities("Error")."</td></tr>";
    dolibarr_install_syslog("repair: " . $langs->transnoentities("ErrorFailedToConnectToDatabase", $dolibarr_main_db_name));
    $ok = 0;
}

/* Copyright (C) 2004-2007 Laurent Destailleur  <[email protected]>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 */
/**
 *       \file       htdocs/boutique/osc_master.inc.php
 *       \brief      File of preparation of the environment Dolibarr for OSCommerce
 */
/*
 * Creation objet $dbosc
 */
$dbosc = getDoliDBInstance($conf->db->type, $conf->global->OSC_DB_HOST, $conf->global->OSC_DB_USER, $conf->global->OSC_DB_PASS, $conf->global->OSC_DB_NAME, $conf->global->OSC_DB_PORT);
if (!$dbosc->connected) {
    dol_syslog($dbosc, "host=" . $conf->global->OSC_DB_HOST . ", user=" . $conf->global->OSC_DB_USER . ", databasename=" . $conf->global->OSC_DB_NAME . ", " . $db->error, LOG_ERR);
    llxHeader("", $langs->trans("OSCommerceShop"), "");
    print '<div class="error">' . $langs->trans('FailedConnectDBCheckModuleSetup') . '</div>';
    llxFooter();
    exit;
}

// After this $db is a defined handler to database.
// Main
$version = '3.2';
@set_time_limit(0);
$error = 0;
$langs->load("main");
print "***** {$script_file} ({$version}) *****\n";
// -------------------- START OF BUILD_CLASS_FROM_TABLE SCRIPT --------------------
// Check parameters
if (!isset($argv[1]) || isset($argv[2]) && !isset($argv[6])) {
    print "Usage: {$script_file} tablename [server port databasename user pass]\n";
    exit;
}
if (isset($argv[2]) && isset($argv[3]) && isset($argv[4]) && isset($argv[5]) && isset($argv[6])) {
    print 'Use specific database ids' . "\n";
    $db = getDoliDBInstance('mysqli', $argv[2], $argv[5], $argv[6], $argv[4], $argv[3]);
}
if ($db->type != 'mysql' && $db->type != 'mysqli') {
    print "Error: This script works with mysql or mysqli driver only\n";
    exit;
}
// Show parameters
print 'Tablename=' . $argv[1] . "\n";
print "Current dir is " . getcwd() . "\n";
// Define array with list of properties
$property = array();
$table = $argv[1];
$foundprimary = 0;
$resql = $db->DDLDescTable($table);
if ($resql) {
    $i = 0;

    /**
     *  Fonction qui dit si cet utilisateur est un redacteur existant dans spip
     *
     *	@param	Object	$object		Object with data (->login)
     *  @return int     			1=exists, 0=does not exists, -1=error
     */
    function is_in_spip($object)
    {
        if (defined("ADHERENT_USE_SPIP") && ADHERENT_USE_SPIP ==1 &&
        defined('ADHERENT_SPIP_SERVEUR') && ADHERENT_SPIP_SERVEUR != '' &&
        defined('ADHERENT_SPIP_USER') && ADHERENT_SPIP_USER != '' &&
        defined('ADHERENT_SPIP_PASS') && ADHERENT_SPIP_PASS != '' &&
        defined('ADHERENT_SPIP_DB') && ADHERENT_SPIP_DB != '')
        {
            $query = "SELECT login FROM spip_auteurs WHERE login='".$object->login."'";

            $mydb=getDoliDBInstance('mysql',ADHERENT_SPIP_SERVEUR,ADHERENT_SPIP_USER,ADHERENT_SPIP_PASS,ADHERENT_SPIP_DB,ADHERENT_SPIP_PORT);

            if ($mydb->ok)
            {
                $result = $mydb->query($query);

                if ($result)
                {
                    if ($mydb->num_rows($result))
                    {
                        // nous avons au moins une reponse
                        $mydb->close($result);
                        return 1;
                    }
                    else
                    {
                        // nous n'avons pas de reponse => n'existe pas
                        $mydb->close($result);
                        return 0;
                    }
                }
                else
                {
                    $this->error=$mydb->lasterror();
                    $mydb->close();
                    return -1;
                }
            }
            else
            {
                $this->error="Failed to connect ".ADHERENT_SPIP_SERVEUR." ".ADHERENT_SPIP_USER." ".ADHERENT_SPIP_PASS." ".ADHERENT_SPIP_DB;
                return -1;
            }
        }
    }