";
if($db_host && $db_user){
mysql_connect("$db_host","$db_user","$db_password") or die("Error: No BD Connection");
$rs = mysql_query("show databases");
$db_names=array();
while($arr=mysql_fetch_array($rs)){
$db_names[]=$arr[0];
}
$post_name = isset($_POST['db_name']) ? $_POST['db_name'] : "";
foreach($db_names as $db_name) {
$selected="";
if ($db_name == $post_name) $selected=' selected ';
$db_select .="";
}
}
$db_select .= "";
?>
EXECUTING QUERIES ON REAL TABLES!!!
";
}
foreach ($field_list as $t_name=>$t_fields) {
echo "
-- Table: $t_name ";
if (in_array($t_name, $skip_tables)) {
$font_color = "red";
echo "
-- Table: $t_name => skipped! ";
continue;
}
foreach($t_fields as $f_name=>$f_record) {
$query = "UPDATE `$t_name` SET `$f_name`=DATE_ADD(`$f_name`, INTERVAL 540 MINUTE) WHERE 1 ; ";
//$query = "SELECT `$f_name`, DATE_ADD(`$f_name`, INTERVAL 540 MINUTE) as `{$f_name}_modified` FROM `$t_name` WHERE 1 ; ";
if ($f_name=="date_entered" || $f_name=="date_modified" || $f_name=="date_created" || $f_name=="deleted_date_modified") {
$font_color = "grey";
}
else {
$font_color = "black";
}
if ($execute_queries && $process_type=='execute') {
mysql_query($query);
}
echo "
$query ";
}
}
}
function GetDatetimeCols($source_db, $table_descriptions) {
if (empty($source_db)) return array();
$db_check = @mysql_select_db ( $source_db );
$skip_fields=array('id');
$datetime_fields=array();
foreach($table_descriptions as $tablename=>$fields){
foreach($fields as $field) {
$field_name=$field[0];
$field_type=$field[1];
if (in_array($field_name, $skip_fields)) continue;
if ($field_type=='datetime') {
$datetime_fields[$tablename][$field_name]=$field;
} else {
if ((strpos($field_type, 'char') !==false) || (strpos($field_type, 'text') !==false)) {
//SELECT * FROM config WHERE value REGEXP '^([1-3][0-9]{3,3})-(0?[1-9]|1[0-2])-(0?[1-9]|[1-2][1-9]|3[0-1]) ([0-1][0-9]|2[0-4]):([0-5][0-9]):([0-5][0-9])$'
$query="select {$field_name} from {$tablename} where {$field_name} REGEXP '^([1-3][0-9]{3,3})-(0?[1-9]|1[0-2])-(0?[1-9]|[1-2][1-9]|3[0-1]) ([0-1][0-9]|2[0-4]):([0-5][0-9]):([0-5][0-9])$' LIMIT 0, 1";
$result=mysql_query($query);
if($row = mysql_fetch_row($result)) {
//$datetime_fields[$tablename][$field_name]=$field;
echo "
-- !!!!! table_name: $tablename field name: $field_name field type: $field_type has date-like records";
}
}
}
}
}
return $datetime_fields;
}
function DBColumns($source_db){
if (empty($source_db)) return array();
$db_check = @mysql_select_db ( $source_db );
$getTables = mysql_query("SHOW TABLES");
$tables = array();
while($row = mysql_fetch_row($getTables)){
$tables[] = $row[0];
}
$table_descriptions=array();
foreach($tables as $tablename){
$sql = "DESCRIBE $tablename";
$result =mysql_query($sql);
while($row = mysql_fetch_row($result) ){
$table_descriptions[$tablename][$row[0]] = array($row[0], $row[1]);
}
}
return $table_descriptions;
}
?>