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

Changeset 3659


Ignore:
Timestamp:
Aug 9, 2007, 4:24:51 PM (14 years ago)
Author:
ogawa
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.8.x/webapp/modules/admin/lib/db_admin.php

    r3527 r3659  
    15951595   
    15961596    $today = getdate();
    1597     $cur = $today['mon']*100 + $today['mday'];
    1598     $sql = "SELECT ((YEAR(CURDATE()) - birth_year) " .
    1599         "- ( ? < (birth_month*100 + birth_day))) " .
    1600         "AS age FROM c_member WHERE birth_year <> 0;";
    1601     $lst = db_get_all($sql, array($cur));
     1597    $mmdd = $today['mon'] * 100 + $today['mday'];
     1598    $sql = 'SELECT ' . $today['year'] . ' - birth_year'
     1599         . ' - (' . $mmdd . ' < (birth_month * 100 + birth_day))'
     1600         . ' AS age FROM c_member WHERE birth_year <> 0';
     1601    $lst = db_get_all($sql);
    16021602
    16031603    $temp = array_keys($analysis_generation);
Note: See TracChangeset for help on using the changeset viewer.