how do i fix it so it doesn't do IP/~username/linksSQL and instead does www.domainname.com/linksSQL - when i try to set the paths it goes back to the IP -
When updating your paths in Setup > Paths & URL's, be sure to tick the box at the bottom ("update others") , and it should do the remaining updates for you :)