Hey pgogy –
I’m really fascinated by your code (which is WAY beyond this simple noob).
I found this snippet of your code:
global $wpdb, $bp;
$myrows = $wpdb->get_results(
“SELECT forum_name, count(forum_name) as forum_count FROM ” . $wpdb->prefix . “bp_activity, ” . $wpdb->prefix . “bb_forums where forum_id = item_id and type like ‘new_forum_%’ and user_id='” . $bp->displayed_user->id . “‘”
Would you be willing to tell me how to tweak this to echo:
1) The total forum posts of current user for a SPECIFIC FORUM (e.g. forum_name=”Impact”), between STARTDATE and ENDDATE?
2) The same query but for ALL user posts in that specific forum.
Would much appreciate your help.
If you like I’ll show you the end result – I’m going to TRY (lol) to link these results to google chart API to plot user posts over the last few days/weeks in that special forum, and graphed against total posts. (Whole idea being to encourage posting in this particular forum)
- The topic ‘code query’ is closed to new replies.