fork download
copy 
  1. #region Include Classes
  2. using System;
  3. using System.Text;
  4. using System.Collections.Generic;
  5. using System.Linq;
  6. using System.Web;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Data;
  10. using MySql;
  11. using MySql.Web;
  12. using MySql.Data;
  13. using MySql.Data.Common;
  14. using MySql.Data.Entity;
  15. using MySql.Data.Entity.Properties;
  16. using MySql.Data.MySqlClient;
  17. using MySql.Data.MySqlClient.Authentication;
  18. using MySql.Data.MySqlClient.Properties;
  19. using MySql.Data.Types;
  20. #endregion
  21.  
  22.  
  23. namespace WebApplication1
  24. {
  25.     public partial class Default : System.Web.UI.Page
  26.     {
  27.         private string tmpStr = String.Empty;
  28.  
  29.         protected void Page_Load(object sender, EventArgs e)
  30.         {
  31.             try
  32.             {
  33.                 Default pageHandler = sender as Default;
  34.                 tmpStr = HttpUtility.UrlDecode(pageHandler.ClientQueryString);
  35.  
  36.                 if (tmpStr != String.Empty)
  37.                 {
  38.                     if (pageHandler.Request.HttpMethod == "GET")
  39.                     {
  40.                         if (pageHandler.Request.Params["method"] == "checkAuth")
  41.                         {
  42.                             string reqLogin = pageHandler.Request.Params["username"].ToString();
  43.                             string reqPass = pageHandler.Request.Params["password"].ToString();
  44.                             bool reqChecked = Convert.ToBoolean(pageHandler.Request.Params["checked"].ToString());
  45.  
  46.                             MySQLGear mysqlObject = new MySQLGear();
  47.                             MySqlConnection mysqlConn = mysqlObject.CreateConnection();
  48.                             bool userExists = Convert.ToBoolean(mysqlObject.MakeScalar(ref mysqlConn,
  49.                                 "SELECT COUNT(*) FROM `data_user` WHERE username='" + reqLogin + "' AND password='" + reqPass + "'"));
  50.  
  51.                             if (userExists)
  52.                             {
  53.                                 pageHandler.Response.Cookies.Add(new HttpCookie("sessionId", Guid.NewGuid().ToString()));
  54.                                 pageHandler.Response.Cookies.Add(new HttpCookie("clientIp", pageHandler.Request.UserHostAddress.ToString()));
  55.                                 pageHandler.Response.Cookies.Add(new HttpCookie("timeAuth", DateTime.Now.ToString()));
  56.  
  57.                                 Response.Redirect("Cabinet.aspx");
  58.                             }
  59.                             else
  60.                             {
  61.                                 Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('Такого пользователя - нет в базе данных!'); RedirectUser('Default.aspx');", true);
  62.                             }
  63.                         }
  64.                     }
  65.                     else if (pageHandler.Request.HttpMethod == "POST")
  66.                     {
  67.  
  68.                     }
  69.                 }
  70.             }
  71.             catch (Exception exc)
  72.             {
  73.                 exc.ToString();
  74.             }
  75.         }
  76.     }
  77. }
Not running #stdin #stdout 0s 0KB
comments ()
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/bQzCJd
language:
C# (gmcs 5.20.1)
created:
12 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!