Submit bugs or request changes to the Decks of KeyForge website. See below to suggest changes to the SAS system or card ratings
- Do No Harm It is more important to prevent falsely overrated decks and cards than to accurately capture all value. Your idea should improve scores for almost all decks it touches, and very rarely cause a card to be overrated in value in decks.
- Legacy Cards are lower priority If a card has not been included in the last two sets, it is considered a "legacy" card in terms of changes to SAS. Changes to legacy cards will only be considered if it is obviously inconsistent with other cards with similar scores, or there is an egregious problem.
- Avoid suggesting minor tweaks to scores Make sure your change request is relevant. If you think a card is only off by 0.25 AERC most of the time, it probably isn't worth updating.
- Read the About Page This page details the basic details of how decks and cards are scored in SAS.
- Read the AERC Rating guidelines Find the relevant sections in the AERC rating guidelines This google doc contains detailed information about how cards are rated, and what expectations and rules are used to maintain consistency.
- Compare with existing cards using the card search tool to ensure your change request is consistent with existing cards.
- Don't make duplicates Search the card change issues or sas feature change issues to make sure your request isn't a duplicate or hasn't already been rejected
Run:
./scripts/build-and-push.ps1
Login to AWS Elastic Beanstalk. Go to Upload and deploy. For file choose:
/docker/Dockerrun.aws.json
./gradlew bootRun
cd ui
yarn
npm run start
making the db in RDS:
RDS create database
postgres
only enable free tier
20GB
name: keyswap-{env}
master username: coraythan
publicly accessible yes
choose default VPC-security group
db name: keyswap
3 day backups
connecting with pgadmin
maintenance db keyswap coraythan
cd 'C:\Program Files\PostgreSQL\12\scripts\'
.\runpsql.bat
// server click enter
// database enter: keyswap
SET CLIENT_ENCODING TO 'utf8';
\COPY (select keyforge_id, name, expansion, house_names_string, sas_rating, synergy_rating, antisynergy_rating, aerc_score, amber_control, expected_amber, artifact_control, creature_control, efficiency, recursion, disruption, creature_protection, other, effective_power, raw_amber, action_count, upgrade_count, creature_count, power_level, chains, wins, losses, card_names from deck) to 'C:\Users\Coray\Downloads\dok-decks.csv' DELIMITER ',' CSV HEADER;
Find it in downloads
Run the load-cards.cmd
with the Reload Cards run config.
set PGPASSWORD=password
pg_dump -h keyswap-prod.cik0ar7sipfl.us-west-2.rds.amazonaws.com -U coraythan -F c -a -t card_traits -t card_identifier -t extra_card_info -t card -t syn_trait_value -f .\scripts\extra-info.dump keyswap
set PGPASSWORD=postgres
psql -U postgres -d keyswap -f .\scripts\truncate-card-tables.sql
pg_restore -h localhost -U postgres -d keyswap .\scripts\extra-info.dump
SELECT pg_cancel_backend(pg_stat_activity.pid)
from pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes' and state = 'active';
SELECT
pid,
now() - pg_stat_activity.query_start AS duration,
query,
state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';
LIMIT 10;
Go to profile for coraythan
Unlink and relink with buttons.
Go to: https://www.patreon.com/portal/registration/register-clients
Copy Creator's Access Token into the auth header
Delete *.png
in /card-imgs/
. Uncomment line in RunOnStart. Run app. In /card-imgs/
run:
.\pngquant.exe --ext=.png --force 256 *.png
upload to S3 public with headers: Cache-Control: max-age=31536000
Change ddl-auto
in application.yml
to update
. show-sql
to true. Run. Copy paste. Delete tables. Revert.
set PGPASSWORD=password
pg_dump --host keyswap-prod.cik0ar7sipfl.us-west-2.rds.amazonaws.com --username coraythan --format c --no-unlogged-table-data --file .\scripts\full-db.dump keyswap
set PGPASSWORD=postgres
pg_restore -h localhost -U postgres --clean --if-exists --no-tablespaces --no-privileges --no-owner -d keyswap .\scripts\full-db.dump
To update passwords run: update key_user set password = 'hash-from-db-for-password-to-make-all-passwords';