SetTimer("FetchAdminMessages",5000,1);

#define RESULT_ADMINCHAT 1

forward public FetchAdminMessages();
public FetchAdminMessages()
{
	mysql_query("SELECT * FROM `adminchat` WHERE `received` = '0'",RESULT_ADMINCHAT);
	return 1
}

public OnQueryFinish(query[],resultid,extraid)
{
	switch(resultid)
	{
	    case (RESULT_ADMINCHAT):
	    {
	        mysql_store_result();
	        while(mysql_retrieve_row())
	        {
	            new sender[24],message[100];
	            mysql_fetch_field_row(sender,"sender");
	            mysql_fetch_field_row(message,"message");
	            format(string,sizeof(string),"ACP %s: %s",sender,message);
	            SendToAdmins(-1,string);
			}
			mysql_free_result();
			mysql_query("UPDATE `adminchat` SET `received` = '1'");
		}
	}
	return 1;
}

// or

public FetchAdminMessages()
{
	mysql_query("SELECT * FROM `adminchat` WHERE `received` = '0'",RESULT_ADMINCHAT);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        new sender[24],message[100];
        mysql_fetch_field_row(sender,"sender");
        mysql_fetch_field_row(message,"message");
        format(string,sizeof(string),"ACP %s: %s",sender,message);
        SendToAdmins(-1,string);
	}
	mysql_free_result();
	mysql_query("UPDATE `adminchat` SET `received` = '1'");
	return 1
}