can someone please edit this code?

[wman]

hej guys i am using the Wordpress autosubmitter by Whoo, its showing my the latest download titles and i can select titles and submit to ddl sites. but its showing all titles from all categories. i want him to only show the download titles from the categorie games (number 233). can somebody please edit the next code of index.php so it will only show titles from the categorie 233. i have 10$ in my paypal if u want i can send u if u make it working

code:


~~~~ CODE REMOVED BY Mr Happy ~~~~~
**************************************
This code belongs to Whoo. By showing it all here your leaking it. I'm sure Whoo will be happy to help you if you PM him. Sorry.
**************************************

wman Reviewed by wman on 19th Aug 2010. can someone please edit this code? hej guys i am using the Wordpress autosubmitter by Whoo, its showing my the latest download titles and i can select titles and submit to ddl sites. but its showing all titles from all categories. i want him to only show the download titles from the categorie games (number 233). can somebody please edit the next code of index.php so it will only show titles from the categorie 233. i have 10$ in my paypal if u want i can send u if u make it working code: ~~~~ CODE REMOVED BY Mr Happy Rating: 5

[wman]

please anyone help?

[r4myy]

I dont use wordpress but i think you need to edit this line

$result = mysql_query("select * from wp_posts WHERE post_type = 'post' ORDER BY ID DESC limit 0,250"); 

to something like

$result = mysql_query("select * from wp_posts WHERE post_type = 'post' and post_parent='233' ORDER BY ID DESC limit 0,250"); 

Not sure if that'll work though, just trying to help

[mRAza]

not saw all ur code but here is a code to get posts from a particular category

change this

$result = mysql_query("select * from wp_posts WHERE post_type = 'post' ORDER BY ID DESC limit 0,250"); 

to

$result = mysql_query("SELECT * FROM `wp_posts`, wp_term_relationships, wp_term_taxonomy WHERE wp_term_relationships.object_id = wp_posts.id AND post_status = 'publish' and post_type = 'post' AND wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id = CATEGORY_ID ORDER BY ID DESC LIMIT 0,250"); 

change CATEGORY_ID to ur catergory id