PLK_QuizGamePlugin

Displays a list of sequences and adjustable icons 1-10.

Display unlimited custom categories

After selecting a category, the questions in that category will be answered and the score will be given.

  * Terms of Use *  No duplication or distribution is permitted. Can be used in commercial games I ask you to specify "Palatkorn" in your game credits only

✅ How to Use in Google Sheets

1. Create a new Google Sheet and set up the columns as above.
2. Copy and paste the table data into the sheet.
3. Integrate the Google Sheets API with RPG Maker MZ using a plugin.
   
4. Test the item functionality in the game. 🎮

Prevent duplicate submission, prevent repeating the same task completely

When you complete the same task and repeat it, the system will not save that task. In this way, we will always get the real activity and score of the player.

Same database

Plug-in must be loade PLK_GoogleSheetEmailRegister

Copy Google Sheet to your own database

You should also update your app script version if you are an existing user.

Paste the same URL into the plugin.

Select 

PLK_QuizGamePlugin

Put URL here https://script.google.com/macros/s/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

You can set the phone number format according to your country and customize the window.

Step	Description	Parameters/Commands Involved
1. Set Parameters	Configure values in the Plugin Manager for: - googleScriptUrl: URL of the Google Apps Script Web App - phoneRegex and phoneExample: For validating phone numbers - Background and WindowSkin: The background image and window skin - scrollSpeedX and scrollSpeedY: Background scroll speeds - rankIconIds: Icon IDs for rankings - scoreColumns: Settings for the score window columns (e.g., Rank, Name, Score, Last Date)	Plugin parameters
2. Add Topic (AddTopic)	Use the AddTopic Plugin Command by sending a JSON struct (TopicData) that includes: - topicName: The topic name - inputMode: The answer input mode (either "multiple" or "manual") - requirePhone: Boolean indicating if a phone number is required for this topic - quizList: An array of QuizData (each quiz includes a question, options, and optionScores)	Plugin Command: AddTopic Structs: TopicData, QuizData
3. Start the Quiz (StartQuiz)	Use the StartQuiz Plugin Command to: - Retrieve the player's nickname from Actor #1 (via the getPlayerNickname function) - Verify the nickname exists in the "User" sheet - If found, proceed to the topic selection scene	Plugin Command: StartQuiz
4. Choose a Topic (Scene_QuizTopic)	Displays a list of topics that haven’t been completed yet. - The topic names support line breaks (using "\n") and are centered in the list	Scene: Scene_QuizTopic Window: Window_QuizTopic
5. Play the Quiz (Scene_Quiz)	Once a topic is selected, the system will: - Load the questions for the selected topic - Display the question text (replacing string literals "\n" with actual newlines) - Depending on the inputMode: • multiple: Show selectable options • manual: Provide an input field for the answer - If requirePhone is true, prompt the player to enter their phone number before submitting an answer	Scene: Scene_Quiz Windows: Window_QuizChoices or Window_ManualInput
6. Submit an Answer	When the player answers a question, the system sends the following data to the Google Apps Script to record it in the "QuizLog" sheet: - Nickname, Topic, Question, Answer, Phone, Score - The system checks to avoid recording duplicate answers for the same topic and question.	Function: sendQuestionAnswer
7. Award Special Score (GiveSpecialScore)	Use the GiveSpecialScore Plugin Command with parameters: - score: The special score value to award - reason: A description that will be used as both the Topic and Question for the special score entry - ID: A special identifier to record in the sheet The system checks if the player has already received a special score for the same (Nickname, reason, ID) before recording the new entry.	Plugin Command: GiveSpecialScore
8. Show Overall Scores (ShowScores)	Use the ShowScores Plugin Command to display a scrollable window showing the overall scores of all players, with data loaded from the Google Apps Script (via action=loadScores)	Plugin Command: ShowScores