ansonphong / postworld

Wordpress Theme Development Framework
GNU General Public License v2.0
7 stars 0 forks source link

Outdated Database Structure : User Meta #39

Closed ansonphong closed 10 years ago

ansonphong commented 10 years ago

Hi Haidy, I was looking through the DB structure, and I noticed we haven't implemented the new methods for storing favorites , view_later posts and viewed posts.

If you look in the updated User Meta table, and configuration in postworld_install.php you'll see we're still running on an old system.

Here is the new structure:
https://github.com/phongmedia/postworld/blob/master/dev/DATABASE-STRUCTURE.md#post_relationships--json

You can update all the install script, and corresponding methods : set_favorite(), add_favorite(), set_viewed(), etc.

These should all be using the get_post_relationship() and set_post_relationship() methods.

https://github.com/phongmedia/postworld/tree/master/php#get_post_relationship-relationship-post_id-user_id-

get_post_relationship()
https://github.com/phongmedia/postworld/tree/master/php#get_post_relationship-relationship-post_id-user_id-

set_post_relationship()
https://github.com/phongmedia/postworld/tree/master/php#set_post_relationship-relationship-post_id-user_id-switch-

Let me know if you have any questions about this.