1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/** |
4
|
|
|
* Importer class for importing from CubePoints. |
5
|
|
|
* |
6
|
|
|
* @package WordPoints_Importer |
7
|
|
|
* @since 1.0.0 |
8
|
|
|
*/ |
9
|
|
|
|
10
|
|
|
/** |
11
|
|
|
* CubePoints importer. |
12
|
|
|
* |
13
|
|
|
* @since 1.0.0 |
14
|
|
|
*/ |
15
|
|
|
class WordPoints_CubePoints_Importer extends WordPoints_Importer { |
16
|
|
|
|
17
|
|
|
/** |
18
|
|
|
* Reversible log types indexed by the reversing log type. |
19
|
|
|
* |
20
|
|
|
* This information is used to set the `auto_reversed` and `original_log_id` |
21
|
|
|
* points log metadata for the imported logs. |
22
|
|
|
* |
23
|
|
|
* @since 1.2.0 |
24
|
|
|
* |
25
|
|
|
* @see WordPoints_CubePoints_Importer::import_points_log() |
26
|
|
|
* |
27
|
|
|
* @var array |
28
|
|
|
*/ |
29
|
|
|
protected $reversible_log_types = array( |
30
|
|
|
'comment_remove' => 'comment', |
31
|
|
|
'post_comment_remove' => 'post_comment', |
32
|
|
|
); |
33
|
|
|
|
34
|
|
|
/** |
35
|
|
|
* Primary entity slugs for each imported log type. |
36
|
|
|
* |
37
|
|
|
* These are points log meta keys under which to save the entity ID in the |
38
|
|
|
* CubePoints `data` log field. |
39
|
|
|
* |
40
|
|
|
* @since 1.2.0 |
41
|
|
|
* |
42
|
|
|
* @see WordPoints_CubePoints_Importer::import_points_log() |
43
|
|
|
* |
44
|
|
|
* @var array |
45
|
|
|
*/ |
46
|
|
|
protected $log_type_entities = array( |
47
|
|
|
'comment' => 'comment', |
48
|
|
|
'comment_remove' => 'comment', |
49
|
|
|
'post' => 'post', |
50
|
|
|
'post_comment' => 'comment', |
51
|
|
|
'post_comment_remove' => 'comment', |
52
|
|
|
'register' => 'user', |
53
|
|
|
); |
54
|
|
|
|
55
|
|
|
/** |
56
|
|
|
* IDs of reversible logs, indexed by CubePoints log type and object ID. |
57
|
|
|
* |
58
|
|
|
* @since 1.2.0 |
59
|
|
|
* |
60
|
|
|
* @see WordPoints_CubePoints_Importer::import_points_log() |
61
|
|
|
* |
62
|
|
|
* @var int[][] |
63
|
|
|
*/ |
64
|
|
|
protected $reversible_log_ids; |
65
|
|
|
|
66
|
|
|
/** |
67
|
|
|
* @since 1.0.0 |
68
|
|
|
*/ |
69
|
|
|
public function __construct( $name ) { |
70
|
|
|
|
71
|
|
|
parent::__construct( $name ); |
72
|
|
|
|
73
|
|
|
$this->components = array( |
74
|
|
|
'points' => array( |
75
|
|
|
'excluded_users' => array( |
76
|
|
|
'label' => __( 'Excluded users', 'wordpoints-importer' ), |
77
|
|
|
'function' => array( $this, 'import_excluded_users' ), |
78
|
|
|
), |
79
|
|
|
'settings' => array( |
80
|
|
|
'label' => __( 'Points Reactions', 'wordpoints-importer' ), |
81
|
|
|
'description' => __( 'If checked, the settings for the number of points to award for posts, comments, etc. are imported.', 'wordpoints-importer' ), |
82
|
|
|
'function' => array( $this, 'import_points_settings' ), |
83
|
|
|
), |
84
|
|
|
'user_points' => array( |
85
|
|
|
'label' => __( 'User points', 'wordpoints-importer' ), |
86
|
|
|
'function' => array( $this, 'import_user_points' ), |
87
|
|
|
), |
88
|
|
|
'logs' => array( |
89
|
|
|
'label' => __( 'Points logs', 'wordpoints-importer' ), |
90
|
|
|
'function' => array( $this, 'import_points_logs' ), |
91
|
|
|
'can_import' => array( $this, 'can_import_points_logs' ), |
92
|
|
|
), |
93
|
|
|
), |
94
|
|
|
'ranks' => array( |
95
|
|
|
'ranks' => array( |
96
|
|
|
'label' => __( 'Rank settings', 'wordpoints-importer' ), |
97
|
|
|
'description' => __( 'If checked, the list of ranks is imported, and users will have the correct ranks assigned to them.', 'wordpoints-importer' ), |
98
|
|
|
'function' => array( $this, 'import_ranks' ), |
99
|
|
|
), |
100
|
|
|
), |
101
|
|
|
); |
102
|
|
|
} |
103
|
|
|
|
104
|
|
|
/** |
105
|
|
|
* @since 1.0.0 |
106
|
|
|
*/ |
107
|
|
|
public function is_available() { |
108
|
|
|
|
109
|
|
|
if ( ! $this->is_cubepoints_installed() ) { |
110
|
|
|
return new WP_Error( |
111
|
|
|
'cubepoints_not_installed' |
112
|
|
|
, __( 'CubePoints is not installed', 'wordpoints-importer' ) |
113
|
|
|
); |
114
|
|
|
} |
115
|
|
|
|
116
|
|
|
return true; |
117
|
|
|
} |
118
|
|
|
|
119
|
|
|
/** |
120
|
|
|
* Check if CubePoints is installed. |
121
|
|
|
* |
122
|
|
|
* @since 1.0.0 |
123
|
|
|
*/ |
124
|
|
|
public function is_cubepoints_installed() { |
125
|
|
|
|
126
|
|
|
return (bool) get_option( 'cp_db_version' ); |
127
|
|
|
} |
128
|
|
|
|
129
|
|
|
/** |
130
|
|
|
* Check if CubePoints is active. |
131
|
|
|
* |
132
|
|
|
* @since 1.0.0 |
133
|
|
|
*/ |
134
|
|
|
public function is_cubepoints_active() { |
135
|
|
|
|
136
|
|
|
return function_exists( 'cp_ready' ); |
137
|
|
|
} |
138
|
|
|
|
139
|
|
|
/** |
140
|
|
|
* Import the excluded users. |
141
|
|
|
* |
142
|
|
|
* @since 1.0.0 |
143
|
|
|
*/ |
144
|
|
|
protected function import_excluded_users() { |
145
|
|
|
|
146
|
|
|
$this->feedback->info( __( 'Importing excluded users…', 'wordpoints-importer' ) ); |
147
|
|
|
|
148
|
|
|
$excluded_users = get_option( 'cp_topfilter' ); |
149
|
|
|
|
150
|
|
|
if ( ! is_array( $excluded_users ) ) { |
151
|
|
|
$this->feedback->warning( __( 'No excluded users found.', 'wordpoints-importer' ) ); |
152
|
|
|
return; |
153
|
|
|
} |
154
|
|
|
|
155
|
|
|
$user_ids = array(); |
156
|
|
|
|
157
|
|
|
foreach ( $excluded_users as $user_login ) { |
158
|
|
|
|
159
|
|
|
$user = get_user_by( 'login', $user_login ); |
160
|
|
|
|
161
|
|
|
if ( $user instanceof WP_User ) { |
162
|
|
|
$user_ids[] = $user->ID; |
163
|
|
|
} |
164
|
|
|
} |
165
|
|
|
|
166
|
|
|
$excluded_user_ids = wordpoints_get_maybe_network_array_option( |
167
|
|
|
'wordpoints_excluded_users' |
168
|
|
|
); |
169
|
|
|
|
170
|
|
|
$excluded_user_ids = array_unique( |
171
|
|
|
array_merge( $excluded_user_ids, $user_ids ) |
172
|
|
|
); |
173
|
|
|
|
174
|
|
|
wordpoints_update_maybe_network_option( |
175
|
|
|
'wordpoints_excluded_users' |
176
|
|
|
, $excluded_user_ids |
177
|
|
|
); |
178
|
|
|
|
179
|
|
|
$this->feedback->success( |
180
|
|
|
sprintf( |
181
|
|
|
// translators: Number of users. |
182
|
|
|
__( 'Imported %s excluded users.', 'wordpoints-importer' ) |
183
|
|
|
, count( $user_ids ) |
184
|
|
|
) |
185
|
|
|
); |
186
|
|
|
} |
187
|
|
|
|
188
|
|
|
/** |
189
|
|
|
* Import the points settings to the points hooks. |
190
|
|
|
* |
191
|
|
|
* @since 1.1.0 |
192
|
|
|
* |
193
|
|
|
* @param array $settings The settings for the points component import. |
194
|
|
|
*/ |
195
|
|
|
protected function import_points_settings( $settings ) { |
196
|
|
|
|
197
|
|
|
$this->feedback->info( __( 'Importing points reactions…', 'wordpoints-importer' ) ); |
198
|
|
|
|
199
|
|
|
$options = array( |
200
|
|
|
'cp_comment_points' => array( |
201
|
|
|
'event' => 'comment_leave\post', |
202
|
|
|
'target' => array( 'comment\post', 'author', 'user' ), |
203
|
|
|
/* translators: The post type name */ |
204
|
|
|
'log_text' => __( 'Comment on a %s.', 'wordpoints-importer' ), |
205
|
|
|
/* translators: The post type name */ |
206
|
|
|
'description' => __( 'Commenting on a %s.', 'wordpoints-importer' ), |
207
|
|
|
'legacy_log_type' => 'cubepoints-comment', |
208
|
|
|
'legacy_meta_key' => 'comment', |
209
|
|
|
), |
210
|
|
|
'cp_post_points' => array( |
211
|
|
|
'event' => 'post_publish\post', |
212
|
|
|
'target' => array( 'post\post', 'author', 'user' ), |
213
|
|
|
/* translators: The post type name */ |
214
|
|
|
'log_text' => __( 'Published a Post.', 'wordpoints-importer' ), |
215
|
|
|
/* translators: The post type name */ |
216
|
|
|
'description' => __( 'Publishing a Post.', 'wordpoints-importer' ), |
217
|
|
|
'legacy_log_type' => 'cubepoints-post', |
218
|
|
|
'legacy_meta_key' => 'post', |
219
|
|
|
// CubePoints doesn't remove points when a post is deleted. |
220
|
|
|
'blocker' => array( 'toggle_off' => true ), |
221
|
|
|
'points_legacy_repeat_blocker' => array( 'toggle_on' => true ), |
222
|
|
|
), |
223
|
|
|
'cp_reg_points' => array( |
224
|
|
|
'event' => 'user_register', |
225
|
|
|
'log_text' => __( 'Registration.', 'wordpoints-importer' ), |
226
|
|
|
'description' => __( 'Registration.', 'wordpoints-importer' ), |
227
|
|
|
'legacy_log_type' => 'cubepoints-register', |
228
|
|
|
), |
229
|
|
|
'cp_post_author_points' => array( |
230
|
|
|
'event' => 'comment_leave\post', |
231
|
|
|
'target' => array( 'comment\post', 'post\post', 'post\post', 'author', 'user' ), |
232
|
|
|
/* translators: The post type name */ |
233
|
|
|
'log_text' => __( 'Received a comment on a %s.', 'wordpoints-importer' ), |
234
|
|
|
/* translators: The post type name */ |
235
|
|
|
'description' => __( 'Receiving a comment on a %s.', 'wordpoints-importer' ), |
236
|
|
|
'legacy_log_type' => 'cubepoints-post_author', |
237
|
|
|
'legacy_meta_key' => 'comment', |
238
|
|
|
), |
239
|
|
|
); |
240
|
|
|
|
241
|
|
|
// Don't import this module setting if the module isn't active. |
242
|
|
|
if ( function_exists( 'cp_module_activated' ) && ! cp_module_activated( 'post_author_points' ) ) { |
243
|
|
|
unset( $options['cp_post_author_points'] ); |
244
|
|
|
} |
245
|
|
|
|
246
|
|
|
$imported = 0; |
247
|
|
|
|
248
|
|
|
foreach ( $options as $option => $hook_settings ) { |
249
|
|
|
|
250
|
|
|
$points = get_option( $option ); |
251
|
|
|
|
252
|
|
|
if ( wordpoints_posint( $points ) ) { |
253
|
|
|
|
254
|
|
|
$hook_settings['points'] = $points; |
255
|
|
|
$hook_settings['points_type'] = $settings['points_type']; |
256
|
|
|
|
257
|
|
|
if ( |
258
|
|
|
// The CubePoints post points were only awarded for Posts. |
259
|
|
|
'post_publish\post' !== $hook_settings['event'] |
260
|
|
|
&& strpos( $hook_settings['event'], '\post' ) |
261
|
|
|
) { |
262
|
|
|
|
263
|
|
|
$post_type_slugs = get_post_types( array( 'public' => true ) ); |
264
|
|
|
|
265
|
|
|
foreach ( $post_type_slugs as $post_type_slug ) { |
266
|
|
|
|
267
|
|
|
$added = $this->add_points_hook( |
268
|
|
|
$this->format_settings_for_post_type( |
269
|
|
|
$post_type_slug |
270
|
|
|
, $hook_settings |
271
|
|
|
) |
272
|
|
|
); |
273
|
|
|
|
274
|
|
|
if ( $added ) { |
275
|
|
|
$imported++; |
276
|
|
|
} |
277
|
|
|
} |
278
|
|
|
|
279
|
|
|
} else { |
280
|
|
|
if ( $this->add_points_hook( $hook_settings ) ) { |
281
|
|
|
$imported++; |
282
|
|
|
} |
283
|
|
|
} |
284
|
|
|
} |
285
|
|
|
|
286
|
|
|
} // End foreach ( $options ). |
287
|
|
|
|
288
|
|
|
if ( $this->import_daily_points_hook( $settings ) ) { |
289
|
|
|
$imported++; |
290
|
|
|
} |
291
|
|
|
|
292
|
|
|
$this->feedback->success( |
293
|
|
|
// translators: Number of reactions. |
294
|
|
|
sprintf( __( 'Imported %s points reactions.', 'wordpoints-importer' ), $imported ) |
295
|
|
|
); |
296
|
|
|
} |
297
|
|
|
|
298
|
|
|
/** |
299
|
|
|
* Import the settings for the Daily Points module to a points hook. |
300
|
|
|
* |
301
|
|
|
* @since 1.1.0 |
302
|
|
|
* |
303
|
|
|
* @param array $settings The settings for the points component import. |
304
|
|
|
* |
305
|
|
|
* @return bool True if the settings were imported, false otherwise. |
306
|
|
|
*/ |
307
|
|
|
protected function import_daily_points_hook( $settings ) { |
308
|
|
|
|
309
|
|
|
// Don't import this module setting if the module isn't active. |
310
|
|
|
if ( function_exists( 'cp_module_activated' ) && ! cp_module_activated( 'dailypoints' ) ) { |
311
|
|
|
return false; |
312
|
|
|
} |
313
|
|
|
|
314
|
|
|
$points = get_option( 'cp_module_dailypoints_points' ); |
315
|
|
|
$period = get_option( 'cp_module_dailypoints_time' ); |
316
|
|
|
|
317
|
|
|
if ( ! wordpoints_int( $points ) || ! wordpoints_posint( $period ) ) { |
318
|
|
|
return false; |
319
|
|
|
} |
320
|
|
|
|
321
|
|
|
return $this->add_points_hook( |
322
|
|
|
array( |
323
|
|
|
'event' => 'user_visit', |
324
|
|
|
'target' => array( 'current:user' ), |
325
|
|
|
'reactor' => 'points_legacy', |
326
|
|
|
'points' => $points, |
327
|
|
|
'points_type' => $settings['points_type'], |
328
|
|
|
'points_legacy_periods' => array( |
329
|
|
|
'fire' => array( |
330
|
|
|
array( |
331
|
|
|
'length' => $period, |
332
|
|
|
'args' => array( array( 'current:user' ) ), |
333
|
|
|
'relative' => true, |
334
|
|
|
), |
335
|
|
|
), |
336
|
|
|
), |
337
|
|
|
'log_text' => __( 'Visiting the site.', 'wordpoints-importer' ), |
338
|
|
|
'description' => __( 'Visiting the site.', 'wordpoints-importer' ), |
339
|
|
|
'points_legacy_reversals' => array(), |
340
|
|
|
'legacy_log_type' => 'cubepoints-dailypoints', |
341
|
|
|
) |
342
|
|
|
); |
343
|
|
|
} |
344
|
|
|
|
345
|
|
|
/** |
346
|
|
|
* Programmatically create a new instance of a points hook. |
347
|
|
|
* |
348
|
|
|
* @since 1.0.0 |
349
|
|
|
* @since 1.2.0 Now just accepts a single argument, $settings. |
350
|
|
|
* |
351
|
|
|
* @param array $settings The settings for this hook. |
352
|
|
|
* |
353
|
|
|
* @return bool True if added successfully, or false on failure. |
354
|
|
|
*/ |
355
|
|
|
private function add_points_hook( $settings = array() ) { |
356
|
|
|
|
357
|
|
|
$reaction_store = wordpoints_hooks()->get_reaction_store( 'points' ); |
358
|
|
|
|
359
|
|
|
$settings = array_merge( |
360
|
|
|
array( |
361
|
|
|
'target' => array( 'user' ), |
362
|
|
|
'reactor' => 'points_legacy', |
363
|
|
|
'points_legacy_reversals' => array( 'toggle_off' => 'toggle_on' ), |
364
|
|
|
) |
365
|
|
|
, $settings |
366
|
|
|
); |
367
|
|
|
|
368
|
|
|
$reaction = $reaction_store->create_reaction( $settings ); |
369
|
|
|
|
370
|
|
|
if ( ! $reaction instanceof WordPoints_Hook_ReactionI ) { |
371
|
|
|
return false; |
372
|
|
|
} |
373
|
|
|
|
374
|
|
|
return true; |
375
|
|
|
} |
376
|
|
|
|
377
|
|
|
/** |
378
|
|
|
* Format the settings for a reaction for a particular post type. |
379
|
|
|
* |
380
|
|
|
* @since 1.2.0 |
381
|
|
|
* |
382
|
|
|
* @param string $post_type The slug of the post type to format the settings for. |
383
|
|
|
* @param array $settings The reaction settings. |
384
|
|
|
* |
385
|
|
|
* @return array The settings modified for this particular post type. |
386
|
|
|
*/ |
387
|
|
|
protected function format_settings_for_post_type( $post_type, $settings ) { |
388
|
|
|
|
389
|
|
|
$settings['event'] = str_replace( |
390
|
|
|
'\post' |
391
|
|
|
, '\\' . $post_type |
392
|
|
|
, $settings['event'] |
393
|
|
|
); |
394
|
|
|
|
395
|
|
|
$settings['target'] = str_replace( |
396
|
|
|
'\post' |
397
|
|
|
, '\\' . $post_type |
398
|
|
|
, $settings['target'] |
399
|
|
|
); |
400
|
|
|
|
401
|
|
|
$labels = get_post_type_labels( get_post_type_object( $post_type ) ); |
402
|
|
|
|
403
|
|
|
$settings['log_text'] = sprintf( $settings['log_text'], $labels->singular_name ); |
404
|
|
|
$settings['description'] = sprintf( $settings['description'], $labels->singular_name ); |
405
|
|
|
|
406
|
|
|
return $settings; |
407
|
|
|
} |
408
|
|
|
|
409
|
|
|
/** |
410
|
|
|
* Import the user points. |
411
|
|
|
* |
412
|
|
|
* @since 1.0.0 |
413
|
|
|
* |
414
|
|
|
* @param array $settings The settings for the points component import. |
415
|
|
|
*/ |
416
|
|
|
protected function import_user_points( $settings ) { |
417
|
|
|
|
418
|
|
|
$this->feedback->info( __( 'Importing users' points…', 'wordpoints-importer' ) ); |
419
|
|
|
|
420
|
|
|
// We don't log the import transactions. |
421
|
|
|
add_filter( 'wordpoints_points_log', '__return_false' ); |
422
|
|
|
|
423
|
|
|
$start = 0; |
424
|
|
|
$rows = $this->get_next_user_points_batch( $start ); |
425
|
|
|
|
426
|
|
|
// We do the import in batches. |
427
|
|
|
while ( $rows ) { |
428
|
|
|
|
429
|
|
|
foreach ( $rows as $row ) { |
430
|
|
|
|
431
|
|
|
wordpoints_alter_points( |
432
|
|
|
$row->user_id |
433
|
|
|
, $row->points |
434
|
|
|
, $settings['points_type'] |
435
|
|
|
, 'cubepoints_import' // This is only for the hooks, it isn't being logged. |
436
|
|
|
); |
437
|
|
|
} |
438
|
|
|
|
439
|
|
|
$start += count( $rows ); |
440
|
|
|
$rows = $this->get_next_user_points_batch( $start ); |
441
|
|
|
} |
442
|
|
|
|
443
|
|
|
remove_filter( 'wordpoints_points_log', '__return_false' ); |
444
|
|
|
|
445
|
|
|
// translators: Number of users. |
446
|
|
|
$this->feedback->success( sprintf( __( 'Imported points for %s users…', 'wordpoints-importer' ), $start ) ); |
447
|
|
|
} |
448
|
|
|
|
449
|
|
|
/** |
450
|
|
|
* Get a batch of user points to import. |
451
|
|
|
* |
452
|
|
|
* @since 1.0.0 |
453
|
|
|
* |
454
|
|
|
* @param int $start The offset number to begin counting at. |
455
|
|
|
* |
456
|
|
|
* @return object[]|false The rows, or false. |
457
|
|
|
*/ |
458
|
|
|
protected function get_next_user_points_batch( $start ) { |
459
|
|
|
|
460
|
|
|
global $wpdb; |
461
|
|
|
|
462
|
|
|
$rows = $wpdb->get_results( |
463
|
|
|
$wpdb->prepare( |
464
|
|
|
" |
465
|
|
|
SELECT `user_id`, `meta_value` as points |
466
|
|
|
FROM {$wpdb->usermeta} |
467
|
|
|
WHERE `meta_key` = 'cpoints' |
468
|
|
|
ORDER BY `umeta_id` |
469
|
|
|
LIMIT %d,500 |
470
|
|
|
" |
471
|
|
|
, $start |
472
|
|
|
) |
473
|
|
|
); // WPCS: cache OK. |
474
|
|
|
|
475
|
|
|
if ( ! is_array( $rows ) ) { |
476
|
|
|
return false; |
477
|
|
|
} |
478
|
|
|
|
479
|
|
|
return $rows; |
480
|
|
|
} |
481
|
|
|
|
482
|
|
|
/** |
483
|
|
|
* Check if the points logs can be imported. |
484
|
|
|
* |
485
|
|
|
* @since 1.0.0 |
486
|
|
|
* |
487
|
|
|
* @return true|WP_Error True on success or a WP_Error on failure. |
488
|
|
|
*/ |
489
|
|
|
public function can_import_points_logs() { |
490
|
|
|
|
491
|
|
|
if ( ! $this->is_cubepoints_active() ) { |
492
|
|
|
|
493
|
|
|
return new WP_Error( |
494
|
|
|
'wordpoints_import_points_logs_cubepoints_inactive' |
495
|
|
|
, __( 'CubePoints must be active.', 'wordpoints-importer' ) |
496
|
|
|
); |
497
|
|
|
} |
498
|
|
|
|
499
|
|
|
return true; |
500
|
|
|
} |
501
|
|
|
|
502
|
|
|
/** |
503
|
|
|
* Import the points logs. |
504
|
|
|
* |
505
|
|
|
* @since 1.0.0 |
506
|
|
|
* |
507
|
|
|
* @param array $settings The import settings for the points component. |
508
|
|
|
*/ |
509
|
|
|
protected function import_points_logs( $settings ) { |
510
|
|
|
|
511
|
|
|
$this->feedback->info( __( 'Importing points logs…', 'wordpoints-importer' ) ); |
512
|
|
|
|
513
|
|
|
$start = 0; |
514
|
|
|
$logs = $this->get_next_points_logs_batch( $start ); |
515
|
|
|
|
516
|
|
|
while ( $logs ) { |
517
|
|
|
|
518
|
|
|
foreach ( $logs as $log ) { |
519
|
|
|
|
520
|
|
|
$this->import_points_log( |
521
|
|
|
$log->uid |
522
|
|
|
, $log->points |
523
|
|
|
, $settings['points_type'] |
524
|
|
|
, "cubepoints-{$log->type}" |
525
|
|
|
, array( |
526
|
|
|
'cubepoints_type' => $log->type, |
527
|
|
|
'cubepoints_data' => $log->data, |
528
|
|
|
) |
529
|
|
|
, date( 'Y-m-d H:i:s', $log->timestamp ) |
530
|
|
|
); |
531
|
|
|
} |
532
|
|
|
|
533
|
|
|
$start += count( $logs ); |
534
|
|
|
$logs = $this->get_next_points_logs_batch( $start ); |
535
|
|
|
} |
536
|
|
|
|
537
|
|
|
// translators: Number of points logs. |
538
|
|
|
$this->feedback->success( sprintf( __( 'Imported %s points log entries.', 'wordpoints-importer' ), $start ) ); |
539
|
|
|
} |
540
|
|
|
|
541
|
|
|
/** |
542
|
|
|
* Import a points log. |
543
|
|
|
* |
544
|
|
|
* @since 1.0.0 |
545
|
|
|
* |
546
|
|
|
* @param int $user_id The ID of the user the log is for. |
547
|
|
|
* @param int $points The number of points awarded. |
548
|
|
|
* @param string $points_type The points type. |
549
|
|
|
* @param string $log_type The log type. |
550
|
|
|
* @param array $meta The metadata for this log. |
551
|
|
|
* @param int $date The date the transaction took place. |
552
|
|
|
*/ |
553
|
|
|
protected function import_points_log( $user_id, $points, $points_type, $log_type, $meta, $date ) { |
554
|
|
|
|
555
|
|
|
global $wpdb; |
556
|
|
|
|
557
|
|
|
$result = $wpdb->insert( |
558
|
|
|
$wpdb->wordpoints_points_logs, |
559
|
|
|
array( |
560
|
|
|
'user_id' => $user_id, |
561
|
|
|
'points' => $points, |
562
|
|
|
'points_type' => $points_type, |
563
|
|
|
'log_type' => $log_type, |
564
|
|
|
'text' => $this->render_points_log_text( '', $user_id, $points, $points_type, $log_type, $meta ), |
565
|
|
|
'date' => $date, |
566
|
|
|
'site_id' => $wpdb->siteid, |
567
|
|
|
'blog_id' => $wpdb->blogid, |
568
|
|
|
), |
569
|
|
|
array( '%d', '%d', '%s', '%s', '%s', '%s', '%d', '%d' ) |
570
|
|
|
); |
571
|
|
|
|
572
|
|
|
if ( false !== $result ) { |
573
|
|
|
|
574
|
|
|
$log_id = (int) $wpdb->insert_id; |
575
|
|
|
|
576
|
|
|
// Set auto_reversed and original_log_id metadata for reversed logs. |
577
|
|
|
foreach ( $this->reversible_log_types as $reverse_type => $type ) { |
578
|
|
|
|
579
|
|
|
if ( $meta['cubepoints_type'] === $type ) { |
580
|
|
|
|
581
|
|
|
// Save this log ID for later, in case this log was reversed. |
582
|
|
|
// cubepoints_data will contain the entity ID. |
583
|
|
|
$this->reversible_log_ids[ $type ][ $meta['cubepoints_data'] ] = $log_id; |
584
|
|
|
|
585
|
|
|
} elseif ( |
586
|
|
|
$meta['cubepoints_type'] === $reverse_type |
587
|
|
|
&& isset( $this->reversible_log_ids[ $type ][ $meta['cubepoints_data'] ] ) |
588
|
|
|
) { |
589
|
|
|
|
590
|
|
|
// This log was reverses another one. Set the original log ID. |
591
|
|
|
$meta['original_log_id'] = $this->reversible_log_ids[ $type ][ $meta['cubepoints_data'] ]; |
592
|
|
|
|
593
|
|
|
// And mark the original as auto_reversed. |
594
|
|
|
wordpoints_add_points_log_meta( $meta['original_log_id'], 'auto_reversed', $log_id ); |
595
|
|
|
|
596
|
|
|
// No need to keep this info anymore. |
597
|
|
|
unset( $this->reversible_log_ids[ $type ][ $meta['cubepoints_data'] ] ); |
598
|
|
|
} |
599
|
|
|
} |
600
|
|
|
|
601
|
|
|
// Set the entity IDs to their own meta keys, for the sake of reversals. |
602
|
|
|
if ( isset( $this->log_type_entities[ $meta['cubepoints_type'] ] ) ) { |
603
|
|
|
$meta[ $this->log_type_entities[ $meta['cubepoints_type'] ] ] = $meta['cubepoints_data']; |
604
|
|
|
} |
605
|
|
|
|
606
|
|
|
foreach ( $meta as $meta_key => $meta_value ) { |
607
|
|
|
|
608
|
|
|
wordpoints_add_points_log_meta( $log_id, $meta_key, $meta_value ); |
609
|
|
|
} |
610
|
|
|
|
611
|
|
|
do_action( 'wordpoints_points_log', $user_id, $points, $points_type, $log_type, $meta, $log_id ); |
612
|
|
|
|
613
|
|
|
} // End if ( inserted successfully ). |
614
|
|
|
} |
615
|
|
|
|
616
|
|
|
/** |
617
|
|
|
* Generate the log text when importing a points log. |
618
|
|
|
* |
619
|
|
|
* @since 1.0.0 |
620
|
|
|
*/ |
621
|
|
|
public function render_points_log_text( $text, $user_id, $points, $points_type, $log_type, $meta ) { |
|
|
|
|
622
|
|
|
|
623
|
|
|
ob_start(); |
624
|
|
|
do_action( 'cp_logs_description', $meta['cubepoints_type'], $user_id, $points, $meta['cubepoints_data'] ); |
625
|
|
|
return ob_get_clean(); |
626
|
|
|
} |
627
|
|
|
|
628
|
|
|
/** |
629
|
|
|
* Get the next 500 points logs from CubePoints. |
630
|
|
|
* |
631
|
|
|
* @since 1.0.0 |
632
|
|
|
* |
633
|
|
|
* @param int $start The offset number to begin counting the 500 at. |
634
|
|
|
* |
635
|
|
|
* @return object[]|false The rows from the database. |
636
|
|
|
*/ |
637
|
|
|
protected function get_next_points_logs_batch( $start ) { |
638
|
|
|
|
639
|
|
|
global $wpdb; |
640
|
|
|
|
641
|
|
|
$logs = $wpdb->get_results( // WPCS: unprepared SQL OK. |
642
|
|
|
$wpdb->prepare( // WPCS: unprepared SQL OK. |
643
|
|
|
' |
644
|
|
|
SELECT * |
645
|
|
|
FROM `' . CP_DB . '` |
646
|
|
|
ORDER BY `id` |
647
|
|
|
LIMIT %d,500 |
648
|
|
|
' |
649
|
|
|
, $start |
650
|
|
|
) |
651
|
|
|
); // WPCS: cache OK. |
652
|
|
|
|
653
|
|
|
if ( ! is_array( $logs ) ) { |
654
|
|
|
$this->feedback->error( __( 'Unable to retrieve the logs from CubePoints…', 'wordpoints-importer' ) ); |
655
|
|
|
return false; |
656
|
|
|
} |
657
|
|
|
|
658
|
|
|
return $logs; |
659
|
|
|
} |
660
|
|
|
|
661
|
|
|
/** |
662
|
|
|
* Import ranks. |
663
|
|
|
* |
664
|
|
|
* @since 1.1.0 |
665
|
|
|
* |
666
|
|
|
* @param array $settings The import settings for the ranks component. |
667
|
|
|
*/ |
668
|
|
|
public function import_ranks( $settings ) { |
669
|
|
|
|
670
|
|
|
$this->feedback->info( __( 'Importing ranks…', 'wordpoints-importer' ) ); |
671
|
|
|
|
672
|
|
|
$ranks_data = get_option( 'cp_module_ranks_data' ); |
673
|
|
|
|
674
|
|
|
if ( empty( $ranks_data ) || ! is_array( $ranks_data ) ) { |
675
|
|
|
$this->feedback->error( __( 'No ranks found.', 'wordpoints-importer' ) ); |
676
|
|
|
return; |
677
|
|
|
} |
678
|
|
|
|
679
|
|
|
$i = 0; |
680
|
|
|
|
681
|
|
|
// The base rank already exists, so we just update it. |
682
|
|
|
if ( isset( $ranks_data[0] ) ) { |
683
|
|
|
|
684
|
|
|
wordpoints_update_rank( |
685
|
|
|
WordPoints_Rank_Groups::get_group( $settings['rank_group'] )->get_rank( 0 ) |
686
|
|
|
, $ranks_data[0] |
687
|
|
|
, 'base' |
688
|
|
|
, $settings['rank_group'] |
689
|
|
|
, 0 |
690
|
|
|
); |
691
|
|
|
|
692
|
|
|
$i++; |
693
|
|
|
|
694
|
|
|
unset( $ranks_data[0] ); |
695
|
|
|
} |
696
|
|
|
|
697
|
|
|
$points_type = substr( $settings['rank_group'], strlen( 'points_type-' ) ); |
698
|
|
|
$rank_type = 'points-' . $points_type; |
699
|
|
|
|
700
|
|
|
ksort( $ranks_data ); |
701
|
|
|
|
702
|
|
|
foreach ( $ranks_data as $points => $rank_name ) { |
703
|
|
|
|
704
|
|
|
wordpoints_add_rank( |
705
|
|
|
$rank_name |
706
|
|
|
, $rank_type |
707
|
|
|
, $settings['rank_group'] |
708
|
|
|
, $i |
709
|
|
|
, array( 'points' => $points, 'points_type' => $points_type ) |
710
|
|
|
); |
711
|
|
|
|
712
|
|
|
$i++; |
713
|
|
|
} |
714
|
|
|
|
715
|
|
|
// translators: Number of ranks. |
716
|
|
|
$this->feedback->success( sprintf( __( 'Imported %s ranks.', 'wordpoints-importer' ), $i ) ); |
717
|
|
|
} |
718
|
|
|
} |
719
|
|
|
|
720
|
|
|
// EOF |
721
|
|
|
|
This check looks from parameters that have been defined for a function or method, but which are not used in the method body.