alexalexes

$(document).keydown(function (e) {
        if (e.which == 13) {
            document.getElementById("commentAdd").click();
            document.getElementById("messageArea").value = "";
                    }
    });

$('textarea').on('keydown', function( el ) {
        if( el.keyCode === 13 ) {
            el.preventDefault();
            whenEnterPressed();
        }
    });

function wp_json_encode( $data, $options = JSON_UNESCAPED_UNICODE, $depth = 512 ) 
{
...

var iframe = document.getElementById('fileUploadIframe');
 iframe.width = iframe.contentWindow.document.body.scrollWidh + "px";
 iframe.height = iframe.contentWindow.document.body.scrollHeight + "px";

SELECT count(e.id) "кол-во записей example со статусом 1",
       (
           select count(type_id)
           from example e_1
           where type_id = 1
              and e_1.status = 3
       ) "кол-во для типа 1",
       (
           select count(type_id)
           from example e_3
           where type_id = 3
              and e_3.status = 3
       ) "кол-во для типа 3",
       (
           select count(type_id)
           from example e_4
           where type_id = 4 
            and e_4.status = 3
       ) "кол-во для типа 4"
FROM example e
WHERE e.status = 1
     and e.user_id = 53;

SELECT count(e.id) "кол-во записей example со статусом 1",
             count(case when e.type_id = 1
              and e.status = 3 then 1 end)  "кол-во для типа 1",
       count(case when e.type_id = 3
              and e.status = 3 then 1 end)  "кол-во для типа 3",
     count(case when e.type_id = 4
              and e.status = 3 then 1 end)  "кол-во для типа 4"
FROM example e
WHERE e.status = 1
     and e.user_id = 53;

SELECT count(case when e.status = 1 then 1 end) "кол-во записей example со статусом 1",
             count(case when e.type_id = 1
              and e.status = 3 then 1 end)  "кол-во для типа 1",
       count(case when e.type_id = 3
              and e.status = 3 then 1 end)  "кол-во для типа 3",
     count(case when e.type_id = 4
              and e.status = 3 then 1 end)  "кол-во для типа 4"
FROM example e
where e.user_id = 53

-- Считаем статус 1, игнорируем типы
SELECT 'with_status_1' type_query, null type_id, count(*) cnt
FROM example e
where e.status = 1
and e.user_id = 53
union all
-- Считаем остальные типы со статусом 3
SELECT 'with_another_types' type_query, e.type_id, count(*) cnt
FROM example e
where e.status = 3
and e.user_id = 53
group by e.type_id

....
   <tr class="Item-service" onclick="hide_trs(this)"></tr>
....

function hide_trs(target)
  {
        var parent = target.parentNode;
        var tr_nodes = Array.prototype.slice.call(parent.getElementsByTagName('TR'));
        var tr_count = tr_nodes.length;
        var target_index = tr_nodes.indexOf(target);
        for(var i = target_index + 1; i < tr_count; i++)
        {
          var cur_tr = tr_nodes[i];
          if(cur_tr.className !== 'Item-service')
            cur_tr.style.display = 'none';
          else
            break;
        }
  }

SET @var = 4;

Select * from
(
-------------Ваш сложный подзапрос --------------------
SELECT *
FROM menu
WHERE FIND_IN_SET(ID,(SELECT GROUP_CONCAT(lv SEPARATOR ',') FROM (
SELECT @pv:=(SELECT GROUP_CONCAT(ID SEPARATOR ',')
FROM menu WHERE submenu IN (@pv)) AS lv FROM menu
JOIN (SELECT @pv:=@var)tmp
WHERE submenu IN (@pv)) a))

UNION ALL
SELECT *
FROM menu
WHERE ID = @var
ORDER BY ID
-------конец сложного подзапроса--------------
) complicated_menu
inner join ваша_таблица vt on complicated_menu.id = vt.id

SELECT p.*, u.name FROM posts p
JOIN users u ON u.id = p.user_id
JOIN postTags pt1 ON pt1.post_id = p.id and pt1.tag_id = 3
JOIN postTags pt2 ON pt2.post_id = p.id and pt2.tag_id = 5
JOIN postTags pt3 ON pt3.post_id = p.id and pt3.tag_id = 7
WHERE p.user_id = 4

Select a.*
from
(
SELECT p.*, u.name, count (distinct  pt1.tag_id) over (partition by p.id) unik_tag_count
 FROM posts p
JOIN users u ON u.id = p.user_id
JOIN postTags pt1 ON pt1.post_id = p.id
WHERE p.user_id = 4
and pt1.tag_id in (3, 5, 7)
) a
where  a.unik_tag_count = 3 -- уникальное кол-во тегов на один пост

select a.* from
(
  select b.id, b.split_value, count(b.id) over (partition by b.split_value) as v_count
  from
  (
    select c.id, cast(unnest(string_to_array(translate(c.value,'{}',''),',')) as INTEGER) as split_value
    from
    ( -- имитация данных таблицы
      (select 0 as id, '{1,2,3}' as value) union all
      (select 1, '{4, 5}') union all
      (select 2, '{3, 6}') 
    ) c
  ) b
) a
where a.v_count > 1

select a.* from
(
  select b.id, b.split_value, count(b.id) over (partition by b.split_value) as v_count
  from
  (
    select c.id, unnest(c.value) as split_value
    from
    ( -- имитация данных таблицы
      (select 0 as id, array[1,2,3] as value) union all
      (select 1, array[4,5]) union all
      (select 2, array[3,6]) 
    ) c
  ) b
) a
where a.v_count > 1

Try this. Check /etc/php7/

Rename 20_mysqli.ini to 30_mysqli.ini, or delete 20_mysqli.ini if both exist. If you also have 20_openssl.ini there, rename that to 10_openssl.ini.
Above change is needed to load the modules in the correct order.
This should now be fixed in the latest builds, but you could be running older code, or suffering from the bug that was there earlier.

while(true)
{
  $f = readdir($d);
  if($f === fasle)
  {  break; }
  // Сделать что-то с $f в противном случае.
}