WordPress.org

Ready to get started?Download WordPress

Forums

Trying to extend x-Dashboard (1 post)

  1. jcdesign
    Member
    Posted 8 years ago #

    Hi there, this looks like a nice little plugin, and I tried to extend it further myself with something that would show pages and link to them. I got a MySQL error, though. Here's what I attempted, ripping code from edit-pages.php and pasting it into one the x-Dash plugin for Drafts. The first MySQL statement was causing problems. Any advice?

    <pre>
    <?php
    /* x-Dash-Plugin-Name:Pages */

    global $wpdb, $user_ID;
    if (isset($user_ID) && ('' != intval($user_ID))) {
    $posts = $wpdb->get_results("
    SELECT $wpdb->posts.*, $wpdb->users.user_level FROM $wpdb->posts
    INNER JOIN $wpdb->users ON ($wpdb->posts.post_author = $wpdb->users.ID)
    WHERE $wpdb->posts.post_status = 'static'
    AND ($wpdb->users.user_level < $user_level OR $wpdb->posts.post_author = $user_ID)
    ");
    } else {
    $posts = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_status = 'static'");
    }

    if ($posts) {

    xdash_show_title('Pages:');
    if ($xdash_cur_section == 'ticker')
    echo "Pages: ";

    $i = 0;
    foreach ($posts as $post) {
    if (0 != $i)
    echo ', ';
    $post->post_title = stripslashes($draft->post_title);
    if ($post->post_title == '')
    $post->post_title = sprintf(__('Post #%s'), $post->ID);
    echo "ID' title='" . __('Edit this Page') . "'>$draft->post_title";
    ++$i;
    }
    ?>
    .
    <?php
    } ?>
    </pre>

Topic Closed

This topic has been closed to new replies.

About this Topic