157,7 → 157,7 |
echo "</HTML>" >> $TMP_HTML |
|
# inform users about that by setting the Alcasar-Imputability-Warning attribute |
QUERY="INSERT INTO radreply (username, attribute, value, op) SELECT ui.username, 'Alcasar-Imputability-Warning', '1' , ':=' FROM userinfo ui LEFT JOIN radreply rr ON rr.username = ui.username AND rr.attribute = 'Alcasar-Imputability-Warning' WHERE rr.username IS NULL;" |
QUERY="INSERT INTO radreply (username, attribute, value, op) SELECT ui.username, 'Alcasar-Imputability-Warning', '1' , '=' FROM userinfo ui LEFT JOIN radreply rr ON rr.username = ui.username AND rr.attribute = 'Alcasar-Imputability-Warning' WHERE rr.username IS NULL;" |
mysql -u root -p"$DB_ROOT_PW" -D radius -e "$QUERY" |
|
/usr/bin/wkhtmltopdf $TMP_HTML $TMP_PDF |