A table used to store recent special events so db admins can see whats happening for instance.

Add event to table


//*********************************************
//*********************************************
//********** ADD API EVENT LOG ENTRY **********
//*********************************************
//*********************************************
function ApiEventLogAdd ($EventType, $EventText)
{
  global $dblink;
	
	//----- DELETE OLD EVENTS -----
	mysqli_query($dblink, "DELETE FROM tblApiEventsLog WHERE EventTime < DATE_SUB(now(), INTERVAL 30 DAY)");
	
	//----- ADD THE NEW EVENT -----
	$EventType = intval($EventType);
	$EventText = mysqli_real_escape_string($dblink, $EventText);
	
	mysqli_query($dblink, "INSERT INTO tblApiEventsLog (
				EventTime,
				EventType,
				EventMessage
			) VALUES (
				Now(),
				$EventType,
				'$EventText'
			)");
}
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published.