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

Changeset 462


Ignore:
Timestamp:
Oct 14, 2006, 12:40:51 PM (16 years ago)
Author:
tejimaa
Message:

rss.phpできあがり。

Location:
OpenPNE/branches/tejima/prj_db_refine/webapp/lib/db
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/tejima/prj_db_refine/webapp/lib/db/deplicated_tejima.php

    r452 r462  
    1616        return db_bookmark_list($c_member_id, $page, $page_size);
    1717}
     18//------------------------------------------------------------------
     19function p_h_home_h_blog_list_friend4c_member_id($c_member_id, $page_size = 5)
     20{
     21        return db_rss_h_blog_list_friend4c_member_id($c_member_id, $page_size);
     22}
     23function p_h_diary_list_all_c_rss_cache_list($limit)
     24{
     25        return db_rss_list_all_c_rss_cache_list($limit);
     26}
     27function p_h_diary_list_friend_c_rss_cache_list($c_member_id, $limit)
     28{
     29        return db_rss_list_friend_c_rss_cache_list($c_member_id, $limit);
     30}
     31function p_fh_diary_list_c_rss_cache_list($c_member_id,$page_size, $page)
     32{
     33        return db_rss_list_c_rss_cache_list($c_member_id,$page_size, $page);
     34}
     35function p_fh_diary_list_c_rss_cache_list_date($c_member_id, $year, $month, $day=0)
     36{
     37        return db_rss_list_c_rss_cache_list_date($c_member_id, $year, $month, $day);
     38}
     39function p_f_home_c_rss_cache_list4c_member_id($c_member_id, $limit = 5)
     40{
     41        return db_rss_c_rss_cache_list4c_member_id($c_member_id);
     42}
     43function db_is_duplicated_rss_cache($c_member_id, $date, $link)
     44{
     45        return db_rss_is_duplicated_rss_cache($c_member_id, $date, $link);
     46}
     47function db_is_updated_rss_cache($c_member_id, $link)
     48{
     49        return db_rss_is_updated_rss_cache($c_member_id, $link);
     50}
     51function db_is_future_rss_item($date)
     52{
     53        return db_rss_is_future_rss_item($date);
     54}
     55
     56function db_insert_c_rss_cache($c_member_id, $subject, $body, $date, $link)
     57{
     58        return db_rss_insert_c_rss_cache($c_member_id, $subject, $body, $date, $link);
     59}
     60
     61function db_update_c_rss_cache($c_rss_cache_id, $subject, $body, $date, $link)
     62{
     63        return db_rss_update_c_rss_cache($c_rss_cache_id, $subject, $body, $date, $link);
     64}
     65
     66function delete_rss_cache($c_member_id)
     67{
     68        return db_rss_delete_rss_cache($c_member_id);
     69{
     70
     71function insert_rss_cache($rss_url, $c_member_id)
     72{
     73        return db_rss_insert_rss_cache($rss_url, $c_member_id);
     74}
    1875
    1976
  • OpenPNE/branches/tejima/prj_db_refine/webapp/lib/db/rss.php

    r454 r462  
    55 */
    66
    7 function p_h_home_h_blog_list_friend4c_member_id($c_member_id, $page_size = 5)
     7function db_rss_h_blog_list_friend4c_member_id($c_member_id, $page_size = 5)
    88{
    99    $sql = "SELECT c_rss_cache.*, c_member.nickname" .
     
    1616}
    1717
    18 function p_h_diary_list_all_c_rss_cache_list($limit)
     18function db_rss_list_all_c_rss_cache_list($limit)
    1919{
    2020    $hint = db_mysql_hint('FORCE INDEX (r_datetime)');
     
    2828}
    2929
    30 function p_h_diary_list_friend_c_rss_cache_list($c_member_id, $limit)
     30function db_rss_list_friend_c_rss_cache_list($c_member_id, $limit)
    3131{
    3232    $friends = db_friend_c_member_id_list($c_member_id, true);
     
    4545}
    4646
    47 function p_fh_diary_list_c_rss_cache_list($c_member_id,$page_size, $page)
     47function db_rss_list_c_rss_cache_list($c_member_id,$page_size, $page)
    4848{
    4949    $sql = 'SELECT * FROM c_rss_cache WHERE c_member_id = ? ORDER BY r_datetime DESC';
     
    5757}
    5858
    59 function p_fh_diary_list_c_rss_cache_list_date($c_member_id, $year, $month, $day=0)
     59function db_rss_list_c_rss_cache_list_date($c_member_id, $year, $month, $day=0)
    6060{
    6161    if ($day) {
     
    7979}
    8080
    81 function p_f_home_c_rss_cache_list4c_member_id($c_member_id, $limit = 5)
     81function db_rss_c_rss_cache_list4c_member_id($c_member_id, $limit = 5)
    8282{
    8383    $sql = 'SELECT * FROM c_rss_cache WHERE c_member_id = ? ORDER BY r_datetime DESC';
     
    8686}
    8787
    88 function db_is_duplicated_rss_cache($c_member_id, $date, $link)
     88function db_rss_is_duplicated_rss_cache($c_member_id, $date, $link)
    8989{
    9090    $sql = 'SELECT c_rss_cache_id FROM c_rss_cache' .
     
    9494}
    9595
    96 function db_is_updated_rss_cache($c_member_id, $link)
     96function db_rss_is_updated_rss_cache($c_member_id, $link)
    9797{
    9898    $sql = 'SELECT c_rss_cache_id FROM c_rss_cache' .
     
    102102}
    103103
    104 function db_is_future_rss_item($date)
     104function db_rss_is_future_rss_item($date)
    105105{
    106106    $item_timestamp = strtotime($date);
     
    115115 */
    116116
    117 function db_insert_c_rss_cache($c_member_id, $subject, $body, $date, $link)
     117function db_rss_insert_c_rss_cache($c_member_id, $subject, $body, $date, $link)
    118118{
    119119    $data = array(
     
    128128}
    129129
    130 function db_update_c_rss_cache($c_rss_cache_id, $subject, $body, $date, $link)
     130function db_rss_update_c_rss_cache($c_rss_cache_id, $subject, $body, $date, $link)
    131131{
    132132    $data = array(
     
    144144 * メンバーのRSSを削除する
    145145 */
    146 function delete_rss_cache($c_member_id)
     146function db_rss_delete_rss_cache($c_member_id)
    147147{
    148148    $sql = 'DELETE FROM c_rss_cache WHERE c_member_id = ?';
     
    151151}
    152152
    153 function insert_rss_cache($rss_url, $c_member_id)
     153function db_rss_insert_rss_cache($rss_url, $c_member_id)
    154154{
    155155    include_once 'OpenPNE/RSS.php';
Note: See TracChangeset for help on using the changeset viewer.