Problem with tfs 2.9 sql import

Ryu · Feb 17, 2008

Well I want to make a ot with tfs 2.9, but WHen I try to import the forgottenserver.s3db i get this huge error... What do i do ..

Error
Hay la posibilidad de que usted haya encontrado un error en el intérprete de SQL. Por favor examine cuidadosamente su consulta, y verifique que las comillas están siendo usadas adecuadamente y hacen juego. Otra posible causa del fallo es que usted este subiendo un archivo con datos binarios por fuera del área de texto delimitado. Intente su consulta en la interfaz de comandos de MySQL. La salida generada por el servidor de MySQL, de existir, aparece abajo, en cuyo caso puede ayudar a diagnosticar el problema. Si aún tiene problemas o el intérprete falla en tanto que en la interfaz de comandos funciona, por favor reduzca la salida de su consulta de SQL a la consulta que genera el problema, y env*e un reporte de error con la cadena de datos en la sección de CORTE indicada abajo:
----INICIO DEL CORTE----
eNrtXU1sG8cVnuXaZkIX+XMcxmFcjxHLMmNJFmlJjmUYDi2vbCIU6ZCUXQcx5BW5ljcid2kuqUgO
AlSyUqNIgPbUS9DUBdpeChS9FAiCoL0EAYoC7aGXXnrpIUWLXHppCxSoO7tLijuzs+QOSbkyPc/U
mj9vZmffm/fNe29nZqVsNpOdhjMxOBOHKSk9DWOTMDYFJ2KnpiZDuTz6DYRCuSvohyPJ4jQ0bpcq
ctVQqmMldXGscqsCY7Hx2CkYHx8/NRqLj8ZjMPbaNHpNTLwFS0r5NDwSmlvLvZmahpNj42OTsdB8
LgszuRGYuCil8yPwioROcVXV4FzmrWQqlTDZQpfnEtMwPhaLjU2ELl+6bDKNZHJmFfGxSXg1mU7n
Q6lE+uI0VIzReu3m6Gsh6xTooNYUeFOvluUaPAl2AUEAr0MIAJgAOJ1Af4LjswB80m70t0/8sfk2
Kv5H/Kf4D/Fr8a/iX8Q/i38S/yj+Xvyt+IX4G/Ez8VfiL8Wfiz+zWTlx4mTSsTF0GD6ODkflcuVM
FL0ZGkaHI0Po8IT5J6JDMBBCR1H8FIifir8T/8blxonTo0DPCkFwQEBUKclrStX86uVAEAztRl/J
cEkuK2XZqKEfDj1AhIbd/WIQhBu/6kVwSH7wo3+jr037F5Dhc9vnxGmAab+wFzwtiMLTIYQBMQE8
eADGkenb9v8xQC9OnDjtHCoIx8Fxc4gPBASCQs1vQs1vEoWCXtdqcE7W5CWlir4B4Afon0lao8J4
PCh8v1V/KBRqjv9fA/TixInTANM+8bgLJywggIiO3q7rtTMV3Vi138FkOi9dlLIwncnD9HwqBS9I
s4n5VB6Oj+AF1lgL3GEqUNC1olpTdc1oFDufypzfKoNxyhWmmg2F7VpLKKIq6UuqxlxKZWyYvKI0
LzaTSUmJtLtAzFmgqhSN5Xqp1KnQOK1QTS0rTM2rytryglr0KOPkXKqrpaKmFpYbvFcS2ZlLieyx
+ORk1H2S4WGKtPV6jalxiyXFMFRtyWAqVVSrSsHsZGyq1Q1jQVmtKFVV0QodhRhzFy4jM+yimLGs
lkoGW8FKVSkrWpHpAnWtpGrN68on09dQMc8i8+nkm/MSPGaza3KzV0Xtn2czWSl5MQ3fkK41eWQb
jLb6UhRmpVkpK6VnpBzEWJrX2ii4VcCz6qWqXq+0q9hi8Ko2FDX9ogD4CoCvhL8P7oiwIQjB8IED
wt3rNRkZji0T+xiYyUqJvATzifMpiSozRz9xgcHlbHIukb1masTZn1qdgg4FTt6bJZnRiFFfQbbv
A5bK8mpRqeg1taaUffKvqJWSanhBUSi6uS8QDB88KNxbsyTZ7LbN/0WKNMmu7VOe1BZWZMN4V68W
/Qq3tlbpDFckehTlNYN56EOFmMosK2vkRYzTxopxbLBQyrJa6mKQWSzphWWlyDRuvitXNeYBBsej
jkLfJkQTQAGYr22i7z0nBsORiPDD9ywjsFPTRuO/XRQTaPzUDwtggZYOyiAwBRui2jKXlBWlxGRW
K3pBZnY7bilyqXar8+hPKYSQjLGcf/eGcFP05UW9uMbq3OjLNxWlxl4KXV6RvRQa8gz2Ur7A8+QU
WUwuFltBjD8pluUlX32KKOTHp3QVYe8aZimjomhsDrqh19mup6a/q7WxP4Q7e0xsA7t4hM+J0+NI
pv3vBisAvX4qfBG4LL7xMM46umtPOBERgKoVlVXjdgmFEwtyvaZbnxcavs1CrPFm98bLu61ga3Of
HWyZuRHDPj5JC7asXx5SsIUgFo3yfnycQlWxPJaiXJP9hE56rcjkl1M8X6xxFMeX8CJdnu/6k3uC
4eFhYf3NluAXVG0F6cvAPuz1UkOTAdPGDfu8aGi64SGCG43CFAbUqtVgMMyu1WaVPmTP0gHauRne
IQnWFlpIgvVht2LiT1gWsXHOUswtvW4ohn0MUVRh/9KDRVgdyYfgKrLKlicjQsK89K28Q9PcO+HE
6fH2Trj9c+LE7Z8TJ07c/jlx4vT42L8IMgBkhKHAas/VreeedCaOrKyIz/uTqlHzzUjLZXhmgvBG
UDJBeO7GlQnauByyUnSbC447xwtFRa7dMrAPz3jeRW4wUNJDW3k6H1fOPBmO/Z6vOXdLKS4srnUx
X0E1Gnlln9MDKaoipNFFPvXu7r3B8IkTwgencWU1Z9S4vni2ndKIeTjdKs6qaIExb2f4qrrCWKt5
OW3uEeOTW+uMt0/lWq2qLtZbyWjKdNht0Tr3Yjhx4lEMJ06cuP1z4sTp8bL/XeAdAN4Rvh0oiNs3
ixxs7PuGlQy4qzjjS3vNE/bhOe+4Elsh1W1MaVXii3NFLtUVxmWN/iO/bYnn1m+EguFoVNh4D5Ny
Ta/KS8Sn59vI2eboUdCtRR/dCnk7BfX+U5ag7k46BdVYEIR/2u8tKHwBUbeCQrV0YtwGGXhW7GxO
N5J96elgOBwWNuwZkTW1pBjW4QWKHK0fepj8tepDvH564R3PNWDcQ+LEiUdInDhx4vbPiRMnbv+c
OHF6POxfBJ8D8LnwX/G1R6vtG+eeCYYPHxY2k1upmAVrWk7rXdgjKbPgNX3H/tFXovWxmYeDyYSS
MsOyXO5pcqeeDYaHhoTNmDMV6Zx0Zb0/4J2GZJhq1VlTnbXErCE/2tmpM6TWpees+xYbSSyjXlEc
9y2sDy+1yadbDD1mif0t/OWzxDhx4sRjIE6cOHH758SJU8/2HwCfAPBJoL7zWnc3vy8Y3r9fuLfX
itAWZc0w/yKUeMz8npbT8LH3Ix7iVhg3bzSWOxWYiJ+eOD11Kn56csQVILJumMyc92DfLV6RDV1j
XZklW7uxs5Yq6OVyaz/KZuw7Nd55H2BZ05xr8rxPF4refeL5YOT4AeGD+VpVXVpSqrpmbYqmLDi3
dAPNPpVNXjRram6ojrHaX4YSs3nEkUznpGweZtKUzbNC56WLybTV4AYbamEG2xLM3JWfiMtbeYAR
92rFEUjfxOtKIjWPwv1mvuqWAlOKXGz2rBF4cgSmpatjROR/5v/QNhleUQvKKN68+A5q3pxSXmy1
LObRMil9wUbNfeYjOnY3oOoDfX8wMhoRPjxE9jJ8W+UO/QzL12AdLbTV0XCedj2NOrmWmjoaoU2h
HXFP5GwJzS2bEWTcMDbuqbyH3ZrYjmpNfEe15uSOas3EjmrN5I5qzVSjNQh21ldfCEZOHBTujm5h
TFEpKeY2psTzC7xQhmDfghAzt4zGzJSUl1o4Q3AhHiglZi7BbOaqA3XsUnA2m5mj5pyvXpKyktfu
7GdhJnWBuOQzHtU6PDxnnQ4P7yw8CRPpC1RviX6mBpYL4NfAfD169J1zYWvY+egc2SX8DTs4c/v+
gDN5dIccKjSTh9lEMicdy2ZSqfOJmTdG4HBDn7oGLVee2lVWVL2EBkHDfFS9oi5p09Tdbm9W9TJW
idPxGo5arbA7yLFGY4iJ544+hW146uxV+ClpnScKk7ktf/NMqK0tEKsJnCci7xPRTgUzWdp6Ahbj
oS7/YG1Hp8qdkNjnup33QftctWtLi36LxXmLsF91+wHDuAMMsWjT+0Tzly+YKEHZAyYn5Sm78p6F
426z8YO4AfAZAJ8J/3rEZl1Mv2iFkpunSbT1E0pirO2hFuPxQFpMVziQtpRFPtHtrBlIU58LR6qS
fGqcXzTFojNnhcRO2FRM9eruPddsdbzNPQeswfLe3Jb6VM1QqjWfgyXOjGuwfZDGOFg2vM6uBkvS
x8JGxJaD6X5QTs5eFgUbhFrcWePEM7GcSnGow/us0eZpGwPodggEf3qQhzjIRwx1IwzsgU4dRUE+
H2pLEFsI+SUAXwb+8Ojmljf3vESaW71S9J8SwZlxc7PBr0/m1kBSbm79EMgjaG4bYxF7WD/sGtYd
T1jsNKw7muM5rDt5+hJAYULwpxJ3AIUpljGC8g72ibP6iKEayLcLxAGIC2rgvpjz4ZNNvGwrb5Qc
1P34ZBhr+xHdj0/GNn5h0aev4NfDnIjHwXRjTd56pJoT8YwXzJomDpIKaSC5H4VgrO0xvxeF0BFu
MBWyPv5NSyEbQyS8OZ/g0gHenMGgF7xhPL7ThfZepGZ6hHaxxHapnr79+quHgpFoWNg4SF5ka5uC
DpfomMvtdYVOFt8X6Jp0j0Xs2KT79jGz8DYQ3g78gs9a6HNUn4HByOQrwmaGOoLYYafjrZ+xxBmr
th1QMMb+jSpYrOzpF2Bxs5erRjzAqitXzSvNSnfViNu02OCSOUzqyjli+NaVu5CPsaYXXbUZcAZV
VxyzthOzbIl7AJdjTHW87QBcroHYC7jcjH0BLrcj4GUMuFPgYQzkRuvdGAOWAu9oDOSu6jhwveIB
XGy6chdqD1w964oOXAOtKxu4XgTCi4GPONQ4QOf2kWAkcULYfI+eP2+3p7yvnLrrXlz77LqbvY95
dvd9Qa8eTtzH8+jirgWBDyEodK0PxBDp9hCpTSzj2o02vSrwk7ztWZvtspYDr00bs14HwuuB+xyp
usC260flcgX5U6eHhc2CB75R9jT1h2vOqREdMA1j7SeeYdMzBg3Lrg+TmsOhiEFztIK+8KsXzbXF
rkHWnI1bU0CYCnzMUcg3Wi0eC0bORIVN1QupaPsC+8Qq5xyxTmCF8fYVrbCZaoMGV4tRUn0E6rCo
j1rUH2L1or72kDXI6rOnZ9wB4E7gJw95SsXwq1bHuWd42D11m2t/do/NUe1g9zhvP+0enyk7SB1n
u2XinBvsIRB8O/KHIA18w3EMAq8dtyHwqgcEMvVkalFfENhTT24LgYOoNXvLtKcAeEq4Gri/MTsS
jJw8LGwmSDSi7UfWAYXIu6ReCOTi6wv6uO7ReukLu1/roTBiI7VuNObcV6yjvohNyjAzmx0lVdSw
FRYVuYq0N61eVUQ3q4FV0fWxDlkH945kPj15x8qDTo68k7Wvfrxz9cNA+oEQBO6jA81be38caTYi
fPeExwTYBflmTakyTYO1i2Drg7uaC8uyXKU1J6UkG7WSvqRqjd+PltChJS3yZ3L9SZ+XAO2Mdnms
H9oZjaMt+NoZLaMtiXtoLbNg90SHlKF/2KUV9BeA9wC77ePvAYbd/wHbeJic
----FIN DEL CORTE----
----INICIO DEL VOLCADO----

ERROR: C1 C2 LEN: 15 16 41765
STR: �

SVN: $Id: sqlparser.lib.php 11017 2007-12-21 18:18:44Z lem9 $
MySQL: 5.0.51
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.11.4
PHP VER,OS: 5.2.5 WINNT
LANG: es-utf-8
SQL: SQLite format 3��@ ��4��/��)��(.��'+��&)��%'��$%��
��player��%a gamemaster��a god�a��
��
1��0��
��c+�+

Account Manager��n��22��

��
��+Account Manager��
"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,
"redskull" BOOLEAN NOT NULL DEFAULT 0,
"redskulltime" 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,
"direction" INTEGER NOT NULL DEFAULT 0,
"loss_experience" INTEGER NOT NULL DEFAULT 10,
"loss_mana" INTEGER NOT NULL DEFAULT 10,
"loss_skills" INTEGER NOT NULL DEFAULT 10,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
UNIQUE ("name"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("group_id") REFERENCES "groups" ("id")
)
��]tablegroupsgroupsCREATE TABLE "groups" (
"id" INTEGER PRIMARY KEY,
"name" VARCHAR(255) NOT NULL,
"flags" INTEGER NOT NULL DEFAULT 0,
"access" INTEGER NOT NULL,
"maxdepotitems" INTEGER NOT NULL,
"maxviplist" INTEGER NOT NULL
)��ytableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"password" VARCHAR(255) NOT NULL,
"type" INTEGER NOT NULL DEFAULT 1,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"email" VARCHAR(255) NOT NULL DEFAULT '',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
FOREIGN KEY ("group_id") REFERENCES "groups" ("id")
)
��c��c��{tableplayersplayersCREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"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,��
��
��v��v��PK��-A�indexsqlite_autoindex_players_1players��tableguildsguilds CREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)� ''�Qtableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
`player_id` INTEGER NOT NULL,
`guild_id` INTEGER NOT NULL
)�x "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")
)�2�?tablehouseshouses
CREATE TABLE "houses" (
"id" INTEGER PRIMARY KEY,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" TEXT NOT NULL
)
��
��
��
��
��O��O%x��S "house_id" INTEGER NOT NULL,
"listid" INTEGER NOT NULL,
"list" TEXT NOT NULL,
FOREIGN KEY ("house_id") REFERENCES "houses" ("id")
)�P
''�_tableplayer_deathsplayer_deathsCREATE TABLE "player_deaths" (
"player_id" INTEGER NOT NULL,
"time" INTEGER NOT NULL DEFAULT 0,
"level" INTEGER NOT NULL DEFAULT 1,
"killed_by" VARCHAR(255) NOT NULL DEFAULT '',
"is_player" BOOLEAN NOT NULL DEFAULT 1,
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)�//�9tableplayer_depotitemsplayer_depotitemsCREATE TABLE "player_depotitems" (
"player_id" INTEGER NOT NULL,
"depot_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,
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)
��
��
��
��j��j�cc�� ''�etableplayer_skillsplayer_skillsCREATE TABLE "player_skills" (
"player_id" INTEGER NOT NULL,
"skillid" INTEGER NOT NULL,
"value" INTEGER NOT NULL DEFAULT 0,
"count" INTEGER NOT NULL DEFAULT 0,
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)�`
))�{tableplayer_storageplayer_storageCREATE TABLE "player_storage" (
"player_id" INTEGER NOT NULL,
"key" INTEGER NOT NULL,
"value" INTEGER NOT NULL,
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)�}))�5tableplayer_viplistplayer_viplistCREATE TABLE "player_viplist" (
"player_id" INTEGER NOT NULL,
"vip_id" INTEGER NOT NULL,
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("vip_id") REFERENCES "players" ("id")
)��tabletilestilesCREATE TABLE "tiles" (
"id" INTEGER PRIMARY KEY,
"x" INTEGER NOT NULL,
"y" INTEGER NOT NULL,
"z" INTEGER NOT NULL
)
��
��
��
��
��8��?!!�Itabletile_itemstile_itemsCREATE TABLE "tile_items" (
"tile_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,
FOREIGN KEY ("tile_id") REFERENCES "tiles" ("id")
)�7%%�1tableplayer_itemsplayer_itemsCREATE 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,
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)�E''�Itableplayer_spellsplayer_spellsCREATE TABLE "player_spells" (
"player_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)
��
��
��
��u��T�tablebansbansCREATE TABLE "bans" (
"type" INTEGER NOT NULL DEFAULT 0,
"ip" INTEGER NOT NULL DEFAULT 0,
"mask" INTEGER NOT NULL DEFAULT 4294967295,
"player" INTEGER NOT NULL DEFAULT 0,
"account" INTEGER NOT NULL DEFAULT 0,
"time" INTEGER NOT NULL DEFAULT 0,
"reason_id" INTEGER NOT NULL DEFAULT 0,
"action_id" INTEGER NOT NULL DEFAULT 0,
"comment" VARCHAR(60) NOT NULL DEFAULT '',
"banned_by" INTEGER NOT NULL DEFAULT 0
)�+�Utriggeroncreate_guildsguilds�CREATE TRIGGER "oncreate_guilds"
AFTER INSERT ON "guilds"
BEGIN
INSERT INTO "guild_ranks" ("name", "level", "guild_id") VALUES ("the Leader", 3, NEW."id");
INSERT INTO "guild_ranks" ("name", "level", "guild_id") VALUES ("a Vice-Leader", 2, NEW."id");
INSERT INTO "guild_ranks" ("name", "level", "guild_id") VALUES ("a Member", 1, NEW."id");
END
��o-�triggeroncreate_playersplayers�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�x/�-triggerondelete_accountsaccounts�CREATE TRIGGER "ondelete_accounts"
BEFORE DELETE
ON "accounts"
FOR EACH ROW
BEGIN
DELETE FROM "players" WHERE "account_id" = OLD."id";
DELETE FROM "bans" WHERE "type" = 3 AND "account" = OLD."id";
END
��?-�?triggerondelete_playersplayers�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 "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 "bans" WHERE "type" = 2 AND "player" = OLD."id";
UPDATE "houses" SET "owner" = 0 WHERE "owner" = OLD."id";
END
��:+�9triggerondelete_guildsguilds�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";
END�-�Mtriggeroninsert_playersplayers�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;

SELECT RAISE(ROLLBACK, 'INSERT on table "players" violates foreign: "group_id"')
WHERE NEW."group_id" IS NULL
OR (SELECT "id" FROM "groups" WHERE "id" = NEW."group_id") IS NULL;
END
��-�Mtriggeronupdate_playersplayers�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;

SELECT RAISE(ROLLBACK, 'UPDATE on table "players" violates foreign: "group_id"')
WHERE NEW."group_id" IS NULL
OR (SELECT "id" FROM "groups" WHERE "id" = NEW."group_id") IS NULL;
END�.+�!triggerondelete_groupsgroups�CREATE TRIGGER "ondelete_groups"
BEFORE DELETE
ON "groups"
FOR EACH ROW
BEGIN
SELECT RAISE(ROLLBACK, 'DELETE on table "groups" violates foreign: "group_id" from table "players"')
WHERE (SELECT "id" FROM "players" WHERE "group_id" = OLD."id") IS NOT NULL;
END
��2��2i�S��4+�-triggeroninsert_guildsguilds�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�4+�-triggeronupdate_guildsguilds�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�0+�%triggerondelete_houseshouses�CREATE TRIGGER "ondelete_houses"
BEFORE DELETE
ON "houses"
FOR EACH ROW
BEGIN
DELETE FROM "house_lists" WHERE "house_id" = OLD."id";
END�*)�triggerondelete_tilestiles�CREATE TRIGGER "ondelete_tiles"
BEFORE DELETE
ON "tiles"
FOR EACH ROW
BEGIN
DELETE FROM "tile_items" WHERE "tile_id" = OLD."id";
END
��\�\��O 5#�Otriggeroninsert_guild_ranksguild_ranks�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�O!5#�Otriggeronupdate_guild_ranksguild_ranks�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
��\�\��O"5#�Otriggeroninsert_house_listshouse_lists�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�O#5#�Otriggeronupdate_house_listshouse_lists�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
��q$A/�{triggeroninsert_player_depotitemsplayer_depotitems�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�q%A/�{triggeronupdate_player_depotitemsplayer_depotitems�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
��@�@��]&9'�ctriggeroninsert_player_skillsplayer_skills�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�]'9'�ctriggeronupdate_player_skillsplayer_skills�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
��6�6��b(

�itriggeroninsert_player_storageplayer_storage�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�b)

�itriggeronupdate_player_storageplayer_storage�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
��z��z��'*

�striggeroninsert_player_viplistplayer_viplist�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�Y+

�Wtriggeronupdate_player_viplistplayer_viplist�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
��W��F,3!�Atriggeroninsert_tile_itemstile_items�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�F-3!�Atriggeronupdate_tile_itemstile_items�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�].9'�ctriggeroninsert_player_spellsplayer_spells�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
�� }09�/triggeronupdate_players_afterplayers�CREATE TRIGGER "onupdate_players_after"
AFTER UPDATE
ON "players"
FOR EACH ROW
BEGIN
DELETE FROM "player_spells" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id";
DELETE FROM "player_items" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id";
DELETE FROM "player_depotitems" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id";
DELETE FROM "player_storage" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id";
DELETE FROM "player_viplist" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id";
END�]/9'�ctriggeronupdate_player_spellsplayer_spells�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

----FIN DEL VOLCADO----

consulta SQL: Documentación

SQLite format 3��@ ��4��/��)��(.��'+��&)��%'��$%�� player��%a gamemaster��a god�a�� 1��0�� c+�+ Account Manager��n��22�� +Account Manager�� "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, "redskull" BOOLEAN NOT NULL DEFAULT 0, "redskulltime" 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, "direction" INTEGER NOT NULL DEFAULT 0, "loss_experience" INTEGER NOT NULL DEFAULT 10, "loss_mana" INTEGER NOT NULL DEFAULT 10, "loss_skills" INTEGER NOT NULL DEFAULT 10, "premend" INTEGER NOT NULL DEFAULT 0, "online" TINYINT NOT NULL DEFAULT 0, UNIQUE ("name"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"), FOREIGN KEY ("group_id") REFERENCES "groups" ("id") ) ��]tablegroupsgroupsCREATE TABLE "groups" ( "id" INTEGER PRIMARY KEY, "name" VARCHAR(255) NOT NULL, "flags" INTEGER NOT NULL DEFAULT 0, "access" INTEGER NOT NULL, "maxdepotitems" INTEGER NOT NULL, "maxviplist" INTEGER NOT NULL )��ytableaccountsaccountsCREATE TABLE "accounts" ( "id" INTEGER PRIMARY KEY NOT NULL, "password" VARCHAR(255) NOT NULL, "type" INTEGER NOT NULL DEFAULT 1, "premdays" INTEGER NOT NULL DEFAULT 0, "lastday" INTEGER NOT NULL DEFAULT 0, "key" VARCHAR(20) NOT NULL DEFAULT '0', "email" VARCHAR(255) NOT NULL DEFAULT '', "blocked" BOOLEAN NOT NULL DEFAULT 0, "warnings" INTEGER NOT NULL DEFAULT 0, "group_id" INTEGER NOT NULL DEFAULT 1, FOREIGN KEY ("group_id") REFERENCES "groups" ("id") ) ��c��c��{tableplayersplayersCREATE TABLE "players" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "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,�� v��v��PK��-A�indexsqlite_autoindex_players_1players��tableguildsguilds CREATE TABLE "guilds" ( "id" INTEGER PRIMARY KEY, "name" VARCHAR(255) NOT NULL, "ownerid" INTEGER NOT NULL, "creationdata" INTEGER NOT NULL, "motd" VARCHAR(255) NOT NULL DEFAULT '', FOREIGN KEY ("ownerid") REFERENCES "players" ("id") )� ''�Qtableguild_invitesguild_invitesCREATE TABLE "guild_invites" ( `player_id` INTEGER NOT NULL, `guild_id` INTEGER NOT NULL )�x "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") )�2�?tablehouseshouses CREATE TABLE "houses" ( "id" INTEGER PRIMARY KEY, "owner" INTEGER NOT NULL, "paid" INTEGER NOT NULL DEFAULT 0, "warnings" TEXT NOT NULL ) �� O��O%x��S "house_id" INTEGER NOT NULL, "listid" INTEGER NOT NULL, "list" TEXT NOT NULL, FOREIGN KEY ("house_id") REFERENCES "houses" ("id") )�P ''�_tableplayer_deathsplayer_deathsCREATE TABLE "player_deaths" ( "player_id" INTEGER NOT NULL, "time" INTEGER NOT NULL DEFAULT 0, "level" INTEGER NOT NULL DEFAULT 1, "killed_by" VARCHAR(255) NOT NULL DEFAULT '', "is_player" BOOLEAN NOT NULL DEFAULT 1, FOREIGN KEY ("player_id") REFERENCES "players" ("id") )�//�9tableplayer_depotitemsplayer_depotitemsCREATE TABLE "player_depotitems" ( "player_id" INTEGER NOT NULL, "depot_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, FOREIGN KEY ("player_id") REFERENCES "players" ("id") ) �� j��j�cc�� ''�etableplayer_skillsplayer_skillsCREATE TABLE "player_skills" ( "player_id" INTEGER NOT NULL, "skillid" INTEGER NOT NULL, "value" INTEGER NOT NULL DEFAULT 0, "count" INTEGER NOT NULL DEFAULT 0, FOREIGN KEY ("player_id") REFERENCES "players" ("id") )�` ))�{tableplayer_storageplayer_storageCREATE TABLE "player_storage" ( "player_id" INTEGER NOT NULL, "key" INTEGER NOT NULL, "value" INTEGER NOT NULL, FOREIGN KEY ("player_id") REFERENCES "players" ("id") )�}))�5tableplayer_viplistplayer_viplistCREATE TABLE "player_viplist" ( "player_id" INTEGER NOT NULL, "vip_id" INTEGER NOT NULL, FOREIGN KEY ("player_id") REFERENCES "players" ("id"), FOREIGN KEY ("vip_id") REFERENCES "players" ("id") )��tabletilestilesCREATE TABLE "tiles" ( "id" INTEGER PRIMARY KEY, "x" INTEGER NOT NULL, "y" INTEGER NOT NULL, "z" INTEGER NOT NULL ) �� 8��?!!�Itabletile_itemstile_itemsCREATE TABLE "tile_items" ( "tile_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, FOREIGN KEY ("tile_id") REFERENCES "tiles" ("id") )�7%%�1tableplayer_itemsplayer_itemsCREATE 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, FOREIGN KEY ("player_id") REFERENCES "players" ("id") )�E''�Itableplayer_spellsplayer_spellsCREATE TABLE "player_spells" ( "player_id" INTEGER NOT NULL, "name" VARCHAR(255) NOT NULL, FOREIGN KEY ("player_id") REFERENCES "players" ("id") ) �� u��T�tablebansbansCREATE TABLE "bans" ( "type" INTEGER NOT NULL DEFAULT 0, "ip" INTEGER NOT NULL DEFAULT 0, "mask" INTEGER NOT NULL DEFAULT 4294967295, "player" INTEGER NOT NULL DEFAULT 0, "account" INTEGER NOT NULL DEFAULT 0, "time" INTEGER NOT NULL DEFAULT 0, "reason_id" INTEGER NOT NULL DEFAULT 0, "action_id" INTEGER NOT NULL DEFAULT 0, "comment" VARCHAR(60) NOT NULL DEFAULT '', "banned_by" INTEGER NOT NULL DEFAULT 0 )�+�Utriggeroncreate_guildsguilds�CREATE TRIGGER "oncreate_guilds" AFTER INSERT ON "guilds" BEGIN INSERT INTO "guild_ranks" ("name", "level", "guild_id") VALUES ("the Leader", 3, NEW."id"); INSERT INTO "guild_ranks" ("name", "level", "guild_id") VALUES ("a Vice-Leader", 2, NEW."id"); INSERT INTO "guild_ranks" ("name", "level", "guild_id") VALUES ("a Member", 1, NEW."id"); END ��o-�triggeroncreate_playersplayers�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�x/�-triggerondelete_accountsaccounts�CREATE TRIGGER "ondelete_accounts" BEFORE DELETE ON "accounts" FOR EACH ROW BEGIN DELETE FROM "players" WHERE "account_id" = OLD."id"; DELETE FROM "bans" WHERE "type" = 3 AND "account" = OLD."id"; END ��?-�?triggerondelete_playersplayers�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 "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 "bans" WHERE "type" = 2 AND "player" = OLD."id"; UPDATE "houses" SET "owner" = 0 WHERE "owner" = OLD."id"; END ��:+�9triggerondelete_guildsguilds�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"; END�-�Mtriggeroninsert_playersplayers�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; SELECT RAISE(ROLLBACK, 'INSERT on table "players" violates foreign: "group_id"') WHERE NEW."group_id" IS NULL OR (SELECT "id" FROM "groups" WHERE "id" = NEW."group_id") IS NULL; END ��-�Mtriggeronupdate_playersplayers�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; SELECT RAISE(ROLLBACK, 'UPDATE on table "players" violates foreign: "group_id"') WHERE NEW."group_id" IS NULL OR (SELECT "id" FROM "groups" WHERE "id" = NEW."group_id") IS NULL; END�.+�!triggerondelete_groupsgroups�CREATE TRIGGER "ondelete_groups" BEFORE DELETE ON "groups" FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'DELETE on table "groups" violates foreign: "group_id" from table "players"') WHERE (SELECT "id" FROM "players" WHERE "group_id" = OLD."id") IS NOT NULL; END ��2��2i�S��4+�-triggeroninsert_guildsguilds�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�4+�-triggeronupdate_guildsguilds�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�0+�%triggerondelete_houseshouses�CREATE TRIGGER "ondelete_houses" BEFORE DELETE ON "houses" FOR EACH ROW BEGIN DELETE FROM "house_lists" WHERE "house_id" = OLD."id"; END�*)�triggerondelete_tilestiles�CREATE TRIGGER "ondelete_tiles" BEFORE DELETE ON "tiles" FOR EACH ROW BEGIN DELETE FROM "tile_items" WHERE "tile_id" = OLD."id"; END ��\�\��O 5#�Otriggeroninsert_guild_ranksguild_ranks�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�O!5#�Otriggeronupdate_guild_ranksguild_ranks�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 ��\�\��O"5#�Otriggeroninsert_house_listshouse_lists�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�O#5#�Otriggeronupdate_house_listshouse_lists�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 ��q$A/�{triggeroninsert_player_depotitemsplayer_depotitems�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�q%A/�{triggeronupdate_player_depotitemsplayer_depotitems�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 ��@�@��]&9'�ctriggeroninsert_player_skillsplayer_skills�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�]'9'�ctriggeronupdate_player_skillsplayer_skills�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 ��6�6��b(

�itriggeroninsert_player_storageplayer_storage�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�b)

�itriggeronupdate_player_storageplayer_storage�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 ��z��z��'*

�striggeroninsert_player_viplistplayer_viplist�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�Y+

�Wtriggeronupdate_player_viplistplayer_viplist�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 ��W��F,3!�Atriggeroninsert_tile_itemstile_items�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�F-3!�Atriggeronupdate_tile_itemstile_items�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�].9'�ctriggeroninsert_player_spellsplayer_spells�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 �� }09�/triggeronupdate_players_afterplayers�CREATE TRIGGER "onupdate_players_after" AFTER UPDATE ON "players" FOR EACH ROW BEGIN DELETE FROM "player_spells" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id"; DELETE FROM "player_items" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id"; DELETE FROM "player_depotitems" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id"; DELETE FROM "player_storage" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id"; DELETE FROM "player_viplist" WHERE OLD."lastlogin" < NEW."lastlogin" AND "player_id" = OLD."id"; END�]/9'�ctriggeronupdate_player_spellsplayer_spells�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

MySQL ha dicho: Documentación
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLite format 3' at line 1

Mark · Feb 17, 2008

forgottenserver.s3db is for SqLite, it's binary.
For MySQL you should import forgottenserver.sql

Ryu · Feb 18, 2008

so I have to download sql lite.. or where do I get the sql one, because its not in the 2.9 files...

gr33nd3v1l · Feb 18, 2008

Download the server and it should come with it? =\

Oh and use code tags ;D

Ryu · Feb 18, 2008

ok sorry,, I downloaded the server tfs mystic spirit.. but it comes with the s3db format... So what sever do i download

EvulMastah · Feb 18, 2008

Just look in there for `forgottenserver.sql` file... Should be where *.exe is.

Ryu · Feb 18, 2008

I is not in the files i downloaded ...does it work with other versions of tfs.sql.. I mean am using 2.9 but i can use the sql files from 2.4

Ryu · Feb 18, 2008

here is a pic

[/IMG]

Ryu · Feb 19, 2008

btw for some reason I cant opne the .lua file (with note pad)

ragal · Feb 19, 2008

rightclick on config.lua and click open with "Editor"

Ryu · Feb 19, 2008

yes sorry ok i did it.. But still the sql problem from above

Problem with tfs 2.9 sql import

Ryu

New Member

Mark

Administrator

Ryu

New Member

gr33nd3v1l

You see a Green Devil.

Ryu

New Member

EvulMastah

๏̯͡๏﴿

Ryu

New Member

Ryu

New Member

Ryu

New Member

ragal

Member

Ryu

New Member

Similar threads