#!/bin/bash
# 一鍵安裝 osCommerce + XOOPS 環境
# 適用於 Ubuntu Server (20.04/22.04)

# 更新系統
sudo apt update && sudo apt upgrade -y

# 安裝 Apache、MySQL、PHP
sudo apt install -y apache2 mysql-server php php-mysql php-xml php-gd php-mbstring unzip wget

# 啟動服務
sudo systemctl enable apache2
sudo systemctl enable mysql
sudo systemctl start apache2
sudo systemctl start mysql

# 建立資料庫與使用者
mysql -u root <<EOF
CREATE DATABASE oscdb;
CREATE DATABASE xoopsdb;
CREATE USER 'oscuser'@'localhost' IDENTIFIED BY 'oscpass';
CREATE USER 'xoopsuser'@'localhost' IDENTIFIED BY 'xoopspass';
GRANT ALL PRIVILEGES ON oscdb.* TO 'oscuser'@'localhost';
GRANT ALL PRIVILEGES ON xoopsdb.* TO 'xoopsuser'@'localhost';
FLUSH PRIVILEGES;
EOF

# 下載 osCommerce 與 XOOPS
cd /var/www/html
sudo wget https://github.com/osCommerce/oscommerce/archive/refs/heads/master.zip -O osc.zip
sudo wget https://github.com/XOOPS/XoopsCore/archive/refs/heads/master.zip -O xoops.zip

# 解壓縮
sudo unzip osc.zip -d osc
sudo unzip xoops.zip -d xoops

# 設定權限
sudo chown -R www-data:www-data /var/www/html/osc
sudo chown -R www-data:www-data /var/www/html/xoops
sudo chmod -R 755 /var/www/html/osc
sudo chmod -R 755 /var/www/html/xoops

# 建立 Apache 虛擬主機設定
cat <<EOF | sudo tee /etc/apache2/sites-available/osc.conf
<VirtualHost *:80>
ServerName osc.local
DocumentRoot /var/www/html/osc/oscommerce-master
<Directory /var/www/html/osc/oscommerce-master>
AllowOverride All
Require all granted
</Directory>
</VirtualHost>
EOF

cat <<EOF | sudo tee /etc/apache2/sites-available/xoops.conf
<VirtualHost *:80>
ServerName xoops.local
DocumentRoot /var/www/html/xoops/XoopsCore-master
<Directory /var/www/html/xoops/XoopsCore-master>
AllowOverride All
Require all granted
</Directory>
</VirtualHost>
EOF

# 啟用站點並重啟 Apache
sudo a2ensite osc.conf
sudo a2ensite xoops.conf
sudo systemctl reload apache2

echo "✅ 安裝完成！請在 /etc/hosts 加入以下設定："
echo "127.0.0.1 osc.local"
echo "127.0.0.1 xoops.local"
echo "然後在瀏覽器輸入 http://osc.local 或 http://xoops.local 進行安裝。"