Guest User

SAMP help

a guest
Mar 26th, 2013
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.66 KB | None | 0 0
  1. #include <a_samp>
  2. #include <zcmd>
  3. #include <a_mysql>
  4. #include <sscanf2>
  5.  
  6. #define mysql_host "localhost"
  7. #define mysql_user "admin"
  8. #define mysql_password "default"
  9. #define mysql_database "db"
  10.  
  11. enum playerdata
  12. {
  13. pName[24],
  14. pMoney
  15. };
  16. new pInfo[MAX_PLAYERS][playerdata];
  17.  
  18. stock SetPlayerMoney(playerid, cash)
  19. {
  20. ResetPlayerMoney(playerid);
  21. return GivePlayerMoney(playerid, cash);
  22. }
  23.  
  24. stock Login(playerid)
  25. {
  26. new query[500];
  27. format(query, 500, "SELECT * FROM 'playerdata' WHERE 'user' = '%s'", pInfo[playerid][pName]);
  28. mysql_query(query);
  29. mysql_store_result();
  30. while(mysql_fetch_row(query))
  31. {
  32. mysql_fetch_field_row("money", pInfo[playerid][pName]); GivePlayerMoney(playerid, pInfo[playerid][pMoney]);
  33. }
  34. mysql_free_result();
  35. }
  36.  
  37. stock CreatePlayer(playerid)
  38. {
  39. new query[500];
  40. format(query, 500, "INSERT INTO 'playerdata' ('user', 'money') VALUES('%s', 0)", pInfo[playerid][pName]);
  41. mysql_query(query);
  42. }
  43.  
  44. stock SavePlayer(playerid)
  45. {
  46. new query[500];
  47. format(query, 500, "UPDATE 'playerdata' SET 'money' = '%d' WHERE 'user' = '%s'", pInfo[playerid][pName]);
  48. mysql_query(query);
  49. }
  50.  
  51. main()
  52. {
  53. print("\n----------------------------------");
  54. print(" Blank Gamemode by your name here");
  55. print("----------------------------------\n");
  56. }
  57.  
  58. public OnGameModeInit()
  59. {
  60. SetGameModeText("Learning MySQL :)");
  61. AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
  62. // MYSQL //
  63. new Connection = mysql_connect(mysql_host, mysql_user, mysql_database, mysql_password);
  64. if(Connection)
  65. {
  66. new dest[200];
  67. mysql_stat(dest);
  68. printf(dest);
  69. printf(">> MySQL connection successfully initialized");
  70. }
  71. mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), money INT(20) )");
  72. return 1;
  73. }
  74.  
  75. public OnGameModeExit()
  76. {
  77. mysql_close();
  78. return 1;
  79. }
  80.  
  81. public OnPlayerRequestClass(playerid, classid)
  82. {
  83. SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
  84. SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
  85. SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
  86. return 1;
  87. }
  88.  
  89. public OnPlayerConnect(playerid)
  90. {
  91. GetPlayerName(playerid, pInfo[playerid][pName], 24);
  92. mysql_real_escape_string(pInfo[playerid][pName], pInfo[playerid][pName]);
  93. new query[500];
  94. format(query, 500, "SELECT 'user' FROM 'playerdata' WHERE 'user' = %s", pInfo[playerid][pName]);
  95. mysql_query(query);
  96. mysql_store_result();
  97. if(mysql_num_rows() > 0)
  98. {
  99. Login(playerid);
  100. }
  101. else
  102. {
  103. CreatePlayer(playerid);
  104. }
  105. mysql_free_result();
  106. return 1;
  107. }
  108.  
  109. public OnPlayerDisconnect(playerid, reason)
  110. {
  111. SavePlayer(playerid);
  112. return 1;
  113. }
Advertisement
Add Comment
Please, Sign In to add comment