function save() { $ou = base64_decode($_GET["ou"]); if ($_GET["database"] == null) { $_GET["database"] = basename($_GET["filepath"]); } $_GET["database"] = format_mysql_table($_GET["database"]); $sql = "INSERT INTO emailing_db_paths (filepath,databasename,ou,zDate) VALUES('{$_GET["filepath"]}','{$_GET["database"]}','{$ou}',NOW());"; $q = new mysql(); $q->check_emailing_tables(); $q->QUERY_SQL($sql, "artica_backup"); if (!$q->ok) { echo $q->mysql_error; return; } $sock = new sockets(); $sock->getFrameWork("cmd.php?emailing-import-contacts=yes"); }
function mailer_link_add() { $p = base64_encode(serialize($_GET)); $ou = base64_decode($_GET["ou"]); $sql = "INSERT INTO emailing_campain_linker (template_id,database_id,parameters,ou,name,zdate)\n\tVALUES('{$_GET["template_id"]}','{$_GET["database_id"]}','{$p}','{$ou}','{$_GET["campain_name"]}',NOW())"; if ($_GET["ID"] > 0) { $sql = "UPDATE emailing_campain_linker SET \n\t\t\ttemplate_id='{$_GET["template_id"]}',\n\t\t\tdatabase_id='{$_GET["database_id"]}',\n\t\t\tname ='{$_GET["campain_name"]}',\n\t\t\tparameters='{$p}' WHERE ID='{$_GET["ID"]}'"; } $q = new mysql(); $q->check_emailing_tables(); $q->QUERY_SQL($sql, "artica_backup"); if (!$q->ok) { echo $q->mysql_error . "\nLine:" . __LINE__ . "\nOf:" . basename(__FILE__); return; } }
function mass_mailing_finish($task_success) { $SartOff = time(); $q = new mysql(); $q->check_emailing_tables(); $time_duration = distanceOfTimeInWords($GLOBALS["SartON"], $SartOff); $logs = @implode("\n", $GLOBALS["EVENTS_DETAILS"]); unset($GLOBALS["EVENTS_DETAILS"]); event(__FUNCTION__, __LINE__, "Building queue finish"); $q->QUERY_SQL("UPDATE `emailing_campain_linker` SET `queue_builder_pourc`=100,`locked`=0 WHERE `ID`={$GLOBALS["campain_linker_id"]}", "artica_backup"); if (!$q->ok) { event(__FUNCTION__, __LINE__, $q->mysql_error); } $sql = "INSERT INTO `emailing_campain_events` (`campain_linker_id`,`template_id`,`database_id`,`zDate`,\n\t`time_duration`,\n\t`messages_number`,\n\t`massmailing_size`,\n\t`events_details`,\n\t`task_success`)\n\tVALUES('{$GLOBALS["campain_linker_id"]}','{$GLOBALS["template_id"]}','{$GLOBALS["database_id"]}','{$GLOBALS["start_date_task"]}',\n\t'{$time_duration}',\n\t'{$GLOBALS["messages_number"]}',\n\t'{$GLOBALS["massmailing_size"]}',\n\t'{$logs}',\n\t'{$task_success}'\n\t)"; $q->QUERY_SQL($sql, "artica_backup"); if (!$q->ok) { event(__FUNCTION__, __LINE__, $q->mysql_error . "\n\n{$sql}\n\n"); } $GLOBALS["messages_number"] = 0; $GLOBALS["start_date_task"] = null; $GLOBALS["massmailing_size"] = 0; }