WordPress.org
Get WordPress

Plugin Directory

Changeset 2829234


Ignore:
Timestamp:
12/06/2022 09:46:39 AM (3 years ago)
Author:
wilsos6
Message:

Version 2.3.1 commit.

Location:
joy-of-text/trunk
Files:
2 added
2 deleted
5 edited

Legend:

Unmodified
Added
Removed

  • joy-of-text/trunk/classes/class-jot-plugin-messenger.php

    r2600087 r2829234  
    339339                     //Get member details for given memberid
    340340                     global $wpdb;
     341                     
     342                     $jotmemid = (int) $jotmemid;
    341343                   
    342344                     $table_members = $wpdb->prefix."jot_groupmembers";
    343345                     $sql = " SELECT jot_grpmemid, jot_grpmemname, jot_grpmemnum " .
    344346                            " FROM " . $table_members  .
    345                             " WHERE jot_grpmemid =" . $jotmemid;
    346                                 
    347                      $member = $wpdb->get_row( $sql );
     347                            " WHERE jot_grpmemid = %d";
     348                     $sqlprep = $wpdb->prepare($sql,$jotmemid);
     349                     $member = $wpdb->get_row( $sqlprep );
    348350                     
    349351                     if ($member) {

  • joy-of-text/trunk/classes/class-jot-plugin-options.php

    r2600087 r2829234  
    709709         $sql = " SELECT jot_grpmemnum  " .
    710710                " FROM " . $table .
    711                 " WHERE jot_grpid = " . $id .
    712                 " AND jot_grpmemnum = '" . $number . "'";
    713               
    714          $numexists = $wpdb->get_results( $sql );
     711                " WHERE jot_grpid = %d " .
     712                " AND jot_grpmemnum = %s ";
     713         $sqlprep = $wpdb->prepare($sql, $id, $number);     
     714         $numexists = $wpdb->get_results( $sqlprep );
    715715         return $numexists;
    716716
    … …  
    725725         $sql = " SELECT jot_grpmemnum  " .
    726726                " FROM " . $table .
    727                 " WHERE jot_grpid = " . $grpid .
    728                 " AND   jot_grpmemid != " . $memid .
    729                 " AND jot_grpmemnum = '" . $number . "'";
    730               
    731          $numexists = $wpdb->get_results( $sql );       
    732          
     727                " WHERE jot_grpid = %d " .
     728                " AND   jot_grpmemid !=  %d" .
     729                " AND jot_grpmemnum = %s ";
     730         $sqlprep = $wpdb->prepare($sql, $grpid, $id, $number);
     731         $numexists = $wpdb->get_results( $sqlprep );
     732                  
    733733         return $numexists;
    734734
    … …  
    741741         $sql = " SELECT jot_grpinvretchk,jot_grpinvrettxt  " .
    742742                " FROM " . $table .
    743                 " WHERE jot_grpid = " . $id;               
    744          
    745          $welchkbox = $wpdb->get_row( $sql );
     743                " WHERE jot_grpid = %d ";               
     744         $sqlprep = $wpdb->prepare($sql, $id);
     745         $welchkbox = $wpdb->get_row( $sqlprep );
    746746         
    747747         if ($welchkbox->jot_grpinvretchk) {

  • joy-of-text/trunk/classes/class-jot-plugin-settings.php

    r2748389 r2829234  
    510510            $html .= "<ul class='jot-getstarted-nested'>";
    511511            $html .= "<li>" . "<span class='getstarted-description'>" . __("To use this plugin you'll need a Twilio account.","jot-plugin") . "</span>" . "</li>";
    512             $twilio_referral_url = "<a href='https://www.twilio.com/referral/vDJcVW' target='_blank'>" . __("referral","jot-plugin") .  "</a>";
    513             $twilio_referral_tcs_url = "<a href='https://www.twilio.com/legal/referral-program' target='_blank'>" . __("here","jot-plugin") .  "</a>";
    514             $html .= "<li> " . "<span class='getstarted-description'>" . sprintf (__("If you're new to Twilio, you can get <b>$10</b> added to your Twilio account, using this %s link.","jot-plugin"), $twilio_referral_url) . "</span>" . "</li>";
     512            //$twilio_referral_url = "<a href='https://www.twilio.com/referral/vDJcVW' target='_blank'>" . __("referral","jot-plugin") .  "</a>";
     513            //$twilio_referral_tcs_url = "<a href='https://www.twilio.com/legal/referral-program' target='_blank'>" . __("here","jot-plugin") .  "</a>";
     514            //$html .= "<li> " . "<span class='getstarted-description'>" . sprintf (__("If you're new to Twilio, you can get <b>$10</b> added to your Twilio account, using this %s link.","jot-plugin"), $twilio_referral_url) . "</span>" . "</li>";
    515515        //$html .= "<li> " . "<span class='getstarted-description'>" . sprintf (__("The terms and conditions of Twilio's referral program are available %s.","jot-plugin"), $twilio_referral_tcs_url) . "</span>" . "</li>";
    516516        $html .= "<li> " . "<span class='getstarted-description'>" . sprintf (__("Register an account at %s, purchase a phone number and get your unique 'Twilio Account SID' and 'Twilio Auth Token'.","jot-plugin"), $twilio_url) . "</span>" . "</li>";
    … …  
    12571257            $sql = " SELECT jot_groupid, jot_groupname,jot_groupdesc, jot_ts " .
    12581258                   " FROM " . $table .
    1259                    " WHERE jot_groupid = " . $lastid;
    1260            
    1261             $groupdetails = $wpdb->get_row( $sql );
     1259                   " WHERE jot_groupid = %s";
     1260            $sqlprep = $wpdb->prepare($sql, $lastid);
     1261            $groupdetails = $wpdb->get_row( $sqlprep );
     1262           
     1263            $jot_groupname = isset($groupdetails->jot_groupname) ? stripslashes($groupdetails->jot_groupname) : __("Group name not found","jotplugin");
     1264            $jot_groupdesc = isset($groupdetails->jot_groupdesc) ? stripslashes($groupdetails->jot_groupdesc) : __("Group description not found","jotplugin");
    12621265           
    12631266            if (isset($_GET['subtab'])) {
    … …  
    12721275           
    12731276            $html  = "<div id='jottabgroupdetails' $style>";         
    1274             $html .= "<h3> Group Details - <span id='jot_grptitle'>" . stripslashes($groupdetails->jot_groupname) . "</span></h3>";
     1277            $html .= "<h3> Group Details - <span id='jot_grptitle'>" . $jot_groupname . "</span></h3>";
    12751278            $html .= "<form id='jot-group-details-form' action='' method='post'>";
    12761279            $html .= "<input type=\"hidden\"  id=\"jot_form_id\" name=\"jot_form_id\" value=\"jot-group-details-form\">";
    … …  
    12781281            $html .= "<table class=\"jot-formtab form-table\">\n";
    12791282           
    1280             $html .= $this->render_row('jot_groupnameupd','',$groupdetails->jot_groupname,$tab);
    1281             $html .= $this->render_row('jot_groupdescupd','',$groupdetails->jot_groupdesc,$tab);
     1283            $html .= $this->render_row('jot_groupnameupd','',$jot_groupname,$tab);
     1284            $html .= $this->render_row('jot_groupdescupd','',$jot_groupdesc,$tab);
    12821285                       
    12831286                       
    … …  
    14321435            $sql = " SELECT a.jot_grpmemid, a.jot_grpid, a.jot_grpmemname, a.jot_grpmemnum, a.jot_grpmemts, b.jot_grpxrefts " .
    14331436                   " FROM " . $table_grpmem . " a, " . $table_grpxref . " b " .
    1434                    " WHERE a.jot_grpid = " . $grpid .
     1437                   " WHERE a.jot_grpid = %d " .
    14351438                   " AND a.jot_grpmemid = b.jot_grpmemid" .
    14361439                   " AND a.jot_grpid = b.jot_grpid" .
    14371440                   " ORDER BY 3 ASC";
    1438            
    1439             $groupmembers = $wpdb->get_results( $sql );
     1441            $sqlprep = $wpdb->prepare($sql, $grpid);
     1442            $groupmembers = $wpdb->get_results( $sqlprep );
    14401443
    14411444            if (isset($_GET['subtab'])) {
    … …  
    15181521            $sql = " SELECT jot_grpid, jot_grpinvdesc, jot_grpinvnametxt, jot_grpinvnumtxt, jot_grpinvretchk, jot_grpinvrettxt" .
    15191522                   " FROM " . $table .
    1520                    " WHERE jot_grpid = " . $lastid;
    1521                
    1522             $groupinvite = $wpdb->get_row( $sql );
     1523                   " WHERE jot_grpid = %d ";
     1524            $sqlprep = $wpdb->prepare($sql, $lastid);   
     1525            $groupinvite = $wpdb->get_row( $sqlprep );
    15231526           
    15241527            if (isset($_GET['subtab'])) {
    … …  
    18771880            $sql = " SELECT jot_grpmemid, jot_grpmemname, jot_grpmemnum " .
    18781881                   " FROM " . $table_members  .
    1879                    " WHERE jot_grpmemid =" . $jotmemid;
    1880                        
    1881             $member = $wpdb->get_row( $sql );
     1882                   " WHERE jot_grpmemid = %d";
     1883            $sqlprep = $wpdb->prepare($sql, $jotmemid);           
     1884            $member = $wpdb->get_row( $sqlprep );
    18821885            $memarr = array("jot_grpmemid" => $member->jot_grpmemid, "jot_grpmemname" => $member->jot_grpmemname, "jot_grpmemnum" => $member->jot_grpmemnum );
    18831886                         

  • joy-of-text/trunk/joy-of-text.php

    r2748389 r2829234  
    1717 * Plugin URI:        http://www.getcloudsms.com
    1818 * Description:       Send SMS and text-to-voice messages to your customers, subscribers, followers, members and friends.
    19  * Version:           2.3.0
     19 * Version:           2.3.1
    2020 * Author:            Stuart Wilson
    2121 * Author URI:        http://www.getcloudsms.com
    … …  
    3232  *
    3333  * Version
     34  * 2.3.1 - Removed link to Twilio referral scheme, which has now be discontinued by Twilio.
     35  *         Changed SQL queries to use prepare statement.
    3436  * 2.3.0 - Added Application-to-Person (A2P) registration guidance.
    3537  * 2.2.9.1 - Added code to sanitise text area input
    … …  
    124126            $this->product = "JOT Lite";                       
    125127            $this->token = 'jot-plugin';
    126             $this->version = '2.3.0';
     128            $this->version = '2.3.1';
    127129            $this->debug = false;           
    128130           

  • joy-of-text/trunk/readme.txt

    r2748389 r2829234  
    44Tags:  twilio, message, sms, mms, text, mobile, sms scheduler, scheduler, woocommerce, membermouse, voice message, notification, subscribe, buddypress, gravity forms
    55Requires at least: 3.0.1
    6 Tested up to: 6.0
    7 Stable tag: 2.3.0
     6Tested up to: 6.1.1
     7Stable tag: 2.3.1
    88License: GPLv2 or later
    99License URI: http://www.gnu.org/licenses/gpl-2.0.html
    … …  
    2222* A Twilio phone number - either one you've purchased or your [Twilio free trial](https://support.twilio.com/hc/en-us/articles/223136107-How-does-Twilio-s-Free-Trial-work-) number.
    2323* Your unique 'Twilio Account SID' and 'Twilio Auth Token' - you'll enter these details into the Joy Of Text plugin's settings.
    24 
    25 If you're new to Twilio or upgrading your existing account from a trial to full account, you can get $10 credit by using this [referral link](https://www.twilio.com/referral/vDJcVW).
    2624
    2725This free version includes the following features:
    … …  
    159157Please refer to [Twilio's charges](https://www.twilio.com/sms/pricing) for more detail.
    160158
    161 If you're new to Twilio or upgrading your existing account from a trial to full account, you can get $10 credit by using this [referral link](https://www.twilio.com/referral/vDJcVW).
    162 
    163159
    164160= Are other SMS providers supported? =
    … …  
    259255
    260256== Changelog ==
     257= 2.3.1 =
     258* Removed link to Twilio referral scheme, which has now be discontinued by Twilio.
     259* Changed SQL queries to use prepare statements.
    261260
    262261= 2.3.0 =
    … …  
    396395== Upgrade Notice ==
    397396
    398 = 2.3.0 =
    399 * Added Application-to-Person (A2P) registration guidance.
    400 
     397= 2.3.1 =
     398* Removed link to Twilio referral scheme, which has now be discontinued by Twilio.
     399* Changed SQL queries to use prepare statements.
     400
Note: See TracChangeset for help on using the changeset viewer.