public function install_MX()
{
$path = realpath(dirname(__FILE__));
$this->Install_Path = realpath(dirname($path, 1)) . self::DS;
unset($path);
$FsConf = $this->Install_Path . 'config.php';
$FsUnI = $this->Install_Path . 'plugins' . self::DS . 'admin_mexico' . self::DS . 'extras' . self::DS . 'uninstall.xml';
if (!copy($FsConf, $FsConf . '.bak')) {
return (bool) false;
}
if (is_writable($FsConf)) {
$strConf = file_get_contents($FsConf);
if (strpos($strConf, "define('FS_INSTALL_PATH',") === false) {
$setDef = self::R . '/// Modificación admin_mexico' . self::R . "define('FS_INSTALL_PATH', '" . $this->Install_Path . "');";
if (!file_put_contents($FsConf, $setDef, FILE_APPEND | LOCK_EX)) {
return (bool) false;
}
}
unset($strConf);
if (file_exists($FsUnI)) {
unlink($FsUnI);
}
$fp = fopen($FsUnI, 'w+');
fwrite($fp, '<?xml version="1.0" encoding="UTF-8"?>' . "\r\n");
fwrite($fp, '<files>' . self::R);
fclose($fp);
require_once $this->Install_Path . 'base' . self::DS . 'fs_db2.php';
$db = new fs_db2();
if ($db->connect()) {
$tables = $db->list_tables();
file_put_contents($FsUnI, '<databases>' . self::R, FILE_APPEND | LOCK_EX);
$qry = "SELECT TABLE_NAME AS name FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '" . FS_DB_NAME . "' AND COLUMN_NAME = 'codpostal' AND TABLE_NAME='empresa';";
if ($rs = $db->select($qry)) {
foreach ($rs as $tb) {
$e = '<tb nam="' . $tb["name"] . '" />' . self::R;
file_put_contents($FsUnI, $e, FILE_APPEND | LOCK_EX);
$db->exec("ALTER TABLE " . $tb["name"] . " ADD colonia TEXT NULL AFTER codpostal;", false);
}
}
file_put_contents($FsUnI, '</databases>' . self::R . '</files>', FILE_APPEND | LOCK_EX);
} else {
return (bool) false;
}
return (bool) false;
} else {
return (bool) false;
}
}
/**
* Comprueba y actualiza la estructura de la tabla si es necesario
* @param type $table_name
* @return boolean
*/
protected function check_table($table_name)
{
$done = TRUE;
$consulta = '';
$xml_columnas = array();
$xml_restricciones = array();
if ($this->get_xml_table($table_name, $xml_columnas, $xml_restricciones)) {
if ($this->db->table_exists($table_name)) {
if (!$this->db->check_table_aux($table_name)) {
$this->new_error_msg('Error al convertir la tabla a InnoDB.');
}
/// eliminamos restricciones
$restricciones = $this->db->get_constraints($table_name);
$consulta2 = $this->db->compare_constraints($table_name, $xml_restricciones, $restricciones, TRUE);
if ($consulta2 != '') {
if (!$this->db->exec($consulta2)) {
$this->new_error_msg('Error al comprobar la tabla ' . $table_name);
}
}
/// comparamos las columnas
$columnas = $this->db->get_columns($table_name);
$consulta .= $this->db->compare_columns($table_name, $xml_columnas, $columnas);
/// comparamos las restricciones
$restricciones = $this->db->get_constraints($table_name);
$consulta .= $this->db->compare_constraints($table_name, $xml_restricciones, $restricciones);
} else {
/// generamos el sql para crear la tabla
$consulta .= $this->db->generate_table($table_name, $xml_columnas, $xml_restricciones);
$consulta .= $this->install();
}
if ($consulta != '') {
if (!$this->db->exec($consulta)) {
$this->new_error_msg('Error al comprobar la tabla ' . $table_name);
$done = FALSE;
}
}
} else {
$this->new_error_msg('Error con el xml.');
$done = FALSE;
}
return $done;
}
