ID
| Title | Format | Category | Avg Per Day | Total Played | Status | Edit | View | ');
$cnt=0;
$result = mysql_query("select d.data_id,d.url,title,cat_string,format_name,d.status,d.created_dt,".
"(TO_DAYS(now())-TO_DAYS(d.created_dt)) numdays,".
"(hit_cnt+hit_quick) as total".
" from ap_".TABLE_NAME."_data d,ap_".TABLE_NAME."_cat c,ref_format rf where d.status in (0,1,5) and d.format_id=rf.format_id and d.member_id=".$gbUserID." and d.cat_id=c.cat_id",$db);
while( ($row = mysql_fetch_array($result)) != FALSE ){
$avghit=$row['total'];
$status="";
switch($row['status']){
case 0: $status="Pending";break;
case 1: $status="Approved";break;
case 2: $status="Not Approved";break;
case 5: $status="Edited Review";break;
}
if($row['numdays']!=0)$avghit=floor($row['total']/$row['numdays']);
print(''.
'| '.$row['data_id'].' | '.
''.$row['title'].' | '.
''.$row['format_name'].' | '.
''.$row['cat_string'].' | '.
''.$avghit.' | '.
''.$row['total'].' | '.
''.$status.' | '.
'edit | '.
'view |
');
$cnt++;
}
if($cnt==0){
print('
no '.DES_NAME.'s added
|
');
}
print('+ add new '.DES_NAME.'
|
'.boxfoot());
mysql_close($db);
require("../inc/apodfoot_noad.php");
//=======================================================================
?>