1 files changed, 57 insertions, 0 deletions
diff --git a/includes/classes/SearchStatsLib.php b/includes/classes/SearchStatsLib.php
new file mode 100755
index 0000000..de5bd9e
--- /dev/null
+++ b/includes/classes/SearchStatsLib.php
@@ -0,0 +1,57 @@
+<?php
+/**
+ * $Header$
+ *
+ * @copyright (c) 2004 bitweaver.org
+ * Copyright (c) 2003 tikwiki.org
+ * Copyright (c) 2002-2003, Luis Argerich, Garland Foster, Eduardo Polidor, et. al.
+ * All Rights Reserved. See below for details and a complete list of authors.
+ * Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See http://www.gnu.org/copyleft/lesser.html for details
+ *
+ * $Id$
+ * @author  Luis Argerich (lrargerich@yahoo.com)
+ * @package search
+ */
+
+namespace Bitweaver\Search;
+use Bitweaver\BitBase;
+
+/**
+ * @package search
+ * @subpackage SearchStatsLib
+ */
+class SearchStatsLib extends BitBase {
+
+	function clear_search_stats() {
+		$query = "DELETE FROM `".BIT_DB_PREFIX."search_stats";
+		$result = $this->mDb->query($query,[]);
+	}
+
+	function list_search_stats($offset, $max_records, $sort_mode, $find) {
+
+		if ($find) {
+			$mid = " WHERE (UPPER(`term`) LIKE ?)";
+			$bindvars = [ "%".strtoupper( $find )."%" ];
+		} else {
+			$mid = "";
+			$bindvars = [];
+		}
+
+		$query = "SELECT * FROM `".BIT_DB_PREFIX."search_stats` $mid ORDER BY ".$this->mDb->convertSortmode($sort_mode);
+		$query_cant = "SELECT COUNT(*) FROM `".BIT_DB_PREFIX."search_stats` $mid";
+		$result = $this->mDb->query($query,$bindvars,$max_records,$offset);
+		$cant = $this->mDb->getOne($query_cant,$bindvars);
+		$ret = [];
+
+		while ($res = $result->fetchRow()) {
+			$ret[] = $res;
+		}
+
+		$retval = [];
+		$retval["data"] = $ret;
+		$retval["cant"] = $cant;
+		return $retval;
+	}
+}
+
+$searchstatslib = new SearchStatsLib();