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']); }