Welcome Sponges We may not have the skill for kills, but we make up for it by strategically soaking up the enemy's attention and firepower. And while it's hard being a Sponge (irony), it's so much fun to soak up damage together. Tuesday nights are ours! 8.30pm.

Deprecated: Function utf8_decode() is deprecated in /home/darwinet/damagesponge.com/index.php on line 150
Fri Nov 10th, 2023
By Darwi

" Post 3 "

Hello. Testing Inner Table

hello:

#	Category	n	W:L	Time	CSR	Kills	Deaths	Assists	KPM	Kills?	Deaths?	Score	Accuracy	Damage Done	Damage Taken
1	CTF 3 Captures	40	50.0%	445	888	11.8	11.6	4.2	1.16	0.2	-0.8	1,600	56%	3,519	3,622
2	CTF 5 Captures	108	39.8%	765	917	15.1	14.0	5.5	1.27	0.4	-1.2	2,127	57%	4,430	4,356
3	Extraction	7	28.6%	837	827	14.1	12.6	5.9	1.48	2.3	-1.0	2,236	65%	4,332	4,360
4	King of the Hill	115	32.2%	453	926	14.9	12.9	7.1	1.51	-0.7	-2.3	2,079	55%	4,150	4,073
5	Oddball	89	41.6%	588	920	14.8	14.5	7.2	1.30	-1.1	-2.0	2,347	56%	4,356	4,530
6	Slayer	204	49.0%	64	916	11.0	9.6	4.6	1.21	-0.7	-2.2	1,329	55%	3,239	3,195
7	Strongholds	109	49.5%	645	912	15.7	14.1	5.7	1.37	0.1	-1.4	2,468	57%	4,498	4,601
		96.0	41.5%	542.4	900.9	13.9	12.7	5.7	1.33	0.1	-1.5	2,026.7	57.4%	4,075.0	4,105.3

 

Deprecated: Function utf8_decode() is deprecated in /home/darwinet/damagesponge.com/index.php on line 150
Wed Oct 4th, 2023
By Darwi

" Post 2 "

Placeholder

Deprecated: Function utf8_decode() is deprecated in /home/darwinet/damagesponge.com/index.php on line 150
Sun Oct 1st, 2023
By Darwi

" Post 1 "

Place Holder

!Crash and Burn SQL failure!

Unknown column '_score' in 'field list'

WITH inside AS (SELECT _when, _rnd, _ha, _tm, _op, _vn, _score, _cwd, _tmRung, _opRung, _tmFin, _opFin, _for AS '_for', _agt AS '_agt', (_for) - (_agt) AS '_mgn', IF((_for) - (_agt) > 0, 'W', IF((_for) - (_agt) = 0, 'D', 'L')) AS '_WL', ROW_NUMBER() OVER (PARTITION BY _tm ORDER BY _when DESC) as '_game', DATEDIFF(_when, LAG(_when, 1) OVER (PARTITION BY _tm ORDER BY _when)) AS '_tmDays', DATEDIFF(_when, LAG(_when, 1) OVER (PARTITION BY _op ORDER BY _when)) AS '_opDays', LAG(_vn, 1) OVER (PARTITION BY _tm ORDER BY _when) AS '_pre' FROM haven WHERE YEAR(_when) BETWEEN 2010 AND 2023), middle AS (SELECT *, ROW_NUMBER() OVER (PARTITION BY _tm ORDER BY _when DESC) as '_rank' FROM inside WHERE _tm IN ('Blu','Bom','Bul','Cat','Cro','Dem','Doc','Eag','Gia','Haw','Kan','Pow','Sai','Sun','Swa','Tig') AND _op IN ('Mag','Lio')) SELECT GROUP_CONCAT(CONCAT_WS(' ', YEAR(_when), _RND(_rnd), _tm, _op, CONCAT(_HA, '@', _vn), _WL, ABS(_mgn)) ORDER BY _when DESC LIMIT 50) AS _data, _tm AS 'Team', count(*) AS 'P', SUM(CASE WHEN _for > _agt THEN 1 ELSE 0 END) AS 'W', SUM(CASE WHEN _for < _agt THEN 1 ELSE 0 END) AS 'L', SUM(CASE WHEN _for = _agt THEN 1 ELSE 0 END) AS 'D', FORMAT(SUM(_for), 0) as 'For', FORMAT(SUM(_agt), 0) as 'Agt', SUM(CASE WHEN _for > _agt THEN 4 WHEN _for = _agt THEN 2 ELSE 0 END) AS 'Pts', ROUND(100 * SUM(_for) / SUM(_agt), 2) AS '%' FROM middle WHERE _rank <= 5 GROUP BY _tm ORDER BY 10 * SUM(IF(_for > _agt, 4, IF(_for = _agt, 2, 0))) + (_for / _agt) DESC