jro_apps/pbase Commit - r4:5 · Jicamarca Repository

modificaciones del componente usuarios. Reduccion de codigo

arturo -

r4:5

parent child

trunk/administrator/components/com_users/UsersController.php +2 -3

             <?php
             class UsersController extends ControllerBase{
   No newline at end of file
                 public function ingresar(){
   No newline at end of file
                     if(isset($_SESSION['usersession']['iduser'])){
                         require 'models/UsersModel.php';
   No newline at end of file
                         $user       = new UsersModel();
                         $session    = new SessionsModel();
   No newline at end of file
                         $datos_validados = $user->obtenerUsuarioxId($_SESSION['usersession']['iduser']);
                         $datos_session_validados = $session->validarSession($_SESSION['usersession']['iduser']);
   No newline at end of file
                         $datos_usuario = $datos_validados->fetch();
                         $datos_session = $datos_session_validados->fetch();
   No newline at end of file
                         if(is_array($datos_usuario) && is_array($datos_session) && ($datos_usuario['usertype'] == 2) ){
                             //$resultado_log = $items->registrarLogIngreso($datos_usuario["id_usu"]); ///???
                             //require 'components'.DS.'com_messages'.DS.'models'.DS.'MailBoxesModel.php';
   No newline at end of file
                             $date_last_activity = new DateTime(date("Y-m-d H:i:s"));
   No newline at end of file
                             //$mailbox = new MailBoxesModel();
   No newline at end of file
                             //$rs_boxes = $mailbox->getMailBoxesSystem($datos_usuario['iduser']);
   No newline at end of file
                             //$idtypemb = 1;
                             //$rsMailBox = $mailbox->getMailBoxType($datos_usuario['iduser'], $idtypemb);
                             //$datosMailBox = $rsMailBox->fetch();
   No newline at end of file
                             //$lista_mensajes = $mailbox->getMessagesNoRead($datosMailBox['idmailbox']);
                             //$idmailbox = $datosMailBox['idmailbox'];
   No newline at end of file
                             $_SESSION['usersession']['attempt']             = 0;
                             $_SESSION['usersession']['iduser']              = $datos_usuario['iduser'];
                             $_SESSION['usersession']['date_last_activity']  = $date_last_activity->format("Y-m-d H:i:s") ;
                             $_SESSION['usersession']['idsession']           = $datos_session['idsession'];
   No newline at end of file
                             $datos['idsession'] = $datos_session['idsession'];
                             $datos['date_last_activity'] =  $date_last_activity->format("Y-m-d H:i:s") ;
   No newline at end of file
                             if($datos_usuario['state'] == 1){
                                 $data['datos_usuario']  = $datos_usuario;
                                 $data['inicio']         = 0;
                                 //$data['rs_boxes']       = $rs_boxes;
                                 //$data['lista_mensajes'] = $lista_mensajes;
                                 //$data['idmailbox']      = $idmailbox;
                                 $data['content']        = "components".DS."com_users".DS."views".DS."home.php";
                                 $data['title']          = "WELCOME:::::::::::::";
   No newline at end of file
                                 $this->view->show("template.php", $data);
                             }else{
                                 $data = array();
                                 $data['xin'] = '';
                                 $data['forget'] = 'no';
                                 $data['force'] = 'yes';
   No newline at end of file
                                 $this->view->show("usersNewPasswordForm.php", $data);
                             }
                         }else{
                             $data = array();
                             $this->view->show("login.php", $data);
                         }
                     }else{
                         $data = array();
                         $this->view->show("login.php", $data);
                     }
                 }
   No newline at end of file
                 public function validarUsuario(){
   No newline at end of file
                     $valor_intervalo = 30;
                     $intervalo = 'PT'.$valor_intervalo.'M';
                     $tiempo_bloqueo = new DateInterval($intervalo); //minutos
   No newline at end of file
                     if(isset($_SESSION['usersession']['timebadlogin'])){
                         $valor_timebadlogin = $_SESSION['usersession']['timebadlogin'];
                         $timebadlogin = new DateTime($valor_timebadlogin);
                         date_add($timebadlogin, $tiempo_bloqueo);
                         $timeactual = new DateTime(date("Y-m-d H:i:s"));
   No newline at end of file
                         if($timeactual > $timebadlogin){
                             $_SESSION['usersession']['disabled'] = false;
                             $_SESSION['usersession']['attempt']  = 0;
                             unset($_SESSION['usersession']['timebadlogin']);
                         }
                     }
   No newline at end of file
                     require 'components'.DS.'com_users'.DS.'models'.DS.'UsersModel.php';
   No newline at end of file
                     $user       = new UsersModel();
                     $session    = new SessionsModel();
   No newline at end of file
                     $username = $_REQUEST["username"];
                     $password = $_REQUEST["passwd"];
   No newline at end of file
                     if( (@$_SESSION['usersession']['attempt'] < 3) && ( @!$_SESSION['usersession']['disabled'] )  ){
   No newline at end of file
                         $datos_usuario = "";
                         $rs_usuario = $user->validateUsers($username,$password);
                         $datos_usuario = $rs_usuario->fetch();
   No newline at end of file
                         if(@is_array($datos_usuario)){
                             $_SESSION["usersession"]["iduser"]      = $datos_usuario['iduser'];
                             $_SESSION["usersession"]["username"]    = $datos_usuario['username'];
                             $_SESSION["usersession"]["firstname"]   = $datos_usuario['firstname'];
                             $_SESSION["usersession"]["lastname"]    = $datos_usuario['lastname'];
                             $_SESSION["usersession"]["photo"]       = $datos_usuario['photo'];
                             $_SESSION["usersession"]["type"]        = $datos_usuario['usertype'];
   No newline at end of file
                             $date_session       = new DateTime(date('Y-m-d H:i:s'));
                             $date_last_activity = new DateTime(date("Y-m-d H:i:s"));
   No newline at end of file
                             $datos['idsession']             = "";
                             $datos['iduser']                = $datos_usuario['iduser'];
                             $datos['client_ip']             = $_SERVER['REMOTE_ADDR'];
                             $datos['date_session']          = $date_session->format('Y-m-d H:i:s');
                             $datos['date_last_activity']    = $date_last_activity->format("Y-m-d H:i:s") ;
                             $datos['state']                 = 1;
   No newline at end of file
                             list($rs_session, $idsession, $message) = $session->addItem($datos);
                             $_SESSION['usersession']['idsession']   = $idsession;
   No newline at end of file
                             $_SESSION['usersession']['attempt']             = 0;
                             $_SESSION['usersession']['client_ip']           = $_SERVER['REMOTE_ADDR'];
                             $_SESSION['usersession']['date_session']        = $date_session->format('Y-m-d H:i:s');
                             $_SESSION['usersession']['date_last_activity']  = $date_last_activity->format("Y-m-d H:i:s");
                             $_SESSION['usersession']['state']               = 1;
                             //coloca los idmailbox dentro de la variable de session
                             //$_SESSION['usersession']['inbox']   = $mnuBoxes[0]['idmailbox'];//Inbox
                             $_SESSION['usersession']['inbox']   = 1;//Inbox
                             //$_SESSION['usersession']['sent']    = $mnuBoxes[1]['idmailbox'];//Sent
                             $_SESSION['usersession']['sent']    = 2;//Sent
                             //$_SESSION['usersession']['trash']   = $mnuBoxes[2]['idmailbox'];//Trash
                             $_SESSION['usersession']['trash']   = 3;//Trash
   No newline at end of file
                             if(($datos_usuario['state'] == 4) || ($datos_usuario['state'] == 5)){
                                 $url = "index.php?option=com_users&controller=Users&action=getNewPasswordForm";
                                 header("location: ".$url);
                                 exit(0);
                             }
                             if($datos_usuario['state'] == 2){
                                 $data['titulo']     = "Error:: User Locked";
                                 $data['mensaje']    = "Login is disabled by excesses of failed attempts. Contact your 'System Administrator' to solve the problem";
                                 $this->view->show("errorLogin.php", $data);
                                 exit(0);
                             }
   No newline at end of file
                             $flag_activo = true;
                             //require 'components'.DS.'com_messages'.DS.'models'.DS.'MailBoxesModel.php';
   No newline at end of file
                             //$resultado_log = $items->registrarLogIngreso($datos_usuario["id_usu"]);
                             /*
                             $mailbox = new MailBoxesModel();
   No newline at end of file
                             $rs_boxes       = $mailbox->getMailBoxesSystem($datos_usuario['iduser']);
                             //Coloca los idmailbox dentro de variables de session
                             $rs_mnuboxes    = $mailbox->getIDMailBoxesSystem($datos_usuario['iduser']);
                             $mnuBoxes       = $rs_mnuboxes->fetchAll();
   No newline at end of file
                             $idtypemb = 1;
                             $rsMailBox = $mailbox->getMailBoxType($datos_usuario['iduser'], $idtypemb);
                             $datosMailBox = $rsMailBox->fetch();
   No newline at end of file
                             $lista_mensajes = $mailbox->getMessagesNoRead($datosMailBox['idmailbox']);
                             $idmailbox = $datosMailBox['idmailbox'];
                             */
   No newline at end of file
                             $data['datos_usuario']  = $datos_usuario;
                             $data['inicio']         = 0;
                             //$data['rs_boxes']       = $rs_boxes;
                             //$data['lista_mensajes'] = $lista_mensajes;
                             //$data['idmailbox']      = $idmailbox;
                             $data['content']        = "components".DS."com_users".DS."views".DS."home.php";
                             $data['title']          = "WELCOME:::::::::::";
   No newline at end of file
                             $this->view->show("template.php", $data);
                         }else{
                             $result = $user->obtenerUsuarioxUsername($username);
                             $data_user = $result->fetch();
                             if(is_array($data_user)){
                                 if (!isset($_SESSION['usersession'])) {
                                     $_SESSION['usersession']            = array();
                                     $_SESSION['usersession']['attempt'] = 1;
                                 }else{
                                     if (!isset($_SESSION['usersession']['attempt'])) {
                                         $_SESSION['usersession']['attempt'] = 1;
                                     }else{
                                         $_SESSION['usersession']['attempt']++;
                                     }
                                 }
                                 if ($_SESSION['usersession']['attempt'] == 3){
                                     $datos['state'] = 2;
                                     $user->setIdValue($data_user['iduser']);
                                     list($result, $message) = $user->UpdateItem($datos);
   No newline at end of file
                                     $data['titulo']     = "Failed attempts excess";
                                     $data['mensaje']    = "You have exceeded the number of attempts. <br /> User blocked";
   No newline at end of file
                                     $this->view->show("errorLogin.php", $data);
                                     exit(0);
                                 }
                             }else{
                                 if (!isset($_SESSION['usersession'])) {
                                     $_SESSION['usersession']            = array();
                                     $_SESSION['usersession']['attempt'] = 1;
                                 }else{
                                     if (!isset($_SESSION['usersession']['attempt'])) {
                                         $_SESSION['usersession']['attempt'] = 1;
                                     }else{
                                         $_SESSION['usersession']['attempt']++;
                                     }
                                 }
                                 $data['titulo']     = "Error user login / password";
                                 $data['mensaje']    = "Error user login / password";
                                 //Finalmente presentamos nuestra plantilla
                                 $this->view->show("errorLogin.php", $data);
                                 exit(0);
                             }
                         }
                     }else{
                         //EXCESO DE INTENTOS
                         $timebadlogin = new DateTime(date('Y-m-d H:i:s'));
                         //deshabilitar logueo por determinado tiempo
                         $data['titulo']     = "Failed attempts excess";
                         $data['mensaje']    = "You have exceeded the number of attempts.<br />Try again in".$valor_intervalo." minutes";
                         //establecemos la variable que maneje el tiempo de espera
                         $_SESSION['usersession']['disabled'] = true;
                         if(!isset($_SESSION['usersession']['timebadlogin'])){
                             $_SESSION['usersession']['timebadlogin'] = $timebadlogin->format('Y-m-d H:i:s');
                         }
   No newline at end of file
                         $this->view->show("errorLogin.php", $data);
                     }
                 }
   No newline at end of file
                 public function logout(){
                     //@print_r($_SESSION['usersession']);
                     $session = new SessionsModel();
   No newline at end of file
                     $rs_datos_session = $session->validarSession(@$_SESSION['usersession']['iduser']);
                     //print_r($rs_datos_session);
                     $datos_session = $rs_datos_session->fetch();
                     $date_last_activity = new DateTime(date("Y-m-d H:i:s"));
   No newline at end of file
                     //establecemos el arreglo datos.
                     $datos['date_last_activity'] = $date_last_activity->format('Y-m-d H:i:s');
                     $datos['idsession'] = $datos_session['idsession'];
                     $rs = $session->setInactive($datos);
   No newline at end of file
                     unset($_SESSION['usersession']);
                     session_destroy();
   No newline at end of file
                     $data = array();
                     $this->view->show("logout.php", $data);
                 }
   No newline at end of file
                 public function getRememberPasswordForm(){
                     $data = array();
                     $this->view->show("password.php", $data);
                 }
   No newline at end of file
                 public function sendPasswordLink(){
   No newline at end of file
                     require 'models/UsersModel.php';
                     $user = new UsersModel();
   No newline at end of file
                     $username = $_REQUEST["usuario"];
   No newline at end of file
                     $rs_usuario = $user->obtenerUsuarioxUsername($username);
                     $datos_usuario = $rs_usuario->fetch();
   No newline at end of file
                     if(is_array($datos_usuario)){
                         $servername = $_SERVER['SERVER_NAME'];
                         $usernamemd5 = md5($datos_usuario['username']);
                         $link = 'http://'.$servername.'/?controller=Users&action=getNewPasswordForm&xin='.$usernamemd5.'&forget=yes';
   No newline at end of file
                         $contenido = '';
   No newline at end of file
                         $destinatario = "nmedina79@gmail.com";
                         $asunto = "Este mensaje es de prueba";
                         $cuerpo = '
                         <html>
                         <head>
                            <title>Prueba de correo</title>
                         </head>
                         <body>
                         <h1>Hola amigos!</h1>
                         <p>
                         <b>Bienvenidos a mi correo electronico de prueba</b>. Estoy encantado de tener tantos lectores. Este cuerpo del mensaje es del articulo de envio de mails por PHP. Habria que cambiarlo para poner tu propio cuerpo. Por cierto, cambia tambien las cabeceras del mensaje.<br/>
                         enlace : <a href="'.$link.'" target="_parent">'.$link.'</a>
   No newline at end of file
                         </p>
                         </body>
                         </html>
                         ';
   No newline at end of file
                         //para el envio en formato HTML
                         $headers = "MIME-Version: 1.0\r\n";
                         $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
   No newline at end of file
                         //direccion del remitente
                         $headers .= "From: Administrador <admin@epimed.com>\r\n";
   No newline at end of file
                         //direccion de respuesta, si queremos que sea distinta que la del remitente
                         $headers .= "Reply-To: deployment@epimed.com\r\n";
   No newline at end of file
                         //ruta del mensaje desde origen a destino
                         $headers .= "Return-path: nmedina79@gmail.com\r\n";
   No newline at end of file
                         //direcciones que recibion copia
                         $headers .= "Cc: deployment@epimed.com\r\n";
   No newline at end of file
                         //direcciones que recibiron copia oculta
                         $headers .= "Bcc: jsalyrosas@poweruptechs.com,hleon@poweruptechs.com\r\n";
   No newline at end of file
                         if(mail($destinatario,$asunto,$cuerpo,$headers)){
                             $mensaje = 'An email with a link to update has been sent to your email.';
                         }else{
                             $mensaje = 'Failed to send link. Try again in a few minutes or contact your system administrator';
                         }
   No newline at end of file
                         try{
                             mail($destinatario,$asunto,$cuerpo,$headers);
                         }catch (Exception $e){
                             echo 'Caught exception: ',  $e->getMessage(), "\n";
                         }
   No newline at end of file
                         /*
                         require("class.phpmailer.php");
                         $mail = new PHPMailer();
   No newline at end of file
                         $mail->IsSMTP();                                      // set mailer to use SMTP
                         $mail->Host = "smtp.innovaciencia.com;smtp.innovaciencia.com";  // specify main and backup server
                         $mail->SMTPAuth = true;     // turn on SMTP authentication
                         $mail->Username = "jsalyrosas";  // SMTP username
                         $mail->Password = "j05e4nt0n10"; // SMTP password
   No newline at end of file
                         $mail->From = "Admin@epimed.com";
                         $mail->FromName = "Admin";
                         $mail->AddAddress("nmedina79@gmail.com", "Josh Adams");
                         $mail->AddAddress("nmedina79@gmail.com");                  // name is optional
                         $mail->AddReplyTo("nmedina79@hotmail.com", "Information");
   No newline at end of file
                         $mail->WordWrap = 50;                                 // set word wrap to 50 characters
                         //$mail->AddAttachment("/var/tmp/file.tar.gz");         // add attachments
                         //$mail->AddAttachment("/tmp/image.jpg", "new.jpg");    // optional name
                         $mail->IsHTML(true);                                  // set email format to HTML
   No newline at end of file
                         $mail->Subject = "Here is the subject";
                         //$mail->Body    = "This is the HTML message body <b>in bold!</b>".$cuerpo;
                         $mail->Body    =  $cuerpo;
                         $mail->AltBody = "This is the body in plain text for non-HTML mail clients";
   No newline at end of file
                         if(!$mail->Send()){
                            echo "Message could not be sent. <p>";
                            echo "Mailer Error: " . $mail->ErrorInfo;
                            exit;
                         }
   No newline at end of file
                         echo "Message has been sent";
                         */
                     }else{
                         $mensaje = " User doesn't exist.";
                     }
   No newline at end of file
                     $data = array();
                     $data['mensaje']    =  $mensaje;
                     $data['link']       =  $link;
   No newline at end of file
                     $this->view->show("password.php", $data);
                 }
   No newline at end of file
                 public function getNewPasswordForm(){
                     (!empty($_REQUEST['forget']))?$forget = $_REQUEST['forget']:$forget='no';
                     (!empty($_REQUEST['xin']))?$xin = $_REQUEST['xin']:$xin='';
                     (!empty($_REQUEST['force']))?$force = $_REQUEST['force']:$force='yes';
   No newline at end of file
                     //@$forget = $_REQUEST['forget'];
                     //@$xin = $_REQUEST['xin'];
                     $data = array();
                     $data['forget'] = $forget;
                     $data['force'] = $force;
                     $data['xin'] = $xin;
   No newline at end of file
                     $this->view->show("change_passwd.php", $data);
                 }
   No newline at end of file
                 public function passwordUpdate(){
   No newline at end of file
                     $datos = $_REQUEST['datos'];
                     (!empty($_REQUEST['forget']))?$forget = $_REQUEST['forget']:$forget='no';
                     (!empty($_REQUEST['usernamemd5']))?$usernamemd5 = $_REQUEST['xin']:$usernamemd5='';
                     (!empty($_REQUEST['force']))?$force = $_REQUEST['force']:$force='';
                     //@$forget = $_REQUEST['forget'];
                     //@$usernamemd5 = $_REQUEST['xin'];
                     //@$force = $_REQUEST['force'];
   No newline at end of file
                     //print_r($datos);
   No newline at end of file
                     require 'models/UsersModel.php';
   No newline at end of file
                     $user = new UsersModel();
   No newline at end of file
                     if( $datos['new_password'] == $datos['new_password_again']){
   No newline at end of file
                         if($forget == 'yes'){
                             //echo $usernamemd5;
                             $rs_usuario = $user->obtenerUsuarioxUsernameMD5($usernamemd5);
                             //print_r($rs_usuario);
                             $datos_usuario = $rs_usuario->fetch();
                             $iduser = $datos_usuario['iduser'];
                             $password = $datos['new_password'];
                             $rs_updatePassword = $user->setNewPassword($iduser,$password);
                             //print_r($rs_updatePassword);
                             $data['xin'] = $usernamemd5;
                             $data['forget'] = $forget;
                             $data['force'] = $force;
   No newline at end of file
                             $data['mensaje'] = ' your password has been updated<br/><a href="?controller=Users&action=ingresar">next</a>';
                             unset($_SESSION['sessionuser']);
                             $this->view->show("usersNewPasswordForm.php", $data);
   No newline at end of file
                             }else{
                                     if(!empty($datos['current_password'])){
                                             //validarAdministrador($username,$password)
                                             if(!empty($_SESSION['usersession']['iduser'])){
                                                     $iduser = $_SESSION['usersession']['iduser'];
                                                     $password = $datos['new_password'];
                                                     $rs_usuario = $user->obtenerUsuarioxId($iduser);
                                                     $datos_usuario = $rs_usuario->fetch();
   No newline at end of file
                                                     //validamos la existencia del usuario
                                                     $username = $datos_usuario['username'];
                                                     $current_password = $datos['current_password'];//
                                                     $rs_validado = $user->validarAdministrador($username,$current_password);
                                                     $datos_validado = $rs_validado->fetch();
   No newline at end of file
                                                     if(is_array($datos_validado)){
                                                             //actualizamos el nuevo password
                                                             $rs_updatePassword = $user->setNewPassword($iduser,$password);
                                                             //cambiar el estado del usuario
                                                             $rs_updatePassword = $user->setActive($iduser);
   No newline at end of file
                                                             unset($_SESSION['usersession']);
                                                             $data = array();
                                                             $data['forget'] = $forget;
                                                             $data['mensaje'] = ' your password has been updated<br/><a href="send.php?controller=Users&action=logout" target="enviar">continuar</a>';
                                                             $this->view->show("usersNewPasswordForm.php", $data);
   No newline at end of file
   No newline at end of file
                                                     }else{
                                                             $data['mensaje'] = ' your current password is invalid ';
                                                             $this->view->show("usersNewPasswordForm.php", $data);
                                                     }
                                             }else{
                                                     $data['mensaje'] = ' you have not started your user session.<br/> ';
                                                     $this->view->show("login.php", $data);
                                             }
                                     }else{
                                             //$data['xin'] = $usernamemd5;
                                             //$data['forget'] = $forget;
                                             $data['mensaje'] = ' did not enter the current password ';
                                             $this->view->show("usersNewPasswordForm.php", $data);
                                     }
                             }
   No newline at end of file
                     }else{
                             $data['xin'] = $usernamemd5;
                             $data['forget'] = $forget;
                             $data['mensaje'] = 'the new password entered does not match';
                             $this->view->show("usersNewPasswordForm.php", $data);
                     }
   No newline at end of file
                 }
   No newline at end of file
                 public function dolist(){
                     require 'components'.DS.'com_users'.DS.'models'.DS.'UsersModel.php';
                     $users = new UsersModel();
   No newline at end of file
                     if(!empty($_REQUEST['inicio'])){
                             $inicio = $_REQUEST['inicio'];
                     }else{
                             $inicio = 0;
                     }
   No newline at end of file
                     $tamanio = 15;
                     $parametros = array("inicio" => $inicio, "tamanio" => $tamanio);
                     list($list_users, $paginas, $navegador) = $users->dolist($parametros);
   No newline at end of file
                     $data['listUsers']  = $list_users;
                     $data['paginas']    = $paginas;
                     $data['navegador']  = $navegador;
                     $data['inicio']     = $inicio;
                     $data['content']    = "components".DS."com_users".DS."views".DS."dolist.php";
                     $data['title']      = "USUARIOS::::::::::::";
   No newline at end of file
                     $this->view->show("template.php", $data);
                 }
   No newline at end of file
                 public function newUser(){
                     if(!empty($_REQUEST['message'])){
                         $message = $_REQUEST['message'];
                     }else{
                         $message = "";
                     }
                     $data['message']    = $message;
                     $data['content']    = "components".DS."com_users".DS."views".DS."newUser.php";
                     $data['title']      = "NEW USER:::::";
   No newline at end of file
                     $this->view->show("template.php", $data);
                 }
   No newline at end of file
                 public function addUser(){
                     require 'components'.DS.'com_users'.DS.'models'.DS.'UsersModel.php';
                     $user = new UsersModel();
   No newline at end of file
                     $data_user              = $_REQUEST["data_user"];
                     $data_user['username']  = $_REQUEST["newusername"];
                     $data_user['password']  = md5($_REQUEST["newpasswd"]);
                     $data_user['email']     = $_REQUEST["txt_email"];
                     $data_user['usertype']  = 1;
                     $data_user['state']     = 4;
   No newline at end of file
                     $urlphoto   = "avatar.jpg";
   No newline at end of file
                     $url = explode(DS, trim(dirname(__DIR__)));
                     array_pop($url);
                     array_pop($url);
                     array_pop($url);
                     array_pop($url);
                     $path = implode(DS, $url);
   No newline at end of file
                     $flag = FALSE;
                     $data_list = $user->getAllUsers();
  No newline at end of file
-                    $result = $user->getAllUsers();
              No newline at end of file
-                    $data_list = $result->fetchAll();
  No newline at end of file
                     foreach($data_list as $userdata){
                         if(strtolower($data_user['username']) == strtolower($userdata->username)){$flag = TRUE; break;}
  No newline at end of file
-                        if(strtolower($data_user['username']) == strtolower($userdata['username'])){$flag = TRUE; break;}
  No newline at end of file
                     }
   No newline at end of file
                     if($flag === FALSE){
                         if($_FILES['fphoto']['tmp_name'] != ""){
                             if (is_uploaded_file($_FILES['fphoto']['tmp_name'])){
                                 $psize = $_FILES ['fphoto']['size'];
                                 $pname = $_FILES ['fphoto']['name'];
                                 $type = substr( $pname, strlen($pname)-4);
                                 if($type==".jpg" || $type==".gif" || $type==".png" || $type==".JPG" || $type==".GIF" || $type==".PNG"){
                                     copy($_FILES['fphoto']['tmp_name'], $path.DS."files".DS."photos".DS.$username.$type);
                                     $urlphoto = "photos".DS.$username.$type;
                                 }else{
                                     $mensaje_upload = ". Uploaded failed: No image file.";// error por tipo
                                 }
                             }else{
                                 $mensaje_upload = ". Uploaded failed.";// error por tamanio
                             }
                         }else{
                             $mensaje_upload = "Error: Uploaded failed.";
                         }
   No newline at end of file
                         $data_user['photo'] = $urlphoto;
                         list($result, $id, $message) = $user->addItem($data_user);
   No newline at end of file
                         $url = 'index.php?option=com_users&controller=Users&action=dolist';
                     }else{
                         $message = "Error::: Username unavailable.";
                         $url = 'index.php?option=com_users&controller=Users&action=newUser&message='.$message;
                     }
                     header("location: ".$url);
                     exit();
                 }
   No newline at end of file
                 public function editUser(){
                     require 'components'.DS.'com_users'.DS.'models'.DS.'UsersModel.php';
   No newline at end of file
                     $user = new UsersModel();
   No newline at end of file
                     $iduser     = $_REQUEST['user'];
                     $newuser    = $user->editUser($iduser);
                     $method     = "edit";
   No newline at end of file
                     $data['usuario']    = $newuser->fetch();
                     $data['edit']       = true;
                     $data['method']     = $method;
                     $data['iduser']     = $iduser;
                     $data['content']    = "components".DS."com_users".DS."views".DS."editUser.php";
                     $data['title']      = "EDIT USER::::::::::::::::";
   No newline at end of file
                     $this->view->show("template.php", $data);
                 }
   No newline at end of file
                 public function view(){
                     require 'models/UsersModel.php';
   No newline at end of file
                     $user = new UsersModel();
   No newline at end of file
                     $iduser     = $_REQUEST['user'];
                     $newuser    = $user->editUser($iduser);
                     $method     = "view";
   No newline at end of file
                     $data['usuario']    = $newuser->fetch();
                     $data['edit']       = false;
                     $data['method']     = $method;
                     $data['iduser']     = $iduser;
                     $data['content']    = "components".DS."com_users".DS."views".DS."editUser.php";
   No newline at end of file
                     $this->view->show("template.php", $data);
                 }
   No newline at end of file
                 public function updateUser(){
                     require 'components'.DS.'com_users'.DS.'models'.DS.'UsersModel.php';
   No newline at end of file
                     $user = new UsersModel();
                     $iduser                 = $_POST['iduser'];
                     $datos['firstname'] 	= $_POST['firstname'];
                     $datos['lastname'] 	= $_POST['lastname'];
                     $datos['state']     	= $_POST['state'];
   No newline at end of file
                     $user->setIdValue($iduser);
                     list($result, $message) = $user->UpdateItem($datos);
   No newline at end of file
                     $url = 'index.php?option=com_users&controller=Users&action=dolist';
                     header("location: ".$url);
                     exit();
                 }
   No newline at end of file
                 public function remove(){
                     require 'models/UsersModel.php';
                     $user = new UsersModel();
                     $iduser = $_REQUEST['user'];
   No newline at end of file
                     $data_user['state'] = 3;
   No newline at end of file
                     $user->setIdValue($iduser);
                     //list($result, $message) = $user->DeleteItem();
                     list($result, $message) = $user->UpdateItem($data_user);
   No newline at end of file
                     $url = 'index.php?option=com_users&controller=Users&action=getUsers';
   No newline at end of file
                     header("location: ".$url);
                     exit();
                 }
   No newline at end of file
                 public function searchUser(){
                     require 'models/UsersModel.php';
   No newline at end of file
                     $user = new UsersModel();
                     $username = $_REQUEST['value'];
                     $newuser = $user->searchUserbyUName($username);
                     $usuario = $newuser->fetch();
   No newline at end of file
                     if(!is_array($usuario)){
                             $generatePassword = substr(md5($username.time('YmdHis')),0,5);
                     }
   No newline at end of file
                     $data['username'] = $username;
                     $data['usuario'] = $usuario;
                     @$data['key'] = $generatePassword;
   No newline at end of file
                     $this->view->show("searchUser.php", $data);
                 }
   No newline at end of file
                 public function changePasswd(){
                     require 'components'.DS.'com_users'.DS.'models'.DS.'UsersModel.php';
   No newline at end of file
                     $iduser = $_POST['iduser'];
                     try{
                         if(isset ($_POST['chgPasswd'])){
                             $type_login = $_POST['chgPasswd'];
                             $user = new UsersModel();
   No newline at end of file
                             if($type_login == 4){
   No newline at end of file
                                 $datos['password']  = md5($_POST['passwd']);
                                 $datos['state']     = 1;
                                 $user->setIdValue($iduser);
                                 list($result, $message) = $user->UpdateItem($datos);
   No newline at end of file
                                 $url = 'index.php?option=com_users&controller=Users&action=home';
   No newline at end of file
                                 header("location: ".$url);
                                 exit();
                             }else{
   No newline at end of file
                                 $oldpasswd          = $_POST['oldpasswd'];
                                 $datos['password']  = $_POST['newpasswd'];
                                 $check_password     = $_POST['retypepasswd'];
   No newline at end of file
                                 $result = $user->getPasswd($iduser);
                                 $data_model = $result->fetch();
                                 $db_old_passwd = $data_model[0];
   No newline at end of file
                                 if($db_old_passwd == md5($oldpasswd)){
                                     $user->setIdValue($iduser);
                                     $datos['password'] = md5($datos['password']);
                                     list($result, $message) = $user->UpdateItem($datos);
                                 }
   No newline at end of file
                                 $url = 'index.php?controller=Users&action=editUser&user='.$iduser;
   No newline at end of file
                                 header("location: ".$url);
                                 exit();
                             }
                         }
                     }  catch (Exception $e){
                         var_dump($e->getMessage());
                     }
                 }
   No newline at end of file
                 public function home(){
                     $data['content']        = "components".DS."com_users".DS."views".DS."home.php";
                     $data['title']          = "WELCOME:::::::::::";
   No newline at end of file
                     $this->view->show("template.php", $data);
                 }
             }
   No newline at end of file
             ?>

trunk/administrator/components/com_users/models/UsersModel.php +4 -22

             <?php
             class UsersModel extends ModelBase{
   No newline at end of file
                 public $tableName = 'sis_user';
                 public $id = array('key'=>'iduser','value'=>'');
   No newline at end of file
                 public function addItem($datos){
                     $this->setFieldArray($datos);
                     list($resultado,$id,$mensaje) = $this->insert();
                     return array ($resultado,$id,$mensaje);
                 }
   No newline at end of file
                 public function DeleteItem(){
                     list($resultado,$mensaje) = $this->delete();
                     return array ($resultado,$mensaje);
                 }
   No newline at end of file
                 public function UpdateItem($datos){
                     $this->setFieldArray($datos);
                     list($resultado,$mensaje) = $this->update();
                     return array ($resultado,$mensaje);
                 }
   No newline at end of file
                 public function dolist($datos = array("inicio" => 0, "tamanio" => 5)){
                     $query = "SELECT * FROM sis_user WHERE usertype = 1";
                     $consulta = $this->db->prepare($query);
                     $consulta->execute();
                     $num_filas = $consulta->rowCount();
                     //getPager($datos = array("total" => 0, "inicio" => 0, "pagina" => 5)//uso de la variable arreglo.
                     $parametros = array("total" => $num_filas, "inicio" => $datos['inicio'], "pagina" =>  $datos['tamanio']);
                     list($paginas,$navegador) = $this->getPager($parametros);
   No newline at end of file
                     //realizamos una consulta paginada
                     $consulta = $this->db->prepare($query.' LIMIT '.$datos['inicio'].' , '.$datos['tamanio'].' ');
                     $consulta->execute();
   No newline at end of file
                     return array($consulta,$paginas,$navegador);
                 }
   No newline at end of file
                 public function validarUsuario($username,$password){
                     $str_query = ' SELECT sis_user.* FROM sis_user WHERE username = "'.$username.'"'
                                 .' AND password = "'.md5($password).'" AND (state = "1"  OR state = "4"  OR state = "5") AND usertype = 1 ';
                     $consulta = $this->db->prepare($str_query);
                     $consulta->execute();
   No newline at end of file
                     return $consulta;
                 }
   No newline at end of file
                 public function validarAdmin($username,$password){
                     $str_query = 'SELECT * FROM sis_user WHERE username = "'.$username
                                 .'" AND password = "'.md5($password).'" AND state = "1" AND usertype = 2 ';
                     $consulta = $this->db->prepare($str_query);
                     $consulta->execute();
   No newline at end of file
                     return $consulta;
                 }
   No newline at end of file
                 public function validateUsers($username,$password){
                     $str_query = 'SELECT * FROM '.$this->tableName.' WHERE username = "'.$username
                                 .'" AND password = "'.md5($password).'" AND usertype >= 1 ';
                     $consulta = $this->db->prepare($str_query);
                     $consulta->execute();
   No newline at end of file
                     return $consulta;
                 }
   No newline at end of file
                 public function obtenerUsuarioxId($id){
                     //realizamos la consulta de usuario por id
                     $consulta = $this->db->prepare('SELECT sis_user.* FROM sis_user WHERE iduser = "'.$id.'" ');
                     $consulta->execute();
                     //devolvemos la coleccion para que la vista la presente.
                     return $consulta;
   No newline at end of file
                 }
   No newline at end of file
                 public function obtenerUsuarioxUsername($username){
                     $str_query = 'SELECT * FROM '.$this->tableName.' WHERE username = "'.$username.'" ';
                     $consulta = $this->db->prepare($str_query);
                     $consulta->execute();
                     return $consulta;
                 }
   No newline at end of file
                 public function obtenerUsuarioxUsernameMD5($username){
                     //realizamos la consulta de usuario por id
                     $consulta = $this->db->prepare('SELECT sis_user.* FROM sis_user WHERE MD5(sis_user.username) = "'.$username.'" ');
                     $consulta->execute();
                     //devolvemos la coleccion para que la vista la presente.
                     return $consulta;
                 }
   No newline at end of file
                 public function bloquearUsuario($iduser){
                     //realizamos la consulta de usuario por id
                     $consulta = $this->db->prepare('UPDATE  sis_user SET  state =  "2" WHERE  iduser = '.$iduser.' ');
                     $consulta->execute();
                     //devolvemos la coleccion para que la vista la presente.
                     return $consulta;
                 }
   No newline at end of file
                 public function setUserSession($datos){
                     //realizamos la consulta de usuario por id
                     $consulta = $this->db->prepare(' INSERT INTO  sis_session ( idsession , iduser , client_ip , date_session, date_last_activity, state )  VALUES ( "" ,  "'.$datos['iduser'].'",  "'.$datos['client_ip'].'",  "'.$datos['date_session'].'" ,  "'.$datos['date_last_activity'].'" ,  "'.$datos['state'].'" ) ');
                     $consulta->execute();
                     //devolvemos la coleccion para que la vista la presente.
                     return $consulta;
                 }
   No newline at end of file
                 public function obtenerEstadoUsuario($username){
                     $str_query = 'SELECT * FROM '.$this->tableName.' WHERE username = "'.$username.'"';
                     $consulta = $this->db->prepare($str_query);
                     $consulta->execute();
   No newline at end of file
                     $datauser = $consulta->fetch();
                     $estado = "";
   No newline at end of file
                     if(isset($datauser['state'])){
                         switch($datauser['state']){
                             case 1:
                                     $state = "ACTIVE";
                             break;
                             case 2:
                                     $state = "LOCKED";
                             break;
                             case 3:
                                     $state = "DELETED";
                             break;
                             case 4:
                                     $state = "FLOGIN";
                             break;
                             case 5:
                                     $state = "RESET";
                             break;
                         }
                         return $state;
                     }else{
                         return '';
                     }
                 }
   No newline at end of file
                 public function registrarLogIngreso($id_usu){
                     $consulta = $this->db->prepare(' INSERT INTO log_login ( id_log , id_usu , fec_log ) VALUES ( "" ,  "'.$id_usu.'",  "'.date("Ymd H:i:s", time()).'") ');
                     $consulta->execute();
                     //devolvemos ....
                     return $consulta;
                 }
   No newline at end of file
                 public function obtenerListaUsuariosIngresos($where=""){
                     //realizamos la consulta de todos los items
                     $consulta = $this->db->prepare('SELECT tb_usuarios.* , tb_roles.des_rol AS "rol", count(log_login.id_usu) as "ingresos",
             max(log_login.fec_log) as "ultimo_ingreso" FROM tb_usuarios LEFT JOIN tb_roles ON tb_usuarios.id_rol = tb_roles.id_rol LEFT JOIN log_login ON tb_usuarios.id_usu = log_login.id_usu '.$where.' GROUP BY tb_usuarios.id_usu');
                     $consulta->execute();
                     //devolvemos la coleccion para que la vista la presente.
                     return $consulta;
                 }
   No newline at end of file
                 public function setNewPassword($iduser,$password){
                         //realizamos la consulta de usuario por id
                         $consulta = $this->db->prepare('UPDATE  sis_user SET  password =  "'.md5($password).'" WHERE  iduser = '.$iduser.' ');
                         $consulta->execute();
                         //devolvemos la coleccion para que la vista la presente.
                         return $consulta;
   No newline at end of file
                 }
   No newline at end of file
                 public function setInactive($iduser){
                         //realizamos la consulta de usuario por id
                         $consulta = $this->db->prepare('UPDATE  sis_user SET  state =  "2" WHERE  iduser = '.$iduser.' ');
                         $consulta->execute();
                         //devolvemos la coleccion para que la vista la presente.
                         return $consulta;
   No newline at end of file
                 }
   No newline at end of file
                 public function setActive($iduser){
                         //realizamos la consulta de usuario por id
                         $consulta = $this->db->prepare('UPDATE  sis_user SET  state =  "1" WHERE  iduser = '.$iduser.' ');
                         $consulta->execute();
                         //devolvemos la coleccion para que la vista la presente.
                         return $consulta;
   No newline at end of file
                 }
   No newline at end of file
                 public function getStringUsers(){
                     //realizamos la consulta de todos los items
                     $query = $this->db->prepare('SELECT u.*  FROM sis_user AS u ');
                     $query->execute();
                     //Se recibe el arreglo completo de usuarios.
                     $arregloUsuarios = $query->fetchAll();
                     $j = count($arregloUsuarios);
                     $cadena = '';
                     for($i=0; $j>$i;$i++){
                             $arregloUsuario = $arregloUsuarios[$i];
                             if(($j-1) == $i){
                                     $cadena .= $arregloUsuario['firstname'].' '.$arregloUsuario['lastname'].' [ '.$arregloUsuario['username'].' ]';
                             }else{
                                     $cadena .= $arregloUsuario['firstname'].' '.$arregloUsuario['lastname'].' [ '.$arregloUsuario['username'].' ] , ';
                             }
   No newline at end of file
                     }
   No newline at end of file
                     return $cadena;
                 }
   No newline at end of file
                 public function getStringUser($iduser){
                         //realizamos la consulta de todos los items
                         $query = $this->db->prepare('SELECT u.*  FROM sis_user AS u WHERE u.iduser = "'.$iduser.'" ');
                         $query->execute();
                         //Se recibe el arreglo completo de usuarios.
                         $datosUsuarios = $query->fetch();
                         $cadena = '';
                         $cadena .= $datosUsuarios['firstname'].' '.$datosUsuarios['lastname'].' [ '.$datosUsuarios['username'].' ]';
                         return $cadena;
                 }
                         return $cadena;
  No newline at end of file
                 public function obtenerListaRoles(){
                     //realizamos la consulta de todos los items
                     $consulta = $this->db->prepare('SELECT tb_roles.*  FROM  tb_roles ');
                     $consulta->execute();
                     //devolvemos la coleccion para que la vista la presente.
                     return $consulta;
                 }
                     return $consulta;
  No newline at end of file
                 public function getUsers($datos = array("inicio" => 0, "tamanio" => 5)){
                     //realizamos la consulta de todos los items
                     $query = "SELECT * FROM sis_user WHERE usertype = 1";
                     $consulta = $this->db->prepare($query);
                     $consulta->execute();
                     $num_filas = $consulta->rowCount();
                     //getPager($datos = array("total" => 0, "inicio" => 0, "pagina" => 5)//uso de la variable arreglo.
                     $parametros = array("total" => $num_filas, "inicio" => $datos['inicio'], "pagina" =>  $datos['tamanio']);
                     list($paginas,$navegador) = $this->getPager($parametros);
                     $parametros = array("total" => $num_filas, "inicio" => $datos['inicio'], "pagina" =>  $datos['tamanio']);
  No newline at end of file
                     list($paginas,$navegador) = $this->getPager($parametros);
  No newline at end of file
                     //realizamos una consulta paginada
                     $consulta = $this->db->prepare($query.' LIMIT '.$datos['inicio'].' , '.$datos['tamanio'].' ');
                     $consulta->execute();
                     $consulta = $this->db->prepare($query.' LIMIT '.$datos['inicio'].' , '.$datos['tamanio'].' ');
  No newline at end of file
                     //devolvemos la coleccion para que la vista la presente.
                     return array($consulta,$paginas,$navegador);
                 }
                     return array($consulta,$paginas,$navegador);
  No newline at end of file
                 function editUser($user){
                         $query = "SELECT * FROM sis_user WHERE iduser = '$user'";
              No newline at end of file
-                function addUser($username, $password, $data_user){
              No newline at end of file
-                    $query = "INSERT INTO sis_user( username, password, date_create, firstname, lastname, email,"
              No newline at end of file
-                            ." photo, usertype, state ) VALUES ( '$username' , md5('$password'), '".date("Y-m-d H:i:s")."',"
              No newline at end of file
-                            ." '".$data_user['firstname']."', '".$data_user['lastname']."', '".$data_user['email']."',"
              No newline at end of file
-                            ." '".$data_user['urlphoto']."', 1, 4)";
              No newline at end of file
-                    $result = $this->db->prepare($query);
              No newline at end of file
-                    $result->execute();
              No newline at end of file
-                    return $result;
              No newline at end of file
              No newline at end of file
-  No newline at end of file
                         $result = $this->db->prepare($query);
                         $result->execute();
                         return $result;
                 }
                         return $result;
  No newline at end of file
                 function delUser($user){
                         $query = "UPDATE sis_user SET state = 3 WHERE iduser = $user";
              No newline at end of file
-                function updateUser($user, $firstname, $lastname, $state){
              No newline at end of file
-                        $query = "UPDATE sis_user SET firstname = '$firstname', lastname = '$lastname'"
              No newline at end of file
-                                .", state = $state WHERE iduser = $user";
              No newline at end of file
-                        $result = $this->db->prepare($query);
              No newline at end of file
-                        $result->execute();
              No newline at end of file
-                        return $result;
              No newline at end of file
              No newline at end of file
-  No newline at end of file
                         $result = $this->db->prepare($query);
                         $result->execute();
                         return $result;
                 }
                         return $result;
  No newline at end of file
                 function searchUserbyUName($username){
                     $query = "SELECT * FROM sis_user WHERE username = '$username'";
                     $result = $this->db->prepare($query);
                     $result->execute();
                     return $result;
                 }
                     return $result;
  No newline at end of file
                 public function getPasswd($iduser){
                     $query = "SELECT password FROM sis_user WHERE iduser = $iduser";
                     $result = $this->db->prepare($query);
                     $result->execute();
                     return $result;
                 }
                     return $result;
  No newline at end of file
                 public function getAllUsers(){
                     $str_query = "SELECT * FROM ".$this->tableName." WHERE usertype = 1";
                     $this->setQuery($str_query);
                     $query = $this->loadObjectList();
-                    $query = "SELECT username FROM sis_user WHERE usertype = 1";
+             No newline at end of file
                     return $query;
-                    $result = $this->db->prepare($query);
+             No newline at end of file
              No newline at end of file
-                    $result->execute();
+             No newline at end of file
             }
  No newline at end of file
-                    return $result;
  No newline at end of file
             ?>
             }
  No newline at end of file
             L278: rhodecode diff rendering error

trunk/administrator/components/com_users/views/dolist.php +6 -6

             <?php
                 $html_select_pag = '<select onchange="window.location='.chr(39).'index.php?option=com_users&controller=Users&action=dolist&inicio='.chr(39).'+this.value">';
  No newline at end of file
-                $html_select_pag = '<select onchange="window.location='.chr(39).'index.php?option=com_users&controller=Users&action=getUsers&inicio='.chr(39).'+this.value">';
  No newline at end of file
   No newline at end of file
                 $j = count($paginas);
                 for($i=0;$i<$j;$i++){
                     $html_select_pag .= "<option value='".$paginas[$i]."'";
                     if($inicio == $paginas[$i]){
                         $html_select_pag .= "selected='selected'";
                     }
                     $html_select_pag .= ">";
                     $html_select_pag .= "".($i+1)."/".$j."</option>";
                 }
                 $html_select_pag .= "</select>";
   No newline at end of file
                 $html_pagination  = '<ul class="mnu_pagination">';
                 $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=dolist&inicio='.$navegador["fin"].'">';
  No newline at end of file
-                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=getUsers&inicio='.$navegador["fin"].'">';
  No newline at end of file
                 $html_pagination .= "Last</a></li>";
                 $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=dolist&inicio='.$navegador["siguiente"].'">';
  No newline at end of file
-                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=getUsers&inicio='.$navegador["siguiente"].'">';
  No newline at end of file
                 $html_pagination .= "Next</a></li>";
                 $html_pagination .= '<li class="pages">Page'.$html_select_pag.'</li>';
                 $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=dolist&inicio='.$navegador["anterior"].'">';
  No newline at end of file
-                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=getUsers&inicio='.$navegador["anterior"].'">';
  No newline at end of file
                 $html_pagination .= "Prev</a></li>";
                 $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=dolist&inicio='.$navegador["inicio"].'">';
  No newline at end of file
-                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=getUsers&inicio='.$navegador["inicio"].'">';
  No newline at end of file
                 $html_pagination .= "Start</a></li>";
                 $html_pagination .= '</ul><div style="clear:both"></div>';
             ?>
             <script type="text/javascript">
             $().ready(function() {
                 $(".btn_delUser").click(function(){
                     var _id = $(this).attr("alt");
                     if(confirm("Are you sure to delete this user?")){
                         window.location = "index.php?option=com_users&controller=Users&action=remove&user="+_id;
                     }
                 });
             });
             </script>
             <span class="etiqueta">Users</span>
             <div id="div_info_user">
             <div class="toolbar_right">
             <ul>
                 <li><a href="index.php?option=com_users&controller=Users&action=newUser">Delete</a></li>
                 <li><a href="index.php?option=com_users&controller=Users&action=newUser">Add</a></li>
             </ul>
             </div>
             <div style="clear:both; overflow: hidden"></div>
                 <div class="div_pagination_right">
                 <?php echo $html_pagination; ?>
                 </div>
                 <div style="clear:both; overflow: hidden"></div>
             <div id="content_user" class="content_list">
             <table width="100%" cellpadding="0" cellspacing="0">
             <thead>
             <tr>
                 <th align="center" width="5%">N&deg;</th>
                 <th align="center" width="10%" colspan="2"></th>
                 <th align="center">Username</th>
                 <th align="center">Lastname</th>
                 <th align="center">Firstname</th>
                 <th align="center">State</th>
             </tr>
             </thead>
             <tbody>
             <?php
             $numeracion = 1;
   No newline at end of file
             $num_rows = $listUsers->rowCount();
             //echo SYS_IMAGES.DS.'system'.DS.'b_edit.png';
             if($num_rows > 0){
                 while($datos_usuario = $listUsers->fetch()){
             ?>
             <tr>
                 <td align="center" width="5%"><?php echo ($numeracion+$inicio); ?></td>
                 <td width="5%" align="center">
                     <a href="index.php?option=com_users&controller=Users&action=editUser&user=<?php echo $datos_usuario['iduser']; ?>">
                         <img src="../images/system/b_edit.png" alt="Edit" style="border: 0" />
                     </a>
                 </td>
                 <td width="5%" align="center">
                     <a href="#" class="btn_delUser" alt="<?php echo $datos_usuario['iduser']; ?>">
                         <img src="../images/system/b_drop.png" alt="Delete" style="border: 0" />
                     </a>
                 </td>
                 <td align="center">
                     <a href="index.php?option=com_users&controller=Users&action=view&user=<?php echo $datos_usuario['iduser']; ?>">
                     <?php echo $datos_usuario['username']; ?>
                     </a>
                 </td>
                 <td align="center"><?php echo $datos_usuario['lastname']; ?></td>
                 <td align="center"><?php echo $datos_usuario['firstname']; ?></td>
                 <td align="center">
                     <?php if($datos_usuario['state'] == 1){ ?>
                         <img src="images/system/tick.png" alt="Active" border="0" />
  No newline at end of file
-                        <img src="../imagenes/usractive.jpeg" alt="Active" border="0" />
  No newline at end of file
                     <?php } ?>
                     <?php if($datos_usuario['state'] == 2){ ?>
                         <img src="../imagenes/b_locked.png" alt="Locked" border="0" />
                     <?php } ?>
                     <?php
                         switch($datos_usuario['state']){
                             case 3: echo 'Deleted';
                                     break;
                             case 4: echo 'First Login';
                                     break;
                             case 5: echo 'Reset';
                                     break;
                         }
                     ?>
                 </td>
             </tr>
             <?php
                     $numeracion ++;
                 }
             } else {
             ?>
             <tr><td colspan="7" align="center">Users not found.</td></tr>
             <?php } ?>
             </tbody>
             </table>
             </div>
                 <div class="div_pagination_right">
                 <?php echo $html_pagination; ?>
                 </div>
                 <div style="clear:both; overflow: hidden"></div>
             </div>

General Comments 0

Write
Preview

You need to be logged in to leave comments. Login now

No TODOs yet

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages