[WordPress] requête SQL export CPT et métas

MySQL |

2.06 KB

None

0 👍

0 👎

Raw Download Clone Embed Print View

SELECT DISTINCT
ID AS "ID" /* ID du post */
, post_title AS "Titre" /* titre du post */
, post_date AS "Date publication" /* date de création du post */
, post_content AS "Description" /* contenu du post */
 
/* récupérer la méta 'client' */
, IFNULL((SELECT meta_value FROM wp_postmeta WHERE wp_postmeta.meta_key = 'client' AND wp_postmeta.post_id = wp_posts.ID), '') AS "ID client"
 
/* récupérer la méta 'adresse_email' d'un CPT lié par la méta 'client' */
, IFNULL((SELECT meta_value FROM wp_postmeta a WHERE a.meta_key = 'adresse_email' AND a.post_id = (SELECT meta_value FROM wp_postmeta b WHERE b.meta_key = 'client' AND b.post_id = wp_posts.ID)), '') AS "Email client"
 
/* récupérer les valeurs de la colonne 'therapeute' d'un ACF type répéteur 'horaires_par_pieces', les dédoublonner et les regrouper en les séparant par un point-virgule */
, IFNULL((SELECT GROUP_CONCAT(DISTINCT wp_postmeta.meta_value SEPARATOR ';') FROM wp_postmeta WHERE wp_postmeta.meta_key LIKE 'horaires_par_pieces_%_therapeute' AND wp_postmeta.meta_value!="" AND wp_postmeta.post_id = wp_posts.ID), '') AS "Thérapeute(s)"
 
/* la même sauf qu'on va récupérer la méta 'nom' du CPT d'un CPT lié à la valeur de la colonne 'therapeute' qui est un ID pointant vers un CPT */
, IFNULL((SELECT meta_value FROM wp_postmeta a WHERE a.meta_key = 'nom' AND a.post_id = (SELECT GROUP_CONCAT(DISTINCT wp_postmeta.meta_value SEPARATOR ';') FROM wp_postmeta WHERE wp_postmeta.meta_key LIKE 'horaires_par_pieces_%_therapeute' AND wp_postmeta.meta_value!="" AND wp_postmeta.post_id = wp_posts.ID)), '') AS "Thérapeute"
 
/* récupérer la somme des valeurs numériques de la colonne 'quantite' d'un ACF type répéteur 'quantites_totales' */
, IFNULL((SELECT SUM(wp_postmeta.meta_value) FROM wp_postmeta WHERE wp_postmeta.meta_key LIKE 'quantites_totales_%_quantite' AND wp_postmeta.meta_value!="" AND wp_postmeta.post_id = wp_posts.ID), 0) AS "Unités achetées"
 
FROM wp_posts /* table des posts */
WHERE post_type = 'reservation' /* slug du CPT */
ORDER BY post_title, post_content /* ordre de tri */

Comments

CSS |

0 B

0 👍

0 👎

Raw Download Clone Embed Print View

✅ 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).

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

[WordPress] requête SQL export CPT et métas

Comments