WordPress.org
Get WordPress

Plugin Directory

Changeset 3428414


Ignore:
Timestamp:
12/27/2025 10:45:50 PM (3 months ago)
Author:
davidfcarr
Message:

wpdb prepare fixes, including for show attendees

Location:
rsvpmaker/trunk
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • rsvpmaker/trunk/README.txt

    r3423832 r3428414  
    99Requires at least: 5.0
    1010Tested up to: 6.9
     11Stable tag: 11.7.1
     12Stable tag: 11.6.9
     13=======
    1114Stable tag: 11.7
     15>>>>>>> .r3428411
    1216
    1317Event and email marketing. Register guests and collect payment by PayPal or Stripe. Send invitations and newsletters.

  • rsvpmaker/trunk/rsvpmaker-api-endpoints.php

    r3419017 r3428414  
    248248
    249249        $event = $request['post_id'];
    250 
    251         $sql = $wpdb->prepare("SELECT FROM first,last,note %i WHERE event=%d AND yesno=1 ORDER BY id DESC",$wpdb->prefix . "rsvpmaker",$event);
    252 
     250        $sql = $wpdb->prepare("SELECT first,last,note FROM %i WHERE event=%d AND yesno=1 ORDER BY id DESC",$wpdb->prefix . "rsvpmaker",$event);
    253251        $attendees = $wpdb->get_results( $sql );
    254252

  • rsvpmaker/trunk/rsvpmaker-plugabble.php

    r3423832 r3428414  
    26902690            }
    26912691
    2692             $sql = $wdbp->prepare("SELECT details FROM %i WHERE email LIKE %s ORDER BY id DESC",$wpdb->prefix . 'rsvpmaker',$email);
     2692            $sql = $wpdb->prepare("SELECT details FROM %i WHERE email LIKE %s ORDER BY id DESC",$wpdb->prefix . 'rsvpmaker',$email);
    26932693            } else {
    26942694                $sql = $wpdb->prepare("SELECT details FROM %i WHERE email LIKE %s ORDER BY id DESC",$wpdb->prefix . 'rsvpmaker',$email);

  • rsvpmaker/trunk/rsvpmaker-report.php

    r3419017 r3428414  
    327327
    328328            if( !isset( $_GET['rsvp_order'] ) || ( $_GET['rsvp_order'] == 'host' ) )
    329             {
    330                
     329            {               
    331330                $results = $wpdb->get_results( $wpdb->prepare("SELECT * FROM %i WHERE event=%d AND master_rsvp=0 ORDER BY ".(isset($_GET['latest']) ? ' timestamp DESC ' : ' yesno DESC, last, first '),$wpdb->prefix."rsvpmaker",$eventid), ARRAY_A );
    332331                format_rsvp_details( $results, true, true );   
    333332            }
    334333            else {
    335                
    336 
    337334                $results = $wpdb->get_results( $wpdb->prepare("SELECT * FROM %i WHERE event=%d ".( isset( $_GET['rsvp_order'] ) && ( $_GET['rsvp_order'] == 'alpha' ) ) ? ' ORDER BY yesno DESC, last, first' : ' ORDER BY yesno DESC, timestamp DESC',$wpdb->prefix . "rsvpmaker",$wpdb->prefix . "rsvpmaker"), ARRAY_A );
    338 
    339335                format_rsvp_details( $results );   
    340336            }
    … …  
    695691
    696692        $number_registered = sizeof($results);
     693        $unpaidcount = 0;
    697694
    698695        foreach ( $results as $index => $row ) {
    … …  
    710707            }
    711708            $owed_list .= format_rsvp_row($row,$fields, $pricing);
     709
     710            $is_unpaid = !empty($row['fee_total']) && '0.00' != $row['fee_total'] && '0.00' != $row['owed'] && !empty($row['owed']);
     711            if($is_unpaid)
     712                $unpaidcount++;
    712713
    713714            if($check_guests) {
    … …  
    716717                if($g) {
    717718                    $number_registered += sizeof($g);
     719                    if($is_unpaid)
     720                        $unpaidcount+= sizeof($g);
    718721                    echo '<blockquote>';
    719722                    foreach($g as $grow) {
    … …  
    751754
    752755        }
    753         printf('<p>%d registered</p>',$number_registered);
     756        printf('<p>%d registered, including %d unpaid</p>',$number_registered,$unpaidcount);
    754757
    755758        echo '<div class="noprint">';

  • rsvpmaker/trunk/rsvpmaker.php

    r3423832 r3428414  
    1111* License:           GPL v2 or later
    1212* License URI:       https://www.gnu.org/licenses/gpl-2.0.html
    13 * Version: 11.7
     13* Version: 11.7.1
    1414*/
    1515
    1616function get_rsvpversion() {
    17     return '11.7';
     17    return '11.7.1';
    1818}
    1919
Note: See TracChangeset for help on using the changeset viewer.