function xfac_user_deleteRecord($record)
{
global $wpdb;
$tblAuth = xfac_getTableAuth();
wp_cache_delete($record->user_id, XFAC_CACHE_RECORDS_BY_USER_ID);
return $wpdb->delete($tblAuth, array('id' => $record->id));
}
function xfac_install()
{
global $wpdb;
$currentVersion = 13;
$installedVersion = intval(get_option('xfac_version'));
$tblAuth = xfac_getTableAuth();
$tblSync = $wpdb->prefix . 'xfac_sync';
if ($installedVersion < 1) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
dbDelta('
CREATE TABLE ' . $tblAuth . ' (
id INT(11) NOT NULL AUTO_INCREMENT,
user_id INT(11) NOT NULL,
provider VARCHAR(50) NOT NULL,
identifier VARCHAR(100) NOT NULL,
profile MEDIUMBLOB,
token MEDIUMBLOB,
PRIMARY KEY (id),
UNIQUE KEY `user_id` (`user_id`)
);
');
}
if ($installedVersion < 2) {
if (!$wpdb->get_col($wpdb->prepare('SHOW KEYS FROM ' . $tblAuth . ' WHERE key_name = %s', 'user_id'))) {
$wpdb->query('ALTER TABLE ' . $tblAuth . ' ADD UNIQUE KEY `user_id` (`user_id`);');
}
}
if ($installedVersion < 3) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
dbDelta('
CREATE TABLE ' . $tblSync . ' (
provider VARCHAR(50) NOT NULL,
provider_content_type VARCHAR(50) NOT NULL,
provider_content_id VARCHAR(100) NOT NULL,
sync_id INT(11) NOT NULL,
sync_date INT(10) UNSIGNED NOT NULL,
sync_data MEDIUMBLOB,
PRIMARY KEY (provider, provider_content_type, provider_content_id, sync_id)
);
');
}
if ($installedVersion < 4) {
update_option('xfac_sync_post_wp_xf', 1);
update_option('xfac_sync_post_xf_wp', 1);
update_option('xfac_sync_comment_wp_xf', 1);
update_option('xfac_sync_comment_xf_wp', 1);
}
if ($installedVersion < 6) {
update_option('xfac_sync_avatar_xf_wp', 1);
}
if ($installedVersion < 10) {
update_option('xfac_sync_post_wp_xf_link', 1);
}
if ($installedVersion < 13) {
update_option('xfac_sync_role', array('administrator' => -1, 'editor' => 4, 'subscriber' => 2));
update_option('xfac_sync_role_wp_xf', 1);
}
if ($installedVersion < $currentVersion) {
update_option('xfac_version', $currentVersion);
}
xfac_setupCrons();
}
