...so far.
Hits Date/Time Name Number Clan
15 2010-09-16 00:13:11 BARTMAN IS THE MAN (#977) (SOL)
10 2010-08-29 04:29:59 The best in SOL mob (#296) (SOL)
10 2010-08-31 05:32:28 LAF Suck On THIS DICT (#667) (SOL)
10 2010-08-31 08:11:44 german girls torment me in bed (#121) (LAF)
9 2010-08-25 21:14:52 Auntie ROS (#386) (SOL)
9 2010-08-26 21:03:15 Auntie ROS (#386) (SOL)
9 2010-08-26 21:04:23 tHe SlEePiNg GiAnT (#276) (SOL)
9 2010-08-27 19:25:47 The best in SOL mob (#296) (SOL)
9 2010-08-29 05:00:49 Auntie ROS (#386) (SOL)
9 2010-08-29 05:02:26 Auntie ROS (#386) (SOL)
9 2010-08-30 12:32:08 Auntie ROS (#386) (SOL)
9 2010-08-31 05:46:36 Auntie ROS (#386) (SOL)
9 2010-08-31 08:12:36 german girls torment me in bed (#121) (LAF)
9 2010-09-07 05:56:57 swampy is having mobs baby (#750) (SOL)
9 2010-09-10 05:17:30 Deathwish (#833) (SOL)
9 2010-09-15 00:19:46 BARTMAN IS THE MAN (#977) (SOL)
8 2010-08-25 21:28:03 Auntie ROS (#386) (SOL)
8 2010-08-26 18:12:28 Little Butt Nugget (#236) (SOL)
8 2010-08-26 21:12:08 Auntie ROS (#386) (SOL)
8 2010-09-02 19:06:23 Torment is daisings you (#18) (LAF)
8 2010-09-05 19:49:55 tHe SlEePiNg GiAnT (#276) (SOL)
8 2010-09-07 19:53:48 TANgotNOballs (#773) (TheFist)
8 2010-09-08 03:30:10 Deathwish (#833) (SOL)
8 2010-09-08 05:29:43 Dark Revenge (#782) (SOL)
8 2010-09-10 02:29:21 Your mom was dtf last night (#13) (SancT50)
8 2010-09-10 03:09:33 Your mom was dtf last night (#13) (SancT50)
8 2010-09-11 06:04:40 Your mom was dtf last night (#13) (SancT50)
8 2010-09-12 02:08:52 Earth Sucks (#88) (SancT50)
8 2010-09-14 01:58:36 DAI DAI DAI SOL DAI DAI DAI (#946) (LAF)
8 2010-09-14 19:18:30 Dexter (#966) (SOL)

BARTMAN IS THE MAN (#977) (SOL) seems to be pretty fast getting 15 hits in one second at one point and a few other places in the top 10.

15 in one second... didn't think it was possible.

o yea.. that's hits per specific second. some people prefer to measure by how long it takes them to get rid of all 120(or whatever) turns, tho that's a bit harder to write an SQL statement for, heh.

TANgotNOballs (#773) (TheFist)

WTF??

rofl. hadn't noticed.

is tan girl?

iZarcon, you need to take into account that your site is a remote site. Therefore, you may not have received all the attacks as fast as the people made them, due to things like latency, network congestion, etc. So your rankings may be way off.

For example, here's the raw output from qzGT's db. You may not be able to interpret the time without a unix->time conversion, but, being that qzGT is on the same server as EE, it's pretty much the most sure method of measuring rankings of how fast ppl have hit, without going into the game db itself (which I tend to stay away from). We don't really have a PHP page set up that measures this, mostly because EVO is a netting alliance, so most of our tools are geared towards netting. And I've personally been busy with rl lately.


attacks attacker attacknum attacktag time
16 BARTMAN IS THE MAN 977 SOL 1284595991
14 Auntie ROS 386 SOL 1282770642
12 Auntie ROS 386 SOL 1282770641
12 tHe SlEePiNg GiAnT 276 SOL 1282856663
12 Abendstern 539 SoF 1283373172
12 Little Dwimpy 152 SOL 1283818136
11 Bsnakeback4laffs 896 iMagNum 1284520464
10 Auntie ROS 386 SOL 1282856595
10 Tormormormormon 727 LaF 1284320801
10 Tormormormormon 727 LaF 1284320802
10 True SOLdier NLS 249 SOL 1283732390
10 tHe SlEePiNg GiAnT 276 SOL 1283818135
9 Auntie ROS 386 SOL 1282770892
9 Little Dwimpy 152 SOL 1282823583
9 Little Butt Nugget 236 SOL 1282846348
9 Live Laugh n Love Thru Your SoL 251 SOL 1282856616
9 Live Laugh n Love Thru Your SoL 251 SOL 1282856664
9 Auntie ROS 386 SOL 1283058049
9 Auntie ROS 386 SOL 1283058146
9 BARTMAN IS THE MAN 977 SOL 1284509986
9 BARTMAN IS THE MAN 977 SOL 1284509987
9 Bsnakeback4laffs 896 iMagNum 1284520462
9 Your mom was dtf last night 13 SancT50 1284185080
9 tHe SlEePiNg GiAnT 276 SOL 1283716195
9 1K FS LULZ 684 SoF 1284459315
9 A 879 TheFist 1284229445
9 Auntie ROS 386 SOL 1283171528
9 Suppressor 199 Paradigm 1283206571
9 Suppressor 199 Paradigm 1283206630
9 tHe SlEePiNg GiAnT 276 SOL 1283213619


P.S. You can see that Auntie ROS (#386) [SOL] put out ~26 hits in a 2 second period.

hehe :-P poor SOLers

make stat pages like this for every server via ingame links

that'd be cool

first of all, NukEvil, you could have easilly used the FROM_UNIXTIME() MySQL function to convert that to a readable time

second, i'm not sure what stoneage version of the news API that you may be referring to, but the news API that I use actually sends the ACTUAL TIME TO THE SECOND THAT IT HAPPENED IN EE. it doesn't matter if my website was on mars, i would still get the same time data that evo's site gets.

btw.. LKS doesn't have a PHP page that monitors this either. i just simply wrote a quick sql query.

i would be interested to know why evo's site has different data tho. i haven't logged any "missing" news b/c EE also sends it's unique newsID with each news item and my script checks to make sure it's received them all.

cross-referencing http://www.eesites.com 's data to make sure my data is correct, i also see that #977 did 15 attacks in 1 second... not 16. and that #386 did 9 hits where my query suggested they did.

please don't try to explain to me how the news feed works when it's obvious you aren't exactly sure yourself.

eesites.com ? never heard of that... but it won't load for me

whats there?

But latency will affect the values on the way to the ee server anyways. I'm not sure this table gives any information of interest.

hehe. sorry. meant http://www.eestats.com =/ not going to edit post b/c i don't wanna.

and, i feel it does give info of interest. a lot of people like to brag about how fast they can use all their turns in a warchat. latency is an issue, but it affects us all at one point or another.

damn iZ, that was kind of rude

meh, maybe i felt the same?

Yah, looking back - I gues Nukee was not being terribly sweet to you either - especially since you did all the work.

Are all of you code-type guys asshats to each other all the time?

not normally. just don't like being made to look a fool.

anyway, i've checked ingame news for #977 as well. ingame news doesn't show the second of the hit, but it does show that i have the same news items on LKS that the game does. seeing as game API sends the unix time stamp with each attack for me(so i don't have to worry about my site's lag etc) i can correctly say that there were only 15 hits for that time.

i do agree (like i said) with Sifos that latency is an issue, and i presume a more precice way of measuring the "fastest" hitter could be devised, but this was just for laughs when i thought my 6 in one second was pretty good.

err Zarcon is right, the *actual timestamps* of the news are sent in the API.....

latency is pretty key it's true; with my ping times I could probably get in quite a few hits in one second...

but even still, latency isn't *quite* as big an issue; if you have 100ms latency, that doesn't necessarily limit you to 10hits / second...

because you can send say 25 hit requests in the first 100ms, and as long as they all hit the server with different HTTP connections, they should all be processed in parallel; of course due to various timing & database consistency reasons you can only have one thread running for a given country at the same time, so the 2nd would have to wait on the 1st etc, but that would be merely for the actual code time, which is typically < 50ms even for attacking (which is kindof complicated you have to admit)... so it would really depend on server load in that case.

Also, threads will only wait for 1 second before failing with the "Too many requests..." error message, so sending 100 attack requests in one second is unlikely to be useful, as unless the processing time for an attack was < 10ms (it is not... many things like exploring and main page and cashing and building are, but attacking is complicated...) then most would fail, and you'd probably load the server kindof heavily and slow down some of your other attacks too....

Well, you two need to kiss and make up. EE needs a lot more people like you guys pushing the capability of game tools. :p

I am not accusing anybody of anything here, I honestly am completely ignorant to this kind of thing. What is the fastest method of running attacks by hand? I have noticed that I cannot run attacks on EE as fast as I was able to on Earth2025, but I am also using different machines. Is it realisitic to hand run 15 attacks in one second?!?! 5-6 per second is as fast as I was ever able to do it, and 3 per second is that best I can do on my home desktop with Win-V, IE 8 (yes, I know it sucks). Is there anything in the EE rules that would prevent someone from using a bot to run attacks on a single hand run country?

-

I did not see qz's post before I sent this - so I take it that using an external application to run attacks is ok for ones own country?

Bots I are against the rules ;)

But if you use the Submit-To-Tab extension in Firefox (not in the newest ones, but in 2.X it still works) you can click many attacks quickly to new tabs, which will open parallel connections as I described above.


Also, the general latency and whatnot of the server will be back down in about a week or so.......

maybe two weeks...

Holy crap, what got your panties in a wad? All I said was that latency and congestion may have skewed your data a bit. And I'm just as interested in finding out why the data is so different between two different sites, and I just chalked it up to our site being in the same box as EE.

Chill out.

np guys ;) I did evo's news feed stuff myself, not nuk, so he probably just forgot I added timestamp fancies :)

I just had a look at the bot code, and I do see where it grabs the timestamp from the API feed, but assuming LKS does the same thing, why the discrepancy? Was it the <1 hour difference between the time the queries were run?

EDIT: Or did I run a different query altogether?

list($this->serverid, $this->resetid, $this->newsid, $this->time, $this->type, $this->win, $this->attacker_num, $this->attacker_name, $this->defender_name, $this->result1, $this->result2, $this->a_tag, $this->d_tag, $this->killhit) = explode(',',$line);

must have done a different query? dunno

hmmm i should be able to break into that list when my net gets fixed lol

hemorrhoids

The hell out of boring ass warchats?

Sorry if I missed this, but Zarcon, did you calculate hits per real second, as in any sequence of 1000 miliseconds, or are they hits per "calendar second" so to speak?

For example, someone made 16 hits at 00:13:11.

But maybe others also made as many or more hits, say from 00:15:00.05 to 00:15:01.049

indeed

Sorry, we don't get to play with milliseconds. Just a normal unix time stamp. Even if we did, it'd be trickier to query.

Nuk, i just selected a count of all attacks grouped by attacker and time. That list() qz posted is the same method i use for parsing the comma delimited lists.

I'm quite interested why two data sets which should be identical are in fact different.

I filtered my results by countries that were still alive via an inner join. I'm assuming you did the same?

nah. i didn't want to include only countries that were still alive b/c i wanted to get a fastest for this round. i just plainly queried the news data and only joined with the ranks data to get names / clans to go with the country numbers.

did you use MySQL to count the hits? or some kind of PHP loop/array? i just used mysql's count() function and grouped by the unix time stamp and country number(as i said earlier) as long as it was an attacker from this round.

table isn't really indexed for the search i did, so it was a pretty slow query. likely why i won't be making a php page to display it on-demand.

i did check ingame news, and the country that i said did 15 hits in one second(calendar second as beltz pointed out) did in fact only make those 15 hits during that one calendar second.

Yep, used mysql to count the hits, ordered it by the number of attacks descending, grouped it by time, and limited it to countries that were still alive.

I counted the number of hits 977 did in that one second, and qzGT says he did do 15 hits. Next question is why it counted 16 hits when it did a count query in the db. Obviously, I can't do the same query again, because 977 is now dead (along with a few other countries), and adding a limit to the latest time of attacks would be pointless.

Turns out, I was running a different query.

Forgot to group it by attacker. Whoopsy.


attacks attacker attacknum attacktag time
15 BARTMAN IS THE MAN 977 SOL 2010-09-15 18:13:11
10 The best in SOL mob 296 SOL 2010-08-28 22:29:59
10 LaF Suck On THIS DICT 667 SOL 2010-08-30 23:32:28
10 german girls torment me in bed 121 LaF 2010-08-31 02:11:44
9 Auntie ROS 386 SOL 2010-08-30 23:46:36
9 german girls torment me in bed 121 LaF 2010-08-31 02:12:36
9 Auntie ROS 386 SOL 2010-08-30 06:32:08
9 Auntie ROS 386 SOL 2010-08-28 23:00:49
9 Auntie ROS 386 SOL 2010-08-28 23:02:26
9 Auntie ROS 386 SOL 2010-08-26 15:03:15
9 tHe SlEePiNg GiAnT 276 SOL 2010-08-26 15:04:23
9 The best in SOL mob 296 SOL 2010-08-27 13:25:47
9 Auntie ROS 386 SOL 2010-08-25 15:14:52
9 BARTMAN IS THE MAN 977 SOL 2010-09-14 18:19:46
9 swampy is having mobs baby 750 SOL 2010-09-06 23:56:57
9 Deathwish 833 SOL 2010-09-09 23:17:30
8 Your mom was dtf last night 13 SancT50 2010-09-09 20:29:21
8 Your mom was dtf last night 13 SancT50 2010-09-09 21:09:33
8 TANgotNOballs 773 TheFist 2010-09-07 13:53:48
8 Deathwish 833 SOL 2010-09-07 21:30:10
8 Your mom was dtf last night 13 SancT50 2010-09-11 00:04:40
8 Earth Sucks 88 SancT50 2010-09-11 20:08:52
8 Auntie ROS 386 SOL 2010-08-25 15:28:03
8 Little Butt Nugget 236 SOL 2010-08-26 12:12:28
8 Auntie ROS 386 SOL 2010-08-26 15:12:08
8 Torment is daisings you 18 LaF 2010-09-02 13:06:23
8 tHe SlEePiNg GiAnT 276 SOL 2010-09-05 13:49:55
8 Dexter 966 SOL 2010-09-14 13:18:30
8 BARTMAN IS THE MAN 977 SOL 2010-09-14 18:19:47


That from_unixtime function is kinda handy...

it's great, i love it. makes it so you can instantly tap into mysql's powerful date/time functions while saving storage space using a unix timestamp

I wonder what EVO can also do with their alliance hosting service directly connected to the EE database.

qzGT is not connected to the EE db. It only resides in the same box. We have our own db, which is much larger.

"qzGT is on the same server as EE, it's pretty much the most sure method of measuring rankings of how fast ppl have hit, without going into the game db itself"

As you already pointed out twice now, the two databases are separate.

Ya, it's all separate.... anything that is available to one hosting site is offered to all hosting sites.

The only gain Evo's site gets is that its bots can connect via localhost, rather than remotely. That also help EE save on bandwidth load... so that's positive for the game in general :p

OMG THAT MEAN EVO CHEATS!

It also means that if the game server is up, evo2025 is up... and if the game server is down, evo2025 is down =/ sometimes it might be nice to have the hosting site up if the game is down... but our uptime is generally pretty good

/me makes blue Pfizer M+Ms available for earthers to sort out the latency ;)

bleh. Fastest I can get is 5-6 hits per second.

Shock me.. SOL is destroying.

sol.ghqnet.com

Join a REAL alliance.

i was in SoL last set on a bet

and you all got utterly destroyed. there is no denying that, you FSed 2 clans, and they murdered you

this set, you are fighting fairly impressively, but it still doesn't erase last set.

ur all high and might when you are on top this set, but don't forget your past or it will destroy you

usually i keep it to like 6 attacks each time I spam attack in case the person comes online to wall.. lol

i made 9 hits per second, wow

IE spam click ftw

24 - fast as fast can be i keel u (#1073) (SOL) - 2010-09-20 00:23:44

15 - BARTMAN IS THE MAN (#977) (SOL) - 2010-09-16 00:13:11

12 - fast as fast can be i keel u (#1073) (SOL) - 2010-09-20 00:23:45

10 - The best in SOL mob (#296) (SOL) - 2010-08-29 04:29:59

10 - LaF Suck On THIS DICT (#667) (SOL) - 2010-08-31 05:32:28

10 - german girls torment me in bed (#121) (LaF) - 2010-08-31 08:11:44

9 - Auntie ROS (#386) (SOL) - 2010-08-25 21:14:52

9 - Auntie ROS (#386) (SOL) - 2010-08-26 21:03:15

9 - tHe SlEePiNg GiAnT (#276) (SOL) - 2010-08-26 21:04:23

9 - The best in SOL mob (#296) (SOL) - 2010-08-27 19:25:47

9 - Auntie ROS (#386) (SOL) - 2010-08-29 05:00:49

9 - Auntie ROS (#386) (SOL) - 2010-08-29 05:02:26

9 - Auntie ROS (#386) (SOL) - 2010-08-30 12:32:08

9 - Auntie ROS (#386) (SOL) - 2010-08-31 05:46:36

9 - german girls torment me in bed (#121) (LaF) - 2010-08-31 08:12:36

9 - swampy is having mobs baby (#750) (SOL) - 2010-09-07 05:56:57

9 - Deathwish (#833) (SOL) - 2010-09-10 05:17:30

9 - BARTMAN IS THE MAN (#977) (SOL) - 2010-09-15 00:19:46

9 - blomcrat (#910) (LaF) - 2010-09-18 13:25:08

9 - scraggly (#768) () - 2010-09-18 21:12:25

8 - Auntie ROS (#386) (SOL) - 2010-08-25 21:28:03

8 - Little Butt Nugget (#236) (SOL) - 2010-08-26 18:12:28

8 - Auntie ROS (#386) (SOL) - 2010-08-26 21:12:08

8 - Torment is daisings you (#18) (LaF) - 2010-09-02 19:06:23

8 - tHe SlEePiNg GiAnT (#276) (SOL) - 2010-09-05 19:49:55

8 - TANgotNOballs (#773) (TheFist) - 2010-09-07 19:53:48

8 - Deathwish (#833) (SOL) - 2010-09-08 03:30:10

8 - Dark Revenge (#782) (SOL) - 2010-09-08 05:29:43

8 - Your mom was dtf last night (#13) (SancT50) - 2010-09-10 02:29:21

8 - Your mom was dtf last night (#13) (SancT50) - 2010-09-10 03:09:33

This page loaded in 0.16647 seconds. still a bit slow =/