or your brain is dead eh bro ?
the new projects are total maded from 0 no based source any more so dont talk when you dont know
or your brain is dead eh bro ?
the new projects are total maded from 0 no based source any more so dont talk when you dont know
UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Dexterity, Dexterity = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Dexterity < 0) AND (ConnectStat = 0)
UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Vitality, Vitality = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Vitality < 0) AND (ConnectStat = 0)
UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Strength, Strength = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Strength < 0) AND (ConnectStat = 0)
UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Energy, Energy = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Energy < 0) AND (ConnectStat = 0)
UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Leadership, Leadership = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Leadership < 0) AND (ConnectStat = 0)
UPDATE Character
SET LevelUpPoint='0
WHERE Strength+Dexterity+Vitality+Energy='131068' OR Strength+Dexterity+Vitality+Energy+Leadership='163835'
ofcorse will not work, simply database edit and sql jobs will not do the work
you need gameserver to do it, so you need to build an some function , and add check in protocol simply work ;)
how much stats he wants?
how to fix mix chaos 2second wings ????
just run this
@NujdCode:USE MUONLINE alter table character alter column Strength smallint null alter table character alter column Dexterity smallint null alter table character alter column Vitality smallint null alter table character alter column Energy smallint null alter table character alter column Leadership smallint null
use other db =d
maybe the one from P4F S3 ep1
@laulinh2
don't even understand ur problem exactly