Attachment #157808 for bug #34889

View | Details | Raw Unified | Return to bug 34889
Collapse All | Expand All




            # Insert any values found from system preference into additional_contents
            foreach my $lang ('default') {
                $dbh->do(
                    "INSERT INTO additional_contents ( category, code, location, branchcode, published_on ) VALUES ('html_customizations', 'PatronSelfRegistrationAdditionalInstructions', 'PatronSelfRegistrationAdditionalInstructions', NULL, CAST(NOW() AS date) )"
                );

                my ($insert_id) = $dbh->selectrow_array(
                    "SELECT id FROM additional_contents WHERE category = 'html_customizations' AND code = 'PatronSelfRegistrationAdditionalInstructions' AND location = 'PatronSelfRegistrationAdditionalInstructions' LIMIT 1",
                    {}
                );

                $dbh->do(
                    "INSERT INTO additional_contents_localizations ( additional_content_id, title, content, lang ) VALUES ( ?, ?, ?, ? )",
                    undef, $insert_id, "PatronSelfRegistrationAdditionalInstructions $lang",
                    $patronselfregistrationadditionalinstructions, $lang
                );
            }
- 

Return to bug 34889

Lines 18-25 return { Link Here

(-)a/installer/data/mysql/atomicupdate/bug-34889-move-PatronSelfRegistrationAdditionalInstructions-to-additional-contents.pl (-3 / +11 lines)
18	# Insert any values found from system preference into additional_contents	18	# Insert any values found from system preference into additional_contents
19	foreach my $lang ('default') {	19	foreach my $lang ('default') {
20	$dbh->do(	20	$dbh->do(
21	"INSERT INTO additional_contents ( category, code, location, branchcode, title, content, lang, published_on ) VALUES ('html_customizations', 'PatronSelfRegistrationAdditionalInstructions', 'PatronSelfRegistrationAdditionalInstructions', NULL, ?, ?, ?, CAST(NOW() AS date) )",	21	"INSERT INTO additional_contents ( category, code, location, branchcode, published_on ) VALUES ('html_customizations', 'PatronSelfRegistrationAdditionalInstructions', 'PatronSelfRegistrationAdditionalInstructions', NULL, CAST(NOW() AS date) )"
22	undef, "PatronSelfRegistrationAdditionalInstructions $lang",	22	);
		23
		24	my ($insert_id) = $dbh->selectrow_array(
		25	"SELECT id FROM additional_contents WHERE category = 'html_customizations' AND code = 'PatronSelfRegistrationAdditionalInstructions' AND location = 'PatronSelfRegistrationAdditionalInstructions' LIMIT 1",
		26	{}
		27	);
		28
		29	$dbh->do(
		30	"INSERT INTO additional_contents_localizations ( additional_content_id, title, content, lang ) VALUES ( ?, ?, ?, ? )",
		31	undef, $insert_id, "PatronSelfRegistrationAdditionalInstructions $lang",
23	$patronselfregistrationadditionalinstructions, $lang	32	$patronselfregistrationadditionalinstructions, $lang
24	);	33	);
25	}	34	}
26	-