1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244
|
<?php
$table=@$_GET['table'];
$client=@$_GET['client'];
$requete=@$_GET['requete'];
$tableBDD=@$_GET['tableBDD'];
$table=@$_GET['table'];
$client=@$_GET['client'];
function affchamps($nom, $table, $requete)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
$liste_champs='<b><u>'.$nom.'</u></b><br>';
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
if ($requete<>'' and $requete<>'0'){$result = mysql_query("ALTER TABLE `".$suff_table.$requete);}
$query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = '".$suff_table.$table."'";
//$query = "SHOW ".$suff_table.$table." FROM ".$dbname;
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$liste_champs.= $row['COLUMN_NAME']."<br>";
//$liste_champs.= $row[0]."<br>";
}
return $liste_champs;
mysql_close($link);
}
if ($client<>""){
echo '
<table>
<tr>
<td width="50%" valign="top" align="left">';$z=affchamps("CL_0",$table,$requete);echo $z.'</td>
<td width="50%" valign="top" align="left">';$z=affchamps($client,$table,$requete);echo $z.'</td>
</tr>
</table><br><br><br>';
}
else
{
function info($nom)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
//ect..... 200 CL
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
$info='<span style="float:right;"><i>';
$result = mysql_query("SELECT * FROM `".$suff_table."table_0` where supp='0'");$info.='D: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `".$suff_table."table_1` where supp='0'");$info.='F: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `".$suff_table."table_2`"); $info.='M: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `pws_sms`");$info.='S: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `extra_chat`");$info.='T: '.mysql_num_rows($result).'<br>';
$result = mysql_query("SELECT * FROM `".$suff_table."table_3` where a_acc='1'");$info.='U: '.mysql_num_rows($result).'<br>';
$resdate = mysql_query("SELECT date FROM `".$suff_table."table_4` ORDER BY `idJ` DESC limit 1");while($rowdt = mysql_fetch_array($resdate)){$info.='X: '.date ("d/m H:i", $rowdt['date']);}
$info.='</i></span>';
return $info;
mysql_close($link);
}
function affres($nom, $table, $requete)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
//ect..... 200 CL
$numcham="0";
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
if ($table=='chat'){$suff_table="extra_";}
if ($table=='sms'){$suff_table="pws_";}
if ($requete<>'' and $requete<>'0'){$result = mysql_query("ALTER TABLE `".$suff_table.$requete);}
$result = mysql_query("SELECT * FROM `".$suff_table.$table."`");
$numcham = mysql_num_fields($result);
if ($nom=="iobnet"){$_SESSION['verifnumcham']=$numcham;}
if ($numcham==$_SESSION['verifnumcham']){$color="green";}else{$color="red; font-weight:bold";}
$num_cham='<a href="?table='.$table.'&client='.$nom.'" style="color:'.$color.'">'.$numcham.'</a>';
return $num_cham;
mysql_close($link);
}
function affemail($nom, $table)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
//ect..... 200 CL
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
$result = mysql_query("SELECT mail_direction FROM `".$suff_table.$table."`");
while($row = mysql_fetch_array($result)){$res.= $row['mail_direction'].'; ';}
return $res;
mysql_close($link);
}
function listinfo()
{
$recol='<td style="text-align:left">';$recol.=info("CL_0");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_1");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_2");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_3");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_4");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_5");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_6");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_7");$recol.='</td>
<td style="text-align:left">';$recol.=info("CL_8");$recol.='</td>
';
return $recol;
}
function affrecol($table, $requete)
{
$recol='<td>';$recol.=affres("CL_0",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_1",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_2",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_3",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_4",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_5",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_6",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_7",$table, $requete);$recol.='</td>
<td>';$recol.=affres("CL_8",$table, $requete);$recol.='</td>
';
return $recol;
}
function liste_email($table)
{
$remail="";
$remail.=affemail("CL_1",$table);
$remail.=affemail("CL_2",$table);
$remail.=affemail("CL_3",$table);
$remail.=affemail("CL_4",$table);
$remail.=affemail("CL_5",$table);
$remail.=affemail("CL_6",$table);
$remail.=affemail("CL_7",$table);
$remail.=affemail("CL_8",$table);
return $remail;
}
function affbq($nom, $table)
{
if ($nom=='CL_0'){ $host="BDD_0.mysql.db"; $dbname="BDD_0"; $loginbdd="BDD_0"; $passbdd="MDP_0"; $suff_table="extratest_";}
if ($nom=='CL_1'){ $host="BDD_1.mysql.db"; $dbname="BDD_1"; $loginbdd="BDD_1"; $passbdd="MDP_1"; $suff_table="extratest_";}
if ($nom=='CL_2'){ $host="BDD_2.mysql.db"; $dbname="BDD_2"; $loginbdd="BDD_2"; $passbdd="MDP_2"; $suff_table="extra_";}
if ($nom=='CL_3'){ $host="BDD_3.mysql.db"; $dbname="BDD_3"; $loginbdd="BDD_3"; $passbdd="MDP_3"; $suff_table="ext_";}
if ($nom=='CL_4'){ $host="BDD_4.mysql.db"; $dbname="BDD_4"; $loginbdd="BDD_4"; $passbdd="MDP_4"; $suff_table="extra_";}
if ($nom=='CL_5'){ $host="BDD_5.mysql.db"; $dbname="BDD_5"; $loginbdd="BDD_5"; $passbdd="MDP_5"; $suff_table="extratest_";}
if ($nom=='CL_6'){ $host="BDD_6.mysql.db"; $dbname="BDD_6"; $loginbdd="BDD_6"; $passbdd="MDP_6"; $suff_table="extratest_";}
if ($nom=='CL_7'){ $host="BDD_7.mysql.db"; $dbname="BDD_7"; $loginbdd="BDD_7"; $passbdd="MDP_7"; $suff_table="ext_";}
if ($nom=='CL_8'){ $host="BDD_8.mysql.db"; $dbname="BDD_8"; $loginbdd="BDD_8"; $passbdd="MDP_8"; $suff_table="extra_";}
//ect..... 200 CL
$res="";
$link = mysql_connect($host,$loginbdd,$passbdd);mysql_select_db($dbname);
$result = mysql_query("SELECT idBQ, nom_BQ FROM `".$suff_table.$table."` order by idBQ asc");
while($row = mysql_fetch_array($result)){$res.= $row['idBQ']." - ".$row['nom_BQ'].'<br>';}
return $res;
mysql_close($link);
}
echo '
<style>
td {text-align:center;}
th {text-align:center; font-weight:bold}
</style>
EMAILS : '.$r=liste_email('config');echo '<br>
<table width="100%" border="1">
<thead>
<tr>
<th></th>
<th>CL_0</th>
<th>CL_1</th>
<th>CL_2</th>
<th>CL_3</th>
<th>CL_4</th>
<th>CL_5</th>
<th>CL_6</th>
<th>CL_7</th>
<th>CL_8</th>
</tr>
</thead>
<tbody>
<tr><td><b>INFOS</b></td>'.$r=listinfo();echo '</tr>';
if ($tableBDD<>''){
echo '<tr><td>'.$tableBDD.'</td>'.$r=affrecol($tableBDD, $requete);echo '</tr>';
}
else
{
echo '
<tr><td>Table_1</td>'.$r=affrecol("table_1", $requete);echo '</tr>
<tr><td>Table_2</td>'.$r=affrecol("table_2", $requete);echo '</tr>
<tr><td>Table_3</td>'.$r=affrecol("table_3", $requete);echo '</tr>
<tr><td>Table_4</td>'.$r=affrecol("table_4", $requete);echo '</tr>
<tr><td>Table_5</td>'.$r=affrecol("table_5", $requete);echo '</tr>
<tr><td>Table_6</td>'.$r=affrecol("table_6", $requete);echo '</tr>
<tr><td>Table_7</td>'.$r=affrecol("table_7", $requete);echo '</tr>
<tr><td>Table_8</td>'.$r=affrecol("table_8", $requete);echo '</tr>
<tr><td>Table_9</td>'.$r=affrecol("table_9", $requete);echo '</tr>
<tr><td>Table_10</td>'.$r=affrecol("table_10", $requete);echo '</tr>
}
//echo '
//<tr><td>LISTE CHAMPS</td><td>';$b=affbq('CL_0',"banque");echo $b.'</td><td>';$b=affbq('CL_1',"banque");echo $b.'</td><td>';$b=affbq('CL_2',"banque");echo $b.'</td><td>';$b=affbq('CL_3',"banque");echo $b.'</td><td>';$b=affbq('CL_4',"banque");echo $b.'</td><td>';$b=affbq('CL_5','dem', $requete);echo $b.'</td><td>';$b=affbq('CL_6',"banque");echo $b.'</td><td>';$b=affbq('CL_7',"banque");echo $b.'</td><td>';$b=affbq('CL_8',"banque");echo $b.'</td></tr>
echo '
</tbody
</table>';
}
?> |