Custom Query By jQuery Var WordPress

Zach Reed comments:

Well the votes are being stored in a whole different system using SQLite, not related to WP at all. It uses this php script to do the voting: [[LINK href="http://codecanyon.net/item/thumbsup/50411"]]http://codecanyon.net/item/thumbsup/50411[[/LINK]] - and to make a "voting box" you have to have unique values, so I put the voting box in the loop and take a post's id to make each voting box unique.

That is why I thought I would have to use a jQuery variable like:
var numbers = $('.thumbsup').find('form').find('a').find('span').text();

to pull that number and then somehow sort the post's via that number.

Tom Ransom comments:

Ok - now I have a better understanding - for the case that you describe - you will need to create your own sorting function and resort $wp_query->posts using a custom function after executing your query.

There is an excellent article here with sample code:
http://jeffgran.com/218/blog/wordpress-sort-posts-by-multiple-fields

Your function used with usort needs to retrieve the current vote count from the $thumbsup object for each of the two posts passed into the routine
http://www.geertdedeckere.be/lab/themeforest/thumbsup/wordpress/

Zach Reed comments:

I am not exactly sure what you mean...

This may help, this is my loop for the category page: [[LINK href="http://snipt.org/klpJ/"]]http://snipt.org/klpJ/[[/LINK]]

And this is the sorting script I have: [[LINK href="http://snipt.org/kloW/"]]http://snipt.org/kloW/[[/LINK]]

And I target the number in the thumbsup output with this jQuery function (if that even matters?)
var numbers = $('.thumbsup').find('form').find('a').find('span').text();


could you possible give me an example of what you mean?

Tom Ransom comments:

Here is some example code:
http://snipt.org/klpN/

We are adding a new option - Votes and a new switch case.
In the new switch case - we need to do a default wp query then resort the response based on the vote count.

Zach Reed comments:

Okay I copied your code but sorry if this is a dumb question... I get this error...

Fatal error: Call to undefined method ThumbsUp::SOMEFUNCTION()

I take it I need to replace "SOMEFUNCTION", but with what? That VAR?

Tom Ransom comments:

I don't have access to the thumbsup script. But you are inserting the vote template by giving each thumbs up/down element an id that includes the post ID.

It is almost a given that there is a function within the thumbsup script that given that identifier - returns a numeric vote count. You'll have to look at the documentation/code to figure that part out.

Zach Reed comments:

I found the identifier in the Thumbsup template but now I get:

Fatal error: Cannot access protected property ThumbsUp::$item'

If I could somehow give it access (not sure how?) would that be bad? Would it be some kind of security hole or something?

Zach Reed comments:

Not sure if this helps but <?php defined('THUMBSUP_DOCROOT') or exit('No direct script access.') ?> is in the Thumbsup template, at the top.

Tom Ransom comments:

You are looking for a function within the thumbsup class that will return the count given the identifier.

Zach Reed comments:

I think I did that:

global $thumbsup;
$vote_count_1 = $thumbsup->$item['results']['positive_votes']($post1->ID); // Get the vote count for post1
$vote_count_2 = $thumbsup->$item['results']['positive_votes']($post2->ID); // Get the vote count for post2
return ($vote_count_1 < $vote_count_2) ? -1 : 1;

But with that I get: "Fatal error: Cannot access protected property ThumbsUp::$item"

In the Thumbsup template at the top it has, <?php defined('THUMBSUP_DOCROOT') or exit('No direct script access.') ?>


I think it may have something to do with that? Thoughts?

Zach Reed comments:

I think I may have got it... Let me test it out in the AM (it is after 3am my tine) and I will let you know how it goes! :)

Zach Reed comments:

We are so close....

I fixed that "cannot access protected property error" so now,
<?php echo $thumbsup->item['results']['positive_votes'] ?>
will output the item's vote number.

The problem I think now is the "sort_posts_by_vote" function, I currently have:
function sort_posts_by_vote($vote_count_1, $vote_count_2){
global $thumbsup;
$vote_count_1 = $thumbsup->item['results']['positive_votes'][$post1->ID]; // Get the vote count for post1
$vote_count_2 = $thumbsup->item['results']['positive_votes'][$post2->ID]; // Get the vote count for post2
return ($vote_count_1 > $vote_count_2) ? 1 : -1;
}

And that makes this:
http://shirtlaunch.com/category/testing123/?by=votes&dir=asc

But as you can see, it isn't sorting right. I think if we just tweak that function it will work! :) We are sooooo close! haha

p.s.
You have already "won" this question for all of your great help, we are so close to getting it right. I also want to make sure to get your PayPal to send you a few extra bucks, I didn't realize how complex this was, so I feel like $15 is not worth all the time you have put in to help, but we can talk about that after we get this done, I will "message" you! :) (JUST AN FYI!)

Tom Ransom comments:

You are getting the error because you are NOT using a function - you are using a array variable marked as private.

Looking for a method within the class that returns the vote count. Work backwards from the section that outputs the values - it has to retrieve it from somewhere. You need to access the same code.

Tom Ransom comments:

If you'd like to send me the thumbsup script via email - I can probably find it pretty quickly.

transom at 1bigidea dot com