|
@@ 55-62 (lines=8) @@
|
| 52 |
|
} |
| 53 |
|
} |
| 54 |
|
|
| 55 |
|
if (news_TableExists($xoopsDB->prefix('stories'))) { |
| 56 |
|
$sql = sprintf('ALTER TABLE ' . $xoopsDB->prefix('stories') . ' RENAME ' . $xoopsDB->prefix('news_stories')); |
| 57 |
|
$result = $xoopsDB->queryF($sql); |
| 58 |
|
if (!$result) { |
| 59 |
|
echo '<br>' . _AM_NEWS_UPGRADEFAILED . ' ' . _AM_NEWS_UPGRADEFAILED2; |
| 60 |
|
++$errors; |
| 61 |
|
} |
| 62 |
|
} |
| 63 |
|
|
| 64 |
|
if (news_TableExists($xoopsDB->prefix('topics'))) { |
| 65 |
|
$sql = sprintf('ALTER TABLE ' . $xoopsDB->prefix('topics') . ' RENAME ' . $xoopsDB->prefix('news_topics')); |
|
@@ 64-71 (lines=8) @@
|
| 61 |
|
} |
| 62 |
|
} |
| 63 |
|
|
| 64 |
|
if (news_TableExists($xoopsDB->prefix('topics'))) { |
| 65 |
|
$sql = sprintf('ALTER TABLE ' . $xoopsDB->prefix('topics') . ' RENAME ' . $xoopsDB->prefix('news_topics')); |
| 66 |
|
$result = $xoopsDB->queryF($sql); |
| 67 |
|
if (!$result) { |
| 68 |
|
echo '<br>' . _AM_NEWS_UPGRADEFAILED . ' ' . _AM_NEWS_UPGRADEFAILED2; |
| 69 |
|
++$errors; |
| 70 |
|
} |
| 71 |
|
} |
| 72 |
|
|
| 73 |
|
if (news_TableExists($xoopsDB->prefix('stories_files'))) { |
| 74 |
|
$sql = sprintf('ALTER TABLE ' . $xoopsDB->prefix('stories_files') . ' RENAME ' . $xoopsDB->prefix('news_stories_files')); |
|
@@ 73-80 (lines=8) @@
|
| 70 |
|
} |
| 71 |
|
} |
| 72 |
|
|
| 73 |
|
if (news_TableExists($xoopsDB->prefix('stories_files'))) { |
| 74 |
|
$sql = sprintf('ALTER TABLE ' . $xoopsDB->prefix('stories_files') . ' RENAME ' . $xoopsDB->prefix('news_stories_files')); |
| 75 |
|
$result = $xoopsDB->queryF($sql); |
| 76 |
|
if (!$result) { |
| 77 |
|
echo '<br>' . _AM_NEWS_UPGRADEFAILED . ' ' . _AM_NEWS_UPGRADEFAILED2; |
| 78 |
|
++$errors; |
| 79 |
|
} |
| 80 |
|
} |
| 81 |
|
|
| 82 |
|
// 2) Change the topic title's length, in the topics table |
| 83 |
|
$sql = sprintf('ALTER TABLE ' . $xoopsDB->prefix('news_topics') . ' CHANGE topic_title topic_title VARCHAR( 255 ) NOT NULL;'); |
XoopsModules25x /
news
