} $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); } } else { $return = array("e" => $message); } } else { $return = array("e" => 1); } } else {
public function volveraPublicar($parametros) { $bd = new bd(); $parametros["descripcion"] = $this->descripcion; $parametros["dias_garantia"] = $this->dias_garantia; $parametros["dafactura"] = $this->dafactura; $parametros["estienda"] = $this->estienda; $parametros["visitas_publicaciones_id"] = $this->visitas_publicaciones_id; $parametros["usuarios_id"] = $this->usuarios_id; $parametros["condiciones_publicaciones_id"] = $this->condiciones_publicaciones_id; $parametros["monto"] = $this->monto; $parametros["clasificados_id"] = $this->clasificados_id; $parametros["vencimientos_publicaciones_id"] = $this->vencimientos_publicaciones_id; $parametros["titulo"] = ucwords(strtolower($parametros["titulo"])); $result = $bd->doInsert($this->table, $parametros); if ($result) { $ultimoId = $bd->lastInsertId(); $tiempo = date("Y-m-d H:i:s", time()); $bd->doInsert("publicaciones_montos", array("fecha" => $tiempo, "monto" => $parametros["monto"], "publicaciones_id" => $ultimoId)); $bd->doInsert("publicacionesxstatus", array("fecha" => $tiempo, "publicaciones_id" => $ultimoId, "status_publicaciones_id" => 1)); $fotos = $bd->doFullSelect("fotosxpublicaciones", "publicaciones_id={$this->id}", "fotos_id"); foreach ($fotos as $f) { $bd->doInsert("fotosxpublicaciones", array("fotos_id" => $f['fotos_id'], "publicaciones_id" => $ultimoId)); } return $result; } }
public function crearFotoPort($id_usuario, $dataurl) { $bd = new bd(); if (substr($dataurl, 0, 4) == "data") { $this->ruta = $this->crearRuta(); $result = $bd->doInsert($this->table, array("id" => 0, "ruta" => substr($this->ruta, strpos($this->ruta, "/") + 1))); if ($result) { $this->id = $bd->lastInsertId(); $bd->doInsert($this->table_user, array("status" => "P", "usuarios_id" => $id_usuario, "fotos_id" => $this->id)); // fotos de portada se agregan con el estado PA (portada activa) $this->subirFoto($dataurl); return true; } else { return false; } } }
$bd->emptyTable("fotos"); $bd->emptyTable("usuarios"); $usuario = new usuario(); $foto = new fotos(); $i = 0; foreach ($naturales as $natural) { echo $usuario->datosUsuario($natural["direccion"], $natural["telefono"], $natural["descripcion"], rand(1, 24)); echo $usuario->datosNatural($natural["identificacion"], $natural["nombre"], $natural["apellido"], $natural["tipo"]); echo $usuario->datosAcceso(strtolower($natural["nombre"] . "_" . $natural["apellido"]), $natural["email"], $natural["nombre"] . $natural["apellido"]); echo $usuario->datosStatus(); echo showResult($usuario->crearUsuario()); if (rand(0, 1) == 0 and $i <= 100) { $i++; $ruta = $foto->crearRuta(); echo $bd->doInsert("fotos", array("id" => $i, "ruta" => substr($ruta, strpos($ruta, "/") + 1))); $fotoid = $bd->lastInsertId(); echo $bd->doInsert("fotos_usuarios", array("status" => "A", "usuarios_id" => $usuario->id, "fotos_id" => $fotoid)); } } foreach ($juridicos as $juridico) { echo $usuario->datosUsuario($juridico["direccion"], $juridico["telefono"], $juridico["descripcion"], rand(1, 24)); echo $usuario->datosJuridico($juridico["rif"], $juridico["razon_social"], $juridico["tipo"], rand(1, 40)); echo $usuario->datosAcceso($juridico["rif"], $juridico["email"], $juridico["rif"]); echo $usuario->datosStatus(); echo showResult($usuario->crearUsuario()); if (rand(0, 1) == 0 and $i <= 100) { $i++; $ruta = $foto->crearRuta(); $bd->doInsert("fotos", array("id" => $i, "ruta" => substr($ruta, strpos($ruta, "/") + 1))); $fotoid = $bd->lastInsertId(); echo $bd->doInsert("fotos_usuarios", array("status" => "A", "usuarios_id" => $usuario->id, "fotos_id" => $fotoid));
$db = new bd(); $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']; $timezone = $result['timezone']; if ($page = getPage($fbh, $at, $fpid)) { $fields = array('userid' => $userid, 'user_id' => $fpid, 'name' => $page['n'], 'access_token' => $page['at'], 'expired' => 0, 'timezone' => $timezone, 'img' => $page['p'], 'last_update' => time()); if ($db->doInsert($table, $fields)) { $return = array("e" => 0, "i" => $db->lastInsertId(), "n" => $page['n'], "p" => $page['p']); } else { $return = array("e" => 6); } } else { $return = array('e' => 3); } } catch (Exception $e) { $return = array('e' => 3); } } } else { $return = array('e' => 1); } echo json_encode($return);
public function crearUsuario() { if (isset($this->n_identificacion) xor isset($this->j_rif)) { if (isset($this->a_seudonimo)) { $bd = new bd(); $result = $bd->doInsert($this->u_table, $this->serializarDatos("u_")); if ($result == true) { $result = 0; $this->id = $bd->lastInsertId(); $hnsc = new Handler_NewSocialConnection(); if ($red_social = $hnsc->returnTableAndBody($this->id)) { if (!$bd->doInsert($red_social['table'], $red_social['fields'])) { error_log('Error occurred:' . implode(":", $bd->errorInfo())); } } if (isset($this->n_identificacion)) { $result += $bd->doInsert($this->n_table, $this->serializarDatos("n_", $this->u_table)); } else { $result += $bd->doInsert($this->j_table, $this->serializarDatos("j_", $this->u_table)); } $result += $bd->doInsert($this->a_table, $this->serializarDatos("a_", $this->u_table)); $result += $bd->doInsert($this->s_table, $this->serializarDatos("s_", array($this->s_f_table, $this->u_table))); if ($result >= 3) { return true; } else { return false; } } else { return false; } } else { throw new Exception("Error Usuario 004: No se han definido datos de acceso"); } } else { throw new Exception("Error Usuario 003: No se han definido datos Juridicos o Naturales"); } }