#date needs to be yyyy-mm-dd

if not agent.startswith('@'):

agent = '@' + agent

print(agent)

sql1 = "SELECT idagents FROM agents WHERE `name`='{}';".format(agent)

print(sql1)

agentid = exec_mysql(sql1)[0][0]

print(agentid)

sql2 = "UPDATE `agent_stats`.`stats` SET `flag`='{flag}' WHERE `idagents`='{agentid}' and`date`='{date}';".format(agentid=agentid, date=date, flag=flag)

print(sql2)

exec_mysql(sql2)