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)