mysql_real_escape_string – Страница 5

mysql_real_escape_string / Говнокод #25503

0

1

SELECT MIN(len) from huis

bormandyan, 03.04.2019 (Updated 03.04.2019)

Комментарии (5, +5)

mysql_real_escape_string / Говнокод #25502

0

1

SELECT MAX(len) from huis

bormandyan, 03.04.2019 (Updated 03.04.2019)

Комментарии (3, +3)

mysql_real_escape_string / Говнокод #25360

0

1
2
3
4
5
6
7
8

CREATE TABLE `test` (
    `id` INT(11) unsigned NOT NULL AUTO_INCREMENT,
     `parent` INT(10) unsigned NOT NULL DEFAULT '0',
      `name` VARCHAR(50),
     PRIMARY KEY (`id`)
    ) ENGINE=InnoDB;
INSERT INTO test (id, parent, name) values (1, 0, '10'),(2, 1, '21'),(4, 3, '43'),(5, 0, '50'),(6, 5, '65'),(7, 6, '76'),(8, 7, '87'),(9, 8, '98');
SELECT t1.name AS lev1, t2.name as lev2, t3.name as lev3, t4.name as lev4, t5.name as lev5, t6.name as lev6, t7.name as lev7 FROM `test` AS t1 LEFT JOIN test AS t2 ON t2.`parent` = t1.`id`  LEFT JOIN test AS t3 ON t3.`parent` = t2.`id`  LEFT JOIN test AS t4 ON t4.`parent` = t3.`id` LEFT JOIN test AS t5 ON t5.`parent` = t4.`id` LEFT JOIN test AS t6 ON t6.`parent` = t5.`id` LEFT JOIN test AS t7 ON t7.`parent` = t6.`id`;

взять последнего парента с седьмого колена!
я просто похлопаю :)

websbkinfo, 07.02.2019 (Updated 07.02.2019)

Комментарии (21, +21)

mysql_real_escape_string / Говнокод #25253

0

1

SQL — гниль

rHujlb, 01.01.2019 (Updated 01.01.2019)

Комментарии (1, +1)

mysql_real_escape_string / Говнокод #24861

0

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

product_id '14' 
 product_id '17' 
 product_id '18' 
 product_id '19' 
 product_id '20' 
 product_id '21' 
 product_id '22' 
 product_id '25' 
 product_id '28' 
 product_id '29' 
 product_id '30' 
 product_id '31' 
 product_id '32' 
 product_id '33' 
 product_id '34' 
 product_id '35' 
 product_id '36' 
 product_id '37' 
 product_id '38' 
 product_id '39' 
 product_id '40' 
 product_id '41' 
 product_id '42' 
 product_id '152' 
 product_id '166' 
 product_id '181' 
 product_id '183' 
 product_id '184' 
 product_id '187' 
 product_id '188' 
 product_id '189' 
 product_id '190' 
 product_id '191' 
 product_id '192' 
 product_id '193' 
 product_id '194' 
 product_id '195' 
 product_id '196' 
 product_id '197' 
 product_id '198' 
 product_id '200' 
 product_id '202' 
 product_id '203' 
 product_id '803' 
 product_id '805' 
 product_id '806' 
 product_id '807' 
 product_id '808' 
 product_id '809' 
 product_id '810'

snegoviktlt, 04.10.2018 (Updated 04.10.2018)

Комментарии (22, +22)

mysql_real_escape_string / Говнокод #24817

0

1
2
3
4
5

https://ru.wikipedia.org/wiki/Хранимая_процедура#Возможности_программирования
Начиная с версии Oracle 10g поддерживается так называемая естественная компиляция
(native compilation) хранимого процедурного кода в Си и затем в машинный код целевой
машины, после чего при вызове хранимой процедуры происходит прямое выполнение её
скомпилированного объектного кода.

Можно сделать вирусню, живущую в этих самых хранимых процедурах в машинном коде и инфицирующую другие БД с хранимыми процедурами

j123123, 26.09.2018 (Updated 26.09.2018)

Комментарии (42, +42)

mysql_real_escape_string / Говнокод #24749

0

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97

SELECT *
FROM
  (SELECT CASE
   WHEN (CASE
		WHEN datediff(DAY,date,
						(SELECT top (1) date
						FROM Battles AS P2
						WHERE P2.date > P1.date
						ORDER BY P2.date))/365 = 0 THEN 'Y y.,'
		ELSE cast((datediff(DAY,date,
								(SELECT top (1) date
								FROM Battles AS P2
								WHERE P2.date > P1.date
								ORDER BY P2.date))/365) AS varchar(20)) + ','
	END + CASE
				WHEN (datediff(DAY,date,
								(SELECT top (1) date
								FROM Battles AS P2
								WHERE P2.date > P1.date
								ORDER BY P2.date))/30 - (datediff(DAY,date,
																	(SELECT top (1) date
																	FROM Battles AS P2
																	WHERE P2.date > P1.date
																	ORDER BY P2.date))/365) * 12) = 0 THEN 'M m.'
				ELSE cast((datediff(DAY,date,
									(SELECT top (1) date
									FROM Battles AS P2
									WHERE P2.date > P1.date
									ORDER BY P2.date))/30 - (datediff(DAY,date,
																		(SELECT top (1) date
																			FROM Battles AS P2
																			WHERE P2.date > P1.date
																			ORDER BY P2.date))/365) * 12) AS varchar(20))
			END) = 'Y y.,M m.' THEN ''
      ELSE (CASE
        WHEN datediff(DAY,date,
                        (SELECT top (1) date
                         FROM Battles AS P2
                         WHERE P2.date > P1.date
                         ORDER BY P2.date))/365 = 0 THEN 'Y y.,'
        ELSE cast((datediff(DAY,date,
                              (SELECT top (1) date
                               FROM Battles AS P2
                               WHERE P2.date > P1.date
                               ORDER BY P2.date))/365) AS varchar(20)) + ','
    END + CASE
     WHEN (datediff(DAY,date,
                      (SELECT top (1) date
                       FROM Battles AS P2
                       WHERE P2.date > P1.date
                       ORDER BY P2.date))/30 - (datediff(DAY,date,
                                                           (SELECT top (1) date
                                                            FROM Battles AS P2
                                                            WHERE P2.date > P1.date
                                                            ORDER BY P2.date))/365) * 12) = 0 THEN 'M m.'
     ELSE cast((datediff(DAY,date,
                           (SELECT top (1) date
                            FROM Battles AS P2
                            WHERE P2.date > P1.date
                            ORDER BY P2.date))/30 - (datediff(DAY,date,
                                                                (SELECT top (1) date
                                                                 FROM Battles AS P2
                                                                 WHERE P2.date > P1.date
                                                                 ORDER BY P2.date))/365) * 12) AS varchar(20))  END)
  END AS 'Возраст',
  date AS date1,
     (SELECT top (1) date
      FROM Battles AS P2
      WHERE P2.date > P1.date
      ORDER BY P2.date) AS date2
   FROM Battles AS P1
   WHERE
       (SELECT top (1) date
        FROM Battles AS P2
        WHERE P2.date > P1.date
        ORDER BY P2.date) IS NOT NULL) AS t
UNION
  (SELECT CASE
   WHEN (CASE
             WHEN datediff(DAY,date,CONVERT (date, GETDATE()))/365 = 0 THEN 'Y y.,'
             ELSE cast((datediff(DAY,date,CONVERT (date, GETDATE()))/365) AS varchar(20)) + ','
         END + CASE
                   WHEN (datediff(DAY,date,CONVERT (date, GETDATE()))/30 - (datediff(DAY,date,CONVERT (date, GETDATE()))/365) * 12) = 0 THEN 'M m.'
                   ELSE cast((datediff(DAY,date,CONVERT (date, GETDATE()))/30 - (datediff(DAY,date,CONVERT (date, GETDATE()))/365) * 12) AS varchar(20))
               END) = 'Y y.,M m.' THEN ''
   ELSE (CASE
             WHEN datediff(DAY,date,CONVERT (date, GETDATE()))/365 = 0 THEN 'Y y.,'
             ELSE cast((datediff(DAY,date,CONVERT (date, GETDATE()))/365) AS varchar(20)) + ','
         END + CASE
                   WHEN (datediff(DAY,date,CONVERT (date, GETDATE()))/30 - (datediff(DAY,date,CONVERT (date, GETDATE()))/365) * 12) = 0 THEN 'M m.'
                   ELSE cast((datediff(DAY,date,CONVERT (date, GETDATE()))/30 - (datediff(DAY,date,CONVERT (date, GETDATE()))/365) * 12) AS varchar(20))
               END)
    END, date, CONVERT (date, GETDATE())
   FROM Battles AS T1
   WHERE
       (SELECT top (1) date    FROM Battles AS T2
        WHERE T2.date > T1.date ORDER BY T2.date) IS NULL );

BDcorabli@ex5

akimachan, 12.09.2018 (Updated 12.09.2018)

Комментарии (3, +3)

mysql_real_escape_string / Говнокод #24748

0

1
2
3
4
5
6

select * from
(
select case when (case when datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/365 = 0 then 'Y y.,' else cast((datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/365) as varchar(20)) + ',' end + case when (datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/30 - (datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/365) * 12) = 0 then 'M m.' else cast((datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/30 - (datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/365) * 12) as varchar(20)) end) = 'Y y.,M m.' then '' else (case when datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/365 = 0 then 'Y y.,' else cast((datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/365) as varchar(20)) + ',' end + case when (datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/30 - (datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/365) * 12) = 0 then 'M m.' else cast((datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/30 - (datediff(day,date,(select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date))/365) * 12) as varchar(20)) end) end as 'Возраст', date as date1, (select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date) as date2 from Battles as P1 where (select top (1) date from Battles as P2 where P2.date > P1.date order by P2.date) is not null) as t
union
(select case when (case when datediff(day,date,CONVERT (date, GETDATE()))/365 = 0 then 'Y y.,' else cast((datediff(day,date,CONVERT (date, GETDATE()))/365) as varchar(20)) + ',' end + case when (datediff(day,date,CONVERT (date, GETDATE()))/30 - (datediff(day,date,CONVERT (date, GETDATE()))/365) * 12) = 0 then 'M m.' else cast((datediff(day,date,CONVERT (date, GETDATE()))/30 - (datediff(day,date,CONVERT (date, GETDATE()))/365) * 12) as varchar(20)) end) = 'Y y.,M m.' then '' else (case when datediff(day,date,CONVERT (date, GETDATE()))/365 = 0 then 'Y y.,' else cast((datediff(day,date,CONVERT (date, GETDATE()))/365) as varchar(20)) + ',' end + case when (datediff(day,date,CONVERT (date, GETDATE()))/30 - (datediff(day,date,CONVERT (date, GETDATE()))/365) * 12) = 0 then 'M m.' else cast((datediff(day,date,CONVERT (date, GETDATE()))/30 - (datediff(day,date,CONVERT (date, GETDATE()))/365) * 12) as varchar(20)) end) end, date, CONVERT (date, GETDATE()) from Battles as T1 where (select top (1) date from Battles as T2 where T2.date > T1.date order by T2.date) is null
);

BDcorabli@nomer5

akimachan, 12.09.2018 (Updated 12.09.2018)

Комментарии (3, +3)

mysql_real_escape_string / Говнокод #24336

0

1
2

//Список категорий записан в строках с разделителем вида "23", "11||12" или даже "3||8||12||43||23"
SELECT id, pagetitle FROM modx_site_content WHERE categores LIKE "%|[[*id]]" OR categores LIKE "%|[[*id]]|%" OR categores LIKE "[[*id]]|%" OR categores="[[*id]]"

FODD, 29.05.2018 (Updated 29.05.2018)

Комментарии (49, +49)

mysql_real_escape_string / Говнокод #24334

0

1
2
3
4
5
6
7
8
9
10
11
12
13
14

SELECT DISTINCT comment_author
FROM  `wp_comments` 
WHERE comment_content LIKE  '%и т.д%'
ORDER BY comment_date

https://ideone.com/78q77K


SELECT DISTINCT comment_author
FROM  `wp_comments` 
WHERE comment_content LIKE  '%итд%'
ORDER BY comment_date

https://ideone.com/bB9w3t

Тут сразу палятся файки roskomgovno aka SemaReal aka barop aka huesto aka guestinho aka guesto

minusinho, 28.05.2018 (Updated 28.05.2018)

Комментарии (23, +23)