TP locations on NI/AG

Discussion in 'Next Island' started by Reb, Sep 25, 2019.

  1. Reb

    Reb

    Ajoite Ridge [Next Island, 125046, 88557, 270, Waypoint]
    Ancient Ruins [Next Island, 138557, 82988, 163, Waypoint]
    Daudomaur Bog [Next Island, 130476, 93473, 123, Waypoint]
    Biological Research Area [Next Island, 137462, 83967, 143, Waypoint]
    Bonerattle Cove [Next Island, 126305, 94709, 220, Waypoint]
    Borass Rock [Next Island, 133785, 92033, 200, Waypoint]
    Bustamite Forest [Next Island, 132932, 97126, 160, Waypoint]
    Crimson Fields [Next Island, 137512, 93367, 265, Waypoint]
    Crystal Bay [Next Island, 137093, 83307, 103, Waypoint]
    Crystal Cove [Next Island, 137042, 84286, 113, Waypoint]
    Crystal Peak Teleport [Next Island, 136788, 83397, 180, Waypoint]
    Death Vally [Next Island, 132411, 93861, 243, Waypoint]
    Dragon's Breach [Next Island, 124999, 91195, 194, Waypoint]
    Drusy Blue Ridge [Next Island, 133937, 88464, 437, Waypoint]
    Emily's Lookout [Next Island, 124342, 92686, 361, Waypoint]
    Enchanted Excavation Lodge [Next Island, 129332, 94046, 115, Waypoint]
    Enchanted Village [Next Island, 125372, 93124, 172, Waypoint]
    Enchanted Waterfall Ridge [Next Island, 126916, 93295, 361, Waypoint]
    Fenster Landing [Next Island, 136900, 89577, 280, Waypoint]
    First Wave Settlement [Next Island, 136378, 84366, 236, Waypoint]
    Flash Point [Next Island, 131922, 90787, 142, Waypoint]
    Forsaken Outpost [Next Island, 131593, 87999, 132, Waypoint]
    Hillside Hideout [Next Island, 132244, 93095, 167, Waypoint]
    Hunters Waterfall Outpost [Next Island, 134435, 87441, 349, Waypoint]
    Kamba Outpost [Next Island, 126268, 89430, 155, Waypoint]
    Kyanite Lake [Next Island, 125789, 86393, 111, Waypoint]
    Kyanite Lookout [Next Island, 126008, 86935, 258, Waypoint]
    Marshland Observation [Next Island, 130004, 91842, 212, Waypoint]
    Misty Outpost [Next Island, 128378, 92653, 177, Waypoint]
    Morion Outpost [Next Island, 128980, 84245, 121, Waypoint]
    Mushroom Marsh [Next Island, 126485, 90979, 124, Waypoint]
    Neophyte Village [Next Island, 138044, 83951, 149, Waypoint]
    Oasis Outlook [Next Island, 127599, 83060, 179, Waypoint]
    Draken Stand [Next Island, 136227, 91131, 222, Waypoint]
    Orpheus' Cave [Next Island, 136178, 87223, 179, Waypoint]
    Orpheus' Way [Next Island, 136532, 86598, 148, Waypoint]
    Papoo Village [Next Island, 137701, 83211, 106, Waypoint]
    Paradise Landing [Next Island, 135863, 83724, 315, Waypoint]
    Pearl Cove [Next Island, 137712, 85159, 117, Waypoint]
    Resa Docks [Next Island, 133758, 88622, 101, Waypoint]
    Riverside View [Next Island, 133333, 85083, 117, Waypoint]
    Salvation Outpost [Next Island, 128880, 89261, 227, Waypoint]
    Screeching Hollow [Next Island, 134804, 85704, 102, Waypoint]
    Serpentine Village [Next Island, 128000, 86646, 116, Waypoint]
    Shadow Hill [Next Island, 126885, 85027, 294, Waypoint]
    Sharptooth Cliff [Next Island, 124850, 84011, 149, Waypoint]
    Shatterrock [Next Island, 124840, 96677, 201, Waypoint]
    Shepherd's Beach [Next Island, 133746, 83236, 111, Waypoint]
    Sherman Outpost [Next Island, 127648, 88419, 144, Waypoint]
    Shoreline Flats [Next Island, 123882, 90683, 103, Waypoint]
    Sypherton Gardens [Next Island, 133517, 93874, 763, Waypoint]
    Tanzanite View [Next Island, 135383, 88562, 449, Waypoint]
    Vulcans Pass [Next Island, 132926, 91602, 285, Waypoint]
    Warrior Peak [Next Island, 132350, 95632, 605, Waypoint]
    Xrager Island [Next Island, 135225, 94993, 159, Waypoint]

    ------------------------------------------------------------------------------

    Dodona - [Ancient Greece, 33628, 22705, 184, Waypoint]
    Ephesus - [Ancient Greece, 39797, 20273, 218, Waypoint]
    Macedonia - [Ancient Greece, 35300, 23043, 344, Waypoint]
    Mount Diete - [Ancient Greece, 38017, 17214, 115, Waypoint]
    Mount Olympus Basecamp - [Ancient Greece, 35012, 21945, 138, Waypoint]
    Mount Olympus Peak - [Ancient Greece, 34728, 22675, 602, Waypoint]
    Olympia - [Ancient Greece, 35031, 20197, 108, Waypoint]
    Orpheus' Cave - [Ancient Greece, 36020, 19839, 117, Waypoint]
    Sparta - [Ancient Greece, 35647, 19340, 140, Waypoint]
    Syracuse - [Ancient Greece, 33494, 19084, 116, Waypoint]
    Thebes - [Ancient Greece, 36219, 20671, 181, Waypoint]
    Thebes Amphitheater - [Ancient Greece, 36515, 20757, 115, Waypoint]
    Thebes Market - [Ancient Greece, 36275, 20279, 112, Waypoint]
    Thrace - [Ancient Greece, 38367, 23306, 169, Waypoint]
    Troy - [Ancient Greece, 39616, 22381, 230, Waypoint]
    Teleporter(Revive Point) [Ancient Greece, 35131, 19558, 105, Waypoint]
    Teleporter (Revive point)[Ancient Greece, 33983, 22065, 200, Waypoint]
    Teleporter(Revive Point)[Ancient Greece, 38668, 22495, 113, Waypoint]
     
    • Like Like x 1
    • Winner Winner x 1
    • Informative Informative x 1
  2. Wistrel

    Wistrel Kick Ass Elf

    Superb!! Thanks so much. I should be able to write some regex to turn that post into DB update/insert commands! Looks like a lot there I don't have yet (and none of my stuff has height coords!)
     
    • Like Like x 1
  3. Reb

    Reb

    Two locations have changed name, and I can see now I did't put them in the right alphabetical place lol. (<-- or correct english)
    I can message these locations ingame ofc, just send a PM to Rebecca Reb Kean.
     
    • Friendly Friendly x 1
  4. Super Cool, ty for it.

    Will add you to FL when online, this is what friends are for :)
     
    • Like Like x 2
  5. Wistrel

    Wistrel Kick Ass Elf

    Ah bugger... I set locationType as required ^_^*** oddly I didn't for planets... that's one to fix.

    HTML:
    mysql> describe location;
    +-----------+-----------------+------+-----+---------+----------------+
    | Field     | Type            | Null | Key | Default | Extra          |
    +-----------+-----------------+------+-----+---------+----------------+
    | id        | int(4) unsigned | NO   | PRI | NULL    | auto_increment |
    | name      | varchar(60)     | YES  |     | NULL    |                |
    | type      | int(2) unsigned | NO   | MUL | NULL    |                |
    | latitude  | int(6) unsigned | NO   |     | NULL    |                |
    | longitude | int(6) unsigned | NO   |     | NULL    |                |
    | height    | int(4)          | YES  |     | NULL    |                |
    | planetID  | int(2) unsigned | YES  | MUL | NULL    |                |
    +-----------+-----------------+------+-----+---------+----------------+
    I think for this I'll just have to add an "UNKNOWN" to the locationType table

    HTML:
    mysql> select * from locationType;
    +----+-------------------+
    | id | name              |
    +----+-------------------+
    |  5 | Estate Area       |
    |  7 | Land Area         |
    |  3 | Outpost           |
    |  1 | Place             |
    |  4 | Point of Interest |
    |  6 | PvP Area          |
    |  8 | Race Track        |
    |  2 | Teleport          |
    +----+-------------------+
    Still, it will be nice to have some height data for the first time with this lot.
     
    • Like Like x 1
  6. Reb

    Reb

    Yeah, I don't understand much of that language at all lol.
    But if you want the numbers as links, I'll happily send them in a message ingame. =)
    (unless that's not what this is about at all, and in that case, oops)
     
  7. Wistrel

    Wistrel Kick Ass Elf

    No worries, out of interest, the locations you posted, are they all teleport locations, or are some of them something else (as listed under the word locationType above? I'm trying to decide if I should record them as an "unknown" location type for now (and fix later) or not.

    If they are all TP's that would be sweet. No probs if they are not though.

    Yeh it's all about something entirely different that I'm working on that I've not told anyone about yet (cause it may still never happen - certainly at current rate of "progress" - I don't want to end up in McCormick's "content of oblivion" blog! XD)

    I did at least manage to turn all that into SQL just now though.
     
  8. Reb

    Reb

    Aha, then good, makes sense I didn't understand it lol
    And yes, they are all TPs. Very few outposts here without a TP. So yeah, they are.
     
  9. is there actually an new content there worth going for a bit? Is Greece still an empty waste land with a huge ass invisible wall in the center of the water that makes it hard to move around since you have to climb all those God Blessed Mountains everywhere that have nothing in them except a lot of places to fall and die.
     
  10. Wistrel

    Wistrel Kick Ass Elf

    indeed, always a disappointment that it was so pretty/interesting landscape but nothing of any note whatsoever. I tell you, they should have let me at it. I'd have love to have got my teeth into the Next Island story. Could have put all sorts of cool stuff in AG with that undercover timetravel plot.

    MAGIC! I'll add them all as TP's then. Great stuff!

    Wistrel
     
  11. Wistrel

    Wistrel Kick Ass Elf

    Brilliant thanks so much for sharing these and so consistently formatted.

    My DB is nicely updated and I didn't have anything for Ancient Greece it seems.

    HTML:
    +-----+----------------------------+------+----------+-----------+--------+----------+
    | id  | name                       | type | latitude | longitude | height | planetID |
    +-----+----------------------------+------+----------+-----------+--------+----------+
    | 879 | Ajoite Ridge               |    2 |   125046 |     88557 |    270 |       15 |
    | 880 | Ancient Ruins              |    2 |   138557 |     82988 |    163 |       15 |
    | 881 | Daudomaur Bog              |    2 |   130476 |     93473 |    123 |       15 |
    | 882 | Biological Research Area   |    2 |   137462 |     83967 |    143 |       15 |
    | 883 | Bonerattle Cove            |    2 |   126305 |     94709 |    220 |       15 |
    | 884 | Borass Rock                |    2 |   133785 |     92033 |    200 |       15 |
    | 885 | Bustamite Forest           |    2 |   132932 |     97126 |    160 |       15 |
    | 886 | Crimson Fields             |    2 |   137512 |     93367 |    265 |       15 |
    | 887 | Crystal Bay                |    2 |   137093 |     83307 |    103 |       15 |
    | 888 | Crystal Cove               |    2 |   137042 |     84286 |    113 |       15 |
    | 889 | Crystal Peak Teleport      |    2 |   136788 |     83397 |    180 |       15 |
    | 890 | Death Vally                |    2 |   132411 |     93861 |    243 |       15 |
    | 891 | Dragon's Breach            |    2 |   124999 |     91195 |    194 |       15 |
    | 892 | Drusy Blue Ridge           |    2 |   133937 |     88464 |    437 |       15 |
    | 893 | Emily's Lookout            |    2 |   124342 |     92686 |    361 |       15 |
    | 894 | Enchanted Excavation Lodge |    2 |   129332 |     94046 |    115 |       15 |
    | 895 | Enchanted Village          |    2 |   125372 |     93124 |    172 |       15 |
    | 896 | Enchanted Waterfall Ridge  |    2 |   126916 |     93295 |    361 |       15 |
    | 897 | Fenster Landing            |    2 |   136900 |     89577 |    280 |       15 |
    | 898 | First Wave Settlement      |    2 |   136378 |     84366 |    236 |       15 |
    | 899 | Flash Point                |    2 |   131922 |     90787 |    142 |       15 |
    | 900 | Forsaken Outpost           |    2 |   131593 |     87999 |    132 |       15 |
    | 901 | Hillside Hideout           |    2 |   132244 |     93095 |    167 |       15 |
    | 902 | Hunters Waterfall Outpost  |    2 |   134435 |     87441 |    349 |       15 |
    | 903 | Kamba Outpost              |    2 |   126268 |     89430 |    155 |       15 |
    | 904 | Kyanite Lake               |    2 |   125789 |     86393 |    111 |       15 |
    | 905 | Kyanite Lookout            |    2 |   126008 |     86935 |    258 |       15 |
    | 906 | Marshland Observation      |    2 |   130004 |     91842 |    212 |       15 |
    | 907 | Misty Outpost              |    2 |   128378 |     92653 |    177 |       15 |
    | 908 | Morion Outpost             |    2 |   128980 |     84245 |    121 |       15 |
    | 909 | Mushroom Marsh             |    2 |   126485 |     90979 |    124 |       15 |
    | 910 | Neophyte Village           |    2 |   138044 |     83951 |    149 |       15 |
    | 911 | Oasis Outlook              |    2 |   127599 |     83060 |    179 |       15 |
    | 912 | Draken Stand               |    2 |   136227 |     91131 |    222 |       15 |
    | 913 | Orpheus' Cave              |    2 |   136178 |     87223 |    179 |       15 |
    | 914 | Orpheus' Way               |    2 |   136532 |     86598 |    148 |       15 |
    | 915 | Papoo Village              |    2 |   137701 |     83211 |    106 |       15 |
    | 916 | Paradise Landing           |    2 |   135863 |     83724 |    315 |       15 |
    | 917 | Pearl Cove                 |    2 |   137712 |     85159 |    117 |       15 |
    | 918 | Resa Docks                 |    2 |   133758 |     88622 |    101 |       15 |
    | 919 | Riverside View             |    2 |   133333 |     85083 |    117 |       15 |
    | 920 | Salvation Outpost          |    2 |   128880 |     89261 |    227 |       15 |
    | 921 | Screeching Hollow          |    2 |   134804 |     85704 |    102 |       15 |
    | 922 | Serpentine Village         |    2 |   128000 |     86646 |    116 |       15 |
    | 923 | Shadow Hill                |    2 |   126885 |     85027 |    294 |       15 |
    | 924 | Sharptooth Cliff           |    2 |   124850 |     84011 |    149 |       15 |
    | 925 | Shatterrock                |    2 |   124840 |     96677 |    201 |       15 |
    | 926 | Shepherd's Beach           |    2 |   133746 |     83236 |    111 |       15 |
    | 927 | Sherman Outpost            |    2 |   127648 |     88419 |    144 |       15 |
    | 928 | Shoreline Flats            |    2 |   123882 |     90683 |    103 |       15 |
    | 929 | Sypherton Gardens          |    2 |   133517 |     93874 |    763 |       15 |
    | 930 | Tanzanite View             |    2 |   135383 |     88562 |    449 |       15 |
    | 931 | Vulcans Pass               |    2 |   132926 |     91602 |    285 |       15 |
    | 932 | Warrior Peak               |    2 |   132350 |     95632 |    605 |       15 |
    | 933 | Xrager Island              |    2 |   135225 |     94993 |    159 |       15 |
    +-----+----------------------------+------+----------+-----------+--------+----------+
    
    +-----+------------------------+------+----------+-----------+--------+----------+
    | id  | name                   | type | latitude | longitude | height | planetID |
    +-----+------------------------+------+----------+-----------+--------+----------+
    | 861 |                        |    2 |    35131 |     19558 |    105 |       41 |
    | 862 |                        |    2 |    33983 |     22065 |    200 |       41 |
    | 863 |                        |    2 |    38668 |     22495 |    113 |       41 |
    | 864 | Dodona                 |    2 |    33628 |     22705 |    184 |       41 |
    | 865 | Ephesus                |    2 |    39797 |     20273 |    218 |       41 |
    | 866 | Macedonia              |    2 |    35300 |     23043 |    344 |       41 |
    | 867 | Mount Diete            |    2 |    38017 |     17214 |    115 |       41 |
    | 868 | Mount Olympus Basecamp |    2 |    35012 |     21945 |    138 |       41 |
    | 869 | Mount Olympus Peak     |    2 |    34728 |     22675 |    602 |       41 |
    | 870 | Olympia                |    2 |    35031 |     20197 |    108 |       41 |
    | 871 | Orpheus' Cave          |    2 |    36020 |     19839 |    117 |       41 |
    | 872 | Sparta                 |    2 |    35647 |     19340 |    140 |       41 |
    | 873 | Syracuse               |    2 |    33494 |     19084 |    116 |       41 |
    | 874 | Thebes                 |    2 |    36219 |     20671 |    181 |       41 |
    | 875 | Thebes Amphitheater    |    2 |    36515 |     20757 |    115 |       41 |
    | 876 | Thebes Market          |    2 |    36275 |     20279 |    112 |       41 |
    | 877 | Thrace                 |    2 |    38367 |     23306 |    169 |       41 |
    | 878 | Troy                   |    2 |    39616 |     22381 |    230 |       41 |
    +-----+------------------------+------+----------+-----------+--------+----------+
    For the regex enthusiasts out there, for my DB at least, the conversion code was:

    HTML:
    #convert AG stuff without name
    cat nextIsland_ToAdd_RawDatat.txt | grep Teleporter | sed "s/.*Ancient Greece, \([0-9]\+\), \([0-9]\+\), \([0-9]\+\),.*/INSERT INTO location (name, type, latitude, longitude, height, planetID) VALUES ('',2,\1,\2,\3,41);/"
    
    #convert AG stuff with a name
    cat nextIsland_ToAdd_RawDatat.txt | grep -v Teleporter | grep "Ancient Greece" | sed "s/'/\\\'/" |sed "s/\(.*\) - \[Ancient Greece, \([0-9]\+\), \([0-9]\+\), \([0-9]\+\),.*/INSERT INTO location (name, type, latitude, longitude, height, planetID) VALUES ('\1',2,\2,\3,\4,41);/"
    
    #convert NI stuff
    cat nextIsland_ToAdd_RawDatat.txt | grep "Next Island" | sed "s/'/\\\'/" | sed "s/\(.*\) \[Next Island, \([0-9]\+\), \([0-9]\+\), \([0-9]\+\),.*/INSERT INTO location (name, type, latitude, longitude, height, planetID) VALUES ('\1',2,\2,\3,\4,15);/"
    Just need to go though and tidy up the duplicates now. I think this is possible with fancy SQL but will probably be quicker with a GUI.
     
  12. Reb

    Reb

    I guess that would depend on many things. How long ago you were there, what kinds of things you like and so on.
    But since I came there about a year and a half ago, they did add quite a few things.
    Some are cosmetic, like new buildings and that. And then there are missions.
    3 new mobs btw, but they have no iron mission, I guess that's because the codex will be implemented at some point.
    There is however mining "irons" for Dark Lysterium/Phlogiston/Sorensens.
    Might also be a new drake one, I mean new this year, but since I don't hunt them yet, I can't say which one.

    Two missions that gives a 10 click BP. One is for the vehicle Kraka, and the other is for an armour piece of your choice, Arcticus.
    You get a hovercar or whatever, without mission.
    And well, the new taming mission is not working atm as you might have seen. But since they announced it's being nerfed,
    the mission will likely come back. There's a harder bot to tame as well, but I haven't seen it. And seems it was too hard
    to tame atm, so I guess it will be fixed. Just mentioning all new things I can think of lol.

    There's 3 dailies, that reward oil. One mission that rewards a papoo creature capsule.
    A number of exploration missions that have lower rewards, if any. I think some universal ammo at a few of them.

    The devs, or well Poseidon who shows up sometimes, told us earlier that the focus was on NI first.
    And that AG would get worked on later. And I saw on facebook a tiny hint that AG is being worked on now.
    At least that's how I read it. =)
    At this moment, there is just the Falcata mission there that works. No crystals are needed to go there anymore, and no restricions
    on vehicles or weapons/armour.
     
    • Informative Informative x 1
  13. Wistrel

    Wistrel Kick Ass Elf

    Actually sounds like genuine progress with AG...

    Just cleaned up my DB, as I suspected, easier to manually delete with a GUI. Spotted a few miss matched ones anyhow and a typo (Death Valley) while at it so all good.

    If anyone fancies fetching the coords of interesting places on that new Arkadia moon btw... ;)
     
    Last edited: Oct 12, 2019
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.