private function loadItemsFromDatabase() { $retVal = false; global $wpdb; $sql = "SELECT item_id\n\t\t\t\tFROM " . \CEOS\Slider\PLUGIN_PREFIX . "items\n\t\t\t\tWHERE item_slider_id = %d"; $results = $wpdb->get_results($wpdb->prepare($sql, $this->getID())); if (is_array($results)) { foreach ($results as $result) { $item = new \CEOS\Slider\SliderItem(); $item->loadFromDatabase($result->item_id); $this->addItem($item); } $retVal = true; } else { $retVal = false; } }
} } /** * If the default transition duration of the current slider item was not * provided by the user, we give it a default value. */ if (!isset($item['transition_duration']) || !is_numeric($item['transition_duration'])) { $item['transition_duration'] = 1000; } else { $item['transition_duration'] *= 1000; } /** * Here we set a SliderItem object with the information provided and * insert it into the Slider object previously created. */ $sldItem = new \CEOS\Slider\SliderItem(); if (isset($item['id']) && is_numeric($item['id'])) { $sldItem->loadFromDatabase($item['id']); } $sldItem->setPosition($pos); $sldItem->setTitle(@$item['title']); $sldItem->setDescription(@$item['desc']); $sldItem->setURL(@$item['url']); $sldItem->setTransitionName(@$item['transition']); if (isset($item['transition-dur']) && is_numeric($item['transition-dur'])) { $sldItem->setTransitionDuration($item['transition-dur'] * 1000); } if (isset($item['interval']) && is_numeric($item['interval'])) { $sldItem->setInterval($item['interval'] * 1000); } if (isset($item['img']['src']) && !empty($item['img']['src'])) {