View source for Drumbeat/PaulBooker/An example santization script for a drupal site running CiviCRM

&nbsp; &lt;?php<br>require './includes/bootstrap.inc';<br>drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);<br>set_time_limit(0);<br>_sanitize_mozcrm_drupal();<br>_sanitize_mozcrm_civicrm();<br>function _sanitize_mozcrm_drupal() {<br>print("Starting sanitization of mozcrm_drupal database ..&lt;BR&gt;&lt;BR&gt;");<br>db_query("TRUNCATE {access}");<br>db_query("TRUNCATE {boost_access}");<br>db_query("TRUNCATE {boost_access_relationships}");<br>db_query("TRUNCATE {boost_access_settings}");<br>db_query("TRUNCATE {boost_crawler}");<br>db_query("TRUNCATE {cache}");<br>db_query("TRUNCATE {cache_block}");<br>db_query("TRUNCATE {cache_content}");<br>db_query("TRUNCATE {cache_drumbeat_tabs}");<br>db_query("TRUNCATE {cache_filter}");<br>db_query("TRUNCATE {cache_form}");<br>db_query("TRUNCATE {cache_location}");<br>db_query("TRUNCATE {cache_menu}");<br>db_query("TRUNCATE {cache_node}");<br>db_query("TRUNCATE {cache_page}");<br>db_query("TRUNCATE {cache_pathdst}");<br>db_query("TRUNCATE {cache_pathsrc}");<br>db_query("TRUNCATE {cache_update}");<br>db_query("TRUNCATE {cache_views}");<br>db_query("TRUNCATE {cache_views_data}");<br>db_query("TRUNCATE {domain_2_cache}");<br>db_query("TRUNCATE {domain_2_cache_block}");<br>db_query("TRUNCATE {domain_2_cache_content}");<br>db_query("TRUNCATE {domain_2_cache_filter}");<br>db_query("TRUNCATE {domain_2_cache_form}");<br>db_query("TRUNCATE {domain_2_cache_location}");<br>db_query("TRUNCATE {domain_2_cache_menu}");<br>db_query("TRUNCATE {domain_2_cache_page}");<br>db_query("TRUNCATE {domain_2_cache_pathdst}");<br>db_query("TRUNCATE {domain_2_cache_pathsrc}");<br>db_query("TRUNCATE {domain_2_cache_update}");<br>db_query("TRUNCATE {domain_2_cache_views}");<br>db_query("TRUNCATE {domain_2_cache_views_data}");<br>db_query("TRUNCATE {domain_2_ctools_css_cache}");<br>db_query("TRUNCATE {domain_2_ctools_object_cache}");<br>db_query("TRUNCATE {domain_2_views_object_cache}");<br>db_query("TRUNCATE {location}");<br>db_query("TRUNCATE {location_instance}");<br>db_query("TRUNCATE {sessions}");<br>db_query("TRUNCATE {signup_log}");<br>db_query("TRUNCATE {signup_views}");<br>db_query("TRUNCATE {watchdog}");<br>db_query("UPDATE {comments} SET hostname = '127.0.0.1'");

db_query("UPDATE {users} SET init = CONCAT(users.uid, '@testmail.drumbeat.org')");<br>db_query("UPDATE {users} SET mail = CONCAT(users.uid, '@testmail.drumbeat.org')");<br>db_query("UPDATE {users} SET pass = MD5('pass')");<br>db_query("UPDATE {users} SET status = 1 WHERE uid = 1");<br>db_query("UPDATE {users} SET name = 'test.admin' WHERE uid = 1");<br>db_query("UPDATE {users} SET data = ");<br>db_query("UPDATE {content_field_im_account} SET field_im_account_value = NULL");<br>db_query("UPDATE {content_field_im_provider} SET field_im_provider_value = NULL");<br>db_query("UPDATE {content_field_job_area} SET field_job_area_value = NULL");<br>db_query("UPDATE {content_field_profile_groups} SET field_profile_groups_value = NULL");<br>db_query("UPDATE {content_field_profile_hidden_city} SET field_profile_hidden_city_value = NULL");<br>db_query("UPDATE {content_field_profile_hidden_country} SET field_profile_hidden_country_value = NULL");<br>db_query("UPDATE {content_field_profile_hidden_state} SET field_profile_hidden_state_value = NULL");<br>db_query("UPDATE {content_field_profile_hidden_zip} SET field_profile_hidden_zip_value = NULL");<br>db_query("UPDATE {content_field_profile_languages} SET field_profile_languages_value = NULL");<br>db_query("UPDATE {content_field_profile_operating_system} SET field_profile_operating_system_value = NULL");<br>db_query("UPDATE {content_field_profile_organisations} SET field_profile_organisations_value = NULL");<br>db_query("UPDATE {content_field_profile_programming_lang} SET field_profile_programming_lang_value = NULL");<br>db_query("UPDATE {content_field_profile_projects} SET field_profile_projects_value = NULL"); <br>db_query("UPDATE {content_field_profile_roles SET field_profile_roles_value = NULL");<br>db_query("UPDATE {content_field_profile_skills} SET field_profile_skills_value = NULL");<br>db_query("UPDATE {content_field_profile_social} SET field_profile_social_url = NULL");<br>db_query("UPDATE {content_field_profile_social} SET field_profile_social_title = NULL");<br>db_query("UPDATE {content_field_profile_social} SET field_profile_social_attributes = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_first_name_value = 'first_name'");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_last_name_value = 'last_name'");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_occupation_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_nationality_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_birthday_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_gender_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_size_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_contact_mail_email = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_bugzilla_email = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_irc_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_blog_url = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_blog_title = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_blog_attributes = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_location_lid = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_first_name_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_org_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_products_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_skills_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_location_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_last_name_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_picture_data = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_hidden_city_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_hidden_state_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_hidden_country_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_gender_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_roles_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_email_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_occupation_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_irc_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_hidden_languages_value = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_svn_email = NULL");<br>db_query("UPDATE {content_type_public_profile} SET field_profile_cvs_email = NULL");<br>db_query("DELETE FROM {variable} WHERE name = 'googlemap_api_key'");<br>db_query("DELETE FROM {variable} WHERE name = 'boost_crawler_key'");<br>db_query("DELETE FROM {variable} WHERE name = 'flickr_api_secret'");<br>db_query("DELETE FROM {variable} WHERE name = 'flickr_api_key'");<br>db_query("DELETE FROM {variable} WHERE name = 'flickr_default_userid'");<br>db_query("DELETE FROM {variable} WHERE name = 'drupal_private_key'");<br>db_query("DROP TABLE IF EXISTS {captcha_points}");<br>db_query("DROP TABLE IF EXISTS {captcha_sessions}");

print("Finished sanitization of mozcrm_drupal database.&lt;BR&gt;&lt;BR&gt;");<br>}<br>function _sanitize_mozcrm_civicrm() {<br>print("Starting sanitization of mozcrm_civicrm database.&lt;BR&gt;&lt;BR&gt;");<br>db_query("TRUNCATE {civicrm_cache}");<br>db_query("TRUNCATE {civicrm_contribution}");<br>db_query("TRUNCATE {civicrm_contribution_recur}");<br>db_query("TRUNCATE {civicrm_contribution_financial_trxn}");<br>db_query("TRUNCATE {civicrm_payment_processor}");<br>db_query("UPDATE {civicrm_address} SET street_address = NULL");<br>db_query("UPDATE {civicrm_address} SET street_number = NULL");<br>db_query("UPDATE {civicrm_address} SET street_number_suffix = NULL");<br>db_query("UPDATE {civicrm_address} SET street_number_predirectional = NULL");<br>db_query("UPDATE {civicrm_address} SET street_name = NULL");<br>db_query("UPDATE {civicrm_address} SET street_type = NULL");<br>db_query("UPDATE {civicrm_address} SET street_number_postdirectional = NULL");<br>db_query("UPDATE {civicrm_address} SET street_unit = NULL");<br>db_query("UPDATE {civicrm_address} SET supplemental_address_1 = NULL");<br>db_query("UPDATE {civicrm_address} SET supplemental_address_2 = NULL");<br>db_query("UPDATE {civicrm_address} SET supplemental_address_3 = NULL");<br>db_query("UPDATE {civicrm_address} SET city = NULL");<br>db_query("UPDATE {civicrm_address} SET county_id = NULL"); <br>db_query("UPDATE {civicrm_address} SET state_province_id = NULL");<br>db_query("UPDATE {civicrm_address} SET postal_code_suffix = NULL");<br>db_query("UPDATE {civicrm_address} SET postal_code = NULL");<br>db_query("UPDATE {civicrm_address} SET usps_adc = NULL");<br>db_query("UPDATE {civicrm_address} SET country_id = NULL");<br>db_query("UPDATE {civicrm_address} SET geo_code_1 = NULL");<br>db_query("UPDATE {civicrm_address} SET geo_code_2 = NULL");<br>db_query("UPDATE {civicrm_address} SET timezone = NULL");<br>db_query("UPDATE {civicrm_address} SET name = NULL");<br>db_query("UPDATE {civicrm_contact} SET name = NULL");<br>db_query("UPDATE {civicrm_contact} SET sort_name = 'lastname, firstname'");<br>db_query("UPDATE {civicrm_contact} SET display_name = 'lastname, firstname'");<br>db_query("UPDATE {civicrm_contact} SET nickname = NULL");<br>db_query("UPDATE {civicrm_contact} SET legal_name = NULL");<br>db_query("UPDATE {civicrm_contact} SET home_URL = NULL");<br>db_query("UPDATE {civicrm_contact} SET image_URL = NULL");<br>db_query("UPDATE {civicrm_contact} SET preferred_communication_method = NULL");<br>db_query("UPDATE {civicrm_contact} SET source = NULL");<br>db_query("UPDATE {civicrm_contact} SET first_name = 'firstname'");<br>db_query("UPDATE {civicrm_contact} SET middle_name = NULL");<br>db_query("UPDATE {civicrm_contact} SET last_name = 'lastname'");<br>db_query("UPDATE {civicrm_contact} SET prefix_id = NULL");<br>db_query("UPDATE {civicrm_contact} SET suffix_id = NULL");<br>db_query("UPDATE {civicrm_contact} SET greeting_type_id = NULL");<br>db_query("UPDATE {civicrm_contact} SET custom_greeting = NULL");<br>db_query("UPDATE {civicrm_contact} SET job_title = NULL");<br>db_query("UPDATE {civicrm_contact} SET gender_id = NULL");<br>db_query("UPDATE {civicrm_contact} SET birth_date = NULL");<br>db_query("UPDATE {civicrm_contact} SET mail_to_household_id = NULL");<br>db_query("UPDATE {civicrm_contact} SET household_name = NULL");<br>db_query("UPDATE {civicrm_contact} SET primary_contact_id = NULL");<br>db_query("UPDATE {civicrm_contact} SET organization_name = NULL");<br>db_query("UPDATE {civicrm_contact} SET sic_code = NULL");<br>db_query("UPDATE {civicrm_contact} SET user_unique_id = NULL");<br>db_query("UPDATE {civicrm_contact} SET employer_id = NULL");<br>db_query("UPDATE {civicrm_contact} SET api_key = NULL");<br>db_query("UPDATE {civicrm_contribution_widget} SET url_homepage = NULL");<br>db_query("UPDATE {civicrm_email} SET mail = CONCAT(civicrm_email.contact_id, '@testmail.drumbeat.org')");<br>db_query("UPDATE {civicrm_im} SET name = NULL");<br>db_query("UPDATE {civicrm_phone} SET phone = NULL");<br>db_query("UPDATE {civicrm_uf_group} SET post_URL = NULL");<br>db_query("UPDATE {civicrm_uf_group} SET notify = NULL");<br>db_query("UPDATE {civicrm_uf_match} SET uf_name = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET preferred_name_18 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET organizations_20 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET nationality_21 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET mail_address_24 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET contributer_start_28 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET contact_email_29 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET bugzilla_email_30 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET irc_nick_31 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET blog_url_32 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET twitter_33 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET linkedin_34 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET social_networks_35 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET languages_36 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET skills_37 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET rolls_38 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET projects_39 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET programming_languages_40 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET operating_system_41 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET cvs_access_44 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET svn_access_45 = NULL");<br>db_query("UPDATE {civicrm_value_profile_fields_4} SET hg_account_47 = NULL");<br>print("Finished sanitization of mozcrm_civicrm database.&lt;BR&gt;&lt;BR&gt;");<br>}