Advertisement
Guest User

Untitled

a guest
Jun 29th, 2016
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. // cookies
  2. +---------+-------------------------+------------------+------------+
  3. | id | email | cookie | date_time |
  4. +---------+-------------------------+------------------+------------+
  5. | int(11) | varchar(50) | varchar(128) | int(11) |
  6. +---------+-------------------------+------------------+------------+
  7. | 1 | jack_2009@gmail.com | ojer0f934mf2... | 1467204523 |
  8. | 2 | peter.zm@yahoo.com | ko4398f43043... | 1467205521 |
  9. | 3 | matrix_john23@gmail.com | 34fjkg3j438t... | 1467205601 |
  10. | 4 | peter.zm@yahoo.com | 0243hfd348i4... | 1467206039 |
  11. +---------+-------------------------+------------------+------------+
  12.  
  13. INSERT INTO cookies VALUES(NULL, $email, $hash, unix_timestamp())
  14.  
  15. INSERT INTO cookies(id, email, cookie, date_time)
  16. SELECT NULL, $email, $hash, unix_timestamp()
  17. FROM cookie
  18. WHERE email = $email AND
  19. 100 >= ( SELECT count(1) FROM cookies WHERE email = $email )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement