Castle.sql

[KaL]

Alguem pode postar uma SQL que esteja com as sieges regulares a cada 7 dias??

A minha ta com 14 dias e eu nao sei alterar, na coluna 'siegeDate', da SQL ta escrito 0-20 Oo

Se alguem puder postar ai, agradeço

[viniciusocp]

No meu servidor tambem..!

[Tony_RadeoN]

posta 1 screen assim posso t ajudar =S

[KaL]

-- ---------------------------
-- Table structure for `castle`
-- ---------------------------
CREATE TABLE IF NOT EXISTS `castle` (
`id` INT NOT NULL default 0,
`name` varchar(25) NOT NULL,
`taxPercent` INT NOT NULL default 15,
`treasury` INT NOT NULL default 0,
`siegeDate` DECIMAL(20,0) NOT NULL default 0,
`siegeDayOfWeek` INT NOT NULL default 7,
`siegeHourOfDay` INT NOT NULL default 20,
PRIMARY KEY (`name`),
KEY `id` (`id`)
) DEFAULT CHARSET=utf8;

INSERT IGNORE INTO `castle` VALUES
(1,'Gludio',0,0,0,7,20),
(2,'Dion',0,0,0,7,20),
(3,'Giran',0,0,0,1,16),
(4,'Oren',0,0,0,1,16),
(5,'Aden',0,0,0,7,20),
(6,'Innadril',0,0,0,1,16),
(7,'Goddard',0,0,0,1,16),
(8,'Rune',0,0,0,7,20),
(9,'Schuttgart',0,0,0,7,20);

Tai...

[Tony_RadeoN]

tenta isso INSERT INTO `castle` VALUES ('5', 'Aden', '0', '0', '1229194800000', '7', '20');
INSERT INTO `castle` VALUES ('2', 'Dion', '0', '0', '1229194800000', '7', '20');
INSERT INTO `castle` VALUES ('3', 'Giran', '0', '0', '1229266800000', '1', '16');
INSERT INTO `castle` VALUES ('1', 'Gludio', '0', '0', '1229194800000', '7', '20');
INSERT INTO `castle` VALUES ('7', 'Goddard', '0', '0', '1229266800000', '1', '16');
INSERT INTO `castle` VALUES ('6', 'Innadril', '0', '0', '1229266800000', '1', '16');
INSERT INTO `castle` VALUES ('4', 'Oren', '0', '0', '1229266800000', '1', '16');
INSERT INTO `castle` VALUES ('8', 'Rune', '10', '2088624569', '1229194800000', '7', '20');
INSERT INTO `castle` VALUES ('9', 'Schuttgart', '0', '0', '1229194800000', '7', '20');



se nao funcionar Avisa e se funcionar click simplesmente em obrigado :D