Created-by: Noam Post AI tools: GPT-4o, Qwen3, Amazon Q Version: v5.01 Version-date: 02/20/2026 ------------------------------------------------------------------------------------------------------------ GENERAL SITE USAGE: This website was created to help reduce workload and organize center data more efficently to best aid the students and their familes For local website (for pdf instuctions) 1. open XAMPP 2. click 'Start' on Apache (hosts site) and MySQL (password system) For Digital Ocean 1. runs continously 2. see backup steps if db manager not being paid for droplet ------------------------------------------------------------------------------------------------------------ LOCAL XAMPP SET UP STEPS: 1. download code from gitHub, linked to google account operations email 2. extract zip folder 3. install XAMPP (default options) 4. click 'Start' on Apache (hosts site) and MySQL (password system) 5. move the myDojo folder into C:\xampp\htdocs (should look like C:xampp\htdocs\myDojo\api...data... and so on) OR clone github to folder (easier) 6. download Visual Studio or another ide to make changes to code when needed 7. in a internet browser to go http://localhost/phpmyadmin/ or click 'Admin' button next to MySQL 8. in left sidebar click 'Databases' 9. under 'Create database' enter 'user_management' as name of database then click 'Create' 10. user_management will now apear on left side bar, click it 11. click Import tab on top bar 12. get latest .sql database backups from sharepoint website folder, or for latest latest export from digital ocean phpadmin 13. click browse and select .sql file 14. hit Import button (if you get an error from table already existing, delete/drop tables under Structure tab, I recomend exporting a backup before just in case) 15. repeat steps 9-14 with 'dojo_system' and 'site_resources' 16. go to C:\xampp\htdocs\myDojo\data\config and move db.php from a backup of website DIGITAL OCEAN SET UP STEPS: THESE ARE INCOMPLETE AND ALSO NOT TESTED! type history to see all commands and you can see my original set up sans admin commands 1. cloud.digitalocean.com/login, sign in with google operations email 2. click droplet 'ubuntu-s-1vcpu-512mb-10gb-sfo3-01' 3. click 'Console' in top right corner 4. Check if apache is installed, if not apt install apache2 -y systemctl enable apache2 systemctl start apache2 apt install php libapache2-mod-php php-mysql -y 5. set up admin passwords and such ??? 6. install db tools mysql_secure_installation 7. clone code to web root cd /var/www/html rm -f index.html git clone https://github.com/conico-ninja/myDojo.git . 8. upload db.php mkdir -p /var/www/html/myDojo/data/config ??? make sure db.php is not saved by github or you will have to regenerate new hash passwords! 9. Set permissions chown -R www-data:www-data /var/www/html/myDojo chmod -R 755 /var/www/html/myDojo chmod 600 /var/www/html/myDojo/data/config/db.php 10. protect config directory echo -e "\n Require all denied\n" > /var/www/html/myDojo/data/config/.htaccess (optional, once domain is given) 11. Enable HTTPS with Certbot apt install snapd -y snap install core; snap refresh core snap install --classic certbot ln -s /snap/bin/certbot /usr/bin/certbot certbot --apache --non-interactive --agree-tos -m your@email.com -d your_domain_or_ip 12. restart systemctl restart apache2 mariadb 13. git ignore local config files during pulls cd /var/www/html/myDojo git update-index --assume-unchanged data/config/db.php ------------------------------------------------------------------------------------------------------------ LOCAL GITHUB SETUP: Front desk already has it set up, can be messy if it gets reset 1. make sure you have the root folder matching what is on github website 2. usually i delete the htdocs folder (C:\xampp\htdocs) and then open github and clone repo to it. 3. This readme should sit in \htdocs alongside myDojo 4. if the file hireachy gets messed up you'll know (either large change log on git or digital ocean will break on pull) DIGITAL OCEAN GITHUB SETUP: Currently the git should be linked to the vm, there are various ways to get access to the private repo. note that using a google account for the github account makes the typical prompt of user/password not work ( in the future i recomend setting up a github account differently ) ------------------------------------------------------------------------------------------------------------ HELPFUL SITE SETUP: - use Inspect element on browser to find issues when launching through XAMPP - Apache. - you can modify dirrectly in mySQL but using php request set up in /data is much simpiler - if xampp breaks it is much easier to reinstall xampp and rego through setup steps ------------------------------------------------------------------------------------------------------------ UPDATE WEBSITE: 1. make desired edits on Visual studio and test with XAMPP server first 2. push on github desktop 3. login to digitial ocean 4. click myDojo droplet 5. click 'Console' 6. type 'cd var/www/html/myDojo' (make sure in ls -la /var/www/html/myDojo/) 'git pull origin main' 7. run 'sudo systemctl restart apache' (not usualy needed) ------------------------------------------------------------------------------------------------------------ BACKUP DATABASE: For most days only dojo_system needs to be backed up. User_managment only stores passwords and site_resources is links 1. go to ipadress/phpmyadmin/ 2. login, look at data/config/db.php for user/passwords for each database OR get admin login from binder to view all dbs at once 3. on side bar, find database name 4. on top bar find Export 5. don't chance any settings, click Export at bottom 6. make sure file has downloaded, sometimes downloads from unsecured websites need extra confirm step in browser download tab 7. for backing up to sharepoint add yyyy_mm_dd to end of file name