Generate stats from summary files, using PHP

icefreez · 02-15-2005

UPDATE:

Images of what this script creates when its done:
http://icefreez.com/files/pictures/G...iechan.php.gif
http://icefreez.com/files/pictures/G...vendor.php.gif
http://icefreez.com/files/pictures/G...piewep.php.gif

Release 2:
Got a new update

I need some feedback though

Post what you think of the script please

Download Summary Stats Version 2

NEW:

Added Channels pie chart

Added WEP vs NO WEP pie chart

Added ability to set a GPS grid to get your results from.

More info posted here

Release 1:
Currently it does just creates a customizable pie chart of the venders for all the AP's you output into a Net Stumbler Summary file. (I will add more graphs and information over time)

Download Package 1 of Summary file to Vendor Pie Chart Script

Don't forget you need a server capable of PHP and a mySQL database set up for this script to work.

----------------------------Original post-------------------------
I am working on a project to generate interesting information about NS Summary files.

I want to be able to see things like How many AP's have WEP VS no WEP, how many AP's are on what channels, What is the percentage of my AP's are Cisco routers.

Some of this stuff NS can do, but it lists it out for you not numbers it and percents it.

I will post the files here when I have completed them, but the reason I posted is to ask if anyone else has some ideas on what kind of stats might be interesting to generate.

Script currently requires (PHP Server, 1 mySQL database)

streaker69 · 02-15-2005

Quote:

Originally Posted by icefreez

I am working on a project to generate interesting information about NS Summary files.

I want to be able to see things like How many AP's have WEP VS no WEP, how many AP's are on what channels, What is the percentage of my AP's are Cisco routers.

Some of this stuff NS can do, but it lists it out for you not numbers it and percents it.

I will post the files here when I have completed them, but the reason I posted is to ask if anyone else has some ideas on what kind of stats might be interesting to generate.

Script currently requires (PHP Server, 1 mySQL database)

You mean stats like this?

Database Size 3.29mb
Total Entries: 8125
Data Files 116
Default SSID's 4456
Unique SSID's 2887
Single Hits 3336
Multiple Hits 4789
Infrastructure 7716 94.97%
Ad-Hoc: 409 5.03%
Open Points: 5896 72.57%
Closed Points: 2229 27.43%
802.11b: 5658 69.64%
802.11g: 2467 30.36%
Channel 01: 606 7.46%
Channel 02: 80 0.98%
Channel 03: 138 1.70%
Channel 04: 61 0.75%
Channel 05: 70 0.86%
Channel 06: 4275 52.62%
Channel 07: 86 1.06%
Channel 08: 72 0.89%
Channel 09: 99 1.22%
Channel 10: 372 4.58%
Channel 11: 1668 20.53%

icefreez · 02-15-2005

Yes

Hopefully there is not already a script out that does that :P If there is I will probably still develope my script taylored to my wants though

Right now I play on having the info displayed like this:

VENDORS:
Linksys: 45 (40%)
NetGear 30 (34%)
Cisco 3 (2%)

(MAYBE PUT PIE CHART HERE, maybe

)

Channel 1: 4%
Channel 2: 20%
Channel 3: 6%
Channel 4: 7%
Channel 5: 3%
Channel 6: 50%

streaker69 · 02-15-2005

Those stats are generated from my own script that I wrote for my own website here I keep all my own personal wardriving info.

It really isn't hard to do what you want to do. Just need to know how to enter data into a database and then tabulate it.

icefreez · 02-15-2005

Ya it hasn't been to hard to do. The hardest thing I had to do was parse the oui.txt file to strip out the vender names and mac address beginnings.

BTW whats the address to your script? I didn't see a link to it off your site and im curious to see what it looks like.

streaker69 · 02-15-2005

Quote:

Originally Posted by icefreez

Ya it hasn't been to hard to do. The hardest thing I had to do was parse the oui.txt file to strip out the vender names and mac address beginnings.

BTW whats the address to your script? I didn't see a link to it off your site and im curious to see what it looks like.

Ya shoulda asked, I already have it parsed out to an XLS and in an Access Database.

icefreez · 02-16-2005

Ok I'm having a bit of a problem parsing the mac address's out of the summary file. It works fine untill i hit an entry with no address like this.

N 43.9791333 W 96.8158483 ( ) BSS ( 00:02:2d:a5:94:6c ) 03:13:15 (GMT) [ 25 74 49 ] # ( ) 0011 00000040 100 110 6

I am currrently doing this to the file

$fcontents = file ('./sum2.txt'); // File name of stumble summary

for($i=1; $i<sizeof($fcontents); $i++) // Cycles though each line of the code
{
$line = trim($fcontents[$i]);
$line = explode("\t", $line); // Strips up line by Tabs

any tips on how to overcome this?

streaker69 · 02-16-2005

Do you mean no SSID?

In my script which was done in Vbscript, if the SSID is blank then I just have it set the SSID to "NO BROADCAST" which then gets entered in to my database that way.

icefreez · 02-16-2005

LOL ya umm... sorry :P it was an ID 10 T error :P

I axidently corrupted the tab structure in my test file. So big supprise that tab parsing wasn't working right :P

Everything is working again now.
Close to getting beta 1 of the script up

icefreez · 02-17-2005

Well I got my pie chart of my brand names working, but the php pie chart function I am using tends to glitch after a certain number of divisions

http://icefreez.com/temp/statscript/stats.php

I will keep working on it. If anyone is intested in the source I will post it, but if not I will wait till I perfect it a bit more.

streaker69 · 02-17-2005

Quote:

Originally Posted by icefreez

Well I got my pie chart of my brand names working, but the php pie chart function I am using tends to glitch after a certain number of divisions

http://icefreez.com/temp/statscript/stats.php

I will keep working on it. If anyone is intested in the source I will post it, but if not I will wait till I perfect it a bit more.

that's exactly why I never bothered with pie charts on my system. Once you have large amounts of data, the chart is meaningless. Probably the only data that would be worth charting would be channel distribution, Open/closed Ap's and Ad-Hoc/Infrastructure modes. Charting SSID's and vendors you're goin to have a pie chart with hundreds and thousands of slices.

icefreez · 02-17-2005

Ahh I just got an idea. I could set a minimum percentage, so only the top 4 or 5 are listed and the rest are dropped into a Other category

EDIT: Now I fixed it to have a min number for a company to be displayed

Looks nice now

http://icefreez.com/temp/statscript/stats.php

streaker69 · 02-17-2005

Quote:

Originally Posted by icefreez

Ahh I just got an idea. I could set a minimum percentage, so only the top 4 or 5 are listed and the rest are dropped into a Other category

There ya go, now you're cooking with gas.

icefreez · 02-17-2005

Ok finally here is my first release of this script. I am pretty happy with how it performs.

Currently it does just creates a customizable pie chart of the venders for all the AP's you output into a Net Stumbler Summary file. (I will add more graphs and information over time)

Download Package 1 of Summary file to Vendor Pie Chart Script

Don't forget you need a server capable of PHP and a mySQL database set up for this script to work.

Please report any bugs you notice.

icefreez · 02-19-2005

I have been having abit of trouble getting the pie chart function to display correctly everytime. It seems that every once in a while the function is not able to draw a certain section and ends up coloring the background as well as the section its supposed to.

This function is a bit to advanced for me to assess the problem, and I was wondering if anyone could spot any potential problems with or, or just refer me to different pie chart functions they know of.

I also am modifying my script to now allow you to get statistics from a certain GPS square grid

This should be intesting to see how various parts of your data compair to other parts of your data

02-15-2005	#1 (permalink)
icefreez Banned Join Date: Dec 2004 Location: South Dakota Posts: 32	Generate Graphs from summary files, using PHP UPDATE: Images of what this script creates when its done: http://icefreez.com/files/pictures/G...iechan.php.gif http://icefreez.com/files/pictures/G...vendor.php.gif http://icefreez.com/files/pictures/G...piewep.php.gif Release 2: Got a new update I need some feedback though Post what you think of the script please Download Summary Stats Version 2 NEW: Added Channels pie chart Added WEP vs NO WEP pie chart Added ability to set a GPS grid to get your results from. More info posted here Release 1: Currently it does just creates a customizable pie chart of the venders for all the AP's you output into a Net Stumbler Summary file. (I will add more graphs and information over time) Download Package 1 of Summary file to Vendor Pie Chart Script Don't forget you need a server capable of PHP and a mySQL database set up for this script to work. ----------------------------Original post------------------------- I am working on a project to generate interesting information about NS Summary files. I want to be able to see things like How many AP's have WEP VS no WEP, how many AP's are on what channels, What is the percentage of my AP's are Cisco routers. Some of this stuff NS can do, but it lists it out for you not numbers it and percents it. I will post the files here when I have completed them, but the reason I posted is to ask if anyone else has some ideas on what kind of stats might be interesting to generate. Script currently requires (PHP Server, 1 mySQL database) Last edited by icefreez : 02-28-2005 at 09:22 PM.

02-15-2005	#3 (permalink)
icefreez Banned Join Date: Dec 2004 Location: South Dakota Posts: 32	Yes Hopefully there is not already a script out that does that :P If there is I will probably still develope my script taylored to my wants though Right now I play on having the info displayed like this: VENDORS: Linksys: 45 (40%) NetGear 30 (34%) Cisco 3 (2%) (MAYBE PUT PIE CHART HERE, maybe) Channel 1: 4% Channel 2: 20% Channel 3: 6% Channel 4: 7% Channel 5: 3% Channel 6: 50%

02-15-2005	#4 (permalink)
streaker69 Psychic Amish Stumbler Join Date: Jul 2004 Location: Virginville, BlueBall, Bird In Hand, Intercourse, Paradise, PA Posts: 11,837	Those stats are generated from my own script that I wrote for my own website here I keep all my own personal wardriving info. It really isn't hard to do what you want to do. Just need to know how to enter data into a database and then tabulate it. __________________ "One of these days, I'm going to cut you to pieces." If you're offended by this post, please feel free to report it to one of the many helpful moderators of this forum. Thank you.

02-16-2005	#8 (permalink)
streaker69 Psychic Amish Stumbler Join Date: Jul 2004 Location: Virginville, BlueBall, Bird In Hand, Intercourse, Paradise, PA Posts: 11,837	Do you mean no SSID? In my script which was done in Vbscript, if the SSID is blank then I just have it set the SSID to "NO BROADCAST" which then gets entered in to my database that way. __________________ "One of these days, I'm going to cut you to pieces." If you're offended by this post, please feel free to report it to one of the many helpful moderators of this forum. Thank you.

02-16-2005	#9 (permalink)
icefreez Banned Join Date: Dec 2004 Location: South Dakota Posts: 32	Id 10 T LOL ya umm... sorry :P it was an ID 10 T error :P I axidently corrupted the tab structure in my test file. So big supprise that tab parsing wasn't working right :P Everything is working again now. Close to getting beta 1 of the script up

02-15-2005	#5 (permalink)
icefreez Banned Join Date: Dec 2004 Location: South Dakota Posts: 32	Ya it hasn't been to hard to do. The hardest thing I had to do was parse the oui.txt file to strip out the vender names and mac address beginnings. BTW whats the address to your script? I didn't see a link to it off your site and im curious to see what it looks like.

02-16-2005	#7 (permalink)
icefreez Banned Join Date: Dec 2004 Location: South Dakota Posts: 32	Ok I'm having a bit of a problem parsing the mac address's out of the summary file. It works fine untill i hit an entry with no address like this. N 43.9791333 W 96.8158483 ( ) BSS ( 00:02:2d:a5:94:6c ) 03:13:15 (GMT) [ 25 74 49 ] # ( ) 0011 00000040 100 110 6 I am currrently doing this to the file $fcontents = file ('./sum2.txt'); // File name of stumble summary for($i=1; $i<sizeof($fcontents); $i++) // Cycles though each line of the code { $line = trim($fcontents[$i]); $line = explode("\t", $line); // Strips up line by Tabs any tips on how to overcome this?

02-17-2005	#10 (permalink)
icefreez Banned Join Date: Dec 2004 Location: South Dakota Posts: 32	Well I got my pie chart of my brand names working, but the php pie chart function I am using tends to glitch after a certain number of divisions http://icefreez.com/temp/statscript/stats.php I will keep working on it. If anyone is intested in the source I will post it, but if not I will wait till I perfect it a bit more.

02-17-2005	#12 (permalink)
icefreez Banned Join Date: Dec 2004 Location: South Dakota Posts: 32	Ahh I just got an idea. I could set a minimum percentage, so only the top 4 or 5 are listed and the rest are dropped into a Other category EDIT: Now I fixed it to have a min number for a company to be displayed Looks nice now http://icefreez.com/temp/statscript/stats.php Last edited by icefreez : 02-17-2005 at 09:28 AM.

02-17-2005	#14 (permalink)
icefreez Banned Join Date: Dec 2004 Location: South Dakota Posts: 32	Finally Ok finally here is my first release of this script. I am pretty happy with how it performs. Currently it does just creates a customizable pie chart of the venders for all the AP's you output into a Net Stumbler Summary file. (I will add more graphs and information over time) Download Package 1 of Summary file to Vendor Pie Chart Script Don't forget you need a server capable of PHP and a mySQL database set up for this script to work. Please report any bugs you notice. Last edited by icefreez : 02-19-2005 at 04:35 PM.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode