stock punishmentLog(playerid, issuerid, puntype, szPunishment[128], szReason[]) {
	if(AdminDuty[playerid] == 0) {
		new
			szPunText[128],
			szRawReason[128],
			szQuery[440];

		mysql_real_escape_string(szPunishment, szPunText, g_MySQLConnections[0]);
		mysql_real_escape_string(szReason, szRawReason, g_MySQLConnections[0]);
	
		format(szQuery, sizeof(szQuery), "INSERT INTO punishments (punIssuer, punIssuedTo, punText, punType, punReason, punTS) VALUES(%d, %d, '%s', %d, '%s', UNIX_TIMESTAMP(now()))", PlayerInfo[issuerid][pID], PlayerInfo[playerid][pID], szPunText, puntype, szRawReason);
		mysql_query(szQuery, THREAD_NO_RESULT, 0, g_MySQLConnections[0]);
	}
	return 1;
}

stock player_remove_vip_toys(iTargetID)
{
	if(PlayerInfo[iTargetID][pDonator] >= 3) return 1;
	else for(new iToyIter; iToyIter < MAX_PLAYER_ATTOBJECTS; ++iToyIter) {
		for(new LoopRapist; LoopRapist < sizeof(HoldingObjectsCop); ++LoopRapist) {
			if(HoldingObjectsCop[LoopRapist][holdingmodelid] == PlayerToyInfo[iTargetID][iToyIter][ptModelID]) {			
				new
					szQuery[128];

				SetPVarInt(iTargetID, "deleteObject", iToyIter);
				format(szQuery, sizeof(szQuery), "DELETE FROM toys WHERE Owner = %d AND ID = %d", PlayerInfo[iTargetID][pID], PlayerToyInfo[iTargetID][iToyIter][ptRealID]);
				mysql_query(szQuery, THREAD_DELETE_PLAYER_OBJECT, iTargetID, g_MySQLConnections[0]);
				if(IsPlayerAttachedObjectSlotUsed(iTargetID, iToyIter)) RemovePlayerAttachedObject(iTargetID, iToyIter);
			}
		}
	}
	SendClientMessage(iTargetID, COLOR_WHITE, "All accessories/toys that were property of your former employer have been removed.");
	return 1;
}

stock punishmentLogEx(playerid, issuerid, puntype, szPunishment[128], szReason[]) {
	if(AdminDuty[playerid] == 0) {
		new
	    szPunText[128],
	    szRawReason[128],
	    szQuery[440];

		mysql_real_escape_string(szPunishment, szPunText, g_MySQLConnections[0]);
		mysql_real_escape_string(szReason, szRawReason, g_MySQLConnections[0]);
	
		format(szQuery, sizeof(szQuery), "INSERT INTO punishments (punIssuer, punIssuedTo, punText, punType, punReason, punTS) VALUES(%d, %d, '%s', %d, '%s', UNIX_TIMESTAMP(now()))", issuerid, playerid, szPunText, puntype, szRawReason);
		mysql_query(szQuery, THREAD_NO_RESULT, 0, g_MySQLConnections[0]);
	}
	return 1;
}

	format(szQuery, sizeof(szQuery), "UPDATE playervehicles SET Owner = %d WHERE ID = %d", PlayerInfo[playerid][pID], GetPVarInt(playerid, "carsaleid"));
							mysql_query(szQuery, THREAD_NO_RESULT, 0, g_MySQLConnections[0]);

CMD:oipcheck(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] < 2)
		return SendClientMessage(playerid, COLOR_GRAD1, "You're not authorized to use that command!");

	if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
		return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

	if(isnull(params))
	    return SendClientMessage(playerid, COLOR_GREY, "USAGE: /oipcheck [name]");

	new
		string[128],
		szPlayerName[MAX_PLAYER_NAME];

	mysql_real_escape_string(params, szPlayerName, g_MySQLConnections[0]);

	format(string, sizeof(string), "SELECT Username, LastIP FROM players WHERE Username = '%s'", szPlayerName);
	mysql_query(string, THREAD_OFFLINE_IP_CHECK, playerid, g_MySQLConnections[0]);
	return 1;
}

CMD:unban(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] >= 6 || PlayerInfo[playerid][pBanAppealer] >= 1) {
		if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
			return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

		new
		    szPlayerName[MAX_PLAYER_NAME],
			string[128];
			
		if(isnull(params))
			return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /unban [playername]");

		mysql_real_escape_string(params, szPlayerName, g_MySQLConnections[0]);
		
		format(string, sizeof(string), "SELECT Banned, Permabanned, Warnings, LastIP, Username FROM players WHERE Username = '%s'", szPlayerName);
		mysql_query(string, THREAD_CHECK_BANNED, playerid, g_MySQLConnections[0]);
	}
	else
	{
		return SendClientMessage(playerid, COLOR_GRAD1, " Only server manager or ban appealers can use this cmd!");
	}
	return 1;
}

CMD:oban(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] < 4)
		return SendClientMessage(playerid, COLOR_GRAD1, "You're not authorized to use that command!");

 	if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
   		return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

	new
		string[128],
		playername[MAX_PLAYER_NAME],
		reason[64];
		
	if(sscanf(params, "s[MAX_PLAYER_NAME]s[64]", playername, reason))
		return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /oban [playername] [reason]");

    new
		giveplayerid = ReturnUser(playername);
		
	if(IsPlayerConnected(giveplayerid))
		return SendClientMessage(playerid, COLOR_GRAD2, "That player is online, use /ban for online players.");

	SetPVarString(playerid, "obanreason", reason);
	
	new
	    szPlayerName[MAX_PLAYER_NAME];

	mysql_real_escape_string(playername, szPlayerName, g_MySQLConnections[0]);
	
	format(string, sizeof(string), "SELECT Permabanned, Banned, AdminLevel, Username, LastIP, ID FROM players WHERE Username = '%s'", szPlayerName);
	mysql_query(string, THREAD_OFFLINE_BAN, playerid, g_MySQLConnections[0]);
	return 1;
}

CMD:ofine(playerid, params[])
{
	if(PlayerInfo[playerid][pAdmin] < 3)
		return SendClientMessage(playerid, COLOR_GRAD1, "You're not authorized to use that command!");
		
	if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
		return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

	new 
		string[128], 
		name[MAX_PLAYER_NAME], 
		amount, 
		reason[64];
		
	if(sscanf(params, "s[MAX_PLAYER_NAME]ds[64]", name, amount, reason)) 
		return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /ofine [name] [amount] [reason]");

	new 
		giveplayerid = ReturnUser(name);
		
	if(giveplayerid != INVALID_PLAYER_ID)
		return SendClientMessage(playerid, COLOR_GRAD2, "That player is online, use /fine for online players.");
		
	if(amount < 1)
		return SendClientMessage(playerid, COLOR_GRAD2, "Amount must be greater than 0.");

	SetPVarString(playerid, "ofinereason", reason);
	SetPVarInt(playerid, "ofineamount", amount);
	
	new
	    szPlayerName[MAX_PLAYER_NAME];

	mysql_real_escape_string(name, szPlayerName, g_MySQLConnections[0]);
	
	format(string, sizeof(string), "SELECT Permabanned, Banned, AdminLevel, Username, LastIP, Bank, Cash FROM players WHERE Username = '%s'", szPlayerName);
	mysql_query(string, THREAD_OFFLINE_FINE, playerid, g_MySQLConnections[0]);
	
	return 1;
}

CMD:oflag(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] >= 2) {
 		if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
	        return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

		new
			string[128],
			name[MAX_PLAYER_NAME],
			reason[64];
			
		if(sscanf(params, "s[24]s[64]", name, reason))
			return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /oflag [name] [reason]");

    	new
			giveplayerid = ReturnUser(name);

        if(IsPlayerConnected(giveplayerid)) {
			AddFlag(giveplayerid, playerid, reason);
			SendClientMessage(playerid, COLOR_WHITE, "The player is online and has been flagged!");
			
			format(string, sizeof(string), "AdmCmd: %s was flagged by %s, reason: %s.", GetPlayerNameEx(giveplayerid), GetPlayerNameEx(playerid), reason);
			ABroadCast(COLOR_LIGHTRED, string, 1);
		} else {
		    new
		        szPlayerName[MAX_PLAYER_NAME],
		        szFlag[128],
		        szQuery[128];

			mysql_real_escape_string(name, szPlayerName, g_MySQLConnections[0]);

			mysql_real_escape_string(reason, szFlag, g_MySQLConnections[0]);
			SetPVarString(playerid, "offline_flag", szFlag);
			SetPVarString(playerid, "offline_flag_target", szPlayerName);

			format(szQuery, sizeof(szQuery), "SELECT Username FROM players WHERE Username = '%s'", szPlayerName);
			mysql_query(szQuery, THREAD_OFFLINE_FLAG, playerid, g_MySQLConnections[0]);
		}
		return 1;
	}
	return 1;
}

CMD:approvename(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] < 1)
	    return SendClientMessage(playerid, COLOR_GREY, "You're not authorised to use this command.");

	new
	    iTarget,
		szQuery[128];

	if(sscanf(params, "u", iTarget))
	    return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /approvename [playerid/partOfName]");

	if(iTarget == INVALID_PLAYER_ID)
	    return SendClientMessage(playerid, COLOR_GREY, "Invalid player specified.");

    if(GetPVarInt(iTarget, "RequestingNameChange") == 0)
		return SendClientMessage(playerid, COLOR_GREY, "The specified player isn't requesting a name change.");

	new
	    szPlayerName[MAX_PLAYER_NAME];

    GetPVarString(iTarget, "NewNameRequest", szPlayerName, MAX_PLAYER_NAME);
    SetPVarInt(iTarget, "requestby", playerid);

    mysql_real_escape_string(szPlayerName, szPlayerName, g_MySQLConnections[0]);

    SetPVarString(iTarget, "requestedname", szPlayerName);

    format(szQuery, sizeof(szQuery), "SELECT Username FROM players WHERE Username = '%s'", szPlayerName);
	mysql_query(szQuery, THREAD_CHECK_NEW_NAME, iTarget, g_MySQLConnections[0]);
	return 1;
}

CMD:setname(playerid, params[]) {
	new
		szQuery[128],
		iTarget,
		szNewName[MAX_PLAYER_NAME];
	
	if(sscanf(params, "us[24]", iTarget, szNewName))
		return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /setname [playerid/partofname] [newname]");
		
	if(iTarget == INVALID_PLAYER_ID)
	    return SendClientMessage(playerid, COLOR_GREY, "Invalid player specified.");

	if(PlayerInfo[playerid][pAdmin] < 4)
	    return SendClientMessage(playerid, COLOR_GREY, "Insufficient admin level. ");

	if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
		return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

	if(AdminDuty[iTarget] == 1)
 		return SendClientMessage(playerid,COLOR_WHITE, "You can't use /setname on an on-duty admin.");

	if(strfind(szNewName, "_", false) == -1)
		return SendClientMessage(playerid, COLOR_GREY, "The name must include an underscore ('_').");

	mysql_real_escape_string(szNewName, szNewName, g_MySQLConnections[0]);
	
	SetPVarInt(iTarget, "requestby", playerid);
	SetPVarInt(iTarget, "requestpath", 3);
	SetPVarString(iTarget, "requestedname", szNewName);
	
	format(szQuery, sizeof(szQuery), "SELECT Username FROM players WHERE Username = '%s'", szNewName);
	mysql_query(szQuery, THREAD_CHECK_NEW_NAME, iTarget, g_MySQLConnections[0]);

	return 1;
}

CMD:listpnamechanges(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] < 3)
	    return SendClientMessage(playerid, COLOR_GREY, "You're not authorised to use this command.");

	if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
	    return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

	new
	    iTarget;
	    
	if(sscanf(params, "u", iTarget))
	    return SendClientMessage(playerid, COLOR_GREY, "USAGE: /listnchanges [playerid/partOfName]");

	if(iTarget == INVALID_PLAYER_ID)
	    return SendClientMessage(playerid, COLOR_GREY, "Invalid player specified.");

	new
	    szQuery[114];

	SetPVarInt(playerid, "namechanges_target", iTarget);
	
	format(szQuery, sizeof(szQuery), "SELECT oldname, unixts, newname, approvedbyname FROM namechanges WHERE dbid = %d ORDER BY unixts DESC LIMIT 10", PlayerInfo[iTarget][pID]);
	mysql_query(szQuery, THREAD_LIST_NAMECHANGES, playerid, g_MySQLConnections[0]);
	return 1;
}

CMD:oprison(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] >= 3) {
		if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
   			return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

		new
			string[128],
			name[MAX_PLAYER_NAME],
			minutes,
			reason[64];

		if(sscanf(params, "s[24]ds[64]", name, minutes, reason))
			return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /oprison [playername] [time (minutes)] [reason]");

        new giveplayerid = ReturnUser(name);
        if(IsPlayerConnected(giveplayerid))
			return SendClientMessage(playerid, COLOR_GRAD2, "That player is online, use /prison for online players.");

		SetPVarInt(playerid, "oprisontime", minutes*60);
		SetPVarString(playerid, "oprisonreason", reason);
		
		new
		    szPlayerName[MAX_PLAYER_NAME];

		mysql_real_escape_string(name, szPlayerName, g_MySQLConnections[0]);

		format(string, sizeof(string), "SELECT Permabanned, Banned, AdminLevel, Username, LastIP, JailTime, ID FROM players WHERE Username = '%s'", szPlayerName);
		mysql_query(string, THREAD_OFFLINE_PRISON, playerid, g_MySQLConnections[0]);
	}
	return 1;
}

CMD:su(playerid, params[]) {
	if(IsACop(playerid) || PlayerInfo[playerid][pFaction] == 5 && PlayerInfo[playerid][pDivision] == 5 || PlayerInfo[playerid][pFaction] == 5 && PlayerInfo[playerid][pDivision] == 2) {
		if(PlayerInfo[playerid][pJailed] > 0) {
			return SendClientMessage(playerid, COLOR_WHITE, "You can't use this in jail/prison.");
		}

		new
			iTargetID,
			szCrime[64];

		if(sscanf(params, "us[64]", iTargetID, szCrime)) {
			SendClientMessage(playerid, COLOR_WHITE, "USAGE: (/su)spect [playerid/partofname] [crime description]");
		}
		else if(!IsPlayerConnected(iTargetID)) {
			SendClientMessage(playerid, COLOR_GRAD1, "Invalid player specified.");
		}
		else if(IsACop(iTargetID)) {
			SendClientMessage(playerid, COLOR_GREY, "You can't use this command on a law enforcement officer.");
		}
		else if(PlayerInfo[iTargetID][pFaction] == 5) {
			SendClientMessage(playerid, COLOR_GREY, "This person has diplomatic immunity.");
		}
		else if(PlayerInfo[iTargetID][pWantedLevel] >= 6) {
			SendClientMessage(playerid, COLOR_GRAD2, "Target is already most wanted.");
		}
		else {

			new
				szMessage[128];

			++PlayerInfo[iTargetID][pCrimes];
			SetPlayerWantedLevel(iTargetID, ++PlayerInfo[iTargetID][pWantedLevel]);
			if(PlayerInfo[iTargetID][pWantedLevel] > 5)
 			{
				SetPlayerColor(iTargetID, WANTED_COLOR);
			}

			format(szMessage, sizeof(szMessage), "You've commited a crime (%s), reporter: %s.", szCrime, GetPlayerNameEx(playerid));
			SendClientMessage(iTargetID, COLOR_LIGHTRED, szMessage);

			format(szMessage, sizeof(szMessage), "Current wanted level: %d", PlayerInfo[iTargetID][pWantedLevel]);
			SendClientMessage(iTargetID, COLOR_YELLOW, szMessage);
			
			if(AdminDuty[iTargetID] == 0) {
				new
					szCleanDescription[64],
					szQuery[270];

				mysql_real_escape_string(szCrime, szCleanDescription, g_MySQLConnections[0]);

				format(szQuery, sizeof(szQuery), "INSERT INTO crimes (crimeIssuer, crimeIssuedTo, crimeDescription, crimeIssuerName, crimeIssuedToName) VALUES(%d, %d, '%s', '%s', '%s')", PlayerInfo[playerid][pID], PlayerInfo[iTargetID][pID], szCleanDescription, GetPlayerNameEx(playerid), GetPlayerNameEx(iTargetID));
				mysql_query(szQuery, THREAD_NO_RESULT, 0, g_MySQLConnections[0]);
			}
			foreach(Player, i) if(IsACop(i) || PlayerInfo[i][pFaction] == 5 && PlayerInfo[i][pDivision] == 5 || PlayerInfo[playerid][pFaction] == 5 && PlayerInfo[playerid][pDivision] == 2) {
				format(szMessage, sizeof(szMessage), "HQ: All units APB (reporter: %s)",GetPlayerNameEx(playerid));
				SendClientMessage(i, TEAM_BLUE_COLOR, szMessage);
				format(szMessage, sizeof(szMessage), "HQ: Crime: %s, suspect: %s", szCrime, GetPlayerNameEx(iTargetID));
				SendClientMessage(i, TEAM_BLUE_COLOR, szMessage);
			}
		}
	}
	else SendClientMessage(playerid, COLOR_GRAD2, "You're not a law enforcement officer.");
	return 1;
}

CMD:ouninvite(playerid, params[]) {
	if(PlayerInfo[playerid][pLeader] >= 1) {
		if(isnull(params))
			return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /ouninvite [name]");

		if(IsPlayerConnected(ReturnUser(params)))
		    return SendClientMessage(playerid, COLOR_GREY, "This player is currently connected, please use /uninvite to uninvite the player.");
		    
		new
		    szPlayerName[MAX_PLAYER_NAME],
		    szQuery[128];
		    
		mysql_real_escape_string(params, szPlayerName, g_MySQLConnections[0]);
		
		SetPVarString(playerid, "uninvite_target", szPlayerName);

		format(szQuery, sizeof(szQuery), "SELECT Faction, AdminLevel FROM players WHERE Username = '%s'", szPlayerName);
		mysql_query(szQuery, THREAD_OFFLINE_UNINVITE, playerid, g_MySQLConnections[0]);
	}
	else SendClientMessage(playerid, COLOR_GRAD1, "You're not authorized to use that command - only leaders can do this.");
	return 1;
}

CMD:changeuserpassword(playerid, params[]) {
    if(PlayerInfo[playerid][pAdmin] < 5)
        return SendClientMessage(playerid, COLOR_GRAD1, "You're not authorized to use that command!");

   	if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
   		return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

    new
		string[128],
		accountName[24],
		szPassword[64],
		password[64];
		
    if(sscanf(params, "s[MAX_PLAYER_NAME]s[64]", accountName, password))
		return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changeuserpassword [playername] [new password]");

	mysql_real_escape_string(accountName, accountName, g_MySQLConnections[0]);
	mysql_real_escape_string(password, szPassword, g_MySQLConnections[0]);
	
	SetPVarString(playerid, "opasschange", szPassword);
	SetPVarString(playerid, "opasschangetarget", accountName);

	format(string, sizeof(string), "SELECT Username FROM players WHERE Username = '%s' AND AdminLevel = 0", accountName);
	mysql_query(string, THREAD_CHECK_NAME_PASSWORD, playerid, g_MySQLConnections[0]);
    return 1;
}

CMD:ocheck(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] < 3)
		return SendClientMessage(playerid, COLOR_GRAD1, "You're not authorized to use that command!");

	if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
  		return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

	if(isnull(params))
		return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /ocheck [name]");
		
	new
		giveplayerid = ReturnUser(params);

	if(IsPlayerConnected(giveplayerid))
		return SendClientMessage(playerid, COLOR_WHITE, "That player is online, please use /check instead.");

	new
		szPlayerName[MAX_PLAYER_NAME],
	    szQuery[68];

	mysql_real_escape_string(params, szPlayerName, g_MySQLConnections[0]);
	format(szQuery, sizeof(szQuery), "SELECT * FROM players WHERE Username = '%s'", szPlayerName);
	mysql_query(szQuery, THREAD_GET_STATS, playerid, g_MySQLConnections[0]);
	return 1;
}

CMD:okills(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] < 3)
		return SendClientMessage(playerid, COLOR_GRAD1, "You're not authorized to use that command!");

	if(AdminDuty[playerid] != 1 && PlayerInfo[playerid][pAdmin] < 6)
  		return SendClientMessage(playerid,COLOR_WHITE, "You're not on-duty as admin. To access your admin commands you must be on-duty. Type /aduty to go on-duty.");

	if(isnull(params))
		return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /okills [name]");
		
	new
		giveplayerid = ReturnUser(params);

	if(IsPlayerConnected(giveplayerid))
		return SendClientMessage(playerid, COLOR_WHITE, "That player is online, please use /kills instead.");

	new
		szPlayerName[MAX_PLAYER_NAME],
	    szQuery[68];

	mysql_real_escape_string(params, szPlayerName, g_MySQLConnections[0]);
	format(szQuery, sizeof(szQuery), "SELECT * FROM players WHERE Username = '%s'", szPlayerName);
	mysql_query(szQuery, THREAD_OFFLINE_KILLS, playerid, g_MySQLConnections[0]);
	return 1;
}

forward OnPlayerRegister(playerid, password[]);
public OnPlayerRegister(playerid, password[]) {
	if(IsPlayerConnected(playerid)) {
		new
		    szPlayerName[MAX_PLAYER_NAME],
		    szPlayerName2[MAX_PLAYER_NAME],
		    szQuery[225];

		GetPlayerName(playerid, szPlayerName, MAX_PLAYER_NAME);
		
		mysql_real_escape_string(szPlayerName, szPlayerName2, g_MySQLConnections[0]);
		
		SetPVarString(playerid, "password", password);
		
		// Set the variable to logged in so we aren't cockblocked by SaveAccount()
		gPlayerLogged[playerid] = 1;
		
		format(szQuery, sizeof(szQuery), "INSERT INTO players (Username, Password) VALUES('%s', '%s')", szPlayerName2, password);
		mysql_query(szQuery, THREAD_REGISTER_ACCOUNT, playerid, g_MySQLConnections[0]);
	}
	return 1;
}

	g_MySQLConnections[0] = mysql_connect("127.0.0.1", "asdo", "easdo", "093as99");
	
	mysql_debug(1);
	
	mysql_query("set session query_cache_type=0;", THREAD_NO_RESULT, 0, g_MySQLConnections[0]);

mysql_query("set session query_cache_type=0;", THREAD_NO_RESULT, 0, g_MySQLConnections[0]);

	new
		szQuery[128];
	format(szQuery, sizeof(szQuery), "DELETE FROM connections WHERE PlayerID = %d", playerid);
	mysql_query(szQuery, THREAD_NO_RESULT, playerid, g_MySQLConnections[0]);

stock AttemptPlayerLogin(playerid, passbuffer[]) {
	new
	    szQuery[225],
	    szPlayerName[MAX_PLAYER_NAME],
		szPlayerName2[MAX_PLAYER_NAME];

	GetPlayerName(playerid, szPlayerName, sizeof(szPlayerName));
	
	mysql_real_escape_string(szPlayerName, szPlayerName2, g_MySQLConnections[0]);

	format(szQuery, sizeof(szQuery), "SELECT * FROM players WHERE Username = '%s' AND Password = '%s'", szPlayerName2, passbuffer);
	mysql_query(szQuery, THREAD_LOGIN_ATTEMPT, playerid, g_MySQLConnections[0]);
	return 1;
}

stock LoadPlayerDynamicItems(playerid) {
	new
	    szString[128];

	format(szString, sizeof(szString), "SELECT toys.* FROM toys INNER JOIN players ON toys.Owner = players.ID WHERE players.ID = '%d' ORDER BY toys.ID ASC LIMIT %d", PlayerInfo[playerid][pID], MAX_PLAYERTOYS);
	mysql_query(szString, THREAD_LOAD_P_ITEMS_CHAIN_1, playerid, g_MySQLConnections[0]);
	return 1;
}

stock SaveAccount(playerid) {
    // The query threads continue in the callback for finished queries.
	if(GetPVarInt(playerid, "TempName") != 1 && gPlayerLogged[playerid] && AdminDuty[playerid] == 0) {
	    
		new
			szPlayerName[MAX_PLAYER_NAME],
			szPlayerName2[MAX_PLAYER_NAME],
			szAdminName[MAX_PLAYER_NAME],
		    szQuery[2048];

		GetPlayerName(playerid, szPlayerName, MAX_PLAYER_NAME);
		
		mysql_real_escape_string(szPlayerName, szPlayerName2, g_MySQLConnections[0]);
		mysql_real_escape_string(PlayerInfo[playerid][pAdminName], szAdminName, g_MySQLConnections[0]);

		format(szQuery, sizeof(szQuery), "UPDATE players SET Username = '%s', Password = '%s', Level = %d, AdminLevel = %d, AdminName = '%s', BanAppealer = %d, Donator = %d, Banned = %d, Permabanned = %d, Disabled = %d, LastIP = '%s', Registered = %d, \
		Tutorial = %d, Sex = %d, Age = %d, Skin = %d, PosX = '%f', PosY = '%f', PosZ = '%f', PosR = '%f', ConnectTime = %d, Respect = %d, PhoneNumber = %d, Warnings = %d, Gang = %d, Faction = %d, Leader = %d, Rank = %d WHERE ID = %d",
		szPlayerName, PlayerInfo[playerid][pKey], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], szAdminName, PlayerInfo[playerid][pBanAppealer], PlayerInfo[playerid][pDonator], PlayerInfo[playerid][pBanned],
		PlayerInfo[playerid][pPermaBanned], PlayerInfo[playerid][pDisabled], PlayerInfo[playerid][pIP], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pPos_x],
		PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], PlayerInfo[playerid][pPos_r], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pRespect], PlayerInfo[playerid][pNumber], PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pGang],
		PlayerInfo[playerid][pFaction], PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pID]);

		mysql_query(szQuery, THREAD_SAVE_ACCOUNT_CHAIN_1, playerid, g_MySQLConnections[0]);
	}
	return 1;
}

stock timec(timestamp, compare = -1) {
    if (compare == -1) {
        compare = gettime();
    }
    new
        n,
        // on the following line, I have removed the need for the diff() function.
        // if you want to use the diff() function in pawn, replace the following with:
        // Float:d = diff(timestamp, compare),
        Float:d = (timestamp > compare) ? timestamp - compare : compare - timestamp,
        returnstr[32];
    if (d < 60) {
        format(returnstr, sizeof(returnstr), "< 1 minute");
        return returnstr;
    } else if (d < 3600) { // 3600 = 1 hour
        n = floatround(floatdiv(d, 60.0), floatround_floor);
        format(returnstr, sizeof(returnstr), "minute");
    } else if (d < 86400) { // 86400 = 1 day
        n = floatround(floatdiv(d, 3600.0), floatround_floor);
        format(returnstr, sizeof(returnstr), "hour");
    } else if (d < 2592000) { // 2592000 = 1 month
        n = floatround(floatdiv(d, 86400.0), floatround_floor);
        format(returnstr, sizeof(returnstr), "day");
    } else if (d < 31536000) { // 31536000 = 1 year
        n = floatround(floatdiv(d, 2592000.0), floatround_floor);
        format(returnstr, sizeof(returnstr), "month");
    } else {
        n = floatround(floatdiv(d, 31536000.0), floatround_floor);
        format(returnstr, sizeof(returnstr), "year");
    }
    if (n == 1) {
        format(returnstr, sizeof(returnstr), "1 %s", returnstr);
    } else {
        format(returnstr, sizeof(returnstr), "%d %ss", n, returnstr);
    }
    return returnstr;
}

public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle) {
	printf("errorid: %d | error: %s | callback: %s | query: %s | connection handle: %d | resultid: %d | extraid: %d", errorid, error, callback, query, connectionHandle, resultid, extraid);
	return 1;
}