SQLite format 3 @ Ù 0 ¡ *ûöñìçâÝØÓÎÉÄ¿ºµ°«¦¡ )/ (, '* &( %& $$ #" " !
¸ ¸Ëé player %a gamemaster ÿÿÿÿ a god aÿŸø
ˆ 檧æIˆ*ÇŠÇh žîF
852456 JÝß20 Âd
henrike JÝÜÚ0 ¹ù
catano JÝψ0 !’·D %
levynogueira JÝÎ30 ¶…|
775500 JÝÚ0 ¤¯w
575757 JÝÍ0 ”½
225500 JÝÚê0 ð”f
linniker JÝÉ0 ¼¤
2776980 JÝÁE0 †ƒM
2776980 0 ¼¦S
987987 JÝðy0
1 ÿÿJÝðs0 û ,û +
T ìãs‡cÔÁ¡«T’·~ !Mlk Zicaas
#Dee Enfoder
CadeiaSorc
Cmonty !Pvp De Cao LiikeMerasga Soorc)Knight Thunder!EauhsauhsaBomb+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")
)
4 4Ñ {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, -A indexsqlite_autoindex_players_1players
¥ÄPK ))Atableglobal_storageglobal_storage CREATE TABLE "global_storage"
(
"key" INTEGER NOT NULL,
"value" INTEGER NOT NULL
)‚„tableguildsguildsCREATE 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##ƒ7tableguild_ranksguild_ranks
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")
)2 ‚?tablehouseshousesCREATE TABLE "houses" (
"id" INTEGER PRIMARY KEY,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" TEXT NOT NULL
)
O O%x S
##‚mtablehouse_listshouse_listsCREATE TABLE "house_lists" (
"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")
)
o æѼ*‹o %
JÝàH ‚Black Knight
JÝ×Ù ‚Soorc%JÝÖU ‚Black Knight JÝÐH ‚SoorcJÝÏ ‚Soorc!JÝÎÆ ‚Pvp De Cao
û .û -N
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);
ENDx/ƒ-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;
END0+‚%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
* „}19‰/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‚]09'„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
F “ F'·Pç€ ¬ d+
BombS ‚ßßdDLN' € …… dèè
f +
Cmonty| ‚dDLN' € oo dèè w
j+ !
Pvp De Cao›Ä ‚dDLN' € oo dèè w
e+
Liike
‚ü ‚}}dDLN' € II dèè ;
g+
Merasga ÷ ‚}}dDLN' ˆ II dèè ;
e+
SoorcŒ ‚dDLN' € oo dèè w
n+ )
Knight Thunder<
f ‚ßßdDLN' € …… dèè
j+ !
Eauhsauhsa ‚ßßdDLN' € …… dèè
k+ +
Account Manager – – n èè JÝðt
Y š2ÅY j
+ !
Mlk Zicaas·F ‚dDLN' € oo dèè w
k+ #
Dee Enfoder!d ‚dDLN' € oo dèè w
f+
Cadeia
‚ü ‚dDLN' € oo dèè w
d
+
Sorc
‚ü ‚dDLN' € oo dèè w
N ¦ õêßÔɾ³¨’‡|qf[PE:/$øíâ×ÌÁ¶«*•Šti^SH=2'ûðåÚÏĹ®£˜‚wlaVK@5* þ ó è Ý Ò Ç ¼ ± ¦ N
M
L
K
J
I
H
G
F
E
D
C
B
A
@
?
>
=
<
;
:
9
8
7
6
5
4
3
2
1
0
/
.
-
,
+
*
)
(
'
&
%
$
#
"
!
¾ õêßÔɾ T
S
R
Q
P
O