コード例 #1
0
 public function call()
 {
     $pdo = core\paDB::conn();
     $sql = "SELECT * FROM {$this->paPrefix}_scenes";
     if ($this->args['sceneID']) {
         $sql .= " WHERE id={$this->args['sceneID']}";
     }
     $rs = $pdo->query($sql);
     $output = array();
     $scints = array('id');
     $exints = array("id", "sceneID", "destID");
     $chints = array("id", "isPlayer", "startX", "startY", "startX2", "startY2", "startFrame2");
     foreach ($rs as $row) {
         $rsx = $pdo->query("SELECT * FROM {$this->paPrefix}_sceneExits WHERE sceneID={$row['id']}");
         $row['exits'] = $rsx->fetchAll();
         $rch = $pdo->query("SELECT c.id,c.isPlayer,cs.startX,cs.startY,cs.startFrame,cs.startX2,cs.startY2,cs.startFrame2 FROM {$this->paPrefix}_characterScenes cs JOIN {$this->paPrefix}_characters c on c.id=cs.characterID WHERE cs.sceneID={$row['id']}");
         $row['chars'] = $rch->fetchAll();
         foreach ($scints as $int) {
             $row[$int] = (int) $row[$int];
         }
         //required for sqlite as it returns strings for all variables.
         foreach ($row['exits'] as &$ex) {
             foreach ($exints as $int) {
                 $ex[$int] = (int) $ex[$int];
             }
         }
         foreach ($row['chars'] as &$ch) {
             foreach ($chints as $int) {
                 $ch[$int] = (int) $ch[$int];
             }
         }
         $output[] = $row;
     }
     return $output;
 }
コード例 #2
0
 public function call()
 {
     $output = array();
     $pdo = core\paDB::conn();
     if ($this->args['id']) {
         $old = core\paMain::call(array('module' => 'loadCharacters', 'charID' => $this->args['id']));
         if ($old['success']) {
             $old = $old['results'][0];
         } else {
             throw new core\paException('Failed to load existing character #' . $this->args['id']);
         }
         $chquery = $this->charUpdate($pdo);
         $pdo->query($chquery);
         $output['id'] = $this->args['id'];
         $spquery = $this->spriteUpdate($pdo);
         $pdo->query($spquery);
         $output['spriteID'] = $this->args['spriteID'];
     } else {
         $chquery = $this->charInsert($pdo);
         $pdo->query($chquery);
         $output['id'] = $pdo->lastInsertId();
         $spquery = $this->spriteInsert($pdo);
         $pdo->query($spquery);
         $output['spriteID'] = $pdo->lastInsertId();
     }
     return $output;
 }
コード例 #3
0
 public function call()
 {
     $pdo = core\paDB::conn();
     $sql = "SELECT * FROM {$this->paPrefix}_conversations WHERE saidTo={$this->args['charID']} AND saidBy=1";
     $rs = $pdo->query($sql);
     $output = array();
     foreach ($rs as $row) {
         $output[] = $row;
     }
     return $output;
 }
コード例 #4
0
 public function call()
 {
     $output = array();
     $pdo = core\paDB::conn();
     $queries = array();
     if ($this->args['id']) {
         $old = core\paMain::call(array('module' => 'loadScenes', 'sceneID' => $this->args['id']));
         if ($old['success']) {
             $old = $old['results'][0];
         } else {
             throw new core\paException('Failed to load existing scene #' . $this->args['id']);
         }
         $scquery = $this->sceneUpdate($pdo);
         $pdo->query($scquery);
         $output['id'] = $this->args['id'];
         foreach ($this->args['exits'] as $exit) {
             if ($this->hasExitId($exit, $old['exits'])) {
                 //exit being saved matches an existing one?
                 $queries[] = $this->exitUpdate($pdo, $exit, $output['id']);
                 //then update it
             } else {
                 //otherwise insert it.
                 $queries[] = $this->exitInsert($pdo, $exit, $this->args['id']);
             }
         }
         foreach ($old['exits'] as $oexit) {
             if (!$this->hasExitId($oexit, $this->args['exits'])) {
                 //existing exit isn't in the exit list being saved?
                 $queries[] = $this->exitDelete($pdo, $oexit, $output['id']);
                 //then delete it.
             }
         }
     } else {
         $scquery = $this->sceneInsert($pdo);
         $pdo->query($scquery);
         $output['id'] = $pdo->lastInsertId();
         foreach ($this->args['exits'] as $exit) {
             $queries[] = $this->exitInsert($pdo, $exit, $output['id']);
         }
     }
     foreach ($queries as $query) {
         try {
             if ($query) {
                 $pdo->query($query);
             }
         } catch (\Exception $e) {
             print "Error with query";
             die;
         }
     }
     return $output;
 }
コード例 #5
0
 public function call()
 {
     $pdo = core\paDB::conn();
     $sql = "SELECT * FROM {$this->paPrefix}_items";
     if ($this->args['itemID']) {
         $sql .= " WHERE id={$this->args['itemID']}";
     }
     $rs = $pdo->query($sql);
     $output = array();
     foreach ($rs as $row) {
         $output[] = $row;
     }
     return $output;
 }
コード例 #6
0
 public function call()
 {
     $pdo = core\paDB::conn();
     $sql = "SELECT c.id,c.name,c.startSceneID,c.talkColour, c.isPlayer, csp.id as spriteID, csp.sprite, csp.width, csp.height, csp.frames, csp.animList FROM {$this->paPrefix}_characters c LEFT JOIN {$this->paPrefix}_characterSprites csp ON csp.characterID=c.id";
     if ($this->args['charID']) {
         $sql .= " WHERE c.id={$this->args['charID']}";
     }
     $rs = $pdo->query($sql);
     $output = array();
     $ints = array('id', 'startSceneID', 'isPlayer', 'width', 'height', 'frames');
     foreach ($rs as $row) {
         foreach ($ints as $int) {
             $row[$int] = (int) $row[$int];
         }
         //this is necessary for sqlite which returns everything as a string.
         $output[] = $row;
     }
     return $output;
 }