function notify_artist($id)
{
global $wpdb;
// this is to notify artist about download of the $id image
$max_downloads = get_option('max_downloads');
// how many download attempts left?
//$sql = "select downloads from wp_download_status where $id=".$id." and active=1 LIMIT 1";
$sql = "SELECT c.price, st.purchid as zakaz, st.downloads, p.id as imageid, p.image as filename, p.name as cartoonname, p.description as description, \r\n\t\t\t\t\tu.user_email as email, b.name as artist\r\n\t\t\tFROM wp_download_status AS st, wp_product_list AS p, wp_users AS u, wp_product_brands AS b, wp_cart_contents as c\r\n\t\t\tWHERE st.fileid = p.file\r\n\t\t\tAND b.id = p.brand\r\n\t\t\tAND b.user_id = u.id\r\n\t\t\tAND c.purchaseid = st.purchid\r\n\t\t\tAND st.id =" . $id;
$downloads_left = $wpdb->get_results($sql, ARRAY_A);
// actual downloads_left
$downloads = $downloads_left[0]['downloads'];
// actual downloads_left
if ($downloads == $max_downloads - 1) {
// if this is a first download of the file
send_email_to_artist($downloads_left[0]['price'], $downloads_left[0]['imageid'], $downloads_left[0]['filename'], $downloads_left[0]['cartoonname'], $downloads_left[0]['description'], $downloads_left[0]['artist'], $downloads_left[0]['email']);
//rise clear flag
$sql = "UPDATE wp_options SET `option_value`=1 WHERE `option_name` = 'clearmycache'";
$result = mysql_query($sql);
}
return;
}
function notify_artist($id)
{
global $wpdb;
// this is to notify artist about download of the $id image
$max_downloads = 5;
// how many download attempts left?
//$sql = "select downloads from wp_download_status where $id=".$id." and active=1 LIMIT 1";
$sql = "SELECT c.price, st.purchid as zakaz, st.downloads, p.id as imageid, p.image as filename, p.name as cartoonname, p.description as description, \r\nu.user_email as email, b.name as artist\r\nFROM \r\nwp_purchase_logs as plog,\r\nwp_download_status AS st, \r\nwp_product_list AS p, \r\nwp_users AS u, \r\nwp_product_brands AS b, \r\nwp_cart_contents as c\r\nWHERE \r\nplog.id = " . $id . " AND\r\nplog.id = st.purchid AND\r\nplog.id = c.purchaseid AND\r\np.id = st.fileid AND\r\np.brand = b.id AND\r\nu.id = b.user_id\r\nlimit 1";
//pokazh($sql);
$result = mysql_query("{$sql}");
if (!$result) {
die('Invalid query: ' . mysql_error());
}
//pokazh($result,"111");
while ($row = mysql_fetch_array($result)) {
//pokazh($row,"row");
$downloads = $row['downloads'];
$price = $row['price'];
$imageid = $row['imageid'];
$filename = $row['filename'];
$cartoonname = $row['cartoonname'];
$description = $row['description'];
$artist = $row['artist'];
$email = $row['email'];
}
send_email_to_artist($price, $imageid, $filename, $cartoonname, $description, $artist, $email);
return;
}
