| 1 | 309c309
|
|---|
| 2 | < $sqlcat = '';
|
|---|
| 3 | ---
|
|---|
| 4 | > $join = '';
|
|---|
| 5 | 311c311,317
|
|---|
| 6 | < $sqlcat = " AND post_category = '$current_category' ";
|
|---|
| 7 | ---
|
|---|
| 8 | > $join = " INNER JOIN $wpdb->post2cat ON $wpdb->posts.ID = $wpdb->post2cat.post_id ";
|
|---|
| 9 | > $cat_array = $wpdb->get_col("SELECT category_id FROM $wpdb->post2cat WHERE post_id = $post->ID");
|
|---|
| 10 | > $join .= " AND ($wpdb->post2cat.category_id = " . intval($cat_array[0]);
|
|---|
| 11 | > for ($i = 1; $i < (count($cat_array)); $i++) {
|
|---|
| 12 | > $join .= ' OR category_id = ' . intval($cat_array[$i]);
|
|---|
| 13 | > }
|
|---|
| 14 | > $join .= ')';
|
|---|
| 15 | 344c350
|
|---|
| 16 | < $sqlcat = '';
|
|---|
| 17 | ---
|
|---|
| 18 | > $join = '';
|
|---|
| 19 | 346c352,358
|
|---|
| 20 | < $sqlcat = " AND post_category='$current_category' ";
|
|---|
| 21 | ---
|
|---|
| 22 | > $join = " INNER JOIN $wpdb->post2cat ON $wpdb->posts.ID= $wpdb->post2cat.post_id ";
|
|---|
| 23 | > $cat_array = $wpdb->get_col("SELECT category_id FROM $wpdb->post2cat WHERE post_id = $post->ID");
|
|---|
| 24 | > $join .= ' AND (category_id = ' . intval($cat_array[0]);
|
|---|
| 25 | > for ($i = 1; $i < (count($cat_array)); $i++) {
|
|---|
| 26 | > $join .= ' OR category_id = ' . intval($cat_array[$i]);
|
|---|
| 27 | > }
|
|---|
| 28 | > $join .= ')';
|
|---|
| 29 | 362c374
|
|---|
| 30 | < $nextpost = @$wpdb->get_row("SELECT ID,post_title FROM $wpdb->posts WHERE post_date > '$current_post_date' AND post_date_gmt < '$now' AND post_status = 'publish' $sqlcat $sql_exclude_cats AND ID != $post->ID ORDER BY post_date ASC LIMIT $limitnext,1");
|
|---|
| 31 | ---
|
|---|
| 32 | > $nextpost = @$wpdb->get_row("SELECT ID,post_title FROM $wpdb->posts $join WHERE post_date > '$current_post_date' AND post_date_gmt < '$now' AND post_status = 'publish' $sqlcat $sql_exclude_cats AND ID != $post->ID ORDER BY post_date ASC LIMIT $limitnext,1");
|
|---|
| 33 | 506c518
|
|---|
| 34 | < ?>
|
|---|
| 35 | \ No newline at end of file
|
|---|
| 36 | ---
|
|---|
| 37 | > ?>
|
|---|
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png){kind=logo}
