Example #1
0
 public function postCrearCuenta()
 {
     // captcha instance of the login page
     $captcha = $this->getLoginCaptchaInstance();
     // validate the user-entered Captcha code when the form is submitted
     $code = Input::get('CaptchaCode');
     $isHuman = $captcha->Validate($code);
     if ($isHuman) {
         if (Input::get("politicas") == false) {
             return Redirect::back()->withInput(Input::except('password'))->withErrors(array('politicas' => 'Se deben aceptar las politicas de uso'));
         }
         if (Input::get("password") != Input::get("password_rep") && strlen(Input::get("password")) > 0 && strlen(Input::get("password_rep")) > 0) {
             return Redirect::back()->withInput(Input::except('password'))->withErrors(array('pass' => 'Las contraseñas no coinciden'));
         }
         $alia = new Alia();
         $alia->nombre = Input::get("alias");
         $alia->correo = Input::get("alias");
         $alia->password = Input::get("password");
         $alia->pais = Input::get("pais");
         $alia->estado = Input::get("estado");
         if ($alia->save()) {
             $usuarios = DB::select(DB::raw("\n\t\t\t\t\t\t\t\t\t\t\t\t\tSELECT idAlias, password, nombre, correo, pais, estado\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM alias\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE correo = '{$alia->correo}'\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND password = '******'\n\t\t\t\t\t\t\t\t\t\t\t\t"));
             $usuario = $usuarios[0];
             //$usuario->ubicacion
             $usuario->front = array('nombre' => $usuario->nombre, 'correo' => $usuario->correo, 'pais' => $usuario->pais, 'estado' => $usuario->estado);
             Session::put('usuario', $usuario);
             return Response::json(array('ok' => 1));
             //;Redirect::to('/principal');
         }
         return Redirect::back()->withInput(Input::except('password'))->withErrors($alia->getErrors());
     } else {
         return Redirect::back()->withInput(Input::except('password'))->withErrors("Codigo incorrecto. Intente de nuevo.");
     }
 }
Example #2
0
        $data['posts'][$i]->fotos = $fotos_posts;
        $comm_posts = DB::select(DB::raw("\n\t\t\t\t\t\t\t\t\t\tSELECT a.idComentarioPost, a.comentario, b.nombre usuario, a.created_at \n\t\t\t\t\t\t\t\t\t\tFROM comentarios_posts a\n\t\t\t\t\t\t\t\t\t\tINNER JOIN alias b\n\t\t\t\t\t\t\t\t\t\tON a.idAlias = b.idAlias\n\t\t\t\t\t\t\t\t\t\tWHERE a.idPost = {$idPost}\n\t\t\t\t\t\t\t\t\t\tORDER BY a.created_at DESC\n\t\t\t\t\t\t\t\t\t"));
        $data['posts'][$i]->comentarios = $comm_posts;
        $subcomm_posts = DB::select(DB::raw("\n\t\t\t\t\t\t\t\t\t\tSELECT \ta.idSubcomentario, a.link_evi, a.comentario, a.video, b.nombre usuario,\n\t\t\t\t\t\t\t\t\t\t\t\tCOALESCE(c.siconf, 0) com_siconf, COALESCE(c.noconf, 0) com_noconf, a.created_at,\n\n\t\t\t\t\t\t\t\t\t\t\t\tROUND(COALESCE(vid_corazon, 0)/5) vid_corazon, ROUND(COALESCE(vid_estrella, 0)/4) vid_estrella, \n\t\t\t\t\t\t\t\t\t\t\t\tROUND(COALESCE(vid_blike, 0)/3) vid_blike, ROUND(COALESCE(vid_carita, 0)/2) vid_carita, ROUND(COALESCE(vid_cake, 0)/1) vid_cake,\n\t\t\t\t\t\t\t\t\t\t\t\tROUND(COALESCE(vid_caca, 0)/5) vid_caca, ROUND(COALESCE(vid_craneo, 0)/4) vid_craneo, ROUND(COALESCE(vid_bug, 0)/3) vid_bug, \n\t\t\t\t\t\t\t\t\t\t\t\tROUND(COALESCE(vid_gota, 0)/2) vid_gota, ROUND(COALESCE(vid_enojo, 0)/1) vid_enojo,\n\n\t\t\t\t\t\t\t\t\t\t\t\tROUND(COALESCE(com_corazon, 0)/5) com_corazon, ROUND(COALESCE(com_estrella, 0)/4) com_estrella, \n\t\t\t\t\t\t\t\t\t\t\t\tROUND(COALESCE(com_blike, 0)/3) com_blike, ROUND(COALESCE(com_carita, 0)/2) com_carita, ROUND(COALESCE(com_cake, 0)/1) com_cake,\n\t\t\t\t\t\t\t\t\t\t\t\tROUND(COALESCE(com_caca, 0)/5) com_caca, ROUND(COALESCE(com_craneo, 0)/4) com_craneo, ROUND(COALESCE(com_bug, 0)/3) com_bug, \n\t\t\t\t\t\t\t\t\t\t\t\tROUND(COALESCE(com_gota, 0)/2) com_gota, ROUND(COALESCE(com_enojo, 0)/1) com_enojo\n\t\t\t\t\t\t\t\t\t\tFROM subcomentarios a\n\t\t\t\t\t\t\t\t\t\tINNER JOIN alias b\n\t\t\t\t\t\t\t\t\t\tON a.idAlias = b.idAlias\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN \t(\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tSELECT \tSUM(CASE confiable WHEN 1 THEN 1 ELSE 0 END) siconf,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSUM(CASE confiable WHEN 0 THEN 1 ELSE 0 END) noconf,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ttipo, idRel\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM confiables\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE tipo IN (6, 7)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY tipo, idRel\n\t\t\t\t\t\t\t\t\t\t\t\t\t) c\n\t\t\t\t\t\t\t\t\t\tON a.idSubcomentario = c.idRel\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN \t(\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tSELECT \tidSubcomentario,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSUM(COALESCE(corazon, 0)) vid_corazon, SUM(COALESCE(estrella, 0)) vid_estrella, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSUM(COALESCE(blike, 0)) vid_blike, SUM(COALESCE(carita, 0)) vid_carita, SUM(COALESCE(cake, 0)) vid_cake,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSUM(COALESCE(caca, 0)) vid_caca, SUM(COALESCE(craneo, 0)) vid_craneo, SUM(COALESCE(bug, 0)) vid_bug, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSUM(COALESCE(gota, 0)) vid_gota, SUM(COALESCE(enojo, 0)) vid_enojo\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM ranks_subcomentarios\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE tipo = 2\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY idSubcomentario\n\t\t\t\t\t\t\t\t\t\t\t\t\t) d\n\t\t\t\t\t\t\t\t\t\tON a.idSubcomentario = d.idSubcomentario\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN \t(\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tSELECT \tidSubcomentario,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSUM(COALESCE(corazon, 0)) com_corazon, SUM(COALESCE(estrella, 0)) com_estrella, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSUM(COALESCE(blike, 0)) com_blike, SUM(COALESCE(carita, 0)) com_carita, SUM(COALESCE(cake, 0)) com_cake,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSUM(COALESCE(caca, 0)) com_caca, SUM(COALESCE(craneo, 0)) com_craneo, SUM(COALESCE(bug, 0)) com_bug, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSUM(COALESCE(gota, 0)) com_gota, SUM(COALESCE(enojo, 0)) com_enojo\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM ranks_subcomentarios\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE tipo = 1\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY idSubcomentario\n\t\t\t\t\t\t\t\t\t\t\t\t\t) e\n\t\t\t\t\t\t\t\t\t\tON a.idSubcomentario = e.idSubcomentario\n\t\t\t\t\t\t\t\t\t\tWHERE a.idPost = {$idPost}\n\t\t\t\t\t\t\t\t\t\tORDER BY a.created_at DESC\n\t\t\t\t\t\t\t\t\t"));
        $data['posts'][$i]->subcomentarios = $subcomm_posts;
        for ($j = 0; $j < count($data['posts'][$i]->subcomentarios); $j++) {
            $idSubcomentario = $data['posts'][$i]->subcomentarios[$j]->idSubcomentario;
            $data['posts'][$i]->subcomentarios[$j]->fotos = DB::select(DB::raw("\n\t\t\t\t\t\t\t\t\t\tSELECT idSubcomentarioFoto, idSubcomentario, imagen, created_at \n\t\t\t\t\t\t\t\t\t\tFROM subcomentarios_fotos\n\t\t\t\t\t\t\t\t\t\tWHERE idSubcomentario = {$idSubcomentario}\n\t\t\t\t\t\t\t\t\t\tORDER BY created_at DESC\n\t\t\t\t\t\t\t\t\t"));
        }
    }
    // dd($data);
    return View::make('perfil')->with('data', $data);
});
Route::get('/eliminar_perfil/{id}', function () {
    $idAlias = Session::get('usuario')->idAlias;
    Alia::where('idAlias', '=', $idAlias)->delete();
    return Redirect::to('/logout');
});
Route::get('/update_perfil/{id}', function ($id) {
    $idAlias = Session::get('usuario')->idAlias;
    $perfil = DB::table('perfiles')->where('idAlias', '=', $idAlias)->where('idPerfil', '=', $id)->first();
    $apods = DB::table('apodos_publicos')->where('idPerfil', '=', $id)->get();
    $masks = DB::table('mascaras_publicas')->where('idPerfil', '=', $id)->get();
    $perfil->apods = $apods;
    $apodos = '';
    for ($i = 0; $i < count($apods); $i++) {
        $apodos .= $apods[$i]->apodo . ', ';
    }
    $perfil->apodos = $apodos;
    $perfil->masks = $masks;
    $mascaras = '';
Example #3
0
 public function run()
 {
     DB::table('alias')->delete();
     Alia::create(array('nombre' => 'Jax Destructor de Mundos', 'password' => '123', 'pais' => 'Mexico', 'estado' => 'DF', 'correo' => '*****@*****.**'));
     Alia::create(array('nombre' => 'ok', 'password' => 'ok', 'pais' => 'Mexico', 'estado' => 'DF', 'correo' => 'ok'));
 }