← All changes | integrations/wp-polls/includes/functions.php +69 -0 7.8.9 → 8.0.5 View file →

		@@ -1,0 +1,69 @@
	1	+<?php
	2	+/**
	3	+ * Functions
	4	+ *
	5	+ * @package GamiPress\WP_Polls\Functions
	6	+ * @since 1.0.0
	7	+ */
	8	+
	9	+// Exit if accessed directly
	10	+if( !defined( 'ABSPATH' ) ) exit;
	11	+
	12	+/**
	13	+ * Overrides GamiPress AJAX Helper for selecting posts
	14	+ *
	15	+ * @since 1.0.0
	16	+ */
	17	+function gamipress_wp_polls_ajax_get_posts() {
	18	+
	19	+ // Security check, forces to die if not security passed
	20	+ check_ajax_referer( 'gamipress_admin', 'nonce' );
	21	+
	22	+ // Check if user can manage GamiPress
	23	+ if( ! current_user_can( gamipress_get_manager_capability() ) ) {
	24	+ wp_send_json_error( __( 'You\'re not allowed to perform this action.', 'gamipress' ) );
	25	+ }
	26	+
	27	+ global $wpdb;
	28	+
	29	+ if( isset( $_REQUEST['post_type'] ) && in_array( 'wp_polls', $_REQUEST['post_type'] ) ) {
	30	+
	31	+ $results = array();
	32	+
	33	+ // Pull back the search string
	34	+ $search = isset( $_REQUEST['q'] ) ? $wpdb->esc_like( sanitize_text_field( $_REQUEST['q'] ) ) : '';
	35	+
	36	+ $polls = $wpdb->get_results( $wpdb->prepare(
	37	+ "SELECT pollq_id, pollq_question
	38	+ FROM {$wpdb->pollsq}
	39	+ WHERE pollq_question LIKE %s",
	40	+ "%%{$search}%%"
	41	+ ) );
	42	+
	43	+ foreach ( $polls as $poll ) {
	44	+
	45	+ // Results should meet same structure like posts
	46	+ $results[] = array(
	47	+ 'ID' => $poll->pollq_id,
	48	+ 'post_title' => $poll->pollq_question,
	49	+ );
	50	+
	51	+ }
	52	+
	53	+ // Return our results
	54	+ wp_send_json_success( $results );
	55	+ die;
	56	+ }
	57	+
	58	+}
	59	+add_action( 'wp_ajax_gamipress_get_posts', 'gamipress_wp_polls_ajax_get_posts', 5 );
	60	+
	61	+// Helper function to get the poll title (Question)
	62	+function gamipress_wp_polls_get_poll_title( $poll_id ) {
	63	+
	64	+ global $wpdb;
	65	+ $sql = "SELECT pollq_question FROM {$wpdb->pollsq} WHERE pollq_id = %d ";
	66	+
	67	+ return $wpdb->get_var( $wpdb->prepare( $sql, $poll_id ) );
	68	+
	69	+}