Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter stocksohio

    (@stocksohio)

    It seems to be working now! Thanks so much!

    Thread Starter stocksohio

    (@stocksohio)

    Thanks, I appreciate it.

    Thread Starter stocksohio

    (@stocksohio)

    I’ve already got that selected. That’s why I am a little stumped. Here is the link: http://iamachildofdivorce.com/askusaquestion/ how is it supposed to work? Are they supposed to be able to see their prior tickets when they enter their e-mail?

    Thread Starter stocksohio

    (@stocksohio)

    When I used a guest e-mail to submit a ticket (to test it), I got an e-mail telling me that it had been answered. When I went back to the page to check on it, I put in the same e-mail address, but nothing comes up except the box to submit a new ticket. I couldn’t see any old tickets as a guest.

    Thread Starter stocksohio

    (@stocksohio)

    It’s inexact I’m sure because I am not a coder, but I got it to work. I changed:

    if(isset($atts[‘label’])) $label = strtolower($atts[‘label’]);
    if(isset($atts[‘limit’]) && $atts[‘limit’] > 0) { $limit = “LIMIT 0, ” . $atts[‘limit’]; } else { $limit = “”; }

    if( isset($age) && isset($label) ) {
    $allevents = $wpdb->get_results(” SELECT * FROM $table_name WHERE event_label = ‘$label’ AND $range ORDER BY event_start $limit”, “ARRAY_A”);
    } elseif(isset($age)) {
    $allevents = $wpdb->get_results(” SELECT * FROM $table_name WHERE $range ORDER BY event_start $limit”, “ARRAY_A”);
    } elseif(isset($label)) {
    $currentTime = time();
    $allevents = $wpdb->get_results(” SELECT * FROM $table_name WHERE event_label = ‘$label’ AND event_end >= $currentTime ORDER BY event_start $limit”, “ARRAY_A”);
    } else {
    $currentTime = time();
    $allevents = $wpdb->get_results(” SELECT * FROM $table_name WHERE event_end >= $currentTime ORDER BY event_start $limit”, “ARRAY_A”);
    }

    TO

    if(isset($atts[‘label’])) $label = strtolower($atts[‘label’]);
    if(isset($atts[‘limit’]) && $atts[‘limit’] > 0) { $limit = “LIMIT 0, ” . $atts[‘limit’]; } else { $limit = “”; }

    if( isset($age) && isset($label) ) {
    $allevents = $wpdb->get_results(” SELECT * FROM $table_name WHERE event_label = ‘$label’ AND $range ORDER BY event_start $limit”, “ARRAY_A”);
    } elseif(isset($age)) {
    $allevents = $wpdb->get_results(” SELECT * FROM $table_name WHERE $range ORDER BY event_start $limit”, “ARRAY_A”);
    } elseif(isset($label)) {
    $currentTime = time()-14400;
    $allevents = $wpdb->get_results(” SELECT * FROM $table_name WHERE event_label = ‘$label’ AND event_end >= $currentTime ORDER BY event_start $limit”, “ARRAY_A”);
    } else {
    $currentTime = time()-14400;
    $allevents = $wpdb->get_results(” SELECT * FROM $table_name WHERE event_end >= $currentTime ORDER BY event_start $limit”, “ARRAY_A”);
    }

    This subtracted four hours off the time code and caused my events to show up until they shouldn’t anymore.

    Thanks for the short codes. I was trying to figure out how to sort by title rather than most recent, and this did the trick. Does anyone know if there is a short code to generate random posts when the plugin is loaded. I have a grid on my static home page to feature posts. I would rather not show all of the posts (especially as the site gets bigger). Instead I would like to show say 5 pages with 3 columns, but I would like it to pick those 15 posts randomly from a pull of say 50 in the category. Any ideas?

Viewing 6 replies - 1 through 6 (of 6 total)