public function insert($city)
{
$con = new bd();
$sql = 'INSERT INTO city (name, state, country, description, thumbnail, id_gallery, id_user) VALUES ' . '("' . $city->getName() . '", "' . $city->getState() . '", ' . '"' . $city->getCountry() . '", "' . $city->getDescription() . '", ' . '"' . $city->getThumbnail() . '", ' . $city->getIdGallery() . ', ' . $city->getIdUser() . ')';
$r = $con->prepare($sql);
$r->execute();
}
function LlamadaInsert()
{
$obj = new bd();
$array = array(99, "pruebacontraseña", 'jorge', '*****@*****.**');
return $obj->insert('usuario', $array);
echo 'hola';
}
public function insert($form)
{
$con = new bd();
$sql = "INSERT INTO form_interest (id_package, first_name, last_name, guests_number, couple_room, individual_room, double_room, triple_room, observation, email, area_code, phone, newsletter) VALUES " . "(" . $form->getIdPackage() . ", '" . $form->getFirstName() . "', " . "'" . $form->getLastName() . "', " . $form->getGuestsNumber() . ", " . $form->getCoupleRoom() . ", " . $form->getIndividualRoom() . ", " . $form->getDoubleRoom() . ", " . $form->getTripleRoom() . ", '" . $form->getObservation() . "', '" . $form->getEmail() . "', " . $form->getAreaCode() . ", " . $form->getPhone() . ", " . $form->getNewsletter() . ")";
$r = $con->prepare($sql);
$r->execute();
}
public function update($package)
{
$con = new bd();
$sql = "UPDATE package SET id_city=" . $package->getIdCity() . ", name='" . $package->getName() . "', " . "description='" . $package->getDescription() . "', price=" . $package->getPrice() . ", " . "price_promo=" . $package->getPricePromo() . ", date_start='" . $package->getDateStart() . "', date_end='" . $package->getDateEnd() . "', " . "id_user="******", thumbnail='" . $package->getThumbnail() . "' WHERE idpackage=" . $package->getIdPackage();
$r = $con->prepare($sql);
$r->execute();
}
public function subir($ar, $ex, $dir)
{
$this->dir = $dir;
$this->archivo = explode(".", $ar['name']);
$this->extensiones = $ex;
$random = date("d:m:y:h:i") * rand() * 9999999;
if (in_array($this->archivo[1], $this->extensiones)) {
$this->url = $dir . $random . "." . $this->archivo[1];
if (!file_exists($this->dir)) {
@mkdir($this->dir, 777);
}
$this->arr = array(':nombre' => "hola", ':des' => "Hola", ':url' => $this->url);
$this->archivo = $ar;
if (move_uploaded_file($this->archivo['tmp_name'], $this->url)) {
$base = new bd(TBD, SER, BD, US, CL);
$i = 1;
$sql = $base->prepare("INSERT INTO imagen(idimagen, nombre, ruta, foto) VALUES ({$i}+1, {$this->archivo}[1], {$this->url}, {$this->archivo}['tmp_name'])");
if ($sql->execute($this->arr)) {
echo "Imagen subida y almacenada correctamente";
} else {
echo "Error";
}
} else {
echo "error";
}
} else {
echo "Extension invalida";
}
}
/** @fn ( validarLogin que busca en la base de datos por el nick del usuario y devuelve el id del mismo si todo a ido bien o la varia error=false)*/
public function validarLogin()
{
$username = $_POST['nick'];
$password = $_POST['pass'];
$password = sha1($password);
//Desencriptar;
$db = new bd();
$db->conexionBd();
//Nos conectamos
$arraySelect[0] = 'id';
$arraySelect[1] = 'nombre';
$arraySelect[2] = 'password';
$arrayWhere[0] = 'nombre = ' . $username;
$result = $db->select('usuarios', $arraySelect, $arrayWhere);
if (!empty($result)) {
$row = $result->fetch();
//Meto el resultado en un array
print $row['id'];
if ($row['password'] == $password) {
Sesiones . crearSesion($row['id']);
} else {
return true;
}
} else {
return true;
}
return false;
}
public function getUser($login, $password)
{
$con = new bd();
$sql = 'Select * from user where login="******" AND password = MD5("' . $password . '")';
$r = $con->prepare($sql);
$r->execute();
$result = $r->fetch();
$user = new user($result['iduser'], $result['login'], $result['password'], $result['name'], $result['privilege']);
return $user;
}
function actualizaFavoritos()
{
$bd = new bd();
session_start();
$valores = array("usuarios_id" => $_SESSION["id"], "visitas_publicaciones_id" => $_POST["id"]);
if ($_POST["tipo"] == 1) {
$result = $bd->doInsert("publicaciones_favoritos", $valores);
} else {
$result = $bd->query("delete from publicaciones_favoritos where usuarios_id={$_SESSION['id']} and visitas_publicaciones_id={$_POST['id']}");
}
}
public function buscarSedes($id = NULL)
{
$bd = new bd();
$consulta = "select id, nombre, codigo from sedes where 1 ";
if (!empty($id)) {
$consulta .= " and id='{$id}' ";
}
$result = $bd->query($consulta);
if ($result) {
return $result;
} else {
return false;
}
}
function obtenerMensajesNuevos($idmensaje)
{
$tabmensaje = 'mensaje';
$idmensaje++;
include 'bbdd/bd.php';
$obj = new bd();
$sms = $obj->select($tabmensaje, $idmensaje);
if (isset($sms)) {
for ($i = $idmensaje; $i < count($sms); $i++) {
$mensajes[] = $obj->select($tabmensaje, $i);
}
return json_encode($mensajes);
} else {
return json_encode(array(FALSE));
}
}
function buscaPublicaciones()
{
$bd = new bd();
if (!isset($_SESSION)) {
session_start();
}
$inicio = ($_POST["pagina"] - 1) * 5;
$consulta = "select * from publicaciones where \n\tusuarios_id in (SELECT\n\tusuarios.id\n\tFROM\n\tusuarios where\n\tusuarios.id_sede ='" . $_SESSION['id_sede'] . "' )\n\tand\n\tid in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 and fecha_fin IS NULL) order by id desc limit 5 OFFSET {$inicio}";
$result = $bd->query($consulta);
$resultTotal = $bd->query("select count(*) as tota from publicaciones where usuarios_id in (SELECT\n\tusuarios.id\n\tFROM\n\tusuarios where\n\tusuarios.id_sede ='" . $_SESSION['id_sede'] . "' ) and id in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 AND fecha_fin IS NULL)");
foreach ($resultTotal as $r => $valor) {
$total = $valor["tota"];
}
echo "<div class='hidden-xs hidden-sm col-md-1 col-lg-1'></div>";
$i = 0;
foreach ($result as $r) {
$i++;
$publicacion = new publicaciones($r["id"]);
$usua = new usuario($publicacion->usuarios_id);
if ($_POST["pagina"] == 1) {
$izquierda = "";
} else {
$izquierda = $i == 1 ? "<i class='fa fa-chevron-circle-left t38 point 'style='color: \t#ccc; position:absolute; top:37%; left:-20%; ' id='izquierda' onClick='javascript:buscaIzquierda();'></i>" : "";
}
if ($_POST["pagina"] == 5) {
$derecha = "";
} else {
if ($total <= $_POST["pagina"] * 5) {
$derecha = "";
} else {
$derecha = $i == 5 ? "<i class='fa fa-chevron-circle-right t38 point derecha' style='color: \t#ccc; position:absolute; float:right; top:37%; right:-15%; ' id='derecha' onClick='javascript:buscaDerecha();'></i>" : "";
}
}
$cadena = "\n\t \t<div class='col-xs-12 col-sm-12 col-md-6 col-lg-2'>\n\t \t {$izquierda} \n\t \t\t\t<div class='text-center mar10 publicaciones1' style='relative;width:70%;' id='" . $publicacion->id . "'>\n\t\t\t\t \t<br>\n\t\t\t\t \t<div class='marco-foto-conf point center-block sombra-div3 ' style='height:120px; width: 120px;' >\n\t\t\t\t\t\t<img src='" . $publicacion->getFotoPrincipal() . "' class=' img-responsive center-block img-apdp'>\n\t\t\t\t\t\t</div> \n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<span class='negro point t16'>" . $publicacion->tituloFormateado(15) . "</span>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<a href='perfil.php?id=" . $usua->id . "' ><span class='blue-vin t16' >" . $usua->j_razon_social . "</span></a>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<span class='red t14'><b>" . $publicacion->getMonto() . "</b></span>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t <span class='t12 grisC'><i class='fa fa-clock-o'></i>" . $publicacion->getTiempoPublicacion() . "</span>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t</div>\n\t\t\t\t\t{$derecha} \n\t\t\t</div>";
echo $cadena;
if ($i == 5) {
echo '<div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
<div class="text-right ancho95 "> <a href="listado.php">Ver Todas</a> </div>
<br>
</div>';
break;
}
}
}
function obtenerMensajesNuevos($idmensaje)
{
$tabmensaje = 'mensaje';
// variable que guarda la tabla con la que se trabaja
$where = array();
//$where es la condicion que debe cumplirse para que el mensaje sea mostrado este caso sería que id>$idmensaje. HAY QUE HACER.
$atributos = array('id', 'usuario', 'fecha', 'texto');
//que atributos se cojen de la tabla
include 'bbdd/bd.php';
$obj = new bd();
$sms = $obj->select($tabmensaje, $atributos, $where);
if (isset($sms)) {
//comprueba si la variable esta definida
for ($i = $idmensaje; $i < count($sms); $i++) {
$mensajes[] = $obj->select($tabmensaje, $atributos, $i);
//se va guardando en un array los datos de los mensajes nuevos que hay en la base de datos. hay que modificar la select.
}
return json_encode($mensajes);
} else {
return json_encode(array(FALSE));
//no hay mensajes nuevos
}
}
function buscaPublicaciones()
{
$bd = new bd();
$inicio = ($_POST["pagina"] - 1) * 5;
$consulta = "select * from publicaciones where id in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 AND fecha_fin IS NULL) order by id desc limit 5 OFFSET {$inicio}";
$result = $bd->query($consulta);
$resultTotal = $bd->query("select count(*) as tota from publicaciones where id in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 AND fecha_fin IS NULL)");
foreach ($resultTotal as $r => $valor) {
$total = $valor["tota"];
}
$i = 0;
foreach ($result as $r) {
$i++;
$publicacion = new publicaciones($r["id"]);
$usua = new usuario($publicacion->usuarios_id);
if ($_POST["pagina"] == 1) {
$izquierda = "";
} else {
$izquierda = $i == 1 ? " <i class='fa fa-caret-left t30 point izquierda'style='position:absolute; top:37%; left:-2%; ' id='izquierda' onClick='javascript:buscaIzquierda();'></i>" : "";
}
if ($_POST["pagina"] == 5) {
$derecha = "";
} else {
if ($total <= $_POST["pagina"] * 5) {
$derecha = "";
} else {
$derecha = $i == 5 ? " <i class='fa fa-caret-right t30 point derecha'style='position:absolute; float:right; top:37%; right:15%; ' id='derecha' onClick='javascript:buscaDerecha();'></i>" : "";
}
}
$cadena = "\r\n\t \t<div class='col-xs-12 col-sm-12 col-md-6 col-lg-2'>\r\n\t \t{$izquierda}\r\n\t \t\t\t<div class='text-center mar10 publicaciones1' style='relative;width:70%;' id='{$publicacion->id}' onClick='javascript:verDetalle({$publicacion->id})'>\r\n\t\t\t\t \t<br>\r\n\t\t\t\t \t<div class='marco-foto-conf point center-block sombra-div3 ' style='height:120px; width: 120px;' >\r\n\t\t\t\t\t\t<img src='" . $publicacion->getFotoPrincipal() . "' class=' img-responsive center-block img-apdp'>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t<br>\r\n\t\t\t\t\t\t<span class='negro t16'>" . $publicacion->tituloFormateado(15) . "</span>\r\n\t\t\t\t\t\t<br>\r\n\t\t\t\t\t\t<span class='red t14'><b>" . $publicacion->getMonto() . "</b></span>\r\n\t\t\t\t\t\t<br>\r\n\t\t\t\t\t\t<span class='t12 grisC'>" . $usua->getEstado() . "</span> <span class='t12 grisC'><i class='fa fa-clock-o'></i>" . $publicacion->getTiempoPublicacion() . "</span>\r\n\t\t\t\t\t\t<br>\r\n\t\t\t\t\t\t<br>\r\n\t\t\t\t\t</div>\r\n\t\t\t\t\t{$derecha}\r\n\t\t\t</div>\r\n\t\t";
echo $cadena;
if ($i == 5) {
break;
}
}
}
public function agregarM1()
{
// $this->pdf($nomb);
$time = time();
$fecha = date("Y-m-d", $time);
$bd = bd::getInstance();
/*$sql = $bd->ejecutar("INSERT INTO correos_alumno
VALUES('',
'{$this->id_destino}',
'{$this->id_modulo}',
'$fecha',
'{$this->mensaje}',
'0','1')");*/
$bd->ejecutar("INSERT INTO correos (id_Tipo,id_ModuloE,id_Envia,id_Destino,id_ModuloD,id_Recibe,fecha_Envio,Contenido,Estatus) \n\t\t\t\tVALUES({$tipo},{$moduloE},{$envia},{$destino},{$moduloD},{$recibe},current_date(),'{$contenido}',{$estatus})");
if ($sql) {
echo " <script type='text/javascript'>\n\t\t alert('Enviado Correctamente');\n\t\t window.location='../vistas/modulo2/paneladmi.php';\n\t\t </script> ";
} else {
echo " <script type='text/javascript'>\n\t\t alert('Error al Enviar');\n\t\t window.location='../vistas/modulo2/paneladmi.php';\n\t\t </script> ";
}
}
/**
*
* Función de conexión a la base de datos.
*/
function conectar()
{
$config = new bd();
$config->conexion();
}
<?php
include "../modeles/membre.php";
include "../modeles/bd.php";
if (isset($_POST['pseudo']) && isset($_POST['mdp'])) {
$pseudo = $_POST['pseudo'];
$mdp = $_POST['mdp'];
$bd = new bd();
$requete_co = mysqli_query($bd->getco(), "select * from membre where pseudo = '{$pseudo}' and mdpasse = '{$mdp}';");
if (mysqli_num_rows($requete_co) == 1) {
$membre = new Membre($bd, $pseudo, $mdp);
$membre->connexion();
header("location: ../vue/espace_membre.php");
}
$bd->disconnect();
}
header("location: ../vue/formulaire_inscription.php");
<?php
include_once "clases/publicaciones.php";
include_once "clases/bd.php";
$bd = new bd();
$publicaciones = $bd->query("select publicaciones_id from publicacionesxstatus where status_publicaciones_id<4 and fecha_fin IS NULL and fecha<=DATE_SUB(CURDATE(), INTERVAL 30 DAY)");
$tiempo = date("Y-m-d H:i:s", time());
$contador = 0;
foreach ($publicaciones as $key => $valor) {
$valores = array("fecha" => $tiempo, "publicaciones_id" => $valor["publicaciones_id"], "status_publicaciones_id" => 4, "fecha_fin" => $tiempo);
$consulta = "update publicacionesxstatus set fecha_fin='{$tiempo}' where publicaciones_id={$valor["publicaciones_id"]} and fecha_fin IS NULL";
$bd->query($consulta);
$bd->doInsert("publicacionesxstatus", $valores);
$contador++;
}
echo "Actualizadas {$contador} publicaciones";
function ordena()
{
$bd = new bd();
$foto = new fotos();
$consulta = "select id from publicaciones where id in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 and fecha_fin is null)";
$_POST["orden"] = str_replace("_", " ", $_POST["orden"]);
if ($_POST["categoria"] != "") {
$criterio = "I{$_POST["categoria"]}F";
$consulta .= " and clasificados_id in (select id from clasificados where ruta like '%{$criterio}%')";
}
if ($_POST["condicion"]) {
$consulta .= " and condiciones_publicaciones_id = {$_POST["condicion"]}";
}
if ($_POST["estado"] != "") {
$consulta .= " and usuarios_id in (select id from usuarios where estados_id={$_POST["estado"]})";
}
if ($_POST["palabra"] != "") {
$consulta .= " and titulo like '%{$_POST["palabra"]}%'";
}
$consulta .= " order by {$_POST["orden"]} limit 25 OFFSET 0";
$result = $bd->query($consulta);
foreach ($result as $r => $valor) {
$publi = new publicaciones($valor["id"]);
$usua = new usuario($publi->usuarios_id);
$miTitulo = $publi->titulo;
$miTitulo = str_ireplace($_POST["palabra"], "<span style='background:#ccc'><b>" . strtoupper($_POST["palabra"]) . "</b></span>", $miTitulo);
?>
<div class=' col-xs-12 col-sm-6 col-md-2 col-lg-2'>
<div class='marco-foto-conf point marL20 ' style='height:130px; width: 130px;' >
<div style='position:absolute; left:40px; top:10px; ' class='f-condicion'><?php
echo $publi->getCondicion();
?>
</div>
<img src='<?php
echo $publi->getFotoPrincipal();
?>
' class='img img-responsive center-block img-apdp imagen' style='width:100%;height:100%;'
data-id='<?php
echo $publi->id;
?>
'>
</div>
</div>
<div class=' col-xs-12 col-sm-6 col-md-7 col-lg-7'><p class='t16 marL10 marT5'>
<span class=' t15'><a class='negro' href='detalle.php?id=<?php
echo $publi->id;
?>
' class='grisO'><b> <?php
echo $miTitulo;
?>
</b></a></span>
<br><span class=' vin-blue t14'><a href='perfil.php?id=<?php
echo $usua->id;
?>
' class=''><b> <?php
echo $usua->a_seudonimo;
?>
</b></a></span>
<br><span class='t14 grisO '><?php
echo $usua->getNombre();
?>
</span><br>
<span class='t12 grisO '><i class='glyphicon glyphicon-time t14 opacity'></i><?php
echo $publi->getTiempoPublicacion();
?>
</span><br>
<span class='t11 grisO'> <span> <i class='fa fa-eye negro opacity'></i></span><span class='marL5'><?php
echo $publi->getVisitas();
?>
Visitas</span><i class='fa fa-heart negro marL5 opacity'>
</i><span class=' point h-under marL5'><?php
echo $publi->getFavoritos();
?>
Me gusta</span><i class='fa fa-share-alt negro marL15 opacity hidden'></i> <span class=' point h-under marL5 hidden'> <?php
echo $publi->getCompartidos(3);
?>
Veces compartido</span> </span></p>
</div>
<div class=' col-xs-12 col-sm-12 col-md-3 col-lg-3 text-right'>
<div class='marR20'><span class='red t20'><b> <?php
echo $publi->getMonto();
?>
</b></span >
<br><span class=' t12'> <?php
echo $usua->getEstado();
?>
</span><br><span class='vin-blue t16'><a href='detalle.php?id=<?php
echo $publi->id;
?>
' style='text-decoration:underline;'>Ver Mas</a></span >
</div>
</div>
<div class='col-xs-12 col-sm-12 col-md-12 col-lg-2'><br></div><div class='col-xs-12 col-sm-12 col-md-12 col-lg-10'><hr class='marR10'><br></div>
<?php
}
}
public function insertar()
{
$id_modulo = $_SESSION['modulo'];
if ($this->asesor == "1") {
$sql = "INSERT INTO alumno\n VALUES ('','{$this->carrera}',\n '{$this->plan}',\n '{$this->depart}',\n '1',\n '{$this->nombre}',\n '{$this->apellido}',\n '{$this->matricula}',\n '{$this->semestre}',\n '{$this->correo}',\n '{$this->pass}',\n '{$this->celular}',\n '{$this->genero}')";
mysql_query($sql);
$sql2 = $bd->ejecutar("INSERT INTO avancemodulo\n VALUES ({$id_modulo},'','0')");
} else {
$sql = "INSERT INTO alumno\n VALUES ('','{$this->carrera}',\n '{$this->plan}',\n '0',\n '{$this->nombre}',\n '{$this->apellido}',\n '{$this->matricula}',\n '{$this->semestre}',\n '{$this->correo}',\n '{$this->pass}',\n '{$this->celular}',\n '{$this->genero}')";
mysql_query($sql);
}
//Funcion que me sirve para obtener el ultimo id que se registro en la tabla alumno
$id = mysql_insert_id();
$bd = bd::getInstance();
$sql2 = $bd->ejecutar("INSERT INTO avancemodulo\n VALUES ({$id_modulo},{$id},'0')");
// mysql_query($sql);
// echo $sql;
// echo mysql_error();
// exit();
$this->insertar2($id);
if ($sql) {
echo " <script type='text/javascript'>\n alert('El registro ha sido guardado correctamente');\n window.location='../vistas/modulo1/sesion.php';\n </script> ";
} else {
echo " <script type='text/javascript'>\n alert('Error al Guardar los datos');\n window.location='../vistas/modulo1/registroAlumno.php';\n </script> ";
}
}
$table = "manager_stats";
$fields = array("userid" => $uid, "social_network" => $type, "user_id" => $fbacc['user_id'], "message" => $message->getStatus(), "message_id" => $post['id'], "type" => 1, "time" => $timezone);
$db->doInsert($table, $fields);
$message->setLastShare();
} else {
error_log($hfb->getErrorMes());
}
} catch (Exception $e) {
error_log($e);
}
}
}
}
}
$user_object = new usuario();
$db = new bd();
$usuarios = $user_object->listarUsuariosConPublicaciones(1);
foreach ($usuarios as $usuario) {
$uid = $usuario['id'];
$pubs = $usuario['publicaciones']->fetchAll();
$message = new Handler_Message($pubs[0]);
$query = "SELECT * FROM manager_messages_scheduled WHERE userid = {$uid}";
if ($res = $db->query($query)) {
$plus = $res->rowCount();
} else {
$plus = 0;
}
$upst = $usuario['total'] + $plus;
if ($upst > 0) {
if ($message->canPublishTwitter()) {
handleTwitterMessage($message, $uid, $db, $user_object, $upst);
/**
* Pega o retorno do SQL
* @param string $SQL recebe a sql e executa
* @example <br />array(1) {
* <br />[2365]=>
* <br />array(2) {
* <br />["nome"]=>
* <br />string(19) "ABADIA DOS DOURADOS"
* <br />[0]=>
* <br />array(3) {
* <br />["valor"]=>
* <br />string(6) "72.936"
* <br />["fk_ano_referencia"]=>
* <br />string(1) "3"
* <br />["fk_variavel"]=>
* <br />string(1) "1"
* <br />}
* <br />}
*/
private function iRunSQLSecundarioCC($ResultadosMain, $SQL)
{
//die($SQL);
if (strpos($SQL, "()")) {
die(json_encode(array("erro" => 1, "msg" => " Houve um erro desconhecido no servidor, recarregue a página. <br />Código: #001")));
}
$tempArry = parent::ExecutarSQL($SQL, "iRunSQLSecundario22");
//die(var_dump($tempArry));
$dv = 0;
$Formatado = array();
foreach ($tempArry as $key => $val) {
if ($val['country'] === 'true') {
//Paises
//$Formatado[]=$val['nome'];
$this->varOnly = false;
if (!$this->varOnly) {
$arg = $val;
//die(var_dump($arg));
unset($arg['im']);
unset($arg['nome']);
unset($arg['country']);
unset($arg['rm']);
unset($arg['u']);
unset($arg['uf']);
unset($arg['udh']);
unset($arg['is_ri']);
unset($arg['reg']);
unset($arg['cod']);
unset($val['rm']);
unset($val['u']);
unset($val['uf']);
unset($val['udh']);
unset($val['is_ri']);
unset($val['reg']);
unset($val['cod']);
if (in_array($arg["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
} else {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
}
//if($this->isSearchName)
$Formatado[$val['im']]["nome"] = $val["nome"];
$Formatado[$val['im']]["country"] = $val["country"];
$Formatado[$val['im']]["id"] = str_replace("10000", "", $val["im"]);
$Formatado[$val['im']]["esp"] = 10;
$Formatado[$val['im']]["vs"][$val["iv"] . "_" . $val["ka"]] = $arg;
} else {
if (in_array($val["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 2, '.', '');
} else {
$val["v"] = cutNumber($arg["v"], 2, '.', '');
}
$Formatado[$key] = $val;
}
} elseif ($val['rm'] === 'true') {
//RMs
//$Formatado[]=$val['nome'];
if (!$this->varOnly) {
$arg = $val;
//die(var_dump($arg));
unset($arg['im']);
unset($arg['nome']);
unset($arg['rm']);
unset($arg['country']);
unset($arg['u']);
unset($arg['uf']);
unset($arg['udh']);
unset($arg['is_ri']);
unset($arg['reg']);
unset($arg['cod']);
unset($val['country']);
unset($val['u']);
unset($val['uf']);
unset($val['udh']);
unset($val['is_ri']);
unset($val['reg']);
unset($val['cod']);
if (in_array($arg["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
} else {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
}
//if($this->isSearchName)
$Formatado[$val['im']]["nome"] = $val["nome"];
//$Formatado[$val['im']]["u"] = $val["u"];
$Formatado[$val['im']]["rm"] = $val["rm"];
$Formatado[$val['im']]["id"] = str_replace("10000", "", $val["im"]);
$Formatado[$val['im']]["esp"] = 6;
$Formatado[$val['im']]["vs"][$val["iv"] . "_" . $val["ka"]] = $arg;
} else {
foreach ($tempArry as $key => $val) {
if (in_array($val["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 2, '.', '');
} else {
$val["v"] = cutNumber($arg["v"], 2, '.', '');
}
$Formatado[$key] = $val;
}
}
} elseif ($val['reg'] === 'true') {
//Regional
//$Formatado[]=$val['nome'];
if (!$this->varOnly) {
$arg = $val;
//die(var_dump($arg));
unset($arg['im']);
unset($arg['nome']);
unset($arg['reg']);
unset($arg['country']);
unset($arg['u']);
unset($arg['uf']);
unset($arg['rm']);
unset($arg['udh']);
unset($arg['is_ri']);
unset($arg['cod']);
unset($val['country']);
unset($val['u']);
unset($val['uf']);
unset($val['rm']);
unset($val['udh']);
unset($val['is_ri']);
unset($val['cod']);
if (in_array($arg["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
} else {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
}
//if($this->isSearchName)
$Formatado[$val['im']]["nome"] = $val["nome"];
//$Formatado[$val['im']]["u"] = $val["u"];
$Formatado[$val['im']]["reg"] = $val["reg"];
$Formatado[$val['im']]["id"] = str_replace("10000", "", $val["im"]);
$Formatado[$val['im']]["esp"] = 3;
$Formatado[$val['im']]["vs"][$val["iv"] . "_" . $val["ka"]] = $arg;
} else {
foreach ($tempArry as $key => $val) {
if (in_array($val["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 2, '.', '');
} else {
$val["v"] = cutNumber($arg["v"], 2, '.', '');
}
$Formatado[$key] = $val;
}
}
} elseif ($val['udh'] === 'true') {
//UHDs
//$Formatado[]=$val['nome'];
if (!$this->varOnly) {
$arg = $val;
//die(var_dump($arg));
unset($arg['im']);
unset($arg['nome']);
unset($arg['udh']);
unset($arg['country']);
unset($arg['u']);
unset($arg['uf']);
unset($arg['rm']);
unset($arg['is_ri']);
unset($arg['reg']);
unset($arg['cod']);
unset($val['country']);
unset($val['u']);
unset($val['uf']);
unset($val['rm']);
unset($val['is_ri']);
unset($val['reg']);
unset($val['cod']);
if (in_array($arg["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
} else {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
}
//if($this->isSearchName)
$Formatado[$val['im']]["nome"] = $val["nome"];
//$Formatado[$val['im']]["u"] = $val["u"];
$Formatado[$val['im']]["udh"] = $val["udh"];
$Formatado[$val['im']]["id"] = str_replace("10000", "", $val["im"]);
$Formatado[$val['im']]["esp"] = 5;
$Formatado[$val['im']]["vs"][$val["iv"] . "_" . $val["ka"]] = $arg;
} else {
foreach ($tempArry as $key => $val) {
if (in_array($val["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 2, '.', '');
} else {
$val["v"] = cutNumber($arg["v"], 2, '.', '');
}
$Formatado[$key] = $val;
}
}
} elseif (strlen($val['u']) and !strlen($val['uf'])) {
//Estatual
if (!$this->varOnly) {
$arg = $val;
unset($arg['im']);
unset($arg['nome']);
unset($arg['u']);
unset($arg['cod']);
unset($arg['country']);
unset($arg['rm']);
unset($arg['uf']);
unset($arg['udh']);
unset($arg['is_ri']);
unset($arg['reg']);
unset($val['country']);
unset($val['rm']);
unset($val['uf']);
unset($val['udh']);
unset($val['is_ri']);
unset($val['reg']);
if (in_array($arg["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
} else {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
}
//if($this->isSearchName)
$Formatado[$val['im']]["nome"] = $val["nome"];
$Formatado[$val['im']]["u"] = $val["u"];
$Formatado[$val['im']]["cod"] = $val["cod"];
$Formatado[$val['im']]["id"] = str_replace("10000", "", $val["im"]);
$Formatado[$val['im']]["esp"] = 4;
$Formatado[$val['im']]["vs"][$val["iv"] . "_" . $val["ka"]] = $arg;
} else {
if (in_array($val["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 2, '.', '');
} else {
$val["v"] = cutNumber($arg["v"], 2, '.', '');
}
$Formatado[$key] = $val;
}
} elseif (strlen($val['u']) and strlen($val['uf'])) {
//Municipal
//$Formatado[]=$val['nome'];
if (!$this->varOnly) {
//$dv++;
$arg = $val;
unset($arg['im']);
unset($arg['nome']);
unset($arg['uf']);
unset($arg['cod']);
unset($arg['country']);
unset($arg['rm']);
unset($arg['u']);
unset($arg['udh']);
unset($arg['is_ri']);
unset($arg['reg']);
unset($val['country']);
unset($val['rm']);
unset($val['u']);
unset($val['udh']);
unset($val['is_ri']);
unset($val['reg']);
if (in_array($arg["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
} else {
$arg["v"] = cutNumber($arg["v"], 2, '.', '');
}
//if($this->isSearchName){
//if(isset($val["nome"]))
$Formatado[$val['im']]["nome"] = $val["nome"];
if (isset($val["uf"])) {
$Formatado[$val['im']]["uf"] = $val["uf"];
}
//}
$Formatado[$val['im']]["cod"] = $val["cod"];
$Formatado[$val['im']]["id"] = $val["im"];
$Formatado[$val['im']]["esp"] = 2;
$Formatado[$val['im']]["vs"][$val["iv"] . "_" . $val["ka"]] = $arg;
} else {
foreach ($tempArry as $key => $val) {
if (in_array($val["iv"], PublicMethods::$ArrayPadding3ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 3, '.', '');
} elseif (in_array($val["iv"], PublicMethods::$ArrayPadding2ZerosDireita)) {
$val["v"] = cutNumber($val["v"], 2, '.', '');
} else {
$val["v"] = cutNumber($arg["v"], 2, '.', '');
}
$Formatado[$key] = $val;
}
}
}
}
//die(var_dump($Formatado));
//die(var_dump($dv));
$this->results = $Formatado;
}
<?php
include "clases/busqueda.php";
include_once "clases/bd.php";
include_once "clases/fotos.php";
include_once "clases/publicaciones.php";
$bd = new bd();
$foto = new fotos();
$lista = $bd->query("select id,(select count(favoritos_id) from usuarios_favoritos where favoritos_id=usuarios.id) as fav, \r\n(select fecha from usuariosxstatus where usuarios_id=usuarios.id) as fecha from usuarios order by certificado desc, fav desc,fecha asc");
$estados = $bd->query("select id,nombre,(select count(id) from usuarios where estados_id = estados.id) as totaP from estados");
$total = $lista->rowCount();
$totalPaginas = ceil($total / 25);
?>
<div class="container " id="principal" name="principal" >
<div class="row">
<?php
if ($total == 0) {
?>
<div class='col-xs-12 col-sm-12 col-md-12 col-lg-12' id="noresultados" name"noresultados">
<div class='alert alert-warning2 text-left' role='alert' >
<img src="galeria/img/logos/bill-error.png" width="120px" height="120px;" class="pull-left" style="margin-top:-10px;"/>
<div class="t16 marL20 marB5 ">No se encontraron resultados de tu busqueda.</div>
<span class="t12 marL30 grisO">
<i class="fa fa-caret-right marR10"></i> Verifica la ortografia en cada palabra.
</span>
<br>
<span class="t12 marL30 grisO">
<i class="fa fa-caret-right marR10"></i> Utiliza palabras más estandares.
</span>
<br>
<span class="t12 marL30 grisO">
<?php
require_once "../../clases/bd.php";
require_once "../../clases/publicaciones.php";
$db = new bd();
session_start();
$uid = $_SESSION['id'];
$sn = array();
function formatTimeStamp($timestamp, $lang = false)
{
$months = array("Enero" => "January", "Febrero" => "February", "Marzo" => "March", "Abril" => "April", "Mayo" => "May", "Junio" => "June", "Julio" => "July", "Agosto" => "August", "Septiembre" => "September", "Octubre" => "October", "Noviembre" => "November", "Diciembre" => "December");
$day = date("d", $timestamp);
$year = date("Y", $timestamp);
$month = date("F", $timestamp);
$month = array_search($month, $months);
return "{$day} {$month}, {$year}";
}
function formatHour($hour)
{
$hour = explode(":", $hour);
if ($hour[0] > 12) {
$h = $hour[0] - 12;
$t = " PM";
} else {
$h = $hour[0];
$t = " AM";
}
return $h . ":" . $hour[1] . $t;
}
$query = "SELECT * FROM manager_messages_scheduled WHERE userid = {$uid}";
if ($res = $db->query($query)) {
public function getCondiciones()
{
$bd = new bd();
$condicion = "where id in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 and fecha_fin is null)";
$operador = "and";
if ($this->palabra != "") {
$condicion .= " {$operador} titulo like '%{$this->palabra}%'";
$operador = " and ";
}
if ($this->clasificados_id != "") {
$criterio = "I" . $this->clasificados_id . "F";
$condicion .= $operador . " clasificados_id in (select id from clasificados where ruta like '%{$criterio}%')";
//ojo
$operador = " and ";
}
$consulta = "select (select count(id) from publicaciones {$condicion} and condiciones_publicaciones_id=1) as tota1,\n \t\t\t\t(select count(id) from publicaciones {$condicion} and condiciones_publicaciones_id=2) as tota2,\n \t\t\t\t(select count(id) from publicaciones {$condicion} and condiciones_publicaciones_id=3) as tota3";
$r = $bd->query($consulta);
if ($r) {
return $r->fetch();
} else {
return false;
}
}
$hfb = new Handler_Facebook();
if ($post = $hfb->post("/me/feed", $message->getFacebookPostBody(), $fbacc['access_token'])) {
$table = "manager_stats";
$fields = array("userid" => $uid, "social_network" => "fb", "user_id" => $fbacc['user_id'], "message" => $message->getStatus(), "message_id" => $post->{$response}['id'], "type" => 2, "time" => $timezone);
$db->doInsert($table, $fields);
} else {
error_log($hfb->lastError);
}
} catch (Exception $e) {
error_log($e);
}
}
}
}
$user_object = new usuario();
$db = new bd();
$time = time();
$day = date('D', $time);
$hour_min = date('H:i:00', strtotime('- 4 minutes', $time));
$hour_max = date('H:i:00', strtotime('+ 4 minutes', $time));
$table = "manager_messages_scheduled";
$condition = " days LIKE '%{$day}%' \n\t\tAND time_start<{$time} AND time_end>{$time} \n\t\tAND hour>'{$hour_min}' && hour<'{$hour_max}'";
$user_object = new usuario();
if ($res = $db->doFullSelect($table, $condition)) {
foreach ($res as $re) {
$message = new Handler_Message($re, false);
if ($message->canPublishTwitter()) {
handleTwitterMessage($message, $db, $user_object);
}
if ($message->canPublishFacebook()) {
handleFacebookMessage($message, $db, $user_object);
<span class="marL10"><i class="fa fa-phone"></i> Telefono</span>
</div>
<div class="form-group col-xs-12 col-sm-12 col-md-12 col-lg-12 input">
<input type="text"
placeholder="Ingrese un numero de telefono..." name="e_telefono"
class=" form-input" id="e_telefono">
</div>
<div class="col-xs-12">
<span class="marL10"><i class="fa fa-map-marker"></i>
Ubicacion...</span>
</div>
<div class="form-group col-xs-12 col-sm-12 col-md-12 col-lg-12 input">
<select class=" form-select " id="e_estado" name="e_estado">
<option value="" disabled selected>Seleccione un Estado</option>
<?php
$estados = new bd();
foreach ($estados->getDatosBase("estados", 1) as $estado) {
?>
<option value="<?php
echo $estado["id"];
?>
"><?php
echo $estado["nombre"];
?>
</option>
<?php
}
?>
</select>
</div>
<div class="form-group col-xs-12 col-sm-12 col-md-12 col-lg-12 input">
<?php
require '../../config/bd/connect.php';
require '../../config/bd/bd.php';
$bd = bd::getInstance();
$mod = $_GET["id_Modulo"];
$proy = $_GET["proy"];
$alum = $_GET["id_Alumno"];
$sql = "SELECT id_Modulo FROM avancemodulo WHERE id_Alumno ={$_GET['id_Alumno']} and id_Proyecto ={$_GET['proy']} and id_Modulo={$_GET['id_Modulo']}";
$activar = "insert into avancemodulo values({$_GET['id_Modulo']},{$_GET['id_Alumno']},{$_GET['proy']})";
$desactivar = "delete FROM avancemodulo WHERE id_Alumno ={$_GET['id_Alumno']} and id_Proyecto ={$_GET['proy']} and id_Modulo={$_GET['id_Modulo']}";
// echo $sql;
$stmt = $bd->ejecutar($sql);
$i = 0;
while ($resp = mysql_fetch_array($stmt)) {
$i = 1;
break;
}
if ($i == 0) {
$bd->ejecutar($activar);
//echo $activar;
} else {
$bd->ejecutar($desactivar);
//echo $desactivar;
}
$sql = "SELECT id_Modulo FROM avancemodulo WHERE id_Alumno ={$_GET['id_Alumno']} and id_Proyecto ={$_GET['proy']} order by id_Modulo asc";
// echo $sql;
$stmt = $bd->ejecutar($sql);
$modulos = "";
while ($row = mysql_fetch_array($stmt)) {
$modulos .= $row["id_Modulo"] . ",";
<p class="text-left mar20 " style="border-right: 1px solid #ccc;">
<span class="negro t26 ">Ultimas <br> públicaciones</span>
<br><br>
<span class="">echale un vistazo a las publicaciones más recientes.</span>
<br><br>
<span class="vin-blue t18" style="text-decoration:underline;"><a href="listado.php">Ver más...</a></span>
<br>
<br>
<br>
<br>
</p>
</div>
<div id="listaPublicaciones" data-pagina="1">
<!--desde aqui -->
<?php
$bd = new bd();
$consulta = "select * from publicaciones where id in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 and fecha_fin IS NULL) order by id desc limit 5";
$result = $bd->query($consulta);
$resultTotal = $bd->query("select count(*) as tota from publicaciones where id in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 and fecha_fin IS NULL)");
foreach ($resultTotal as $r => $valor) {
$total = $valor["tota"];
}
$i = 0;
foreach ($result as $r) {
$i++;
$publicacion = new publicaciones($r["id"]);
$usua = new usuario($publicacion->usuarios_id);
// $izquierda=($i==1)?" <i class='fa fa-caret-left t30 point izquierda'style='position:absolute; top:37%; left:-2%; ' id='izquierda' onClick='javascript:buscaIzquierda();'></i>":"";
$izquierda = "";
if ($total <= 5) {
$derecha = "";
<?php
require_once "../../clases/bd.php";
session_start();
$mesid = $_POST['id'];
$uid = $_SESSION['id'];
$table = "manager_fb_acc";
$db = new bd();
$query = "DELETE FROM manager_messages_scheduled WHERE id=" . $db->quote($mesid) . " AND userid=" . $db->quote($uid);
error_log($query);
if ($db->query($query)) {
$return = array("e" => 0);
} else {
$return = array("e" => 1);
}
echo json_encode($return);
$table = "fb_acc_page";
if ($info = $fbh->get("/me/accounts", $at)) {
$c = count($info['data']);
if ($c > 0) {
foreach ($info['data'] as $page) {
$perms = $page["perms"];
if (in_array("ADMINISTER", $perms) || in_array("CREATE_CONTENT", $perms) || in_array("BASIC_ADMIN", $perms)) {
$pages[] = array("n" => $page['name'], "i" => $page['id'], "p" => getFBPpic($page['access_token'], $fbh, $page['id']));
}
}
}
}
return $pages;
}
session_start();
$db = new bd();
$userid = $_SESSION["id"];
$table = "manager_fb_acc";
$condition = " userid=" . $userid . " AND expired=0 AND (expires_at>" . time() . " OR expires_at=0) ";
if ($result = $db->doSingleSelect($table, $condition)) {
$table = "manager_fbp_acc";
$condition = " userid=" . $userid;
if ($db->doSingleSelect($table, $condition)) {
$return = array("e" => 2);
} else {
try {
$fbh = new Handler_Facebook();
$at = $result['access_token'];
$return = array("e" => 0, "p" => getFBPages($at, $fbh));
} catch (Exception $e) {
$return = array("e" => 3);
