← All changes | extensions/wdk-cached-users.php +39 -32 1.5.3 → 1.5.9 View file →

		@@ -53,34 +53,35 @@
53	53	}
54	54
55	55	$insert_id = $Winter_MVC_WDK->cachedusers_m->insert(array(
56	56	'cacheduser_user_id' => $user_id,
57		- 'cacheduser_profile_url' => $user_data['profile_url'],
58		- 'cacheduser_avatar_url' => $user_data['avatar'],
59		- 'cacheduser_display_name' => wdk_get_user_field ($user_id, 'display_name'),
60		- 'cacheduser_email' => wdk_get_user_field ($user_id, 'user_email'),
61		- 'cacheduser_wdk_address' => wdk_get_user_field ($user_id, 'wdk_address'),
62		- 'cacheduser_wdk_phone' => wdk_get_user_field ($user_id, 'wdk_phone'),
63		- 'cacheduser_wdk_city' => wdk_get_user_field ($user_id, 'wdk_city'),
64		- 'cacheduser_wdk_company_name' => wdk_get_user_field ($user_id, 'wdk_company_name'),
65		- 'cacheduser_wdk_facebook' => wdk_get_user_field ($user_id, 'wdk_facebook'),
66		- 'cacheduser_wdk_youtube' => wdk_get_user_field ($user_id, 'wdk_youtube'),
67		- 'cacheduser_wdk_linkedin' => wdk_get_user_field ($user_id, 'wdk_linkedin'),
68		- 'cacheduser_wdk_twitter' => wdk_get_user_field ($user_id, 'wdk_twitter'),
69		- 'cacheduser_wdk_instagram' => wdk_get_user_field ($user_id, 'wdk_instagram'),
70		- 'cacheduser_wdk_whatsapp' => wdk_get_user_field ($user_id, 'wdk_whatsapp'),
71		- 'cacheduser_wdk_viber' => wdk_get_user_field ($user_id, 'wdk_viber'),
72		- 'cacheduser_wdk_iban' => wdk_get_user_field ($user_id, 'wdk_iban'),
73		- 'cacheduser_wdk_telegram' => wdk_get_user_field ($user_id, 'wdk_telegram'),
74		- 'cacheduser_wdk_position_title' => wdk_get_user_field ($user_id, 'wdk_position_title'),
75		- 'cacheduser_wdk_slug' => wdk_get_user_field ($user_id, 'wdk_slug'),
76		- 'cacheduser_user_login' => wdk_get_user_field ($user_id, 'user_login'),
77		- 'cacheduser_agency_name' => wdk_get_user_field ($user_id, 'agency_name'),
78		- 'cacheduser_description' => wdk_get_user_field ($user_id, 'description'),
79		- 'cacheduser_user_url' => wdk_get_user_field ($user_id, 'user_url'),
80		- 'cacheduser_roles' => join(',', ( array ) wdk_get_user_field ($user_id, 'roles')),
81		- 'cacheduser_json_data' => json_encode($json_data),
82		- 'cacheduser_date_updated' => date('Y-m-d H:i:s'),
	57	+ 'cacheduser_profile_url' => wdk_esc_sql($user_data['profile_url'], true),
	58	+ 'cacheduser_avatar_url' => wdk_esc_sql($user_data['avatar'], true),
	59	+ 'cacheduser_display_name' => wdk_esc_sql(wdk_get_user_field($user_id, 'display_name'), true),
	60	+ 'cacheduser_email' => wdk_esc_sql(wdk_get_user_field($user_id, 'user_email'), true),
	61	+ 'cacheduser_wdk_address' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_address'), true),
	62	+ 'cacheduser_wdk_phone' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_phone'), true),
	63	+ 'cacheduser_wdk_city' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_city'), true),
	64	+ 'cacheduser_wdk_company_name' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_company_name'), true),
	65	+ 'cacheduser_wdk_facebook' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_facebook'), true),
	66	+ 'cacheduser_wdk_youtube' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_youtube'), true),
	67	+ 'cacheduser_wdk_linkedin' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_linkedin'), true),
	68	+ 'cacheduser_wdk_twitter' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_twitter'), true),
	69	+ 'cacheduser_wdk_instagram' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_instagram'), true),
	70	+ 'cacheduser_wdk_whatsapp' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_whatsapp'), true),
	71	+ 'cacheduser_wdk_viber' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_viber'), true),
	72	+ 'cacheduser_wdk_iban' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_iban'), true),
	73	+ 'cacheduser_wdk_telegram' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_telegram'), true),
	74	+ 'cacheduser_wdk_position_title' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_position_title'), true),
	75	+ 'cacheduser_wdk_slug' => wdk_esc_sql(wdk_get_user_field($user_id, 'wdk_slug'), true),
	76	+ 'cacheduser_user_login' => wdk_esc_sql(wdk_get_user_field($user_id, 'user_login'), true),
	77	+ 'cacheduser_agency_name' => wdk_esc_sql(wdk_get_user_field($user_id, 'agency_name'), true),
	78	+ 'cacheduser_description' => wdk_esc_sql(wdk_get_user_field($user_id, 'description'), true),
	79	+ 'cacheduser_user_url' => wdk_esc_sql(wdk_get_user_field($user_id, 'user_url'), true),
	80	+ 'cacheduser_roles' => wdk_esc_sql(join(',', (array) wdk_get_user_field($user_id, 'roles')), true),
	81	+ 'cacheduser_json_data' => wdk_esc_sql(json_encode($json_data), true),
	82	+ 'cacheduser_date_updated' => gmdate('Y-m-d H:i:s'),
	83	+
83	84	), NULL);
84	85	}
85	86
86	87	public function regenerate_cache_activation()
		@@ -105,14 +106,20 @@
105	106
106	107	public function regenerate_cache($limit = NULL)
107	108	{
108	109	global $wpdb;
109		- $sql = "SELECT * FROM $wpdb->users";
110		-
111		- if(!empty($limit))
112		- $sql .= " LIMIT ".esc_sql($limit);
113		-
114		- $dbusers = $wpdb->get_results($sql);
	110	+ if (!empty($limit)) {
	111	+ $dbusers = $wpdb->get_results(
	112	+ $wpdb->prepare(
	113	+ "SELECT * FROM {$wpdb->users} LIMIT %d",
	114	+ absint($limit)
	115	+ )
	116	+ );
	117	+ } else {
	118	+ $dbusers = $wpdb->get_results(
	119	+ "SELECT * FROM {$wpdb->users}"
	120	+ );
	121	+ }
115	122
116	123	foreach($dbusers as $dbuser) {
117	124	$this->update(wmvc_show_data('ID', $dbuser));
118	125	}