snippets.txt

MOVE TO SERVER
winSCP local/dash.../server.zip server/dash...
server/dash...
rm package-lock.json
cp ~/server/motg/.htaccess .
cp app.mysql.js app.js
package.json:
  "homepage": "https://dash.marysonthego.tech"
  "main": "app.js"

edit /local/dashboard/public/baseUrl.js
  export const baseUrl = "https://dash.marysonthego.tech:${PUBLIC_URL}";
cd local/ npm run build
cp local/dashboard/build/* local/public
cd local/public
select all, zip then rename to public.zip
winSCP to server/dash/public
unzip public.zip -d public
cd ..
node app



UPDATE returns object
{fieldCount: 0, affectedRows: 1, insertId: 0, info: "Rows matched: 1 Changed: 1 Warnings: 0",…}
affectedRows: 1
changedRows: 1
fieldCount: 0
info: "Rows matched: 1  Changed: 1  Warnings: 0"
insertId: 0
serverStatus: 2
warningStatus: 0

ADD returns object
{fieldCount: 0, affectedRows: 1, insertId: 10034, info: "", serverStatus: 2, warningStatus: 0}
affectedRows: 1
fieldCount: 0
info: ""
insertId: 10034
serverStatus: 2
warningStatus: 0

GET returns array of objects
[{id: 100011, zip: "92154", cell: "4695253229", custid: 10000, nickname: "", weatheralert: 0,…},…]
0: {id: 100011, zip: "92154", cell: "4695253229", custid: 10000, nickname: "", weatheralert: 0,…}
1: {id: 100015, zip: "93722", cell: "4695253229", custid: 10000, nickname: "Fresno", weatheralert: 1,…}
2: {id: 100017, zip: "98115", cell: "4695253229", custid: 10000, nickname: "Seattle", weatheralert: 1,…}
3: {id: 100022, zip: "90011", cell: "4695253229", custid: 10000, nickname: "Lax", weatheralert: 1,…}
4: {id: 100023, zip: "98058", cell: "4695253229", custid: 10000, nickname: "Renton", weatheralert: 1,…}
5: {id: 100035, zip: "97402", cell: "4695253229", custid: 10000, nickname: "Eugene1", weatheralert: 1,…}

{/^https?:\/\//.test(url)
                  ? <a href="https://alertsforgood.org/about" className="ml-10">
                    About
                    </a>
                  : <Link to={url} />
                  }
                  
                  <div className="ml-10">About
                    {window.location.assign("https://alertsforgood.org/about")}
                  </div>      
                  
                  <div className="d-flex">
                
                  <a href="https://alertsforgood.org/volunteer" className="ml-10">
                    Volunteer
                  </a>
                  <a href="https://alertsforgood.org/donate" className="ml-10">
                    Donate
                  </a>
                  <a href="https://alertsforgood.org/about" className="ml-10">
                    About
                  </a>    
                </div>
                
<Dropdown className="dropdown-inline" drop="down" alignRight>
            <Dropdown.Toggle
              className="btn btn-transparent-dark btn-sm font-weight-bolder dropdown-toggle px-5"
              variant="transparent"
              id="dropdown-toggle-top">
              Export
            </Dropdown.Toggle>
            <Dropdown.Menu className="dropdown-menu dropdown-menu-sm dropdown-menu-right">
              <DropdownMenu2 />
            </Dropdown.Menu>
          </Dropdown>
    
Mixed Content: The page at 'https://marysonthego.tech/todos' was loaded over HTTPS, but requested an insecure stylesheet 'http://www.modrails.com/error_pages/1.0/error_page.css'. This request has been blocked; the content must be served over HTTPS.

\Device\HarddiskVolumeShadowCopy16\Windows\System32\config\systemprofile\AppData\Local\Microsoft\Windows\INetCache\IE\T15XV11I.htm->(SCRIPT0004)