-- MySQL dump 9.11 -- -- Host: localhost Database: demo_pd -- ------------------------------------------------------ -- Server version 4.0.27-standard -- -- Table structure for table `perlDesk_accesslog` -- CREATE TABLE perlDesk_accesslog ( id int(11) unsigned NOT NULL auto_increment, user varchar(255) default NULL, ip varchar(255) default NULL, time varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_accesslog` -- INSERT INTO perlDesk_accesslog VALUES (1,'demo','81.157.47.160','1163760695'); INSERT INTO perlDesk_accesslog VALUES (2,'test','61.17.200.73','1197977206'); INSERT INTO perlDesk_accesslog VALUES (3,'gggggg','38.104.28.6','1197990846'); INSERT INTO perlDesk_accesslog VALUES (4,'demo','65.222.95.3','1197997643'); INSERT INTO perlDesk_accesslog VALUES (5,'demo','24.119.60.94','1198000846'); INSERT INTO perlDesk_accesslog VALUES (6,'demo','72.54.148.246','1198003006'); INSERT INTO perlDesk_accesslog VALUES (7,'demo','74.4.20.42','1198006399'); INSERT INTO perlDesk_accesslog VALUES (8,'demo','138.89.101.132','1198009349'); INSERT INTO perlDesk_accesslog VALUES (9,'demo','222.127.250.150','1198016956'); INSERT INTO perlDesk_accesslog VALUES (10,'demo','62.68.201.78','1198017924'); INSERT INTO perlDesk_accesslog VALUES (11,'demo','75.72.229.212','1198040272'); INSERT INTO perlDesk_accesslog VALUES (12,'demo','217.20.18.2','1198061100'); INSERT INTO perlDesk_accesslog VALUES (13,'demo','79.212.200.83','1198061435'); INSERT INTO perlDesk_accesslog VALUES (14,'demo','217.155.45.209','1198063326'); INSERT INTO perlDesk_accesslog VALUES (15,'demo','195.3.110.90','1198077931'); INSERT INTO perlDesk_accesslog VALUES (16,'demo','205.161.244.62','1198082914'); -- -- Table structure for table `perlDesk_activitylog` -- CREATE TABLE perlDesk_activitylog ( id int(11) unsigned NOT NULL auto_increment, cid varchar(255) NOT NULL default '', date varchar(255) NOT NULL default '', user varchar(255) NOT NULL default '', action varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_activitylog` -- INSERT INTO perlDesk_activitylog VALUES (1,'1','17-11-2006-04:46','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (2,'2','17-11-2006-04:52','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (3,'3','17-11-2006-04:53','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (4,'4','17-11-2006-04:56','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (5,'4','17-11-2006-04:59','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (6,'5','17-11-2006-05:08','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (7,'6','17-11-2006-05:13','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (8,'7','18-9-2007-12:30','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (9,'8','30-11-2007-10:26','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (10,'9','30-11-2007-10:27','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (11,'10','30-11-2007-10:29','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (12,'11','30-11-2007-10:32','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (13,'1','30-11-2007-11:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (14,'6','7-12-2007-00:04','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (15,'3','7-12-2007-00:04','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (16,'2','7-12-2007-00:04','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (17,'12','7-12-2007-00:06','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (18,'13','7-12-2007-00:06','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (19,'14','7-12-2007-00:08','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (20,'15','7-12-2007-00:14','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (21,'16','18-12-2007-05:54','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (22,'17','18-12-2007-07:47','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (23,'18','18-12-2007-09:13','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (24,'19','18-12-2007-09:14','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (25,'19','18-12-2007-09:15','Staff: staff','staff Claimed Ownership'); INSERT INTO perlDesk_activitylog VALUES (26,'20','18-12-2007-09:42','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (27,'13','18-12-2007-11:14','Staff: staff','Status Changed: HOLD'); INSERT INTO perlDesk_activitylog VALUES (28,'21','18-12-2007-11:59','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (29,'21','18-12-2007-12:04','Staff staff','Request Assigned Internal (Supportstaff)'); INSERT INTO perlDesk_activitylog VALUES (30,'17','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (31,'17','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (32,'18','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (33,'18','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (34,'20','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (35,'20','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (36,'21','18-12-2007-12:07','Staff: staff','staff Claimed Ownership'); INSERT INTO perlDesk_activitylog VALUES (37,'21','18-12-2007-12:07','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (38,'19','18-12-2007-12:12','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (39,'12','18-12-2007-12:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (40,'13','18-12-2007-12:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (41,'14','18-12-2007-12:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (42,'15','18-12-2007-12:13','Staff: staff','Status Changed: HOLD'); INSERT INTO perlDesk_activitylog VALUES (43,'16','18-12-2007-12:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (44,'22','18-12-2007-13:00','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (45,'23','18-12-2007-13:31','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (46,'22','18-12-2007-14:29','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (47,'22','18-12-2007-14:29','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (48,'23','18-12-2007-14:29','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (49,'23','18-12-2007-14:29','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (50,'24','18-12-2007-16:45','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (51,'24','18-12-2007-22:05','Staff staff','Request Assigned Internal (Supporthelpme)'); INSERT INTO perlDesk_activitylog VALUES (52,'25','19-12-2007-02:29','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (53,'26','19-12-2007-04:14','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (54,'27','19-12-2007-04:22','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (55,'28','19-12-2007-05:33','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (56,'25','19-12-2007-06:12','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (57,'29','19-12-2007-08:45','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (58,'29','19-12-2007-08:46','Staff: staff','Status Changed: HOLD'); INSERT INTO perlDesk_activitylog VALUES (59,'29','19-12-2007-08:54','Staff: staff','staff Claimed Ownership'); INSERT INTO perlDesk_activitylog VALUES (60,'29','19-12-2007-08:57','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (61,'29','19-12-2007-08:57','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (62,'30','19-12-2007-09:14','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (63,'15','19-12-2007-11:01','Staff staff','Request Assigned Internal (Supportstaff)'); INSERT INTO perlDesk_activitylog VALUES (64,'31','19-12-2007-12:18','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (65,'26','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (66,'27','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (67,'27','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (68,'28','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (69,'28','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (70,'30','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (71,'30','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (72,'31','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (73,'31','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (74,'25','19-12-2007-12:51','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (75,'25','19-12-2007-12:51','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (76,'17','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (77,'18','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (78,'20','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (79,'22','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (80,'25','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (81,'27','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (82,'28','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (83,'30','19-12-2007-12:53','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (84,'31','19-12-2007-12:53','Staff: staff','Status Changed: DELETED'); -- -- Table structure for table `perlDesk_announce` -- CREATE TABLE perlDesk_announce ( id int(11) unsigned NOT NULL auto_increment, author varchar(255) default NULL, subject varchar(255) default NULL, message text, staff char(1) default NULL, users char(1) default NULL, time varchar(16) default NULL, display_until varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_announce` -- INSERT INTO perlDesk_announce VALUES (1,'admin','Example news posting','This is great!!!!\r
','0','1','17-11-2006-04:58',NULL); INSERT INTO perlDesk_announce VALUES (2,'admin','Example Announcement','This is an example announcement posted by the administrator!','1','','30-11-2007-11:14',NULL); -- -- Table structure for table `perlDesk_blocked_email` -- CREATE TABLE perlDesk_blocked_email ( id int(11) unsigned NOT NULL auto_increment, address varchar(255) NOT NULL default '', type varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_blocked_email` -- -- -- Table structure for table `perlDesk_call_fields` -- CREATE TABLE perlDesk_call_fields ( id int(11) unsigned NOT NULL auto_increment, cid varchar(255) default NULL, fid varchar(255) default NULL, value text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_call_fields` -- INSERT INTO perlDesk_call_fields VALUES (1,'2','1','demo'); INSERT INTO perlDesk_call_fields VALUES (2,'3','1','demo'); INSERT INTO perlDesk_call_fields VALUES (3,'4','1','demo'); INSERT INTO perlDesk_call_fields VALUES (4,'5','1','wqeq'); INSERT INTO perlDesk_call_fields VALUES (5,'8','1',''); INSERT INTO perlDesk_call_fields VALUES (6,'9','1',''); INSERT INTO perlDesk_call_fields VALUES (7,'19','1','g'); INSERT INTO perlDesk_call_fields VALUES (8,'24','1','bedford'); -- -- Table structure for table `perlDesk_callrules` -- CREATE TABLE perlDesk_callrules ( id int(11) unsigned NOT NULL auto_increment, rule int(11) NOT NULL default '0', type text, value text, param text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_callrules` -- INSERT INTO perlDesk_callrules VALUES (1,1170894417,'match','department','Support'); INSERT INTO perlDesk_callrules VALUES (2,1170894417,'match','unanswered','24'); INSERT INTO perlDesk_callrules VALUES (3,1170894417,'action','notifyowner','on'); -- -- Table structure for table `perlDesk_calls` -- CREATE TABLE perlDesk_calls ( id int(11) unsigned NOT NULL auto_increment, status enum('OPEN','CLOSED','HOLD','DELETED') NOT NULL default 'OPEN', username varchar(30) default NULL, email varchar(255) default NULL, priority char(1) default NULL, category varchar(255) default NULL, subject varchar(255) default NULL, description text, time varchar(20) default NULL, ownership varchar(255) default NULL, closedby varchar(255) default NULL, method char(2) default NULL, track varchar(50) NOT NULL default '', active varchar(50) NOT NULL default '', aw char(1) default NULL, an char(1) NOT NULL default '', time_spent varchar(255) NOT NULL default '', sub_status text, is_locked int(11) NOT NULL default '0', ikey varchar(255) NOT NULL default '', close_timer int(11) default NULL, lock_time int(11) default NULL, due_date datetime default NULL, color varchar(255) default NULL, PRIMARY KEY (id), KEY status (status) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_calls` -- INSERT INTO perlDesk_calls VALUES (1,'CLOSED','Unregistered','j.bennett@logicnow.com','3','1','Example Emailed Ticket','This is an example ticket sent to perldesk@logicdemo.com which is setup \nto go into the Support department.\n\nperldesk2@logicdemo.com is setup to go to the Billing Department..\n\ngive it a try!\n\n\n','17-11-2006-04:46','Unowned','staff','em','1163760404','1163760404','1','1','0',NULL,0,'A5SOprAX3y',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (2,'CLOSED','demo','demo@perldesk.com','3','1','Printer Problems','Hi\r\n\r\nI am having trouble with my printer, it keeps getting stuck and jamming.\r\n\r\nAny help?','17-11-2006-04:52','Unowned','staff','hd','1163760730','1163761384','1','1','0',NULL,0,'mCM9kohDaM',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (3,'CLOSED','demo','demo@perldesk.com','3','2','Billing Problem','Hi\r\n\r\nI have been double billed for September, please check this!\r\n\r\nThanks','17-11-2006-04:53','Unowned','staff','hd','1163760808','1163761420','1','1','0',NULL,2,'ygFaf2Cqse',NULL,1163761447,NULL,NULL); INSERT INTO perlDesk_calls VALUES (4,'DELETED','demo','demo@perldesk.com','3','2','Billing Problem','Hi\r\n\r\nI have been double billed for September, please check this!\r\n\r\nThanks','17-11-2006-04:56','Unowned',NULL,'hd','1163761005','1163761005','1','0','0',NULL,0,'stD377gn20',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (6,'CLOSED','Unregistered','j.bennett@logicnow.com','3','2','test','test\n\n','17-11-2006-05:13','Unowned','staff','em','1163761985','1163762060','0','1','0',NULL,0,'jsbleXt3Id',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (12,'CLOSED','Unregistered','j.bennett@logicnow.com','1','1','Example Emailed Ticket\n','This is an example of a ticket created from an email, try it yourself! \nSend an email to perldesk@logicdemo.com and it will be picked up by this \ninstallation. You can then test the response and management of your own \nticket via the PerlDesk interface.\n\nEmail integration works by POP3 (like a normal mail client) or via email \npiping if you are using a Linux based OS.\n\n\n\n','7-12-2007-00:06','','staff','em','1197007579','1197007834','0','1','0','CREATED',0,'hmIgVEnt1d',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (13,'CLOSED','Unregistered','j.bennett@logicnow.com','2','1','Printer is not working\n','I am having trouble with my printer...\n\n','7-12-2007-00:06','staff','staff','em','1197007610','1197992258','0','1','0','CREATED',2,'WbLuJoJRsJ',1198597058,1197992290,'2007-12-18 23:59:59',NULL); INSERT INTO perlDesk_calls VALUES (14,'CLOSED','Unregistered','j.bennett@logicnow.com','3','1','Domain not resolving\n','Another example ticket.\n\nUsing the ticket management interface you can assign a ticket to other \nstaff by clicking the 'Assign' button, alternatively you can respond and \nmanage it yourself. Once resolved, you can mark the ticket as CLOSED and \nit will be removed from the Unresolved listing, and archived in the \nResolved responses.\n\n\n\n\n\n','7-12-2007-00:08','','staff','em','1197007700','1197007700','1','1','0','CREATED',2,'05nSGJ8sXd',NULL,1197992250,NULL,NULL); INSERT INTO perlDesk_calls VALUES (15,'HOLD','Unregistered','j.bennett@logicnow.com','3','1','THIS DEMO IS RESET EVERY HOUR\n','Please note during testing that this demonstration install is reset \nhourly and test data is removed.\n\n\n\n','7-12-2007-00:14','staff',NULL,'em','1197008092','1197008092','1','0','0','CREATED',2,'gRWewXCQhe',NULL,1198070197,NULL,NULL); INSERT INTO perlDesk_calls VALUES (16,'CLOSED','Unregistered','logicnow@gmail.com','3','1','test\n','test\n\n-- \n-- \nJohn Bennett\nManaging Director\nLogicNow Limited\n','18-12-2007-05:54','','staff','em','1197978860','1197978860','1','1','0','CREATED',2,'vP7ZHUpYnn',NULL,1197987865,NULL,NULL); INSERT INTO perlDesk_calls VALUES (19,'DELETED','gggggg','g@mail.com','3','2','New Ticket','what can I see as a customer','18-12-2007-09:14','staff',NULL,'hd','1197990875','1198001815','1','0','0','CREATED',0,'NOPATR',1198606270,0,'2007-12-18 23:59:59',NULL); INSERT INTO perlDesk_calls VALUES (21,'CLOSED','Unregistered','ChrisC@palacecasinoresort.com','3','1','printer\n','The printer on pc043 isn\'t working again.\r\n\r\n \r\n\r\nChristopher M. Carus\r\n\r\nDirector of MIS\r\n\r\nPalace Casino Resort\r\n\r\n228-386-2148\r\n\r\n\r\n\r\n**********************************************************************\r\nThis email and any files transmitted with it are confidential and \r\nintended solely for the use of the individual or entity to whom they \r\nare addressed. If you have received this email in error please \r\nreply to the sender of the message and or remove it from any and\r\nall systems it may have been received on. This footnote also confirms that this email message has been \r\nscanned for the presence of computer viruses.\r\n**********************************************************************\r\n\n\n[ Call last edited by staff: 18-12-2007-12:08 ]','18-12-2007-11:59','staff','staff','em','1198000770','1198001208','0','1','0','CREATED',0,'4x4bMk3c1c',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (29,'DELETED','Unregistered','jimkos@gmail.com','4','1','Hello\n','Hello again---\n\nthis is a TEST\n\n','19-12-2007-08:45','staff',NULL,'em','1198075526','1198075654','0','0','0','CREATED',2,'MQ8HXh4w7I',1198680454,1198075781,'2007-12-19 23:59:59',NULL); INSERT INTO perlDesk_calls VALUES (24,'OPEN','demo','demo@perldesk.com','3','1','test','test','18-12-2007-16:45','helpme',NULL,'hd','1198017950','1198017950','1','0','0','CREATED',0,'XLWHTD',NULL,NULL,NULL,NULL); -- -- Table structure for table `perlDesk_chat` -- CREATE TABLE perlDesk_chat ( id int(11) unsigned NOT NULL auto_increment, session_id int(11) unsigned default NULL, time timestamp(14) NOT NULL, username varchar(30) default NULL, staffname varchar(20) default NULL, department varchar(255) default NULL, direction int(11) NOT NULL default '0', type int(11) NOT NULL default '0', status int(11) NOT NULL default '0', message text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_chat` -- INSERT INTO perlDesk_chat VALUES (1,1,20061117051015,'demo',NULL,'Billing',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (2,1,20061117051022,'demo','staff','Billing',1,1,0,'chat request accepted'); INSERT INTO perlDesk_chat VALUES (3,1,20061117051024,'demo','staff','Billing',1,0,0,'hi demo\n'); INSERT INTO perlDesk_chat VALUES (4,1,20061117051032,'demo','staff','Billing',0,0,0,'hi\n'); INSERT INTO perlDesk_chat VALUES (5,1,20061117051039,'demo','staff','Billing',1,0,0,'how are you?\n'); INSERT INTO perlDesk_chat VALUES (6,1,20061117051047,'demo','staff','Billing',0,0,0,'good, you?\n'); INSERT INTO perlDesk_chat VALUES (7,1,20061117051054,'demo','staff','Billing',0,0,0,'good\n'); INSERT INTO perlDesk_chat VALUES (8,1,20061117051059,'demo','staff','Billing',0,0,0,'.\n'); INSERT INTO perlDesk_chat VALUES (9,1,20061117051105,'demo','staff','Billing',0,0,0,'.\n'); INSERT INTO perlDesk_chat VALUES (10,1,20061117051114,'demo','staff','Billing',1,0,0,'go away\n'); INSERT INTO perlDesk_chat VALUES (11,1,20061117051120,'demo','staff','Billing',0,0,0,'ok\n'); INSERT INTO perlDesk_chat VALUES (12,1,20061117051125,'demo','staff','Billing',1,1,0,'Session closed by staff'); INSERT INTO perlDesk_chat VALUES (13,2,20071218071136,'guest58701',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (14,2,20071218071158,'guest58701',NULL,'Support',0,0,0,'HELLO\r\n'); INSERT INTO perlDesk_chat VALUES (15,2,20071218071234,'guest58701',NULL,'Support',0,0,0,'ARE YOU STILL THERE\r\n'); INSERT INTO perlDesk_chat VALUES (16,2,20071218071236,'guest58701',NULL,'Support',0,1,0,'chat request canceled by timeout'); INSERT INTO perlDesk_chat VALUES (17,3,20071218115208,'guest15477',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (18,3,20071218115214,'guest15477',NULL,'Support',0,0,0,'hi ..\n'); INSERT INTO perlDesk_chat VALUES (19,3,20071218115222,'guest15477',NULL,'Support',0,1,0,'chat request canceled by user'); INSERT INTO perlDesk_chat VALUES (20,4,20071218124123,'guest34626',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (21,4,20071218125627,'guest34626',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); INSERT INTO perlDesk_chat VALUES (22,5,20071218132350,'guest74145',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (23,5,20071218133856,'guest74145',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); INSERT INTO perlDesk_chat VALUES (24,6,20071218153450,'guest97142',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (25,6,20071218153454,'guest97142',NULL,'Support',0,0,0,'hi\r\n'); INSERT INTO perlDesk_chat VALUES (26,7,20071218160959,'guest82347',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (27,7,20071218161008,'guest82347',NULL,'Support',0,0,0,'test\n'); INSERT INTO perlDesk_chat VALUES (28,7,20071218161011,'guest82347',NULL,'Support',0,1,0,'chat request canceled by user'); INSERT INTO perlDesk_chat VALUES (29,6,20071218161100,'guest97142',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); INSERT INTO perlDesk_chat VALUES (30,8,20071218203632,'guest92486',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (31,8,20071218210541,'guest92486',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); INSERT INTO perlDesk_chat VALUES (32,9,20071219000634,'guest42789',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (33,9,20071219000641,'guest42789',NULL,'Support',0,1,0,'chat request canceled by user'); INSERT INTO perlDesk_chat VALUES (34,10,20071219111006,'guest95926',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (35,10,20071219114131,'guest95926',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); -- -- Table structure for table `perlDesk_chatsession` -- CREATE TABLE perlDesk_chatsession ( id int(11) unsigned NOT NULL auto_increment, time timestamp(14) NOT NULL, activity timestamp(14) NOT NULL default '00000000000000', username varchar(30) default NULL, staffname varchar(20) default NULL, department varchar(255) default NULL, state text, message text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_chatsession` -- INSERT INTO perlDesk_chatsession VALUES (1,20061117051015,20061117051131,'demo','staff','Billing','close','session closed by staff'); INSERT INTO perlDesk_chatsession VALUES (2,20071218071136,20071218071236,'guest58701',NULL,'Support','cancel','chat request canceled by timeout'); INSERT INTO perlDesk_chatsession VALUES (3,20071218115208,20071218115222,'guest15477',NULL,'Support','cancel','chat request canceled by user'); INSERT INTO perlDesk_chatsession VALUES (4,20071218124123,20071218124123,'guest34626',NULL,'Support','closing','session closed (inactivity timeout)'); INSERT INTO perlDesk_chatsession VALUES (5,20071218132350,20071218132350,'guest74145',NULL,'Support','closing','session closed (inactivity timeout)'); INSERT INTO perlDesk_chatsession VALUES (6,20071218153450,20071218153454,'guest97142',NULL,'Support','closing','session closed (inactivity timeout)'); INSERT INTO perlDesk_chatsession VALUES (7,20071218160959,20071218161011,'guest82347',NULL,'Support','cancel','chat request canceled by user'); INSERT INTO perlDesk_chatsession VALUES (8,20071218203632,20071218203632,'guest92486',NULL,'Support','closing','session closed (inactivity timeout)'); INSERT INTO perlDesk_chatsession VALUES (9,20071219000634,20071219000641,'guest42789',NULL,'Support','cancel','chat request canceled by user'); INSERT INTO perlDesk_chatsession VALUES (10,20071219111006,20071219111006,'guest95926',NULL,'Support','closing','session closed (inactivity timeout)'); -- -- Table structure for table `perlDesk_contacts` -- CREATE TABLE perlDesk_contacts ( id int(11) unsigned NOT NULL auto_increment, staff int(11) NOT NULL default '0', name varchar(50) NOT NULL default '', company varchar(50) NOT NULL default '', address varchar(255) NOT NULL default '', email varchar(90) NOT NULL default '', phone varchar(19) default NULL, url varchar(90) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_contacts` -- -- -- Table structure for table `perlDesk_cronrules` -- CREATE TABLE perlDesk_cronrules ( id int(11) unsigned NOT NULL auto_increment, period int(11) NOT NULL default '0', action text, lastrun int(11) NOT NULL default '0', lastcheck int(11) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_cronrules` -- INSERT INTO perlDesk_cronrules VALUES (1,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (2,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (3,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (4,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (5,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (6,1800,'check_calls',0,0); -- -- Table structure for table `perlDesk_debug` -- CREATE TABLE perlDesk_debug ( id int(11) unsigned NOT NULL auto_increment, time timestamp(14) NOT NULL, priority varchar(10) default NULL, category varchar(25) default NULL, file varchar(50) default NULL, function varchar(50) default NULL, message varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_debug` -- INSERT INTO perlDesk_debug VALUES (1,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_db_level missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (2,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_stderr_level missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (3,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_directory missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (4,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_debug_file missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (5,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_mail_file missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (6,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_mailin missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (7,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_mailout missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (8,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_fatal_mail missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (9,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (10,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Test ticket'); INSERT INTO perlDesk_debug VALUES (11,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (12,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: zmeizz@gmail.com'); INSERT INTO perlDesk_debug VALUES (13,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: \"perldesk@logicdemo.com\" '); INSERT INTO perlDesk_debug VALUES (14,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (15,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: zmeizz@gmail.com with subject \'{100-16} Test ticket\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (16,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (17,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (18,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Test 2 ticket'); INSERT INTO perlDesk_debug VALUES (19,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (20,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: zmeizz@gmail.com'); INSERT INTO perlDesk_debug VALUES (21,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk2@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (22,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (23,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: zmeizz@gmail.com with subject \'{100-17} Test 2 ticket\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (24,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (25,20071212155802,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: zmeizz@gmail.com with subject \'{100-16} RE: Test ticket\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (26,20071212155802,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (27,20071212161332,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: alhena@alhena.poznan.pl with subject \'Help Desk Registration\' using template \'user_welcome.email\''); INSERT INTO perlDesk_debug VALUES (28,20071212161333,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (29,20071212161333,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa12012c)\', \'P'); INSERT INTO perlDesk_debug VALUES (30,20071212161333,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'register2\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::'); INSERT INTO perlDesk_debug VALUES (31,20071212161449,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: alhena@alhena.poznan.pl with subject \'{100-16} Cos tam cos tam\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (32,20071212161449,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (33,20071212161449,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa67998c)\', \'P'); INSERT INTO perlDesk_debug VALUES (34,20071212161449,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (35,20071212161639,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: alhena@alhena.poznan.pl with subject \'{100-16} RE: Cos tam cos tam\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (36,20071212161639,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (37,20071212161639,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x95da480)\', \'P'); INSERT INTO perlDesk_debug VALUES (38,20071212161639,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'addnote\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Aja'); INSERT INTO perlDesk_debug VALUES (39,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (40,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test 5'); INSERT INTO perlDesk_debug VALUES (41,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (42,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: mbhatt@capitalc.ca'); INSERT INTO perlDesk_debug VALUES (43,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (44,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (45,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: mbhatt@capitalc.ca with subject \'{100-17} test 5\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (46,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (47,20071212163809,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: syt2212@mobyportal.com with subject \'{100-18} red wing slipper socks\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (48,20071212163809,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (49,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (50,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: HW: DILBERT - Printer is making knocking sounds'); INSERT INTO perlDesk_debug VALUES (51,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (52,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: jodonnell@mhalaw.com'); INSERT INTO perlDesk_debug VALUES (53,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (54,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 19'); INSERT INTO perlDesk_debug VALUES (55,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: jodonnell@mhalaw.com with subject \'{100-19} HW: DILBERT - Printer is making knocking sounds\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (56,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (57,20071212164632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #19 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (58,20071212164632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (59,20071212164730,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: jodonnell@mhalaw.com with subject \'{100-19} RE: HW: DILBERT - Printer is making knocking sounds\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (60,20071212164730,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (61,20071212170551,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #1 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (62,20071212170551,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (63,20071212170551,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x8f3acb8)\', \'P'); INSERT INTO perlDesk_debug VALUES (64,20071212170551,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'movedep\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at staff.cgi line 31\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::St'); INSERT INTO perlDesk_debug VALUES (65,20071212172914,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: fartoviy12345@mail.ru with subject \'{100-16} New super Sites\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (66,20071212172914,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (67,20071212172914,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa28b99c)\', \'P'); INSERT INTO perlDesk_debug VALUES (68,20071212172914,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (69,20071212172938,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: dasinonus@dasinonus.com with subject \'{100-17} Casino Bonus\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (70,20071212172938,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (71,20071212172938,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x9be769c)\', \'P'); INSERT INTO perlDesk_debug VALUES (72,20071212172938,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (73,20071212180429,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: meryacure@mymail-in.net with subject \'{100-16} A bukkake gallery on this one \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (74,20071212180429,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (75,20071212180429,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa1d349c)\', \'P'); INSERT INTO perlDesk_debug VALUES (76,20071212180429,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (77,20071212180444,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: erafiterric@mymail-in.net with subject \'{100-17} A redhead in school uniforms \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (78,20071212180444,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (79,20071212180444,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa877bbc)\', \'P'); INSERT INTO perlDesk_debug VALUES (80,20071212180444,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (81,20071212180452,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: noissuslybymn@mymail-in.net with subject \'{100-18} A pregnant girl blowing two friends \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (82,20071212180452,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (83,20071212180452,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x9e55a64)\', \'P'); INSERT INTO perlDesk_debug VALUES (84,20071212180452,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (85,20071212180504,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: honsgogyhok@mymail-in.net with subject \'{100-19} Girls toying and fingering \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (86,20071212180504,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (87,20071212180504,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x8b49c3c)\', \'P'); INSERT INTO perlDesk_debug VALUES (88,20071212180504,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (89,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (90,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Where have you been?'); INSERT INTO perlDesk_debug VALUES (91,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <01c83d63$87d50380$6ab58dd3@a-alcher>'); INSERT INTO perlDesk_debug VALUES (92,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: a-alcher@abinanti.com'); INSERT INTO perlDesk_debug VALUES (93,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (94,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 20'); INSERT INTO perlDesk_debug VALUES (95,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: a-alcher@abinanti.com with subject \'{100-20} {Spam?} Where have you been?\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (96,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (97,20071212183839,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: dogswregade@mymail-in.net with subject \'{100-21} A busty girl in the bathroom \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (98,20071212183839,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (99,20071212184526,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: 848ut@was.com with subject \'{100-22} buy cialis online viagra\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (100,20071212184526,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (101,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (102,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: (no subject)'); INSERT INTO perlDesk_debug VALUES (103,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (104,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: Khalif926@aol.com'); INSERT INTO perlDesk_debug VALUES (105,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (106,20071212204142,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112, line 87.\n at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112\n '); INSERT INTO perlDesk_debug VALUES (107,20071212205923,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: dest142@mobyportal.com with subject \'{100-17} sony ericsson mobile accessory, accessory cell dash mobile phone t\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (108,20071212205923,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (109,20071212210953,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: b3@twiins.cn with subject \'{100-16} hairy amateur teens super hairy girls \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (110,20071212210953,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (111,20071212210953,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa7efb7c)\', \'P'); INSERT INTO perlDesk_debug VALUES (112,20071212210953,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (113,20071212212943,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} Request closed: Printer is not working\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (114,20071212212943,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (115,20071212223851,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: b1@twiins.cn with subject \'{100-16} nylon fetish groups on yahoo a lady in nylon stocking \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (116,20071212223851,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (117,20071212223851,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x8ff2580)\', \'P'); INSERT INTO perlDesk_debug VALUES (118,20071212223851,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (119,20071212223956,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: adsad@ww.de with subject \'{100-17} sdaad\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (120,20071212223956,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (121,20071212235353,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: francesca@onlymail.ru with subject \'{100-16} Girls with onion booties\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (122,20071212235353,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (123,20071213000830,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'lpass〈=en\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0xa1a9dc0)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (124,20071213001205,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: montreal@epage.ru with subject \'{100-16} Charlie Laine 481 pics\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (125,20071213001205,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (126,20071213001205,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa52544c)\', \'P'); INSERT INTO perlDesk_debug VALUES (127,20071213001205,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (128,20071213002657,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: demo@perldesk.com with subject \'{100-17} BUG\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (129,20071213002657,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (130,20071213002657,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x9b909a8)\', \'P'); INSERT INTO perlDesk_debug VALUES (131,20071213002657,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (132,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (133,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} {Disarmed} [IstanbulGeziKulubu] Kurban Bayramý Ozel : 20-23 Aralýk Marmaris Dalyan Datca 4 Gun 3 Gece Full Eglence ve Doga Gezisi'); INSERT INTO perlDesk_debug VALUES (134,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <159551.67915.qm@web50302.mail.re2.yahoo.com>'); INSERT INTO perlDesk_debug VALUES (135,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: caglayang@yahoo.com'); INSERT INTO perlDesk_debug VALUES (136,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: izmirgezikulubu@yahoogroups.com'); INSERT INTO perlDesk_debug VALUES (137,20071213022856,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 482.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::'); INSERT INTO perlDesk_debug VALUES (138,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (139,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Disarmed} [IstanbulGeziKulubu] Izmir Gezi Kulubu Marmariste Istanbul Gezi Kulubu uyeleriyle beraber 3 Gece 4 Gun Muhtesem Gezide'); INSERT INTO perlDesk_debug VALUES (140,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <454795.98340.qm@web50301.mail.re2.yahoo.com>'); INSERT INTO perlDesk_debug VALUES (141,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: caglayang@yahoo.com'); INSERT INTO perlDesk_debug VALUES (142,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: izmirgezikulubu@yahoogroups.com,\n Istanbulgezikulubu Kulubu '); INSERT INTO perlDesk_debug VALUES (143,20071213031901,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 438.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::'); INSERT INTO perlDesk_debug VALUES (144,20071213040255,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: demo@perldesk.com with subject \'{100-16} Big problem\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (145,20071213040257,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (146,20071213040257,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x8a21954)\', \'P'); INSERT INTO perlDesk_debug VALUES (147,20071213040257,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (148,20071213040317,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: demo@perldesk.com with subject \'{100-17} Big problem\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (149,20071213040317,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (150,20071213040317,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa63c9bc)\', \'P'); INSERT INTO perlDesk_debug VALUES (151,20071213040317,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (152,20071213040344,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: test@ermite.com with subject \'{100-18} Big problem\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (153,20071213040347,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (154,20071213040347,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x93b09bc)\', \'P'); INSERT INTO perlDesk_debug VALUES (155,20071213040347,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (156,20071213045503,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x98c5c98)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (157,20071213045710,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x9abbda4)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (158,20071213051745,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x8d06da4)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (159,20071213051919,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x9914da4)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (160,20071213052120,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x9766da4)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (161,20071213054538,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x8dd0c98)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (162,20071213055223,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: nataliaor@fromru.com with subject \'{100-16} 001 Tramadol New TraMADOL Pillrun Number One Nextday Best Tramadol Pharmacy Go Cheaps Tramadol Casino Fioricet Search Engine Carisoprodol'); INSERT INTO perlDesk_debug VALUES (163,20071213055224,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (164,20071213061143,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: grapp@axigenmail.com with subject \'{100-16} Successo\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (165,20071213061144,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (166,20071213061144,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x93985d4)\', \'P'); INSERT INTO perlDesk_debug VALUES (167,20071213061144,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (168,20071213061719,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x8d55c98)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (169,20071213062621,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x955cc98)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (170,20071213083048,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: bbntbbbn@mail.ru with subject \'{100-16} New and very cool\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (171,20071213083048,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (172,20071213083048,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa2959e4)\', \'P'); INSERT INTO perlDesk_debug VALUES (173,20071213083048,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (174,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (175,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Trackstick GPS device now available at Earth Products and Accessories'); INSERT INTO perlDesk_debug VALUES (176,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <20071213063910.2086414062@gearthstore.com>'); INSERT INTO perlDesk_debug VALUES (177,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: sales@gearthstore.com'); INSERT INTO perlDesk_debug VALUES (178,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (179,20071213084138,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (180,20071213084138,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: sales@gearthstore.com with subject \'{100-17} {Spam?} Trackstick GPS device now available at Earth Products and Accessories\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (181,20071213084138,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (182,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (183,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: dsfsdf'); INSERT INTO perlDesk_debug VALUES (184,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <47614DEE.3020307@logicnow.com>'); INSERT INTO perlDesk_debug VALUES (185,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: j.bennett@logicnow.com'); INSERT INTO perlDesk_debug VALUES (186,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: Support '); INSERT INTO perlDesk_debug VALUES (187,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (188,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-16} dsfsdf\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (189,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (190,20071213092503,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: wikes@toysrus.com with subject \'Help Desk Registration\' using template \'user_welcome.email\''); INSERT INTO perlDesk_debug VALUES (191,20071213092503,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (192,20071213093733,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-16} Request closed: dsfsdf\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (193,20071213093733,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (194,20071213093743,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-16} Request closed: dsfsdf\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (195,20071213093743,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (196,20071213094337,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #12 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (197,20071213094337,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (198,20071213094747,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-12} Request closed: Example Emailed Ticket\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (199,20071213094747,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (200,20071213095609,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (201,20071213095610,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} {Disarmed} [IstanbulGeziKulubu] Gezi : SULEYMANIYE - VEFA Tarih Kultur Gezisi 16 Aralýk Pazar ( Sevdiklerinizle ve Kulup uyeleriyle gunu anýya cevirin )'); INSERT INTO perlDesk_debug VALUES (202,20071213095610,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <899476.2639.qm@web38202.mail.mud.yahoo.com>'); INSERT INTO perlDesk_debug VALUES (203,20071213095610,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: travel.terminal@yahoo.com'); INSERT INTO perlDesk_debug VALUES (204,20071213095610,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: istanbulgezikulubu@yahoogroups.com, gezikulubu@yahoogroups.com'); INSERT INTO perlDesk_debug VALUES (205,20071213095610,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 501.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::'); INSERT INTO perlDesk_debug VALUES (206,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} Request closed: Printer is not working\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (207,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (208,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-14} Request closed: Domain not resolving\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (209,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (210,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-15} Request closed: THIS DEMO IS RESET EVERY HOUR\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (211,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (212,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-16} Request closed: dsfsdf\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (213,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (214,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (215,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} CIAL1S - From a pharmacy that believes in providing excellent services and the cheapest pr1ces'); INSERT INTO perlDesk_debug VALUES (216,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <000a01c83da1$043c88fa$03d9319f@ugghx>'); INSERT INTO perlDesk_debug VALUES (217,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: maryann73@nokia.com'); INSERT INTO perlDesk_debug VALUES (218,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (219,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (220,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: maryann73@nokia.com with subject \'{100-16} {Spam?} CIAL1S - From a pharmacy that believes in providing excellent services and the cheapest pr1ces\n\' using template \'user_newcall.email'); INSERT INTO perlDesk_debug VALUES (221,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (222,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (223,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Beat all the records with our new size'); INSERT INTO perlDesk_debug VALUES (224,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <430231021.16547119320493@ldneqt.eq.gs.com>'); INSERT INTO perlDesk_debug VALUES (225,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: tello@ldneqt.eq.gs.com'); INSERT INTO perlDesk_debug VALUES (226,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: staff@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (227,20071213102337,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 56.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (228,20071213102752,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} RE: Printer is not working\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (229,20071213102752,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (230,20071213102808,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} RE: Printer is not working\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (231,20071213102808,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (232,20071213110112,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'submit_ticket〈\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0xa2b8cd8)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (233,20071213110533,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (234,20071213110534,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Testing 3333'); INSERT INTO perlDesk_debug VALUES (235,20071213110534,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <98B56B44090B3247A97660D27D069C9C0553ECBC@hqexch1.hq.escription.com>'); INSERT INTO perlDesk_debug VALUES (236,20071213110534,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: george.peguero@escription.com'); INSERT INTO perlDesk_debug VALUES (237,20071213110534,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (238,20071213110534,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112, line 179.\n at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112\n'); INSERT INTO perlDesk_debug VALUES (239,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (240,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Paradise is here!'); INSERT INTO perlDesk_debug VALUES (241,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <59833.eung@tzuwang>'); INSERT INTO perlDesk_debug VALUES (242,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: jorgen@sfr.net'); INSERT INTO perlDesk_debug VALUES (243,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: \"Gift of $2400\" '); INSERT INTO perlDesk_debug VALUES (244,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (245,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: jorgen@sfr.net with subject \'{100-17} {Spam?} Paradise is here!\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (246,20071213112046,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (247,20071213113035,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Quantifier follows nothing in regex; marked by <-- HERE in m/* <-- HERE / at lib/PerlDesk/App/Staff.pm line 2320.\n at lib/PerlDesk/App/Staff.pm line 2320\n PerlDesk::App::Staff::lookupresults(\'PerlDesk::App::Staff=HASH(0x886ef04)\') called at extlib/CGI/App'); INSERT INTO perlDesk_debug VALUES (248,20071213113035,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'lookupresults\': Quantifier follows nothing in regex; marked by <-- HERE in m/* <-- HERE / at lib/PerlDesk/App/Staff.pm line 2320.\n at staff.cgi line 31\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (249,20071213113107,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: demo@perldesk.com with subject \'{100-18} 235\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (250,20071213113107,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (251,20071213113157,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-12} RE: Example Emailed Ticket\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (252,20071213113158,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (253,20071213114012,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (254,20071213114013,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test'); INSERT INTO perlDesk_debug VALUES (255,20071213114013,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <711D9C6F9602BC4F81121C4A0788AAA27A0B9C@exchgb1.dsa.reldom.tamu.edu>'); INSERT INTO perlDesk_debug VALUES (256,20071213114013,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: michaelh@housing.tamu.edu'); INSERT INTO perlDesk_debug VALUES (257,20071213114014,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (258,20071213114014,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 19'); INSERT INTO perlDesk_debug VALUES (259,20071213114014,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: michaelh@housing.tamu.edu with subject \'{100-19} test\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (260,20071213114015,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (261,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (262,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test'); INSERT INTO perlDesk_debug VALUES (263,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <47616EDB.7060506@logicnow.com>'); INSERT INTO perlDesk_debug VALUES (264,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: j.bennett@logicnow.com'); INSERT INTO perlDesk_debug VALUES (265,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: Support '); INSERT INTO perlDesk_debug VALUES (266,20071213114412,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112, line 145.\n at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112\n'); INSERT INTO perlDesk_debug VALUES (267,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (268,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: testing'); INSERT INTO perlDesk_debug VALUES (269,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <102D560E-1CCC-4AE0-8930-44DB484CFB65@airshift.tv>'); INSERT INTO perlDesk_debug VALUES (270,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: timo@airshift.tv'); INSERT INTO perlDesk_debug VALUES (271,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (272,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (273,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: timo@airshift.tv with subject \'{100-17} testing\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (274,20071213114516,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (275,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (276,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test'); INSERT INTO perlDesk_debug VALUES (277,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <47617138.4010603@logicnow.com>'); INSERT INTO perlDesk_debug VALUES (278,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: j.bennett@logicnow.com'); INSERT INTO perlDesk_debug VALUES (279,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: Support '); INSERT INTO perlDesk_debug VALUES (280,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 18'); INSERT INTO perlDesk_debug VALUES (281,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-18} test\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (282,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (283,20071213115614,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: demo@perldesk.com with subject \'{100-3} RE: Billing Problem\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (284,20071213115614,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (285,20071213115758,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #14 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (286,20071213115758,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (287,20071213115825,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} Request closed: Printer is not working\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (288,20071213115825,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (289,20071213115949,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: doldenkamp@baptist.edu with subject \'{100-19} test\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (290,20071213115949,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (291,20071213121943,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-12} RE: Example Emailed Ticket\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (292,20071213121943,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (293,20071213123425,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (294,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Êîäèðîâêà'); INSERT INTO perlDesk_debug VALUES (295,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <47617B1B.6060503@mail.ru>'); INSERT INTO perlDesk_debug VALUES (296,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: hard59@mail.ru'); INSERT INTO perlDesk_debug VALUES (297,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (298,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (299,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: hard59@mail.ru with subject \'{100-16} {Spam?} Êîäèðîâêà\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (300,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (301,20071213123909,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (302,20071213123909,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Trying'); INSERT INTO perlDesk_debug VALUES (303,20071213123909,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <02f001c83db7$62f2d4d0$1a00a8c0@hosted.intercity.cl>'); INSERT INTO perlDesk_debug VALUES (304,20071213123909,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: claudio@intercity.net'); INSERT INTO perlDesk_debug VALUES (305,20071213123910,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (306,20071213123910,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (307,20071213123910,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: claudio@intercity.net with subject \'{100-17} Trying\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (308,20071213123910,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (309,20071213124535,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (310,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} aa'); INSERT INTO perlDesk_debug VALUES (311,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <021201c83db8$4884f910$d98eeb30$@net>'); INSERT INTO perlDesk_debug VALUES (312,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: dave@totalpayroll.net'); INSERT INTO perlDesk_debug VALUES (313,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (314,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 18'); INSERT INTO perlDesk_debug VALUES (315,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: dave@totalpayroll.net with subject \'{100-18} {Spam?} aa\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (316,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (317,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (318,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: (no subject)'); INSERT INTO perlDesk_debug VALUES (319,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (320,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: Khalif926@aol.com'); INSERT INTO perlDesk_debug VALUES (321,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (322,20071213125951,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112, line 72.\n at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112\n '); INSERT INTO perlDesk_debug VALUES (323,20071213130116,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (324,20071213130116,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?}'); INSERT INTO perlDesk_debug VALUES (325,20071213130116,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <2E3A0BC3D750174DA91754F87FC77A64090B15@psserver1.pstech.local>'); INSERT INTO perlDesk_debug VALUES (326,20071213130116,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: peretz@pstechsolutions.com'); INSERT INTO perlDesk_debug VALUES (327,20071213130117,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (328,20071213130117,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (329,20071213130117,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: peretz@pstechsolutions.com with subject \'{100-16} {Spam?} \n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (330,20071213130117,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (331,20071218052634,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: a@a.com with subject \'Help Desk Registration\' using template \'user_welcome.email\''); INSERT INTO perlDesk_debug VALUES (332,20071218052635,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (333,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (334,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Have a great night with your girlfriend!'); INSERT INTO perlDesk_debug VALUES (335,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <609362709.88637266281959@invivocom.com>'); INSERT INTO perlDesk_debug VALUES (336,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: dorinvivocomsig@invivocom.com'); INSERT INTO perlDesk_debug VALUES (337,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: nperldesk2@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (338,20071218054819,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 54.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (339,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (340,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Have a great night with your girlfriend!'); INSERT INTO perlDesk_debug VALUES (341,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <609362709.88637266281959@invivocom.com>'); INSERT INTO perlDesk_debug VALUES (342,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: dorinvivocomsig@invivocom.com'); INSERT INTO perlDesk_debug VALUES (343,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: nperldesk2@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (344,20071218054820,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 54.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (345,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (346,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test'); INSERT INTO perlDesk_debug VALUES (347,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <9e7fbea90712180354o7489a7f3nd124b3669a09fc47@mail.gmail.com>'); INSERT INTO perlDesk_debug VALUES (348,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: logicnow@gmail.com'); INSERT INTO perlDesk_debug VALUES (349,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (350,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (351,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: logicnow@gmail.com with subject \'{100-16} test\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (352,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (353,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (354,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Huge progressive jackpots, slots, multi-hand, and single-hand blackjack.'); INSERT INTO perlDesk_debug VALUES (355,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: SydneyoratoryCotton@rimmkaufman.com'); INSERT INTO perlDesk_debug VALUES (356,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: ,\n To: SydneyoratoryCotton@rimmkaufman.com with subject \'{100-17} {Spam?} Huge progressive jackpots, slots, multi-hand, and single-hand blackjack.\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (359,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (360,20071218084915,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (361,20071218084916,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Get approved in 48 hours'); INSERT INTO perlDesk_debug VALUES (362,20071218084916,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (363,20071218084916,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: FrancesfeatherbrainValencia@maggienash.com'); INSERT INTO perlDesk_debug VALUES (364,20071218084916,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (365,20071218084916,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 96.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (366,20071218091300,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (367,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} An example can be seen below.'); INSERT INTO perlDesk_debug VALUES (368,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <4767E367.5040608@evergreen.edu>'); INSERT INTO perlDesk_debug VALUES (369,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: hcwk@evergreen.edu'); INSERT INTO perlDesk_debug VALUES (370,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (371,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 18'); INSERT INTO perlDesk_debug VALUES (372,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: hcwk@evergreen.edu with subject \'{100-18} {Spam?} An example can be seen below.\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (373,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (374,20071218091403,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: g@mail.com with subject \'Help Desk Registration\' using template \'user_welcome.email\''); INSERT INTO perlDesk_debug VALUES (375,20071218091403,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (376,20071218091435,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} New Ticket\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (377,20071218091435,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (378,20071218091541,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (379,20071218091541,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (380,20071218091642,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (381,20071218091642,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (382,20071218093738,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} RE: Printer is not working\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (383,20071218093738,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (384,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (385,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} "Sorprende a tu Pareja habitaciones desde $25.000/US$50.00 Hotel AHEX"'); INSERT INTO perlDesk_debug VALUES (386,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <442044-2200712218151716656@totin>'); INSERT INTO perlDesk_debug VALUES (387,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: infoahex@ahex.cl'); INSERT INTO perlDesk_debug VALUES (388,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (389,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 20'); INSERT INTO perlDesk_debug VALUES (390,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: infoahex@ahex.cl with subject \'{100-20} {Spam?} "Sorprende a tu Pareja habitaciones desde $25.000/US$50.00 Hotel AHEX"\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (391,20071218094245,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (392,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (393,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Re: {100-19} New Ticket'); INSERT INTO perlDesk_debug VALUES (394,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <2d7294850712180919o70c1e922g7e4b53ad8c5d600@mail.gmail.com>'); INSERT INTO perlDesk_debug VALUES (395,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: g@mail.com'); INSERT INTO perlDesk_debug VALUES (396,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: \"Billing Department\" '); INSERT INTO perlDesk_debug VALUES (397,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as note for call ID# 19'); INSERT INTO perlDesk_debug VALUES (398,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_newnote.email\''); INSERT INTO perlDesk_debug VALUES (399,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (400,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (401,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: printer'); INSERT INTO perlDesk_debug VALUES (402,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (403,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: ChrisC@palacecasinoresort.com'); INSERT INTO perlDesk_debug VALUES (404,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (405,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 21'); INSERT INTO perlDesk_debug VALUES (406,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: ChrisC@palacecasinoresort.com with subject \'{100-21} printer\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (407,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (408,20071218120453,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #21 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (409,20071218120453,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (410,20071218120648,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: ChrisC@palacecasinoresort.com with subject \'{100-21} RE: printer\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (411,20071218120648,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (412,20071218120751,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: ChrisC@palacecasinoresort.com with subject \'{100-21} Request closed: printer\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (413,20071218120751,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (414,20071218121110,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (415,20071218121110,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (416,20071218121302,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-12} Request closed: Example Emailed Ticket\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (417,20071218121302,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (418,20071218121311,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} Request closed: Printer is not working\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (419,20071218121312,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (420,20071218121330,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-14} Request closed: Domain not resolving\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (421,20071218121330,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (422,20071218121342,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: logicnow@gmail.com with subject \'{100-16} Request closed: test\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (423,20071218121342,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (424,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (425,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Re: {100-19} RE: New Ticket'); INSERT INTO perlDesk_debug VALUES (426,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <2d7294850712181016v4ae1aa10l14edfdf04a636999@mail.gmail.com>'); INSERT INTO perlDesk_debug VALUES (427,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: g@mail.com'); INSERT INTO perlDesk_debug VALUES (428,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: \"Billing Department\" '); INSERT INTO perlDesk_debug VALUES (429,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as note for call ID# 19'); INSERT INTO perlDesk_debug VALUES (430,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_newnote.email\''); INSERT INTO perlDesk_debug VALUES (431,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (432,20071218130017,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (433,20071218130017,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Great Solution for seasonal merchants'); INSERT INTO perlDesk_debug VALUES (434,20071218130017,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <1900201c841a8$2670ffb0$0301a8c0@sergio>'); INSERT INTO perlDesk_debug VALUES (435,20071218130017,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: DeliaplebianMead@philips.com'); INSERT INTO perlDesk_debug VALUES (436,20071218130017,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (437,20071218130017,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 22'); INSERT INTO perlDesk_debug VALUES (438,20071218130017,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: DeliaplebianMead@philips.com with subject \'{100-22} {Spam?} Great Solution for seasonal merchants\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (439,20071218130018,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (440,20071218133106,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (441,20071218133106,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Test'); INSERT INTO perlDesk_debug VALUES (442,20071218133106,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (443,20071218133106,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: mkinnick@johnsoncitytn.org'); INSERT INTO perlDesk_debug VALUES (444,20071218133106,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (445,20071218133106,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 23'); INSERT INTO perlDesk_debug VALUES (446,20071218133106,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: mkinnick@johnsoncitytn.org with subject \'{100-23} Test\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (447,20071218133107,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (448,20071218152327,'FATAL','','lib/PerlDesk/App.pm:152','PerlDesk::App::__ANON__','No such run mode \'submit_ticket〈\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x999d3b0)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (449,20071218164550,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: demo@perldesk.com with subject \'{100-24} test\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (450,20071218164550,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (451,20071218164550,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: helpme@helpme.com with subject \'{100-24} test\' using template \'staff_newcall.email\''); INSERT INTO perlDesk_debug VALUES (452,20071218164550,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (453,20071218220502,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'Ticket #24 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (454,20071218220503,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (455,20071218220503,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-24} Assign ticket: test\' using template \'staff_reassign.email\''); INSERT INTO perlDesk_debug VALUES (456,20071218220503,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (457,20071219022919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (458,20071219022919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Slots, multi-hand, and single-hand blackjack'); INSERT INTO perlDesk_debug VALUES (459,20071219022919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: KellybuenosDye@searchles.com'); INSERT INTO perlDesk_debug VALUES (460,20071219022919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (461,20071219022919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 25'); INSERT INTO perlDesk_debug VALUES (462,20071219022919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: KellybuenosDye@searchles.com with subject \'{100-25} {Spam?} Slots, multi-hand, and single-hand blackjack\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (463,20071219022919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (464,20071219022919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-25} {Spam?} Slots, multi-hand, and single-hand blackjack\n\' using template \'staff_newcall.email\''); INSERT INTO perlDesk_debug VALUES (465,20071219022919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (466,20071219041436,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (467,20071219041436,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Let's chat'); INSERT INTO perlDesk_debug VALUES (468,20071219041436,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <01c8426f$00115c80$8ee9cbdd@a-akreut>'); INSERT INTO perlDesk_debug VALUES (469,20071219041436,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: a-akreut@abaecherlihaus.ch'); INSERT INTO perlDesk_debug VALUES (470,20071219041437,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (471,20071219041437,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 26'); INSERT INTO perlDesk_debug VALUES (472,20071219041437,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: a-akreut@abaecherlihaus.ch with subject \'{100-26} {Spam?} Let's chat\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (473,20071219041437,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (474,20071219041437,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-26} {Spam?} Let's chat\n\' using template \'staff_newcall.email\''); INSERT INTO perlDesk_debug VALUES (475,20071219041437,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (476,20071219042241,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (477,20071219042241,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Your Online Account! (message id: TQ53135996)'); INSERT INTO perlDesk_debug VALUES (478,20071219042241,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: automessageg8995366r.us@citibank.com'); INSERT INTO perlDesk_debug VALUES (479,20071219042241,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: \"Perldesk\" '); INSERT INTO perlDesk_debug VALUES (480,20071219042241,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 27'); INSERT INTO perlDesk_debug VALUES (481,20071219042241,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: automessageg8995366r.us@citibank.com with subject \'{100-27} {Spam?} Your Online Account! (message id: TQ53135996)\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (482,20071219042241,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (483,20071219042241,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-27} {Spam?} Your Online Account! (message id: TQ53135996)\n\' using template \'staff_newcall.email\''); INSERT INTO perlDesk_debug VALUES (484,20071219042241,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (485,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (486,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} underdog'); INSERT INTO perlDesk_debug VALUES (487,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <47690183.7000405@wghouse.pl>'); INSERT INTO perlDesk_debug VALUES (488,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: i.fleur@wghouse.pl'); INSERT INTO perlDesk_debug VALUES (489,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (490,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 28'); INSERT INTO perlDesk_debug VALUES (491,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: i.fleur@wghouse.pl with subject \'{100-28} {Spam?} underdog\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (492,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (493,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-28} {Spam?} underdog\n\' using template \'staff_newcall.email\''); INSERT INTO perlDesk_debug VALUES (494,20071219053350,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (495,20071219061233,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: KellybuenosDye@searchles.com with subject \'{100-25} Request closed: {Spam?} Slots, multi-hand, and single-hand blackjack\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (496,20071219061233,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (497,20071219073724,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (498,20071219073724,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Play your favorite games from the comfort of your home'); INSERT INTO perlDesk_debug VALUES (499,20071219073724,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: VirgiejeremyVarner@observer.com'); INSERT INTO perlDesk_debug VALUES (500,20071219073724,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (501,20071219073724,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 26.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (502,20071219084526,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (503,20071219084526,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Hello'); INSERT INTO perlDesk_debug VALUES (504,20071219084526,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (505,20071219084526,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: jimkos@gmail.com'); INSERT INTO perlDesk_debug VALUES (506,20071219084526,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (507,20071219084526,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 29'); INSERT INTO perlDesk_debug VALUES (508,20071219084526,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: jimkos@gmail.com with subject \'{100-29} Hello\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (509,20071219084527,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (510,20071219084527,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-29} Hello\n\' using template \'staff_newcall.email\''); INSERT INTO perlDesk_debug VALUES (511,20071219084527,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (512,20071219084734,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-29} Assign ticket: Hello\n\' using template \'staff_reassign.email\''); INSERT INTO perlDesk_debug VALUES (513,20071219084734,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (514,20071219084734,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-29} RE: Hello\n\' using template \'staff_response.email\''); INSERT INTO perlDesk_debug VALUES (515,20071219084734,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (516,20071219084734,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: jimkos@gmail.com with subject \'{100-29} RE: Hello\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (517,20071219084735,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (518,20071219085457,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-29} Assign ticket: Hello\n\' using template \'staff_reassign.email\''); INSERT INTO perlDesk_debug VALUES (519,20071219085457,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (520,20071219091413,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (521,20071219091413,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Let's chat'); INSERT INTO perlDesk_debug VALUES (522,20071219091413,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <01c8425e$3014fce0$08b47a57@997seqra>'); INSERT INTO perlDesk_debug VALUES (523,20071219091413,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: 997seqra@joshuaredman.com'); INSERT INTO perlDesk_debug VALUES (524,20071219091413,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (525,20071219091413,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 30'); INSERT INTO perlDesk_debug VALUES (526,20071219091413,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: 997seqra@joshuaredman.com with subject \'{100-30} {Spam?} Let's chat\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (527,20071219091413,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (528,20071219091413,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-30} {Spam?} Let's chat\n\' using template \'staff_newcall.email\''); INSERT INTO perlDesk_debug VALUES (529,20071219091414,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (530,20071219105024,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (531,20071219105024,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Have a great night with your girlfriend!'); INSERT INTO perlDesk_debug VALUES (532,20071219105024,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <707143508.02129874187013@javaexpress.us>'); INSERT INTO perlDesk_debug VALUES (533,20071219105024,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: jawjavaexpressxul@javaexpress.us'); INSERT INTO perlDesk_debug VALUES (534,20071219105024,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: nperldesk2@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (535,20071219105024,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 52.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (536,20071219105025,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (537,20071219105025,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Have a great night with your girlfriend!'); INSERT INTO perlDesk_debug VALUES (538,20071219105025,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <707143508.02129874187013@javaexpress.us>'); INSERT INTO perlDesk_debug VALUES (539,20071219105025,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: jawjavaexpressxul@javaexpress.us'); INSERT INTO perlDesk_debug VALUES (540,20071219105025,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: nperldesk2@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (541,20071219105025,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 52.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (542,20071219110133,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #15 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (543,20071219110133,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (544,20071219110133,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-15} Assign ticket: THIS DEMO IS RESET EVERY HOUR\n\' using template \'staff_reassign.email\''); INSERT INTO perlDesk_debug VALUES (545,20071219110133,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (546,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (547,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Did you forget to take your meds perldesk?'); INSERT INTO perlDesk_debug VALUES (548,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <000701c84284$03ba47d7$db2dd5a0@jdssnh>'); INSERT INTO perlDesk_debug VALUES (549,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: esme@one2one.net'); INSERT INTO perlDesk_debug VALUES (550,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (551,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 31'); INSERT INTO perlDesk_debug VALUES (552,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: esme@one2one.net with subject \'{100-31} {Spam?} Did you forget to take your meds perldesk?\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (553,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (554,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: helpme@helpme.com with subject \'{100-31} {Spam?} Did you forget to take your meds perldesk?\n\' using template \'staff_newcall.email\''); INSERT INTO perlDesk_debug VALUES (555,20071219121822,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (556,20071219123853,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8e27ef0'); INSERT INTO perlDesk_debug VALUES (557,20071219123853,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8e2'); INSERT INTO perlDesk_debug VALUES (558,20071219123930,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x93d7b78'); INSERT INTO perlDesk_debug VALUES (559,20071219123930,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x93d'); INSERT INTO perlDesk_debug VALUES (560,20071219123954,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9ccaef0'); INSERT INTO perlDesk_debug VALUES (561,20071219123954,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9cc'); INSERT INTO perlDesk_debug VALUES (562,20071219124031,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x95c4b78'); INSERT INTO perlDesk_debug VALUES (563,20071219124031,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x95c'); INSERT INTO perlDesk_debug VALUES (564,20071219124056,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9d59ef0'); INSERT INTO perlDesk_debug VALUES (565,20071219124056,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9d5'); INSERT INTO perlDesk_debug VALUES (566,20071219124141,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8c1ab78'); INSERT INTO perlDesk_debug VALUES (567,20071219124141,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8c1'); INSERT INTO perlDesk_debug VALUES (568,20071219124157,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x95a8ef0'); INSERT INTO perlDesk_debug VALUES (569,20071219124157,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x95a'); INSERT INTO perlDesk_debug VALUES (570,20071219124243,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x84eab78'); INSERT INTO perlDesk_debug VALUES (571,20071219124243,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x84e'); INSERT INTO perlDesk_debug VALUES (572,20071219124257,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9d29ef0'); INSERT INTO perlDesk_debug VALUES (573,20071219124257,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9d2'); INSERT INTO perlDesk_debug VALUES (574,20071219124347,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9b48b78'); INSERT INTO perlDesk_debug VALUES (575,20071219124347,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9b4'); INSERT INTO perlDesk_debug VALUES (576,20071219124358,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8371ef0'); INSERT INTO perlDesk_debug VALUES (577,20071219124358,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x837'); INSERT INTO perlDesk_debug VALUES (578,20071219124448,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8cc1b78'); INSERT INTO perlDesk_debug VALUES (579,20071219124448,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8cc'); INSERT INTO perlDesk_debug VALUES (580,20071219124459,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8eb1ef0'); INSERT INTO perlDesk_debug VALUES (581,20071219124459,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8eb'); INSERT INTO perlDesk_debug VALUES (582,20071219124549,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9578b78'); INSERT INTO perlDesk_debug VALUES (583,20071219124549,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x957'); INSERT INTO perlDesk_debug VALUES (584,20071219124600,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x99a0ef0'); INSERT INTO perlDesk_debug VALUES (585,20071219124600,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x99a'); INSERT INTO perlDesk_debug VALUES (586,20071219124650,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8c92b78'); INSERT INTO perlDesk_debug VALUES (587,20071219124650,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8c9'); INSERT INTO perlDesk_debug VALUES (588,20071219124701,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8601ef0'); INSERT INTO perlDesk_debug VALUES (589,20071219124701,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x860'); INSERT INTO perlDesk_debug VALUES (590,20071219124751,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8482b78'); INSERT INTO perlDesk_debug VALUES (591,20071219124751,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x848'); INSERT INTO perlDesk_debug VALUES (592,20071219124757,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Can\'t locate object method \"log\" via package \"PerlDesk::App::Staff\" at lib/PerlDesk/Call.pm line 53.\n at lib/PerlDesk/Call.pm line 53\n PerlDesk::Call::call_delete(\'PerlDesk::Call=HASH(0x917fcec)\', \'PerlDesk::App::Staff=HASH(0x8e46bbc)\', \'PerlDesk::Staff=H'); INSERT INTO perlDesk_debug VALUES (593,20071219124757,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'update_list_calls\': Can\'t locate object method \"log\" via package \"PerlDesk::App::Staff\" at lib/PerlDesk/Call.pm line 53.\n at staff.cgi line 31\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Staff=HA'); INSERT INTO perlDesk_debug VALUES (594,20071219124802,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9bb1ef0'); INSERT INTO perlDesk_debug VALUES (595,20071219124802,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9bb'); INSERT INTO perlDesk_debug VALUES (596,20071219124852,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x985cb78'); INSERT INTO perlDesk_debug VALUES (597,20071219124852,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x985'); INSERT INTO perlDesk_debug VALUES (598,20071219124902,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8dc4ef0'); INSERT INTO perlDesk_debug VALUES (599,20071219124902,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8dc'); INSERT INTO perlDesk_debug VALUES (600,20071219124919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (601,20071219124919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?}'); INSERT INTO perlDesk_debug VALUES (602,20071219124919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <7.0.1.0.2.20071219184830.033b1328@zen.co.uk>'); INSERT INTO perlDesk_debug VALUES (603,20071219124919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: zen82654@zen.co.uk'); INSERT INTO perlDesk_debug VALUES (604,20071219124919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (605,20071219124919,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','deleted by matching rule'); INSERT INTO perlDesk_debug VALUES (606,20071219124953,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa14eb78'); INSERT INTO perlDesk_debug VALUES (607,20071219124953,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa14'); INSERT INTO perlDesk_debug VALUES (608,20071219125004,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9196ef0'); INSERT INTO perlDesk_debug VALUES (609,20071219125004,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x919'); INSERT INTO perlDesk_debug VALUES (610,20071219125054,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x82e9b78'); INSERT INTO perlDesk_debug VALUES (611,20071219125054,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x82e'); INSERT INTO perlDesk_debug VALUES (612,20071219125105,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8d0eef0'); INSERT INTO perlDesk_debug VALUES (613,20071219125105,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8d0'); INSERT INTO perlDesk_debug VALUES (614,20071219125155,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x93e4b78'); INSERT INTO perlDesk_debug VALUES (615,20071219125155,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x93e'); INSERT INTO perlDesk_debug VALUES (616,20071219125206,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa088ef0'); INSERT INTO perlDesk_debug VALUES (617,20071219125206,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa08'); INSERT INTO perlDesk_debug VALUES (618,20071219125256,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa1eeb78'); INSERT INTO perlDesk_debug VALUES (619,20071219125256,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa1e'); INSERT INTO perlDesk_debug VALUES (620,20071219125307,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x83cbef0'); INSERT INTO perlDesk_debug VALUES (621,20071219125307,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x83c'); INSERT INTO perlDesk_debug VALUES (622,20071219125357,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x96e5b78'); INSERT INTO perlDesk_debug VALUES (623,20071219125357,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x96e'); INSERT INTO perlDesk_debug VALUES (624,20071219125408,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8998ef0'); INSERT INTO perlDesk_debug VALUES (625,20071219125408,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x899'); INSERT INTO perlDesk_debug VALUES (626,20071219125459,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x94d8b78'); INSERT INTO perlDesk_debug VALUES (627,20071219125459,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x94d'); INSERT INTO perlDesk_debug VALUES (628,20071219125508,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8e56ef0'); INSERT INTO perlDesk_debug VALUES (629,20071219125508,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8e5'); INSERT INTO perlDesk_debug VALUES (630,20071219125600,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x996db78'); INSERT INTO perlDesk_debug VALUES (631,20071219125600,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x996'); INSERT INTO perlDesk_debug VALUES (632,20071219125609,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8931ef0'); INSERT INTO perlDesk_debug VALUES (633,20071219125609,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x893'); INSERT INTO perlDesk_debug VALUES (634,20071219125701,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x923eb78'); INSERT INTO perlDesk_debug VALUES (635,20071219125701,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x923'); INSERT INTO perlDesk_debug VALUES (636,20071219125710,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x832aef0'); INSERT INTO perlDesk_debug VALUES (637,20071219125710,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x832'); INSERT INTO perlDesk_debug VALUES (638,20071219125802,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa0dfb78'); INSERT INTO perlDesk_debug VALUES (639,20071219125802,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa0d'); INSERT INTO perlDesk_debug VALUES (640,20071219125811,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8730ef0'); INSERT INTO perlDesk_debug VALUES (641,20071219125811,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x873'); INSERT INTO perlDesk_debug VALUES (642,20071219125903,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9a59b78'); INSERT INTO perlDesk_debug VALUES (643,20071219125903,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9a5'); INSERT INTO perlDesk_debug VALUES (644,20071219125912,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at extlib/CGI/Application.pm line 152\n eval {...} called at extlib/CGI/Application.pm line 151\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9bfcef0'); INSERT INTO perlDesk_debug VALUES (645,20071219125912,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','Error executing run mode \'departments\': Undefined subroutine &PerlDesk::App::Ajax::departments called at extlib/CGI/Application.pm line 152.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9bf'); INSERT INTO perlDesk_debug VALUES (646,20071219130004,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','No such run mode \'departments\' at ajax.cgi line 19\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8f41b78)\') called at ajax.cgi line 19\n eval {...} called at ajax.cgi line 13'); INSERT INTO perlDesk_debug VALUES (647,20071219130013,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','No such run mode \'departments\' at ajax.cgi line 19\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9dfdef0)\') called at ajax.cgi line 19\n eval {...} called at ajax.cgi line 13'); INSERT INTO perlDesk_debug VALUES (648,20071219130105,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','No such run mode \'departments\' at ajax.cgi line 19\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa155b78)\') called at ajax.cgi line 19\n eval {...} called at ajax.cgi line 13'); INSERT INTO perlDesk_debug VALUES (649,20071219130114,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','No such run mode \'departments\' at ajax.cgi line 19\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0xa2a4ef0)\') called at ajax.cgi line 19\n eval {...} called at ajax.cgi line 13'); INSERT INTO perlDesk_debug VALUES (650,20071219130206,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','No such run mode \'departments\' at ajax.cgi line 19\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x8d6db78)\') called at ajax.cgi line 19\n eval {...} called at ajax.cgi line 13'); INSERT INTO perlDesk_debug VALUES (651,20071219130215,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','No such run mode \'departments\' at ajax.cgi line 19\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x886aef0)\') called at ajax.cgi line 19\n eval {...} called at ajax.cgi line 13'); INSERT INTO perlDesk_debug VALUES (652,20071219130307,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','No such run mode \'departments\' at ajax.cgi line 19\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9a70b78)\') called at ajax.cgi line 19\n eval {...} called at ajax.cgi line 13'); INSERT INTO perlDesk_debug VALUES (653,20071219130316,'FATAL','','lib/PerlDesk/App.pm:132','PerlDesk::App::__ANON__','No such run mode \'departments\' at ajax.cgi line 19\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::Ajax=HASH(0x9dd4ef0)\') called at ajax.cgi line 19\n eval {...} called at ajax.cgi line 13'); -- -- Table structure for table `perlDesk_departments` -- CREATE TABLE perlDesk_departments ( id int(11) unsigned NOT NULL auto_increment, level varchar(255) default NULL, from_name text, from_email text, assign_staff text, internal int(1) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_departments` -- INSERT INTO perlDesk_departments VALUES (1,'Support','Support','perldesk@logicdemo.com','',0); INSERT INTO perlDesk_departments VALUES (2,'Billing','Billing Department','perldesk2@logicdemo.com','',0); -- -- Table structure for table `perlDesk_downloadcats` -- CREATE TABLE perlDesk_downloadcats ( id int(11) unsigned NOT NULL auto_increment, parent_id int(11) default NULL, name varchar(255) default NULL, assign_staff text, datetime timestamp(14) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_downloadcats` -- -- -- Table structure for table `perlDesk_downloadfiles` -- CREATE TABLE perlDesk_downloadfiles ( id int(11) unsigned NOT NULL auto_increment, filename varchar(255) default NULL, parent_id int(11) unsigned NOT NULL default '0', subject text NOT NULL, keywords text, description text, pd_file_id int(11) NOT NULL default '0', owner int(11) default NULL, datetime timestamp(14) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_downloadfiles` -- -- -- Table structure for table `perlDesk_em_floodprotect` -- CREATE TABLE perlDesk_em_floodprotect ( id int(11) NOT NULL auto_increment, sender varchar(255) default NULL, timestamp varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_em_floodprotect` -- INSERT INTO perlDesk_em_floodprotect VALUES (33,'zen82654@zen.co.uk','1198090159'); INSERT INTO perlDesk_em_floodprotect VALUES (32,'esme@one2one.net','1198088302'); -- -- Table structure for table `perlDesk_em_forwarders` -- CREATE TABLE perlDesk_em_forwarders ( id int(11) unsigned NOT NULL auto_increment, address varchar(255) default NULL, category varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_em_forwarders` -- INSERT INTO perlDesk_em_forwarders VALUES (1,'perldesk@logicdemo.com','Support'); INSERT INTO perlDesk_em_forwarders VALUES (2,'perldesk2@logicdemo.com','Billing'); -- -- Table structure for table `perlDesk_emaillog` -- CREATE TABLE perlDesk_emaillog ( id int(11) unsigned NOT NULL auto_increment, time timestamp(14) NOT NULL, from varchar(255) default NULL, msgid varchar(255) default NULL, subject varchar(255) default NULL, log varchar(255) default NULL, to varchar(255) default NULL, direction int(11) default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_emaillog` -- INSERT INTO perlDesk_emaillog VALUES (1,20070729145849,'zmeizz@gmail.com','\n','{Spam?} test attachment\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (2,20070729145959,'zmeizz@gmail.com','\n','Re: {100-7} {Spam?} test attachment\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (3,20070729202827,'pcr@somtel.com','<002601c7d248$f131cec0$972cceee@ti.uo>\n','{Spam?} You've received a postcard from a School friend!\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (4,20070730010636,'CameronsperryWeber@baltimoresun.com','<6021501c7d26f$cace29a0$40f9a7d8@Arbic>\n','{Spam?} Fwd: Thanks, we are ready to lend you money regardless of Credit\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (5,20070730010636,'ShaunsoonCummings@typepad.com','<6020701c7d26f$ca4d60e0$40f9a7d8@Arbic>\n','{Spam?} Re: Thanks, we are ready to give a business loan for a low month payment\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (6,20070730011955,'tmarkle@quiksystems.com','<62597.71.202.128.141.1185776386.squirrel@www.quiksystems.com>\n','Support Test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (7,20070730014754,'wkuyx@tdtv.tinp.net.tw','<46AD8992.2010208@tdtv.tinp.net.tw>\n','{Spam?} Publication\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (8,20070730045424,'newocasknegroea@protectivesuits.com','<000b01c7d4eb$9a9c3500$00000000@dslb-084-058-222-253.pools.arcor-ip.net>\n','{Spam?} Things getting better\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (9,20070730045753,'nogazloanlinefiw@azloanline.com','<521531432.67839919678172@azloanline.com>\n','{Spam?} Can you imagine that you are healthy?\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (10,20070730045753,'nogazloanlinefiw@azloanline.com','<521531432.67839919678172@azloanline.com>\n','{Spam?} Can you imagine that you are healthy?\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (11,20070730051912,'a-1ccs@adpowerzone.com','<01c7d293$102e1730$6a9f3255@a-1ccs>\n','{Spam?} Re: Photo\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (12,20070730053011,'kris@tezwiz.com','<01c7d294$ad408cf0$4c4003dd@kris>\n','{Spam?} $99.95 100mg x 30 pills buy now\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (13,20070730055852,'karan@netsmartz.net','<010201c7d298$93dd3c00$9f01a8c0@sebiz.net>\n','Looking for a Demo\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (14,20070730061833,'sigbandaladdsdyj@bandaladds.com','<268898447.35847575863279@thhebat.net>\n','{Spam?} Our present for your health\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (15,20070730061833,'sigbandaladdsdyj@bandaladds.com','<268898447.35847575863279@thhebat.net>\n','{Spam?} Our present for your health\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (16,20070730063013,'hvr@cnzmwl.com','<01c7d29c$e479ff00$9d0dc77c@hvr>\n','{Spam?} Penis enlarge patch will expand the erectile tissue longer and wider without any extra effort! Powerful erections when you need it.\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (17,20070730105748,'SherrieworkoutSneed@gambling365.com','<433501c7d2c2$55fbc440$0100a8c0@msdev2>\n','{Spam?} Fw: Thank you, we are ready to lend you money\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (18,20070730105749,'MyrnapeatColvin@washingtonpost.com','<433c01c7d2c2$55fd4ae0$0100a8c0@msdev2>\n','{Spam?} Fw: Thank you, we will help you fight out the cash crunch\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (19,20070730135813,'kunigunde.dahl@maxprofit.se','<01c7d2db$8ee87be0$9e586b4a@kunigunde.dahl>\n','{Spam?} Sunrise in your life\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (20,20070730143459,'a-440@activeware.com','<01c7d399$029c8e60$0ff2b651@a-440>\n','{Spam?} Re: Photo\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (21,20070730150211,'sigbankcreditcarddyj@bankcreditcard.us','<312497215.13461071278633@bankcreditcard.us>\n','{Spam?} Olny this 5 days special price on pharma for you dear customer\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (22,20070730150211,'sigbankcreditcarddyj@bankcreditcard.us','<312497215.13461071278633@bankcreditcard.us>\n','{Spam?} Olny this 5 days special price on pharma for you dear customer\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (23,20070730221711,'Hit-Booster',NULL,'{Spam?} How would you like unlimited hits to your website 15 minutes from now ?\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (24,20070730231700,'nwi@ctihk.com','<000501c7d329$a0c3b9d0$2ad06aa0@nqu.qnva>\n','{Spam?} RE:\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (25,20070731020528,'dlz@quadramed.com','<46AEDF2C.3070203@quadramed.com>\n','{Spam?} (no subject)\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (26,20070731030656,'ujz@pobox.com','<46AEED92.8000603@pobox.com>\n','{Spam?} Doc\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (27,20070731034057,'Pickensvewosndw@barnesindustrial.com','<926947u6qqx0$a9304yu0$2209p5k0@Delldim5150\n','{Spam?} chiropractors mailing list\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (28,20070731035452,'TracieinstructBurgos@kitonline.org','<458101c7d418$6e20dea0$6f02a8c0@EXT011>\n','{Spam?} Re: Thank you, we accepted your refinance loan request\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (29,20070731035455,'LaurelexpelledAkins@pacificit.ca','<457a01c7d418$6dff73f0$6f02a8c0@EXT011>\n','{Spam?} Fwd: Thank you, we are ready to lend you some cash\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (30,20070731035844,'erosinkiracira@robbyleblanc.com','<000b01c7d350$fde1b320$1502a8c0@dip.t-dialin.net>\n','{Spam?} Sorry to be late\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (31,20070731050952,'mujbartosikfek@bartosik.sk','<575637385.24525689772614@bartosik.sk>\n','{Spam?} Can you imagine that you are healthy?\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (32,20070731050953,'mujbartosikfek@bartosik.sk','<575637385.24525689772614@bartosik.sk>\n','{Spam?} Can you imagine that you are healthy?\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (33,20070731051811,'karan@netsmartz.net','<019a01c7d35c$0e94c030$9f01a8c0@sebiz.net>\n','karan is testing\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (34,20070731081653,'hfql@logicdemo.com','<66f201c7d3b0$01c7d3b0$1f63197d@logicdemo.com>\n','{Spam?} Degree award: Re your nomination\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (35,20070731093252,'orlcampfire@eatraffic.com','<001b01c19266$73f6d400$00a0a58c@familia>\n','{Spam?} angry cathy asymptote\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (36,20070731093256,'jcentrifugal@awesomeemails4u.com','<001601c19266$75d88c50$00a0a58c@familia>\n','{Spam?} compacter davidson boltzmann\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (37,20070731095104,'sny@home.nl','<002201c7d45c$6f47ba80$7267378b@nilkl.glfe>\n','{Spam?} You've received a greeting ecard from a Friend!\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (38,20070731095652,'hqt@entsgo.com','<001b01c7d383$069f7b00$cc1ba71a@phhcx.plyf>\n','{Spam?} You've received a postcard from a Partner!\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (39,20070731100245,'phil@todotec.com','\n','{Spam?} test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (40,20070731122641,'taynguyenonline.net@northaustinproperties.com','<000401c7d397$5a308480$0100007f@onlyr>\n','{Spam?} She will love you more than any other guy\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (41,20070731130937,'9mcc@qlink.queensu.ca','<01c7d530$578a5ae0$37ab6155@9mcc>\n','{Spam?} Re: Hi\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (42,20070731135045,'mkonopinski@ristorantegaribaldi.com','<01c4fd8e$a8e3c7e0$256c8ade@mkonopinski>\n','{Spam?} Price for Viagra (Sildenafil) 100mg x 90 pills US $ 159.95\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (43,20070731135134,'hearings1@herblip.net','<542768171.83208476876679@herblip.net>\n','{Spam?} 5% of the price.\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (44,20070731145636,'cgwynn@hiscockbarclay.com','<40CA1510121A484DB9416F17F09852B60926F818@syrexch.hiscockbarclay.com>\n','Test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (45,20070731150333,'sygbcclothesboh@bcclothes.net','<476273270.84956375338634@bcclothes.net>\n','{Spam?} Olny this 5 days special price on pharma for you dear customer\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (46,20070731150333,'sygbcclothesboh@bcclothes.net','<476273270.84956375338634@bcclothes.net>\n','{Spam?} Olny this 5 days special price on pharma for you dear customer\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (47,20070731150532,'Owen@wsu.edu','<00e101c7d3ae$1bac37b0$14a5e23e@Owen>\n','{Spam?} Find out the sex craving all guys have\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (48,20070731153205,'rhelmuth@Princeton.EDU','<004f01c7d3b1$d36c9810$74cc7080@libraries.princeton.edu>\n','asdfasdf helm\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (49,20070731185003,'adriano@intermaker.com.br','<000001c7d3cd$7862b640$692822c0$@com.br>\n','{Spam?} teste\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (50,20070731200520,'waynemoranr@scug.org.uk','\n','{Spam?} Just keep in touch\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (51,20070731222656,'brhuleiagia@ninkiya.com','\n','{Spam?} When will it be okay\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (52,20070801010335,'npo@sti.net','<46B0222B.7070307@sti.net>\n','{Spam?} Notice\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (53,20070801011550,'delbert.daker@ofischer.com','<01c7d403$664b4db0$86e1f857@delbert.daker>\n','{Spam?} Solve erection problems\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (54,20070912151311,'logicnow@gmail.com','<9e7fbea90709121312y5a2422f7he130b59b8b1ce3e@mail.gmail.com>\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (55,20070912151924,'jack@datavisiongroup.com','\n','jack test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (56,20070912203415,'greg@icaccess.com','<000001c7f5a6$23a1c8d0$6701a8c0@tigershark>\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (57,20070912215233,'perldesk@logicdemo.com','\n','{Spam?} No pain, yes gain!\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (58,20070913021613,'JoestagnateMurphy@stokestropicals.com','1d77501c7f5d5$f0fefb70$6600a8c0@alisa\n','{Spam?} Thanks, 4 girls from our site want to meet you\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (59,20070913021614,'PatricktrudgeRoberts@funduc.com','1d78a01c7f5d5$f15272a0$6600a8c0@alisa\n','{Spam?} Thank you, a girl to be yours in here found!\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (60,20070913031202,'as@greatdayre.com','<01c7f5dd$aa07e490$a979727b@as>\n','{Spam?} Your online shopping is safe & secure with EliteHerbal...\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (61,20070913031203,'as@greatdayre.com','<01c7f5dd$aa07e490$a979727b@as>\n','{Spam?} Your online shopping is safe & secure with EliteHerbal...\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (62,20070913033729,'chung-ya@sinagirl.com','<000701c7f9de$052b1bfe$b6ac438c@cuwdi>\n','{Spam?} Just call the number below\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (63,20070913041210,'afcths@driversourceaustin.com','<01c7f5e6$29011b10$661b003b@afcths>\n','{Spam?} Viagra (Sildenafil) 50mg x 10 pills $6.00 per pill\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (64,20070913054201,'john@lareponseestb.com','<01c7f5f2$b5193f90$2560e0d3@john>\n','{Spam?} Save US $ 529.05 Photoshop cs2\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (65,20070913061430,'sales@tianiumiris.com','<151301c7f5f6$01dd9126$a1f1ea58@[88.234.241.161]>\n','{Spam?} Dennis Hopper on Owen Wilson\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (66,20070913082521,'placensjoz@aenigmatica.it','\n','{Spam?} How far will it last\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (67,20070913084458,'perle-pferd@8mal11.de','<607642922869051623.50110220290979488@8mal11.de>\n','{Spam?} RE:\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (68,20070913102049,'anctongttd@boobsthemusical.com','<251346827.20927649521903@boobsthemusical.com>\n','{Spam?} Daniel has sent you a message\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (69,20070913120659,'JKELLER@binghamt.gannett.com','\n','Test message\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (70,20070913125952,'sezlagomut@lago.com','<297513066.00863413713232@lago.com>\n','{Spam?} Control your weight and appetite\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (71,20070913125952,'sezlagomut@lago.com','<297513066.00863413713232@lago.com>\n','{Spam?} Control your weight and appetite\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (72,20070913140826,'toothpicksj6@advancethermal.com','<502788409.33028463021227@advancethermal.com>\n','{Spam?} Don't waste your money\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (73,20070913145341,'Andrew.Hart@lairdtech.com','\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (74,20070913162324,'cservice.refsk8927333ax.gps@citizensbank.com',NULL,'{Spam?} customer notification: data confirmation! (mess_id: c18366594337)\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (75,20070913163230,'sales@milliondollarresultscoach.com','<781701c7f64d$118b490e$01d9c929@rahmouni>\n','{Spam?} Russell Crowe in Better Yuma\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (76,20070913212351,'info@manifesto.com.ar',NULL,'{Spam?} tst\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (77,20070913212508,'pagos@manifesto.com.ar',NULL,'RE: {100-7} {Spam?} tst\n','Access error',NULL,0); INSERT INTO perlDesk_emaillog VALUES (78,20070914125010,'richieau@tpg.com.au','\n','testtes\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (79,20070914125057,'wikes@toysrus.com','<0618FA1CF2628B4BA57D0721E60A4EEF082BA501@msg22usa.usa.glb.tru.com>\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (80,20070914125057,'wigleisuretravelgroupfih@leisuretravelgroup.com','<992387903.99420789973627@leisuretravelgroup.com>\n','{Spam?} Legal software sales\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (81,20070914125058,'wigleisuretravelgroupfih@leisuretravelgroup.com','<992387903.99420789973627@leisuretravelgroup.com>\n','{Spam?} Legal software sales\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (82,20070914125131,'yuki.com@krfarm.com','<01c7f6dc$41ebf810$15837adc@yuki.com>\n','{Spam?} 100mg x 30 pills US $ 3.33 Per Pill buy now\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (83,20070914125834,'Yngve.Nilsen@softscenario.no','<9CD65EE8451C824D9568F38E38D452F1651663@sos-exchange1.ad.softscenario.no>\n','Test support\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (84,20070914130145,'goce.mitevski@gmail.com','<195c6c7d0709140519g10a26022kb26386dd47d3335@mail.gmail.com>\n','sdfsdsd\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (85,20070914131026,'vips@absamail.co.za','<20070914180122.CA28F17827E6@mmi01.absamail.co.za>\n','perldesk test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (86,20070914131610,'samantha@datentechnik.com','<000801c7f6cf$05b85a54$19a68b9a@mhnpbv>\n','{Spam?} Work as Advertising Coordinator\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (87,20070914132013,'logicnow@gmail.com','<9e7fbea90709140522y41fed1c5s716d654f2a16bf5b@mail.gmail.com>\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (88,20070914132347,'DScott@laneventure.com','\n','Problem wiht menu\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (89,20070914132530,'j.bennett@logicnow.com','<46EA7B67.4020204@logicnow.com>\n','dfsdf\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (90,20070914133055,'j.bennett@logicnow.com','<46EA6500.1000109@logicnow.com>\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (91,20070914140553,'wigleflerfih@lefler.net','<828118043.52867407224796@lefler.net>\n','{Spam?} Software\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (92,20070914140554,'wigleflerfih@lefler.net','<828118043.52867407224796@lefler.net>\n','{Spam?} Software\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (93,20070914153556,'wiglegendnyfih@legendny.com','<372788495.30012224791223@legendny.com>\n','{Spam?} Burn pounds off with Anatrim\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (94,20070914153557,'wiglegendnyfih@legendny.com','<372788495.30012224791223@legendny.com>\n','{Spam?} Burn pounds off with Anatrim\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (95,20070914160608,'portsman@icpbelgium.com','<000001c7f711$23c58380$0100007f@localhost>\n','{Spam?} Off1ce 2OO7 Pro 79 $ Save_999,95 from retalI and down1oad lnstant1y\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (96,20070914170233,'Jimmylam9@aol.com','\n','NEED SOFTWARE FOR MY COMPUPTER\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (97,20070914211400,'mudd@finnfun.com','<01c7f73e$14379b10$a23776dc@mudd>\n','{Spam?} ADOBE PHOTOSHOP CS3 EXTENDED Retail price: $999.00 our price US $ 89.95 You save $909.05\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (98,20070914211400,'mudd@finnfun.com','<01c7f73e$14379b10$a23776dc@mudd>\n','{Spam?} ADOBE PHOTOSHOP CS3 EXTENDED Retail price: $999.00 our price US $ 89.95 You save $909.05\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (99,20070914213720,'jqztj@express-scripts.com','<01c7f741$4e042d60$6eb979c8@jqztj>\n','{Spam?} + . ] -+ (\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (100,20070914232507,'good_trainer@yahoo.com',NULL,'{Spam?} ¡ÅÂØ·¸ì¡ÒâÒ ¡ÒõÅÒ´ ã¹ÀÒ¤¡Òõé͹Ã','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (101,20070915022130,'9crspsflxh9x@telepath.com','<01c7f769$46122710$ac11cfcb@9crspsflxh9x>\n','Looking for penpal?\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (102,20070915062827,'lrgranger@wardcartoons.com','<01c7f78b$808cbb90$c38751dc@lrgranger>\n','{Spam?} Our price US $ 269.90 Creative Suite 3\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (103,20070915073246,'tabassum.dalzell@upm.dk','<01c7f794$78854990$acb49a56@tabassum.dalzell>\n','{Spam?} Good luck, dear friend\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (104,20070915090145,'dtk@lmscoaching.com','<01c7f7a0$cdc75810$4107d0d3@dtk>\n','{Spam?} adobe cs2 v9.0\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (105,20070915094359,'landshuter@googlemail.com','<552aa7b70709150743g3ecaf1e2w71fb428de3560e05@mail.gmail.com>\n','test leibnitz\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (106,20070915102403,'landshuter@googlemail.com','<552aa7b70709150823p3b1c1811g79293b7b18ba9eb6@mail.gmail.com>\n','testtttttt\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (107,20070915113829,'a.hugh1@yahoo.co.uk','<003601c7f7b6$c0d595c0$4c802a52@048231020505>\n','faafa\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (108,20070915133127,'gayk_drougas@cmc3s.org','<000601c7f7c6$c5cadc60$41dd0553@homel4qnykhzt6>\n','{Spam?} yksnaelr\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (109,20070915182134,'thevikingyqoiu@newnewmedia.com','<0e6201c7f829$6a205580$a91ab737@thevikingyqoiu>\n','How's ted\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (110,20070915194016,'agcava2@dynocarb.com','<01c7f7fa$1d863d90$86dba0de@agcava2>\n','{Spam?} buy now Viagra (Sildenafil) 50mg x 60 pills\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (111,20070915194017,'agcava2@dynocarb.com','<01c7f7fa$1d863d90$86dba0de@agcava2>\n','{Spam?} buy now Viagra (Sildenafil) 50mg x 60 pills\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (112,20070915194327,'d.stewart@asiahotels.net','<002a01c7f7fa$8b2ee720$dc00a8c0@skz88c65dc707e>\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (113,20070915203722,'dohlotolebof@lotole.com','<519273063.52496550339713@lotole.com>\n','{Spam?} Software\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (114,20070915203722,'dohlotolebof@lotole.com','<519273063.52496550339713@lotole.com>\n','{Spam?} Software\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (115,20070916004639,'pamccomas@jf365.com','<01c7f824$f002b990$151a98da@pamccomas>\n','{Spam?} Viagra (Sildenafil) 50mg x 60 pills $119.95 buy now\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (116,20070916024517,'dpilla@junkfoodguy.com','<01c7f835$7fb06410$f3e979de@dpilla>\n','{Spam?} Save $1529.1 Adobe Creative 3 for windows $269\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (117,20070916060525,'Collmarldri@megadrive.com.ua','<000401c7f851$7946a1e0$caaa0c51@Cujmir1>\n','{Spam?} duarion\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (118,20070916075611,'abdiashuertapyoxu@alicedsl.de','\n','{Spam?} Always on time\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (119,20070916152922,'asa@onelist.com','<000801c2c36c$02ed09c7$20a074a3@xpfvo>\n','{Spam?} Local representatives wanted. Really high wages, no investment is required.\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (120,20070917000926,'bykotaim@ix.netcom.com','<01c7f8e8$e2af0310$5f7bb1ca@bykotaim>\n','{Spam?} Anti-ED innovations\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (121,20070917041011,'eulalia10@sial.com','<003101c7f90a$85bd3fb0$4ae43793@alht>\n','{Spam?} Free games!\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (122,20070917043903,'benn@creativemotiondesign.com','\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (123,20070917055506,'Sam.Yatim@manconsulting.co.uk','<46EE6B2C020000EF0000073C@mail.manconsulting.co.uk>\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (124,20070917064650,'avalonrosedesign@gmail.com','<46ee6914.050b240a.1a53.0014@mx.google.com>\n','Sample Email\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (125,20070917074622,'perlaverano@yahoo.fr','<519864185247703829.41842894173228766@yahoo.fr>\n','{Spam?} RE:\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (126,20070917080723,'doug@uditelco.co.za','<2174.22641190034404.udigroup.net@MHS>\n','Trial\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (127,20070917081545,'EduardowidthwiseRhodes@realityblurred.com','<1b0a801c7f92c$d41aec80$fd822a53@pajuelinfw6el3>\n','{Spam?} Re: Thanks, we accepted your business loan request\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (128,20070917081601,'RosshistorySutton@tcvb.org','<1b09301c7f92c$d41176a0$fd822a53@pajuelinfw6el3>\n','{Spam?} Fwd: Thanks, we accepted your company business loan request\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (129,20070917082017,'Nick.Crisanti@itt.com','<9C107012050BAA4EA7F58AE4ED2C289D185E3B74@sfexch1.usa.itt.net>\n','test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (130,20070917083437,'suvallepgvl@alicedsl.de','<506b01c7f911$f470ec70$124b2611@suvallepgvl>\n','{Spam?} Show me, can you\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (131,20070917092405,'turgayKurys@QUELPENIS.COM','<000301c7f936$65bf8930$159c09c9@FINANCEIRO>\n','{Spam?} ahotufur\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (132,20070917092411,'Dymacekbyta@QUELPENIS.COM','<000e01c7f936$6473f660$159c09c9@FINANCEIRO>\n','{Spam?} agueuses\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (133,20070917151647,'rhiggins@restaurant43.com','<01c7f967$9ce54f90$a36cf158@rhiggins>\n','{Spam?} I never thought that I suffer from any problem.\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (134,20070917162735,'COX@hismastersvoice.com','<000801c7f972$1a0fcea0$f5f7b155@workstation>\n','{Spam?} kraenker\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (135,20070917162747,'taeho810@hismastersvoice.com','<000401c7f972$1ab6bd00$f5f7b155@workstation>\n','{Spam?} kolbsgni\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (136,20070917165156,'a-2000@4biztech.com','<01c7f974$a628e910$9c0c033b@a-2000>\n','Can we be friends?\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (137,20070917183431,'pierre@demester.com','<01f901c7f983$3f43abe0$6f01a8c0@NX9420>\n','ticket created via email - blah blah blah\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (138,20070917200857,'ross@rosshill.com.au','<3F1CF956-5570-406F-9B4C-73671CFF994D@rosshill.com.au>\n','help!\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (139,20070918042333,'nicolas.lussier@tembec.com','<46EF9900.8070007@tembec.com>\n','probleme imprimante\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (140,20070918054844,'markus.jansons@ctxm.com','<000c01c7f9e1$66a0f1d0$52a415d9@office.ctxm.lv>\n','test email during presales enquiry to Perldesk\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (141,20070918085416,'qassim.Brock@batia.biz',NULL,'{Spam?} erfeltes\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (142,20070918100118,'perldl@gggai.com','<296281010112936769.973448927556951914@gggai.com>\n','{Spam?} RE:\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (143,20070918100945,'accounts@citizensbank.com','<326063195.31505292499298@uniolprodukter.com>\n','{Spam?} {Disarmed} Protect your online CITIZENS BANK account now.\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (144,20070918123039,'j.bennett@logicnow.com','<46F00AD8.6090408@logicnow.com>\n','dfdsf\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (145,20071130102915,'infoahex@ahex.cl','<3257143-220071153015146562@totin>\n','{Spam?} {Disarmed} "Disfrute de la Unica Hoteleria Boutique Ahex Express desde$30.000/US$60.00 "\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (146,20071130103237,'psmith@Seabrookhouse.org','\n','{Spam?} test\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (147,20071207000619,'j.bennett@logicnow.com','<4758E24D.5000407@logicnow.com>\n','Example Emailed Ticket\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (148,20071207000650,'j.bennett@logicnow.com','<4758E26E.3030703@logicnow.com>\n','Printer is not working\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (149,20071207000820,'j.bennett@logicnow.com','<4758E2C2.8000707@logicnow.com>\n','Domain not resolving\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (150,20071207000904,'j.bennett@logicnow.com','<4758E2F5.9080903@logicnow.com>\n','Re: {100-13} RE: Printer is not working\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (151,20071207001452,'j.bennett@logicnow.com','<4758E452.8030303@logicnow.com>\n','THIS DEMO IS RESET EVERY HOUR\n','ok',NULL,0); INSERT INTO perlDesk_emaillog VALUES (152,20071218052635,'\"Support\" ',NULL,'Help Desk Registration','message sent successfully using template user_welcome.email','a@a.com',0); INSERT INTO perlDesk_emaillog VALUES (153,20071218055420,'logicnow@gmail.com','<9e7fbea90712180354o7489a7f3nd124b3669a09fc47@mail.gmail.com>\n','test\n','OK. Stored as call ID# 16','perldesk@logicdemo.com\n',0); INSERT INTO perlDesk_emaillog VALUES (154,20071218055420,'\"Support\" ',NULL,'{100-16} test\n','message sent successfully using template user_newcall.email','logicnow@gmail.com',0); INSERT INTO perlDesk_emaillog VALUES (155,20071218074739,'SydneyoratoryCotton@rimmkaufman.com',NULL,'{Spam?} Huge progressive jackpots, slots, multi-hand, and single-hand blackjack.\n','OK. Stored as call ID# 17',',\n ',NULL,'{100-17} {Spam?} Huge progressive jackpots, slots, multi-hand, and single-hand blackjack.\n','message sent successfully using template user_newcall.email','SydneyoratoryCotton@rimmkaufman.com',0); INSERT INTO perlDesk_emaillog VALUES (157,20071218091301,'hcwk@evergreen.edu','<4767E367.5040608@evergreen.edu>\n','{Spam?} An example can be seen below.\n','OK. Stored as call ID# 18','perldesk@logicdemo.com\n',0); INSERT INTO perlDesk_emaillog VALUES (158,20071218091301,'\"Support\" ',NULL,'{100-18} {Spam?} An example can be seen below.\n','message sent successfully using template user_newcall.email','hcwk@evergreen.edu',0); INSERT INTO perlDesk_emaillog VALUES (159,20071218091403,'\"Support\" ',NULL,'Help Desk Registration','message sent successfully using template user_welcome.email','g@mail.com',0); INSERT INTO perlDesk_emaillog VALUES (160,20071218091435,'\"Billing Department\" ',NULL,'{100-19} New Ticket','message sent successfully using template user_newcall.email','g@mail.com',0); INSERT INTO perlDesk_emaillog VALUES (161,20071218091541,'\"Billing Department\" ',NULL,'{100-19} RE: New Ticket','message sent successfully using template user_response.email','g@mail.com',0); INSERT INTO perlDesk_emaillog VALUES (162,20071218091642,'\"Billing Department\" ',NULL,'{100-19} RE: New Ticket','message sent successfully using template user_response.email','g@mail.com',0); INSERT INTO perlDesk_emaillog VALUES (163,20071218093738,'\"Support\" ',NULL,'{100-13} RE: Printer is not working\n','message sent successfully using template user_response.email','j.bennett@logicnow.com',0); INSERT INTO perlDesk_emaillog VALUES (164,20071218094244,'infoahex@ahex.cl','<442044-2200712218151716656@totin>\n','{Spam?} "Sorprende a tu Pareja habitaciones desde $25.000/US$50.00 Hotel AHEX"\n','OK. Stored as call ID# 20','perldesk@logicdemo.com\n',0); INSERT INTO perlDesk_emaillog VALUES (165,20071218094245,'\"Support\" ',NULL,'{100-20} {Spam?} "Sorprende a tu Pareja habitaciones desde $25.000/US$50.00 Hotel AHEX"\n','message sent successfully using template user_newcall.email','infoahex@ahex.cl',0); INSERT INTO perlDesk_emaillog VALUES (166,20071218112004,'g@mail.com','<2d7294850712180919o70c1e922g7e4b53ad8c5d600@mail.gmail.com>\n','Re: {100-19} New Ticket\n','OK. Stored as note for call ID# 19','\"Billing Department\" \n',0); INSERT INTO perlDesk_emaillog VALUES (167,20071218112004,'\"Billing Department\" ',NULL,'{100-19} RE: New Ticket','message sent successfully using template user_newnote.email','g@mail.com',0); INSERT INTO perlDesk_emaillog VALUES (168,20071218115930,'ChrisC@palacecasinoresort.com','\n','printer\n','OK. Stored as call ID# 21','\n',0); INSERT INTO perlDesk_emaillog VALUES (169,20071218115930,'\"Support\" ',NULL,'{100-21} printer\n','message sent successfully using template user_newcall.email','ChrisC@palacecasinoresort.com',0); INSERT INTO perlDesk_emaillog VALUES (170,20071218120453,'\"Support\" ',NULL,'Ticket #21 assigned to you','message sent successfully using template staff_assign.email','john@logicdemo.com',0); INSERT INTO perlDesk_emaillog VALUES (171,20071218120648,'\"Support\" ',NULL,'{100-21} RE: printer\n','message sent successfully using template user_response.email','ChrisC@palacecasinoresort.com',0); INSERT INTO perlDesk_emaillog VALUES (172,20071218120751,'\"Support\" ',NULL,'{100-21} Request closed: printer\n','message sent successfully using template user_close.email','ChrisC@palacecasinoresort.com',0); INSERT INTO perlDesk_emaillog VALUES (173,20071218121110,'\"Billing Department\" ',NULL,'{100-19} RE: New Ticket','message sent successfully using template user_response.email','g@mail.com',0); INSERT INTO perlDesk_emaillog VALUES (174,20071218121302,'\"Support\" ',NULL,'{100-12} Request closed: Example Emailed Ticket\n','message sent successfully using template user_close.email','j.bennett@logicnow.com',0); INSERT INTO perlDesk_emaillog VALUES (175,20071218121312,'\"Support\" ',NULL,'{100-13} Request closed: Printer is not working\n','message sent successfully using template user_close.email','j.bennett@logicnow.com',0); INSERT INTO perlDesk_emaillog VALUES (176,20071218121330,'\"Support\" ',NULL,'{100-14} Request closed: Domain not resolving\n','message sent successfully using template user_close.email','j.bennett@logicnow.com',0); INSERT INTO perlDesk_emaillog VALUES (177,20071218121342,'\"Support\" ',NULL,'{100-16} Request closed: test\n','message sent successfully using template user_close.email','logicnow@gmail.com',0); INSERT INTO perlDesk_emaillog VALUES (178,20071218121655,'g@mail.com','<2d7294850712181016v4ae1aa10l14edfdf04a636999@mail.gmail.com>\n','Re: {100-19} RE: New Ticket\n','OK. Stored as note for call ID# 19','\"Billing Department\" \n',0); INSERT INTO perlDesk_emaillog VALUES (179,20071218121655,'\"Billing Department\" ',NULL,'{100-19} RE: New Ticket','message sent successfully using template user_newnote.email','g@mail.com',0); INSERT INTO perlDesk_emaillog VALUES (180,20071218130017,'DeliaplebianMead@philips.com','<1900201c841a8$2670ffb0$0301a8c0@sergio>\n','{Spam?} Great Solution for seasonal merchants\n','OK. Stored as call ID# 22','\n',0); INSERT INTO perlDesk_emaillog VALUES (181,20071218130018,'\"Billing Department\" ',NULL,'{100-22} {Spam?} Great Solution for seasonal merchants\n','message sent successfully using template user_newcall.email','DeliaplebianMead@philips.com',0); INSERT INTO perlDesk_emaillog VALUES (182,20071218133106,'mkinnick@johnsoncitytn.org','\n','Test\n','OK. Stored as call ID# 23','\n',0); INSERT INTO perlDesk_emaillog VALUES (183,20071218133107,'\"Support\" ',NULL,'{100-23} Test\n','message sent successfully using template user_newcall.email','mkinnick@johnsoncitytn.org',0); INSERT INTO perlDesk_emaillog VALUES (184,20071218164550,'\"Billing Department\" ',NULL,'{100-24} test','message sent successfully using template user_newcall.email','demo@perldesk.com',0); INSERT INTO perlDesk_emaillog VALUES (185,20071218164550,'\"Billing Department\" ',NULL,'{100-24} test','message sent successfully using template staff_newcall.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (186,20071218220503,'\"Support\" ',NULL,'Ticket #24 assigned to you','message sent successfully using template staff_assign.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (187,20071218220503,'\"Support\" ',NULL,'{100-24} Assign ticket: test','message sent successfully using template staff_reassign.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (188,20071219022919,'KellybuenosDye@searchles.com',NULL,'{Spam?} Slots, multi-hand, and single-hand blackjack\n','OK. Stored as call ID# 25','\n',0); INSERT INTO perlDesk_emaillog VALUES (189,20071219022919,'\"Support\" ',NULL,'{100-25} {Spam?} Slots, multi-hand, and single-hand blackjack\n','message sent successfully using template user_newcall.email','KellybuenosDye@searchles.com',0); INSERT INTO perlDesk_emaillog VALUES (190,20071219022919,'\"Support\" ',NULL,'{100-25} {Spam?} Slots, multi-hand, and single-hand blackjack\n','message sent successfully using template staff_newcall.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (191,20071219041437,'a-akreut@abaecherlihaus.ch','<01c8426f$00115c80$8ee9cbdd@a-akreut>\n','{Spam?} Let's chat\n','OK. Stored as call ID# 26','\n',0); INSERT INTO perlDesk_emaillog VALUES (192,20071219041437,'\"Support\" ',NULL,'{100-26} {Spam?} Let's chat\n','message sent successfully using template user_newcall.email','a-akreut@abaecherlihaus.ch',0); INSERT INTO perlDesk_emaillog VALUES (193,20071219041437,'\"Support\" ',NULL,'{100-26} {Spam?} Let's chat\n','message sent successfully using template staff_newcall.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (194,20071219042241,'automessageg8995366r.us@citibank.com',NULL,'{Spam?} Your Online Account! (message id: TQ53135996)\n','OK. Stored as call ID# 27','\"Perldesk\" \n',0); INSERT INTO perlDesk_emaillog VALUES (195,20071219042241,'\"Support\" ',NULL,'{100-27} {Spam?} Your Online Account! (message id: TQ53135996)\n','message sent successfully using template user_newcall.email','automessageg8995366r.us@citibank.com',0); INSERT INTO perlDesk_emaillog VALUES (196,20071219042241,'\"Support\" ',NULL,'{100-27} {Spam?} Your Online Account! (message id: TQ53135996)\n','message sent successfully using template staff_newcall.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (197,20071219053350,'i.fleur@wghouse.pl','<47690183.7000405@wghouse.pl>\n','{Spam?} underdog\n','OK. Stored as call ID# 28','perldesk@logicdemo.com\n',0); INSERT INTO perlDesk_emaillog VALUES (198,20071219053350,'\"Support\" ',NULL,'{100-28} {Spam?} underdog\n','message sent successfully using template user_newcall.email','i.fleur@wghouse.pl',0); INSERT INTO perlDesk_emaillog VALUES (199,20071219053350,'\"Support\" ',NULL,'{100-28} {Spam?} underdog\n','message sent successfully using template staff_newcall.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (200,20071219061233,'\"Support\" ',NULL,'{100-25} Request closed: {Spam?} Slots, multi-hand, and single-hand blackjack\n','message sent successfully using template user_close.email','KellybuenosDye@searchles.com',0); INSERT INTO perlDesk_emaillog VALUES (201,20071219084526,'jimkos@gmail.com','\n','Hello\n','OK. Stored as call ID# 29','perldesk@logicdemo.com\n',0); INSERT INTO perlDesk_emaillog VALUES (202,20071219084527,'\"Support\" ',NULL,'{100-29} Hello\n','message sent successfully using template user_newcall.email','jimkos@gmail.com',0); INSERT INTO perlDesk_emaillog VALUES (203,20071219084527,'\"Support\" ',NULL,'{100-29} Hello\n','message sent successfully using template staff_newcall.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (204,20071219084734,'\"Support\" ',NULL,'{100-29} Assign ticket: Hello\n','message sent successfully using template staff_reassign.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (205,20071219084734,'\"Support\" ',NULL,'{100-29} RE: Hello\n','message sent successfully using template staff_response.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (206,20071219084735,'\"Support\" ',NULL,'{100-29} RE: Hello\n','message sent successfully using template user_response.email','jimkos@gmail.com',0); INSERT INTO perlDesk_emaillog VALUES (207,20071219085457,'\"Support\" ',NULL,'{100-29} Assign ticket: Hello\n','message sent successfully using template staff_reassign.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (208,20071219091413,'997seqra@joshuaredman.com','<01c8425e$3014fce0$08b47a57@997seqra>\n','{Spam?} Let's chat\n','OK. Stored as call ID# 30','\n',0); INSERT INTO perlDesk_emaillog VALUES (209,20071219091413,'\"Support\" ',NULL,'{100-30} {Spam?} Let's chat\n','message sent successfully using template user_newcall.email','997seqra@joshuaredman.com',0); INSERT INTO perlDesk_emaillog VALUES (210,20071219091414,'\"Support\" ',NULL,'{100-30} {Spam?} Let's chat\n','message sent successfully using template staff_newcall.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (211,20071219110133,'\"Support\" ',NULL,'Ticket #15 assigned to you','message sent successfully using template staff_assign.email','john@logicdemo.com',0); INSERT INTO perlDesk_emaillog VALUES (212,20071219110133,'\"Support\" ',NULL,'{100-15} Assign ticket: THIS DEMO IS RESET EVERY HOUR\n','message sent successfully using template staff_reassign.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (213,20071219121822,'esme@one2one.net','<000701c84284$03ba47d7$db2dd5a0@jdssnh>\n','{Spam?} Did you forget to take your meds perldesk?\n','OK. Stored as call ID# 31','\n',0); INSERT INTO perlDesk_emaillog VALUES (214,20071219121822,'\"Support\" ',NULL,'{100-31} {Spam?} Did you forget to take your meds perldesk?\n','message sent successfully using template user_newcall.email','esme@one2one.net',0); INSERT INTO perlDesk_emaillog VALUES (215,20071219121822,'\"Support\" ',NULL,'{100-31} {Spam?} Did you forget to take your meds perldesk?\n','message sent successfully using template staff_newcall.email','helpme@helpme.com',0); INSERT INTO perlDesk_emaillog VALUES (216,20071219124919,'zen82654@zen.co.uk','<7.0.1.0.2.20071219184830.033b1328@zen.co.uk>\n','{Spam?} \n','deleted by matching rule','perldesk@logicdemo.com\n',0); -- -- Table structure for table `perlDesk_files` -- CREATE TABLE perlDesk_files ( id int(11) unsigned NOT NULL auto_increment, cid int(11) default NULL, nid int(11) default NULL, filename varchar(255) NOT NULL default '', file varchar(255) NOT NULL default '', kb int(11) default NULL, type text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_files` -- INSERT INTO perlDesk_files VALUES (1,11,NULL,'image001.gif','/home/demo/uploads/calls/11/96614.gif',NULL,NULL); -- -- Table structure for table `perlDesk_kb_acronym` -- CREATE TABLE perlDesk_kb_acronym ( id int(11) unsigned NOT NULL auto_increment, letter char(1) default NULL, acronym varchar(255) default NULL, acronymname varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_kb_acronym` -- -- -- Table structure for table `perlDesk_kb_cat` -- CREATE TABLE perlDesk_kb_cat ( id int(11) unsigned NOT NULL auto_increment, category varchar(255) default NULL, parent_category int(11) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_kb_cat` -- INSERT INTO perlDesk_kb_cat VALUES (1,'Printer Problems',0); INSERT INTO perlDesk_kb_cat VALUES (2,'Software Issues',0); INSERT INTO perlDesk_kb_cat VALUES (3,'New Category',0); INSERT INTO perlDesk_kb_cat VALUES (4,'Sub of New Category',3); -- -- Table structure for table `perlDesk_kb_comments` -- CREATE TABLE perlDesk_kb_comments ( id int(11) unsigned NOT NULL auto_increment, article_id int(11) default NULL, name varchar(255) default NULL, email varchar(255) default NULL, comments text, PRIMARY KEY (id), KEY article_id (article_id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_kb_comments` -- -- -- Table structure for table `perlDesk_kb_entries` -- CREATE TABLE perlDesk_kb_entries ( id int(11) unsigned NOT NULL auto_increment, category varchar(255) default NULL, catid int(11) default NULL, author varchar(255) default NULL, subject varchar(255) default NULL, keywords text, description text, views varchar(50) default NULL, stamp timestamp(14) NOT NULL, filetype varchar(255) default NULL, fileid int(11) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_kb_entries` -- INSERT INTO perlDesk_kb_entries VALUES (1,NULL,1,'John Demo','Please Note!','test ','

Please note that the data in this demonstration install of PerlDesk is reset every 2 hours!

Thank you

 

 

 

','19',20061117051827,'',0); INSERT INTO perlDesk_kb_entries VALUES (2,NULL,1,'John Demo','What you can do with PerlDesk..','','

With PerlDesk you can...

  • Have live chat with your web site visitors from your support portal
  • Allow your visitors/customers to submit help desk records by email and this web based interface
  • Respond by the staff interface,assign emails to departments, staff members and set priorities.
  • View Reporting on how issues are handled, and when!
  • Upload your own download files for users
  • Create Troubleshooters (step by step guides)
  • Create an Article database.. with articles like this one, they can contain pictures, HTML and are easily formatted.
  • Create announcements to users/staff.

and many many more.. email sales@perldesk.com if you have any specific questions!

 
You can also integrate PerlDesk with

  • Skype! You can enable Skype integration in the admin and allow visitors to contact you through Skype.
  • vBulletin forum integration, you can tie PerlDesk into your vBulletin - which will allow you to merge user records and show latest posts on the PerlDesk portal home page. 

 

 

','27',20061117051900,'',0); -- -- Table structure for table `perlDesk_kb_glossary` -- CREATE TABLE perlDesk_kb_glossary ( id int(11) unsigned NOT NULL auto_increment, letter char(1) default NULL, shortname varchar(255) default NULL, description text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_kb_glossary` -- -- -- Table structure for table `perlDesk_kb_ratings` -- CREATE TABLE perlDesk_kb_ratings ( id int(11) unsigned NOT NULL auto_increment, article_id int(11) default NULL, word_id int(11) default NULL, rating int(2) default NULL, PRIMARY KEY (id), KEY article_id (article_id), KEY word_id (word_id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_kb_ratings` -- INSERT INTO perlDesk_kb_ratings VALUES (1,1,8,2); INSERT INTO perlDesk_kb_ratings VALUES (2,1,32,5); INSERT INTO perlDesk_kb_ratings VALUES (3,1,26,5); INSERT INTO perlDesk_kb_ratings VALUES (4,1,25,1); INSERT INTO perlDesk_kb_ratings VALUES (5,1,16,2); INSERT INTO perlDesk_kb_ratings VALUES (6,1,14,3); INSERT INTO perlDesk_kb_ratings VALUES (7,1,10,1); INSERT INTO perlDesk_kb_ratings VALUES (8,1,1,0); INSERT INTO perlDesk_kb_ratings VALUES (9,1,27,1); INSERT INTO perlDesk_kb_ratings VALUES (10,1,4,1); INSERT INTO perlDesk_kb_ratings VALUES (11,1,23,1); INSERT INTO perlDesk_kb_ratings VALUES (12,1,2,0); INSERT INTO perlDesk_kb_ratings VALUES (13,1,20,2); INSERT INTO perlDesk_kb_ratings VALUES (14,1,19,1); INSERT INTO perlDesk_kb_ratings VALUES (15,1,13,1); INSERT INTO perlDesk_kb_ratings VALUES (16,1,5,1); INSERT INTO perlDesk_kb_ratings VALUES (17,1,7,3); INSERT INTO perlDesk_kb_ratings VALUES (18,1,3,5); INSERT INTO perlDesk_kb_ratings VALUES (19,1,24,0); INSERT INTO perlDesk_kb_ratings VALUES (20,1,22,1); INSERT INTO perlDesk_kb_ratings VALUES (21,1,12,1); INSERT INTO perlDesk_kb_ratings VALUES (22,1,9,1); INSERT INTO perlDesk_kb_ratings VALUES (23,1,11,1); INSERT INTO perlDesk_kb_ratings VALUES (24,1,15,2); INSERT INTO perlDesk_kb_ratings VALUES (25,1,6,1); INSERT INTO perlDesk_kb_ratings VALUES (26,1,28,3); INSERT INTO perlDesk_kb_ratings VALUES (27,1,21,1); INSERT INTO perlDesk_kb_ratings VALUES (28,1,30,1); INSERT INTO perlDesk_kb_ratings VALUES (29,1,17,1); INSERT INTO perlDesk_kb_ratings VALUES (30,1,18,1); INSERT INTO perlDesk_kb_ratings VALUES (31,1,31,0); INSERT INTO perlDesk_kb_ratings VALUES (32,1,29,4); INSERT INTO perlDesk_kb_ratings VALUES (33,2,35,2); INSERT INTO perlDesk_kb_ratings VALUES (34,2,34,0); INSERT INTO perlDesk_kb_ratings VALUES (35,2,3,3); INSERT INTO perlDesk_kb_ratings VALUES (36,2,33,0); -- -- Table structure for table `perlDesk_kb_stats` -- CREATE TABLE perlDesk_kb_stats ( id int(11) unsigned NOT NULL auto_increment, article_id int(11) default NULL, number int(11) default NULL, date date default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_kb_stats` -- INSERT INTO perlDesk_kb_stats VALUES (1,1,1,'2006-11-17'); INSERT INTO perlDesk_kb_stats VALUES (2,2,4,'2006-11-17'); INSERT INTO perlDesk_kb_stats VALUES (3,2,1,'2007-09-18'); INSERT INTO perlDesk_kb_stats VALUES (4,1,1,'2007-09-18'); INSERT INTO perlDesk_kb_stats VALUES (5,1,13,'2007-12-18'); INSERT INTO perlDesk_kb_stats VALUES (6,2,13,'2007-12-18'); INSERT INTO perlDesk_kb_stats VALUES (7,2,9,'2007-12-19'); INSERT INTO perlDesk_kb_stats VALUES (8,1,4,'2007-12-19'); -- -- Table structure for table `perlDesk_kb_words` -- CREATE TABLE perlDesk_kb_words ( id int(11) unsigned NOT NULL auto_increment, word varchar(255) default NULL, PRIMARY KEY (id), UNIQUE KEY word (word) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_kb_words` -- INSERT INTO perlDesk_kb_words VALUES (1,'pstrongexample'); INSERT INTO perlDesk_kb_words VALUES (2,'articlestrongppthis'); INSERT INTO perlDesk_kb_words VALUES (3,'article'); INSERT INTO perlDesk_kb_words VALUES (4,'has'); INSERT INTO perlDesk_kb_words VALUES (5,'been'); INSERT INTO perlDesk_kb_words VALUES (6,'created'); INSERT INTO perlDesk_kb_words VALUES (7,'in'); INSERT INTO perlDesk_kb_words VALUES (8,'the'); INSERT INTO perlDesk_kb_words VALUES (9,'staff'); INSERT INTO perlDesk_kb_words VALUES (10,'area'); INSERT INTO perlDesk_kb_words VALUES (11,'using'); INSERT INTO perlDesk_kb_words VALUES (12,'wysiwyg'); INSERT INTO perlDesk_kb_words VALUES (13,'editor'); INSERT INTO perlDesk_kb_words VALUES (14,'you'); INSERT INTO perlDesk_kb_words VALUES (15,'can'); INSERT INTO perlDesk_kb_words VALUES (16,'add'); INSERT INTO perlDesk_kb_words VALUES (17,'pictures'); INSERT INTO perlDesk_kb_words VALUES (18,'and'); INSERT INTO perlDesk_kb_words VALUES (19,'html'); INSERT INTO perlDesk_kb_words VALUES (20,'to'); INSERT INTO perlDesk_kb_words VALUES (21,'your'); INSERT INTO perlDesk_kb_words VALUES (22,'articles'); INSERT INTO perlDesk_kb_words VALUES (23,'perldesk'); INSERT INTO perlDesk_kb_words VALUES (24,'ppnbspyou'); INSERT INTO perlDesk_kb_words VALUES (25,'even'); INSERT INTO perlDesk_kb_words VALUES (26,'a'); INSERT INTO perlDesk_kb_words VALUES (27,'file'); INSERT INTO perlDesk_kb_words VALUES (28,'as'); INSERT INTO perlDesk_kb_words VALUES (29,'an'); INSERT INTO perlDesk_kb_words VALUES (30,'such'); INSERT INTO perlDesk_kb_words VALUES (31,'pdfppnbspppnbspp'); INSERT INTO perlDesk_kb_words VALUES (32,'test'); INSERT INTO perlDesk_kb_words VALUES (33,'ptesting'); INSERT INTO perlDesk_kb_words VALUES (34,'systemppnbspppnbspp'); INSERT INTO perlDesk_kb_words VALUES (35,'second'); -- -- Table structure for table `perlDesk_mailrules` -- CREATE TABLE perlDesk_mailrules ( id int(11) unsigned NOT NULL auto_increment, rule_id int(11) default NULL, rule int(5) default NULL, action int(5) default NULL, text text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_mailrules` -- INSERT INTO perlDesk_mailrules VALUES (1,1198089660,2,NULL,'{Spam?}'); INSERT INTO perlDesk_mailrules VALUES (2,1198089660,NULL,7,'on'); -- -- Table structure for table `perlDesk_messages` -- CREATE TABLE perlDesk_messages ( id int(11) unsigned NOT NULL auto_increment, touser varchar(50) NOT NULL default '', sender varchar(50) NOT NULL default '', date varchar(20) NOT NULL default '', subject varchar(255) NOT NULL default '', message text NOT NULL, stamp varchar(20) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_messages` -- -- -- Table structure for table `perlDesk_notedrafts` -- CREATE TABLE perlDesk_notedrafts ( id int(11) unsigned NOT NULL auto_increment, owner char(1) default NULL, visible char(1) default NULL, action varchar(255) default NULL, call int(11) default NULL, author varchar(255) default NULL, time varchar(20) default NULL, ikey varchar(255) default NULL, comment text, poster_ip varchar(40) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_notedrafts` -- INSERT INTO perlDesk_notedrafts VALUES (2,'1','1',NULL,24,'staff','19-12-2007-08:45','KE0eeM8W12','Dear Customer,\n\nWe would like to thank you for your email relating to your problem with the printer. Please find below a suitable resolutions:\n\nbla bla bla\n\nThank you \n\nCustomer Services\n\n','68.106.198.168'); -- -- Table structure for table `perlDesk_notes` -- CREATE TABLE perlDesk_notes ( id int(11) unsigned NOT NULL auto_increment, owner char(1) default NULL, visible char(1) default NULL, action varchar(255) default NULL, call int(11) default NULL, author varchar(255) default NULL, time varchar(20) default NULL, ikey varchar(255) default NULL, comment text, poster_ip varchar(40) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_notes` -- INSERT INTO perlDesk_notes VALUES (1,'0','1',NULL,2,'demo','17-11-2006-05:03','A..Za..z0..9a..z0..90..9A..Za..za..za..z','Test reply','81.157.47.160'); INSERT INTO perlDesk_notes VALUES (2,'0','1',NULL,3,'demo','17-11-2006-05:03','a..za..za..zA..Z0..9A..Z0..9A..Z0..9a..z','Ho','81.157.47.160'); INSERT INTO perlDesk_notes VALUES (3,'1','1',NULL,6,'staff','17-11-2006-05:14','8iXfvor7qL','teest','81.157.47.160'); INSERT INTO perlDesk_notes VALUES (4,'1','1',NULL,6,'staff','17-11-2006-05:14','UOUaLiMg3K','test2','81.157.47.160'); INSERT INTO perlDesk_notes VALUES (5,'1','1',NULL,13,'staff','7-12-2007-00:08','SsaqwLVgkX','Test response, this is a response from staff','86.154.244.205'); INSERT INTO perlDesk_notes VALUES (6,'0','1',NULL,13,'Unregistered','7-12-2007-00:09','TV2Ws3XvRj','And this is a response direct from my email client as the customer!\n\n','IP Unknown'); INSERT INTO perlDesk_notes VALUES (7,'1','1',NULL,12,'staff','7-12-2007-00:10','Ur8M0A3rA3','Example staff reply','86.154.244.205'); INSERT INTO perlDesk_notes VALUES (8,'1','1',NULL,19,'staff','18-12-2007-09:15','iwV4dY3j9v','This is a note','38.104.28.6'); INSERT INTO perlDesk_notes VALUES (9,'1','1',NULL,19,'staff','18-12-2007-09:16','74y44j81br','Dear Customer,\r\n\r\nWe would like to thank you for your email relating to your problem with the printer. Please find below a suitable resolutions:\r\n\r\nbla bla bla\r\n\r\nThank you \r\n\r\nCustomer Services\r\n','38.104.28.6'); INSERT INTO perlDesk_notes VALUES (10,'1','1','OPEN',13,'staff','18-12-2007-09:37','3o42viNRic','testing due date','74.218.200.2'); INSERT INTO perlDesk_notes VALUES (11,'0','1',NULL,19,'gggggg','18-12-2007-11:20','YNR3s85ZBK','Hi please stop sending me these emails.\n\nthanks,\nGary\n\nOn 18/12/2007, Billing Department <perldesk2@logicdemo.com> wrote:\n>\n> Thank you for submitting a support request. A summary of your request is below:\n>\n> -----------------------------------------------------------\n> Details [Submitted 18-12-2007-09:14 ]\n> -----------------------------------------------------------\n>\n> ID............: 19\n> Viewing Key...: NOPATR\n>\n> Name..........: gggggg\n> Subject.......: New Ticket\n>\n> -----------------------------------------------------------\n>\n>\n> Registered users may login to track the status of their request : http://perldesk.logicdemo.com/pdesk.cgi?do=track_call&id=19&key=NOPATR\n>\n> Thank you,\n>\n> Thank You.\n>\n>\n\n','IP Unknown'); INSERT INTO perlDesk_notes VALUES (12,'3','1','ASSIGN',21,'staff','18-12-2007-12:04','hbFDHwdhlw','','24.119.60.94'); INSERT INTO perlDesk_notes VALUES (13,'1','1',NULL,21,'staff','18-12-2007-12:06','tcmyY1gd5f','Dear Customer,\r\n\r\nWe would like to thank you for your email relating to your problem with the printer. Please find below a suitable resolutions:\r\n\r\nbla bla bla\r\n\r\nThank you \r\n\r\nCustomer Services\r\nHi There\r\n\r\nMany Thanks for your email, we have received your request for some extra bandwidth and will update your account shortly.\r\n\r\nThanks\r\nDear Customer,\r\n\r\nWe would like to thank you for your email relating to your problem with the printer. Please find below a suitable resolutions:\r\n\r\nbla bla bla\r\n\r\nThank you \r\n\r\nCustomer Services\r\n','24.119.60.94'); INSERT INTO perlDesk_notes VALUES (14,'1','1','OPEN',19,'staff','18-12-2007-12:11','JtcivGISJu','> what can I see as a customer\r\n\r\nPlease view the demo customer interface located here: \r\n\r\nhttp://perldesk.logicdemo.com/\r\n\r\nlogon: demo pw: demo\r\n\r\n\r\n\r\n','24.119.60.94'); INSERT INTO perlDesk_notes VALUES (15,'0','1',NULL,19,'gggggg','18-12-2007-12:16','CuCPwGTgYT','Please stop sending me these emails\n\nOn 18/12/2007, Billing Department <perldesk2@logicdemo.com> wrote:\n> &gt; what can I see as a customer\n>\n> Please view the demo customer interface located here:\n>\n> http://perldesk.logicdemo.com/\n>\n> logon: demo pw: demo\n>\n>\n>\n>\n>\n> Thanks for using the help desk, if you have any further difficulties or are required to respond to your request, please login to the help desk\n>\n>\n> _______________________________________________\n>\n> Was this response helpful? We would be grateful if you would submit a short rating for this response as part of our satisfaction monitoring.\n>\n> http://perldesk.logicdemo.com/pdesk.cgi?do=rate_response&nid=14&key=JtcivGISJu\n>\n>\n>\n> View Your Ticket Online: http://perldesk.logicdemo.com/pdesk.cgi?do=track_call&id=19&key=NOPATR\n> _______________________________________________\n>\n> Thank you,\n>\n>\n\n','IP Unknown'); INSERT INTO perlDesk_notes VALUES (16,'3','1','ASSIGN',24,'staff','18-12-2007-22:05','sfAqKgRiRg','','69.133.102.114'); INSERT INTO perlDesk_notes VALUES (17,'1','1','OPEN',29,'staff','19-12-2007-08:47','TXlotYF9MR','Dear Customer,\r\n\r\nWe would like to thank you for your email relating to your problem with the printer. Please find below a suitable resolutions:\r\n\r\nbla bla bla\r\n\r\nThank you \r\n\r\nCustomer Services\r\n> Hello again---\r\n> \r\n> this is a TEST\r\n','68.106.198.168'); INSERT INTO perlDesk_notes VALUES (18,'3','1','ASSIGN',15,'staff','19-12-2007-11:01','OcUmGKZgej','','88.114.99.203'); -- -- Table structure for table `perlDesk_popservers` -- CREATE TABLE perlDesk_popservers ( id int(11) unsigned NOT NULL auto_increment, pop_host varchar(255) NOT NULL default '', pop_user varchar(255) NOT NULL default '', pop_password varchar(255) NOT NULL default '', pop_port varchar(5) NOT NULL default '', stay_emails int(3) default NULL, use_ssl int(3) default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_popservers` -- -- -- Table structure for table `perlDesk_popservers_poplog` -- CREATE TABLE perlDesk_popservers_poplog ( id int(11) unsigned NOT NULL auto_increment, mail_id varchar(255) NOT NULL default '', stamp timestamp(14) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_popservers_poplog` -- -- -- Table structure for table `perlDesk_preans` -- CREATE TABLE perlDesk_preans ( id int(11) unsigned NOT NULL auto_increment, author varchar(25) default NULL, subject varchar(255) default NULL, text text, date varchar(20) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_preans` -- INSERT INTO perlDesk_preans VALUES (1,'admin','Example Pre-Defined Response 1','Dear Customer,\r\n\r\nWe would like to thank you for your email relating to your problem with the printer. Please find below a suitable resolutions:\r\n\r\nbla bla bla\r\n\r\nThank you \r\n\r\nCustomer Services',''); INSERT INTO perlDesk_preans VALUES (2,'admin','Example Pre-Defined Response 2','Hi There\r\n\r\nMany Thanks for your email, we have received your request for some extra bandwidth and will update your account shortly.\r\n\r\nThanks',''); -- -- Table structure for table `perlDesk_reviews` -- CREATE TABLE perlDesk_reviews ( id int(11) unsigned NOT NULL auto_increment, owner varchar(255) default NULL, staff varchar(255) default NULL, nid varchar(255) default NULL, rating varchar(255) default NULL, comments text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_reviews` -- INSERT INTO perlDesk_reviews VALUES (1,'','staff','13','3',''); INSERT INTO perlDesk_reviews VALUES (2,'test','staff','17','1','This guy sux'); -- -- Table structure for table `perlDesk_settings` -- CREATE TABLE perlDesk_settings ( setting varchar(50) NOT NULL default '', value varchar(225) default NULL, PRIMARY KEY (setting) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_settings` -- INSERT INTO perlDesk_settings VALUES ('sess_ip','1'); INSERT INTO perlDesk_settings VALUES ('pri5','#CCCCFF'); INSERT INTO perlDesk_settings VALUES ('floodwait','15'); INSERT INTO perlDesk_settings VALUES ('imgbase','http://perldesk.logicdemo.com/images'); INSERT INTO perlDesk_settings VALUES ('db_version','1234'); INSERT INTO perlDesk_settings VALUES ('epre','100'); INSERT INTO perlDesk_settings VALUES ('baseurl','http://perldesk.logicdemo.com'); INSERT INTO perlDesk_settings VALUES ('adminemail','webmaster@perldesk.logicdemo.com'); INSERT INTO perlDesk_settings VALUES ('default_auto_close','7'); INSERT INTO perlDesk_settings VALUES ('sendmail','/usr/sbin/sendmail'); INSERT INTO perlDesk_settings VALUES ('pri4','#CCFF99'); INSERT INTO perlDesk_settings VALUES ('global_form','0'); INSERT INTO perlDesk_settings VALUES ('data','/home/demo/public_html/perldesk'); INSERT INTO perlDesk_settings VALUES ('ereqreg','0'); INSERT INTO perlDesk_settings VALUES ('enable_lock_while_respond','1'); INSERT INTO perlDesk_settings VALUES ('sdelete','1'); INSERT INTO perlDesk_settings VALUES ('title','PerlDesk'); INSERT INTO perlDesk_settings VALUES ('timeoffset','0'); INSERT INTO perlDesk_settings VALUES ('pageraddr',''); INSERT INTO perlDesk_settings VALUES ('reqvalid','0'); INSERT INTO perlDesk_settings VALUES ('ssi_closed','0'); INSERT INTO perlDesk_settings VALUES ('pri3','#FFFF99'); INSERT INTO perlDesk_settings VALUES ('pri2','#FFCC99'); INSERT INTO perlDesk_settings VALUES ('validate','0'); INSERT INTO perlDesk_settings VALUES ('kb_req_user','0'); INSERT INTO perlDesk_settings VALUES ('language','en'); INSERT INTO perlDesk_settings VALUES ('pri1','#FF9999'); INSERT INTO perlDesk_settings VALUES ('license_id','ONI8SNT4NJGA42A'); INSERT INTO perlDesk_settings VALUES ('logo_url','http://perldesk.logicdemo.com/images/v4/PerlDesk_Logo.png'); INSERT INTO perlDesk_settings VALUES ('slock','0'); INSERT INTO perlDesk_settings VALUES ('avgtime','0'); INSERT INTO perlDesk_settings VALUES ('pager','0'); INSERT INTO perlDesk_settings VALUES ('max_auto_close','12'); INSERT INTO perlDesk_settings VALUES ('sub_status_list','CREATED,IN PROGRESS,CONFIRMED,QUERIED,REJECTED'); INSERT INTO perlDesk_settings VALUES ('subj_delimiter_left','{'); INSERT INTO perlDesk_settings VALUES ('user_see_due_date','0'); INSERT INTO perlDesk_settings VALUES ('user_see_sub_status','0'); INSERT INTO perlDesk_settings VALUES ('subj_delimiter_right','}'); INSERT INTO perlDesk_settings VALUES ('user_see_internal_deps','0'); INSERT INTO perlDesk_settings VALUES ('autoreg_from_email','0'); INSERT INTO perlDesk_settings VALUES ('default_sub_status','CREATED'); INSERT INTO perlDesk_settings VALUES ('main_from_email','perldesk@logicdemo.com'); INSERT INTO perlDesk_settings VALUES ('date_format','0'); INSERT INTO perlDesk_settings VALUES ('main_from_name','Support'); INSERT INTO perlDesk_settings VALUES ('enablemail','1'); INSERT INTO perlDesk_settings VALUES ('int_answer','0'); INSERT INTO perlDesk_settings VALUES ('send_attachments','0'); INSERT INTO perlDesk_settings VALUES ('kb_related_int_answer','0'); INSERT INTO perlDesk_settings VALUES ('db_backup_dir','/home/demo/www/perldesk/backup'); INSERT INTO perlDesk_settings VALUES ('staff_usergroup_respond','0'); -- -- Table structure for table `perlDesk_settings_extra` -- CREATE TABLE perlDesk_settings_extra ( setting varchar(50) NOT NULL default '', value text, PRIMARY KEY (setting) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_settings_extra` -- INSERT INTO perlDesk_settings_extra VALUES ('staff_default_template','v4'); INSERT INTO perlDesk_settings_extra VALUES ('admin_default_template','v4'); INSERT INTO perlDesk_settings_extra VALUES ('user_default_template','v4'); INSERT INTO perlDesk_settings_extra VALUES ('forum_host',''); INSERT INTO perlDesk_settings_extra VALUES ('forum_dbname',''); INSERT INTO perlDesk_settings_extra VALUES ('access_rate','1'); INSERT INTO perlDesk_settings_extra VALUES ('default_tab','New'); INSERT INTO perlDesk_settings_extra VALUES ('forum_password',''); INSERT INTO perlDesk_settings_extra VALUES ('forum_url',''); INSERT INTO perlDesk_settings_extra VALUES ('forum_type','vb3'); INSERT INTO perlDesk_settings_extra VALUES ('forum_auth','0'); INSERT INTO perlDesk_settings_extra VALUES ('skype_name','test'); INSERT INTO perlDesk_settings_extra VALUES ('articles_feature','1'); INSERT INTO perlDesk_settings_extra VALUES ('access_submit','0'); INSERT INTO perlDesk_settings_extra VALUES ('em_header',''); INSERT INTO perlDesk_settings_extra VALUES ('tickets_count','10'); INSERT INTO perlDesk_settings_extra VALUES ('forum_showthreads','0'); INSERT INTO perlDesk_settings_extra VALUES ('signup_notification','0'); INSERT INTO perlDesk_settings_extra VALUES ('pass_chars','6'); INSERT INTO perlDesk_settings_extra VALUES ('access_view','0'); INSERT INTO perlDesk_settings_extra VALUES ('file_path','/home/demo/uploads'); INSERT INTO perlDesk_settings_extra VALUES ('forum_username',''); INSERT INTO perlDesk_settings_extra VALUES ('forum_tableprefix',''); INSERT INTO perlDesk_settings_extra VALUES ('forum_port',''); INSERT INTO perlDesk_settings_extra VALUES ('skype_feature','1'); INSERT INTO perlDesk_settings_extra VALUES ('use_smtp','0'); INSERT INTO perlDesk_settings_extra VALUES ('em_footer',''); INSERT INTO perlDesk_settings_extra VALUES ('livechat_feature','1'); INSERT INTO perlDesk_settings_extra VALUES ('smtp_address',''); INSERT INTO perlDesk_settings_extra VALUES ('access_respond','0'); INSERT INTO perlDesk_settings_extra VALUES ('smtp_port','25'); INSERT INTO perlDesk_settings_extra VALUES ('staff_rating','1'); INSERT INTO perlDesk_settings_extra VALUES ('downloads_feature','1'); INSERT INTO perlDesk_settings_extra VALUES ('email_convert_charset','Default'); INSERT INTO perlDesk_settings_extra VALUES ('md5_sum',''); INSERT INTO perlDesk_settings_extra VALUES ('ldap_domain',''); INSERT INTO perlDesk_settings_extra VALUES ('max_attachment_size',''); INSERT INTO perlDesk_settings_extra VALUES ('ldap_host',''); INSERT INTO perlDesk_settings_extra VALUES ('smtp_pwd',''); INSERT INTO perlDesk_settings_extra VALUES ('smtp_login',''); INSERT INTO perlDesk_settings_extra VALUES ('extension_attachment_allow',''); INSERT INTO perlDesk_settings_extra VALUES ('tshooter_feature','0'); INSERT INTO perlDesk_settings_extra VALUES ('email_max_size',''); INSERT INTO perlDesk_settings_extra VALUES ('max_attachments','0'); INSERT INTO perlDesk_settings_extra VALUES ('extension_attachment_forbid',''); INSERT INTO perlDesk_settings_extra VALUES ('output_mail_charset',''); INSERT INTO perlDesk_settings_extra VALUES ('no_auto_answer_on_email','0'); INSERT INTO perlDesk_settings_extra VALUES ('output_mail_type','text/plain'); INSERT INTO perlDesk_settings_extra VALUES ('ldap_auth','0'); INSERT INTO perlDesk_settings_extra VALUES ('make_email_check','0'); INSERT INTO perlDesk_settings_extra VALUES ('output_charset',''); INSERT INTO perlDesk_settings_extra VALUES ('smtp_auth','NO AUTH'); INSERT INTO perlDesk_settings_extra VALUES ('ldap_auth_staff','0'); INSERT INTO perlDesk_settings_extra VALUES ('captcha','1'); INSERT INTO perlDesk_settings_extra VALUES ('ldap_email_domain',''); -- -- Table structure for table `perlDesk_signup_fields` -- CREATE TABLE perlDesk_signup_fields ( id int(11) unsigned NOT NULL auto_increment, name varchar(255) default NULL, value varchar(255) default NULL, dorder varchar(10) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_signup_fields` -- INSERT INTO perlDesk_signup_fields VALUES (1,'Company','{company}','1'); INSERT INTO perlDesk_signup_fields VALUES (2,'URL','{url}','2'); -- -- Table structure for table `perlDesk_signup_values` -- CREATE TABLE perlDesk_signup_values ( id int(11) unsigned NOT NULL auto_increment, cid varchar(10) default NULL, sid varchar(10) default NULL, value varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_signup_values` -- INSERT INTO perlDesk_signup_values VALUES (1,'1','1','Hello, nice site look this:\r\nhttp://www.1url.org/go/1kuw9 Polyphonic Ringtones [url=http://www.1url.org/go/1kuw9]Polyphonic Ringtones[/url]\nhttp://www.1url.org/go/1td4 Funny Ring'); INSERT INTO perlDesk_signup_values VALUES (2,'1','2','Hello, nice site look this:\r\nhttp://www.1url.org/go/1kuw9 Polyphonic Ringtones [url=http://www.1url.org/go/1kuw9]Polyphonic Ringtones[/url]\nhttp://www.1url.org/go/1td4 Funny Ring'); INSERT INTO perlDesk_signup_values VALUES (3,'2','1','demo'); INSERT INTO perlDesk_signup_values VALUES (4,'2','2','demo'); INSERT INTO perlDesk_signup_values VALUES (5,'3','1','as'); INSERT INTO perlDesk_signup_values VALUES (6,'3','2',NULL); INSERT INTO perlDesk_signup_values VALUES (7,'4','1','ggg'); INSERT INTO perlDesk_signup_values VALUES (8,'4','2',''); -- -- Table structure for table `perlDesk_staff` -- CREATE TABLE perlDesk_staff ( id int(11) unsigned NOT NULL auto_increment, username varchar(20) default NULL, password varchar(255) default NULL, name varchar(50) default NULL, email varchar(50) default NULL, access varchar(255) default NULL, notify char(1) default NULL, responsetime varchar(20) default NULL, callsclosed varchar(10) default NULL, signature text, rkey char(2) default NULL, lpage varchar(255) default NULL, play_sound char(1) default NULL, llogin varchar(255) default NULL, address text, city text, state text, zip text, country text, phone text, mobile text, comments text, template text, number_new_main int(11) default NULL, awatar int(11) default NULL, report_access int(1) default NULL, redirect_answer int(1) default NULL, currenttask int(11) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_staff` -- INSERT INTO perlDesk_staff VALUES (1,'admin','75jb5OkNiRhm6','admin','webmaster@perldesk.logicdemo.com','admin',NULL,NULL,NULL,NULL,'75',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'v4',NULL,NULL,NULL,NULL,NULL); INSERT INTO perlDesk_staff VALUES (2,'staff','4sJQyQCFdetBU','John Demo','john@logicdemo.com',NULL,'0','0','0','','4s','0',NULL,'Never','.','.','.','.','.','.','.','.','v4',0,NULL,1,0,1); INSERT INTO perlDesk_staff VALUES (3,'helpme','QwhxBwovEExXI','helpme','helpme@helpme.com',NULL,'1','0','0',NULL,'Qw','0','0','Never','123anywhere','nowhere','somewhere','00000','anyplace','(000) 000-0000','(111) 111-1111','',NULL,NULL,NULL,1,NULL,NULL); INSERT INTO perlDesk_staff VALUES (4,'test','EOHex0NX0hCHc','test','test@logc.com',NULL,'0','0','0',NULL,'EO','0','0','Never','','','','','','','','',NULL,NULL,NULL,0,NULL,NULL); -- -- Table structure for table `perlDesk_staffaccess` -- CREATE TABLE perlDesk_staffaccess ( staff_id int(11) default NULL, dep_id int(11) default NULL ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_staffaccess` -- INSERT INTO perlDesk_staffaccess VALUES (2,1); INSERT INTO perlDesk_staffaccess VALUES (3,-1); INSERT INTO perlDesk_staffaccess VALUES (3,2); INSERT INTO perlDesk_staffaccess VALUES (3,1); INSERT INTO perlDesk_staffaccess VALUES (2,2); -- -- Table structure for table `perlDesk_staffactive` -- CREATE TABLE perlDesk_staffactive ( username varchar(20) NOT NULL default '', date varchar(20) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_staffactive` -- INSERT INTO perlDesk_staffactive VALUES ('staff','1198091043'); INSERT INTO perlDesk_staffactive VALUES ('helpme','0'); INSERT INTO perlDesk_staffactive VALUES ('test','1198091032'); -- -- Table structure for table `perlDesk_stafflogin` -- CREATE TABLE perlDesk_stafflogin ( username varchar(50) default NULL, date varchar(20) default NULL ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_stafflogin` -- INSERT INTO perlDesk_stafflogin VALUES ('staff','19-12-2007-12:50'); INSERT INTO perlDesk_stafflogin VALUES ('helpme','Never'); INSERT INTO perlDesk_stafflogin VALUES ('test','19-12-2007-11:44'); -- -- Table structure for table `perlDesk_staffread` -- CREATE TABLE perlDesk_staffread ( username varchar(50) NOT NULL default '', date varchar(20) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_staffread` -- INSERT INTO perlDesk_staffread VALUES ('staff','1198090418'); INSERT INTO perlDesk_staffread VALUES ('helpme','0'); INSERT INTO perlDesk_staffread VALUES ('test','0'); -- -- Table structure for table `perlDesk_survey` -- CREATE TABLE perlDesk_survey ( id int(11) unsigned NOT NULL auto_increment, order int(11) default NULL, text varchar(30) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_survey` -- INSERT INTO perlDesk_survey VALUES (211,0,'bullshit'); INSERT INTO perlDesk_survey VALUES (212,1,'Hehe'); INSERT INTO perlDesk_survey VALUES (213,2,'Good'); INSERT INTO perlDesk_survey VALUES (214,3,'Stupendous'); INSERT INTO perlDesk_survey VALUES (215,4,'Sucks big time'); -- -- Table structure for table `perlDesk_taskbar` -- CREATE TABLE perlDesk_taskbar ( id int(11) unsigned NOT NULL auto_increment, username varchar(50) default NULL, last_call varchar(50) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_taskbar` -- -- -- Table structure for table `perlDesk_tasks` -- CREATE TABLE perlDesk_tasks ( id int(11) NOT NULL auto_increment, user_id int(11) default NULL, name varchar(50) default NULL, details varchar(255) default NULL, time datetime default NULL, notify tinyint(4) default NULL, notify_type tinyint(4) default NULL, notify_earlier int(11) default NULL, notify_email varchar(255) default NULL, your_period int(11) default NULL, status tinyint(4) default NULL, stamp timestamp(14) NOT NULL, callid int(11) default NULL, progress int(11) default '0', lastingdays int(11) default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_tasks` -- INSERT INTO perlDesk_tasks VALUES (1,2,'Executive Meeting','This is an example task in PerlDesk, you can create and manage your tasks via the \'Tasks\' menu above. \r\n','2007-12-07 01:09:00',0,0,0,'',0,1,20071207000951,NULL,50,5); INSERT INTO perlDesk_tasks VALUES (2,3,'replace computer','replace april\'s computer','2007-12-18 13:57:00',0,0,0,'',0,1,20071218135831,NULL,0,0); -- -- Table structure for table `perlDesk_templates` -- CREATE TABLE perlDesk_templates ( id int(11) NOT NULL auto_increment, user_dir text, staff_dir text, admin_dir text, name text, img_dir text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_templates` -- -- -- Table structure for table `perlDesk_ticket_fields` -- CREATE TABLE perlDesk_ticket_fields ( id int(11) unsigned NOT NULL auto_increment, name varchar(255) default NULL, value varchar(255) default NULL, dorder varchar(10) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_ticket_fields` -- INSERT INTO perlDesk_ticket_fields VALUES (1,'Name','{name}','1'); -- -- Table structure for table `perlDesk_tshooter` -- CREATE TABLE perlDesk_tshooter ( id int(11) NOT NULL auto_increment, name varchar(50) default NULL, first_question_id int(11) default NULL, stamp timestamp(14) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_tshooter` -- INSERT INTO perlDesk_tshooter VALUES (1,'email',1,20071218094757); -- -- Table structure for table `perlDesk_tshooter_archive` -- CREATE TABLE perlDesk_tshooter_archive ( id int(11) NOT NULL auto_increment, tshooter_id int(11) default NULL, parent_id int(11) default NULL, name varchar(255) default NULL, question text, answer text, level tinyint(4) default NULL, action_type tinyint(4) default NULL, stamp timestamp(14) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_tshooter_archive` -- INSERT INTO perlDesk_tshooter_archive VALUES (1,1,NULL,'email','My Email doesn\'t work',NULL,0,0,20071218094757); -- -- Table structure for table `perlDesk_user_events` -- CREATE TABLE perlDesk_user_events ( id int(11) unsigned NOT NULL auto_increment, user varchar(255) default NULL, time varchar(255) default NULL, subject varchar(255) default NULL, description text, date varchar(50) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_user_events` -- -- -- Table structure for table `perlDesk_usergroups` -- CREATE TABLE perlDesk_usergroups ( id int(11) NOT NULL auto_increment, name varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_usergroups` -- INSERT INTO perlDesk_usergroups VALUES (1,'Production'); -- -- Table structure for table `perlDesk_users` -- CREATE TABLE perlDesk_users ( id int(11) unsigned NOT NULL auto_increment, username varchar(30) default NULL, password varchar(255) default NULL, name varchar(50) default NULL, email text, url varchar(50) default NULL, company varchar(50) default NULL, rkey varchar(5) default NULL, pending char(1) default NULL, active varchar(50) default NULL, acode varchar(50) default NULL, lcall varchar(255) NOT NULL default '', group_id int(11) default NULL, secondary_email text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_users` -- INSERT INTO perlDesk_users VALUES (2,'demo','ZhLPAJQL/x0Lk','bedford','demo@perldesk.com',NULL,NULL,'Zh','0','1198082925','0','1198017950',0,''); INSERT INTO perlDesk_users VALUES (3,'test','RjdbsTXpZIVg6','Test','a@a.com',NULL,NULL,'Rj','0','1197977229','0','0',NULL,NULL); INSERT INTO perlDesk_users VALUES (4,'gggggg','3iki/i.GgvdIU','g','g@mail.com',NULL,NULL,'3i','0','1197990974','0','1197990875',NULL,NULL);