Gecko [ aodai.devttt.com ]

Name	Size	Permission
AutoLogin.html	1.86 KB	-rw-r--r--
OptimizeMySQL.html	17.81 KB	-rw-r--r--
Updatemysql.html	4.42 KB	-rw-r--r--
createDatabase.html	17.1 KB	-rw-r--r--
deleteDatabase.html	17.25 KB	-rw-r--r--
index.html	5.39 KB	-rw-r--r--
listDataBases.html	22.99 KB	-rw-r--r--
mysqlmanager.html	20.09 KB	-rw-r--r--
phpMyAdmin.html	3.71 KB	-rw-r--r--

Code Editor : mysqlmanager.html

{% extends "baseTemplate/index.html" %}
{% load i18n %}
{% block title %}{% trans "MySQL Manager - CyberPanel" %}{% endblock %}
{% block content %}

{% load static %}
{% get_current_language as LANGUAGE_CODE %}

.processes-table td {
        padding: 1rem;
        color: var(--text-secondary);
        font-size: 1rem;
        border-bottom: 1px solid var(--border-light);
    }
    
    .processes-table tbody tr {
        transition: all 0.2s ease;
    }
    
    .processes-table tbody tr:hover {
        background: var(--bg-hover);
    }
    
    .processes-table tbody tr:last-child td {
        border-bottom: none;
    }
    
    .process-id {
        font-weight: 600;
        color: var(--accent-color);
        font-family: monospace;
    }
    
    .process-user {
        display: flex;
        align-items: center;
        gap: 0.5rem;
    }
    
    .user-icon {
        width: 24px;
        height: 24px;
        background: var(--accent-light);
        border-radius: 50%;
        display: flex;
        align-items: center;
        justify-content: center;
        font-size: 0.875rem;
        color: var(--accent-color);
    }
    
    .command-badge {
        background: var(--border-light);
        color: var(--text-primary);
        padding: 0.25rem 0.75rem;
        border-radius: 6px;
        font-size: 0.875rem;
        font-weight: 500;
        font-family: monospace;
    }
    
    .time-badge {
        background: var(--warning-bg);
        color: var(--warning-text);
        padding: 0.25rem 0.75rem;
        border-radius: 6px;
        font-size: 0.875rem;
        font-weight: 500;
    }
    
    .state-badge {
        padding: 0.25rem 0.75rem;
        border-radius: 6px;
        font-size: 0.875rem;
        font-weight: 500;
    }
    
    .state-active {
        background: var(--success-bg);
        color: var(--success-text);
    }
    
    .state-idle {
        background: var(--accent-light);
        color: var(--accent-color);
    }
    
    .info-text {
        max-width: 300px;
        overflow: hidden;
        text-overflow: ellipsis;
        white-space: nowrap;
        font-family: monospace;
        font-size: 1rem;
    }
    
    .progress-bar {
        width: 100px;
        height: 6px;
        background: var(--border-color);
        border-radius: 3px;
        overflow: hidden;
    }
    
    .progress-fill {
        height: 100%;
        background: var(--accent-color);
        transition: width 0.3s ease;
    }
    
    .loading-spinner {
        width: 20px;
        height: 20px;
        border: 3px solid var(--border-color);
        border-top-color: var(--accent-color);
        border-radius: 50%;
        animation: spin 1s linear infinite;
        display: inline-block;
        margin-left: 1rem;
    }
    
    .refresh-btn {
        background: var(--bg-secondary);
        color: var(--text-secondary);
        border: 1px solid var(--border-color);
        padding: 0.5rem 1rem;
        border-radius: 8px;
        font-weight: 500;
        cursor: pointer;
        transition: all 0.3s ease;
        display: inline-flex;
        align-items: center;
        gap: 0.5rem;
        font-size: 1rem;
    }
    
    .refresh-btn:hover {
        color: var(--accent-color);
        border-color: var(--accent-color);
        transform: rotate(180deg);
    }
    
    .empty-state {
        text-align: center;
        padding: 4rem 2rem;
        color: var(--text-muted);
    }
    
    .empty-state i {
        font-size: 3rem;
        color: var(--icon-color);
        margin-bottom: 1rem;
    }
    
    @keyframes spin {
        to { transform: rotate(360deg); }
    }
    
    @keyframes rotate {
        from { transform: rotate(0deg); }
        to { transform: rotate(360deg); }
    }
    
    @keyframes fadeInDown {
        from {
            opacity: 0;
            transform: translateY(-20px);
        }
        to {
            opacity: 1;
            transform: translateY(0);
        }
    }
    
    @keyframes fadeInUp {
        from {
            opacity: 0;
            transform: translateY(20px);
        }
        to {
            opacity: 1;
            transform: translateY(0);
        }
    }
    
    @keyframes pulse {
        0%, 100% { opacity: 1; }
        50% { opacity: 0.5; }
    }
    
    /* Angular cloak */
    [ng\:cloak], [ng-cloak], [data-ng-cloak], [x-ng-cloak], .ng-cloak, .x-ng-cloak {
        display: none !important;
    }
    
    @media (max-width: 768px) {
        .page-title {
            font-size: 2rem;
        }
        
        .stat-value {
            font-size: 2rem;
        }
        
        .processes-table {
            font-size: 1rem;
        }
        
        .processes-table th,
        .processes-table td {
            padding: 0.5rem;
        }
        
        .info-text {
            max-width: 150px;
        }
    }
</style>

<div class="modern-container" ng-controller="Mysqlmanager" ng-init="cyberPanelLoading=false" ng-cloak>
    <div class="page-header">
        <h1 class="page-title">
            <div class="mysql-icon">
                <i class="fas fa-database" style="color: var(--accent-color); font-size: 1.75rem;"></i>
            </div>
            {% trans "MySQL Manager" %}
        </h1>
        <p class="page-subtitle">{% trans "Monitor and manage your MySQL database performance" %}</p>
        <div class="header-actions">
            <a href="{% url 'OptimizeMySQL' %}" class="btn-primary">
                <i class="fas fa-tachometer-alt"></i>
                {% trans "Optimize MySQL" %}
            </a>
            <a href="{% url 'phpMyAdmin' %}" class="btn-secondary">
                <i class="fas fa-external-link-alt"></i>
                {% trans "phpMyAdmin" %}
            </a>
        </div>
    </div>

<div class="stats-grid">
        <div class="stat-card uptime">
            <div class="stat-header">
                <h3 class="stat-title">{% trans "MySQL Uptime" %}</h3>
                <div class="stat-icon" style="color: var(--info-color);">
                    <i class="fas fa-clock"></i>
                </div>
            </div>
            <p class="stat-value">{$ uptime $}</p>
            <p class="stat-label">{% trans "Server running time" %}</p>
        </div>

<div class="stat-card connections">
            <div class="stat-header">
                <h3 class="stat-title">{% trans "Active Connections" %}</h3>
                <div class="stat-icon" style="color: var(--success-color);">
                    <i class="fas fa-link"></i>
                </div>
            </div>
            <p class="stat-value">{$ connections $}</p>
            <p class="stat-label">{% trans "Current connections" %}</p>
        </div>

<div class="stat-card slow-queries">
            <div class="stat-header">
                <h3 class="stat-title">{% trans "Slow Queries" %}</h3>
                <div class="stat-icon" style="color: var(--warning-color);">
                    <i class="fas fa-exclamation-triangle"></i>
                </div>
            </div>
            <p class="stat-value">{$ Slow_queries $}</p>
            <p class="stat-label">{% trans "Queries exceeding time limit" %}</p>
        </div>
    </div>

<div class="main-card">
        <div class="card-header">
            <h2 class="card-title">
                <i class="fas fa-list-ul"></i>
                {% trans "Active MySQL Processes" %}
                <span ng-show="cyberPanelLoading" class="loading-spinner"></span>
            </h2>
            <button class="refresh-btn" ng-click="refreshProcesses()">
                <i class="fas fa-sync-alt"></i>
            </button>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="processes-table">
                    <thead>
                        <tr>
                            <th>{% trans "ID" %}</th>
                            <th>{% trans "User" %}</th>
                            <th>{% trans "Database" %}</th>
                            <th>{% trans "Command" %}</th>
                            <th>{% trans "Time" %}</th>
                            <th>{% trans "State" %}</th>
                            <th>{% trans "Query Info" %}</th>
                            <th>{% trans "Progress" %}</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr ng-repeat="process in processes">
                            <td>
                                <span class="process-id" ng-bind="process.id"></span>
                            </td>
                            <td>
                                <div class="process-user">
                                    <div class="user-icon">
                                        <i class="fas fa-user"></i>
                                    </div>
                                    <span ng-bind="process.user"></span>
                                </div>
                            </td>
                            <td>
                                <i class="fas fa-database" style="color: var(--text-muted); margin-right: 0.5rem;"></i>
                                <span ng-bind="process.database || 'None'"></span>
                            </td>
                            <td>
                                <span class="command-badge" ng-bind="process.command"></span>
                            </td>
                            <td>
                                <span class="time-badge" ng-bind="process.time + 's'"></span>
                            </td>
                            <td>
                                <span class="state-badge" 
                                      ng-class="{'state-active': process.state === 'executing', 'state-idle': process.state !== 'executing'}"
                                      ng-bind="process.state || 'Idle'"></span>
                            </td>
                            <td>
                                <span class="info-text" 
                                      ng-bind="process.info || 'No query'"
                                      ng-attr-title="{$ process.info $}"></span>
                            </td>
                            <td>
                                <div class="progress-bar">
                                    <div class="progress-fill" 
                                         ng-style="{'width': (process.progress || 0) + '%'}"></div>
                                </div>
                            </td>
                        </tr>
                        <tr ng-if="processes.length === 0">
                            <td colspan="8" class="empty-state">
                                <i class="fas fa-check-circle"></i>
                                <p>{% trans "No active processes found" %}</p>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

{% endblock %}

${this.title}

Code Editor : mysqlmanager.html