{"id":9973667,"date":"2018-02-14T13:44:32","date_gmt":"2018-02-14T13:44:32","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/account-for-different-db-prefixes\/"},"modified":"2018-02-14T13:44:32","modified_gmt":"2018-02-14T13:44:32","slug":"account-for-different-db-prefixes","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/account-for-different-db-prefixes\/","title":{"rendered":"Account for different DB Prefixes"},"content":{"rendered":"<p>Just a heads up you should update your <code>wc_delete_orders<\/code> function to account for different database prefixes.  <\/p>\n<pre><code>    public function wc_delete_orders() {\n      global $wpdb;\n      $ran = true;\n      $sql = &quot;DELETE FROM &quot; . $wpdb-&gt;prefix . &quot;woocommerce_order_itemmeta&quot;;\n      $sql = &quot;DELETE FROM &quot; . $wpdb-&gt;prefix . &quot;woocommerce_order_items&quot;;\n      $sql = &quot;DELETE FROM &quot; . $wpdb-&gt;prefix . &quot;posts WHERE post_type = &#039;shop_order&#039;&quot;;\n      $rows = $wpdb-&gt;query( $sql );\n\n      if( false !== $rows ) {\n        $this-&gt;deleted = $rows;\n        \/\/add_action( &#039;admin_notices&#039;, array( $this, &#039;admin_notice_success&#039; ) );\n      }\n    }<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-9973667","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/9973667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/9973667\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=9973667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}