function SendNotificationToNextAttacker($clanID) { $db = new BaseDB(); $sql = "\n SELECT p.GameName, gcmu.gcm_regid\n FROM dbo.OurParticipant AS op INNER JOIN\n dbo.Player AS p ON op.PlayerID = p.PlayerID INNER JOIN\n dbo.gcm_users AS gcmu ON p.GameName = gcmu.game_name\n WHERE op.NextAttacker = 1 AND ClanID = {$clanID}\n "; $result = $db->dbQuery($sql); while ($record = sqlsrv_fetch_array($result, SQLSRV_FETCH_BOTH)) { $registatoin_ids[0] = $record['gcm_regid']; $msg = array("data" => "cal" . $record['GameName'] . " it is your turn to attack!"); send_push_notification($registatoin_ids, $msg); } $db->Free($result); $db->close(); }
<?php include_once "BaseClasses/BaseDB.class.php"; include_once "BaseClasses/Database.class.php"; $warID = $_REQUEST['selectedWarID']; $db = new BaseDB(); $sql = "\n select GameName,\n CASE FirstAttack\n WHEN 1 THEN 'First'\n WHEN 0 THEN 'Second'\n END AS Attack,\n StarsTaken,\n OurRank,\n TheirRank\n FROM View_WarProgress\n WHERE WarID = {$warID} AND OurAttack = 1 ORDER BY OurRank ASC, FirstAttack DESC\n "; $records = $db->dbQuery($sql); $data = array(); $i = 0; if (!$records) { $data['stats'][0] = array('GameName' => '', 'Attack' => '', 'StarsTaken' => 0, 'OurRank' => 0, 'TheirRank' => 0); } else { while ($record = sqlsrv_fetch_array($records, SQLSRV_FETCH_BOTH)) { $data['stats'][$i] = array('GameName' => $record['GameName'], 'Attack' => $record['Attack'], 'StarsTaken' => $record['StarsTaken'], 'OurRank' => $record['OurRank'], 'TheirRank' => $record['TheirRank']); $i++; } } $db->Free($records); $db->close(); echo json_encode($data);
<?php include_once "BaseClasses/BaseDB.class.php"; include_once "BaseClasses/Database.class.php"; $warID = $_REQUEST['selectedWarID']; $db = new BaseDB(); $sql = "\n SELECT TOP (1) dbo.Attack.BusyAttackingRank, dbo.Player.GameName\n FROM dbo.Attack INNER JOIN\n dbo.OurParticipant ON dbo.Attack.OurParticipantID = dbo.OurParticipant.OurParticipantID INNER JOIN\n dbo.Player ON dbo.OurParticipant.PlayerID = dbo.Player.PlayerID\n WHERE (ISNULL(dbo.Attack.BusyAttackingRank, - 1) <> - 1) AND (dbo.Attack.OurAttack = 1) AND (dbo.Attack.WarID = {$warID}) AND (dbo.Attack.BusyAttackingRank > 0)\n GROUP BY dbo.Attack.BusyAttackingRank, dbo.Attack.AttackID, dbo.Attack.OurAttack, dbo.Attack.WarID, dbo.Player.GameName\n "; $result = $db->dbQuery($sql); $record = sqlsrv_fetch_array($result, SQLSRV_FETCH_BOTH); $data = array(); if (!$record) { $data['busyAttackingRank'][0] = array('rank' => 0); } else { $data['busyAttackingRank'][0] = array('rank' => $record['BusyAttackingRank'], 'gameName' => $record['GameName']); } $db->Free($result); $db->close(); echo json_encode($data);