3 # Copyright 2012 Foundations Bible College Inc.
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
25 use autouse
'Data::Dumper' => qw(Dumper);
33 my $dbh = C4
::Context
->dbh;
35 my ( $status, $cookie, $sessionID ) = C4
::Auth
::check_api_auth
( $cgi, { tools
=> 'edit_quotes' } );
36 unless ($status eq "ok") {
37 print $cgi->header(-type
=> 'application/json', -status
=> '403 Forbidden');
38 print to_json
({ auth_status
=> $status });
43 my $quotes_tmp = uri_unescape
( $cgi->param('quote' ) );
44 my $quotes = decode_json
( $quotes_tmp );
46 my $action = $cgi->param('action');
48 my $sth = $dbh->prepare('INSERT INTO quotes (source, text) VALUES (?, ?);');
52 foreach my $quote (@
$quotes) {
53 $insert_count++ if $sth->execute($quote->[1], $quote->[2]);
55 warn sprintf('Database returned the following error: %s', $sth->errstr);
60 print $cgi->header('application/json');
64 records
=> $insert_count,