Skip to content

SSOFB/StreetArtAberdeen

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Street Art Aberdeen

A gallery and map of street art in Aberdeen, Scotland, built with Joomla, online at https://streetartaberdeen.org/

Screen grabs

They'll probably be out of date shortly, but a picture tells a 1000 words I guess. Map View Gallery View

To-do

Moved into issues, see https://github.com/SSOFB/StreetArtAberdeen/issues

Project links

Website tech links

Useful Joomla! docs

Street Art Links

Fonts

Git cheat-sheet

  • Get started git clone git@github.com:SSOFB/StreetArtAberdeen.git
  • Get updates from main git fetch origin then git pull
  • Commit changes git commit -m "all fixed" or git commit -a -m "all fixed"
  • Add a file git add blah
  • Send your changes to the main git push origin main
  • Set git to ignore file permission changes git config core.fileMode false

DNS and hosting

178.79.157.89

Handy SQL

Change a field value...

UPDATE `s3ib7_fields_values` SET `value`='Sculpture' WHERE `value`='3D' AND `field_id`=1;

UPDATE `s3ib7_fields_values` SET `value`='Mosaic' WHERE `value`='Sculpture' AND `field_id`=1 AND `item_id` IN(832,475,687,474,536,710,476,690,151,860,303);

UPDATE `s3ib7_fields_values` SET `value`='Spray' WHERE `value`='Unknown' AND `field_id`=1;

Handy Video snippets

Create a video stretching the image to fit, 5fps...

ffmpeg -framerate 5 -pattern_type glob -i "large*.jpeg" -vf "pad=ceil(iw/2)*2:ceil(ih/2)*2"  movie01.mp4

Create a video, keeping the image aspect ratio, 10fps...

ffmpeg -framerate 10 -pattern_type glob -i "large*.jpeg" -vf "scale=1280:720:force_original_aspect_ratio=decrease,pad=1280:720:(ow-iw)/2:(oh-ih)/2"  movie03.mp4