Advertisement
Niko_boy

mysql_start

Feb 14th, 2012
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 0.85 KB | None | 0 0
  1.  
  2. public mysql_start()
  3. {
  4.     mysql_debug(1);
  5.     if (mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DB))
  6.     {
  7.         print("+================================+");
  8.         print("|                                |");
  9.         print("| [MYSQL] Connection successful! |");
  10.         print("|                                |");
  11.         print("+================================+");
  12.     }
  13.     else
  14.     {
  15.         print("[MYSQL] There was an error connecting to the MYSQL server. Shit!");
  16.     }
  17.     return 1;
  18. }
  19.  
  20. public CheckSQL()
  21. {
  22.    new bool:connected;
  23.    if(mysql_ping() != 0)
  24.    {  connected = false;  }
  25.    else { connected = true; }
  26.  
  27.    if (connected == false)
  28.    {
  29.       print("[MYSQL] Lost connection to MYSQL server, Reconnecting...");
  30.       mysql_start();
  31.    }
  32.    return 1;
  33. }
  34.  
  35.  
  36. public SendQuery(query[])
  37. {
  38.    CheckSQL();
  39.    if (mysql_query(query)){}
  40.    else{return false;}
  41.    return 1;
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement