clickio icon

Create new nodes

clickio | PRO | 05/20/21 01:15:40 PM UTC | 0 ⭐ | 8494 👁️ | Never ⏰ | []
MySQL |

1.44 KB

|

None

|

0 👍

/

0 👎

DROP TEMPORARY TABLE IF EXISTS sa_with_external_nodes;
CREATE TEMPORARY TABLE sa_with_external_nodes (PRIMARY KEY (site_area_id))
SELECT DISTINCT sa.site_area_id FROM rabota_db.site_area sa 
JOIN site s ON sa.parent_id = s.site_id
RIGHT JOIN rabota_db.site_area_demand_source_settings sds ON sa.site_area_id = sds.site_area_id
WHERE sa.parent_id = 216564
AND 
(
sa.use_header_bidding = 1 
OR
s.use_header_bidding = 1
)
AND sds.chain_status <> 1
AND sds.status <> 1
AND sds.deleted <> 0
AND sds.end_date_ptz IS NOT NULL
;
 
SELECT * FROM sa_with_external_nodes;
 
 
DROP TEMPORARY TABLE IF EXISTS sa_without_external_nodes;
CREATE TEMPORARY TABLE sa_without_external_nodes (PRIMARY KEY (site_area_id))
SELECT sa.site_area_id FROM rabota_db.site_area sa 
LEFT JOIN
   sa_with_external_nodes saen ON saen.site_area_id = sa.site_area_id
WHERE sa.parent_id = 216564
AND saen.site_area_id IS NULL
;
 
SELECT * FROM sa_without_external_nodes;
 
INSERT INTO rabota_db.`site_area_demand_source_settings` (
    `site_area_id`, 
    `demand_source_id`, 
    `status`, 
    `chain_id`, 
    `chain_type`, 
    `chain_status`, 
    `order`, 
    `manual_percent`,
    `modify_date`,
    `start_date_ptz`
)
    SELECT
        sa.`site_area_id`,
        2,
        1,
        1,
        'manual',
        1,
        1,
        100,
        NOW() AS modify_date,
        DATE(NOW()) AS start_date_ptz
      
FROM sa_without_external_nodes sa;

Comments

  • Saxdutor icon
    03/30/26 02:42:41 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

    |

    👍

    /

    👎