[wp-trac] Re: [WordPress Trac] #4015: Post and link category confusion

[WordPress Trac]

#4015: Post and link category confusion
----------------------------+-----------------------------------------------
 Reporter:  donncha         |        Owner:  ryan
     Type:  defect          |       Status:  new 
 Priority:  normal          |    Milestone:  2.3 
Component:  Administration  |      Version:  2.2 
 Severity:  normal          |   Resolution:      
 Keywords:  has-patch       |  
----------------------------+-----------------------------------------------
Comment (by Tjworld):

 I’ve just spent the best part of a morning trying to work out why 60
 categories weren’t showing up when posting/editing, after assigning them
 to links.

 I hacked the code and found the SQL clause in return_categories_list()
 causing the issue. It makes no sense to me, definitely counter-intuitive
 and even illogical.

 As a solution, how about adding an integer field "cat_scope" to
 wp_categories?

 "cat_scope" would have the values: 0 = Both, 1 = Posts, 2 = Links.

 In the "Edit Category" form add a radio-button field "Scope: * Both  *
 Posts  * Links"

 Then modify the SQL queries in return_categories_list() and
 return_link_categories_list() to use the new field as the discriminator
 instead of the AND/OR logic.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4015#comment:9>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software