You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
[8.5] The Forgotten Server v0.2.5 (Mystic Spirit)
- Thread starter Mark
- Start date
- Status
- Not open for further replies.
independentebr
New Member
- Joined
- Jul 21, 2009
- Messages
- 23
- Reaction score
- 0
Some informations!
Hello Everyone!
I'm using TFS 0.3.5pl1 but I have a big problem! My server get crash all time!
My max uptime is: 10h!
TFS 0.2.5 are more stable ???
I use 8.50!
Can somebody give me some information or help me!
Thx!
Have a good day for all
Hello Everyone!
I'm using TFS 0.3.5pl1 but I have a big problem! My server get crash all time!
My max uptime is: 10h!
TFS 0.2.5 are more stable ???
I use 8.50!
Can somebody give me some information or help me!
Thx!
Have a good day for all
Error:
Code:[20/10/2009 11:42:27] Bomb has logged out. [20/10/2009 11:42:27] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 130, `group_id` = 1, `vocation` = 8, `health` = 2015, `healthmax` = 2015, `experience` = 34963300, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 645, `manamax` = 645, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 998, `posy` = 1002, `posz` = 7, `cap` = 3485, `sex` = 1, `lastlogin` = 1256046060, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1256046147, `blessings` = 31 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error [20/10/2009 11:42:27] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 130, `group_id` = 1, `vocation` = 8, `health` = 2015, `healthmax` = 2015, `experience` = 34963300, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 645, `manamax` = 645, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 998, `posy` = 1002, `posz` = 7, `cap` = 3485, `sex` = 1, `lastlogin` = 1256046060, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1256046147, `blessings` = 31 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error [20/10/2009 11:42:27] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 130, `group_id` = 1, `vocation` = 8, `health` = 2015, `healthmax` = 2015, `experience` = 34963300, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 645, `manamax` = 645, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 998, `posy` = 1002, `posz` = 7, `cap` = 3485, `sex` = 1, `lastlogin` = 1256046060, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1256046147, `blessings` = 31 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error [20/10/2009 11:42:27] Error while saving player: Bomb
Database:
Code: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 Cadeia Sorc Cmonty !Pvp De Cao Liike Merasga 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 )‚ „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_invites CREATE 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‡ tablebansbans CREATE 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
What is this?
What is this?
Could be that it couldn't connect to the mySQL database or that characters table its bugged...
Dunno though...its a database problem though
hustlamike
Shit happens.
- Joined
- Dec 23, 2007
- Messages
- 134
- Reaction score
- 0
Anyone know how to make bless work like aol? rep+
hustlamike
Shit happens.
- Joined
- Dec 23, 2007
- Messages
- 134
- Reaction score
- 0
this gunna be updated to 8.53?
this gunna be updated to 8.53?
not this version work on 850
Master Sama
New Member
Please help i downloaded the first one and started it and it says to me that i need some lua file or somethin like that!?
fast help
fast help
Cykotitan
Experienced G'
- Joined
- Nov 4, 2008
- Messages
- 16,892
- Solutions
- 5
- Reaction score
- 849
update it yourself, it's very easy ;sthis gunna be updated to 8.53?
Otserverbrasil
New Member
- Joined
- Nov 13, 2009
- Messages
- 4
- Reaction score
- 0
[ 8.53 ] ? Days ?
- Status
- Not open for further replies.