ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 8841


Ignore:
Timestamp:
Oct 27, 2008, 7:37:50 PM (12 years ago)
Author:
mori
Message:

#2507 public_flag で default をみているSQLを修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.12.x/webapp/lib/db/bookmark.php

    r6630 r8841  
    7474    $ids = implode(',', array_map('intval', $bookmarks));
    7575
    76     $sql = 'SELECT c_diary.* FROM c_diary, c_member WHERE c_diary.c_member_id IN ('.$ids.') AND ((c_diary.public_flag = \'public\') OR (c_diary.public_flag = \'default\' AND c_member.public_flag_diary = \'public\')) AND c_diary.c_member_id=c_member.c_member_id ORDER BY r_datetime DESC';
     76    $sql = 'SELECT c_diary.* FROM c_diary,c_member WHERE c_diary.c_member_id IN ('.$ids.') AND c_diary.public_flag = \'public\' AND c_diary.c_member_id=c_member.c_member_id ORDER BY r_datetime DESC';
    7777
    7878    $diary_list = db_get_all_limit($sql, 0, intval($limit));
     
    118118    $ids = implode(',', array_map('intval', $bookmarks));
    119119
    120     $sql = 'SELECT c_diary.* FROM c_diary, c_member WHERE c_diary.c_member_id IN ('.$ids.') AND ((c_diary.public_flag = \'public\') OR (c_diary.public_flag = \'default\' AND c_member.public_flag_diary = \'public\')) AND c_diary.c_member_id=c_member.c_member_id ORDER BY r_datetime DESC';
     120    $sql = 'SELECT c_diary.* FROM c_diary, c_member WHERE c_diary.c_member_id IN ('.$ids.') AND c_diary.public_flag = \'public\' AND c_diary.c_member_id=c_member.c_member_id ORDER BY r_datetime DESC';
    121121
    122122    $diary_list = db_get_all_page($sql, intval($page), intval($page_size));
Note: See TracChangeset for help on using the changeset viewer.