XoopsModules25x /
smartpartner
| @@ 462-480 (lines=19) @@ | ||
| 459 | * |
|
| 460 | * @return bool true if success, false if an error occured |
|
| 461 | */ |
|
| 462 | public function renameTable($from, $to) |
|
| 463 | { |
|
| 464 | global $xoopsDB; |
|
| 465 | ||
| 466 | $from = $xoopsDB->prefix($from); |
|
| 467 | $to = $xoopsDB->prefix($to); |
|
| 468 | ||
| 469 | $query = sprintf('ALTER TABLE %s RENAME %s', $from, $to); |
|
| 470 | $ret = $xoopsDB->query($query); |
|
| 471 | if (!$ret) { |
|
| 472 | echo "<li class='err'>" . sprintf(_AM_SPARTNER_DB_MSG_RENAME_TABLE_ERR, $from) . '</li>'; |
|
| 473 | ||
| 474 | return false; |
|
| 475 | } else { |
|
| 476 | echo "<li class='ok'>" . sprintf(_AM_SPARTNER_DB_MSG_RENAME_TABLE, $from, $to) . '</li>'; |
|
| 477 | ||
| 478 | return true; |
|
| 479 | } |
|
| 480 | } |
|
| 481 | ||
| 482 | /** |
|
| 483 | * Use to update a table |
|
| @@ 609-627 (lines=19) @@ | ||
| 606 | * |
|
| 607 | * @return bool true if success, false if an error occured |
|
| 608 | */ |
|
| 609 | public function renameTable($from, $to) |
|
| 610 | { |
|
| 611 | global $xoopsDB; |
|
| 612 | ||
| 613 | $from = $xoopsDB->prefix($from); |
|
| 614 | $to = $xoopsDB->prefix($to); |
|
| 615 | ||
| 616 | $query = sprintf('ALTER TABLE %s RENAME %s', $from, $to); |
|
| 617 | $ret = $xoopsDB->query($query); |
|
| 618 | if (!$ret) { |
|
| 619 | echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE_ERR, $from) . '<br>'; |
|
| 620 | ||
| 621 | return false; |
|
| 622 | } else { |
|
| 623 | echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE, $from, $to) . '<br>'; |
|
| 624 | ||
| 625 | return true; |
|
| 626 | } |
|
| 627 | } |
|
| 628 | ||
| 629 | /** |
|
| 630 | * Use to update a table |
|
