Go to the documentation of this file.
27 require
'../../main.inc.php';
29 $langs->load(
"admin");
35 $table =
GETPOST(
'table',
'alpha');
45 print
load_fiche_titre($langs->trans(
"Table").
" ".$table,
'',
'title_setup');
49 if (preg_match(
'/mysql/i', $conf->db->type)) {
50 $sql =
"SHOW TABLE STATUS LIKE '".$db->escape($table).
"'";
52 } elseif ($conf->db->type ==
'pgsql') {
53 $sql =
"SELECT conname,contype FROM pg_constraint";
58 print $langs->trans(
"FeatureNotAvailableWithThisDatabaseDriver");
62 $num = $db->num_rows(
$resql);
65 $row = $db->fetch_row(
$resql);
72 $cons = explode(
";", $row[14]);
74 foreach ($cons as $cc) {
75 $cx = preg_replace(
"/\)\sREFER/",
"", $cc);
76 $cx = preg_replace(
"/\(`/",
"", $cx);
77 $cx = preg_replace(
"/`\)/",
"", $cx);
78 $cx = preg_replace(
"/`\s/",
"", $cx);
80 $val = explode(
"`", $cx);
82 $link[trim($val[0])][0] = (isset($val[1]) ? $val[1] :
'');
83 $link[trim($val[0])][1] = (isset($val[2]) ? $val[2] :
'');
89 print
'<table class="noborder">';
90 print
'<tr class="liste_titre">';
91 print
'<td>'.$langs->trans(
"Fields").
'</td><td>'.$langs->trans(
"Type").
'</td><td>'.$langs->trans(
"Index").
'</td>';
96 print
'<td>'.$langs->trans(
"FieldsLinked").
'</td>';
100 $sql =
"SHOW FULL COLUMNS IN ".$db->escape($table);
102 $resql = $db->query($sql);
104 $num = $db->num_rows(
$resql);
107 $row = $db->fetch_row(
$resql);
108 print
'<tr class="oddeven">';
109 print
"<td>".$row[0].
"</td>";
110 print
"<td>".$row[1].
"</td>";
111 print
"<td>".$row[3].
"</td>";
112 print
"<td>".(empty($row[4]) ?
'' : $row[4]).
"</td>";
113 print
"<td>".(empty($row[5]) ?
'' : $row[5]).
"</td>";
114 print
"<td>".(empty($row[6]) ?
'' : $row[6]).
"</td>";
115 print
"<td>".(empty($row[7]) ?
'' : $row[7]).
"</td>";
117 print
"<td>".(isset($link[$row[0]][0]) ? $link[$row[0]][0] :
'').
".";
118 print (isset($link[$row[0]][1]) ? $link[$row[0]][1] :
'').
"</td>";
120 print
'<!-- ALTER ALTER TABLE '.$table.
' MODIFY '.$row[0].
' '.$row[1].
' COLLATE utf8_unicode_ci; -->';
load_fiche_titre($titre, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
if(isModEnabled('facture') &&!empty($user->rights->facture->lire)) if((isModEnabled('fournisseur') &&empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) && $user->rights->fournisseur->facture->lire)||(isModEnabled('supplier_invoice') && $user->rights->supplier_invoice->lire)) if(isModEnabled('don') &&!empty($user->rights->don->lire)) if(isModEnabled('tax') &&!empty($user->rights->tax->charges->lire)) if(isModEnabled('facture') &&isModEnabled('commande') && $user->rights->commande->lire &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) $resql
Social contributions to pay.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program Calling this function terminate execution ...
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOCSRFCHECK')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.