Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <a_samp> // Dossier pawno/include
- #include <a_mysql> // Idem.
- /* On aére le code.
- */
- // Place aux defines pour la connexion à la base de données.
- #define SQL_HOTE "" // L'hote de la base de données.
- #define SQL_UTILISATEUR "" // L'user de la base de données.
- #define SQL_MOTDEPASSE "" // Le mot de passe qui coïncide pour la connexion à la base de données.
- #define SQL_DATABASE "" // Le nom de la base de données qui contient les données.
- #define SQL_TABLE "" // La table spécifique contenant les comptes.
- /* On aére le code.
- */
- // Les new.
- new bool:ISCONNECTED[MAX_PLAYERS];
- new SKINS[MAX_PLAYERS];
- new Float:POSITIONS[3]; // Nombre de positions énumérées dans un tableau d'où le [3].
- /* On aére le code.
- */
- // Les defines concernant les dialogs.
- #define DIALOGREGISTER 5
- #define DIALOGLOGIN 10
- #define CONNEXIONMSG "{FF0000}Nous vous souhaitons la bienvenue sur notre serveur."
- #define ENREGISTREMENTMSG "{FF0000}Nous vous souhaitons la bienvenue sur notre serveur, veuillez vous enregistrer."
- new ACCOUNTUPDATE[1024];
- // Passons aux stocks.
- stock UPDATESQL(QUERY[])
- {
- new UQUERY[256];
- format(UQUERY, sizeof(UQUERY), "%s", QUERY);
- ACCOUNTUPDATE = UQUERY;
- }
- stock UPDATEVARINT(QUERY[], VARIABLE, bool:LAST)
- {
- if(!LAST)
- {
- format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s `%s` = '%d',", ACCOUNTUPDATE, QUERY, VARIABLE);
- }
- else format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s `%s` = '%d'", ACCOUNTUPDATE, QUERY, VARIABLE);
- }
- stock UPDATEVARCHAR(QUERY[], VARIABLE[], bool:LAST)
- {
- if(!LAST)
- {
- format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s `%s` = '%d',", ACCOUNTUPDATE, QUERY, VARIABLE);
- }
- else format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s `%s` = '%d'", ACCOUNTUPDATE, QUERY, VARIABLE);
- }
- stock UPDATEWHERE(PLAYID)
- {
- new NOM[MAX_PLAYER_NAME];
- GetPlayerName(PLAYID, NOM, sizeof(NOM));
- format(ACCOUNTUPDATE, sizeof(ACCOUNTUPDATE), "%s WHERE `NOM` = '%s'", ACCOUNTUPDATE, NOM);
- }
- stock SENDQUERY()
- {
- mysql_query(ACCOUNTUPDATE);
- printf("%s", ACCOUNTUPDATE);
- ACCOUNTUPDATE = "";
- }
- stock ENREGISTREMENT(PLAYID, PASS[])
- {
- new QUERY[256], NOM[MAX_PLAYER_NAME], IP[16];
- GetPlayerName(PLAYID, NOM, sizeof(NOM));
- GetPlayerIp(PLAYID, IP, sizeof(IP));
- ISCONNECTED[PLAYID] = true;
- 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);
- mysql_query(QUERY);
- return 1;
- }
- stock DISCONNECT(PLAYID)
- {
- if(ISCONNECTED[PLAYID])
- {
- new IP[16], Float:POS[3];
- GetPlayerIp(PLAYID, IP, sizeof(IP));
- GetPlayerPos(PLAYID, POS[0], POS[1], POS[2]);
- UPDATESQL("UPDATE `"SQL_TABLE"` SET");
- UPDATEVARCHAR("IP", IP, false);
- UPDATEVARINT("SKINS", GetPlayerSkin(PLAYID), false);
- UPDATEVARINT("SCORE", GetPlayerScore(PLAYID), false);
- UPDATEVARINT("PX", floatround(POS[0]), false);
- UPDATEVARINT("PY", floatround(POS[1]), false);
- UPDATEVARINT("PZ", floatround(POS[2]), false);
- ISCONNECTED[PLAYID] = false;
- UPDATEVARINT("CONNECTED", 0, true);
- UPDATEWHERE(PLAYID);
- SENDQUERY();
- return 1;
- }
- return 1;
- }
- stock LOGIN(PLAYID)
- {
- new QUERY[1024], NOM[MAX_PLAYER_NAME], SAVS[20];
- GetPlayerName(PLAYID, NOM, sizeof(NOM));
- format(QUERY, sizeof(QUERY), "SELECT * FROM `"SQL_TABLE"` WHERE `NOM` = '%s'", NOM);
- mysql_query(QUERY);
- mysql_store_result();
- // Boucle
- while(mysql_fetch_row_format(QUERY, "|"))
- {
- mysql_fetch_field_row(SAVS, "SKINS"); SKINS[PLAYID] = strval(SAVS);
- mysql_fetch_field_row(SAVS, "SCORE"); SetPlayerScore(PLAYID, strval(SAVS));
- mysql_fetch_field_row(SAVS, "PX"); POSITIONS[0] = strval(SAVS);
- mysql_fetch_field_row(SAVS, "PY"); POSITIONS[1] = strval(SAVS);
- mysql_fetch_field_row(SAVS, "PZ"); POSITIONS[2] = strval(SAVS);
- }
- mysql_free_result();
- new SCDQUERY[128];
- format(SCDQUERY, sizeof(SCDQUERY), "UPDATE `"SQL_TABLE"` SET `CONNECTED` = `1` WHERE `NOM` = '%s'", NOM);
- mysql_query(SCDQUERY);
- ISCONNECTED[PLAYID] = true;
- TogglePlayerSpectating(PLAYID, true);
- return 1;
- }
- public OnFilterScriptInit()
- {
- mysql_connect(SQL_HOTE, SQL_UTILISATEUR, SQL_DATABASE, SQL_MOTDEPASSE);
- mysql_debug(true);
- if(!mysql_ping())
- {
- print("Une erreur est survenue à la connexion de la base de données où du serveur.");
- print("Veuillez corriger les accès à la base de données où regarder si le port 80 n'est pas déjà utilisé.");
- }
- else
- {
- print("La connexion SQL est bien accordée au serveur.");
- }
- // Ça va faire la création de la table si elle n'existe pas, et différentes tâches.
- 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))");
- return 1;
- }
- public OnFilterScriptExit()
- {
- return 1;
- }
- public OnPlayerConnect(playerid)
- {
- new QUERY[256], NOM[MAX_PLAYER_NAME];
- GetPlayerName(playerid, NOM, sizeof(NOM));
- TogglePlayerSpectating(playerid, true);
- format(QUERY, sizeof(QUERY), "SELECT NOM FROM `"SQL_TABLE"` WHERE NOM = '%s'", NOM);
- mysql_query(QUERY);
- mysql_store_result();
- new ROWS = mysql_num_rows();
- if(!ROWS)
- {
- ShowPlayerDialog(playerid, DIALOGREGISTER, DIALOG_STYLE_PASSWORD, "Enregistrement", ENREGISTREMENTMSG, "Enregistrer", "");
- mysql_free_result();
- }
- else if(ROWS == 1)
- {
- ShowPlayerDialog(playerid, DIALOGLOGIN, DIALOG_STYLE_PASSWORD, "Connexion", CONNEXIONMSG, "Connexion", "");
- mysql_free_result();
- }
- else if(ROWS > 1)
- {
- ShowPlayerDialog(playerid, DIALOGLOGIN+3, DIALOG_STYLE_PASSWORD, "Enregistrement", "Il y a déjà un compte à ce nom.", "", "");
- mysql_free_result();
- }
- return 1;
- }
- public OnPlayerSpawn(playerid)
- {
- SetPlayerSkin(playerid, SKINS[playerid]);
- if(POSITIONS[0] != 0 && POSITIONS[1] != 0 && POSITIONS[2] != 0)
- {
- SetPlayerPos(playerid, POSITIONS[0], POSITIONS[1], POSITIONS[2]);
- }
- return 1;
- }
- public OnPlayerDisconnect(playerid, reason)
- {
- DISCONNECT(playerid);
- return 1;
- }
- public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
- {
- if(dialogid == DIALOGREGISTER)
- {
- if(!response) return Kick(playerid);
- else if (!strlen(inputtext)) return Kick(playerid);
- if(strlen(inputtext))
- {
- new ESCA[100];
- mysql_real_escape_string(inputtext, ESCA);
- ENREGISTREMENT(playerid, inputtext);
- TogglePlayerSpectating(playerid, false);
- return 1;
- }
- else if(strlen(inputtext) < 5) return ShowPlayerDialog(playerid, DIALOGREGISTER, DIALOG_STYLE_PASSWORD, "Enregistrement", "Le mot de passe est trop court.", "Enregistrement", "Quitter");
- else if(strlen(inputtext) > 20) return ShowPlayerDialog(playerid, DIALOGREGISTER, DIALOG_STYLE_PASSWORD, "Enregistrement", "Le mot de passe est trop long.", "Enregistrement", "Quitter");
- return 1;
- }
- else if(dialogid == DIALOGLOGIN)
- {
- new QUERY[20], NOM[MAX_PLAYER_NAME], ESCA[100];
- GetPlayerName(playerid, NOM, sizeof(NOM));
- if(!response) return Kick(playerid);
- else if(!strlen(inputtext)) return Kick(playerid);
- else if(strlen(inputtext) <= 0) return Kick(playerid);
- mysql_real_escape_string(inputtext, ESCA);
- format(QUERY, sizeof(QUERY), "SELECT `NOM` FROM `"SQL_TABLE"` WHERE NOM = '%s' AND MDP = '%s'", NOM, ESCA);
- mysql_query(QUERY);
- mysql_store_result();
- new ROWS = mysql_num_rows();
- if(ROWS == 1)
- {
- LOGIN(playerid);
- mysql_free_result();
- }
- else if(ROWS > 1)
- {
- ShowPlayerDialog(playerid, DIALOGLOGIN, DIALOG_STYLE_PASSWORD, "Enregistrement", "Enregistrement", "", "Quitter");
- mysql_free_result();
- }
- else if(!ROWS)
- {
- ShowPlayerDialog(playerid, DIALOGLOGIN, DIALOG_STYLE_PASSWORD, "Connexion", "Le mot de passe est incorrect.", "Connexion", "Quitter");
- mysql_free_result();
- }
- return 1;
- }
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment