求高人教教

要详细点的谢谢

修改CREATE_NEW_CHAR存储以下段落：

1. INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ ,loyalty,Exp,gold,[Level],Points,strSkill)
   
2.         VALUES         (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ,100,1951540999,200000,80,287,0x8E000000000000000000)

复制代码

若需修改等级，strSkill值自行计算，此处8E（十六进制）=142（二进制）

执行以下命令可取消献身

1. update magic set MagicNum = 905660  where MagicNum = 105660
   
2. update magic set MagicNum = 906660  where MagicNum = 106660
   
3. update magic set MagicNum = 805660  where MagicNum = 205660
   
4. update magic set MagicNum = 806660  where MagicNum = 206660
   
5. 
   
6. update MAGIC_TYPE3 set iNum = 905660  where MagicNum = 105660
   
7. update MAGIC_TYPE3 set iNum = 906660  where MagicNum = 106660
   
8. update MAGIC_TYPE3 set iNum = 805660  where MagicNum = 205660
   
9. update MAGIC_TYPE3 set iNum = 806660  where MagicNum = 206660

复制代码