Skip to content

Instantly share code, notes, and snippets.

@mikegreen
mikegreen / 00-base.conf
Created April 24, 2020 18:08
Clean up of PNP modules 00-base.conf
#
# This file loads most of the modules included with the Apache HTTP
# Server itself.
#
#LoadModule access_compat_module modules/mod_access_compat.so
#LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
#LoadModule allowmethods_module modules/mod_allowmethods.so
#LoadModule auth_basic_module modules/mod_auth_basic.so
#!/bin/bash
# supports https://docs.google.com/document/d/1N-5cyHh2YYwvtq5ntw0lKZ4MH_YvVatVqAd3nKu_9-Y/edit#
cd /home/ec2-user/forum-work/pnp_maps
git pull
cd maps_more
sudo cp -r ./mapsmore* /var/www/html/maps_more
#!/bin/bash
# supports https://docs.google.com/document/d/1N-5cyHh2YYwvtq5ntw0lKZ4MH_YvVatVqAd3nKu_9-Y/edit?usp=sharing
cd /home/ec2-user/forum-work/pnp_forum
git pull
sudo rm -r -f /var/www/html/forum/cache/
sudo cp -r ./ /var/www/html/forum

Keybase proof

I hereby claim:

  • I am mikegreen on github.
  • I am mikegreenhc (https://keybase.io/mikegreenhc) on keybase.
  • I have a public key ASAXCx-MMORzDP1bz5-lzpxfPhDOjzT9eWwoDiscjP505wo

To claim this, I am signing this object:

@mikegreen
mikegreen / gist:475d04448e0fd9f53a77
Last active September 29, 2021 01:48
roommaster sql
-- sample row
SELECT FIRST CONFNUM, [INTERN NUM], RESERVESTATUS, CHECKIN, CHECKOUT, NIGHTS, BEDTYPE,
[RATE REQ], GROUPCODE, EMAIL, PREFIX, LASTNAME, FIRSTNAME, STREET, CITY, STATE,
ZIPCODE, COUNTRY, PHONE1, ADULTS, CHILD, ROOMRATE, ENDRATE, VIPNUMBER,
HOUSENOTE, NOC, MADEBY, ENTEREDBY, ENTRYDATE, ENTRYTIME,
CAST(CAST(ENTRYDATE AS VARCHAR(20)) + ' ' + CAST(ENTRYTIME AS VARCHAR(20)) AS DATETIME) as ENTRYTIMESTAMP,
CHANGEDATE, CHANGETIME,
CAST(CAST(CHANGEDATE AS VARCHAR(20)) + ' ' + CAST(CHANGETIME AS VARCHAR(20)) AS DATETIME) as CHANGETIMESTAMP,
CXLNUM,
CASE