Ir para conteúdo
TK News
  • Cadastre-se

Normal [Erro] Website

Jean Otserv

Por ,
em Suporte Tibia OTServer

 Share Seguidores 0

Posts Recomendados

Jean Otserv

Jean Otserv 0

Postado
Postado
  • 2101.png

  • Newbie

  • Grupo: Membros
  • Posts: 4
  • Reputação: 0
  • Membro Desde: 12/12/2015
  • OTserv Preferido: o meu

  • 2860.gif

  • Alerta

Boa Tarde,

Estava tentando criar um site pro meu servidor ai na hora de procurar o arquivo "otserv.s3db" da um erro e no config.lua coloquei tudo certo 

sqlDatabase = "otserv"
sqlFile = "otserv.s3db"
 
ai no site eu vo la abro esse aqui otserv.s3db e da o erro da print alguem ajuda?
 

@edit
acho que problema ta nesse arquivo alguem pode deixar ele pronto ?

CREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER ' at line 1
UNIQUE ("config")
);
 
INSERT INTO "server_config" VALUES ('db_version', 23);
 
CREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
);
 
INSERT INTO "server_motd" VALUES (1, 0, 'Welcome to The Forgotten Server!');
 
CREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
);
 
INSERT INTO "server_record" VALUES (0, 0, 0);
 
CREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
);
 
CREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
);
 
INSERT INTO "accounts" VALUES (1, '1', '1', 65535, 0, '', '0', 0, 0, 1);
 
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
);
 
INSERT INTO "players" VALUES (1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 
 
50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '');
 
CREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);
 
CREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
);
 
CREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
);
 
CREATE TABLE "guild_ranks" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
);
 
CREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
"doors" INTEGER NOT NULL DEFAULT 0,
"beds" INTEGER NOT NULL DEFAULT 0,
"tiles" INTEGER NOT NULL DEFAULT 0,
"guild" BOOLEAN NOT NULL DEFAULT FALSE,
"clear" BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE ("id", "world_id")
);
 
CREATE TABLE "house_lists" (
"house_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"listid" INTEGER NOT NULL,
"list" TEXT NOT NULL,
UNIQUE ("house_id", "world_id", "listid"),
FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id")
);
 
CREATE TABLE "house_data" (
"house_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"data" LONGBLOB NOT NULL,
UNIQUE ("house_id", "world_id"),
FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id")
);
 
CREATE TABLE "house_auctions" (
"house_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
"bid" INTEGER NOT NULL DEFAULT 0,
"limit" INTEGER NOT NULL DEFAULT 0,
"endtime" INTEGER NOT NULL DEFAULT 0,
UNIQUE ("house_id", "world_id"),
FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id")
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "player_deaths" (
"id" INTEGER PRIMARY KEY,
"player_id" INTEGER NOT NULL,
"date" INTEGER NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "killers" (
"id" INTEGER PRIMARY KEY,
"death_id" INTEGER NOT NULL,
"final_hit" BOOLEAN NOT NULL DEFAULT FALSE,
"unjustified" BOOLEAN NOT NULL DEFAULT FALSE,
FOREIGN KEY ("death_id") REFERENCES "player_deaths" ("id")
);
 
CREATE TABLE "player_killers" (
"kill_id" INTEGER NOT NULL,
"player_id" INTEGER NOT NULL,
FOREIGN KEY ("kill_id") REFERENCES "killers" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "environment_killers" (
"kill_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
FOREIGN KEY ("kill_id") REFERENCES "killers" ("id")
);
 
CREATE TABLE "player_depotitems" (
"player_id" INTEGER NOT NULL,
"sid" INTEGER NOT NULL,
"pid" INTEGER NOT NULL DEFAULT 0,
"itemtype" INTEGER NOT NULL,
"count" INTEGER NOT NULL DEFAULT 0,
"attributes" BLOB NOT NULL,
UNIQUE ("player_id", "sid"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "player_namelocks" (
"player_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"new_name" VARCHAR(255) NOT NULL,
"date" INTEGER NOT NULL DEFAULT 0,
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "player_skills" (
"player_id" INTEGER NOT NULL,
"skillid" INTEGER NOT NULL,
"value" INTEGER NOT NULL DEFAULT 0,
"count" INTEGER NOT NULL DEFAULT 0,
UNIQUE ("player_id", "skillid"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "player_storage" (
"player_id" INTEGER NOT NULL,
"key" INTEGER NOT NULL,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("player_id", "key"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "player_viplist" (
"player_id" INTEGER NOT NULL,
"vip_id" INTEGER NOT NULL,
UNIQUE ("player_id", "vip_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("vip_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "tiles" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"house_id" INTEGER NOT NULL,
"x" INTEGER NOT NULL,
"y" INTEGER NOT NULL,
"z" INTEGER NOT NULL,
UNIQUE ("id", "world_id"),
FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id")
);
 
CREATE TABLE "tile_items" (
"tile_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"sid" INTEGER NOT NULL,
"pid" INTEGER NOT NULL DEFAULT 0,
"itemtype" INTEGER NOT NULL,
"count" INTEGER NOT NULL DEFAULT 0,
"attributes" BLOB NOT NULL,
UNIQUE ("tile_id", "world_id", "sid"),
FOREIGN KEY ("tile_id") REFERENCES "tiles" ("id")
);
 
CREATE TABLE "player_items" (
"player_id" INT NOT NULL,
"sid" INT NOT NULL,
"pid" INT NOT NULL DEFAULT 0,
"itemtype" INT NOT NULL,
"count" INT NOT NULL DEFAULT 0,
"attributes" BLOB NOT NULL,
UNIQUE ("player_id", "sid"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "player_spells" (
"player_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
UNIQUE ("player_id", "name"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);
 
CREATE TABLE "bans" (
"id" INTEGER PRIMARY KEY NOT NULL,
"type" INTEGER NOT NULL,
"value" INTEGER NOT NULL,
"param" INTEGER NOT NULL DEFAULT 4294967295,
"active" BOOLEAN NOT NULL DEFAULT 1,
"expires" INTEGER NOT NULL,
"added" INTEGER NOT NULL,
"admin_id" INTEGER NOT NULL DEFAULT 0,
"comment" TEXT NOT NULL,
"reason" INTEGER NOT NULL DEFAULT 0,
"action" INTEGER  NOT NULL DEFAULT 0,
"statement" VARCHAR(255) NOT NULL DEFAULT ''
);
 
CREATE TRIGGER "oncreate_guilds"
AFTER INSERT ON "guilds"
BEGIN
INSERT INTO "guild_ranks" ("name", "level", "guild_id") VALUES ("Leader", 3, NEW."id");
INSERT INTO "guild_ranks" ("name", "level", "guild_id") VALUES ("Vice-Leader", 2, NEW."id");
INSERT INTO "guild_ranks" ("name", "level", "guild_id") VALUES ("Member", 1, NEW."id");
END;
 
CREATE TRIGGER "oncreate_players"
AFTER INSERT
ON "players"
BEGIN
INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 0, 10);
INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 1, 10);
INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 2, 10);
INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 3, 10);
INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 4, 10);
INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 5, 10);
INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 6, 10);
END;
 
CREATE TRIGGER "ondelete_accounts"
BEFORE DELETE
ON "accounts"
FOR EACH ROW
BEGIN
DELETE FROM "players" WHERE "account_id" = OLD."id";
DELETE FROM "account_viplist" WHERE "account_id" = OLD."id";
DELETE FROM "bans" WHERE "type" IN (3, 4) AND "value" = OLD."id";
END;
 
CREATE TRIGGER "ondelete_players"
BEFORE DELETE
ON "players"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'DELETE on table "players" violates foreign: "ownerid" from table "guilds"')
WHERE (SELECT "id" FROM "guilds" WHERE "ownerid" = OLD."id") IS NOT NULL;
 
DELETE FROM "account_viplist" WHERE "player_id" = OLD."id";
DELETE FROM "player_viplist" WHERE "player_id" = OLD."id" OR "vip_id" = OLD."id";
DELETE FROM "player_storage" WHERE "player_id" = OLD."id";
DELETE FROM "player_skills" WHERE "player_id" = OLD."id";
DELETE FROM "player_items" WHERE "player_id" = OLD."id";
DELETE FROM "player_depotitems" WHERE "player_id" = OLD."id";
DELETE FROM "player_spells" WHERE "player_id" = OLD."id";
DELETE FROM "player_killers" WHERE "player_id" = OLD."id";
DELETE FROM "player_deaths" WHERE "player_id" = OLD."id";
DELETE FROM "guild_invites" WHERE "player_id" = OLD."id";
DELETE FROM "bans" WHERE "type" IN (2, 5) AND "value" = OLD."id";
UPDATE "houses" SET "owner" = 0 WHERE "owner" = OLD."id";
END;
 
CREATE TRIGGER "ondelete_guilds"
BEFORE DELETE
ON "guilds"
FOR EACH ROW
BEGIN
UPDATE "players" SET "guildnick" = '', "rank_id" = 0 WHERE "rank_id" IN (SELECT "id" FROM "guild_ranks" WHERE 
 
"guild_id" = OLD."id");
DELETE FROM "guild_ranks" WHERE "guild_id" = OLD."id";
DELETE FROM "guild_invites" WHERE "guild_id" = OLD."id";
END;
 
CREATE TRIGGER "oninsert_players"
BEFORE INSERT
ON "players"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "players" violates foreign: "account_id"')
WHERE NEW."account_id" IS NULL
OR (SELECT "id" FROM "accounts" WHERE "id" = NEW."account_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_players"
BEFORE UPDATE
ON "players"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "players" violates foreign: "account_id"')
WHERE NEW."account_id" IS NULL
OR (SELECT "id" FROM "accounts" WHERE "id" = NEW."account_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_guilds"
BEFORE INSERT
ON "guilds"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "guilds" violates foreign: "ownerid"')
WHERE NEW."ownerid" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."ownerid") IS NULL;
END;
 
CREATE TRIGGER "onupdate_guilds"
BEFORE UPDATE
ON "guilds"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "guilds" violates foreign: "ownerid"')
WHERE NEW."ownerid" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."ownerid") IS NULL;
END;
 
CREATE TRIGGER "ondelete_houses"
BEFORE DELETE
ON "houses"
FOR EACH ROW
BEGIN
DELETE FROM "house_lists" WHERE "house_id" = OLD."id";
END;
 
CREATE TRIGGER "ondelete_tiles"
BEFORE DELETE
ON "tiles"
FOR EACH ROW
BEGIN
DELETE FROM "tile_items" WHERE "tile_id" = OLD."id";
END;
 
CREATE TRIGGER "oninsert_guild_ranks"
BEFORE INSERT
ON "guild_ranks"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "guild_ranks" violates foreign: "guild_id"')
WHERE NEW."guild_id" IS NULL
OR (SELECT "id" FROM "guilds" WHERE "id" = NEW."guild_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_guild_ranks"
BEFORE UPDATE
ON "guild_ranks"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "guild_ranks" violates foreign: "guild_id"')
WHERE NEW."guild_id" IS NULL
OR (SELECT "id" FROM "guilds" WHERE "id" = NEW."guild_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_house_lists"
BEFORE INSERT
ON "house_lists"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "house_lists" violates foreign: "house_id"')
WHERE NEW."house_id" IS NULL
OR (SELECT "id" FROM "houses" WHERE "id" = NEW."house_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_house_lists"
BEFORE UPDATE
ON "house_lists"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "house_lists" violates foreign: "house_id"')
WHERE NEW."house_id" IS NULL
OR (SELECT "id" FROM "houses" WHERE "id" = NEW."house_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_player_depotitems"
BEFORE INSERT
ON "player_depotitems"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "player_depotitems" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_player_depotitems"
BEFORE UPDATE
ON "player_depotitems"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "player_depotitems" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_player_skills"
BEFORE INSERT
ON "player_skills"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "player_skills" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_player_skills"
BEFORE UPDATE
ON "player_skills"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "player_skills" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_player_storage"
BEFORE INSERT
ON "player_storage"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "player_storage" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_player_storage"
BEFORE UPDATE
ON "player_storage"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "player_storage" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_player_viplist"
BEFORE INSERT
ON "player_viplist"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "player_viplist" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
 
SELECT RAISE(ROLLBACK, 'INSERT on table "player_viplist" violates foreign: "vip_id"')
WHERE NEW."vip_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."vip_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_player_viplist"
BEFORE UPDATE
ON "player_viplist"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "player_viplist" violates foreign: "vip_id"')
WHERE NEW."vip_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."vip_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_account_viplist"
BEFORE INSERT
ON "account_viplist"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "account_viplist" violates foreign: "account_id"')
WHERE NEW."account_id" IS NULL
OR (SELECT "id" FROM "accounts" WHERE "id" = NEW."account_id") IS NULL;
 
SELECT RAISE(ROLLBACK, 'INSERT on table "account_viplist" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_account_viplist"
BEFORE UPDATE
ON "account_viplist"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "account_viplist" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_tile_items"
BEFORE INSERT
ON "tile_items"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "tile_items" violates foreign: "tile_id"')
WHERE NEW."tile_id" IS NULL
OR (SELECT "id" FROM "tiles" WHERE "id" = NEW."tile_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_tile_items"
BEFORE UPDATE
ON "tile_items"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "tile_items" violates foreign: "tile_id"')
WHERE NEW."tile_id" IS NULL
OR (SELECT "id" FROM "tiles" WHERE "id" = NEW."tile_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_player_spells"
BEFORE INSERT
ON "player_spells"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "player_spells" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_player_spells"
BEFORE UPDATE
ON "player_spells"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "player_spells" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_player_deaths"
BEFORE INSERT
ON "player_deaths"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "player_deaths" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_player_deaths"
BEFORE UPDATE
ON "player_deaths"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "player_deaths" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_killers"
BEFORE INSERT
ON "killers"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "killers" violates foreign: "death_id"')
WHERE NEW."death_id" IS NULL
OR (SELECT "id" FROM "player_deaths" WHERE "id" = NEW."death_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_killers"
BEFORE UPDATE
ON "killers"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "killers" violates foreign: "death_id"')
WHERE NEW."death_id" IS NULL
OR (SELECT "id" FROM "player_deaths" WHERE "id" = NEW."death_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_environment_killers"
BEFORE INSERT
ON "environment_killers"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "enviroment_killers" violates foreign: "kill_id"')
WHERE NEW."kill_id" IS NULL
OR (SELECT "id" FROM "killers" WHERE "id" = NEW."kill_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_environment_killers"
BEFORE UPDATE
ON "environment_killers"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "enviroment_killers" violates foreign: "kill_id"')
WHERE NEW."kill_id" IS NULL
OR (SELECT "id" FROM "killers" WHERE "id" = NEW."kill_id") IS NULL;
END;
 
CREATE TRIGGER "oninsert_player_killers"
BEFORE INSERT
ON "player_killers"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'INSERT on table "player_killers" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
 
SELECT RAISE(ROLLBACK, 'INSERT on table "player_killers" violates foreign: "kill_id"')
WHERE NEW."kill_id" IS NULL
OR (SELECT "id" FROM "killers" WHERE "id" = NEW."kill_id") IS NULL;
END;
 
CREATE TRIGGER "onupdate_player_killers"
BEFORE UPDATE
ON "player_killers"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'UPDATE on table "player_killers" violates foreign: "player_id"')
WHERE NEW."player_id" IS NULL
OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL;
 
SELECT RAISE(ROLLBACK, 'UPDATE on table "killers" violates foreign: "kill_id"')
WHERE NEW."kill_id" IS NULL
OR (SELECT "id" FROM "killers" WHERE "id" = NEW."kill_id") IS NULL;
END;
Link para o post
Compartilhar em outros sites
Gaant

Gaant 230

Postado
Postado

pra importar a db lá no phpmyadmin, é a db que fica na pasta schemas do seu servidor, importe a mysql.sql

poste o config.lua do seu servidor aqui

Gente, não dou suporte via mp, caso queira ajuda crie um tópico no fórum!!!
youtube.png  10869_64x64.png
Ajudei? Clicar em gostar não vai te matar

Link para o post
Compartilhar em outros sites

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

Visitante
Responder

×   Você colou conteúdo com formatação.   Remover formatação

  Apenas 75 emojis são permitidos.

×   Seu link foi automaticamente incorporado.   Mostrar como link

×   Seu conteúdo anterior foi restaurado.   Limpar o editor

×   Não é possível colar imagens diretamente. Carregar ou inserir imagens do URL.

×
 Share
Seguidores 0
Ir para a lista de tópicos

  • Quem Está Navegando   0 membros estão online

    Nenhum usuário registrado visualizando esta página.

  • Conteúdo Similar

    • Jaurez
      .
      Por Jaurez
      .
    • Cat
      Tibia 8.60 v2 Map Editor Release (Corrige erro: Could not locate Tibia.dat and/or Tibia.spr, please navigate to your Tibia 8.60 installation folder)
      Por Cat
      Em alguns casos, o tibia 8.60 comum não abre de jeito nenhum no map editor, mesmo desmarcando check file signatures e configurando o path corretamente.
       
      Este é o client 8.60 adaptado para o Remere's Map Editor. Resolvi postar já que ele foi removido do site oficial do RME. (ficou apenas a versão para linux lá)
      Se estiver tendo problemas para abrir a versão 8.60, tente utilizar este.
                                                                                                                     
      Baixar o Tibia Client 8.60 que funciona no Remere’s Map Editor
      Essa versão do Tibia 8.60 client resolve o erro unsupported client version ou Could not locate tibia.dat and/or tibia.spr, please navigate to your tibia 8.60 installation folder.
       
      Downloads
      https://tibiaking.com/applications/core/interface/file/attachment.php?id=47333

      Scan: https://www.virustotal.com/gui/file/333e172ac49ba2028db9eb5889994509e7d2de28ebccfa428c04e86defbe15cc
       
    • danilo belato
      (Resolvido)Problema com Dat Editor (Sprites que e exportada n abri)
      Por danilo belato
      Fala Galera To Com um problema aki 
       
      quero exporta umas sprites de um server para colocar em outro 
       
      eu clico na sprites ai aparece tds a forma delas do lado de la >>
       
      ai eu clico nela e ponho a opiçao de export mais quando salvo a sprite ela n abri 
       
      aparece isso quando tento vê-la 
       
      visualização não disponível ( no formatos png e bitmap)
       
      Agora no formato idc fala que o paint n pode ler 
       
      me ajudem ae...
    • nathalys2
      (Resolvido)Erro no Website
      Por nathalys2
      Olá galara estou querendo mudar meu gesior pois está meio desatualizado, hoje baixei o 2.0 do ricardo3 > http://www.tibiaking.com/forum/topic/12381-gesior-acc-maker-para-tibia-86020/ <

      Só que quando tento entrar no localhost da o seguinte erro

      Seria alguma coisa errada nas pastas, ou porque o Xamp ou outra coisa não aceita? meu otserver é 8.60 Baiak Ice e Xamp 1.6.5
      Não modifiquei nada nele, somente troquei meu Htdocs por esse 2.0 , e deu o erro.. será que podem me ajudar?? dou +REP

       Warning: parse_ini_file(F:/Disco D/Andressa - Imagens/Anderson/Arquivos Que Eu Mais Uso/The End V0.6/Baiak Extreme(OTProjects)/config.lua) [function.parse-ini-file]: failed to open stream: No such file or directory in C:\xampp\htdocs\config-and-functions.php on line 13
      Database error. Unknown database type in F:/Disco D/Andressa - Imagens/Anderson/Arquivos Que Eu Mais Uso/The End V0.6/Baiak Extreme(OTProjects)/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

       
      Desculpe o tópico não estar organizado, estou com um pouco de pressa !
      Agradeço desde já!!


       
    • Vitor Bicaleto
      (Resolvido)Script addon bugado
      Por Vitor Bicaleto
      Galera to com o script do addon doll aqui, quando eu digito apenas "!addon" ele aparece assim: Digite novamente, algo está errado!"
      quando digito por exemplo: "!addon citizen" ele não funciona e não da nenhum erro
       
      mesma coisa acontece com o mount doll.. 

TibiaKing

Open Tibia Server

Quer aprender a criar seu próprio servidor de Tibia? Então está no lugar certo, aqui você encontrará milhares de tutorias, scripts, códigos, mapas e utilitários para que você possa fazer o seu próprio servidor de Tibia começando do zero.

Redes Sociais

Anuncie no TibiaKing

Precisa de mais visibilidade em seus projetos? Quer fazer um plano publicitário para o seu servidor? Anuncie no OTKing e faça sua divulgação, possuímos centenas de acessos simultâneos e milhares diários, com certeza será a sua solução!

×
×
  • Criar Novo...

Informação Importante

Confirmação de Termo

  Eu aceito