public function deleteNodesReferencedByObject($gameId, $type, $intNpcId)
{
$query = "SELECT node_id FROM npc_conversations WHERE game_id = {$gameId} AND npc_id = {$intNpcId}";
$result = Module::query($query);
if (mysql_error()) {
return new returnData(3, NULL, "SQL Error");
}
while ($nid = mysql_fetch_object($result)) {
Nodes::deleteNode($gameId, $nid->node_id);
}
return new returnData(0);
}
public function deleteConversationWithNode($gameId, $conversationId, $editorId, $editorToken)
{
if (!Module::authenticateGameEditor($gameId, $editorId, $editorToken, "read_write")) {
return new returnData(6, NULL, "Failed Authentication");
}
$query = "SELECT node_id FROM npc_conversations WHERE game_id = '{$gameId}' AND conversation_id = {$conversationId} LIMIT 1";
$nodeIdRs = Module::query($query);
if (mysql_error()) {
return new returnData(3, NULL, "SQL Error:" . mysql_error() . "while running query:" . $query);
}
$nodeIdObject = @mysql_fetch_object($nodeIdRs);
if (!$nodeIdObject) {
return new returnData(2, NULL, "No such conversation");
}
$nodeId = $nodeIdObject->node_id;
Nodes::deleteNode($gameId, $nodeId);
$query = "DELETE FROM npc_conversations WHERE game_id = '{$gameId}' AND conversation_id = {$conversationId}";
$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 conversation id');
}
}
public static function deleteContent($gameId, $intContentID, $editorId, $editorToken)
{
if (!Module::authenticateGameEditor($gameId, $editorId, $editorToken, "read_write")) {
return new returnData(6, NULL, "Failed Authentication");
}
//Lookup the object
$query = "SELECT content_type,content_id FROM folder_contents WHERE object_content_id = {$intContentID} AND game_id = '{$gameId}' LIMIT 1";
$contentQueryResult = Module::query($query);
$content = @mysql_fetch_object($contentQueryResult);
if (mysql_error()) {
return new returnData(3, NULL, "SQL Error");
}
Spawnables::deleteSpawnablesOfObject($gameId, $content->content_type, $content->content_id, $editorId, $editorToken);
//Delete the content record
$query = "DELETE FROM folder_contents WHERE object_content_id = {$intContentID} AND game_id = '{$gameId}'";
Module::query($query);
if (mysql_error()) {
return new returnData(3, NULL, "SQL Error");
}
//Delete the object
if ($content->content_type == "Node") {
Nodes::deleteNode($gameId, $content->content_id, $editorId, $editorToken);
} else {
if ($content->content_type == "Item") {
Items::deleteItem($gameId, $content->content_id, $editorId, $editorToken);
} else {
if ($content->content_type == "Npc") {
Npcs::deleteNpc($gameId, $content->content_id, $editorId, $editorToken);
} else {
if ($content->content_type == "WebPage") {
WebPages::deleteWebPage($gameId, $content->content_id, $editorId, $editorToken);
} else {
if ($content->content_type == "AugBubble") {
AugBubbles::deleteAugBubble($gameId, $content->content_id, $editorId, $editorToken);
} else {
if ($content->content_type == "PlayerNote") {
Notes::deleteNote($content->content_id, $editorId, $editorToken);
}
}
}
}
}
}
if (mysql_affected_rows()) {
return new returnData(0);
} else {
return new returnData(2, 'invalid folder id');
}
}
