';
endif;
echo $strcont .= '"; $wppcont_strcont .= "name.' ,'; } echo $wpp_termdata = substr($term_data, 0, strlen($term_data)-1); } } break; default: break; } // end switch } // hide the Post Tags and Portfolio Types Quick Edit fields on the WP Projects Portfolio listing function wpprojects_portfolio_quickedit() { global $post; if ( is_object($post) ) { if ( $post->post_type == 'wpprojects_portfolio' ) { echo ''; } } } //removes view from portfolio list function remove_wpprojects_portfolio_quick_edit( $actions ) { global $post; if( $post->post_type == 'wpprojects_portfolio' ) { //unset($actions['inline hide-if-no-js']); //unset($actions['edit']); } return $actions; } function wpprojects_portfolio_custom_edit( $actions, $post ) { $actions['customedit'] = ''; $clientrec_val = get_post_meta($post->ID, '_clientrecommendation', true); if ( $post->post_type == 'wpprojects_portfolio' ) { if($clientrec_val == ''): //Adding a custom link and passing the post id with it $actions['customedit'] .= 'ID).'&wppaction=1\' class="crecomm">Request Client Recommendation'; endif; } return $actions; } //******* PORTFOLIO EDIT SCREEN CODE START *******// function save_wpprojects_portfolio_meta($post_id) { $postid = wp_is_post_revision( $post_id ); if ( $postid == false ) { // if the save was initiated by an autosave or a quick edit, exit out as the Portfolio fields being updated here may get over written or hang the save if (!isset($_POST['autosave_quickedit_check'])) { return $post_id; } // verify this call is the result of a POST if ( empty($_POST) ) { return $post_id; } // if the user isn't saving a portfolio if (strtolower($_POST['post_type']) != "wpprojects_portfolio") { return $post_id; } // verify this came from our screen and with proper authorization, because save_post can be triggered at other times if ( !check_admin_referer('wpprojects_portfolio_edit','wppportfoliometanonce') ) { return $post_id; } // Is the user allowed to edit the post or page? if ( !current_user_can( 'edit_post', $post_id )) { return $post_id; } // OK, we're authenticated: we need to find and save the data $portfolio_meta['_siteurl'] = $_POST['_siteurl']; $portfolio_meta['_imageurl'] = $_POST['_imageurl']; $portfolio_meta['_projectbefore'] = $_POST['_projectbefore']; $portfolio_meta['_projectafter'] = $_POST['_projectafter']; $portfolio_meta['_clientname'] = $_POST['_clientname']; $portfolio_meta['_clientemail'] = $_POST['_clientemail']; $portfolio_meta['_clientphoto'] = $_POST['_clientphoto']; $portfolio_meta['_wpp_passcode'] = $_POST['_wpp_passcode']; $portfolio_meta['_technical_details'] = $_POST['_technical_details']; $portfolio_meta['_clientrecommendation'] = $_POST['_clientrecommendation']; if (!empty($_POST['_sortorder'])) { $portfolio_meta['_sortorder'] = $_POST['_sortorder']; } else { $portfolio_meta['_sortorder'] = -1*($post_id); } // Add values of $portfolio_meta as custom fields foreach ($portfolio_meta as $key => $value) { // Cycle through the $portfolio_meta array! $value = implode(',', (array)$value); // If $value is an array, make it a CSV (unlikely) if (get_post_meta($post_id, $key, false)) { // If the custom field already has a value update_post_meta($post_id, $key, $value); } else { // If the custom field doesn't have a value add_post_meta($post_id, $key, $value); } if (!$value) delete_post_meta($post_id, $key); // Delete if blank } } } //*************************************************// //******** PORTFOLIO EDIT SCREEN CODE END ********// //*************************************************// // Define the Portfolio edit form custom fields function wpprojects_portfolio_edit_init() { global $post; // Noncename needed to verify where the data originated wp_nonce_field( 'wpprojects_portfolio_edit', 'wppportfoliometanonce' ); // Gather any existing custom data for the Portfolio $datecreate = get_post_meta($post->ID, '_createdate', true); $siteurl = get_post_meta($post->ID, '_siteurl', true); $imageurl = get_post_meta($post->ID, '_imageurl', true); $projectlocation = get_post_meta($post->ID, '_projectlocation', true); $projectbefore = get_post_meta($post->ID, '_projectbefore', true); $projectafter = get_post_meta($post->ID, '_projectafter', true); $client_name = get_post_meta($post->ID, '_clientname', true); $clientemail = get_post_meta($post->ID, '_clientemail', true); $client_photo = get_post_meta($post->ID, '_clientphoto', true); $client_passcode = get_post_meta($post->ID , "_wpp_passcode", true); $technical_details = get_post_meta($post->ID, '_technical_details', true); $clientrecommendation = get_post_meta($post->ID, '_clientrecommendation', true); $wpp_portfolio_type = get_post_meta($post->ID, '_wpprojects_portfolio_type', true); $sortorder = get_post_meta($post->ID, '_sortorder', true); if ($sortorder=="") $sortorder = "-" . $post->ID; // Gather the list of WP Projects Portfolio Types $portfolio_type_list = get_terms('wpprojects_portfolio_type', 'hide_empty=0'); // Build out the form fields echo '
'; echo '
'; echo ''; echo '
'; echo '';
echo '
';
echo '
';
if(!empty($imageurl)):
echo '
'; echo ''; echo '
'; echo ''; echo '
'; echo '
'; echo ''; echo '
'; echo '';
echo '
';
echo '
';
if(!empty($client_photo)):
echo '
'; echo ''; echo '
'; echo '
'; echo ''; echo ''; echo '
'; echo '
'; $crsts_val = get_post_meta($post->ID , "_wpp_crstatus", true); if($crsts_val): $switch_status = $crsts_val; else: $switch_status = "off"; endif; echo ''; echo ''; echo ''; echo '
'; } /* Add the Portfolio custom fields (called as an argument of the custom post type registration) */ function add_wpprojects_portfolio_metaboxes() { add_meta_box('wpprojects_portfolio_edit_init', 'Concrete Project', 'wpprojects_portfolio_edit_init', 'wpprojects_portfolio', 'normal', 'high'); } // Manage Portfolio Types taxonomy counts function wpprojects_portfolio_type_taxonomy_count_rec($post_id) { global $wpdb; $postid = wp_is_post_revision( $post_id ); if ( $postid == false ) { $postid = $post_id; } $wpdb->query( " DELETE FROM $wpdb->term_relationships WHERE object_id = '".$postid."' AND EXISTS ( SELECT 1 FROM $wpdb->term_taxonomy stt WHERE stt.term_taxonomy_id = $wpdb->term_relationships.term_taxonomy_id AND stt.taxonomy = 'wpprojects_portfolio_type') " ); $wpdb->query( " INSERT INTO $wpdb->term_relationships (object_id, term_taxonomy_id, term_order) SELECT sp.id 'object_id', ( SELECT ssstt.term_taxonomy_id FROM $wpdb->postmeta spm INNER JOIN $wpdb->terms ssst ON spm.meta_value = ssst.slug INNER JOIN $wpdb->term_taxonomy ssstt ON ssst.term_id = ssstt.term_id AND ssstt.taxonomy = 'wpprojects_portfolio_type' WHERE spm.meta_key = 'wpprojects_portfolio_type' AND spm.post_id = sp.id) 'term_taxonomy_id', 0 'term_order' FROM $wpdb->posts sp WHERE sp.id = '".$postid."' AND sp.post_type = 'wpprojects_portfolio' AND EXISTS ( SELECT 1 FROM $wpdb->postmeta sspm INNER JOIN $wpdb->terms sssst ON sspm.meta_value = sssst.slug INNER JOIN $wpdb->term_taxonomy sssstt ON sssst.term_id = sssstt.term_id AND sssstt.taxonomy = 'wpprojects_portfolio_type' WHERE sspm.meta_key = '_wpprojects_portfolio_type' AND sspm.post_id = sp.id) AND NOT EXISTS ( SELECT 1 FROM $wpdb->term_relationships str INNER JOIN $wpdb->term_taxonomy stt ON str.term_taxonomy_id = stt.term_taxonomy_id AND stt.taxonomy = 'wpprojects_portfolio_type' INNER JOIN $wpdb->terms st ON stt.term_id = st.term_id WHERE str.object_id = sp.id) " ); // update the WP Projects Portfolio (Post) counts on the Portfolio Types $wpdb->query( " UPDATE $wpdb->term_taxonomy SET count = (SELECT count(ssp.id) FROM $wpdb->posts ssp INNER JOIN $wpdb->term_relationships str ON ssp.id = str.object_id WHERE ssp.post_type = 'wpprojects_portfolio' AND ssp.post_status = 'publish' AND str.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) WHERE taxonomy = 'wpprojects_portfolio_type' " ); } /* Define Portfolio Plugin De-activation process */ function wpprojects_portfolio_remove() { $deletedata = "false"; // if the delete data option is set to delete, then delete the Portfolio records and Portfolio Type taxonomy records if ( $deletedata == "true" ) { // Gather the Portfolios $portfolios_to_delete = new WP_Query(array('post_type' => 'wpprojects_portfolio', 'post_status' => 'any', 'orderby' => 'ID', 'order' => 'DESC')); // Loop through and delete the Portfolios if ( $portfolios_to_delete->have_posts() ) { while ( $portfolios_to_delete->have_posts() ) : $portfolios_to_delete->the_post(); wp_delete_post( get_the_id(), true ); endwhile; } // Gather the list of Portfolio Types $portfolio_type_list = get_terms('wpprojects_portfolio_type', 'hide_empty=0'); // Loop thru the types and delete each one, the last will clear the taxonomy foreach ($portfolio_type_list as $portfolio_item) { wp_delete_term( $portfolio_item->term_id, 'wpprojects_portfolio_type' ); } // Gather the list of Portfolio Tags $portfolio_type_list = get_terms('wpprojects_portfolio_tag', 'hide_empty=0'); // Loop thru the tags and delete each one foreach ($portfolio_type_list as $portfolio_item) { wp_delete_term( $portfolio_item->term_id, 'wpprojects_portfolio_tag' ); } } } function wpprojects_portfolio_set_admin_css() { $file = plugins_url('css/wpproj_admin.css', __FILE__); wp_register_style('wpproj_admin', $file); wp_enqueue_style('wpproj_admin'); } function wpprojects_portfolio_post_css() { global $post; // don't include the Portfolio Post CSS file if we aren't on the Portfolio Post edit screen if (strtolower($post->post_type) == "wpprojects_portfolio") { $file = plugins_url('css/post_wpportfolio.css', __FILE__); wp_register_style('post_wpportfolio', $file); wp_enqueue_style('post_wpportfolio'); } } if(!function_exists('wpprojects_create_portfolio')) { function wpprojects_create_portfolio() { wpprojects_portfolio_googleapis_jquery(); add_wpprojects_portfolio_css(); deregister_wpprojec_plugin_styles(); add_action('wp_print_scripts', 'deregister_wpprojec_plugin_scripts'); } } function add_wpprojects_portfolio_css() { $css = plugins_url('css/wppcr_main.css', __FILE__); wp_register_style('wppcr_main', $css); wp_enqueue_style('wppcr_main'); } function deregister_wpprojec_plugin_styles() { wp_deregister_style('thickbox'); } function deregister_wpprojec_plugin_scripts() { wp_deregister_script('thickbox'); } if(!function_exists('wpprojects_create_single_portfolio')) { function wpprojects_create_single_portfolio() { $js = plugins_url('css/post_single_wpproject.css', __FILE__); $js = wpprojects_portfolio_clear($js); wp_register_style('wpprojects_single_portfolio', $js); wp_enqueue_style('wpprojects_single_portfolio'); } } /* define the Portfolio ShortCode and set defaults for available arguments */ function wpprojects_portfolio_loop($atts, $content = null) { if ( is_admin() ) { return null; } global $for; global $portfolio_types; global $portfolio_output; global $num_per_page; global $limit_portfolios_returned; global $display_the_credit; wpprojects_clear_global_entries(); $max_nav_spread = ''; $portfolio_type = ''; extract( shortcode_atts( array( 'max_nav_spread' => 5, 'portfolio_type' => '', 'thickbox' => '', 'id' => '', 'per_page' => '', 'limit' => '', 'credit' =>''), $atts ) ); $for = $max_nav_spread; $portfolio_types = $portfolio_type; if ( !empty($per_page) && is_numeric($per_page) ) { $num_per_page = $per_page; } if ( !empty($id) ) { $portfolio_output = '';
}
if ( !empty($content) ) {
$portfolio_output .= '
';
}
return $portfolio_output;
}
/* clear out the shortcode values otherwise they get re-used if more than one shortcode is used per page */
function wpprojects_clear_global_entries() {
global $wp_query;
global $for;
global $portfolio_types;
global $click_behavior;
global $portfolio_output;
global $num_per_page;
global $limit_portfolios_returned;
global $display_the_credit;
$wp_query->query_vars['portfoliotype'] = '';
$for = '';
$portfolio_types = '';
$click_behavior = '';
$portfolio_output = '';
$num_per_page = '';
$limit_portfolios_returned = '';
$display_the_credit = '';
}
// Passcode validate FUNCTION
function cr_validate_passcode(){
$wpp_passcode = trim($_POST['wpppcode']);
$wpp_postid = $_POST['wpppid'];
if(!empty($wpp_passcode) && !empty($wpp_postid)):
$dbpasscode = get_post_meta($wpp_postid , "_wpp_passcode", true);
$dbpassvalue = ($dbpasscode == "") ? 0 : $dbpasscode;
if($wpp_passcode == $dbpassvalue) {
$message = "spcode";
} else {
$message = "fpcode";
}
else:
$message = "empcode";
endif;
echo $message;
die();
}
function author_wpinfo() {
echo "\n";
echo '';
echo '';
echo "\n";
}
function crecommend_script_enqueuer() {
wp_register_script( "crecommend_script", WP_PLUGIN_URL.'/wp-projects-portfolio/scripts/cr_script.js', array('jquery') );
wp_localize_script( 'crecommend_script', 'crAjax', array( 'ajaxurl' => admin_url( 'admin-ajax.php' )));
wp_enqueue_script( 'jquery' );
wp_enqueue_script( 'crecommend_script' );
wp_register_script( "onoff_script",WP_PLUGIN_URL.'/wp-projects-portfolio/scripts/on-off-script.js', array('jquery') );
wp_enqueue_script( 'onoff_script' );
}
add_action('wp_head', 'author_wpinfo');
add_action( 'init', 'crecommend_script_enqueuer');
add_action( 'wp_ajax_crpcode_nonce', 'cr_validate_passcode');
add_action( 'wp_ajax_nopriv_crpcode_nonce', 'cr_validate_passcode');
function clientrec_contentsubmit(){
$wpp_crcontent = trim($_POST['crboxcontent']);
$crpostid = $_POST['crpid'];
$cl_name = get_post_meta($crpostid, "_clientname", true);
$cl_email = get_post_meta($crpostid, "_clientemail", true);
$crpost_title = get_the_title($crpostid);
$wpp_peditlink = admin_url()."/post.php?post=".$crpostid."&action=edit";
$crplink = get_permalink($crpostid);
$wp_adminemail = get_option('admin_email');
$crec_subject = "New Client's Recommendation Received From -".$cl_name."";
$crec_mail_headers = "MIME-Version: 1.0" . "\r\n";
$crec_mail_headers .= "Content-type: text/html; charset=".get_bloginfo('charset')."" . "\r\n";
$crec_mail_headers .= 'From:'.$cl_name."<".$cl_email. ">\r\n";
$wpcr_recmessage = get_option('wpcr_recmessage');
if($wpcr_recmessage != '') {
$crec_mail_content = get_option('wpcr_recmessage')."' . $content . '
';
}
if ( !empty($limit) && is_numeric($limit) ) {
$limit_portfolios_returned = $limit;
}
include('loop-wppcr-portfolio.php');
if ( !empty($id) ) {
$portfolio_output .= '"; $crec_mail_content .= "Project Title".$crpost_title."
"; $crec_mail_content .= "Recommendation".stripslashes($wpp_crcontent)."
"; $crec_mail_content .= "Please click on the following link & approve this recommendation.
".$wpp_peditlink."
Thanks,"; } else { $crec_mail_content = 'Hello Admin,
New recommendation received for '.$crpost_title.' project.
'.$crplink.'
Recommendation:
'.stripslashes($wpp_crcontent).'
Please click on the following link & approve this recommendation.
'.$wpp_peditlink.'
Thanks,'; } if(!empty($wpp_crcontent) && !empty($crpostid)): $dbcrcontent = update_post_meta($crpostid , "_clientrecommendation", $wpp_crcontent); if($dbcrcontent) { wp_mail($wp_adminemail, $crec_subject, $crec_mail_content, $crec_mail_headers); $message = "scrcont"; } else { $message = "fcrcont"; } else: $message = "empcrcont"; endif; echo $message; die(); } //Now to get the 'test' argument, and triggering a function based on it... //Pass code generator function passcodegen($length=10) { $passcode = ''; list($usec, $sec) = explode(' ', microtime()); mt_srand((float) $sec + ((float) $usec * 100000)); $inputs = array_merge(range('z','a'),range(0,9),range('A','Z')); for($i=0; $i<$length; $i++) { $passcode .= $inputs{mt_rand(0,61)}; } return $passcode; } function wpp_clientrec_sent() { global $current_screen; $ptrashed =""; $puntrashed = ""; if(isset($_REQUEST['trashed'])): $ptrashed = $_REQUEST['trashed']; endif; if(isset($_REQUEST['untrashed'])): $puntrashed = $_REQUEST['untrashed']; endif; if ( 'wpprojects_portfolio' == $current_screen->post_type && !$ptrashed && !$ptrashed ){ _e('
Client recommendation request has been sent!
'; $crmail_content .= $wprec_message; $crmail_content .= 'Submit Testimonial by clicking on the link'.$wpp_postplink.''; $crmail_content .= 'Use the Password: '.$sendpasscode .'
Thanks,'; } else { $crmail_content = 'Hello '.$wpp_clientname.',
Thanks for offering me the project & it was nice working with you on this project as per your request.
So I would request you to provide testimonial on my portfolio for the same by clicking on the link below
'.$wpp_postplink.'
Use the Password: '.$sendpasscode .' to provide the testimonial.
Thanks,'; } wp_mail($wpp_clientemail, $crmail_subject, $crmail_content, $crmail_headers); } add_action( 'wp_ajax_crcontent_nonce', 'clientrec_contentsubmit'); add_action( 'wp_ajax_nopriv_crcontent_nonce', 'clientrec_contentsubmit'); // test for whether a hook should be applied or not function wpprojects_portfolio_apply_hook( $query, $hook ) { return ( // We have query vars property_exists( $query, 'query_vars' ) && ( array_key_exists( 'post_type', $query->query_vars ) && $query->query_vars['post_type'] == 'wpprojects_portfolio' ) ); } // add "portfoliotype" into the recognized set of query variables function wpprojects_portfolio_queryvars( $qvars ) { $qvars[] = 'portfoliotype'; return $qvars; } // status mode - FUNCTION function cr_non_dstatus(){ $crstatus = $_POST['crsts']; $cr_postid = $_POST['crpid']; if(!empty($crstatus) && !empty($cr_postid)): $crsts_update = update_post_meta($cr_postid , "_wpp_crstatus", $crstatus); if($crsts_update) { $message = "crstss"; } else { $message = "crstsf"; } endif; echo $message; die(); } // augment the JOIN if a Portfolio Type is part of the search function wpprojects_portfolio_search_join( $join, $query ) { global $wpdb, $wp_query; // if the portfolio type has been defined in the search vars if ( wpprojects_portfolio_apply_hook( $query, 'join' ) ) { // add the join to the wp_postmeta table for meta records that are of a Portfolio Type $join .= " LEFT OUTER JOIN " . $wpdb->prefix . "postmeta AS port ON (" . $wpdb->posts . ".ID = port.post_id AND port.meta_key = '_wpprojects_portfolio_type') "; } return $join; } // augment the WHERE clause if a Portfolio Type is part of the search function wpprojects_portfolio_search_where( $where, $query ) { global $wp_query; if ( is_admin() ) { return $where; } // if the portfolio type has been defined in the search vars if ( wpprojects_portfolio_apply_hook( $query, 'where' ) ) { // clear out our portfolio type buckets $IN = ""; $OUT = ""; $types = get_query_var('portfoliotype'); // place the portfolio types into an array so that it is easier to process them $ptypes = explode(",",$types); // loop through the portfolio array foreach ($ptypes as $value) { // if the portfolio type is not lead by a minus sign then add it to the IN bucket if (substr($value, 0, 1) != '-') { if ( !empty($IN) ) $IN .= ","; $IN .= $value; } else { // otherwise, add it to the OUT bucket if ( !empty($OUT) ) $OUT .= ","; $OUT .= substr($value, 1); } } // if some of the portfolio types were flagged for inclusion then add an IN() clause if ( !empty($IN) ) { if (!empty($where)) $where .= " AND "; $where .= " port.meta_value IN ('" . str_replace(',', "','", $IN) . "')"; } // if some of the portfolio types were flagged for exclusion then add a NOT IN() clause if ( !empty($OUT) ) { if (!empty($where)) $where .= " AND "; $where .= " port.meta_value NOT IN ('" . str_replace(',', "','", $OUT) . "')"; } } return $where; } add_action( 'wp_ajax_crsts_nonce', 'cr_non_dstatus'); add_action( 'wp_ajax_nopriv_crsts_nonce', 'cr_non_dstatus'); // extend standard WordPress tag cloud to include Portfolio tags function wpprojects_portfolio_tag_cloud_inc($args = array()) { $include = "False"; if ($include == 'True') { if (is_array($args['taxonomy'])) { array_push($args['taxonomy'],"wpprojects_portfolio_tag"); } else { $args['taxonomy'] = array($args['taxonomy'],'wpprojects_portfolio_tag'); } } return $args; } if ( ! is_admin() ) { add_filter('widget_tag_cloud_args', 'wpprojects_portfolio_tag_cloud_inc', 90); } function wp_admin_bar_crtotalcount_item() { global $wpdb, $wp_admin_bar; if ( ! is_super_admin() || ! is_admin_bar_showing() ) return; $cr_count = $wpdb->get_var( "SELECT COUNT( * ) AS count FROM {$wpdb->postmeta} pm LEFT JOIN {$wpdb->posts} p ON p.ID = pm.post_id WHERE ( pm.meta_key = '_clientrecommendation' AND pm.meta_value != '' ) AND p.post_status = 'publish' AND p.post_type = 'wpprojects_portfolio' "); $wp_admin_bar->add_menu(array( 'id' => 'wp-admin-bar-new-item', 'title' => __('Total CR-Received ('.$cr_count.')'), 'href' => admin_url().'edit.php?post_type="wpprojects_portfolio&sfname=_clientrecommendation"' )); } add_action('wp_before_admin_bar_render', 'wp_admin_bar_crtotalcount_item'); // if we are on a post or a page with the wp-projects-portfolio shortcode in the content then carry off certain actions function wpprojects_shortcode() { $cont = ""; global $post; if ( is_single() || is_page() ) { $cont = getWPProjectsPageContent($post->ID); } // if the wp-projects-portfolio shortcode is within the content take the actions indicated if ( strpos($cont, "wp-projects-portfolio") > 0 ) { add_action('wp_print_styles', 'wpprojects_create_portfolio'); } else { if ($_SERVER["REMOTE_ADDR"] == '127.0.0.1') { // asterisk - when running locally this was needed to avert a non-ending re-direct remove_filter('template_redirect', 'redirect_canonical'); } // add_action('template_redirect', 'use_single_portfolio_page_template'); add_filter('template_include', 'wpprojects_portfolio_template_include'); // add_filter('template_include', 'wpprojects_portfolio_tag_template_include'); add_action('wp_print_styles', 'wpprojects_create_single_portfolio'); } } function wpprojects_portfolio_template_include($incFile) { if ( get_post_type() == 'wpprojects_portfolio' ) { $incFile = wpprojects_portfolio_post_templatefile_include($incFile); } return $incFile; } if(!function_exists('wpprojects_portfolio_post_templatefile_include')) { function wpprojects_portfolio_post_templatefile_include($incFile) { global $wp_query; if (is_single()) { add_action('wp_print_styles', 'wpprojects_create_single_portfolio'); $file = get_stylesheet_directory() . '/single-wp-projects-portfolio.php'; if ( ! file_exists($file) ) { $file = plugin_dir_path(__FILE__) . 'single-wp-projects-portfolio.php'; } if (file_exists($file)) { $incFile = $file; } } else { $wp_query->is_404 = true; } return $incFile; } } if(!function_exists('getWPProjectsPageContent')) { function getWPProjectsPageContent($pageId) { if(!is_numeric($pageId)) { return; } global $wpdb; $sql_query = 'SELECT DISTINCT * FROM ' . $wpdb->posts . ' WHERE ' . $wpdb->posts . '.ID=' . $pageId; $posts = $wpdb->get_results($sql_query); if(!empty($posts)) { foreach($posts as $post) { return nl2br($post->post_content); } } } } // smart jquery inclusion function wpprojects_portfolio_googleapis_jquery() { wp_deregister_script('jquery'); wp_register_script('jquery', 'https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js'); wp_enqueue_script('jquery'); } // clear the passed in path up to wp-content as some code and hosting providers don't play nicely with arguments containing http://www if ( ! function_exists( 'wpprojects_portfolio_clear' ) ) : function wpprojects_portfolio_clear($url) { $return = $url; $use_full_path = 'True'; if ( $use_full_path != 'True' ) { $pos = strpos($return, 'wp-content'); if ( ! empty($pos) ) { $return = str_replace(substr($return, 0, strpos($return, 'wp-content') - 1), "", $return); } } return $return; } endif; /************** Project Requirements label display******************************/ // 'Enter property description here' label filter function customs_tinyMCE_label($content){ if($content == '') $content = 'ENTER THE PROJECT REQUIREMENTS HERE...'; return $content; } // add custom tinyMCE settings filter function customs_tinyMCE($settings){ $settings['setup'] = 'tinyEvent'; return $settings; } // add custom tinyMCE script and custom tinyMCE initialize content $bozuri = $_SERVER['REQUEST_URI']; if ( strstr($bozuri, 'post_type=wpprojects_portfolio') ) { add_filter('tiny_mce_before_init','customs_tinyMCE'); add_filter('the_editor_content', 'customs_tinyMCE_label'); } /* Build out the navigation elements for paging through the WP projects Portfolio pages */ function wpprojects_nav_pages($qryloop, $pageurl, $class) { global $for; global $portfolio_output; global $navcontrol; global $limit_portfolios_returned; // get total number of pages in the query results $pages = $qryloop->max_num_pages; $legacy = ''; $top = ""; $bottom = ""; if ($legacy == 'True') { $top = " top"; $bottom = " bottom"; } // if the user has set a hard value for the number of portfolios to return in the shortcode if ( is_numeric($limit_portfolios_returned) ) { if ($limit_portfolios_returned > 0) { $pages = 1; } } // if there is more than one page of Portfolio query results if ($pages > 1) { if ( ($class == "wpprojects_nav_bottom") && ( !empty($navcontrol) ) ) { $portfolio_output .= '
' . $navcontrol . '
';
$navcontrol = array();
return $portfolio_output;
}
$paged_1 = $pageurl;
if ( strpos($pageurl, "?page_id=") > 0 ) {
$paged = $pageurl . "&paged=";
$paged_end = "";
} else {
// $paged = $pageurl . "?paged=";
$paged = $pageurl . "/page/";
$paged_end = "/";
}
// get current page number
intval(get_query_var('paged')) == 0 ? $curpage=1 : $curpage = intval(get_query_var('paged'));
// determine the starting page number of the nav control
// figure out where to start and end the nav control numbering as well as what arrow elements we need on each end, if any
$start = $curpage - round(($for/2),0) + 1;
if ( ($start + $for) > $pages ) { $start = $pages - $for + 1; }
if ($start < 1) { $start = 1; }
if ( ($start + $for) > $pages ) { $for = $pages - $start + 1; }
$before = 0;
if ($start > 2) {
$before = 2;
} elseif ($start > 1) {
$before = 1;
}
$after = $pages - ($start + $for - 1);
if ($after > 2) {
$after = 2;
} elseif ( $after < 0) {
$after = 0;
}
// now build out the navigation page control elements
$nav = '- ';
if ($before == 1) {
$nav .= '
- < '; } elseif ($before == 2) { $nav .= '
- « '; $nav .= '
- < '; } for ($i=$start;$i<=($start+$for-1);$i++) { if ($i == 1) { $pagenav = $paged_1; } else { $pagenav = $paged . $i . $paged_end; } if ($curpage!=$i) { $nav .= '
- '; } if ($after == 1) { $nav .= '
- > '; } elseif ($after == 2) { $nav .= '
- > '; $nav .= '
- » '; } $nav .= '
' . $nav . '
';
if ($class == "wpprojects_nav_top") {
$navcontrol = $nav;
}
}
return $portfolio_output;
}
add_filter( 'parse_query', 'wpprojects_portfolio_search_filter' );
add_action( 'restrict_manage_posts', 'wpprojects_portfolio_search_filter_downlist' );
function wpprojects_portfolio_search_filter( $query )
{
global $pagenow;
if ( is_admin() && $pagenow=='edit.php' && isset($_GET['sfname']) && $_GET['sfname'] != '') {
$query->set('meta_key',$_GET['sfname']);
if (isset($_GET['sfvalue']) && $_GET['sfvalue'] != '')
$query->set('meta_value',$_GET['sfvalue']);
$query->set( 'meta_compare', 'LIKE' );
}
}
function wpprojects_portfolio_search_filter_downlist()
{
$ptype = isset($_REQUEST['post_type'])? $_REQUEST['post_type']:'';
if($ptype == 'wpprojects_portfolio'):
$drop_down_array = array( array('_clientname'=>'Client Name'),
array('_clientemail'=> 'Client Email'),
array('_siteurl'=> 'Website URL'),
array('_clientrecommendation'=> 'CR-Received'),
);
?>
');
$is_mysql_valid = version_compare($wpdb->db_version(), '5.0.0', '>');
$is_wp_valid = version_compare(get_bloginfo("version"), '3.0.0', '>');
$meets_requirements = ($is_php_valid && $is_mysql_valid && $is_wp_valid);
$class = $meets_requirements ? "update-message" : "error";
if ( !$meets_requirements ) {
$top_message_head = "