Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- user=*******
- pass=*******
- base=*******
- echo "
- <html>
- <head>
- <title>Liste des Synchro.</title>
- </head>
- <body>
- <h1>Dernière Date Synchro Techniciens.</h1>
- <form name=\"Rafraichir\" method=\"post\" action=\"/script.php\">
- <input type=\"submit\" value=\"Rafraichir\">
- </form>
- <pre>" >/var/www/openmediavault/date.php
- mysql --user=$user --password=$pass $base << EOF >>/var/www/openmediavault/date.php
- select FROM_UNIXTIME(max(timestamp)) as '._.-DATE/HEURE-._.',user as "._.-Utilisateur-._."
- from oc_activity
- group by user
- order by "._.DATE/HEURE-._.";
- exit
- EOF
- echo "
- </pre>
- </body>
- </html>">>/var/www/openmediavault/date.php
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement