Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

For those who are stupid this will help

Junior Spellweaver
Joined
Sep 14, 2011
Messages
156
Reaction score
5
Declaration of war isn't broken, use this, im not helping you set it up.

CREATE TABLE dbo.td_DeclarationOfWar (
Influence TINYINT,
MSWarStep TINYINT,
NCP INT,
MSNum INT,
MSAppearanceMap INT,
MSWarStepStartTime datetime,
MSWarStepEndTime datetime,
MSWarStartTime datetime,
MSWarEndTime datetime,
SelectCount TINYINT,
GiveUp BIT,
MSWarEndState TINYINT
)
CREATE UNIQUE CLUSTERED INDEX idx_on_DeclarationOfWar ON td_DeclarationOfWar(Influence, MSWarStep)
GO
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (2, 1, 0, 0, 0, GetDate(), DateAdd(day, 7, GetDate()), DateAdd(day, 3, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (2, 2, 0, 0, 0, DateAdd(day, 7, GetDate()), DateAdd(day, 14, GetDate()), DateAdd(day, 10, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (2, 3, 0, 0, 0, DateAdd(day, 14, GetDate()), DateAdd(day, 21, GetDate()), DateAdd(day, 17, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (2, 4, 0, 0, 0, DateAdd(day, 21, GetDate()), DateAdd(day, 28, GetDate()), DateAdd(day, 24, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (2, 5, 0, 0, 0, DateAdd(day, 28, GetDate()), DateAdd(day, 35, GetDate()), DateAdd(day, 31, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (2, 99, 0, 0, 0, DateAdd(day, 35, GetDate()), DateAdd(day, 42, GetDate()), DateAdd(day, 38, GetDate()), NULL, 3, 0, 0)

INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (4, 1, 0, 0, 0, GetDate(), DateAdd(day, 7, GetDate()), DateAdd(day, 3, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (4, 2, 0, 0, 0, DateAdd(day, 7, GetDate()), DateAdd(day, 14, GetDate()), DateAdd(day, 10, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (4, 3, 0, 0, 0, DateAdd(day, 14, GetDate()), DateAdd(day, 21, GetDate()), DateAdd(day, 17, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (4, 4, 0, 0, 0, DateAdd(day, 21, GetDate()), DateAdd(day, 28, GetDate()), DateAdd(day, 24, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (4, 5, 0, 0, 0, DateAdd(day, 28, GetDate()), DateAdd(day, 35, GetDate()), DateAdd(day, 31, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
VALUES (4, 99, 0, 0, 0, DateAdd(day, 35, GetDate()), DateAdd(day, 42, GetDate()), DateAdd(day, 38, GetDate()), NULL, 3, 0, 0)
GO







I know this is pointless, but does anyone have the paint shop .obj's and up to date object.ini/inf
:scared:
 
Experienced Elementalist
Joined
May 9, 2011
Messages
222
Reaction score
34
Hmm this code was already up on the forum i think and he got an error that he doesn't set the ms num and let it to 0 so ms never happened,i modify this DeclarationOfWar.txt long time ago. Don't remember if that was PanKJ or someone else that upload it
 
Upvote 0
Joined
Sep 7, 2011
Messages
1,323
Reaction score
528
Well i made it to work without what haterz made... i only deleted the columns and made it from 0.

If you need a DecofWar simple and...very small, that works fine, take this and after you delete the columns COPY this in the table. Simple...

2 1 0 0 0 2011-10-15 00:00:00.000 2011-10-22 02:00:00.000 2011-10-15 00:00:00.000 2011-10-22 02:00:00.000 3 False 0
2 2 0 0 0 2011-10-29 00:00:00.000 2011-11-05 02:00:00.000 2011-10-29 00:00:00.000 2011-11-05 02:00:00.000 3 False 0
2 3 0 0 0 2011-11-12 00:00:00.000 2011-11-19 02:00:00.000 2011-11-12 00:00:00.000 2011-11-19 02:00:00.000 3 False 0
2 4 0 0 0 2011-11-26 00:00:00.000 2011-12-03 02:00:00.000 2011-11-26 00:00:00.000 2011-12-03 02:00:00.000 3 False 0
2 5 0 0 0 2011-12-10 00:00:00.000 2011-12-17 02:00:00.000 2011-12-10 00:00:00.000 2011-12-17 02:00:00.000 3 False 0
2 99 0 0 0 2011-12-19 00:00:00.000 2011-12-26 02:00:00.000 2011-12-19 00:00:00.000 2011-12-26 02:00:00.000 3 False 0
4 1 0 0 0 2011-10-15 00:00:00.000 2011-10-22 02:00:00.000 2011-10-15 00:00:00.000 2011-10-22 02:00:00.000 3 False 0
4 2 0 0 0 2011-10-29 00:00:00.000 2011-11-05 02:00:00.000 2011-10-29 00:00:00.000 2011-11-05 02:00:00.000 3 False 0
4 3 0 0 0 2011-11-12 00:00:00.000 2011-11-19 02:00:00.000 2011-11-12 00:00:00.000 2011-11-19 02:00:00.000 3 False 0
4 4 0 0 0 2011-11-26 00:00:00.000 2011-12-03 02:00:00.000 2011-11-26 00:00:00.000 2011-12-03 02:00:00.000 3 False 0
4 5 0 0 0 2011-12-10 00:00:00.000 2011-12-17 02:00:00.000 2011-12-10 00:00:00.000 2011-12-17 02:00:00.000 3 False 0
4 99 0 0 0 2011-12-19 00:00:00.000 2011-12-26 02:00:00.000 2011-12-19 00:00:00.000 2011-12-26 02:00:00.000 3 False 0
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
 
Upvote 0
Back
Top