Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function liste {
- if [[ $1 == 1 ]]
- then
- chaine=$2;
- elif [[ $1 == 3 ]]
- then
- chaine=$2"-"$3
- elif [[ $1 == 4 ]]
- then
- chaine=$2"-"$3$4
- elif [[ $1 == 5 ]]
- then
- chaine=$2"-"$3"."$4
- fi
- mysql -D kettu-core -e "
- SELECT contact_email
- FROM users
- INNER JOIN memberships ON memberships.connectable_id = users.id
- INNER JOIN rents ON rents.connectable_id = users.id
- INNER JOIN rooms ON rents.room_id = rooms.id
- WHERE (
- memberships.end > NOW( )
- OR memberships.end =0000 -00 -00
- )
- AND (
- rents.end > NOW( )
- OR rents.end IS NULL
- )
- AND LEFT( rooms.name, $i ) = '$chaine';" --skip-column-names --skip-line-numbers --user=mail --password=X7DhNLb --silent
- }
- liste 3 1 A
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement