For those who are stupid this will help
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:
Re: For those who are stupid this will help
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
Re: For those who are stupid this will help
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