static function deleteOnId($mediaId)
{
$mysqli = MySQL\Connection::getInstance()->getHandle();
//sanitize input
settype($mediaId, "integer");
$sql = " delete from sc_media where id = ? ";
MySQL\Helper::executeSQL($mysqli, $sql);
$stmt = $mysqli->prepare($sql);
if ($stmt) {
$stmt->bind_param("i", $mediaId);
$stmt->execute();
if ($mysqli->affected_rows != 1) {
MySQL\Error::handle($stmt);
}
$stmt->close();
} else {
MySQL\Error::handle($mysqli);
}
}
static function capture($emails, $message)
{
$mysqli = MySQL\Connection::getInstance()->getHandle();
$sql = " insert into sc_email_capture(email,message,created_on) values ";
//sanitize message
$message = $mysqli->real_escape_string($message);
$isize = sizeof($emails);
if ($isize == 0) {
return;
}
for ($index = 0; $index < $isize; $index++) {
//last one?
$suffix = $index == $isize - 1 ? "" : ",";
$email = $emails[$index];
//sanitize email
$email = $mysqli->real_escape_string($email);
$sql .= sprintf(" ('%s','%s',now())%s ", $email, $message, $suffix);
}
MySQL\Helper::executeSQL($mysqli, $sql);
}
function process_activities($mysqli)
{
/*
* process activities data
* @imp activities should be brought in the order that they have happened
* so sort on id ASC
*/
$sql = " select * from sc_activity where op_bit = 0 order by id limit 50";
$rows = MySQL\Helper::fetchRows($mysqli, $sql);
$activityDao = new \com\indigloo\sc\dao\Activity();
foreach ($rows as $row) {
try {
$sql2 = " update sc_activity set op_bit = 1 where id = " . $row["id"];
$feed = $activityDao->pushToRedis($row);
$activityDao->sendMail($row, $feed);
//flip the op_bit for this activity
MySQL\Helper::executeSQL($mysqli, $sql2);
} catch (\Exception $ex) {
Logger::getInstance()->error($ex->getMessage());
}
}
}
