Guest User

MySQL Problem

a guest
Mar 5th, 2011
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 1.62 KB | None | 0 0
  1. public OnGameModeInit()
  2. {
  3.     mysql_debug(1);
  4.     ConnectMySQL();
  5.     DisableInteriorEnterExits();
  6.     AllowInteriorWeapons(true);
  7.     EnableStuntBonusForAll(false);
  8.     AllowAdminTeleport(false);
  9.     SetGameModeText("ParUni 4.0.0");
  10.     AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
  11.    
  12.     SetTimer("CheckMySQL", 30000, true); // Check MySQL Connection every 30 seconds.
  13.     return 1;
  14. }
  15.  
  16. public OnGameModeExit()
  17. {
  18.     mysql_close();
  19.     return 1;
  20. }
  21. public OnPlayerConnect(playerid)
  22. {
  23.     new Query[200], Pname[24], escpname[24];\
  24.     GetPlayerName(playerid, Pname, 24);
  25.     mysql_real_escape_string(Pname, escpname);
  26.     format(Query, sizeof(Query), "SELECT * FROM `Players` WHERE `user` = '%s'", escpname);
  27.     mysql_query(Query);
  28.     mysql_store_result();
  29.     if(mysql_num_rows() <= 0)
  30.     {
  31.         AccountExists[playerid] = 0; // NOT REGISTERED
  32.     }
  33.     else
  34.     {
  35.         AccountExists[playerid] = 1; //REGISTERED
  36.     }
  37.     mysql_free_result();
  38.     return 1;
  39. }
  40.  
  41. public OnPlayerDisconnect(playerid, reason)
  42. {
  43.     SaveAccount(playerid);
  44.     LoggedIn[playerid] = 0;
  45.     return 1;
  46. }
  47. publicf ConnectMySQL()
  48. {
  49.     if(mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_DB,MYSQL_PASS))
  50.     {
  51.         print("[MySQL] MySQL database successfully loaded.");
  52.     }
  53.     else
  54.     {
  55.         print("[MySQL] MySQL database failed to load.");
  56.     }
  57. }
  58.  
  59. publicf CreateAccount(playername, password[])
  60. {
  61.     new query[128];
  62.     format(query, sizeof(query), "INSERT INTO Players (Username, Password) VALUES ('%s', '%s')", playername, password);
  63.     mysql_query(query);
  64.     return 1;
  65. }
  66. publicf CheckMySQL()
  67. {
  68.     if(mysql_ping() == -1)
  69.     {
  70.         return 0;
  71.     }
  72.     return 1;
  73. }
Advertisement
Add Comment
Please, Sign In to add comment