hi
if you like integrate a small sql manager (like phpmyadmin) into your pragmamx
you need download this soft ESKUEL (http://www.phptools4u.com/generated_content/download/eskuel.zip)
create a folder named ex eskuel into (modules/) , unzip all files into this folder
open index.php, replace all content by:
<?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
<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:
<?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
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.... :gruebel:
ps:
I have the same doubts with the ftp or filemanager integration...
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,
< ?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
<?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)
very sorry :red: you are right, I made a serious error And it is a good lesson for me,
henceforth I would pay more attention :crash:
Danke ;)
I will seek another solution surer :gruebel:
hallo
new version without iframe
download link (http://demo-pragmamx.22web.net/modules.php?name=Downloads&cid=1)