public static function getDetailedFullNoteObject($noteId, $playerId = 0)
{
$query = "SELECT note_id, game_id, owner_id, title, public_to_map, public_to_notebook, created FROM notes WHERE note_id = '{$noteId}'";
$result = Module::query($query);
if (mysql_error()) {
return new returnData(1, NULL, mysql_error());
}
if ($note = mysql_fetch_object($result)) {
$query = "SELECT user_name FROM players WHERE player_id = '{$note->owner_id}'";
$player = Module::query($query);
$playerObj = mysql_fetch_object($player);
$note->username = $playerObj->user_name;
$note->displayname = $playerObj->display_name;
$note->contents = Notes::getNoteContentsAPI($noteId);
$note->comments = Notes::getNoteCommentsAPI($noteId, $playerId);
$note->tags = Notes::getNoteTagsAPI($noteId, $note->game_id);
$note->likes = Notes::getNoteLikesAPI($noteId);
$note->player_liked = $playerId == 0 ? 0 : Notes::playerLikedAPI($playerId, $noteId);
$note->icon_media_id = 5;
if ($note->dropped = Notes::noteDropped($noteId, $note->game_id)) {
$location = Notes::getNoteLocation($noteId, $note->game_id);
} else {
$location = new stdClass();
$location->lat = $location->lon = 0;
}
$note->lat = $location->lat;
$note->lon = $location->lon;
return $note;
}
return;
}