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);
}
}
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');
}
}
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);
}
}
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');
}
}