How to display total sold item counts on user profile and sidebar of item.php under user profile option.

@ishan
Theme does not have such feature. You need to query tables t_item, t_item_veronika, restrict results on logged in user and sum rows where i_sold = 1

thanks for your reply,

but i dont know how to use these query so can you mention in detail the i will mention on my site.

please give me code of below query, then i will use it

@ishan
Theme does not have such feature. You need to query tables t_item, t_item_veronika, restrict results on logged in user and sum rows where i_sold = 1

@ishan
If I would had it, I would post it there. You can start with:

select count(v.i_sold) from prefix_t_item i, prefix_t_item_veronika v where i.pk_i_id = v.fk_i_item_id and i.fk_i_user_id = ' . osc_logged_user_id() . '

<?php $conn = getConnection(); $sold_items = $conn->osc_dbFetchresult("select count(v.i_sold) from prefix_t_item i, prefix_t_item_veronika v where i.pk_i_id = v.fk_i_item_id and i.fk_i_user_id = ' . osc_logged_user_id() . '", DB_TABLE_PREFIX, osc_logged_user_id()) ;?>
<?php echo $sold_items;?>

Can you tell me this code is  ok ?

@ishan

<?php 
  $conn = getConnection(); 
  $sold_items = $conn->osc_dbFetchresult(sprintf('select count(v.i_sold) from %st_item i, %st_item_veronika v where i.pk_i_id = v.fk_i_item_id and i.fk_i_user_id = %d', DB_TABLE_PREFIX, DB_TABLE_PREFIX, osc_logged_user_id()));

  print_r($sold_items);
?>


maybe this one

@ishan

Code: [Select]

<?php 
  $conn = getConnection(); 
  $sold_items = $conn->osc_dbFetchresult(sprintf('select count(v.i_sold) from %st_item i, %st_item_veronika v where i.pk_i_id = v.fk_i_item_id and i.fk_i_user_id = %d', DB_TABLE_PREFIX, DB_TABLE_PREFIX, osc_logged_user_id()));

  print_r($sold_items);
?>


maybe this one

i tried above code in item.php . but i am facing below error. so please solve this error.

Array ([count(v.i_sold)] => 0)