# 🚀 cPanel Setup & Installation Guide (100% Web Configured)

Aapka Multi-Site Accounting Bot aur Admin Dashboard poore Advanced Features ke saath ready hai!

---

## ⚡ AB BOT SETUP AUR AASAAN HO GAYA:

Aapko `config.php` me **SIRF Database credentials** daalna hai!  
**Bot Token, Passwords, Admin User ID, Google Apps Script URL, aur Group Mappings** sab kuch direct **Web Admin Dashboard** UI se setup ho jayega!

---

## 📋 STEP 1: cPanel File Upload

1. Apne cPanel me login karein aur **File Manager** kholein.
2. `public_html` ke andar ek naya folder banayein, e.g. `hisab`.
3. `e:\all exel hisab bot` folder ki saari files ko Zip karke upload karein aur extract kar dein.

---

## 🗄️ STEP 2: Database Setup (phpMyAdmin)

1. cPanel me **MySQL Databases** par jayein aur naya Database banayein (e.g. `user_hisabdb`).
2. cPanel me **phpMyAdmin** open karein, apne database par click karein aur **`schema.sql`** file ko Import kar dein.

---

## ⚙️ STEP 3: Config.php Edit (SIRF Database Details)

`config.php` file ko edit karke SIRF apne database details daalein:

```php
define('DB_HOST', 'localhost');
define('DB_USER', 'your_cpanel_db_username');
define('DB_PASS', 'your_cpanel_db_password');
define('DB_NAME', 'your_cpanel_db_name');
```

---

## 🖥️ STEP 4: Web Dashboard Se Complete Bot & Settings Setup

1. Browser me open karein:  
   👉 **`https://yourdomain.com/hisab/dashboard.php`** (Default Password: `admin123`).
2. Upar **`⚙️ Bot & System Settings`** button par click karein.
3. Wahan par daalein:
   - **Telegram Bot Token** (@BotFather se milne wala)
   - **Admin Telegram User ID** (Daily Report CSV & Database Backup `.sql` file lene ke liye)
   - **Google Apps Script URL** (Google Sheet sync ke liye)
   - **Super Admin & Staff Passwords** (apni pasand ka pass set karein)
   - **Save Settings to Database** button dabayein!
4. Clear button **`1-Click Connect Telegram Webhook`** dabayein taaki Bot Webhook instant connect ho jaye!
5. **Add / Map New Group to Site** me apne Telegram Group IDs (e.g. `-100123456789`) ko Site Name (e.g. `Site Alpha`) se link karein.

---

## ⏱️ STEP 5: Automated Daily Backup & Report Cron Job (cPanel)

cPanel me **Cron Jobs** section me jayein aur yeh command add karein (Run Once Daily at 23:59 PM):

```bash
php /home/yourcpaneluser/public_html/hisab/cron_jobs.php >/dev/null 2>&1
```

Isse har raat 11:59 PM par Bot automatic Telegram Admin ko Daily Report CSV aur MySQL Database Backup `.sql` file bhej dega!

---

## 🎯 TELEGRAM BOT COMMANDS:

- 🎛️ **`/admin`** ➔ Private chat me Interactive Admin Panel menu kholein (Download Backup / View Live Stats)!
- 🟢 **Auto Deposit Approval:** Admin Telegram me jaise hi `manager_AI` ka request approve karega, Bot silently Database aur Google Sheet me entry add kar dega.
- 📢 **`/ads 3000 FB Ads`** ➔ Ad spend log karein.
- 💵 **`/fund 10000 Cash`** ➔ Manual deposit log karein.
- 📊 **`/today`** ➔ Us site ka today's stats dekhne ke liye.
- 📍 **`/groupid`** ➔ Group ID nikalein.