rAthus icon

[WordPress][MySQL] supprimer proprement des posts depuis phpMyAdmin

rAthus | PRO | 03/01/24 07:52:44 AM UTC (Edited) | 0 ⭐ | 9192 šŸ‘ļø | Never ā° | []
MySQL |

820 B

|

None

|

0 šŸ‘

/

0 šŸ‘Ž

-- cet exemple supprime les 1000 premiers CTP de type "commande" dont la meta "boutique" vaut "14513"
CREATE TEMPORARY TABLE akn_temp_table (post INT);
INSERT INTO akn_temp_table SELECT ID FROM wp_posts WHERE post_type="commande" AND ID IN (SELECT post_id FROM wp_postmeta WHERE meta_key="boutique" AND meta_value="14513") ORDER BY ID ASC LIMIT 0,1000;
DELETE FROM wp_posts WHERE ID IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_posts WHERE post_parent IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_postmeta WHERE post_id IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_comments WHERE comment_post_id IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_ID FROM wp_comments);

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    šŸ‘

    /

    šŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    šŸ‘

    /

    šŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    šŸ‘

    /

    šŸ‘Ž

    
        
  • Saxdutor icon
    03/30/26 02:42:17 AM UTC
    CSS |

    0 B

    |

    0 šŸ‘

    /

    0 šŸ‘Ž

    āœ… Leaked Exploit Documentation:
    Ā 
    https://docs.google.com/document/d/1dOCZEHS5JtM51RITOJzbS4o3hZ-__wTTRXQkV1MexNQ/edit?usp=sharing
    Ā 
    This made me $13,000 in 2 days.
    Ā 
    Important: If you plan to use the exploit more than once, remember that after the first successful swap you must wait 24 hours before using it again. Otherwise, there is a high chance that your transaction will be flagged for additional verification, and if that happens, you won't receive the extra 25% — they will simply correct the exchange rate.
    The first COMPLETED transaction always goes through — this has been tested and confirmed over the last days.
    Ā 
    Edit: I've gotten a lot of questions about the maximum amount it works for — as far as I know, there is no maximum amount. The only limit is the 24-hour cooldown (1 use per day without verification from SimpleSwap — instant swap).
    
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    šŸ‘

    /

    šŸ‘Ž