SetJobRankVehicleModel(job, number, newmodel)
{
	new query[90];
	for(new i = 0; i < sizeof(RankInfo); i++)
		if(RankInfo[ i ][ JobId ] == job && RankInfo[ i ][ RNumber ] == number)
		{
			format(query, sizeof(query), "UPDATE job_ranks SET vehicle = %d WHERE job_id = %d AND number = %d",
				newmodel, job, number);
			mysql_query(query);
			return RankInfo[ i ][ Vehicle ] = newmodel;
		}
	new index = CreateNewRank(job, number);
	if(index != -1)
		SetJobRankVehicleModel(job, number, newmodel);
	return 0;
}
GetJobRankPaycheck(job, number)
{
	for(new i = 0; i < sizeof(RankInfo); i++)
		if(RankInfo[ i ][ JobId ] == job && RankInfo[ i ][ RNumber ] == number)
			return RankInfo[ i ][ Paycheck ];
	return 0;
}
SetJobRankPaycheck(job, number, paycheck)
{
	new query[160];
	for(new i = 0; i < sizeof(RankInfo); i++)
		if(RankInfo[ i ][ JobId ] == job && RankInfo[ i ][ RNumber ] == number)
		{
			format(query, sizeof(query), "UPDATe job_ranks SET paycheck = %d WHERE job_id = %d AND number = %d",
				paycheck, job, number);
			mysql_query(query);
			return RankInfo[ i ][ Paycheck ] = paycheck;
		}

	if(CreateNewRank(job, number) != -1)
		return SetJobRankPaycheck(job, number ,paycheck);
	return 0;
}

CreateNewRank(job, number)
{
	new query[80];
	for(new i = 0; i < sizeof(RankInfo); i++)
	{
		if(!RankInfo[ i ][ JobId ] && !RankInfo[ i ][ RNumber ])
		{
			RankInfo[ i ][ JobId ] = job;
			RankInfo[ i ][ RNumber ] = number;
			format(query, sizeof(query),"INSERT INTO job_ranks (job_id, number) VALUES (%d, %d)", job, number);
			mysql_query(query);
			return i;
		}
	}
	return -1;
}
stock IsJobVehicle(vehicleid)
{
	for(new i = 0; i < sizeof(MedikuMasina); i++)
		if(MedikuMasina[ i ] == vehicleid)
			return true;
	for(new i = 0; i < sizeof(TaksiMasina); i++)
		if(TaksiMasina[ i ] == vehicleid)
			return true;
	for(new i = 0; i < sizeof(ArmijaMasina); i++)
		if(ArmijaMasina[ i ] == vehicleid)
			return true;
	for(new i = 0; i < sizeof(BrigadaMasina); i++)
		if(BrigadaMasina[ i ] == vehicleid)
			return true;
	for(new i = 0; i < sizeof(PolicijosMasina); i++)
		if(PolicijosMasina[i] == vehicleid)
			return true;
	for(new i = 0; i < sizeof(FuristuMasina); i++)
		if(FuristuMasina[i] == vehicleid)
			return true;
	for(new i = 0; i < sizeof(DyleriuMasina); i++)
		if(DyleriuMasina[ i ] == vehicleid)
			return true;
	for(new i = 0; i < sizeof(MechanikuMasina); i++)
		if(MechanikuMasina[ i ] == vehicleid)
			return true;
	for(new i = 0; i < sizeof(RadistuMasina); i++)
		if(RadistuMasina[i] == vehicleid)
			return true;
	for(new i = 0; i < sizeof(GenoveseMasina); i++)
		if(GenoveseMasina[ i ] == vehicleid)
			return true;
	return false;
}
stock CanPlayerUseJobVehicle(playerid, model)
{
	if(!playerDB[ playerid ][ specialybe ])
		return false;

	for(new i = 0; i < MAX_JOB_RANKS; i++)
	{
		if(RankInfo[ i ][ Vehicle ] != model)
			continue;
		if(RankInfo[ i ][ JobId ] != playerDB[ playerid ][ specialybe ])
			return false;
		if(RankInfo[ i ][ RNumber ] > playerDB[ playerid ][ rangas ])
			return false;
		return true;
		/*
		if(RankInfo[ i ][ JobId ] != playerDB[ playerid ][ specialybe ])
			continue;

		if(RankInfo[ i ][ Vehicle ] == model && RankInfo[ i ][ RNumber ] > playerDB[ playerid ][ rangas ])
			return false;
		*/
	}
	return false;
}

SetJobRankName(job, number, name[])
{
	new query[190];
	for(new i = 0; i < sizeof(RankInfo); i++)
		if(RankInfo[ i ][ JobId ] == job && RankInfo[ i ][ RNumber ] == number)
		{

			format(RankInfo[ i ][ Name ], MAX_RANK_NAME, name);
			format(query, sizeof(query), "UPDATE job_ranks SET name = '%s' WHERE job_id = %d AND number = %d", name, job, number);
			return mysql_query(query);
		}
	if(CreateNewRank(job, number) != -1)
		return SetJobRankName(job, number ,name);
	return 0;
}

IsValidRank(jobid, ranknr)
{
	for(new i = 0; i < sizeof(RankInfo); i++)
		if(RankInfo[ i ][ JobId ] == jobid && RankInfo[ i ][ RNumber ] == ranknr)
			return true;
	return false;
}

stock GetRankName(jobid, ranknr)
{
	new s[MAX_RANK_NAME];
	for(new i = 0; i < sizeof(RankInfo); i++)
		if(RankInfo[ i ][ JobId ] == jobid && RankInfo[ i ][ RNumber ] == ranknr)
		{
			strcat(s, RankInfo[ i ][ Name ]);
			break;
		}
	return s;
}
stock GetPlayerJobRank(playerid)
{
 new s[MAX_RANK_NAME];
 s = GetRankName(playerDB[ playerid ][ specialybe ], playerDB[ playerid ][ rangas ]);
 return s;
}
LoadJobRanks()
{
	new buffer[128], count = 0;
	mysql_query("SELECT * FROM job_ranks");
	mysql_store_result();
	while(mysql_fetch_row_format(buffer, "|"))
		sscanf(buffer, "p<|>e<iis[" #MAX_RANK_NAME "]ii>", RankInfo[ count++ ]);
	mysql_free_result();
	return 1;
}