protected function conn() { isset($this->username); isset($this->password); if (!$this->db instanceof PDO) { $this->db = DB_Connect::getInstance($this->dsn, $this->username, $this->password); } }
set_include_path($ini_path); // Include functions. require_once 'functions.php'; $registry = new Registry(); /*{START_INI_DIR}*/ $registry->ini_dir = realpath(__SITE_PATH . '/../../uthando/ini'); /*{END_INI_DIR}*/ $registry->config = new Config($registry, array('path' => $registry->ini_dir . '/uthando.ini.php')); $registry->ushop_config = new Config($registry, array('path' => $registry->ini_dir . '/ushop.ini.php')); $core = $registry->config->get('core', 'DATABASE') . '.'; $user = $registry->config->get('user', 'DATABASE') . '.'; try { // connect user to database. $dsn = array('hostspec' => $registry->config->get('hostspec', 'DATABASE'), 'phptype' => $registry->config->get('phptype', 'DATABASE'), 'database' => $registry->config->get('user', 'DATABASE')); $dsn = array_merge($dsn, $registry->config->get('DATABASE_USER')); $db = DB_Connect::getInstance($dsn['phptype'] . ":host=" . $dsn['hostspec'] . ";dbname=" . $dsn['database'], $dsn['username'], $dsn['password']); $paypal = new Payment_Paypal_IPN($registry); if ($paypal->validateIPN()) { $verified = array(); // check invoice. if (isset($paypal->ipn_data['invoice'])) { $stmt = $db->prepare("\n\t\t\t\tSELECT order_id\n\t\t\t\tFROM " . $user . "ushop_orders\n\t\t\t\tWHERE invoice = :invoice\n\t\t\t\tLIMIT 1\n\t\t\t"); $stmt->execute(array(':invoice' => $paypal->ipn_data['invoice'])); $res = $stmt->fetch(PDO::FETCH_OBJ); $verified['order_id'] = $res->order_id; } else { $verified['order_id'] = false; } // check payment status if ($paypal->ipn_data['payment_status'] == "Completed") { $verified['payment_status'] = true;