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:

#	#P#K#D#A	Category	n	W:L_%.1	Time	CSR	Kills_.1	Deaths_.1	Assists_.1	KPM_.2	Kills?_.1	Deaths?_.1	Score_.0	Accuracy_.0%	Damage Done_.0	Damage Taken_.0
1	CTF 3 Captures	40	50	445	888	12	12	4	1	0	-1	1600	56	3519	3622
2	CTF 5 Captures	108	40	765	917	15	14	6	1	0	-1	2127	57	4430	4356
3	Extraction	7	29	837	827	14	13	6	1	2	-1	2236	65	4332	4360
4	King of the Hill	115	32	453	926	15	13	7	2	-1	-2	2079	55	4150	4073
5	Oddball	89	42	588	920	15	15	7	1	-1	-2	2347	56	4356	4530
6	Slayer	204	49	64	916	11	10	5	1	-1	-2	1329	55	3239	3195
7	Strongholds	109	50	645	912	16	14	6	1	0	-1	2468	57	4498	4601
		96.0672	41.5291	542.43797	900.96306	13.997	12.789	5.740	1.39	0.10	-1.5-11	2026.714187	57.4401	4075.028525	4105.328737

 

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