Révision fed664aa htdocs/epack/commande.php
| htdocs/epack/commande.php | ||
|---|---|---|
| 264 | 264 |
if($_SESSION['epack_session'] == 1) {
|
| 265 | 265 |
//Code saisi ... |
| 266 | 266 |
if(trim($login_email) != "" && trim($login_pass) != "") {
|
| 267 |
$query = "SELECT gu.ID as userid,firstname,realname,FK_entities,g.name as company, g.completename as completename FROM glpi_users as gu |
|
| 268 |
LEFT JOIN glpi_entities AS g ON FK_entities=g.ID |
|
| 269 |
WHERE gu.name='" . $login_email . "' AND gu.password_md5='" . md5($login_pass) . "'"; |
|
| 267 |
//profil 8 -> ce sont les grossistes, 3 et 4 c'est admin et super admin |
|
| 268 |
$query = "SELECT gu.ID as userid,firstname,realname,gu.FK_entities,ge.name as company, ge.completename as completename FROM glpi_users as gu |
|
| 269 |
LEFT JOIN glpi_users_profiles AS gup ON gup.FK_users=gu.ID |
|
| 270 |
LEFT JOIN glpi_entities AS ge ON gu.FK_entities=ge.ID |
|
| 271 |
WHERE gu.email='" . $login_email . "' AND gu.password_md5=MD5('" . $login_pass . "') AND (gup.FK_profiles='8' OR gup.FK_profiles='3' OR gup.FK_profiles='4')
|
|
| 272 |
GROUP BY gu.email"; |
|
| 273 |
|
|
| 274 |
//print $query; |
|
| 270 | 275 |
|
| 271 | 276 |
$result = $DB->query($query); |
| 272 | 277 |
$data=$DB->fetch_assoc($result); |
Formats disponibles : Unified diff