require_once('../include/database2.inc.php'); require_once('include/inc_colstr.php'); // Open DB connection. $pldb = new PluribDatabase(); $pldb->OpenConnection(); $browserID = CsBrowser::Browser_Register(); $pngID = $_GET['pngID']; if ($pngID . "" == "") { echo "pngID not found."; exit(); } $png_ar = $pldb->GetResultsAsNestedArray("SELECT * " . "FROM colstr_png WHERE pngID = " . ValToSQL_num($pngID) . ";", 1); if (count($png_ar) == 0) { echo "Error. can't find png."; exit(); } $png_r = $png_ar[0]; $upload_ar = $pldb->GetResultsAsNestedArray("SELECT upl.*, " . "CASE WHEN (SELECT COUNT(*) FROM colstr_uploadBrowser ubr WHERE ubr.uploadID = upl.uploadID AND ubr.browserID = " . ValToSQL_num($browserID) . ") = 0 THEN 0 ELSE 1 END AS browserAuth " . "FROM colstr_upload upl WHERE uploadID = " . ValToSQL_num($png_r['uploadID']) . ";", 1); $upload_r = $upload_ar[0]; ?>