summaryrefslogtreecommitdiffstatshomepage
path: root/services/tagstatservice.php
diff options
context:
space:
mode:
authorGravatar cweiske2009-10-03 14:00:33 +0000
committerGravatar cweiske2009-10-03 14:00:33 +0000
commit29422fa55379aa61a61019b832c83dab6d450264 (patch)
treee5884ce6fed2cf1d02165a1b5667b99cd80262e5 /services/tagstatservice.php
parentb8b1d06b2d899658fae64d0de506439ca0ea067c (diff)
downloadscuttle-29422fa55379aa61a61019b832c83dab6d450264.tar.gz
scuttle-29422fa55379aa61a61019b832c83dab6d450264.zip
move files to new locations
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@386 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'services/tagstatservice.php')
-rw-r--r--services/tagstatservice.php193
1 files changed, 0 insertions, 193 deletions
diff --git a/services/tagstatservice.php b/services/tagstatservice.php
deleted file mode 100644
index 9d3ca5d..0000000
--- a/services/tagstatservice.php
+++ /dev/null
@@ -1,193 +0,0 @@
-<?php
-class TagStatService {
- var $db;
- var $tablename;
-
- function &getInstance(&$db) {
- static $instance;
- if (!isset($instance))
- $instance =& new TagStatService($db);
- return $instance;
- }
-
- function TagStatService(&$db) {
- $this->db =& $db;
- $this->tablename = $GLOBALS['tableprefix'] .'tagsstats';
- }
-
- function getNbChildren($tag1, $relationType, $uId) {
- $tts =& ServiceFactory::getServiceInstance('Tag2TagService');
- $query = "SELECT tag1, relationType, uId FROM `". $tts->getTableName() ."`";
- $query.= " WHERE tag1 = '" .$tag1 ."'";
- $query.= " AND relationType = '". $relationType ."'";
- $query.= " AND uId = '".$uId."'";
-
- return $this->db->sql_numrows($this->db->sql_query($query));
- }
-
- function getNbDescendants($tag1, $relationType, $uId) {
- $query = "SELECT nb FROM `". $this->getTableName() ."`";
- $query.= " WHERE tag1 = '" .$tag1 ."'";
- $query.= " AND relationType = '". $relationType ."'";
- $query.= " AND uId = '".$uId."'";
-
- $dbresults =& $this->db->sql_query($query);
- $row = $this->db->sql_fetchrow($dbresults);
- if($row['nb'] == null) {
- return 0;
- } else {
- return (int) $row['nb'];
- }
- }
-
- function getMaxDepth($tag1, $relationType, $uId) {
- $query = "SELECT depth FROM `". $this->getTableName() ."`";
- $query.= " WHERE tag1 = '" .$tag1 ."'";
- $query.= " AND relationType = '". $relationType ."'";
- $query.= " AND uId = '".$uId."'";
-
- $dbresults =& $this->db->sql_query($query);
- $row = $this->db->sql_fetchrow($dbresults);
- if($row['depth'] == null) {
- return 0;
- } else {
- return (int) $row['depth'];
- };
- }
-
- function getNbUpdates($tag1, $relationType, $uId) {
- $query = "SELECT nbupdate FROM `". $this->getTableName() ."`";
- $query.= " WHERE tag1 = '" .$tag1 ."'";
- $query.= " AND relationType = '". $relationType ."'";
- $query.= " AND uId = '".$uId."'";
-
- $dbresults =& $this->db->sql_query($query);
- $row = $this->db->sql_fetchrow($dbresults);
- if($row['nbupdate'] == null) {
- return 0;
- } else {
- return (int) $row['nbupdate'];
- }
- }
-
- function existStat($tag1, $relationType, $uId) {
- $query = "SELECT tag1, relationType, uId FROM `". $this->getTableName() ."`";
- $query.= " WHERE tag1 = '" .$tag1 ."'";
- $query.= " AND relationType = '". $relationType ."'";
- $query.= " AND uId = '".$uId."'";
-
- return $this->db->sql_numrows($this->db->sql_query($query))>0;
- }
-
- function createStat($tag1, $relationType, $uId) {
- $query = "INSERT INTO `". $this->getTableName() ."`";
- $query.= "(tag1, relationType, uId)";
- $query.= " VALUES ('".$tag1."','".$relationType."','".$uId."')";
- $this->db->sql_query($query);
- }
-
- function updateStat($tag1, $relationType, $uId=null, $stoplist=array()) {
- if(in_array($tag1, $stoplist)) {
- return false;
- }
-
- $tts =& ServiceFactory::getServiceInstance('Tag2TagService');
- $linkedTags = $tts->getLinkedTags($tag1, $relationType, $uId);
- $nbDescendants = 0;
- $maxDepth = 0;
- foreach($linkedTags as $linkedTag) {
- $nbDescendants+= 1 + $this->getNbDescendants($linkedTag, $relationType, $uId);
- $maxDepth = max($maxDepth, 1 + $this->getMaxDepth($linkedTag, $relationType, $uId));
- }
- $this->setNbDescendants($tag1, $relationType, $uId, $nbDescendants);
- $this->setMaxDepth($tag1, $relationType, $uId, $maxDepth);
- $this->increaseNbUpdate($tag1, $relationType, $uId);
-
- // propagation to the precedent tags
- $linkedTags = $tts->getLinkedTags($tag1, $relationType, $uId, true);
- $stoplist[] = $tag1;
- foreach($linkedTags as $linkedTag) {
- $this->updateStat($linkedTag, $relationType, $uId, $stoplist);
- }
- }
-
- function updateAllStat() {
- $tts =& ServiceFactory::getServiceInstance('Tag2TagService');
-
- $query = "SELECT tag1, uId FROM `". $tts->getTableName() ."`";
- $query.= " WHERE relationType = '>'";
-
- //die($query);
-
- if (! ($dbresult =& $this->db->sql_query($query)) ){
- message_die(GENERAL_ERROR, 'Could not update stats', '', __LINE__, __FILE__, $query, $this->db);
- return false;
- }
-
- $rowset = $this->db->sql_fetchrowset($dbresult);
- foreach($rowset as $row) {
- $this->updateStat($row['tag1'], '>', $row['uId']);
- }
- }
-
- function setNbDescendants($tag1, $relationType, $uId, $nb) {
- if(!$this->existStat($tag1, $relationType, $uId)) {
- $this->createStat($tag1, $relationType, $uId);
- }
- $query = "UPDATE `". $this->getTableName() ."`";
- $query.= " SET nb = ". $nb;
- $query.= " WHERE tag1 = '" .$tag1 ."'";
- $query.= " AND relationType = '". $relationType ."'";
- $query.= " AND uId = '".$uId."'";
- $this->db->sql_query($query);
- }
-
- function setMaxDepth($tag1, $relationType, $uId, $depth) {
- if(!$this->existStat($tag1, $relationType, $uId)) {
- $this->createStat($tag1, $relationType, $uId);
- }
- $query = "UPDATE `". $this->getTableName() ."`";
- $query.= " SET depth = ". $depth;
- $query.= " WHERE tag1 = '" .$tag1 ."'";
- $query.= " AND relationType = '". $relationType ."'";
- $query.= " AND uId = '".$uId."'";
- $this->db->sql_query($query);
- }
-
- function increaseNbUpdate($tag1, $relationType, $uId) {
- if(!$this->existStat($tag1, $relationType, $uId)) {
- $this->createStat($tag1, $relationType, $uId);
- }
- $query = "UPDATE `". $this->getTableName() ."`";
- $query.= " SET nbupdate = nbupdate + 1";
- $query.= " WHERE tag1 = '" .$tag1 ."'";
- $query.= " AND relationType = '". $relationType ."'";
- $query.= " AND uId = '".$uId."'";
-
- //die($query);
-
- $this->db->sql_query($query);
- }
-
- function deleteTagStatForUser($uId) {
- $query = 'DELETE FROM '. $this->getTableName() .' WHERE uId = '. intval($uId);
-
- if (!($dbresult = & $this->db->sql_query($query))) {
- message_die(GENERAL_ERROR, 'Could not delete tag stats', '', __LINE__,
- __FILE__, $query, $this->db);
- return false;
- }
-
- return true;
- }
-
- function deleteAll() {
- $query = 'TRUNCATE TABLE `'. $this->getTableName() .'`';
- $this->db->sql_query($query);
- }
-
- // Properties
- function getTableName() { return $this->tablename; }
- function setTableName($value) { $this->tablename = $value; }
-}
-?>