yugiohcards VS ygo-fabrica

The actual scripting is kind of the simplest part, since you usally need to find a card that does something similar, search it up on EDOPro, and click the card name to open its script. Then you simply copy the parts you need to your c.lua, and if you do that often enough you just eventually figure out what the commands actually mean. The .cdb file is a lot trickier because you first need to set up the correct table structure (easiest way to do it manually is copying an existing one and emptying out the data with a SQLite editor) and then enter all the information with the correct numeric values for card type, attributes, etc. Here's a pretty old tutorial that should still be fairly accurate, though incomplete at this point. But the process can be simplified a lot by using automated tools like YGOFabrica (uses simple text files as input, also generates the folder structure, pics, and blank script files) or mse2cdb (uses Magic Set Editor 2 projects as input, only generates/updates a .cdb file).