How to access/add specific prices of products through modules?

[Adeel Ahmad]

How to access/add specific prices of products through modules? In which table stores this information? Also, in phpmyadmin, I cannot find ps_product table. Can someone guide me? Thanks. 

[Ress]

Informations about specific prices are in ps_specific_price.

In php, you can get from the database the discount rule for a product like this:

$specific_price = SpecificPrice::getSpecificPrice(
	(int) $id_product,
	$id_shop,
	$id_currency,
	$id_country,
	$id_group,
	$quantity,
	$id_product_attribute,
	$id_customer,
	$id_cart,
	$real_quantity
);