SQL query – get ids – Advanced Custom Fields / WPeC

Thanks for your help s_ha_dum, I had a look at the table structure using phpMyAdmin, ACF Plugin saves fields to the postmeta table, so sb_wpsc_meta needed to be changed to sb_postmeta. also needed to change what was being SELECT to post_id aswell as the meta_value to 1. final query; “SELECT post_id FROM sb_postmeta WHERE `meta_key` … Read more

Hook functions for Wp e-commerce? [closed]

1.customer register success event WordPress: user_register 2.customer login WordPress: wp_login 3.sales order place after WP E-Commerce: wpsc_purchase_log_save 4.Hook function to change order shipping status from wp-admin end WP E-Commerce: wpsc_update_purchase_log_status To identify the status: INCOMPLETE_SALE = 1; ORDER_RECEIVED = 2; ACCEPTED_PAYMENT = 3; JOB_DISPATCHED = 4; CLOSED_ORDER = 5; PAYMENT_DECLINED = 6; REFUNDED = 7; … Read more

Convert featured images into “product images”

That sounds weird because post thumbnails were changed to Featured Images with WP 3.0. I guess you’re talking about some custom field or metabox your framework adds on post edit. You could grab _thumbnail_id which is the key in the wp_postmeta table that stores what you’re looking for. But to me you’d better usewp_get_attachment_img_src: if(has_post_thumbnail($post->ID)) … Read more

WPSC how do i output product per category on one page (wpsc-product-page)

You need to do 2 queries, 1 for the terms (using get_terms) and then a post query, an example is: $taxonomy = ‘portfolio_types’; $tax_terms = get_terms($taxonomy); foreach ($tax_terms as $tax_term) { echo ‘<li>’ . ‘<a href=”#’.$tax_term->slug.'”‘ . ‘>’ . $tax_term->name.'</a></li>’; } endwhile; endif; wp_reset_query(); $the_query = new WP_Query( ‘post_type=portfolio&portfolio_types=”$taxonomy ); while ( $the_query->have_posts() ) : … Read more

Ecommerce Single Product Next Product Link

next_post function is deprecated. You should try this instead: next_post_link and previous_post_link The basic way to use it is like so: This will link to the next post or prev post. <?php next_post_link( ‘%link’, ‘%title’ ); previous_post_link( ‘%link’, ‘%title’ ); ?> If you would like to link to the next post in the same category, … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)