Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2014
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1.  
  2. public static function previouslyShortened($username)
  3. {
  4. //Gets all related info for the info for member page
  5. $query = DB::select("select users.id as user_id,
  6. links.id,
  7. links.long_url,
  8. links.short_url,
  9. links.updated_at,
  10. links.clicks,
  11. links.page_title,
  12. users_links.privacy,
  13. users_links.notes,
  14. tags.id,
  15. tags.tag
  16. from users
  17. right outer join users_links on users.id = users_links.user_id
  18. join links on links.id = users_links.link_id
  19. where users.username = '$username'
  20. ". (Auth::check() && Auth::user()->username == $username ? "" : "and users_links.privacy = 0")
  21. );
  22.  
  23. $result = array('username' => $username, 'links' => $query);
  24. return $result;
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement