Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- liste() {
- if [ $1 -eq 1 ]
- then
- chaine=$2;
- elif [ $1 -eq 3 ]
- then
- chaine=$2"-"$3
- elif [ $1 -eq 4 ]
- then
- chaine=$2"-"$3$4
- elif [ $1 -eq 5 ]
- then
- chaine=$2"-"$3"."$4
- fi
- echo 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