Changeset 3458 for pmb4.2/trunk/fuentes/pmb/usur_imp_itaca.php

Timestamp:

Jan 31, 2017, 6:36:31 PM (3 years ago)

Author:

jrpelegrina

Message:

WIP in new procedure to renow users

File:

• pmb4.2/trunk/fuentes/pmb/usur_imp_itaca.php (modified) (2 diffs)

pmb4.2/trunk/fuentes/pmb/usur_imp_itaca.php

@@ -232 +232 @@
                                 
                         if (@mysql_num_rows($resul1) != 0) {
+                                $sql_user_cad="SELECT `empr`.`id_empr`, `empr`.`empr_login`, `empr`.`empr_password`, `empr`.`empr_location` FROM `empr` WHERE (`empr`.`empr_cb`='" . $tot[$num-$correctorNIA] . "' AND `empr`. `empr_nom` like '" . $tot[$num-(22+$correctorVacia)] . "' AND `empr`. `empr_prenom` like '" . $tot[$num-(21+$correctorVacia)] . "' AND  `empr`. `empr_date_expiration`< '" . $fecha . "')";
+                                $resul_cad= @mysql_query($sql_user_cad, $link2);
+                                
                                 //echo "$msg[usur_imp_b] <b>" . $tot[$num-23] . "</b><br>";
                                 $row1 = mysql_fetch_array($resul1);
@@ -269 +272 @@
                                 //$requete .= "empr_statut='"$tot[$num-22]."',";
                                 $requete .= "empr_modif='".$fecha."',";
+                                if (@mysql_num_rows($resul_cad) != 0) {
+                                        $requete .= "empr_date_expiration='".$fecha_cad."',";
+                                }
                                 $requete .= "empr_sexe=".intval(($tot[$num-(10+$correctorVacia)]))."";
                                 $requete .= " WHERE id_empr=".intval($row1['id_empr'])." ";