X-Git-Url: http://git.osdn.net/view?a=blobdiff_plain;f=www%2Fheader.php;fp=www%2Fheader.php;h=8d33e3fac6efb837639f38df6eae22569bee8524;hb=4f383eb289315bfa0b5dfe9e3468f164aad6a4fa;hp=1946f81054085a67bfa489a770f7b57e257ef30e;hpb=5e04f57d6a7553745a7e406d75be62257c522349;p=h58pcdgame%2FGameScriptCoreLibrary.git diff --git a/www/header.php b/www/header.php index 1946f81..8d33e3f 100644 --- 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) {