insert into macroheader values ('MAIL COMMANDS','Looks for commands in str',0,0,0); insert into macrodetail values ('MAIL COMMANDS',1,37,'',NULL,'"',1,''); insert into macrodetail values ('MAIL COMMANDS',2,15,'[LOCAL2]',NULL,'if (pos("[LOCAL1]", char(9)) > 0, left("[LOCAL1]", pos("[LOCAL1]", char(9)) - 1), "" )',0,''); insert into macrodetail values ('MAIL COMMANDS',3,27,'',NULL,' (pos(upper("{G_EMAILS}"), "," + upper("[LOCAL2]") + ",") > 0, "Continue", "Error" ), "Error" ), "Error" )',0,''); insert into macrodetail values ('MAIL COMMANDS',4,26,'',NULL,'Continue',0,''); insert into macrodetail values ('MAIL COMMANDS',5,37,'',NULL,'Livingroom"',1,''); insert into macrodetail values ('MAIL COMMANDS',6,38,'',0,'if (pos("[LOCAL1]", "HEAT ON") > 0, ph_macro("X10 A3 ON"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',7,38,'',0,'if (pos("[LOCAL1]", "HEAT OFF") > 0, ph_macro("X10 A3 OFF"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',8,38,'',0,'if (pos("[LOCAL1]", "FAN ON") > 0, ph_macro("X10 A5 ON"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',9,38,'',0,'if (pos("[LOCAL1]", "FAN OFF") > 0, ph_macro("X10 A5 OFF"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',10,38,'',0,'if (pos("[LOCAL1]", "OVERHEAD ON") > 0, ph_macro("X10 A1 ON"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',11,38,'',0,'if (pos("[LOCAL1]", "OVERHEAD OFF") > 0, ph_macro("X10 A1 OFF"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',12,38,'',0,'if (pos("[LOCAL1]", "COUCH ON") > 0, ph_macro("X10 A2 ON"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',13,38,'',0,'if (pos("[LOCAL1]", "COUCH OFF") > 0, ph_macro("X10 A2 OFF"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',14,37,'',NULL,'Bedroom',1,''); insert into macrodetail values ('MAIL COMMANDS',15,38,'',0,'if (pos("[LOCAL1]", "BED1 ON") > 0, ph_macro("X10 B1 ON"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',16,38,'',0,'if (pos("[LOCAL1]", "BED1 OFF") > 0, ph_macro("X10 B1 OFF"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',17,38,'',0,'if (pos("[LOCAL1]", "BED2 ON") > 0, ph_macro("X10 B2 ON"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',18,38,'',0,'if (pos("[LOCAL1]", "BED2 OFF") > 0, ph_macro("X10 B2 OFF"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',19,38,'',0,'if (pos("[LOCAL1]", "CHARGER ON") > 0, ph_macro("X10 B3 ON"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',20,38,'',0,'if (pos("[LOCAL1]", "CHARGER OFF") > 0, ph_macro("X10 B3 OFF"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',21,37,'',NULL,'Outside',1,''); insert into macrodetail values ('MAIL COMMANDS',22,38,'',0,'if (pos("[LOCAL1]", "WALK ON") > 0, ph_macro("X10 A4 ON"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',23,38,'',0,'if (pos("[LOCAL1]", "WALK OFF") > 0, ph_macro("X10 A4 OFF"),0)',0,''); insert into macrodetail values ('MAIL COMMANDS',24,37,'',NULL,'Parse out email and send',1,''); insert into macrodetail values ('MAIL COMMANDS',25,24,'No TTS',1,'"''"+"[LOCAL2]"+"''"',1,''); insert into macrodetail values ('MAIL COMMANDS',26,38,'',0,'ph_macroparm("MAIL SEND STATUS", "[LOCAL2]", "", "", "", "")',0,''); insert into macrodetail values ('MAIL COMMANDS',27,15,'[LOCAL1]',NULL,'"1"',0,''); insert into macrodetail values ('MAIL COMMANDS',28,27,'',NULL,'"The End"',0,''); insert into macrodetail values ('MAIL COMMANDS',29,26,'',NULL,'Error',0,''); insert into macrodetail values ('MAIL COMMANDS',30,10,'G_EMAIL_ERRORS',NULL,'"{G_EMAIL_ERRORS}" + "[LOCAL2]" + ", "',0,''); insert into macrodetail values ('MAIL COMMANDS',31,15,'[LOCAL1]',NULL,'"0"',0,''); insert into macrodetail values ('MAIL COMMANDS',32,26,'',NULL,'The End',0,'');