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

Changeset 13132


Ignore:
Timestamp:
Nov 11, 2009, 4:48:54 PM (13 years ago)
Author:
shingo
Message:

#4366:r13130 のマージ

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.12.x/webapp/modules/portal/lib/db_portal.php

    r10768 r13132  
    349349function db_portal_image_list($page, $page_size, &$pager)
    350350{
    351     $sql = 'SELECT portal_image_id FROM portal_image ORDER BY portal_image_id DESC';
    352     $id_list = db_get_col_page($sql, $page, $page_size);
    353 
    354     $portal_image_list = array();
    355     foreach ($id_list as $portal_image_id) {
    356         $sql = 'SELECT pi.portal_image_id AS portal_image_id, pi.image_filename AS image_filename, ci.r_datetime AS r_datetime'
    357             . ' FROM portal_image AS pi LEFT JOIN c_image AS ci ON pi.image_filename = ci.filename'
    358             . ' WHERE pi.portal_image_id = ?';
    359         $params = array(intval($portal_image_id));
    360         $portal_image_list[] = db_get_row($sql, $params);
    361     }
     351    $sql = 'SELECT * FROM portal_image ORDER BY portal_image_id DESC';
     352    $portal_image_list = db_get_all_page($sql, $page, $page_size);
    362353
    363354    $sql = 'SELECT COUNT(*) FROM portal_image';
Note: See TracChangeset for help on using the changeset viewer.