Kein Hack: Tabellenpräfix nach Update von vb 2.3.x auf 3.x.x ändern

**xGalaxius** · 25.04.2004, 13:23

Hallo zusammen,

vielleicht kann das jemand gebrauchen:

Code:

alter table `access` rename `vb3_access`;
alter table `adminhelp` rename `vb3_adminhelp`;
alter table `administrator` rename `vb3_administrator`;
alter table `adminlog` rename `vb3_adminlog`;
alter table `adminutil` rename `vb3_adminutil`;
alter table `announcement` rename `vb3_announcement`;
alter table `attachment` rename `vb3_attachment`;
alter table `attachmenttype` rename `vb3_attachmenttype`;
alter table `attachmentviews` rename `vb3_attachmentviews`;
alter table `avatar` rename `vb3_avatar`;
alter table `bbcode` rename `vb3_bbcode`;
alter table `calendar` rename `vb3_calendar`;
alter table `calendarcustomfield` rename `vb3_calendarcustomfield`;
alter table `calendarmoderator` rename `vb3_calendarmoderator`;
alter table `calendarpermission` rename `vb3_calendarpermission`;
alter table `cron` rename `vb3_cron`;
alter table `cronlog` rename `vb3_cronlog`;
alter table `customavatar` rename `vb3_customavatar`;
alter table `customprofilepic` rename `vb3_customprofilepic`;
alter table `datastore` rename `vb3_datastore`;
alter table `deletionlog` rename `vb3_deletionlog`;
alter table `editlog` rename `vb3_editlog`;
alter table `event` rename `vb3_event`;
alter table `faq` rename `vb3_faq`;
alter table `forum` rename `vb3_forum`;
alter table `forumpermission` rename `vb3_forumpermission`;
alter table `holiday` rename `vb3_holiday`;
alter table `icon` rename `vb3_icon`;
alter table `imagecategory` rename `vb3_imagecategory`;
alter table `imagecategorypermission` rename `vb3_imagecategorypermission`;
alter table `language` rename `vb3_language`;
alter table `mailqueue` rename `vb3_mailqueue`;
alter table `moderation` rename `vb3_moderation`;
alter table `moderator` rename `vb3_moderator`;
alter table `moderatorlog` rename `vb3_moderatorlog`;
alter table `passwordhistory` rename `vb3_passwordhistory`;
alter table `phrase` rename `vb3_phrase`;
alter table `phrasetype` rename `vb3_phrasetype`;
alter table `pm` rename `vb3_pm`;
alter table `pmreceipt` rename `vb3_pmreceipt`;
alter table `pmtext` rename `vb3_pmtext`;
alter table `poll` rename `vb3_poll`;
alter table `pollvote` rename `vb3_pollvote`;
alter table `post` rename `vb3_post`;
alter table `post_parsed` rename `vb3_post_parsed`;
alter table `posthash` rename `vb3_posthash`;
alter table `postindex` rename `vb3_postindex`;
alter table `profilefield` rename `vb3_profilefield`;
alter table `ranks` rename `vb3_ranks`;
alter table `regimage` rename `vb3_regimage`;
alter table `reminder` rename `vb3_reminder`;
alter table `reputation` rename `vb3_reputation`;
alter table `reputationlevel` rename `vb3_reputationlevel`;
alter table `search` rename `vb3_search`;
alter table `session` rename `vb3_session`;
alter table `setting` rename `vb3_setting`;
alter table `settinggroup` rename `vb3_settinggroup`;
alter table `smilie` rename `vb3_smilie`;
alter table `stats` rename `vb3_stats`;
alter table `strikes` rename `vb3_strikes`;
alter table `style` rename `vb3_style`;
alter table `subscribeevent` rename `vb3_subscribeevent`;
alter table `subscribeforum` rename `vb3_subscribeforum`;
alter table `subscribethread` rename `vb3_subscribethread`;
alter table `subscription` rename `vb3_subscription`;
alter table `subscriptionlog` rename `vb3_subscriptionlog`;
alter table `template` rename `vb3_template`;
alter table `thread` rename `vb3_thread`;
alter table `threadrate` rename `vb3_threadrate`;
alter table `threadviews` rename `vb3_threadviews`;
alter table `upgradelog` rename `vb3_upgradelog`;
alter table `user` rename `vb3_user`;
alter table `useractivation` rename `vb3_useractivation`;
alter table `userban` rename `vb3_userban`;
alter table `userfield` rename `vb3_userfield`;
alter table `usergroup` rename `vb3_usergroup`;
alter table `usergroupleader` rename `vb3_usergroupleader`;
alter table `usergrouprequest` rename `vb3_usergrouprequest`;
alter table `usernote` rename `vb3_usernote`;
alter table `userpromotion` rename `vb3_userpromotion`;
alter table `usertextfield` rename `vb3_usertextfield`;
alter table `usertitle` rename `vb3_usertitle`;
alter table `word` rename `vb3_word`;

Anschließend in der config.php natürlich den Präfix ändern!

Viel Spaß damit!

Sascha