Jerricha's, a ParagonChat Database App, something to help us nerdy DB hackers automate our hacking.

• Jerricha's, a ParagonChat Database App v0.3.1
• Table of Contents
  • What does Jerricha's do?
  • How does it work?
  • I'm a total newbie to DBing and I have no idea what you just said. Can you just take me to the thing?
  • How do I run Jerrichas?
    • From .exe
    • From Source (Advanced)
  • New Features as of v.0.3.1
    • Bug Fixes
    • Body Scales & Gender
    • API
  • New Features as of v.0.2.0
    • Config file
    • Cherry-Pick mode
  • I'm a poweruser/hacker/programmer/techie, and I can roll my own SQL. Why do I need Jerrichas?
  • Things Jerrichas currently does not do, but will in the future:
  • Upcoming features

Jerricha's is an shell app that simplifies and automates DB costume hacking.

Jerricha's imports costumesave files straight into your ParagonChat database, without you having to manually query and figure out which fields go where.

I also wrote a complete newbie and idiot-proof guide to DB hacking with Jerrichas: The Ultimate Guide "DBing your Costume" Using Jerrichas

Jerrichas batch converts those costumesave files into a long SQL query (the langauge ParagonChat database uses), and executes it on the ParagonChat database. This assumes that you've already completely designed your costume in Icon.exe, and have /costumesave'd it.

Jerrichas works both at the batch level (replace an entire costume), or at the part level (replace just one part of that costume).

YES, just read this: The Ultimate Guide "DBing your Costume" Using Jerrichas

1. Download Jerrichas.exe
2. Double click on Jerrichas.exe, follow the instructions =)
3. If you're still unsure, read The Ultimate Guide "DBing your Costume" Using Jerrichas

1. Install Python 3
2. Install git
3. Clone the repo

git clone https://github.com/Jerricha/jerrichas

4. (Optional) Install virtualenvwrapper, a create virtualenvironment

cd jerrichas
pip install virtualenvwrapper-win
mkvirtualenv jerrichas
setprojectdir .
workon jerrichas

4. Run Jerrichas at the commandline with python Jerrichas.py
5. Follow the on-screen instructions

• Secondary color will now update

• Body scales and gender will update. You can replace a male.
• NOTE: Face/head scales are still being worked on

• Jerrichas has been modularized and refactored substantially
• jerrichas.ParagonChatDB and jerrichas.CostumeCSV expose functionality into the database and costumesave CSV files.
• We're working on converting Sentinel+ XML into Jerrichas
• We're also working on converting .costume files into Jerrichas

• Jerrichas will generate a config file, so you can specify your database and costumesave paths. If you ever screw it up, don't worry, Jerrichas will re-generate the config.
• BTW, don't surround your path in quotes, it'll confuse the parser (and let you know)

1. Curate your costumefile to include only the parts you want. For example, in trenchcoat_cherrypicked, this will give you just Mother Mayhem's trenchcoat.
2. Select Cherry-Pick mode from the menu =)

• Seriously, don't select Batch with a cherrypicked file, or you will seriously screw up your costume.

You absolutely can do this manually, as the community has been so far. However, in addition speeding-up and simplifying DB hacking, Jerrichas will feature full API support to the ParagonChat database, so you could build your app / l33t h4x ontop of Jerrichas.

• Update your gender! Be careful to choose the right costumefile for the right gender!
• Updates your proportions. Jerrichas currently just replaces costume parts and sets colors (...ish)
• Changes your characters' names, class, origin, description, battlecry, etc.

• Compilation into a .exe (v0.2.0)
• Cherry-pick mode (v0.2.0)
• Automated testing (on-going) (v0.3.1)
• Full API support for other developers/coders/hackers
• Mac support
• JerrichaQT GUI