Starcraft 2 - FFA

Stage 1, 2 and 3 of DSRack LAN #(3 in 1)

Our Starcraft 2 - Free for All tournaments are not to be taken that seriously.
The entire concept of FFA is way to random, but nevertheless we are still putting a bit of money into these tournaments so more casual players also have a chance of winning something.

Structure

Qualifier cup #1: Monday
Qualifier cup #2: Wednesday
Qualifier cup #3: Friday
Free For All - Master: Saturday

Entry fee

FREE ENTRY and no player limit for LAN participants.

Prize distribution

Prizes in qualification cups:

€65 & access to the FFA master cup
Giftcertificate for 2 hours of bowling & access to the FFA master cup

Prizes in FFA master cup:

€200
Hardware
Hardware

Prize pot requirements

The prize pot is guaranteed.

Schedule

Not set yet.

(default) 12 queries took 8 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `aros`	7	7	1
2	DESCRIBE `acos`	7	7	1
3	DESCRIBE `aros_acos`	7	7	1
4	DESCRIBE `webpages`	6	6	1
5	DESCRIBE `languages`	4	4	1
6	DESCRIBE `pages`	3	3	1
7	DESCRIBE `ip2nations`	3	3	1
8	SELECT `Webpage`.`id`, `Webpage`.`language_id`, `Webpage`.`page_id`, `Webpage`.`body`, `Webpage`.`updated`, `Webpage`.`created`, `Language`.`id`, `Language`.`code`, `Language`.`name`, `Language`.`native_name`, `Page`.`id`, `Page`.`name`, `Page`.`public` FROM `webpages` AS `Webpage` LEFT JOIN `languages` AS `Language` ON (`Webpage`.`language_id` = `Language`.`id`) LEFT JOIN `pages` AS `Page` ON (`Webpage`.`page_id` = `Page`.`id`) WHERE `Webpage`.`language_id` = 2 AND `Webpage`.`page_id` = 228 AND `Page`.`public` = 1 LIMIT 1	1	1	0
9	SELECT `Language`.`id`, `Language`.`code`, `Language`.`name`, `Language`.`native_name` FROM `languages` AS `Language` WHERE `Language`.`id` = 2	1	1	0
10	SELECT `Webpage`.`id`, `Webpage`.`language_id`, `Webpage`.`page_id`, `Webpage`.`body`, `Webpage`.`updated`, `Webpage`.`created` FROM `webpages` AS `Webpage` WHERE `Webpage`.`language_id` = (2)	62	62	1
11	SELECT `Page`.`id`, `Page`.`name`, `Page`.`public` FROM `pages` AS `Page` WHERE `Page`.`id` = 228	1	1	0
12	SELECT `Webpage`.`id`, `Webpage`.`language_id`, `Webpage`.`page_id`, `Webpage`.`body`, `Webpage`.`updated`, `Webpage`.`created` FROM `webpages` AS `Webpage` WHERE `Webpage`.`page_id` = (228)	2	2	0

(default) 12 queries took 8 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `aros`

DESCRIBE `acos`

DESCRIBE `aros_acos`

DESCRIBE `webpages`

DESCRIBE `languages`

DESCRIBE `pages`

DESCRIBE `ip2nations`

SELECT `Webpage`.`id`, `Webpage`.`language_id`, `Webpage`.`page_id`, `Webpage`.`body`, `Webpage`.`updated`, `Webpage`.`created`, `Language`.`id`, `Language`.`code`, `Language`.`name`, `Language`.`native_name`, `Page`.`id`, `Page`.`name`, `Page`.`public` FROM `webpages` AS `Webpage` LEFT JOIN `languages` AS `Language` ON (`Webpage`.`language_id` = `Language`.`id`) LEFT JOIN `pages` AS `Page` ON (`Webpage`.`page_id` = `Page`.`id`) WHERE `Webpage`.`language_id` = 2 AND `Webpage`.`page_id` = 228 AND `Page`.`public` = 1 LIMIT 1

SELECT `Language`.`id`, `Language`.`code`, `Language`.`name`, `Language`.`native_name` FROM `languages` AS `Language` WHERE `Language`.`id` = 2

SELECT `Webpage`.`id`, `Webpage`.`language_id`, `Webpage`.`page_id`, `Webpage`.`body`, `Webpage`.`updated`, `Webpage`.`created` FROM `webpages` AS `Webpage` WHERE `Webpage`.`language_id` = (2)

SELECT `Page`.`id`, `Page`.`name`, `Page`.`public` FROM `pages` AS `Page` WHERE `Page`.`id` = 228

SELECT `Webpage`.`id`, `Webpage`.`language_id`, `Webpage`.`page_id`, `Webpage`.`body`, `Webpage`.`updated`, `Webpage`.`created` FROM `webpages` AS `Webpage` WHERE `Webpage`.`page_id` = (228)