53 reputation
216
bio website
location
age
visits member for 2 years, 2 months
seen Oct 25 at 20:51

Sep
9
asked Local version of jquery not working right
Sep
4
awarded  Notable Question
Aug
1
awarded  Notable Question
Jul
31
comment wpdb getting avatars and author url
Perfect! :) thanks.
Jul
31
accepted wpdb getting avatars and author url
Jul
30
asked wpdb getting avatars and author url
Jul
30
comment $wpdb select date range of posts
Ah damnit, I can't get it working. I'll create a new question for it. Thanks again!
Jul
30
comment $wpdb select date range of posts
Ah, that's amazing, bonger! Thanks. I've asked around a bunch of people about this and you're one of the only ones who's been good with the SQL queries. I accepted your answer, really helped! Just one question as an addendum, I've been trying to do something like this <li> <a href="' . get_author_posts_url( $author->ID ) . '">' . get_the_author_meta( 'user_nicename' , $author->ID ) . '</a> (' . $author->posts . ') ' . get_avatar( $author->ID , 40 ) . ' </li> to display avatar and link to profile urls, but it doesn't seem to accept standard WP markup. Ideas?
Jul
30
accepted $wpdb select date range of posts
Jul
30
revised $wpdb select date range of posts
added 1360 characters in body
Jul
30
comment $wpdb select date range of posts
I edited my original question to reflect the code I'm using. Users are ranked seemingly randomly, not based on either weekly or total votes.
Jul
30
comment $wpdb select date range of posts
After some testing that new output doesn't appear to respect the DESC order for the vote sum.
Jul
30
comment $wpdb select date range of posts
Can you update your answer with it? this sql stuff really goes over my head despite reading the documentation.
Jul
29
comment $wpdb select date range of posts
Having trouble with the concat, want something like this:- CONCAT_WS('<div>VALUE HERE</div>/ this week',, 'VALUE HERE' being the number of votes. Reading about SQL concat_WS now.
Jul
29
comment $wpdb select date range of posts
Excellent, thanks.
Jul
29
comment $wpdb select date range of posts
Can you update your answer to write that within the context of my code?
Jul
29
comment $wpdb select date range of posts
How would I roll both into the query so I could display total in last week AND the total?
Jul
29
awarded  Benefactor
Jul
29
accepted using update_user_meta to rank users
Jul
29
asked $wpdb select date range of posts