idno
Globally make posts private
Hi folks,
Sorry this isn't a issue as such but I've just imported 1700 posts from Wordpress and I'd like to make all my posts private, is there a way of doing this? I tried doing some find and replace sql statements on the database but if I replace PUBLIC in the entities table posts are marked in the GUI as private but are still viewable. A similar find and replace in the metadata table locks me out of the site.
version = "0.9.9-a" build = 2018091301
It seems that the variables that count are those in the JSON within entities.contents.
You seem to need to change access to the UUID for your profile…
Something like update entities set contents = replace(contents, 'access":"PUBLIC', 'access":"https:\/\/domain.tld\/view\/hexadecimal-string' where entity_subtype not like 'Idno\Entities\User';
It's unfortunately more subtle than that. I'll try and write a script today that will do what you need - I think it's something that a lot of people would like!
If someone could give me a hint on what to update I could probably work this one out for myself. Any tips?
That script could be expanded into a nice privacy plug-in too. You initially post publicly , but after a set amount of time the posts become Private or Member Only. Similar to using a service with twitter that automatically prunes your feed but now you get to keep your data.
