$query = 'INSERT INTO instagram_media_mentions VALUES(NULL, $1, $2, \'$3\');'; $result_insert = db_query($query, array($id_profile, $id_media, strtolower($mention)), 1); } } /*** Comments ***/ $aux_count = 1; foreach ($post['comments']['data'] as $comment) { $query = 'INSERT INTO instagram_media_comments VALUES(NULL, $1, $2, \'$3\', \'$4\', $5, \'$6\', \'$7\', \'$8\', $9);'; $result_insert = db_query($query, array($id_profile, $id_media, $comment['text'], $comment['from']['username'], $comment['from']['id'], $comment['from']['full_name'], $comment['from']['profile_picture'], $comment['id'], $comment['created_time']), 1); if ($aux_count++ > 4) { break; } } } } } else { error_log('Meta code: ' . json_encode($posts) . ' - ' . date('d m Y H:i:s')); } if ($update_type == 'update_post_info' && empty($pagination)) { $have_post = false; } } while ($have_post && $meta_code == 200); } } update_instagram_media('add_new_posts'); //Capturamos los nuevos posteos update_instagram_media('add_old_posts'); //Capturamos los viejos posteos update_instagram_media('update_post_info', 90); //Actualizamos los datos de los pasteos de hace 3 meses error_log('Record Posts (f): ' . date('d m Y H:i:s'));
$found_user['bio'] = 'NULL'; } if (empty($found_user['website'])) { $found_user['website'] = 'NULL'; } $query = 'INSERT INTO instagram_profiles VALUES(NULL, $1, \'$2\', ' . ($found_user['bio'] != "NULL" ? "'\$3'" : "\$3") . ', ' . ($found_user['website'] != "NULL" ? "'\$4'" : "\$4") . ', \'$5\', \'$6\', $7, 1, NOW(), NOW());'; $row = db_query($query, array($found_user['id'], $found_user['username'], $found_user['bio'], $found_user['website'], $found_user['profile_picture'], $found_user['full_name'], $category['id_category']), 1); $new_register = true; $profile_id = get_instagram_profile_id($found_user['id']); if (!empty($profile_id)) { $query = 'INSERT INTO instagram_record VALUES($1, $2, $3, $4, NOW());'; $row = db_query($query, array($profile_id, $found_user['counts']['media'], $found_user['counts']['followed_by'], $found_user['counts']['follows']), 1); /***** Insertamos los posteos *****/ error_log('Record Posts (i): ' . date('d m Y H:i:s')); include 'record_posts.php'; update_instagram_media('add_new_posts', $profile_id, 5); //Capturamos los nuevos posteos error_log('Record Posts (f): ' . date('d m Y H:i:s')); /***** El usuario se ha registrado! *****/ //Generamos y enviamos los datos error_log(' Add Profile (f): ' . date('d m Y H:i:s')); error_log(' Generate Results (i): ' . date('d m Y H:i:s')); generate_data_results($profile_id); } else { $message = array('message_code' => 3, 'description' => 'Sorry, an error has occurred'); } } else { // El usuario ya existe! //Generamos y enviamos los datos error_log(' Add Profile (f): ' . date('d m Y H:i:s')); error_log(' Generate Results (i): ' . date('d m Y H:i:s'));