[ Closed ] Патчи. Заплатки. Устранение ошибок PunBB 1.4.4

function DBLayer($db_host, $db_username, $db_password, $db_name, $db_prefix, $p_connect)

function __construct($db_host, $db_username, $db_password, $db_name, $db_prefix, $p_connect)

   function add_field($table_name, $field_name, $field_type, $allow_null, $default_value = null, $after_field = 0, $no_prefix = false)
   {
      if ($this->field_exists($table_name, $field_name, $no_prefix))
         return;

      $table = $this->get_table_info($table_name, $no_prefix);

      // Create temp table
      $now = time();
      $tmptable = str_replace('CREATE TABLE '.($no_prefix ? '' : $this->prefix).$this->escape($table_name).' (', 'CREATE TABLE '.($no_prefix ? '' : $this->prefix).$this->escape($table_name).'_t'.$now.' (', $table['sql']);
      $this->query($tmptable) or error(__FILE__, __LINE__);
      $this->query('INSERT INTO '.($no_prefix ? '' : $this->prefix).$this->escape($table_name).'_t'.$now.' SELECT * FROM '.($no_prefix ? '' : $this->prefix).$this->escape($table_name)) or error(__FILE__, __LINE__);

      // Create new table sql
      $field_type = preg_replace(array_keys($this->datatype_transformations), array_values($this->datatype_transformations), $field_type);
      $query = $field_type;
      if (!$allow_null)
         $query .= ' NOT NULL';
      if ($default_value === null || $default_value === '')
         $default_value = '\'\'';

      $query .= ' DEFAULT '.$default_value;

      $old_columns = array_keys($table['columns']);
      array_insert($table['columns'], $after_field, $query.',', $field_name);

      $new_table = 'CREATE TABLE '.($no_prefix ? '' : $this->prefix).$this->escape($table_name).' (';

      foreach ($table['columns'] as $cur_column => $column_details)
         $new_table .= "\n".$cur_column.' '.$column_details;

      if (isset($table['unique']))
         $new_table .= "\n".$table['unique'].',';

      if (isset($table['primary_key']))
         $new_table .= "\n".$table['primary_key'];

      $new_table = trim($new_table, ',')."\n".');';

      // Drop old table
      $this->drop_table($table_name, $no_prefix);

      // Create new table
      $this->query($new_table) or error(__FILE__, __LINE__);

      // Recreate indexes
      if (!empty($table['indices']))
      {
         foreach ($table['indices'] as $cur_index)
            $this->query($cur_index) or error(__FILE__, __LINE__);
      }

      //Copy content back
      $this->query('INSERT INTO '.($no_prefix ? '' : $this->prefix).$this->escape($table_name).' ('.implode(', ', $old_columns).') SELECT * FROM '.($no_prefix ? '' : $this->prefix).$this->escape($table_name).'_t'.$now) or error(__FILE__, __LINE__);

      // Drop temp table
      $this->drop_table($table_name.'_t'.$now, $no_prefix);
   }

   function add_field($table_name, $field_name, $field_type, $allow_null, $default_value = null, $after_field = null, $no_prefix = false)
   {
      if ($this->field_exists($table_name, $field_name, $no_prefix))
         return;

      $field_type = preg_replace(array_keys($this->datatype_transformations), array_values($this->datatype_transformations), $field_type);

      if ($default_value !== null && !is_int($default_value) && !is_float($default_value))
         $default_value = '\''.$this->escape($default_value).'\'';

      $this->query('ALTER TABLE '.($no_prefix ? '' : $this->prefix).$table_name.' ADD '.$field_name.' '.$field_type.($allow_null ? ' ' : ' NOT NULL').($default_value !== null ? ' DEFAULT '.$default_value : ' ').($after_field != null ? ' AFTER '.$after_field : '')) or error(__FILE__, __LINE__);
   }