Re: Good model plugin for newbie plugin author to study?
It might be a bit confusing, because it is a complex plugin, but the Support Forum plugin uses the topic meta table to store topic support status. This data used to be in a column in the topic table but was moved to the meta table a few versions ago.
The basic usage is (with some guessing as to what you would call your data):
// To add
bb_update_topicmeta($topic_id, 'topic_geolocation', $latlong);
// To delete
bb_delete_topicmeta($topic_id, 'topic_geolocation');
The topic metadata is automatically included in the results when you call get_topic()
.
No table manipulation should be necessary.