Changeset 6446

Timestamp:

Apr 9, 2008, 4:12:01 PM (14 years ago)

Author:

ebihara

Message:

#2180:merged r6392:6396, r6401 (thanks to toraneko)

Location:

OpenPNE/trunk

Files:

• setup/sql/mysql41/update/update-for2.12-useroption.sql (copied) (copied from OpenPNE/branches/work/toraneko/prj_commentmail/setup/sql/mysql41/update/update-for2.12-useroption.sql)
• webapp/lib/db/member.php (modified) (1 diff)
• webapp/modules/ktai/init.inc (modified) (1 diff)
• webapp/modules/pc/init.inc (modified) (1 diff)

OpenPNE/trunk/webapp/lib/db/member.php

@@ -1952 +1952 @@
 }
 
+/*
+ * c_member_configの値を取得する
+ * @param int $c_member_id
+ * @return array メンバー設定情報
+ */
+function db_member_c_member_config4c_member_id($c_member_id)
+{
+    $sql = 'SELECT a.*,b.name FROM c_member_config a'
+         . ' INNER JOIN c_member_config_option b USING(c_member_config_option_id)'
+         . ' WHERE c_member_id = ?';
+    $params = array(intval($c_member_id));
+    $list = db_get_all($sql,$params);
+
+    $member_config = array();
+    foreach ($list as $value){
+        $member_config[$value['name']] = $value['value'];
+    }
+    return $member_config;
+}
+
+/*
+ * 設定値があるか
+ * @param int $c_member_id
+ * @param int $c_member_config_option_id
+ * @return true あり false なし
+ */
+function db_member_c_member_config4optionid($c_member_id,$c_member_config_option_id)
+{
+    $sql = 'SELECT COUNT(c_member_config_id) FROM c_member_config'
+         . ' WHERE c_member_id = ? AND c_member_config_option_id = ?';
+    $params = array(intval($c_member_id),intval($c_member_config_option_id));
+    return (bool)db_get_one($sql, $params, 'main');
+}
+
+/*
+ * c_member_config_option_id取得
+ * @param str $name
+ * @return int $c_member_config_option_id
+ */
+function db_member_config_option_id4name($name)
+{
+    $sql = 'SELECT c_member_config_option_id FROM c_member_config_option'
+         . ' WHERE name = ?';
+    $params = array(strval($name));
+    return db_get_one($sql,$params);    
+}
+
+/*
+ * c_member_config更新(無ければInsert)
+ * @param int $c_member_id
+ * @param str $name
+ * @param str $value
+ */
+function db_member_update_c_member_config($c_member_id, $name, $value)
+{
+    $optionid = db_member_config_option_id4name($name);
+
+    if (!db_member_c_member_config4optionid($c_member_id,$optionid)){
+        $data = array('c_member_id' => intval($c_member_id),
+                  'c_member_config_option_id' => intval($optionid),
+                  'value' => intval($value));
+        db_insert('c_member_config', $data);
+    } else {
+        $data = array('value' => intval($value));
+        $where = array('c_member_id'=>intval($c_member_id),
+                       'c_member_config_option_id' => intval($optionid));
+        db_update('c_member_config', $data, $where);
+    }
+}
+
 ?>

OpenPNE/trunk/webapp/modules/ktai/init.inc

@@ -85 +85 @@
     }
 
+    if ($is_secure) {
+        $u = $GLOBALS['AUTH']->uid();
+        $smarty->assign('C_MEMBER_CONFIG',db_member_c_member_config4c_member_id($u));
+    }
+
     // set SJIS
     $smarty->setOutputCharset('SJIS');

OpenPNE/trunk/webapp/modules/pc/init.inc

@@ -66 +66 @@
     $smarty->assign('INC_FOOTER_side_banner_html_before', p_common_c_siteadmin4target_pagename('side_banner_html_before'));
     $smarty->assign('INC_FOOTER_side_banner_html_after', p_common_c_siteadmin4target_pagename('side_banner_html_after'));
+
+    if ($is_secure) {
+        $u = $GLOBALS['AUTH']->uid();
+        $smarty->assign('C_MEMBER_CONFIG',db_member_c_member_config4c_member_id($u));
+    }
+
 }