Aces High Bulletin Board

General Forums => Aces High General Discussion => Topic started by: BGBMAW on January 27, 2003, 09:03:40 PM

Title: Is the "who was shot down logs" secret?
Post by: BGBMAW on January 27, 2003, 09:03:40 PM: Does HTC ever release the Logs on who you or any other player has shot down in the last month???

It would be very interesting to see....

especailly these "extremly high score " guys...

Not pointing fingers(2nd account vulchers)..but i would be interested to see who shoots who and such...

These logs are secret HTC property??

Have they ever been available?

Salute..
BiGB

p.s. I only get Kill shooter kills...so if you se me killing my self alot..dont sweat it:D
Title: Is the "who was shot down logs" secret?
Post by: Shane on January 27, 2003, 10:46:18 PM: i believe the logs ahve to be specifically turned on. and considering the vloume of MA traffic over a month, can we say it'll make a mass goon drop look like a teeny twitch?
Title: Is the "who was shot down logs" secret?
Post by: KBall on January 28, 2003, 12:01:47 AM: I would like these logs available as well. It would be quite entertaining and informative.
Title: Is the "who was shot down logs" secret?
Post by: Frogm4n on January 28, 2003, 01:04:55 AM: yea i thought the the logs are something that have to be turned on by the admin?
Title: Is the "who was shot down logs" secret?
Post by: ccvi on January 28, 2003, 01:19:07 AM: It's all in the database. If you want to know for someone whose callsign you know, you can look it up on the score pages (player vs. player, select your and opponents callsign).

Logging doesn't have to be turned on, there just needs to be a web-page that reads this from the scoredatabase.
Title: Is the "who was shot down logs" secret?
Post by: MadBirdCZ on January 28, 2003, 07:05:12 AM: I would like to be able to dump all the console messages (even better - include option to select specific channels) into the plain text file. Would be very easy to write an parser for that "file".

IMHO this text dump save log feature would be a really easy and simple addition.

Edit:
This above mentioned idea would run on your FE so no SQL queries required. Result would be just plain TXT file ready to be parsed (maybe each line of this dump could start with your system time and date (tab or space delimited) for better parsing)

Edit Edit:
ehh... Just noticed that there is already similar thought in the forums.... oh well... :) But it is still a good thing to implement IMHO. just a simple dump... :D
Title: Is the "who was shot down logs" secret?
Post by: Mini D on January 28, 2003, 07:38:28 AM: There's a slight problem with installing this function. It requires a major search. Right now, HTC's database isn't the most efficient function on the face of the earth. If you run a querry every 10 seconds for something as simple as player stats you will cause warping in the arenas.

If you've ever had HiTech call you at 10 at night and ask if you were running querries, you'd know what I mean.

MiniD
Title: Is the "who was shot down logs" secret?
Post by: BNM on January 28, 2003, 09:33:03 AM: That function has always been on the 'Stats' page BGB. Just go to scores/kill stats/pilot vs/pilot. I don't know alot about "netstuff" but I think the website and the game servers are separate.
Title: Is the "who was shot down logs" secret?
Post by: MadBirdCZ on January 28, 2003, 09:53:25 AM: Quote
Originally posted by BNM
That function has always been on the 'Stats' page BGB. Just go to scores/kill stats/pilot vs/pilot. I don't know alot about "netstuff" but I think the website and the game servers are separate.

heh then try to use it to find out who were the guys you have shot down and how many times you shot them down (or you was shot down by them).

You will soon realize that the function that is there on the stat page was NOT designed for getting such stats and using it for getting such stats is next to impossible ;)
Title: Is the "who was shot down logs" secret?
Post by: BNM on January 28, 2003, 09:57:14 AM: Works for me :confused: I mean the way it's designed it is tedious to look up several but it is better than nothing...
Title: Is the "who was shot down logs" secret?
Post by: MadBirdCZ on January 28, 2003, 10:02:13 AM: Yep but there should be a simple way to track all your kills/deaths names during the tour... Even if only the console log (Channel 6 is it?) was dumped into a text file It would take me probably very short time to write application that would parse the file into a very readable statistics... could be interesting...
Title: Is the "who was shot down logs" secret?
Post by: BNM on January 28, 2003, 10:05:16 AM: Ahhh .. I see what you're saying now. It would be nice, sounds like it could be incorporated into this...

http://www.hitechcreations.com/forums/showthread.php?s=&threadid=46919 (http://www.hitechcreations.com/forums/showthread.php?s=&threadid=46919)
Title: Is the "who was shot down logs" secret?
Post by: MadBirdCZ on January 28, 2003, 10:08:24 AM: Quote
Originally posted by BNM
Ahhh .. I see what you're saying now. It would be nice, sounds like it could be incorporated into this...

http://www.hitechcreations.com/forums/showthread.php?s=&threadid=46919 (http://www.hitechcreations.com/forums/showthread.php?s=&threadid=46919)

Exactly! as i inserted in the edit of my original reply, I noticed too late thta this almost very same idea has been brought up before by someone else... Well it is hard to be original when being surrounded by great minds... hehe :D
Title: Is the "who was shot down logs" secret?
Post by: Pongo on January 28, 2003, 10:09:06 AM: I dont see what possible value there is in knowing that its me that the top 10 people mostly shot down.
Title: Is the "who was shot down logs" secret?
Post by: rod367th on January 28, 2003, 11:33:38 PM: First of all I wouldn't worry top guys cheating. Look at rules Hitech said all kills and scores to be chk before money.
Title: Is the "who was shot down logs" secret?
Post by: hitech on January 29, 2003, 09:26:32 AM: 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
Title: Is the "who was shot down logs" secret?
Post by: Shane on January 29, 2003, 09:39:15 AM: Quote
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.
Title: Is the "who was shot down logs" secret?
Post by: eskimo2 on January 29, 2003, 09:45:02 AM: Quote
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
Title: Is the "who was shot down logs" secret?
Post by: JB73 on January 29, 2003, 11:45:55 AM: 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 :D).

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 :D

oh well my 2¢
Title: Is the "who was shot down logs" secret?
Post by: MadBirdCZ on January 29, 2003, 12:14:23 PM: Quote
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 :D 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 ;)
Title: Is the "who was shot down logs" secret?
Post by: BGBMAW on January 29, 2003, 12:37:50 PM: 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
Title: Scripts
Post by: llyr69 on January 29, 2003, 01:15:29 PM: Are lyou sure that was HT? The spelling makes it awfully suspicious............:D
Title: Is the "who was shot down logs" secret?
Post by: muckmaw on January 29, 2003, 01:43:01 PM: Quote
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.:D
Title: this would work if
Post by: sawman on January 30, 2003, 06:59:44 AM: :rolleyes: 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.