/* Updates the l_userid parameter for newer user accounts. */
$res = XDB::iterator(
- "SELECT g.g_account_name, a.id
+ "SELECT g.g_account_name, a.uid
FROM gapps_accounts AS g
LEFT JOIN aliases as a ON (a.alias = g.g_account_name AND a.type = 'a_vie')
WHERE (g.l_userid IS NULL OR g.l_userid <= 0) AND a.uid IS NOT NULL");
"UPDATE gapps_accounts
SET l_userid = {?}
WHERE g_account_name = {?}",
- $account['id'], $account['g_account_name']);
+ $account['uid'], $account['g_account_name']);
}
/* Emits a warning for GApps accounts without local uid. */
/* Updates the l_userid parameter for newer nicknames. */
$res = XDB::iterator(
- "SELECT g.g_account_name, a.id
+ "SELECT g.g_account_name, a.uid
FROM gapps_nicknames AS g
LEFT JOIN aliases AS a ON (a.alias = g.g_account_name AND a.type = 'a_vie')
WHERE (g.l_userid IS NULL or g.l_userid <= 0) AND a.uid IS NOT NULL
"UPDATE gapps_nicknames
SET l_userid = {?}
WHERE g_account_name = {?}",
- $nickname['id'], $nickname['g_account_name']);
+ $nickname['uid'], $nickname['g_account_name']);
}
/* Emits a warning for nicknames without local uid. */
"INSERT INTO gapps_queue
SET q_recipient_id = {?}, p_entry_date = NOW(), p_notbefore_date = NOW(),
p_priority = 'offline', j_type = 'n_create', j_parameters = {?}",
- $nickname['id'],
+ $nickname['uid'],
json_encode($nickname));
}
}
"INSERT INTO gapps_queue
SET q_recipient_id = {?}, p_entry_date = NOW(), p_notbefore_date = NOW(),
p_priority = 'offline', j_type = 'n_delete', j_parameters = {?}",
- $nickname['id'],
+ $nickname['uid'],
json_encode($nickname));
}