llms_update_300_migrate_lesson_postmeta()
Update keys of lesson meta fields for consistency
Return Return
(void)
Source Source
File: includes/functions/updates/llms-functions-updates-300.php
function llms_update_300_migrate_lesson_postmeta() {
global $wpdb;
llms_update_util_rekey_meta( 'lesson', '_llms_audio_embed', '_audio_embed' );
llms_update_util_rekey_meta( 'lesson', '_llms_video_embed', '_video_embed' );
llms_update_util_rekey_meta( 'lesson', '_llms_has_prerequisite', '_has_prerequisite' );
llms_update_util_rekey_meta( 'lesson', '_llms_prerequisite', '_prerequisite' );
llms_update_util_rekey_meta( 'lesson', '_llms_days_before_available', '_days_before_avalailable' );
// Convert numeric has_preqeq to "yes".
// Convert numeric free_lesson to "yes".
// Convert numeric require_passing_grade to "yes".
$wpdb->query(
"UPDATE {$wpdb->prefix}postmeta AS m
INNER JOIN {$wpdb->prefix}posts AS p ON p.ID = m.post_ID
SET m.meta_value = 'yes'
WHERE p.post_type = 'lesson' AND (
( m.meta_key = '_llms_has_prerequisite' AND m.meta_value = 1 )
OR ( m.meta_key = '_llms_free_lesson' AND m.meta_value = 1 )
OR ( m.meta_key = '_llms_require_passing_grade' AND m.meta_value = 1 )
);"
); // db call ok; no-cache ok.
// Convert empty has_prereq to "no".
// Convert empty free_lesson to "no".
// Convert empty require_passing_grade to "no".
$wpdb->query(
"UPDATE {$wpdb->prefix}postmeta AS m
INNER JOIN {$wpdb->prefix}posts AS p ON p.ID = m.post_ID
SET m.meta_value = 'no'
WHERE p.post_type = 'lesson' AND (
( m.meta_key = '_llms_has_prerequisite' AND m.meta_value = '' )
OR ( m.meta_key = '_llms_free_lesson' AND m.meta_value = '' )
OR ( m.meta_key = '_llms_require_passing_grade' AND m.meta_value = '' )
);"
); // db call ok; no-cache ok.
// Updates course enrollment settings and reformats existing dates.
$drips = $wpdb->get_results(
"SELECT m.post_id
FROM {$wpdb->postmeta} AS m
INNER JOIN {$wpdb->posts} AS p ON p.ID = m.post_ID
WHERE p.post_type = 'lesson' AND m.meta_key = '_llms_days_before_available';"
); // db call ok; no-cache ok.
foreach ( $drips as $r ) {
add_post_meta( $r->post_id, '_llms_drip_method', 'enrollment' );
}
}
Expand full source code Collapse full source code View on GitHub
Changelog Changelog
| Version | Description |
|---|---|
| 3.0.0 | Introduced. |