Announcement

Collapse
No announcement yet.

UAS2 Portals Database (what I have so far)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts
  • #16

    Interested in what you are using to accomplish this (gf's tool?)
    Will start from last page of that list and help!
    Once we have all those in we can start figuring out spawns etc!

    Comment

    • #17

      I already have a uas2 running in mysql, how do I add your updated data to that ?

      Comment

      • #18

        Originally posted by Chosenone View Post
        Interested in what you are using to accomplish this (gf's tool?)
        Will start from last page of that list and help!
        Once we have all those in we can start figuring out spawns etc!
        You will need the UAS2 server up and running along with its database. I currently use two computers, one for the UAS2 client and one for the live server/client. In the live server I go to a older then ToD dungeon and get the coordinates and !telemap my UAS2 client character to that location. https://github.com/MiachofTD/UASItemCreator is the GF's created web interface that needs to run on the UAS2 server computer with some form of web server running that can handle PHP. I used XAMPP for a quick and dirty web server. In the web interface you simply select the character you are using in UAS2 client, name the portal, describe the portal (usually the same as the name) and then select the color of the portal. Next, on the live server go into the portal, land and type in /loc. Use !teleloc and the 8 alpha numeric after the 0x and the 0.0, 0.0, 0.0, 0.0 coordinates to teleport your UAS2 client character into the dungeon. Example: 0128b547d 10.0, -15.0, 0.0, -0.9

        Once the UAS2 client character is in the dungeon use the web interface on the second table to record the internal landing spot and that portal is complete.

        In all honesty I appreciate the help but using the packet recording tools would probably be far more useful as all I am doing is recording the old school dungeons. I have even installed the needed tools to record my packets for where ever I go. My goal isn't to get UAS2 running as a primary EMU but as a tool to make sure the older content stays alive.

        Comment

        • #19

          Originally posted by InterimMadAxe_TD View Post
          I already have a uas2 running in mysql, how do I add your updated data to that ?
          I used XAMPP with PHPMyAdmin so I can easily work with the data in the database. If I was to download the database file I have made I would simply delete the gameobjects_portals table then use the insert tool in PHPMyAdmin to import my SQL file. That would replace and add all of the portals I have added so far.

          Comment

          • #20

            How is the progress Miach? I'm running the Packet Logger plus the other 3 .DLL's.

            Comment

            • #21

              I too am running packet loggers and the three decal plugins. Paused my manual database entry for now as I want to make sure as much data logging that can be done is done. My database may or may not work with the new emulator so I am now focusing on that aspect.

              You know to upload your logs to http://aka-steve.com/uploads/ right?

              Comment

              • #22

                I wasn't sure how often I should dump those files the .DLL's are creating?

                I did upload 5 dungeons on Trello.

                Comment

                • #23

                  Dump as often as you like. I have gotten into the habit of just going the places I can think of, marking them down, when done, naming the RAR files where I was at and uploading them. Only limit is stay under 50MB for the uploads, that's it.

                  Comment

                  • #24

                    Thank you so much for your efforts with all this. It was a surprise when I was running around in Eastham in UAS2 and found the portal to Asheron's island actually worked!

                    Comment

                    • #25

                      Originally posted by Gefferz View Post
                      Thank you so much for your efforts with all this. It was a surprise when I was running around in Eastham in UAS2 and found the portal to Asheron's island actually worked!
                      You're welcome, just wait until the devs get done with ACEmu it's gonna be a lot better.

                      Comment

                      • #26

                        Hi I was going to add what I have (@loc) to yours, but I wanted to test some out to make sure I was on the same page as you. I reverse engineered some of your numbers and got lost. The Glandenwood Dungeon Enter portal landed me on a hill top, where you land when taking the portal to GW in the woods on the run from Holt to GW. I dont know if this was a glitch in my conversion or what. I have the locs as:

                        Glendenwood Dungeon Portal (Start Outside) 0xA0A4001F [75.129486 165.073257 67.761108] -0.021975 0.000000 0.000000 0.999759
                        Glendenwood Dungeon Landing (Inside) 0x01E30332 [150.196365 -157.349045 0.005000] 0.999999 0.000000 0.000000 -0.001413

                        Im running acclient Version 0.0.11.6096 and the latest client_cell_1.dat and client_portal.dat files.

                        But when I reverse engineered yours I get:

                        Glendenwood Dungeon Portal (Start Outside) 0xa0a4001f [42.968571 0.432444 4.287649] 0.037939 0.000000 0.000000 0.037868
                        Glendenwood Dungeon Landing (Inside) 0x01e3033d [43.210000 3.160000 0.033700] 0.037170 0.000000 0.000000 3.324968

                        I'm not sure if I am converting them wrong or what. Im using the programmer part of the MS calculator and swapping between Dec and Hex. Im I doing it right or no?

                        Comment

                        • #27

                          I used the database to get my characters location. I then used what the database has provided for my coordinates.

                          Comment

                          • #28

                            Wow! What was your final dungeon count?

                            Dungeon Tatters?
                            ancient Town portals captured? High Mountain Valley, etc.
                            Soul Fearing?

                            This thread was awesome to read. Thank you for your hard work during the final sad days.

                            Comment

                            Working...
                            X