1. Home Page
1.1. Order
1.1.1. Packages
1.2. Contact
1.2.1. Contact Form
1.3. Forums
1.4. About
1.5. Login
2. Customer Panel
2.1. Update Payment Information
2.1.1. Add/Remove Payment Methods/Subscriptions
2.2. View Invoices
2.3. View Server Activity
2.3.1. Graph showing different time lengths and amount of users online
2.4. Manage Servers
2.4.1. Start | Stop | Reset to default | Change Welcome Message | Manage ACL'S & Channels | Read Log File
2.4.2. User Management
2.4.3. Channel Viewer
2.5. Ticketed Requests
2.5.1. Upgrade Request
2.5.2. Billing Cycle Modification
2.5.3. Downgrade Request
2.5.4. Cancellation Request
2.5.5. Support Tickets
2.5.5.1. Submit/View/Respond
2.5.6. Billing Tickets
2.5.6.1. Submit/View/Respond
3. Partial Ideas
3.1. Reseller
3.2. Server Monitoring
3.2.1. Load / CPU / Connections Ticker
3.3. Make panel portable and license for use
3.4. Ability to incorporate additional voice server types
3.4.1. Such as Ventrilo
3.5. Referral Benefits
3.5.1. Free Month
3.5.2. % Base amount off of month subscription based on how many referrals
4. Database Structure
4.1. packages
4.1.1. id
4.1.1.1. auto-increment(int(10))
4.1.2. package_name
4.1.2.1. varchar(20)
4.1.2.1.1. Name of the package
4.1.3. slots
4.1.3.1. int(1)
4.1.3.1.1. Amount of User Slots
4.1.4. active
4.1.4.1. int(1)
4.1.4.1.1. 0 - Inactive
4.1.4.1.2. 1 - Active
4.1.5. position
4.1.5.1. int(1)
4.1.5.1.1. Ordered By this number
4.1.6. base_amount
4.1.6.1. varchar(10)
4.1.6.1.1. Base Slot Price
4.1.7. extended_discount
4.1.7.1. int(2)
4.1.7.1.1. % Discount for Multiple Months
4.2. Ticket System
4.3. Customer Panel
4.3.1. signup
4.3.1.1. id
4.3.1.1.1. int(10)
4.3.1.2. email
4.3.1.2.1. varchar(50)
4.3.1.3. name
4.3.1.3.1. varchar(50)
4.3.1.4. username
4.3.1.4.1. varchar(10)
4.3.1.5. ip
4.3.1.5.1. varchar(15)
4.3.1.6. date
4.3.1.6.1. TIMESTAMP
4.3.1.7. referring_url
4.3.1.7.1. varchar(200)
4.3.2. customer_billing
4.3.2.1. id
4.3.2.1.1. auto-increment(int(10))
4.3.2.2. customer_id
4.3.2.2.1. (Maintain from signup)
4.3.2.3. name
4.3.2.3.1. Defaulted from Signup (Changeable in Panel)
4.3.2.4. address
4.3.2.4.1. varchar(75)
4.3.2.5. city
4.3.2.5.1. varchar(75)
4.3.2.6. zip
4.3.2.6.1. int(10)
4.3.2.7. country
4.3.2.7.1. varchar(50)
4.3.3. customer_packages
4.3.3.1. id
4.3.3.1.1. auto-increment(int(10))
4.3.3.2. active
4.3.3.2.1. int(1)
4.3.3.3. customer_id
4.3.3.3.1. (Maintained from Login)
4.3.3.4. package_id
4.3.3.4.1. (Maintaned from Packages)
4.3.4. customer_login
4.3.4.1. id
4.3.4.1.1. int(10)
4.3.4.2. email
4.3.4.2.1. varchar(50)
4.3.4.3. username
4.3.4.3.1. varchar(10)
4.3.4.4. password
4.3.4.4.1. md5(varchar(16))
4.3.4.5. date_created
4.3.4.5.1. DATE
4.3.4.6. last_login
4.3.4.6.1. TIMESTAMP
4.3.5. customer_transaction
4.3.5.1. id
4.3.5.1.1. autoincrement(int(15))
4.3.5.2. customer_id
4.3.5.2.1. (Maintained from Signup)
4.3.5.3. transaction_id
4.3.5.3.1. varchar(75)
4.3.5.4. amount
4.3.5.4.1. varchar(5)
4.3.5.5. type
4.3.5.5.1. int(1)
5. Back End
5.1. Billing
5.1.1. Manage Packages
5.1.1.1. Add New Package Type
5.1.1.2. Add Promotional Pricing
5.1.1.3. Modify Current Package Types
5.1.1.4. Enable Discounts
5.1.2. Account Status Modification
5.1.2.1. Pending
5.1.2.1.1. After successful charge - Account is created but must still be reviewed.
5.1.2.2. Active
5.1.2.2.1. Fully Activated
5.1.2.2.2. Invoices Generated 5 Days before due date - Email Sent
5.1.2.2.3. 5 Day Grace Period after Invoice Due Date before suspension
5.1.2.3. Suspended
5.1.2.3.1. Non-Pay
5.1.2.3.2. Abuse
5.1.2.4. Cancelled
5.1.2.4.1. Requested Cancellation
5.1.2.4.2. Fraudulent Account
5.1.3. Modify Customer's Packages
5.1.3.1. Add Server Instance
5.1.3.2. Cancel Server Instance
5.1.3.3. Modify Server Instance
5.1.3.4. Add Credit
5.1.3.5. Add Discount
5.1.3.6. Create Invoice
5.1.3.7. Delete Invoice
5.1.4. View Financial Reports
5.1.4.1. $ Per Server
5.1.4.1.1. Per User
5.1.4.1.2. Per Instance
5.1.4.2. Orders Made
5.1.4.2.1. Per Day
5.1.4.2.2. Per Month
5.1.4.2.3. Per Year
5.1.4.2.4. Promotional Codes Used
5.1.4.3. Unpaid Invoices
5.1.4.4. Active Accounts
5.1.4.5. Total Number of Active User Slots
5.1.4.6. Suspended for Non Payment
5.2. Ticket System
5.2.1. Departments
5.2.1.1. Support
5.2.1.1.1. User Contact (From Customer Panel)
5.2.1.1.2. Non-User Contact Form
5.2.1.1.3. Feed Back
5.2.1.1.4. Support @
5.2.1.2. Billing
5.2.1.2.1. Upgrade
5.2.1.2.2. Downgrade
5.2.1.2.3. Change Billing Cycle
5.2.1.2.4. Invoice Replies
5.2.1.2.5. Invoice Extensions
5.2.1.2.6. Fraud
5.2.1.2.7. General Inquiry
5.2.1.3. Cancellations
5.2.1.3.1. Request to Cancel
5.2.1.4. Spam
5.2.1.4.1. All the junk
5.3. Access Control List
5.3.1. Multiple Levels of Access for Accessing the Backend
5.4. Server Management
5.4.1. View Servers
5.4.1.1. Manage Instances
5.4.1.1.1. Add Instances
5.4.1.1.2. Remove Instances
5.4.1.1.3. Copy Instances
5.4.1.1.4. Start Instances
5.4.1.1.5. Stop Instances
5.4.1.1.6. Reset Instances
5.4.1.2. Add Servers
5.4.1.2.1. Automated Installation
5.4.1.3. Remove Servers
5.4.1.4. Bandwidth
5.4.1.4.1. Per User
5.4.1.4.2. Per Server
5.4.1.4.3. Per Day
5.4.1.4.4. Per Week
5.4.1.4.5. Per Month