| 1 |
<?php |
<?php |
| 2 |
// $Id: import_user.install,v 1.1 2008/10/31 17:51:23 cyberswat Exp $ |
// $Id: import_user.install,v 1.2 2009/04/08 21:42:11 cyberswat Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* @file |
* @file |
| 84 |
$sql_profile_field = "INSERT INTO {profile_fields} (title, name, explanation, category, type, weight, required, register, visibility, autocomplete, options, page) VALUES ('%s', '%s', '%s', '%s', '%s', %d, %d, %d, %d, %d, '%s', '%s')"; |
$sql_profile_field = "INSERT INTO {profile_fields} (title, name, explanation, category, type, weight, required, register, visibility, autocomplete, options, page) VALUES ('%s', '%s', '%s', '%s', '%s', %d, %d, %d, %d, %d, '%s', '%s')"; |
| 85 |
|
|
| 86 |
// insert 100 random users to be imported |
// insert 100 random users to be imported |
| 87 |
_import_user_generate_random_user(100); |
_import_user_generate_random_user(10); |
| 88 |
|
|
| 89 |
// Create example profile fields |
// Create example profile fields |
| 90 |
db_query($sql_profile_field, 'Name', 'profile_name', '', 'Personal Information', 'textfield', 0, 0, 0, 2, 0, '', ''); |
db_query($sql_profile_field, 'Name', 'profile_name', '', 'Personal Information', 'textfield', 0, 0, 0, 2, 0, '', ''); |
| 132 |
db_query("DELETE FROM {profile_fields} WHERE fid = %d", $original_id_field->fid); |
db_query("DELETE FROM {profile_fields} WHERE fid = %d", $original_id_field->fid); |
| 133 |
db_query("DELETE FROM {profile_values} WHERE fid = %d", $name_field->fid); |
db_query("DELETE FROM {profile_values} WHERE fid = %d", $name_field->fid); |
| 134 |
db_query("DELETE FROM {profile_values} WHERE fid = %d", $original_id_field->fid); |
db_query("DELETE FROM {profile_values} WHERE fid = %d", $original_id_field->fid); |
|
db_query("DELETE FROM {import} WHERE type = '%s'", 'user'); |
|
| 135 |
|
|
| 136 |
// Clean up users that were created during this import |
// Clean up users that were created during this import |
| 137 |
$imported_users = db_query("SELECT uid FROM {users} WHERE data LIKE '%%%s%%'", 'profile_original_id'); |
$imported_users = db_query("SELECT uid FROM {users} WHERE data LIKE '%%%s%%'", 'profile_original_id'); |
| 140 |
} |
} |
| 141 |
|
|
| 142 |
// delete from import tables |
// delete from import tables |
| 143 |
db_query("DELETE FROM {import_pass} WHERE type = '%s'", 'user'); |
db_query("DELETE FROM {import} WHERE type = '%s'", 'user'); |
| 144 |
db_query("DELETE FROM {import_pass} WHERE type = '%s'", 'user'); |
db_query("DELETE FROM {import_pass} WHERE type = '%s'", 'user'); |
| 145 |
db_query("DELETE FROM {import_fail} WHERE type = '%s'", 'user'); |
db_query("DELETE FROM {import_fail} WHERE type = '%s'", 'user'); |
| 146 |
|
|