{"id":61566,"date":"2024-02-13T07:40:34","date_gmt":"2024-02-13T12:40:34","guid":{"rendered":"https:\/\/memberpress.com\/docs\/resetting-memberpress-data\/"},"modified":"2024-02-13T17:18:55","modified_gmt":"2024-02-13T22:18:55","slug":"resetting-memberpress-data","status":"publish","type":"ht_kb","link":"https:\/\/memberpress.com\/pt\/docs\/resetting-memberpress-data\/","title":{"rendered":"Redefini\u00e7\u00e3o dos dados do MemberPress"},"content":{"rendered":"

Atualmente, o MemberPress n\u00e3o possui um bot\u00e3o \u2018redefinir' que apague todos os dados encontrados no MemberPress. No entanto, se voc\u00ea precisar redefinir as assinaturas, transa\u00e7\u00f5es, membros e dados de configura\u00e7\u00f5es, execute as seguintes consultas *<\/strong>:<\/p>

\n\tAviso:<\/strong> Isso excluir\u00e1 irreversivelmente todas as assinaturas, associa\u00e7\u00f5es, grupos, regras, lembretes, cupons e dados de transa\u00e7\u00f5es, bem como todas as suas configura\u00e7\u00f5es do MemberPress.<\/p>

\n\tOBSERVA\u00c7\u00c3O:<\/strong> Seu banco de dados pode n\u00e3o usar o \u201cwp_\u201d<\/strong> prefixo. Portanto, se o seu banco de dados usa um prefixo diferente, antes de executar as consultas abaixo, substitua todas as inst\u00e2ncias de \u201cwp_\u201d nas consultas para corresponder ao seu prefixo.<\/p>

TRUNCATE TABLE wp_mepr_subscriptions;<\/p>
TRUNCATE TABLE wp_mepr_transactions;<\/p>
TRUNCATE TABLE wp_mepr_events;<\/p>
TRUNCATE TABLE wp_mepr_members;<\/p>
TRUNCATE TABLE wp_mepr_jobs;<\/p>
TRUNCATE TABLE wp_mepr_rule_access_conditions;<\/p>
TRUNCATE TABLE wp_mepr_tax_rates;<\/p>
TRUNCATE TABLE wp_mepr_tax_rate_locations;<\/p><\/pre>
\n\tOBSERVA\u00c7\u00c3O:<\/strong> A execu\u00e7\u00e3o desses scripts n\u00e3o remover\u00e1 os usu\u00e1rios do seu site (Painel de controle > Usu\u00e1rios > Todos os usu\u00e1rios<\/em>). Embora as contas do WordPress de seus usu\u00e1rios permane\u00e7am intactas, eles n\u00e3o ser\u00e3o mais vistos como membros ativos no MemberPress.<\/p>
Em seguida, voc\u00ea pode executar o seguinte (eles DEVE <\/strong>ser executados nessa ordem):\u00a0<\/p>
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('memberpresscoupon','memberpressgroup','memberpressproduct','mp-reminder', 'memberpressrule'));<\/p>
DELETE FROM wp_posts WHERE post_type IN ('memberpresscoupon','memberpressgroup','memberpressproduct','mp-reminder', 'memberpressrule');<\/p>
DELETE FROM wp_options WHERE option_name LIKE '%mepr%';<\/p><\/pre>
Al\u00e9m disso, voc\u00ea deve executar o seguinte se tiver o Corporate Accounts Add-on instalado:<\/p>
TRUNCATE TABLE wp_mepr_corporate_accounts;<\/p><\/pre>
Se voc\u00ea tiver cursos MemberPress, dever\u00e1 executar a seguinte consulta:<\/p>
TRUNCATE TABLE wp_mpcs_answers;<\/p>
TRUNCATE TABLE wp_mpcs_attempts;<\/p>
TRUNCATE TABLE wp_mpcs_questions;<\/p>
TRUNCATE TABLE wp_mpcs_sections;<\/p>
TRUNCATE TABLE wp_mpcs_user_progress;<\/p><\/pre>
e, em seguida, execute este:<\/p>
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('mpcs-course','mpcs-lesson','mpcs-quiz'));<\/p>
DELETE FROM wp_posts WHERE post_type IN ('mpcs-course','mpcs-lesson','mpcs-quiz');<\/p><\/pre>
Para o PDF Invoices Add-on, voc\u00ea deve executar a seguinte consulta:<\/p>
TRUNCATE TABLE wp_mpdf_invoice_numbers;<\/p>
TRUNCATE TABLE wp_mpdf_credit_notes;<\/p><\/pre>
Para o complemento Downloads, voc\u00ea deve executar a seguinte consulta:<\/p>
TRUNCATE TABLE wp_mpdl_file_downloads;<\/p>
TRUNCATE TABLE wp_mpdl_file_stats;<\/p><\/pre>
\n\tOBSERVA\u00c7\u00c3O:<\/strong> Observe que N\u00c3O executaremos essas consultas em seu site. Voc\u00ea precisar\u00e1 fazer isso por conta pr\u00f3pria. Se n\u00e3o tiver certeza de como executar essas consultas, entre em contato com seu host para obter ajuda.\u00a0<\/p>","protected":false},"excerpt":{"rendered":"
MemberPress does not currently have a \u2018reset\u2019 button that will erase all data found in MemberPress. However, if you need to\u00a0reset the Subscriptions, Transactions, Members, and settings data you can run the following queries *: TRUNCATE TABLE wp_mepr_subscriptions;TRUNCATE TABLE wp_mepr_transactions;TRUNCATE TABLE wp_mepr_events;TRUNCATE TABLE wp_mepr_members;TRUNCATE TABLE wp_mepr_jobs;TRUNCATE TABLE wp_mepr_rule_access_conditions;TRUNCATE TABLE wp_mepr_tax_rates;TRUNCATE TABLE wp_mepr_tax_rate_locations; Then, you can [\u2026]<\/p>\n","protected":false},"author":62252,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"_strive_editorial_status":"not-started","_strive_copy_of":0,"inline_featured_image":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_FSMCFIC_featured_image_caption":"","_FSMCFIC_featured_image_nocaption":"","_FSMCFIC_featured_image_hide":"","_strive_checklists":"\"\"","_strive_active_checklist":"62291e2bb2422","footnotes":""},"ht-kb-category":[1314],"ht-kb-tag":[],"class_list":{"0":"post-61566","1":"ht_kb","2":"type-ht_kb","3":"status-publish","4":"format-standard","6":"ht_kb_category-miscellaneous","7":"entry"},"acf":[],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t