public function verify_email($code)
 {
     try {
         $user = User::where('activation_code', '=', $code)->first();
         if ($user == null) {
             echo "Invalide verfication code";
             return;
         } elseif ($user->activated == 1) {
             return Redirec::route('myprofile');
         }
         $user->activated = 1;
         $user->save();
         $id = $user->id;
         Auth::login($user);
         //verify success and login user
         //create a profile record for this new user
         $profile = UserProfile::firstOrNew(array('id' => $id));
         $financial = FinancialProfile::firstOrNew(array('user_id' => $id));
         $profile->save();
         $financial->save();
         /*DB::table('users')
         			-> where('activation_code',$code)
         			-> update(array('activated'=>1));
         		}catch(Exception $e) {
         			echo $e -> getMessage();
         		}*/
     } catch (Exception $e) {
         echo $e->getMessage();
     }
     return Redirect::route('editProfile');
 }