Warning: Undefined array key "choice" in /home/darwinet/damagesponge.com/index.php on line 77

"qui sumus morituri te salutant" - For those who are about to die, we salute you!
Home
Articles
Forum

^
 
KEEP
CALM
 
AND
 
PLAN C

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#ACategorynW:L_%.1TimeCSRKills_.1Deaths_.1Assists_.1KPM_.2Kills?_.1Deaths?_.1Score_.0Accuracy_.0%Damage Done_.0Damage Taken_.0
1CTF 3 Captures40504458881212410-116005635193622
2CTF 5 Captures108407659171514610-121275744304356
3Extraction7298378271413612-122366543324360
4King of the Hill11532453926151372-1-220795541504073
5Oddball8942588920151571-1-223475643564530
6Slayer2044964916111051-1-213295532393195
7Strongholds109506459121614610-124685744984601
  96.067241.5291542.43797900.9630613.99712.7895.7401.390.10-1.5-112026.71418757.44014075.0285254105.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