quando envia o invite de war nao aparece erro porem quando o player vai aceitar, da esse erro aqui, creio ser na database porem nao sei arrumar

 

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: guild_wars (SELECT "guild_id", "status" FROM "guild_wars" WHERE "guild_id" IN (2,1) AND "enemy_id" IN (1,2) AND "status" IN (0, 1))
[8:46:44.475] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: guild_wars (INSERT INTO "guild_wars" ("guild_id", "enemy_id", "begin", "end", "frags", "payment") VALUES (2, 1, 1537962404, 0, 10, 0);)
> Broadcasted message: "Testando has invited Teste to war till 10 frags.".
[8:47:00.250] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: guild_wars (SELECT "id", "begin", "end", "payment" FROM "guild_wars" WHERE "guild_id" = 2 AND "enemy_id" = 1 AND "status" = 0)

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT 0,
  `end` BIGINT NOT NULL DEFAULT 0,
  `frags` INT NOT NULL DEFAULT 0,
  `payment` BIGINT NOT NULL DEFAULT 0,
  `guild_kills` INT NOT NULL DEFAULT 0,
  `enemy_kills` INT NOT NULL DEFAULT 0,
  `status` TINYINT(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)  
)

 

56 minutos atrás, Vodkart disse:

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT 0,
  `end` BIGINT NOT NULL DEFAULT 0,
  `frags` INT NOT NULL DEFAULT 0,
  `payment` BIGINT NOT NULL DEFAULT 0,
  `guild_kills` INT NOT NULL DEFAULT 0,
  `enemy_kills` INT NOT NULL DEFAULT 0,
  `status` TINYINT(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)  
)

 

 

em que lugar do sqlitestudio clico para inserir esse sql?

 

JA ACHEI KKKK VOU TESTAR

 

DEU CERTO, OBRG REP+

Editado Setembro 26, 2018 6 anos por ExtremyDsgnr
achei (veja o histórico de edições)