OpencachingDeutschland /
oc-server3
| @@ 632-644 (lines=13) @@ | ||
| 629 | ||
| 630 | $sFields[] = '`' . sql_escape($k) . '`'; |
|
| 631 | ||
| 632 | if ((($field['insertfunction'] & RE_INSERT_OVERWRITE) == RE_INSERT_OVERWRITE) || (($field['changed'] == false) && ($field['insertfunction'] != RE_INSERT_NOTHING))) { |
|
| 633 | if (($field['insertfunction'] & RE_INSERT_NOW) == RE_INSERT_NOW) { |
|
| 634 | $sValues[] = 'NOW()'; |
|
| 635 | } else { |
|
| 636 | $sValues[] = 'NULL'; |
|
| 637 | } |
|
| 638 | } else { |
|
| 639 | if ($field['value'] === null) { |
|
| 640 | $sValues[] = 'NULL'; |
|
| 641 | } else { |
|
| 642 | $sValues[] = '\'' . sql_escape($this->pFormatValueSql($field['type'], $field['value'])) . '\''; |
|
| 643 | } |
|
| 644 | } |
|
| 645 | } |
|
| 646 | ||
| 647 | foreach ($this->fields as $k => $field) { |
|
| @@ 654-666 (lines=13) @@ | ||
| 651 | ||
| 652 | $sFields[] = '`' . sql_escape($k) . '`'; |
|
| 653 | ||
| 654 | if ((($field['insertfunction'] & RE_INSERT_OVERWRITE) == RE_INSERT_OVERWRITE) || (($field['changed'] == false) && ($field['insertfunction'] != RE_INSERT_NOTHING))) { |
|
| 655 | if (($field['insertfunction'] & RE_INSERT_NOW) == RE_INSERT_NOW) { |
|
| 656 | $sValues[] = 'NOW()'; |
|
| 657 | } else { |
|
| 658 | $sValues[] = 'NULL'; |
|
| 659 | } |
|
| 660 | } else { |
|
| 661 | if ($field['value'] === null) { |
|
| 662 | $sValues[] = 'NULL'; |
|
| 663 | } else { |
|
| 664 | $sValues[] = '\'' . sql_escape($this->pFormatValueSql($field['type'], $field['value'])) . '\''; |
|
| 665 | } |
|
| 666 | } |
|
| 667 | } |
|
| 668 | $sql .= join(', ', $sFields); |
|
| 669 | $sql .= ') VALUES ('; |
|
