View difference between Paste ID: VpfXM0w2 and Ex89Cdn1

 
 //------------------------------------------------------------------[ Includes ]
 #include <a_samp>
 #include <a_mysql>
 #include <time>
 #include <file> // système de log par exemple
 #include <sscanf2>
 //-------------------------------------------------------------[Connexion ]
 #define mysql_host "127.0.0.1" //Has to be a string
 #define mysql_user "root" //Has to be a string
 #define mysql_password "" //There is none for wamp unless you set one.
-#define mysql_password "an1106" //There is none for wamp unless you set one.
+#define mysql_database "" //Has to be a string
-#define mysql_database "LSI-RP" //Has to be a string
+
 #define JoueursMax  GetMaxPlayers()
 #define MaxVoiture MAX_VEHICLES
 #define MaxObjets  MAX_OBJECTS
 //--------------------------------------------------------------------[ Colors ]
 #define Noir   "{000000}"
 #define Blanc   "{FFFFFF}"
 #define Gris   "{BFBFBF}"
 #define Rouge    "{FF0000}"
 #define Orange  "{FFA500}"
 #define Jaune  "{FFFF00}"
 #define Vert   "{008000}"
 #define Bleu    "{0000FF}"
 #define Violet  "{800080}"
 #define Teal    "{008080}"
 //--------------------------------------------------------------[ Milliseconds ]
 #define An    31536000000 // Day x 365
 #define Mois   2592000000  // Day x 30
 #define Semaine    604800000   // Day x 7
 #define Jour     86400000    // Hour x 24
 #define Heure    3600000     // Minute x 60
 #define Minute  60000       // Second x 60
 #define Seconde  1000        // Millisecond x 1000
 //-----------------------------------------------------------------[ Variables ]
 //--------------------------------------------------------------------[ Unused ]
 main() {}
 //--------------------------------------------------------------------[ Timers ]
 //----------------------------------------------------------[ Custom Functions ]
 //---------------------------------------------------------[ Default Callbacks ]
 public OnGameModeInit() {
 	mysql_connect(mysql_host,mysql_user,mysql_database ,mysql_password);
 	enum PlayerInfo
 	{
 	Username[23],
 	Password[24],
 	Argent
 	}
 	new PInfo[MAX_PLAYERS][PlayerInfo];
     return true;
 }
 
 public OnGameModeExit() {
     return true;
 }
 
 public OnPlayerConnect(playerid) {
 	new Query[80],pName[24],string[164];
 	GetPlayerName(playerid,pName,24);
 	format(Query,sizeof(Query),"SELECT `Username` FROM `Users` WHERE `Username` = '%s' LIMIT 1;",pName);
 	mysql_query(Query);
 	mysql_store_result();
 	if(mysql_num_rows() != 0)//if number of rows is different from 0 then continue
 		{
 		format(string,sizeof(string),"Hey, %s! \nYour account is registered.\nPlease enter the password to log in!",pName);
 		ShowPlayerDialog(playerid,0,DIALOG_STYLE_INPUT,"Lo g in",string,"Login","");
 		}
 	else
 		{
 		format(string,sizeof(string),"Hey, %s! \nYour account is not registered. \nPlease register to continue!",pName);
 		ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Re gister",string,"Register","");
 		}
 	mysql_free_result();
     return true;
 }
 
 public OnPlayerDisconnect(playerid, reason) {
     return true;
 }
 
 public OnPlayerRequestClass(playerid, classid) {
     return true;
 }
 
 public OnPlayerRequestSpawn(playerid) {
     return true;
 }
 
 public OnPlayerSpawn(playerid) {
     return true;
 }
 
 public OnPlayerDeath(playerid, killerid, reason) {
     return true;
 }
 
 public OnVehicleSpawn(vehicleid) {
     return true;
 }
 
 public OnVehicleDeath(vehicleid, killerid) {
     return true;
 }
 
 public OnPlayerText(playerid, text[]) {
     return true;
 }
 
 public OnPlayerCommandText(playerid, cmdtext[]) {
     OnPlayerText(playerid, cmdtext);
     return true;
 }
 
 public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger) {
     return true;
 }
 
 public OnPlayerExitVehicle(playerid, vehicleid) {
     return true;
 }
 
 public OnPlayerStateChange(playerid, newstate, oldstate) {
     return true;
 }
 
 public OnPlayerEnterCheckpoint(playerid) {
     return true;
 }
 
 public OnPlayerLeaveCheckpoint(playerid) {
     return true;
 }
 
 public OnPlayerEnterRaceCheckpoint(playerid) {
     return true;
 }
 
 public OnPlayerLeaveRaceCheckpoint(playerid) {
     return true;
 }
 
 public OnRconCommand(cmd[]) {
     return true;
 }
 
 public OnObjectMoved(objectid) {
     return true;
 }
 
 public OnPlayerObjectMoved(playerid, objectid) {
     return true;
 }
 
 public OnPlayerPickUpPickup(playerid, pickupid) {
     return true;
 }
 
 public OnVehicleMod(playerid, vehicleid, componentid) {
     return true;
 }
 
 public OnEnterExitModShop(playerid, enterexit, interiorid) {
     return true;
 }
 
 public OnVehiclePaintjob(playerid, vehicleid, paintjobid) {
     return true;
 }
 
 public OnVehicleRespray(playerid, vehicleid, color1, color2) {
     return true;
 }
 
 public OnVehicleDamageStatusUpdate(vehicleid, playerid) {
     return true;
 }
 
 public OnUnoccupiedVehicleUpdate(vehicleid, playerid, passenger_seat) {
     return true;
 }
 
 public OnPlayerSelectedMenuRow(playerid, row) {
     return true;
 }
 
 public OnPlayerExitedMenu(playerid) {
     return true;
 }
 
 public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid) {
     return true;
 }
 
 public OnPlayerKeyStateChange(playerid, newkeys, oldkeys) {
     return true;
 }
 
 public OnRconLoginAttempt(ip[], password[], success ) {
     return true;
 }
 
 public OnPlayerUpdate(playerid) {
     return true;
 }
 
 public OnPlayerStreamIn(playerid, forplayerid) {
     return true;
 }
 
 public OnPlayerStreamOut(playerid, forplayerid) {
     return true;
 }
 
 public OnVehicleStreamIn(vehicleid, forplayerid) {
     return true;
 }
 
 public OnVehicleStreamOut(vehicleid, forplayerid) {
     return true;
 }
 
 public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) {
 
 if(dialogid == Logindialog)
 {
 if(strlen(inputtext) == 0)
 {
 ShowPlayerDialog(playerid,Regdialog,DIALOG_STYLE_I NPUT,"Register - Entrez votre mdp","You are about to register a new account! \nChoississez un mdp \n","Register!","");
 }
 else
 {
 LoginPlayer(playerid,inputtext);
 }
 }
     return true;
 }
 
 public OnPlayerTakeDamage(playerid, issuerid, Float:amount, weaponid) {
     return true;
 }
 
 public OnPlayerGiveDamage(playerid, damagedid, Float:amount, weaponid) {
     return true;
 }
 
 public OnPlayerClickMap(playerid, Float:fX, Float:fY, Float:fZ) {
     return true;
 }
 
 public OnPlayerClickTextDraw(playerid, Text:clickedid) {
     return true;
 }
 
 public OnPlayerClickPlayerTextDraw(playerid, PlayerText:playertextid) {
     return true;
 }
 
 public OnPlayerClickPlayer(playerid, clickedplayerid, source) {
     return true;
 }
 
 public OnPlayerEditObject(playerid, playerobject, objectid, response, Float:fX, Float:fY, Float:fZ, Float:fRotX, Float:fRotY, Float:fRotZ ) {
     return true;
 }
 
 public OnPlayerEditAttachedObject(playerid, response, index, modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ ) {
     return true;
 }
 
 public OnPlayerSelectObject(playerid, type, objectid, modelid, Float:fX, Float:fY, Float:fZ) {
     return true;
 }
 
 
 
 
 
 
 stock LoginPlayer(playerid,const password[])
 {
 new EscapedText[60];
 mysql_real_escape_string(password, EscapedText);
 format(Query,sizeof(Query),"SELECT * FROM `Users` WHERE `Username` = '%s' AND `Password` = '%s'",GetPName(playerid),EscapedText);
 mysql_query(Query);
 mysql_store_result();
 if(mysql_num_rows() != 0)
 {
 SendClientMessage(playerid,green,"You have been logged in!");
 LoadStats(playerid);
 }
 else
 {
 SendClientMessage(playerid,red,"Wrong password!");
 Kick(playerid);
 }
 mysql_free_result();
 return 1;
 }
 
 
 
 
 stock LoadStats(playerid)
 {
 new pName[24],Query[80];
 GetPlayerName(playerid,pName,24);
 format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);
 mysql_query(Query);
 mysql_store_result();
 mysql_fetch_row_format(Query, "|");
 sscanf(Query, "e<p<|>s[24]s[23]i>", PInfo[playerid]);
 mysql_free_result();
 GivePlayerMoney(playerid,PInfo[playerid][Money]);
 return 1;
 }