Largest hit ever?

34 views
Skip to first unread message

Hunter

unread,
Jul 30, 2009, 6:35:53 AM7/30/09
to mysqlgame
From Shard 4
run by Hunter: 2009-07-30
UPDATE rows SET attackers=attackers-27,097,481+ 2,026,715, money=money
+ 548,741,112, fuel=fuel+41,665,265-5,390,625 WHERE row_id=4070;
UPDATE rows SET attackers=attackers-30,938,889,
defenders=defenders-2,500,077, money=money-548,741,112,
fuel=fuel-41,665,265 WHERE row_id=4071;

Lost 27,097,481 attackers and recruited 2,026,715, net deaths:
25,070,766
Used 5,390,625 fuel and took 41,665,265, net fuel: 36,274,640
Lost attackers worth 501,415,320 and took 548,741,112 money, net
profit: 47,325,792
Killed 30,938,889 attackers and 2,500,077 defenders, net damage:
1,192,519,662

timlash

unread,
Aug 6, 2009, 1:50:50 AM8/6/09
to mysqlgame
Not quite as large a gross haul, but better net results.

From Shard 2:
UPDATE rows SET attackers=attackers-10,776,960+2,286,646,
money=money+335,716,558, fuel=fuel+35,414,523-2,322,582 WHERE
row_id=457;
UPDATE rows SET attackers=attackers-1,130,918,
defenders=defenders-2,900,937, money=money-335,716,558,
fuel=fuel-35,414,523 WHERE row_id=456;

Lost 10,776,960 attackers and recruited 2,286,646, net deaths:
8,490,314
Used 2,322,582 fuel and took 35,414,523, net fuel: 33,091,941
Lost attackers worth 169,806,280 and took 335,716,558 money, net
profit: 165,910,278

Léo

unread,
Aug 6, 2009, 10:11:27 AM8/6/09
to mysqlgame
run by timlash: (in shard 2)
UPDATE rows SET attackers=attackers-1453431+241828, money=money
+4969059, fuel=fuel+5477270-241859 WHERE row_id=457; (timlash's)
UPDATE rows SET attackers=attackers-420393,
defenders=defenders-250000, money=money-4969059, fuel=fuel-5477270
WHERE row_id=452; (mine)

timlash, you lost 1453431-241828=1,211,603 attackers. Lost attackers
woth = 24,232,060. You took 4,969,059 from me (plus attackers/
defenders).

You've lost 19,263,001 money attacking me. Was it typo? Misreading?
Please, don't do that again.

timlash

unread,
Aug 6, 2009, 8:11:51 PM8/6/09
to mysqlgame
I needed the fuel to transfer 300 million cash money even if that
required that I take some collateral damage. Boo-ya! Think of it as
an exchange of 5.4 million fuel for 19.2 million cash. Besides, I
still had over 10 million attackers with no other profitable targets.
Nothing personal dude.

Léo

unread,
Aug 7, 2009, 9:40:34 PM8/7/09
to mysqlgame
Ok. But don't you have any other row to get fuel from?

Next time, I can sell fuel to you. Cheaper fuel. Nobody loses anything

brownieapple

unread,
Aug 8, 2009, 9:51:08 AM8/8/09
to mysqlgame
but not nearly quite as fun.

funkenstein

unread,
Aug 9, 2009, 9:41:21 AM8/9/09
to mysqlgame
Wow hunter!!! Epic :)

With the help of TGSYSADM I had a similar profit 6 months ago but
nowhere near as large a battlefield:

UPDATE rows SET attackers=attackers-3543270+448852, money=money
+111551238, fuel=fuel+137681386-6094411 WHERE row_id=1770;
UPDATE rows SET attackers=attackers-553704,
defenders=defenders-1161190, money=money-111551238,
fuel=fuel-137681386 WHERE row_id=1784;

Léo

unread,
Aug 12, 2009, 10:03:39 AM8/12/09
to mysqlgame
Fun enough to me.
Reply all
Reply to author
Forward
0 new messages