List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "SELECT post_id FROM {$wpdb->prefix}postmeta WHERE meta_key = 'moodle_course_id' AND meta_value = %s" | 1 |
|
| "SELECT DISTINCT(user_id) FROM {$wpdb->base_prefix}usermeta WHERE user_id NOT IN (SELECT DISTINCT(user_id) from {$wpdb->base_prefix}usermeta WHERE meta_key = 'moodle_user_id' && meta_value IS NOT NULL) ORDER BY user_id ASC LIMIT %d , 20" | 1 |
|
| 'Update Course Category' | 1 |
|
| 'Show recommended courses on single course page.' | 1 |
|
| 'Show Category Wise Recommended Courses' | 1 |
|
| 'Show category wise selected recommended courses on single course page.' | 1 |
|
| "SELECT user_id, meta_value AS moodle_user_id FROM {$wpdb->base_prefix}usermeta WHERE user_id =%d AND meta_key = 'moodle_user_id' AND meta_value IS NOT NULL" | 1 |
|
| "SELECT user_id, meta_value AS moodle_user_id FROM {$wpdb->base_prefix}usermeta WHERE meta_key = 'moodle_user_id' AND meta_value IS NOT NULL ORDER BY user_id ASC LIMIT %d , 20" | 1 |
|
| "SELECT COUNT(user_id) AS users_count FROM {$wpdb->base_prefix}usermeta WHERE meta_key = 'moodle_user_id' AND meta_value IS NOT NULL" | 1 |
|
| "SELECT course_id FROM {$wpdb->prefix}moodle_enrollment WHERE user_id = %d" | 1 |
|
| "SELECT COUNT(DISTINCT(user_id)) as users_count FROM {$wpdb->base_prefix}usermeta WHERE user_id NOT IN (SELECT DISTINCT(user_id) from {$wpdb->base_prefix}usermeta WHERE meta_key = 'moodle_user_id' && meta_value IS NOT NULL)" | 1 |
|
| 'SELECT `course_id`, `time` FROM {$wpdb->prefix}moodle_enrollment WHERE user_id = %d' | 1 |
|
| "SELECT * FROM {$wpdb->prefix}moodle_enrollment WHERE expire_time!='0000-00-00 00:00:00' AND expire_time<%s;" | 1 |
|
| 'Select transaction currency code, Default is USD.' | 1 |
|
| 'Update user\'s course enrollment status' | 1 |
|
| 'Update previously synchronized courses' | 1 |
|
| 'Select user account page here. Default page is %s ' | 1 |
|
| 'Select my courses page here. Default page is' | 1 |
|
| 'Show recommended courses on eb-my-courses page.' | 1 |
|
| 'Show Default Recommended Courses' | 1 |
|
| 'Show category wise selected recommended courses on eb-my-courses page.' | 1 |
|
| 'DELETE FROM {$wpdb->prefix}moodle_enrollment WHERE user_id = %d' | 1 |
|
| 'Select an action to perform on course access expiration.' | 1 |
|
| 'SELECT `course_id` FROM {$wpdb->prefix}moodle_enrollment WHERE user_id = %d' | 1 |
|
| "SELECT user_id FROM {$wpdb->prefix}usermeta WHERE meta_value=%d AND meta_key = 'moodle_user_id'" | 1 |
|
| "SELECT term_id FROM {$wpdb->prefix}termmeta WHERE meta_key = 'eb_moodle_cat_id' AND meta_value = %d" | 1 |
|
| "SELECT count(*) count FROM {$wpdb->prefix}posts WHERE post_type = 'eb_course'" | 1 |
|
| "SELECT count(*) count FROM {$wpdb->prefix}term_taxonomy WHERE taxonomy = 'eb_course_cat'" | 1 |
|
| "SELECT count(*) count FROM {$wpdb->prefix}users" | 1 |
|
| "SELECT expire_time FROM {$wpdb->prefix}moodle_enrollment WHERE course_id=%d AND user_id=%d;" | 1 |
|
| "select user_id,course_id from {$wpdb->prefix}moodle_enrollment where id in(%s)" | 1 |
|
| "SELECT post_id FROM {$wpdb->prefix}postmeta WHERE meta_value=%s AND meta_key = 'moodle_course_id'" | 1 |
|
| 'SELECT ID FROM ' . $wpdb->posts . " WHERE post_type='page' AND post_content LIKE %s LIMIT 1;" | 1 |
|
| "SELECT * FROM {$wpdb->prefix}moodle_enrollment WHERE time> %s AND time< %s" | 1 |
|
| 'SELECT ID FROM ' . $wpdb->posts . " WHERE post_type='page' AND post_name = %s LIMIT 1;" | 1 |
|
| "SELECT post_id FROM {$wpdb->prefix}postmeta WHERE meta_value=%d AND meta_key = 'moodle_course_id'" | 1 |
|
| "SHOW COLUMNS FROM `{$wpdb->prefix}moodle_enrollment` LIKE 'suspended';" | 1 |
|
| "SELECT * FROM {$wpdb->prefix}moodle_enrollment WHERE time> %s" | 1 |
|
| "SELECT * FROM {$wpdb->prefix}moodle_enrollment" | 1 |
|
| "SELECT suspended FROM {$wpdb->prefix}moodle_enrollment WHERE course_id=%d AND user_id=%d;" | 1 |
|
| 'Show _MENU_ entries' | 1 |
|
| "SHOW COLUMNS FROM `{$wpdb->prefix}moodle_enrollment` LIKE 'act_cnt';" | 1 |
|
| "SHOW COLUMNS FROM `{$wpdb->prefix}moodle_enrollment` LIKE 'expire_time';" | 1 |
|
| 'Select Courses' | 2 |
|
| "SELECT act_cnt FROM {$wpdb->prefix}moodle_enrollment WHERE course_id=%d AND user_id=%d;" | 2 |
|
| 'Select Role' | 2 |
|
| 'Select default role for users on registration from User Account Page.' | 2 |
|
| 'Select courses to show in custom courses in recommended course section.' | 2 |
|
| 'Show Recommended Courses' | 2 |
|
| "SELECT term_id FROM {$wpdb->prefix}termmeta WHERE meta_key = 'eb_moodle_cat_id' AND meta_value = %d" | 2 |
|
| "SELECT user_id FROM {$wpdb->prefix}moodle_enrollment WHERE course_id=%d AND user_id=%d;" | 2 |
|
| 'Select a page' | 3 |
|