JimboLP

DB Basics - May 2018

Jun 20th, 2018
412
0
Never
4
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.47 KB | None | 0 0
  1. create proc usp_GetHoldersWithBalanceHigherThan @balance decimal(18,4)
  2. as
  3. begin
  4.  
  5. --Take the IDs of the accounts with total balance bigger than the given amount (@balance)
  6. with CET_AccountBalance as(
  7. select ah.Id, sum(a.Balance) Balance from AccountHolders ah
  8. left join Accounts a on a.AccountHolderId = ah.Id
  9. group by ah.Id
  10. having sum(a.Balance) > @balance
  11. )
  12.  
  13. select ah.FirstName, ah.LastName from AccountHolders ah
  14. right join CET_AccountBalance ab on ab.Id = ah.Id
  15.  
  16. end
Advertisement
Comments
  • User was banned
  • User was banned
  • User was banned
  • Lenyevor
    220 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).
Add Comment
Please, Sign In to add comment