Setting post_id for single.php based on URL without a redirect

I figured it out, here is the solution for anyone else wondering how to do something like this:

function force_ID($query) {
 global $wpdb;
 if (substr($_SERVER['REQUEST_URI'],-5) == '.html') {
    $post_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE post_name=%s AND post_status="publish"",substr(basename($_SERVER['REQUEST_URI']),0,-5)));
    if ($post_id > 0) $query->set('page_id',$post_id);
 }
}
add_action('pre_get_posts','force_ID');

In examining the wp-includes/query.php file, I noticed that the object accepts page_id to exclusively select an ID. Using post_id worked for archive post loops, but page_id worked for a single post call.

Related Posts:

  1. What is the Difference between directly call a function and call a function using add_action?
  2. WordPress class, using add_action to call member function does not work
  3. Call to undefined function is_home() or any conditional tags
  4. Adding tables to dashboard pages programmatically?
  5. wp_ajax add_action fuction won’t fire on custom jQuery action
  6. How to add user details to different tables immediately after user registration
  7. How to filter content for specific content variable
  8. pre_get_post alter current post id
  9. mysql_real_escape_string() vs. esc_sql() in WordPress
  10. load_plugin_textdomain doestn’t work with add_action plugins_loaded
  11. Show error message after exception handled
  12. I have 2 plugins using the same wp_login action hook and one is not working
  13. WordPress function get_the_terms() returns ‘Invalid taxonomy’ error
  14. Checking for existence of a page by title?
  15. Valid filenames for add_action’s first parameter
  16. how to get context information inside my funcion
  17. Where do I put my add_action(… and add_filter(… and do I need to remove them?
  18. How dynamic action login_form_{action} is working
  19. How to modify files inside wp-includes directory in wordpress
  20. Fatal error: Call to a member function get_page_permastruct() on a non-object
  21. wp_get_post_terms Order by not working
  22. What action hook can I use to add a JavaScript to a page post using a theme template that is not including get_header() nor get_footer()?
  23. How to get all queries’s results after they have executed?
  24. Function/Class to list categories with checkboxes
  25. wp_get_theme Warning: Illegal offset type
  26. Bug: Post needs to be updated twice when adding action for save_post hook
  27. Delete data from database using row action
  28. Why wp_die() doesn’t work with wp_redirect but exit() works
  29. When does save_post hook fire on post save/update
  30. Warning: call_user_func_array() expects parameter 1 to be a valid callback
  31. Print Dashboard submenu name and filename
  32. Autogenerate a Table of Contents
  33. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  34. how to get the post id in plugin
  35. A question about add_action()
  36. WordPress multisite,use same cookies across all website?
  37. Apply styles to blockquote element with the WYSIWYG editor
  38. Hook add_attachment error
  39. unregister_setting() vs delete_option() for plugin update
  40. How to change WooCommerce loop product title HTML output in single product page and archive page
  41. How to output functions from plugin inside theme
  42. wp_schedule_event is registered but function isn’t running
  43. How to find list of all functions bind to a particular hook from my plugin?
  44. Can I Hook Into the TinyMCE Insert/Edit Link Button to Use Shortlink For Post?
  45. Include HTML (Bootstrap Modal Box) with a plugin into my header
  46. Overwriting a plugin function
  47. wordpress automatic update does not run
  48. Writing editor content to a file
  49. Using init hook for register_taxonomy is causing invalid_taxonomy in wp_insert_term()
  50. Remove Permalink Meta Box not working?
  51. How Can I Add Code To A Preexisting Function Without Editing it
  52. using admin functions on frontend
  53. Javascript Function Called Too Early in PHP Script
  54. Modify code for functions.php with specific twitter user url and hashtags
  55. can’t access some WordPress function from my plugin
  56. WP 3-way voting system: On to something! Please help!
  57. Custom Settings Plugin Save foreach checkboxes
  58. Customise Grouped Product display in Woocommerce with custom column
  59. Change the behaviour of a button
  60. How to do admin ajax request in a plugin for rest api
  61. Action / Hook when a new plugin is added
  62. apply_filters() and call_user_func() to define and call a function outside a class
  63. Can someone explain what’s the use of parse request function in WordPress?
  64. Add default value from selection
  65. function add custom fields to media gallery
  66. Override category archive page title (not the head title)
  67. Where do I hook to have the server do something in PHP on block attribute change?
  68. The function called on the wp head hook becomes null
  69. Make visible page only in the trash
  70. Redirection from a specific page for users logged in but not with membership
  71. WordPress: I wanted to use Add rewrite rule multiple times for multiple CPT in my plugin
  72. Why would one specify multiple arguments when using get_previous_posts_link() which takes only one parameter?
  73. I cant add is_admin control to plugin
  74. WordPress Ajax not returning Response
  75. ajax-action.php can’t find added action
  76. Post is uncatagorized in publish_post action
  77. How to show only specific category post by user role without plugin and restrict all other cats
  78. Does hooking into a plugin action / filter override the plugin’s function for that hook?
  79. WordPress Plugin Boilerplate – add actions and/or filters based on user’s role
  80. do_action from within a class does not seem to work
  81. Remove tag from all posts when publishing new post
  82. WordPress plugin how to run function when button is clicked
  83. remove different admin menu for specific users
  84. WordPress Reset password Strength set to medium
  85. Add function to Dokan ajax class
  86. foreach argument to get specific file types getting too many returns
  87. add_option_{$option} action hook not being called
  88. Remove from a div by class name from post page if post author role is not administrator
  89. Function not working on any file other than the main plugin file
  90. Building WordPress Themes With Bootstrap with Adi Purdila → TutsPlus
  91. Does WordPress have something like timer hook?
  92. Ajax not working to insert, query and result data
  93. Associating special meaning with user id 0
  94. action callback, for action dispatched as reported by hook sniffer, not called
  95. Template file structure , wordpress hook for altering the template
  96. WordPress permalink setting
  97. How can I see a varibles value when my plugin runs?
  98. How can I set a dynamic value for post_updated_messages based on return value of post_updated?
  99. How can I add recent posts to menu like mashable
  100. How to use get_pages( ) correctly with ‘child_of’ to replace page with child page
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)