TheDoctor0 / TheDoctor0/CoDMod
Rework database structure
Open
@TheDoctor0 is already working on this.
Since Oct 18, 2020.
enhancement
- Dominant language
- Pawn
- Stars
- 17
- Forks
- 7
- PR merge metrics
- No merged PRs in 30d
Description
- Database manager plugin:
- initial database schema creator
- migrations support
- handles
cod_playerstable - executes all
ignore_handlequeries to database
cod_players(Primary key: player_id)
- player_id
- player_admin
- player_steamid
- player_name
- player_password (encrypted)
- player_honor (replace separate cod_honor tasble)
- player_knife (replace nvault in cod_knife plugin)
- player_bonus (replace nvault in cod_free_honor plugin)
- player_exchange (enable/disable exchange offers)
cod_classes(Primary key: player_id, class_id)
- player_id (foreign key from cod_players table)
- class_id (unique
- class_name
- class_experience
- class_level
- class_intelligence
- class_health
- class_stamina
- class_condition
- class_strength
cod_stats(Primary key: player_id)
- player_id (foreign key from cod_players table)
- stats_kills
- stats_time
- stats_first_visit
- stats_last_visit
- stats_medals_bronze
- stats_medals_silver
- stats_medals_gold
- stats_best_kills
- stats_best_hs
- stats_best_deaths
cod_missions(Primary key: player_id, class_id)
- player_id (foreign key from cod_player table)
- class_id (foreign key from cod_classes table)
- mission_id
- mission_type
- mission_additional
- mission_progress
- mission_chapter
cod_clans(Primary key: clan_id)
- clan_id
- clan_name
- clan_honor
- clan_kills
- clan_level
- clan_wins
- clan_health
- clan_gravity
- clan_damage
- clan_experience
cod_clans_members(Primary key: player_id)
- player_id (foreign key from cod_player table)
- member_clan_id (foreign key from cod_clans table)
- member_flag
- member_donations
cod_clans_applications(Primary key: player_id, clan_id)
- player_id (foreign key from cod_player table)
- clan_id (foreign key from cod_clans table)
- text
cod_clans_wars(Primary key: war_id)
- war_id
- war_attacker_clan_id (foreign key from cod_clans table)
- war_defender_clan_id (foreign key from cod_clans table)
- war_attacker_progress
- war_defender_progress
- war_duration
- war_reward
- war_started
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.