Geeklog Forums

Is there anyway to select a number of stories at once and give them all the same permissions. I made everything only for members, and now i want to give it anonymous access and that would take hours to manually set all the permissions for each story. Anyone know how i could do it faster ? Maybe in SQL ?

Thanks.

i dont know if there is a feature like that in geeklog. but if you have access to you database you can do that with just a single query. i have done that once.

uo can do something like this

change gl_stories to the actual stories table name in your geeklog database.

---

we are just shadows of our hidden identities

can you give me a little bit more detail, im really bad at working with SQL. Im using phpmyadmin for an SQL administration program.

in your phpmyadmin point to your geeklog database click on query window. execute the query below.



change gl_stories to the actual stories table name in your geeklog database.

this will give anonymous user read access to all of you stories.

---

we are just shadows of our hidden identities

i already tried that it doesn't seem to do anything, at most it just lists all the stories, and then someitmes it just says:

" You have to choose at least one Column to display "

There are all kinds of boxes in the query option that i don't know about.

My table is gl_stories.

you mean this code?



try doing it again, this time use this query

---

we are just shadows of our hidden identities

here's a screen:

SQL Screen

did you click on submit query? the one on the lower right? that query should do what you wanted to happen.

---

we are just shadows of our hidden identities

yes i did, nothing happens except that error message in red comes up.

maybe throw a semicolon at the end of the command. shouldn't matter with phpmyadmin, but whoknows

That is all i get, it has gone through properly and it says it affects like 300 rows but then nothing is even changed, the permissions are still not anonymous for all the stories.

thats not the query i was telling you! try to compare the one you executed and the one im telling you.

on the screen shot you've posted here. just below the phpMyAdmin logo in the upper left. that icon third from left(the one that was labeled SQL), click that, paste the query i'm telling you and click on go button.

---

we are just shadows of our hidden identities