Reply To: BD

01/24/2019 at 10:50 am #482548
Steven Zahm
Keymaster

@ sebastien

There is a way but there is not a point and click way of doing this. Here’s how:

  • Install the Code Snippets plugin.
  • Add a new snippet with the following code.
  • Save and Active the code snippet with the Only run once option selected.
  • After the snippet runs all the data from Connections will be erased. *This operation can not be undone. Use with caution. This snippet can be run any time you wish to delete all the Connections data.

code snippet

add_action( 'plugins_loaded', 'cn_empty_tables' );

function cn_empty_tables() {
    global $wpdb;

    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_ADDRESS_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_PHONE_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_EMAIL_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_MESSENGER_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_SOCIAL_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_LINK_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_DATE_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_ENTRY_TABLE_META );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_TERM_RELATIONSHIP_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_TERMS_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_TERM_TAXONOMY_TABLE );
    $wpdb->query( 'TRUNCATE TABLE ' . CN_TERM_META_TABLE );

}

Hope this helps!

  • This reply was modified 7 years, 6 months ago by Steven Zahm.