Is the "who was shot down logs" secret?

[hitech]

So you wish this?

select DiedGameID,count(DiedGameID) from Kills where KillerGameID = "BNM" group by DiedGameID;

and also this

select KillerGameID,count(KillerGameID) from Kills where DiedGameID = "BNM" group by KillerGameID;

?

HiTech

[Shane]

Originally posted by hitech
So you wish this?
select DiedGameID,count(DiedGameID) from Kills where KillerGameID = "BNM" group by DiedGameID;
and also this
select KillerGameID,count(KillerGameID) from Kills where DiedGameID = "BNM" group by KillerGameID;
?
HiTech

yeah... if i parsed that right

BMN: list of kills by id and count.
BNM: list of killed by id and count.

the feature is semi-present on the score pages, but it's awkward and 99% of the time we can't remember all the kills or killed by we've done over a tour. it'd be nice if we could see a listing of who we've killed (and how many times) and who we've been killed by (and how many times) in some list format.

no biggie, but....

of course it'd be even nicer if it was further broken down in what planes were used for those kills/kills in and deaths/died in by those lists.

eheh a stats weenie fantasyland of data to wallow in.

[eskimo2]

Originally posted by hitech
So you wish this?

select DiedGameID,count(DiedGameID) from Kills where KillerGameID = "BNM" group by DiedGameID;

and also this

select KillerGameID,count(KillerGameID) from Kills where DiedGameID = "BNM" group by KillerGameID;

?

HiTech

Hitech,
You lost me on the first step, "select KillerGameID".
I'm assuming that you first go to the scores page, and then what?
Player Vs. Player?

Do you actually type in, "select DiedGameID,count(DiedGameID)"?
Where do you type it in?

This sounds like a really cool feature that I would like to play with, but I don't have a clue what you are talking about.

Thanks,

eskimo

[JB73]

eskimo... hes talking about some type of scrpited database query i believe.. not positive but since thats what the thread is about (had to through that in ).

but hes talking about afeature not available. to be able to look up who you shot down for the whole tour.

like if i put JB73 into the starting "gameID" field i would get a list of all the CIPD's that i shot down + who shot me down. my guess is that you could then sort it by name or something to see who really spanked u r arse more than once

oh well my 2¢

[MadBirdCZ]

Originally posted by hitech
So you wish this?

select DiedGameID,count(DiedGameID) from Kills where KillerGameID = "BNM" group by DiedGameID;

and also this

select KillerGameID,count(KillerGameID) from Kills where DiedGameID = "BNM" group by KillerGameID;

?

HiTech

Actually... Yas and No But I think that BGBMAW was asking about above mentioned query...

I was thinking about something a bit different that would not add any excessive load to your database server/s

[BGBMAW]

lolol..HT...i have no idea what your saying..but thats ok..

I just wanted to know if there was an "easy" way to see who you killed..(there game id..like BGBMAW killed BiGMax 2 times) in the month of January


Rod i wasnt really caring about cheating..just wanted to see logs..

But it would defntly show this also...

BGBMAW killed 2weeker 460 times...in the month of Janaury

Salute to all

BiGB
xoxo

[llyr69]

Are lyou sure that was HT?  The spelling makes it awfully suspicious............

[muckmaw]

Originally posted by Shane
it's awkward and 99% of the time we can't remember all the kills or killed by we've done over a tour

Let me help you out on this one Shane. I've killed you 4 times this tour. You've killed me....mmmm...0!

Granted 3 times, you were in a GV, and the 4th in an A-20...

But I have to get my kills on you anyway I can.

[sawman]

to be able to see who youve killed or been killed by should be as ez as maybe hitting  .last kills or .last killers and maybe showing you the last 10 people,any more then that,who really wants to know LOL.