@@ -189,8 +189,7 @@ discard block |
||
| 189 | 189 | if (!@ is_file($template)) |
| 190 | 190 | { |
| 191 | 191 | $content = & $template; //template is a string (it is a reference to save memory!!!) |
| 192 | - } |
|
| 193 | - else |
|
| 192 | + } else |
|
| 194 | 193 | { |
| 195 | 194 | $content = implode("", file($template)); //template is a file |
| 196 | 195 | } |
@@ -233,10 +232,11 @@ discard block |
||
| 233 | 232 | //$content = str_replace("</head>", '<meta http-equiv="Content-Type" content="text/html; charset='.$this->_encoding.'">'."\n".'</head>', $content); |
| 234 | 233 | } |
| 235 | 234 | |
| 236 | - if ($return) |
|
| 237 | - return $content; |
|
| 238 | - else |
|
| 239 | - echo $content; |
|
| 235 | + if ($return) { |
|
| 236 | + return $content; |
|
| 237 | + } else { |
|
| 238 | + echo $content; |
|
| 239 | + } |
|
| 240 | 240 | } |
| 241 | 241 | |
| 242 | 242 | /** |
@@ -66,7 +66,9 @@ |
||
| 66 | 66 | if ( isset($options["block"]) ) { |
| 67 | 67 | $component->setBlock($options["block"]); |
| 68 | 68 | } |
| 69 | - if ($component->getBlock()) $component->addClass('btn-block expanded'); |
|
| 69 | + if ($component->getBlock()) { |
|
| 70 | + $component->addClass('btn-block expanded'); |
|
| 71 | + } |
|
| 70 | 72 | |
| 71 | 73 | |
| 72 | 74 | |
@@ -85,8 +85,12 @@ |
||
| 85 | 85 | $component->setActive($options["active"]); |
| 86 | 86 | } |
| 87 | 87 | |
| 88 | - if ($component->getBlock()) $component->addClass('btn-block expanded'); |
|
| 89 | - if ($component->getActive()) $component->addClass('active'); |
|
| 88 | + if ($component->getBlock()) { |
|
| 89 | + $component->addClass('btn-block expanded'); |
|
| 90 | + } |
|
| 91 | + if ($component->getActive()) { |
|
| 92 | + $component->addClass('active'); |
|
| 93 | + } |
|
| 90 | 94 | |
| 91 | 95 | if ($component->getTagname() == 'a') { |
| 92 | 96 | $component->setAttributes(array_merge_recursive($component->getAttributes(), array( |
@@ -142,8 +142,7 @@ discard block |
||
| 142 | 142 | $result = array(); |
| 143 | 143 | if (is_array($this->config['updateTypes'])) { |
| 144 | 144 | $updateActions = $this->config['updateTypes']; |
| 145 | - } |
|
| 146 | - else |
|
| 145 | + } else |
|
| 147 | 146 | { |
| 148 | 147 | $updateActions = array_map('trim', explode(',', $this->config['updateTypes'])); |
| 149 | 148 | } |
@@ -155,24 +154,20 @@ discard block |
||
| 155 | 154 | if (in_array('create', $updateActions)) { |
| 156 | 155 | $result[$table] = $info; |
| 157 | 156 | } |
| 158 | - } |
|
| 159 | - elseif ($info['destOrphan']) { |
|
| 157 | + } elseif ($info['destOrphan']) { |
|
| 160 | 158 | if (in_array('drop', $updateActions)) { |
| 161 | 159 | $result[$table] = $info; |
| 162 | 160 | } |
| 163 | - } |
|
| 164 | - elseif($info['differs']) { |
|
| 161 | + } elseif($info['differs']) { |
|
| 165 | 162 | $resultInfo = $info; |
| 166 | 163 | unset($resultInfo['differs']); |
| 167 | 164 | foreach ($info['differs'] as $diff) |
| 168 | 165 | { |
| 169 | 166 | if (empty($diff['dest']) && in_array('add', $updateActions)) { |
| 170 | 167 | $resultInfo['differs'][] = $diff; |
| 171 | - } |
|
| 172 | - elseif (empty($diff['source']) && in_array('remove', $updateActions)) { |
|
| 168 | + } elseif (empty($diff['source']) && in_array('remove', $updateActions)) { |
|
| 173 | 169 | $resultInfo['differs'][] = $diff; |
| 174 | - } |
|
| 175 | - elseif(in_array('modify', $updateActions)) { |
|
| 170 | + } elseif(in_array('modify', $updateActions)) { |
|
| 176 | 171 | $resultInfo['differs'][] = $diff; |
| 177 | 172 | } |
| 178 | 173 | } |
@@ -198,11 +193,9 @@ discard block |
||
| 198 | 193 | { |
| 199 | 194 | if ($info['sourceOrphan']) { |
| 200 | 195 | $result['sourceOrphans'][] = $table; |
| 201 | - } |
|
| 202 | - elseif ($info['destOrphan']) { |
|
| 196 | + } elseif ($info['destOrphan']) { |
|
| 203 | 197 | $result['destOrphans'][] = $table; |
| 204 | - } |
|
| 205 | - else |
|
| 198 | + } else |
|
| 206 | 199 | { |
| 207 | 200 | $result['different'][] = $table; |
| 208 | 201 | } |
@@ -244,11 +237,9 @@ discard block |
||
| 244 | 237 | $info = array('destOrphan'=>false, 'sourceOrphan'=>false, 'differs'=>false); |
| 245 | 238 | if(in_array($tab, $destOrphans)) { |
| 246 | 239 | $info['destOrphan'] = true; |
| 247 | - } |
|
| 248 | - elseif (in_array($tab, $sourceOrphans)) { |
|
| 240 | + } elseif (in_array($tab, $sourceOrphans)) { |
|
| 249 | 241 | $info['sourceOrphan'] = true; |
| 250 | - } |
|
| 251 | - else |
|
| 242 | + } else |
|
| 252 | 243 | {
|
| 253 | 244 | $destSql = $this->getTabSql($this->destStruct, $tab, true); |
| 254 | 245 | $sourceSql = $this->getTabSql($this->sourceStruct, $tab, true); |
@@ -256,12 +247,12 @@ discard block |
||
| 256 | 247 | if ($diffs===false) { |
| 257 | 248 | trigger_error('[WARNING] error parsing definition of table "'.$tab.'" - skipped'); |
| 258 | 249 | continue; |
| 259 | - } |
|
| 260 | - elseif (!empty($diffs))//not empty array |
|
| 250 | + } elseif (!empty($diffs)) { |
|
| 251 | + //not empty array |
|
| 261 | 252 | { |
| 262 | - $info['differs'] = $diffs; |
|
| 263 | - } |
|
| 264 | - else { continue;//empty array |
|
| 253 | + $info['differs'] = $diffs; |
|
| 254 | + } |
|
| 255 | + } else { continue;//empty array |
|
| 265 | 256 | } |
| 266 | 257 | } |
| 267 | 258 | $result[$tab] = $info; |
@@ -279,10 +270,12 @@ discard block |
||
| 279 | 270 | { |
| 280 | 271 | $result = array(); |
| 281 | 272 | if (preg_match_all('/CREATE(?:\s*TEMPORARY)?\s*TABLE\s*(?:IF NOT EXISTS\s*)?(?:`?(\w+)`?\.)?`?(\w+)`?/i', $struct, $m)) { |
| 282 | - foreach($m[2] as $match)//m[1] is a database name if any |
|
| 273 | + foreach($m[2] as $match) { |
|
| 274 | + //m[1] is a database name if any |
|
| 283 | 275 | { |
| 284 | 276 | $result[] = $match; |
| 285 | 277 | } |
| 278 | + } |
|
| 286 | 279 | } |
| 287 | 280 | return $result; |
| 288 | 281 | } |
@@ -309,8 +302,7 @@ discard block |
||
| 309 | 302 | $end = $this->getDelimPos($struct, $offset); |
| 310 | 303 | if ($end === false) { |
| 311 | 304 | $result = substr($struct, $start); |
| 312 | - } |
|
| 313 | - else |
|
| 305 | + } else |
|
| 314 | 306 | { |
| 315 | 307 | $result = substr($struct, $start, $end-$start);//already without ';' |
| 316 | 308 | } |
@@ -382,9 +374,11 @@ discard block |
||
| 382 | 374 | $result = array(); |
| 383 | 375 | //split with comma delimiter, not line breaks |
| 384 | 376 | $sourceParts = $this->splitTabSql($sourceSql); |
| 385 | - if ($sourceParts===false)//error parsing sql |
|
| 377 | + if ($sourceParts===false) { |
|
| 378 | + //error parsing sql |
|
| 386 | 379 | { |
| 387 | 380 | trigger_error('[WARNING] error parsing source sql'); |
| 381 | + } |
|
| 388 | 382 | return false; |
| 389 | 383 | } |
| 390 | 384 | $destParts = $this->splitTabSql($destSql); |
@@ -423,15 +417,12 @@ discard block |
||
| 423 | 417 | $different = $inSource && $inDest && $destPartsIndexed[$key]!=$sourcePartsIndexed[$key]; |
| 424 | 418 | if ($sourceOrphan) { |
| 425 | 419 | $info['source'] = $sourcePartsIndexed[$key]; |
| 426 | - } |
|
| 427 | - elseif ($destOrphan) { |
|
| 420 | + } elseif ($destOrphan) { |
|
| 428 | 421 | $info['dest'] = $destPartsIndexed[$key]; |
| 429 | - } |
|
| 430 | - elseif ($different) { |
|
| 422 | + } elseif ($different) { |
|
| 431 | 423 | $info['source'] = $sourcePartsIndexed[$key]; |
| 432 | 424 | $info['dest'] = $destPartsIndexed[$key]; |
| 433 | - } |
|
| 434 | - else { continue; |
|
| 425 | + } else { continue; |
|
| 435 | 426 | } |
| 436 | 427 | $result[] = $info; |
| 437 | 428 | } |
@@ -452,19 +443,24 @@ discard block |
||
| 452 | 443 | $options = $this->config; |
| 453 | 444 | $result = array('key'=>'', 'line'=>''); |
| 454 | 445 | $line = rtrim(trim($line), ','); |
| 455 | - if (preg_match('/^(CREATE TABLE)|(\) ENGINE=)/i', $line))//first or last table definition line |
|
| 446 | + if (preg_match('/^(CREATE TABLE)|(\) ENGINE=)/i', $line)) { |
|
| 447 | + //first or last table definition line |
|
| 456 | 448 | { |
| 457 | 449 | return false; |
| 458 | 450 | } |
| 459 | - if (preg_match('/^(PRIMARY KEY)|(((UNIQUE )|(FULLTEXT ))?KEY `?\w+`?)/i', $line, $m))//key definition |
|
| 451 | + } |
|
| 452 | + if (preg_match('/^(PRIMARY KEY)|(((UNIQUE )|(FULLTEXT ))?KEY `?\w+`?)/i', $line, $m)) { |
|
| 453 | + //key definition |
|
| 460 | 454 | { |
| 461 | 455 | $key = $m[0]; |
| 462 | 456 | } |
| 463 | - elseif (preg_match('/^`?\w+`?/i', $line, $m))//field definition |
|
| 457 | + } elseif (preg_match('/^`?\w+`?/i', $line, $m)) { |
|
| 458 | + //field definition |
|
| 464 | 459 | { |
| 465 | - $key = '!'.$m[0];//to make sure fields will be synchronised before the keys |
|
| 460 | + $key = '!'.$m[0]; |
|
| 466 | 461 | } |
| 467 | - else |
|
| 462 | + //to make sure fields will be synchronised before the keys |
|
| 463 | + } else |
|
| 468 | 464 | { |
| 469 | 465 | return false;//line has no valuable info (empty or comment) |
| 470 | 466 | } |
@@ -501,13 +497,16 @@ discard block |
||
| 501 | 497 | } |
| 502 | 498 | foreach($diff as $tab=>$info) |
| 503 | 499 | { |
| 504 | - if ($info['sourceOrphan'])//delete it |
|
| 500 | + if ($info['sourceOrphan']) { |
|
| 501 | + //delete it |
|
| 505 | 502 | { |
| 506 | 503 | $sqls[] = 'DROP TABLE `'.$tab.'`'; |
| 507 | 504 | } |
| 508 | - elseif ($info['destOrphan'])//create destination table in source |
|
| 505 | + } elseif ($info['destOrphan']) { |
|
| 506 | + //create destination table in source |
|
| 509 | 507 | { |
| 510 | 508 | $database = ''; |
| 509 | + } |
|
| 511 | 510 | $destSql = $this->getTabSql($this->destStruct, $tab, $database); |
| 512 | 511 | if (!empty($options['ignoreIncrement'])) { |
| 513 | 512 | $destSql = preg_replace("/\s*AUTO_INCREMENT=[0-9]+/i", '', $destSql); |
@@ -519,8 +518,7 @@ discard block |
||
| 519 | 518 | $destSql = preg_replace('/(CREATE(?:\s*TEMPORARY)?\s*TABLE\s*)(?:IF NOT EXISTS\s*)?(`?\w+`?)/i', '$1IF NOT EXISTS $2', $destSql); |
| 520 | 519 | } |
| 521 | 520 | $sqls[] = $destSql; |
| 522 | - } |
|
| 523 | - else |
|
| 521 | + } else |
|
| 524 | 522 | { |
| 525 | 523 | foreach($info['differs'] as $finfo) |
| 526 | 524 | { |
@@ -529,12 +527,10 @@ discard block |
||
| 529 | 527 | if ($inSource && !$inDest) { |
| 530 | 528 | $sql = $finfo['source']; |
| 531 | 529 | $action = 'drop'; |
| 532 | - } |
|
| 533 | - elseif ($inDest && !$inSource) { |
|
| 530 | + } elseif ($inDest && !$inSource) { |
|
| 534 | 531 | $sql = $finfo['dest']; |
| 535 | 532 | $action = 'add'; |
| 536 | - } |
|
| 537 | - else |
|
| 533 | + } else |
|
| 538 | 534 | { |
| 539 | 535 | $sql = $finfo['dest']; |
| 540 | 536 | $action = 'modify'; |
@@ -571,8 +567,7 @@ discard block |
||
| 571 | 567 | case 'drop': |
| 572 | 568 | if ($type=='primary') { |
| 573 | 569 | $result.= 'DROP PRIMARY KEY'; |
| 574 | - } |
|
| 575 | - else |
|
| 570 | + } else |
|
| 576 | 571 | { |
| 577 | 572 | $result.= 'DROP INDEX `'.$name.'`'; |
| 578 | 573 | } |
@@ -580,11 +575,9 @@ discard block |
||
| 580 | 575 | case 'add': |
| 581 | 576 | if ($type=='primary') { |
| 582 | 577 | $result.= 'ADD PRIMARY KEY '.$fields; |
| 583 | - } |
|
| 584 | - elseif ($type=='') { |
|
| 578 | + } elseif ($type=='') { |
|
| 585 | 579 | $result.= 'ADD INDEX `'.$name.'` '.$fields; |
| 586 | - } |
|
| 587 | - else |
|
| 580 | + } else |
|
| 588 | 581 | { |
| 589 | 582 | $result .='ADD '.strtoupper($type).' `'.$name.'` '.$fields;//fulltext or unique |
| 590 | 583 | } |
@@ -592,27 +585,23 @@ discard block |
||
| 592 | 585 | case 'modify': |
| 593 | 586 | if ($type=='primary') { |
| 594 | 587 | $result.='DROP PRIMARY KEY, ADD PRIMARY KEY '.$fields; |
| 595 | - } |
|
| 596 | - elseif ($type=='') { |
|
| 588 | + } elseif ($type=='') { |
|
| 597 | 589 | $result.='DROP INDEX `'.$name.'`, ADD INDEX `'.$name.'` '.$fields; |
| 598 | - } |
|
| 599 | - else |
|
| 590 | + } else |
|
| 600 | 591 | { |
| 601 | 592 | $result.='DROP INDEX `'.$name.'`, ADD '.strtoupper($type).' `'.$name.'` '.$fields;//fulltext or unique |
| 602 | 593 | } |
| 603 | 594 | break; |
| 604 | 595 | |
| 605 | 596 | } |
| 606 | - } |
|
| 607 | - else //fields operations |
|
| 597 | + } else //fields operations |
|
| 608 | 598 | { |
| 609 | 599 | $sql = rtrim(trim($sql), ','); |
| 610 | 600 | $result.= strtoupper($action); |
| 611 | 601 | if ($action=='drop') { |
| 612 | 602 | $spacePos = strpos($sql, ' '); |
| 613 | 603 | $result.= ' '.substr($sql, 0, $spacePos); |
| 614 | - } |
|
| 615 | - else |
|
| 604 | + } else |
|
| 616 | 605 | { |
| 617 | 606 | $result.= ' '.$sql; |
| 618 | 607 | } |
@@ -637,8 +626,7 @@ discard block |
||
| 637 | 626 | $reg = $regPrefix.'("|\')|(/\\*)|(\\*/)|(-- )|(\r\n|\r|\n)|'; |
| 638 | 627 | if ($skipInBrackets) { |
| 639 | 628 | $reg.='(\(|\))|'; |
| 640 | - } |
|
| 641 | - else |
|
| 629 | + } else |
|
| 642 | 630 | { |
| 643 | 631 | $reg.='()'; |
| 644 | 632 | } |
@@ -659,43 +647,47 @@ discard block |
||
| 659 | 647 | continue;//here we could also simplify regexp |
| 660 | 648 | } |
| 661 | 649 | |
| 662 | - if (!empty($m[7][0]))// ';' found |
|
| 650 | + if (!empty($m[7][0])) { |
|
| 651 | + // ';' found |
|
| 663 | 652 | { |
| 664 | 653 | if (empty($stack)) { |
| 665 | 654 | return $m[7][1]; |
| 666 | - } |
|
| 667 | - else |
|
| 655 | + } |
|
| 656 | + } else |
|
| 668 | 657 | { |
| 669 | 658 | //var_dump($stack, substr($string, $offset-strlen($m[0][0]))); |
| 670 | 659 | } |
| 671 | 660 | } |
| 672 | - if (!empty($m[6][0]))// '(' or ')' found |
|
| 661 | + if (!empty($m[6][0])) { |
|
| 662 | + // '(' or ')' found |
|
| 673 | 663 | { |
| 674 | 664 | if (empty($stack) && $m[6][0]=='(') { |
| 675 | 665 | array_push($stack, $m[6][0]); |
| 676 | - } |
|
| 677 | - elseif($m[6][0]==')' && end($stack)=='(') { |
|
| 666 | + } |
|
| 667 | + } elseif($m[6][0]==')' && end($stack)=='(') { |
|
| 678 | 668 | array_pop($stack); |
| 679 | 669 | } |
| 680 | - } |
|
| 681 | - elseif (!empty($m[1][0]))// ' or " found |
|
| 670 | + } elseif (!empty($m[1][0])) { |
|
| 671 | + // ' or " found |
|
| 682 | 672 | { |
| 683 | 673 | if (end($stack)==$m[1][0]) { |
| 684 | 674 | array_pop($stack); |
| 685 | - } |
|
| 686 | - else |
|
| 675 | + } |
|
| 676 | + } else |
|
| 687 | 677 | { |
| 688 | 678 | array_push($stack, $m[1][0]); |
| 689 | 679 | } |
| 690 | - } |
|
| 691 | - elseif (!empty($m[2][0])) // opening comment / * |
|
| 680 | + } elseif (!empty($m[2][0])) { |
|
| 681 | + // opening comment / * |
|
| 692 | 682 | { |
| 693 | 683 | array_push($stack, $m[2][0]); |
| 694 | 684 | } |
| 695 | - elseif (!empty($m[4][0])) // opening comment -- |
|
| 685 | + } elseif (!empty($m[4][0])) { |
|
| 686 | + // opening comment -- |
|
| 696 | 687 | { |
| 697 | 688 | array_push($stack, $m[4][0]); |
| 698 | 689 | } |
| 690 | + } |
|
| 699 | 691 | } |
| 700 | 692 | return false; |
| 701 | 693 | } |