stock GetUserIDByName(name[])
{
	new Cache:reports,query[128];
 	mysql_format(mysqlconnect, query, sizeof(query), "SELECT * FROM user WHERE username = '%s'", name);
    reports = mysql_query(mysqlconnect, query, true);
    new count = cache_num_rows();
    if(count > 0)
    {
        for(new i = 0; i < count; i++)
        {
            new userID;
	    	cache_get_value_name_int(0, "userID", userID);
			return userID;
        }
    }
    else return 0;
    cache_delete(reports);
	return 1;
}