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);
