81 reputation
213
bio website
location
age
visits member for 1 year, 11 months
seen 7 hours ago

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
Jul
25
comment using update_user_meta to rank users
Appears to be working (I think). As an addendum, is it possible to use strtotime to select the date range of the posts it's getting the sum of the meta value from? Been playing around with it but I've not really used global $wpdb; much before. $date1 = date('Y-m-d', strtotime('+1 days')); $date2 = date('Y-m-d', strtotime('-8 days')); Or something? And how do you declare the number of results?
Jul
25
comment using update_user_meta to rank users
Ah hang on, I think it's working now (will do some testing and report back), you made a small mistake in your query ( ' instead of " ).
Jul
25
comment using update_user_meta to rank users
SQL query breaks the page unfortunately.
Jul
25
revised using update_user_meta to rank users
added 325 characters in body
Jul
25
comment using update_user_meta to rank users
Can you slip the SQL statement into an example loop? Just as a FYI, the first method is doing strange things. Whenever I refresh the page (see the edit at the bottom, that's the loop I'm using to output the ranked users) it adds one or two points to each user. Strange, right?
Jul
24
comment using update_user_meta to rank users
Sure thing! thanks.
Jul
24
comment using update_user_meta to rank users
Ok after some testing I can say this sort of works. The problem is that every time a post is voted on it increments the epicredvote meta field of that user by 1, so a post can be voted up/down/up/down/up/down/ and that users meta value will increase by 8. Obviously it should be the sum of the votes and not how many times the users posts have been voted on.
Jul
24
comment using update_user_meta to rank users
Doing some testing now. Will report back soon.
Jul
23
revised using update_user_meta to rank users
added 397 characters in body
Jul
23
comment using update_user_meta to rank users
No filters that I can see. It does use Ajax however to register the votes. Made a small edit to the first code block (at the top). I'm sure it's possible to update the user meta with ajax when someone votes on the post, the problem is 1. update_user_meta is a WP function I've never worked with before and 2. Ajax is finicky as heck when I try to get it to work with WP.
Jul
21
asked using update_user_meta to rank users
Jul
2
awarded  Curious
Jun
30
awarded  Popular Question
Jun
13
comment Sort users by meta_value_num
Reading about update_user_meta just now. Trying to get my head around the logic for this. So it's creating a new row in the database (sorry, not particularly knowledgeable about DB's and their structures etc), will it automatically know the meta_key count for each user?
Jun
13
comment Sort users by meta_value_num
Alright well, I'm silly. Although I can get the total number of 'points' each user has recieved on their author.php page, apparently it's not a user meta key. Urgh. Still possible to query users based on the number of votes they've received on their posts or will I need to learn how to create a user some sort of table/meta key or whatever?