Team BlueWater Game Online Tutorial's
Bine ati venit la Team-BlueWater!!Tutorial's 4 all Games!

[Release] Reset Points

View previous topic View next topic Go down

[Release] Reset Points

Post  m4s4cru on Tue Aug 02, 2011 10:42 am

Aici este un cod pentru cei care nu ştiu cum să se adapteze ce să dea, după respondenţi, etc
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)

Acest cod dă 2000 de puncte de puncte de respondenţi să-şi păstreze caracterul solului şi a 6-Level caracterul tau incepe cu 100 de puncte, deoarece este pentru [mg, DW, DK, ELF]
avatar
m4s4cru
Admin
Admin

Mesaje : 172
Data de inscriere : 2011-07-29
Varsta : 26

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum