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 can you check if you are in a particular page in the WP Admin section? For example how can I check if I am in the Users > Your Profile page?
  7. How to override existing plugin action with new action
  8. Which hook should be used to add an action containing a redirect?
  9. Why does WordPress add 0 (zero) to an Ajax response?
  10. WordPress Update Plugin Hook/Action? Since 3.9
  11. function deactivate_plugins does not exist
  12. Understanding WordPress functions’ naming conventions
  13. add_action with a class method is causing fatal errors
  14. Do I need to call do_action in my plugin?
  15. How Do I Load My Action Earlier Enough?
  16. Which to use to execute code during the saving of a plugin settings page?
  17. How do I Make a Theme “plugin-ready”?
  18. A Post is saved twice or more during add_action(save_post)
  19. How can i list current author’s categories?
  20. How to use filter hook ‘post_updated_messages’ in coherence with action hook ‘save_post’
  21. Is it possible to create an action hook using do_action() within add_action()?
  22. Change of query var in pre_get_posts not maintained
  23. When is it too late to call the action wp_enqueue_scripts?
  24. Dynamically Override Fancy Title
  25. Odd behaviour with submenu link creation
  26. Problems with removing admin bar
  27. Problem with `wp_mail()`
  28. Calling a function from functions.php in custom page/ blog post
  29. Call to undefined function get_blog_option()
  30. Plugin development: is adding empty index.php files necessary?
  31. Undefined function wp_set_password
  32. Create a plugin to change the action to which a function is hooked
  33. Plugin Uninstall and Deactivate via Options Menu
  34. admin_notices not displaying in plugin
  35. How can I add a CSS rule to edit.php?
  36. Widget update function not saving values
  37. Getting admin notices working for plugin errors
  38. Which are the hooks run before/after when a category’s deletion?
  39. add more custom post types and custom role to the code
  40. How to use WP_Term with (menu) argument in the wp_nav_menu?
  41. WordPress after content Hook & external template part
  42. override pluggable.php functions
  43. An echo line in a transition_post_status action leads to “cannot modify header information – headers already sent by”
  44. Namespaced action and filter tags
  45. creating custom function to log actions in plugin
  46. Adding Default Settings to Theme My Login plugin
  47. add_rewrite_rule works in themes function php but when moved into plugin it stops working
  48. Maximum lifetime for nonce
  49. Where can i find wordpress auto update code flows?
  50. Adding option to Gallery shortcode
  51. Plugin with action ‘save_post’ needs to press publish twice on order to publish
  52. Adding rewrite rule dynamically
  53. Remove unwanted elements for a wp_nav_menu
  54. wp_set_object_terms not updating database without a die()
  55. mysql_real_escape_string() vs. esc_sql() in WordPress
  56. Show error message after exception handled
  57. I have 2 plugins using the same wp_login action hook and one is not working
  58. Checking for existence of a page by title?
  59. how to get context information inside my funcion
  60. Where do I put my add_action(… and add_filter(… and do I need to remove them?
  61. How to modify files inside wp-includes directory in wordpress
  62. Fatal error: Call to a member function get_page_permastruct() on a non-object
  63. Function/Class to list categories with checkboxes
  64. Bug: Post needs to be updated twice when adding action for save_post hook
  65. Delete data from database using row action
  66. When does save_post hook fire on post save/update
  67. Warning: call_user_func_array() expects parameter 1 to be a valid callback
  68. Print Dashboard submenu name and filename
  69. Autogenerate a Table of Contents
  70. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  71. WordPress multisite,use same cookies across all website?
  72. unregister_setting() vs delete_option() for plugin update
  73. How to change WooCommerce loop product title HTML output in single product page and archive page
  74. wp_schedule_event is registered but function isn’t running
  75. Include HTML (Bootstrap Modal Box) with a plugin into my header
  76. Using init hook for register_taxonomy is causing invalid_taxonomy in wp_insert_term()
  77. WP 3-way voting system: On to something! Please help!
  78. Custom Settings Plugin Save foreach checkboxes
  79. function add custom fields to media gallery
  80. Where do I hook to have the server do something in PHP on block attribute change?
  81. Make visible page only in the trash
  82. WordPress: I wanted to use Add rewrite rule multiple times for multiple CPT in my plugin
  83. WordPress Ajax not returning Response
  84. Post is uncatagorized in publish_post action
  85. Remove tag from all posts when publishing new post
  86. remove different admin menu for specific users
  87. WordPress Reset password Strength set to medium
  88. foreach argument to get specific file types getting too many returns
  89. Remove from a div by class name from post page if post author role is not administrator
  90. Ajax not working to insert, query and result data
  91. Associating special meaning with user id 0
  92. WordPress permalink setting
  93. How can I add recent posts to menu like mashable
  94. Why is ‘register_activation_hook’ undefined?
  95. Dynamic banner for use on external sites
  96. How can i call from custom fields to the category editor?
  97. Why does this fail: Disabling plugins enqueue_script() in functions.php
  98. Apply function on all action hooks?
  99. How to plugin function code move to theme function.php ? I’ve tried below code but not working [closed]
  100. WordPress simple ‘Hello World’ plugin – problems