- This topic has 3 replies, 1 voice, and was last updated 1 week, 6 days ago by ejsoon.
-
AuthorPosts
-
2026-05-10 at 10:17:36 #192062026-05-10 at 23:44:22 #19215ejsoonKeymaster
翻譯成繁體中文：
Steps to add a new game to the database.
Generally, everything here has to be done twice, once to the development
database on your local machine, and again on the live database. It's not
critical when, except of course the changes have to be made sometime before
the game goes live.Open the database using Mysql Workbench or similar tool of your choice.
Add a new row to the "variations" table. This contains several crucial
things which also have to be known to the GameInfo entry for the game.These next two items trigger massive internal changes in mysql which alter
every record. I've never had any trouble resulting, but be cautious.Use "edit table" to change the enum "variations" in EITHER the zertz_gamerecord
or the mp_gamerecord table. Zertz-gamecord for strictly 2 player games, mp_gamerecord
for games with potentially more than 2 players.Use edit table to change the enum "variations" in the "ranking" table.
Sometime after these changes are made to the database, the game server has
to be restarted. The restart script extracts the new data from the database
and configures the server. In particular, the "directory number" and
corresponding physical directory location of the new game needs to be known
to the server.The new game's short name (2 letter name) and full name, and directory number
need to be installed in the new game's GameInfo record, and naturally must
agree with the database values.2026-05-10 at 23:46:07 #19216ejsoonKeymaster這是在資料庫中新增遊戲的步驟翻譯：
---
### 將新遊戲新增至資料庫的步驟
通常情況下，這裡的所有操作都需要執行兩次：一次是在你本地機器的**開發資料庫**，另一次則是在**正式環境資料庫（Live Database）**。操作的時間點並非絕對關鍵，但顯然必須在遊戲正式上線前的某個時間點完成。
1. **開啟資料庫**：使用 MySQL Workbench 或任何你偏好的類似工具。
2. **新增資料列**：在variations資料表中新增一行。這包含了幾個關鍵項目，這些項目也必須與該遊戲的GameInfo條目內容一致。
3. **更新列舉型別（Enum）**：
> **注意：** 接下來的這兩個項目會觸發 MySQL 內部的重大變更並更動所有記錄。雖然我從未遇到過問題，但請務必謹慎執行。* 使用「編輯資料表（edit table）」功能，修改
zertz_gamerecord或mp_gamerecord資料表中的variations列舉值。如果是嚴格的雙人遊戲，請修改zertz_gamerecord；如果是可能超過兩人的遊戲，則修改mp_gamerecord。
* 使用「編輯資料表」功能，修改ranking資料表中的variations列舉值。4. **重啟伺服器**：在對資料庫完成這些變更後的某個時間點，必須**重啟遊戲伺服器**。重啟腳本會從資料庫中提取新資料並配置伺服器。特別是新遊戲的「目錄編號（directory number）」及對應的實際物理目錄位置，必須讓伺服器知曉。
5. **同步 GameInfo**：新遊戲的短名稱（2 個字母的代碼）、全名以及目錄編號，都必須設定在該遊戲的GameInfo紀錄中，且理所當然必須與資料庫中的數值保持一致。2026-05-13 at 06:11:37 #19228 -
AuthorPosts
- You must be logged in to reply to this topic.