Design Document Server Side Overview - Revision history

Rich: /* Include Modules */ added authajax.php and removed makeTables.php

2020-10-03T21:18:38Z

Include Modules: added authajax.php and removed makeTables.php

← Older revision		Revision as of 21:18, 3 October 2020
Line 144:		Line 144:
	There are also a number of php modules that are included (using ''require once'') by some of the above programs to reduce redundant code.		There are also a number of php modules that are included (using ''require once'') by some of the above programs to reduce redundant code.

	* [[Design_Document_Server_Side_Coding_Details#auth.php\|auth.php]] is included at the front of every php program that is listed above [except logout.php, emailPlayerID.php and emailPassword.php] and of every php enabled page. ~~This module~~ checks that the session is signed on and redirects control to access-denied.html if it is not.		* [[Design_Document_Server_Side_Coding_Details#auth.php\|auth.php]] is included at the front of every php program that is listed above [except logout.php, emailPlayerID.php and emailPassword.php] and of every php enabled page. It checks that the session is signed on and redirects control to access-denied.html if it is not.
			* [[Design_Document_Server_Side_Coding_Details#authajax.php\|authajax.php]] is included by auth.php to handle php programs that are called via AJAX. It checks that the session is signed on and will echo '''<!doctype html>''' and exit to the callback function if it is not.
	* [[Design_Document_Server_Side_Coding_Details#configMail.php\|configMail.php]] is included at the front of the sendEmail.php module. It contains information used to locate and access a SMTP server.		* [[Design_Document_Server_Side_Coding_Details#configMail.php\|configMail.php]] is included at the front of the sendEmail.php module. It contains information used to locate and access a SMTP server.
	* [[Design_Document_Server_Side_Coding_Details#config.php\|config.php]] is included at the front of every php program and php enabled page that accesses the board18 database. It contains information used to locate and access the BOARD18 database.		* [[Design_Document_Server_Side_Coding_Details#config.php\|config.php]] is included at the front of every php program and php enabled page that accesses the board18 database. It contains information used to locate and access the BOARD18 database.
Line 150:		Line 151:
	* [[Design_Document_Server_Side_Coding_Details#rm_r.php\|rm_r.php]] is a required module for board18BoxLoad.php. It contains the rm_r() function.		* [[Design_Document_Server_Side_Coding_Details#rm_r.php\|rm_r.php]] is a required module for board18BoxLoad.php. It contains the rm_r() function.
	* [[Design_Document_Server_Side_Coding_Details#sendEmail.php\|sendEmail.php]] is included at the front of every php program or module that sends Email. It accesses a SMTP server to actually send the email. This module includes some modules obtained from the [https://github.com/Synchro/PHPMailer PHPMailer] application.		* [[Design_Document_Server_Side_Coding_Details#sendEmail.php\|sendEmail.php]] is included at the front of every php program or module that sends Email. It accesses a SMTP server to actually send the email. This module includes some modules obtained from the [https://github.com/Synchro/PHPMailer PHPMailer] application.
	* [[Design_Document_Server_Side_Coding_Details#makeTables.php\|makeTables.php]] is included into various board18 PHP pages. It supplies a number of functions for creating the HTML to display various tables on those pages.

	[[Category:Design]]		[[Category:Design]]

Rich: /* Data Base */

2017-10-23T17:08:12Z

Data Base

← Older revision		Revision as of 17:08, 23 October 2017
Line 10:		Line 10:
	# The Box Table		# The Box Table
	# The Game Table		# The Game Table
	~~# The Game Check Point Table~~
	# The Game Link Table		# The Game Link Table
	# The Game Player Table		# The Game Player Table

Rich: /* Data Base */ removed tables and added link

2017-08-01T14:05:06Z

Data Base: removed tables and added link

← Older revision		Revision as of 14:05, 1 August 2017
Line 4:		Line 4:
	== Data Base==		== Data Base==

	BOARD 18 uses MySQL for its data management. A single database, with a data base name of BOARD18, is used. ~~The~~ database consists of ~~six~~ tables:		BOARD 18 uses MySQL for its data management. A single database, with a data base name of BOARD18, is used. <br>
			This database consists of seven tables:

			# The Auth Tokens Table
	# The Box Table		# The Box Table
	# The Game Table		# The Game Table
Line 13:		Line 15:
	# The Players Table		# The Players Table

	~~=== The Box Table===~~		These tables are described in detail on the [[Data Base Tables]] page.

	~~Each row in the table named “box” contains a game box. The table layout is shown below. The json_text field contains a stringified JSON game box object as described in section 5.2.1.~~

	~~{\| class="wikitable"~~
	~~!Column!!Type!!Null!!Default~~
	\|-
	~~\|box_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|bname\|\|Varchar (25)\|\|No\|\|~~
	\|-
	~~\|version\|\|Varchar (25)\|\|Yes\|\|NULL~~
	\|-
	~~\|create_date\|\|Timestamp\|\|Yes\|\|NULL~~
	\|-
	~~\|activity_date\|\|Timestamp\|\|No\|\|CURRENT_TIMESTAMP~~
	\|-
	~~\|author\|\|Varchar (25)\|\|No\|\|~~
	\|-
	~~\|status\|\|Varchar (10)\|\|No\|\|'Active'~~
	\|-
	~~\|json_text\|\|MediumText\|\|Yes\|\|NULL~~
	\|}

	~~=== The Game Table===~~

	~~The “game” table contains a row for each game that is being tracked by BOARD18. The table layout is shown below. The json_text field contains a stringified JSON game session object as~~ described in ~~section 5.2.2.~~

	~~{\| class="wikitable"~~
	~~!Column!!Type!!Null!!Default~~
	\|-
	~~\|game_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|gname\|\|Varchar (25)\|\|No\|\|~~
	\|-
	~~\|start_date\|\|Timestamp\|\|Yes\|\|NULL~~
	\|-
	~~\|activity_date\|\|Timestamp\|\|No\|\|CURRENT_TIMESTAMP~~
	\|-
	~~\|update_counter\|\|Int (11)\|\|No\|\|0~~
	\|-
	~~\|last_updater\|\|Varchar (45)\|\|No\|\|~~
	\|-
	~~\|box_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|cp_count\|\|Int (11)\|\|No\|\|0~~
	\|-
	~~\|status\|\|Varchar (10)\|\|No\|\|'Active'~~
	\|-
	~~\|json_text\|\|MediumText\|\|Yes\|\|NULL~~
	\|}

	~~=== The Game Snapshot Table===~~

	The “game_snap” table contains a row for each snapshot taken for each game that is being tracked by BOARD18. The table layout is shown below. The json_text field contains a stringified JSON game session object as described in section 5.2.2.

	~~{\| class="wikitable"~~
	~~!Column!!Type!!Null!!Default~~
	\|-
	~~\|game_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|cp_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|cp_date\|\|Timestamp\|\|No\|\|CURRENT_TIMESTAMP~~
	\|-
	~~\|player\|\|Varchar (45)\|\|No\|\|~~
	\|-
	~~\|last_updater\|\|Varchar (45)\|\|No\|\|~~
	\|-
	~~\|game_round\|\|Varchar (32)\|\|No\|\|~~
	\|-
	~~\|json_text\|\|MediumText\|\|Yes\|\|NULL~~
	\|}

	~~=== The Game Link Table===~~

	~~The “game_link” table contains a row for each link that will be available to each game that is being tracked by BOARD18. The table layout is shown below.~~

	~~{\| class="wikitable"~~
	~~!Column!!Type!!Null!!Default~~
	\|-
	~~\|game_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|link_name\|\|Varchar (30)\|\|No\|\|~~
	\|-
	~~\|link_url\|\|Varchar (100)\|\|Yes\|\|NULL~~
	\|-
	~~\|activity_date\|\|Timestamp\|\|No\|\|CURRENT_TIMESTAMP~~
	\|}

	~~=== The Game Player Table===~~

	The “game_player” table contains a row for each player of each active game that is being tracked by BOARD18. The table layout is shown below. This table is the link between players and the game sessions that they are playing.

	~~{\| class="wikitable"~~
	~~!Column!!Type!!Null!!Default~~
	\|-
	~~\|game_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|player_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|status\|\|Varchar (10)\|\|No\|\|'P'~~
	\|}

	~~=== The Players Table===~~

	~~The “players” table contains a row for each player that has a login ID in BOARD18. The table layout is shown below. This table is used to control player access to the application.~~

	~~{\| class="wikitable"~~
	~~!Column!!Type!!Null!!Default~~
	\|-
	~~\|player_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|firstname\|\|Varchar (25)\|\|No\|\|~~
	\|-
	~~\|lastname\|\|Varchar (25)\|\|Yes\|\|NULL~~
	\|-
	~~\|email\|\|Varchar (254)\|\|No\|\|~~
	\|-
	~~\|login\|\|Varchar (16)\|\|No\|\|~~
	\|-
	~~\|passwd\|\|Varchar (64)\|\|No\|\|~~
	\|-
	~~\|create_date\|\|Timestamp\|\|No\|\|CURRENT_TIMESTAMP~~
	\|-
	~~\|level\|\|Varchar (10)\|\|No\|\|player~~
	\|-
	~~\|changeit\|\|Tinyint (1)\|\|No\|\|0~~
	\|}

	~~=== The Auth_tokens Table===~~

	~~The “auth_tokens” table contains a row for each unexpired LTPAlocal cookie created during login processing. These rows are deleted when the cookies are deleted, so this is a volatile table. <br>~~
	~~The table layout is shown below. This table is used to control player access to~~ the ~~application~~.

	~~{\| class="wikitable"~~
	~~!Column!!Type!!Null!!Default~~
	\|-
	~~\|token_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|selector\|\|Varchar (16)\|\|Yes\|\|NULL~~
	\|-
	~~\|hashedValidator\|\|Char (64)\|\|Yes\|\|NULL~~
	\|-
	~~\|player_id\|\|Int (11)\|\|No\|\|~~
	\|-
	~~\|expires\|\|Bigint (20)\|\|Yes\|\|NULL~~
	\|}

	== Logic==		== Logic==

Rich: /* AJAX Called Programs */ update links

2017-07-31T22:56:38Z

AJAX Called Programs: update links

Rich: /* AJAX Called Programs */ update links

2017-07-31T22:50:38Z

AJAX Called Programs: update links

Rich: /* AJAX Called Programs */

2017-07-31T22:28:09Z

AJAX Called Programs

Rich: updated release notice

2017-07-31T18:20:13Z

updated release notice

← Older revision		Revision as of 18:20, 31 July 2017
Line 1:		Line 1:
	{{ReleaseNotice\|1.3}}		{{ReleaseNotice\|1.5}}
	The server side of the BOARD18 application will use a minimalist approach. In other words, anything that can be done on the client side, will be done on the client side. This philosophy limits the server mostly to data base access and game logging tasks. The server side of the BOARD18 application will also provide conflict resolution for multi thread database accesses. {{Design Document Index}}		The server side of the BOARD18 application will use a minimalist approach. In other words, anything that can be done on the client side, will be done on the client side. This philosophy limits the server mostly to data base access and game logging tasks. The server side of the BOARD18 application will also provide conflict resolution for multi thread database accesses. {{Design Document Index}}

Rich: /* AJAX Called Programs */ added auth_token logic

2017-07-31T18:19:40Z

AJAX Called Programs: added auth_token logic

← Older revision		Revision as of 18:19, 31 July 2017
Line 230:		Line 230:
	\|-		\|-
	\| [[Design_Document_Server_Side_Coding_Details#statSwap.php\|statSwap.php]]\|\|post\|\|board18SnapList.js\|\|echo status\|\|Yes		\| [[Design_Document_Server_Side_Coding_Details#statSwap.php\|statSwap.php]]\|\|post\|\|board18SnapList.js\|\|echo status\|\|Yes
			\|-
			\| [[Design_Document_Server_Side_Coding_Details#tokenCheck.php\|tokenCheck.php]]\|\|post\|\|index.html\|\|echo status\|\|Yes
			\|-
			\| [[Design_Document_Server_Side_Coding_Details#tokenInsert.php\|tokenInsert.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes
			\|-
			\| [[Design_Document_Server_Side_Coding_Details#tokenRemove.php\|tokenRemove.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[Design_Document_Server_Side_Coding_Details#updateGame.php\|updateGame.php]]\|\|post\|\|board18Map3.js\|\|echo status\|\|Yes		\| [[Design_Document_Server_Side_Coding_Details#updateGame.php\|updateGame.php]]\|\|post\|\|board18Map3.js\|\|echo status\|\|Yes
Line 271:		Line 277:
	* snapShow.php Returns an array of the game_snap records for the current game.		* snapShow.php Returns an array of the game_snap records for the current game.
	* statSwap.php Toggles game status in the database.		* statSwap.php Toggles game status in the database.
			* tokenCheck.php Checks each auth_token row for a match.
			* tokenInsert.php Inserts a new row in the auth_tokens table.
			* tokenRemove.php Deletes from auth_tokens table any rows for the logged in player.
	* updateGame.php Loads game updates into the database.		* updateGame.php Loads game updates into the database.
	* updateUser.php Updates a row in the players table.		* updateUser.php Updates a row in the players table.

Rich: /* The Auth_tokens Table */

2017-07-31T17:55:26Z

The Auth_tokens Table

← Older revision		Revision as of 17:55, 31 July 2017
Line 159:		Line 159:
	\|player_id\|\|Int (11)\|\|No\|\|		\|player_id\|\|Int (11)\|\|No\|\|
	\|-		\|-
	\|expires\|\|Bigint (20)\|\|Yes\|\|		\|expires\|\|Bigint (20)\|\|Yes\|\|NULL
	\|}		\|}

Rich: /* The Players Table */ added auth_tokens Table

2017-07-31T17:54:14Z

The Players Table: added auth_tokens Table

← Older revision		Revision as of 17:54, 31 July 2017
Line 130:		Line 130:
	\|lastname\|\|Varchar (25)\|\|Yes\|\|NULL		\|lastname\|\|Varchar (25)\|\|Yes\|\|NULL
	\|-		\|-
	\|email\|\|Varchar (25)\|\|No\|\|		\|email\|\|Varchar (254)\|\|No\|\|
	\|-		\|-
	\|login\|\|Varchar (16)\|\|No\|\|		\|login\|\|Varchar (16)\|\|No\|\|
Line 141:		Line 141:
	\|-		\|-
	\|changeit\|\|Tinyint (1)\|\|No\|\|0		\|changeit\|\|Tinyint (1)\|\|No\|\|0
			\|}

			=== The Auth_tokens Table===

			The “auth_tokens” table contains a row for each unexpired LTPAlocal cookie created during login processing. These rows are deleted when the cookies are deleted, so this is a volatile table. <br>
			The table layout is shown below. This table is used to control player access to the application.

			{\| class="wikitable"
			!Column!!Type!!Null!!Default
			\|-
			\|token_id\|\|Int (11)\|\|No\|\|
			\|-
			\|selector\|\|Varchar (16)\|\|Yes\|\|NULL
			\|-
			\|hashedValidator\|\|Char (64)\|\|Yes\|\|NULL
			\|-
			\|player_id\|\|Int (11)\|\|No\|\|
			\|-
			\|expires\|\|Bigint (20)\|\|Yes\|\|
	\|}		\|}

← Older revision		Revision as of 21:18, 3 October 2020
Line 144:		Line 144:
	There are also a number of php modules that are included (using ''require once'') by some of the above programs to reduce redundant code.		There are also a number of php modules that are included (using ''require once'') by some of the above programs to reduce redundant code.

	* [[Design_Document_Server_Side_Coding_Details#auth.php\|auth.php]] is included at the front of every php program that is listed above [except logout.php, emailPlayerID.php and emailPassword.php] and of every php enabled page. ~~This module~~ checks that the session is signed on and redirects control to access-denied.html if it is not.		* [[Design_Document_Server_Side_Coding_Details#auth.php\|auth.php]] is included at the front of every php program that is listed above [except logout.php, emailPlayerID.php and emailPassword.php] and of every php enabled page. It checks that the session is signed on and redirects control to access-denied.html if it is not.
			* [[Design_Document_Server_Side_Coding_Details#authajax.php\|authajax.php]] is included by auth.php to handle php programs that are called via AJAX. It checks that the session is signed on and will echo '''<!doctype html>''' and exit to the callback function if it is not.
	* [[Design_Document_Server_Side_Coding_Details#configMail.php\|configMail.php]] is included at the front of the sendEmail.php module. It contains information used to locate and access a SMTP server.		* [[Design_Document_Server_Side_Coding_Details#configMail.php\|configMail.php]] is included at the front of the sendEmail.php module. It contains information used to locate and access a SMTP server.
	* [[Design_Document_Server_Side_Coding_Details#config.php\|config.php]] is included at the front of every php program and php enabled page that accesses the board18 database. It contains information used to locate and access the BOARD18 database.		* [[Design_Document_Server_Side_Coding_Details#config.php\|config.php]] is included at the front of every php program and php enabled page that accesses the board18 database. It contains information used to locate and access the BOARD18 database.
Line 150:		Line 151:
	* [[Design_Document_Server_Side_Coding_Details#rm_r.php\|rm_r.php]] is a required module for board18BoxLoad.php. It contains the rm_r() function.		* [[Design_Document_Server_Side_Coding_Details#rm_r.php\|rm_r.php]] is a required module for board18BoxLoad.php. It contains the rm_r() function.
	* [[Design_Document_Server_Side_Coding_Details#sendEmail.php\|sendEmail.php]] is included at the front of every php program or module that sends Email. It accesses a SMTP server to actually send the email. This module includes some modules obtained from the [https://github.com/Synchro/PHPMailer PHPMailer] application.		* [[Design_Document_Server_Side_Coding_Details#sendEmail.php\|sendEmail.php]] is included at the front of every php program or module that sends Email. It accesses a SMTP server to actually send the email. This module includes some modules obtained from the [https://github.com/Synchro/PHPMailer PHPMailer] application.
	* [[Design_Document_Server_Side_Coding_Details#makeTables.php\|makeTables.php]] is included into various board18 PHP pages. It supplies a number of functions for creating the HTML to display various tables on those pages.

	[[Category:Design]]		[[Category:Design]]

← Older revision		Revision as of 22:56, 31 July 2017
Line 219:		Line 219:
	\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#newUser.php\|newUser.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#newUser.php\|newUser.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#playerGet.php\|playerGet.php]]\|\|post\|\|board18Players1.js\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#playerGet.php\|playerGet.php]]\|\|post\|\|board18Players1.js\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#playerShow.php\|playerShow.php]]\|\|post\|\|board18Players1.js\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#playerShow.php\|playerShow.php]]\|\|post\|\|board18Players1.js\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#playerUpdate.php\|playerUpdate.php]]\|\|post\|\|board18Players1.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#playerUpdate.php\|playerUpdate.php]]\|\|post\|\|board18Players1.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#snapShot.php\|snapShot.php]]\|\|post\|\|board18Map6.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#snapShot.php\|snapShot.php]]\|\|post\|\|board18Map6.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#snapShow.php\|snapShow.php]]\|\|post\|\|board18Map7.js\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#snapShow.php\|snapShow.php]]\|\|post\|\|board18Map7.js\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#statSwap.php\|statSwap.php]]\|\|post\|\|board18SnapList.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#statSwap.php\|statSwap.php]]\|\|post\|\|board18SnapList.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#tokenCheck.php\|tokenCheck.php]]\|\|post\|\|index.html\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#tokenCheck.php\|tokenCheck.php]]\|\|post\|\|index.html\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#tokenInsert.php\|tokenInsert.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#tokenInsert.php\|tokenInsert.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#tokenRemove.php\|tokenRemove.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#tokenRemove.php\|tokenRemove.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#updateGame.php\|updateGame.php]]\|\|post\|\|board18Map3.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#updateGame.php\|updateGame.php]]\|\|post\|\|board18Map3.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#updateUser.php\|updateUser.php]]\|\|post\|\|board18Admin.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#updateUser.php\|updateUser.php]]\|\|post\|\|board18Admin.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#validateUser.php\|validateUser.php]]\|\|post\|\|board18index.js\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_3#validateUser.php\|validateUser.php]]\|\|post\|\|board18index.js\|\|JSON file\|\|Yes
	\|}		\|}
	Most of the server side processing for BOARD18 is done in stand alone PHP programs that are executed from the web pages via AJAX calls.		Most of the server side processing for BOARD18 is done in stand alone PHP programs that are executed from the web pages via AJAX calls.

← Older revision		Revision as of 22:50, 31 July 2017
Line 195:		Line 195:
	\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#forcePasswd.php\|forcePasswd.php]]\|\|post\|\|board18Admin.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#forcePasswd.php\|forcePasswd.php]]\|\|post\|\|board18Admin.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#gameBox.php\|gameBox.php]]\|\|getJSON\|\|board18Map2.js\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#gameBox.php\|gameBox.php]]\|\|getJSON\|\|board18Map2.js\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#gameGet.php\|gameGet.php]]\|\|post\|\|board18Games.js\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#gameGet.php\|gameGet.php]]\|\|post\|\|board18Games.js\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#gameSession.php\|gameSession.php]]\|\|getJSON\|\|board18Map.php\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#gameSession.php\|gameSession.php]]\|\|getJSON\|\|board18Map.php\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#gameShow.php\|gameShow.php]]\|\|post\|\|board18Games.php\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#gameShow.php\|gameShow.php]]\|\|post\|\|board18Games.php\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#gameSnap.php\|gameSnap.php]]\|\|getJSON\|\|board18SnapMap.php\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#gameSnap.php\|gameSnap.php]]\|\|getJSON\|\|board18SnapMap.php\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#gameUpdate.php\|gameUpdate.php]]\|\|post\|\|board18Games.php\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#gameUpdate.php\|gameUpdate.php]]\|\|post\|\|board18Games.php\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#linkAdd.php\|linkAdd.php]]\|\|post\|\|board18Misc.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#linkAdd.php\|linkAdd.php]]\|\|post\|\|board18Misc.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#linkDel.php\|linkDel.php]]\|\|post\|\|board18Misc.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#linkDel.php\|linkDel.php]]\|\|post\|\|board18Misc.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#linkGet.php\|linkGet.php]]\|\|post\|\|board18Misc.js\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#linkGet.php\|linkGet.php]]\|\|post\|\|board18Misc.js\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#logout.php\|logout.php]]\|\|post\|\|board18Main.php\|\|echo status\|\|No		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#logout.php\|logout.php]]\|\|post\|\|board18Main.php\|\|echo status\|\|No
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#myGameList.php\|myGameList.php]]\|\|post\|\|board18Main.php\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#myGameList.php\|myGameList.php]]\|\|post\|\|board18Main.php\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#newUser.php\|newUser.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_2#newUser.php\|newUser.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[Design_Document_Server_Side_Coding_Details#playerGet.php\|playerGet.php]]\|\|post\|\|board18Players1.js\|\|JSON file\|\|Yes		\| [[Design_Document_Server_Side_Coding_Details#playerGet.php\|playerGet.php]]\|\|post\|\|board18Players1.js\|\|JSON file\|\|Yes

← Older revision		Revision as of 22:28, 31 July 2017
Line 169:		Line 169:
	!Return Type<ref>[[Coding_Standards_Introduction\|This standards document]] describes return types.</ref>!!MySQL?		!Return Type<ref>[[Coding_Standards_Introduction\|This standards document]] describes return types.</ref>!!MySQL?
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#allGameList.php\|allGameList.php]]\|\|post\|\|board18View.php\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#allGameList.php\|allGameList.php]]\|\|post\|\|board18View.php\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#boxGet.php\|boxGet.php]]\|\|post\|\|board18Boxes.php\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#boxGet.php\|boxGet.php]]\|\|post\|\|board18Boxes.php\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#boxShow.php\|boxShow.php]]\|\|post\|\|board18Boxes.php\|\|JSON file\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#boxShow.php\|boxShow.php]]\|\|post\|\|board18Boxes.php\|\|JSON file\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#boxUpdate.php\|boxUpdate.php]]\|\|post\|\|board18Boxes.php\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#boxUpdate.php\|boxUpdate.php]]\|\|post\|\|board18Boxes.php\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#changePlayers.php\|changePlayers.php]]\|\|post\|\|board18Misc.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#changePlayers.php\|changePlayers.php]]\|\|post\|\|board18Misc.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#checkForUpdate.php\|checkForUpdate.php]]\|\|post\|\|board18Map3.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#checkForUpdate.php\|checkForUpdate.php]]\|\|post\|\|board18Map3.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#createGame.php\|createGame.php]]\|\|post\|\|board18New.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#createGame.php\|createGame.php]]\|\|post\|\|board18New.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#emailPassword.php\|emailPassword.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#emailPassword.php\|emailPassword.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#emailPlayer.php\|emailPlayer.php]]\|\|post\|\|board18Players2.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#emailPlayer.php\|emailPlayer.php]]\|\|post\|\|board18Players2.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#emailPlayerAdd.php\|emailPlayerAdd.php]]\|\|post\|\|board18New.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#emailPlayerAdd.php\|emailPlayerAdd.php]]\|\|post\|\|board18New.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#emailPlayerID.php\|emailPlayerID.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#emailPlayerID.php\|emailPlayerID.php]]\|\|post\|\|board18index.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#emailPlayerRem.php\|emailPlayerRem.php]]\|\|post\|\|board18Misc.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#emailPlayerRem.php\|emailPlayerRem.php]]\|\|post\|\|board18Misc.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[~~Design_Document_Server_Side_Coding_Details~~#forcePasswd.php\|forcePasswd.php]]\|\|post\|\|board18Admin.js\|\|echo status\|\|Yes		\| [[Design_Document_PHP_AJAX_Coding_Details_Part_1#forcePasswd.php\|forcePasswd.php]]\|\|post\|\|board18Admin.js\|\|echo status\|\|Yes
	\|-		\|-
	\| [[Design_Document_Server_Side_Coding_Details#gameBox.php\|gameBox.php]]\|\|getJSON\|\|board18Map2.js\|\|JSON file\|\|Yes		\| [[Design_Document_Server_Side_Coding_Details#gameBox.php\|gameBox.php]]\|\|getJSON\|\|board18Map2.js\|\|JSON file\|\|Yes