Esempio n. 1
0
        echo json_encode($arr);
    } else {
        array_push($arr, 0);
        // retrieve failed
        echo json_encode($arr);
    }
}
// **********************************************************************************
// GET EVENT NAME BY EVENT ID
// **********************************************************************************
if ($_REQUEST['ACTIONS'] == 'GET_EVENT_NAME_BY_ID') {
    $id = $_REQUEST['EVENT_ID'];
    $mysql = new mysql();
    $name = "";
    $result = $mysql->query("SELECT name, startTime\r\n\t\t\t\t\tFROM " . $eventTableName . "\r\n\t\t\t\t\tWHERE id = " . $id . ";");
    if ($mysql->num_rows() > 0) {
        while ($mysql->movenext()) {
            $name = urldecode($mysql->getfield("name"));
            $name = $name . ' (' . urldecode($mysql->getfield("startTime")) . ')';
        }
    }
    if ($result == 0) {
        echo "error_undefinedId";
    } else {
        echo $name;
    }
}
// **********************************************************************************
// CLEAR EVENT NEW USER REMINDER
// **********************************************************************************
if ($_REQUEST['ACTIONS'] == 'CLEAR_EVENT_NEW_USER_REMINDER') {
Esempio n. 2
0
    }
}
//**********************************************************************************
//     SELECT DATA
//**********************************************************************************
if ($_POST['ACTIONS'] == "select") {
    $data = new mysql();
    $sql = "SELECT id,name, price, reserved, status FROM event_tickets";
    if ($_POST['event_id'] != "") {
        $sql = $sql . " where event_id='" . $_POST['event_id'] . "' ";
    }
    $sql = $sql . " ORDER BY id";
    $data->query($sql);
    $i = 0;
    $dataArray = array();
    if ($data->num_rows() > 0) {
        while ($data->movenext()) {
            //$dataArray[$i][] = urldecode($data -> getfield('id'));
            //$dataArray[$i][] = $i+1;
            $dataArray[$i][] = '<span id="title' . urldecode($data->getfield('id')) . '">' . urldecode($data->getfield('name')) . '</span>';
            $dataArray[$i][] = '<span id="price' . urldecode($data->getfield('id')) . '">' . urldecode($data->getfield('price')) . '</span>';
            $dataArray[$i][] = '<span id="reserved' . urldecode($data->getfield('id')) . '">' . urldecode($data->getfield('reserved')) . '</span>';
            $temp = urldecode($data->getfield('status'));
            if ($temp == 'Y') {
                $dataArray[$i][] = '<i class="icon-ok-sign"></i>';
            } else {
                $dataArray[$i][] = '<i class="icon-remove-sign"></i>';
            }
            $dataArray[$i][] = '<button type="button" class="btn btn-default btn-sm" data-toggle="modal" onclick="addTickets(' . urldecode($data->getfield('id')) . ')" data-target="">
				<i class="icon-tag"></i>
				</button>
Esempio n. 3
0
<?
	include "class.mysql.php";
	
	$sql = new mysql;
	
	$sql->connect ( );
	$sql->select_db ( "register" );
	
	$rResult = $sql->query ( "SELECT * FROM genre" );
	if ( $sql->num_rows ( $rResult ) > 0 )
	{
		while ( $genre = $sql->fetch_assoc ( $rResult ) )
		{
			echo $genre['genre'] . "<br>\n";
		}
	}
	
	echo "<br>SQL time: " . $sql->getSqlTime ( );
?>
Esempio n. 4
0
         $this->user->logout();
     }
     $res = $this->user->login($D->email, md5($D->password), $D->rememberme);
 } else {
     $networks = array();
     if ($n = $this->network->find_network_by_email($D->email)) {
         $networks[$n->id] = $n;
     }
     $r = $db1->query('SELECT networks FROM emails_multinetworks WHERE email="' . $db1->e($D->email) . '" LIMIT 1');
     if ($tmp = $db1->fetch_object($r)) {
         $tmp = explode(',', stripslashes($tmp->networks));
         foreach ($tmp as $sdf) {
             if ($sdf = $this->network->find_network_by_id($sdf)) {
                 $ndb = new mysql($sdf->db_host, $sdf->db_user, $sdf->db_pass, $sdf->db_name);
                 $ndb->query('SELECT id FROM users WHERE email="' . $ndb->e($D->email) . '" LIMIT 1');
                 if ($ndb->num_rows() > 0) {
                     $networks[$sdf->id] = $sdf;
                 }
             }
         }
     }
     if (0 == count($networks)) {
         $res = FALSE;
     } elseif (1 == count($networks)) {
         $this->network->LOAD_by_id(key($networks));
         $this->user = new user();
         $this->user->LOAD();
         if ($this->user->is_logged) {
             $this->user->logout();
         }
         $res = $this->user->login($D->email, md5($D->password), $D->rememberme);
Esempio n. 5
0
function editarcatalogo()
{
    include "conf.php";
    include "functions.php";
    include "include/mysql.class.php";
    $id_usuario = @$_GET["id"];
    $t_usuario = tipo_usuario($id_usuario);
    $db = new mysql($db_host, $db_name, $db_user, $db_password);
    $db->connect();
    $qsql = "select * from usuarios where id_usuario='{$id_usuario}'";
    $db->query($qsql);
    if ($db->num_rows() > 0) {
        while ($row = $db->fetch_assoc()) {
            $nombre = $row['nombre'];
            $a_paterno = $row['a_paterno'];
            $a_materno = $row['a_materno'];
            $rfc = $row['rfc'];
            $direccion = $row['direccion'];
            $ciudad = $row['ciudad'];
            $estado = $row['estado'];
            $cp = $row['cp'];
            $direccion_fact = $row['direccion_fact'];
            $ciudad_fact = $row['ciudad_fact'];
            $estado_fact = $row['estado_fact'];
            $cp_fact = $row['cp_fact'];
            $telefono = $row['telefono'];
            $telefono2 = $row['telefono2'];
            $email = $row['email'];
            $email2 = $row['email2'];
        }
    }
    ?>
	<title>Edicion de Perfiles de Usuario</title>
	<h1>Edicion de Perfiles de Usuario</h1><hr>
	<form method="post" action="usuarios.php">
		<table width="200" border="0"                                                                                                                                                                                                            >
			<input name="catalogo" type="hidden" size="33" maxlength="84" value="1" />		 
			<input name="id_usuario" type="hidden" size="33" maxlength="84" value="<?php 
    echo $id_usuario;
    ?>
" />		 
		 <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Nombre</font></div></td>
			<td><input name="nombre" type="text" size="33" maxlength="84" value="<?php 
    echo $nombre;
    ?>
" /></td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Apellido Paterno</font></div></td>
			<td><input name="apaterno" type="text" size="33" maxlength="84" value="<?php 
    echo $a_paterno;
    ?>
" /></td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Apellido Materno</font></div></td>
			<td><input name="amaterno" type="text" size="33" maxlength="84" value="<?php 
    echo $a_materno;
    ?>
" /></td>
		  </tr>		
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Direccion</font></div></td>
			<td><textarea name="direccion" id="direccion" cols="25" rows="3" ><?php 
    echo $direccion;
    ?>
</textarea></td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Ciudad</font></div></td>
			<td><input name="ciudad" type="text" size="33" maxlength="84" value="<?php 
    echo $ciudad;
    ?>
" /></td>
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Estado</font></div></td>
			<td>
				<select name="estado" style="width:225px">
					<OPTGROUP LABEL="Seleccione un Estado" selected>
					<option value="Aguascalientes"<?php 
    if ($estado == "Aguascalientes") {
        echo "SELECTED";
    }
    ?>
>Aguascalientes</option>
					<option value="Baja California"<?php 
    if ($estado == "Baja California") {
        echo "SELECTED";
    }
    ?>
>Baja California</option>
					<option value="Baja California Sur"<?php 
    if ($estado == "Baja California Sur") {
        echo "SELECTED";
    }
    ?>
>Baja California Sur</option>
					<option value="Campeche"<?php 
    if ($estado == "Campeche") {
        echo "SELECTED";
    }
    ?>
>Campeche</option>
					<option value="Coahuila"<?php 
    if ($estado == "Coahuila") {
        echo "SELECTED";
    }
    ?>
>Coahuila</option>
					<option value="Colima"<?php 
    if ($estado == "Colima") {
        echo "SELECTED";
    }
    ?>
>Colima</option>
					<option value="Chiapas"<?php 
    if ($estado == "Chiapas") {
        echo "SELECTED";
    }
    ?>
>Chiapas</option>
					<option value="Chihuahua"<?php 
    if ($estado == "Chihuahua") {
        echo "SELECTED";
    }
    ?>
>Chihuahua</option>
					<option value="Distrito Federal"<?php 
    if ($estado == "Distrito Federal") {
        echo "SELECTED";
    }
    ?>
>Distrito Federal</option>
					<option value="Durango"<?php 
    if ($estado == "Durango") {
        echo "SELECTED";
    }
    ?>
>Durango</option>
					<option value="Estado de México"<?php 
    if ($estado == "Estado de México") {
        echo "SELECTED";
    }
    ?>
>Estado de México</option>
					<option value="Guanajuato"<?php 
    if ($estado == "Guanajuato") {
        echo "SELECTED";
    }
    ?>
>Guanajuato</option>
					<option value="Guerrero"<?php 
    if ($estado == "Guerrero") {
        echo "SELECTED";
    }
    ?>
>Guerrero</option>
					<option value="Hidalgo"<?php 
    if ($estado == "Hidalgo") {
        echo "SELECTED";
    }
    ?>
>Hidalgo</option>
					<option value="Jalisco"<?php 
    if ($estado == "Jalisco") {
        echo "SELECTED";
    }
    ?>
>Jalisco</option>
					<option value="Michoacán"<?php 
    if ($estado == "Michoacán") {
        echo "SELECTED";
    }
    ?>
>Michoacán</option>
					<option value="Morelos"<?php 
    if ($estado == "Morelos") {
        echo "SELECTED";
    }
    ?>
>Morelos</option>
					<option value="Nayarit"<?php 
    if ($estado == "Nayarit") {
        echo "SELECTED";
    }
    ?>
>Nayarit</option>
					<option value="Nuevo León"<?php 
    if ($estado == "Nuevo León") {
        echo "SELECTED";
    }
    ?>
>Nuevo León</option>
					<option value="Oaxaca"<?php 
    if ($estado == "Oaxaca") {
        echo "SELECTED";
    }
    ?>
>Oaxaca</option>
					<option value="Puebla"<?php 
    if ($estado == "Puebla") {
        echo "SELECTED";
    }
    ?>
>Puebla</option>
					<option value="Querétaro"<?php 
    if ($estado == "Querétaro") {
        echo "SELECTED";
    }
    ?>
>Querétaro</option>
					<option value="Quintana Roo"<?php 
    if ($estado == "Quintana Roo") {
        echo "SELECTED";
    }
    ?>
>Quintana Roo</option>
					<option value="San Luis Potosí"<?php 
    if ($estado == "San Luis Potosí") {
        echo "SELECTED";
    }
    ?>
>San Luis Potosí</option>
					<option value="Sinaloa"<?php 
    if ($estado == "Sinaloa") {
        echo "SELECTED";
    }
    ?>
>Sinaloa</option>
					<option value="Sonora"<?php 
    if ($estado == "Sonora") {
        echo "SELECTED";
    }
    ?>
>Sonora</option>
					<option value="Tabasco"<?php 
    if ($estado == "Tabasco") {
        echo "SELECTED";
    }
    ?>
>Tabasco</option>
					<option value="Tamaulipas"<?php 
    if ($estado == "Tamaulipas") {
        echo "SELECTED";
    }
    ?>
>Tamaulipas</option>
					<option value="Tlaxcala"<?php 
    if ($estado == "Tlaxcala") {
        echo "SELECTED";
    }
    ?>
>Tlaxcala</option>
					<option value="Veracruz"<?php 
    if ($estado == "Veracruz") {
        echo "SELECTED";
    }
    ?>
>Veracruz</option>
					<option value="Yucatán"<?php 
    if ($estado == "Yucatán") {
        echo "SELECTED";
    }
    ?>
>Yucatán</option>
					<option value="Zacatecas"<?php 
    if ($estado == "Zacatecas") {
        echo "SELECTED";
    }
    ?>
>Zacatecas</option>
				</select>
			</td>
		  </tr>		
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Codigo Postal</font></div></td>
			<td><input name="cp" type="text" size="33" maxlength="84" value="<?php 
    echo $cp;
    ?>
" /></td>
		  </tr>			  
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Correo Electronico </font></div></td>
			<td><input name="email" type="text" size="33" maxlength="84" value="<?php 
    echo $email;
    ?>
" /></td>
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Correo Alternativo </font></div></td>
			<td><input name="email2" type="text" size="33" maxlength="84" value="<?php 
    echo $email2;
    ?>
" /></td>		
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Telefono 1</font></div></td>
			<td><input name="telefono" type="text" size="33" maxlength="84" value="<?php 
    echo $telefono;
    ?>
" /></td>
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Telefono 2</font></div></td>
			<td><input name="telefono2" type="text" size="33" maxlength="84" value="<?php 
    echo $telefono2;
    ?>
" /></td>		
		  </tr>	
			<?php 
    if ($t_usuario == 2) {
        ?>
		<tr>
			<td colspan=2><div align="center"><font  face="Verdana, Arial, Helvetica, sans-serif" size="3">Datos de Facturacion</font></div></td>
		</tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Direccion</font></div></td>
			<td><textarea name="direccion_fact" id="direccion" cols="25" rows="3" ><?php 
        echo $direccion_fact;
        ?>
</textarea></td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Ciudad</font></div></td>
			<td><input name="ciudad_fact" type="text" size="33" maxlength="84" value="<?php 
        echo $ciudad_fact;
        ?>
" /></td>
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Estado</font></div></td>
			<td>
				<select name="estado_fact" style="width:225px">
					<OPTGROUP LABEL="Seleccione un Estado" selected>
					<option value="Aguascalientes"<?php 
        if ($estado_fact == "Aguascalientes") {
            echo "SELECTED";
        }
        ?>
>Aguascalientes</option>
					<option value="Baja California"<?php 
        if ($estado_fact == "Baja California") {
            echo "SELECTED";
        }
        ?>
>Baja California</option>
					<option value="Baja California Sur"<?php 
        if ($estado_fact == "Baja California Sur") {
            echo "SELECTED";
        }
        ?>
>Baja California Sur</option>
					<option value="Campeche"<?php 
        if ($estado_fact == "Campeche") {
            echo "SELECTED";
        }
        ?>
>Campeche</option>
					<option value="Coahuila"<?php 
        if ($estado_fact == "Coahuila") {
            echo "SELECTED";
        }
        ?>
>Coahuila</option>
					<option value="Colima"<?php 
        if ($estado_fact == "Colima") {
            echo "SELECTED";
        }
        ?>
>Colima</option>
					<option value="Chiapas"<?php 
        if ($estado_fact == "Chiapas") {
            echo "SELECTED";
        }
        ?>
>Chiapas</option>
					<option value="Chihuahua"<?php 
        if ($estado_fact == "Chihuahua") {
            echo "SELECTED";
        }
        ?>
>Chihuahua</option>
					<option value="Distrito Federal"<?php 
        if ($estado_fact == "Distrito Federal") {
            echo "SELECTED";
        }
        ?>
>Distrito Federal</option>
					<option value="Durango"<?php 
        if ($estado_fact == "Durango") {
            echo "SELECTED";
        }
        ?>
>Durango</option>
					<option value="Estado de México"<?php 
        if ($estado_fact == "Estado de México") {
            echo "SELECTED";
        }
        ?>
>Estado de México</option>
					<option value="Guanajuato"<?php 
        if ($estado_fact == "Guanajuato") {
            echo "SELECTED";
        }
        ?>
>Guanajuato</option>
					<option value="Guerrero"<?php 
        if ($estado_fact == "Guerrero") {
            echo "SELECTED";
        }
        ?>
>Guerrero</option>
					<option value="Hidalgo"<?php 
        if ($estado_fact == "Hidalgo") {
            echo "SELECTED";
        }
        ?>
>Hidalgo</option>
					<option value="Jalisco"<?php 
        if ($estado_fact == "Jalisco") {
            echo "SELECTED";
        }
        ?>
>Jalisco</option>
					<option value="Michoacán"<?php 
        if ($estado_fact == "Michoacán") {
            echo "SELECTED";
        }
        ?>
>Michoacán</option>
					<option value="Morelos"<?php 
        if ($estado_fact == "Morelos") {
            echo "SELECTED";
        }
        ?>
>Morelos</option>
					<option value="Nayarit"<?php 
        if ($estado_fact == "Nayarit") {
            echo "SELECTED";
        }
        ?>
>Nayarit</option>
					<option value="Nuevo León"<?php 
        if ($estado_fact == "Nuevo León") {
            echo "SELECTED";
        }
        ?>
>Nuevo León</option>
					<option value="Oaxaca"<?php 
        if ($estado_fact == "Oaxaca") {
            echo "SELECTED";
        }
        ?>
>Oaxaca</option>
					<option value="Puebla"<?php 
        if ($estado_fact == "Puebla") {
            echo "SELECTED";
        }
        ?>
>Puebla</option>
					<option value="Querétaro"<?php 
        if ($estado_fact == "Querétaro") {
            echo "SELECTED";
        }
        ?>
>Querétaro</option>
					<option value="Quintana Roo"<?php 
        if ($estado_fact == "Quintana Roo") {
            echo "SELECTED";
        }
        ?>
>Quintana Roo</option>
					<option value="San Luis Potosí"<?php 
        if ($estado_fact == "San Luis Potosí") {
            echo "SELECTED";
        }
        ?>
>San Luis Potosí</option>
					<option value="Sinaloa"<?php 
        if ($estado_fact == "Sinaloa") {
            echo "SELECTED";
        }
        ?>
>Sinaloa</option>
					<option value="Sonora"<?php 
        if ($estado_fact == "Sonora") {
            echo "SELECTED";
        }
        ?>
>Sonora</option>
					<option value="Tabasco"<?php 
        if ($estado_fact == "Tabasco") {
            echo "SELECTED";
        }
        ?>
>Tabasco</option>
					<option value="Tamaulipas"<?php 
        if ($estado_fact == "Tamaulipas") {
            echo "SELECTED";
        }
        ?>
>Tamaulipas</option>
					<option value="Tlaxcala"<?php 
        if ($estado_fact == "Tlaxcala") {
            echo "SELECTED";
        }
        ?>
>Tlaxcala</option>
					<option value="Veracruz"<?php 
        if ($estado_fact == "Veracruz") {
            echo "SELECTED";
        }
        ?>
>Veracruz</option>
					<option value="Yucatán"<?php 
        if ($estado_fact == "Yucatán") {
            echo "SELECTED";
        }
        ?>
>Yucatán</option>
					<option value="Zacatecas"<?php 
        if ($estado_fact == "Zacatecas") {
            echo "SELECTED";
        }
        ?>
>Zacatecas</option>
				</select>
			</td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Codigo Postal</font></div></td>
			<td><input name="cp_fact" type="text" size="33" maxlength="84" value="<?php 
        echo $cp_fact;
        ?>
" /></td>
		  </tr>	
		  <tr>
				<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">RFC</font></div></td>
				<td><input name="rfc" type="text" size="33" maxlength="84" value="<?php 
        echo $rfc;
        ?>
" /></td>
			</tr>
			<?php 
    }
    ?>
		  
		  <tr>
			<td><div align="right"><input name="save" type="submit" value="Grabar" /></div></td>
			<td><div align="left"><input type="button" name="cancel" value="Cancelar" onclick="javascript:window.location.href='usuarios.php?a=viewcat&id=<?php 
    echo $id_usuario;
    ?>
'"></div></td>		
		  </tr>
		</table>
	</form>
<?php 
}
Esempio n. 6
0
File: model.php Progetto: pnixx/boot
 /**
  * Чтение кол-ва записай в запросе
  * @return integer
  */
 public function num_rows()
 {
     return $this->_db->num_rows();
 }
Esempio n. 7
0
function editarcatalogo()
{
    include "conf.php";
    include "functions.php";
    include "include/mysql.class.php";
    $Vx45bjsvssal_usuario = @$_GET["id"];
    $Vux3chut224d = tipo_usuario($Vx45bjsvssal_usuario);
    $Viflpsygq44k = new mysql($Viflpsygq44k_host, $Viflpsygq44k_name, $Viflpsygq44k_user, $Viflpsygq44k_password);
    $Viflpsygq44k->connect();
    $Va2nkkdhy450 = "select * from usuarios where id_usuario='{$Vx45bjsvssal_usuario}'";
    $Viflpsygq44k->query($Va2nkkdhy450);
    if ($Viflpsygq44k->num_rows() > 0) {
        while ($V3q35cfpll3z = $Viflpsygq44k->fetch_assoc()) {
            $V1rzlqut2pvl = $V3q35cfpll3z['nombre'];
            $Vfgynz23hmzn_paterno = $V3q35cfpll3z['a_paterno'];
            $Vfgynz23hmzn_materno = $V3q35cfpll3z['a_materno'];
            $Vuoiiu2iihgi = $V3q35cfpll3z['rfc'];
            $Vyya5snsrwss = $V3q35cfpll3z['direccion'];
            $Vdn1ax1ihd13 = $V3q35cfpll3z['ciudad'];
            $Vtfkauq20pz4 = $V3q35cfpll3z['estado'];
            $Vtvszbqxer54 = $V3q35cfpll3z['cp'];
            $Vyya5snsrwss_fact = $V3q35cfpll3z['direccion_fact'];
            $Vdn1ax1ihd13_fact = $V3q35cfpll3z['ciudad_fact'];
            $Vtfkauq20pz4_fact = $V3q35cfpll3z['estado_fact'];
            $Vtvszbqxer54_fact = $V3q35cfpll3z['cp_fact'];
            $Vn42o5h4dv3c = $V3q35cfpll3z['telefono'];
            $Vn42o5h4dv3c2 = $V3q35cfpll3z['telefono2'];
            $Vo5fxmz1l2n2 = $V3q35cfpll3z['email'];
            $Vo5fxmz1l2n22 = $V3q35cfpll3z['email2'];
        }
    }
    ?>
	<title>Edicion de Perfiles de Usuario</title>
	<h1>Edicion de Perfiles de Usuario</h1><hr>
	<form method="post" action="usuarios.php">
		<table width="200" border="0"                                                                                                                                                                                                            >
			<input name="catalogo" type="hidden" size="33" maxlength="84" value="1" />		 
			<input name="id_usuario" type="hidden" size="33" maxlength="84" value="<?php 
    echo $Vx45bjsvssal_usuario;
    ?>
" />		 
		 <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Nombre</font></div></td>
			<td><input name="nombre" type="text" size="33" maxlength="84" value="<?php 
    echo $V1rzlqut2pvl;
    ?>
" /></td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Apellido Paterno</font></div></td>
			<td><input name="apaterno" type="text" size="33" maxlength="84" value="<?php 
    echo $Vfgynz23hmzn_paterno;
    ?>
" /></td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Apellido Materno</font></div></td>
			<td><input name="amaterno" type="text" size="33" maxlength="84" value="<?php 
    echo $Vfgynz23hmzn_materno;
    ?>
" /></td>
		  </tr>		
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Direccion</font></div></td>
			<td><textarea name="direccion" id="direccion" cols="25" rows="3" ><?php 
    echo $Vyya5snsrwss;
    ?>
</textarea></td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Ciudad</font></div></td>
			<td><input name="ciudad" type="text" size="33" maxlength="84" value="<?php 
    echo $Vdn1ax1ihd13;
    ?>
" /></td>
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Estado</font></div></td>
			<td>
				<select name="estado" style="width:225px">
					<OPTGROUP LABEL="Seleccione un Estado" selected>
					<option value="Aguascalientes"<?php 
    if ($Vtfkauq20pz4 == "Aguascalientes") {
        echo "SELECTED";
    }
    ?>
>Aguascalientes</option>
					<option value="Baja California"<?php 
    if ($Vtfkauq20pz4 == "Baja California") {
        echo "SELECTED";
    }
    ?>
>Baja California</option>
					<option value="Baja California Sur"<?php 
    if ($Vtfkauq20pz4 == "Baja California Sur") {
        echo "SELECTED";
    }
    ?>
>Baja California Sur</option>
					<option value="Campeche"<?php 
    if ($Vtfkauq20pz4 == "Campeche") {
        echo "SELECTED";
    }
    ?>
>Campeche</option>
					<option value="Coahuila"<?php 
    if ($Vtfkauq20pz4 == "Coahuila") {
        echo "SELECTED";
    }
    ?>
>Coahuila</option>
					<option value="Colima"<?php 
    if ($Vtfkauq20pz4 == "Colima") {
        echo "SELECTED";
    }
    ?>
>Colima</option>
					<option value="Chiapas"<?php 
    if ($Vtfkauq20pz4 == "Chiapas") {
        echo "SELECTED";
    }
    ?>
>Chiapas</option>
					<option value="Chihuahua"<?php 
    if ($Vtfkauq20pz4 == "Chihuahua") {
        echo "SELECTED";
    }
    ?>
>Chihuahua</option>
					<option value="Distrito Federal"<?php 
    if ($Vtfkauq20pz4 == "Distrito Federal") {
        echo "SELECTED";
    }
    ?>
>Distrito Federal</option>
					<option value="Durango"<?php 
    if ($Vtfkauq20pz4 == "Durango") {
        echo "SELECTED";
    }
    ?>
>Durango</option>
					<option value="Estado de M�xico"<?php 
    if ($Vtfkauq20pz4 == "Estado de M�xico") {
        echo "SELECTED";
    }
    ?>
>Estado de M�xico</option>
					<option value="Guanajuato"<?php 
    if ($Vtfkauq20pz4 == "Guanajuato") {
        echo "SELECTED";
    }
    ?>
>Guanajuato</option>
					<option value="Guerrero"<?php 
    if ($Vtfkauq20pz4 == "Guerrero") {
        echo "SELECTED";
    }
    ?>
>Guerrero</option>
					<option value="Hidalgo"<?php 
    if ($Vtfkauq20pz4 == "Hidalgo") {
        echo "SELECTED";
    }
    ?>
>Hidalgo</option>
					<option value="Jalisco"<?php 
    if ($Vtfkauq20pz4 == "Jalisco") {
        echo "SELECTED";
    }
    ?>
>Jalisco</option>
					<option value="Michoac�n"<?php 
    if ($Vtfkauq20pz4 == "Michoac�n") {
        echo "SELECTED";
    }
    ?>
>Michoac�n</option>
					<option value="Morelos"<?php 
    if ($Vtfkauq20pz4 == "Morelos") {
        echo "SELECTED";
    }
    ?>
>Morelos</option>
					<option value="Nayarit"<?php 
    if ($Vtfkauq20pz4 == "Nayarit") {
        echo "SELECTED";
    }
    ?>
>Nayarit</option>
					<option value="Nuevo Le�n"<?php 
    if ($Vtfkauq20pz4 == "Nuevo Le�n") {
        echo "SELECTED";
    }
    ?>
>Nuevo Le�n</option>
					<option value="Oaxaca"<?php 
    if ($Vtfkauq20pz4 == "Oaxaca") {
        echo "SELECTED";
    }
    ?>
>Oaxaca</option>
					<option value="Puebla"<?php 
    if ($Vtfkauq20pz4 == "Puebla") {
        echo "SELECTED";
    }
    ?>
>Puebla</option>
					<option value="Quer�taro"<?php 
    if ($Vtfkauq20pz4 == "Quer�taro") {
        echo "SELECTED";
    }
    ?>
>Quer�taro</option>
					<option value="Quintana Roo"<?php 
    if ($Vtfkauq20pz4 == "Quintana Roo") {
        echo "SELECTED";
    }
    ?>
>Quintana Roo</option>
					<option value="San Luis Potos�"<?php 
    if ($Vtfkauq20pz4 == "San Luis Potos�") {
        echo "SELECTED";
    }
    ?>
>San Luis Potos�</option>
					<option value="Sinaloa"<?php 
    if ($Vtfkauq20pz4 == "Sinaloa") {
        echo "SELECTED";
    }
    ?>
>Sinaloa</option>
					<option value="Sonora"<?php 
    if ($Vtfkauq20pz4 == "Sonora") {
        echo "SELECTED";
    }
    ?>
>Sonora</option>
					<option value="Tabasco"<?php 
    if ($Vtfkauq20pz4 == "Tabasco") {
        echo "SELECTED";
    }
    ?>
>Tabasco</option>
					<option value="Tamaulipas"<?php 
    if ($Vtfkauq20pz4 == "Tamaulipas") {
        echo "SELECTED";
    }
    ?>
>Tamaulipas</option>
					<option value="Tlaxcala"<?php 
    if ($Vtfkauq20pz4 == "Tlaxcala") {
        echo "SELECTED";
    }
    ?>
>Tlaxcala</option>
					<option value="Veracruz"<?php 
    if ($Vtfkauq20pz4 == "Veracruz") {
        echo "SELECTED";
    }
    ?>
>Veracruz</option>
					<option value="Yucat�n"<?php 
    if ($Vtfkauq20pz4 == "Yucat�n") {
        echo "SELECTED";
    }
    ?>
>Yucat�n</option>
					<option value="Zacatecas"<?php 
    if ($Vtfkauq20pz4 == "Zacatecas") {
        echo "SELECTED";
    }
    ?>
>Zacatecas</option>
				</select>
			</td>
		  </tr>		
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Codigo Postal</font></div></td>
			<td><input name="cp" type="text" size="33" maxlength="84" value="<?php 
    echo $Vtvszbqxer54;
    ?>
" /></td>
		  </tr>			  
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Correo Electronico </font></div></td>
			<td><input name="email" type="text" size="33" maxlength="84" value="<?php 
    echo $Vo5fxmz1l2n2;
    ?>
" /></td>
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Correo Alternativo </font></div></td>
			<td><input name="email2" type="text" size="33" maxlength="84" value="<?php 
    echo $Vo5fxmz1l2n22;
    ?>
" /></td>		
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Telefono 1</font></div></td>
			<td><input name="telefono" type="text" size="33" maxlength="84" value="<?php 
    echo $Vn42o5h4dv3c;
    ?>
" /></td>
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Telefono 2</font></div></td>
			<td><input name="telefono2" type="text" size="33" maxlength="84" value="<?php 
    echo $Vn42o5h4dv3c2;
    ?>
" /></td>		
		  </tr>	
			<?php 
    if ($Vux3chut224d == 2) {
        ?>
		<tr>
			<td colspan=2><div align="center"><font  face="Verdana, Arial, Helvetica, sans-serif" size="3">Datos de Facturacion</font></div></td>
		</tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Direccion</font></div></td>
			<td><textarea name="direccion_fact" id="direccion" cols="25" rows="3" ><?php 
        echo $Vyya5snsrwss_fact;
        ?>
</textarea></td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Ciudad</font></div></td>
			<td><input name="ciudad_fact" type="text" size="33" maxlength="84" value="<?php 
        echo $Vdn1ax1ihd13_fact;
        ?>
" /></td>
		  </tr>	
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Estado</font></div></td>
			<td>
				<select name="estado_fact" style="width:225px">
					<OPTGROUP LABEL="Seleccione un Estado" selected>
					<option value="Aguascalientes"<?php 
        if ($Vtfkauq20pz4_fact == "Aguascalientes") {
            echo "SELECTED";
        }
        ?>
>Aguascalientes</option>
					<option value="Baja California"<?php 
        if ($Vtfkauq20pz4_fact == "Baja California") {
            echo "SELECTED";
        }
        ?>
>Baja California</option>
					<option value="Baja California Sur"<?php 
        if ($Vtfkauq20pz4_fact == "Baja California Sur") {
            echo "SELECTED";
        }
        ?>
>Baja California Sur</option>
					<option value="Campeche"<?php 
        if ($Vtfkauq20pz4_fact == "Campeche") {
            echo "SELECTED";
        }
        ?>
>Campeche</option>
					<option value="Coahuila"<?php 
        if ($Vtfkauq20pz4_fact == "Coahuila") {
            echo "SELECTED";
        }
        ?>
>Coahuila</option>
					<option value="Colima"<?php 
        if ($Vtfkauq20pz4_fact == "Colima") {
            echo "SELECTED";
        }
        ?>
>Colima</option>
					<option value="Chiapas"<?php 
        if ($Vtfkauq20pz4_fact == "Chiapas") {
            echo "SELECTED";
        }
        ?>
>Chiapas</option>
					<option value="Chihuahua"<?php 
        if ($Vtfkauq20pz4_fact == "Chihuahua") {
            echo "SELECTED";
        }
        ?>
>Chihuahua</option>
					<option value="Distrito Federal"<?php 
        if ($Vtfkauq20pz4_fact == "Distrito Federal") {
            echo "SELECTED";
        }
        ?>
>Distrito Federal</option>
					<option value="Durango"<?php 
        if ($Vtfkauq20pz4_fact == "Durango") {
            echo "SELECTED";
        }
        ?>
>Durango</option>
					<option value="Estado de M�xico"<?php 
        if ($Vtfkauq20pz4_fact == "Estado de M�xico") {
            echo "SELECTED";
        }
        ?>
>Estado de M�xico</option>
					<option value="Guanajuato"<?php 
        if ($Vtfkauq20pz4_fact == "Guanajuato") {
            echo "SELECTED";
        }
        ?>
>Guanajuato</option>
					<option value="Guerrero"<?php 
        if ($Vtfkauq20pz4_fact == "Guerrero") {
            echo "SELECTED";
        }
        ?>
>Guerrero</option>
					<option value="Hidalgo"<?php 
        if ($Vtfkauq20pz4_fact == "Hidalgo") {
            echo "SELECTED";
        }
        ?>
>Hidalgo</option>
					<option value="Jalisco"<?php 
        if ($Vtfkauq20pz4_fact == "Jalisco") {
            echo "SELECTED";
        }
        ?>
>Jalisco</option>
					<option value="Michoac�n"<?php 
        if ($Vtfkauq20pz4_fact == "Michoac�n") {
            echo "SELECTED";
        }
        ?>
>Michoac�n</option>
					<option value="Morelos"<?php 
        if ($Vtfkauq20pz4_fact == "Morelos") {
            echo "SELECTED";
        }
        ?>
>Morelos</option>
					<option value="Nayarit"<?php 
        if ($Vtfkauq20pz4_fact == "Nayarit") {
            echo "SELECTED";
        }
        ?>
>Nayarit</option>
					<option value="Nuevo Le�n"<?php 
        if ($Vtfkauq20pz4_fact == "Nuevo Le�n") {
            echo "SELECTED";
        }
        ?>
>Nuevo Le�n</option>
					<option value="Oaxaca"<?php 
        if ($Vtfkauq20pz4_fact == "Oaxaca") {
            echo "SELECTED";
        }
        ?>
>Oaxaca</option>
					<option value="Puebla"<?php 
        if ($Vtfkauq20pz4_fact == "Puebla") {
            echo "SELECTED";
        }
        ?>
>Puebla</option>
					<option value="Quer�taro"<?php 
        if ($Vtfkauq20pz4_fact == "Quer�taro") {
            echo "SELECTED";
        }
        ?>
>Quer�taro</option>
					<option value="Quintana Roo"<?php 
        if ($Vtfkauq20pz4_fact == "Quintana Roo") {
            echo "SELECTED";
        }
        ?>
>Quintana Roo</option>
					<option value="San Luis Potos�"<?php 
        if ($Vtfkauq20pz4_fact == "San Luis Potos�") {
            echo "SELECTED";
        }
        ?>
>San Luis Potos�</option>
					<option value="Sinaloa"<?php 
        if ($Vtfkauq20pz4_fact == "Sinaloa") {
            echo "SELECTED";
        }
        ?>
>Sinaloa</option>
					<option value="Sonora"<?php 
        if ($Vtfkauq20pz4_fact == "Sonora") {
            echo "SELECTED";
        }
        ?>
>Sonora</option>
					<option value="Tabasco"<?php 
        if ($Vtfkauq20pz4_fact == "Tabasco") {
            echo "SELECTED";
        }
        ?>
>Tabasco</option>
					<option value="Tamaulipas"<?php 
        if ($Vtfkauq20pz4_fact == "Tamaulipas") {
            echo "SELECTED";
        }
        ?>
>Tamaulipas</option>
					<option value="Tlaxcala"<?php 
        if ($Vtfkauq20pz4_fact == "Tlaxcala") {
            echo "SELECTED";
        }
        ?>
>Tlaxcala</option>
					<option value="Veracruz"<?php 
        if ($Vtfkauq20pz4_fact == "Veracruz") {
            echo "SELECTED";
        }
        ?>
>Veracruz</option>
					<option value="Yucat�n"<?php 
        if ($Vtfkauq20pz4_fact == "Yucat�n") {
            echo "SELECTED";
        }
        ?>
>Yucat�n</option>
					<option value="Zacatecas"<?php 
        if ($Vtfkauq20pz4_fact == "Zacatecas") {
            echo "SELECTED";
        }
        ?>
>Zacatecas</option>
				</select>
			</td>
		  </tr>
		  <tr>
			<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">Codigo Postal</font></div></td>
			<td><input name="cp_fact" type="text" size="33" maxlength="84" value="<?php 
        echo $Vtvszbqxer54_fact;
        ?>
" /></td>
		  </tr>	
		  <tr>
				<td><div align="right"><font  face="Verdana, Arial, Helvetica, sans-serif" size="2">RFC</font></div></td>
				<td><input name="rfc" type="text" size="33" maxlength="84" value="<?php 
        echo $Vuoiiu2iihgi;
        ?>
" /></td>
			</tr>
			<?php 
    }
    ?>
		  
		  <tr>
			<td><div align="right"><input name="save" type="submit" value="Grabar" /></div></td>
			<td><div align="left"><input type="button" name="cancel" value="Cancelar" onclick="javascript:window.location.href='usuarios.php?a=viewcat&id=<?php 
    echo $Vx45bjsvssal_usuario;
    ?>
'"></div></td>		
		  </tr>
		</table>
	</form>
<?php 
}