![(please configure the [header_logo] section in trac.ini)](/share/chrome/site/your_project_logo.png){kind=logo}
Changeset 20609
- Timestamp:
- 10/03/08 17:44:10 (3 months ago)
- Location:
- events/phpframework/plain_php/trunk/model/phwittr
- Files:
-
- 2 modified
-
FriendshipService.php (modified) (2 diffs)
-
TimelineService.php (modified) (9 diffs)
Legend:
- Unmodified
- Added
- Removed
-
events/phpframework/plain_php/trunk/model/phwittr/FriendshipService.php
r20338 r20609 15 15 $count = $this->fetchFollowerCount($user_id); 16 16 17 $smt = $this->pdo->prepare('17 /*$smt = $this->pdo->prepare(' 18 18 select 19 19 user_followers.*, … … 33 33 )user_followings 34 34 on user_followers.id = user_followings.follow_id 35 ');*/ 36 37 $smt = $this->pdo->prepare(' 38 select 39 *, 40 users.id as user_id 41 from 42 followers left join users 43 on followers.user_id = users.id 44 where followers.follow_id = :user_id 45 limit :offset, :limit 35 46 '); 36 37 47 38 48 $smt->bindValue(':user_id', $user_id, PDO::PARAM_INT); -
events/phpframework/plain_php/trunk/model/phwittr/TimelineService.php
r20338 r20609 11 11 function fetchPublicTimeline($offset, $limit) 12 12 { 13 $smt = $this->pdo->prepare( 14 'select count(users.id) from statuses left join users on ' . 15 'users.id = statuses.user_id where users.private_flag = 0 and ' . 16 'users.delete_flag = 0'); 13 $smt = $this->pdo->prepare(' 14 select count(users.id) 15 from statuses left join users on 16 users.id = statuses.user_id where users.private_flag = 0 and 17 users.delete_flag = 0 18 '); 17 19 $smt->execute(); 18 20 $count = intval(array_val($smt->fetch(), 'count(users.id)')); … … 20 22 21 23 22 $smt = $this->pdo->prepare( 23 'select users.user_name, users.image, statuses.* from ' . 24 'statuses left join users on users.id = statuses.user_id ' . 25 'where users.private_flag = 0 and users.delete_flag = 0 ' . 26 'order by statuses.created_at desc limit :offset, :limit'); 24 $smt = $this->pdo->prepare(' 25 select 26 users.user_name, 27 users.image, 28 statuses.* from 29 statuses left join users on users.id = statuses.user_id 30 where users.private_flag = 0 and users.delete_flag = 0 31 order by statuses.created_at desc limit :offset, :limit 32 '); 27 33 $smt->bindValue(':offset', $offset, PDO::PARAM_INT); 28 34 $smt->bindValue(':limit', $limit, PDO::PARAM_INT); … … 33 39 { 34 40 $smt = $this->pdo->prepare(' 35 select count(users.id) from statuses left join users on 36 users.id = statuses.user_id where users.id = :user_id'); 41 select count(users.id) 42 from statuses left join users on users.id = statuses.user_id 43 where users.id = :user_id 44 '); 37 45 $smt->bindValue(':user_id', $user_id, PDO::PARAM_INT); 38 46 $smt->execute(); … … 40 48 41 49 $smt = $this->pdo->prepare(' 42 select users.user_name, users.image, statuses.* from statuses 43 left join users on users.id = statuses.user_id where users.id = :user_id 50 select 51 users.user_name, 52 users.image, 53 statuses.* 54 from statuses left join users on users.id = statuses.user_id 55 where users.id = :user_id 44 56 order by statuses.created_at desc 45 57 limit :offset, :limit'); … … 55 67 { 56 68 $smt = $this->pdo->prepare(' 57 select statuses.*, users.user_name, users.image from statuses 58 left join users on users.id = statuses.user_id where users.id = :user_id 69 select statuses.*, users.user_name, users.image 70 from statuses left join users on users.id = statuses.user_id 71 where users.id = :user_id 59 72 order by statuses.created_at desc 60 73 limit 1'); … … 69 82 $smt = $this->pdo->prepare(' 70 83 select count(users.id) 71 from statuses left join users on users.id = statuses.user_id 72 where statuses.reply_user_id = :user_id'); 84 from statuses left join users on users.id = statuses.user_id 85 where statuses.reply_user_id = :user_id 86 '); 73 87 $smt->bindValue(':user_id', $user_id, PDO::PARAM_INT); 74 88 $smt->execute(); … … 78 92 $smt = $this->pdo->prepare(' 79 93 select users.user_name, users.image, statuses.* 80 from statuses left join users on users.id = statuses.user_id 81 where statuses.reply_user_id = :user_id 82 order by statuses.created_at desc limit :offset, :limit'); 94 from statuses left join users on users.id = statuses.user_id 95 where statuses.reply_user_id = :user_id 96 order by statuses.created_at desc limit :offset, :limit 97 '); 83 98 $smt->bindValue(':user_id', $user_id, PDO::PARAM_INT); 84 99 $smt->bindValue(':offset', $offset, PDO::PARAM_INT); … … 91 106 $smt = $this->pdo->prepare(' 92 107 select count(users.id) 93 from statuses left join users on users.id = statuses.user_id 94 left join (select * from followers where user_id = :user_id) f1 on f1.follow_id = users.id 108 from statuses 109 left join users on users.id = statuses.user_id 110 left join followers on followers.follow_id = statuses.user_id and followers.user_id = :user_id 95 111 96 where users.delete_flag = 0 and f1.user_id = :user_id 97 or users.id = :user_id '); 112 where users.delete_flag = 0 and followers.user_id = :user_id 113 or users.id = :user_id 114 '); 98 115 99 116 $smt->bindValue(':user_id', $user_id, PDO::PARAM_INT); … … 104 121 $smt = $this->pdo->prepare(' 105 122 select users.user_name, users.image, statuses.* 106 from statuses left join users on users.id = statuses.user_id 107 left join (select * from followers where user_id = :user_id) f1 on f1.follow_id = users.id 123 from statuses 124 left join users on users.id = statuses.user_id 125 left join followers on followers.follow_id = statuses.user_id and followers.user_id = :user_id 108 126 109 where users.delete_flag = 0 and f1.user_id = :user_id110 or users.id = :user_id127 where users.delete_flag = 0 and followers.user_id = :user_id 128 or statuses.user_id = :user_id 111 129 112 order by statuses.created_at desc 113 limit :offset, :limit'); 130 order by statuses.created_at desc 131 limit :offset, :limit 132 '); 114 133 115 134 $smt->bindValue(':user_id', $user_id, PDO::PARAM_INT);
