-- Database import -- psc_id: 167926,167927,167928,167929,167930,167931,167932,167933,167934,167935,167936,167937,167938,167939,167940,167941,167942,167943,167944,167945,167946,167947,167948,167949,167950,167951,167952,167953,167954,167955,167956,167957,167958,167959,167960,167961,167962,167963,167964,167965,167966,167967,167968,167969,167970,167971,167972,167973,167974,167975,167976,167977,167978,167979,167980,167981,167982,167983,167984,167985,167986,167987,167988,167989,167990,167991,167992,167993,167994,167995,167996,167997,167998,167999,168000,168001,168002,168003,168004,168005,168006,168007,168008,168009,168010,168011,168012,168013,168014,168015,168016,168017,168018,168019,168020,168021,168022,168023,168024,168025,168026,168027,168028,168029,168030,168031,168032,168033,168034,168035,168036,168037,168038,168039,168040,168041,168042,168043,168446,168447,168448,168449,168450,168451,168452,168453,168454,168455,168456,168457,168458,168459,168460,168461,168462,168463,168464,168465,168466,168467,168468,168469,168470,168471,168472,168473,168474,168475,168476,168477,168478,168479 -- mysqldump main_sqlcvs_utf8 -hlocalhost -ulinuxmce -plinux0718mc3 InfraredGroup_Command --where "psc_id IN (167926,167927,167928,167929,167930,167931,167932,167933,167934,167935,167936,167937,167938,167939,167940,167941,167942,167943,167944,167945,167946,167947,167948,167949,167950,167951,167952,167953,167954,167955,167956,167957,167958,167959,167960,167961,167962,167963,167964,167965,167966,167967,167968,167969,167970,167971,167972,167973,167974,167975,167976,167977,167978,167979,167980,167981,167982,167983,167984,167985,167986,167987,167988,167989,167990,167991,167992,167993,167994,167995,167996,167997,167998,167999,168000,168001,168002,168003,168004,168005,168006,168007,168008,168009,168010,168011,168012,168013,168014,168015,168016,168017,168018,168019,168020,168021,168022,168023,168024,168025,168026,168027,168028,168029,168030,168031,168032,168033,168034,168035,168036,168037,168038,168039,168040,168041,168042,168043,168446,168447,168448,168449,168450,168451,168452,168453,168454,168455,168456,168457,168458,168459,168460,168461,168462,168463,168464,168465,168466,168467,168468,168469,168470,168471,168472,168473,168474,168475,168476,168477,168478,168479)" --no-create-info --skip-comments --force --skip-extended-insert /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; LOCK TABLES `InfraredGroup_Command` WRITE; /*!40000 ALTER TABLE `InfraredGroup_Command` DISABLE KEYS */; INSERT INTO `InfraredGroup_Command` VALUES (167599,6038,97,NULL,'if(@mute)\r\n <$\"MF\\r\"$>\r\nelse\r\n <$\"MO\\r\"$> \r\nend\r\n@mute=!@mute',NULL,167926,327,38890,0,'2009-12-17 18:18:54',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167600,6038,193,NULL,'<$\"PF\\r\"$>',NULL,167927,327,38890,0,'2009-12-17 18:18:54',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167601,6038,192,NULL,'<$\"PO\\r\"$>\r\nsleep(5)',NULL,167928,369,38890,0,'2010-05-12 23:50:09',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167602,6038,90,NULL,'<$\"VD\\r\"$>',NULL,167929,327,38890,0,'2009-12-17 18:18:56',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167603,6038,89,NULL,'<$\"VU\\r\"$>',NULL,167930,327,38890,0,'2009-12-17 18:18:56',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167604,6038,996,NULL,'<$\"04FN\\r\"$>',NULL,167931,327,38890,0,'2009-12-17 18:18:57',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167605,6038,162,NULL,'<$\"01FN\\r\"$>',NULL,167932,327,38890,0,'2009-12-17 18:18:57',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167606,6038,999,NULL,'<$\"03FN\\r\"$>',NULL,167933,327,38890,0,'2009-12-17 18:18:58',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167607,6038,165,NULL,'<$\"04FN\\r\"$>',NULL,167934,327,38890,0,'2009-12-17 18:18:59',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167608,6038,714,NULL,'<$\"15FN\\r\"$>',NULL,167935,327,38890,0,'2009-12-17 18:18:59',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167609,6038,767,NULL,'<$\"20FN\\r\"$>',NULL,167936,327,38890,0,'2009-12-17 18:19:00',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167610,6038,930,NULL,'<$\"21FN\\r\"$>',NULL,167937,327,38890,0,'2009-12-17 18:19:00',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167611,6038,997,NULL,'<$\"17FN\\r\"$>',NULL,167938,327,38890,0,'2009-12-17 18:19:01',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167612,6038,881,NULL,'<$\"12FN\\r\"$>',NULL,167939,327,38890,0,'2009-12-17 18:19:01',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167613,6038,166,NULL,'<$\"02FN\\r\"$>',NULL,167940,327,38890,0,'2009-12-17 18:19:02',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167614,6038,998,NULL,'<$\"05FN\\r\"$>',NULL,167941,327,38890,0,'2009-12-17 18:19:03',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167615,6038,155,NULL,'<$\"10FN\\r\"$>',NULL,167942,327,38890,0,'2009-12-17 18:19:03',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167616,6038,156,NULL,'<$\"14FN\\r\"$>',NULL,167943,327,38890,0,'2009-12-17 18:19:04',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167617,6038,909,NULL,'<$\"18FN\\r\"$>',NULL,167944,327,38890,0,'2009-12-17 18:19:04',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167618,6038,663,NULL,'<$\"TD\\r\"$>',NULL,167945,327,38890,0,'2009-12-17 18:19:05',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167619,6038,666,NULL,'<$\"TI\\r\"$>',NULL,167946,327,38890,0,'2009-12-17 18:19:05',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167620,6038,201,NULL,'<$\"CDN\\r\"$>',NULL,167947,327,38890,0,'2009-12-17 18:19:06',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167621,6038,202,NULL,'<$\"CLE\\r\"$>',NULL,167948,327,38890,0,'2009-12-17 18:19:07',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167622,6038,203,NULL,'<$\"CRI\\r\"$>',NULL,167949,327,38890,0,'2009-12-17 18:19:07',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167623,6038,200,NULL,'<$\"CUP\\r\"$>',NULL,167950,327,38890,0,'2009-12-17 18:19:08',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167624,6038,954,NULL,'<$\"CRT\\r\"$>',NULL,167951,327,38890,0,'2009-12-17 18:19:08',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167625,6038,230,NULL,'<$\"BD\\r\"$>',NULL,167952,327,38890,0,'2009-12-17 18:19:09',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167626,6038,229,NULL,'<$\"BI\\r\"$>',NULL,167953,327,38890,0,'2009-12-17 18:19:09',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167627,6038,888,NULL,'<$\"0109SR\\r\"$>',NULL,167954,327,38890,0,'2009-12-17 18:19:10',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167628,6038,308,NULL,'<$\"0007SR\\r\"$>',NULL,167955,327,38890,0,'2009-12-17 18:19:10',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167629,6038,153,NULL,'<$\"0107SR\\r\"$>',NULL,167956,327,38890,0,'2009-12-17 18:19:11',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167630,6038,885,NULL,'<$\"0101SR\\r\"$>',NULL,167957,327,38890,0,'2009-12-17 18:19:12',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167631,6038,302,NULL,'<$\"0080SR\\r\"$>',NULL,167958,327,38890,0,'2009-12-17 18:19:12',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167632,6038,899,NULL,'<$\"0068SR\\r\"$>',NULL,167959,327,38890,0,'2009-12-17 18:19:13',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167633,6038,304,NULL,'<$\"0057SR\\r\"$>',NULL,167960,327,38890,0,'2009-12-17 18:19:13',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167634,6038,1066,NULL,'<$\"0151SR\\r\"$>',NULL,167961,327,38890,0,'2009-12-17 18:19:14',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167635,6038,1016,NULL,'<$\"0103SR\\r\"$>',NULL,167962,327,38890,0,'2009-12-17 18:19:14',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167636,6038,1001,NULL,'<$\"0018SR\\r\"$>',NULL,167963,327,38890,0,'2009-12-17 18:19:15',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167637,6038,1003,NULL,'<$\"0019SR\\r\"$>',NULL,167964,327,38890,0,'2009-12-17 18:19:16',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167638,6038,1005,NULL,'<$\"0020SR\\r\"$>',NULL,167965,327,38890,0,'2009-12-17 18:19:16',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167639,6038,1002,NULL,'<$\"0014SR\\r\"$>',NULL,167966,327,38890,0,'2009-12-17 18:19:17',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167640,6038,1004,NULL,'<$\"0015SR\\r\"$>',NULL,167967,327,38890,0,'2009-12-17 18:19:17',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167641,6038,1006,NULL,'<$\"0012SR\\r\"$>',NULL,167968,327,38890,0,'2009-12-17 18:19:18',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167642,6038,1009,NULL,'<$\"0029SR\\r\"$>',NULL,167969,327,38890,0,'2009-12-17 18:19:18',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167643,6038,1010,NULL,'<$\"0028SR\\r\"$>',NULL,167970,327,38890,0,'2009-12-17 18:19:19',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167644,6038,1022,NULL,'<$\"0118SR\\r\"$>',NULL,167971,327,38890,0,'2009-12-17 18:19:20',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167645,6038,1021,NULL,'<$\"0116SR\\r\"$>',NULL,167972,327,38890,0,'2009-12-17 18:19:20',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167646,6038,1024,NULL,'<$\"0110SR\\r\"$>',NULL,167973,327,38890,0,'2009-12-17 18:19:21',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167647,6038,1017,NULL,'<$\"0102SR\\r\"$>',NULL,167974,327,38890,0,'2009-12-17 18:19:21',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167648,6038,1069,NULL,'<$\"0010SR\\r\"$>',NULL,167975,327,38890,0,'2009-12-17 18:19:22',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167649,6038,1023,NULL,'<$\"0117SR\\r\"$>',NULL,167976,327,38890,0,'2009-12-17 18:19:22',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167650,6038,1015,NULL,'<$\"0100SR\\r\"$>',NULL,167977,327,38890,0,'2009-12-17 18:19:23',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167651,6038,311,NULL,'<$\"0001SR\\r\"$>',NULL,167978,327,38890,0,'2009-12-17 18:19:24',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167652,6038,1013,NULL,'<$\"0027SR\\r\"$>',NULL,167979,327,38890,0,'2009-12-17 18:19:24',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167653,6038,1011,NULL,'<$\"0025SR\\r\"$>',NULL,167980,327,38890,0,'2009-12-17 18:19:25',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167654,6038,1012,NULL,'<$\"0026SR\\r\"$>',NULL,167981,327,38890,0,'2009-12-17 18:19:25',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167655,6038,1014,NULL,'<$\"0030SR\\r\"$>',NULL,167982,327,38890,0,'2009-12-17 18:19:26',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167656,6038,1007,NULL,'<$\"0016SR\\r\"$>',NULL,167983,327,38890,0,'2009-12-17 18:19:26',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167657,6038,1008,NULL,'<$\"0017SR\\r\"$>',NULL,167984,327,38890,0,'2009-12-17 18:19:27',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167658,6038,1068,NULL,'<$\"0004SR\\r\"$>',NULL,167985,327,38890,0,'2009-12-17 18:19:28',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167659,6038,1051,NULL,'<$\"0066SR\\r\"$>',NULL,167986,327,38890,0,'2009-12-17 18:19:28',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167660,6038,1039,NULL,'<$\"0079SR\\r\"$>',NULL,167987,327,38890,0,'2009-12-17 18:19:29',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167661,6038,1050,NULL,'<$\"0065SR\\r\"$>',NULL,167988,327,38890,0,'2009-12-17 18:19:29',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167662,6038,1048,NULL,'<$\"0063SR\\r\"$>',NULL,167989,327,38890,0,'2009-12-17 18:19:30',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167663,6038,1049,NULL,'<$\"0064SR\\r\"$>',NULL,167990,327,38890,0,'2009-12-17 18:19:30',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167664,6038,1047,NULL,'<$\"0062SR\\r\"$>',NULL,167991,327,38890,0,'2009-12-17 18:19:31',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167665,6038,1033,NULL,'<$\"0081SR\\r\"$>',NULL,167992,327,38890,0,'2009-12-17 18:19:32',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167666,6038,286,NULL,'<$\"0008SR\\r\"$>',NULL,167993,327,38890,0,'2009-12-17 18:19:32',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167667,6038,1063,NULL,'<$\"0005SR\\r\"$>',NULL,167994,327,38890,0,'2009-12-17 18:19:33',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167668,6038,1064,NULL,'<$\"0006SR\\r\"$>',NULL,167995,327,38890,0,'2009-12-17 18:19:33',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167669,6038,1031,NULL,'<$\"0058SR\\r\"$>',NULL,167996,327,38890,0,'2009-12-17 18:19:34',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167670,6038,1060,NULL,'<$\"0089SR\\r\"$>',NULL,167997,327,38890,0,'2009-12-17 18:19:35',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167671,6038,1061,NULL,'<$\"0090SR\\r\"$>',NULL,167998,327,38890,0,'2009-12-17 18:19:35',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167672,6038,1055,NULL,'<$\"0084SR\\r\"$>',NULL,167999,327,38890,0,'2009-12-17 18:19:36',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167673,6038,1065,NULL,'<$\"0152SR\\r\"$>',NULL,168000,327,38890,0,'2009-12-17 18:19:36',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167674,6038,1053,NULL,'<$\"0082SR\\r\"$>',NULL,168001,327,38890,0,'2009-12-17 18:19:37',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167675,6038,1058,NULL,'<$\"0087SR\\r\"$>',NULL,168002,329,38890,0,'2009-12-17 18:21:47',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167676,6038,1045,NULL,'<$\"0061SR\\r\"$>',NULL,168003,329,38890,0,'2009-12-17 18:21:48',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167677,6038,1059,NULL,'<$\"0088SR\\r\"$>',NULL,168004,329,38890,0,'2009-12-17 18:21:49',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167678,6038,1062,NULL,'<$\"0091SR\\r\"$>',NULL,168005,329,38890,0,'2009-12-17 18:21:49',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167679,6038,1046,NULL,'<$\"0067SR\\r\"$>',NULL,168006,329,38890,0,'2009-12-17 18:21:50',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167680,6038,1043,NULL,'<$\"0059SR\\r\"$>',NULL,168007,329,38890,0,'2009-12-17 18:21:50',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167681,6038,1054,NULL,'<$\"0083SR\\r\"$>',NULL,168008,329,38890,0,'2009-12-17 18:21:51',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167682,6038,1044,NULL,'<$\"0060SR\\r\"$>',NULL,168009,329,38890,0,'2009-12-17 18:21:51',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167683,6038,1057,NULL,'<$\"0086SR\\r\"$>',NULL,168010,329,38890,0,'2009-12-17 18:21:52',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167684,6038,1028,NULL,'<$\"0050SR\\r\"$>',NULL,168011,329,38890,0,'2009-12-17 18:21:53',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167685,6038,1027,NULL,'<$\"0051SR\\r\"$>',NULL,168012,329,38890,0,'2009-12-17 18:21:53',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167686,6038,1041,NULL,'<$\"0078SR\\r\"$>',NULL,168013,329,38890,0,'2009-12-17 18:21:54',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167687,6038,1040,NULL,'<$\"0077SR\\r\"$>',NULL,168014,329,38890,0,'2009-12-17 18:21:54',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167688,6038,1042,NULL,'<$\"0054SR\\r\"$>',NULL,168015,329,38890,0,'2009-12-17 18:21:55',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167689,6038,1029,NULL,'<$\"0052SR\\r\"$>',NULL,168016,329,38890,0,'2009-12-17 18:21:55',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167690,6038,1035,NULL,'<$\"0072SR\\r\"$>',NULL,168017,329,38890,0,'2009-12-17 18:21:56',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167691,6038,1034,NULL,'<$\"0071SR\\r\"$>',NULL,168018,329,38890,0,'2009-12-17 18:21:56',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167692,6038,1038,NULL,'<$\"0075SR\\r\"$>',NULL,168019,329,38890,0,'2009-12-17 18:21:57',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167693,6038,1025,NULL,'<$\"0112SR\\r\"$>',NULL,168020,329,38890,0,'2009-12-17 18:21:58',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167694,6038,1026,NULL,'<$\"0113SR\\r\"$>',NULL,168021,329,38890,0,'2009-12-17 18:21:58',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167695,6038,1020,NULL,'<$\"0106SR\\r\"$>',NULL,168022,329,38890,0,'2009-12-17 18:21:59',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167696,6038,1019,NULL,'<$\"0104SR\\r\"$>',NULL,168023,329,38890,0,'2009-12-17 18:21:59',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167697,6038,1030,NULL,'<$\"0053SR\\r\"$>',NULL,168024,329,38890,0,'2009-12-17 18:22:00',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167698,6038,1036,NULL,'<$\"0073SR\\r\"$>',NULL,168025,329,38890,0,'2009-12-17 18:22:00',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167699,6038,1037,NULL,'<$\"0074SR\\r\"$>',NULL,168026,329,38890,0,'2009-12-17 18:22:01',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167700,6038,1056,NULL,'<$\"0085SR\\r\"$>',NULL,168027,329,38890,0,'2009-12-17 18:22:02',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167701,6038,1018,NULL,'<$\"0105SR\\r\"$>',NULL,168028,329,38890,0,'2009-12-17 18:22:02',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167702,6038,433,NULL,'<$\"1SPK\\r\"$>',NULL,168029,329,38890,0,'2009-12-17 18:22:03',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167703,6038,434,NULL,'<$\"3SPK\\r\"$>',NULL,168030,329,38890,0,'2009-12-17 18:22:03',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167704,6038,450,NULL,'<$\"2SPK\\r\"$>',NULL,168031,329,38890,0,'2009-12-17 18:22:04',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167705,6038,547,NULL,'',NULL,168032,329,38890,0,'2009-12-17 18:22:04',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167706,6038,585,NULL,'<$\"TPD\\r\"$>',NULL,168033,329,38890,0,'2009-12-17 18:22:05',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167707,6038,586,NULL,'<$\"TPI\\r\"$>',NULL,168034,329,38890,0,'2009-12-17 18:22:05',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167708,6038,587,NULL,'',NULL,168035,329,38890,0,'2009-12-17 18:22:06',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167709,6038,649,NULL,'',NULL,168036,329,38890,0,'2009-12-17 18:22:07',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167710,6038,313,NULL,'<$level + \"VL\"\"\\r\"$>\r\nSetDeviceDataInDB( device_.devid_, 2033, level ) # 2033 = DEVICEDATA_Volume_Level_CONST\r\nprint \"volume and corresponding device data set\\n\"\r\n',NULL,168037,369,38890,0,'2010-05-12 23:50:10',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167711,6038,1071,NULL,'<$\"31FN\\r\"$>',NULL,168038,329,38890,0,'2009-12-17 18:22:08',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167712,6038,984,NULL,'<$\"19FN\\r\"$>',NULL,168039,329,38890,0,'2009-12-17 18:22:08',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167713,6038,1070,NULL,'<$\"27FN\\r\"$>',NULL,168040,329,38890,0,'2009-12-17 18:22:09',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167714,6038,1072,NULL,'<$\"26FN\\r\"$>',NULL,168041,329,38890,0,'2009-12-17 18:22:09',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167715,6038,163,NULL,'<$\"00FN\\r\"$>',NULL,168042,329,38890,0,'2009-12-17 18:22:10',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167716,6038,985,NULL,'<$\"22FN\\r\"$>',NULL,168043,329,38890,0,'2009-12-17 18:22:11',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167920,6038,364,NULL,'',NULL,168446,369,38890,0,'2010-05-12 23:49:44',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167921,6038,204,NULL,'',NULL,168447,369,38890,0,'2010-05-12 23:49:45',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167922,6038,205,NULL,'',NULL,168448,369,38890,0,'2010-05-12 23:49:46',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167923,6038,206,NULL,'',NULL,168449,369,38890,0,'2010-05-12 23:49:46',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167924,6038,207,NULL,'',NULL,168450,369,38890,0,'2010-05-12 23:49:47',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167925,6038,208,NULL,'',NULL,168451,369,38890,0,'2010-05-12 23:49:48',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167926,6038,209,NULL,'',NULL,168452,369,38890,0,'2010-05-12 23:49:48',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167927,6038,210,NULL,'',NULL,168453,369,38890,0,'2010-05-12 23:49:49',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167928,6038,211,NULL,'',NULL,168454,369,38890,0,'2010-05-12 23:49:49',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167929,6038,212,NULL,'',NULL,168455,369,38890,0,'2010-05-12 23:49:50',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167930,6038,213,NULL,'',NULL,168456,369,38890,0,'2010-05-12 23:49:51',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167931,6038,363,NULL,'',NULL,168457,369,38890,0,'2010-05-12 23:49:51',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167932,6038,190,NULL,'',NULL,168458,369,38890,0,'2010-05-12 23:49:53',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167933,6038,48,NULL,'',NULL,168459,369,38890,0,'2010-05-12 23:49:54',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167934,6038,92,NULL,'',NULL,168460,369,38890,0,'2010-05-12 23:49:54',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167935,6038,139,NULL,'',NULL,168461,369,38890,0,'2010-05-12 23:49:55',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167936,6038,102,NULL,'',NULL,168462,369,38890,0,'2010-05-12 23:49:55',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167937,6038,125,NULL,'',NULL,168463,369,38890,0,'2010-05-12 23:49:56',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167938,6038,93,NULL,'',NULL,168464,369,38890,0,'2010-05-12 23:49:56',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167939,6038,64,NULL,'',NULL,168465,369,38890,0,'2010-05-12 23:49:57',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167940,6038,63,NULL,'',NULL,168466,369,38890,0,'2010-05-12 23:49:58',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167941,6038,98,NULL,'',NULL,168467,369,38890,0,'2010-05-12 23:49:58',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167942,6038,99,NULL,'',NULL,168468,369,38890,0,'2010-05-12 23:49:59',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167943,6038,95,NULL,'',NULL,168469,369,38890,0,'2010-05-12 23:49:59',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167944,6038,240,NULL,'',NULL,168470,369,38890,0,'2010-05-12 23:50:00',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167945,6038,225,NULL,'',NULL,168471,369,38890,0,'2010-05-12 23:50:01',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167946,6038,368,NULL,'',NULL,168472,369,38890,0,'2010-05-12 23:50:01',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167947,6038,86,NULL,'',NULL,168473,369,38890,0,'2010-05-12 23:50:02',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167948,6038,373,NULL,'def log(line)\r\n # This function logs a line to the log file of the device\r\n log = File.open(\"/var/log/pluto/\" + device_.devid_.to_s + \"_Generic_Serial_Device.log\", \"a\")\r\n log.puts Time.now.to_s + \" (Ruby script):\" + line.to_s\r\n log.close\r\nend\r\n',NULL,168474,369,38890,0,'2010-05-12 23:50:02',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167949,6038,351,NULL,'',NULL,168475,369,38890,0,'2010-05-12 23:50:03',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167950,6038,350,NULL,'buff = \'\'\r\n loop do\r\n buff=conn_.Recv(30,200)\r\n if buff.empty?\r\n log(\'Nothing Received\')\r\n break\r\n end\r\n log(\'Received: \' + Regexp.escape(buff.to_s))\r\n if buff.include?(\"OK\")\r\n log(Regexp.escape(buff.to_s) + \': Command Processed Successfully\')\r\n elsif buff.include?(\"NG\")\r\n log(Regexp.escape(buff.to_s) +\': Command Processed Unsuccessfully\')\r\n end\r\n end \r\n',NULL,168476,369,38890,0,'2010-05-12 23:50:04',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167951,6038,355,NULL,'#Mandingo init Pioneer Elite\r\n\r\ninitok=false\r\n\r\n\r\n# It doesn\'t respond to anything but power on when it\'s off. Before turning it on and off\r\n# See if it responds to something it normally would while it\'s on\r\n\r\nfor iRetry in 0...4\r\n print \"Initializing unit\\n\"\r\n conn_.Send(\"\\r\")\r\n sleep(8)\r\n conn_.Send(\"PO\\r\")\r\n buff = conn_.Recv(100, 4000)\r\n if( (!buff.nil?) && (!buff.include?(\"PWR1\")) )\r\n print \"Initialized ok from off state\\n\"\r\n initok=true\r\n log(\'Initializing unit, system turned on\')\r\n break\r\n else\r\n print \"Failed to initialize\\n\"\r\n log(\'Initializing unit Failed, system is off\')\r\n end\r\n print \"Failed to initialize. Wait 4 secs and try again\\n\"\r\n sleep(4)\r\nend\r\n\r\n\r\nif initok==false\r\n DisableDevice( device_.devid_, true )\r\n print \"The device wouldn\'t respond. Disabling it.\\n\"\r\n log(\'Initialize unit Error, system has been disabled\')\r\n return\r\nend\r\n\r\n$eventCode = { \r\n\r\n\"SR\" => \"Listening Mode\",\r\n\"TO\" => \"Tone Frequency\",\r\n\"B\" => \"Bass Volume\",\r\n\"T\" => \"Treble Volume\",\r\n\"TP\" => \"Tuner Present\",\r\n\"TF\" => \"Tuner Freq\",\r\n\"TB\" => \"Tuner Band\",\r\n\"TC\" => \"Tuner Class\",\r\n\"P\" => \"Power\",\r\n\"AP\" => \"Zone 2 Power\",\r\n\"BP\" => \"Zone 3 Power\",\r\n\"V\" => \"Master Volume\",\r\n\"Z\" => \"Zone 2 Volume\",\r\n\"Y\" => \"Zone 3 Volume\",\r\n\"M\" => \"Mute\",\r\n\"Z2M\" => \"Zone 2 Mute\",\r\n\"Z3M\" => \"Zone 3 Mute\",\r\n\"FN\" => \"Input Change\"\r\n}\r\n\r\n\r\n$inputSources = {\r\n\"BD\" => 996,\r\n\"CD\" => 162,\r\n\"CD-R/TAPE\" => 999,\r\n\"DVD\" => 165,\r\n\"DVR\" => 714,\r\n\"HDMI(cyclic)\" => 1071,\r\n\"HDMI 2\" => 767,\r\n\"HDMI 3\" => 930,\r\n\"HDMI 4\" => 985,\r\n\"HDMI1\" => 984,\r\n\"HOME MEDIA GALLERY\" => 1072,\r\n\"I-POD/USB\" => 997,\r\n\"MULTICHANNEL\" => 881,\r\n\"PHONO\" => 163,\r\n\"SIRIUS\" => 1070,\r\n\"TUNER\" => 166,\r\n\"TV/SAT\" => 998,\r\n\"VIDEO 1\" => 155,\r\n\"VIDEO 2\" => 156,\r\n\"XM\" => 909\r\n}\r\n',NULL,168477,369,38890,0,'2010-05-12 23:50:04',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167952,6038,384,NULL,'',NULL,168478,369,38890,0,'2010-05-12 23:50:05',NULL); INSERT INTO `InfraredGroup_Command` VALUES (167953,6038,356,NULL,'',NULL,168479,369,38890,0,'2010-05-12 23:50:05',NULL); /*!40000 ALTER TABLE `InfraredGroup_Command` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- EOF