@@ -36,12 +36,12 @@ discard block |
||
36 | 36 | public static function substr($str, $start, $length, $trimmarker = '...') |
37 | 37 | { |
38 | 38 | if (!XOOPS_USE_MULTIBYTES) { |
39 | - return (strlen($str) - $start <= $length) ? substr($str, $start, $length) : substr($str, $start, $length - strlen($trimmarker)) . $trimmarker; |
|
39 | + return (strlen($str) - $start <= $length) ? substr($str, $start, $length) : substr($str, $start, $length - strlen($trimmarker)).$trimmarker; |
|
40 | 40 | } |
41 | 41 | if (function_exists('mb_internal_encoding') && @mb_internal_encoding(_CHARSET)) { |
42 | 42 | $str2 = mb_strcut($str, $start, $length - strlen($trimmarker)); |
43 | 43 | |
44 | - return $str2 . (mb_strlen($str) != mb_strlen($str2) ? $trimmarker : ''); |
|
44 | + return $str2.(mb_strlen($str) != mb_strlen($str2) ? $trimmarker : ''); |
|
45 | 45 | } |
46 | 46 | |
47 | 47 | return $str; |
@@ -87,7 +87,7 @@ discard block |
||
87 | 87 | if (XOOPS_USE_MULTIBYTES && function_exists('mb_convert_encoding')) { |
88 | 88 | $converted_text = @mb_convert_encoding($text, $to, $from); |
89 | 89 | } elseif (function_exists('iconv')) { |
90 | - $converted_text = @iconv($from, $to . '//TRANSLIT', $text); |
|
90 | + $converted_text = @iconv($from, $to.'//TRANSLIT', $text); |
|
91 | 91 | } elseif ('utf-8' === $to) { |
92 | 92 | $converted_text = utf8_encode($text); |
93 | 93 | } |
@@ -138,9 +138,9 @@ discard block |
||
138 | 138 | if (isset($GLOBALS['xoopsConfig']['server_TZ'])) { |
139 | 139 | $server_TZ = abs((int)($GLOBALS['xoopsConfig']['server_TZ'] * 3600.0)); |
140 | 140 | $prefix = ($GLOBALS['xoopsConfig']['server_TZ'] < 0) ? ' -' : ' +'; |
141 | - $TIME_ZONE = $prefix . date('Hi', $server_TZ); |
|
141 | + $TIME_ZONE = $prefix.date('Hi', $server_TZ); |
|
142 | 142 | } |
143 | - $date = gmdate('D, d M Y H:i:s', (int)$time) . $TIME_ZONE; |
|
143 | + $date = gmdate('D, d M Y H:i:s', (int)$time).$TIME_ZONE; |
|
144 | 144 | |
145 | 145 | return $date; |
146 | 146 | } |
@@ -19,4 +19,4 @@ |
||
19 | 19 | |
20 | 20 | $GLOBALS['xoopsLogger']->addDeprecated("'/class/mimetypes.inc.php' is deprecated, use '/include/mimetypes.inc.php' directly."); |
21 | 21 | |
22 | -return include XOOPS_ROOT_PATH . '/include/mimetypes.inc.php'; |
|
22 | +return include XOOPS_ROOT_PATH.'/include/mimetypes.inc.php'; |
@@ -18,7 +18,7 @@ discard block |
||
18 | 18 | */ |
19 | 19 | defined('XOOPS_ROOT_PATH') || exit('Restricted access'); |
20 | 20 | |
21 | -include_once XOOPS_ROOT_PATH . '/kernel/object.php'; |
|
21 | +include_once XOOPS_ROOT_PATH.'/kernel/object.php'; |
|
22 | 22 | |
23 | 23 | /** |
24 | 24 | * Factory for object handlers |
@@ -72,15 +72,15 @@ discard block |
||
72 | 72 | { |
73 | 73 | static $handlers; |
74 | 74 | if (!isset($handlers[$name])) { |
75 | - if (file_exists($file = __DIR__ . '/' . $name . '.php')) { |
|
75 | + if (file_exists($file = __DIR__.'/'.$name.'.php')) { |
|
76 | 76 | include_once $file; |
77 | - $className = 'XoopsModel' . ucfirst($name); |
|
77 | + $className = 'XoopsModel'.ucfirst($name); |
|
78 | 78 | $handler = new $className(); |
79 | 79 | } elseif (xoops_load('model', 'framework')) { |
80 | 80 | $handler = XoopsModel::loadHandler($name); |
81 | 81 | } |
82 | 82 | if (!is_object($handler)) { |
83 | - trigger_error('Handler not found in file ' . __FILE__ . ' at line ' . __LINE__, E_USER_WARNING); |
|
83 | + trigger_error('Handler not found in file '.__FILE__.' at line '.__LINE__, E_USER_WARNING); |
|
84 | 84 | |
85 | 85 | return null; |
86 | 86 | } |
@@ -136,7 +136,7 @@ discard block |
||
136 | 136 | public function setHandler($handler) |
137 | 137 | { |
138 | 138 | if (is_object($handler) && is_a($handler, 'XoopsPersistableObjectHandler')) { |
139 | - $this->handler =& $handler; |
|
139 | + $this->handler = & $handler; |
|
140 | 140 | |
141 | 141 | return true; |
142 | 142 | } |
@@ -42,7 +42,7 @@ discard block |
||
42 | 42 | if (!in_array($this->handler->keyName, $fields)) { |
43 | 43 | $fields[] = $this->handler->keyName; |
44 | 44 | } |
45 | - $select = '`' . implode('`, `', $fields) . '`'; |
|
45 | + $select = '`'.implode('`, `', $fields).'`'; |
|
46 | 46 | } else { |
47 | 47 | $select = '*'; |
48 | 48 | } |
@@ -50,12 +50,12 @@ discard block |
||
50 | 50 | $start = null; |
51 | 51 | $sql = "SELECT {$select} FROM `{$this->handler->table}`"; |
52 | 52 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
53 | - $sql .= ' ' . $criteria->renderWhere(); |
|
53 | + $sql .= ' '.$criteria->renderWhere(); |
|
54 | 54 | if ($groupby = $criteria->getGroupby()) { |
55 | 55 | $sql .= $groupby; |
56 | 56 | } |
57 | 57 | if ($sort = $criteria->getSort()) { |
58 | - $sql .= " ORDER BY {$sort} " . $criteria->getOrder(); |
|
58 | + $sql .= " ORDER BY {$sort} ".$criteria->getOrder(); |
|
59 | 59 | $orderSet = true; |
60 | 60 | } |
61 | 61 | $limit = $criteria->getLimit(); |
@@ -105,7 +105,7 @@ discard block |
||
105 | 105 | */ |
106 | 106 | public function &getObjects(CriteriaElement $criteria = null, $id_as_key = false, $as_object = true) |
107 | 107 | { |
108 | - $objects =& $this->getAll($criteria, null, $as_object, $id_as_key); |
|
108 | + $objects = & $this->getAll($criteria, null, $as_object, $id_as_key); |
|
109 | 109 | |
110 | 110 | return $objects; |
111 | 111 | } |
@@ -131,9 +131,9 @@ discard block |
||
131 | 131 | } |
132 | 132 | $sql .= " FROM `{$this->handler->table}`"; |
133 | 133 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
134 | - $sql .= ' ' . $criteria->renderWhere(); |
|
134 | + $sql .= ' '.$criteria->renderWhere(); |
|
135 | 135 | if ($sort = $criteria->getSort()) { |
136 | - $sql .= ' ORDER BY ' . $sort . ' ' . $criteria->getOrder(); |
|
136 | + $sql .= ' ORDER BY '.$sort.' '.$criteria->getOrder(); |
|
137 | 137 | } |
138 | 138 | $limit = $criteria->getLimit(); |
139 | 139 | $start = $criteria->getStart(); |
@@ -164,7 +164,7 @@ discard block |
||
164 | 164 | $sql = "SELECT `{$this->handler->keyName}` FROM `{$this->handler->table}`"; |
165 | 165 | $limit = $start = null; |
166 | 166 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
167 | - $sql .= ' ' . $criteria->renderWhere(); |
|
167 | + $sql .= ' '.$criteria->renderWhere(); |
|
168 | 168 | $limit = $criteria->getLimit(); |
169 | 169 | $start = $criteria->getStart(); |
170 | 170 | } |
@@ -192,7 +192,7 @@ discard block |
||
192 | 192 | */ |
193 | 193 | public function &getByLimit($limit = 0, $start = 0, CriteriaElement $criteria = null, $fields = null, $asObject = true) |
194 | 194 | { |
195 | - $GLOBALS['xoopsLogger']->addDeprecated(__CLASS__ . '::' . __FUNCTION__ . '() is deprecated, please use getAll instead.'); |
|
195 | + $GLOBALS['xoopsLogger']->addDeprecated(__CLASS__.'::'.__FUNCTION__.'() is deprecated, please use getAll instead.'); |
|
196 | 196 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
197 | 197 | $criteria->setLimit($limit); |
198 | 198 | $criteria->setStart($start); |
@@ -216,7 +216,7 @@ discard block |
||
216 | 216 | */ |
217 | 217 | public function convertResultSet($result, $id_as_key = false, $as_object = true) |
218 | 218 | { |
219 | - $GLOBALS['xoopsLogger']->addDeprecated(__CLASS__ . '::' . __FUNCTION__ . '() is deprecated.'); |
|
219 | + $GLOBALS['xoopsLogger']->addDeprecated(__CLASS__.'::'.__FUNCTION__.'() is deprecated.'); |
|
220 | 220 | $ret = array(); |
221 | 221 | while (false !== ($myrow = $this->handler->db->fetchArray($result))) { |
222 | 222 | $obj = $this->handler->create(false); |
@@ -234,7 +234,7 @@ discard block |
||
234 | 234 | } |
235 | 235 | } else { |
236 | 236 | if ($as_object) { |
237 | - $ret[$myrow[$this->handler->keyName]] =& $obj; |
|
237 | + $ret[$myrow[$this->handler->keyName]] = & $obj; |
|
238 | 238 | } else { |
239 | 239 | $row = array(); |
240 | 240 | $vars = $obj->getVars(); |
@@ -40,12 +40,12 @@ discard block |
||
40 | 40 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
41 | 41 | if ($criteria->groupby != '') { |
42 | 42 | $groupby = true; |
43 | - $field = $criteria->groupby . ', '; |
|
43 | + $field = $criteria->groupby.', '; |
|
44 | 44 | } |
45 | 45 | } |
46 | 46 | $sql = "SELECT {$field} COUNT(*) FROM `{$this->handler->table}`"; |
47 | 47 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
48 | - $sql .= ' ' . $criteria->renderWhere(); |
|
48 | + $sql .= ' '.$criteria->renderWhere(); |
|
49 | 49 | $sql .= $criteria->getGroupby(); |
50 | 50 | } |
51 | 51 | $result = $this->handler->db->query($sql); |
@@ -87,7 +87,7 @@ discard block |
||
87 | 87 | $groupby_key = $groupby; |
88 | 88 | } |
89 | 89 | } |
90 | - $sql = "SELECT {$groupby_key}, COUNT(*) AS count" . " FROM `{$this->handler->table}`" . " {$sql_where}" . " GROUP BY {$groupby_key}"; |
|
90 | + $sql = "SELECT {$groupby_key}, COUNT(*) AS count"." FROM `{$this->handler->table}`"." {$sql_where}"." GROUP BY {$groupby_key}"; |
|
91 | 91 | if (!$result = $this->handler->db->query($sql, $limit, $start)) { |
92 | 92 | return $ret; |
93 | 93 | } |
@@ -179,7 +179,7 @@ discard block |
||
179 | 179 | continue 2; |
180 | 180 | } |
181 | 181 | if ($cleanv != '' && !preg_match("/^http[s]*:\/\//i", $cleanv)) { |
182 | - $cleanv = XOOPS_PROT . $cleanv; |
|
182 | + $cleanv = XOOPS_PROT.$cleanv; |
|
183 | 183 | } |
184 | 184 | if (!$v['not_gpc']) { |
185 | 185 | $cleanv = $ts->stripSlashesGPC($cleanv); |
@@ -193,7 +193,7 @@ discard block |
||
193 | 193 | continue 2; |
194 | 194 | } |
195 | 195 | if ($cleanv != '' && !preg_match("/^http[s]*:\/\//i", $cleanv)) { |
196 | - $cleanv = XOOPS_PROT . $cleanv; |
|
196 | + $cleanv = XOOPS_PROT.$cleanv; |
|
197 | 197 | } |
198 | 198 | if (!$v['not_gpc']) { |
199 | 199 | $cleanv = $ts->stripSlashesGPC($cleanv); |
@@ -231,7 +231,7 @@ discard block |
||
231 | 231 | $cleanv[$key] = str_replace('\\"', '"', addslashes($cleanv[$key])); |
232 | 232 | } |
233 | 233 | // TODO: Not encoding safe, should try base64_encode -- phppp |
234 | - $cleanv = "'" . serialize(array_walk($cleanv, 'xoops_aw_encode')) . "'"; |
|
234 | + $cleanv = "'".serialize(array_walk($cleanv, 'xoops_aw_encode'))."'"; |
|
235 | 235 | break; |
236 | 236 | |
237 | 237 | case XOBJ_DTYPE_ARRAY: |
@@ -273,25 +273,25 @@ discard block |
||
273 | 273 | public function insert(&$object, $force = true) |
274 | 274 | { |
275 | 275 | if (!$object->isDirty()) { |
276 | - trigger_error("Data entry is not inserted - the object '" . get_class($object) . "' is not dirty", E_USER_NOTICE); |
|
276 | + trigger_error("Data entry is not inserted - the object '".get_class($object)."' is not dirty", E_USER_NOTICE); |
|
277 | 277 | |
278 | 278 | return $object->getVar($this->handler->keyName); |
279 | 279 | } |
280 | 280 | if (!$this->cleanVars($object)) { |
281 | - trigger_error("Insert failed in method 'cleanVars' of object '" . get_class($object) . "'", E_USER_WARNING); |
|
281 | + trigger_error("Insert failed in method 'cleanVars' of object '".get_class($object)."'", E_USER_WARNING); |
|
282 | 282 | |
283 | 283 | return $object->getVar($this->handler->keyName); |
284 | 284 | } |
285 | 285 | $queryFunc = empty($force) ? 'query' : 'queryF'; |
286 | 286 | |
287 | 287 | if ($object->isNew()) { |
288 | - $sql = 'INSERT INTO `' . $this->handler->table . '`'; |
|
288 | + $sql = 'INSERT INTO `'.$this->handler->table.'`'; |
|
289 | 289 | if (!empty($object->cleanVars)) { |
290 | 290 | $keys = array_keys($object->cleanVars); |
291 | 291 | $vals = array_values($object->cleanVars); |
292 | - $sql .= ' (`' . implode('`, `', $keys) . '`) VALUES (' . implode(',', $vals) . ')'; |
|
292 | + $sql .= ' (`'.implode('`, `', $keys).'`) VALUES ('.implode(',', $vals).')'; |
|
293 | 293 | } else { |
294 | - trigger_error("Data entry is not inserted - no variable is changed in object of '" . get_class($object) . "'", E_USER_NOTICE); |
|
294 | + trigger_error("Data entry is not inserted - no variable is changed in object of '".get_class($object)."'", E_USER_NOTICE); |
|
295 | 295 | |
296 | 296 | return $object->getVar($this->handler->keyName); |
297 | 297 | } |
@@ -306,7 +306,7 @@ discard block |
||
306 | 306 | foreach ($object->cleanVars as $k => $v) { |
307 | 307 | $keys[] = " `{$k}` = {$v}"; |
308 | 308 | } |
309 | - $sql = 'UPDATE `' . $this->handler->table . '` SET ' . implode(',', $keys) . ' WHERE `' . $this->handler->keyName . '` = ' . $this->handler->db->quote($object->getVar($this->handler->keyName)); |
|
309 | + $sql = 'UPDATE `'.$this->handler->table.'` SET '.implode(',', $keys).' WHERE `'.$this->handler->keyName.'` = '.$this->handler->db->quote($object->getVar($this->handler->keyName)); |
|
310 | 310 | if (!$result = $this->handler->db->{$queryFunc}($sql)) { |
311 | 311 | return false; |
312 | 312 | } |
@@ -328,13 +328,13 @@ discard block |
||
328 | 328 | $clause = array(); |
329 | 329 | $thishandlerkeyNameCount = count($this->handler->keyName); |
330 | 330 | for ($i = 0; $i < $thishandlerkeyNameCount; ++$i) { |
331 | - $clause[] = '`' . $this->handler->keyName[$i] . '` = ' . $this->handler->db->quote($object->getVar($this->handler->keyName[$i])); |
|
331 | + $clause[] = '`'.$this->handler->keyName[$i].'` = '.$this->handler->db->quote($object->getVar($this->handler->keyName[$i])); |
|
332 | 332 | } |
333 | 333 | $whereclause = implode(' AND ', $clause); |
334 | 334 | } else { |
335 | - $whereclause = '`' . $this->handler->keyName . '` = ' . $this->handler->db->quote($object->getVar($this->handler->keyName)); |
|
335 | + $whereclause = '`'.$this->handler->keyName.'` = '.$this->handler->db->quote($object->getVar($this->handler->keyName)); |
|
336 | 336 | } |
337 | - $sql = 'DELETE FROM `' . $this->handler->table . '` WHERE ' . $whereclause; |
|
337 | + $sql = 'DELETE FROM `'.$this->handler->table.'` WHERE '.$whereclause; |
|
338 | 338 | $queryFunc = empty($force) ? 'query' : 'queryF'; |
339 | 339 | $result = $this->handler->db->{$queryFunc}($sql); |
340 | 340 | |
@@ -362,10 +362,10 @@ discard block |
||
362 | 362 | return $num; |
363 | 363 | } |
364 | 364 | $queryFunc = empty($force) ? 'query' : 'queryF'; |
365 | - $sql = 'DELETE FROM ' . $this->handler->table; |
|
365 | + $sql = 'DELETE FROM '.$this->handler->table; |
|
366 | 366 | if (!empty($criteria)) { |
367 | 367 | if (is_subclass_of($criteria, 'CriteriaElement')) { |
368 | - $sql .= ' ' . $criteria->renderWhere(); |
|
368 | + $sql .= ' '.$criteria->renderWhere(); |
|
369 | 369 | } else { |
370 | 370 | return false; |
371 | 371 | } |
@@ -396,9 +396,9 @@ discard block |
||
396 | 396 | } else { |
397 | 397 | $set_clause .= $this->handler->db->quote($fieldvalue); |
398 | 398 | } |
399 | - $sql = 'UPDATE `' . $this->handler->table . '` SET ' . $set_clause; |
|
399 | + $sql = 'UPDATE `'.$this->handler->table.'` SET '.$set_clause; |
|
400 | 400 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
401 | - $sql .= ' ' . $criteria->renderWhere(); |
|
401 | + $sql .= ' '.$criteria->renderWhere(); |
|
402 | 402 | } |
403 | 403 | $queryFunc = empty($force) ? 'query' : 'queryF'; |
404 | 404 | $result = $this->handler->db->{$queryFunc}($sql); |
@@ -58,7 +58,7 @@ discard block |
||
58 | 58 | } |
59 | 59 | |
60 | 60 | if (empty($this->handler->field_object) || empty($this->handler->table_link) || empty($this->handler->field_link)) { |
61 | - trigger_error("The link information is not set for '" . get_class($this->handler) . "' yet.", E_USER_WARNING); |
|
61 | + trigger_error("The link information is not set for '".get_class($this->handler)."' yet.", E_USER_WARNING); |
|
62 | 62 | |
63 | 63 | return null; |
64 | 64 | } |
@@ -67,10 +67,10 @@ discard block |
||
67 | 67 | * for MySQL 4.1+ |
68 | 68 | */ |
69 | 69 | if (version_compare(mysqli_get_server_info($this->handler->db->conn), '4.1.0', 'ge')) { |
70 | - $sql = "DELETE FROM `{$this->handler->table}`" . " WHERE (`{$this->handler->field_object}` NOT IN ( SELECT DISTINCT `{$this->handler->field_link}` FROM `{$this->handler->table_link}`) )"; |
|
70 | + $sql = "DELETE FROM `{$this->handler->table}`"." WHERE (`{$this->handler->field_object}` NOT IN ( SELECT DISTINCT `{$this->handler->field_link}` FROM `{$this->handler->table_link}`) )"; |
|
71 | 71 | } else { |
72 | 72 | // for 4.0+ |
73 | - $sql = "DELETE `{$this->handler->table}` FROM `{$this->handler->table}`" . " LEFT JOIN `{$this->handler->table_link}` AS aa ON `{$this->handler->table}`.`{$this->handler->field_object}` = aa.`{$this->handler->field_link}`" . " WHERE (aa.`{$this->handler->field_link}` IS NULL)"; |
|
73 | + $sql = "DELETE `{$this->handler->table}` FROM `{$this->handler->table}`"." LEFT JOIN `{$this->handler->table_link}` AS aa ON `{$this->handler->table}`.`{$this->handler->field_object}` = aa.`{$this->handler->field_link}`"." WHERE (aa.`{$this->handler->field_link}` IS NULL)"; |
|
74 | 74 | } |
75 | 75 | if (!$result = $this->handler->db->queryF($sql)) { |
76 | 76 | return false; |
@@ -80,8 +80,8 @@ discard block |
||
80 | 80 | } |
81 | 81 | |
82 | 82 | if (is_array($fields) && count($fields)) { |
83 | - if (!in_array('o.' . $this->handler->keyName, $fields)) { |
|
84 | - $fields[] = 'o.' . $this->handler->keyName; |
|
83 | + if (!in_array('o.'.$this->handler->keyName, $fields)) { |
|
84 | + $fields[] = 'o.'.$this->handler->keyName; |
|
85 | 85 | } |
86 | 86 | $select = implode(',', $fields); |
87 | 87 | } else { |
@@ -90,11 +90,11 @@ discard block |
||
90 | 90 | $limit = null; |
91 | 91 | $start = null; |
92 | 92 | // $field_object = empty($field_object) ? $field_link : $field_object; |
93 | - $sql = " SELECT {$select}" . " FROM {$this->handler->table} AS o" . " LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
93 | + $sql = " SELECT {$select}"." FROM {$this->handler->table} AS o"." LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
94 | 94 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
95 | - $sql .= ' ' . $criteria->renderWhere(); |
|
95 | + $sql .= ' '.$criteria->renderWhere(); |
|
96 | 96 | if ($sort = $criteria->getSort()) { |
97 | - $sql .= " ORDER BY {$sort} " . $criteria->getOrder(); |
|
97 | + $sql .= " ORDER BY {$sort} ".$criteria->getOrder(); |
|
98 | 98 | $orderSet = true; |
99 | 99 | } |
100 | 100 | $limit = $criteria->getLimit(); |
@@ -136,9 +136,9 @@ discard block |
||
136 | 136 | return null; |
137 | 137 | } |
138 | 138 | |
139 | - $sql = " SELECT COUNT(DISTINCT o.{$this->handler->keyName}) AS count" . " FROM {$this->handler->table} AS o" . " LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
139 | + $sql = " SELECT COUNT(DISTINCT o.{$this->handler->keyName}) AS count"." FROM {$this->handler->table} AS o"." LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
140 | 140 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
141 | - $sql .= ' ' . $criteria->renderWhere(); |
|
141 | + $sql .= ' '.$criteria->renderWhere(); |
|
142 | 142 | } |
143 | 143 | if (!$result = $this->handler->db->query($sql)) { |
144 | 144 | return false; |
@@ -159,9 +159,9 @@ discard block |
||
159 | 159 | if (!$this->validateLinks()) { |
160 | 160 | return null; |
161 | 161 | } |
162 | - $sql = " SELECT l.{$this->handler->field_link}, COUNT(*)" . " FROM {$this->handler->table} AS o" . " LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
162 | + $sql = " SELECT l.{$this->handler->field_link}, COUNT(*)"." FROM {$this->handler->table} AS o"." LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
163 | 163 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
164 | - $sql .= ' ' . $criteria->renderWhere(); |
|
164 | + $sql .= ' '.$criteria->renderWhere(); |
|
165 | 165 | } |
166 | 166 | $sql .= " GROUP BY l.{$this->handler->field_link}"; |
167 | 167 | if (!$result = $this->handler->db->query($sql)) { |
@@ -189,11 +189,11 @@ discard block |
||
189 | 189 | } |
190 | 190 | $set = array(); |
191 | 191 | foreach ($data as $key => $val) { |
192 | - $set[] = "o.{$key}=" . $this->handler->db->quoteString($val); |
|
192 | + $set[] = "o.{$key}=".$this->handler->db->quoteString($val); |
|
193 | 193 | } |
194 | - $sql = " UPDATE {$this->handler->table} AS o" . ' SET ' . implode(', ', $set) . " LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
194 | + $sql = " UPDATE {$this->handler->table} AS o".' SET '.implode(', ', $set)." LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
195 | 195 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
196 | - $sql .= ' ' . $criteria->renderWhere(); |
|
196 | + $sql .= ' '.$criteria->renderWhere(); |
|
197 | 197 | } |
198 | 198 | |
199 | 199 | return $this->handler->db->query($sql); |
@@ -210,9 +210,9 @@ discard block |
||
210 | 210 | if (!$this->validateLinks()) { |
211 | 211 | return null; |
212 | 212 | } |
213 | - $sql = "DELETE FROM {$this->handler->table} AS o " . " LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
213 | + $sql = "DELETE FROM {$this->handler->table} AS o "." LEFT JOIN {$this->handler->table_link} AS l ON o.{$this->handler->field_object} = l.{$this->handler->field_link}"; |
|
214 | 214 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
215 | - $sql .= ' ' . $criteria->renderWhere(); |
|
215 | + $sql .= ' '.$criteria->renderWhere(); |
|
216 | 216 | } |
217 | 217 | |
218 | 218 | return $this->handler->db->query($sql); |
@@ -55,14 +55,14 @@ |
||
55 | 55 | if (function_exists('mb_http_output')) { |
56 | 56 | mb_http_output('pass'); |
57 | 57 | } |
58 | - header('Content-Type: ' . $this->mimetype); |
|
58 | + header('Content-Type: '.$this->mimetype); |
|
59 | 59 | if (preg_match("/MSIE (\d\.\d{1,2})/", $_SERVER['HTTP_USER_AGENT'])) { |
60 | - header('Content-Disposition: attachment; filename="' . $filename . '"'); |
|
60 | + header('Content-Disposition: attachment; filename="'.$filename.'"'); |
|
61 | 61 | header('Expires: 0'); |
62 | 62 | header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); |
63 | 63 | header('Pragma: public'); |
64 | 64 | } else { |
65 | - header('Content-Disposition: attachment; filename="' . $filename . '"'); |
|
65 | + header('Content-Disposition: attachment; filename="'.$filename.'"'); |
|
66 | 66 | header('Expires: 0'); |
67 | 67 | header('Pragma: no-cache'); |
68 | 68 | } |