REPLACE INTO modx_site_content
(
id,
pagetitle,
content,
parent,
template,
published,
alias,
createdby,
editedby,
uri
)
VALUES
(
'SELECT LAST_INSERT_ID();',
'%Название%',
'%content%',
'4',
'5',
'1',
'%Название%',
'1',
'1',
'novosti/%Название%.html'
);
REPLACE INTO modx_site_tmplvar_contentvalues
(
id,
tmplvarid,
contentid,
value
)
VALUES
(
'SELECT LAST_INSERT_ID();',
'1',
'SELECT * FROM modx_site_content AS msc
LEFT JOIN modx_site_tmplvar_contentvalues AS mstc
ON msc.id = mstc.contentid AND mstc.tmplvarid = 1
ORDER BY mstc.contentid DESC', //Вот сюда надо ID статьи
'%namepage%'
);imgs = [
'[[*image-2]]',
'[[*image-3]]',
];
setInterval(
function(){
img = imgs[Math.floor(Math.random()*imgs.length)];
$('.fusion-builder-row .fusion-layout-column:nth-child(1) .bgfimg img').attr('src', img);
}, 2000);
