Changeset 777 for trunk

Timestamp:

Sep 16, 2016, 10:21:04 PM (8 years ago)

Author:

autocommit@…

Message:

el nuevo query para actualizar la clave, anda

File:

• trunk/egroupware/CTA/inc/class.uiCTA.inc.php (modified) (2 diffs)

trunk/egroupware/CTA/inc/class.uiCTA.inc.php

@@ -10 +10 @@
         {
         print ($GLOBALS['egw_info']['user']['account_lid']); 
-        print "<br>";
-        print_r($data);
-        print "<br>GET :";
-        print_r ($_GET);
-        print "<br>POST:";
-        print_r ($_POST);
+        //print "<br>";
+        //print_r($data);
+        //print "<br>GET :";
+        //print_r ($_GET);
+        //print "<br>POST:";
+        //print_r ($_POST);
              
             include_once('/usr/share/alternc/panel/class/functions.php'); 
@@ -33 +33 @@
                 }
 
-                $username_=str_replace("@","_",$username);
-                print "<br /><br /><br />".$username_;
+                // separamos email en 2, usuario y dominio
+                $u_email = explode("@", $username);
+                $u_lp = $u_email[0];
+                $u_domain = $u_email[1];
+
+                // encrypt new password
                 $crypted_passwd=_md5cr($data['new_passwd']);
 
                 $connect_sql=mysql_connect($db_host.":".$db_port,$db_pwd_user,$db_pwd_pass);
+                if ($connect_sql)
+                {
+                        $db=mysql_select_db($db_pwd_name,$connect_sql);
+                        if($db)
+                        {
+                                $query="UPDATE address SET password=\"$crypted_passwd\"
+                                         WHERE address = \"$u_lp\"
+                                              AND domain_id = (SELECT id FROM domaines 
+                                                  WHERE domaine = \"$u_domain\")";
+
+                                //print "<br /><br /><br />".$query;
+
+                                $result=mysql_query($query, $connect_sql);
+
+                                // print resultados...
+                                //while($row = mysql_fetch_assoc($result)){
+                                //    foreach($row as $cname => $cvalue){
+                                //        print "$cname: $cvalue\t";
+                                //    }
+                                //    print "\r\n";
+                                //}
+ 
+                                if ($result)
+                                        {return true;}else return false;
+                                }else 
+                                        {return false;}
+
+                }else
+                {return false;}
         }
 }