From 0039bd344c40890a191279083bc3335e05274509 Mon Sep 17 00:00:00 2001 From: cash Date: Tue, 16 Nov 2010 02:20:08 +0000 Subject: Refs #2573 updates the uservalidationbyemail plugin to work with new validation metadata approach git-svn-id: http://code.elgg.org/elgg/trunk@7327 36083f99-b078-4883-b0ff-0f9b5a30f544 --- mod/uservalidationbyemail/lib/functions.php | 26 -------------------------- 1 file changed, 26 deletions(-) (limited to 'mod/uservalidationbyemail/lib/functions.php') diff --git a/mod/uservalidationbyemail/lib/functions.php b/mod/uservalidationbyemail/lib/functions.php index 38822595a..ea77c8d61 100644 --- a/mod/uservalidationbyemail/lib/functions.php +++ b/mod/uservalidationbyemail/lib/functions.php @@ -105,29 +105,3 @@ function uservalidationbyemail_get_user_validation_status($user_guid) { return FALSE; } - -/** - * Returns all users who haven't been validated. - * - * "Unvalidated" means metadata of validated is not set or not truthy. - * We can't use the elgg_get_entities_from_metadata() because you can't say - * "where the entity has metadata set OR it's not equal to 1". - * - * This doesn't include any security, so should be called ONLY be admin users! - * @return array - */ -function uservalidationbyemail_get_unvalidated_users_sql_where() { - global $CONFIG; - - $validated_id = get_metastring_id('validated'); - $one_id = get_metastring_id(1); - - // thanks to daveb@freenode for the SQL tips! - $where = "NOT EXISTS ( - SELECT 1 FROM {$CONFIG->dbprefix}metadata md - WHERE md.entity_guid = e.guid - AND md.name_id = $validated_id - AND md.value_id = $one_id)"; - - return $where; -} \ No newline at end of file -- cgit v1.2.3