How to delete Posts?

[marcelll]

How do i delete posts by users or in generel posts by users i dont want on my website?

[Yankidank]

1. Log in as an admin or god level user.
2. Find the story you wish to modify/delete.
3. Click on "admin links" just below the title.
4. Click "Admin: change the status".
5. Choose "Set to discard", "Set to queued" or "Set to published".

[jpfieber]

If you set a post to 'discard', it doesn't show up on the upcoming or published pages, but it still exists (takes up space in the database, clutters up the News Management window). Is there a way to cleanly delete the post like it never existed? Seems you should be able to do this without hacking away with phpMyAdmin, and risking the nasty side affects that come with deleting the wrong things.

[phalcon]

I agree. I have quite a few test posts which all are labeled 'discard' but they clutter up my admin news management page.

[P1mpPanther]

i think the only way to actually "remove" the posts is from the database - you can probably do it with phpMyAdmin or something similar.

[jpfieber]

Originally Posted by P1mpPanther

i think the only way to actually "remove" the posts is from the database - you can probably do it with phpMyAdmin or something similar.

Undoubtedly it's possible if you know where to delete the post, and then where to find all the references to the post to delete as well, but that's not practical. This software needs a built in method for truly and properly deleting a post.

[Thunder]

I have got the same problem.

I want to completly delete newsposts but it seems not to be possible.

For the upcoming releases please fix this problem.

[ivnj]

So when I goto PhpMyAdmin. In my database which table contains the posts?

Thanks,
ivnj

[fiacyberz]

It is the pligg_links table.
You can easily delete alls DISCARD posts with the SQL-command:
DELETE FROM pligg_links WHERE link_status = 'discard'

But a better way is, of course, to integrate this into the admin control panel
I take a look at it and maybe upload a hack here.

[fiacyberz]

Ok got this finished.

Changes in admin_links.php, just enter under the links for marking

<a href=# onclick="javascript:window.open('admin_delete.php?time=259200', 'ab 3 Tage löschen', 'width=200, height=100')">delete 3-day old discard</a>

and now make a new file called admin_delete.php
it is maybe to much included, but i works ;)

<?php
include_once('Smarty.class.php');
$main_smarty = new Smarty;

include('config.php');
include(mnminclude.'html1.php');
include(mnminclude.'link.php');
include(mnminclude.'user.php');
include(mnminclude.'smartyvariables.php');
			
// require user to log in
force_authentication();

// restrict access to god only
$canIhaveAccess = 0;
$canIhaveAccess = $canIhaveAccess + checklevel('god');

// sidebar
$main_smarty = do_sidebar($main_smarty);

if ($canIhaveAccess == 1 && isset($_GET[time])) {
	$time = $_GET[time];
	
	$time = date("U") - $time;
	$time = date("Y-m-d H:i:s",$time);   
	
	$db->query ("DELETE FROM " . table_links . " WHERE link_date < '$time' AND link_status = 'discard'");
	echo MYSQL_AFFECTED_ROWS()." rows affected";
}
?>