Changeset 9091

Timestamp:

Nov 11, 2008, 9:17:07 PM (14 years ago)

Author:

shingo

Message:

#3135:PC版のコミュニティ新規登録以外のコミュニティ情報編集フォームで、重複したコミュニティ名が登録できてしまうのを修正

Location:

OpenPNE/branches/stable-2.12.x/webapp

Files:

• lib/db/commu.php (modified) (1 diff)
• lib/util/ktai.php (modified) (1 diff)
• modules/ktai/do/c_edit_update_c_commu.php (modified) (1 diff)
• modules/ktai/do/h_com_add_insert_c_commu.php (modified) (1 diff)
• modules/ktai/templates/h_com_add.tpl (modified) (1 diff)
• modules/pc/do/c_edit_update_c_commu.php (modified) (1 diff)

OpenPNE/branches/stable-2.12.x/webapp/lib/db/commu.php

@@ -3461 +3461 @@
 }
 
+/**
+ * コミュニティ名が変更されているかどうか
+ *
+ * @param int $c_commu_id
+ * @param string $name
+ * @return bool
+ */
+function db_commu_is_changed_c_commu_name($c_commu_id, $name)
+{
+    $sql = 'SELECT name FROM c_commu WHERE c_commu_id = ?';
+    $params = array(intval($c_commu_id));
+    $now_name = db_get_one($sql, $params);
+    if ($name === $now_name) {
+        return false;
+    }
+    return true;
+}
+
 ?>

OpenPNE/branches/stable-2.12.x/webapp/lib/util/ktai.php

@@ -62 +62 @@
         47  => "ｺﾒﾝﾄが1000番に達したので、これ以上のｺﾒﾝﾄはできません",
         48  => "設定を変更しました",
+        49  => "その" . WORD_COMMUNITY . "はすでに存在します",
     );
 

OpenPNE/branches/stable-2.12.x/webapp/modules/ktai/do/c_edit_update_c_commu.php

@@ -24 +24 @@
         $public_flag = $requests['public_flag'];
         $topic_authority = $requests['topic_authority'];
+
+        if (   db_commu_is_changed_c_commu_name($target_c_commu_id, $name)
+            && db_commu_is_commu4c_commu_name($name)) {
+            $p = array('msg' => 49);
+            openpne_redirect('ktai', 'page_h_com_add', $p);
+        }
         // ----------
 

OpenPNE/branches/stable-2.12.x/webapp/modules/ktai/do/h_com_add_insert_c_commu.php

@@ -22 +22 @@
         $info = $requests['info'];
         $public_flag = $requests['public_flag'];
+
+        if (db_commu_is_commu4c_commu_name($name)) {
+            $p = array('msg' => 49);
+            openpne_redirect('ktai', 'page_h_com_add', $p);
+        }
         // ----------
 

OpenPNE/branches/stable-2.12.x/webapp/modules/ktai/templates/h_com_add.tpl

@@ -4 +4 @@
 <font color="#({$ktai_color_config.font_05})"><a name="top">({$WORD_COMMUNITY_HALF})の作成</a></font><br>
 </td></tr></table>
+
+({if $msg})
+<font color="#({$ktai_color_config.font_09})">({$msg})</font><br>
+<br>
+({/if})
 
 ({t_form m=ktai a=do_h_com_add_insert_c_commu})

OpenPNE/branches/stable-2.12.x/webapp/modules/pc/do/c_edit_update_c_commu.php

@@ -38 +38 @@
         if (!$name) $err_msg[] = WORD_COMMUNITY . "名を入力してください";
         if (!$info) $err_msg[] = WORD_COMMUNITY . "の説明を入力してください";
+
+        if (   db_commu_is_changed_c_commu_name($target_c_commu_id, $name)
+            && db_commu_is_commu4c_commu_name($name)) {
+            $err_msg[] = 'その' . WORD_COMMUNITY . 'はすでに存在します';
+        }
 
         if (!empty($upfile_obj) && $upfile_obj['error'] !== UPLOAD_ERR_NO_FILE) {