How i can get expiration date of premium, which extended by user?
I want to extand expiration day of ads on duration for premium.
I use

$expire = date('Y-m-d H:i:s', strtotime(" + " . $hours . " hours", strtotime($curr_date)));
Item::newInstance()->dao->query(sprintf('UPDATE %st_item SET dt_expiration = "%s" WHERE pk_i_id = %d', DB_TABLE_PREFIX, $expire, $item_id));
Its work good, when user buy premium at first, but when he extend i can not get date of expiration premium and extend expiration date of ads from this date.
I found $duration = $product[2]; in fuction osp_product_title($product), this return date of expiration premium, but it does not work on function osp_pay_fee($details)

Premium "label" cannot extend expiration date of item, there is republish option for that. Expiration date is saved in _osp_item table with code 201 and item id.

Premium "label" cannot extend expiration date of item, there is republish option for that. Expiration date is saved in _osp_item table with code 201 and item id.

Thanks, i know that premium lable can not extend expiration day. And republish option dont extend to. Republish only change publish date.
Can you help me with custom query for premium lable expiration date. How i can select it for assign a value to a variable

Republish update expiration date, to update publish date only you can use move to top feature.