Forum Replies Created

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter Zignar

    (@zignar)

    Hi again

    Is there a way I can make this edit become permanent, and survive an update of the plugin? Can it somehow be included in the Child Theme?

    I would be very grateful for a solution.
    Happy New Year

    Thread Starter Zignar

    (@zignar)

    Update… the fix is working (just me mixing up file versions).

    Still a way to permanent this edit would be superb, either through WPCode or Child Theme.

    Thanks!

    Thread Starter Zignar

    (@zignar)

    Dear Codepeople,

    I just updated your excellent plugin calculated-fields-form and now the website editors no longer has access to the plugin. I tried your intrsuction again and edited the file cpcff_main.inc.php but the plugin is still notm displaying to the website editors.

    What can I do??

    Is there a way that I can make the edit permanent?

    Happy New Year!

    Thread Starter Zignar

    (@zignar)

    Thank you!! That did the trick. Very useful.

    Thread Starter Zignar

    (@zignar)

    Hello,

    Thank you for your support. We have been trying to see if by using Microsoft 365 app passwords we can get Postie to connect to Exchange server IMAP or POP3 but without success. We are assuming that Postie uses basic authentication and at this stage it doesn’t support OAuth, or other authentication methods. Is this correct?

    App passwords and basic authentication in general is being discontinued by Microsoft shortly. Do you have plans to adopt other authentications methods in Postie? Such feature will be worth paying for as it will be very difficult to continue with basic authentication going forward.

    Thank you very much for your great work!

    Best

    https://docs.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basic-authentication-exchange-online

    Thread Starter Zignar

    (@zignar)

    Already did that. I am lost here. The mail account seems to work fine. Any other suggestions?

    This is the DEBUG log:

    enabling duplicate comments
    doing postie_session_start
    Starting mail fetch
    WordPress datetime: 2022-09-09 10:19:42
    wp_content_path: /home/fruitbox/domains/fruit-box.se/public_html/wp-content
    OS: Linux prime2.inleed.net 4.18.0-372.9.1.1.lve.el8.x86_64 #1 SMP Tue May 24 07:49:22 EDT 2022 x86_64
    PHP version: 7.4.30
    PHP error_log: 
    PHP log_errors: On
    PHP get_temp_dir: /home/fruitbox/domains/fruit-box.se/public_html/wp-content/uploads/
    PHP disable_functions: exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname
    PHP cURL version: 7.71.0
    PHP Multibyte String support: yes
    MySQL Version: 10.4.25
    MySQL client: mysqli
    Query: SHOW FULL COLUMNS FROM <code>wp_posts</code>
    wp_posts charset: utf8mb4
    WordPress Version: 6.0.2
    WordPress Singlesite
    WP_TEMP_DIR: /home/fruitbox/domains/fruit-box.se/public_html/wp-content/uploads
    WP_HOME: (none)
    home_url(): https://fruit-box.se
    WP_SITEURL: (none)
    site_url(): https://fruit-box.se
    WP_DEBUG: Off
    WP_DEBUG_DISPLAY: On
    WP_DEBUG_LOG: Off
    WP_MAX_MEMORY_LIMIT: 256M (default)
    WP_MEMORY_LIMIT: 40M
    imagick version: 3.5.1
    gd version: 7.4.30
    image editor supported: WP_Image_Editor_Imagick
    WP_Image_Editor_Imagick supports: image/jpeg
    WP_Image_Editor_Imagick supports: image/png
    WP_Image_Editor_Imagick supports: image/gif
    image editor supported: WP_Image_Editor_GD
    WP_Image_Editor_GD supports: image/jpeg
    WP_Image_Editor_GD supports: image/png
    WP_Image_Editor_GD supports: image/gif
    Registered image sizes
    Array
    (
        [0] => thumbnail
        [1] => medium
        [2] => medium_large
        [3] => large
        [4] => 1536x1536
        [5] => 2048x2048
        [6] => et-pb-post-main-image
        [7] => et-pb-post-main-image-fullwidth
        [8] => et-pb-portfolio-image
        [9] => et-pb-portfolio-module-image
        [10] => et-pb-portfolio-image-single
        [11] => et-pb-gallery-module-image-portrait
        [12] => et-pb-post-main-image-fullwidth-large
        [13] => et-pb-image--responsive--desktop
        [14] => et-pb-image--responsive--tablet
        [15] => et-pb-image--responsive--phone
    )
    No registered filters for image_downsize
    No registered filters for wp_handle_upload
    No registered filters for wp_get_attachment_thumb_file
    No registered filters for wp_handle_upload_prefilter
    No registered filters for wp_handle_sideload_prefilter
    No registered filters for pre_move_uploaded_file
    image memory limit: 512M
    DISABLE_WP_CRON: Off
    ALTERNATE_WP_CRON: Off
    WP_CRON_LOCK_TIMEOUT: 60
    iconv: present
    Active plugins
         akismet/akismet.php => 5.0
         litespeed-cache/litespeed-cache.php => 5.2
         post-types-order/post-types-order.php => 1.9.9.1
         postie/postie.php => 1.9.61
         wordfence/wordfence.php => 7.6.0
         wp-mail-smtp/wp_mail_smtp.php => 3.5.2
         wp-optimize/wp-optimize.php => 3.2.7
    Postie is in /home/fruitbox/domains/fruit-box.se/public_html/wp-content/plugins/postie/
    Postie Version: 1.9.61
    POSTIE_DEBUG: On
    No registered filters for postie_filter_email
    No registered filters for postie_filter_email2
    No registered filters for postie_filter_email3
    No registered filters for postie_author
    No registered filters for postie_post_before
    No registered filters for postie_post_after
    No registered filters for postie_file_added
    No registered filters for postie_gallery
    No registered filters for postie_comment_before
    No registered filters for postie_comment_after
    No registered filters for postie_category_default
    Registered filters for postie_log_debug
    Registered filters for postie_log_error
    No registered filters for postie_session_start
    No registered filters for postie_session_end
    No registered filters for postie_preconnect
    No registered filters for postie_post_pre
    No registered filters for postie_email_reject_recipients
    No registered filters for postie_email_notify_recipients
    No registered filters for postie_email_reject_subject
    No registered filters for postie_email_notify_subject
    No registered filters for postie_email_reject_body
    No registered filters for postie_place_media
    No registered filters for postie_place_media_before
    No registered filters for postie_place_media_after
    No registered filters for postie_raw
    No registered filters for postie_bare_link
    No registered filters for postie_category
    No registered filters for postie_file_added_pre
    No registered filters for postie_include_attachment
    default_charset: UTF-8
    DB_CHARSET: utf8
    DB_COLLATE: database default
    WordPress encoding: UTF-8
    memory at start of email processing: 23702336
    postie configuration
    Array
    (
        [add_meta] => no
        [admin_username] => Sv20Pr20
        [allow_html_in_body] => 1
        [allow_html_in_subject] => 1
        [allow_subject_in_mail] => 1
        [audiotemplate] => <a href="{FILELINK}">{FILENAME}</a>
        [audiotypes] => Array
            (
                [0] => m4a
                [1] => mp3
                [2] => ogg
                [3] => wav
                [4] => mpeg
            )
    
        [authorized_addresses] => Array
            (
                [0] => (hidden)
                [1] => (hidden)
                [2] => (hidden)
            )
    
        [banned_files_list] => Array
            (
            )
    
        [confirmation_email] => 
        [convertnewline] => 0
        [converturls] => 1
        [custom_image_field] => 0
        [default_post_category] => 7
        [category_match] => 1
        [default_post_tags] => Array
            (
            )
    
        [default_title] => Live From The Field
        [delete_mail_after_processing] => 1
        [drop_signature] => 1
        [filternewlines] => 1
        [forward_rejected_mail] => 1
        [icon_set] => silver
        [icon_size] => 32
        [auto_gallery] => 0
        [image_new_window] => 
        [image_placeholder] => #img%#
        [images_append] => 1
        [imagetemplate] => <a href="{PAGELINK}"><img src="{MEDIUM}" alt="{CAPTION}" width="{MEDIUMWIDTH}" height="{MEDIUMHEIGHT}" class="alignnone size-medium wp-image-{ID}" /></a>
        [imagetemplates] => Array
            (
                [simple_link] => <a href="{FILELINK}">{FILENAME}</a>
                [no_wrappers] => <a href="{IMAGE}"><img src="{THUMBNAIL}" alt="{CAPTION}" title="{CAPTION}" class="attachment" /></a>
                [wordpress_default] => <a href="{PAGELINK}"><img src="{MEDIUM}" alt="{CAPTION}" width="{MEDIUMWIDTH}" height="{MEDIUMHEIGHT}" class="alignnone size-medium wp-image-{ID}" /></a>
                [thumbnail_left] => <div style="float:left;margin-right:10px;"><a href="{IMAGE}"><img src="{THUMBNAIL}" alt="{CAPTION}" title="{CAPTION}" class="attachment" /></a></div>
                [thumbnail_right] => <div style="float:right;margin-left:10px;"><a href="{IMAGE}"><img src="{THUMBNAIL}" alt="{CAPTION}" title="{CAPTION}" class="attachment" /></a></div>
                [robert_felty] => <div style="margin-right:10px;background:black;color:white;padding:2px; width:{MEDIUMWIDTH};float:left"><a href="{IMAGE}"><img src="{MEDIUM}" alt="{CAPTION}" title="{CAPTION}" class="attachment" /></a><div style="padding:.2em;text-align:left">{CAPTION}</div></div>
                [postie_legacy] => <div class="postie-image-div"><a href="{IMAGE}"><img src="{THUMBNAIL}" alt="{FILENAME}" title="{FILENAME}" style="border:none" class="postie-image" /></a></div>
                [custom] => 
            )
    
        [input_protocol] => imap-ssl
        [input_connection] => sockets
        [interval] => daily
        [mail_server] => outlook.office365.com
        [mail_server_port] => 993
        [mail_userid] => [email protected]
        [maxemails] => 0
        [message_start] => 
        [message_end] => 
        [message_encoding] => UTF-8
        [message_dequote] => 1
        [post_status] => publish
        [prefer_text_type] => plain
        [return_to_sender] => 0
        [role_access] => Array
            (
                [editor] => 1
                [author] => 1
            )
    
        [selected_audiotemplate] => simple_link
        [selected_imagetemplate] => wordpress_default
        [selected_video1template] => vshortcode
        [selected_video2template] => simple_link
        [shortcode] => 
        [sig_pattern_list] => Array
            (
                [0] => --\s?[\r\n]?
                [1] => --\s
                [2] => --
                [3] => ---
            )
    
        [smtp] => Array
            (
            )
    
        [start_image_count_at_zero] => 0
        [supported_file_types] => Array
            (
                [0] => application
            )
    
        [turn_authorization_off] => 0
        [time_offset] => 1
        [video1template] => [video width="568" height="320" {FILETYPE}="{FILELINK}"][/video]
        [video1types] => Array
            (
                [0] => mp4
                [1] => mpeg4
                [2] => 3gp
                [3] => 3gpp
                [4] => 3gpp2
                [5] => 3gp2
                [6] => mov
                [7] => mpeg
                [8] => quicktime
            )
    
        [video2template] => <a href="{FILELINK}">{FILENAME}</a>
        [video2types] => Array
            (
                [0] => x-flv
            )
    
        [video1templates] => Array
            (
                [simple_link] => <a href="{FILELINK}">{FILENAME}</a>
                [small] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="128"height="96"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="128" height="96"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="128" height="110" scale="tofit"></embed> </object>
                [medium] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="320"height="240"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="320" height="240"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="320" height="260" scale="tofit"></embed> </object>
                [medium_widescreen] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="480"height="270"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="480" height="270"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="480" height="290" scale="tofit"></embed> </object>
                [large] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="480"height="360"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="480" height="360"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="480" height="380" scale="tofit"></embed> </object>
                [large_widescreen] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="640"height="360"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="640" height="360"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="640" height="380" scale="tofit"></embed> </object>
                [vshortcode] => [video width="568" height="320" {FILETYPE}="{FILELINK}"][/video]
                [custom] => 
            )
    
        [video2templates] => Array
            (
                [simple_link] => <a href="{FILELINK}">{FILENAME}</a>
                [small] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="128"height="96"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="128" height="96"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="128" height="110"></embed> </object>
                [medium] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="320"height="240"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="320" height="240"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="320" height="260"></embed> </object>
                [medium_widescreen] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="480"height="270"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="480" height="270"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="480" height="290"></embed> </object>
                [large] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="480"height="360"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="480" height="360"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="480" height="380"></embed> </object>
                [large_widescreen] => <object classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="https://www.apple.com/qtactivex/qtplugin.cab" width="640"height="360"> <param name="src" value="{FILELINK}" /> <param name="autoplay" value="no" /> <param name="controller" value="true" /> <embed src="{FILELINK}" width="640" height="360"autoplay="no" controller="true" type="video/quicktime" pluginspage="https://www.apple.com/quicktime/download/" width="640" height="380"></embed> </object>
                [flv_embed] => [flv:{FILELINK} 480 270]
                [custom] => 
            )
    
        [wrap_pre] => no
        [featured_image] => 0
        [include_featured_image] => 1
        [email_tls] => 
        [post_format] => standard
        [post_type] => post
        [generaltemplates] => Array
            (
                [postie_default] => <a href="{FILELINK}">{ICON} {FILENAME}</a>
                [simple_link] => <a href="{FILELINK}">{FILENAME}</a>
                [custom] => 
            )
    
        [generaltemplate] => <a href="{FILELINK}">{ICON} {FILENAME}</a>
        [selected_generaltemplate] => postie_default
        [generate_thumbnails] => 1
        [reply_as_comment] => 1
        [force_user_login] => 0
        [auto_gallery_link] => Default
        [ignore_mail_state] => 
        [strip_reply] => 1
        [postie_log_error] => 1
        [postie_log_debug] => 1
        [category_colon] => 1
        [category_dash] => 1
        [category_bracket] => 1
        [prefer_text_convert] => 1
        [category_remove] => 1
        [ignore_email_date] => 1
        [use_time_offset] => 0
        [postie_log_error_notify] => (All Admins)
        [image_resize] => 1
        [duplicate_comments] => 1
        [legacy_commands] => 1
    )
    fetch_mail: Connecting to outlook.office365.com:993 (imap-ssl)
    pConnection: mailbox: INBOX
    Connecting via Socket
    Socket: tls://outlook.office365.com:993
    Socket error: 0 -  (Resource id #224)
    Socket: IMAP
    socket write: A0001 CAPABILITY
    socket read (3) :* OK The Microsoft Exchange IMAP4 service is ready. [RwBWADMAUAAyADgAMABDAEEAMAAwADYAMwAuAFMAVwBFAFAAMgA4ADAALgBQAFIATwBEAC4ATwBVAFQATABPAE8ASwAuAEMATwBNAA==]
    socket write: (login) LOGIN/APOP/PASS
    socket read (1) :A0002 NO LOGIN failed.
    fetch_mail: IMAP - Could not connect to IMAP server outlook.office365.com on port 993. Array
    (
        [0] => A0002 NO LOGIN failed.
    )
    doing postie_session_end
    memory at end of email processing: 23713480
    Query: UPDATE <code>wp_options</code> SET <code>option_value</code> = '1662715243' WHERE <code>option_name</code> = 'action_scheduler_lock_async-request-runner'
    Query: SELECT COUNT(DISTINCT claim_id) FROM wp_actionscheduler_actions WHERE claim_id != 0 AND status IN ( 'pending', 'in-progress')
    Query: SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN ('pending') AND a.scheduled_date_gmt <= '2022-09-09 09:19:43' LIMIT 0, 5
    Query: SELECT *, CASE 
    WHEN <code>type</code> = 3 THEN 0
    WHEN <code>type</code> = 4 THEN 1
    WHEN <code>type</code> = 7 THEN 2
    WHEN <code>type</code> = 6 THEN 3
    WHEN <code>type</code> = 5 THEN 4
    WHEN <code>type</code> = 9 THEN 5
    WHEN <code>type</code> = 8 THEN 6
    WHEN <code>type</code> = 2 THEN 7
    WHEN <code>type</code> = 1 THEN 8
    ELSE 9999
    END AS <code>typeSort</code>, CASE 
    WHEN <code>type</code> = 3 THEN <code>parameters</code>
    WHEN <code>type</code> = 4 THEN <code>parameters</code>
    WHEN <code>type</code> = 1 THEN <code>IP</code>
    WHEN <code>type</code> = 9 THEN <code>IP</code>
    WHEN <code>type</code> = 5 THEN <code>IP</code>
    WHEN <code>type</code> = 6 THEN <code>IP</code>
    WHEN <code>type</code> = 7 THEN <code>IP</code>
    WHEN <code>type</code> = 2 THEN <code>IP</code>
    WHEN <code>type</code> = 8 THEN <code>IP</code>
    ELSE 9999
    END AS <code>detailSort</code>
     FROM <code>wp_wfblocks7</code> WHERE <code>type</code> IN (4) AND (<code>expiration</code> = 0 OR <code>expiration</code> > UNIX_TIMESTAMP()) ORDER BY <code>typeSort</code> ASC, <code>id</code> DESC
    Query: SELECT *, CASE 
    WHEN <code>type</code> = 3 THEN 0
    WHEN <code>type</code> = 4 THEN 1
    WHEN <code>type</code> = 7 THEN 2
    WHEN <code>type</code> = 6 THEN 3
    WHEN <code>type</code> = 5 THEN 4
    WHEN <code>type</code> = 9 THEN 5
    WHEN <code>type</code> = 8 THEN 6
    WHEN <code>type</code> = 2 THEN 7
    WHEN <code>type</code> = 1 THEN 8
    ELSE 9999
    END AS <code>typeSort</code>, CASE 
    WHEN <code>type</code> = 3 THEN <code>parameters</code>
    WHEN <code>type</code> = 4 THEN <code>parameters</code>
    WHEN <code>type</code> = 1 THEN <code>IP</code>
    WHEN <code>type</code> = 9 THEN <code>IP</code>
    WHEN <code>type</code> = 5 THEN <code>IP</code>
    WHEN <code>type</code> = 6 THEN <code>IP</code>
    WHEN <code>type</code> = 7 THEN <code>IP</code>
    WHEN <code>type</code> = 2 THEN <code>IP</code>
    WHEN <code>type</code> = 8 THEN <code>IP</code>
    ELSE 9999
    END AS <code>detailSort</code>
     FROM <code>wp_wfblocks7</code> WHERE <code>type</code> IN (3) AND (<code>expiration</code> = 0 OR <code>expiration</code> > UNIX_TIMESTAMP()) ORDER BY <code>typeSort</code> ASC, <code>id</code> DESC
    Query: SELECT *, CASE 
    WHEN <code>type</code> = 3 THEN 0
    WHEN <code>type</code> = 4 THEN 1
    WHEN <code>type</code> = 7 THEN 2
    WHEN <code>type</code> = 6 THEN 3
    WHEN <code>type</code> = 5 THEN 4
    WHEN <code>type</code> = 9 THEN 5
    WHEN <code>type</code> = 8 THEN 6
    WHEN <code>type</code> = 2 THEN 7
    WHEN <code>type</code> = 1 THEN 8
    ELSE 9999
    END AS <code>typeSort</code>, CASE 
    WHEN <code>type</code> = 3 THEN <code>parameters</code>
    WHEN <code>type</code> = 4 THEN <code>parameters</code>
    WHEN <code>type</code> = 1 THEN <code>IP</code>
    WHEN <code>type</code> = 9 THEN <code>IP</code>
    WHEN <code>type</code> = 5 THEN <code>IP</code>
    WHEN <code>type</code> = 6 THEN <code>IP</code>
    WHEN <code>type</code> = 7 THEN <code>IP</code>
    WHEN <code>type</code> = 2 THEN <code>IP</code>
    WHEN <code>type</code> = 8 THEN <code>IP</code>
    ELSE 9999
    END AS <code>detailSort</code>
     FROM <code>wp_wfblocks7</code> WHERE <code>type</code> IN (1, 8, 9, 2, 5, 6) AND (<code>expiration</code> = 0 OR <code>expiration</code> > UNIX_TIMESTAMP()) ORDER BY <code>typeSort</code> ASC, <code>id</code> DESC
    Query: SELECT *, CASE 
    WHEN <code>type</code> = 3 THEN 0
    WHEN <code>type</code> = 4 THEN 1
    WHEN <code>type</code> = 7 THEN 2
    WHEN <code>type</code> = 6 THEN 3
    WHEN <code>type</code> = 5 THEN 4
    WHEN <code>type</code> = 9 THEN 5
    WHEN <code>type</code> = 8 THEN 6
    WHEN <code>type</code> = 2 THEN 7
    WHEN <code>type</code> = 1 THEN 8
    ELSE 9999
    END AS <code>typeSort</code>, CASE 
    WHEN <code>type</code> = 3 THEN <code>parameters</code>
    WHEN <code>type</code> = 4 THEN <code>parameters</code>
    WHEN <code>type</code> = 1 THEN <code>IP</code>
    WHEN <code>type</code> = 9 THEN <code>IP</code>
    WHEN <code>type</code> = 5 THEN <code>IP</code>
    WHEN <code>type</code> = 6 THEN <code>IP</code>
    WHEN <code>type</code> = 7 THEN <code>IP</code>
    WHEN <code>type</code> = 2 THEN <code>IP</code>
    WHEN <code>type</code> = 8 THEN <code>IP</code>
    ELSE 9999
    END AS <code>detailSort</code>
     FROM <code>wp_wfblocks7</code> WHERE <code>type</code> IN (7) AND (<code>expiration</code> = 0 OR <code>expiration</code> > UNIX_TIMESTAMP()) ORDER BY <code>typeSort</code> ASC, <code>id</code> DESC
    • This reply was modified 2 years, 2 months ago by Zignar.
    Thread Starter Zignar

    (@zignar)

    Thanks for your quick response.
    I will play around with it and see what I can find.
    kind regards
    S

    • This reply was modified 2 years, 4 months ago by Zignar.
Viewing 7 replies - 1 through 7 (of 7 total)