I set a blog with math games where I installed a Register Plus plugin so I can have a custom field that would allow on registration to choose which school grade of the registering user. For example in this case I have elementary and middle (junior high) school.
And these choices (elementary and middle school) are created in wp_usermeta with a record like:
umeta_id user_id meta_key meta_value
380 21 school Junior High
I have also some categories for elementary and some for middle school where I insert some math problems posts.
So, my question: is there a way that I can connect categories to the meta_value so when a user joins will see only related posts so I can have an association?...
Or the only way is to play with a custom loop with a custom SELECT in the index.php file?...
Plus, as admin, I'd want to assign to users some points based on problem type... and I was thinking to create a custom table with fields like:
user_id post_id points
but first I'd ask if is there a way to insert that to wp tables using wp functions so I can easily query them using wp functions?...
thanks to all in advance for the hints! :-)