PageRenderTime 82ms CodeModel.GetById 22ms RepoModel.GetById 1ms app.codeStats 0ms

/classes/tag.php

https://github.com/mivaul/fotbalfan
PHP | 216 lines | 175 code | 41 blank | 0 comment | 25 complexity | 286535cf8a9674437ad0acac40f21c59 MD5 | raw file
    

  1. <?php
    2. 

  2. 

  3. class Tag{
    4. 

  4. 

  5. 	public function addTag($tag,$obj,$id_obj){
    6. 

  6. 		
    7. 

  7. 		include_once "classes/config.php";
    8. 

  8. 		global $TABLES,$FIELDS,$conn;
    9. 

  9. 		$query = "SELECT `" . $FIELDS['tags']['id'] . "` FROM `" . $TABLES['tags'] . "` WHERE `" . $FIELDS['tags']['tag'] . "` = '" . $tag . "' AND `" . $FIELDS['tags']['id_obj'] . "` = '" . $id_obj . "' AND `" . $FIELDS['tags']['obj'] . "` = '" . $obj . "' LIMIT 1;";
    10. 

  10. 		$result = $conn->query($query);
    11. 

  11. 		if($result->num_rows){
    12. 

  12. 			$row = $result->fetch_row(); $id = $row[0];
    13. 

  13. 			unset($query,$result,$row);
    14. 

  14. 			$query = "UPDATE `" . $TABLES['tags'] . "` SET `" . $FIELDS['tags']['hits'] . "` = `" . $FIELDS['tags']['hits'] . "`+1 WHERE `" . $FIELDS['tags']['id'] . "` = '" . $id . "' LIMIT 1 ;";
    15. 

  15. 			unset($id);
    16. 

  16. 			$conn->query($query);
    17. 

  17. 			unset($query);
    18. 

  18. 			
    19. 

  19. 			$query = "UPDATE `" . $TABLES['allTags'] . "` SET `" . $FIELDS['allTags']['hits'] . "` = `" . $FIELDS['allTags']['hits'] . "`+1 WHERE `" . $FIELDS['allTags']['tag'] . "` = '" . $tag . "' LIMIT 1 ;";
    20. 

  20. 			$conn->query($query);
    21. 

  21. 			unset($query);
    22. 

  22. 		}
    23. 

  23. 		else{
    24. 

  24. 			unset($query,$result);
    25. 

  25. 			$query = "INSERT INTO `" . $TABLES['tags'] . "` (`" . $FIELDS['tags']['id'] . "`,`" . $FIELDS['tags']['tag'] . "`,`" . $FIELDS['tags']['obj'] . "`,`" . $FIELDS['tags']['id_obj'] . "`) VALUES (NULL,'" . $tag . "','" . $obj . "','" . $id_obj . "');";
    26. 

  26. 			$conn->query($query);
    27. 

  27. 			unset($query);
    28. 

  28. 			
    29. 

  29. 			$query = "INSERT INTO `" . $TABLES['allTags'] . "` (`" . $FIELDS['allTags']['tag'] . "`) VALUES ('" . $tag . "');";
    30. 

  30. 			$conn->query($query);
    31. 

  31. 		}
    32. 

  32. 		return 1;
    33. 

  33. 	}
    34. 

  34. 	
    35. 

  35. 	public function addViewTag($tag,$id_user,$obj){
    36. 

  36. 	
    37. 

  37. 		include_once "classes/config.php";
    38. 

  38. 		global $TABLES,$FIELDS,$conn;
    39. 

  39. 		$query = "SELECT `" . $FIELDS['userTags']['id'] . "` FROM `" . $TABLES['userTags'] . "` WHERE `" . $FIELDS['userTags']['tag'] . "` = '" . $tag . "' AND `" . $FIELDS['userTags']['obj'] . "` = '" . $obj . "' AND `" . $FIELDS['userTags']['user'] . "` = '" . $id_user . "' LIMIT 1;";
    40. 

  40. 		$result = $conn->query($query);
    41. 

  41. 		if($result->num_rows){
    42. 

  42. 			$row = $result->fetch_row(); $id = $row[0];
    43. 

  43. 			unset($query,$result);
    44. 

  44. 			$query = "UPDATE `" . $TABLES['userTags'] . "` SET `" . $FIELDS['userTags']['hits'] . "` = `" . $FIELDS['userTags']['hits'] . "`+1 WHERE `" . $FIELDS['userTags']['id'] . "` = '" . $id . "' LIMIT 1 ;";
    45. 

  45. 		
    46. 

  46. 			$conn->query($query);
    47. 

  47. 		}
    48. 

  48. 		else{
    49. 

  49. 			unset($query,$result);
    50. 

  50. 			$query = "INSERT INTO `" . $TABLES['userTags'] . "` (`" . $FIELDS['userTags']['id'] . "`,`" . $FIELDS['userTags']['tag'] . "`,`" . $FIELDS['userTags']['obj'] . "`,`" . $FIELDS['userTags']['user'] . "`) VALUES (NULL,'" . $tag . "','" . $obj . "','" . $id_user . "');";
    51. 

  51. 			$conn->query($query);
    52. 

  52. 		}
    53. 

  53. 		return 1;
    54. 

  54. 	}
    55. 

  55. 	
    56. 

  56. 	public function addSearchTag($tag){
    57. 

  57. 		include_once "classes/config.php";
    58. 

  58. 		global $FIELDS,$TABLES,$conn;
    59. 

  59. 		
    60. 

  60. 		$query = "SELECT `" . $FIELDS['allTags']['hits'] . "` FROM `" . $TABLES['allTags'] . "` WHERE `" . $FIELDS['allTags']['tag'] . "` = '" . $tag . "' LIMIT 1;";
    61. 

  61. 		$result = $conn->query($query);
    62. 

  62. 		if($result->num_rows){
    63. 

  63. 			unset($query);
    64. 

  64. 			$query = "UPDATE `" . $TABLES['allTags'] . "` SET `" . $FIELDS['allTags']['hits'] . "` = `" . $FIELDS['allTags']['hits'] . "`+1 WHERE `" . $FIELDS['allTags']['tag'] . "` = '" . $tag . "' LIMIT 1;";
    65. 

  65. 			$conn->query($query);
    66. 

  66. 		}
    67. 

  67. 		else{
    68. 

  68. 			$query = "INSERT INTO `" . $TABLES['allTags'] . "` (`" . $FIELDS['allTags']['tag'] . "`) VALUES ('" . $tag . "');";
    69. 

  69. 			$conn->query($query);
    70. 

  70. 		}
    71. 

  71. 		return 1;
    72. 

  72. 	}
    73. 

  73. 	
    74. 

  74. 	public function primeleTaguri($obj,$id_obj){
    75. 

  75. 		
    76. 

  76. 		include_once "classes/config.php";
    77. 

  77. 		global $FIELDS,$TABLES,$conn;
    78. 

  78. 		
    79. 

  79. 		$return = array();
    80. 

  80. 		
    81. 

  81. 		$query = "SELECT `" . $FIELDS['tags']['tag'] . "` FROM `" . $TABLES['tags'] . "` WHERE `" . $FIELDS['tags']['obj'] . "` = '" . $obj . "' AND `" . $FIELDS['tags']['id_obj'] . "` = '" . $id_obj . "' ORDER BY `" . $FIELDS['tags']['hits'] . "` DESC LIMIT 5;";
    82. 

  82. 		$result = $conn->query($query);
    83. 

  83. 		
    84. 

  84. 		if($result->num_rows){
    85. 

  85. 			while($row = $result->fetch_row())
    86. 

  86. 				$return[count($return)] = $row[0];
    87. 

  87. 		}
    88. 

  88. 		
    89. 

  89. 		 unset($query,$result,$row);
    90. 

  90. 		
    91. 

  91. 		return $return;
    92. 

  92. 		
    93. 

  93. 	}
    94. 

  94. 	
    95. 

  95. }
    96. 

  96. 

  97. class SearchByTag{
    98. 

  98. 	
    99. 

  99. 	function __construct($tag,$pg = 1,$unde = NULL){
    100. 

  100. 		if(is_null($unde)){
    101. 

  101. 			$nrStiri = self::searchByTagGetNr($tag,"stiri");
    102. 

  102. 			$nrFoto = self::searchByTagGetNr($tag,"foto");
    103. 

  103. 			if($nrStiri)
    104. 

  104. 				echo '<a href="stiri.php?tag=' . $tag . '">' . $nrStiri . ' rezultate</a> in stiri<br />' . "\n";
    105. 

  105. 			if($nrFoto)
    106. 

  106. 				echo '<a href="foto.php?tag=' . $tag . '">' . $nrFoto . ' rezultate</a> in foto<br />' . "\n";
    107. 

  107. 		}
    108. 

  108. 		else{
    109. 

  109. 			if($unde == "stiri"){
    110. 

  110. 				include_once "classes/stiri.php";
    111. 

  111. 				$limitaInf = ( $pg - 1 ) * 5;
    112. 

  112. 				Stiri::showNewsByTag($tag,"ASC",$limitaInf,false);
    113. 

  113. 			}
    114. 

  114. 			elseif($unde == "foto"){
    115. 

  115. 				include_once "classes/foto.php";
    116. 

  116. 				$limitaInf = ( $pg - 1 ) * 30;
    117. 

  117. 				Foto::showFotosByTag($tag,$limitaInf,false);
    118. 

  118. 			}
    119. 

  119. 			else
    120. 

  120. 				echo 'Nu exista pagina pe care o cautati!';
    121. 

  121. 		}
    122. 

  122. 	}
    123. 

  123. 	
    124. 

  124. 	public function searchByTagGetNr($tag,$unde){
    125. 

  125. 		include_once "classes/config.php";
    126. 

  126. 		global $FIELDS,$TABLES,$conn;
    127. 

  127. 		
    128. 

  128. 		$query = "SELECT `" . $FIELDS['tags']['id'] . "` FROM `" . $TABLES['tags'] . "` WHERE `" . $FIELDS['tags']['tag'] . "` = '" . $tag . "' AND `" . $FIELDS['tags']['obj'] . "` = '" . $unde . "'";
    129. 

  129. 		$result = $conn->query($query);
    130. 

  130. 		return $result->num_rows;
    131. 

  131. 	}
    132. 

  132. }
    133. 

  133. 

  134. class TagCloud{
    135. 

  135. 	
    136. 

  136. 	function __construct($where = NULL,$nr = NULL){
    137. 

  137. 	
    138. 

  138. 		include_once "classes/config.php";
    139. 

  139. 		global $FIELDS,$TABLES,$conn;
    140. 

  140. 		
    141. 

  141. 		(string)$unde = "";
    142. 

  142. 		
    143. 

  143. 		if(isset($where)){
    144. 

  144. 			if($where == "stiri")
    145. 

  145. 				$unde = "stiri.php?";
    146. 

  146. 			elseif($where == "foto")
    147. 

  147. 				$unde = "foto.php?";
    148. 

  148. 			else
    149. 

  149. 				$unde = "facilities.php?ce=cauta-dupa-tag&amp;";
    150. 

  150. 		}
    151. 

  151. 		else
    152. 

  152. 			$unde = "facilities.php?ce=cauta-dupa-tag&amp;";
    153. 

  153. 			
    154. 

  154. 		(string)$limit = " LIMIT 15";
    155. 

  155. 		if(!is_null($nr))
    156. 

  156. 			$limit = "";
    157. 

  157. 		
    158. 

  158. 		$query = "SELECT * FROM `" . $TABLES['allTags'] . "` ORDER BY `" . $FIELDS['allTags']['hits'] . "` DESC" . $limit . ";";
    159. 

  159. 		$result = $conn->query($query);
    160. 

  160. 		(int)$i = (int)$best = 0; (int)$max = 30;
    161. 

  161. 		$class = 0;
    162. 

  162. 		while($row = $result->fetch_row()){
    163. 

  163. 			if($i == 0)
    164. 

  164. 				$best = $row[1];
    165. 

  165. 			$class = self::aprox( $row[1] / $best * $max);
    166. 

  166. 			if($class < 7)
    167. 

  167. 				$class = 7;
    168. 

  168. 			echo '<a href="' . $unde . 'tag=' . str_replace(" ","+",$row[0]) . '" class="tagSize' . $class . '">' . $row[0] . '</a>' . "\n";	
    169. 

  169. 			
    170. 

  170. 			$i++;
    171. 

  171. 		}	
    172. 

  172. 	}
    173. 

  173. 	
    174. 

  174. 	private function aprox($numar){
    175. 

  175. 		(string)$numar; $part = array();
    176. 

  176. 		$part = explode(".",$numar);
    177. 

  177. 		$part1 = @$part[1];
    178. 

  178. 		if((int)$part1[0] < 5)
    179. 

  179. 			return (int)$part[0];
    180. 

  180. 		else
    181. 

  181. 			return ((int)$part[0] + 1);
    182. 

  182. 	}
    183. 

  183. 	
    184. 

  184. 	public function afiseazaTaguri($id_obj,$obj,$limit){
    185. 

  185. 	
    186. 

  186. 		include_once "classes/config.php";
    187. 

  187. 		global $TABLES,$FIELDS,$conn;
    188. 

  188. 		
    189. 

  189. 		(string)$unde = "";
    190. 

  190. 		if($obj == "stiri")
    191. 

  191. 			$unde = "stiri.php?";
    192. 

  192. 		elseif($obj == "foto")
    193. 

  193. 			$unde = "foto.php?";
    194. 

  194. 		else
    195. 

  195. 			$unde = "facilities.php?ce=cauta-dupa-tag&amp;";
    196. 

  196. 		
    197. 

  197. 

  198. 		$query = "SELECT `" . $FIELDS['tags']['tag'] . "`,`" . $FIELDS['tags']['hits'] . "` FROM `" . $TABLES['tags'] . "` WHERE `" . $FIELDS['tags']['id_obj'] . "` = '" . $id_obj . "' AND `" . $FIELDS['tags']['obj'] . "` = '" . $obj . "' ORDER BY `" . $FIELDS['tags']['hits'] . "` DESC LIMIT " . $limit . ";";
    199. 

  199. 		$result = $conn->query($query);
    200. 

  200. 		
    201. 

  201. 		(int)$i = 0;
    202. 

  202. 		$max = 30;
    203. 

  203. 		while($row = $result->fetch_row()){
    204. 

  204. 			if($i == 0)
    205. 

  205. 				$best = $row[1];
    206. 

  206. 			$class = self::aprox( $row[1] / $best * $max);
    207. 

  207. 			if($class < 7)
    208. 

  208. 				$class = 7;
    209. 

  209. 			echo '<a href="' . $unde . 'tag=' . str_replace(" ","+",$row[0]) . '&amp;unde=' . $obj . '" class="tagSize' . $class . '">' . $row[0] . '</a>' . "\n";	$i++;
    210. 

  210. 

  211. 		}
    212. 

  212. 	
    213. 

  213. 	}
    214. 

  214. }
    215. 

  215. 

  216. ?>
    217.