| 156,21 → 156,10 |
|---|
| echo "</body>" >> $TMP_HTML |
| echo "</HTML>" >> $TMP_HTML |
| |
| #inform users about that by setting the fourth bit of Filter-Id at 1. |
| QUERY="SELECT username from radreply INTO OUTFILE '$TMP_USERS' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';" |
| # 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;" |
| mysql -u root -p"$DB_ROOT_PW" -D radius -e "$QUERY" |
| |
| if [ -e $TMP_USERS ] && [ $(cat $TMP_USERS | wc -l) -gt 0 ] |
| then |
| for user in $(cat $TMP_USERS) |
| do |
| QUERY="set @CurrentFilter=(SELECT value from radreply where username='$user');set @CurrentFilterLeft=(SELECT LEFT(@CurrentFilter,3));set @CurrentFilterRight=(SELECT RIGHT(@CurrentFilter,4));UPDATE radreply SET value = CONCAT((@CurrentFilterLeft),'1', (@CurrentFilterRight)) WHERE username='$user' ;" |
| mysql -u root -p"$DB_ROOT_PW" -D radius -e "$QUERY" |
| done |
| fi |
| rm $TMP_USERS |
| |
| |
| /usr/bin/wkhtmltopdf $TMP_HTML $TMP_PDF |
| |
| |