SQL Manager

algebre · 25 April 2007, 18:06:16

hi
if you like integrate a small sql manager (like phpmyadmin) into your pragmamx
you need download this soft ESKUEL

create a folder named ex eskuel into (modules/) , unzip all files into this folder
open index.php, replace all content by:

Code Auswählen

<?php

if (!defined("mxMainFileLoaded")) die ("You can't access this file directly...");
$module_name = basename(dirname(__FILE__));
$index = 0; // right side off
include("header.php");
opentable();
?>
<body> 
<iframe id="nom_Frame" src="http://your-domaine/modules/eskuel/main.php" marginwidth="0" marginheight="0" frameborder="0" scrolling="no"></iframe> 
</body> 
<?php
    closetable();
    include("footer.php");
?>

now open main php and put this code before <?php

Code Auswählen

<head> 
<script language="JavaScript" type="text/JavaScript"> 

function redim(){ 
	//as=document.getElementById("mon_tableau").offsetHeight; 
	parent.document.getElementById("nom_Frame").height="10000"; 
	as=document.getElementById("mon_tableau").offsetWidth; 
	parent.document.getElementById("nom_Frame").width="100%";
	 } 
 
	</script> 
	</head> 
	<body onLoad="redim()"> 
	<table id="mon_tableau" width="100%" border="0"> 
	<tr> 
    <td>

open config.php
replace content by:

Code Auswählen

<?php
if (!defined("mxMainFileLoaded")) include ('../../config.php' );
### eskuel's configuration file
### Configuration number 0
$confDB['0']['name'] = 'pragmaMx';
$confDB['0']['host'] = $dbhost;
$confDB['0']['user'] = $dbuname;
$confDB['0']['password'] = $dbpass;
$confDB['0']['db'] = $dbname;
$confDB['0']['tpl'] = '';// theme ex professionnel or Soft (look in tpl folder


$conf['defaultPerRequest'] = '30';
$conf['defaultConf'] = '0';
$conf['defaultTxt'] = 'francais.inc.php'; //chose default language german=deutsch.inc.php
$conf['tipsOfTheDay'] = '0';
$conf['siteUrl'] = 'your-site-url';// dont forget
$conf['showMysqlState'] = '1';
$conf['showMysqlVars'] = '1';
$conf['showMysqlProcess'] = '1';
$conf['reduceBlob'] = '50';
?>

NB: there are two problems 1 the page is very height and there is an error when you change language

Andi · 25 April 2007, 23:23:15

nice idea, but where is the advantage?
I am not inspired to integrate such system-critical applications into the system.

Don't forget security....
http://yourhomepage.net/modules/eskuel/main.php?db=nf_506545_mx

Everybody can work in your database....

ps:
I have the same doubts with the ftp or filemanager integration...

algebre · 25 April 2007, 23:53:19

Hallo
Thank you Andi
for the advantage? (I don't know but I like easiness)

Sorry, but where you have find this name (nf_506545_mx) ?

I made changes so that the name of the module is concealed,

Code Auswählen

< ?php echo (MX_BASE_URL ". / modules/$module_name/main.php ");? >

for the security I think that information of the data base are in file config of pragma (normally it is protected 644)

the new index.php

Code Auswählen

<?php

if (!defined("mxMainFileLoaded")) die ("You can't access this file directly...");
$module_name = basename(dirname(__FILE__));
global $module_name;
$index = 0; // right side off
include("header.php");
opentable();
?>
<iframe height="460" name="manage_database" scrolling="yes" border="0" frameborder="0" marginwidth="0" marginheight="0" width="100%" src="<?php echo (MX_BASE_URL ."/modules/$module_name/main.php");?>"></iframe>
<?php
    closetable();
    include("footer.php");
?>

the main.php is a default (no changes)

algebre · 26 April 2007, 00:11:18

very sorry

you are right, I made a serious error And it is a good lesson for me,

henceforth I would pay more attention

Danke

I will seek another solution surer

algebre · 05 Juli 2007, 15:18:15

hallo
new version without iframe
download link

SQL Manager

algebre

Andi

algebre

algebre

algebre