Coopetition Ladder - Revision history

XeryusTC at 22:27, 26 August 2006

2006-08-26T22:27:52Z

XeryusTC: /* Teams */

2006-08-23T14:43:10Z

‎Teams

Osai: added stats to score table

2006-08-22T21:41:13Z

added stats to score table

XeryusTC: /* Teams */

2006-08-22T21:20:14Z

‎Teams

XeryusTC at 19:54, 22 August 2006

2006-08-22T19:54:06Z

XeryusTC at 20:33, 20 August 2006

2006-08-20T20:33:56Z

XeryusTC at 12:49, 20 August 2006

2006-08-20T12:49:29Z

XeryusTC: /* Database settup */

2006-08-19T23:02:37Z

‎Database settup

XeryusTC at 15:28, 19 August 2006

2006-08-19T15:28:10Z

XeryusTC at 14:36, 19 August 2006

2006-08-19T14:36:11Z

← Older revision		Revision as of 22:27, 26 August 2006
Line 92:		Line 92:
	* team_id, the ID of the team the user wants to join, smallint. '''Linked to the teams table'''		* team_id, the ID of the team the user wants to join, smallint. '''Linked to the teams table'''

−	[[Category:~~Research~~]]	+	[[Category:Coopetition]]

@@ Line 2: / Line 2: @@
 All players should be able to join a team of his/her choice, this should be accepted by the team founder.
 A player should be able to:
-* Create his/her own team.
+* Create his/her own team. '''Done'''
 * Join an existing team. '''Done'''
-* Leave a team.
+* Leave a team. '''Done'''
 Teams have a team founder, he/she should be able to:
 * Challenge other teams.
 * Changing the team name (ladder supervisors should approve with the namechange too).
-* Kick players from the team.
+* Kick players from the team. '''Done'''
 * Edit the schedule (when the team is able to play).
-* Accept players into the team
+* Accept players into the team. '''Done'''
 * Delete the team '''Done'''
 * Join a ladder, this will be done automaticly on the 2vs2 ladder at first, it can be choosable when we decide to add more ladders. '''Done'''

@@ Line 45: / Line 45: @@
 * ladder_id, the ID of the ladder to which the score belongs, tinyint. '''Linked to the ladders table'''
 * score, the ELO score.
 ===Ladders===

@@ Line 3: / Line 3: @@
 A player should be able to:
 * Create his/her own team.
-* Join an existing team.
+* Join an existing team. '''Done'''
 * Leave a team.
 Teams have a team founder, he/she should be able to:
@@ Line 11: / Line 11: @@
 * Edit the schedule (when the team is able to play).
 * Accept players into the team
-* Delete the team
+* Delete the team '''Done'''
-* Join a ladder, this will be done automaticly on the 2vs2 ladder at first, it can be choosable when we decide to add more ladders.
+* Join a ladder, this will be done automaticly on the 2vs2 ladder at first, it can be choosable when we decide to add more ladders. '''Done'''
-* Reset ladder statistics.
+* Reset ladder statistics. '''Done'''
 ==Ratings==

@@ Line 25: / Line 25: @@
 * name, the actual name of the user, a varchar limited to 32 characters.
 * password, a varchar limited to 32 characters
-* team_id, the ID of the team the member is in, tinyint. '''Linked to the teams table'''
+* team_id, the ID of the team the member is in, smallint. '''Linked to the teams table'''
-* rights, if the user is an admin or has more rights than the average user, tinyint.
+* rights, if the user is an admin or has more rights than the average user, smallint.
 * email, the e-mail address of the user, a varchar limited to 50 characters.
 * nationality, the nationality of the user, tinyint. '''Linked to nationality table'''
@@ Line 33: / Line 33: @@
 The team table should get the following elements:
 * ID, an autoincrement field to keep the ID of the team.
-* founder, the user ID of the player that is founder of the team, tinyint. '''Linked to the user table'''
+* founder, the user ID of the player that is founder of the team, smallint. '''Linked to the user table'''
 * name, the name of the team as choosen by the founder, a varchar limited to 50 characters.
-* games_played, speaks for itself, tinyint.
+* games_played, speaks for itself, smallint.
-* games_won, the amount of games that the team won, tinyint.
+* games_won, the amount of games that the team won, smallyint.
 * description, some information about the team, text.
@@ Line 42: / Line 42: @@
 The score table holds the score of teams for each ladder they participate in. It should get the following elements:
 * ID, an autoincrement field to keep the ID of the score.
-* team_id, the ID that the score belongs too, tinyint. '''Linked to the teams table'''
+* team_id, the ID that the score belongs too, smallint. '''Linked to the teams table'''
 * ladder_id, the ID of the ladder to which the score belongs, tinyint. '''Linked to the ladders table'''
 * score, the ELO score.
@@ Line 61: / Line 61: @@
 * ID, an autoincrement field to keep the ID of the game.
 * ladder_id, the ladder in which the game was played, tinyint. '''Linked to the ladders table'''
-* team1_id, the ID of the first team, tinyint. '''Linked to the teams table'''
+* team1_id, the ID of the first team, smallint. '''Linked to the teams table'''
-* team2_id, the ID of the second team, tinyint. '''Linked to the teams table'''
+* team2_id, the ID of the second team, smallint. '''Linked to the teams table'''
 * date, the day at which the game was played, date.
 * savegame, the name of the savegame, a varchar limited to 30 characters.
@@ Line 78: / Line 78: @@
 * challenge_date, the date since the challenge has been submitted, date.
 * game_played, if the challenge has ended because the game has been played, boolean
-* team1_id, the ID of the challenging team, tinyint. '''Linked to the teams table'''
+* team1_id, the ID of the challenging team, smallint. '''Linked to the teams table'''
-* team2_id, the ID of the challenged team, tinyint. '''Linked to the teams table'''
+* team2_id, the ID of the challenged team, smallint. '''Linked to the teams table'''
 * proposed_date, the date at which the game will be held, date.
 [[Category:Research]]

← Older revision		Revision as of 20:33, 20 August 2006
Line 73:		Line 73:
	* trainlenght, the amount of tiles that the average train of the team team had, tinyint.		* trainlenght, the amount of tiles that the average train of the team team had, tinyint.

		+	===Challenges===
		+	Teams have to challenge other teams for a ladder game. The table should get the following elements:
		+	* ID, an autoincrement field to keep the ID of the challenge.
		+	* challenge_date, the date since the challenge has been submitted, date.
		+	* game_played, if the challenge has ended because the game has been played, boolean
		+	* team1_id, the ID of the challenging team, tinyint. '''Linked to the teams table'''
		+	* team2_id, the ID of the challenged team, tinyint. '''Linked to the teams table'''
		+	* proposed_date, the date at which the game will be held, date.

	[[Category:Research]]		[[Category:Research]]

@@ Line 18: / Line 18: @@
 We've decided to go with the [http://en.wikipedia.org/wiki/ELO_rating_system ELO rating system] as the ladder rating.
-==Database settup==
+==Database setup==
 ===Users===
 The user table should get the following elements:

@@ Line 55: / Line 55: @@
 * name, the name of the country, a varchar limited to 20 characters.
 * image, the name of the country's flag image.
 [[Category:Research]]