# BabelCDB

**Repository Path**: zx14855735/BabelCDB

## Basic Information

- **Project Name**: BabelCDB
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-04-27
- **Last Updated**: 2021-04-27

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Project Ignis card databases for EDOPro

These databases are automatically synchronized with servers. Please keep all bug reports and questions on Discord; do NOT open an issue or pull request. External contributions are not allowed here.

If you are submitting a database for a new unofficial addition, please submit a single new database to [Larry's fork](https://github.com/larry126/BabelCDB), where they will eventually be combined and merged back upstream. To submit such a pull request, first follow the contributing guidelines for the [script collection](https://github.com/ProjectIgnis/CardScripts). The pull request title should be the same, and the description should simply link to the pull request to the script collection.

## Guidelines for SQLite3 CDB files

* For new cards:
	* for each new set, add a `preRelease` cdb with its name
		* when that set is released, update the cards ID and remove the pre-release OT, then move the cards to `official.cdb`.

* For fixes to existing cards:
	* for official cards:
		* if the card is already in a cdb in [the repository the users get updates from]( https://github.com/ProjectIgnis/DeltaHopeHarbinger), edit the entry in the corresponding file here, so it gets committed over there.

		* if not, add it to one of the following files here:
			* `fixSetcode.cdb`: for changes in the setcodes of the card.
			* `fixString.cdb`: for changes in the strings used by the card, including card text.
			* `fixOT.cdb`: for changes in the OTs of the card.
			* `fixMisc.cdb`: for changes not listed above. Please describe what you have changed.

	* for unofficial cards:
		* same as above, but add `-unofficial` to the file name. Example: `fixMisc-unofficial.cdb`

* New products are not longer called "beta". They are "pre-release". As such, they take a corresponding OT, (hex= 0x100, dec=256).

* We have replaced the categories used as filter in the "Effect" button in Deck edit for 32 different categories.

* If you use DataEditorX, use this [English file](https://github.com/NaimSantos/DataEditorX/blob/master/DataEditorX/data/cardinfo_english.txt) with the updated archetype names/setcodes, the new OTs, and the new categories already mapped.

## GitHub Actions

Responsible for pushing database updates to [the repository the users get updates from]( https://github.com/ProjectIgnis/DeltaHopeHarbinger)
- new CDBs since [the last tag](https://github.com/ProjectIgnis/BabelCDB/tree/20200403) are directly committed
- delta databases are computed for databases already present and committed
	- a delta database is a database containing only new or changed rows compared to the previous version
- files that were deleted since the last Actions run are also deleted in the other repository
- if a pushed HEAD commit title contains `[ci skip]`, `[skip ci]`, `[actions skip]`, or `[skip actions]`, this is skipped.

## Guidelines for passcodes

Announced OCG/TCG cards receive a nine-digit prerelease passcode until they are
released as official product, when the official passcode is used. Speed Duel has
[its own policy](https://github.com/ProjectIgnis/CardScripts/wiki/Skill-Documentation#cdb-handling)
with the `30ZYYYXXX` range and Rush Duel has its own policy in the `160ZYYXXX` range.

- `XXX` is the card index within its set
- `Y` or `YY` is the set index, incremented by one for each chronological set of that product type
	- For Structure Decks, `YY` comes from the prefix, e.g. SD38, ST18, SR10
	- For Structure Deck Enhancement Packs, they share `YY` with the Deck and add 50 to `XXX`
	- For Deck Build Packs, `YY` counts up from the previous one
	- For Duelist Packs, `YY` comes the prefix
	- TODO: there is potential overlap with this above scheme, to be eventually reworked
- Main set: `10ZZYYXXX`
	- Series `ZZ`: currently 11
- Side set: `1002YYXXX`
	- All VJMP-JP (V Jump) promos are considered part of set 200
	- All WJMP-JP (Weekly Shounen Jump) promos are considered part of set 203
	- All SJMP-JP (Saikyou Jump) promos are considered part of set 204
- Structure Deck and Starter Deck: `1003YYXXX`
- Deck Build Pack and Duelist Pack: `1004YYXXX`
- Rush Duel sets: `160ZYYXXX`
	- `Z` product type
	- 0: KP Deck Modification Pack "main booster"
	- 2: CP Character Pack "side booster"
	- 3: ST Starter Deck
	- 4: Promos

Unofficial cards fall under numerous ranges due to historical reasons but are
slowly being reworked and reorganized to the `511YYYXXX` range.

Cards with passcodes aliased to a passcode within 10 are treated as alternate
artworks.

### Upcoming sets

Release date | Set | Prefix | Prerelease passcode
--- | --- | --- | ---
2020-04-04 | [Starter Deck Yuga - Cut Through! Sevens Road!!][RD/ST01-JP]      | RD/ST01-JP | 160301XXX
2020-04-04 | [Starter Deck Luke - Explosive Supremacy! Dragears!!][RD/ST02-JP] | RD/ST02-JP | 160302XXX
2020-04-04 | [Starter Deck Set - Yuga vs. Luke][RD/VS01-JP]                    | RD/VS01-JP | 160401XXX
2020-04-11 | [Deck Modification Pack - Hyperspeed Rush Road!!][RD/KP01-JP]     | RD/KP01-JP | 160001XXX
2020-04-18 | [Rise of the Duelist][ROTD-JP]                                    | ROTD-JP | 101101XXX
2020-04-24 | [The Valuable Book 22 promotional cards][VB22-JP]                 | VB22-JP | 100264XXX
2020-05-30 | [Duelist Pack: Duelists of Gloom][DP24-JP]                        | DP24-JP | 100424XXX
2020-06-18 | [Toon Chaos][TOCH-EN]                                             | TOCH-EN | 100268XXX
2020-06-20 | [Collection Pack 2020][CP20-JP]                                   | CP20-JP | 100266XXX
2020-07-04 | [Structure Deck: Masters of the Spiritual Arts][SD39-JP]          | SD39-JP | 100339XXX
2020-07-04 | [Structure Deck: Masters of the Spiritual Arts][SD39-JP]          | SD39-JPP| 10033905X
2020-07-30 | [Prismatic Special Pack][VP20-JP]                                 | VP20-JP | 100267XXX
2020-08-01 | [Deck Modification Pack - Shocking Lightning Attack!!][RD/KP02-JP]| RD/KP02-JP | 160002XXX
2020-08-08 | [Phantom Rage][PHRA-JP]                                           | PHRA-JP | 101102XXX
2020-08-27 | [Tin of Lost Memories][MP20-EN]                                   | MP20-EN | 100268XXX
2020-08-29 | [Structure Deck R: Dragunity Drive][SR11-JP]                      | SR11-JP | 100311XXX
2020-09-04 | [_OCG Structures_ Volume 2 promotional card][YO02-JP]             | YO01-JP | 100269XXX
2020-09-12 | [Deck Build Pack: Genesis Impactors][DBGI-JP]                     | DBGI-JP | 100415XXX
2020-09-19 | [Character Pack - Gakuto/Roa/Romin][RD/CP01-JP]                   | RD/CP01-JP | 160201XXX
2020-09-21 | [V Jump Fall 2020 subscription bonus][VJMP9]                      | VJMP-JP1XX | 100200XXX
2020-10-03 | [World Premiere Pack 2020][WPP1-JP]                               | WPP1-JP | 100270XXX
2020-10-28 | [_SEVENS Duel-1 Blu-ray_ & DVD promotional card][RD/BD01-JP]      | RD/BD01-JP | 160402XXX
2020-10-31 | [Blazing Vortex][BLVO-JP]                                         | BLVO-JP | 101103XXX
2020-11-14 | [Deck Modification Pack - Fantastrike Mirage Impact!!][RD/KP03-JP]| RD/KP03-JP | 160003XXX
2020-11-20 | [Speed Duel Battle City Box][SBCB]                                | SBCB-EN | 100271XXX
2020-11-21 | [Structure Deck: Ice Barrier of the Frozen Prison][SD40-JP]       | SD40-JP | 100340XXX
2020-12-05 | [Selection 10][SLT1]                                              | SLT1-JP | 100272XXX
2020-12-12 | [Maximum Ultra Enhancement Pack][RD/MAX1-JP]                      | RD/MAX1-JP | 160202XXX
2020-12-16 | [Prismatic God Box][PGB1]                                         | PGB1-JP | 100273XXX
2021-01-16 | [Lightning Overdrive][LIOV]                                       | LIVO-JP | 101104XXX
????-??-?? | [Premium Pack 2021] [21PP]                                        | 21PP-JP | 100274XXX

[RD/ST01-JP]: https://yugipedia.com/wiki/Starter_Deck_Yuga_-_Cut_Through!_Sevens_Road!!
[RD/ST02-JP]: https://yugipedia.com/wiki/Starter_Deck_Rook_-_Explosive_Supremacy!_Dragears!!
[RD/VS01-JP]: https://yugipedia.com/wiki/Starter_Deck_Set_-_Yuga_vs._Rook
[RD/KP01-JP]: https://yugipedia.com/wiki/Deck_Modification_Pack_-_Hyperspeed_Rush_Road!!
[ROTD-JP]: https://yugipedia.com/wiki/Rise_of_the_Duelist
[VB22-JP]: https://yugipedia.com/wiki/The_Valuable_Book_22_promotional_cards
[DP24-JP]: https://yugipedia.com/wiki/Duelist_Pack:_Duelists_of_Gloom
[TOCH-EN]: https://yugipedia.com/wiki/Toon_Chaos
[CP20-JP]: https://yugipedia.com/wiki/Collection_Pack_2020
[SD39-JP]: https://yugipedia.com/wiki/Structure_Deck:_Masters_of_the_Spiritual_Arts
[RD/KP02-JP]: https://yugipedia.com/wiki/Deck_Modification_Pack_-_Shocking_Lightning_Attack!!
[VP20-JP]: https://yugipedia.com/wiki/Prismatic_Special_Pack
[PHRA-JP]: https://yugipedia.com/wiki/Phantom_Rage
[MP20-EN]: https://yugipedia.com/wiki/Tin_of_Lost_Memories
[SR11-JP]: https://yugipedia.com/wiki/Structure_Deck_R:_Dragunity_Drive
[YO02-JP]: https://yugipedia.com/wiki/Yu-Gi-Oh!_OCG_Structures_Volume_2_promotional_card
[DBGI-JP]: https://yugipedia.com/wiki/Deck_Build_Pack:_Genesis_Impactors
[RD/CP01-JP]: https://yugipedia.com/wiki/Character_Pack_-_Gakuto/Roa/Romin
[VJMP9]: https://yugipedia.com/wiki/V_Jump_Fall_2020_subscription_bonus
[WPP1-JP]: https://yugipedia.com/wiki/World_Premiere_Pack_2020
[RD/BD01-JP]: https://yugipedia.com/wiki/Yu-Gi-Oh!_SEVENS_Duel-1_Blu-ray_%26_DVD_promotional_card
[BLVO-JP]: https://yugipedia.com/wiki/Blazing_Vortex
[RD/KP03-JP]: https://yugipedia.com/wiki/Deck_Modification_Pack_-_Fantastrike_Mirage_Impact!!
[SPDB]: https://yugipedia.com/wiki/Speed_Duel_Box
[SD40-JP]: https://yugipedia.com/wiki/Structure_Deck:_Ice_Barrier_of_the_Frozen_Prison
[SLT1]: https://yugipedia.com/wiki/Selection_10
[RD/MAX1-JP]: https://yugipedia.com/wiki/Maximum_Ultra_Enhancement_Pack
[PGB1]: https://yugipedia.com/wiki/Prismatic_God_Box
[LIOV]: https://yugipedia.com/wiki/Lightning_Overdrive
[21PP]: https://yugipedia.com/wiki/Premium_Pack_2021