www/update.php

   1 <?php
   2         //MySQL 更新データの仕様
   3         // ステージごとに一つのテーブル"Stage_[StageName]"をもつ。
   4         // 変更テストテスト
   5
   6         define("DATABASE_USER", "pcd2013devUser");
   7         define("DATABASE_PWD", "MoonStone");
   8         define("DATABASE_NAME", "pcd2013dev");
   9         define("REGEX_SQL_QUERY_ESCAPE", "\\|\"|\'");
  10         define("QUERY_SELECT_USER_ID", "SELECT id from AuthUserTable where name = ?;");
  11         define("QUERY_SELECT_USER_ID_TYPES", "s");
  12         define("QUERY_ADD_USER", "insert into AuthUserTable (name) values (?)");
  13         define("QUERY_ADD_USER_TYPES", "s");
  14
  15         $db = new mysqli('localhost', DATABASE_USER, DATABASE_PWD, DATABASE_NAME);
  16         if (mysqli_connect_error()) {
  17                 die('接続に失敗しました。');
  18         }
  19         // 文字化け防止
  20         $db->set_charset("utf8");
  21
  22 if(isset($_GET['action']) && isset($_GET['name'])){
  23         $action = $_GET['action'];
  24         $name = urldecode($_GET['name']);
  25         if(strcmp($action, 'join') == 0){
  26                 echo("new Array(");
  27                 $stmt = $db->prepare(QUERY_SELECT_USER_ID);
  28                 $stmt->bind_param(QUERY_SELECT_USER_ID_TYPES, $name);
  29                 $stmt->execute();
  30                 // 結果の個数を確認
  31                 if($stmt->errno == 0){
  32                         //クエリ成功
  33                         $stmt->store_result();
  34                         if($stmt->num_rows == 0){
  35                                 //ユーザー名はリストになかった=はじめてのひと
  36                                 $stmt = $db->prepare(QUERY_ADD_USER);
  37                                 $stmt->bind_param(QUERY_ADD_USER_TYPES, $name);
  38                                 $stmt->execute();
  39                                 if($stmt->errno == 0){
  40                                         //クエリ成功
  41                                         $stmt = $db->prepare(QUERY_SELECT_USER_ID);
  42                                         $stmt->bind_param(QUERY_SELECT_USER_ID_TYPES, $name);
  43                                         $stmt->execute();
  44                                         if($stmt->errno == 0){
  45                                                 //クエリ成功
  46                                                 $stmt->store_result();
  47                                                 if($stmt->num_rows == 0){
  48                                                         //ユーザー名はリストになかった=そんな…登録したのに。あきらめてエラーを返す
  49                                                         echo("0,");
  50                                                 } else{
  51                                                         //ユーザー名がリストにある=予想通り
  52                                                         $stmt->bind_result($id);
  53                                                         $stmt->fetch();
  54                                                         echo($id);
  55                                                         echo(",");
  56                                                 }
  57                                         } else{
  58                                                 //クエリ失敗
  59                                                 echo("0,");
  60                                         }
  61                                 } else{
  62                                         //クエリ失敗
  63                                         echo("0,");
  64                                 }
  65                         } else{
  66                                 //すでにユーザー名がリストにある=続きからプレイ
  67                                 $stmt->bind_result($id);
  68                                 $stmt->fetch();
  69                                 echo($id);
  70                                 echo(",");
  71                         }
  72                 } else{
  73                         //クエリ失敗
  74                         echo("0,");
  75                 }
  76                 echo(ceil(microtime(true)*1000));
  77                 echo(",'main');");
  78         }
  79 }
  80 ?>