Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2014
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. $query = DB::select("select users.id as user_id,
  2. links.id,
  3. links.long_url,
  4. links.short_url,
  5. links.updated_at,
  6. links.clicks,
  7. links.page_title,
  8. users_links.privacy,
  9. users_links.tags,
  10. users_links.notes
  11. from users
  12. right outer join users_links on users.id = users_links.user_id
  13. join links on links.id = users_links.link_id
  14. where users.username = '$username'
  15. ". (Auth::check() && Auth::user()->username == $username ? "" : "and users_links.privacy = 0")
  16. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement