<?php
sleep(2);
include_once '../../model/csConexion.php';
$con = new csConexion();
if ($_REQUEST) {
$username = $_REQUEST['username'];
$query = "select*from users where username='******'";
$con->connect();
$result = $con->execute($query);
$con->disconnect();
if (mysql_num_rows($result) > 0) {
echo '<script src="view/js/classie.js"></script>
<script src="view/js/notificationFx.js"></script>';
echo "<script>";
echo "(function(){\r\n\t\t\t\tvar txt = document.getElementById( 'txtusuario1' );\r\n\t\t\t\tvar btn= document.getElementById('btnlogin');\r\n\t\t\t\t\$(document).ready(function(){\r\n\t\t\t\t\tclassie.add( txt, 'active' );\r\n\t\t\t\t\t\tsetTimeout( function() {";
echo "classie.remove( txt, 'active' );";
echo "var notification = new NotificationFx({";
echo "message: '";
echo '<div class="ns-thumb"><img src="view/styles/images/alert.png"/></div><div class="ns-content"><p>El nombre de usuario no está disponible, elija otro nombre de usuario.</p></div>';
echo "',";
echo "layout : 'other',";
echo "ttl : 4000,\r\n\t\t\t\t\t\t\t\t\t\teffect : 'thumbslider',\r\n\t\t\t\t\t\t\t\t\t\ttype : 'warning',\r\n\t\t\t\t\t\t\t\t\t\tonClose : function() {\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\t\t\tnotification.show();\r\n\t\t\t\t\t\t\t\t\t\$('#validate-info').fadeIn(1000);\r\n\t\t\t\t\t\t\t\t}, 300 );\r\n\t\t\t\t});\r\n\t\t\t})();</script>";
} else {
echo '<script src="view/js/classie.js"></script>
<script src="view/js/notificationFx.js"></script>';
echo "<script>";
echo "(function(){\r\n\t\t\t\tvar txt = document.getElementById( 'txtusuario1' );\r\n\t\t\t\tvar btn= document.getElementById('btnlogin');\r\n\t\t\t\t\$(document).ready(function(){\r\n\t\t\t\t\tclassie.add( txt, 'active' );\r\n\t\t\t\t\t\tsetTimeout( function() {";
echo "classie.remove( txt, 'active' );";
echo "var notification = new NotificationFx({";
echo "message: '";
<?
include_once("../../model/csConexion.php");
$con= new csConexion();
if($_POST["query"]){
$con->connect();
$query= "select*from users where idUser="******"query"];
$result= $con->execute($query);
$con->disconnect();
$active;
if(mysql_num_rows($result)>0){
while($row= mysql_fetch_array($result)){
$active= $row["active"];
}
if($active==1){
$con->connect();
$con->execute("update users set active=0 where idUser="******"query"]);
$con->disconnect();
}else if($active==0){
$con->connect();
$con->execute("update users set active=1 where idUser="******"query"]);
$con->disconnect();
}
}
}
?>
<?php
include_once '../../model/csConexion.php';
$con = new csConexion();
if (isset($_POST["data"])) {
list($city, $humidity, $current_temp, $description, $cloudines, $windspeed, $date) = split("/", $_POST["data"]);
$con->connect();
$exist = $con->execute("select*from citys where name='" . $city . "'");
$con->disconnect();
if (mysql_num_rows($exist) < 1) {
$query = "insert into citys values(default,'" . $city . "')";
$con->connect();
$result = $con->execute($query);
$con->disconnect();
}
$query = "select w.dateRegistry, c.name from weather w ";
$query .= "join citys c on c.idCity= w.idCity ";
$query .= "where w.dateRegistry='" . $date . "' and c.name='" . $city . "'";
$con->connect();
$exist = $con->execute($query);
$con->disconnect();
if (mysql_num_rows($exist) < 1) {
$query1 = "select idCity from citys where name='" . $city . "'";
$con->connect();
$result = $con->execute($query1);
$con->disconnect();
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
$query2 = "insert into weather values(default";
$query2 .= ",'" . $description . "'," . $current_temp . "," . $cloudines . "," . $row['idCity'] . ",'" . $date . "'," . $windspeed . ")";
$con->connect();
