Plugin Directory


Ignore:
Timestamp:
11/02/2023 06:49:06 AM (18 months ago)
Author:
storeapps
Message:

Preparing for 9.1.0 release

Location:
news-announcement-scroll/trunk
Files:
7 edited

Legend:

Unmodified
Added
Removed
  • news-announcement-scroll/trunk/gAnnounce/gAnnounce.php

    r2818951 r2987837  
    1010
    1111$gNewsAnnouncementtype = get_option( 'gNewsAnnouncementtype' );
    12 $sSql                  = 'SELECT * from ' . WP_G_NEWS_ANNOUNCEMENT . " where gNews_status='Yes'";
    13 $sSql                  = $sSql . " and (`gNews_date` <= NOW() or `gNews_date` = '0000-00-00')";
    14 $sSql                  = $sSql . " and (`gNews_expiration` >= NOW() or `gNews_expiration` = '0000-00-00')";
     12$gNewsAnnouncementtype = ! empty( $gNewsAnnouncementtype ) ? esc_sql( $gNewsAnnouncementtype ) : '';
     13$gNewsAnnouncementorder = get_option( 'gNewsAnnouncementorder' );
    1514
    16 if ( $gNewsAnnouncementtype != '' ) {
    17     $sSql = $sSql . " and gNews_type='" . $gNewsAnnouncementtype . "'";
    18 }
    19 
    20 if ( get_option( 'gNewsAnnouncementorder' ) == '1' ) {
    21     $sSql = $sSql . ' ORDER BY rand( )';
    22 } else {
    23     $sSql = $sSql . ' ORDER BY gNews_order';
    24 }
     15$sSql = $wpdb->prepare(
     16        "SELECT * FROM " . WP_G_NEWS_ANNOUNCEMENT . "
     17        WHERE gNews_status = %s
     18        AND (`gNews_date` <= NOW() OR `gNews_date` = %s)
     19        AND (`gNews_expiration` >= NOW() OR `gNews_expiration` = %s)
     20        " . ($gNewsAnnouncementtype ? "AND `gNews_type` = '{$gNewsAnnouncementtype}'" : '') . "
     21        ORDER BY " . ('1' == $gNewsAnnouncementorder ? 'RAND()' : 'gNews_order'),
     22        'Yes',
     23        '0000-00-00',
     24        '0000-00-00'
     25);
    2526
    2627$data = $wpdb->get_results( $sSql );
  • news-announcement-scroll/trunk/languages/news-announcement-scroll.pot

    r2818951 r2987837  
    1 # Copyright (C) 2022 StoreApps
    2 # This file is distributed under the same license as the News Announcement Scroll plugin.
     1# Copyright (C) 2023 StoreApps
     2# This file is distributed under the GNU General Public License v3.0.
    33msgid ""
    44msgstr ""
    5 "Project-Id-Version: News Announcement Scroll 9.0.0\n"
     5"Project-Id-Version: News Announcement Scroll 9.1.0\n"
    66"Report-Msgid-Bugs-To: https://wordpress.org/support/plugin/news-announcement-scroll\n"
    77"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
     
    1010"Content-Type: text/plain; charset=UTF-8\n"
    1111"Content-Transfer-Encoding: 8bit\n"
    12 "POT-Creation-Date: 2022-11-16T17:41:31+05:30\n"
     12"POT-Creation-Date: 2023-11-02T11:58:50+05:30\n"
    1313"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
    14 "X-Generator: WP-CLI 2.1.0\n"
     14"X-Generator: WP-CLI 2.7.1\n"
    1515"X-Domain: news-announcement-scroll\n"
    1616
     
    4343msgstr ""
    4444
     45#: news-announcement-scroll.php:328
     46msgid "View News Announcement Scroll Settings"
     47msgstr ""
     48
     49#: news-announcement-scroll.php:328
     50msgid "Settings"
     51msgstr ""
     52
    4553#: news-announcement-scroll.php:329
    46 msgid "View News Announcement Scroll Settings"
     54msgid "Documentation"
    4755msgstr ""
    4856
    4957#: news-announcement-scroll.php:329
    50 msgid "Settings"
    51 msgstr ""
    52 
    53 #: news-announcement-scroll.php:330
    54 msgid "Documentation"
    55 msgstr ""
    56 
    57 #: news-announcement-scroll.php:330
    5858msgid "Docs"
    5959msgstr ""
     
    9494#: pages/content-management-edit.php:117
    9595#: pages/content-management-show.php:63
    96 #: pages/content-setting.php:14
     96#: pages/content-setting.php:13
    9797msgid "Widget Settings"
    9898msgstr ""
     
    101101#: pages/content-management-edit.php:118
    102102#: pages/content-management-show.php:64
    103 #: pages/content-setting.php:16
     103#: pages/content-setting.php:15
    104104msgid "Help"
    105105msgstr ""
     
    140140msgstr ""
    141141
    142 #: pages/content-management-add.php:154
     142#: pages/content-management-add.php:152
    143143#: pages/content-management-edit.php:181
    144144msgid "This is to group the news. Select your news group."
    145145msgstr ""
    146146
    147 #: pages/content-management-add.php:156
     147#: pages/content-management-add.php:154
    148148#: pages/content-management-edit.php:183
    149149#: pages/content-management-show.php:87
     
    152152msgstr ""
    153153
    154 #: pages/content-management-add.php:158
     154#: pages/content-management-add.php:156
    155155#: pages/content-management-edit.php:185
    156156msgid "Please enter the news publish date in this format YYYY-MM-DD."
    157157msgstr ""
    158158
    159 #: pages/content-management-add.php:160
     159#: pages/content-management-add.php:158
    160160#: pages/content-management-edit.php:187
    161161msgid "Expiration date"
    162162msgstr ""
    163163
    164 #: pages/content-management-add.php:162
     164#: pages/content-management-add.php:160
    165165msgid "Please enter the expiration date in this format YYYY-MM-DD <br /> 9999-12-30 : Is equal to no expire."
    166166msgstr ""
    167167
    168 #: pages/content-management-add.php:167
     168#: pages/content-management-add.php:165
     169#: pages/content-setting.php:252
     170msgid "Save"
     171msgstr ""
     172
     173#: pages/content-management-add.php:166
     174#: pages/content-management-edit.php:195
    169175#: pages/content-setting.php:253
    170 msgid "Save"
    171 msgstr ""
    172 
    173 #: pages/content-management-add.php:168
    174 #: pages/content-management-edit.php:195
    175 #: pages/content-setting.php:254
    176176msgid "Cancel"
    177177msgstr ""
    178178
    179 #: pages/content-management-edit.php:24
     179#: pages/content-management-edit.php:26
    180180#: pages/content-management-show.php:29
    181181msgid "Oops, selected details doesnt exist."
     
    268268msgstr ""
    269269
    270 #: pages/content-setting.php:15
     270#: pages/content-setting.php:14
    271271msgid "Add New News"
    272272msgstr ""
    273273
    274 #: pages/content-setting.php:71
     274#: pages/content-setting.php:70
    275275msgid "Details successfully updated."
    276276msgstr ""
    277277
    278 #: pages/content-setting.php:80
     278#: pages/content-setting.php:79
    279279msgid "Title"
    280280msgstr ""
    281281
    282 #: pages/content-setting.php:82
     282#: pages/content-setting.php:81
    283283msgid "This title is only for widget."
    284284msgstr ""
    285285
    286 #: pages/content-setting.php:84
    287 #: pages/content-setting.php:121
     286#: pages/content-setting.php:83
     287#: pages/content-setting.php:120
    288288msgid "Text alignment"
    289289msgstr ""
    290290
    291 #: pages/content-setting.php:111
     291#: pages/content-setting.php:110
    292292msgid "Horizontal alignment of the news."
    293293msgstr ""
    294294
    295 #: pages/content-setting.php:113
     295#: pages/content-setting.php:112
    296296msgid "Width"
    297297msgstr ""
    298298
    299 #: pages/content-setting.php:115
     299#: pages/content-setting.php:114
    300300msgid "Enter widget width, only number"
    301301msgstr ""
    302302
    303 #: pages/content-setting.php:117
     303#: pages/content-setting.php:116
    304304msgid "Font family"
    305305msgstr ""
    306306
    307 #: pages/content-setting.php:119
     307#: pages/content-setting.php:118
    308308msgid "Enter news font family name, Example: verdana, arial, sans-serif"
    309309msgstr ""
    310310
    311 #: pages/content-setting.php:142
     311#: pages/content-setting.php:141
    312312msgid "Vertical alignment of the news."
    313313msgstr ""
    314314
    315 #: pages/content-setting.php:144
     315#: pages/content-setting.php:143
    316316msgid "Height"
    317317msgstr ""
    318318
    319 #: pages/content-setting.php:146
     319#: pages/content-setting.php:145
    320320msgid "Enter widget height, only number"
    321321msgstr ""
    322322
    323 #: pages/content-setting.php:148
     323#: pages/content-setting.php:147
    324324msgid "Announcement display order"
    325325msgstr ""
    326326
    327 #: pages/content-setting.php:163
     327#: pages/content-setting.php:162
    328328msgid "Display order: It means display as per order option. Random order: It means random order."
    329329msgstr ""
    330330
    331 #: pages/content-setting.php:167
     331#: pages/content-setting.php:166
    332332msgid "Font size"
    333333msgstr ""
    334334
    335 #: pages/content-setting.php:169
     335#: pages/content-setting.php:168
    336336msgid "News font size, Example: 13px."
    337337msgstr ""
    338338
    339 #: pages/content-setting.php:171
     339#: pages/content-setting.php:170
    340340msgid "Font color"
    341341msgstr ""
    342342
    343 #: pages/content-setting.php:173
     343#: pages/content-setting.php:172
    344344msgid "News font color, Example: #000000."
    345345msgstr ""
    346346
    347 #: pages/content-setting.php:175
     347#: pages/content-setting.php:174
    348348msgid "Slide direction"
    349349msgstr ""
    350350
    351 #: pages/content-setting.php:190
     351#: pages/content-setting.php:189
    352352msgid "Select your slide direction"
    353353msgstr ""
    354354
    355 #: pages/content-setting.php:192
     355#: pages/content-setting.php:191
    356356msgid "Font weight"
    357357msgstr ""
    358358
    359 #: pages/content-setting.php:207
     359#: pages/content-setting.php:206
    360360msgid "Select font weight."
    361361msgstr ""
    362362
    363 #: pages/content-setting.php:209
     363#: pages/content-setting.php:208
    364364msgid "No announcement text"
    365365msgstr ""
    366366
    367 #: pages/content-setting.php:211
     367#: pages/content-setting.php:210
    368368msgid "Text to show if no news/announcement available in the database."
    369369msgstr ""
    370370
    371 #: pages/content-setting.php:213
     371#: pages/content-setting.php:212
    372372msgid "Slide timeout"
    373373msgstr ""
    374374
    375 #: pages/content-setting.php:215
     375#: pages/content-setting.php:214
    376376msgid "1000 = 1 second."
    377377msgstr ""
    378378
    379 #: pages/content-setting.php:217
     379#: pages/content-setting.php:216
    380380msgid "News Group"
    381381msgstr ""
    382382
    383 #: pages/content-setting.php:248
     383#: pages/content-setting.php:247
    384384msgid "Select your news group to display (This option is available in add/edit news page)."
    385385msgstr ""
  • news-announcement-scroll/trunk/news-announcement-scroll.php

    r2818951 r2987837  
    44 * Plugin URI: https://www.storeapps.org/product/news-announcement-scroll/
    55 * Description: A simple vertical scroll news widget for your WordPress website. Easy to use & no coding knowledge required.
    6  * Version: 9.0.0
     6 * Version: 9.1.0
    77 * Author: StoreApps
    88 * Author URI: https://www.storeapps.org/
     
    1515 * License: GNU General Public License v3.0
    1616 * License URI: http://www.gnu.org/licenses/gpl-3.0.html
    17  * Copyright (c) 2015-2022 StoreApps. All rights reserved.
     17 * Copyright (c) 2015-2023 StoreApps. All rights reserved.
    1818 */
    1919
     
    243243    }
    244244
    245     $gNewsAnnouncementtype = $atts['group'];
    246 
    247     $sSql = 'SELECT * from ' . WP_G_NEWS_ANNOUNCEMENT . " where gNews_status='YES'";
    248     $sSql = $sSql . " and (`gNews_date` <= NOW() or `gNews_date` = '0000-00-00')";
    249     $sSql = $sSql . " and (`gNews_expiration` >= NOW() or `gNews_expiration` = '0000-00-00')";
    250 
    251     if ( $gNewsAnnouncementtype != '' ) {
    252         $sSql = $sSql . " and gNews_type='" . $gNewsAnnouncementtype . "'";
    253     }
    254 
    255     if ( get_option( 'gNewsAnnouncementorder' ) == '1' ) {
    256         $sSql = $sSql . ' ORDER BY rand()';
    257     } else {
    258         $sSql = $sSql . ' ORDER BY gNews_order';
    259     }
    260 
    261     $data = $wpdb->get_results( $sSql );
     245    $gNewsAnnouncementtype = ! empty( $atts['group'] ) ? esc_sql( $atts['group'] ) : '';
     246    $gNewsAnnouncementorder = get_option( 'gNewsAnnouncementorder' );
     247
     248    $sSql = $wpdb->prepare(
     249        "SELECT * FROM " . WP_G_NEWS_ANNOUNCEMENT . "
     250        WHERE gNews_status = %s
     251        AND (`gNews_date` <= NOW() OR `gNews_date` = %s)
     252        AND (`gNews_expiration` >= NOW() OR `gNews_expiration` = %s)
     253        " . ($gNewsAnnouncementtype ? "AND `gNews_type` = '{$gNewsAnnouncementtype}'" : '') . "
     254        ORDER BY " . ('1' == $gNewsAnnouncementorder ? 'RAND()' : 'gNews_order'),
     255        'Yes',
     256        '0000-00-00',
     257        '0000-00-00'
     258    );
     259
     260    $data = $wpdb->get_results($sSql);
    262261
    263262    $nas = $nas . '<script language="JavaScript" type="text/javascript">';
  • news-announcement-scroll/trunk/pages/content-management-add.php

    r2818951 r2987837  
    124124            <select name="gNews_type" id="gNews_type">
    125125                <?php
    126                     $sSql             = 'SELECT distinct(gNews_type) as gNews_type FROM `' . WP_G_NEWS_ANNOUNCEMENT . '` order by gNews_type';
     126                    $sSql             = $wpdb->prepare( 'SELECT DISTINCT(gNews_type) as gNews_type FROM `' . WP_G_NEWS_ANNOUNCEMENT . '` WHERE 1 = %s ORDER BY gNews_type', 1 );
    127127                    $myDistinctData   = array();
    128128                    $arrDistinctDatas = array();
     
    136136
    137137                for ( $j = $i; $j < $i + 5; $j++ ) {
    138 
    139138                    $arrDistinctData[ $j ]['gNews_type'] = 'GROUP' . $j;
    140139                }
    141140
    142                     $arrDistinctData[ $j + 1 ]['gNews_type'] = 'WIDGET';
    143                     $arrDistinctData[ $j + 2 ]['gNews_type'] = 'SAMPLE';
    144                     $arrDistinctDatas                        = array_unique( $arrDistinctData, SORT_REGULAR );
     141                $arrDistinctData[ $j + 1 ]['gNews_type'] = 'WIDGET';
     142                $arrDistinctData[ $j + 2 ]['gNews_type'] = 'SAMPLE';
     143                $arrDistinctDatas                        = array_unique( $arrDistinctData, SORT_REGULAR );
    145144
    146145                foreach ( $arrDistinctDatas as $arrDistinct ) {
    147 
    148146                    ?>
    149                         <option value='<?php echo $arrDistinct['gNews_type']; ?>'><?php echo $arrDistinct['gNews_type']; ?></option>
    150                                                   <?php
     147                    <option value='<?php echo $arrDistinct['gNews_type']; ?>'><?php echo $arrDistinct['gNews_type']; ?></option>
     148                    <?php
    151149                }
    152150                ?>
  • news-announcement-scroll/trunk/pages/content-management-edit.php

    r2818951 r2987837  
    3232
    3333        $sSql = $wpdb->prepare(
    34             '
    35             SELECT *
     34            'SELECT *
    3635            FROM `' . WP_G_NEWS_ANNOUNCEMENT . '`
    3736            WHERE `gNews_id` = %d
    38             LIMIT 1
    39             ',
     37            LIMIT 1',
    4038            array( $did )
    4139        );
     
    154152            <select name="gNews_type" id="gNews_type">
    155153                <?php
    156                 $sSql             = 'SELECT distinct(gNews_type) as gNews_type FROM `' . WP_G_NEWS_ANNOUNCEMENT . '` order by gNews_type';
     154                $sSql             = $wpdb->prepare( 'SELECT DISTINCT(gNews_type) as gNews_type FROM `' . WP_G_NEWS_ANNOUNCEMENT . '` WHERE 1 = %s ORDER BY gNews_type', 1 );
    157155                $myDistinctData   = array();
    158156                $arrDistinctDatas = array();
  • news-announcement-scroll/trunk/pages/content-setting.php

    r2818951 r2987837  
    218218                            <?php
    219219                            $selected         = '';
    220                             $sSql             = 'SELECT distinct(gNews_type) as gNews_type FROM `' . WP_G_NEWS_ANNOUNCEMENT . '` order by gNews_type';
     220                            $sSql             = $wpdb->prepare( 'SELECT DISTINCT(gNews_type) as gNews_type FROM `' . WP_G_NEWS_ANNOUNCEMENT . '` WHERE 1 = %s ORDER BY gNews_type', 1 );
    221221                            $myDistinctData   = array();
    222222                            $arrDistinctDatas = array();
  • news-announcement-scroll/trunk/readme.txt

    r2818951 r2987837  
    77Tested up to: 5.5.3
    88Requires PHP: 5.6.0
    9 Stable tag: 9.0.0
     9Stable tag: 9.1.0
    1010License: GPLv3
    1111
     
    150150== Changelog ==
    151151
     152= 9.1.0 (02-11-2023) =
     153
     154* New: Strengthen security [Thanks to: Wordfence]
     155* Update: POT file
     156
    152157= 9.0.0 (16-11-2022) =
    153158
     
    232237== Upgrade Notice ==
    233238
     239= 9.1.0 (02-11-2023) =
     240
     241* New: Strengthen security [Thanks to: Wordfence]
     242* Update: POT file
     243
    234244= 9.0.0 (16-11-2022) =
    235245
Note: See TracChangeset for help on using the changeset viewer.