Esempi in PHP per mysql::check_emailing_tables

Esempio n. 1

File: domains.emailings.import.php Progetto: brucewu16899/1.6.x

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");
}

Esempio n. 2

File: domains.emailings.builder.php Progetto: brucewu16899/1.6.x

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;
    }
}

Esempio n. 3

File: exec.emailing.php Progetto: BillTheBest/1.6.x

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;
}