Advertisement
Guest User

Syntax error on line 51?!

a guest
Mar 18th, 2012
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.22 KB | None | 0 0
  1. <?php
  2.   define('CLAIMS', true);
  3.  
  4.   require_once 'includes/inc.core.php';
  5.  
  6.   $data = array('success' => false);
  7.  
  8.   if($_GET['action'] == 'scores')
  9.   {
  10.     $query = 'SELECT
  11.                Hole1,
  12.                Hole2,
  13.                Hole3,
  14.                Hole4,
  15.                Hole5,
  16.                Hole6,
  17.                Hole7,
  18.                Hole8,
  19.                Hole9,
  20.                Putts1,
  21.                Putts2,
  22.                Putts3,
  23.                Putts4,
  24.                Putts5,
  25.                Putts6,
  26.                Putts7,
  27.                Putts8,
  28.                Putts9,
  29.                TotalPutts,
  30.                Gross,
  31.                AttendanceOnly
  32.              FROM
  33.                tblScores
  34.              WHERE
  35.                PlayerID = :player_id AND
  36.                GroupValue = :group_id AND
  37.                SeasonYear = :year AND
  38.                PlayDate = :date
  39.              LIMIT 1';
  40.     $stmt = $database->prepare($query);
  41.     $stmt->execute(array(
  42.       ':player_id' => $_GET['player_id'],
  43.       ':group_id' => $_GET['group_id'],
  44.       ':year' => $_GET['year'],
  45.       ':date' => $_GET['date']
  46.     ));
  47.    
  48.     $data['success'] = true;
  49.     $scores = $stmt->fetch(PDO::FETCH_ASSOC);
  50.  
  51.     array_walk($scores, function(&$data) {
  52.       if($data == null)
  53.         $data = 0;
  54.     });
  55.     $data += $scores;
  56.   }
  57.   else if($_GET['action'] == 'list_members')
  58.   {
  59.     $query = 'SELECT
  60.                CONCAT(l.field_user_last_value, ", ", f.field_user_first_value) AS name,
  61.                u.uid AS id,
  62.                s.GroupValue AS group_id
  63.              FROM
  64.                dr_users AS u
  65.                JOIN
  66.                  (dr_users_roles AS ur
  67.                    JOIN
  68.                      dr_role AS r
  69.                      ON
  70.                        ur.rid = r.rid AND
  71.                        r.name = "player"
  72.                  )
  73.                  ON
  74.                    ur.uid = u.uid
  75.                JOIN
  76.                  dr_field_data_field_user_first AS f
  77.                  ON
  78.                    f.entity_id = u.uid AND
  79.                    f.entity_type = "user"
  80.                JOIN
  81.                  dr_field_data_field_user_last AS l
  82.                  ON
  83.                    l.entity_id = u.uid AND
  84.                    l.entity_type = "user"
  85.                LEFT OUTER JOIN
  86.                  tblScores AS s
  87.                  ON
  88.                    s.PlayerID = u.uid AND
  89.                    s.SeasonYear = "' . $_SESSION['event']['year'] . '" AND
  90.                    s.PlayDate = "' . $_SESSION['event']['date'] . '"';
  91.  
  92.     $stmt = $database->query($query);
  93.     $players = $stmt->fetchAll(PDO::FETCH_ASSOC);
  94.     $data['aaData'] = array();
  95.     $data['success'] = true;
  96.     foreach($players as $player)
  97.     {
  98.       $data['aaData'][] = array(
  99.         $player['id'],
  100.         $player['name'],
  101.         $player['group_id'],
  102.         '<span class="addPlayer"><a href="#" onclick="addToGroup(this); return false">Add to Group</a></span><span class="removePlayer"><a href="#" onclick="removeFromGroup(this); return false">Remove from Group</a></span>'
  103.       );
  104.     }
  105.   }
  106.  
  107.   header('Content-type: application/json');
  108.   echo json_encode($data);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement