Advertisement
PJH

Untitled

PJH
Oct 29th, 2014
205
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.57 KB | None | 0 0
  1. [postgres@sofa ~]$ grep "^135.*Passable Poster" /var/lib/pgsql/restores/*/dump.sql
  2. /var/lib/pgsql/restores/2014-09-17/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 21 2014-08-07 15:07:28.047772 2014-09-05 23:18:37.736768 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND\n (:backfill OR user_id IN (:user_ids) OR p.id IN (:post_ids) ) t t12 1 t f
  3. /var/lib/pgsql/restores/2014-09-29/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 26 2014-08-07 15:07:28.047772 2014-09-26 13:09:43.075645 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND\n (:backfill OR user_id IN (:user_ids) OR p.id IN (:post_ids) ) t t12 1 t f
  4. /var/lib/pgsql/restores/2014-10-01/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 26 2014-08-07 15:07:28.047772 2014-09-26 13:09:43.075645 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND\n (:backfill OR user_id IN (:user_ids) OR p.id IN (:post_ids) ) t t12 1 t f
  5. /var/lib/pgsql/restores/2014-10-14/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 27 2014-08-07 15:07:28.047772 2014-10-03 22:56:51.837365 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND\n (:backfill OR user_id IN (:user_ids) OR p.id IN (:post_ids) ) t t12 1 t f
  6. /var/lib/pgsql/restores/2014-10-17/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 27 2014-08-07 15:07:28.047772 2014-10-14 11:35:51.323463 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND\n (:backfill OR p.id IN (:post_ids) ) t t 12 1 tf
  7. /var/lib/pgsql/restores/2014-10-18/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 27 2014-08-07 15:07:28.047772 2014-10-14 11:35:51.323463 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND\n (:backfill OR p.id IN (:post_ids) ) t t 12 1 tf
  8. /var/lib/pgsql/restores/2014-10-23/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 28 2014-08-07 15:07:28.047772 2014-10-23 12:52:26.149863 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND /* Just exclude the likes thread - other discountable threads can still get legitimate likes */\n (:backfill OR p.id IN (:post_ids) ) t t 12 1 t f
  9. /var/lib/pgsql/restores/2014-10-24/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 28 2014-08-07 15:07:28.047772 2014-10-23 12:52:26.149863 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND /* Just exclude the likes thread - other discountable threads can still get legitimate likes */\n (:backfill OR p.id IN (:post_ids) ) t t 12 1 t f
  10. /var/lib/pgsql/restores/2014-10-25/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 28 2014-08-07 15:07:28.047772 2014-10-23 12:52:26.149863 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND /* Just exclude the likes thread - other discountable threads can still get legitimate likes */\n (:backfill OR p.id IN (:post_ids) ) t t 12 1 t f
  11. /var/lib/pgsql/restores/2014-10-28/dump.sql:135 Passable Poster Received 25 likes on a single post. In a thread/situation not obviously being abused for this purpose. 29 2014-08-07 15:07:28.047772 2014-10-28 23:17:01.169296 t t fa-thumbs-o-up t t SELECT p.user_id, p.id post_id, p.updated_at granted_at\nFROM badge_posts p\nWHERE p.like_count >= 25 AND \n p.topic_id not in (1000) AND /* Just exclude the likes thread - other discountable threads can still get legitimate likes */\n (:backfill OR p.id IN (:post_ids) ) t t 12 1 t f fa-thumbs-o-up
  12. [postgres@sofa ~]$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement