[DB] Reskill / Restat erzwingen

01/28/2015 22:46 Flogolo#1
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
01/28/2015 22:53 マリブ#2
Code:
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
01/28/2015 23:04 Flogolo#3
ok nice, und Reskill ?
01/28/2015 23:41 Sedrika#4
Quote:
Originally Posted by iMalibu View Post
Code:
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 ;)
Quote:
Originally Posted by Flogolo View Post
ok nice, und Reskill ?
Quote:
USE [CHARACTER_01_DBF]
GO
UPDATE [tblSkillPoint] SET [SkillLv] = '0'
GO