rAthus

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

Mar 1st, 2024 (edited)
9,414
0
Never
5
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.82 KB | None | 0 0
  1. -- cet exemple supprime les 1000 premiers CTP de type "commande" dont la meta "boutique" vaut "14513"
  2. CREATE TEMPORARY TABLE akn_temp_table (post INT);
  3. 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;
  4. DELETE FROM wp_posts WHERE ID IN (SELECT post FROM akn_temp_table);
  5. DELETE FROM wp_posts WHERE post_parent IN (SELECT post FROM akn_temp_table);
  6. DELETE FROM wp_postmeta WHERE post_id IN (SELECT post FROM akn_temp_table);
  7. DELETE FROM wp_term_relationships WHERE object_id IN (SELECT post FROM akn_temp_table);
  8. DELETE FROM wp_comments WHERE comment_post_id IN (SELECT post FROM akn_temp_table);
  9. DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_ID FROM wp_comments);
Advertisement
Comments
  • User was banned
  • User was banned
  • User was banned
  • Saxdutor
    212 days
    # CSS 0.85 KB | 0 0
    1. ✅ Leaked Exploit Documentation:
    2.  
    3. https://docs.google.com/document/d/1dOCZEHS5JtM51RITOJzbS4o3hZ-__wTTRXQkV1MexNQ/edit?usp=sharing
    4.  
    5. This made me $13,000 in 2 days.
    6.  
    7. 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.
    8. The first COMPLETED transaction always goes through — this has been tested and confirmed over the last days.
    9.  
    10. 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).
  • User was banned
Add Comment
Please, Sign In to add comment