Esempio n. 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);
     }
 }
Esempio n. 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');
     }
 }
Esempio n. 3
0
 public function deleteNote($noteId)
 {
     if ($noteId == 0) {
         return new returnData(0);
     }
     //if 0, it would delete ALL notes
     $noteObj = Module::queryObject("SELECT * FROM notes WHERE note_id = '{$noteId}' LIMIT 1");
     Module::query("DELETE FROM note_tags WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_likes WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_flags WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_shares WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM folder_contents WHERE game_id = {$noteObj->game_id} AND content_type = 'PlayerNote' AND content_id = '{$noteId}'");
     Module::query("DELETE FROM note_content WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_tags WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_likes WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM notes WHERE note_id = '{$noteId}'");
     Locations::deleteLocationsForObject($noteObj->game_id, "PlayerNote", $noteId);
     $result = Module::query("SELECT note_id FROM notes WHERE parent_note_id = '{$noteId}'");
     while ($commentNote = mysql_fetch_object($result)) {
         Notebook::deleteNote($commentNote->note_id);
     }
     return new returnData(0);
 }
Esempio n. 4
0
 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);
     }
 }
Esempio n. 5
0
 function deleteNote($noteId)
 {
     //If noteId is 0, it will rather elegantly delete EVERYTHING in the note database
     //becasue 0 is used for the parent_id of all new notes
     if ($noteId == 0) {
         return new returnData(0);
     }
     $noteObj = Module::queryObject("SELECT * FROM notes WHERE note_id = '{$noteId}' LIMIT 1");
     Module::query("DELETE FROM note_tags WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_likes WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_flags WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_shares WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM folder_contents WHERE game_id = {$noteObj->game_id} AND content_type = 'PlayerNote' AND content_id = '{$noteId}'");
     Module::query("DELETE FROM note_content WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_tags WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM note_likes WHERE note_id = '{$noteId}'");
     Module::query("DELETE FROM notes WHERE note_id = '{$noteId}'");
     Locations::deleteLocationsForObject($noteObj->game_id, "PlayerNote", $noteId);
     $result = Module::query("SELECT note_id FROM notes WHERE parent_note_id = '{$noteId}'");
     while ($commentNote = mysql_fetch_object($result)) {
         Notes::deleteNote($commentNote->note_id);
     }
     return new returnData(0);
 }
Esempio n. 6
0
 function deleteNote($noteId)
 {
     //If noteId is 0, it will rather elegantly delete EVERYTHING in the note database
     //becasue 0 is used for the parent_id of all new notes
     if ($noteId == 0) {
         return new returnData(0);
     }
     $query = "SELECT * FROM notes WHERE note_id = '{$noteId}' LIMIT 1";
     $result = Module::query($query);
     $noteObj = mysql_fetch_object($result);
     $query = "DELETE FROM note_tags WHERE note_id = '{$noteId}'";
     Module::query($query);
     $query = "DELETE FROM note_likes WHERE note_id = '{$noteId}'";
     Module::query($query);
     $query = "SELECT note_id FROM notes WHERE parent_note_id = '{$noteId}'";
     $result = Module::query($query);
     if (mysql_error()) {
         return new returnData(1, NULL, mysql_error());
     }
     while ($commentNote = mysql_fetch_object($result)) {
         Notes::deleteNote($commentNote->note_id);
     }
     //Delete Note locations
     Locations::deleteLocationsForObject($noteObj->game_id, "PlayerNote", $noteId);
     //Delete the folder record
     //EditorFolderContents::deleteContent($noteObj->game_id, "PlayerNote", $noteId); //This would cause an infinite loop becasue it deletes the note
     $query = "DELETE FROM folder_contents WHERE game_id = {$noteObj->game_id} AND content_type = 'PlayerNote' AND content_id = '{$noteId}'";
     Module::query($query);
     if (mysql_error()) {
         return new returnData(1, NULL, mysql_error());
     }
     //Delete the Note's Content
     $query = "DELETE FROM note_content WHERE note_id = '{$noteId}'";
     Module::query($query);
     if (mysql_error()) {
         return new returnData(1, NULL, mysql_error());
     }
     $query = "DELETE FROM note_tags WHERE note_id = '{$noteId}'";
     Module::query($query);
     if (mysql_error()) {
         return new returnData(1, NULL, mysql_error());
     }
     $query = "DELETE FROM note_likes WHERE note_id = '{$noteId}'";
     Module::query($query);
     if (mysql_error()) {
         return new returnData(1, NULL, mysql_error());
     }
     //Delete the Note itself
     $query = "DELETE FROM notes WHERE note_id = '{$noteId}'";
     Module::query($query);
     if (mysql_error()) {
         return new returnData(1, NULL, mysql_error());
     }
     return new returnData(0);
 }
Esempio n. 7
0
 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');
     }
 }