[Original] Batch replace gotoip domain names in website programs

When visiting the website, a verification page appears. This is because the website calls a second-level domain name. Our company's second-level domain name is used to test access results and cannot be used for formal access. However, some users used second-level domain names when debugging and installing their websites, and the internal links were not modified, so accessing those links triggers a verification page.

At this point, check the domain settings in the website backend, and promptly update the page and application cache. You can also use File Management to replace it with your own domain name.

In File Management, enter the wwwroot directory, then click the "Replace" button, enter the domain name, and perform the replacement.

For some programs, the domain name is written into the database.

Modifying the link address in the database: Virtual Host Management --- Management --- Database Management

Then click your database name on the left, and then click 

Then enter the content as shown in the figure below:

Click Execute, then click Browse in the results. (Before browsing, please record the table name you are browsing; the browsing results are displayed at the bottom of the page.)

The following uses the table name xxx_config as an example.

Select a row, edit it, and find which item on the page contains gotoip3.com. For example, the result is shown below.

Record the column name.

Click the  at the top, and enter the following command:

UPDATE `xxx_config` 

SET `mobile_value` = REPLACE(`mobile_value`, 'xxx.gotoip3.com', 'your own domain name') 

Repeat the above operation until no gotoip3.com can be found in the database. 

3. If many of your tables contain gotoip3.com, please use the function of phpmyadmin to complete batch replacement 

   First, export the database as an SQL file, and use a local editor to edit the SQL file (it is recommended to download the notepad++ editor). Batch replace xxx.gotoip3.com with your own  domain name, and save.

   Finally, empty the database, and use the SQL file you just modified to import into the database to complete the batch replacement.