Parental Control - Revision history

Ray N: Added page category

2009-09-11T14:39:26Z

Added page category

←Older revision		Revision as of 14:39, 11 September 2009
Line 1:		Line 1:
			[[Category: Development]]
	LinuxMCE is installed in family environments with children of different ages. Lots of parents would like to limit the stuff that is available for the kids to see.		LinuxMCE is installed in family environments with children of different ages. Lots of parents would like to limit the stuff that is available for the kids to see.

2009-09-11T09:44:55Z

Files needed changing

←Older revision		Revision as of 09:44, 11 September 2009
Line 55:		Line 55:
	=== Files needed changing ===		=== Files needed changing ===

	src/Media_Plugin/Media_Plugin.cpp		* src/Media_Plugin/
	~~src/Media_Plugin/~~Media_Plugin_Grids.cpp		** Media_Plugin.cpp
			** Media_Plugin_Grids.cpp

2009-09-11T09:44:32Z

Orbiter Display

←Older revision		Revision as of 09:44, 11 September 2009
Line 53:		Line 53:
	The list of files currently shown at the orbiter is already filtered by lots of things. The SQL statement should be modified to take into account the filter criteria for the specific user.		The list of files currently shown at the orbiter is already filtered by lots of things. The SQL statement should be modified to take into account the filter criteria for the specific user.

	src/Media_Plugin ~~needs to be amended~~.		=== Files needed changing ===

			src/Media_Plugin/Media_Plugin.cpp
			src/Media_Plugin/Media_Plugin_Grids.cpp

2009-09-11T09:07:26Z

Orbiter Display

←Older revision		Revision as of 09:07, 11 September 2009
Line 53:		Line 53:
	The list of files currently shown at the orbiter is already filtered by lots of things. The SQL statement should be modified to take into account the filter criteria for the specific user.		The list of files currently shown at the orbiter is already filtered by lots of things. The SQL statement should be modified to take into account the filter criteria for the specific user.

	src/~~media_plugin~~ needs to be amended.		src/Media_Plugin needs to be amended.

2009-09-11T09:07:10Z

Orbiter Display

←Older revision		Revision as of 09:07, 11 September 2009
Line 52:		Line 52:
	== Orbiter Display ==		== Orbiter Display ==
	The list of files currently shown at the orbiter is already filtered by lots of things. The SQL statement should be modified to take into account the filter criteria for the specific user.		The list of files currently shown at the orbiter is already filtered by lots of things. The SQL statement should be modified to take into account the filter criteria for the specific user.

			src/media_plugin needs to be amended.

2009-09-11T09:02:49Z

Example

←Older revision		Revision as of 09:02, 11 September 2009
Line 23:		Line 23:
	=== Example ===		=== Example ===
	* FK_Users points to kid 16 y/o		* FK_Users points to kid 16 y/o
	** ~~FK_Attribute~~ points to R		** EK_Attribute points to R
	** MustMeet = False		** MustMeet = False
	** NotAllowed = True		** NotAllowed = True

	* FK_Users points to kid 6 y/o		* FK_Users points to kid 6 y/o
	** ~~FK_Attribute~~ points to PG13		** EK_Attribute points to PG13
	** MustMeet = False		** MustMeet = False
	** NotAllowed = True		** NotAllowed = True

	** ~~FK_Attribute~~ points to R		** EK_Attribute points to R
	** MustMeet = False		** MustMeet = False
	** NotAllowed = True		** NotAllowed = True

	** ~~FK_Attribute~~ points to Children		** EK_Attribute points to Children
	** MustMeet = True		** MustMeet = True
	** NotAllowed = False		** NotAllowed = False

	* FK_Users points to guest		* FK_Users points to guest
	** ~~FK_Attribute~~ points to X-Rated		** EK_Attribute points to X-Rated
	** MustMeet = False		** MustMeet = False
	** NotAllowed = True		** NotAllowed = True

2009-09-11T06:37:57Z

Example

←Older revision		Revision as of 06:37, 11 September 2009
Line 23:		Line 23:
	=== Example ===		=== Example ===
	* FK_Users points to kid 16 y/o		* FK_Users points to kid 16 y/o
	** FK_Attribute points to PG13
	** MustMeet = False
	** NotAllowed = False

	** FK_Attribute points to R		** FK_Attribute points to R
	** MustMeet = False		** MustMeet = False
	** NotAllowed = True		** NotAllowed = True

	** FK_Attribute points to Action
	** MustMeet = False
	** NotAllowed = False

	* FK_Users points to kid 6 y/o		* FK_Users points to kid 6 y/o
Line 44:		Line 36:
	** NotAllowed = True		** NotAllowed = True

	** FK_Attribute points to ~~Action~~		** FK_Attribute points to Children
			** MustMeet = True
			** NotAllowed = False

			* FK_Users points to guest
			** FK_Attribute points to X-Rated
	** MustMeet = False		** MustMeet = False
	** NotAllowed = True		** NotAllowed = True

	** FK_Attribute points to ~~Children~~		(We don't want our guests to see how strange our tastes are...)
	** MustMeet = True
	** NotAllowed = False

	== Display in the web admin ==		== Display in the web admin ==

2009-09-11T06:34:33Z

Data

←Older revision		Revision as of 06:34, 11 September 2009
Line 8:		Line 8:

	== Data ==		== Data ==
	~~There will be~~ a new table ~~called Attribute_Allowance~~. ~~This table contains FK_Attribute~~, MustMeet, NotAllowed, FK_Users.		=== Structure ===
			We need a new table in pluto_main:
			CREATE TABLE `pluto_main`.`Users_AttributeAllowance` (
			`FK_Users` Int NOT NULL,
			`EK_Attribute` int NOT NULL,
			`MustMeet` tinyint NOT NULL DEFAULT 0 COMMENT 'If this is set, ONLY media containing this attribute is listed',
			`NotAllowed` tinyint NOT NULL DEFAULT 0 COMMENT 'If this is set. the media containing the above attribute is NOT available',
			INDEX `users`(`FK_Users`)
			)
			ENGINE = InnoDB
			DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
			COMMENT = 'Contains limits and rules describing what media a user sees';

	=== Example ===		=== Example ===

2009-09-10T20:14:45Z

←Older revision		Revision as of 20:14, 10 September 2009
Line 40:		Line 40:
	** MustMeet = True		** MustMeet = True
	** NotAllowed = False		** NotAllowed = False

			== Display in the web admin ==
			As part of the user page, the web admin should have the ability to select AttributeType. This will filter the currently available attributes of that type, and the ability to mark Must Meet and/or Not Allowed buttons. These Attributes should be presented as a list, where the administrator can, after it was originally setup of a user, mark and unmark Must Meet and/or Not Allowed.

			== Orbiter Display ==
			The list of files currently shown at the orbiter is already filtered by lots of things. The SQL statement should be modified to take into account the filter criteria for the specific user.

2009-09-10T20:08:17Z

Example

←Older revision		Revision as of 20:08, 10 September 2009
Line 36:		Line 36:
	** MustMeet = False		** MustMeet = False
	** NotAllowed = True		** NotAllowed = True

			** FK_Attribute points to Children
			** MustMeet = True
			** NotAllowed = False