????JFIF??x?x????'
Server IP : 79.136.114.73 / Your IP : 18.222.183.98 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); ?>