/**
  * Replaces Rsa key pair. The first step: prepare temporary data on the server:
  * a temporary table in the DB to reencrypt data etc.
  *
  * : close the shop?
  *
  * It removes the temporary table with the reencrypted data order_person_info,
  * if it exists. It creates the same one, by copying order info.
  * It initializes and saves required ancillary variables to the module
  * settings Offline CC.
  *
  */
 function ReplaceRSAKeyPairStep1PrepareServerTmpData()
 {
     global $application;
     $table_prefix = $application->getAppIni('DB_TABLE_PREFIX');
     $table_suffix = modApiFunc("Payment_Module_Offline_CC", "getTmpTableSuffix");
     $table_name = "order_person_data";
     $table_name_with_prefix_and_suffix = $table_prefix . $table_name . $table_suffix;
     $table_name_with_suffix = $table_name . $table_suffix;
     if (DB_MySQL::DB_isTableExists($table_name_with_prefix_and_suffix)) {
         /**
          * Remove old temporary data. It can left if, for example,
          * the previous data reencryption wasn't completed.
          */
         $db_table_delete = new DB_Table_Delete($table_name_with_suffix);
         $application->db->PrepareSQL($db_table_delete);
         $application->db->DB_Exec();
     }
     //Prepare new temporary data for reencrypting.
     new DB_Table_Clone("Checkout", $table_name, $table_name . $table_suffix);
     /**
      * Prepare new optional data storing reencription status.
      *
      * The field order_person_data_id has now an attribute auto_increment now,
      * so just remember that not decrypted, where we stopped last time.
      * All records with great ID will be considered as not reencrypted.
      *
      */
     $this->ReplaceRSAKeyPairStep2ReencryptTmpDataOrderPersonDataId = 1;
     modApiFunc("Payment_Module_Offline_CC", "saveState");
 }
 /**
  * DB_Table_Create class constructor.
  *
  * @return
  * @param array $tables array of meta description of the tables.
  * @ change error messages to error description from resource file
  */
 function DB_Table_Create($tables)
 {
     global $application;
     $table_prefix = $application->getAppIni('DB_TABLE_PREFIX');
     foreach ($tables as $table_name => $table_properties) {
         $table_name = $table_prefix . $table_name;
         if (DB_MySQL::DB_isTableExists($table_name)) {
             _fatal(array("CODE" => "CORE_043"), $table_name);
         }
         $this->QueryType = DBQUERY_TYPE_CREATE;
         $this->CreateTable = $table_name;
         $this->CreateFields = array();
         $this->CreateKeys = array();
         $this->CreateIndexes = array();
         foreach ($table_properties['columns'] as $key => $field) {
             $this->addField($this->parseFieldName($field), $table_properties['types'][$key]);
         }
         if (isset($table_properties['primary']) && sizeof($table_properties['primary']) > 0) {
             $primary_key = array();
             foreach ($table_properties['primary'] as $pk) {
                 array_push($primary_key, $this->parseFieldName($table_properties['columns'][$pk]));
             }
             $this->addKey(implode(', ', $primary_key));
         }
         if (isset($table_properties['indexes']) && sizeof($table_properties['indexes']) > 0) {
             foreach ($table_properties['indexes'] as $index_name => $field_names) {
                 $field_names = str_replace(' ', '', $field_names);
                 $fields = explode(',', $field_names);
                 $index = array();
                 foreach ($fields as $field) {
                     //         ,
                     if (is_int($_pos = _ml_strpos($field, '('))) {
                         $_len = _ml_substr($field, $_pos);
                         $_field_without_len = _ml_substr($field, 0, $_pos);
                         array_push($index, $this->parseFieldName($table_properties['columns'][$_field_without_len]) . $_len);
                     } else {
                         array_push($index, $this->parseFieldName($table_properties['columns'][$field]));
                     }
                 }
                 $this->addIndex(implode(', ', $index), $index_name);
             }
         }
         $application->db->getDB_Result($this);
     }
 }
Beispiel #3
0
 /**
  * Returns Module's version if the module with the specified name is installed.
  */
 function getModuleVersion($moduleName)
 {
     global $application;
     $tables = $this->getTables();
     $module_tbl = 'module';
     $module_columns = $tables[$module_tbl]['columns'];
     if (!DB_MySQL::DB_isTableExists($application->getAppIni('DB_TABLE_PREFIX') . $module_tbl)) {
         // the table 'module' doesn't exist, so update should not be performed
         return '0.0.0';
     }
     static $updated_modules = null;
     if ($updated_modules == null) {
         $db_select = new DB_Select();
         $db_select->addSelectTable($module_tbl);
         $db_select->addSelectField($module_columns['version'], 'version');
         $db_select->WhereValue($module_columns['name'], DB_EQ, $moduleName);
         $result = $application->db->getDB_Result($db_select);
         $updated_modules = array();
         foreach ($result as $resultItem) {
             $resultversion[] = $resultItem['version'];
         }
     }
     if (!empty($resultversion)) {
         return $resultversion[0];
     } else {
         return '0.0.0';
     }
 }