henrystivens / upload-image-and-data

core/libs/db/db.php

Spacing +1 added lines, -1 removed lines

@@ -85,7 +85,7 @@
             $dbclass = "DbPdo{$config['type']}";
             $db_file = "$path/adapters/pdo/{$config['type']}.php";
         } else {
-            if($config['type'] == 'mysql') $config['type'] = 'mysqli';
+            if ($config['type'] == 'mysql') $config['type'] = 'mysqli';
             $dbclass = "Db{$config['type']}";
             $db_file = "$path/adapters/{$config['type']}.php";
         }

Braces +3 added lines, -1 removed lines

@@ -85,7 +85,9 @@
             $dbclass = "DbPdo{$config['type']}";
             $db_file = "$path/adapters/pdo/{$config['type']}.php";
         } else {
-            if($config['type'] == 'mysql') $config['type'] = 'mysqli';
+            if($config['type'] == 'mysql') {
+                $config['type'] = 'mysqli';
+            }
             $dbclass = "Db{$config['type']}";
             $db_file = "$path/adapters/{$config['type']}.php";
         }

core/libs/db/adapters/pdo.php

Spacing +13 added lines, -13 removed lines

@@ -196,7 +196,7 @@ 
      * @param int $opt
      * @return array
      */
-    public function fetch_array($pdo_statement=NULL, $opt='')
+    public function fetch_array($pdo_statement = NULL, $opt = '')
     {
         if ($opt === '') {
             $opt = self::DB_BOTH;
@@ -235,7 +235,7 @@ 
      * @deprecated
      * @return int
      */
-    public function num_rows($pdo_statement='')
+    public function num_rows($pdo_statement = '')
     {
         if ($pdo_statement) {
             $pdo = clone $pdo_statement;
@@ -252,7 +252,7 @@ 
      * @param resource $pdo_statement
      * @return string
      */
-    public function field_name($number, $pdo_statement=NULL)
+    public function field_name($number, $pdo_statement = NULL)
     {
         if (!$this->pdo) {
             throw new KumbiaException('No hay conexión para realizar esta acción');
@@ -278,7 +278,7 @@ 
      * @param PDOStatement $pdo_statement
      * @return boolean
      */
-    public function data_seek($number, $pdo_statement=NULL)
+    public function data_seek($number, $pdo_statement = NULL)
     {
         return false;
     }
@@ -290,7 +290,7 @@ 
      * @deprecated
      * @return int
      */
-    public function affected_rows($pdo_statement=NULL)
+    public function affected_rows($pdo_statement = NULL)
     {
         if (!$this->pdo) {
             throw new KumbiaException('No hay conexión para realizar esta acción');
@@ -315,7 +315,7 @@ 
      *
      * @return string
      */
-    public function error($err='')
+    public function error($err = '')
     {
         if ($this->pdo) {
             $error = $this->pdo->errorInfo();
@@ -323,7 +323,7 @@ 
         } else {
             $error = "";
         }
-        $this->last_error.= $error . " [" . $err . "]";
+        $this->last_error .= $error . " [" . $err . "]";
         if ($this->logger) {
             Logger::error($this->last_error);
         }
@@ -335,7 +335,7 @@ 
      *
      * @return int
      */
-    public function no_error($number=0)
+    public function no_error($number = 0)
     {
         if ($this->pdo) {
             $error = $this->pdo->errorInfo();
@@ -349,7 +349,7 @@ 
      *
      * @return string
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
         return $this->pdo->lastInsertId();
     }
@@ -399,7 +399,7 @@ 
      * @param array $fields
      * @return integer
      */
-    public function insert($table, $values, $fields=null)
+    public function insert($table, $values, $fields = null)
     {
         //$insert_sql = "";
         if (is_array($values)) {
@@ -426,7 +426,7 @@ 
      * @param string $where_condition
      * @return integer
      */
-    public function update($table, $fields, $values, $where_condition=null)
+    public function update($table, $fields, $values, $where_condition = null)
     {
         $update_sql = "UPDATE $table SET ";
         if (count($fields) != count($values)) {
@@ -438,9 +438,9 @@ 
             $update_values[] = $field . ' = ' . $values[$i];
             $i++;
         }
-        $update_sql.= join(',', $update_values);
+        $update_sql .= join(',', $update_values);
         if ($where_condition != null) {
-            $update_sql.= " WHERE $where_condition";
+            $update_sql .= " WHERE $where_condition";
         }
         return $this->exec($update_sql);
     }

core/libs/db/adapters/oracle.php

Spacing +15 added lines, -15 removed lines

@@ -195,7 +195,7 @@ 
      * @param int $opt
      * @return array
      */
-    function fetch_array($resultQuery=NULL, $opt=OCI_BOTH)
+    function fetch_array($resultQuery = NULL, $opt = OCI_BOTH)
     {
 
         if (!$resultQuery) {
@@ -228,7 +228,7 @@ 
     /**
      * Devuelve el numero de filas de un select
      */
-    function num_rows($resultQuery=NULL)
+    function num_rows($resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -267,7 +267,7 @@ 
      * @param resource $resultQuery
      * @return string
      */
-    function field_name($number, $resultQuery=NULL)
+    function field_name($number, $resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -291,7 +291,7 @@ 
      * @param resource $resultQuery
      * @return boolean
      */
-    function data_seek($number, $resultQuery=NULL)
+    function data_seek($number, $resultQuery = NULL)
     {
         if (!$resultQuery) {
             $resultQuery = $this->last_result_query;
@@ -325,7 +325,7 @@ 
      * @param resource $resultQuery
      * @return int
      */
-    function affected_rows($resultQuery=NULL)
+    function affected_rows($resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -346,12 +346,12 @@ 
      *
      * @return string
      */
-    function error($err='')
+    function error($err = '')
     {
         if (!$this->id_connection) {
             $error = oci_error() ? oci_error() : "[Error Desconocido en Oracle]";
             if (is_array($error)) {
-                $error['message'].=" > $err ";
+                $error['message'] .= " > $err ";
                 return $error['message'];
             } else {
                 //$error.=" $php_errormsg ";
@@ -360,7 +360,7 @@ 
         }
         $error = oci_error($this->id_connection);
         if ($error) {
-            $error['message'].=" > $err ";
+            $error['message'] .= " > $err ";
         } else {
             $error['message'] = $err;
         }
@@ -418,7 +418,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             if ($this->table_exists($table)) {
@@ -444,7 +444,7 @@ 
      * @param array $definition
      * @return resource
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -494,7 +494,7 @@ 
             }
             $create_lines[] = "$field " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -506,7 +506,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -526,7 +526,7 @@ 
      *
      * @return int
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
         if (!$this->id_connection) {
             return false;
@@ -548,7 +548,7 @@ 
      * @param string $table
      * @return boolean
      */
-    function table_exists($table, $schema='')
+    function table_exists($table, $schema = '')
     {
         $num = $this->fetch_one("SELECT COUNT(*) FROM ALL_TABLES WHERE TABLE_NAME = '" . strtoupper($table) . "'");
         return $num[0];
@@ -560,7 +560,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         /**
          * Soporta schemas?

core/libs/db/adapters/mssql.php

Spacing +54 added lines, -54 removed lines

@@ -26,7 +26,7 @@ 
  * @package    Db
  * @subpackage Adapters
  */
-class DbMsSQL extends DbBase implements DbBaseInterface  {
+class DbMsSQL extends DbBase implements DbBaseInterface {
 
     /**
      * Resource de la Conexión a MsSQL
@@ -116,17 +116,17 @@ 
      * @param array $config
      * @return bool
      */
-    public function connect($config){
-        if(!extension_loaded('mssql')){
+    public function connect($config) {
+        if (!extension_loaded('mssql')) {
             throw new KumbiaException('Debe cargar la extensión de PHP llamada php_mssql');
         }
-        if(!isset($config['port']) || !$config['port']) {
+        if (!isset($config['port']) || !$config['port']) {
             $config['port'] = 1433;
         }
         //if($this->id_connection = mssql_connect("{$config['host']},{$config['port']}", $config['username'], $config['password'], true)){
-        if($this->id_connection = mssql_connect($config['host'], $config['username'], $config['password'], true)){
-            if($config['name']!=='') {
-                if(!mssql_select_db($config['name'], $this->id_connection)){
+        if ($this->id_connection = mssql_connect($config['host'], $config['username'], $config['password'], true)) {
+            if ($config['name'] !== '') {
+                if (!mssql_select_db($config['name'], $this->id_connection)) {
                     throw new KumbiaException($this->error());
                 }
             }
@@ -141,25 +141,25 @@ 
      * @param string $sql_query
      * @return resource or false
      */
-    public function query($sql_query){
+    public function query($sql_query) {
         $this->debug($sql_query);
-        if($this->logger){
+        if ($this->logger) {
             Logger::debug($sql_query);
         }
 
         $this->last_query = $sql_query;
-        if($result_query = mssql_query($sql_query, $this->id_connection)){
+        if ($result_query = mssql_query($sql_query, $this->id_connection)) {
             $this->last_result_query = $result_query;
             return $result_query;
-        }else{
+        } else {
             throw new KumbiaException($this->error(" al ejecutar <em>\"$sql_query\"</em>"));
         }
     }
     /**
      * Cierra la Conexión al Motor de Base de datos
      */
-    public function close(){
-        if($this->id_connection) {
+    public function close() {
+        if ($this->id_connection) {
             return mssql_close();
         }
         return false;
@@ -171,11 +171,11 @@ 
      * @param int $opt
      * @return array
      */
-    public function fetch_array($result_query='', $opt=MSSQL_BOTH){
+    public function fetch_array($result_query = '', $opt = MSSQL_BOTH) {
 
-        if(!$result_query){
+        if (!$result_query) {
             $result_query = $this->last_result_query;
-            if(!$result_query){
+            if (!$result_query) {
                 return false;
             }
         }
@@ -186,21 +186,21 @@ 
      *
      * @param array $config
      */
-    public function __construct($config){
+    public function __construct($config) {
         $this->connect($config);
     }
     /**
      * Devuelve el número de filas de un select
      */
-    public function num_rows($result_query=''){
+    public function num_rows($result_query = '') {
 
-        if(!$result_query){
+        if (!$result_query) {
             $result_query = $this->last_result_query;
-            if(!$result_query){
+            if (!$result_query) {
                 return false;
             }
         }
-        if(($number_rows = mssql_num_rows($result_query))!==false){
+        if (($number_rows = mssql_num_rows($result_query)) !== false) {
             return $number_rows;
         } else {
             throw new KumbiaException($this->error());
@@ -214,15 +214,15 @@ 
      * @param resource $result_query
      * @return string
      */
-    public function field_name($number, $result_query=''){
+    public function field_name($number, $result_query = '') {
 
-        if(!$result_query){
+        if (!$result_query) {
             $result_query = $this->last_result_query;
-            if(!$result_query){
+            if (!$result_query) {
                 return false;
             }
         }
-        if(($fieldName = mssql_field_name($result_query, $number))!==false){
+        if (($fieldName = mssql_field_name($result_query, $number)) !== false) {
             return $fieldName;
         } else {
             throw new KumbiaException($this->error());
@@ -235,14 +235,14 @@ 
      * @param resource $result_query
      * @return boolean
      */
-    public function data_seek($number, $result_query=''){
-        if(!$result_query){
+    public function data_seek($number, $result_query = '') {
+        if (!$result_query) {
             $result_query = $this->last_result_query;
-            if(!$result_query){
+            if (!$result_query) {
                 return false;
             }
         }
-        if(($success = mssql_data_seek($result_query, $number))!==false){
+        if (($success = mssql_data_seek($result_query, $number)) !== false) {
             return $success;
         } else {
             throw new KumbiaException($this->error());
@@ -255,8 +255,8 @@ 
      * @param resource $result_query
      * @return int
      */
-    public function affected_rows($result_query=''){
-        if(($numberRows = mssql_affected_rows())!==false){
+    public function affected_rows($result_query = '') {
+        if (($numberRows = mssql_affected_rows()) !== false) {
             return $numberRows;
         } else {
             throw new KumbiaException($this->error());
@@ -268,17 +268,17 @@ 
      *
      * @return string
      */
-    public function error($err=''){
-        if(!$this->id_connection){
+    public function error($err = '') {
+        if (!$this->id_connection) {
             $this->last_error = mssql_get_last_message() ? mssql_get_last_message() : "[Error Desconocido en MsSQL: $err]";
-            if($this->logger){
+            if ($this->logger) {
                 Logger::error($this->last_error);
             }
             return $this->last_error;
         }
         $this->last_error = mssql_get_last_message() ? mssql_get_last_message() : "[Error Desconocido en MsSQL: $err]";
-        $this->last_error.= $err;
-        if($this->logger){
+        $this->last_error .= $err;
+        if ($this->logger) {
             Logger::error($this->last_error);
         }
         return $this->last_error;
@@ -288,7 +288,7 @@ 
      *
      * @return int
      */
-    public function no_error(){
+    public function no_error() {
         return mssql_errno();
     }
     /**
@@ -296,7 +296,7 @@ 
      *
      * @return int
      */
-    public function last_insert_id($table='', $primary_key=''){
+    public function last_insert_id($table = '', $primary_key = '') {
 
         //$id = false;
         $result = mssql_query("select max({$primary_key}) from $table");
@@ -312,9 +312,9 @@ 
      * @param string $table
      * @return boolean
      */
-    public function table_exists($table, $schema=''){
+    public function table_exists($table, $schema = '') {
         $table = addslashes("$table");
-        if($schema==''){
+        if ($schema == '') {
             $num = $this->fetch_one("SELECT COUNT(*) FROM
                         INFORMATION_SCHEMA.TABLES
                         WHERE TABLE_NAME = '$table'");
@@ -333,11 +333,11 @@ 
      * @param string $sql consulta sql
      * @return string
      */
-    public function limit($sql){
+    public function limit($sql) {
         $params = Util::getParams(func_get_args());
 
         //TODO: añadirle el offset
-        if(isset($params['limit'])){
+        if (isset($params['limit'])) {
             $sql = str_ireplace("SELECT ", "SELECT TOP $params[limit] ", $sql);
         }
         return $sql;
@@ -349,8 +349,8 @@ 
      * @param string $table
      * @return resource
      */
-    public function drop_table($table, $if_exists=true){
-        if($if_exists){
+    public function drop_table($table, $if_exists = true) {
+        if ($if_exists) {
             $sql = "IF EXISTS(SELECT TABLE_NAME FROM
             INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '$table')
             DROP TABLE $table;";
@@ -364,7 +364,7 @@ 
      *
      * @return array
      */
-    public function list_tables(){
+    public function list_tables() {
         return $this->fetch_all("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES");
     }
 
@@ -388,20 +388,20 @@ 
         return $this->fetch_all($sql);
     }
     */
-        public function describe_table($table, $schema=''){
+        public function describe_table($table, $schema = '') {
                 $describeTable = $this->fetch_all("exec sp_columns @table_name = '$table'");
                 $finalDescribe = array();
-                foreach($describeTable as $field){
+                foreach ($describeTable as $field) {
                         $finalDescribe[] = array(
                                 'Field' => $field['COLUMN_NAME'],
-                                'Type' => $field['LENGTH'] ? $field['TYPE_NAME'] : $field['TYPE_NAME'].'('.$field['LENGTH'].')',
+                                'Type' => $field['LENGTH'] ? $field['TYPE_NAME'] : $field['TYPE_NAME'] . '(' . $field['LENGTH'] . ')',
                                 'Null' => $field['NULLABLE'] == 1 ? 'YES' : 'NO'
                         );
                 }
                 $describeKeys = $this->fetch_all("exec sp_pkeys @table_name = '$table'");
-                foreach($describeKeys as $field){
-                        for($i=0;$i<=count($finalDescribe)-1;++$i){
-                                if($finalDescribe[$i]['Field']==$field['COLUMN_NAME']){
+                foreach ($describeKeys as $field) {
+                        for ($i = 0; $i <= count($finalDescribe) - 1; ++$i) {
+                                if ($finalDescribe[$i]['Field'] == $field['COLUMN_NAME']) {
                                         $finalDescribe[$i]['Key'] = 'PRI';
                                 } else {
                                         $finalDescribe[$i]['Key'] = "";
@@ -418,14 +418,14 @@ 
      * @param resource $result_query
      * @return object
      */
-    public function fetch_object($result_query = NULL){
-        if(!$result_query){
+    public function fetch_object($result_query = NULL) {
+        if (!$result_query) {
             $result_query = $this->last_result_query;
         }
         return mssql_fetch_object($result_query);
     }
 
-    public function create_table ($table, $definition, $index = array()){
+    public function create_table($table, $definition, $index = array()) {
 
     }
 }

Braces +1 added lines, -1 removed lines

@@ -151,7 +151,7 @@
         if($result_query = mssql_query($sql_query, $this->id_connection)){
             $this->last_result_query = $result_query;
             return $result_query;
-        }else{
+        } else{
             throw new KumbiaException($this->error(" al ejecutar <em>\"$sql_query\"</em>"));
         }
     }

core/libs/db/adapters/pgsql.php

Spacing +17 added lines, -17 removed lines

@@ -174,7 +174,7 @@ 
      * @param int $opt
      * @return array
      */
-    function fetch_array($resultQuery=NULL, $opt=PGSQL_BOTH)
+    function fetch_array($resultQuery = NULL, $opt = PGSQL_BOTH)
     {
 
         if (!$resultQuery) {
@@ -199,7 +199,7 @@ 
     /**
      * Devuelve el numero de filas de un select
      */
-    function num_rows($resultQuery=NULL)
+    function num_rows($resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -222,7 +222,7 @@ 
      * @param resource $resultQuery
      * @return string
      */
-    function field_name($number, $resultQuery=NULL)
+    function field_name($number, $resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -245,7 +245,7 @@ 
      * @param resource $resultQuery
      * @return boolean
      */
-    function data_seek($number, $resultQuery=NULL)
+    function data_seek($number, $resultQuery = NULL)
     {
         if (!$resultQuery) {
             $resultQuery = $this->last_result_query;
@@ -266,7 +266,7 @@ 
      * @param resource $resultQuery
      * @return int
      */
-    function affected_rows($resultQuery=NULL)
+    function affected_rows($resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -287,7 +287,7 @@ 
      *
      * @return string
      */
-    function error($err='')
+    function error($err = '')
     {
         if (!$this->id_connection) {
             $this->last_error = @pg_last_error() ? @pg_last_error() . $err : "[Error Desconocido en PostgreSQL \"$err\"]";
@@ -297,7 +297,7 @@ 
             return $this->last_error;
         }
         $this->last_error = @pg_last_error() ? @pg_last_error() . $err : "[Error Desconocido en PostgreSQL: $err]";
-        $this->last_error.= $err;
+        $this->last_error .= $err;
         if ($this->logger) {
             Logger::error($this->last_error);
         }
@@ -320,7 +320,7 @@ 
      *
      * @return int
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
 
         $last_id = $this->fetch_one("SELECT CURRVAL('{$table}_{$primary_key}_seq')");
@@ -333,7 +333,7 @@ 
      * @param string $table
      * @return boolean
      */
-    function table_exists($table, $schema='')
+    function table_exists($table, $schema = '')
     {
         $table = addslashes(strtolower($table));
         if (strpos($table, ".")) {
@@ -360,11 +360,11 @@ 
         $sql_new = $sql;
 
         if (isset($params['limit']) && is_numeric($params['limit'])) {
-            $sql_new.=" LIMIT $params[limit]";
+            $sql_new .= " LIMIT $params[limit]";
         }
 
         if (isset($params['offset']) && is_numeric($params['offset'])) {
-            $sql_new.=" OFFSET $params[offset]";
+            $sql_new .= " OFFSET $params[offset]";
         }
 
         return $sql_new;
@@ -376,7 +376,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             if ($this->table_exists($table)) {
@@ -402,7 +402,7 @@ 
      * @param array $definition
      * @return resource
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -452,7 +452,7 @@ 
             }
             $create_lines[] = "$field " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -464,7 +464,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -493,7 +493,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         $describe = $this->fetch_all("SELECT a.attname AS Field, t.typname AS Type,
                 CASE WHEN attnotnull=false THEN 'YES' ELSE 'NO' END AS Null,
@@ -523,7 +523,7 @@ 
      * @param string $class clase de objeto
      * @return object
      */
-    public function fetch_object($query_result=null, $class='stdClass')
+    public function fetch_object($query_result = null, $class = 'stdClass')
     {
         if (!$query_result) {
             $query_result = $this->last_result_query;

core/libs/db/adapters/pdo/access.php

Spacing +11 added lines, -11 removed lines

@@ -92,7 +92,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function table_exists($table, $schema='')
+    public function table_exists($table, $schema = '')
     {
         $table = addslashes("$table");
         $num = $this->fetch_one("SELECT COUNT(*) FROM sysobjects WHERE type = 'U' AND name = '$table'");
@@ -119,12 +119,12 @@ 
         $sql = preg_replace('/^SELECT\s/i', 'SELECT TOP ' . ($number) . ' ', $sql);
         $sql = 'SELECT * FROM (SELECT TOP ' . $number . ' * FROM (' . $sql . ') AS itable';
         if ($orderby !== false) {
-            $sql.= ' ORDER BY ' . $order . ' ';
-            $sql.= ( stripos($sort, 'asc') !== false) ? 'DESC' : 'ASC';
+            $sql .= ' ORDER BY ' . $order . ' ';
+            $sql .= (stripos($sort, 'asc') !== false) ? 'DESC' : 'ASC';
         }
-        $sql.= ') AS otable';
+        $sql .= ') AS otable';
         if ($orderby !== false) {
-            $sql.=' ORDER BY ' . $order . ' ' . $sort;
+            $sql .= ' ORDER BY ' . $order . ' ' . $sort;
         }
         return $sql;
     }
@@ -135,7 +135,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             if ($this->table_exists($table)) {
@@ -161,7 +161,7 @@ 
      * @param array $definition
      * @return boolean
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -211,7 +211,7 @@ 
             }
             $create_lines[] = "$field " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -223,7 +223,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -244,7 +244,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         $describe_table = $this->fetch_all("exec sp_columns @table_name = '$table'");
         $final_describe = array();
@@ -273,7 +273,7 @@ 
      *
      * @return integer
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
         /**
          * Porque no funciona SELECT SCOPE_IDENTITY()?

core/libs/db/adapters/pdo/mysql.php

Spacing +8 added lines, -8 removed lines

@@ -95,7 +95,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function table_exists($table, $schema='')
+    public function table_exists($table, $schema = '')
     {
         $table = addslashes("$table");
         if ($schema == '') {
@@ -119,11 +119,11 @@ 
         $sql_new = $sql;
 
         if (isset($params['limit']) && is_numeric($params['limit'])) {
-            $sql_new.=" LIMIT $params[limit]";
+            $sql_new .= " LIMIT $params[limit]";
         }
 
         if (isset($params['offset']) && is_numeric($params['offset'])) {
-            $sql_new.=" OFFSET $params[offset]";
+            $sql_new .= " OFFSET $params[offset]";
         }
 
         return $sql_new;
@@ -135,7 +135,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             return $this->query("DROP TABLE IF EXISTS $table");
@@ -157,7 +157,7 @@ 
      * @param array $definition
      * @return boolean
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -207,7 +207,7 @@ 
             }
             $create_lines[] = "`$field` " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -219,7 +219,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -240,7 +240,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         if ($schema == '') {
             $describe = $this->fetch_all("DESCRIBE `$table`");

core/libs/db/adapters/pdo/oracle.php

Spacing +7 added lines, -7 removed lines

@@ -117,7 +117,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             if ($this->table_exists($table)) {
@@ -142,7 +142,7 @@ 
      * @param array $definition
      * @return boolean
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -192,7 +192,7 @@ 
             }
             $create_lines[] = "$field " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -204,7 +204,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -224,7 +224,7 @@ 
      *
      * @return integer
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
         /**
          * Oracle No soporta columnas autonuméricas
@@ -243,7 +243,7 @@ 
      * @param string $table
      * @return boolean
      */
-    function table_exists($table, $schema='')
+    function table_exists($table, $schema = '')
     {
         $num = $this->fetch_one("SELECT COUNT(*) FROM ALL_TABLES WHERE TABLE_NAME = '" . strtoupper($table) . "'");
         return $num[0];
@@ -255,7 +255,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         /**
          * Soporta schemas?

core/libs/db/adapters/pdo/mssql.php

Spacing +12 added lines, -12 removed lines

@@ -92,7 +92,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function table_exists($table, $schema='')
+    public function table_exists($table, $schema = '')
     {
         $table = addslashes("$table");
         $num = $this->fetch_one("SELECT COUNT(*) FROM sysobjects WHERE type = 'U' AND name = '$table'");
@@ -109,7 +109,7 @@ 
     {
         $params = Util::getParams(func_get_args());
 
-        if(!isset($params['offset']) && isset($params['limit'])){
+        if (!isset($params['offset']) && isset($params['limit'])) {
             return str_ireplace("SELECT ", "SELECT TOP $params[limit] ", $sql);
         }
         $orderby = stristr($sql, 'ORDER BY');
@@ -121,12 +121,12 @@ 
         $sql = preg_replace('/^SELECT\s/i', 'SELECT TOP ' . $params[offset] . ' ', $sql);
         $sql = 'SELECT * FROM (SELECT TOP ' . $params[limit] . ' * FROM (' . $sql . ') AS itable';
         if ($orderby !== false) {
-            $sql.= ' ORDER BY ' . $order . ' ';
-            $sql.= ( stripos($sort, 'asc') !== false) ? 'DESC' : 'ASC';
+            $sql .= ' ORDER BY ' . $order . ' ';
+            $sql .= (stripos($sort, 'asc') !== false) ? 'DESC' : 'ASC';
         }
-        $sql.= ') AS otable';
+        $sql .= ') AS otable';
         if ($orderby !== false) {
-            $sql.=' ORDER BY ' . $order . ' ' . $sort;
+            $sql .= ' ORDER BY ' . $order . ' ' . $sort;
         }
         return $sql;
     }
@@ -137,7 +137,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             if ($this->table_exists($table)) {
@@ -163,7 +163,7 @@ 
      * @param array $definition
      * @return boolean
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -213,7 +213,7 @@ 
             }
             $create_lines[] = "$field " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -225,7 +225,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -246,7 +246,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         $describe_table = $this->fetch_all("exec sp_columns @table_name = '$table'");
         $final_describe = array();
@@ -275,7 +275,7 @@ 
      *
      * @return integer
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
         /**
          * Porque no funciona SELECT SCOPE_IDENTITY()?