Guest User

Untitled

a guest
Sep 24th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. if ($is_logged_in && $_GET['orderby'] == 'user') {
  2. $query = '
  3. SELECT drawings.id, thumbnail_url, url, model, comment, UNIX_TIMESTAMP(date) as unix_date, ratingcount, ratingavg' . $rating_optional . '
  4. FROM drawings INNER JOIN elgg_artists ON drawings.id = elgg_artists.drawingid
  5. ' . $where_optional . ' AND elgg_artists.userid = ' . $_SESSION['current_user_id'] .
  6. ' AND drawings.id not in (select drawingid from flaggings where useragent = \'' . $useragent . '\' and ip = INET_ATON(\'' . $_SERVER['REMOTE_ADDR'] . '\'))';
  7. } else {
  8. $query = '
  9. SELECT id, url, thumbnail_url, model, comment, UNIX_TIMESTAMP(date) as unix_date, ratingcount, ratingavg' . $rating_optional . '
  10. FROM drawings
  11. ' . $where_optional .
  12. ' AND id not in (select drawingid from flaggings where useragent = \'' . $useragent . '\' and ip = INET_ATON(\'' . $_SERVER['REMOTE_ADDR'] . '\'))';
  13. }
Add Comment
Please, Sign In to add comment