CN107122445A - Real-time question-and-answer game apparatus implementation method based on mobile phone - Google Patents
Real-time question-and-answer game apparatus implementation method based on mobile phone Download PDFInfo
- Publication number
- CN107122445A CN107122445A CN201710273264.8A CN201710273264A CN107122445A CN 107122445 A CN107122445 A CN 107122445A CN 201710273264 A CN201710273264 A CN 201710273264A CN 107122445 A CN107122445 A CN 107122445A
- Authority
- CN
- China
- Prior art keywords
- answer
- player
- topic
- time
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/955—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL]
- G06F16/9554—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL] by using bar codes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/951—Indexing; Web crawling techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Electrically Operated Instructional Devices (AREA)
Abstract
Real-time question-and-answer game apparatus based on mobile phone provide the answer interaction of in-situ match, requirement of the reduction match to question-and-answer game apparatus using mobile phone and planar bar code technology.By the way of scanning Quick Response Code, answer interface or register interface are logged in.Host announces to start after answer, topic Quick Response Code occurs, and player enters answer interface, the answer within the defined time after being scanned with the mobile phone of oneself.Prevent player from occurring situation about being practised fraud by network when with mobile phone answer using means.Match back-fore ground system can import topic and answer data;The releasing of answer Quick Response Code is controlled in match;Player's answer finishes rear system automatic Marking, and to host's returning result.
Description
First, technical field
The present invention is website field, is interacted by the answer at mobile phone and the Quick Response Code scene of playing.
2nd, background technology
Traditional in-situ match realizes the question and answer interaction of match by electronic display and question-and-answer game apparatus.This mode cost
Height, the requirement to equipment is also high.For the match of small cost, this implementation is unrealistic.Now, with social technology
Development and growth in the living standard, smart mobile phone becomes ordinary.The development of Quick Response Code, also causes the interaction of in-situ match to become
Easily.Therefore electronic display and question-and-answer game apparatus can be replaced by mobile phone and Quick Response Code, realizes the interaction of answer, reduction match
Cost.
3rd, the content of the invention
The characteristics of real-time question-and-answer game apparatus is to complete answer by the mobile phone of player oneself, it is not necessary to additionally install software, letter
It is single quick.Website is completed to contestant's information by MySQL database, compete topic and answer, the information such as player's answer
Storage.Front-end interface is realized by HTML.Backstage generates topic interface and in player's answer by PHP reading database information
The result of player's answer is returned afterwards.This technology reduces the high demand to equipment, player's answer simple and fast, and uses one
Fixed technology ensures the just and fair of match.The content of the invention is mainly made up of following four part:
(1) topic is imported:Pre-games staff passes through background management system typing topic, option and correct option, storage
Into database.Then generate the answer interface per problem to link, staff is put the link of every problem using prior art
Enter Quick Response Code, used when giving over to match.
(2) Player registration and log in:Before match, staff is put the link of enrollment page using prior art on network
Enter under Quick Response Code, player's line to scan Quick Response Code and complete registration registration, this causes match to become prone to popularization, improves participation.
Competed the same day, player enters match log-in interface again by Quick Response Code, after completion is logged in, and waits answer.
(3) player's answer:Player's answer:When host announces to start to answer certain problem, background work personnel are existing in match
Webpage after the Quick Response Code of the topic, player's scanning Quick Response Code is released on giant-screen jump to answer interface and start answer.Quick Response Code
It can be updated with topic change, answer link one exclusive Quick Response Code of correspondence per problem.Every player has 10s's
Time answers a question, after the time terminates, and system submits answer automatically, during answer, and player is required to rest on answer circle
Face, is judged to by web search answer if answer interface is left by system, and system will page locking, it is impossible to change
Answer, and submit immediately.
(4) returning result:After having been answered per problem, backstage can automatically generate the person's of answering questions list, preserve in the background, presiding over
When people needs, shown at the scene on giant-screen.It is raw according to laws of the game and player's answer situation after all problems answer terminates
Into last result of the match.For the specific topic in each road, the accuracy and average Reaction time of every problem can be counted,
And statistical result is shown according to answer situation in real time.
4th, illustrate
Fig. 1 in-situ match distribution maps
5th, embodiment
The invention will be further described below.
【Back-stage management】Staff adds topic in the background before match, and topic types, option (if there is) is correctly answered
Case;Wherein topic types include individual event selection, multinomial selection and fill a vacancy;Topic can be that content of text can also be picture.Topic
Purpose be directed through JSON forms realization, then again by JSON format conversions be object, be inserted into database.The storage of topic
By question tables of data, choices tables of data and ture_answer tables of data composition.
Table one, topic information table (question)
Row name | Data type | Explanation | Supplementary notes |
Id | int(11) | Topic is numbered | Major key |
Question | varchar(50) | Problem content | Can be that word can also be image link |
Version | int(11) | Version number | |
Type | int(11) | Topic types | Single choice is to elect 21 as to fill a vacancy as 3 more |
Add_time | datetime | The addition time | Filled in by system function |
Allow_time | int(11) | Allow Reaction time | It is defaulted as 10 seconds |
Table two, topic option information table (choices)
Row name | Data type | Explanation | Supplementary notes |
Id | int(11) | Numbering | Major key |
Q_id | int(11) | Corresponding topic numbering | Id with table one is corresponding |
Choice | varchar(50) | Option | Utf8 forms |
Table three, correct answer data table (true answer)
Row name | Data type | Explanation | Supplementary notes |
Id | int(11) | Numbering | Major key |
Q_id | int(11) | Corresponding topic numbering | Id with table one is corresponding |
True_answer | varchar(50) | Correct option | Utf8 forms |
【Register and log in】Register and log in and mainly realized by HTML list and PHP.Entrant is in register interface
HTML form is filled in, after contestant clicks on submit buttons, form data is sent in corresponding PHP files, PHP files
Database is connected, function performs INSERT INTO sentences, and a new record can be added in database table.Submitting in addition
Outside the data that user fills in, get_client_ip functions are called in PHP files, perhaps the IP address of user terminal, is used as user's
Identification information, or limit each IP times of registration.Player information is stored in the user tables of data in database.
Table four, player information table (user)
Row name | Data type | Explanation | Supplementary notes |
Id | int(11) | Numbering | |
Phone_num | varchar(15) | Register phone number | Utf8 forms |
Ip | varchar(20) | Ip addresses | Filled in by system function |
User_name | varchar(20) | Player's name | Utf8 forms |
User_num | varchar(15) | Player numbers | Job number or student number |
User_password | varchar(15) | Player's password | Utf8 forms |
Add_time | datetime | Hour of log-on | Filled in by system function |
【Answer】Player's scanning Quick Response Code opens the answer interface of a certain topic, and countdown occurs in the page, by taking 10s as an example.
Open after the page, the page first sends out a request to backstage and obtains initial time and termination time changes number by JavaScript
Word.Within 10s, player can click on submitting button and complete answer submission, backstage can be remembered with answer, if answered in advance
The current server time of record, and the answer of player and submission time are inserted into database.Do not have if the time terminates player
There is automatic submission, the page can be submitted automatically.Player's answer is stored in the user_answer tables of data in database.
Table five, player's answering information table (user_answer)
【Anti- cheating measure】It is exactly to prevent player from using a network for the problem of maximum using the mobile phone answer of player oneself
Cheating.In view of the Web vector graphic of mobile phone can not be limited, therefore take the mode that the webpage of player is limited to answer interface
Solve player's cheating problem:Page visibility interface is we provides a method in HTML5, and we can use
Visibilitychange page events judge the state of current page observability, and targetedly perform task.
Whether the document.hidden attribute displays page is the currently viewing page of player, is worth for ture or false.
Or document.visibilityState value, which is visible, (shows that the page is the currently active tab of browser, and window
Mouthful it is not minimum state), otherwise it is hidden (page is not the currently active tab page face, or window is minimized).We
Prevent player from practising fraud by monitoring this event of visibilitychange, answer circle is left when player opens other pages
During face, visibilitychange events can be triggered, monitor locks answer interface and submit answer so as to perform action.
Claims (5)
1. the characteristics of real-time question-and-answer game apparatus is to complete answer by the mobile phone of player oneself, it is not necessary to additionally install software, simply
Fast;Website is completed to contestant's information by MySQL database, match topic and answer, and the information such as player's answer is deposited
Storage;Front-end interface is realized by HTML;Backstage generates topic interface and after player's answer by PHP reading database information
Return to the result of player's answer;This technology reduces the high demand to equipment, player's answer simple and fast, and uses certain
Technology ensure match it is just and fair;Implementation process is mainly made up of following four part:
(1) topic is imported:Pre-games staff passes through background management system typing topic, option and correct option, storage to number
According in storehouse;Then generate the answer interface per problem to link, link is put into Quick Response Code by staff using prior art,
Used when giving over to match;
(2) Player registration and log in:Before match, the link of enrollment page is put into two by staff using prior art on network
Tie up in code, Quick Response Code is scanned under player's line and completes registration registration so that match becomes prone to promote, and improves participation;Match is worked as
Day, player enters match log-in interface again by Quick Response Code, after completion is logged in, and waits answer;
(3) player's answer:When host announces to start to answer certain problem, background work personnel release on in-situ match giant-screen
Webpage jumps to answer interface and starts answer after the Quick Response Code of the topic, player's scanning Quick Response Code;Quick Response Code can change with topic
It is updated, answer link one exclusive Quick Response Code of correspondence per problem;The time that every player has 10s answers a question,
After time terminates, system submits answer automatically, during answer, and player is required to rest on answer interface, is answered if left
Topic interface is then judged to by web search answer by system, and system will page locking, it is impossible to changes answer, and carries immediately
Hand over;
(4) returning result:After having been answered per problem, backstage can automatically generate the person's of answering questions list, preserve in the background, needed in host
When wanting, shown at the scene on giant-screen;After all problems answer terminates, according to laws of the game and player's answer situation, generation is most
Result of the match afterwards;For the specific topic in each road, the accuracy and average Reaction time of every problem, and root can be counted
Statistical result is shown in real time according to answer situation.
Mainly realized 2. registering and logging in by HTML list and PHP;Entrant fills in HTML form in register interface, when
Contestant is clicked on after submit buttons, and form data is sent in corresponding PHP files, PHP files connection database, function
INSERT INTO sentences are performed, a new record can be added in database table;In addition in the data for submitting user to fill in
Outside, get_client_ip functions are called in PHP files, the IP address of user terminal is obtained, as the identification information of user, or
For limiting each IP times of registration;Player information is stored in the user tables of data in database, there is id in tables of data,
Phone_num (phone number), ip (ip addresses), user_name (name), user_password (modification logging), add_
Time (hour of log-on).
3. player's scanning Quick Response Code opens the answer interface of a certain topic, countdown occurs in the page, by taking 10s as an example;Open the page
Afterwards, the page first to backstage send out one request obtain initial time and termination time pass through JavaScript change numeral;10s it
Interior, player can click on submitting button and complete answer submission, backstage can record current clothes with answer, if answered in advance
It is engaged in the device time, and the answer of player and submission time is inserted into database;Do not submitted automatically if the time terminates player,
The page can be submitted automatically;Player's answer is stored in the user_answer tables of data in database, there is id, q_ in tables of data
Id (id of topic), answer (answer made), time (submission time).
4. it is exactly to prevent player from using a network for cheating the problem of maximum using the mobile phone answer of player oneself;In view of
The Web vector graphic of mobile phone can not be limited, therefore takes the mode that the webpage of player is limited into answer interface to solve player's cheating and is asked
Topic:Page visibility interface is we provides a method in HTML5, and we can use the visibilitychange pages
Event judges the state of current page observability, and targetedly performs task;The document.hidden attribute display pages
Whether it is the currently viewing page of player, is worth for ture or false;Or document.visibilityState value is
Visible (shows that the page is the currently active tab of browser, and window is not minimum state), otherwise it is the hidden (pages
It is not the currently active tab page face, or window is minimized);We by monitor this event of visibilitychange come
Prevent player from practising fraud, when player opens other pages and leaves answer interface, visibilitychange events can be triggered, supervise
Listen device to perform action, lock answer interface and submit answer.
5. the addition of topic is mainly realized in back-stage management part, the generation of answer result, the storage of data is by means of MySQL data
Storehouse;Staff adds topic, topic types, option (if there is), correct option in the background before match;Wherein topic types
Including individual event selection, multinomial selection and fill a vacancy;Topic can be that content of text can also be picture;Topic is directed through JSON
Form realize, then again by JSON format conversions be object, be inserted into database;The storage of topic is by three tables of data groups
Into, question tables of data, choices tables of data and ture_answer tables of data have id (topics in question tables of data
Numbering), question (item content), version (topic version), type (topic types), add_time (addition time)
With allow_time (Reaction time gives tacit consent to 10s);Choices tables of data has id, and q_id is (in correspondence question tables of data
Id, is connected topic and option by this) and choice (topic option);True_answer tables of data has id, q_id
(id in correspondence question tables of data, connected topic with correct option by this) and true_answer (are correctly answered
Case);Player is submitted after answer, and the function write using PHP counts achievement, and achievement is made up of two parts:Correctness and time,
Compare Reaction time on the premise of correctness;After having been answered per problem, backstage will return to the list for the person of answering questions at scene
There are the name and Reaction time of the person of answering questions on host, list;After end of match, the achievement of all players of backstage programming count,
If there is fraction identical situation, the few people of Reaction time is winning.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710273264.8A CN107122445A (en) | 2017-04-19 | 2017-04-19 | Real-time question-and-answer game apparatus implementation method based on mobile phone |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710273264.8A CN107122445A (en) | 2017-04-19 | 2017-04-19 | Real-time question-and-answer game apparatus implementation method based on mobile phone |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107122445A true CN107122445A (en) | 2017-09-01 |
Family
ID=59726346
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710273264.8A Pending CN107122445A (en) | 2017-04-19 | 2017-04-19 | Real-time question-and-answer game apparatus implementation method based on mobile phone |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107122445A (en) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109464799A (en) * | 2018-11-02 | 2019-03-15 | 福建书香伟业教育科技有限公司 | A kind of competition method and computer readable storage medium of two people PK |
CN109815819A (en) * | 2018-12-25 | 2019-05-28 | 北京城市网邻信息技术有限公司 | A kind of cheat detection method, device, terminal device and storage medium |
CN110012359A (en) * | 2019-03-25 | 2019-07-12 | 北京小米移动软件有限公司 | Answer reminding method and device |
CN111080999A (en) * | 2019-12-13 | 2020-04-28 | 林捷 | Wireless answering system applied to intelligence competition |
CN111343229A (en) * | 2020-01-20 | 2020-06-26 | 北京翼鸥教育科技有限公司 | Online answering initiating and responding method and online answering system |
CN113947166A (en) * | 2021-10-08 | 2022-01-18 | 上海众言网络科技有限公司 | Questionnaire statistics real-time processing method, system, electronic equipment and storage medium |
CN116029875A (en) * | 2023-03-02 | 2023-04-28 | 江苏一道云科技发展有限公司 | Intelligent competition appraising system based on cloud computing technology |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104851179A (en) * | 2015-05-18 | 2015-08-19 | 广西大学 | Voting system based on WeChat public platform |
CN104901868A (en) * | 2015-05-18 | 2015-09-09 | 广西大学 | Responder based on Wechat public platform |
-
2017
- 2017-04-19 CN CN201710273264.8A patent/CN107122445A/en active Pending
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104851179A (en) * | 2015-05-18 | 2015-08-19 | 广西大学 | Voting system based on WeChat public platform |
CN104901868A (en) * | 2015-05-18 | 2015-09-09 | 广西大学 | Responder based on Wechat public platform |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109464799A (en) * | 2018-11-02 | 2019-03-15 | 福建书香伟业教育科技有限公司 | A kind of competition method and computer readable storage medium of two people PK |
CN109815819A (en) * | 2018-12-25 | 2019-05-28 | 北京城市网邻信息技术有限公司 | A kind of cheat detection method, device, terminal device and storage medium |
CN110012359A (en) * | 2019-03-25 | 2019-07-12 | 北京小米移动软件有限公司 | Answer reminding method and device |
CN111080999A (en) * | 2019-12-13 | 2020-04-28 | 林捷 | Wireless answering system applied to intelligence competition |
CN111343229A (en) * | 2020-01-20 | 2020-06-26 | 北京翼鸥教育科技有限公司 | Online answering initiating and responding method and online answering system |
CN113947166A (en) * | 2021-10-08 | 2022-01-18 | 上海众言网络科技有限公司 | Questionnaire statistics real-time processing method, system, electronic equipment and storage medium |
CN116029875A (en) * | 2023-03-02 | 2023-04-28 | 江苏一道云科技发展有限公司 | Intelligent competition appraising system based on cloud computing technology |
CN116029875B (en) * | 2023-03-02 | 2024-01-26 | 江苏一道云科技发展有限公司 | Intelligent competition appraising system based on cloud computing technology |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107122445A (en) | Real-time question-and-answer game apparatus implementation method based on mobile phone | |
Bederson et al. | Electronic voting system usability issues | |
CN110390068B (en) | Knowledge competition method, system, equipment and storage medium | |
CN104462122A (en) | Test question data processing method and device | |
CN107291463A (en) | A kind of software APP that practises handwriting of Multifunctional multimedia on mobile phone | |
CN109800592A (en) | A kind of group signs up for participating in competition points-scoring system online | |
US20060281512A1 (en) | Automatic publication of interactive crossword puzzles | |
JPH10143491A (en) | Questionnaire system | |
JP2004242816A (en) | Quiz provision system | |
CN106651428A (en) | Lucky draw data processing method and device | |
JP2003016199A (en) | Test conducting method | |
US20020107725A1 (en) | Scholarship award method | |
JP2016521406A (en) | Ranking system | |
Azameti et al. | Design and Implementation of Electronic Voting Systems (Evss) for Effective Election Management: A Contemporary Approach | |
US20210052943A1 (en) | Pitcher Statistics Tracking and Monitoring System | |
JP2009008729A (en) | Particpatory organization learning server and participatory organization learning program | |
CN110766576A (en) | Student data management method and system | |
JP2002083215A (en) | Method for providing web site retrieval service and the web site retrieval service, method for providing prospect game service and system for providing prospect game service | |
KR20020073358A (en) | Study system and the method using internet | |
CN104464424A (en) | Game data processing method and device | |
KR101126763B1 (en) | Online education service system and method using a game | |
JP2013168042A (en) | Contest server device | |
KR20020096839A (en) | Management system for the controlling between players and corporation using on and off line | |
US20230267810A1 (en) | Distributed live bingo system and methods | |
Singh et al. | Online Portal for Issuing Driving License with Mock Test Series |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WD01 | Invention patent application deemed withdrawn after publication | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170901 |