[wp-trac] [WordPress Trac] #2659: Comment meta

[WordPress Trac]

#2659: Comment meta
-----------------------------+----------------------------------------------
 Reporter:  markjaquith      |       Owner:  markjaquith             
     Type:  feature request  |      Status:  accepted                
 Priority:  normal           |   Milestone:  Future Release          
Component:  Comments         |     Version:  2.1                     
 Severity:  normal           |    Keywords:  comment meta needs-patch
-----------------------------+----------------------------------------------

Comment(by Otto42):

 What I'd like to see:
 CREATE TABLE $wpdb->postmeta (
   meta_id bigint(20) unsigned NOT NULL auto_increment,
   comment_id bigint(20) unsigned NOT NULL default '0',
   post_id bigint(20) unsigned NOT NULL default '0',
   meta_key varchar(255) default NULL,
   meta_value longtext,
   PRIMARY KEY  (meta_id),
   KEY post_id (post_id),
   KEY comment_id (comment_id),
   KEY meta_key (meta_key)
 ) $charset_collate;

 This gives you the ability to add arbitrary key=value pairs to a comment.
 It's particularly handy in cases where you need to store some piece of
 information to go with the comment.

 Example use: If I want to allow somebody to sign their comment using, say,
 Twitter, then I can store their Twitter ID with the comment and post a
 link to their Twitter. At the same time, I can go and use Twitter's API to
 get their profile picture from there. A simple action added to the
 get_avatar hook will then let me override the displayed gravatar (since I
 don't have their email anyway, since they used Twitter to authenticate)
 and I can show their profile pic from twitter instead. Repeat for
 FriendFeed (the code is actually much the same). Repeat for Facebook
 Connect, or Google's OpenSocial thing, or other service of your choice,
 many social systems offer these basic capabilities in the API.

 I want people to be able to use other services to comment on my blog
 *without* signing up for an account. In other words, I don't want these
 people in my wp_users table, I just want to get their credentials from
 elsewhere, and use those credentials to let them sign their comments. Then
 i can display their comments and say "X from twitter says" and "Y from
 facebook replied" and so on.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/2659#comment:35>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software