@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | } elseif (isset($mLogin['status']) && $mLogin['status'] === 'emailnotverified') { |
54 | 54 | $this->P->oPayload->cl_html = $textcats->T('login_fail_emailnotverified').'<br><br>'; |
55 | 55 | $this->P->oPayload->cl_html .= '<a href="/_misc/resendverificationmail.html?email=' |
56 | - .$mLogin['data']['cust_email'].'">'.$textcats->T('login_fail_emailnotverifiedresend').'</a>'; |
|
56 | + .$mLogin['data']['cust_email'].'">'.$textcats->T('login_fail_emailnotverifiedresend').'</a>'; |
|
57 | 57 | $this->P->cb_customcontenttemplate = 'customer/login'; |
58 | 58 | } elseif (isset($mLogin['status']) && $mLogin['status'] === 'accountinactive') { |
59 | 59 | $this->P->oPayload->cl_html = $textcats->T('login_fail_accountinactive').'<br>'; |
@@ -83,7 +83,7 @@ discard block |
||
83 | 83 | $sUser = filter_var(trim(Tools::getFormfield('user')), FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW); |
84 | 84 | |
85 | 85 | $sql = 'SELECT cust_no, cust_email, cust_password, cust_active, cust_emailverified, cust_tosaccepted' |
86 | - .' FROM customer WHERE '; |
|
86 | + .' FROM customer WHERE '; |
|
87 | 87 | if ($bTryEmail) { |
88 | 88 | $sql .= '('; |
89 | 89 | } |
@@ -61,7 +61,7 @@ |
||
61 | 61 | $this->P->oPayload->cl_html = $this->textcats->T('denied_default'); |
62 | 62 | } else { |
63 | 63 | $sql = 'SELECT cust_email, cust_id FROM customer ' |
64 | - .'WHERE cust_emailverificationcode = :key AND cust_emailverified = \'n\''; |
|
64 | + .'WHERE cust_emailverificationcode = :key AND cust_emailverified = \'n\''; |
|
65 | 65 | /** @var \PDOStatement $hResult */ |
66 | 66 | $hResult = $this->db->prepare($sql); |
67 | 67 | $hResult->bindValue(':key', filter_input(INPUT_GET, 'key', FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW), \PDO::PARAM_STR); |
@@ -54,7 +54,7 @@ |
||
54 | 54 | |
55 | 55 | $iId = \filter_input(INPUT_GET, 'id', FILTER_SANITIZE_NUMBER_INT); |
56 | 56 | $sql = 'SELECT * FROM orders ' |
57 | - ."WHERE o_id = :id AND o_paymentmethod = 'sofortueberweisung' AND o_paymentcompleted = 'n'"; |
|
57 | + ."WHERE o_id = :id AND o_paymentmethod = 'sofortueberweisung' AND o_paymentcompleted = 'n'"; |
|
58 | 58 | |
59 | 59 | /** @var \PDOStatement $hResult */ |
60 | 60 | $hResult = $this->serviceManager->get('db')->prepare($sql); |
@@ -207,9 +207,9 @@ |
||
207 | 207 | public function getGroupdata($sGroup) |
208 | 208 | { |
209 | 209 | $sql = 'SELECT '.DB_ITEMGROUPFIELDS.' FROM itemgroups_base' |
210 | - .' LEFT OUTER JOIN itemgroups_text ON itemgroups_base.itmg_id = itemgroups_text.itmgt_pid' |
|
211 | - .' AND itmgt_lang = :lang' |
|
212 | - .' WHERE itmg_id = :group'; |
|
210 | + .' LEFT OUTER JOIN itemgroups_text ON itemgroups_base.itmg_id = itemgroups_text.itmgt_pid' |
|
211 | + .' AND itmgt_lang = :lang' |
|
212 | + .' WHERE itmg_id = :group'; |
|
213 | 213 | |
214 | 214 | $hResult = $this->db->prepare($sql); |
215 | 215 | $hResult->bindValue(':lang', $this->config->getLang(), \PDO::PARAM_STR); |