@@ -341,11 +341,11 @@ discard block |
||
341 | 341 | $retval = array(); |
342 | 342 | for ($i = 0, $c = count($query); $i < $c; $i++) |
343 | 343 | { |
344 | - $retval[$i] = new stdClass(); |
|
344 | + $retval[$i] = new stdClass(); |
|
345 | 345 | $retval[$i]->name = $query[$i]->COLUMN_NAME; |
346 | 346 | $retval[$i]->type = $query[$i]->DATA_TYPE; |
347 | - $retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION; |
|
348 | - $retval[$i]->default = $query[$i]->COLUMN_DEFAULT; |
|
347 | + $retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION; |
|
348 | + $retval[$i]->default = $query[$i]->COLUMN_DEFAULT; |
|
349 | 349 | } |
350 | 350 | |
351 | 351 | return $retval; |
@@ -501,7 +501,7 @@ discard block |
||
501 | 501 | ."\nWHERE ".$this->escape_identifiers('CI_rownum').' BETWEEN '.($this->qb_offset + 1).' AND '.$limit; |
502 | 502 | } |
503 | 503 | |
504 | - return preg_replace('/(^\SELECT (DISTINCT)?)/i','\\1 TOP '.$limit.' ', $sql); |
|
504 | + return preg_replace('/(^\SELECT (DISTINCT)?)/i', '\\1 TOP '.$limit.' ', $sql); |
|
505 | 505 | } |
506 | 506 | |
507 | 507 | // -------------------------------------------------------------------- |
@@ -341,11 +341,11 @@ discard block |
||
341 | 341 | $retval = array(); |
342 | 342 | for ($i = 0, $c = count($query); $i < $c; $i++) |
343 | 343 | { |
344 | - $retval[$i] = new stdClass(); |
|
344 | + $retval[$i] = new stdClass(); |
|
345 | 345 | $retval[$i]->name = $query[$i]->COLUMN_NAME; |
346 | 346 | $retval[$i]->type = $query[$i]->DATA_TYPE; |
347 | - $retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION; |
|
348 | - $retval[$i]->default = $query[$i]->COLUMN_DEFAULT; |
|
347 | + $retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION; |
|
348 | + $retval[$i]->default = $query[$i]->COLUMN_DEFAULT; |
|
349 | 349 | } |
350 | 350 | |
351 | 351 | return $retval; |
@@ -501,7 +501,7 @@ discard block |
||
501 | 501 | ."\nWHERE ".$this->escape_identifiers('CI_rownum').' BETWEEN '.($this->qb_offset + 1).' AND '.$limit; |
502 | 502 | } |
503 | 503 | |
504 | - return preg_replace('/(^\SELECT (DISTINCT)?)/i','\\1 TOP '.$limit.' ', $sql); |
|
504 | + return preg_replace('/(^\SELECT (DISTINCT)?)/i', '\\1 TOP '.$limit.' ', $sql); |
|
505 | 505 | } |
506 | 506 | |
507 | 507 | // -------------------------------------------------------------------- |
@@ -51,21 +51,21 @@ |
||
51 | 51 | * |
52 | 52 | * @var string |
53 | 53 | */ |
54 | - protected $_create_table_if = "IF NOT EXISTS (SELECT * FROM sysobjects WHERE ID = object_id(N'%s') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)\nCREATE TABLE"; |
|
54 | + protected $_create_table_if = "IF NOT EXISTS (SELECT * FROM sysobjects WHERE ID = object_id(N'%s') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)\nCREATE TABLE"; |
|
55 | 55 | |
56 | 56 | /** |
57 | 57 | * DROP TABLE IF statement |
58 | 58 | * |
59 | 59 | * @var string |
60 | 60 | */ |
61 | - protected $_drop_table_if = "IF EXISTS (SELECT * FROM sysobjects WHERE ID = object_id(N'%s') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)\nDROP TABLE"; |
|
61 | + protected $_drop_table_if = "IF EXISTS (SELECT * FROM sysobjects WHERE ID = object_id(N'%s') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)\nDROP TABLE"; |
|
62 | 62 | |
63 | 63 | /** |
64 | 64 | * UNSIGNED support |
65 | 65 | * |
66 | 66 | * @var array |
67 | 67 | */ |
68 | - protected $_unsigned = array( |
|
68 | + protected $_unsigned = array( |
|
69 | 69 | 'TINYINT' => 'SMALLINT', |
70 | 70 | 'SMALLINT' => 'INT', |
71 | 71 | 'INT' => 'BIGINT', |
@@ -51,21 +51,21 @@ |
||
51 | 51 | * |
52 | 52 | * @var string |
53 | 53 | */ |
54 | - protected $_create_table_if = "IF NOT EXISTS (SELECT * FROM sysobjects WHERE ID = object_id(N'%s') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)\nCREATE TABLE"; |
|
54 | + protected $_create_table_if = "IF NOT EXISTS (SELECT * FROM sysobjects WHERE ID = object_id(N'%s') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)\nCREATE TABLE"; |
|
55 | 55 | |
56 | 56 | /** |
57 | 57 | * DROP TABLE IF statement |
58 | 58 | * |
59 | 59 | * @var string |
60 | 60 | */ |
61 | - protected $_drop_table_if = "IF EXISTS (SELECT * FROM sysobjects WHERE ID = object_id(N'%s') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)\nDROP TABLE"; |
|
61 | + protected $_drop_table_if = "IF EXISTS (SELECT * FROM sysobjects WHERE ID = object_id(N'%s') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)\nDROP TABLE"; |
|
62 | 62 | |
63 | 63 | /** |
64 | 64 | * UNSIGNED support |
65 | 65 | * |
66 | 66 | * @var array |
67 | 67 | */ |
68 | - protected $_unsigned = array( |
|
68 | + protected $_unsigned = array( |
|
69 | 69 | 'TINYINT' => 'SMALLINT', |
70 | 70 | 'SMALLINT' => 'INT', |
71 | 71 | 'INT' => 'BIGINT', |
@@ -274,11 +274,11 @@ |
||
274 | 274 | $retval = array(); |
275 | 275 | for ($i = 0, $c = count($query); $i < $c; $i++) |
276 | 276 | { |
277 | - $retval[$i] = new stdClass(); |
|
277 | + $retval[$i] = new stdClass(); |
|
278 | 278 | $retval[$i]->name = $query[$i]['name']; |
279 | 279 | $retval[$i]->type = $query[$i]['type']; |
280 | 280 | $retval[$i]->max_length = NULL; |
281 | - $retval[$i]->default = $query[$i]['dflt_value']; |
|
281 | + $retval[$i]->default = $query[$i]['dflt_value']; |
|
282 | 282 | $retval[$i]->primary_key = isset($query[$i]['pk']) ? (int) $query[$i]['pk'] : 0; |
283 | 283 | } |
284 | 284 |
@@ -100,13 +100,13 @@ |
||
100 | 100 | $retval = array(); |
101 | 101 | for ($i = 0, $c = $this->num_fields(); $i < $c; $i++) |
102 | 102 | { |
103 | - $retval[$i] = new stdClass(); |
|
103 | + $retval[$i] = new stdClass(); |
|
104 | 104 | $retval[$i]->name = $this->result_id->columnName($i); |
105 | 105 | |
106 | 106 | $type = $this->result_id->columnType($i); |
107 | 107 | $retval[$i]->type = isset($data_types[$type]) ? $data_types[$type] : $type; |
108 | 108 | |
109 | - $retval[$i]->max_length = NULL; |
|
109 | + $retval[$i]->max_length = NULL; |
|
110 | 110 | } |
111 | 111 | |
112 | 112 | return $retval; |
@@ -274,11 +274,11 @@ |
||
274 | 274 | $retval = array(); |
275 | 275 | for ($i = 0, $c = count($query); $i < $c; $i++) |
276 | 276 | { |
277 | - $retval[$i] = new stdClass(); |
|
277 | + $retval[$i] = new stdClass(); |
|
278 | 278 | $retval[$i]->name = $query[$i]['name']; |
279 | 279 | $retval[$i]->type = $query[$i]['type']; |
280 | 280 | $retval[$i]->max_length = NULL; |
281 | - $retval[$i]->default = $query[$i]['dflt_value']; |
|
281 | + $retval[$i]->default = $query[$i]['dflt_value']; |
|
282 | 282 | $retval[$i]->primary_key = isset($query[$i]['pk']) ? (int) $query[$i]['pk'] : 0; |
283 | 283 | } |
284 | 284 |
@@ -81,7 +81,7 @@ |
||
81 | 81 | { |
82 | 82 | parent::__construct($params); |
83 | 83 | |
84 | - $CI =& get_instance(); |
|
84 | + $CI = & get_instance(); |
|
85 | 85 | isset($CI->db) OR $CI->load->database(); |
86 | 86 | $this->_db = $CI->db; |
87 | 87 |
@@ -81,7 +81,7 @@ |
||
81 | 81 | { |
82 | 82 | parent::__construct($params); |
83 | 83 | |
84 | - $CI =& get_instance(); |
|
84 | + $CI = & get_instance(); |
|
85 | 85 | isset($CI->db) OR $CI->load->database(); |
86 | 86 | $this->_db = $CI->db; |
87 | 87 |