NS php->sql db parser

deaftone · 12-28-2004

This is a little "off topic" so I'll probably get flamed like other noobs for seeking info. If anyone knows of a public php script that would basically do the same thing as the one on wigle.net, meaning: being able to upload a .ns1/summary file for parsing and displaying/storing found info in a mysql db for later use, it would be greatly appreciated.

another example: http://www.secure-wifi.net/index.php?p=stats
(Yes I have searched for that script, other php-based ones and emailed the author/admin of that site, no luck.)

riscphree · 12-30-2004

yeah, all that stuff your going to have to code yourself, i dont think they are in a hurry to release the source.

deaftone · 12-30-2004

I never specifically said their source, but there are some scripts out there for the public that do the same thing, only thing is, they're either python or perl.

King_Ice_Flash · 12-31-2004

I thought that there was a script posted on the World Wide Wardrive site, that would go through the NS files, but I do not remember what it did, I also can not find it any more.

Ze_NiTH · 12-31-2004

I was in the middle of making a script that would do just that. That was also the same time that I discovered wigle.net and saw no use for the script after that. It should be pretty easy to go through the summary files, havent looked at the .ns1 files though.

deaftone · 01-01-2005

The .ns1 is binary; I'm having some trouble understanding how to parse it in php... Since you said you “were in the middle” of writing it when you discovered wigle.net, do you still have what you got up to?

Ze_NiTH · 01-02-2005

Sorry, I lost it in a reformat =\

localhost · 01-02-2005

deaftone: my site (secure-wifi.net) does not use the type of script that you are looking to do (although i am developing it right now since it would be very useful).

as of right now, i export to a summary file, run a c++ program that i wrote on the summary file, then upload the summary to the webserver. the same c++ program handles the statistics page. when someone search for a mac address, it checks using regex to see if it is a mac or not, and then performs a grep on the database. since it is just a text file with only one possible matching line, it is not too big of a deal lag'wise, but i still want to move it to mysql.

if you really want, i can clean up the source and post it (it is kinda sloppy right now).

btw: it is alot easier to parse a summary file than the ns1 file (unless you need data that is only contained in the ns1, then ur sol)

candy-man · 01-02-2005

Thank you for expressing an intrest in the site (secure-wifi.net). Like localhost said, it's currently unavailable to the public.

Bill
Secure-Wifi Staff

deaftone · 01-03-2005

Thanks for the replys. I'd love any piece of code that I can get my hands on at the moment. At least that way I'll have something to look through and build some ideas from. You mentioned developing it/a similar one, any chance on sending a copy when it's done?

It would be greatly appreciated.

janolap1 · 01-06-2005

Hi,

I'm beginning such a php script.
I have already done it for netstumbler text summary (see this message).
You can test the script for ns1 files and improve it (contact me if you can improve it because I'm searching for solutions) (see this message).

Cordially

Jean CARTIER

deaftone · 01-06-2005

Thanks janolap1! I'll mod it a little, but the code helps a lot.

janolap1 · 01-07-2005

Hi deaftone,

I hope you'll make it work.

Those days, I don't have enough time at work

to enhance it.

Leave it to the community when it works... please, leave the source open !

Janolap1

janolap1 · 01-17-2005

See my other post...

deaftone · 01-18-2005

Yeah, I noticed it. Just having some trouble sending the parsed info to a SQL db, for some reason it doesn't like punctuation... Oh well, I'll figure it out hopefully.

12-28-2004	#1 (permalink)
deaftone Registered Member Join Date: Dec 2004 Posts: 12	NS php->sql db parser This is a little "off topic" so I'll probably get flamed like other noobs for seeking info. If anyone knows of a public php script that would basically do the same thing as the one on wigle.net, meaning: being able to upload a .ns1/summary file for parsing and displaying/storing found info in a mysql db for later use, it would be greatly appreciated. another example: http://www.secure-wifi.net/index.php?p=stats (Yes I have searched for that script, other php-based ones and emailed the author/admin of that site, no luck.)

12-31-2004	#4 (permalink)
King_Ice_Flash Alien Paranoid Stumbler Join Date: May 2003 Location: WI Posts: 2,624	I thought that there was a script posted on the World Wide Wardrive site, that would go through the NS files, but I do not remember what it did, I also can not find it any more. __________________ "Yeah," said a voice from under the table, "you go to pieces so fast people get hit by the shrapnel."

01-02-2005	#8 (permalink)
localhost I'm always at 127.0.0.1 Join Date: Mar 2004 Posts: 26	deaftone: my site (secure-wifi.net) does not use the type of script that you are looking to do (although i am developing it right now since it would be very useful). as of right now, i export to a summary file, run a c++ program that i wrote on the summary file, then upload the summary to the webserver. the same c++ program handles the statistics page. when someone search for a mac address, it checks using regex to see if it is a mac or not, and then performs a grep on the database. since it is just a text file with only one possible matching line, it is not too big of a deal lag'wise, but i still want to move it to mysql. if you really want, i can clean up the source and post it (it is kinda sloppy right now). btw: it is alot easier to parse a summary file than the ns1 file (unless you need data that is only contained in the ns1, then ur sol) Last edited by localhost : 01-02-2005 at 12:45 PM.

01-06-2005	#11 (permalink)
janolap1 Registered Member Join Date: Nov 2004 Posts: 9	See my message Hi, I'm beginning such a php script. I have already done it for netstumbler text summary (see this message). You can test the script for ns1 files and improve it (contact me if you can improve it because I'm searching for solutions) (see this message). Cordially Jean CARTIER

01-07-2005	#13 (permalink)
janolap1 Registered Member Join Date: Nov 2004 Posts: 9	Good luck ! Hi deaftone, I hope you'll make it work. Those days, I don't have enough time at work to enhance it. Leave it to the community when it works... please, leave the source open ! Janolap1

12-30-2004	#2 (permalink)
riscphree Registered Member Join Date: Apr 2004 Posts: 17	yeah, all that stuff your going to have to code yourself, i dont think they are in a hurry to release the source.

12-30-2004	#3 (permalink)
deaftone Registered Member Join Date: Dec 2004 Posts: 12	I never specifically said their source, but there are some scripts out there for the public that do the same thing, only thing is, they're either python or perl.

12-31-2004	#5 (permalink)
Ze_NiTH Registered Member Join Date: Sep 2004 Posts: 9	I was in the middle of making a script that would do just that. That was also the same time that I discovered wigle.net and saw no use for the script after that. It should be pretty easy to go through the summary files, havent looked at the .ns1 files though.

01-01-2005	#6 (permalink)
deaftone Registered Member Join Date: Dec 2004 Posts: 12	The .ns1 is binary; I'm having some trouble understanding how to parse it in php... Since you said you “were in the middle” of writing it when you discovered wigle.net, do you still have what you got up to?

01-02-2005	#7 (permalink)
Ze_NiTH Registered Member Join Date: Sep 2004 Posts: 9	Sorry, I lost it in a reformat =\

01-02-2005	#9 (permalink)
candy-man Registered Member Join Date: Sep 2004 Posts: 6	Thank you for expressing an intrest in the site (secure-wifi.net). Like localhost said, it's currently unavailable to the public. Bill Secure-Wifi Staff

01-03-2005	#10 (permalink)
deaftone Registered Member Join Date: Dec 2004 Posts: 12	Thanks for the replys. I'd love any piece of code that I can get my hands on at the moment. At least that way I'll have something to look through and build some ideas from. You mentioned developing it/a similar one, any chance on sending a copy when it's done? It would be greatly appreciated.

01-06-2005	#12 (permalink)
deaftone Registered Member Join Date: Dec 2004 Posts: 12	Thanks janolap1! I'll mod it a little, but the code helps a lot.

01-17-2005	#14 (permalink)
janolap1 Registered Member Join Date: Nov 2004 Posts: 9	The script finally works (with a few bugs) See my other post...

01-18-2005	#15 (permalink)
deaftone Registered Member Join Date: Dec 2004 Posts: 12	Yeah, I noticed it. Just having some trouble sending the parsed info to a SQL db, for some reason it doesn't like punctuation... Oh well, I'll figure it out hopefully.

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