Results 11 to 13 of 13

Thread: Adding another Form to Classified Adverts

August 30th, 2009 #11
pl4y312

Newbie
Not a Verified Customer

Join Date

Aug 2009

Posts

1

Thanks

0

Thanked 0 Times in 0 Posts
Re: Adding another Form to Classified Adverts
Hi,

I got this problem too.
But in my observation (with google :P), I got this

http://wordpress.org/support/topic/286391

here's the script
Code:

$querystr = " SELECT wposts.* FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key = 'price' AND wposts.post_type = 'post' ORDER BY wpostmeta.meta_value+0 DESC ";
But I don't know where I should put this script.
Anyone can help?
Or that is similar solution like dcowgill said

Regards,
pl4y312
September 24th, 2009 #12

thedave

Amateur
Not a Verified Customer

Join Date

Jun 2009

Posts

11

Thanks

0

Thanked 0 Times in 0 Posts

Re: Adding another Form to Classified Adverts
Bump.

As stated in the first post of this string. This is an extremely important feature that is included in this theme. It should work properly. Has anyone figured out a fix?
October 14th, 2009 #13

popsoul

Amateur

Join Date

Oct 2009

Posts

10

Thanks

0

Thanked 0 Times in 0 Posts

Re: Adding another Form to Classified Adverts
Found this solution to the whole Price sorting issue.

http://wordpress.org/support/topic/277454

Basically you use this in your sort links
<a href="?sort=meta_value_number&key=price&order=asc" >
<a href="?sort=meta_value_number&key=price&order=desc ">

But then you have to make a few edits to WP. In the main wordpress directory (not classipress) go inside the wp-includes folder and open the query.php file. Then do the following:

go to line ~2035, after $allowed_keys[] = 'meta_value'; add
$allowed_keys[] = 'meta_value_number';

go to line ~2057, after break; add
case 'meta_value_number':
$orderby = "$wpdb->postmeta.meta_value+0";
break;

I did it and it works for me. If those lines aren't exact for you you may not be up to date with your wordpress. Try upgrading or do a search for the value they said to put your new code in after.

good luck