예제 #1
0
 public static function deleteWebPage($gameId, $webPageId)
 {
     Locations::deleteLocationsForObject($gameId, 'WebPage', $webPageId);
     Requirements::deleteRequirementsForRequirementObject($gameId, 'WebPage', $webPageId);
     PlayerStateChanges::deletePlayerStateChangesThatRefrenceObject($gameId, 'WebPage', $webPageId);
     $query = "DELETE FROM web_pages WHERE game_id = '{$gameId}' AND web_page_id = {$webPageId}";
     $rsResult = Module::query($query);
     if (mysql_error()) {
         return new returnData(3, NULL, "SQL Error");
     }
     if (mysql_affected_rows()) {
         return new returnData(0, TRUE);
     } else {
         return new returnData(0, FALSE);
     }
 }
예제 #2
0
 public function deleteNode($gameId, $intNodeID)
 {
     Locations::deleteLocationsForObject($gameId, 'Node', $intNodeID);
     Requirements::deleteRequirementsForRequirementObject($gameId, 'Node', $intNodeID);
     PlayerStateChanges::deletePlayerStateChangesThatRefrenceObject($gameId, 'Node', $intNodeID);
     $query = "DELETE FROM nodes WHERE game_id = {$gameId} AND node_id = {$intNodeID}";
     $rsResult = Module::query($query);
     if (mysql_error()) {
         return new returnData(3, NULL, "SQL Error");
     }
     if (mysql_affected_rows()) {
         return new returnData(0);
     } else {
         return new returnData(2, NULL, 'invalid node id');
     }
 }
예제 #3
0
파일: items.php 프로젝트: kimblemj/server
 public static function deleteItem($gameId, $itemId)
 {
     Locations::deleteLocationsForObject($gameId, 'Item', $itemId);
     Requirements::deleteRequirementsForRequirementObject($gameId, 'Item', $itemId);
     PlayerStateChanges::deletePlayerStateChangesThatRefrenceObject($gameId, 'Item', $itemId);
     Module::removeItemFromAllPlayerInventories($gameId, $itemId);
     $query = "DELETE FROM items WHERE item_id = {$itemId} AND game_id = '{$gameId}'";
     $rsResult = Module::query($query);
     if (mysql_error()) {
         return new returnData(3, NULL, "SQL Error");
     }
     if (mysql_affected_rows()) {
         return new returnData(0, TRUE);
     } else {
         return new returnData(0, FALSE);
     }
 }
예제 #4
0
파일: npcs.php 프로젝트: kimblemj/server
 public function deleteNpc($gameId, $intNpcId)
 {
     Locations::deleteLocationsForObject($gameId, 'Npc', $intNpcId);
     Requirements::deleteRequirementsForRequirementObject($gameId, 'Npc', $intNpcId);
     PlayerStateChanges::deletePlayerStateChangesThatRefrenceObject($gameId, 'Npc', $intNpcId);
     Nodes::deleteNodesReferencedByObject($gameId, 'Npc', $intNpcId);
     $query = "DELETE FROM npcs WHERE npc_id = {$intNpcId} AND game_id = {$gameId}";
     $rsResult = Module::query($query);
     if (mysql_error()) {
         return new returnData(3, NULL, "SQL Error");
     }
     $hasDeletedNPC = mysql_affected_rows();
     $query = "DELETE FROM npc_conversations WHERE npc_id = {$intNpcId} AND game_id = {$gameId}";
     $rsResult = Module::query($query);
     if (mysql_error()) {
         return new returnData(3, NULL, "SQL Error");
     }
     if ($hasDeletedNPC) {
         return new returnData(0);
     } else {
         return new returnData(2, 'invalid npc id');
     }
 }