Tools for storing, accessing and restoring website content via a website repository

• US 9,378,100 B2
• Filed: 05/17/2013
• Issued: 06/28/2016
• Est. Priority Date: 05/17/2013
• Status: Active Grant

• Current Assignee: Go Daddy Operating Company LLC (GoDaddy, Inc.)
• Original Assignee: Go Daddy Operating Company LLC (GoDaddy, Inc.)
• Inventors: LeBert, Don, Kiser, Domingo JW, Redfoot, Todd, Devarajan, Ganesh
• Primary Examiner(s): Mahmoudi, Tony
• Assistant Examiner(s): NGUYEN, MERILYN P
• Application Number:
  US13/897,246
• Publication Number:
  US 20140344224A1
• Time in Patent Office: 1,138 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
• CPC Class Codes: G06F 40/166 Editing, e.g. inserting or deleting
• CPC Class Codes: G06F 8/70 Software maintenance or management
• CPC Class Codes: G06F 8/71 Version control security arrangements therefor G06F21/57; Configuration management
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]

Abstract

Systems and method of the present invention provide for one or more server computers configured to identify, within a database transaction log, a dynamic website content in a database and a command modifying the dynamic website content, write the dynamic website content and the command modifying the dynamic website content to a website repository as a delta, receive a request to reverse the command modifying the dynamic website content, identify, within the delta, the command modifying the dynamic website content, and generate and execute a database query configured to reverse the command modifying the dynamic website content.

Claims

1. A system, comprising at least one processor executing instructions causing a server computer coupled to a network to:

receive a transmission encoding a request for a modification to a content within a website hosted on the server computer,

the modification comprising uploading a website file or executing a database query;

responsive to a determination that the modification comprises uploading the website file;

determine at least one difference between an uploaded website file and a hosted website file within a directory on the server computer, the uploaded website file sharing a file name with the hosted website file;

log, within a text file stored in the directory, the file name and the at least one difference;

responsive to a determination that the modification comprises executing the database query, log, within the text file, the database query and a second database query to reverse the database query;

render a control panel comprising;

the modification; and

a user interface selection element receiving, from an administrator of the website, a selection to undo the modification;

transmit the control panel to a client computer operated by the administrator;

receive a transmission comprising the selection to undo the modification;

responsive to receiving the selection;

delete the file name and the at least one difference from the text file;

or

execute the second database query to reverse the database query; and

delete the database query and the second database query from the text file.

2. The system of claim 1, wherein the instructions cause the server computer to log, within the text file, a reversal of the modification.

3. The system of claim 1, further comprising an interim software, executed on a interim server between an upload software and the directory, the interim server comprising instructions causing the server computer, prior to rendering the control panel, to:

receive a transmission encoding a request to display the website file;

render a modified website file comprising the at least one difference from the text file; and

transmit the modified website file to the client computer.

4. The system of claim 1, wherein:

the database query is imported from a database transaction log uploaded to the server computer; and

the database query returns a dynamic content to be displayed within the content of the website file.

5. The system of claim 1, wherein the text file comprises a record of the modification, the record comprising:

the administrator that requested the modification;

the name of the website file or a database table modified;

the content modified; and

a time stamp that the modification was executed.

6. The system of claim 1, wherein the at least one difference between the uploaded website file and the hosted website file is determined:

line by line;

character by character;

or

according to binary differences.

7. The system of claim 1, wherein the user interface selection element defines a change, a timestamp or a version of the website for which the modification is to be undone.

8. The system of claim 1, wherein the directory comprises a website repository wherein the administrator can commit, branch, merge and roll back a version of the website according to the modification logged in the text file.

9. The system of claim 1, wherein the control panel further comprises a plurality of website repository user interface elements receiving, from the administrator, at least one request to:

commit, to the hosted website file, the at least one difference between the uploaded website file and the hosted website file;

merge the uploaded website file and the hosted website file;

or

roll back the website repository to a particular time, date, commit or version of the website.

10. A method comprising the steps of:

receiving, by a server computer coupled to a network, a transmission encoding a request for a modification to a content within a website hosted on the server computer, the modification comprising uploading a website file or executing a database query;

responsive to a determination that the modification comprises uploading the website file;

determining, by the server computer, at least one difference between an uploaded website file and a hosted website file within a directory on the server computer, the uploaded website file sharing a file name with the hosted website file;

logging, by the server computer, within a text file stored in the directory, the file name and the at least one difference;

responsive to a determination that the modification comprises executing the database query, logging, by the server computer, within the text file, the database query and a second database query to reverse the database query;

rendering, by the server computer, a control panel comprising;

the modification; and

a user interface selection element receiving, from an administrator of the website, a selection to undo the modification;

transmitting, by the server computer, the control panel to a client computer operated by the administrator;

receiving, by the server computer, a transmission comprising the selection to undo the modification;

responsive to receiving the selection;

deleting, by the server computer, the file name and the at least one difference from the text file;

or

executing, by the server computer, the second database query to reverse the database query; and

deleting, by the server computer, the database query and the second database query from the text file.

11. The method of claim 10, further comprising the step of logging, by the server computer, within the text file, a reversal of the modification.

12. The method of claim 10, further comprising the steps, prior to rendering the control panel, of:

receiving, by an interim software executed on a interim server between the upload software and the directory, a transmission encoding a request to display the website file;

rendering, by the interim software, a modified website file comprising the at least one difference from the text file; and

transmitting, by the interim software, the modified website file to the client computer.

13. The method of claim 10, wherein:

the database query is imported from a database transaction log uploaded to the server computer; and

the database query returns a dynamic content to be displayed within the content of the website file.

14. The method of claim 10, wherein the text file comprises a record of the modification, the record comprising:

the administrator that requested the modification;

the name of the website file or a database table modified;

the content modified; and

a time stamp that the modification was executed.

15. The method of claim 10, wherein the at least one difference between the uploaded website file and the hosted website file is determined:

line by line;

character by character;

or

according to binary differences.

16. The method of claim 10, wherein the user interface selection element defines a change, a timestamp or a version of the website for which the modification is to be undone.

17. The method of claim 10, wherein the directory comprises a website repository wherein the administrator can commit, branch, merge and roll back a version of the website according to the modification logged in the text file.

18. The method of claim 10, wherein the control panel further comprises a plurality of website repository user interface elements receiving, from the administrator, at least one request to:

commit, to the hosted website file, the at least one difference between the uploaded website file and the hosted website file;

merge the uploaded website file and the hosted website file;

or

roll back the website repository to a particular time, date, commit or version of the website.