functions.php

<?php
function format_plural($count, $singular, $plural) {
	if ($count == 1) {return $singular;} 
    else {return $count . " " . $plural;}
}

/**
  * Provides a string representation of how far apart two times are.
  * @param {int} $timeInterval [in positive seconds]
  * @param {int} $granularity [number of units to show before truncating]
  */
function format_interval($timeInterval, $granularity = 2) {
	if ($timeInterval < 0) {
        error_log("format_interval was passed a negative time inteval: $timeInterval, and returned 0 sec"); 
        return "0 sec";
    }
    $units = array('1 year|years' => 31536000, '1 week|weeks' => 604800, '1 day|days' => 86400, '1 hr|hrs' => 3600, '1 min|min' => 60, '1 sec|sec' => 1);
	$output = '';
	foreach ($units as $key => $value) {
		$key = explode('|', $key);
		if ($timeInterval >= $value) {
			$output .= ($output ? ' ' : '') . format_plural(floor($timeInterval / $value), $key[0], $key[1]);
			$timeInterval %= $value;
			$granularity--;
		}
		if ($granularity == 0) {break;}
	}
	return $output ? $output : "0 sec";
}

function pluralize($count, $singular, $plural = false) {
    if (!$plural) {$plural = $singular . 's';} 
    return ($count == 1 ? $singular : $plural);
}

function getCommentAnchor($commentid) {
	return "comment_" . $commentid;
}
/*
Handles URLs after href= and src=.
*/
function turnRelativeLinksAbsolute($htmlcomment) {
	$matches = array();
	$pattern = '/(href|src)="([^" ]*)"/i';
	if ($num_matches = preg_match_all($pattern, $htmlcomment, $matches)) {
		for ($i = 0; $i < $num_matches; $i++) {
			if (stripos($matches[2][$i], "http") === FALSE) { //won't mess with https
				$replacefrom = $matches[2][$i];
				if (stripos($replacefrom, "//") !== FALSE) { 
					//I don't know why people make links like "//www.youtube.com" but they do
					$replaceto = "http:" . $matches[2][$i];
				} else {
					$replaceto = "http://" . $matches[2][$i];
				}
				$htmlcomment = str_replace($replacefrom, $replaceto, $htmlcomment);
			}	
		}
	}
	return $htmlcomment;
}

/*====================
explodePhrases

  Works like explode() with a " " delimiter, but phrases in (unescaped) quotation marks count as one word. 
  Doesn't return empty strings.
  Up to one character from the $operators string is allowed to precede each word. (must be regex-friendly)
======================*/
function explodePhrases( $str, $operators=NULL ) {
	$regex = "/[\s]*([$operators]?\"[^\"]*\")[\s]*/";
	$quotesplit = preg_split($regex, $str, NULL, PREG_SPLIT_NO_EMPTY |  PREG_SPLIT_DELIM_CAPTURE);
	$phraselist = array();
	foreach ($quotesplit as $value) {
		if ( preg_match($regex, $value) ) {
			$phraselist[] = $value;
		} else {
			$phraselist = array_merge($phraselist, preg_split("/\s+/", $value, NULL, PREG_SPLIT_NO_EMPTY));
		}
	}
	return $phraselist;
}

/*====================
preprocessForSqlBoolean

  Force SQL Boolean mode to find all the words (default is OR) and to treat hyphenated words as one word.
======================*/
function preprocessForSqlBoolean( $searchstring ) { //$searchstring should be unescaped
	$operators = "+-~<>";
	$searchPhrases = explodePhrases($searchstring, $operators);
	$len = count($searchPhrases);
    for ($i=0; $i < $len; $i++) {
		//check for operators, add a + if none
		$first = substr($searchPhrases[$i], 0, 1);
		if ( strpbrk($first, $operators) ) {
			$op = $first;
			$searchPhrases[$i] = substr($searchPhrases[$i], 1);
		} else {$op = "+";}
		//surround hyphenated words in quotes
		if ( stripos($searchPhrases[$i], "-") && ($searchPhrases[$i][0] !== "\"") ) {
			$searchPhrases[$i] = "\"" . $searchPhrases[$i] . "\"";
		}
		$searchPhrases[$i] = $op . $searchPhrases[$i];
	}
	
	$searchPhraseString = implode(" ", $searchPhrases);
	return mysql_real_escape_string($searchPhraseString); //sanitize single quotes
}

function stripBooleanOperators($str) {
	//tokenize the search string, removing operators and quotation marks
	//returns the tokens in an array
	$operators = "+-~<>";
	$q_phrases = explodePhrases($str, $operators);
	$strippedStrings = array();
	foreach($q_phrases as $value) {
		$value = str_replace("\"", "", $value);
		if ( strpbrk(substr($value, 0, 1), $operators) ) {
			$value = substr($value, 1);
		}
        $value = addslashes($value);
		$strippedStrings[] = $value;
	}
	return $strippedStrings;
}
/*====================
wantNewPosts

  On the conversations page, see if we have a new post, if we came from the list of new posts or are working with our own post
======================*/
function wantNewPosts($postid) {
	if (empty($postid)) {return false;}
    
    if (isset($_REQUEST['action'])) {
        if (($_REQUEST['action'] != "edit") && ($_REQUEST['action'] != "reply")) {
            return true; 
        }
	}
	if (isset($_SERVER['HTTP_REFERER'])) {
        if ( ($_SERVER['HTTP_REFERER'] == HOST_NAME . "/") || stripos($_SERVER['HTTP_REFERER'], "index.php")) return true;
		// If only the main page can trigger wantNew, you can come from search results or bookmarks to the post you wanted, not some new post.
	}
	return false;	
}

/**
 * Visual dump of MySql query results for debugging.
 */
function echo_mysql($query, $returntype='array') {
    $start = microtime(true);
    $res = mysql_query($query) or die (mysql_error());
    $finish = microtime(true);
    echo "<pre>" . wordwrap($query, 60, "<BR>") . "<BR><hr>";
    echo "(took " . number_format(($finish - $start), 3) . " seconds)<BR>";
    if (is_bool($res)) { 
        echo "Result: " . (string) $res . "<BR>";
        return;
    }
    if ($returntype == 'array') {
        echo "<TABLE>";
        while ($row = mysql_fetch_assoc($res)) {
            foreach ($row as $key=>$value) {
                echo "<TR class='searchResults'><TD class='searchResults'>$key</TD><TD class='searchResults'>" 
                . wordwrap($value, 90, "<BR>") . "</TD></TR>";
            }
            echo "<TR><td>&nbsp;</TD><td>&nbsp;</TD></TR>";
            echo "<TR><td>&nbsp;</TD><td>&nbsp;</TD></TR>";
        }
        echo "</TABLE>";
    } else if ($returntype == 'scalar') {
        echo "scalar 'row': <bR>";
        var_dump($row);
        $row = mysql_fetch_array($res);
            echo $row[0];
    }
    echo "</pre><br> ";
}

?>