Guest User

Untitled

a guest
Sep 22nd, 2013
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.02 KB | None | 0 0
  1. #include <a_samp> // Dossier pawno/include
  2. #include <a_mysql> // Idem.
  3. /* On aére le code.
  4.  
  5. */
  6. // Place aux defines pour la connexion à la base de données.
  7. #define SQL_HOTE "" // L'hote de la base de données.
  8. #define SQL_UTILISATEUR "" // L'user de la base de données.
  9. #define SQL_MOTDEPASSE "" // Le mot de passe qui coïncide pour la connexion à la base de données.
  10. #define SQL_DATABASE "" // Le nom de la base de données qui contient les données.
  11. #define SQL_TABLE "" // La table spécifique contenant les comptes.
  12. /* On aére le code.
  13.  
  14. */
  15. // Les new.
  16. new bool:ISCONNECTED[MAX_PLAYERS];
  17. new SKINS[MAX_PLAYERS];
  18. new Float:POSITIONS[3]; // Nombre de positions énumérées dans un tableau d'où le [3].
  19. /* On aére le code.
  20.  
  21. */
  22. // Les defines concernant les dialogs.
  23. #define DIALOGREGISTER 5
  24. #define DIALOGLOGIN 10
  25.  
  26. #define CONNEXIONMSG "{FF0000}Nous vous souhaitons la bienvenue sur notre serveur."
  27. #define ENREGISTREMENTMSG "{FF0000}Nous vous souhaitons la bienvenue sur notre serveur, veuillez vous enregistrer."
  28.  
  29. new ACCOUNTUPDATE[1024];
  30.  
  31. // Passons aux stocks.
  32.  
  33. stock UPDATESQL(QUERY[])
  34. {
  35. new UQUERY[256];
  36. format(UQUERY, sizeof(UQUERY), "%s", QUERY);
  37. ACCOUNTUPDATE = UQUERY;
  38. }
  39.  
  40. stock UPDATEVARINT(QUERY[], VARIABLE, bool:LAST)
  41. {
  42. if(!LAST)
  43. {
  44. format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s `%s` = '%d',", ACCOUNTUPDATE, QUERY, VARIABLE);
  45. }
  46. else format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s `%s` = '%d'", ACCOUNTUPDATE, QUERY, VARIABLE);
  47. }
  48.  
  49. stock UPDATEVARCHAR(QUERY[], VARIABLE[], bool:LAST)
  50. {
  51. if(!LAST)
  52. {
  53. format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s `%s` = '%d',", ACCOUNTUPDATE, QUERY, VARIABLE);
  54. }
  55. else format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s `%s` = '%d'", ACCOUNTUPDATE, QUERY, VARIABLE);
  56. }
  57.  
  58. stock UPDATEWHERE(PLAYID)
  59. {
  60. new NOM[MAX_PLAYER_NAME];
  61. GetPlayerName(PLAYID, NOM, sizeof(NOM));
  62. format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s WHERE `NOM` = '%s'", ACCOUNTUPDATE, NOM);
  63. }
  64.  
  65. stock SENDQUERY()
  66. {
  67. mysql_query(ACCOUNTUPDATE);
  68. printf("%s", ACCOUNTUPDATE);
  69. ACCOUNTUPDATE = "";
  70. }
  71.  
  72. stock ENREGISTREMENT(PLAYID, PASS[])
  73. {
  74. new QUERY[256], NOM[MAX_PLAYER_NAME], IP[16];
  75. GetPlayerName(PLAYID, NOM, sizeof(NOM));
  76. GetPlayerIp(PLAYID, IP, sizeof(IP));
  77. ISCONNECTED[PLAYID] = true;
  78. format(QUERY, sizeof(QUERY), "INSERT INTO `"SQL_TABLE"` (NOM, MDP, IP, SKINS, SCORE, PX, PY, PZ, CONNECTED) VALUES ('%s', '%s', '%s', '70', '0', '0', '0', '0', '1')", NOM, PASS, IP);
  79. mysql_query(QUERY);
  80. return 1;
  81. }
  82.  
  83. stock DISCONNECT(PLAYID)
  84. {
  85. if(ISCONNECTED[PLAYID])
  86. {
  87. new IP[16], Float:POS[3];
  88. GetPlayerIp(PLAYID, IP, sizeof(IP));
  89. GetPlayerPos(PLAYID, POS[0], POS[1], POS[2]);
  90.  
  91. UPDATESQL("UPDATE `"SQL_TABLE"` SET");
  92.  
  93. UPDATEVARCHAR("IP", IP, false);
  94. UPDATEVARINT("SKINS", GetPlayerSkin(PLAYID), false);
  95. UPDATEVARINT("SCORE", GetPlayerScore(PLAYID), false);
  96.  
  97. UPDATEVARINT("PX", floatround(POS[0]), false);
  98. UPDATEVARINT("PY", floatround(POS[1]), false);
  99. UPDATEVARINT("PZ", floatround(POS[2]), false);
  100.  
  101. ISCONNECTED[PLAYID] = false;
  102.  
  103. UPDATEVARINT("CONNECTED", 0, true);
  104.  
  105. UPDATEWHERE(PLAYID);
  106. SENDQUERY();
  107. return 1;
  108. }
  109. return 1;
  110. }
  111.  
  112. stock LOGIN(PLAYID)
  113. {
  114. new QUERY[1024], NOM[MAX_PLAYER_NAME], SAVS[20];
  115. GetPlayerName(PLAYID, NOM, sizeof(NOM));
  116. format(QUERY, sizeof(QUERY), "SELECT * FROM `"SQL_TABLE"` WHERE `NOM` = '%s'", NOM);
  117. mysql_query(QUERY);
  118. mysql_store_result();
  119. // Boucle
  120. while(mysql_fetch_row_format(QUERY, "|"))
  121. {
  122. mysql_fetch_field_row(SAVS, "SKINS"); SKINS[PLAYID] = strval(SAVS);
  123. mysql_fetch_field_row(SAVS, "SCORE"); SetPlayerScore(PLAYID, strval(SAVS));
  124. mysql_fetch_field_row(SAVS, "PX"); POSITIONS[0] = strval(SAVS);
  125. mysql_fetch_field_row(SAVS, "PY"); POSITIONS[1] = strval(SAVS);
  126. mysql_fetch_field_row(SAVS, "PZ"); POSITIONS[2] = strval(SAVS);
  127. }
  128. mysql_free_result();
  129. new SCDQUERY[128];
  130. format(SCDQUERY, sizeof(SCDQUERY), "UPDATE `"SQL_TABLE"` SET `CONNECTED` = `1` WHERE `NOM` = '%s'", NOM);
  131. mysql_query(SCDQUERY);
  132. ISCONNECTED[PLAYID] = true;
  133. TogglePlayerSpectating(PLAYID, true);
  134. return 1;
  135. }
  136.  
  137. public OnFilterScriptInit()
  138. {
  139. mysql_connect(SQL_HOTE, SQL_UTILISATEUR, SQL_DATABASE, SQL_MOTDEPASSE);
  140. mysql_debug(true);
  141. if(!mysql_ping())
  142. {
  143. print("Une erreur est survenue à la connexion de la base de données où du serveur.");
  144. print("Veuillez corriger les accès à la base de données où regarder si le port 80 n'est pas déjà utilisé.");
  145. }
  146. else
  147. {
  148. print("La connexion SQL est bien accordée au serveur.");
  149. }
  150. // Ça va faire la création de la table si elle n'existe pas, et différentes tâches.
  151. mysql_query("CREATE TABLE `"SQL_TABLE"` (`NOM` char(30), `MDP` char(35), `IP` varchar(20), `SKINS` int(2), `SCORE` int(20), `PX` int(5), `PY` int(5), `PZ` int(5), `CONNECTED` int(2))");
  152. return 1;
  153. }
  154.  
  155. public OnFilterScriptExit()
  156. {
  157. return 1;
  158. }
  159.  
  160. public OnPlayerConnect(playerid)
  161. {
  162. new QUERY[256], NOM[MAX_PLAYER_NAME];
  163. GetPlayerName(playerid, NOM, sizeof(NOM));
  164. TogglePlayerSpectating(playerid, true);
  165. format(QUERY, sizeof(QUERY), "SELECT NOM FROM `"SQL_TABLE"` WHERE NOM = '%s'", NOM);
  166. mysql_query(QUERY);
  167. mysql_store_result();
  168. new ROWS = mysql_num_rows();
  169. if(!ROWS)
  170. {
  171. ShowPlayerDialog(playerid, DIALOGREGISTER, DIALOG_STYLE_PASSWORD, "Enregistrement", ENREGISTREMENTMSG, "Enregistrer", "");
  172. mysql_free_result();
  173. }
  174. else if(ROWS == 1)
  175. {
  176. ShowPlayerDialog(playerid, DIALOGLOGIN, DIALOG_STYLE_PASSWORD, "Connexion", CONNEXIONMSG, "Connexion", "");
  177. mysql_free_result();
  178. }
  179. else if(ROWS > 1)
  180. {
  181. ShowPlayerDialog(playerid, DIALOGLOGIN+3, DIALOG_STYLE_PASSWORD, "Enregistrement", "Il y a déjà un compte à ce nom.", "", "");
  182. mysql_free_result();
  183. }
  184. return 1;
  185. }
  186.  
  187. public OnPlayerSpawn(playerid)
  188. {
  189. SetPlayerSkin(playerid, SKINS[playerid]);
  190. if(POSITIONS[0] != 0 && POSITIONS[1] != 0 && POSITIONS[2] != 0)
  191. {
  192. SetPlayerPos(playerid, POSITIONS[0], POSITIONS[1], POSITIONS[2]);
  193. }
  194. return 1;
  195. }
  196.  
  197. public OnPlayerDisconnect(playerid, reason)
  198. {
  199. DISCONNECT(playerid);
  200. return 1;
  201. }
  202.  
  203. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  204. {
  205. if(dialogid == DIALOGREGISTER)
  206. {
  207. if(!response) return Kick(playerid);
  208. else if (!strlen(inputtext)) return Kick(playerid);
  209. if(strlen(inputtext))
  210. {
  211. new ESCA[100];
  212. mysql_real_escape_string(inputtext, ESCA);
  213. ENREGISTREMENT(playerid, inputtext);
  214. TogglePlayerSpectating(playerid, false);
  215. return 1;
  216. }
  217. else if(strlen(inputtext) < 5) return ShowPlayerDialog(playerid, DIALOGREGISTER, DIALOG_STYLE_PASSWORD, "Enregistrement", "Le mot de passe est trop court.", "Enregistrement", "Quitter");
  218. else if(strlen(inputtext) > 20) return ShowPlayerDialog(playerid, DIALOGREGISTER, DIALOG_STYLE_PASSWORD, "Enregistrement", "Le mot de passe est trop long.", "Enregistrement", "Quitter");
  219. return 1;
  220. }
  221. else if(dialogid == DIALOGLOGIN)
  222. {
  223. new QUERY[20], NOM[MAX_PLAYER_NAME], ESCA[100];
  224. GetPlayerName(playerid, NOM, sizeof(NOM));
  225. if(!response) return Kick(playerid);
  226. else if(!strlen(inputtext)) return Kick(playerid);
  227. else if(strlen(inputtext) <= 0) return Kick(playerid);
  228. mysql_real_escape_string(inputtext, ESCA);
  229. format(QUERY, sizeof(QUERY), "SELECT `NOM` FROM `"SQL_TABLE"` WHERE NOM = '%s' AND MDP = '%s'", NOM, ESCA);
  230. mysql_query(QUERY);
  231. mysql_store_result();
  232. new ROWS = mysql_num_rows();
  233. if(ROWS == 1)
  234. {
  235. LOGIN(playerid);
  236. mysql_free_result();
  237. }
  238. else if(ROWS > 1)
  239. {
  240. ShowPlayerDialog(playerid, DIALOGLOGIN, DIALOG_STYLE_PASSWORD, "Enregistrement", "Enregistrement", "", "Quitter");
  241. mysql_free_result();
  242. }
  243. else if(!ROWS)
  244. {
  245. ShowPlayerDialog(playerid, DIALOGLOGIN, DIALOG_STYLE_PASSWORD, "Connexion", "Le mot de passe est incorrect.", "Connexion", "Quitter");
  246. mysql_free_result();
  247. }
  248. return 1;
  249. }
  250. return 1;
  251. }
Advertisement
Add Comment
Please, Sign In to add comment