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

Changeset 3057


Ignore:
Timestamp:
May 20, 2007, 6:32:14 PM (12 years ago)
Author:
ogawa
Message:

#484:MySQLの設定でSQL ModesにSTRICT_TRANS_TABLESが指定されている環境下で動作しない

Location:
OpenPNE/branches/2.8.x
Files:
15 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/2.8.x/webapp/lib/db/api.php

    r1856 r3057  
    5757}
    5858
    59 
    60 //API‚ðˆê‚Ž擾
    6159function db_api_get_c_api_one($name)
    6260{
     
    6765}
    6866
    69 //API‚ª‹–‰Â‚µ‚Ä‚¢‚éIP‚©‚Ç‚¤‚©ƒ`ƒFƒbƒN‚·‚é
    7067function db_api_check_ip($name, $ip)
    7168{
     
    7875}
    7976
    80 
    81 
    8277?>
  • OpenPNE/branches/2.8.x/webapp/lib/db/ashiato.php

    r1856 r3057  
    7070    return db_get_one($sql, $params);
    7171}
    72 
    73 ?>
    74 <?php
    75 /**
    76  * @copyright 2005-2007 OpenPNE Project
    77  * @license   http://www.php.net/license/3_01.txt PHP License 3.01
    78  */
    7972
    8073/**
  • OpenPNE/branches/2.8.x/webapp/lib/db/commu.php

    r2971 r3057  
    20332033        'r_datetime' => db_now(),
    20342034        'r_date' => db_now(),
     2035        'image_filename' => '',
    20352036    );
    20362037    return db_insert('c_commu', $data);
     
    23262327        'r_datetime' => db_now(),
    23272328        'r_date' => db_now(),
     2329        'image_filename1' => '',
     2330        'image_filename2' => '',
     2331        'image_filename3' => '',
     2332        'filename' => '',
    23282333    );
    23292334    return db_insert('c_commu_topic_comment', $data);
  • OpenPNE/branches/2.8.x/webapp/lib/db/diary.php

    r2906 r3057  
    984984        'r_date' => db_now(),
    985985        'is_checked' => 1,
     986        'image_filename_1' => '',
     987        'image_filename_2' => '',
     988        'image_filename_3' => '',
    986989    );
    987990    return db_insert('c_diary', $data);
     
    11091112        'body' => $body,
    11101113        'r_datetime' => db_now(),
     1114        'image_filename_1' => '',
     1115        'image_filename_2' => '',
     1116        'image_filename_3' => '',
    11111117    );
    11121118    return db_insert('c_diary_comment', $data);
  • OpenPNE/branches/2.8.x/webapp/lib/db/etc.php

    r2970 r3057  
    609609        'c_member_id'             => intval($c_member_id),
    610610        'page_name'               => $page_name,
    611         'target_c_member_id'      => '',
    612         'target_c_commu_id'       => '',
    613         'target_c_commu_topic_id' => '',
    614         'target_c_diary_id'       => '',
     611        'target_c_member_id'      => 0,
     612        'target_c_commu_id'       => 0,
     613        'target_c_commu_topic_id' => 0,
     614        'target_c_diary_id'       => 0,
    615615        'ktai_flag'               => (bool)$ktai_flag,
    616616        'r_datetime' => db_now(),
  • OpenPNE/branches/2.8.x/webapp/lib/db/friend.php

    r2641 r3057  
    641641        'c_member_id_to' => intval($c_member_id_to),
    642642        'r_datetime' => db_now(),
     643        'intro' => '',
    643644    );
    644645    db_insert('c_friend', $data);
     
    648649        'c_member_id_to' => intval($c_member_id_from),
    649650        'r_datetime' => db_now(),
     651        'intro' => '',
    650652    );
    651653    db_insert('c_friend', $data);
  • OpenPNE/branches/2.8.x/webapp/lib/db/member.php

    r2929 r3057  
    988988        'is_receive_daily_news' => intval($c_member['is_receive_daily_news']),
    989989        'r_date' => db_now(),
     990        'image_filename' => '',
     991        'image_filename_1' => '',
     992        'image_filename_2' => '',
     993        'image_filename_3' => '',
     994        'rss' => '',
    990995    );
    991996    $c_member_id = db_insert('c_member', $data);
     
    10011006        'ktai_address'   => t_encrypt($c_member_secure['ktai_address']),
    10021007        'regist_address' => t_encrypt($c_member_secure['regist_address']),
     1008        'easy_access_id' => '',
    10031009    );
    10041010    db_insert('c_member_secure', $data);
     
    10231029        'c_member_id_invite' => intval($profs['c_member_id_invite']),
    10241030        'c_password_query_id' => intval($profs['c_password_query_id']),
     1031        'image_filename' => '',
     1032        'image_filename_1' => '',
     1033        'image_filename_2' => '',
     1034        'image_filename_3' => '',
     1035        'rss' => '',
    10251036    );
    10261037    $c_member_id_new = db_insert('c_member', $data);
     
    10301041        'hashed_password' => md5($profs['password']),
    10311042        'hashed_password_query_answer' => md5($profs['password_query_answer']),
    1032         'ktai_address'     => t_encrypt($profs['ktai_address']),
     1043        'pc_address' => '',
     1044        'ktai_address' => t_encrypt($profs['ktai_address']),
    10331045        'regist_address' => t_encrypt($profs['ktai_address']),
     1046        'easy_access_id' => '',
    10341047    );
    10351048    db_insert('c_member_secure', $data);
     
    12801293        'session' => $session,
    12811294        'r_date' => db_now(),
     1295        'nickname' => '',
     1296        'password' => '',
     1297        'ktai_address' => '',
     1298        'easy_access_id' => '',
     1299        'c_password_query_answer' => '',
    12821300    );
    12831301    return db_insert('c_member_pre', $data);
     
    15511569        'is_receive_daily_news' => true,
    15521570        'r_date' => db_now(),
     1571        'image_filename' => '',
     1572        'image_filename_1' => '',
     1573        'image_filename_2' => '',
     1574        'image_filename_3' => '',
     1575        'rss' => '',
    15531576    );
    15541577    $c_member_id = db_insert('c_member', $data);
     
    15611584        'ktai_address'   => "",
    15621585        'regist_address' => "",
     1586        'easy_access_id' => '',
    15631587    );
    15641588    db_insert('c_member_secure', $data);
  • OpenPNE/branches/2.8.x/webapp/lib/db/message.php

    r2535 r3057  
    402402        'r_datetime'       => db_now(),
    403403        'is_send'          => 1,
     404        'image_filename_1' => '',
     405        'image_filename_2' => '',
     406        'image_filename_3' => '',
    404407    );
    405408    return db_insert('c_message', $data);
     
    426429        'is_syoudaku'      => 1,
    427430        'is_read'          => 1,
     431        'image_filename_1' => '',
     432        'image_filename_2' => '',
     433        'image_filename_3' => '',
    428434    );
    429435    return db_insert('c_message', $data);
     
    443449        'is_send'          => 0,
    444450        'hensinmoto_c_message_id' => intval($jyusin_message_id),
     451        'image_filename_1' => '',
     452        'image_filename_2' => '',
     453        'image_filename_3' => '',
    445454    );
    446455    return db_insert('c_message', $data);
  • OpenPNE/branches/2.8.x/webapp/lib/db/point.php

    r2874 r3057  
    5757            'c_profile_id'   => intval($c_profile_id),
    5858            'c_profile_option_id' => 0,
    59             'value' => 0,
     59            'value' => '0',
    6060            'public_flag' => $public_flag,
    6161        );
  • OpenPNE/branches/2.8.x/webapp/lib/util/image.php

    r1856 r3057  
    259259            'bin' => $c_tmp_image['bin'],
    260260            'r_datetime' => db_now(),
     261            'type' => '',
    261262        );
    262263        if (db_insert("c_image", $params)) {
  • OpenPNE/branches/2.8.x/webapp/modules/admin/lib/db_admin.php

    r3027 r3057  
    129129        'is_hidden_after' => 0,
    130130        'is_hidden_before' => 0,
     131        'image_filename' => '',
    131132    );
    132133    return db_insert('c_banner', $data);
  • OpenPNE/branches/2.8.x/webapp/modules/setup/do/setup.php

    r2641 r3057  
    3737            'c_member_id' => 1,
    3838            'hashed_password' => md5($requests['password']),
     39            'hashed_password_query_answer' => '',
    3940            'pc_address' => t_encrypt($requests['pc_address']),
     41            'ktai_address' => '',
    4042            'regist_address' => t_encrypt($requests['pc_address']),
     43            'easy_access_id' => '',
    4144        );
    4245        db_insert('c_member_secure', $data);
     
    4649            'username' => $requests['admin_username'],
    4750            'password' => md5($requests['admin_password']),
     51            'auth_type' => 'all',
    4852        );
    4953        db_insert('c_admin_user', $data);
  • OpenPNE/branches/2.8.x/webapp_biz/modules/admin_biz/lib/db_admin.php

    r2641 r3057  
    118118        'is_hidden_after' => 0,
    119119        'is_hidden_before' => 0,
     120        'image_filename' => '',
    120121    );
    121122    return db_insert('c_banner', $data);
     
    165166        'name' => $name,
    166167        'caption' => $caption,
     168        'info' => '',
    167169        'is_required' => (bool)$is_required,
    168170        'public_flag_edit' => (bool)$public_flag_edit,
  • OpenPNE/branches/2.8.x/webapp_biz/modules/biz/lib/mysql_functions.php

    r2963 r3057  
    266266
    267267    return $members;
    268 }
    269 
    270 //指定された予定IDを保持している施設名を得る関数
    271 function biz_getJoinShisetsuSchedule($id)
    272 {
    273     $sql = 'SELECT * FROM biz_schedule_shisetsu WHERE biz_schedule_id = ?';
    274     $params = array(
    275         intval($id),
    276     );
    277     $tmp = db_get_all($sql, $params);
    278     $shisetsu = array();
    279 
    280     if (!is_array($tmp)) {
    281         $tmp = array();
    282     }
    283 
    284     foreach ($tmp as $key=> $value) {
    285         $sql = 'SELECT name FROM biz_shisetsu WHERE biz_shisetsu_id = ?';
    286         $params = array(
    287             intval($value['shisetsu_id']),
    288         );
    289         $shisetsu += array($key => db_get_one($sql, $params));
    290     }
    291 
    292     return $shisetsu;
    293268}
    294269
     
    11111086        'finish_time' => $finish_time,
    11121087    );
    1113     $insert_id = db_insert('biz_shisetsu_schedule', $data);
    1114 
    1115     $data = array(
    1116         'shisetsu_id' => intval($shisetsu_id),
    1117         'schedule_id' => intval($insert_id),
    1118     );
    1119     db_insert('biz_schedule_shisetsu', $data);
     1088    return db_insert('biz_shisetsu_schedule', $data);
    11201089}
    11211090
  • OpenPNE/branches/2.8.x/webapp_biz/modules/ktai_biz/page/fh_biz_schedule_view.php

    r1856 r3057  
    7272            $jmembers = array_unique($jmembers);
    7373        }
    74         $jshisetsu = biz_getJoinShisetsuSchedule($requests['id']);
    7574
    7675        //参加者は10人目まで表示
Note: See TracChangeset for help on using the changeset viewer.