function getACRate($userID) { $query = "select \r\n(select count(distinct p.pojProblemID) from problems as p where p.stat=0 ) as allPcount,\r\n(select count(distinct p.pojProblemID) from problems as p, score as s ,user as u where p.stat=0 and s.stat=0 and u.stat=0 and p.id=s.probID and s.AC=1 and s.userID={$userID}) as allAC,\r\n(select count(distinct p.pojProblemID) from problems as p where p.stat=0 and p.level=1) as teamPcount,\r\n(select count(distinct p.pojProblemID) from problems as p, score as s ,user as u where p.stat=0 and s.stat=0 and u.stat=0 and p.id=s.probID and s.AC=1 and p.level=u.team and s.userID=u.id and u.id={$userID}) as teamAC,\r\n(select count(distinct p.pojProblemID) from problems as p where p.userID={$userID}) as userPCount,\r\n(select count(distinct p.pojProblemID) from problems as p ,score as s,user as u where p.stat=0 and s.stat=0 and u.stat=0 and p.userID={$userID} and s.probID=p.id and s.AC=1) as ACed"; return mydb_query_return_first_item($query); }
<?php require_once 'include/db_operator_class.php'; include 'permission.php'; if (isset($_GET['userID'])) { $userId = $_GET['userID']; $query = "SELECT u.photoPath,u.photoType FROM user AS u where id={$userId}"; $result = mydb_query_return_first_item($query); $data = $result['photoPath']; // $type = $result['photoType']; // header( "Content-type: $type"); echo $data; // echo urldecode(json_encode(urlencode($data))); }