#!/usr/bin/python
# import MySQL module

import MySQLdb
import sys
import getopt
import socket
import os

def main(argv):
    db = MySQLdb.connect(host="localhost", user="mythtv", passwd="mythtv", db="mythconverg")
    # create a cursor
    cursor = db.cursor()
    # execute SQL statement
    cursor.execute("SELECT DISTINCT(hostname) from settings where not hostname is NULL")
    result = cursor.fetchall()
    message = sys.argv[2]
    messagetype = sys.argv[1]
    port=str(5000)
    if messagetype == "PH2":
	    port=str(5001)
	    
    
    message = message + " :::" + messagetype
    for row in result:
    	os.system("/usr/bin/osdClient.pl  " + row[0] + "  " +  port   + "   "+  "\"" +  message + "\""  + "&" )

if __name__ == "__main__":
    main(sys.argv[1:])