From d514141b4dd37f6b0f9a69dc2c6d6d158894fcb2 Mon Sep 17 00:00:00 2001
From: gumi <git@gumi.ca>
Date: Sat, 25 Jul 2020 22:20:25 -0400
Subject: add documentation for the player cache system

---
 server/scripts/player_cache.md | 53 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 53 insertions(+)
 create mode 100644 server/scripts/player_cache.md

diff --git a/server/scripts/player_cache.md b/server/scripts/player_cache.md
new file mode 100644
index 0000000..4469be6
--- /dev/null
+++ b/server/scripts/player_cache.md
@@ -0,0 +1,53 @@
+# Player Cache System
+
+The player cache keeps an in-memory copy of misc player data when they log in to the server to reduce the need to query the SQL database at runtime (which slightly adds lag). The player cache should be used whenever possible instead of writing queries.
+
+## name2account
+
+Returns the account id associated with a char name.
+
+```c
+"playerCache"::name2account("Reid");
+```
+
+## name2char
+
+Returns the char id associated with a char name.
+
+```c
+"playerCache"::name2char("Reid");
+```
+
+## char2account
+
+Returns the account id associated with a char id.
+
+```c
+"playerCache"::char2account(.@charID);
+```
+
+## account2char
+
+Returns the char id associated with an account id.
+**This is a weak reference**: an account id does not uniquely identify a character.
+
+```c
+"playerCache"::account2char(.@accountID);
+```
+
+## vault2account
+
+Returns the account id associated with a Vault account id.
+**This is a weak reference**: a Vault account does not uniquely identify a game account.
+
+```c
+"playerCache"::vault2account(.@vaultID);
+```
+
+## account2vault
+
+Returns the Vault account id associated with a game account id.
+
+```c
+"playerCache"::account2vault(.@accountID);
+```
-- 
cgit v1.2.3-70-g09d2