Welcome to Geeklog, Anonymous Tuesday, November 28 2023 @ 08:53 pm EST

Geeklog Forums

What's The Best Way To (Mass) Reset Article Permissions?

Post New Reply

Author:

Mood:

Code

Font Color Font Size Close Tags

Forum BBCode Help

BBCode	Effect
[b]bolded text[/b]	bolded text
[i]italicized text[/i]	italicized text
[u]underlined text[/u]	underlined text
[s]strikethrough text[/s]	strikethrough text
[img]http://www.site.com/forum/images/forum.png[/img] OR [img h=65 w=50]http://www.site.com/forum/images/forum.png[/img]
[url=https://www.geeklog.net]Geeklog[/url]	Geeklog
[quote]quoted text[/quote]	To quote: quoted text
[size=15]Your Text[/size] "12" is usually standard on message boards. Usually measured in pixels (px).	Your Text
[color=red]Red Text[/color] OR [color=#FF0000]Red Text[/color] Can use many different color names or hex codes.	Red Text
[list] []List item 1 []List item 2 [/list] OR [list=1] []List item 1 []List item 2 [/list]	List item 1 List item 2 List item 1 List item 2
[code]monospaced text[/code]	monospaced text
[code=XYX]formatted code[/code] Where XYZ can be any of the following: c css html4strict java javascript jquery perl php plain python SQL and many more...	formatted code
To enter a backslash (\) in your post, use \\\\	\

Subject

[QUOTE][u]Quote by: winnerdk[/u][p]I switched to a subscription model in November of last year (2012). Now paying subscribers have to be logged in to their accounts in order to see the full text of articles.

Articles published

I've been publishing "teaser" articles containing just the first sentence of the article. These "teasers" are visible only to anonymous users (the public who are not logged in to their user accounts). In the gl_stories database, these reflect a "0" under "perm_members" and a "2" under "perm_anon"

The full versions of the articles are published with the entire content, but marked as "read" for members (users who are signed in to their accounts). These are invisible to the general public. In the gl_stories database these articles reflect a "2" under "perm_members" and a "0" under "perm_anon".

Now, here's my question. I only want to keep the "teasers" active for about three or four weeks. After that time, I want to delete the "teaser" articles and change the permissions for the articles that were restricted to signed in users only, to public access.

I now have an accumulation of articles in this status. I know, I can go and change all of them manually, delete the teasers, and change the permission checks on all of the full articles. But, there are a lot of them (like more than 2,000).

So, would it be possible to do this through the database? Can I just pull up the articles and modify them at that level - like make a pull then change the appropriate elements under "perm_members" and "perm_anon" as required? If so, how do I do that? If I make this sort of manipulation at the database level, will I be screwing something else up?

I'm just trying to find a way to save some time, and to make this task easier. Thanks.

Don Winner
www.panama-guide.com[/p][/QUOTE]

Options:

HTML Mode

Geeklog Forums

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks