????JFIF??x?x????'
| Server IP : 79.136.114.73 / Your IP : 216.73.216.55 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/appsrv.astacus.se/apps/school/OLD/PokemonGo/ |
Upload File : |
<?php
require_once('connection.php');
$ChildId = $_GET['ChildId'];
$PokemonId = $_GET['PokemonId'];
$sql = "SELECT CachedPokemonIds, ParentId from tblChildren WHERE Id=$ChildId";
$result = mysql_query($sql);
$rowValue = mysql_fetch_assoc($result);
//echo "<br>$rowValue";
if ($rowValue)
{
$CachedPokemonIds = $rowValue['CachedPokemonIds'];
$ParentId = $rowValue['ParentId'];
//echo "<br>ParentId: $ParentId<br>";
//echo "<br>CachedPokemonIds: $CachedPokemonIds";
$suffix = ($CachedPokemonIds == "") ? "$PokemonId" : ",$PokemonId";
$FinalCachedPokemonIds = "$CachedPokemonIds$suffix";
//echo "<br>FinalCachedPokemonIds: $FinalCachedPokemonIds<br>";
$sqlUpdate = "UPDATE tblChildren SET CachedPokemonIds='$FinalCachedPokemonIds' WHERE Id=$ChildId";
mysql_query($sqlUpdate);
$cachedPokemonIdsArray = explode(',', $FinalCachedPokemonIds);
//echo "<br>cachedPokemonIdsArray: $cachedPokemonIdsArray<br>";
$countCachedPokemonIds = count($cachedPokemonIdsArray);
//echo "<br>countCachedPokemonIds: $countCachedPokemonIds<br>";
$querySelect = "SELECT COUNT(*) AS PokemonsCount FROM tblPokemons WHERE ParentId=$ParentId";
$resultSelectStmt = mysql_query($querySelect);
$rowPokemonsCount = mysql_fetch_assoc($resultSelectStmt);
$TotalPokemonsToTheParent = $rowPokemonsCount['PokemonsCount'];
//echo "<br>rowPokemonsCount: $rowPokemonsCount<br>";
//echo "<br>TotalPokemonsToTheParent: $TotalPokemonsToTheParent<br>";
echo "$countCachedPokemonIds:$TotalPokemonsToTheParent";
}
else
{
echo "Child does not exist!";
}
mysql_close($connection);
?>