Database queries within a gaming machine

• US 8,285,740 B2
• Filed: 06/06/2007
• Issued: 10/09/2012
• Est. Priority Date: 06/06/2007
• Status: Active Grant

• Current Assignee: IGT (International Game Technology)
• Original Assignee: IGT (International Game Technology)
• Inventors: Graham, Jacob, Schlottmann, Gregory A., Bruce, Jacob C., Escalera, Anthony R.
• Primary Examiner(s): Wilson, Kimberly
• Assistant Examiner(s): Uddin, Mohammed R
• Application Number:
  US11/810,888
• Publication Number:
  US 20080305854A1
• Time in Patent Office: 1,952 Days
• Field of Search: 707/769, 707/755, 707/771, 707/999.003
• US Class Current: 707/769
• CPC Class Codes: G07F 17/32 for games, toys, sports, or amusements

Abstract

Methods and devices are provided for querying databases maintained by electronic gaming machines (“EGMs”). The databases preferably follow a predetermined naming convention. In some such implementations, a query is written in a predetermined message field. For example, the query string may be written in a predetermined extension of the Gaming Standards Association'"'"'s G2S Message Protocol. An EGM (or other device) receiving a message containing such a query may extract the query from the predetermined field, parse the query, determine the requested data and return a responsive message that includes the requested data.

Claims

1. A wager gaming machine, comprising:

means for providing wagering games;

a network interface;

a memory having a database stored therein, the database comprising wager gaming data and having fields organized according to a predetermined format; and

a logic system configured to do the following;

determine whether a first message has been received from a device via the network interface;

decrypt the first message, if necessary;

subject the first message to an authentication challenge;

if the first message passes the authentication challenge, determine whether the first message includes a data request message;

if the first message includes a data request message, extract a query string from a predetermined portion of the first message, wherein the predetermined portion comprises a predetermined extension to the Gaming Standards Association'"'"'s G2S Message Protocol,

wherein the query string is formed according to a query language and comprises an indicated format for indicated wager gaming data;

parse the query string to determine the indicated format for indicated wager gaming data;

select one of game usage data, wagering data, configuration data, or peripheral device data from the database based upon the indicated format to form the indicated wager gaming data;

form a second message comprising the indicated wager gaming data such that the indicated wager gaming data are provided in the indicated format; and

send the second message to the device via the network interface.

2. The wager gaming machine of claim 1, wherein the first and second messages are formatted according to the Gaming Standards Association'"'"'s G2S Message Protocol.

3. The wager gaming machine of claim 1, wherein the query language comprises Structured Query Language (“

SQL”

), and the query string comprises a Structured Query Language query string.

4. The wager gaming machine of claim 1, wherein the predetermined portion comprises a predetermined field.

5. The wager gaming machine of claim 1, wherein the logic system is further configured to determine a permission level of the first message and to obtain indicated wager gaming data according to the permission level.

6. The wager gaming machine of claim 1, wherein the logic system is further configured to determine new wager gaming data and update the database in the predetermined format according to the new wager gaming data.

7. The wager gaming machine of claim 1, wherein the logic system comprises at least one of a processor and a programmable logic device.

8. The wager gaming machine of claim 1, wherein the logic system is further configured to encrypt at least a portion of the second message.

9. A method, comprising:

receiving, via a network interface of a wager gaming machine, a first message from a device;

decrypting at least a portion of the first message, if necessary;

sending an authentication challenge to the device, receiving a response to the authentication challenge and determining whether the response to the authentication challenge is adequate;

if the response to the authentication challenge is adequate, determining whether the first message includes a data request message;

if the first message includes a data request message, extracting a query string from a predetermined portion of the first message, wherein the query string specifies at least one indicated field of a database, and the predetermined portion comprises a predetermined extension to the Gaming Standards Association'"'"'s G2S Message Protocol,

wherein the query string is formed according to a query language and comprises an indicated format for indicated wager gaming data;

parsing the query string to determine the indicated format for indicated wager gaming data;

select one of game usage data, wagering data, configuration data, or peripheral device data from the database based upon the indicated format to form the indicated wager gaming data;

obtaining requested wager gaming data from the at least one indicated field of the database;

forming a second message comprising the requested wager gaming data; and

sending the second message to the device via the network interface.

10. The method of claim 9, wherein the first and second messages are formatted according to the Gaming Standards Association'"'"'s G2S Message Protocol.

11. The method of claim 9, wherein the query language comprises Structured Query Language (“

SQL”

), and the query string comprises a Structured Query Language query string.

12. The method of claim 9, wherein the predetermined portion comprises a predetermined field.

13. The method of claim 9, wherein the parsing step comprises parsing the query string to determine an indicated format for the indicated wager gaming data,

the indicated wager gaming data comprise at least one of the game usage data, wagering data, configuration data and peripheral device data selected from the database based upon the indicated format,

and wherein the forming step comprises providing the indicated wager gaming data in the indicated format.

14. The method of claim 9, further comprising:

determining a permission level of the first message; and

obtaining indicated wager gaming data according to the permission level.

15. The method of claim 9, further comprising encrypting at least a portion of the second message.

16. A wager gaming machine, comprising:

means for providing wagering games;

a network interface;

a memory having a database stored therein, the database comprising wager gaming data and having fields organized according to a predetermined format; and

a logic system configured to do the following;

determine whether a first message from a device has been received via the network interface;

decrypt the first message, if necessary;

subject the first message to an authentication challenge,

if the first message passes the authentication challenge, determine whether the first message includes a procedure call or a data request message;

if the first message includes a procedure call, extract a representation of the procedure call from a predetermined portion of the first message, wherein the representation of the procedure call specifies a computer-executable procedure to be executed when the message is received and the predetermined portion comprises a predetermined extension of the G2S Message Protocol;

determine whether to perform the computer-executable procedure,

wherein the determination is made with reference to a permission level assigned to the device and to a corresponding list of approved or forbidden procedures associated with the permission level;

execute the computer-executable procedure according to the representation of the procedure call in response to determining that the procedure is to be performed; and

if the first message includes a data request message, extract a query string from the predetermined portion of the first message, wherein the query string is formed according to a query language and comprises an indicated format for indicated wager gaming data, parse the query string to determine the indicated format for indicated wager gaming data, and select one of game usage data, wagering data, configuration data, or peripheral device data from the database based upon the indicated format to form the indicated wager gaming data.

17. The wager gaming machine of claim 16, wherein the first message is formatted according to the Gaming Standards Association'"'"'s G2S Message Protocol.

18. The wager gaming machine of claim 16, wherein the logic system is further configured to do the following:

form a second message indicating that the procedure was executed; and

send the second message to the device via the network interface.

19. The wager gaming machine of claim 16, wherein the procedure comprises changing a configuration of the means for providing wagering games.

20. The wager gaming machine of claim 16, wherein the logic system comprises at least one of a processor and a programmable logic device.