function migrateData() { $phpAdsNew = new OA_phpAdsNew(); $aPanConfig = $phpAdsNew->_getPANConfig(); $aValues['warn_limit_days'] = $aPanConfig['warn_limit_days'] ? $aPanConfig['warn_limit_days'] : 1; $sql = OA_DB_SQL::sqlForInsert('preference', $aValues); $result = $this->oDBH->exec($sql); return !PEAR::isError($result); }
function migrateData() { $prefix = $this->getPrefix(); $tablePreference = $prefix . 'preference'; $aColumns = $this->oDBH->manager->listTableFields($tablePreference); $sql = "\n\t SELECT * from {$prefix}config"; $rsConfig = DBC::NewRecordSet($sql); if ($rsConfig->find() && $rsConfig->fetch()) { $aDataConfig = $rsConfig->toArray(); $aValues = array(); foreach ($aDataConfig as $column => $value) { if (in_array($column, $aColumns)) { $aValues[$column] = $value; } } // Migrate PAN config variables $phpAdsNew = new OA_phpAdsNew(); $aPanConfig = $phpAdsNew->_getPANConfig(); $aValues['warn_admin'] = $aPanConfig['warn_admin'] ? 't' : 'f'; $aValues['warn_client'] = $aPanConfig['warn_client'] ? 't' : 'f'; $aValues['warn_limit'] = $aPanConfig['warn_limit'] ? $aPanConfig['warn_limit'] : 100; $aValues['default_banner_url'] = $aPanConfig['default_banner_url']; $aValues['default_banner_destination'] = $aPanConfig['default_banner_target']; $result = $this->createGeoTargetingConfiguration($aPanConfig['geotracking_type'], $aPanConfig['geotracking_location'], $aPanConfig['geotracking_stats']); if ($result === false) { return $this->_logErrorAndReturnFalse('Error configuring geotargeting'); } $sql = OA_DB_SQL::sqlForInsert('preference', $aValues); $result = $this->oDBH->exec($sql); if (PEAR::isError($result)) { return $this->_logErrorAndReturnFalse('Error inserting preferences during data migration 108: ' . $result->getUserInfo()); } return true; } else { return false; } }