$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'));
