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."); } }
$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 = '';
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')); }