@@ -38,7 +38,7 @@ discard block |
||
| 38 | 38 | ); |
| 39 | 39 | |
| 40 | 40 | if (isset($this->request->get['information_id'])) { |
| 41 | - $information_id = (int) $this->request->get['information_id']; |
|
| 41 | + $information_id = (int)$this->request->get['information_id']; |
|
| 42 | 42 | } else { |
| 43 | 43 | $information_id = 0; |
| 44 | 44 | } |
@@ -67,7 +67,7 @@ discard block |
||
| 67 | 67 | |
| 68 | 68 | $data['breadcrumbs'][] = array( |
| 69 | 69 | 'text' => $information_info[0]['title'], |
| 70 | - 'href' => $this->url->link('information/information', 'information_id=' . $information_id) |
|
| 70 | + 'href' => $this->url->link('information/information', 'information_id=' . $information_id) |
|
| 71 | 71 | ); |
| 72 | 72 | |
| 73 | 73 | $data['button_continue'] = $this->language->get('button_continue'); |
@@ -117,7 +117,7 @@ discard block |
||
| 117 | 117 | $this->load->model('catalog/information'); |
| 118 | 118 | |
| 119 | 119 | if (isset($this->request->get['information_id'])) { |
| 120 | - $information_id = (int) $this->request->get['information_id']; |
|
| 120 | + $information_id = (int)$this->request->get['information_id']; |
|
| 121 | 121 | } else { |
| 122 | 122 | $information_id = 0; |
| 123 | 123 | } |
@@ -29,8 +29,8 @@ discard block |
||
| 29 | 29 | SELECT DISTINCT * |
| 30 | 30 | FROM information i |
| 31 | 31 | LEFT JOIN information_description id ON (i.information_id = id.information_id) |
| 32 | - WHERE i.information_id = '" . (int) $information_id . "' |
|
| 33 | - AND id.language_id = '" . (int) $this->config->get('config_language_id') . "' |
|
| 32 | + WHERE i.information_id = '" . (int)$information_id . "' |
|
| 33 | + AND id.language_id = '" . (int)$this->config->get('config_language_id') . "' |
|
| 34 | 34 | AND i.status = '1' |
| 35 | 35 | "); |
| 36 | 36 | |
@@ -41,8 +41,8 @@ discard block |
||
| 41 | 41 | ->select('DISTINCT *') |
| 42 | 42 | ->from('information', 'i') |
| 43 | 43 | ->leftJoin('i', 'information_description', 'id', 'i.information_id = id.information_id') |
| 44 | - ->where('i.information_id = ' . (int) $information_id) |
|
| 45 | - ->andWhere('id.language_id = ' . (int) $this->config->get('config_language_id')) |
|
| 44 | + ->where('i.information_id = ' . (int)$information_id) |
|
| 45 | + ->andWhere('id.language_id = ' . (int)$this->config->get('config_language_id')) |
|
| 46 | 46 | ->andWhere('i.status = 1') |
| 47 | 47 | ->execute() |
| 48 | 48 | ->fetchAll(); |
@@ -59,7 +59,7 @@ discard block |
||
| 59 | 59 | SELECT * |
| 60 | 60 | FROM information i |
| 61 | 61 | LEFT JOIN information_description id ON (i.information_id = id.information_id) |
| 62 | - WHERE id.language_id = '" . (int) $this->config->get('config_language_id') . "' |
|
| 62 | + WHERE id.language_id = '" . (int)$this->config->get('config_language_id') . "' |
|
| 63 | 63 | AND i.status = '1' |
| 64 | 64 | ORDER BY i.sort_order, |
| 65 | 65 | LCASE(id.title) ASC |
@@ -73,7 +73,7 @@ discard block |
||
| 73 | 73 | $query = $this->db->query(" |
| 74 | 74 | SELECT * |
| 75 | 75 | FROM information_to_layout |
| 76 | - WHERE information_id = '" . (int) $information_id . "' |
|
| 76 | + WHERE information_id = '" . (int)$information_id . "' |
|
| 77 | 77 | "); |
| 78 | 78 | |
| 79 | 79 | if ($query->num_rows) { |
@@ -45,7 +45,7 @@ discard block |
||
| 45 | 45 | $customer_query = $this->db->query(" |
| 46 | 46 | SELECT * |
| 47 | 47 | FROM customer |
| 48 | - WHERE customer_id = '" . (int) $this->session->data['customer_id'] . "' |
|
| 48 | + WHERE customer_id = '" . (int)$this->session->data['customer_id'] . "' |
|
| 49 | 49 | AND status = '1' |
| 50 | 50 | "); |
| 51 | 51 | |
@@ -62,22 +62,22 @@ discard block |
||
| 62 | 62 | |
| 63 | 63 | $this->db->query(" |
| 64 | 64 | UPDATE customer |
| 65 | - SET language_id = '" . (int) $this->config->get('config_language_id') . "', |
|
| 65 | + SET language_id = '" . (int)$this->config->get('config_language_id') . "', |
|
| 66 | 66 | ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "' |
| 67 | - WHERE customer_id = '" . (int) $this->customer_id . "' |
|
| 67 | + WHERE customer_id = '" . (int)$this->customer_id . "' |
|
| 68 | 68 | "); |
| 69 | 69 | |
| 70 | 70 | $query = $this->db->query(" |
| 71 | 71 | SELECT * |
| 72 | 72 | FROM customer_ip |
| 73 | - WHERE customer_id = '" . (int) $this->session->data['customer_id'] . "' |
|
| 73 | + WHERE customer_id = '" . (int)$this->session->data['customer_id'] . "' |
|
| 74 | 74 | AND ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "' |
| 75 | 75 | "); |
| 76 | 76 | |
| 77 | 77 | if (!$query->num_rows) { |
| 78 | 78 | $this->db->query(" |
| 79 | 79 | INSERT INTO customer_ip |
| 80 | - SET customer_id = '" . (int) $this->session->data['customer_id'] . "', |
|
| 80 | + SET customer_id = '" . (int)$this->session->data['customer_id'] . "', |
|
| 81 | 81 | ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "', |
| 82 | 82 | date_added = NOW() |
| 83 | 83 | "); |
@@ -123,9 +123,9 @@ discard block |
||
| 123 | 123 | |
| 124 | 124 | $this->db->query(" |
| 125 | 125 | UPDATE customer |
| 126 | - SET language_id = '" . (int) $this->config->get('config_language_id') . "', |
|
| 126 | + SET language_id = '" . (int)$this->config->get('config_language_id') . "', |
|
| 127 | 127 | ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "' |
| 128 | - WHERE customer_id = '" . (int) $this->customer_id . "' |
|
| 128 | + WHERE customer_id = '" . (int)$this->customer_id . "' |
|
| 129 | 129 | "); |
| 130 | 130 | |
| 131 | 131 | return true; |
@@ -204,7 +204,7 @@ discard block |
||
| 204 | 204 | $query = $this->db->query(" |
| 205 | 205 | SELECT SUM(amount) AS total |
| 206 | 206 | FROM customer_transaction |
| 207 | - WHERE customer_id = '" . (int) $this->customer_id . "' |
|
| 207 | + WHERE customer_id = '" . (int)$this->customer_id . "' |
|
| 208 | 208 | "); |
| 209 | 209 | |
| 210 | 210 | return $query->row['total']; |
@@ -215,7 +215,7 @@ discard block |
||
| 215 | 215 | $query = $this->db->query(" |
| 216 | 216 | SELECT SUM(points) AS total |
| 217 | 217 | FROM customer_reward |
| 218 | - WHERE customer_id = '" . (int) $this->customer_id . "' |
|
| 218 | + WHERE customer_id = '" . (int)$this->customer_id . "' |
|
| 219 | 219 | "); |
| 220 | 220 | |
| 221 | 221 | return $query->row['total']; |
@@ -58,9 +58,9 @@ discard block |
||
| 58 | 58 | $value = $this->currencies[$currency]['value']; |
| 59 | 59 | } |
| 60 | 60 | |
| 61 | - $amount = $value ? (float) $number * $value : (float) $number; |
|
| 61 | + $amount = $value ? (float)$number * $value : (float)$number; |
|
| 62 | 62 | |
| 63 | - $amount = round($amount, (int) $decimal_place); |
|
| 63 | + $amount = round($amount, (int)$decimal_place); |
|
| 64 | 64 | |
| 65 | 65 | if (!$format) { |
| 66 | 66 | return $amount; |
@@ -72,7 +72,7 @@ discard block |
||
| 72 | 72 | $string .= $symbol_left; |
| 73 | 73 | } |
| 74 | 74 | |
| 75 | - $string .= number_format($amount, (int) $decimal_place, $this->language->get('decimal_point'), $this->language->get('thousand_point')); |
|
| 75 | + $string .= number_format($amount, (int)$decimal_place, $this->language->get('decimal_point'), $this->language->get('thousand_point')); |
|
| 76 | 76 | |
| 77 | 77 | if ($symbol_right) { |
| 78 | 78 | $string .= $symbol_right; |
@@ -45,7 +45,7 @@ discard block |
||
| 45 | 45 | $this->db->query(" |
| 46 | 46 | UPDATE cart |
| 47 | 47 | SET session_id = '" . $this->db->escape($this->session->getId()) . "' |
| 48 | - WHERE customer_id = '" . (int) $this->customer->getId() . "' |
|
| 48 | + WHERE customer_id = '" . (int)$this->customer->getId() . "' |
|
| 49 | 49 | "); |
| 50 | 50 | |
| 51 | 51 | // Once the customer is logged in we want to update the customers cart |
@@ -59,7 +59,7 @@ discard block |
||
| 59 | 59 | foreach ($cart_query->rows as $cart) { |
| 60 | 60 | $this->db->query(" |
| 61 | 61 | DELETE FROM cart |
| 62 | - WHERE cart_id = '" . (int) $cart['cart_id'] . "' |
|
| 62 | + WHERE cart_id = '" . (int)$cart['cart_id'] . "' |
|
| 63 | 63 | "); |
| 64 | 64 | |
| 65 | 65 | // The advantage of using $this->add is that it will check if the products already exist and increaser the quantity if necessary. |
@@ -75,7 +75,7 @@ discard block |
||
| 75 | 75 | $cart_query = $this->db->query(" |
| 76 | 76 | SELECT * |
| 77 | 77 | FROM cart |
| 78 | - WHERE customer_id = '" . (int) $this->customer->getId() . "' |
|
| 78 | + WHERE customer_id = '" . (int)$this->customer->getId() . "' |
|
| 79 | 79 | AND session_id = '" . $this->db->escape($this->session->getId()) . "' |
| 80 | 80 | "); |
| 81 | 81 | |
@@ -86,8 +86,8 @@ discard block |
||
| 86 | 86 | SELECT * |
| 87 | 87 | FROM product p |
| 88 | 88 | LEFT JOIN product_description pd ON (p.product_id = pd.product_id) |
| 89 | - WHERE p.product_id = '" . (int) $cart['product_id'] . "' |
|
| 90 | - AND pd.language_id = '" . (int) $this->config->get('config_language_id') . "' |
|
| 89 | + WHERE p.product_id = '" . (int)$cart['product_id'] . "' |
|
| 90 | + AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "' |
|
| 91 | 91 | AND p.status = '1' |
| 92 | 92 | "); |
| 93 | 93 | |
@@ -103,9 +103,9 @@ discard block |
||
| 103 | 103 | FROM product_option po |
| 104 | 104 | LEFT JOIN `option` o ON (po.option_id = o.option_id) |
| 105 | 105 | LEFT JOIN option_description od ON (o.option_id = od.option_id) |
| 106 | - WHERE po.product_option_id = '" . (int) $product_option_id . "' |
|
| 107 | - AND po.product_id = '" . (int) $cart['product_id'] . "' |
|
| 108 | - AND od.language_id = '" . (int) $this->config->get('config_language_id') . "' |
|
| 106 | + WHERE po.product_option_id = '" . (int)$product_option_id . "' |
|
| 107 | + AND po.product_id = '" . (int)$cart['product_id'] . "' |
|
| 108 | + AND od.language_id = '" . (int)$this->config->get('config_language_id') . "' |
|
| 109 | 109 | "); |
| 110 | 110 | |
| 111 | 111 | if ($option_query->num_rows) { |
@@ -115,9 +115,9 @@ discard block |
||
| 115 | 115 | FROM product_option_value pov |
| 116 | 116 | LEFT JOIN option_value ov ON (pov.option_value_id = ov.option_value_id) |
| 117 | 117 | LEFT JOIN option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) |
| 118 | - WHERE pov.product_option_value_id = '" . (int) $value . "' |
|
| 119 | - AND pov.product_option_id = '" . (int) $product_option_id . "' |
|
| 120 | - AND ovd.language_id = '" . (int) $this->config->get('config_language_id') . "' |
|
| 118 | + WHERE pov.product_option_value_id = '" . (int)$value . "' |
|
| 119 | + AND pov.product_option_id = '" . (int)$product_option_id . "' |
|
| 120 | + AND ovd.language_id = '" . (int)$this->config->get('config_language_id') . "' |
|
| 121 | 121 | "); |
| 122 | 122 | |
| 123 | 123 | if ($option_value_query->num_rows) { |
@@ -159,9 +159,9 @@ discard block |
||
| 159 | 159 | SELECT pov.option_value_id, pov.quantity, pov.subtract, pov.price, pov.price_prefix, pov.points, pov.points_prefix, ovd.name |
| 160 | 160 | FROM product_option_value pov |
| 161 | 161 | LEFT JOIN option_value_description ovd ON (pov.option_value_id = ovd.option_value_id) |
| 162 | - WHERE pov.product_option_value_id = '" . (int) $product_option_value_id . "' |
|
| 163 | - AND pov.product_option_id = '" . (int) $product_option_id . "' |
|
| 164 | - AND ovd.language_id = '" . (int) $this->config->get('config_language_id') . "' |
|
| 162 | + WHERE pov.product_option_value_id = '" . (int)$product_option_value_id . "' |
|
| 163 | + AND pov.product_option_id = '" . (int)$product_option_id . "' |
|
| 164 | + AND ovd.language_id = '" . (int)$this->config->get('config_language_id') . "' |
|
| 165 | 165 | "); |
| 166 | 166 | |
| 167 | 167 | if ($option_value_query->num_rows) { |
@@ -232,9 +232,9 @@ discard block |
||
| 232 | 232 | $product_discount_query = $this->db->query(" |
| 233 | 233 | SELECT price |
| 234 | 234 | FROM product_discount |
| 235 | - WHERE product_id = '" . (int) $cart['product_id'] . "' |
|
| 236 | - AND customer_group_id = '" . (int) $this->config->get('config_customer_group_id') . "' |
|
| 237 | - AND quantity <= '" . (int) $discount_quantity . "' |
|
| 235 | + WHERE product_id = '" . (int)$cart['product_id'] . "' |
|
| 236 | + AND customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' |
|
| 237 | + AND quantity <= '" . (int)$discount_quantity . "' |
|
| 238 | 238 | AND ((date_start = '2000-01-01' OR date_start < NOW()) |
| 239 | 239 | AND (date_end = '2000-01-01' OR date_end > NOW())) |
| 240 | 240 | ORDER BY quantity DESC, priority ASC, price ASC |
@@ -249,8 +249,8 @@ discard block |
||
| 249 | 249 | $product_special_query = $this->db->query(" |
| 250 | 250 | SELECT price |
| 251 | 251 | FROM product_special |
| 252 | - WHERE product_id = '" . (int) $cart['product_id'] . "' |
|
| 253 | - AND customer_group_id = '" . (int) $this->config->get('config_customer_group_id') . "' |
|
| 252 | + WHERE product_id = '" . (int)$cart['product_id'] . "' |
|
| 253 | + AND customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' |
|
| 254 | 254 | AND ((date_start = '2000-01-01' OR date_start < NOW()) |
| 255 | 255 | AND (date_end = '2000-01-01' OR date_end > NOW())) |
| 256 | 256 | ORDER BY priority ASC, price ASC |
@@ -265,8 +265,8 @@ discard block |
||
| 265 | 265 | $product_reward_query = $this->db->query(" |
| 266 | 266 | SELECT points |
| 267 | 267 | FROM product_reward |
| 268 | - WHERE product_id = '" . (int) $cart['product_id'] . "' |
|
| 269 | - AND customer_group_id = '" . (int) $this->config->get('config_customer_group_id') . "' |
|
| 268 | + WHERE product_id = '" . (int)$cart['product_id'] . "' |
|
| 269 | + AND customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' |
|
| 270 | 270 | "); |
| 271 | 271 | |
| 272 | 272 | if ($product_reward_query->num_rows) { |
@@ -283,8 +283,8 @@ discard block |
||
| 283 | 283 | FROM product_to_download p2d |
| 284 | 284 | LEFT JOIN download d ON (p2d.download_id = d.download_id) |
| 285 | 285 | LEFT JOIN download_description dd ON (d.download_id = dd.download_id) |
| 286 | - WHERE p2d.product_id = '" . (int) $cart['product_id'] . "' |
|
| 287 | - AND dd.language_id = '" . (int) $this->config->get('config_language_id') . "' |
|
| 286 | + WHERE p2d.product_id = '" . (int)$cart['product_id'] . "' |
|
| 287 | + AND dd.language_id = '" . (int)$this->config->get('config_language_id') . "' |
|
| 288 | 288 | "); |
| 289 | 289 | |
| 290 | 290 | foreach ($download_query->rows as $download) { |
@@ -334,29 +334,29 @@ discard block |
||
| 334 | 334 | $query = $this->db->query(" |
| 335 | 335 | SELECT COUNT(*) AS total |
| 336 | 336 | FROM cart |
| 337 | - WHERE customer_id = '" . (int) $this->customer->getId() . "' |
|
| 337 | + WHERE customer_id = '" . (int)$this->customer->getId() . "' |
|
| 338 | 338 | AND session_id = '" . $this->db->escape($this->session->getId()) . "' |
| 339 | - AND product_id = '" . (int) $product_id . "' |
|
| 339 | + AND product_id = '" . (int)$product_id . "' |
|
| 340 | 340 | AND `option` = '" . $this->db->escape(json_encode($option)) . "' |
| 341 | 341 | "); |
| 342 | 342 | |
| 343 | 343 | if (!$query->row['total']) { |
| 344 | 344 | $this->db->query(" |
| 345 | 345 | INSERT cart |
| 346 | - SET customer_id = '" . (int) $this->customer->getId() . "', |
|
| 346 | + SET customer_id = '" . (int)$this->customer->getId() . "', |
|
| 347 | 347 | session_id = '" . $this->db->escape($this->session->getId()) . "', |
| 348 | - product_id = '" . (int) $product_id . "', |
|
| 348 | + product_id = '" . (int)$product_id . "', |
|
| 349 | 349 | `option` = '" . $this->db->escape(json_encode($option)) . "', |
| 350 | - quantity = '" . (int) $quantity . "', |
|
| 350 | + quantity = '" . (int)$quantity . "', |
|
| 351 | 351 | date_added = NOW() |
| 352 | 352 | "); |
| 353 | 353 | } else { |
| 354 | 354 | $this->db->query(" |
| 355 | 355 | UPDATE cart |
| 356 | - SET quantity = (quantity + " . (int) $quantity . ") |
|
| 357 | - WHERE customer_id = '" . (int) $this->customer->getId() . "' |
|
| 356 | + SET quantity = (quantity + " . (int)$quantity . ") |
|
| 357 | + WHERE customer_id = '" . (int)$this->customer->getId() . "' |
|
| 358 | 358 | AND session_id = '" . $this->db->escape($this->session->getId()) . "' |
| 359 | - AND product_id = '" . (int) $product_id . "' |
|
| 359 | + AND product_id = '" . (int)$product_id . "' |
|
| 360 | 360 | AND `option` = '" . $this->db->escape(json_encode($option)) . "' |
| 361 | 361 | "); |
| 362 | 362 | } |
@@ -366,9 +366,9 @@ discard block |
||
| 366 | 366 | { |
| 367 | 367 | $this->db->query(" |
| 368 | 368 | UPDATE cart |
| 369 | - SET quantity = '" . (int) $quantity . "' |
|
| 370 | - WHERE cart_id = '" . (int) $cart_id . "' |
|
| 371 | - AND customer_id = '" . (int) $this->customer->getId() . "' |
|
| 369 | + SET quantity = '" . (int)$quantity . "' |
|
| 370 | + WHERE cart_id = '" . (int)$cart_id . "' |
|
| 371 | + AND customer_id = '" . (int)$this->customer->getId() . "' |
|
| 372 | 372 | AND session_id = '" . $this->db->escape($this->session->getId()) . "' |
| 373 | 373 | "); |
| 374 | 374 | } |
@@ -377,8 +377,8 @@ discard block |
||
| 377 | 377 | { |
| 378 | 378 | $this->db->query(" |
| 379 | 379 | DELETE FROM cart |
| 380 | - WHERE cart_id = '" . (int) $cart_id . "' |
|
| 381 | - AND customer_id = '" . (int) $this->customer->getId() . "' |
|
| 380 | + WHERE cart_id = '" . (int)$cart_id . "' |
|
| 381 | + AND customer_id = '" . (int)$this->customer->getId() . "' |
|
| 382 | 382 | AND session_id = '" . $this->db->escape($this->session->getId()) . "' |
| 383 | 383 | "); |
| 384 | 384 | } |
@@ -387,7 +387,7 @@ discard block |
||
| 387 | 387 | { |
| 388 | 388 | $this->db->query(" |
| 389 | 389 | DELETE FROM cart |
| 390 | - WHERE customer_id = '" . (int) $this->customer->getId() . "' |
|
| 390 | + WHERE customer_id = '" . (int)$this->customer->getId() . "' |
|
| 391 | 391 | AND session_id = '" . $this->db->escape($this->session->getId()) . "' |
| 392 | 392 | "); |
| 393 | 393 | } |
@@ -32,7 +32,7 @@ |
||
| 32 | 32 | { |
| 33 | 33 | $this->id = $route; |
| 34 | 34 | |
| 35 | - $parts = explode('/', preg_replace('/[^a-zA-Z0-9_\/]/', '', (string) $route)); |
|
| 35 | + $parts = explode('/', preg_replace('/[^a-zA-Z0-9_\/]/', '', (string)$route)); |
|
| 36 | 36 | |
| 37 | 37 | // Break apart the route |
| 38 | 38 | while ($parts) { |