PageRenderTime 44ms CodeModel.GetById 12ms RepoModel.GetById 0ms app.codeStats 0ms

/modules/forum/classes/mysql/topic.php

https://gitlab.com/alexprowars/bitrix
PHP | 629 lines | 605 code | 22 blank | 2 comment | 102 complexity | 6f4508d509603007ea1091c31ce862f1 MD5 | raw file
    

  1. <?
    2. 

  2. require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/forum/classes/general/topic.php");
    3. 

  3. 

  4. class CForumTopic extends CAllForumTopic
    5. 

  5. {
    6. 

  6. 	public static function GetList($arOrder = Array("SORT"=>"ASC"), $arFilter = Array(), $bCount = false, $iNum = 0, $arAddParams = array())
    7. 

  7. 	{
    8. 

  8. 		global $DB;
    9. 

  9. 		$arOrder = (is_array($arOrder) ? $arOrder : array());
    10. 

  10. 		$arFilter = (is_array($arFilter) ? $arFilter : array());
    11. 

  11. 		$arAddParams = (is_array($arAddParams) ? $arAddParams : array($arAddParams));
    12. 

  12. 		$arSqlSearch = array();
    13. 

  13. 		$arSqlSelect = array();
    14. 

  14. 		$arSqlGroup = array();
    15. 

  15. 		$arSqlOrder = array();
    16. 

  16. 		$strSqlSearch = "";
    17. 

  17. 		$strSqlSelect = "";
    18. 

  18. 		$strSqlGroup = "";
    19. 

  19. 		$strSqlOrder = "";
    20. 

  20. 		$UseGroup = false;
    21. 

  21. 

  22. 		foreach ($arFilter as $key => $val)
    23. 

  23. 		{
    24. 

  24. 			$key_res = CForumNew::GetFilterOperation($key);
    25. 

  25. 			$key = mb_strtoupper($key_res["FIELD"]);
    26. 

  26. 			$strNegative = $key_res["NEGATIVE"];
    27. 

  27. 			$strOperation = $key_res["OPERATION"];
    28. 

  28. 

  29. 			switch ($key)
    30. 

  30. 			{
    31. 

  31. 				case "STATE":
    32. 

  32. 				case "APPROVED":
    33. 

  33. 				case "XML_ID":
    34. 

  34. 					$val = CForumNew::prepareField($strOperation, "string", $val);
    35. 

  35. 					if ($val == '')
    36. 

  36. 						$arSqlSearch[] = ($strNegative=="Y"?"NOT":"")."(FT.".$key." IS NULL OR ".($DB->type == "MSSQL" ? "LEN" : "LENGTH")."(FT.".$key.")<=0)";
    37. 

  37. 					else if ($strOperation == "IN")
    38. 

  38. 						$arSqlSearch[] = ($strNegative=="Y"?" NOT ":"")."(FT.".$key." IN (".$val.") )";
    39. 

  39. 					else
    40. 

  40. 						$arSqlSearch[] = ($strNegative=="Y"?" FT.".$key." IS NULL OR NOT ":"")."(FT.".$key." ".$strOperation." '".$val."' )";
    41. 

  41. 					break;
    42. 

  42. 				case "ID":
    43. 

  43. 				case "USER_START_ID":
    44. 

  44. 				case "SOCNET_GROUP_ID":
    45. 

  45. 				case "OWNER_ID":
    46. 

  46. 				case "FORUM_ID":
    47. 

  47. 				case "SORT":
    48. 

  48. 				case "POSTS":
    49. 

  49. 				case "TOPICS":
    50. 

  50. 					if (($strOperation!="IN") && (intval($val) > 0))
    51. 

  51. 						$arSqlSearch[] = ($strNegative=="Y"?" FT.".$key." IS NULL OR NOT ":"")."(FT.".$key." ".$strOperation." ".intval($val)." )";
    52. 

  52. 					elseif (($strOperation =="IN") && ((is_array($val) && (array_sum($val) > 0)) || ($val <> '') ))
    53. 

  53. 					{
    54. 

  54. 						if (!is_array($val)) 
    55. 

  55. 							$val = explode(',', $val);
    56. 

  56. 						$val_int = array();
    57. 

  57. 						foreach ($val as $v)
    58. 

  58. 							$val_int[] = intval($v);
    59. 

  59. 						$val = implode(", ", $val_int);
    60. 

  60. 

  61. 						$arSqlSearch[] = ($strNegative=="Y"?" NOT ":"")."(FT.".$key." IN (".$DB->ForSql($val).") )";
    62. 

  62. 					}
    63. 

  63. 					else 
    64. 

  64. 						$arSqlSearch[] = ($strNegative=="Y"?"NOT":"")."(FT.".$key." IS NULL OR FT.".$key."<=0)";
    65. 

  65. 					break;
    66. 

  66. 				case "RENEW_TOPIC":
    67. 

  67. //					vhodnye parametry tipa array("TID"=>time); 
    68. 

  68. //					pri TID = 0 peredaetsya FORUM_LAST_VISIT
    69. 

  69. 					$arSqlTemp = array();
    70. 

  70. 					$strSqlTemp = $val[0];
    71. 

  71. 					unset($val[0]);
    72. 

  72. 					if (is_array($val) && !empty($val))
    73. 

  73. 					{
    74. 

  74. 						foreach ($val as $k => $v)
    75. 

  75. 							$arSqlTemp[] = "(FT.ID=".intval($k).") AND (FT.LAST_POST_DATE > ".$DB->CharToDateFunction($DB->ForSql($v), "FULL").")";
    76. 

  76. 

  77. 						$val_int = array();
    78. 

  78. 						foreach (array_keys($val) as $k)
    79. 

  79. 							$val_int[] = intval($k);
    80. 

  80. 						$keys = implode(", ", $val_int);
    81. 

  81. 

  82. 					$arSqlSearch[] = 
    83. 

  83. 							"(FT.ID IN (".$DB->ForSql($keys).") AND ((".implode(") OR (", $arSqlTemp).")))
    84. 

  84. 							OR
    85. 

  85. 							(FT.ID NOT IN (".$DB->ForSql($keys).") AND (FT.LAST_POST_DATE > ".$DB->CharToDateFunction($DB->ForSql($strSqlTemp), "FULL")."))";
    86. 

  86. 					}
    87. 

  87. 					break;
    88. 

  88. 				case "START_DATE":
    89. 

  89. 				case "LAST_POST_DATE":
    90. 

  90. 					if($val == '')
    91. 

  91. 						$arSqlSearch[] = ($strNegative=="Y"?"NOT":"")."(FT.".$key." IS NULL)";
    92. 

  92. 					else
    93. 

  93. 						$arSqlSearch[] = ($strNegative=="Y"?" FT.".$key." IS NULL OR NOT ":"")."(FT.".$key." ".$strOperation." ".$DB->CharToDateFunction($DB->ForSql($val), "FULL").")";
    94. 

  94. 					break;
    95. 

  95. 			}
    96. 

  96. 		}
    97. 

  97. 		if (count($arSqlSearch)>0)
    98. 

  98. 			$strSqlSearch = " AND (".implode(") AND (", $arSqlSearch).")";
    99. 

  99. 		if (count($arSqlSelect) > 0)
    100. 

  100. 			$strSqlSelect = ", ".implode(", ", $arSqlSelect);
    101. 

  101. 		if ($UseGroup)
    102. 

  102. 		{
    103. 

  103. 			foreach ($arSqlSelect as $key => $val)
    104. 

  104. 			{
    105. 

  105. 				if (mb_substr($key, 0, 1) != "!")
    106. 

  106. 					$arSqlGroup[$key] = $val;
    107. 

  107. 			}
    108. 

  108. 			if (!empty($arSqlGroup)):
    109. 

  109. 				$strSqlGroup = ", ".implode(", ", $arSqlGroup);
    110. 

  110. 			endif;
    111. 

  111. 		}
    112. 

  112. 		foreach ($arOrder as $by => $order)
    113. 

  113. 		{
    114. 

  114. 			$by = mb_strtoupper($by);
    115. 

  115. 			$order = mb_strtoupper($order);
    116. 

  116. 			if ($order!="ASC") $order = "DESC";
    117. 

  117. 			if (in_array($by, array("ID", "FORUM_ID", "TOPIC_ID", "TITLE", "TAGS", "DESCRIPTION", "ICON",
    118. 

  118. 					"STATE", "APPROVED", "SORT", "VIEWS", "USER_START_ID", "USER_START_NAME", "START_DATE", 
    119. 

  119. 					"POSTS", "LAST_POSTER_ID", "LAST_POSTER_NAME", "LAST_POST_DATE", "LAST_MESSAGE_ID", 
    120. 

  120. 					"POSTS_UNAPPROVED", "ABS_LAST_POSTER_ID", "ABS_LAST_POSTER_NAME", "ABS_LAST_POST_DATE", "ABS_LAST_MESSAGE_ID", 
    121. 

  121. 					"SOCNET_GROUP_ID", "OWNER_ID", "HTML"))):
    122. 

  122. 				$arSqlOrder[] = "FT.".$by." ".$order;
    123. 

  123. 			else:
    124. 

  124. 				$arSqlOrder[] = "FT.SORT ".$order;
    125. 

  125. 				$by = "SORT";
    126. 

  126. 			endif;
    127. 

  127. 		}
    128. 

  128. 		$arSqlOrder = array_unique($arSqlOrder);
    129. 

  129. 		DelDuplicateSort($arSqlOrder); 
    130. 

  130. 		if (count($arSqlOrder) > 0)
    131. 

  131. 			$strSqlOrder = " ORDER BY ".implode(", ", $arSqlOrder);
    132. 

  132. 

  133. 		if ($bCount || (is_set($arAddParams, "bDescPageNumbering") && intval($arAddParams["nTopCount"]) <= 0))
    134. 

  134. 		{
    135. 

  135. 			$strSql = 
    136. 

  136. 				"SELECT COUNT(FT.ID) as CNT 
    137. 

  137. 				FROM b_forum_topic FT
    138. 

  138. 				WHERE 1 = 1 
    139. 

  139. 				".$strSqlSearch;
    140. 

  140. 			$db_res = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
    141. 

  141. 			$iCnt = 0;
    142. 

  142. 			if ($ar_res = $db_res->Fetch()):
    143. 

  143. 				$iCnt = intval($ar_res["CNT"]);
    144. 

  144. 			endif;
    145. 

  145. 			if ($bCount):
    146. 

  146. 				return $iCnt;
    147. 

  147. 			endif;
    148. 

  148. 		}
    149. 

  149. 

  150. 		$arSQL = array("select" => "", "join" => "");
    151. 

  151. 		if (!empty($arAddParams["sNameTemplate"]))
    152. 

  152. 		{
    153. 

  153. 			$arSQL = array_merge_recursive(
    154. 

  154. 				CForumUser::GetFormattedNameFieldsForSelect(array_merge(
    155. 

  155. 					$arAddParams, array(
    156. 

  156. 					"sUserTablePrefix" => "U_START.",
    157. 

  157. 					"sForumUserTablePrefix" => "FU_START.",
    158. 

  158. 					"sFieldName" => "USER_START_NAME_FRMT",
    159. 

  159. 					"sUserIDFieldName" => "FT.USER_START_ID"))),
    160. 

  160. 				CForumUser::GetFormattedNameFieldsForSelect(array_merge(
    161. 

  161. 					$arAddParams, array(
    162. 

  162. 					"sUserTablePrefix" => "U_LAST.",
    163. 

  163. 					"sForumUserTablePrefix" => "FU_LAST.",
    164. 

  164. 					"sFieldName" => "LAST_POSTER_NAME_FRMT",
    165. 

  165. 					"sUserIDFieldName" => "FT.LAST_POSTER_ID"))),
    166. 

  166. 				CForumUser::GetFormattedNameFieldsForSelect(array_merge(
    167. 

  167. 					$arAddParams, array(
    168. 

  168. 					"sUserTablePrefix" => "U_ABS_LAST.",
    169. 

  169. 					"sForumUserTablePrefix" => "FU_ABS_LAST.",
    170. 

  170. 					"sFieldName" => "ABS_LAST_POSTER_NAME_FRMT",
    171. 

  171. 					"sUserIDFieldName" => "FT.ABS_LAST_POSTER_ID"))));
    172. 

  172. 			$arSQL["select"] = ",\n\t".implode(",\n\t", $arSQL["select"]);
    173. 

  173. 			$arSQL["join"] = "\n".implode("\n", $arSQL["join"]);
    174. 

  174. 		}
    175. 

  175. 

  176. 		if ($UseGroup)
    177. 

  177. 		{
    178. 

  178. 			$strSql = 
    179. 

  179. 				" SELECT F_T.*, FT.FORUM_ID, FT.TOPIC_ID, FT.TITLE, FT.TAGS, FT.DESCRIPTION, FT.ICON, \n".
    180. 

  180. 				"	FT.STATE, FT.APPROVED, FT.SORT, FT.VIEWS, FT.USER_START_ID, FT.USER_START_NAME, \n".
    181. 

  181. 				"	".CForumNew::Concat("-", array("FT.ID", "FT.TITLE_SEO"))." as TITLE_SEO, \n".
    182. 

  182. 				"	".$DB->DateToCharFunction("FT.START_DATE", "FULL")." as START_DATE, \n".
    183. 

  183. 				"	FT.POSTS, FT.LAST_POSTER_ID, FT.LAST_POSTER_NAME, \n".
    184. 

  184. 				"	".$DB->DateToCharFunction("FT.LAST_POST_DATE", "FULL")." as LAST_POST_DATE, \n".
    185. 

  185. 				"	FT.LAST_POST_DATE AS LAST_POST_DATE_ORIGINAL, FT.LAST_MESSAGE_ID, \n".
    186. 

  186. 				"	FT.POSTS_UNAPPROVED, FT.ABS_LAST_POSTER_ID, FT.ABS_LAST_POSTER_NAME, \n".
    187. 

  187. 				"	".$DB->DateToCharFunction("FT.ABS_LAST_POST_DATE", "FULL")." as ABS_LAST_POST_DATE, \n".
    188. 

  188. 				"	FT.ABS_LAST_POST_DATE AS ABS_LAST_POST_DATE_ORIGINAL, FT.ABS_LAST_MESSAGE_ID, \n".
    189. 

  189. 				"	FT.SOCNET_GROUP_ID, FT.OWNER_ID, FT.HTML, FT.XML_ID".$arSQL["select"]." \n".
    190. 

  190. 				" FROM ( \n".
    191. 

  191. 				"		SELECT FT.ID".$strSqlSelect." \n".
    192. 

  192. 				"		FROM b_forum_topic FT \n".
    193. 

  193. 				"		WHERE 1 = 1 ".$strSqlSearch." \n".
    194. 

  194. 				"		GROUP BY FT.ID ".$strSqlGroup." \n".
    195. 

  195. 				" ) F_T \n".
    196. 

  196. 				" INNER JOIN b_forum_topic FT ON (F_T.ID = FT.ID) ".$arSQL["join"]." \n".
    197. 

  197. 				$strSqlOrder;
    198. 

  198. 		}
    199. 

  199. 		else
    200. 

  200. 		{
    201. 

  201. 			$strSql = 
    202. 

  202. 				" SELECT FT.ID, FT.FORUM_ID, FT.TOPIC_ID, FT.TITLE, FT.TAGS, FT.DESCRIPTION, FT.ICON, \n".
    203. 

  203. 				"	FT.STATE, FT.APPROVED, FT.SORT, FT.VIEWS, FT.USER_START_ID, FT.USER_START_NAME, \n".
    204. 

  204. 				"	".CForumNew::Concat("-", array("FT.ID", "FT.TITLE_SEO"))." as TITLE_SEO, \n".
    205. 

  205. 				"	".$DB->DateToCharFunction("FT.START_DATE", "FULL")." as START_DATE, \n".
    206. 

  206. 				"	FT.POSTS, FT.LAST_POSTER_ID, FT.LAST_POSTER_NAME, \n".
    207. 

  207. 				"	".$DB->DateToCharFunction("FT.LAST_POST_DATE", "FULL")." as LAST_POST_DATE, \n".
    208. 

  208. 				"	FT.LAST_POST_DATE AS LAST_POST_DATE_ORIGINAL, FT.LAST_MESSAGE_ID, \n".
    209. 

  209. 				"	FT.POSTS_UNAPPROVED, FT.ABS_LAST_POSTER_ID, FT.ABS_LAST_POSTER_NAME, \n".
    210. 

  210. 				"	".$DB->DateToCharFunction("FT.ABS_LAST_POST_DATE", "FULL")." as ABS_LAST_POST_DATE, \n".
    211. 

  211. 				"	FT.ABS_LAST_POST_DATE AS ABS_LAST_POST_DATE_ORIGINAL, FT.ABS_LAST_MESSAGE_ID, \n".
    212. 

  212. 				"	FT.SOCNET_GROUP_ID, FT.OWNER_ID, FT.HTML, FT.XML_ID".$strSqlSelect.$arSQL["select"]." \n".
    213. 

  213. 				" FROM b_forum_topic FT ".$arSQL["join"]. " \n".
    214. 

  214. 				" WHERE 1 = 1 ".$strSqlSearch." \n".
    215. 

  215. 				$strSqlOrder;
    216. 

  216. 		}
    217. 

  217. 

  218. 		$iNum = intval($iNum);
    219. 

  219. 		if ($iNum > 0 || intval($arAddParams["nTopCount"]) > 0)
    220. 

  220. 		{
    221. 

  221. 			$iNum = ($iNum > 0) ? $iNum : intval($arAddParams["nTopCount"]);
    222. 

  222. 			$strSql .= "\nLIMIT 0,".$iNum;
    223. 

  223. 		}
    224. 

  224. 		
    225. 

  225. 		if (!$iNum && is_set($arAddParams, "bDescPageNumbering") && intval($arAddParams["nTopCount"]) <= 0)
    226. 

  226. 		{
    227. 

  227. 			$db_res =  new CDBResult();
    228. 

  228. 			$db_res->NavQuery($strSql, $iCnt, $arAddParams);
    229. 

  229. 		}
    230. 

  230. 		else 
    231. 

  231. 		{
    232. 

  232. 			$db_res = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
    233. 

  233. 		}
    234. 

  234. 		return new _CTopicDBResult($db_res, $arAddParams);
    235. 

  235. 	}
    236. 

  236. 

  237. 	public static function GetListEx($arOrder = Array("SORT"=>"ASC"), $arFilter = Array(), $bCount = false, $iNum = 0, $arAddParams = array())
    238. 

  238. 	{
    239. 

  239. 		global $DB, $USER;
    240. 

  240. 		$arOrder = (is_array($arOrder) ? $arOrder : array());
    241. 

  241. 		$arFilter = (is_array($arFilter) ? $arFilter : array());
    242. 

  242. 		$arSqlSearch = array();
    243. 

  243. 		$arSqlFrom = array();
    244. 

  244. 		$arSqlSelect = array();
    245. 

  245. 		$arSqlGroup = array();
    246. 

  246. 		$arSqlOrder = array();
    247. 

  247. 		$strSqlSearch = "";
    248. 

  248. 		$strSqlFrom = "";
    249. 

  249. 		$strSqlSelect = "";
    250. 

  250. 		$strSqlGroup = "";
    251. 

  251. 		$strSqlOrder = "";
    252. 

  252. 		$UseGroup = false;
    253. 

  253. 		$arAddParams = (is_array($arAddParams) ? $arAddParams : array($arAddParams));
    254. 

  254. 

  255. 		foreach ($arFilter as $key => $val)
    256. 

  256. 		{
    257. 

  257. 			$key_res = CForumNew::GetFilterOperation($key);
    258. 

  258. 			$key = mb_strtoupper($key_res["FIELD"]);
    259. 

  259. 			$strNegative = $key_res["NEGATIVE"];
    260. 

  260. 			$strOperation = $key_res["OPERATION"];
    261. 

  261. 			switch ($key)
    262. 

  262. 			{
    263. 

  263. 				case "STATE":
    264. 

  264. 				case "XML_ID":
    265. 

  265. 				case "APPROVED":
    266. 

  266. 					$val = CForumNew::prepareField($strOperation, "string", $val);
    267. 

  267. 					if ($val == '')
    268. 

  268. 						$arSqlSearch[] = ($strNegative=="Y"?"NOT":"")."(FT.".$key." IS NULL OR ".($DB->type == "MSSQL" ? "LEN" : "LENGTH")."(FT.".$key.")<=0)";
    269. 

  269. 					else if ($strOperation == "IN")
    270. 

  270. 						$arSqlSearch[] = ($strNegative=="Y"?" NOT ":"")."(FT.".$key." IN (".$val.") )";
    271. 

  271. 					else
    272. 

  272. 						$arSqlSearch[] = ($strNegative=="Y"?" FT.".$key." IS NULL OR NOT ":"")."(FT.".$key." ".$strOperation." '".$val."' )";
    273. 

  273. 					break;
    274. 

  274. 				case "ID":
    275. 

  275. 				case "FORUM_ID":
    276. 

  276. 				case "SOCNET_GROUP_ID":
    277. 

  277. 				case "OWNER_ID":
    278. 

  278. 				case "USER_START_ID":
    279. 

  279. 				case "SORT":
    280. 

  280. 				case "POSTS":
    281. 

  281. 				case "TOPICS":
    282. 

  282. 					if (($strOperation!="IN")&&(intval($val)>0))
    283. 

  283. 						$arSqlSearch[] = ($strNegative=="Y"?" FT.".$key." IS NULL OR NOT ":"")."(FT.".$key." ".$strOperation." ".intval($val)." )";
    284. 

  284. 					elseif (($strOperation =="IN") && ((is_array($val) && (array_sum($val) > 0)) || (is_string($val) && $val <> '') ))
    285. 

  285. 					{
    286. 

  286. 						if (!is_array($val))
    287. 

  287. 							$val = explode(',', $val);
    288. 

  288. 						$val_int = array();
    289. 

  289. 						foreach ($val as $v)
    290. 

  290. 							$val_int[] = intval($v);
    291. 

  291. 						$val = implode(", ", $val_int);
    292. 

  292. 						$arSqlSearch[] = ($strNegative=="Y"?" NOT ":"")."(FT.".$key." IN (".$DB->ForSql($val).") )";
    293. 

  293. 					}
    294. 

  294. 					else
    295. 

  295. 						$arSqlSearch[] = ($strNegative=="Y"?"NOT":"")."(FT.".$key." IS NULL OR FT.".$key."<=0)";
    296. 

  296. 					break;
    297. 

  297. 				case "TITLE_ALL":
    298. 

  298. 					$arSqlSearch[] = GetFilterQuery("FT.TITLE, FT.DESCRIPTION", $val);
    299. 

  299. 					break;
    300. 

  300. 				case "TITLE":
    301. 

  301. 				case "DESCRIPTION":
    302. 

  302. 					$arSqlSearch[] = GetFilterQuery("FT.".$key, $val);
    303. 

  303. 					$arSqlSearch[] = GetFilterQuery("FT.".$key, $val);
    304. 

  304. 					break;
    305. 

  305. 				case "START_DATE":
    306. 

  306. 				case "LAST_POST_DATE":
    307. 

  307. 				case "ABS_LAST_POST_DATE":
    308. 

  308. 					if($val == '')
    309. 

  309. 						$arSqlSearch[] = ($strNegative=="Y"?"NOT":"")."(FT.".$key." IS NULL)";
    310. 

  310. 					else
    311. 

  311. 						$arSqlSearch[] = ($strNegative=="Y"?" FT.".$key." IS NULL OR NOT ":"")."(FT.".$key." ".$strOperation." ".$DB->CharToDateFunction($DB->ForSql($val), "FULL").")";
    312. 

  312. 					break;
    313. 

  313. 				case "USER_ID":
    314. 

  314. 					$arSqlSelect["LAST_VISIT"] = $DB->DateToCharFunction("FUT.LAST_VISIT", "FULL");
    315. 

  315. 					$arSqlFrom["FUT"] = "LEFT JOIN b_forum_user_topic FUT ON (".(
    316. 

  316. 							$val == '' ?
    317. 

  317. 								($strNegative=="Y"?"NOT":"")."(FUT.USER_ID IS NULL)"
    318. 

  318. 								:
    319. 

  319. 								"FUT.USER_ID=".intval($val)
    320. 

  320. 						)." AND FUT.FORUM_ID = FT.FORUM_ID AND FUT.TOPIC_ID = FT.ID)";
    321. 

  321. 					break;
    322. 

  322. 				case "RENEW_TOPIC":
    323. 

  323. 						if (($val <> '') && array_key_exists("FUT", $arSqlFrom))
    324. 

  324. 						{
    325. 

  325. 							$arSqlSearch[] =
    326. 

  326. 								"((FT.LAST_POST_DATE ".$strOperation." ".$DB->CharToDateFunction($DB->ForSql($val), "FULL").") AND
    327. 

  327. 									(
    328. 

  328. 										(LAST_VISIT IS NULL) OR
    329. 

  329. 										(LAST_VISIT < ".$DB->CharToDateFunction($DB->ForSql($val), "FULL").")
    330. 

  330. 									)
    331. 

  331. 								)
    332. 

  332. 								OR
    333. 

  333. 								((FT.LAST_POST_DATE > FUT.LAST_VISIT) AND 
    334. 

  334. 									(
    335. 

  335. 										(LAST_VISIT IS NOT NULL) AND
    336. 

  336. 										(LAST_VISIT > ".$DB->CharToDateFunction($DB->ForSql($val), "FULL").")
    337. 

  337. 									)
    338. 

  338. 								)";
    339. 

  339. 						}
    340. 

  340. 				break;
    341. 

  341. 				case "PERMISSION":
    342. 

  342. 					if (!is_array($val))
    343. 

  343. 						$val = explode(',', $val);
    344. 

  344. 					if (empty($val)):
    345. 

  345. 						$val = $GLOBALS["USER"]->GetGroups();
    346. 

  346. 					elseif (is_array($val)):
    347. 

  347. 						$val_int = array();
    348. 

  348. 						foreach ($val as $v)
    349. 

  349. 							$val_int[] = intval($v);
    350. 

  350. 						$val = implode(", ", $val_int);
    351. 

  351. 					endif;
    352. 

  352. 					$arSqlFrom["FPP"] =
    353. 

  353. 						" INNER JOIN ( \n".
    354. 

  354. 						"	SELECT FPP.FORUM_ID, MAX(FPP.PERMISSION) AS PERMISSION \n".
    355. 

  355. 						"	FROM b_forum_perms FPP \n".
    356. 

  356. 						"	WHERE FPP.GROUP_ID IN (".$DB->ForSql($val).") AND FPP.PERMISSION > 'A' \n".
    357. 

  357. 						"	GROUP BY FPP.FORUM_ID) FPP ON (FPP.FORUM_ID = FT.FORUM_ID) ";
    358. 

  358. 					$arSqlSelect["PERMISSION"] = "FPP.PERMISSION";
    359. 

  359. 				break;
    360. 

  360. 				case "RENEW":
    361. 

  361. 					$val = (is_array($val) ? $val : array("USER_ID" => $val));
    362. 

  362. 					$val["USER_ID"] = intval($val["USER_ID"]);
    363. 

  363. 					if ($val["USER_ID"] <= 0):
    364. 

  364. 						break;
    365. 

  365. 					endif;
    366. 

  366. 					$perms = "NOT_CHECK";
    367. 

  367. 					$arUserGroups = $GLOBALS["USER"]->GetGroups();
    368. 

  368. 					if (is_set($arFilter, "PERMISSION")):
    369. 

  369. 						$perms = "NORMAL";
    370. 

  370. 					elseif (is_set($arFilter, "APPROVED") && $arFilter["APPROVED"] == "Y"):
    371. 

  371. 						$perms = "ONLY_APPROVED";
    372. 

  372. 					endif;
    373. 

  373. 

  374. 					$arSqlFrom["FUT"] = "LEFT JOIN b_forum_user_topic FUT ON (FUT.USER_ID=".intval($val["USER_ID"])." AND FUT.FORUM_ID = FT.FORUM_ID AND FUT.TOPIC_ID = FT.ID)";
    375. 

  375. 					$arSqlFrom["FUF"] = "LEFT JOIN b_forum_user_forum FUF ON (FUF.USER_ID=".$val["USER_ID"]." AND FUF.FORUM_ID = FT.FORUM_ID)";
    376. 

  376. 					$arSqlFrom["FUF_ALL"] = "LEFT JOIN b_forum_user_forum FUF_ALL ON (FUF_ALL.USER_ID=".$val["USER_ID"]." AND FUF_ALL.FORUM_ID = 0)";
    377. 

  377. 

  378. 					$arSqlSearch[] = "FT.STATE != 'L'";
    379. 

  379. 					$arSqlSearch[] = "
    380. 

  380. 					(
    381. 

  381. 						FUT.LAST_VISIT IS NULL 
    382. 

  382. 						AND 
    383. 

  383. 						(
    384. 

  384. 							(FUF_ALL.LAST_VISIT IS NULL AND FUF.LAST_VISIT IS NULL)
    385. 

  385. 							OR 
    386. 

  386. 							(
    387. 

  387. 								FUF.LAST_VISIT IS NOT NULL
    388. 

  388. 								AND 
    389. 

  389. 								(
    390. 

  390. 					".
    391. 

  391. 						( $perms == "NORMAL" ? "
    392. 

  392. 									(FPP.PERMISSION >= 'Q' AND FUF.LAST_VISIT < FT.ABS_LAST_POST_DATE)
    393. 

  393. 									OR 
    394. 

  394. 									(FT.APPROVED = 'Y' AND FUF.LAST_VISIT < FT.LAST_POST_DATE)
    395. 

  395. 									" : 
    396. 

  396. 							( $perms == "NOT_CHECK" ? "
    397. 

  397. 									(FUF.LAST_VISIT < FT.ABS_LAST_POST_DATE OR FUF.LAST_VISIT < FT.LAST_POST_DATE)
    398. 

  398. 									" : 
    399. 

  399. 									"
    400. 

  400. 									(FT.APPROVED = 'Y' AND FUF.LAST_VISIT < FT.LAST_POST_DATE)
    401. 

  401. 									"
    402. 

  402. 							)
    403. 

  403. 						)
    404. 

  404. 					."
    405. 

  405. 								)
    406. 

  406. 							)
    407. 

  407. 							OR 
    408. 

  408. 							(
    409. 

  409. 								FUF.LAST_VISIT IS NULL AND FUF_ALL.LAST_VISIT IS NOT NULL 
    410. 

  410. 								AND 
    411. 

  411. 								(
    412. 

  412. 					".
    413. 

  413. 						( $perms == "NORMAL" ? "
    414. 

  414. 									(FPP.PERMISSION >= 'Q' AND FUF_ALL.LAST_VISIT < FT.ABS_LAST_POST_DATE)
    415. 

  415. 									OR 
    416. 

  416. 									(FT.APPROVED = 'Y' AND FUF_ALL.LAST_VISIT < FT.LAST_POST_DATE)
    417. 

  417. 									" : 
    418. 

  418. 							( $perms == "NOT_CHECK" ? "
    419. 

  419. 									(FUF_ALL.LAST_VISIT < FT.ABS_LAST_POST_DATE OR FUF_ALL.LAST_VISIT < FT.LAST_POST_DATE)
    420. 

  420. 									" : 
    421. 

  421. 									"
    422. 

  422. 									(FT.APPROVED = 'Y' AND FUF_ALL.LAST_VISIT < FT.LAST_POST_DATE)
    423. 

  423. 									"
    424. 

  424. 							)
    425. 

  425. 						)
    426. 

  426. 					."
    427. 

  427. 								)
    428. 

  428. 							)
    429. 

  429. 						)
    430. 

  430. 					)
    431. 

  431. 					OR
    432. 

  432. 					(
    433. 

  433. 						FUT.LAST_VISIT IS NOT NULL 
    434. 

  434. 						AND 
    435. 

  435. 						(
    436. 

  436. 					".
    437. 

  437. 						( $perms == "NORMAL" ? "
    438. 

  438. 									(FPP.PERMISSION >= 'Q' AND FUT.LAST_VISIT < FT.ABS_LAST_POST_DATE)
    439. 

  439. 									OR 
    440. 

  440. 									(FT.APPROVED = 'Y' AND FUT.LAST_VISIT < FT.LAST_POST_DATE)
    441. 

  441. 									" : 
    442. 

  442. 							( $perms == "NOT_CHECK" ? "
    443. 

  443. 									(FUT.LAST_VISIT < FT.ABS_LAST_POST_DATE OR FUT.LAST_VISIT < FT.LAST_POST_DATE)
    444. 

  444. 									" : 
    445. 

  445. 									"
    446. 

  446. 									(FT.APPROVED = 'Y' AND FUT.LAST_VISIT < FT.LAST_POST_DATE)
    447. 

  447. 									"
    448. 

  448. 							)
    449. 

  449. 						)
    450. 

  450. 					."	)
    451. 

  451. 					)";
    452. 

  452. 				break;
    453. 

  453. 				case "PERMISSION_STRONG":
    454. 

  454. 					$arSqlFrom["FP"] = "LEFT JOIN b_forum_perms FP ON (FP.FORUM_ID=FT.FORUM_ID)";
    455. 

  455. 					$arSqlSearch[] = "FP.GROUP_ID IN (".$DB->ForSql($USER->GetGroups()).") AND (FP.PERMISSION IN ('Q','U','Y'))"; 
    456. 

  456. 					$UseGroup = true;
    457. 

  457. 					break;
    458. 

  458. 			}
    459. 

  459. 		}
    460. 

  460. 		if (count($arSqlSearch)>0)
    461. 

  461. 			$strSqlSearch = " AND (".implode(") AND (", $arSqlSearch).")";
    462. 

  462. 		if (count($arSqlSelect) > 0)
    463. 

  463. 		{
    464. 

  464. 			$res = array();
    465. 

  465. 			foreach ($arSqlSelect as $key => $val)
    466. 

  466. 			{
    467. 

  467. 				if (mb_substr($key, 0, 1) == "!")
    468. 

  468. 					$key = mb_substr($key, 1);
    469. 

  469. 				if ($key != $val)
    470. 

  470. 					$res[] = $val." AS ".$key;
    471. 

  471. 				else 
    472. 

  472. 					$res[] = $val;
    473. 

  473. 			}
    474. 

  474. 			$strSqlSelect = ", ".implode(", ", $res);
    475. 

  475. 		}
    476. 

  476. 		if (count($arSqlFrom) > 0)
    477. 

  477. 			$strSqlFrom = implode("\n", $arSqlFrom);
    478. 

  478. 		if ($UseGroup)
    479. 

  479. 		{
    480. 

  480. 			foreach ($arSqlSelect as $key => $val)
    481. 

  481. 			{
    482. 

  482. 				if (mb_substr($key, 0, 1) != "!")
    483. 

  483. 					$arSqlGroup[$key] = $val;
    484. 

  484. 			}
    485. 

  485. 			if (!empty($arSqlGroup)):
    486. 

  486. 				$strSqlGroup = ", ".implode(", ", $arSqlGroup);
    487. 

  487. 			endif;
    488. 

  488. 		}
    489. 

  489. 

  490. 		foreach ($arOrder as $by => $order)
    491. 

  491. 		{
    492. 

  492. 			$by = mb_strtoupper($by);
    493. 

  493. 			$order = mb_strtoupper($order);
    494. 

  494. 			if ($order!="ASC") $order = "DESC";
    495. 

  495. 			if (in_array($by, array("ID", "FORUM_ID", "TOPIC_ID", "TITLE", "TAGS", "DESCRIPTION", "ICON",
    496. 

  496. 					"STATE", "APPROVED", "SORT", "VIEWS", "USER_START_ID", "USER_START_NAME", "START_DATE", 
    497. 

  497. 					"POSTS", "LAST_POSTER_ID", "LAST_POSTER_NAME", "LAST_POST_DATE", "LAST_MESSAGE_ID", 
    498. 

  498. 					"POSTS_UNAPPROVED", "ABS_LAST_POSTER_ID", "ABS_LAST_POSTER_NAME", "ABS_LAST_POST_DATE", "ABS_LAST_MESSAGE_ID", 
    499. 

  499. 					"SOCNET_GROUP_ID", "OWNER_ID", "HTML", "XML_ID"))):
    500. 

  500. 				$arSqlOrder[] = "FT.".$by." ".$order;
    501. 

  501. 			elseif ($by == "FORUM_NAME"):
    502. 

  502. 				$arSqlOrder[] = "F.NAME ".$order;
    503. 

  503. 			else:
    504. 

  504. 				$arSqlOrder[] = "FT.SORT ".$order;
    505. 

  505. 				$by = "SORT";
    506. 

  506. 			endif;
    507. 

  507. 		}
    508. 

  508. 		$arSqlOrder = array_unique($arSqlOrder);
    509. 

  509. 		DelDuplicateSort($arSqlOrder);
    510. 

  510. 		if (count($arSqlOrder) > 0):
    511. 

  511. 			$strSqlOrder = " ORDER BY ".implode(", ", $arSqlOrder);
    512. 

  512. 		endif;
    513. 

  513. 

  514. 		if ($bCount || (is_set($arAddParams, "bDescPageNumbering") && intval($arAddParams["nTopCount"])<=0))
    515. 

  515. 		{
    516. 

  516. 			$strSql = "SELECT COUNT(FT.ID) as CNT FROM b_forum_topic FT ";
    517. 

  517. 

  518. 			$arCountSqlFrom = $arSqlFrom;
    519. 

  519. 			if (isset($arSqlFrom['FUT']) && (mb_strpos($strSqlSearch, "FUT.") === false))
    520. 

  520. 				unset($arCountSqlFrom['FUT']);
    521. 

  521. 			$strSqlCountFrom = implode("\n", $arCountSqlFrom);
    522. 

  522. 

  523. 			$strSql .= $strSqlCountFrom . " WHERE 1 = 1 ".$strSqlSearch;
    524. 

  524. 

  525. 			$db_res = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
    526. 

  526. 			$iCnt = 0;
    527. 

  527. 			if ($ar_res = $db_res->Fetch())
    528. 

  528. 			{
    529. 

  529. 				$iCnt = intval($ar_res["CNT"]);
    530. 

  530. 			}
    531. 

  531. 			if ($bCount)
    532. 

  532. 				return $iCnt;
    533. 

  533. 		}
    534. 

  534. 		$arSQL = array("select" => "", "join" => "");
    535. 

  535. 		if (!empty($arAddParams["sNameTemplate"]))
    536. 

  536. 		{
    537. 

  537. 			$arSQL = array_merge_recursive(
    538. 

  538. 				CForumUser::GetFormattedNameFieldsForSelect(array_merge(
    539. 

  539. 					$arAddParams, array(
    540. 

  540. 					"sUserTablePrefix" => "U_START.",
    541. 

  541. 					"sForumUserTablePrefix" => "FU_START.",
    542. 

  542. 					"sFieldName" => "USER_START_NAME_FRMT",
    543. 

  543. 					"sUserIDFieldName" => "FT.USER_START_ID"))),
    544. 

  544. 				CForumUser::GetFormattedNameFieldsForSelect(array_merge(
    545. 

  545. 					$arAddParams, array(
    546. 

  546. 					"sUserTablePrefix" => "U_LAST.",
    547. 

  547. 					"sForumUserTablePrefix" => "FU_LAST.",
    548. 

  548. 					"sFieldName" => "LAST_POSTER_NAME_FRMT",
    549. 

  549. 					"sUserIDFieldName" => "FT.LAST_POSTER_ID"))),
    550. 

  550. 				CForumUser::GetFormattedNameFieldsForSelect(array_merge(
    551. 

  551. 					$arAddParams, array(
    552. 

  552. 					"sUserTablePrefix" => "U_ABS_LAST.",
    553. 

  553. 					"sForumUserTablePrefix" => "FU_ABS_LAST.",
    554. 

  554. 					"sFieldName" => "ABS_LAST_POSTER_NAME_FRMT",
    555. 

  555. 					"sUserIDFieldName" => "FT.ABS_LAST_POSTER_ID"))));
    556. 

  556. 			$arSQL["select"] = ",\n\t".implode(",\n\t", $arSQL["select"]);
    557. 

  557. 			$arSQL["join"] = "\n".implode("\n", $arSQL["join"]);
    558. 

  558. 		}
    559. 

  559. 

  560. 		if ($UseGroup)
    561. 

  561. 		{
    562. 

  562. 			$strSql =
    563. 

  563. 				" SELECT F_T.*, FT.FORUM_ID, FT.TOPIC_ID, FT.TITLE, FT.TAGS, FT.DESCRIPTION, FT.ICON, \n".
    564. 

  564. 				"	FT.STATE, FT.APPROVED, FT.SORT, FT.VIEWS, FT.USER_START_ID, FT.USER_START_NAME, \n".
    565. 

  565. 				"	".CForumNew::Concat("-", array("FT.ID", "FT.TITLE_SEO"))." as TITLE_SEO, \n".
    566. 

  566. 				"	".$DB->DateToCharFunction("FT.START_DATE", "FULL")." as START_DATE, \n".
    567. 

  567. 				"	FT.POSTS, FT.LAST_POSTER_ID, FT.LAST_POSTER_NAME, \n".
    568. 

  568. 				"	".$DB->DateToCharFunction("FT.LAST_POST_DATE", "FULL")." as LAST_POST_DATE, \n".
    569. 

  569. 				"	FT.LAST_POST_DATE AS LAST_POST_DATE_ORIGINAL, FT.LAST_MESSAGE_ID, \n".
    570. 

  570. 				"	FT.POSTS_UNAPPROVED, FT.ABS_LAST_POSTER_ID, FT.ABS_LAST_POSTER_NAME, \n".
    571. 

  571. 				"	".$DB->DateToCharFunction("FT.ABS_LAST_POST_DATE", "FULL")." as ABS_LAST_POST_DATE, \n".
    572. 

  572. 				"	FT.ABS_LAST_POST_DATE AS ABS_LAST_POST_DATE_ORIGINAL, FT.ABS_LAST_MESSAGE_ID, \n".
    573. 

  573. 				"	FT.SOCNET_GROUP_ID, FT.OWNER_ID, FT.HTML, FT.XML_ID, \n".
    574. 

  574. 				"	F.NAME as FORUM_NAME, \n".
    575. 

  575. 				"	'' as IMAGE, '' as IMAGE_DESCR ".$arSQL["select"]." \n".
    576. 

  576. 				" FROM \n".
    577. 

  577. 				"	( \n".
    578. 

  578. 				"		SELECT FT.ID".$strSqlSelect." \n".
    579. 

  579. 				"		FROM b_forum_topic FT \n".
    580. 

  580. 				"			LEFT JOIN b_forum F ON (FT.FORUM_ID = F.ID) \n".
    581. 

  581. 				"			".$strSqlFrom." \n".
    582. 

  582. 				"		WHERE 1 = 1 ".$strSqlSearch." \n".
    583. 

  583. 				"		GROUP BY FT.ID".$strSqlGroup." \n".
    584. 

  584. 				"	) F_T \n".
    585. 

  585. 				" INNER JOIN b_forum_topic FT ON (F_T.ID = FT.ID) \n".
    586. 

  586. 				" LEFT JOIN b_forum F ON (FT.FORUM_ID = F.ID) ".$arSQL["join"]." \n".
    587. 

  587. 				$strSqlOrder;
    588. 

  588. 		}
    589. 

  589. 		else
    590. 

  590. 		{
    591. 

  591. 			$strSql = 
    592. 

  592. 				" SELECT FT.ID, FT.FORUM_ID, FT.TOPIC_ID, FT.TITLE, FT.TAGS, FT.DESCRIPTION, FT.ICON, \n".
    593. 

  593. 				"	FT.STATE, FT.APPROVED, FT.SORT, FT.VIEWS, FT.USER_START_ID, FT.USER_START_NAME, \n".
    594. 

  594. 				"	".CForumNew::Concat("-", array("FT.ID", "FT.TITLE_SEO"))." as TITLE_SEO, \n".
    595. 

  595. 				"	".$DB->DateToCharFunction("FT.START_DATE", "FULL")." as START_DATE, \n".
    596. 

  596. 				"	FT.POSTS, FT.LAST_POSTER_ID, FT.LAST_POSTER_NAME, \n".
    597. 

  597. 				"	".$DB->DateToCharFunction("FT.LAST_POST_DATE", "FULL")." as LAST_POST_DATE, \n".
    598. 

  598. 				"	FT.LAST_POST_DATE AS LAST_POST_DATE_ORIGINAL, FT.LAST_MESSAGE_ID, \n".
    599. 

  599. 				"	FT.POSTS_UNAPPROVED, FT.ABS_LAST_POSTER_ID, FT.ABS_LAST_POSTER_NAME, \n".
    600. 

  600. 				"	".$DB->DateToCharFunction("FT.ABS_LAST_POST_DATE", "FULL")." as ABS_LAST_POST_DATE, \n".
    601. 

  601. 				"	FT.ABS_LAST_POST_DATE AS ABS_LAST_POST_DATE_ORIGINAL, FT.ABS_LAST_MESSAGE_ID, \n".
    602. 

  602. 				"	FT.SOCNET_GROUP_ID, FT.OWNER_ID, FT.HTML, FT.XML_ID, \n".
    603. 

  603. 				"	F.NAME as FORUM_NAME, \n".
    604. 

  604. 				"	'' as IMAGE, '' as IMAGE_DESCR".$strSqlSelect.$arSQL["select"]." \n".
    605. 

  605. 				" FROM b_forum_topic FT \n".
    606. 

  606. 				"	LEFT JOIN b_forum F ON (FT.FORUM_ID = F.ID) \n".
    607. 

  607. 				"	".$strSqlFrom.$arSQL["join"]." \n".
    608. 

  608. 				" WHERE 1 = 1 ".$strSqlSearch." \n".
    609. 

  609. 				$strSqlOrder;
    610. 

  610. 		}
    611. 

  611. 

  612. 		$iNum = intval($iNum);
    613. 

  613. 		if ($iNum > 0 || intval($arAddParams["nTopCount"]) > 0)
    614. 

  614. 		{
    615. 

  615. 			$iNum = ($iNum > 0) ? $iNum : intval($arAddParams["nTopCount"]);
    616. 

  616. 			$strSql .= "\nLIMIT 0,".$iNum;
    617. 

  617. 		}
    618. 

  618. 		if (!$iNum && is_set($arAddParams, "bDescPageNumbering") && intval($arAddParams["nTopCount"]) <= 0)
    619. 

  619. 		{
    620. 

  620. 			$db_res =  new CDBResult();
    621. 

  621. 			$db_res->NavQuery($strSql, $iCnt, $arAddParams);
    622. 

  622. 		}
    623. 

  623. 		else 
    624. 

  624. 		{
    625. 

  625. 			$db_res = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
    626. 

  626. 		}
    627. 

  627. 		return new _CTopicDBResult($db_res, $arAddParams);
    628. 

  628. 	}
    629. 

  629. }
    630. 

  630.