Samp

#include <a_samp>

//Mysql
#define SQL_HOST     "localhost"
#define SQL_USER     "root"
#define SQL_DB       "samp"
#define SQL_PASS     "cambiala"
#include <a_mysql>
//forward MySQLUpdateFinish(query[], sqlplayerid);
//forward MySQLUpdateBuild(query[], sqlname);
//========


#pragma tabsize 0
#define registro                    0
main()
{
    print("\n----------------------------------");
    print(" Blank Gamemode by your name here");
    print("----------------------------------\n");
}

public OnGameModeInit()
{
    ConectarMySQL();
    SetGameModeText("Blank Script");
    return 1;
}

public OnGameModeExit()
{
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{

return 1;
}

public OnPlayerConnect(playerid)
{
new szQuery[128], szName[MAX_PLAYER_NAME];
GetPlayerName(playerid, szName, sizeof szName);
format(szQuery, sizeof szQuery, "SELECT * FROM Usuarios WHERE Nombre = '%s'", szName);
mysql_function_query(1, szQuery, true, "OnPlayerExists", "i", playerid);
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    return 1;
}

public OnPlayerSpawn(playerid)
{
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    return 1;
}

public OnVehicleSpawn(vehicleid)
{
    return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
    return 1;
}

public OnPlayerText(playerid, text[])
{

    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
    return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
    return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
    return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
    return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
    return 1;
}

public OnRconCommand(cmd[])
{
    return 1;
}

public OnPlayerRequestSpawn(playerid)
{
    return 1;
}

public OnObjectMoved(objectid)
{
    return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
    return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
    return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
    return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
    return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
    return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
    return 1;
}

public OnPlayerExitedMenu(playerid)
{
    return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
    return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
    return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
    return 1;
}

public OnPlayerUpdate(playerid)
{
    return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
    return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
    return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
    return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
 if (dialogid == registro)
   {
//new nombre[MAX_PLAYER_NAME], clave[256], query[1024];
//GetPlayerName(playerid, nombre, sizeof(nombre));
//format(clave, sizeof(clave), "%s", inputtext);
//format(query, sizeof(query), "INSERT INTO members (member_name, passwd, real_name) VALUES('%s', MD5('%s'), '%s')", nombre, clave, nombre);
//mysql_query(query);
}
    return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
    return 1;
}
stock ConectarMySQL()
{
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    mysql_debug(1);
    if(mysql_ping() == 1)
    {
        printf("\t\t[MYSQL]: Conexion Satisfactoria (DataBase: '%s')\n", SQL_DB);
    }
    else
    {
        printf("\t\t[MYSQL]: ERROR. Conexion Fallida (DataBase: '%s')\n", SQL_DB);
        SendRconCommand("exit");
    }
    return 1;
}
forward OnPlayerExists(playerid);
public OnPlayerExists(playerid)
{
    new iRows, iFields;
    cache_get_data(iRows, iFields);
    if(iRows)
    {
        SendClientMessage(playerid, -1, "Esta registrado");
    }
    else
    {
        ShowPlayerDialog(playerid, registro, DIALOG_STYLE_PASSWORD, "Registro", "Coloque su contraseña para crear su cuenta", "Registrar", "Cancelar");
    }
    return 1;
}