#!/bin/bash
PORT=$1
mysql -h127.0.0.1 -P$PORT bitrix -e "UPDATE b_user SET ACTIVE = 'Y' WHERE EMAIL IN ('arsenvz@gmail.com','seregin.w@gmail.com','andrew.gasanoff@gmail.com','support@1c-bitrix.ru','info@sibirix.ru','arsenvz@gmail.com','arsenvz@gmail.com','seregin.w@gmail.com','a.nikitin@maximaster.ru','dz@santehnika-online.ru','rg@santehnika-online.ru','mike22@bk.ru','admin@itechjet.ru','oborin.v@santehnika-online.ru','kokshin.a@santehnika-online.ru','selivanov.v@santehnika-online.ru','testtestperetest@gmail.com','irina.mukhina@santehnika-online.ru','php-job@mail.ru','info@itechjet.ru','nik2.grom@mail.ru','revos16@yandex.ru','basyrov.e@santehnika-online.ru','gabdullin.v@santehnika-online.ru','egorushkin.s@santehnika-online.ru','itsumma@sant-on.ru','mashnickayatamara@sant-on.ru','kudimov.d@gmail.com','mruban@santehnika-online.ru');"
mysql -h127.0.0.1 -P$PORT bitrix -e "INSERT IGNORE INTO b_user_group (USER_ID, GROUP_ID) SELECT u.ID as USER_ID, 1 as GROUP_ID FROM b_user_group ug INNER JOIN b_user u on u.ID = ug.USER_ID AND u.ACTIVE = 'Y' WHERE ug.GROUP_ID = 26;"
mysql -h127.0.0.1 -P$PORT -e "delete from bitrix.b_module_to_module where TO_MODULE_ID = 'bitrixcloud' and MESSAGE_ID = 'OnEndBufferContent';"
mysql -h127.0.0.1 -P$PORT -e "grant all on bitrix.* to demo@192.168.100.137 identified by '8S3swOUlahT78fuZvf1q';grant all on bitrix.* to demo@192.168.100.147 identified by '8S3swOUlahT78fuZvf1q';grant all on bitrix.* to demo@192.168.100.201 identified by '8S3swOUlahT78fuZvf1q';SELECT SLEEP(1);grant all on bitrix.* to demo@localhost identified by '8S3swOUlahT78fuZvf1q';SELECT SLEEP(1);grant all on bitrix.* to demo@141.101.226.254 identified by '8S3swOUlahT78fuZvf1q';SELECT SLEEP(1);grant all on bitrix.* to bitrix@178.63.120.129 identified by 'XSdDxd6sBr3piCwD97v1';"
mysql -h127.0.0.1 -P$PORT -e "grant all on bitrix.* to bitrix@192.168.100.137 identified by 'gZfnBDPejpz,z0CM';grant all on bitrix.* to bitrix@192.168.100.143 identified by 'gZfnBDPejpz,z0CM';grant all on bitrix.* to bitrix@192.168.100.157 identified by 'gZfnBDPejpz,z0CM';grant all on bitrix.* to bitrix@192.168.100.174 identified by 'gZfnBDPejpz,z0CM';grant all on bitrix.* to bitrix@192.168.100.159 identified by 'gZfnBDPejpz,z0CM';grant all on bitrix.* to bitrix@'192.168.100.%' identified by 'gZfnBDPejpz,z0CM';"