[DB] Reskill / Restat erzwingen

[Flogolo]

Hallo zusammen,

man kennt es doch sicher von offi das man sich einloggt und reskillt / restattet ist.

Wie kann ich diesen Befehl erzwingen? Das der komplette Server restattet ist?


Hat da jemand Erfahrungen oder eine Ahnung wie man das auslösen kann?

Viele Grüße

[マリブ]

USE [CHARACTER_01_DBF]
GO
UPDATE [CHARACTER_TBL] SET [m_nRemainGP] = ( ([m_nLevel] * 2) - 2 ) WHERE [m_nLevel] <= 120 AND [m_nJob] < 16; -- Normal
GO
UPDATE [CHARACTER_TBL] SET [m_nRemainGP] = ( ( ( [m_nLevel] * 3 ) - 59 ) - 3 )  WHERE [m_nLevel] >= 60 AND [m_nJob] >= 16; -- Master, Hero, Legend
GO
UPDATE [CHARACTER_TBL] SET [m_nStr] = 15, [m_nSta] = 15, [m_nDex] = 15, [m_nInt] = 15; -- Stat Reset
GO

[Flogolo]

ok nice, und Reskill ?

[Sedrika]

Originally Posted by iMalibu

USE [CHARACTER_01_DBF]
GO
UPDATE [CHARACTER_TBL] SET [m_nRemainGP] = ( ([m_nLevel] * 2) - 2 ) WHERE [m_nLevel] <= 120 AND [m_nJob] < 16; -- Normal
GO
UPDATE [CHARACTER_TBL] SET [m_nRemainGP] = ( ( ( [m_nLevel] * 3 ) - 59 ) - 3 )  WHERE [m_nLevel] >= 60 AND [m_nJob] >= 16; -- Master, Hero, Legend
GO
UPDATE [CHARACTER_TBL] SET [m_nStr] = 15, [m_nSta] = 15, [m_nDex] = 15, [m_nInt] = 15; -- Stat Reset
GO

Das kenn ich doch irgendwo her

Originally Posted by Flogolo

ok nice, und Reskill ?

USE [CHARACTER_01_DBF]
GO
UPDATE [tblSkillPoint] SET [SkillLv] = '0'
GO