Changeset 6629
- Timestamp:
- Apr 18, 2008, 7:02:44 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/trunk/webapp/lib/db/album.php
r6627 r6629 7 7 /** 8 8 * db_album_public_flag_condition 9 * 9 * 10 10 * @param int $c_member_id target c_member_id 11 11 * @param int $u viewer's c_member_id … … 46 46 $sql = 'SELECT * FROM c_album WHERE c_album_id = ?'; 47 47 $params = array(intval($c_album_id)); 48 48 49 49 $album = db_get_row($sql, $params); 50 50 … … 54 54 /** 55 55 * あるメンバーのアルバム一覧を取得 56 * 56 * 57 57 * @param int $c_member_id target_member_id 58 58 * @param int $count … … 63 63 { 64 64 $pf_condition = db_album_public_flag_condition($c_member_id, $u, $force); 65 $sql = 'SELECT * FROM c_album WHERE c_member_id = ? ' 65 $sql = 'SELECT * FROM c_album WHERE c_member_id = ? ' 66 66 . $pf_condition 67 67 . ' ORDER BY u_datetime DESC'; 68 69 $params = array(intval($c_member_id)); 68 69 $params = array(intval($c_member_id)); 70 70 return db_get_all_limit($sql, 0, $count, $params); 71 71 } … … 103 103 $sql = 'SELECT c_album_image_id FROM c_album_image WHERE c_album_image_id = ?'; 104 104 $params = array(intval($c_album_image_id)); 105 105 106 106 return (bool)db_get_one($sql,$params); 107 107 } … … 121 121 $orderby = ' ORDER BY i.r_datetime DESC'; 122 122 $sql = $select .$from . $where .$orderby; 123 123 124 124 $params = array(intval($c_album_id)); 125 125 $list = db_get_all_limit($sql, $page_size * ($page - 1), $page_size, $params); 126 126 127 127 $sql = 'SELECT COUNT(c_album_image_id) FROM c_album_image WHERE c_album_id = ?'; 128 128 $params = array(intval($c_album_id)); … … 156 156 { 157 157 $public_flag_condition = db_album_public_flag_condition($c_member_id, $u); 158 158 159 159 $select = 'SELECT c_album_image.c_album_image_id '; 160 160 $from = ' FROM c_album_image, c_album'; 161 $where = ' WHERE c_album.c_album_id = c_album_image.c_album_id' . 161 $where = ' WHERE c_album.c_album_id = c_album_image.c_album_id' . 162 162 ' AND c_album.c_member_id = ?' . 163 163 ' AND c_album.c_album_id = ?' . … … 167 167 $sql = $select . $from . $where . $orderby; 168 168 $params = array(intval($c_member_id),intval($c_album_id),intval($c_album_image_id)); 169 169 170 170 return db_get_one($sql, $params); 171 171 } … … 181 181 { 182 182 $public_flag_condition = db_album_public_flag_condition($c_member_id, $u); 183 183 184 184 $select = 'SELECT c_album_image.c_album_image_id '; 185 185 $from = ' FROM c_album_image, c_album'; 186 $where = ' WHERE c_album.c_album_id = c_album_image.c_album_id' . 186 $where = ' WHERE c_album.c_album_id = c_album_image.c_album_id' . 187 187 ' AND c_album.c_member_id = ?' . 188 188 ' AND c_album.c_album_id = ?' . … … 192 192 $sql = $select . $from . $where . $orderby; 193 193 $params = array(intval($c_member_id),intval($c_album_id),intval($c_album_image_id)); 194 194 195 195 return db_get_one($sql, $params); 196 196 } … … 239 239 $params = array(intval($c_member_id)); 240 240 $list = db_get_all_page($sql,$page, $page_size,$params); 241 241 242 242 $sql = 'SELECT COUNT(c_album_id) FROM c_album WHERE c_member_id = ?' . $pf_cond; 243 243 $total_num = db_get_one($sql, $params); 244 244 245 245 if ($total_num != 0) { 246 246 $total_page_num = ceil($total_num / $page_size); … … 257 257 } 258 258 } 259 259 260 260 return array($list, $prev, $next, $total_num); 261 261 } … … 290 290 foreach ($keyword_list as $word) { 291 291 $word = check_search_word($word); 292 292 293 293 $where .= ' AND (subject LIKE ? OR description LIKE ?)'; 294 294 $params[] = '%'.$word.'%'; … … 299 299 300 300 $sql = $select . $from . $where . $order; 301 301 302 302 $list = db_get_all_page($sql, $page, $page_size, $params); 303 303 foreach($list as $key => $value) { … … 434 434 ); 435 435 return db_update('c_album', $data, $where); 436 436 437 437 } 438 438 … … 444 444 445 445 if ($image_filename) { 446 446 $data['image_filename'] = $image_filename; 447 447 $data['filesize'] = $filesize; 448 448 } … … 451 451 'c_album_image_id' => intval($c_album_image_id), 452 452 ); 453 453 454 454 return db_update('c_album_image', $data, $where); 455 455 … … 498 498 function db_album_update_c_album_u_datetime($album_id) 499 499 { 500 500 $data = array( 501 501 'u_datetime' => db_now(), 502 502 ); 503 503 504 504 $where =array( 505 505 'c_album_id' => $album_id, … … 557 557 558 558 $params = array(intval($c_album_id)); 559 559 560 560 //アルバムと画像の関連 561 561 $sql = 'DELETE FROM c_album_image WHERE c_album_id = ?'; … … 614 614 'type' => '', 615 615 ); 616 616 617 617 $db =& db_get_instance('image'); 618 618 if ($db->insert("c_image", $params)) { … … 704 704 * @params int $new_filesize 705 705 * @return bool 706 */ 706 */ 707 707 function db_album_is_insertable4c_member_id($c_member_id, $new_filesize = 0) 708 708 {
Note: See TracChangeset
for help on using the changeset viewer.