As a "god" user, can I delete a post?

[jmruas]

I would like to know if I can delete a post as a "god" user. If so, how can I do that.

Thank you.

[kbeeveer46]

There should be a link next to each post that says "admin links." It will drop down more links and you want to click on the one that says change status. Once you do that you can discard the story.

[mobilpress]

Originally Posted by kbeeveer46

There should be a link next to each post that says "admin links." It will drop down more links and you want to click on the one that says change status. Once you do that you can discard the story.

It's not a good way. When the story is discarded we have it in database all the same. After one month I have about 5000 stories in database (!!!).
And how to delete the story completely from a database? Also I think that stories should delete automatically after the certain term established in days.

And I have the second question/offer. I have faced that it is necessary to enter different privileges for users that one, for example, could look through only stories and make comments, but not add new stories.
It is possible?

[onelessthang]

Haev you looked into this delete page in this Wiki?

http://www.pligg.com/wiki/index.php?...stories_script

PHP Code:

<?php

mysql_connect("dbhost", "dbname", "dbpass") or die("error1");
mysql_select_db("dbname") or die("error2");

$fourteen_days   = 1209600;
$now = date("U") - $fourteen_days; 
$ninety_days   = 7776000;
$now2 = date("U") - $ninety_days; 

$now = date("Y-m-d H:i:s",$now);
$now2 = date("Y-m-d H:i:s",$now2);

mysql_query("delete from links where link_date < '$now' AND link_status = 'queued'");
mysql_query("delete from links where link_date < '$now2' AND link_status = 'published'");
mysql_query("delete from links where link_status = 'discard'");

?>

[mobilpress]

Thanks. But we have old votes for this stories in vote table.

[jpfieber]

This seems like something that should definitely be on the front burner for the next release. Not being able to properly remove an entry (including it's votes and other pointers in the database) is a pretty big management issue.

[sunstardude]

Originally Posted by jpfieber

This seems like something that should definitely be on the front burner for the next release. Not being able to properly remove an entry (including it's votes and other pointers in the database) is a pretty big management issue.

Yes, I also have been confused on the lack of a "delete" option. Why does "disacard" not really delete the entry? Also, with the Random Story feature if an item is discarded the random feature sometimes till links to a "discarded" entry. How is the random number of the random story feature generated? Is it a random query from available entries in the database? Or is it just a plain old random number - hence the link sometimes goes to the "Ooops, page not found" page???

[jrothra]

A couple of questions on that script in the wiki.

1. To what do 1209600 and 7776000 refer? Obviously they are fourteen days and ninety days respectively, but is it those time lines in seconds, minutes, what? I'm hoping to know so I can edit it to make it longer/shorter.

2. What file does this script go into?

[revolver]

I think this is going to become a bigger and bigger issue since Pligg is evolving past being a Digg clone and becoming it's own CMS. For many CMS driven sites, users - not just admins - will need to be able to delete their own posts (Imagine a blog without being able to delete a post).

[rezareza]

moauh
TRUNCATE TABLE `pligg_links`

UPDATE `art`.`pligg_totals` SET `total` = '0' WHERE CONVERT( `pligg_totals`.`name` USING utf8 ) = 'queued' LIMIT 1 ;

UPDATE `art`.`pligg_totals` SET `total` = '0' WHERE CONVERT( `pligg_totals`.`name` USING utf8 ) = 'discard' LIMIT 1 ;

TRUNCATE TABLE `pligg_votes`