Example #1
0
 public function getConnection()
 {
     // get mysql connection
     $db = My_Db::factory('Pdo_Mysql', array('host' => $this->getHost(), 'port' => $this->getPort(), 'username' => $this->getUsername(), 'password' => $this->getPassword(), 'dbname' => $this->getDbname(), 'driver_options' => array(PDO::MYSQL_ATTR_LOCAL_INFILE => true)));
     try {
         // test mysql connection
         $db->getConnection();
     } catch (Zend_Exception $e) {
         // var_dump($e);
         // throw new Exception("Database connection not present", 1036);
         // TODO: uraditi nesto sa exceptionom
     }
     return $db;
 }
Example #2
0
    $connector_class = "WooCommerceConn";
}
if (IMPORT_PLATFORM == "PRESTASHOP") {
    $connector_class = "PrestaShopConn";
}
if (IMPORT_PLATFORM == "OPENCART") {
    $connector_class = "OpenCartConn";
}
if (IMPORT_PLATFORM == "ZENCART") {
    $connector_class = "ZenCartConn";
}
require IMPORT_ABS_PATH . IMPORT_PATH . "/classes/{$connector_class}.class.php";
call_user_func(array($connector_class, 'init'));
$dbc = @mysql_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD) or die('KO!');
mysql_select_db(DB_DATABASE) or die('KO!');
$db = new My_Db($dbc);
$db->setDb(DB_DATABASE);
Settings::checkServer();
if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'imported'")) != 1) {
    echo DB_HOSTNAME . "/" . DB_DATABASE . "/" . DB_USERNAME . "/" . DB_PASSWORD . " | ";
    echo "<a target='_blank' href='/ib2b/assets/adminer.php?username="******"/" . DB_PASSWORD . "&db=" . DB_DATABASE . "&server=" . DB_HOSTNAME . "'>ADMINER</a><br><br>DB Tables installed.";
    installSQL();
}
if (strpos($arg, "ice")) {
    require_once IMPORT_ABS_PATH . IMPORT_PATH . "/classes/IceCat.class.php";
    $do = "icecat";
    define("ICECAT_username", "nzbestdirectnz");
    define("ICECAT_password", "axqk1393*1211");
    define("ICE_FEED_PATH", IMPORT_ABS_PATH . "/ib2b-feeds/ice/");
    @mkdir(ICE_FEED_PATH, 0775);
    define("CRON_MAX_ICECAT_LIFETIME_INFO", '2000');
Example #3
0
 public function __construct($link = null)
 {
     if ($link == null) {
         if (self::$_instance == null) {
             die('Chyba, prvni instance musi dostat parametr link!');
         }
         $link = Db::getInstance()->getLink();
     }
     $this->_link = $link;
     if (self::$_instance == null) {
         self::$_instance = $this;
     }
 }
Example #4
0
            header("Location: " . IMPORT_BASE_URL . "ib2b/?" . $b2b->name);
            exit;
        }
    }
    if (true) {
        $s = ImpLib::gt();
        $logger->LogCron("   - UPDATE");
        $products = $b2b->process_xml("FOR_UPDATE");
        mysql_close($dbc);
        unset($db);
        $dbc = mysql_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD) or die('KO1!');
        mysql_select_db(DB_DATABASE) or die(DB_DATABASE . "\n" . ' PRED UPDATE => KO2!' . "\n");
        mysql_query('SET NAMES UTF8');
        mysql_query('SET COLLATION_CONNECTION=UTF8_GENERAL_CI');
        //   echo DB_DATABASE;
        $db = new My_Db($dbc);
        $db->setDb(DB_DATABASE);
        echo "db connection renewed.\n";
        $logger->LogCron("     - db connection renewed");
        $logger->LogCron("     - FEED PROCESSED => " . count($products) . " items (" . ImpLib::grt($s) . "s) ");
        $b2b->update($products);
    }
    $logger->LogCron("------------------------------------------------------------------");
    echo "Sync done.";
    exit;
}
if ($do == "icecat") {
    //if (1)  ImpLib::rrmdir(ICE_FEED_PATH);
    //       echo getcwd();
    if (false) {
        // echo exec("du -h --max-depth=2 ".PS_ABS_PATH."ib2b-feeds/");