Equipment management and role numerical simulation system of original sacred relic game based on pythongui
編輯：Python
Resource download address ：https://download.csdn.net/download/sheziqiong/85794791 Resource download address ：https://download.csdn.net/download/sheziqiong/85794791 Game equipment management and numerical simulation system （ The paper + Project source code and database files ） Catalog Game equipment management and numerical simulation system 1
System Overview 1
System functional requirements 2 2.1 Relic backpack Management 2 2.2 Weapon atlas 3 2.3 Character assembly simulation 3 2.4 Login system 4
Database design 5 3.1 ER chart 5 3.2 Logical structure design of database 6 3.3 Database physical design 10
Detailed design and implementation 11 4.1 Definition and implementation of database transaction 11 4.2 Definition and implementation of database view 21 4.3 Definition and implementation of database trigger 22
Database test 30 5.1 Relic add function test 31 5.2 Relic delete function test 33 5.3 Relic screening function test 36 5.4 Relic sorting function test 38 5.5 Weapon atlas function test 42 5.6 Character assembly simulation test 43 5.7 Login system and data recovery test 57 1. System Overview Proto God is a popular game at present , It has rich equipment systems and character attributes , The system is designed to assist users in managing game equipment , And simulate and assemble the game characters . The system helps users to view the character attributes after assembling equipment through complex numerical calculation , Such as attack power 、 crit 、 Critical hit damage, etc , Thus, it is convenient for players to select equipment and evaluate the strength of their characters . The original divine equipment is divided into weapons and holy relics , Holy relics can be further divided into flowers according to the assembly position 、 Feather 、 hourglass 、 glass 、 There are five kinds of helmets . Each character owned by the player can only be equipped with one weapon and five holy relics in different parts . The name of the weapon 、 Main attribute 、 By attributes 、 Skill information , Relic has assembly parts 、 type 、 name 、 Grade 、 Main attribute 、 Sub attribute information . Details of weapons and relics can be found in the attribute definitions of the tables in the database .
System functional requirements The system shall provide four functional modules , They are the management of holy relics backpacks 、 Weapon atlas 、 Character simulation assembly 、 Login system , Besides , The system shall have good GUI Interactive interface , Convenient for users . 2.1 Relic backpack Management Considering the practical use and significance of the application , Since the holy relics below five stars in the original God are only used as strengthening materials , There is no practical use , So the relic backpack only manages the five-star relic in the game . （1） Users can browse the relics in the warehouse in the relics management interface , Relics are displayed in thumbnails , Users can visually see the name of the relic in the thumbnail 、 Grade 、 appearance 、 Main attribute 、 By attributes 、 Whether it has been equipped . （2） Users can add holy relics to the warehouse , The add interface allows the user to enter the type of relic 、 Grade 、 Properties and other information . （3） Users can assemble relic to characters , Characters that have been equipped with relic in this part can no longer be equipped . （4） Users can delete relics in the warehouse , Deletion is divided into single choice deletion and batch emptying . （5） Users can filter relics , Screening criteria include the type of relic 、 Assembly position 、 Specific attribute types , And it can combine different conditions for screening . （6） Users can sort the relics , The sorting function is divided into level positive sequence 、 Rank reverse 、 Sort by assembly part 、 Sort by type , Sorting by assembly position and sorting by type are mutually exclusive . （7） Users can import external relic data into the database in batches . 2.2 Weapon atlas The system contains the five-star weapons of the original God , Because of the small number of weapons , Players have no management needs in the game , Therefore, the query function is required , It is convenient for users to reasonably assemble roles . （1） Users can browse the weapons in the game in the weapons illustrated interface . （2） The weapons are shown in pictures , The user can click on the weapon picture , View the weapon details on the right side of the interface . 2.3 Character assembly simulation （1） Users can add characters in the character assembly simulation interface , The newly added character has no equipment by default , There cannot be more than one role in the warehouse . （2） Users can assemble or unload weapons and holy relics for characters in the warehouse . （3） Users can view the attribute values of roles , After the new role is warehoused , The attribute is the character in the game 90 Basic properties of level , The attribute value of the character will change with the weapon , The assembly and removal of holy relics change dynamically . （4） Users can delete roles in the warehouse , The deletion function is divided into single selection deletion and batch emptying . 2.4 Login system （1） Users have their own account information , Before starting the system each time, you need to enter the login information to connect to the database . （2） The system can use the login information of the user , Initialize the user warehouse with the data from the back-end database , That is, use the database information to restore user data in the front-end interface . （3） The user entered the wrong account information , The system can prompt the user that the information is incorrect , Need to re-enter information . Resource download address ：https://download.csdn.net/download/sheziqiong/85794791 Resource download address ：https://download.csdn.net/download/sheziqiong/85794791
