[Guide] Chaos Castle Fix 1.01e

Fix Chaos Castle:
1. Open "SQL Server Enterprise Manager"
2. Select "MuOnline" under "Databases"
3. Select "Character" from tables.
4. Right-click and select "Design Table"
5. Select "AccountID" and change "Collation" to database default.
6. Do the same for "Name"
Chaos Castle should now work by reset where "zs_count" is the reset value.
To enter Chaos Castle by level.
1. Go to "Stored Procedures" and double click on "MX_GetCharacter"
You'll see this:

CREATE procedure MX_GetCharacter
@Name nvarchar(12)
as
BEGIN
SET XACT_ABORT OFF
Set nocount on
begin transaction
select [Couple],[mr_value],[pt_score], [zs_count] from [Character] where Name=@Name
commit transaction
Set nocount off
SET XACT_ABORT ON
END
GO

Change the highlighted line to the one below to enter Chaos Castle by level

select [Couple],[mr_value],[pt_score], [cLevel] from [Character] where Name=@Name

Now edit mx_config.ini

[Stronghold]
Stronghold0=50 ;Min level 50
Stronghold1=100 ;Min level 100
Stronghold2=150 ;Min level 150
Stronghold3=200 ;Min level 200
Stronghold4=250 ;Min level 250
Stronghold5=300 ;Min level 300
Stronghold6=400 ;Min level 400