|
@@ 5235-5237 (lines=3) @@
|
| 5232 |
|
// Skip listing with statuses trash, auto-draft etc...
|
| 5233 |
|
$skip_statuses = geodir_imex_export_skip_statuses();
|
| 5234 |
|
$where_statuses = '';
|
| 5235 |
|
if ( !empty( $skip_statuses ) && is_array( $skip_statuses ) ) {
|
| 5236 |
|
$where_statuses = "AND `" . $wpdb->posts . "`.`post_status` NOT IN('" . implode( "','", $skip_statuses ) . "')";
|
| 5237 |
|
}
|
| 5238 |
|
|
| 5239 |
|
$query = $wpdb->prepare( "SELECT COUNT({$wpdb->posts}.ID) FROM {$wpdb->posts} INNER JOIN {$table} ON {$table}.post_id = {$wpdb->posts}.ID WHERE {$wpdb->posts}.post_type = %s " . $where_statuses, $post_type );
|
| 5240 |
|
|
|
@@ 5616-5618 (lines=3) @@
|
| 5613 |
|
// Skip listing with statuses trash, auto-draft etc...
|
| 5614 |
|
$skip_statuses = geodir_imex_export_skip_statuses();
|
| 5615 |
|
$where_statuses = '';
|
| 5616 |
|
if ( !empty( $skip_statuses ) && is_array( $skip_statuses ) ) {
|
| 5617 |
|
$where_statuses = "AND `" . $wpdb->posts . "`.`post_status` NOT IN('" . implode( "','", $skip_statuses ) . "')";
|
| 5618 |
|
}
|
| 5619 |
|
|
| 5620 |
|
$query = "SELECT {$wpdb->posts}.ID FROM {$wpdb->posts} INNER JOIN {$table} ON {$table}.post_id = {$wpdb->posts}.ID WHERE {$wpdb->posts}.post_type = %s " . $where_statuses . " ORDER BY {$wpdb->posts}.ID ASC" . $limit;
|
| 5621 |
|
/**
|
|
@@ 5670-5672 (lines=3) @@
|
| 5667 |
|
// Skip listing with statuses trash, auto-draft etc...
|
| 5668 |
|
$skip_statuses = geodir_imex_export_skip_statuses();
|
| 5669 |
|
$where_statuses = '';
|
| 5670 |
|
if ( !empty( $skip_statuses ) && is_array( $skip_statuses ) ) {
|
| 5671 |
|
$where_statuses = "AND `" . $wpdb->posts . "`.`post_status` NOT IN('" . implode( "','", $skip_statuses ) . "')";
|
| 5672 |
|
}
|
| 5673 |
|
|
| 5674 |
|
$query = "SELECT {$wpdb->posts}.ID, {$schedule_table}.event_date, {$schedule_table}.event_enddate AS enddate, {$schedule_table}.event_starttime AS starttime, {$schedule_table}.event_endtime AS endtime FROM {$wpdb->posts} INNER JOIN {$table} ON ({$table}.post_id = {$wpdb->posts}.ID) INNER JOIN {$schedule_table} ON ({$schedule_table}.event_id = {$wpdb->posts}.ID) WHERE {$wpdb->posts}.post_type = %s " . $where_statuses . " GROUP BY {$table}.post_id ORDER BY {$wpdb->posts}.ID ASC, {$schedule_table}.schedule_id ASC";
|
| 5675 |
|
}
|
GeoDirectory /
geodirectory
