#!/bin/sh

# reset_ombu_password: Reset the password of the (first) admin user.
#
# Upon next login, you'll need to set the password for that user.

parse_conf() {
	cd /usr/share/ombutel/www
	php -r '
		require_once("config.php");
		$vars = ["name", "username", "password", "prefix"];
		foreach($vars as $var_base) {
			$var = "database_${var_base}";
			echo "${var_base}: " . constant("config::$var") . "\n";
		}
	'
}

config=`parse_conf`
name=`         echo "$config" | awk '/^name:/ {print $2}'`
username=`     echo "$config" | awk '/^username:/ {print $2}'`
password=`     echo "$config" | awk '/^password:/ {print $2}'`
prefix=`       echo "$config" | awk '/^prefix:/ {print $2}'`

settings_table="${prefix}settings"
users_table="${prefix}users"

mysql -u$username -p$password -e"update ${name}.${settings_table} set value = 'yes' where name = 'reset_pwd';"
mysql -u$username -p$password -e"update ${name}.${users_table} set require_reset_pass = 'no' where user_id = 1;"
