From a88f08c730ee5e240a89cda336b49c63fa728181 Mon Sep 17 00:00:00 2001 From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> Date: Wed, 10 Jul 2024 13:33:14 +0300 Subject: docs: add almost all lp history from the sheet (#168) --- backend/database/history.sql | 577 +++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 559 insertions(+), 18 deletions(-) (limited to 'backend') diff --git a/backend/database/history.sql b/backend/database/history.sql index cadb30c..4c14212 100644 --- a/backend/database/history.sql +++ b/backend/database/history.sql @@ -1,6 +1,6 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VALUES -- Portal 2 Singleplayer --- 1 +-- Chapter 1 (3,1,'slmid1995',3,'2011-10-05'), (3,1,'LookLikeAKango',1,'2011-10-06'), (3,1,'Bananasaurus Rex',0,'2011-10-24'), @@ -16,7 +16,46 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (9,1,'Jokie',3,'2011-10-05'), (9,1,'Tyronis',2,'2011-10-05'), (9,1,'sicklebrick',0,'2013-03-13'), --- 2 + +(3,2,'slmid1995',3,'2011-10-05'), +(3,2,'LookLikeAKango',1,'2011-10-06'), +(3,2,'Bananasaurus Rex',0,'2011-10-24'), +(4,2,'Tyronis',1,'2011-10-05'), +(4,2,'Krzyhau',0,'2019-05-10'), +(5,2,'LookLikeAKango',2,'2011-10-05'), +(5,2,'JesusCatFace',1,'2013-04-01'), +(6,2,'Stimich',4,'2011-10-08'), +(6,2,'aepaePolakrn',3,'2011-10-19'), +(6,2,'Krzyhau',2,'2020-10-10'), +(7,2,'Tyronis',0,'2013-01-11'), +(9,2,'slmid1995',4,'2011-10-05'), +(9,2,'Jokie',3,'2011-10-05'), +(9,2,'Tyronis',2,'2011-11-02'), +(9,2,'sicklebrick',0,'2013-03-13'), + +(3,3,'slmid1995',3,'2011-10-05'), +(3,3,'LookLikeAKango',1,'2011-10-06'), +(3,3,'Bananasaurus Rex',0,'2011-10-24'), +(4,3,'Tyronis',1,'2011-10-05'), +(4,3,'Krzyhau',0,'2019-05-10'), +(5,3,'LookLikeAKango',2,'2011-10-05'), +(5,3,'JesusCatFace',1,'2013-04-01'), +(6,3,'Stimich',4,'2011-10-08'), +(6,3,'aepaePolakrn',3,'2011-10-19'), +(6,3,'Krzyhau',1,'2017-07-29'), +(7,3,'Tyronis',0,'2013-01-11'), +(9,3,'slmid1995',4,'2011-10-05'), +(9,3,'Jokie',3,'2011-10-05'), +(9,3,'Tyronis',2,'2011-11-02'), +(9,3,'sicklebrick',0,'2013-03-13'), + +(3,4,'Krzyhau',0,'2018-01-11'), +(4,4,'Krzyhau',0,'2018-01-11'), +(5,4,'Krzyhau',0,'2018-01-11'), +(6,4,'Krzyhau',0,'2018-01-11'), +(9,4,'sicklebrick',0,'2013-03-13'), + +-- Chapter 2 (10,1,'Paraxade0',2,'2011-04-21'), (10,1,'PerOculos',0,'2011-04-21'), (11,1,'Tyronis',2,'2011-10-05'), @@ -27,11 +66,52 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (13,1,'jyjey',0,'2012-08-22'), (14,0,'?',0,'2011-04-19'), (15,1,'Tyronis',2,'2011-10-05'), +(15,1,'SuperAiderton',0,'2024-01-28'), (16,1,'LookLikeAKango',2,'2011-10-05'), (16,1,'jyjey',0,'2012-08-25'), (17,1,'rocoty',2,'2011-10-05'), (17,1,'Nidboj132',0,'2023-02-05'), --- 3 + +(10,2,'Paraxade0',2,'2011-04-21'), +(10,2,'PerOculos',0,'2014-08-23'), +(11,2,'Tyronis',2,'2011-10-05'), +(11,2,'Krzyhau',0,'2018-06-06'), +(12,2,'slmid1995',2,'2011-10-04'), +(13,2,'MPRS',3,'2011-05-04'), +(13,2,'Imanex',2,'2011-12-08'), +(13,2,'jyjey',0,'2012-08-22'), +(15,2,'Tyronis',2,'2011-10-05'), +(15,2,'Nidboj132',0,'2022-11-07'), +(16,2,'LookLikeAKango',2,'2011-10-05'), +(16,2,'jyjey',0,'2012-08-25'), +(17,2,'rocoty',2,'2011-10-05'), +(17,2,'Nidboj132',0,'2023-02-05'), + +(10,3,'Paraxade0',2,'2011-04-21'), +(10,3,'PerOculos',0,'2014-08-23'), +(11,3,'Tyronis',2,'2011-10-05'), +(11,3,'Krzyhau',0,'2018-06-06'), +(12,3,'slmid1995',2,'2011-10-04'), +(12,3,'Krzyhau',0,'2018-08-08'), +(13,3,'MPRS',3,'2011-05-04'), +(13,3,'Imanex',2,'2011-12-08'), +(13,3,'jyjey',0,'2012-08-22'), +(15,3,'Tyronis',2,'2011-10-05'), +(15,3,'Nidboj132',0,'2021-02-01'), +(16,3,'LookLikeAKango',2,'2011-10-05'), +(16,3,'jyjey',0,'2012-08-25'), +(17,3,'rocoty',2,'2011-10-05'), +(17,3,'Nidboj132',0,'2023-02-05'), + +(10,4,'PerOculos',0,'2014-08-23'), +(11,4,'Krzyhau',0,'2018-01-11'), +(12,4,'Krzyhau',0,'2018-01-11'), +(13,4,'Krzyhau',0,'2018-01-11'), +(15,4,'Krzyhau',0,'2018-01-11'), +(16,4,'Krzyhau',0,'2018-01-11'), +(17,4,'Krzyhau',0,'2018-01-11'), + +-- Chapter 3 (18,1,'The Last Tofus',5,'2011-05-08'), (18,1,'Schlepian',4,'2011-10-08'), (18,1,'szeimartin',3,'2013-10-08'), @@ -53,7 +133,62 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (26,1,'Schlepian',3,'2011-10-30'), (26,1,'Tyronis',2,'2012-01-08'), (26,1,'PerOculos',0,'2016-06-08'), --- 4 + +(18,2,'The Last Tofus',5,'2011-05-08'), +(18,2,'Schlepian',4,'2011-10-08'), +(18,2,'szeimartin',3,'2013-04-19'), +(18,2,'Krzyhau',2,'2020-05-15'), +(18,2,'Krzyhau',0,'2022-07-02'), +(19,2,'LookLikeAKango',2,'2011-10-06'), +(20,2,'Djinndrache',5,'2011-10-20'), +(20,2,'Schlepian',4,'2011-10-30'), +(20,2,'Jetwash',3,'2014-09-04'), +(20,2,'Krzyhau',2,'2020-02-17'), +(21,2,'LookLikeAKango',4,'2011-10-06'), +(21,2,'Schlepian',2,'2011-10-29'), +(21,2,'PerOculos',0,'2019-04-06'), +(22,2,'Tyronis',0,'2011-10-05'), +(23,2,'LookLikeAKango',2,'2011-10-06'), +(23,2,'Krzyhau',0,'2018-08-01'), +(24,2,'LeviHB',0,'2011-04-30'), +(25,2,'LeviHB',0,'2011-05-01'), +(26,2,'Schlepian',3,'2011-10-30'), +(26,2,'Tyronis',2,'2012-01-08'), +(26,2,'PerOculos',0,'2016-06-08'), + +(18,3,'The Last Tofus',5,'2011-05-08'), +(18,3,'Schlepian',4,'2011-10-08'), +(18,3,'szeimartin',3,'2013-04-19'), +(18,3,'Krzyhau',2,'2020-05-15'), +(18,3,'Krzyhau',0,'2022-07-02'), +(19,3,'LookLikeAKango',2,'2011-10-06'), +(20,3,'Djinndrache',5,'2011-10-20'), +(20,3,'Schlepian',4,'2011-10-30'), +(20,3,'Jetwash',3,'2014-09-04'), +(20,3,'Krzyhau',2,'2020-02-17'), +(21,3,'LookLikeAKango',4,'2011-10-06'), +(21,3,'Schlepian',2,'2011-10-29'), +(21,3,'Krzyhau',0,'2018-08-10'), +(22,3,'Tyronis',0,'2011-10-05'), +(23,3,'LookLikeAKango',2,'2011-10-06'), +(23,3,'Krzyhau',0,'2018-04-06'), +(24,3,'LeviHB',0,'2011-04-30'), +(25,3,'LeviHB',0,'2011-05-01'), +(26,3,'Schlepian',3,'2011-10-30'), +(26,3,'Tyronis',2,'2012-01-08'), +(26,3,'PerOculos',0,'2016-06-08'), + +(18,4,'Krzyhau',0,'2018-01-11'), +(19,4,'Krzyhau',0,'2018-01-11'), +(20,4,'Krzyhau',0,'2018-01-11'), +(21,4,'Krzyhau',0,'2018-01-11'), +(22,4,'Krzyhau',0,'2018-01-21'), +(23,4,'Krzyhau',0,'2018-01-11'), +(24,4,'Krzyhau',0,'2018-01-11'), +(25,4,'Krzyhau',0,'2018-01-11'), +(26,4,'Krzyhau',0,'2018-01-11'), + +-- Chapter 4 (27,1,'LeviHB',2,'2011-05-01'), (27,1,'PerOculos',0,'2020-07-13'), (28,1,'LeviHB',7,'2011-05-01'), @@ -62,7 +197,36 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (29,1,'LeviHB',0,'2011-05-01'), (30,1,'Schlepian',2,'2011-10-30'), (31,1,'Tyronis',0,'2011-10-06'), --- 5 + +(27,2,'LeviHB',2,'2011-05-01'), +(27,2,'PerOculos',0,'2020-07-13'), +(28,2,'LeviHB',7,'2011-05-01'), +(28,2,'SpinDizzy',5,'2011-05-03'), +(28,2,'SpinDizzy',4,'2011-05-06'), +(28,2,'Andy M.J.',2,'2011-10-07'), +(28,2,'Krzyhau',0,'2018-05-19'), +(29,2,'LeviHB',0,'2011-05-01'), +(30,2,'Schlepian',2,'2011-10-30'), +(31,2,'Tyronis',0,'2011-10-06'), + +(27,3,'LeviHB',2,'2011-05-01'), +(27,3,'PerOculos',0,'2020-07-13'), +(28,3,'LeviHB',7,'2011-05-01'), +(28,3,'SpinDizzy',5,'2011-05-03'), +(28,3,'SpinDizzy',4,'2011-05-06'), +(28,3,'Andy M.J.',2,'2011-10-07'), +(28,3,'Krzyhau',0,'2018-05-19'), +(29,3,'LeviHB',0,'2011-05-01'), +(30,3,'Schlepian',2,'2011-10-30'), +(31,3,'Tyronis',0,'2011-10-06'), + +(27,4,'Krzyhau',0,'2018-01-11'), +(28,4,'Krzyhau',0,'2018-01-11'), +(29,4,'Krzyhau',0,'2018-01-11'), +(30,4,'Krzyhau',0,'2018-01-11'), +(31,4,'Krzyhau',0,'2018-01-11'), + +-- Chapter 5 (32,1,'Tyronis',6,'2011-10-21'), (32,1,'Nidboj132',5,'2022-04-24'), (33,1,'Tyronis',7,'2011-10-06'), @@ -72,7 +236,36 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (34,1,'Krzyhau',2,'2020-10-14'), (34,1,'zach',0,'2022-11-02'), (35,1,'Krank',2,'2012-07-28'), --- 6 + +(32,2,'Tyronis',6,'2011-10-21'), +(32,2,'Nidboj132',5,'2022-04-24'), +(32,2,'Fridge',3,'2023-06-18'), +(33,2,'Tyronis',7,'2011-10-06'), +(33,2,'ISimmo',5,'2011-11-02'), +(33,2,'PerOculos',4,'2017-05-30'), +(34,2,'Schlepian',3,'2011-11-01'), +(34,2,'Krzyhau',2,'2020-10-14'), +(34,2,'Krzyhau + Nidboj132',0,'2021-03-14'), +(35,2,'Krank',2,'2012-07-28'), + +(32,3,'Tyronis',6,'2011-10-21'), +(32,3,'Krzyhau',4,'2018-08-07'), +(32,3,'Nidboj132',3,'2022-04-24'), +(33,3,'Tyronis',7,'2011-10-06'), +(33,3,'ISimmo',5,'2011-11-02'), +(33,3,'PerOculos',4,'2017-05-30'), +(34,3,'Schlepian',3,'2011-11-01'), +(34,3,'Krzyhau',2,'2020-07-09'), +(34,3,'Krzyhau + Nidboj132',0,'2021-03-14'), +(35,3,'Krank',2,'2012-07-28'), + +(32,4,'Krzyhau',0,'2021-02-09'), +(33,4,'PerOculos',4,'2017-05-30'), +(33,4,'Krzyhau',0,'2020-12-26'), +(34,4,'Krzyhau',0,'2017-09-27'), +(35,4,'Krank',2,'2012-07-28'), + +-- Chapter 6 (36,1,'Tyronis',6,'2011-10-06'), (36,1,'CalmlyFrenetic',5,'2011-10-09'), (36,1,'sicklebrick',4,'2012-09-13'), @@ -96,7 +289,69 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (41,1,'CalmlyFrenetic',7,'2011-10-09'), (41,1,'Jaso',6,'2011-10-11'), (41,1,'Krank',5,'2012-07-17'), --- 7 + +(36,2,'Tyronis',6,'2011-10-06'), +(36,2,'CalmlyFrenetic',5,'2011-10-09'), +(36,2,'sicklebrick',4,'2012-09-13'), +(36,2,'Nidboj132',2,'2023-03-04'), +(37,2,'LookLikeAKango',7,'2011-10-06'), +(37,2,'Schlepian',6,'2011-11-01'), +(37,2,'Tyronis',5,'2012-01-28'), +(37,2,'Nidboj132',4,'2021-08-22'), +(38,2,'Andy M.J.',2,'2011-10-06'), +(38,2,'Death Pony',0,'2011-11-12'), +(39,2,'Lambda Core',6,'2011-05-13'), +(39,2,'The Last Tofus',5,'2011-05-13'), +(39,2,'LookLikeAKango',4,'2011-10-16'), +(39,2,'Kittaye',3,'2013-03-25'), +(40,2,'LookLikeAKango',7,'2011-10-07'), +(40,2,'Schlepian',6,'2011-11-05'), +(40,2,'Kittaye',4,'2013-04-01'), +(40,2,'Kittaye',3,'2014-09-13'), +(40,2,'szeimartin',2,'2014-09-13'), +(40,2,'Kittaye',0,'2014-09-15'), +(41,2,'CalmlyFrenetic',7,'2011-10-09'), +(41,2,'Jaso',6,'2011-10-11'), +(41,2,'Krank',5,'2012-07-17'), + +(36,3,'Tyronis',6,'2011-10-06'), +(36,3,'CalmlyFrenetic',5,'2011-10-09'), +(36,3,'sicklebrick',4,'2012-09-13'), +(36,3,'Krzyhau',2,'2022-07-20'), +(36,3,'Nidboj132',0,'2023-03-04'), +(37,3,'LookLikeAKango',7,'2011-10-06'), +(37,3,'Schlepian',6,'2011-11-01'), +(37,3,'Tyronis',5,'2012-01-28'), +(37,3,'?',4,'2021-08-22'), +(37,3,'zach',2,'2022-10-17'), +(38,3,'Andy M.J.',2,'2011-10-06'), +(38,3,'Death Pony',0,'2011-11-12'), +(39,3,'Lambda Core',6,'2011-05-13'), +(39,3,'The Last Tofus',5,'2011-05-13'), +(39,3,'LookLikeAKango',4,'2011-10-16'), +(39,3,'Kittaye',3,'2013-03-25'), +(40,3,'LookLikeAKango',7,'2011-10-07'), +(40,3,'Schlepian',6,'2011-11-05'), +(40,3,'Kittaye',4,'2013-04-01'), +(40,3,'Kittaye',3,'2014-09-13'), +(40,3,'szeimartin',2,'2014-09-13'), +(40,3,'Kittaye',0,'2014-09-15'), +(41,3,'CalmlyFrenetic',7,'2011-10-09'), +(41,3,'Jaso',6,'2011-10-11'), +(41,3,'Krank',5,'2012-07-17'), + +(36,4,'Krzyhau',2,'2022-07-20'), +(36,4,'Nidboj132',0,'2023-03-04'), +(37,4,'Tyronis',5,'2012-01-28'), +(37,4,'Krzyhau',0,'2020-12-26'), +(38,4,'Death Pony',0,'2011-11-12'), +(39,4,'Kittaye',3,'2013-03-25'), +(39,4,'Krzyhau',0,'2020-12-26'), +(40,4,'Kittaye',0,'2014-09-15'), +(41,4,'Krank',5,'2012-07-17'), +(41,4,'Krzyhau',0,'2020-12-26'), + +-- Chapter 7 (42,1,'LookLikeAKango',4,'2011-05-17'), (42,1,'ISimmo',2,'2011-11-07'), (43,1,'lmao4ever',5,'2011-10-30'), @@ -116,7 +371,57 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (45,1,'Krank',10,'2013-01-31'), (45,1,'Kittaye',7,'2013-04-04'), (45,1,'PerOculos',4,'2014-09-13'), --- 8 + +(42,2,'LookLikeAKango',4,'2011-05-17'), +(42,2,'Schlepian',2,'2011-11-06'), +(43,2,'lmao4ever',5,'2011-10-30'), +(43,2,'Jaso',2,'2011-11-09'), +(43,2,'feliser',0,'2022-06-26'), +(44,2,'LookLikeAKango',18,'2011-10-07'), +(44,2,'Tyronis',13,'2011-10-30'), +(44,2,'Tyronis',12,'2011-11-10'), +(44,2,'Jetwash',11,'2017-06-12'), +(44,2,'Krzyhau',9,'2022-01-02'), +(45,2,'LookLikeAKango',23,'2011-10-08'), +(45,2,'CalmlyFrenetic',22,'2011-10-09'), +(45,2,'cgreactor',17,'2011-10-09'), +(45,2,'CalmlyFrenetic',16,'2011-10-10'), +(45,2,'LookLikeAKango',15,'2011-10-19'), +(45,2,'Jaso',12,'2012-07-19'), +(45,2,'Krank',10,'2013-01-31'), +(45,2,'Kittaye',7,'2013-04-04'), +(45,2,'PerOculos',4,'2014-09-13'), + +(42,3,'LookLikeAKango',4,'2011-05-17'), +(42,3,'Schlepian',2,'2011-11-06'), +(43,3,'lmao4ever',5,'2011-10-30'), +(43,3,'Jaso',2,'2011-11-09'), +(43,3,'feliser',0,'2022-06-26'), +(44,3,'LookLikeAKango',18,'2011-10-07'), +(44,3,'Tyronis',13,'2011-10-30'), +(44,3,'Tyronis',12,'2011-11-10'), +(44,3,'Jetwash',11,'2017-06-12'), +(44,3,'Krzyhau',9,'2022-01-02'), +(45,3,'LookLikeAKango',23,'2011-10-08'), +(45,3,'CalmlyFrenetic',22,'2011-10-09'), +(45,3,'cgreactor',17,'2011-10-09'), +(45,3,'CalmlyFrenetic',16,'2011-10-10'), +(45,3,'LookLikeAKango',15,'2011-10-19'), +(45,3,'Jaso',12,'2012-07-19'), +(45,3,'Krank',10,'2013-01-31'), +(45,3,'Kittaye',7,'2013-04-04'), +(45,3,'PerOculos',4,'2014-09-13'), +(45,3,'Fridge',3,'2023-08-19'), + +(42,4,'Schlepian',2,'2011-11-06'), +(42,4,'Krzyhau',0,'2020-12-26'), +(43,4,'Krzyhau',0,'2020-12-26'), +(44,4,'Jetwash',11,'2017-06-12'), +(44,4,'Nidboj',0,'2020-12-27'), +(45,4,'PerOculos',4,'2014-09-13'), +(45,4,'Krzyhau',0,'2020-12-27'), + +-- Chapter 8 (46,1,'sparkle1princess',6,'2012-03-24'), (46,1,'Krzyhau',2,'2019-11-21'), (47,1,'holydevel',2,'2011-10-06'), @@ -149,7 +454,79 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (56,1,'LookLikeAKango',5,'2011-10-09'), (56,1,'CalmlyFrenetic',4,'2011-10-09'), (56,1,'Jetwash',2,'2014-09-05'), --- 9 + +(46,2,'Fapmid',6,'2011-05-29'), +(46,2,'Krzyhau',2,'2019-11-21'), +(47,2,'mprs',2,'2011-05-03'), +(47,2,'JesusCatFace',0,'2015-01-16'), +(48,2,'LookLikeAKango',5,'2011-10-08'), +(48,2,'Tyronis',2,'2011-10-08'), +(49,2,'9E161D40',3,'2011-05-06'), +(49,2,'Schlepian',2,'2011-10-08'), +(50,2,'LookLikeAKango',4,'2011-10-08'), +(50,2,'Tyronis',2,'2011-10-11'), +(51,2,'Andy M.J.',3,'2011-10-08'), +(51,2,'LookLikeAKango',2,'2011-10-20'), +(52,2,'SpinDizzy',3,'2011-05-02'), +(53,2,'LookLikeAKango',9,'2011-10-08'), +(53,2,'LookLikeAKango',2,'2011-10-20'), +(53,2,'Krank',0,'2012-08-19'), +(54,2,'LookLikeAKango',7,'2011-06-01'), +(54,2,'Jaso',6,'2011-10-09'), +(54,2,'Schlepian',5,'2011-11-06'), +(54,2,'Spyrunite',4,'2012-08-30'), +(54,2,'Krzyhau + Nidboj',0,'2018-08-01'), +(55,2,'LookLikeAKango',7,'2011-10-08'), +(55,2,'CalmlyFrenetic',3,'2011-10-09'), +(55,2,'Jaso',2,'2011-11-26'), +(56,2,'lihP',6,'2011-05-07'), +(56,2,'LookLikeAKango',5,'2011-10-09'), +(56,2,'CalmlyFrenetic',4,'2011-10-09'), +(56,2,'Jetwash',2,'2014-09-05'), + +(46,3,'Fapmid',6,'2011-05-29'), +(46,3,'Krzyhau',2,'2017-11-02'), +(47,3,'mprs',2,'2011-05-03'), +(47,3,'JesusCatFace',0,'2015-01-16'), +(48,3,'LookLikeAKango',5,'2011-10-08'), +(48,3,'Tyronis',2,'2011-10-08'), +(49,3,'9E161D40',3,'2011-05-06'), +(49,3,'Schlepian',2,'2011-10-08'), +(50,3,'LookLikeAKango',4,'2011-10-08'), +(50,3,'Tyronis',2,'2011-10-11'), +(51,3,'Andy M.J.',3,'2011-10-08'), +(51,3,'LookLikeAKango',2,'2011-10-20'), +(52,3,'SpinDizzy',3,'2011-05-02'), +(53,3,'LookLikeAKango',9,'2011-10-08'), +(53,3,'LookLikeAKango',2,'2011-10-20'), +(53,3,'Krank',0,'2012-08-19'), +(54,3,'LookLikeAKango',7,'2011-06-01'), +(54,3,'Jaso',6,'2011-10-09'), +(54,3,'Schlepian',5,'2011-11-06'), +(54,3,'Spyrunite',4,'2012-08-30'), +(54,3,'Krzyhau + Nidboj',0,'2018-08-01'), +(55,3,'LookLikeAKango',7,'2011-10-08'), +(55,3,'CalmlyFrenetic',3,'2011-10-09'), +(55,3,'Jaso',2,'2011-11-26'), +(56,3,'lihP',6,'2011-05-07'), +(56,3,'LookLikeAKango',5,'2011-10-09'), +(56,3,'CalmlyFrenetic',4,'2011-10-09'), +(56,3,'Jetwash',2,'2014-09-05'), + +(46,4,'Krzyhau',2,'2017-11-02'), +(46,4,'Krzyhau',0,'2020-12-26'), +(47,4,'Krzyhau',0,'2017-09-09'), +(48,4,'Krzyhau',0,'2017-09-09'), +(49,4,'Krzyhau',0,'2017-09-09'), +(50,4,'Krzyhau',0,'2017-09-09'), +(51,4,'Krzyhau',0,'2017-09-09'), +(52,4,'Krzyhau',0,'2017-08-29'), +(53,4,'Krzyhau',0,'2017-08-29'), +(54,4,'Krzyhau',0,'2017-08-29'), +(55,4,'Krzyhau',0,'2017-08-29'), +(56,4,'Krzyhau',0,'2017-08-29'), + +-- Chapter 9 (57,1,'JNS',7,'2011-07-21'), (57,1,'Krank',5,'2012-07-29'), (57,1,'Krzyhau',0,'2017-10-29'), @@ -158,19 +535,68 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (59,1,'sicklebrick',6,'2013-03-20'), (60,1,'CalmlyFrenetic',7,'2011-10-19'), (60,1,'Tyronis',6,'2011-11-01'), +(60,1,'Black_Semka',4,'2024-06-27'), + +(57,2,'JNS',7,'2011-07-21'), +(57,2,'Krank',5,'2012-07-29'), +(57,2,'Krank',0,'2012-08-19'), +(58,2,'Stimich',2,'2011-10-11'), +(58,2,'Krank',0,'2012-08-21'), +(59,2,'Isimmo',7,'2011-11-04'), +(59,2,'Krank',4,'2012-08-22'), +(59,2,'Krzyhau',2,'2017-08-29'), +(60,2,'CalmlyFrenetic',7,'2011-10-19'), +(60,2,'Tyronis',6,'2011-11-01'), +(60,2,'Krzyhau',5,'2020-07-09'), +(60,2,'Krzyhau + CeyHun',3,'2022-06-23'), +(60,2,'Krzyhau',1,'2023-08-22'), + +(57,3,'JNS',7,'2011-07-21'), +(57,3,'Krank',5,'2012-07-29'), +(57,3,'Krank',0,'2012-08-19'), +(58,3,'Stimich',2,'2011-10-11'), +(58,3,'Krank',0,'2012-08-21'), +(59,3,'Isimmo',7,'2011-11-04'), +(59,3,'Krank',4,'2012-08-22'), +(59,3,'Krzyhau',2,'2017-08-29'), +(60,3,'CalmlyFrenetic',7,'2011-10-19'), +(60,3,'Tyronis',6,'2011-11-01'), +(60,3,'Krzyhau',5,'2020-07-09'), +(60,3,'Krzyhau + CeyHun',3,'2022-06-23'), +(60,3,'Krzyhau',1,'2023-08-22'), + +(57,4,'Krzyhau',0,'2017-09-09'), +(58,4,'Krzyhau',0,'2017-09-09'), +(59,4,'Krzyhau',2,'2017-09-09'), +(60,4,'Krzyhau',1,'2017-09-09'), + -- Portal 2 Cooperative --- 1 +-- Chapter 1 (63,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'), (64,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), (64,1,'Chubfish & Exhale',2,'2011-11-01'), (65,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), (65,1,'Nidboj132 & Oryn',3,'2022-02-03'), -(65,1,'Nidboj132 & Oryn',2,'2022-07-11'), +(65,1,'Nidboj132 & Oryn',2,'2023-07-10'), (66,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), (66,1,'Schlepian & Chubfish',2,'2011-10-01'), +(66,1,'Seal & Acuifex',0,'2023-07-22'), (67,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'), (68,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'), --- 2 + +(63,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'), +(64,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), +(64,5,'Chubfish & Exhale',2,'2011-11-01'), +(65,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), +(65,5,'Nidboj132 & Oryn',3,'2022-02-03'), +(65,5,'Nidboj132 & Oryn',2,'2023-07-10'), +(66,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), +(66,5,'Schlepian & Chubfish',2,'2011-10-01'), +(66,5,'Seal & Acuifex',0,'2023-07-22'), +(67,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'), +(68,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'), + +-- Chapter 2 (69,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), (70,1,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01'), (70,1,'Schlepian & Chubfish',4,'2011-10-01'), @@ -195,7 +621,32 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (75,1,'DM_ & follon',0,'2015-04-01'), (76,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), (76,1,'Chubfish & Exhale',0,'2011-12-01'), --- 3 + +(69,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), +(70,5,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01'), +(70,5,'Schlepian & Chubfish',4,'2011-10-01'), +(70,5,'Gocnak & z1mb0bw4y',2,'2012-08-03'), +(71,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), +(71,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'), +(72,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), +(72,5,'Schlepian & LongJohnDickWeed',2,'2011-10-01'), +(73,5,'Stimich & HiTMaRkS',9,'2011-05-09'), +(73,5,'Mathias123961 & Sir Spawn Alot',8,'2011-08-01'), +(73,5,'Schlepian & Lemonsunshine',7,'2011-11-01'), +(73,5,'DM_ & LsDK_',6,'2018-01-01'), +(73,5,'Krzyhau & Klooger',4,'2018-11-01'), +(74,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'), +(74,5,'Stimich & Pitkakorva',7,'2011-10-11'), +(74,5,'Schlepian & Isimmo',3,'2011-10-28'), +(74,5,'Zypeh & szeimartin',2,'2013-11-01'), +(75,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'), +(75,5,'Schlepian & Urination',4,'2011-10-01'), +(75,5,'Schlepian & Lemonsunshine',2,'2012-02-01'), +(75,5,'DM_ & follon',0,'2015-04-01'), +(76,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), +(76,5,'Chubfish & Exhale',0,'2011-12-01'), + +-- Chapter 3 (77,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), (78,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), (78,1,'DM_ & marK',3,'2016-11-01'), @@ -203,13 +654,14 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (79,1,'ganonscrub & ?',5,'2011-04-01'), (79,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), (79,1,'Chubfish & Exhale',2,'2012-08-04'), -(79,1,'BiSaXa & Oryn',0,'2023-07-18') +(79,1,'BiSaXa & Oryn',0,'2023-07-18'), (80,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'), (80,1,'Chubfish & Exhale',4,'2011-12-01'), (81,1,'Mathias123961 & Sir Spawn Alot',7,'2011-08-01'), (81,1,'Schlepian & Lemonsunshine',6,'2011-10-01'), (81,1,'takz & dawn',5,'2011-11-01'), (81,1,'Nidboj132 & Oryn',4,'2021-03-25'), +(81,1,'Seal & Acuifex',2,'2023-12-27'), (82,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), (83,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'), (83,1,'Schlepian & Lemonsunshine',2,'2011-10-01'), @@ -218,7 +670,30 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (84,1,'Schlepian & Chubfish',4,'2011-10-01'), (84,1,'Chubfish & Exhale',2,'2012-01-01'), (84,1,'DM_ & wS',0,'2015-05-01'), --- 4 + +(77,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), +(78,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), +(78,5,'DM_ & marK',3,'2016-11-01'), +(79,5,'ganonscrub & undefined',5,'2011-04-01'), +(79,5,'Bgr & mongfish',4,'2011-04-23'), +(79,5,'Chubfish & Exhale',2,'2012-08-04'), +(79,5,'BiSaXa & Oryn',0,'2023-07-18'), +(80,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'), +(80,5,'Chubfish & Exhale',4,'2011-12-01'), +(81,5,'Mathias123961 & Sir Spawn Alot',7,'2011-08-01'), +(81,5,'Schlepian & Lemonsunshine',6,'2011-10-01'), +(81,5,'takz & dawn',5,'2011-11-01'), +(81,5,'Nidboj132 & Oryn',4,'2024-01-06'), +(82,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), +(83,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'), +(83,5,'Schlepian & Lemonsunshine',2,'2011-10-01'), +(83,5,'Chubfish & Exhale',0,'2011-12-01'), +(84,5,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01'), +(84,5,'Schlepian & Chubfish',4,'2011-10-01'), +(84,5,'Chubfish & Exhale',2,'2012-01-01'), +(84,5,'DM_ & wS',0,'2015-05-01'), + +-- Chapter 4 (85,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), (85,1,'Chubfish & Exhale',0,'2011-10-01'), (86,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), @@ -240,10 +715,34 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (92,1,'ncla & takz',0,'2012-02-01'), (93,1,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01'), (93,1,'Schlepian & Gopherdude',0,'2011-10-01'), --- 5 + +(85,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), +(85,5,'Chubfish & Exhale',0,'2011-10-01'), +(86,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), +(86,5,'Chubfish & Exhale',0,'2011-12-01'), +(87,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'), +(87,5,'Schlepian & Gopherdude',2,'2011-10-01'), +(87,5,'DM_ & follon',0,'2015-04-01'), +(88,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), +(88,5,'Schlepian & Gopherdude',0,'2011-10-01'), +(89,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'), +(90,5,'Mathias123961 & Sir Spawn Alot',4,'2011-09-01'), +(90,5,'Schlepian & Urination',2,'2011-10-01'), +(90,5,'Klooger & Jetwash',0,'2016-02-01'), +(91,5,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01'), +(91,5,'Undead & Zypeh',0,'2013-05-19'), +(92,5,'txx478 & undefined',5,'2011-05-01'), +(92,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'), +(92,5,'Schlepian & Gopherdude',2,'2011-10-01'), +(92,5,'ncla & takz',0,'2012-02-01'), +(93,5,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01'), +(93,5,'Schlepian & Gopherdude',0,'2011-10-01'), + +-- Chapter 5 (94,1,'Chubfish & Exhale',2,'2011-10-01'), (94,1,'Klooger & Imanex',0,'2013-08-01'), (95,1,'Schlepian & Issimoi',2,'2011-10-01'), +(95,1,'Seal & Acuifex',0,'2024-02-13'), (96,1,'ThePortalPatrol & ?',4,'2011-04-01'), (96,1,'sparkle1princess & Zypeh',2,'2014-01-01'), (97,1,'Stimich & HiTMaRkS',7,'2011-05-13'), @@ -256,7 +755,24 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (100,1,'Schlepian & Bananasaurus Rex',0,'2011-10-01'), (101,1,'Chubfish & Exhale',2,'2011-12-01'), (101,1,'DM_ & follon',0,'2015-04-01'), --- 6 + +(94,5,'Chubfish & Exhale',2,'2011-10-01'), +(94,5,'Klooger & Imanex',0,'2013-08-01'), +(95,5,'Schlepian & Issimoi',2,'2011-10-01'), +(96,5,'ThePortalPatrol & undefined',4,'2011-04-01'), +(96,5,'sparkle1princess & Zypeh',2,'2014-01-01'), +(97,5,'Stimich & HiTMaRkS',7,'2011-05-13'), +(97,5,'Schlepian & Lemonsunshine',4,'2011-10-01'), +(97,5,'DM_ & wS',2,'2014-05-01'), +(98,5,'Imanex & 00svo',0,'2011-11-01'), +(99,5,'Schlepian & Gopherdude',3,'2011-10-01'), +(99,5,'Imanex & Klooger',2,'2013-08-01'), +(99,5,'DM_ & wS',0,'2015-05-01'), +(100,5,'Schlepian & Bananasaurus Rex',0,'2011-10-01'), +(101,5,'Chubfish & Exhale',2,'2011-12-01'), +(101,5,'DM_ & follon',0,'2015-04-01'), + +-- Chapter 6 (102,1,'dawn & takz',3,'2011-11-18'), (102,1,'Chubfish & Exhale',2,'2012-01-01'), (102,1,'Imanex & Klooger',0,'2013-08-01'), @@ -280,4 +796,29 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA (110,1,'00svo & z1mb0bw4y',5,'2012-08-08'), (110,1,'00svo & z1mb0bw4y',4,'2012-08-10'), (110,1,'Klooger & z1mb0bw4y',2,'2014-02-01'), -(110,1,'DM_ & follon',0,'2015-04-01'); \ No newline at end of file +(110,1,'DM_ & follon',0,'2015-04-01'), + +(102,5,'dawn & takz',3,'2011-11-18'), +(102,5,'Chubfish & Exhale',2,'2012-01-01'), +(102,5,'Imanex & Klooger',0,'2013-08-01'), +(103,5,'Schlepian & Lemonsunshine',0,'2011-10-01'), +(104,5,'Schlepian & Lemonsunshine',0,'2011-10-01'), +(105,5,'Blaizerazer & undefined',8,'2011-10-01'), +(105,5,'Schlepian & Lemonsunshine',5,'2011-11-01'), +(105,5,'Imanex & Klooger',4,'2013-08-01'), +(105,5,'DM_ & wS',3,'2014-05-01'), +(105,5,'DM_ & follon',2,'2015-04-01'), +(106,5,'Schlepian & Bananasaurus Rex',4,'2011-10-01'), +(106,5,'Gig & takz',3,'2012-06-01'), +(106,5,'Unknown players',0,'2015-04-01'), +(107,5,'Chubfish & Exhale',2,'2011-10-01'), +(107,5,'DM_ & follon',0,'2015-04-01'), +(108,5,'DaFox & P',0,'2011-12-01'), +(109,5,'Schlepian & Tyronis',5,'2011-10-01'), +(109,5,'Chubfish & Exhale',0,'2011-12-01'), +(110,5,'Tyronis & mr.bob806',15,'2011-10-01'), +(110,5,'Schlepian & Chubfish',6,'2011-11-01'), +(110,5,'00svo & z1mb0bw4y',5,'2012-08-08'), +(110,5,'00svo & z1mb0bw4y',4,'2012-08-10'), +(110,5,'Klooger & z1mb0bw4y',2,'2014-02-01'), +(110,5,'DM_ & follon',0,'2015-04-01'); \ No newline at end of file -- cgit v1.2.3