Talk:Webbased configurator - Revision history

Tneo: /* GRF Stuff */

2008-10-12T10:10:02Z

‎GRF Stuff

Tneo: /* GRF order */ new section

2008-10-12T10:06:32Z

‎GRF order: new section

Kommer at 13:29, 10 October 2008

2008-10-10T13:29:13Z

Kommer: /* User Group relationship */

2008-10-10T13:28:28Z

‎User Group relationship

Kommer: /* GRF Stuff */

2008-10-10T13:27:51Z

‎GRF Stuff

Kommer: /* Value Table */

2008-10-10T13:27:23Z

‎Value Table

Kommer: /* Project Scope */

2008-10-10T11:16:28Z

‎Project Scope

Thraxian: Page re-design for organization, new topics

2008-10-09T12:52:08Z

Page re-design for organization, new topics

Kommer: /* Accountability */

2008-10-08T18:14:55Z

‎Accountability

Kommer: /* Accountability */

2008-10-08T18:14:41Z

‎Accountability

← Older revision		Revision as of 10:10, 12 October 2008
Line 22:		Line 22:

	:Good idea. Dont think I will implement it in version 1 but the table is already added [[User:Kommer\|Kommer]] 13:27, 10 October 2008 (UTC)		:Good idea. Dont think I will implement it in version 1 but the table is already added [[User:Kommer\|Kommer]] 13:27, 10 October 2008 (UTC)
		+
		+	Do we want to keep track of GRF updates and when they did become absolete in the database? Or do we physically remove the deleted GRF from the database? Perhaps we should think about something like GRF_add_date_ID, GRF_prev_date_ID, GRF_lastupdate_date_ID. The first ID never changes, but in the database you can keep a kind of history of a GRF. Perhaps it is just a step too far for something like this? (Bit related to the accountability part of Thraxian.) --[[User:Tneo\|Tneo]] 10:10, 12 October 2008 (UTC)

	=== User Group relationship ===		=== User Group relationship ===

← Older revision		Revision as of 10:06, 12 October 2008
Line 41:		Line 41:

	:The project scope is now updated on the main page -- [[User:Kommer\|Kommer]] 13:16, 10 October 2008 (UTC)		:The project scope is now updated on the main page -- [[User:Kommer\|Kommer]] 13:16, 10 October 2008 (UTC)
		+
		+	== GRF order ==
		+
		+	Just a thought and I couldn't find anything about that explicitly yet. Some GRF's require to be loaded before others and have certain dependencies. Will the tool take care of the dependencies, like make those that don't work with chosen climate be unavailable? Will the tool order the GRF list so that they are loaded in the proper order?
		+	Do we want to be able to load various trainsets in a game, or seen possible conflicts in GRF's do we always use one trainset? Is it needed in the database to mark trainset GRF's as such that you can only pick one? Or can PHP handle that, wherefor I presume you still need to know wich GRF is a trainset and which is not. --[[User:Tneo\|Tneo]] 10:06, 12 October 2008 (UTC)

@@ Line 15: / Line 15: @@
 What is the purpose of the value table?  It appears that each of the tables in the server_* and configuration_* tables contain a value for each option.  Does this table hold a list of possible values for an option (like in the case of breakdowns, none, reduced, normal, etc.?)  If so, the value table might want to hold both a name and a value. The name would be displayed in the drop-down list of options, while the value would actually be used in the server_* and configuration_* tables. -- [[User:Thraxian|Thraxian]] 12:52, 9 October 2008 (UTC)
-Your assumption is right. Added a name to the table [[User:Kommer|Kommer]] 13:27, 10 October 2008 (UTC)
+:Your assumption is right. Added a name to the table [[User:Kommer|Kommer]] 13:27, 10 October 2008 (UTC)
 === GRF Stuff ===
@@ Line 21: / Line 21: @@
 Do you want to add the ability to automatically detect GRF requirements and add them as appropriate?  It might make the tool a bit more complex than intended. A new GRF_requirements table would contain the ID of one GRF and the ID of one of its pre-requisites.  If a user adds a GRF, this requirements table would be checked and any required GRFs not currently added will automatically be added, and ordered directly before the user-added GRF.  The problem arises when a user re-orders the GRF list (if that is possible), to ensure that the requirements are still automatically placed earlier in the order than the GRF that needs them.  Could make things complex, but you might consider that as a future expansion of the database design.  The new table would be newgrf_requirement (requirement_id PK, newgrf_id FK1 [newgrf.newgrf_ID], required_newgrf_id FK2 [newgrf.newgrf_ID]).  -- [[User:Thraxian|Thraxian]] 12:52, 9 October 2008 (UTC)
-Good idea. Dont think I will implement it in version 1 but the table is already added [[User:Kommer|Kommer]] 13:27, 10 October 2008 (UTC)
+:Good idea. Dont think I will implement it in version 1 but the table is already added [[User:Kommer|Kommer]] 13:27, 10 October 2008 (UTC)
 === User Group relationship ===
@@ Line 27: / Line 27: @@
 The current schema allows a user to be associated with one and only one server group.  Is this relationship by design?  Would it be better to allow users to belong to more than one server group (for instance, read/write on PS but read-only on Dev).  The current solution for this scenario would be a group for users that have these specific rights.  By assigning the users to groups through another table, you could have a read/write PS group and a read-only Dev group, and the user is a member of both.  The new table would be user_group_member(member_ID PK, user_id FK1 [user.user_ID], group_id FK2 [group.group_ID]), and group_ID would no longer exist in the user table.  Thoughts?  -- [[User:Thraxian|Thraxian]] 12:52, 9 October 2008 (UTC)
-Already changed that :) [[User:Kommer|Kommer]] 13:28, 10 October 2008 (UTC)
+:Already changed that :) [[User:Kommer|Kommer]] 13:28, 10 October 2008 (UTC)
 == Project Scope ==
@@ Line 40: / Line 40: @@
 Many of these features may already be handled by autopilot, but to my knowledge, there isn't a web-based tool to run that, and I don't know of any IRC reference on how someone with appropriate rights can run autopilot commands.  A web-based auto-pilot (or at least some documentation - internal or wiki) may be a separate project, but it would be good to clarify what this web-based configuration tool is NOT going to do. -- [[User:Thraxian|Thraxian]] 12:52, 9 October 2008 (UTC)
-The project scope is now updated on the main pahe  -- [[User:Kommer|Kommer]] 13:16, 10 October 2008 (UTC)
+:The project scope is now updated on the main page  -- [[User:Kommer|Kommer]] 13:16, 10 October 2008 (UTC)

← Older revision		Revision as of 13:28, 10 October 2008
Line 26:		Line 26:

	The current schema allows a user to be associated with one and only one server group. Is this relationship by design? Would it be better to allow users to belong to more than one server group (for instance, read/write on PS but read-only on Dev). The current solution for this scenario would be a group for users that have these specific rights. By assigning the users to groups through another table, you could have a read/write PS group and a read-only Dev group, and the user is a member of both. The new table would be user_group_member(member_ID PK, user_id FK1 [user.user_ID], group_id FK2 [group.group_ID]), and group_ID would no longer exist in the user table. Thoughts? -- [[User:Thraxian\|Thraxian]] 12:52, 9 October 2008 (UTC)		The current schema allows a user to be associated with one and only one server group. Is this relationship by design? Would it be better to allow users to belong to more than one server group (for instance, read/write on PS but read-only on Dev). The current solution for this scenario would be a group for users that have these specific rights. By assigning the users to groups through another table, you could have a read/write PS group and a read-only Dev group, and the user is a member of both. The new table would be user_group_member(member_ID PK, user_id FK1 [user.user_ID], group_id FK2 [group.group_ID]), and group_ID would no longer exist in the user table. Thoughts? -- [[User:Thraxian\|Thraxian]] 12:52, 9 October 2008 (UTC)
		+
		+	Already changed that :) [[User:Kommer\|Kommer]] 13:28, 10 October 2008 (UTC)

	== Project Scope ==		== Project Scope ==

← Older revision		Revision as of 13:27, 10 October 2008
Line 20:		Line 20:

	Do you want to add the ability to automatically detect GRF requirements and add them as appropriate? It might make the tool a bit more complex than intended. A new GRF_requirements table would contain the ID of one GRF and the ID of one of its pre-requisites. If a user adds a GRF, this requirements table would be checked and any required GRFs not currently added will automatically be added, and ordered directly before the user-added GRF. The problem arises when a user re-orders the GRF list (if that is possible), to ensure that the requirements are still automatically placed earlier in the order than the GRF that needs them. Could make things complex, but you might consider that as a future expansion of the database design. The new table would be newgrf_requirement (requirement_id PK, newgrf_id FK1 [newgrf.newgrf_ID], required_newgrf_id FK2 [newgrf.newgrf_ID]). -- [[User:Thraxian\|Thraxian]] 12:52, 9 October 2008 (UTC)		Do you want to add the ability to automatically detect GRF requirements and add them as appropriate? It might make the tool a bit more complex than intended. A new GRF_requirements table would contain the ID of one GRF and the ID of one of its pre-requisites. If a user adds a GRF, this requirements table would be checked and any required GRFs not currently added will automatically be added, and ordered directly before the user-added GRF. The problem arises when a user re-orders the GRF list (if that is possible), to ensure that the requirements are still automatically placed earlier in the order than the GRF that needs them. Could make things complex, but you might consider that as a future expansion of the database design. The new table would be newgrf_requirement (requirement_id PK, newgrf_id FK1 [newgrf.newgrf_ID], required_newgrf_id FK2 [newgrf.newgrf_ID]). -- [[User:Thraxian\|Thraxian]] 12:52, 9 October 2008 (UTC)
		+
		+	Good idea. Dont think I will implement it in version 1 but the table is already added [[User:Kommer\|Kommer]] 13:27, 10 October 2008 (UTC)

	=== User Group relationship ===		=== User Group relationship ===

← Older revision		Revision as of 13:27, 10 October 2008
Line 14:		Line 14:

	What is the purpose of the value table? It appears that each of the tables in the server_* and configuration_* tables contain a value for each option. Does this table hold a list of possible values for an option (like in the case of breakdowns, none, reduced, normal, etc.?) If so, the value table might want to hold both a name and a value. The name would be displayed in the drop-down list of options, while the value would actually be used in the server_* and configuration_* tables. -- [[User:Thraxian\|Thraxian]] 12:52, 9 October 2008 (UTC)		What is the purpose of the value table? It appears that each of the tables in the server_* and configuration_* tables contain a value for each option. Does this table hold a list of possible values for an option (like in the case of breakdowns, none, reduced, normal, etc.?) If so, the value table might want to hold both a name and a value. The name would be displayed in the drop-down list of options, while the value would actually be used in the server_* and configuration_* tables. -- [[User:Thraxian\|Thraxian]] 12:52, 9 October 2008 (UTC)
		+
		+	Your assumption is right. Added a name to the table [[User:Kommer\|Kommer]] 13:27, 10 October 2008 (UTC)

	=== GRF Stuff ===		=== GRF Stuff ===

← Older revision		Revision as of 11:16, 10 October 2008
Line 33:		Line 33:

	Many of these features may already be handled by autopilot, but to my knowledge, there isn't a web-based tool to run that, and I don't know of any IRC reference on how someone with appropriate rights can run autopilot commands. A web-based auto-pilot (or at least some documentation - internal or wiki) may be a separate project, but it would be good to clarify what this web-based configuration tool is NOT going to do. -- [[User:Thraxian\|Thraxian]] 12:52, 9 October 2008 (UTC)		Many of these features may already be handled by autopilot, but to my knowledge, there isn't a web-based tool to run that, and I don't know of any IRC reference on how someone with appropriate rights can run autopilot commands. A web-based auto-pilot (or at least some documentation - internal or wiki) may be a separate project, but it would be good to clarify what this web-based configuration tool is NOT going to do. -- [[User:Thraxian\|Thraxian]] 12:52, 9 October 2008 (UTC)
		+
		+	The project scope is now updated on the main pahe -- [[User:Kommer\|Kommer]] 13:16, 10 October 2008 (UTC)

@@ Line 1: / Line 1: @@
-==Accountability==
+== Database Design ==
 If accountability is a concern, there are a few more things you'll want to add to your database schema.  In particular, a last_modified time (and optionally a last_editor) column on some of the tables to indicate when (and by whom) the last modifications were done.  At the very least, the configuration/server tables should probably have this information.  You may also want to add them to the configuration_* tables to indicate the changes that were made.
@@ Line 5: / Line 7: @@
 Also, will you need a security table to store authorized users (and passwords) which will grant people access to the modification abilities?  You may also consider a simple audit_trail table, which contains a list of users, times, and actions performed using the web-based tool. You may have already designed this table, and have not displayed it for security reasons.  Other alternatives would require linking this tool in with an existing security module, like a web or wiki login.
-Again, if accountability is not a concern (now or ever), you can disregard this comment.
+Again, if accountability is not a concern (now or ever), you can disregard this comment. -- [[User:Thraxian|Thraxian]] 13:51, 7 October 2008 (UTC)
--- [[User:Thraxian|Thraxian]] 13:51, 7 October 2008 (UTC)
+What is the scope of this project?  Is the purpose to provide a CFG file only?  What about some of these other features?
--------------
+Many of these features may already be handled by autopilot, but to my knowledge, there isn't a web-based tool to run that, and I don't know of any IRC reference on how someone with appropriate rights can run autopilot commands.  A web-based auto-pilot (or at least some documentation - internal or wiki) may be a separate project, but it would be good to clarify what this web-based configuration tool is NOT going to do. -- [[User:Thraxian|Thraxian]] 12:52, 9 October 2008 (UTC)

← Older revision		Revision as of 18:14, 8 October 2008
Line 10:		Line 10:

	Thanks for your comments. I added the authorization and logging part. Didnt have time for that. Please comment on the design v0,02		Thanks for your comments. I added the authorization and logging part. Didnt have time for that. Please comment on the design v0,02
		+
		+	-------------

← Older revision		Revision as of 18:14, 8 October 2008
Line 8:		Line 8:

	-- [[User:Thraxian\|Thraxian]] 13:51, 7 October 2008 (UTC)		-- [[User:Thraxian\|Thraxian]] 13:51, 7 October 2008 (UTC)
		+
		+	Thanks for your comments. I added the authorization and logging part. Didnt have time for that. Please comment on the design v0,02