So as I've spoken about before on here, I've created a web application for displaying feeds from thousands of exposed webcams on the Internet.
http://cryptogasm.com/webcams/
What I've been working on recently (as a result of meeting a journalist at Defcon London) is getting GeoIP for all the cameras in the viewer. Doing that was actually the easy part, but I wanted to make them all searchable.
So began an annoyingly complex journey into prepared MySQL statements in PHP, how to even parse complex search queries, and trying desperately to get the database to match on weird characters like 'ã'.
Anyway, it should all work now, but obviously I need some testers before I release it to the world. The previous search function matched the string you typed to the URL. This one is more advanced. It will match individual words or phrases (enclosed in quotation marks). Matches depend on *ALL* search terms being matched, so if one of them does not match anything, you'll get no results.
Additionally, you can use several GeoIP operators:
city:
region:
country:
continent:
Most should be self-explanatory. The "region" depends on the country; in the US it usually means the State. In the UK, it's usually the county.
An example search might be: city:London /anony/
That would show you all the feeds in London which had /anony/ as part of the URL. You can also give phrases to these operators, for instance to search for New York: city:"New York".
The operators use partial match searching, so city:York will match both the English town and New York. To filter down to only the English town, you would have to use country:"United Kingdom" or something similar in the search terms.
For now please use this URL if you want to test: http://cryptogasm.com/webcams/index2.php
Once everything is working well, I'll migrate the changes over to the new site.
http://cryptogasm.com/webcams/
What I've been working on recently (as a result of meeting a journalist at Defcon London) is getting GeoIP for all the cameras in the viewer. Doing that was actually the easy part, but I wanted to make them all searchable.
So began an annoyingly complex journey into prepared MySQL statements in PHP, how to even parse complex search queries, and trying desperately to get the database to match on weird characters like 'ã'.
Anyway, it should all work now, but obviously I need some testers before I release it to the world. The previous search function matched the string you typed to the URL. This one is more advanced. It will match individual words or phrases (enclosed in quotation marks). Matches depend on *ALL* search terms being matched, so if one of them does not match anything, you'll get no results.
Additionally, you can use several GeoIP operators:
city:
region:
country:
continent:
Most should be self-explanatory. The "region" depends on the country; in the US it usually means the State. In the UK, it's usually the county.
An example search might be: city:London /anony/
That would show you all the feeds in London which had /anony/ as part of the URL. You can also give phrases to these operators, for instance to search for New York: city:"New York".
The operators use partial match searching, so city:York will match both the English town and New York. To filter down to only the English town, you would have to use country:"United Kingdom" or something similar in the search terms.
For now please use this URL if you want to test: http://cryptogasm.com/webcams/index2.php
Once everything is working well, I'll migrate the changes over to the new site.
