function update_slideshow($slideshowid, $name, $delay, $slides) { foreach ($slides as $slide) { if (!validate_slide($slide)) { return false; } } if (!($result = DBexecute('UPDATE slideshows SET name=' . zbx_dbstr($name) . ',delay=' . $delay . ' WHERE slideshowid=' . $slideshowid))) { return false; } DBexecute('DELETE FROM slides where slideshowid=' . $slideshowid); $i = 0; foreach ($slides as $slide) { $slideid = get_dbid('slides', 'slideid'); $result = DBexecute('INSERT INTO slides (slideid,slideshowid,screenid,step,delay) ' . ' VALUES (' . $slideid . ',' . $slideshowid . ',' . $slide['screenid'] . ',' . $i++ . ',' . $slide['delay'] . ')'); if (!$result) { return false; } } return true; }
function update_slideshow($slideshowid, $name, $delay, $slides) { foreach ($slides as $slide) { if (!validate_slide($slide)) { return false; } } if (!($result = DBexecute('update slideshows set name=' . zbx_dbstr($name) . ',delay=' . $delay . ' where slideshowid=' . $slideshowid))) { return false; } DBexecute('DELETE FROM slides where slideshowid=' . $slideshowid); $i = 0; foreach ($slides as $slide) { $slideid = get_dbid('slides', 'slideid'); if (!($result = DBexecute('insert into slides (slideid,slideshowid,screenid,step,delay) ' . ' values (' . $slideid . ',' . $slideshowid . ',' . $slide['screenid'] . ',' . $i++ . ',' . $slide['delay'] . ')'))) { return false; } } return true; }