PHP begin_congregation_update Exemples

Exemple #1

Fichier : database.php Projet : sirchuy/disciples-congregation-search

function create_congregation_search_table()
{
    global $wpdb;
    $table_name = $wpdb->prefix . get_congregation_search_table_name();
    $log_table_name = $wpdb->prefix . get_congregation_search_table_name() . '_Log';
    $query_table_name = $wpdb->prefix . get_congregation_search_table_name() . '_Q_History';
    // check to see if the table has already been created
    if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") != $table_name) {
        $charset_collate = $wpdb->get_charset_collate();
        $sql = "CREATE TABLE {$table_name} ( \n\t\t\tPIN int NOT NULL,\n\t\t\tChurch_Name varchar(75) NOT NULL,\n\t\t\tEIN varchar(15),\n\t\t\tYearbook_Address_Line_1 varchar(50),\n\t\t\tYearbook_Address_Line_2 varchar(50),\n\t\t\tYearbook_Zip varchar(10),\n\t\t\tYearbook_City varchar(50),\n\t\t\tYearbook_State varchar(2),\n\t\t\tMailing_Address_Line_1 varchar(50),\n\t\t\tMailing_Address_Line_2 varchar(50),\n\t\t\tMailing_Zip varchar(10),\n\t\t\tMailing_City varchar(50),\n\t\t\tMailing_State varchar(2),\n\t\t\tCounty varchar(50),\n\t\t\tCountry varchar(50),\n\t\t\tPhone varchar(20),\n\t\t\tFax varchar(20),\n\t\t\tEmail_Address varchar(75),\n\t\t\tWeb_Address varchar(100),\n\t\t\tRegion varchar(50),\n\t\t\tDistrict varchar(50),\n\t\t\tYearbook_Code varchar(1),\n\t\t\tMinister_Email varchar(100),\n\t\t\tCode int,\n\t\t\tDate_Updated datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,\n\t\t\tDoNotAutoUpdate tinyint(1),\n\t\t\tLatitude decimal(9,6),\n\t\t\tLongitude decimal(9,6),\n\t\t\tGeocode_Confidence varchar(25),\n\t\t\tGoogle_Maps_Link varchar(255),\n\t\t\tPRIMARY KEY  (PIN),\n\t\t\tKEY EIN (EIN)\n\t\t) ENGINE=MyISAM  {$charset_collate} ;";
        require_once ABSPATH . 'wp-admin/includes/upgrade.php';
        dbDelta($sql);
        $sql_log_table = "CREATE TABLE {$log_table_name} (\n\t\t\tLogID mediumint(9) NOT NULL AUTO_INCREMENT,\n\t\t\tLogDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,\n\t\t\tEntryType varchar(15),\n\t\t\tMessage varchar(255),\n\t\t\tPRIMARY KEY  (LogID),\n\t\t\tKEY LogDate (LogDate) \n\t\t) ENGINE=MyISAM  {$charset_collate} ;";
        dbDelta($sql_log_table);
        $sql_query_table = "CREATE TABLE {$query_table_name} (\n\t\t  QID int NOT NULL AUTO_INCREMENT,\n\t\t  Query VARCHAR(80) NOT NULL,\n\t\t  Latitude DECIMAL(9,6) NULL,\n\t\t  Longitude DECIMAL(9,6) NULL,\n\t\t  HitCount INT NULL,\n\t\t  LastUpdated DATETIME NULL,\n\t\t  PRIMARY KEY  (QID),\n\t\t  KEY Query (Query)\n\t\t  ) ENGINE=MyISAM  {$charset_collate} ;";
        dbDelta($sql_query_table);
        // run update service to input initial data.
        begin_congregation_update();
    }
}

Exemple #2

Fichier : ajax.php Projet : sirchuy/disciples-congregation-search

function begin_manual_congregation_update()
{
    // start the update
    // will return an array [0]=>true|false of success and [1]=>status message to display.
    $UpdateResult = begin_congregation_update();
    $ResultResponse = '';
    if ($UpdateResult != null) {
        $ResultResponse['result'] = $UpdateResult[0];
        $ResultResponse['message'] = $UpdateResult[1];
    } else {
        $ResultResponse['result'] = false;
        $ResultResponse['message'] = 'Unknown error occured when attempting to update congregations. Check the log file for details.';
    }
    echo json_encode($ResultResponse);
    die;
}

Exemple #3

Fichier : updateservice.php Projet : sirchuy/disciples-congregation-search

function CongregationUpdateScheduling()
{
    begin_congregation_update();
}