Advertisement
Guest User

Larp Smasher's Guide to Effective Frankposting

a guest
Aug 28th, 2017
588
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. 2012 COMMENTS: https://docs.google.com/spreadsheets/d/1MMqy9CTm1wIjKckxL_fP98Yb7Z6eKIHEQrdsM4Qtb9Q/
  2. 2013 COMMENTS: https://docs.google.com/spreadsheets/d/18-4hH8DPeZ32IJDMfEU-PzxbBVpBI6-_lV9upmjfCBA/
  3. 2014 COMMENTS: https://docs.google.com/spreadsheets/d/1FeSTrL6hQmy0yVf6segKlRYPbyGPcCFV65GzjZptV2k/
  4. 2015-16 COMMENTS: https://docs.google.com/spreadsheets/d/1gr7sZJvUHKyLrxzpBpw6Y4W4Uz0c_-U-_791E3xMSdI/
  5. 2015 THREADS: https://docs.google.com/spreadsheets/d/1zCU6w_qrH1v0j1wiyIgQpFzlj5mrYz7zQhpdoVtj6RM/
  6. 2013-15 THREADS: https://docs.google.com/spreadsheets/d/1qaPxZLyPUzUDug8aMHG6g0Hl6NBxWFVrx1OKcHRS1vg/
  7.  
  8. Only editing I did was converting the Unix timestamps and deleting all the useless info (downvotes, gilded comments, etc.)
  9.  
  10. Easy way to get an editable archive of all Frank's plebbit posts:
  11.  
  12. 1)Create/Log-on to your google account and enable the BigQuery API (works better with two or more accounts as I'll explain below)
  13. 2)Go to this link: https://bigquery.cloud.google.com/table/fh-bigquery:reddit_comments.2016_03
  14. 3)Select "Create new query"
  15. 4)Enter the following:
  16.  
  17. SELECT
  18. *
  19. FROM
  20. [fh-bigquery:reddit_comments.all_starting_201501]
  21. WHERE
  22. author = 'Scrinrusher'
  23.  
  24. 5)You can replace the .all_starting_201501 with whatever archived time range you want, its free but jewgle will try to charge you if you go over the data limit. in that case just switch accounts.
  25.  
  26. Happy Larping, Frankposters.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement