Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static function previouslyShortened($username)
- {
- //Gets all related info for the info for member page
- $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.notes,
- tags.id,
- tags.tag
- 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")
- );
- $result = array('username' => $username, 'links' => $query);
- return $result;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement