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);
$records = $dbBaseClass->getFieldsByFilter('Company', array('id', 'Name', 'CompanyCode', 'Active', 'ShortName'), "WHERE Name LIKE '%{$bc}%'");
} else {
$records = $dbBaseClass->getFieldsForAll('Company', array('id', 'Name', 'CompanyCode', 'Active', 'ShortName'));
}
if ($records === false) {
$_SESSION['error'] = dbGetErrorMsg();
header("Location: Default.php");
exit;
}
//$numFields = sqlsrv_num_fields($records);
echo "<table class='withBorder'>";
echo '<thead>';
echo '<tr></tr><th>Name</th><th>Company Code</th><th>Active</th><th>ShortName</th><th colspan="3">Action</th> <tr></tr>';
echo '<tr>';
echo '</tr>';
echo '</thead>';
while ($record = sqlsrv_fetch_array($records, SQLSRV_FETCH_BOTH)) {
echo "<tr>";
echo "<td>{$record['Name']}</td>";
echo "<td>{$record['CompanyCode']}</td>";
echo "<td>{$record['Active']}</td>";
echo "<td>{$record['ShortName']}</td>";
echo "<td><a href=Company.php?action=r&id={$record['id']}><img src=\"images/icons/view.png\" /></a></td>";
echo "<td><a href=Company.php?action=u&id={$record['id']}><img src=\"images/icons/edit.png\" /></a></td>";
echo "<td><a href=Company.php?action=d&id={$record['id']}><img src=\"images/icons/delete.png\" /></a></td>";
echo "</tr>";
}
echo "</table>";
$dbBaseClass->close();
?>
</body>