~~If you haven't already done so Import all tables from Me_MuOnline database to your MuOnline database~~
Open the Enterprise Manager and go to your MuOnline Database. Click on Tables then right click on MEMB_INFO and go to Design Table.
Change what you see in your table to this:
- Once you have done that go to memb_guid and on Identity make it Yes. Leave the Identity Seed and Identity Increment at 1
- Then go to memb___id and set it to primary key (click the key picture near the top of sql) and then go to Collation and click the ... and under Windows Collation go to Chinese_PRC (make sure that dictionary sort is selected and Case Sensitive and Accent Sensitive is ticked, click ok after)
- In mail_chek and adminaccess put the Default Value to (0)
(Must include the backets)
After that save your database.
Once all that is done, download the exdb in attachment at bottom and extract somewhere.
Go to your Enterprise Manager again and add a new database named exdb. Restore database with the exdb.bak. After expand the exdb and right click Tables and select Export Data...
Click next twice and select MuOnline database and next twice again and select these tables:
MANG_INFO
MEMB_OUT
MembInfoModify
VI_CURR_INFO
VI_FQNW_INFO
VI_LEAV_INFO
VI_MIDS_INFO
Next twice again and click Finish and your done!!
You can now delete exdb
Register ODBC's again, then MuEditor should work.
This is a absolute complete newbie guide so i shouldn't be getting people with any problems and i don't think it can be explained any easier ^^



Reply With Quote


