Misc

SQL

Using the GetGalleryForDisplay stored procedure:

CALL usp_galleries_GetGalleryForDisplay('Y','N',NULL
    ,NULL,NULL,NULL,NULL,NULL,NULL,NULL
    ,'antsstyle',NULL,NULL,NULL,NULL,25,0,NULL,NULL,NULL)

Get a comma-separated string with all the column names of a given table:

SELECT GROUP_CONCAT(column_name ORDER BY ordinal_position)
FROM information_schema.columns
WHERE table_schema = 'deserted_chateau' AND table_name = 'user_artworks'

Scripts

sudo ./AddEmailTemplate.sh \
    --template DesertedChateau-Activation-Email \
    --subject "Activate your Deserted Chateau account" \ 
    --html "activation/activation.html" \
    --update


sudo ./SendTestActivationEmail.sh \
  --email "testuser1@desertedchateau.com" \
  --activationcode 123