Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = DB::select("select users.id as user_id,
- links.id,
- links.long_url,
- links.short_url,
- links.updated_at,
- links.clicks,
- links.page_title,
- users_links.privacy,
- users_links.tags,
- users_links.notes
- from users
- right outer join users_links on users.id = users_links.user_id
- join links on links.id = users_links.link_id
- where users.username = '$username'
- ". (Auth::check() && Auth::user()->username == $username ? "" : "and users_links.privacy = 0")
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement