Contact Us

FM Gizmo

Field Marketing Made Easier Than Ever

What is FM Gizmo?

FMGizmo is an easy-to-use cloud-based system with a user-friendly mobile app for the field team. It helps you in managing Field Marketing Activities efficiently.

All data captured by your field team is uploaded to the FMGizmo Cloud instantly. No hassles of paperwork, emails or messaging! FM Gizmo provides interactive dashboards and customised reports that make you shine in front of your Clients. Now, you and your Clients can not only monitor the activity in real-time but also take corrective actions swiftly, this ensures your activity is always aligned with the campaign objective.

Switch to FM Gizmo today and streamline your activity management process. Spend more time expanding your business rather than be consumed by the administrative tasks.

FM Gizmo Mobile App

User friendly

Our easy-to-use mobile app ensures your field teams can effortlessly adapt to FM Gizmo

Zero Paperwork

With cloud technology, every significant detail recorded in the mobile app is uploaded to our reliable and secured cloud eliminating the need for paperwork.

Geotagged

Information collected on the FM Gizmo App is Timestamped and Geotagged

Collect, Analyze, Deliver

Collect your information in Real-time, Evaluate field operations and Deliver better results

Mobile Verification

FM Gizmo offers verification of Mobile numbers collected during the activity. This ensures the authenticity of data and limits the need for data auditing

Realtime

Data is collected and sent to the cloud in real-time. This ensures close monitoring of the activities undertaken.

The FM Gizmo Cloud

Interactive Dashboards

Wow your clients by giving them Interactive Dashboards as per their needs!

Customizable Reports

FM Gizmo offers completely customizable reporting to meet your exact needs.

Realtime Data

FM Gizmo delivers data in real-time allowing you to give timely feedback to your team and take corrective decisions instantly.

Workflow Integration

Integrate your routine processes directly into FM Gizmo. FM Gizmo is equipped with workflows like Recce thru Implementation, Accept-Reject-Redo and many more.

Reliable

With a well-managed service platform, FM Gizmo is much more reliable and consistent than any in-house IT infrastructure.

Scalable

You can easily increase or decrease your cloud capacity according to your requirement. You only pay for what you need.

Salient Features

Realtime Data

Easy to Use

Geotagged

Customizable

Reliable

Scalable

How does it work?

A Simple 5 step process

Choose your activity

Retail Seeding, Rural Market Activations, Branding, Merchandizing, BTL, Haat etc.

Create your team

Create logins for your field team and their managers. Optionally you can also assign the route plan for your field team.

Customize the app to match your requirements

Choose what data is required to be collected and you are ready to start your activity.

Choose your dashboards

Choose from our predefined dashboards templates or tell us what you need and we will create one for you.

Get set go

You are ready to start your activity and make your field activity management easier than ever.

EXPAND YOUR HORIZONS

Switch to Working Wisely

About Us

Solutions that Work

Whether you are a start-up or an MNC, we believe in providing tailor-made solutions that will give you a decisive edge over your competition

Experience Matters

With our extensive expertise in market research and related mobility solutions, we offer you a platform that delivers

Cost Effective

FM Gizmo is a cost-effective solution that also brings down your activity management overheads considerably

Strong Support

Our dedicated support team ensures your field team can reach out to us if they ever face any difficulties on the field

So why wait, order FM Gizmo now and switch to working wisely!

About FM Gizmo

FM Gizmo is a one-stop field marketing solution.

FM Gizmo's customizability can help you fulfil all your field activity needs.

Order FM Gizmo now and Switch to working wisely.

Get In Touch

912, Opal Square, Wagle Estate, Thane(W) - 400604, Maharashtra

sales@fmgizmo.com

<?php /** * @file * Install, update and uninstall functions for the user module. */ /** * Implements hook_schema(). */ function user_schema() { $schema['authmap'] = array( 'description' => 'Stores distributed authentication mapping.', 'fields' => array( 'aid' => array( 'description' => 'Primary Key: Unique authmap ID.', 'type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, ), 'uid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => "User's {users}.uid.", ), 'authname' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', 'description' => 'Unique authentication name.', ), 'module' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', 'description' => 'Module which is controlling the authentication.', ), ), 'unique keys' => array( 'authname' => array('authname'), ), 'primary key' => array('aid'), 'foreign keys' => array( 'user' => array( 'table' => 'users', 'columns' => array('uid' => 'uid'), ), ), 'indexes' => array( 'uid_module' => array('uid', 'module'), ), ); $schema['role_permission'] = array( 'description' => 'Stores the permissions assigned to user roles.', 'fields' => array( 'rid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'description' => 'Foreign Key: {role}.rid.', ), 'permission' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', 'description' => 'A single permission granted to the role identified by rid.', ), 'module' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', 'description' => "The module declaring the permission.", ), ), 'primary key' => array('rid', 'permission'), 'indexes' => array( 'permission' => array('permission'), ), 'foreign keys' => array( 'role' => array( 'table' => 'role', 'columns' => array('rid' => 'rid'), ), ), ); $schema['role'] = array( 'description' => 'Stores user roles.', 'fields' => array( 'rid' => array( 'type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, 'description' => 'Primary Key: Unique role ID.', ), 'name' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', 'description' => 'Unique role name.', 'translatable' => TRUE, ), 'weight' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'The weight of this role in listings and the user interface.', ), ), 'unique keys' => array( 'name' => array('name'), ), 'primary key' => array('rid'), 'indexes' => array( 'name_weight' => array('name', 'weight'), ), ); // The table name here is plural, despite Drupal table naming standards, // because "user" is a reserved word in many databases. $schema['users'] = array( 'description' => 'Stores user data.', 'fields' => array( 'uid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'description' => 'Primary Key: Unique user ID.', 'default' => 0, ), 'name' => array( 'type' => 'varchar', 'length' => 60, 'not null' => TRUE, 'default' => '', 'description' => 'Unique user name.', ), 'pass' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', 'description' => "User's password (hashed).", ), 'mail' => array( 'type' => 'varchar', 'length' => 254, 'not null' => FALSE, 'default' => '', 'description' => "User's e-mail address.", ), 'theme' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', 'description' => "User's default theme.", ), 'signature' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', 'description' => "User's signature.", ), 'signature_format' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, 'description' => 'The {filter_format}.format of the signature.', ), 'created' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'Timestamp for when user was created.', ), 'access' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'Timestamp for previous time user accessed the site.', ), 'login' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => "Timestamp for user's last login.", ), 'status' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'size' => 'tiny', 'description' => 'Whether the user is active(1) or blocked(0).', ), 'timezone' => array( 'type' => 'varchar', 'length' => 32, 'not null' => FALSE, 'description' => "User's time zone.", ), 'language' => array( 'type' => 'varchar', 'length' => 12, 'not null' => TRUE, 'default' => '', 'description' => "User's default language.", ), 'picture' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => "Foreign key: {file_managed}.fid of user's picture.", ), 'init' => array( 'type' => 'varchar', 'length' => 254, 'not null' => FALSE, 'default' => '', 'description' => 'E-mail address used for initial account creation.', ), 'data' => array( 'type' => 'blob', 'not null' => FALSE, 'size' => 'big', 'serialize' => TRUE, 'description' => 'A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored and are loaded into the $user object during user_load(). Use of this field is discouraged and it will likely disappear in a future version of Drupal.', ), ), 'indexes' => array( 'access' => array('access'), 'created' => array('created'), 'mail' => array('mail'), 'picture' => array('picture'), ), 'unique keys' => array( 'name' => array('name'), ), 'primary key' => array('uid'), 'foreign keys' => array( 'signature_format' => array( 'table' => 'filter_format', 'columns' => array('signature_format' => 'format'), ), ), ); $schema['users_roles'] = array( 'description' => 'Maps users to roles.', 'fields' => array( 'uid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'description' => 'Primary Key: {users}.uid for user.', ), 'rid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'description' => 'Primary Key: {role}.rid for role.', ), ), 'primary key' => array('uid', 'rid'), 'indexes' => array( 'rid' => array('rid'), ), 'foreign keys' => array( 'user' => array( 'table' => 'users', 'columns' => array('uid' => 'uid'), ), 'role' => array( 'table' => 'role', 'columns' => array('rid' => 'rid'), ), ), ); return $schema; } /** * Implements hook_install(). */ function user_install() { // Insert a row for the anonymous user. db_insert('users') ->fields(array( 'uid' => 0, 'name' => '', 'mail' => '', )) ->execute(); // We need some placeholders here as name and mail are uniques and data is // presumed to be a serialized array. This will be changed by the settings // form in the installer. db_insert('users') ->fields(array( 'uid' => 1, 'name' => 'placeholder-for-uid-1', 'mail' => 'placeholder-for-uid-1', 'created' => REQUEST_TIME, 'status' => 1, 'data' => NULL, )) ->execute(); // Built-in roles. $rid_anonymous = db_insert('role') ->fields(array('name' => 'anonymous user', 'weight' => 0)) ->execute(); $rid_authenticated = db_insert('role') ->fields(array('name' => 'authenticated user', 'weight' => 1)) ->execute(); // Sanity check to ensure the anonymous and authenticated role IDs are the // same as the drupal defined constants. In certain situations, this will // not be true. if ($rid_anonymous != DRUPAL_ANONYMOUS_RID) { db_update('role') ->fields(array('rid' => DRUPAL_ANONYMOUS_RID)) ->condition('rid', $rid_anonymous) ->execute(); } if ($rid_authenticated != DRUPAL_AUTHENTICATED_RID) { db_update('role') ->fields(array('rid' => DRUPAL_AUTHENTICATED_RID)) ->condition('rid', $rid_authenticated) ->execute(); } } /** * Implements hook_update_dependencies(). */ function user_update_dependencies() { // user_update_7006() updates data in the {role_permission} table, so it must // run after system_update_7007(), which populates that table. $dependencies['user'][7006] = array( 'system' => 7007, ); // user_update_7010() needs to query the {filter_format} table to get a list // of existing text formats, so it must run after filter_update_7000(), which // creates that table. $dependencies['user'][7010] = array( 'filter' => 7000, ); // user_update_7012() uses the file API and inserts records into the // {file_managed} table, so it therefore must run after system_update_7061(), // which inserts files with specific IDs into the table and therefore relies // on the table being empty (otherwise it would accidentally overwrite // existing records). $dependencies['user'][7012] = array( 'system' => 7061, ); // user_update_7013() uses the file usage API, which relies on the // {file_usage} table, so it must run after system_update_7059(), which // creates that table. $dependencies['user'][7013] = array( 'system' => 7059, ); return $dependencies; } /** * Utility function: grant a set of permissions to a role during update. * * This function is valid for a database schema version 7000. * * @param $rid * The role ID. * @param $permissions * An array of permissions names. * @param $module * The name of the module defining the permissions. * @ingroup update_api */ function _update_7000_user_role_grant_permissions($rid, array $permissions, $module) { // Grant new permissions for the role. foreach ($permissions as $name) { db_merge('role_permission') ->key(array( 'rid' => $rid, 'permission' => $name, )) ->fields(array( 'module' => $module, )) ->execute(); } } /** * @addtogroup updates-6.x-to-7.x * @{ */ /** * Increase the length of the password field to accommodate better hashes. * * Also re-hashes all current passwords to improve security. This may be a * lengthy process, and is performed batch-wise. */ function user_update_7000(&$sandbox) { $sandbox['#finished'] = 0; // Lower than DRUPAL_HASH_COUNT to make the update run at a reasonable speed. $hash_count_log2 = 11; // Multi-part update. if (!isset($sandbox['user_from'])) { db_change_field('users', 'pass', 'pass', array('type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '')); $sandbox['user_from'] = 0; $sandbox['user_count'] = db_query("SELECT COUNT(uid) FROM {users}")->fetchField(); } else { require_once DRUPAL_ROOT . '/' . variable_get('password_inc', 'includes/password.inc'); // Hash again all current hashed passwords. $has_rows = FALSE; // Update this many per page load. $count = 1000; $result = db_query_range("SELECT uid, pass FROM {users} WHERE uid > 0 ORDER BY uid", $sandbox['user_from'], $count); foreach ($result as $account) { $has_rows = TRUE; // If the $account->pass value is not a MD5 hash (a 32 character // hexadecimal string) then skip it. if (!preg_match('/^[0-9a-f]{32}$/', $account->pass)) { continue; } $new_hash = user_hash_password($account->pass, $hash_count_log2); if ($new_hash) { // Indicate an updated password. $new_hash = 'U' . $new_hash; db_update('users') ->fields(array('pass' => $new_hash)) ->condition('uid', $account->uid) ->execute(); } } $sandbox['#finished'] = $sandbox['user_from']/$sandbox['user_count']; $sandbox['user_from'] += $count; if (!$has_rows) { $sandbox['#finished'] = 1; return t('User passwords rehashed to improve security'); } } } /** * Remove the 'threshold', 'mode' and 'sort' columns from the {users} table. * * These fields were previously used to store per-user comment settings. */ function user_update_7001() { db_drop_field('users', 'threshold'); db_drop_field('users', 'mode'); db_drop_field('users', 'sort'); } /** * Convert user time zones from time zone offsets to time zone names. */ function user_update_7002(&$sandbox) { $sandbox['#finished'] = 0; // Multi-part update. if (!isset($sandbox['user_from'])) { db_change_field('users', 'timezone', 'timezone', array('type' => 'varchar', 'length' => 32, 'not null' => FALSE)); $sandbox['user_from'] = 0; $sandbox['user_count'] = db_query("SELECT COUNT(uid) FROM {users}")->fetchField(); $sandbox['user_not_migrated'] = 0; } else { $timezones = system_time_zones(); // Update this many per page load. $count = 10000; $contributed_date_module = db_field_exists('users', 'timezone_name'); $contributed_event_module = db_field_exists('users', 'timezone_id'); $results = db_query_range("SELECT uid FROM {users} ORDER BY uid", $sandbox['user_from'], $count); foreach ($results as $account) { $timezone = NULL; // If the contributed Date module has created a users.timezone_name // column, use this data to set each user's time zone. if ($contributed_date_module) { $date_timezone = db_query("SELECT timezone_name FROM {users} WHERE uid = :uid", array(':uid' => $account->uid))->fetchField(); if (isset($timezones[$date_timezone])) { $timezone = $date_timezone; } } // If the contributed Event module has stored user time zone information // use that information to update the user accounts. if (!$timezone && $contributed_event_module) { try { $event_timezone = db_query("SELECT t.name FROM {users} u LEFT JOIN {event_timezones} t ON u.timezone_id = t.timezone WHERE u.uid = :uid", array(':uid' => $account->uid))->fetchField(); $event_timezone = str_replace(' ', '_', $event_timezone); if (isset($timezones[$event_timezone])) { $timezone = $event_timezone; } } catch (PDOException $e) { // Ignore error if event_timezones table does not exist or unexpected // schema found. } } if ($timezone) { db_update('users') ->fields(array('timezone' => $timezone)) ->condition('uid', $account->uid) ->execute(); } else { $sandbox['user_not_migrated']++; db_update('users') ->fields(array('timezone' => NULL)) ->condition('uid', $account->uid) ->execute(); } $sandbox['user_from']++; } $sandbox['#finished'] = $sandbox['user_from'] / $sandbox['user_count']; if ($sandbox['user_from'] == $sandbox['user_count']) { if ($sandbox['user_not_migrated'] > 0) { variable_set('empty_timezone_message', 1); drupal_set_message(format_string('Some user time zones have been emptied and need to be set to the correct values. Use the new <a href="@config-url">time zone options</a> to choose whether to remind users at login to set the correct time zone.', array('@config-url' => url('admin/config/regional/settings'))), 'warning'); } return t('Migrated user time zones'); } } } /** * Update user settings for cancelling user accounts. * * Prior to 7.x, users were not able to cancel their accounts. When * administrators deleted an account, all contents were assigned to uid 0, * which is the same as the 'user_cancel_reassign' method now. */ function user_update_7003() { // Set the default account cancellation method. variable_set('user_cancel_method', 'user_cancel_reassign'); // Re-assign notification setting. if ($setting = variable_get('user_mail_status_deleted_notify', FALSE)) { variable_set('user_mail_status_canceled_notify', $setting); variable_del('user_mail_status_deleted_notify'); } // Re-assign "Account deleted" mail strings to "Account canceled" mail. if ($setting = variable_get('user_mail_status_deleted_subject', FALSE)) { variable_set('user_mail_status_canceled_subject', $setting); variable_del('user_mail_status_deleted_subject'); } if ($setting = variable_get('user_mail_status_deleted_body', FALSE)) { variable_set('user_mail_status_canceled_body', $setting); variable_del('user_mail_status_deleted_body'); } } /** * Changes the users table to allow longer e-mail addresses. */ function user_update_7005(&$sandbox) { $mail_field = array( 'type' => 'varchar', 'length' => 254, 'not null' => FALSE, 'default' => '', 'description' => "User's e-mail address.", ); $init_field = array( 'type' => 'varchar', 'length' => 254, 'not null' => FALSE, 'default' => '', 'description' => 'E-mail address used for initial account creation.', ); db_drop_index('users', 'mail'); db_change_field('users', 'mail', 'mail', $mail_field, array('indexes' => array('mail' => array('mail')))); db_change_field('users', 'init', 'init', $init_field); } /** * Add module data to {role_permission}. */ function user_update_7006(&$sandbox) { $module_field = array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', 'description' => "The module declaring the permission.", ); // Check that the field hasn't been updated in an aborted run of this // update. if (!db_field_exists('role_permission', 'module')) { // Add a new field for the fid. db_add_field('role_permission', 'module', $module_field); } } /** * Add a weight column to user roles. */ function user_update_7007() { db_add_field('role', 'weight', array('type' => 'int', 'not null' => TRUE, 'default' => 0)); db_add_index('role', 'name_weight', array('name', 'weight')); } /** * If 'user_register' variable was unset in Drupal 6, set it to be the same as * the Drupal 6 default setting. */ function user_update_7008() { if (!isset($GLOBALS['conf']['user_register'])) { // Set to the Drupal 6 default, "visitors can create accounts". variable_set('user_register', USER_REGISTER_VISITORS); } } /** * Converts fields that store serialized variables from text to blob. */ function user_update_7009() { $spec = array( 'type' => 'blob', 'not null' => FALSE, 'size' => 'big', 'serialize' => TRUE, 'description' => 'A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored and are loaded into the $user object during user_load(). Use of this field is discouraged and it will likely disappear in a future version of Drupal.', ); db_change_field('users', 'data', 'data', $spec); } /** * Update the {user}.signature_format column. */ function user_update_7010() { // Update the database column to allow NULL values. db_change_field('users', 'signature_format', 'signature_format', array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'description' => 'The {filter_format}.format of the signature.', )); // Replace the signature format with NULL if the signature is empty and does // not already have a stored text format. // // In Drupal 6, "0" (the former FILTER_FORMAT_DEFAULT constant) could be used // to indicate this situation, but in Drupal 7, only NULL is supported. This // update therefore preserves the ability of user accounts which were never // given a signature (for example, if the site did not have user signatures // enabled, or if the user never edited their account information) to not // have a particular text format assumed for them the first time the // signature is edited. db_update('users') ->fields(array('signature_format' => NULL)) ->condition('signature', '') ->condition('signature_format', 0) ->execute(); // There are a number of situations in which a Drupal 6 site could store // content with a nonexistent text format. This includes text formats that // had later been deleted, or non-empty content stored with a value of "0" // (the former FILTER_FORMAT_DEFAULT constant). Drupal 6 would filter this // content using whatever the site-wide default text format was at the moment // the text was being displayed. // // In Drupal 7, this behavior is no longer supported, and all content must be // stored with an explicit text format (or it will not be displayed when it // is filtered). Therefore, to preserve the behavior of the site after the // upgrade, we must replace all instances described above with the current // value of the (old) site-wide default format at the moment of the upgrade. $existing_formats = db_query("SELECT format FROM {filter_format}")->fetchCol(); $default_format = variable_get('filter_default_format', 1); db_update('users') ->fields(array('signature_format' => $default_format)) ->isNotNull('signature_format') ->condition('signature_format', $existing_formats, 'NOT IN') ->execute(); } /** * Placeholder function. * * As a fix for user_update_7011() not updating email templates to use the new * tokens, user_update_7017() now targets email templates of Drupal 6 sites and * already upgraded sites. */ function user_update_7011() { } /** * Add the user's pictures to the {file_managed} table and make them managed * files. */ function user_update_7012(&$sandbox) { $picture_field = array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => "Foreign key: {file_managed}.fid of user's picture.", ); if (!isset($sandbox['progress'])) { // Check that the field hasn't been updated in an aborted run of this // update. if (!db_field_exists('users', 'picture_fid')) { // Add a new field for the fid. db_add_field('users', 'picture_fid', $picture_field); } // Initialize batch update information. $sandbox['progress'] = 0; $sandbox['last_user_processed'] = -1; $sandbox['max'] = db_query("SELECT COUNT(*) FROM {users} WHERE picture <> ''")->fetchField(); } // As a batch operation move the photos into the {file_managed} table and // update the {users} records. $limit = 500; $result = db_query_range("SELECT uid, picture FROM {users} WHERE picture <> '' AND uid > :uid ORDER BY uid", 0, $limit, array(':uid' => $sandbox['last_user_processed'])); foreach ($result as $user) { // Don't bother adding files that don't exist. if (file_exists($user->picture)) { // Check if the file already exists. $files = file_load_multiple(array(), array('uri' => $user->picture)); if (count($files)) { $file = reset($files); } else { // Create a file object. $file = new stdClass(); $file->uri = $user->picture; $file->filename = drupal_basename($file->uri); $file->filemime = file_get_mimetype($file->uri); $file->uid = $user->uid; $file->status = FILE_STATUS_PERMANENT; $file = file_save($file); } db_update('users') ->fields(array('picture_fid' => $file->fid)) ->condition('uid', $user->uid) ->execute(); } // Update our progress information for the batch update. $sandbox['progress']++; $sandbox['last_user_processed'] = $user->uid; } // Indicate our current progress to the batch update system. If there's no // max value then there's nothing to update and we're finished. $sandbox['#finished'] = empty($sandbox['max']) ? 1 : ($sandbox['progress'] / $sandbox['max']); // When we're finished, drop the old picture field and rename the new one to // replace it. if (isset($sandbox['#finished']) && $sandbox['#finished'] == 1) { db_drop_field('users', 'picture'); db_change_field('users', 'picture_fid', 'picture', $picture_field); } } /** * Add user module file usage entries. */ function user_update_7013(&$sandbox) { if (!isset($sandbox['progress'])) { // Initialize batch update information. $sandbox['progress'] = 0; $sandbox['last_uid_processed'] = -1; $sandbox['max'] = db_query("SELECT COUNT(*) FROM {users} u WHERE u.picture <> 0")->fetchField(); } // Add usage entries for the user picture files. $limit = 500; $result = db_query_range('SELECT f.*, u.uid as user_uid FROM {users} u INNER JOIN {file_managed} f ON u.picture = f.fid WHERE u.picture <> 0 AND u.uid > :uid ORDER BY u.uid', 0, $limit, array(':uid' => $sandbox['last_uid_processed']))->fetchAllAssoc('fid', PDO::FETCH_ASSOC); foreach ($result as $row) { $uid = $row['user_uid']; $file = (object) $row; file_usage_add($file, 'user', 'user', $uid); // Update our progress information for the batch update. $sandbox['progress']++; $sandbox['last_uid_processed'] = $uid; } // Indicate our current progress to the batch update system. $sandbox['#finished'] = empty($sandbox['max']) || ($sandbox['progress'] / $sandbox['max']); } /** * Rename the 'post comments without approval' permission. * * In Drupal 7, this permission has been renamed to 'skip comment approval'. */ function user_update_7014() { db_update('role_permission') ->fields(array('permission' => 'skip comment approval')) ->condition('permission', 'post comments without approval') ->execute(); return t("Renamed the 'post comments without approval' permission to 'skip comment approval'."); } /** * Change {users}.signature_format into varchar. */ function user_update_7015() { db_change_field('users', 'signature_format', 'signature_format', array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, 'description' => 'The {filter_format}.format of the signature.', )); } /** * @} End of "addtogroup updates-6.x-to-7.x". */ /** * @addtogroup updates-7.x-extra * @{ */ /** * Update the database to match the schema. */ function user_update_7016() { // Add field default. db_change_field('users', 'uid', 'uid', array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, )); } /** * Update email templates to use new tokens. * * This function upgrades customized email templates from the old !token format * to the new core tokens format. Additionally, in Drupal 7 we no longer e-mail * plain text passwords to users, and there is no token for a plain text * password in the new token system. Therefore, it also modifies any saved * templates using the old '!password' token such that the token is removed, and * displays a warning to users that they may need to go and modify the wording * of their templates. */ function user_update_7017() { $message = ''; $tokens = array( '!site' => '[site:name]', '!username' => '[user:name]', '!mailto' => '[user:mail]', '!login_uri' => '[site:login-url]', '!uri_brief' => '[site:url-brief]', '!edit_uri' => '[user:edit-url]', '!login_url' => '[user:one-time-login-url]', '!uri' => '[site:url]', '!date' => '[date:medium]', '!password' => '', ); $result = db_select('variable', 'v') ->fields('v', array('name')) ->condition('name', db_like('user_mail_') . '%', 'LIKE') ->execute(); foreach ($result as $row) { // Use variable_get() to get the unserialized value for free. if ($value = variable_get($row->name, FALSE)) { if (empty($message) && (strpos($value, '!password') !== FALSE)) { $message = t('The ability to send users their passwords in plain text has been removed in Drupal 7. Your existing email templates have been modified to remove it. You should <a href="@template-url">review these templates</a> to make sure they read properly.', array('@template-url' => url('admin/config/people/accounts'))); } variable_set($row->name, str_replace(array_keys($tokens), $tokens, $value)); } } return $message; } /** * Ensure there is an index on {users}.picture. */ function user_update_7018() { if (!db_index_exists('users', 'picture')) { db_add_index('users', 'picture', array('picture')); } } /** * Ensure there is a combined index on {authmap}.uid and {authmap}.module. */ function user_update_7019() { // Check first in case it was already added manually. if (!db_index_exists('authmap', 'uid_module')) { db_add_index('authmap', 'uid_module', array('uid', 'module')); } } /** * @} End of "addtogroup updates-7.x-extra". */