//------------------------------------------------------------------[ 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_database "" //Has to be a string
//-------------------------------------------------------------[ Server Limits ]
#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;
}