@@ -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 | } |