</a> </th> <th><?php _e('Slides', $this->plugin_name); ?> </th> <th><?php _e('Shortcode', $this->plugin_name); ?> </th> <th class="column-modified <?php echo $orderby == "modified" ? 'sorted ' . $order : 'sortable desc'; ?> "> <a href="<?php echo GalleryHtmlHelper::retainquery('orderby=modified&order=' . ($orderby == "modified" ? $otherorder : "asc")); ?> "> <span><?php _e('Date', $this->plugin_name); ?> </span> <span class="sorting-indicator"></span> </a> </th> </tr> </tfoot> <tbody> <?php foreach ($galleries as $gallery) { ?>
/** * WHERE conditions * This should be an array * */ var $where = ''; /** * ORDER condition * */ var $order = array('modified', "DESC"); var $plugin_url = ''; var $sub = ''; var $parent = ''; var $allcount = 0; var $allRecords = array(); var $pagination = ''; function GalleryPaginate($table = '', $fields = '', $sub = '', $parent = '') { $this->sub = $sub; $this->parentd = $parent; if (!empty($table)) { $this->table = $table; } if (!empty($fields)) { $this->fields = $fields; } } function start_paging($page = '') { global $wpdb; $page = empty($page) ? 1 : $page; if (!empty($page)) { $this->page = $page; } if (!empty($this->fields)) { if (is_array($this->fields)) { $this->fields = implode(", ", $this->fields); } } $query = "SELECT " . $this->fields . " FROM `" . $this->table . "`"; $countquery = "SELECT COUNT(*) FROM `" . $this->table . "`"; //check if some conditions where passed. if (!empty($this->where)) { //append the "WHERE" command to the query $query .= " WHERE"; $countquery .= " WHERE"; $c = 1; foreach ($this->where as $key => $val) { if (!empty($val) && is_array($val)) { $k = 1; foreach ($val as $vkey => $vval) { if (eregi("LIKE", $val)) { $query .= " `" . $key . "` " . $vval . ""; $countquery .= " `" . $key . "` " . $vval . ""; } elseif (preg_match("/SE (.*)/si", $vval, $vmatches)) { if (!empty($vmatches[1])) { $query .= " `" . $key . "` <= " . $vmatches[1] . ""; $countquery .= " `" . $key . "` <= " . $vmatches[1] . ""; } } elseif (preg_match("/LE (.*)/si", $vval, $vmatches)) { if (!empty($vmatches[1])) { $query .= " `" . $key . "` >= " . $vmatches[1] . ""; $countquery .= " `" . $key . "` >= " . $vmatches[1] . ""; } } else { $query .= " `" . $key . "` = '" . $vval . "'"; $countquery .= " `" . $key . "` = '" . $vval . "'"; } if ($k < count($val)) { $query .= " AND"; $countquery .= " AND"; } $k++; $vmatches = false; } } else { if (eregi("LIKE", $val)) { $query .= " `" . $key . "` " . $val . ""; $countquery .= " `" . $key . "` " . $val . ""; } elseif (preg_match("/SE (.*)/si", $val, $vmatches)) { if (!empty($vmatches[1])) { $query .= " `" . $key . "` <= " . $vmatches[1] . ""; $countquery .= " `" . $key . "` <= " . $vmatches[1] . ""; } } elseif (preg_match("/LE (.*)/si", $val, $vmatches)) { if (!empty($vmatches[1])) { $query .= " `" . $key . "` >= " . $vmatches[1] . ""; $countquery .= " `" . $key . "` >= " . $vmatches[1] . ""; } } else { $query .= " `" . $key . "` = '" . $val . "'"; $countquery .= " `" . $key . "` = '" . $val . "'"; } if ($c < count($this->where)) { $query .= " AND"; $countquery .= " AND"; } $c++; $vmatches = false; }
echo GalleryHtmlHelper::retainquery('orderby=modified&order=' . ($orderby == "modified" ? $otherorder : "asc")); ?> "> <span><?php _e('Date', $this->plugin_name); ?> </span> <span class="sorting-indicator"></span> </a> </th> <th class="column-order <?php echo $orderby == "order" ? 'sorted ' . $order : 'sortable desc'; ?> "> <a href="<?php echo GalleryHtmlHelper::retainquery('orderby=order&order=' . ($orderby == "order" ? $otherorder : "asc")); ?> "> <span><?php _e('Order', $this->plugin_name); ?> </span> <span class="sorting-indicator"></span> </a> </th> </tr> </tfoot> <tbody> <?php foreach ($slides as $slide) { ?>