1. Список говнокодов пользователя vidok

    Всего: 1

  2. PHP / Говнокод #4511

    +164

    1. 01
    2. 02
    3. 03
    4. 04
    5. 05
    6. 06
    7. 07
    8. 08
    9. 09
    10. 10
    11. 11
    12. 12
    13. 13
    14. 14
    15. 15
    16. 16
    17. 17
    18. 18
    19. 19
    20. 20
    21. 21
    22. 22
    23. 23
    24. 24
    25. 25
    26. 26
    27. 27
    28. 28
    29. 29
    30. 30
    31. 31
    32. 32
    33. 33
    34. 34
    35. 35
    36. 36
    37. 37
    38. 38
    39. 39
    40. 40
    41. 41
    42. 42
    43. 43
    44. 44
    45. 45
    46. 46
    47. 47
    48. 48
    49. 49
    50. 50
    51. 51
    52. 52
    53. 53
    54. 54
    55. 55
    56. 56
    57. 57
    58. 58
    59. 59
    60. 60
    61. 61
    62. 62
    63. 63
    64. 64
    function get_afisha()
{
	global $database;
	$i=2;			
	while(count($row)<4)
	{
		$query='
		(
			SELECT DISTINCT ae.id, ae.title
				FROM afisha.#__afisha_events ae
				WHERE  	ae.published = 1 AND
						ae.deleted = 0 AND
						ae.type_event = 1 AND
						ae.id IN (SELECT aed.id_event FROM afisha.#__afisha_event_dates aed WHERE aed.date >= CURDATE()) AND
						ae.city=1
				ORDER BY RAND()	
				LIMIT 1
		)
		union
		(		
			SELECT c.id,c.title		
				FROM night.#__content c 
				LEFT JOIN night.#__content_afisha_date ca 
					ON c.id = ca.id_content		
				WHERE 	c.state=1 AND 
						c.access=0 AND 
						ca.date >= CURDATE() AND 
						c.catid=5 AND
						ae.city=1
				GROUP BY c.id, ca.id_content		
				ORDER BY RAND()		
				LIMIT 1
		)
		union
		(		
			SELECT DISTINCT ae.id, ae.title
				FROM afisha.#__afisha_events ae
				WHERE  	ae.published = 1 AND
						ae.deleted = 0 AND
						ae.type_event = 4 AND
						ae.id IN (SELECT aed.id_event FROM afisha.#__afisha_event_dates aed WHERE aed.date >= CURDATE()) AND
						ae.city=1
				ORDER BY RAND()	
				LIMIT 1
		)
		union
		(
			SELECT DISTINCT ae.id, ae.title
				FROM afisha.#__afisha_events ae
				WHERE  	ae.published = 1 AND
						ae.deleted = 0 AND
						ae.type_event = 2 AND
						ae.id IN (SELECT aed.id_event FROM afisha.#__afisha_event_dates aed WHERE aed.date >= CURDATE()) AND
						ae.city=1
				ORDER BY RAND()	
				LIMIT 1
		)';		
		$database->setQuery($query);
		$row=$database->loadObjectlist();
		$i++;
	}
	return $row;
}
$row=get_afisha();

    Очень нужная переменная i.

    vidok, 02 Ноября 2010

    Комментарии (28)