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

Changeset 3526


Ignore:
Timestamp:
Jul 24, 2007, 5:04:17 PM (12 years ago)
Author:
maruyama
Message:

#957 admin:世代別メンバー表示で、誕生日を迎えたユーザの世代が更新されない

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/work/maruyama/prj_diary_category/webapp/modules/admin/lib/db_admin.php

    r3483 r3526  
    15941594    );
    15951595   
    1596     $sql = "SELECT ((YEAR(CURDATE()) - birth_year)- " .
    1597         "(RIGHT(CURDATE(),5)<CONCAT(birth_month,'-',birth_day))) " .
     1596    $today = getdate();
     1597    $cur = $today['mon']*100 + $today['mday'];
     1598    $sql = "SELECT ((YEAR(CURDATE()) - birth_year) " .
     1599        "- ( ? < (birth_month*100 + birth_day))) " .
    15981600        "AS age FROM c_member WHERE birth_year <> 0;";
    1599     $lst = db_get_all($sql);
     1601    $lst = db_get_all($sql, array($cur));
    16001602
    16011603    $temp = array_keys($analysis_generation);
Note: See TracChangeset for help on using the changeset viewer.