# Convert GpsDrive to Googlearth v 1.0
# Edited by amri - www.mpetrov.net

import MySQLdb

DB="geoinfo"
LOGIN="gast"
PASSWORD="gast"



def hl():
    print "=" * 80


cnx = MySQLdb.connect(db=DB,user=LOGIN,passwd=PASSWORD)
cursor = cnx.cursor()



cursor.execute("select essid,wep,lat,lon,macaddr from wlan order by essid;")

results = cursor.fetchall()

hl()
print "Total APS:%s" % len(results)
hl()


f = open('wireless_mpetrov_net.kml','w')
f.write('<?xml version="1.0" encoding="UTF-8"?>\n')
f.write('<kml xmlns="http://earth.google.com/kml/2.0">\n')
f.write('<Folder>\n')
f.write('<name>BrestWireless</name>\n')
f.write('<visibility>1</visibility>\n')

for line in results:
    essid = line[0]
    wep  = int(line[1])
    lat  = line[2]
    lon  = line[3]
    macaddr  = line[4]

    if wep == 0:
        free = "Open"
    else:
        free = "Encrypted"

    print "%s (%s): %s %s %s" % (essid,macaddr,lat,lon,free)
    f.write('\n')
    f.write(' <Placemark>\n')
    f.write(' <name>%s</name>\n' % (essid) )
    f.write('  <description>Network: %s\nMAC: %s\nFree: %s</description>\n' % (essid,macaddr,free))
    f.write(' <View>\n')
    f.write('  <longitude>%s</longitude>\n' % lon)
    f.write('  <latitude>%s</latitude>\n' % lat)
    f.write(' </View>\n')
    f.write(' <visibility>1</visibility>\n')
    f.write(' <styleUrl>root://styleMaps#default?iconId=0x307</styleUrl>\n')
    if free =='Encrypted':
        f.write('<Style><Icon><href>http://www.mpetrov.net/gmap/node_interest.png</href></Icon></Style>\n')
    else:
        f.write('<Style><Icon><href>http://www.mpetrov.net/gmap/node_online.png</href></Icon></Style>\n')

    
    f.write(' <Point><coordinates>%s,%s,45</coordinates></Point>\n' % (lon,lat) )


    f.write(' </Placemark>\n')

f.write('</Folder>\n')
f.write('</kml>')
hl()