DataLife Engine Support » DataLife Engine » Modules » SQL Manager

SQL Manager

Author: admin;
Views: 1680;
Date: 9 July 2009;

Module help you can execute SQL Query in Admin CP, don't need to go PhpMyAdmin

SQL Manager v.1.1 by Gauss (cmska.org.ua)

DOWNLOAD : sql_manager.rar

Install

1. Upload files to the server.

2. Open file language\{current langguage}\adminpanel.lng

Find :

// 8.0

BELOW add:

'group_a_sql' => "Run SQL query in Admin Panel",
'group_h_sql' => "This feature will allow users(can access to Admin Panel) execute an SQL query. We strongly recommend that you give users access only concern you have confidence, because the ability to run SQL query can damage or destroy the data of your project.",

3. Open file engine/inc/usergroup.php

find (1)

$admin_googlemap = intval( $_REQUEST['admin_googlemap'] );

BELOW add:

$admin_sql = intval( $_REQUEST['admin_sql'] );

Next find (2)

admin_rssinform,

REPLACE with:

admin_rssinform, admin_sql,

Next find (3)

'$admin_rssinform', '$admin_googlemap'

REPLACE with:

'$admin_rssinform', '$admin_googlemap', '$admin_sql'

Next find (4)

admin_googlemap='$admin_googlemap'

REPLACE with:

admin_googlemap='$admin_googlemap', admin_sql='$admin_sql'

Next find (5)

if( $user_group[$id]['admin_googlemap'] ) $admin_googlemap_yes = "checked"; else $admin_googlemap_no = "checked";

BELOW add:

if( $user_group[$id]['admin_sql'] ) $admin_sql_yes = "checked"; else $admin_sql_no = "checked";

Next find (6)

$admin_googlemap_no = "checked";

BELOW add:

$admin_sql_no = "checked";

Next find (7)

    <tr>
        <td style="padding:4px;" class="option"><b>{$lang['group_a_googlemap']}</b><br /><span class="small">{$lang['group_h_googlemap']}</span></td>
        <td style="padding-top:2px;padding-bottom:2px;"><input type="radio" name="admin_googlemap" {$admin_googlemap_yes} value="1" {$gastgroup}> {$lang['opt_sys_yes']} <input type="radio" name="admin_googlemap" {$admin_googlemap_no} value="0" {$admingroup}> {$lang['opt_sys_no']}</td>
    </tr>
    <tr><td background="engine/skins/images/mline.gif" height=1 colspan=2></td></tr>

BELOW add:

<tr>
<td style="padding:4px;" class="option"><b>{$lang['group_a_sql']}</b><br /><span class="small">{$lang['group_h_sql']}</span></td>
<td style="padding-top:2px;padding-bottom:2px;"><input type="radio" name="admin_sql" {$admin_sql_yes} value="1" {$gastgroup}> {$lang['opt_sys_yes']} <input type="radio" name="admin_sql" {$admin_sql_no} value="0" {$admingroup}> {$lang['opt_sys_no']}</td>
</tr>
<tr><td background="engine/skins/images/mline.gif" height=1 colspan=2></td></tr>

4. Execute this query in PhpMyAdmin (Thực thi câu lệnh SQL sau trong PhpMyAdmin)

ALTER TABLE `dle_usergroups` ADD `admin_sql` TINYINT( 1 ) DEFAULT '0';

5. Open file engine/inc/options.php

Find

$options['filter'] = array (

BELOW add:

(a)

array(
'name' => "SQL Manager",
'url' => "$PHP_SELF?mod=sql",
'descr' => "Module help you run SQL query in Admin CP (like phpMyAdmin)",
'image' => 'sql.png',
'access' => $user_group[$member_id['user_group']]['admin_dle']
),

If you want only group Administrator can execute this module. Add below code instead of above code (Nếu bạn muốn chỉ Nhóm Admin có thể thực hiện module này thì chèn đoạn sau đây thay vì đoạn trên)

(b)

array(
'name' => "SQL Manager",
'url' => "$PHP_SELF?mod=sql",
'descr' => "Module help you run SQL query in Admin CP (like phpMyAdmin)",
'image' => 'sql.png',
'access' => "admin"
),

6. Open file admin.php

Find

'help',

BELOW add:

'sql',

7. Nếu ở bước 5 bạn thêm đoạn (a) thì bạn có thể thiết lập quyền truy cập cho các nhóm thành viên

PAGE 2 IS INSTALL FOR DLE 8.2 and 8.3

We encourage you to Register or Login to website under your name.