<?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();