clickio icon

Script to disable user's site areas withoud statistics

clickio | PRO | 02/11/22 10:25:29 AM UTC | 0 ⭐ | 7384 👁️ | Never ⏰ | []
MySQL |

1.85 KB

|

None

|

0 👍

/

0 👎

DROP TEMPORARY TABLE IF EXISTS adunits_to_disable;
CREATE TEMPORARY TABLE adunits_to_disable
SELECT DISTINCT sa.site_area_id, bsa.user_id, sa.`create_date`, bsa.adv_expense_gbp_30, bsa.requests_30 FROM rabota_db.site_area sa
JOIN bi.site_area bsa ON bsa.site_area_id = sa.site_area_id
LEFT JOIN rabota_db.attached_site_areas basa ON sa.site_area_id  = basa.site_area_id # with attached site area
LEFT JOIN bi.site_area asai ON asai.site_area_id = basa.attached_site_area_id # attached site areas info
WHERE 
    (
    ( 
        basa.site_area_id IS NOT NULL # is base area
    AND ((asai.adv_expense_gbp_30 = 0 #and have no attached areas with stats
    AND asai.requests_30 = 0 )
    OR asai.site_area_id IS NULL) # or have no attached areas
    
    ) 
    OR 
    ( 
        basa.site_area_id IS NULL # is attached area itself
    )
    )
AND bsa.adv_expense_gbp_30 = 0
AND bsa.requests_30 = 0
AND sa.`create_date` < ( NOW() - INTERVAL 3 MONTH )
AND bsa.user_id IN (
143718,
130905,
142171,
143779,
143174,
111441,
145613,
145397,
143885,
103491,
119997,
142788,
144892,
145417,
128837,
116214,
145592,
141408,
143924,
114289,
125676,
143727,
128317,
117170,
130221,
127672,
113821,
122065,
145832,
118982,
132210,
130273,
136691,
122345,
140542,
129927,
108350,
128603,
142114,
142210,
146294,
125922,
143448,
114096,
146466,
123677,
124567,
127942,
130955,
134435,
143263,
144357,
111604,
140209,
102556,
129416,
131176,
141405,
141406,
145591,
108589,
141407,
117333,
122213,
123741,
126356,
140846,
143637,
143764,
144135,
146308,
116989,
109931,
111040,
118339,
120761,
126239,
131337,
132502,
134210,
141900,
143139,
108973,
113159,
142135
);
 
UPDATE site_area sa
JOIN adunits_to_disable dsa ON sa.`site_area_id` = dsa.`site_area_id`
SET sa.active = 0, 
sa.modify_date = NOW() #,
#sa.deleted = 1
;
 

Comments

  • Saxdutor icon
    03/30/26 02:42:35 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).
    
  • Sarkovor icon
    04/05/26 06:48:51 PM UTC
    CSS |

    0 B

    |

    0 👍

    /

    0 👎

    We just shared HQ data on our channel: https://t.me/theprotocolone