Webmaster
From ATS Wiki
THIS IS A DRAFT THIS IS NOT DONEEEEEEE!!!!!!
There are three main parts to being the ATS webmaster - taking care of the ATS website, taking care of the ATS wiki, and taking care of ATS mailing lists.
Contents |
ATS Website
Skills
The website is written in mostly PHP and HTML, with some scatterings of Javascript. You'll also need to work with some SQL databases.
w3schools stackoverflow google
Accessing Files
The files are hosted in the ATS Athena locker at /afs/athena.mit.edu/activity/m/mitats/web_scripts (the easiest way to read/write to these files is either to SSH into Athena and use vim/emacs to edit the files directly, or to grab a local copy of the files for editing, and then FTP the files back.)
FTP [1]
If you don't already run something that uses a terminal, MIT provides a free copy of SecureFX/Fetch (and more software!) at this link: [2]. Pick your OS and put 'File Transfer' for the use. Then download and install the program.
Log in to ftp.dialup.mit.edu[3] using your Kerberos (password is also your Kerberos password) and accept the host. SecureFX doesn't ask for a remote location when you first run it but if whatever you're using does, I think the right one is /mit/mitats. If that doesn't work just use your home directory and manually navigate to ats lol. Then if you're running SecureFX you can do edit > set initial location and the next time you connect it'll be fine yay!
SSH into Athena [4]
Uhhh basically just follow those instructions. I use PuTTY but if you also followed the instructions above you can use SecureCRT. Editing using the terminal is really annoying so I'd recommend...not doing it...............
Accessing SQL Databases
https://sql.scripts.mit.edu/phpMyAdmin/
Important Specifics
Adding people to gain access for read/write
To see who has permissions to modify the current directory, run > fs la
To give a user write permissions to the current directory, run > fs sa . NEWUSER write or to specify a directory, run > fs sa MYDIR NEWUSER write
Giving Social Chairs Access
You should give the social chairs read/write access to the /family directory so they can edit the family lines.
Do this by manually navigating to the folder /afs/athena.mit.edu/activity/m/mitats/web_scripts/family/edit in the terminal. Then type vim .htaccess and you'll see a tiny bit of text containing a list of kerberii. Navigate to this list using the arrow keys and press i to insert. Add the kerberos for new social chairs.
When you're done, press escape and then type :w to save, or :x to quit the program.
Alternatively just FTP the file over to yourself, edit it, and FTP back, but that's a bit bothersome for how little editing you have to do.
Giving access to everything
You'll need to give your successor similar access, but to all the directories instead. For more information, visit kb.mit.edu/confluence/pages/viewpage.action?pageID=3907138 or /afs/athena.mit.edu/activity/m/mitats/HOW_TO_GIVE_PERMISSIONS.txt. The mailing list https://groups.mit.edu/webmoira/list/mitats-request has access to all pages, so you can just add your successor to that list.
Adding people to exec
execportal.php
Ok, this is super ghetto and hopefully this will change after the website is no longer written in PHP.
Steps:
SSH into athena, go to the ats locker.
> cd /mit/mitats
Go into the web scripts folder where the execportal.php file is located. View the file and observe the secret info how to connect to mysql database on the top (trying to be vague here, because this page is public viewable).
If you have experience with mysql, you should be able to infer enough to connect to the mysql database now. Find the table called board and insert values of new execs accoding to the schema (or following template: exec (bool), athena, first name, last name, year of graduation):
> INSERT INTO board VALUES (1, "kerberos@MIT.EDU" , "First", "Last", 2019);
You can either write a script and insert everyone, or you can just add yourself and finish the job from a phpMyAdmin that will be accessible to you from the exec portal. (Do kids these days still know what phpMyAdmin is?)
They probably don't, so just drop into the console:
> mysql -u mitats -h sql.mit.edu mitats+general -p
http://ist.mit.edu/software/athena/helpinfo
Exec pictures
You need 150 (width) x 200 (height) pictures of each exec member. Put them in the /media folder, and name them however you want. It's probably easier for you to keep a consistent naming scheme so that you don't mess up the URLs when you're editing exec.board.php. ex: firstname_lastname.png
After that, you should edit exec.board.php with the new exec's kerberii and names and photos! You can do this in one of multiple ways. You can use vim (type vim filename into the terminal, edit and cry while you edit, save by pressing escape and then typing :w, and then quitting by typing :x) but this is painful. I'd recommend FTPing the file over to your own computer and editing there, then FTPing back.
Managing RSVPs
events.RSVP.php
??? no one has told me what this means or what it does - ehhu
home.php
Freshman Rep App
submitfreshmanrepapp.php freshmanrepapp.php viewfreshmanrepapp.php
News Form
ATS Wiki
Editing Wikis
Naming Convention
Moving/Deleting pages
Wiki Special Pages
ATS Mailing Lists
Moira
