Changeset 5202


Ignore:
Timestamp:
2006/09/20 11:18:00 (20 years ago)
Author:
kakinaka
Message:

blank

Location:
temp/trunk
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • temp/trunk/data/lib/slib.php

    r5199 r5202  
    21292129     
    21302130    //³Æ¥«¥Æ¥´¥êÆâ¤Î¾¦ÉÊ¿ô¤ò¿ô¤¨¤Æ³ÊǼ 
    2131     $sql = " INSERT INTO dtb_category_count(category_id, product_count) "; 
    2132     $sql .= " SELECT T1.category_id, count(T2.category_id) FROM dtb_category AS T1 LEFT JOIN dtb_products AS T2 "; 
     2131    $sql = " INSERT INTO dtb_category_count(category_id, product_count, now()) "; 
     2132    $sql .= " SELECT T1.category_id, count(T2.category_id), now() FROM dtb_category AS T1 LEFT JOIN dtb_products AS T2 "; 
    21332133    $sql .= " ON T1.category_id = T2.category_id  "; 
    21342134    $sql .= " WHERE T2.del_flg = 0 AND T2.status = 1 "; 

  • temp/trunk/html/admin/products/product.php

    r5201 r5202  
    192192            $sqlval['creator_id'] = $_SESSION['member_id']; 
    193193            $sqlval['create_date'] = "now()"; 
     194            $sqlval['update_date'] = "now()"; 
    194195            $objQuery->insert("dtb_recommend_products", $sqlval); 
    195196            $rank--; 

  • temp/trunk/html/admin/products/product_class.php

    r5162 r5202  
    6868        $sqlval['creator_id'] = $_SESSION['member_id']; 
    6969        $sqlval['create_date'] = "now()"; 
     70        $sqlval['update_date'] = "now()"; 
    7071 
    7172        $objQuery->begin(); 
    … …  
    305306            $sqlval['creator_id'] = $_SESSION['member_id']; 
    306307            $sqlval['create_date'] = "now()"; 
     308            $sqlval['update_date'] = "now()"; 
    307309            // INSERT¤Î¼Â¹Ô 
    308310            $objQuery->insert("dtb_products_class", $sqlval); 

  • temp/trunk/html/products/review.php

    r4608 r5202  
    158158    } 
    159159    $arrRegist['create_date'] = 'now()'; 
     160    $arrRegist['update_date'] = 'now()'; 
    160161    $arrRegist['creator_id'] = '0'; 
    161162    //-- ÅÐÏ¿¼Â¹Ô 
Note: See TracChangeset for help on using the changeset viewer.