{"id":251,"date":"2007-09-29T12:43:55","date_gmt":"2007-09-29T11:43:55","guid":{"rendered":"http:\/\/www.2diabolos.com\/blog\/plugins-pour-wordpress\/post-level-for-wp23\/"},"modified":"2024-08-26T19:46:29","modified_gmt":"2024-08-26T18:46:29","slug":"post-level-for-wp23","status":"publish","type":"page","link":"https:\/\/www.2diabolos.com\/blog\/plugins-pour-wordpress\/post-level-for-wp23\/","title":{"rendered":"Post Level (for WP2.3)"},"content":{"rendered":"<div class=\"columns\"><p>I used for a long time a plugin to restrict access of somes posts to some people only.<\/p>\n<p>This plugin (Post level) was released for wp 2.1. But  it made some database error when I upgraded to wp 2.3. So I modified it to be compatible to 2.3.<\/p>\n<p>Download link : <a href=\"https:\/\/www.2diabolos.com\/blog\/wp-content\/uploads\/2007\/09\/post-levels.zip\">Post-level_WP2.3<\/a> (I change the version number for 1.1.3 instead of 1.1.1)<\/p>\n<p>corrected  error : The following database error message appeared in \u00ab\u00a0single post\u00a0\u00bb page, instead of writing links for previous and next post.<\/p>\n<pre>WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds \r\nto your MySQL server version for the right syntax to use near 'AS p WHERE p.post_date &lt; '2007-09-08 14:27:23' \r\nAND p.post_type = 'post' AND p. ' at line 1]\r\nSELECT p.ID, p.post_title FROM (wp_posts LEFT JOIN wp_postmeta as pl_wp_postmeta ON \r\n(wp_posts.ID = pl_wp_postmeta.post_id)) AS p WHERE p.post_date &lt; '2007-09-08 14:27:23' \r\nAND p.post_type = 'post' AND p.wp_posts.post_status = 'publish' \r\nOR (wp_posts.post_status = 'private' AND (pl_wp_postmeta.meta_key = 'post_level' \r\nAND pl_wp_postmeta.meta_value &lt;= 10 ))) ORDER BY p.post_date DESC LIMIT 1<\/pre>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>I used for a long time a plugin to restrict access of somes posts to some people only. This plugin (Post level) was released for wp 2.1. But it made some database error when I upgraded to wp 2.3. So I modified it to be compatible to 2.3. Download link : Post-level_WP2.3 (I change the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":111,"menu_order":200,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-251","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.2diabolos.com\/blog\/wp-json\/wp\/v2\/pages\/251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.2diabolos.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.2diabolos.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.2diabolos.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.2diabolos.com\/blog\/wp-json\/wp\/v2\/comments?post=251"}],"version-history":[{"count":2,"href":"https:\/\/www.2diabolos.com\/blog\/wp-json\/wp\/v2\/pages\/251\/revisions"}],"predecessor-version":[{"id":2752,"href":"https:\/\/www.2diabolos.com\/blog\/wp-json\/wp\/v2\/pages\/251\/revisions\/2752"}],"up":[{"embeddable":true,"href":"https:\/\/www.2diabolos.com\/blog\/wp-json\/wp\/v2\/pages\/111"}],"wp:attachment":[{"href":"https:\/\/www.2diabolos.com\/blog\/wp-json\/wp\/v2\/media?parent=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}