settings['title']);
pdp_menu();
$query_id = dbquery("SELECT user_name"
." FROM ".DB_PREFIX."users"
." WHERE user_id='$id'");
if(!dbrows($query_id)) {
fallback("download.php");
}
echo "
".array_shift(dbarray($query_id)).":"
." "
.$locale['PDP161']."
\n";
echo "
";
if(iPDP_MOD) {
$where = "";
} elseif(iMEMBER) {
$where = " AND ((dl_status='".PDP_PRO_ON."'"
.($pdp->settings['hide_user_allow']=="yes"
? " AND hide_user='no')"
: ")")
." OR user_id='".$userdata['user_id']."')";
} else {
$where = " AND dl_status='".PDP_PRO_ON."'";
if($pdp->settings['hide_user_allow']=="yes") {
$where .= "AND hide_user='no'";
}
}
$query_id = dbquery("SELECT dl_name, download_id, dl_status, dl_broken_count,"
." cat_name, cat_access, dl.cat_id, hide_user"
." FROM ".DB_PREFIX."pdp_downloads AS dl"
." LEFT JOIN ".DB_PREFIX."pdp_cats AS c"
." ON dl.cat_id=c.cat_id"
." WHERE user_id='$id' $where"
." ORDER BY dl_status, dl_name ASC");
$last_status = "";
$found = 0;
$more = array();
while($data = dbarray($query_id)) {
if(!pdpCore::check_access($data['cat_access'])) {
continue;
}
if($last_status != $data['dl_status']) {
if(!empty($last_status)) {
echo "\n";
}
$last_status = $data['dl_status'];
echo "".$locale['PDP904'][$last_status].":\n";
}
if(iPDP_MOD || (iMEMBER && $userdata['user_id']==$id)) {
$more = array();
if($data['dl_broken_count']>0) {
$more[] = $locale['PDP163'];
}
if($pdp->settings['hide_user_allow']=="yes"
&& $data['hide_user']=="yes") {
$more[] = $locale['PDP162'];
}
}
echo "- ";
if(($last_status==PDP_PRO_DEL || $last_status==PDP_PRO_CHECK
|| ($last_status==PDP_PRO_OFF && !$pdp->settings['user_edit']))
&& !iPDP_MOD) {
echo $data['dl_name'];
} elseif($last_status==PDP_PRO_NEW) {
echo ""
.$data['dl_name']."";
} else {
echo ""
.$data['dl_name']."";
}
if(count($more)) {
echo " (".implode(", ", $more).")";
}
echo "
\n";
$found++;
}
if(dbrows($query_id)) {
echo "
\n";
}
if($found==0) {
echo $locale['PDP022'];
}
closetable();
/*
* subscriptions
*/
if(iMEMBER && $id==$userdata['user_id']) {
tablebreak();
opentable($locale['PDP164']);
if($pdp->settings['allow_notify']=="no") {
echo "".$locale['PDP057']."\n";
}
$query_id = dbquery("SELECT dl_name, n.download_id, visited"
." FROM ".DB_PREFIX."pdp_notify AS n"
." LEFT JOIN ".DB_PREFIX."pdp_downloads AS d"
." ON n.download_id=d.download_id"
." WHERE n.user_id='$id'"
." ORDER BY dl_name ASC");
if(!dbrows($query_id)) {
echo "
".$locale['PDP058']."\n";
} else {
echo "
\n";
}
while($data = dbarray($query_id)) {
echo "- "
.$data['dl_name']."";
if($data['visited']=="no") {
echo " (".$locale['PDP003'].")";
}
echo "
\n";
}
if(dbrows($query_id)) {
echo "
\n";
}
closetable();
}
require_once(BASEDIR."side_right.php");
require_once(BASEDIR."footer.php");
?>