error_log("Error al subir foto");
$img = "";
}
} else {
$img = $_POST['img'];
}
} else {
$img = "";
}
$message = cleanMessage($_POST['message'], $max_chars, $userid);
if (!is_numeric($message) || $message > 5) {
$fields = array('userid' => $userid, 'message' => $message, 'img' => $img, 'time_start' => $_POST['time_start'], 'time_end' => $_POST['time_end'], 'days' => $_POST['days'], 'hour' => $_POST['hour'], 'publish_fb' => $_POST['publish_fb'], 'publish_tw' => $_POST['publish_tw'], 'publish_fbp' => $_POST['publish_fbp'], 'publish_fbgp' => $_POST['publish_group']);
if (is_array($fields = makeTimes($fields))) {
if ($_POST['edit'] == true) {
unset($fields['userid']);
if ($hdb->doUpdate($table, $fields, " id=" . $hdb->quote($_POST['mes_id']) . " AND userid=" . $hdb->quote($userid))) {
$return = array("e" => 0, "c" => array("i" => $_POST['mes_id'], "m" => $fields['message'], "p" => $fields['img'], "ts_es" => formatTimeStamp($fields['time_start']), "ts_en" => date('Y-m-d', $fields['time_start']), "te_es" => formatTimeStamp($fields['time_end']), "te_en" => date('Y-m-d', $fields['time_end']), "t_p" => $fields['img'], "d" => $fields['days'], "h" => formatHour($fields['hour']), "tw" => $fields['publish_tw'], "fb" => $fields['publish_fb'], "fbp" => $fields['publish_fbp'], "gp" => $fields['publish_fbgp']));
} else {
error_log($hdb->errorInfo());
$return = array("e" => 2);
}
} else {
if ($hdb->doInsert($table, $fields)) {
$return = array("e" => 0, "c" => array("i" => $hdb->lastInsertId(), "m" => $fields['message'], "p" => $fields['img'], "ts_es" => formatTimeStamp($fields['time_start']), "ts_en" => date('Y-m-d', $fields['time_start']), "te_es" => formatTimeStamp($fields['time_end']), "te_en" => date('Y-m-d', $fields['time_end']), "t_p" => $fields['img'], "d" => $fields['days'], "h" => formatHour($fields['hour']), "tw" => $fields['publish_tw'], "fb" => $fields['publish_fb'], "fbp" => $fields['publish_fbp'], "gp" => $fields['publish_fbgp']));
} else {
error_log($hdb->errorInfo());
$return = array("e" => 2);
}
}
} else {
$return = array("e" => $fields);
$fbh = new Handler_Facebook();
$hsc = new Handler_NewSocialConnection();
$db = new bd();
$permissions = ['user_posts', 'publish_actions', 'user_photos', 'manage_pages', 'publish_pages'];
if ($info = $fbh->javascriptCallbackManager($permissions)) {
$uid = $info['user_id'];
$at = $info['access_token'];
$table = "manager_fb_acc";
$condition = " user_id=" . $uid;
if ($result = $db->doSingleSelect($table, $condition)) {
//account already belongs to a user
if ($info["e"]) {
//some error, could mean a lot of things, but whichever the case we need to expire all the accounts.
$fbh->revokePermissions($at, array());
$fields = array('expires_at' => 1, 'expired' => 1);
$db->doUpdate($table, $fields, $condition);
$return = array("e" => 2);
} else {
$ea = $info['expires_at'];
$fields = array('access_token' => $at, 'expires_at' => $ea, 'expired' => 0);
$db->doUpdate($table, $fields, $condition);
switch ($login) {
case 0:
$return = array("e" => 1);
break;
case 1:
$userid = $result['userid'];
require_once "../../clases/usuarios.php";
$us = new usuario($userid);
$us->ingresoUsuarioPorID();
$hsc->clearFlow();
public function actualizarPublicacion($parametros, $monto, $fotos)
{
$bd = new bd();
$foto = new fotos();
$condicion = "id={$this->id}";
$params["titulo"] = ucwords(strtolower($params["titulo"]));
$result = $bd->doUpdate("publicaciones", $parametros, $condicion);
$params["monto"] = $monto;
$this->setMonto($monto);
$foto->path = "../../" . $foto->path;
$listaFotos = $bd->doFullSelect("fotosxpublicaciones", "publicaciones_id={$this->id}");
$result = $bd->query("delete from fotosxpublicaciones where publicaciones_id={$this->id}");
$ultimafoto = $bd->query("select MAX(id) as ultimo from fotos");
foreach ($ultimafoto as $key) {
$ultima = $key["ultimo"];
}
$i = 0;
$fila = 0;
foreach ($fotos as $data) {
if (substr($data, 0, 10) == "data:image") {
$i++;
$nueva = $ultima + $i;
$data_url = $data;
$data_url = str_replace(" ", "+", $data_url);
$filteredData = substr($data_url, strpos($data_url, ",") + 1);
//Decodificar la dataurl
$unencodedData = base64_decode($filteredData);
$bd->doInsert("fotos", array("id" => $nueva, "ruta" => "galeria/fotos/2015/12/"));
$bd->doInsert("fotosxpublicaciones", array("fotos_id" => $nueva, "publicaciones_id" => $this->id));
//subir la imagen
$ruta = "../../../galeria/fotos/2015/12/{$nueva}.png";
file_put_contents($ruta, $unencodedData);
} else {
$bd->doInsert("fotosxpublicaciones", array("fotos_id" => $listaFotos[$fila]["fotos_id"], "publicaciones_id" => $listaFotos[$fila]["publicaciones_id"]));
$fila++;
}
}
return true;
}
function actualiza()
{
$bd = new bd();
$publi = new publicaciones($_POST["id"]);
$monto = $_POST["monto"];
$publi->setMonto($monto);
$bd->doUpdate("publicaciones", array("titulo" => $_POST["titulo"], "stock" => $_POST["stock"], "monto" => $monto), "id={$_POST["id"]}");
}
function loadSession()
{
$bd = new bd();
$foto = new fotos();
if (!isset($_SESSION)) {
session_start();
}
$result = $bd->doSingleSelect("usuarios_accesos", "usuarios_id={$_POST["id"]}");
$_SESSION["id"] = $result["usuarios_id"];
$_SESSION["seudonimo"] = $result["seudonimo"];
$_SESSION["nivel"] = $result["nivel"];
$_SESSION["fotoperfil"] = $foto->buscarFotoUsuario($result["usuarios_id"]);
$_SESSION["id_rol"] = $result["id_rol"];
$bd->doUpdate("usuarios_accesos", array("bandera" => 0), "usuarios_id={$_POST["id"]}");
echo "OK";
}
public function setNewPassword($user, $clave)
{
$bd = new bd();
$clave = hash("sha256", $clave);
$actualizar = array('password' => $clave);
//$parametro=$actualizar["password"]=$clave;
$condicion = "usuarios_id={$user}";
$result = $bd->doUpdate($this->a_table, $actualizar, $condicion);
return $result;
}
public function updateUserGeneral($usuarios_id, $seudonimo = NULL, $email = NULL, $password = NULL, $id_rol = NULL)
{
$bd = new bd();
$actualizar = array('seudonimo' => $seudonimo, 'email' => $email, 'id_rol' => $id_rol);
//si cambiaron la contrase�a
if (!empty($password)) {
$password = hash("sha256", $password);
$actualizar['password'] = $password;
}
$condicion = "usuarios_id={$usuarios_id}";
$result = $bd->doUpdate($this->a_table, $actualizar, $condicion);
return $result;
}
public function __set($property, $value)
{
if (property_exists($this, $property)) {
$bd = new bd();
$bd->doUpdate($this->table, array($property => $value));
$this->{$property} = $value;
}
}
<?php
require_once "../../clases/bd.php";
$db = new bd();
session_start();
$uid = $_SESSION['id'];
$pid = $db->quote($_POST['id']);
$tw = $_POST['tw'] == 1 ? 1 : 0;
$fb = $_POST['fb'] == 1 ? 1 : 0;
$fbp = $_POST['fbp'] == 1 ? 1 : 0;
$gp = $_POST['gp'] == 1 ? 1 : 0;
$des = $_POST['des'];
$tabla = "publicaciones";
$fields = array("publicar_twitter" => $tw, "publicar_facebook" => $fb, "publicar_fanpage" => $fbp, "publicar_grupo" => $gp, "manager_des" => $des);
if ($db->doUpdate($tabla, $fields, " id={$pid} AND usuarios_id={$uid} ")) {
$return = array("e" => 0);
} else {
$return = array("e" => 1);
}
echo json_encode($return);
