[SA-MP] MySQL Gamemode

#include <a_samp>
#include <a_mysql>

#define NEW_SKIN      299

main()
{
	print("\n----------------------------------");
	print(" MySQL Gamemode by B-Matt");
	print("----------------------------------\n");
}

enum pInfo
{
	pSQLid,
	pPass[50],
	pMoney
}
new PlayerInfo[MAX_PLAYERS][pInfo];

new dbHandle, query[1000];

stock GetName(playerid)
{
	new pName[MAX_PLAYER_NAME];
	GetPlayerName(playerid, pName, sizeof(pName));
	return pName;
}

public OnGameModeInit()
{
	SetGameModeText("MySQL Script");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	dbHandle = mysql_connect("127.0.0.1","root","sa-mp","");
	mysql_function_query(1, "CREATE TABLE IF NOT EXISTS `players` (`Name` varchar(24) NOT NULL,`Password` varchar(50) NOT NULL,`Money` int(11) NOT NULL)", false, "OnQueryFinish", "");
	mysql_debug(1);
	return 1;
}

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

public OnPlayerRequestClass(playerid, classid)
{
    SetSpawnInfo( playerid, 0, 0, 1958.33, 1343.12, 15.36, 269.15, 26, 36, 28, 150, 0, 0 );
}

public OnPlayerConnect(playerid)
{
	format(query, sizeof(query), "SELECT * FROM `players` WHERE `Name` = '%s' LIMIT 0,1" , GetName(playerid));
	mysql_function_query(1, query, true, "CheckPlayer", "i", playerid);
	return 1;
}

forward CheckPlayer(playerid);
public CheckPlayer(playerid)
{
    new rows, fields, string[128];
    cache_get_data(rows, fields);
	if(!rows)
	{
	    format(string, sizeof(string), "{FFFFFF}Welcome {A3FF00}%s{FFFFFF} on server. Input your password and register account.", GetName(playerid));
		ShowPlayerDialog(playerid, 0, DIALOG_STYLE_PASSWORD, "Registration", string, "Registration", "Quit");
	}
	else
	{
	    new temp[12];
	    cache_get_row(0, 1, temp); PlayerInfo[playerid][pSQLid] = strval(temp);
		cache_get_row(0, 2, PlayerInfo[playerid][pPass]);
		cache_get_row(0, 3, temp); PlayerInfo[playerid][pMoney] = strval(temp);
		format(string, sizeof(string), "{FFFFFF}Welcome {A3FF00}%s{FFFFFF} your account is ready for use. Input your password and login.", GetName(playerid));
		ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Login", string, "Login", "Quit");
	}
	return 1;
}

forward OnAccountCreate(playerid);
public OnAccountCreate(playerid)
{
    PlayerInfo[playerid][pSQLid] = mysql_insert_id();
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	format(query, sizeof(query), "UPDATE `players` SET Money=%d WHERE `Name`=%s LIMIT 0,1", GetPlayerMoney(playerid), GetName(playerid));
	mysql_function_query(1, query, false, "OnQueryFinish", "");
	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[])
{
	switch(dialogid)
	{
	    case 0:
	    {
	        if(!response) return Kick(playerid);
	        if(strlen(inputtext) > 50) return SendClientMessage(playerid, -1, "Your password is too long!");
	        format(query, sizeof(query), "INSERT INTO `Players` (Name, Password, Money) VALUES ('%s', '%s', '%d')", GetName(playerid), inputtext, 1000);
			mysql_function_query(dbHandle, query, false, "OnAccountCreate", "i", playerid);
			SpawnPlayer(playerid);
			GivePlayerMoney(playerid, 1000);
	    }
	    case 1:
	    {
	        new string[128];
	        if(!response) return Kick(playerid);
	        if(strcmp(inputtext, PlayerInfo[playerid][pPass], true) == 0)
			{
			    SpawnPlayer(playerid);
			    GivePlayerMoney(playerid, PlayerInfo[playerid][pMoney]);
			}
			else
			{
			    format(string, sizeof(string), "{FFFFFF}Welcome {A3FF00}%s{FFFFFF} your account is ready for use.\n Input your password and login.\n {FF0000}Wrong password{FFFFFF}!", GetName(playerid));
				ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Login", string, "Login", "Quit");
			}
	    }
	}
	return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}