How to create a new account in SQL:
Code:
up_CreateMemberAccount '0','Username','Password','1','2010-09-27'
and then execute.
Here a tut on how to fix map bug,based on this:
Download Map packer from my post:
1.Open MPPack.exe in the pack tools,there are two,pick the one that might work.
2.Select Bind Uppack,and then Target Bindpack file.
3.Copy the data\world.dat under Your client data folder to my document
4.Select Result folder and excute
5.Copy extracted folder(3_WORLD) to
mlserver\smc\Patch\Map\Data,which is the server files.
6.MPPack.exe->Bind Pack->Select the folder you just copyed(3_WORLD)
7.Point the new 3_WORLD.da back to your client data folder.
8.Change version to 0.2.0,press enew version,and then excute.
PROFIT.