- Joined
- Nov 13, 2008
- Messages
- 1,367
- Reaction score
- 509
Ето ви един код за тези който незнаят как да настроят какво да дава след рес и т.н
Този код Дава по 2000 точки на рес точките се запазват героя почва от 6-левел и героя ви започва със по 100 точки това е за [ MG,DW,DK,ELF ]
Code:
UPDATE Character
SET Experience = ('0') , cLevel = ('1') , LevelUpPoint = LevelUpPoint + 0+2000*Reset , Money = Money - (0+Reset*0) , Reset = Reset + 1 , MapNumber = ('0') , MapPosX = ('128') , MapPosY = ('128')
FROM Character
JOIN MEMB_STAT ON
(MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE cLevel >= 330 AND Reset < 1000 AND Money > (0+Reset*0) AND ConnectStat = 0 AND ((ctlcode < 8) OR (ctlcode IS NULL)) AND (Class = 16 OR Class = 17 OR Class = 18)
UPDATE Character
SET Experience = ('0') , cLevel = ('1') , LevelUpPoint = LevelUpPoint + 0+2000*Reset , Money = Money - (0+Reset*0) , Reset = Reset + 1 , MapNumber = ('0') , MapPosX = ('128') , MapPosY = ('128')
FROM Character
JOIN MEMB_STAT ON
(MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE cLevel >= 330 AND Reset < 1000 AND Money > (0+Reset*0) AND ConnectStat = 0 AND ((ctlcode < 8) OR (ctlcode IS NULL)) AND (Class = 0 OR Class = 1 OR Class = 2)
UPDATE Character
SET Experience = ('0') , cLevel = ('1') , LevelUpPoint = LevelUpPoint + 0+2000*Reset , Money = Money - (0+Reset*0) , Reset = Reset + 1 , MapNumber = ('0') , MapPosX = ('128') , MapPosY = ('128')
FROM Character
JOIN MEMB_STAT ON
(MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE cLevel >= 330 AND Reset < 1000 AND Money > (0+Reset*0) AND ConnectStat = 0 AND ((ctlcode < 8) OR (ctlcode IS NULL)) AND (Class = 32 OR Class = 33 OR Class = 34)
UPDATE Character
SET Experience = ('0') , cLevel = ('1') , LevelUpPoint = LevelUpPoint + 0+2000*Reset , Money = Money - (0+Reset*0) , Reset = Reset + 1 , MapNumber = ('0') , MapPosX = ('128') , MapPosY = ('128')
FROM Character
JOIN MEMB_STAT ON
(MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE cLevel >= 330 AND Reset < 1000 AND Money > (0+Reset*0) AND ConnectStat = 0 AND ((ctlcode < 8) OR (ctlcode IS NULL)) AND (Class = 48 OR Class = 49)
UPDATE Character
SET Experience = ('0') , cLevel = ('1') , LevelUpPoint = LevelUpPoint + 0+2000*Reset , Money = Money - (0+Reset*0) , Reset = Reset + 1 , MapNumber = ('0') , MapPosX = ('128') , MapPosY = ('128')
FROM Character
JOIN MEMB_STAT ON
(MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE cLevel >= 330 AND Reset < 1000 AND Money > (0+Reset*0) AND ConnectStat = 0 AND ((ctlcode < 8) OR (ctlcode IS NULL)) AND (Class = 64 OR Class = 65)
Този код Дава по 2000 точки на рес точките се запазват героя почва от 6-левел и героя ви започва със по 100 точки това е за [ MG,DW,DK,ELF ]
Last edited: