SAMP

enum playerdata
{
	pName[24],
	pMoney
};
new pInfo[MAX_PLAYERS][playerdata];

stock SetPlayerMoney(playerid, cash)
{
	ResetPlayerMoney(playerid);
	return GivePlayerMoney(playerid, cash);
}

stock Login(playerid)
{
	new query[500];
	format(query, 500, "SELECT * FROM 'playerdata' WHERE user='%s'", pInfo[playerid][pName]);
	mysql_query(query);
	mysql_store_result();
	while(mysql_fetch_row(query))
	{
	    mysql_fetch_field_row("money", pInfo[playerid][pName]);	GivePlayerMoney(playerid, pInfo[playerid][pMoney]);
	}
	mysql_free_result();
}

stock CreatePlayer(playerid)
{
	new query[500];
	format(query, 500, "INSERT INTO 'playerdata' ('user', 'money') VALUES('%s', 0)", pInfo[playerid][pName]);
	mysql_query(query);
}

stock SavePlayer(playerid)
{
	new query[500];
	format(query, 500, "UPDATE 'playerdata' SET money = %d WHERE user='%s'", pInfo[playerid][pName]);
	mysql_query(query);
}

main()
{
	print("\n----------------------------------");
	print(" Blank Gamemode by your name here");
	print("----------------------------------\n");
}

public OnGameModeInit()
{
	SetGameModeText("Learning MySQL :)");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	// MYSQL //
	new Connection = mysql_connect(mysql_host, mysql_user, mysql_database, mysql_password);
	if(Connection)
    {
        new dest[200];
        mysql_stat(dest);
        printf(dest);
        printf(">> MySQL connection successfully initialized");
	}
	mysql_query("CREATE TABLE IF NOT EXISTS 'playerdata'(user VARCHAR(24), money INT(20) )");
	return 1;
}

public OnGameModeExit()
{
    mysql_close();
	return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
	SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
	return 1;
}

public OnPlayerConnect(playerid)
{
	GetPlayerName(playerid, pInfo[playerid][pName], 24);
	mysql_real_escape_string(pInfo[playerid][pName], pInfo[playerid][pName]);
	new query[500];
	format(query, 500, "SELECT user FROM 'playerdata' WHERE user='%s'", pInfo[playerid][pName]);
	mysql_query(query);
	mysql_store_result();
	if(mysql_num_rows() > 0)
    {
        Login(playerid);
	}
    else
    {
		CreatePlayer(playerid);
    }
	mysql_free_result();
	return 1;
}

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