| @@ -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); |