I need a little help deciphering one line of PHP code:
$prune_all = ($prune_all) ? '' : 'AND t.topic_vote = 0 AND t.topic_type <> ' . POST_ANNOUNCE;
This is the line of code that tells the prune function in phpBB to exclude polls and announcements from being pruned.

My friend, however, wants to include polls in the prune function, and exclude stickies as well as announcements in the prune function.

Removing "AND t.topic_vote = 0" does the trick for including polls in the prune function:
$prune_all = ($prune_all) ? '' : 'AND t.topic_type <> ' . POST_ANNOUNCE;
But I don't know the proper syntax to add stickies (POST_STICKY) to this line to have it excluded from the prune function.

Can anyone help?

Try



$prune_all = ($prune_all) ? '' : 'AND t.topic_type <> ' . POST_ANNOUNCE. 'AND t.topic_type = '. POST_STICKY;



The Ternary Operator (http://www.php.net/manual/en/language.operators.comparison.php) works like this :



(condition) ? true : false;



If (condition) is true, do the stuff after the ? else to the stuff after the :

Thanks fyrestrtr :)

Mind answering some noobie learning questions?

$prune_all = ($prune_all) ? '' : 'AND t.topic_type <> ' . POST_ANNOUNCE. 'AND t.topic_type ='. POST_STICKY;

Why is <> used for one while = for the other?
What purpose do the dots (.) serve?
Any idea why a condition was used if the "true" field is empty?

It just means if $prune_all holds a value set it to nothing ('') else set it to whats after the :

<> means NOT equal to in MySQL, = means equal to

. is used for concatination , eg.

$var = 'hi';
echo 'test '.$var.' test';

This would echo test hi test

Hope this helps.

Thanks for the explanation digitok. :)

Since he wants to prune all topics except for Announcements and Stickies, shouldn't the code be like this then?
$prune_all = ($prune_all) ? '' : 'AND t.topic_type <> ' . POST_ANNOUNCE. 'AND t.topic_type <>'. POST_STICKY.;
Would this work as well?
$prune_all = ($prune_all) ? '' : 'AND t.topic_type <> ' . POST_ANNOUNCE. OR .POST_STICKY;

Try this...

$prune_all = ($prune_all) ? '' : 'AND t.topic_type NOT IN('.POST_ANNOUNCE.','.POST_STICKY.')';

digitok,

Works great! Thanks :)