Minde/Klaidos/SmartWEB/tables.php

Iš PHP, MySQL.
23:41, 11 gruodžio 2008 versija, sukurta Minde (Aptarimas | įnašas) (Naujas puslapis: <?php if(!defined('SMARTWEB')) define('SMARTWEB', 1); require_once 'system/debugger_start.php'; require_once("system/projects.php"); if (substr($_SERVER['H...)

(skirt) ← Ankstesnė versija | Dabartinė versija (skirt) | Vėlesnė versija→ (skirt)
Peršokti į: navigaciją, paiešką

<?php 

   if(!defined('SMARTWEB'))
       define('SMARTWEB', 1);

   require_once 'system/debugger_start.php';

   require_once("system/projects.php");
   if (substr($_SERVER['HTTP_HOST'], -3) == ":80") $_SERVER['HTTP_HOST'] = str_replace(":80", "", $_SERVER['HTTP_HOST']);
   if (!isset($_projects[$_SERVER['HTTP_HOST']])) $_projects[$_SERVER['HTTP_HOST']] = $_projects["default"];
   $pnconfig['_t147Tt'] = $_projects[$_SERVER['HTTP_HOST']];
   require_once("system/config.php");
   require_once($pnconfig['_t147Tt']."/system/config.php");
   require_once($_t0577."error_handler.php");

   if (isset($_SERVER["HTTP_X_FORWARDED_FOR"]))
       $user_ip = $_SERVER["HTTP_X_FORWARDED_FOR"];
   else { $user_ip = $_SERVER['REMOTE_ADDR']; }

   if ($PHP_AUTH_USER == "" && $PHP_AUTH_PW == "" && ereg("^Basic ", $HTTP_AUTHORIZATION)) {
     list($PHP_AUTH_USER, $PHP_AUTH_PW) = explode(":", base64_decode(substr($HTTP_AUTHORIZATION, 6)));
   }

   $have_access = false;

header('Content-Type: text/html; charset=utf-8'); 

           $ip_array = array('213.197.169.106', '213.197.173.18', '82.135.132.20', '213.226.142.140', '217.147.36.152', '127.0.0.1');

   if (true == in_array($user_ip, $ip_array)) {
       $have_access = true;
   } else {
   	if (!isset($_SERVER['PHP_AUTH_USER'])) {
   		authenticate();
   	} else {

if (true == check()) { $have_access = true; } 

   	}
   }

   if ($have_access == false) {
       die('No access. Your IP '.$user_ip.' is logged.');
   }
  
   function  authenticate()  {
       Header("WWW-Authenticate: Basic realm=\"Some test stuff\"");
       Header("HTTP/1.0 401 Unauthorized");
       echo "Sorry, you must enter information ;)\n";
       exit;
   }

   function check(){
              
       $password = '$1$9t5.c.3.$cFeCLxH5.MhKKE1K4rV44/';
       $user = '$1$3r2.OA3.$NaCskbXYYWkH3usDpiknh.';
       if (crypt($_SERVER['PHP_AUTH_USER'],$user) == $user &&
       		crypt($_SERVER['PHP_AUTH_PW'],$password) == $password ) {
       	return TRUE;

} else { return FALSE; } 

   }



   require_once($_t12M."m_site/wfiles/prefices.php");
   require_once($_t0577."db_".$_DB_TYPE.".php");



   $db = New Database();
   $GLOBALS['db'] = $db;

   $db_type = $db->GetType();



   if ($_POST['query']) {
       $query = stripslashes(trim($_POST['query']));
   }

$file_name = "./system/tables_sql.php"; if(file_exists($file_name)) { require_once($file_name); $sql_name_dropdown="<select name=\"selected_sql\" onChange=\"Javascript:Exe_form()\">"; $sql_name_dropdown.="<option value=0>Pasirinkite</option>"; foreach ($sql_array as $key => $value) { $sql_name_dropdown.="<option value=\"".$value."\">".$key."</option>"; } $sql_name_dropdown .= "</select>"; } 

   echo "<html>
   <head>
   <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
       <title>DB tables.</title>
   </head>

   <STYLE>
       A.link {
           font-family: arial;
           font-size:10px; color: #000000;
           font-size: 11px;
       }
       A.link:visited {
           color: #009000;
           text-decoration: underline;
       }
       A.link:hover{
           color: #003300;
           text-decoration: underline;
       }
       A.link:active {
           color: #000000;
           text-decoration: underline;
       }
   </STYLE>



   <script type=\"text/javascript\">
       function addToQuery(str){
           insertAtCaret(str);
           return false;
       }

       function insertAtCaret(myValue) {
           var qryField = document.getElementById('query');

           if (document.selection) {
               qryField.focus();
               var sel = document.selection.createRange();
               sel.text = myValue;
           }else if (qryField.selectionStart || qryField.selectionStart == '0') {
               var startPos = qryField.selectionStart;
               var endPos = qryField.selectionEnd;
               qryField.value = qryField.value.substring(0, startPos) + myValue + qryField.value.substring(endPos, qryField.value.length);
           } else {
               qryField.value += myValue;
           }

           qryField.focus();
       }

function Exe_form() { document.getElementById('query').value = document.getElementById('selected_sql').value; document.getElementById('query').focus(); } 

   </script>
   <body>
   <a href=\"/tables.php\">Lentelių sÄ…raÅas</a>
   <form method=\"post\" action=\"\">
   <input type=\"hidden\" name=\"action\" value=\"qry\">
   <textarea name=\"query\" id=\"query\" rows=10 cols=50 style=\"width: 100%\">".$query."</textarea>

<input type=submit value='Vykdyti užklausą'>

Saugomos užklausos pavadinimas: <input type=text name=\"sql_name\" value=> <input type=submit value=\"IÅsaugoti\"> IÅsaugotos: $sql_name_dropdown

<input type=\"submit\" value=\"PROCESSLIST\" onClick=\"document.getElementById('query').value='SHOW FULL PROCESSLIST'\">


</form> 


   ";



   $t_name = (isset($_REQUEST['t_name']) ? $_REQUEST['t_name'] : );

if( isset($_GET['t']) && !isset($_REQUEST['action']) && !empty($_GET['t']) ) { $_REQUEST['action'] = 'table'; $_REQUEST['t_name'] = $t_name = $_GET['t']; } 

   switch ($_REQUEST['action']) {
   	case "structure":
           $qry = "SHOW FULL COLUMNS FROM ".$_REQUEST['t_name'];
           $result = $db->x5024e($qry);
           echo "".$t_name." (Ä®raÅų: $c_count) <a class=\"link\" href=\"tables.php?action=table&t_name=$t_name\">turinys</a>
";
echo ''; $fc = 0; echo ''; 
           while (list($field, $type, $collation, $null, $key, $default, $extra, $privilegies, $comment ) = $db->GetRowAsList($result)) {
echo ''; 
           }
echo "
'.($fc++).'LaukelisTipasLyginimasRaktasPagal nutylÄ—jimÄ…Privilegijos
'.($fc++).''.$field.''.$type.''.$collation.''.$key.''.$default.''.$privilegies.'
"; 
           break;
       case "table_str":
           $qry = "SELECT COUNT(*) FROM ".$_REQUEST['t_name'];
           $result = $db->x5024e($qry);
           list($c_count) = $db->GetRowAsList($result);

           echo "".$t_name." (ÄÆraÅų: $c_count) <a class=\"link\" href=\"tables.php?action=table&t_name=$t_name\">turinys</a> <a class=\"link\" href=\"tables.php?action=structure&t_name=$t_name\">struktÅ«ra</a>
";
echo ""; $fields = getTableFields ($db_type, $db, $t_name); $field_count = count($fields); echo '
'; for ($fc=0; $fc<$field_count; $fc++) { $field = $fields[$fc]; echo ''; 
           }
echo "
'.($fc+1).''.$field.'
"; 
           break;
       case "table":
           echo '<a href="#" onClick="return addToQuery(\.$t_name.'\');">'.$t_name.'</a>
';
echo ""; $fields = getTableFields ($db_type, $db, $t_name); $field_count = count($fields); echo '
'; for ($fc=0; $fc<$field_count; $fc++) { $field = $fields[$fc]; echo ' '; } echo ""; $order = (true == isset($_REQUEST['order'])) ? ' ORDER BY '.$_REQUEST['order'].' '.$_REQUEST['dir'] : ; $qry = 'SELECT * FROM '.$t_name.' '.$order; $result = $db->x5024e($qry); $count = $db->Count($result); for ($fc=0; $fc<$count; $fc++) { $fields = $db->GetRowAsList($result); echo ''; 
           }
echo "
                       <a href="#" onClick="return addToQuery(\.$field.'\');">'.$field.'</a>  <a href="tables.php?action=table&t_name='.$_REQUEST['t_name'].'&order='.$field.'&dir=ASC">A</a> <a href="tables.php?action=table&t_name='.$_REQUEST['t_name'].'&order='.$field.'&dir=DESC">D</a>
'.implode('', $fields).'
"; 
           break;
       case "drop_tables":
           if ($db_type == 'oracle')
               $qry = "SELECT table_name FROM user_tables";
           else
               $qry = "SHOW TABLES";

           $result = $db->x5024e($qry);
           $table_count = $db->Count($result);

           echo "$table_count lenteliu sk
";

           for ($c=0;$c<$table_count;$c++) {
               list($t_name) = $db->GetRowAsList($result);
               echo "$t_name
";
               $qry = "DROP TABLE $t_name";
               $db->x5024e($qry);
           }
           if ($db_type == 'oracle') {
               $qry = "SELECT SEQUENCE_NAME FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER='EIC'";
               $result = $db->x5024e($qry);
               $table_count = $db->Count($result);
               echo $table_count." seku sk
";
               for ($c=0;$c<$table_count;$c++) {
                   list($t_name) = $db->GetRowAsList($result);
                   echo "$t_name
";
                   $qry = "DROP SEQUENCE $t_name";
                   $r = $db->x5024e($qry);
               }
           }
           echo "baige";
           break;
       case 'check':
       	if (!isset($_POST['x_action'])) $_POST['x_action'] = 'none';
       	if (isset($sql)) unset($sql);
       	$t_name = $_GET['t_name'];
       	$cmd = array();
       	$cmd['mysql'] = array('optimize' => "OPTIMIZE TABLE `$t_name`;",
       						  'repair' => "REPAIR TABLE `$t_name`;",
       						  'check' => "CHECK TABLE `$t_name`;");
       	if (isset($cmd[$db_type][$_POST['x_action']])) {
       		$sql = $cmd[$db_type][$_POST['x_action']];
       	}
       	if (isset($sql)){
       		if (!is_array($sql)) $sqls = array($sql);
       		foreach ($sqls as $sql) {
       			$result = $db->x5024e($sql);
       			if (is_resource($result)) {
echo ""; $data = ""; $header = false; $h1 = ""; while ($row = $db->GetRowAsArray($result)) { $data .= ""; if (!$header) { $h1 .= ""; } foreach ($row as $name => $value) { if (!$header) { $h1 .= ""; 
       						}
$data .= ""; 
       					}
$data .= ""; if (!$header) { $h1 .= "</tr>"; $header = true; } } echo $h1.$data; echo "
$name$value

"; 
       			} else {
       				var_dump($result);
       			}
       		}
       	}
       	echo "<form action=\"tables.php?action=check&t_name=$t_name\" method=\"post\">";
       	echo "<input type=\"submit\" name=\"x_action\" value=\"optimize\" ".(isset($cmd[$db_type]['optimize'])?:'disabled="disabled"')."/>";
       	echo "<input type=\"submit\" name=\"x_action\" value=\"repair\" ".(isset($cmd[$db_type]['repair'])?:'disabled="disabled"')."/>";
       	echo "<input type=\"submit\" name=\"x_action\" value=\"check\" ".(isset($cmd[$db_type]['check'])?:'disabled="disabled"')."/>";
       	echo "</form>";
       	die();
       	break;
       case "qry":
                   		$_REQUEST['sql_name'] = trim($_REQUEST['sql_name']);
   		if (strlen($_REQUEST['sql_name']) > 2 && strlen($query) > 10) {

if(file_exists($file_name)) { $fh = @fopen($file_name, 'a'); } else { $fh = @fopen($file_name, 'w'); @fwrite($fh, "<?php "); } $sql_array[$_REQUEST['sql_name']] = $query; $sql_array = array_unique($sql_array); foreach ($sql_array as $r_key => $r_value) { $stringas .= "\$sql_array['".$r_key."'] = \"$r_value\";"; } @fwrite($fh, $stringas); @fclose($fh); 

   		}



           $max_rows_limit = 200;
           $supported_qry_types = array('select', 'show', 'desc', 'explain', 'update', 'delete', 'replace', 'drop', 'alter', 'create', 'insert', 'repair', 'optimize', 'check', 'set', 'kill');
           $list_qry_types = array('select', 'show', 'desc', 'explain', 'check', 'optimize', 'repair');

           $qry_for_preg = str_replace(
               array("\n", "\r"),
               array(" ",  " "),
               $query);
           $qry_for_preg = strtolower(trim($qry_for_preg));
           $is_supported_qry = preg_match('/('.implode('|', $supported_qry_types).')/i', $qry_for_preg, $matches);
           if ( $is_supported_qry ) {
               $qry_type = $matches[1];
               switch ( $qry_type ) {
               case 'select':
                   $is_matched = preg_match('/select(.*)from\s+([^; ]+)/i', $qry_for_preg, $matches);
                   if ( $is_matched ) {
                       $fields_str = str_replace('`',,$matches[1]);
                       $table_name = str_replace('`',,$matches[2]);

                       $field_list = array();
                       $initial_field_list = explode(',', $fields_str);
                       $fields_count = sizeof($initial_field_list);
                       for ( $i=0; $i<$fields_count; $i++ ) {
                           $field_str = trim($initial_field_list[$i]);
                           if ( '*' == $field_str ) {
                                                                                                                               if ( 'mysql' != $db_type ) {
                                   $field_list = null; unset($field_list);
                                   break;
                               }
                               else {
                                   $rs = $db->x5024e('DESC `'.$table_name.'`');
                                   while ( list($field_name) = $db->GetRowAsList($rs) ) {
                                       $field_list[] = $field_name;
                                   }
                               }
                           }
                           else {
                               $field_str = explode(' as ', $field_str);
                               if ( sizeof($field_str) > 1 ) {
                                   $field_list[] = $field_str[1];
                               }
                               else {
                                   $field_list[] = $field_str[0];
                               }
                           }
                       }
                   }
               }
           }
          
           if ( $is_supported_qry ) {
               if ( in_array($qry_type, $list_qry_types) ) {
echo '
'; 
                   if ( isset($table_name) ) {
                       echo 'LentelÄ—: '.$table_name.'; ';
                   }
                   $result = $db->x5024e($query);
                   $count = $db->Count($result);
                   if ($count == 0)
echo "nieko nerado
"; 
                   else {
                       echo 'Ä®raÅų skaiĨius: '.$count.'</div>';
echo ""; if ( isset($field_list) && is_array($field_list) ) { $fields_count = sizeof($field_list); echo ''; for ( $i=0; $i<$fields_count; $i++ ) { echo ''; 
                           }
echo ''; } for ($c=0; $c<$count && $c<$max_rows_limit; $c++) { echo ""; $tmp = $db->GetRowAsList($result); for ($cc=0; $cc<count($tmp); $cc++) { echo ""; 
                           }
echo ""; } echo "
'.$field_list[$i].'
".$tmp[$cc]."
"; 
                       if ( $count > $max_rows_limit ) {
echo '
Per daug ÄÆraÅų. Rodomi tik pirmi '.$max_rows_limit.'.
Naudokite LIMIT, kad pamatytumÄ—te reikiamus ÄÆraÅus.
'; 
                       }
                   }
                   break;
               }
               else {
                   $result = $db->x5024e($query);
                                       if ( $result && $db->getType == 'mysql') {
                       $affected_rows = $db->AffectedRows();
printf('
Pakeistų laukų skaiĨius: %d
', $affected_rows); 
                   }
               }
           }
           else {
echo '
Klaida! Tokia užklausa nepalaikoma.
Palaikomos tik tokios užklausos: '.implode(', ', $supported_qry_types).'
'; 
           }
       default:
           if ($db_type == 'oracle')
               $qry = "SELECT table_name FROM user_tables";
           else
               $qry = "SHOW TABLES";
           $result = $db->x5024e($qry);
           $table_count = $db->Count($result);
echo "$table_count lenteliu sk
"; for ($c=0;$c<$table_count;$c++) { list($tmp) = $db->GetRowAsList($result); if (strstr($tmp, '$')) continue; $t_array[] = $tmp; } if ($db_type == 'mssql' || $db_type == 'oracle') sort($t_array); $table_count = count($t_array); for ($c=0;$c<$table_count;$c++) { $t_name = $t_array[$c]; echo "

<td><a class=\"link\" href=\"tables.php?action=check&t_name=$t_name\">tikrinti</a></td> 

                       <td><a href=\"tables.php?action=table&t_name=$t_name\">$t_name</a></td>
               ";
               $qry = "select count(*) from $t_name";
               $r = $db->x5024e($qry);
               list($count) = $db->GetRowAsList($r);
echo "<td align=\"right\">$count</td>"; } echo "</table>"; if ($db_type == 'oracle') { $qry = "SELECT SEQUENCE_NAME, LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER='".strtoupper($_DB_USER)."'"; $result = $db->x5024e($qry); $table_count = $db->Count($result); echo "

sekos $table_count
<a class=\"link\" href=\"tables.php?action=table_str&t_name=$t_name\">laukai</a> <a class=\"link\" href=\"tables.php?action=table&t_name=$t_name\">turinys</a></font>
"; for ($c=0;$c<$table_count;$c++) { list($t_name, $t_number) = $db->GetRowAsList($result); echo ""; 
               }
echo "
$t_name $t_number
"; 
               $qry = "SELECT trigger_name, status FROM all_triggers WHERE owner = '".strtoupper($_DB_USER)."'";
               $result = $db->x5024e($qry);
               $table_count = $db->Count($result);
echo "

trigeriai $table_count
"; for ($c=0;$c<$table_count;$c++) { list($t_name, $t_status) = $db->GetRowAsList($result); echo ""; 
               }
echo "
$t_name $t_status
"; 
           }

   }

   echo "
<a href=\"/tables.php\"><< pirmas</a>";

   function getTableFields ($db_type, $db, $table) {
       if ($db_type == 'oracle')
       $qry = "SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE,
       DATA_DEFAULT FROM ALL_TAB_COLUMNS WHERE TABLE_NAME='$table' AND OWNER='".strtoupper($GLOBALS['_DB_USER'])."'";
       else
           $qry = "SHOW FIELDS FROM $table";
       $fields_result = $db->x5024e($qry);
       $field_count = $db->Count($fields_result);
       for ($fc=0; $fc<$field_count; $fc++) {
           $tmp = $db->GetRowAsList($fields_result);
           $fields[] = $tmp[0];
       }
       return $fields;
   }

   require_once 'system/debugger_end.php';

?> </body> </html>

Gauta iš "http://www.mysql.lt/w/index.php?title=Minde/Klaidos/SmartWEB/tables.php&oldid=3063"