China DOS Union

I found the 6.0 version of the DvNews source program today and tried upgrading my original forum to 6.0SP2. But the database upgrade program provided by DvNews can't be used... just as wengier said. Sigh...
So I had no choice but to spend some time upgrading it manually.
The DvNews database isn't encrypted; you can open it with Office 2000 and similar software (specifically it should be MS Access).
I compared the two databases (5.0 and 6.0) and found that only a small number of tables and fields are different.
address
admin ---> administrators ＊＊＊＊
bbs1 ---> forum data (posts) ＊＊＊＊
bbslink
bbsnews
besttopic
board ----> forum categories ＊＊＊＊
BoardPermission
bookmark
class ---> this table does not exist in 6.0.
config ---> configuration file for forum templates. ＊＊＊＊
friend
groupname
lockip
log ----> records of forum administration.
message ---> private message records
online ----> forum online status
topic ---> topics ＊＊＊＊
user ----> this is the registered users table ＊＊＊＊
useraccess
usergroups
usertitle
vote
voteuser
The ones marked with ＊＊＊＊ are relatively important. They need to be migrated into the new database.

board ----> forum categories is different from the old one; it combines the old class and board together. But the fields are the same. The meaning of the values has changed a bit.
bbs1－－－this one is different too. Mainly a few fields are different, and the field order is different too. Just adjust the fields and the order and it'll be OK. Pay attention to the field types...

The others seem like they can just be imported directly...

That's it...
Finished.

btw: Wengier, now you can upgrade the forum, right? Hehe...
If you want to be lazy, you can also upload the database and let me upgrade it.

Hehe... ko makes it sound way too simple... truly an expert... PF

Hehe, KO really is a networking expert!!

DvNews 6.0 database table explanation

Table name Purpose

address IP address table
admin administrators table
bbs1 forum post data table (including topics and replies)
bbslink forum links table
bbsnews forum announcements table
BesTopic featured posts table
board forum sections, serial numbers, descriptions, moderators, etc.
Boardpermission record table for user group custom permissions in forum permissions
bookmark user favorites table
class forum category table
config forum configuration table
Friend user friends table
GroupName faction name table
LockIP blocked IP table
log record table for all forum events
message table of all forum private messages
notdownload long duodecimal table, prevents the database from being downloaded
online record table of users currently online on the forum
SmallPaper forum small bulletin
Topic post topic table
User user list
UserAccess table for determining user permissions
UserGroups forum user groups table
UserTitle forum user rank list
vote poll information table (poll items, vote counts for each item, voting time limit, etc.)
VoteUser table of users participating in polls