[otrs-cvs] Survey/bin otrs.SurveyTriggerSendRequests.pl,1.3,1.4

Comments:
Update of /home/cvs/Survey/bin
In directory lancelot:/tmp/cvs-serv28093/bin

Modified Files:
	otrs.SurveyTriggerSendRequests.pl 
Log Message:
Fixed Bug#9544 thanx to Daniel Santos.

Author: jh

Index: otrs.SurveyTriggerSendRequests.pl
===================================================================
RCS file: /home/cvs/Survey/bin/otrs.SurveyTriggerSendRequests.pl,v
retrieving revision 1.3
retrieving revision 1.4
diff -2 -u -d -r1.3 -r1.4
--- otrs.SurveyTriggerSendRequests.pl	20 Nov 2012 19:12:44 -0000	1.3
+++ otrs.SurveyTriggerSendRequests.pl	24 Jun 2013 15:08:56 -0000	1.4
@@ -2,5 +2,5 @@
 # --
 # bin/otrs.SurveyTriggerSendRequests.pl - trigger sending delayed survey requests
-# Copyright (C) 2001-2012 OTRS AG, http://otrs.org/
+# Copyright (C) 2001-2013 OTRS AG, http://otrs.org/
 # --
 # $Id$
@@ -73,5 +73,5 @@
     print STDERR "5. You can do a dry run to get a list of surveys that would be sent (-d)\n";
     print STDERR "6. If you're fine with it, activate var/cron/generic_agent_survey.dist\n";
-    print STDERR "Copyright (C) 2001-2012 OTRS AG, http://otrs.com/\n";
+    print STDERR "Copyright (C) 2001-2013 OTRS AG, http://otrs.com/\n";
     exit;
 }
@@ -109,5 +109,5 @@
 # Find survey_requests that haven't been sent yet
 $CommonObject{DBObject}->Prepare(
-    SQL => "SELECT id, ticket_id, create_time FROM survey_request WHERE "
+    SQL => "SELECT id, ticket_id, create_time, public_survey_key FROM survey_request WHERE "
         . "(send_time IS NULL OR send_time = '0000-00-00 00:00:00') ORDER BY create_time DESC",
 );
@@ -117,7 +117,8 @@
 while ( my @Row = $CommonObject{DBObject}->FetchrowArray() ) {
     push @Rows, {
-        ID         => $Row[0],
-        TicketID   => $Row[1],
-        CreateTime => $Row[2],
+        ID              => $Row[0],
+        TicketID        => $Row[1],
+        CreateTime      => $Row[2],
+        PublicSurveyKey => $Row[3],
     };
 }
@@ -159,4 +160,5 @@
             SurveyRequestID     => $Line->{ID},
             TicketID            => $Line->{TicketID},
+            PublicSurveyKey     => $Line->{PublicSurveyKey},
         );
     }
---------------------------------------------------------------------
OTRS mailing list: cvs-log - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/cvs-log
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/cvs-log