Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [hasBountyAccount]
- SQL1_1 = SELECT CASE WHEN EXISTS(SELECT uid FROM bounties WHERE uid = ?) THEN 'true' ELSE 'false' END
- SQL1_INPUTS = 1
- OUTPUT = 1
- [createBountyAccount]
- SQL1_1 = INSERT INTO bounties SET uid = ?, name = ?, bounty = '[]', bountyLock = 0, bountyContract = '[]', bountyContractCompleted = '[]', friends = '[]'
- SQL1_INPUTS = 1,2
- [hasImmunity]
- SQL1_1 = SELECT CASE WHEN (SELECT uid FROM bounties WHERE uid = ? AND last_immunity_applied_at < DATE_SUB(NOW(),INTERVAL ? DAY)) THEN 'false' ELSE 'true' END
- SQL1_INPUTS = 1,2
- OUTPUT = 1
- [getBounty]
- SQL1_1 = SELECT bounty, bountyLock, bountyContract, bountyContractCompleted, friends FROM bounties WHERE uid = ?
- SQL1_INPUTS = 1
- OUTPUT = 1,2,3,4,5
- [getAllBounties]
- SQL1_1 = SELECT name, uid, bounty FROM bounties
- OUTPUT = 1-STRING,2-STRING,3
- [setBounty]
- SQL1_1 = UPDATE bounties SET bounty = ? WHERE uid = ?
- SQL1_INPUTS = 1,2
- [setImmunityTime]
- SQL1_1 = UPDATE bounties SET last_immunity_applied_at = NOW() WHERE uid = ?
- SQL1_INPUTS = 1
- [updateBountyLock]
- SQL1_1 = UPDATE bounties SET bountyLock = ? WHERE uid = ?
- SQL1_INPUTS = 1,2
- [nullContract]
- SQL1_1 = UPDATE bounties SET bountyContract = '[]' WHERE bountyContract LIKE ?
- SQL1_INPUTS = 1
- [updateContract]
- SQL1_1 = UPDATE bounties SET bountyContract = ? WHERE uid = ?
- SQL1_INPUTS = 1,2
- [updateCompletedContracts]
- SQL1_1 = UPDATE bounties SET bountyContractCompleted = ? WHERE uid = ?
- SQL1_INPUTS = 1,2
- [updateFriends]
- SQL1_1 = UPDATE bounties SET friends = ? WHERE uid = ?
- SQL1_INPUTS = 1,2
- [resetFriends]
- SQL1_1 = UPDATE bounties SET friends = '[]' WHERE friend_last_reset_at < DATE_SUB(NOW(), INTERVAL ? DAY)
- SQL1_INPUTS = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement