get_col("SELECT `id` FROM `".$wpdb->prefix."purchase_logs` WHERE user_ID = ".(int)$user_ID."") ;
$rowcount = count($purchases);
//echo "".print_r($purchases,true)."
";
if($rowcount >= 1) {
$perchidstr = "(";
$perchidstr .= implode(',',$purchases);
$perchidstr .= ")";
$sql = "SELECT * FROM `".$wpdb->prefix."download_status` WHERE `purchid` IN ".$perchidstr." AND `active` IN ('1') ORDER BY `datetime` DESC";
$products = $wpdb->get_results($sql,ARRAY_A) ;
}
//exit($products);
foreach ((array)$products as $key => $product){
if($product['uniqueid'] == null) { // if the uniqueid is not equal to null, its "valid", regardless of what it is
$links[] = get_option('siteurl')."?downloadid=".$product['id'];
} else {
$links[] = get_option('siteurl')."?downloadid=".$product['uniqueid'];
}
$sql = "SELECT * FROM `".$wpdb->prefix."product_files` WHERE id = ".(int)$product['fileid']."";
$file = $wpdb->get_results($sql,ARRAY_A) ;
$files[] = $file[0];
}
//exit("---------------".print_r($files,1)."
");
?>
";
?>
0) {
?>
| |
|
|
\n\r";
echo " ";
if ($products[$i]['downloads'] > 0) {
echo "".$file['filename']."";
} else {
echo $file['filename']."";
}
echo " | \n\r";
echo " ".$products[$i]['downloads']." | \n\r";
echo " ".date("j M Y", strtotime($products[$i]['datetime']))." | \n\r";
echo " \n\r";
$i++;
}
?>