function getPlayerID($gameName, $clanID)
{
$db = new BaseDB();
$records = $db->dbQuery("SELECT PlayerID from Player WHERE GameName = '{$gameName}' AND ClanID = {$clanID}");
if (sqlsrv_has_rows($records)) {
$record = sqlsrv_fetch_array($records, SQLSRV_FETCH_BOTH);
return $record['PlayerID'];
} else {
return null;
}
}
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
session_start();
$clanID = $_SESSION['selectedClanID'];
include_once "BaseClasses/BaseDB.class.php";
include_once "BaseClasses/Database.class.php";
$warDate = $_REQUEST['wardate'];
$NumberOfParticipants = $_REQUEST['numberofparticipants'];
$WarsWeWon = $_REQUEST['warswewon'];
$WarsTheyWon = $_REQUEST['warstheywon'];
$active = $_REQUEST['active'];
$db = new BaseDB();
$sql = "insert into War(ClanId, date, NumberOfParticipants, WarsWeWon, WarsTheyWon, active) values(\n {$clanID}, '{$warDate}','{$NumberOfParticipants}', '{$WarsWeWon}', '{$WarsTheyWon}', '{$active}')";
$result = $db->dbQuery($sql);
if ($result == false) {
echo json_encode(['errorMsg' => 'An error occured: ' . dbGetErrorMsg()]);
} else {
echo json_encode(['success' => 'success']);
}
// if ($result == false) {
// echo json_encode([
// 'errorMsg' => 'An error occured: ' . dbGetErrorMsg()
// ]);
// } else {
// $sqlIdentity = "select @@identity as EntityId";
// $resultWarID = sqlsrv_query(Database::getInstance()->getConnection(), $sqlIdentity);
// $rowIdentity = sqlsrv_fetch_array($resultWarID);
// $WarID = $rowIdentity["EntityId"];
// }
<?php
session_start();
$selectedWarID = $_SESSION["selectedWarID"];
include_once "BaseClasses/BaseDB.class.php";
include_once "BaseClasses/Database.class.php";
$i = 0;
$dbBaseClass = new BaseDB();
$sql = "\n SELECT atk.AttackID, atk.OurAttack, atk.FirstAttack, atk.OurParticipantID,\n atk.TheirParticipantID, atk.StarsTaken, dbo.Player.GameName,\n dbo.TheirParticipant.Rank,\n CONCAT(dbo.Player.GameName, ' (#', part.Rank, ')') As OurParticipant,\n CONCAT('Rank (#', dbo.TheirParticipant.Rank, ')') As TheirParticipant\n FROM dbo.TheirParticipant RIGHT OUTER JOIN\n dbo.Attack AS atk ON dbo.TheirParticipant.TheirParticipantID = atk.TheirParticipantID LEFT OUTER JOIN\n dbo.Player INNER JOIN\n dbo.OurParticipant AS part ON dbo.Player.PlayerID = part.PlayerID ON atk.OurParticipantID = part.OurParticipantID\n WHERE (atk.OurAttack = 0) AND (atk.WarID = {$selectedWarID})\n ORDER BY atk.TimeOfAttack DESC\n ";
$records = $dbBaseClass->dbQuery($sql);
while ($record = sqlsrv_fetch_array($records, SQLSRV_FETCH_BOTH)) {
$data[$i++] = array('ourparticipant' => $record['OurParticipant'], 'theirparticipant' => $record['TheirParticipant'], 'attackid' => $record['AttackID'], 'ourattack' => 0, 'firstattack' => $record['FirstAttack'], 'ourparticipantid' => $record['OurParticipantID'], 'theirparticipantid' => $record['TheirParticipantID'], 'starstaken' => $record['StarsTaken'], 'gamename' => $record['GameName']);
}
echo json_encode($data);
<?php
require_once 'GCM_Loader.php';
$selectedWarID = $_REQUEST['selectedWarID'];
$ownRank = $_REQUEST['rank'];
$db = new BaseDB();
//TODO Remember to change the hardcoded '0' (RankByExperience) below -> BIT
$sql_callFunc = "SELECT (SELECT dbo.[PlayersNextBestAttack]({$selectedWarID}, {$ownRank}, 0) AS RankToAttack) AS RankToAttack";
$result = $db->dbQuery($sql_callFunc);
$rankToAttack = 0;
$err = "";
$record = sqlsrv_fetch_array($result, SQLSRV_FETCH_BOTH);
if ($record == false) {
$err = dbGetErrorMsg();
}
$db->Free($result);
$db->close();
$data['rankToAttack'][0] = array('rank' => $record['RankToAttack']);
echo json_encode($data);
<?php
session_start();
if (!isset($_SESSION["selectedClanID"])) {
header("Location: Index.php?err=You must sign in first.");
die;
}
$selectedClanID = $_SESSION["selectedClanID"];
include_once "BaseClasses/BaseDB.class.php";
include_once "BaseClasses/Database.class.php";
$i = 0;
$dbBaseClass = new BaseDB();
$activeOnly = $_REQUEST['activeonly'];
if ($activeOnly === 1) {
$records = $dbBaseClass->dbQuery("SELECT PlayerID, GameName, RealName, Active FROM Player\n WHERE active=1 AND ClanID = {$selectedClanID}");
} else {
$records = $dbBaseClass->dbQuery("SELECT PlayerID, GameName, RealName, Active FROM Player\n WHERE ClanID = {$selectedClanID}");
}
$data = array();
while ($record = sqlsrv_fetch_array($records, SQLSRV_FETCH_BOTH)) {
$data[$i++] = array('playerid' => $record['PlayerID'], 'gamename' => $record['GameName'], 'realname' => $record['RealName'], 'active' => $record['Active']);
}
echo json_encode($data);
<?php
include_once "BaseClasses/BaseDB.class.php";
include_once "BaseClasses/Database.class.php";
$warID = $_REQUEST['warid'];
$warDate = $_REQUEST['wardate'];
$NumberOfParticipants = $_REQUEST['numberofparticipants'];
$WarsWeWon = $_REQUEST['warswewon'];
$WarsTheyWon = $_REQUEST['warstheywon'];
$active = $_REQUEST['active'];
$i = 0;
$dbBaseClass = new BaseDB();
$sql = "UPDATE WAR SET Date = '{$warDate}', NumberOfParticipants = {$NumberOfParticipants},\n WarsWeWon = {$WarsWeWon}, WarsTheyWon = {$WarsTheyWon}, Active = {$active} WHERE WarID = {$warID}";
$result = $dbBaseClass->dbQuery($sql);
if ($result == false) {
echo json_encode(['errorMsg' => 'An error occured: ' . dbGetErrorMsg()]);
} else {
echo json_encode(['success' => 'success']);
}
// session_start();
include_once "menu.php";
if (!isset($_SESSION["selectedClanID"])) {
header("Location: Index.php?err=You must sign in first.");
die;
}
include_once "BaseClasses/BaseDB.class.php";
include_once "BaseClasses/Database.class.php";
$clanID = $_SESSION["selectedClanID"];
$selectedWarID = $_REQUEST['selectedWarID'];
// Set session variables
$_SESSION["selectedWarID"] = "{$selectedWarID}";
$db = new BaseDB();
// Delete existing attacks for this war
$sql = "DELETE FROM ATTACK WHERE WarID = {$selectedWarID}";
$result = $db->dbQuery($sql);
if ($result == false) {
echo json_encode(['errorMsg' => 'An error occured: ' . dbGetErrorMsg()]);
goto endOfFunction;
}
$sql = "SELECT OurParticipantID FROM OurParticipant WHERE WarID = {$selectedWarID}";
$records = $db->dbQuery($sql);
while ($record = sqlsrv_fetch_array($records, SQLSRV_FETCH_BOTH)) {
// Insert both attack records for each of our contestants
// First Attack
$sql = "INSERT INTO Attack(WarID, OurAttack, FirstAttack, OurParticipantID, TheirParticipantID, StarsTaken)\n VALUES ({$selectedWarID}, 1, 1, {$record['OurParticipantID']}, 0, null)";
$result = $db->dbQuery($sql);
if ($result == false) {
echo json_encode(['errorMsg' => 'An error occured: ' . dbGetErrorMsg()]);
goto endOfFunction;
}
<?php
$noWarID = false;
$selectedWarID = 0;
require_once 'GCM_Loader.php';
if ($_REQUEST['selectedWarID'] = 0) {
$noWarID = true;
} else {
$noWarID = false;
}
$clanID = $_REQUEST['clanID'];
$db = new BaseDB();
// If no warid was send (WarID = 0) then use the first War that is active
if ($noWarID == false) {
$sql = "\n SELECT TOP(1) WarID FROM War WHERE Active = 1 AND ClanId = {$clanID}\n ";
$records = $db->dbQuery($sql);
$record = sqlsrv_fetch_array($records, SQLSRV_FETCH_BOTH);
$selectedWarID = $record['WarID'];
} else {
$selectedWarID = $_SESSION["selectedWarID"];
}
// increment visits counter
$sql = "UPDATE Visits SET visits = visits + 1 WHERE id = 1";
$result = $db->dbQuery($sql);
$i = 0;
$sql = "\n SELECT dbo.Player.PlayerID, dbo.Player.GameName, dbo.Player.RealName, dbo.OurParticipant.Rank,\n dbo.OurParticipant.Experience, dbo.OurParticipant.TownHallLevel, dbo.OurParticipant.OurParticipantID, dbo.OurParticipant.WarID\n FROM\n dbo.Player LEFT OUTER JOIN\n dbo.OurParticipant ON dbo.Player.PlayerID = dbo.OurParticipant.PlayerID\n WHERE\n --TODO Change value of RankByExperience ('0')\n (dbo.Player.Active = 1 AND WarID = {$selectedWarID}) AND ((SELECT [dbo].[GetNumberOfAttacks]({$selectedWarID}, Rank, 0)) < 2) ORDER BY Rank\n ";
$result = $db->dbQuery($sql);
$data = array();
while ($record = sqlsrv_fetch_array($result, SQLSRV_FETCH_BOTH)) {
$data['warParticipants'][$i++] = array('playerid' => $record['PlayerID'], 'gamename' => $record['GameName'], 'realname' => $record['RealName'], 'rank' => $record['Rank'], 'experience' => $record['Experience'], 'townhalllevel' => $record['TownHallLevel'], 'ourparticipantid' => $record['OurParticipantID'], 'warid' => $record['WarID']);
}
