ネットワーク関連。ゲーム終了後もキャラクタ設定が保持されるようになった。

[h58pcdgame/GameScriptCoreLibrary.git] / www / header.php

diff --git a/www/header.php b/www/header.php
index 1946f81..8d33e3f 100644 (file)
--- a/www/header.php
+++ b/www/header.php
@@ -31,6 +31,10 @@ define("QUERY_SELECT_USER_TIMESTAMP", "SELECT lastResponseTimestamp from authUse
 define("QUERY_SELECT_USER_TIMESTAMP_TYPES", "i");
 define("QUERY_DELETE_OFFLINE_USER", "DELETE from authUserTable WHERE lastResponseTimestamp<=?");
 define("QUERY_DELETE_OFFLINE_USER_TYPES", "i");
+define("QUERY_SELECT_USER_CCLASS", "SELECT userCharacterBaseClass from authUserTable where id=?");
+define("QUERY_SELECT_USER_CCLASS_TYPES", "i");
+define("QUERY_UPDATE_USER_CCLASS", "UPDATE authUserTable SET userCharacterBaseClass=? where id=?");
+define("QUERY_UPDATE_USER_CCLASS_TYPES", "si");
 //SQL文 for stageObjectTable
 define("QUERY_ADD_OBJECT", "insert into stageObjectTable (locationX, locationY, velocityX, velocityY, stageName, className, objectAttribute, constructorArgs, ownerUserID, modifiedTimestamp, addedTimestamp) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
 define("QUERY_ADD_OBJECT_TYPES", "ddddssssiii");
@@ -57,7 +61,7 @@ define("DEFAULT_START_STAGE", "cselect");
 define("OBJECT_ALIVE_TIME_MS", 2000);
 define("OBJECT_DELETE_TIME_MS", 30000);
 define("USER_ALIVE_TIME_MS", 2000);
-define("USER_DELETE_TIME_MS", 30000);
+define("USER_DELETE_TIME_MS", 180000);
 
 function escapeMySQLArgumentString(&$str)
 {