So, I am inheriting an intranet site that was built on Datatables / Wordpress. Basically it is made in Wordpress and then displays custom fields that the users have filled out in the datatable. But it was querying 40 columns per post over 2k entries so is now grinding to a standstill when the users try and view the data in the table.
I'm attempting to utilize the server-side aspect of Datatables for this, but running into a little trouble because of how the SQL data is formatted.
I am looking for someone to modify this server-processing.php script (i'm using this one: http://datatables.net/development/server-side/php_mysql) to make an JSON response that:
1) Display rows based on the wp_posts.id index if the post has been set to publish
2) Display columns in this row based on a different table (wp_postmeta). Each value in wp_postmeta is indexed separately (vertically in the DB) and referenced (horizontally in DB) by a meta_key (which will be the reference for which column to populate) and the post_id (which will be the reference for which row to populate.
3) Link entire row to the URL found in the wp_posts table for the post ID.
The budget for this is $100 and it would be needed to be complete by tomorrow (January 11th, PST). I think it should be a pretty easy to modify, I just don't have a lot of know how in this specific thing, thanks.