• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Gesior acc. maker for TFS

Status
Not open for further replies.
Dark Warrior said:
im getting "too many conections"..can you help me fix it.. im using your shop system and your web site "Im not getting it at the start im getting it when theres like 20 useres aprox
Click to expand...
Do you use Shop LUA script from version 0.0.3? Old version has bug (doesn't close connection to database :p ).
New script connect 1 time every login. Maybe it's too much for your pc/database. I'll try to make new script with configurable time between connections. You set: 30 and script connect to database every 30 seconds and get informations about all items for all players then try to give item to player (if is online) or show him msg "ITem from shop is waiting for you. Please blabla...", but actually I must learn polish, math, history... :>
Many popular OTSes use my acc. maker and don't have any problem with database:
http://ots.wypas.eu/
Persoul:
http://persoul.hopto.org/shop/index.php
use my shop script and he had problem with "Too many connections" with old LUA script, but now all is OK.
 
Last edited:
Im not pretty sure but I think when you search for a character, it doesn't say which is his hometown.
Could you add it , please?
 
Jester said:
Im not pretty sure but I think when you search for a character, it doesn't say which is his hometown.
Could you add it , please?
Click to expand...

Code: 
Name:	Nemaneth
Sex:	male
Profession:	Royal Paladin
Level:	67
Residence:	Saund

Actually it does show.
 
Why dont sqlite work whit the site ?
it say like at the install.php that the database is not vailed or something

//Sorry for my bad english
 
attachment.php


i readed the tut, but now i getting an error when i try to upload it:blink:
 

Attachments

what's your error ?
show us your error and we can help you.

(only press at import ,bladeren and after that press at start)
 
well, when i click ok than i get this:

Code: 
Fout
Er is een kans dat u een fout heeft aangetroffen in de SQL parser. Let er goed op, dat de query op de correcte plaatsen quotes heeft. Een ander mogelijkheid voor deze foutmelding kan zijn dat u het ge-quote text gedeelte in binairy mode heeft. U kunt ook uw query proberen in de command line van MySQL. De MySQL server foutmelding hieronder, mocht die aanwezig zijn, kan ook helpen met het opsporen van fouten. Blijft u problemen houden of als de parser fouten geeft terwijl het goed gaat in de command line van MySQL, probeer dan de SQL query in te korten en een bug report met het stukje data te sturen van het CUT gedeelte hieronder:
----Begin KNIP----
eNrtXV9s28YZP4pJ1CpD/6WpmqpZLmgcR43tSHLsNA6CVHGYRIgipZKcLEMDh5YYhzVFKiLl2ikK
zI67YFiB7WkvxboM2PYyYNjLgKIotpeiwDBge9jLXvayhw4b+rKXbcCAZUdSsnjHo0RKcuYo99Vh
JfG74/H77vvd9328OwqFQr4wA2eTcDYFs0JuBianYHIaHk+emJ6KFEvoHIhEilfRiUOZygzU7yg1
sa5L9QlFXpio3a7BZDKZmoSpROKN8URqPDkJk5MzieTM5NQ3oSJVT8JDkcurxbeyM3BqIjExlRQj
c8UCzBfHYPqCkCuNwasCusY1WYUZAZ6YSESuXE7PwNREMjkxFbly8Yp5fixfNIunJqbgtUwuV4pk
07kLM1BVxhvGrfE3Ilb16CAbEryl1auiASfBDsBx4E0IAQAnAE7H0D/O8Z0DPmkn+reH/7H5Mc7/
h/8n/w/+K/6v/F/4P/N/4v/I/57/Lf85/xv+U/5X/C/5n/M/s1kZMWJk0pEJdBg9ig6HxWrtVBx9
GBlFh0Mj6PCU+Y9Hh3Aogo48/wngP+F/x/+NyY0Ro8eBnufCYB+HqKaIq1Ld/OnVUBiM7EQ/iXBR
rEpVUTfQiQMPEaFhdy8fBtHmWa0CDogPf/Rv9LNp/xwyfGb7jBgNMe3ldoNnOZ57NoIwIMmBhw9B
Apm+bf8fAfTHiBGj7UNl7ig4ag7xoRBHUKT1S6T1S7pc1hqqAS+Lqrgo1dEvAPwA/WeS2qwwlQpz
32/XH4lEWuP/VwD9MWLEaIhpD3/UhRMWEEBEh+80NONUTdNX7E8wkysJF4QCzOVLMDeXzcJzwvn0
XLYEE2N4gdWgBe4GKlDW1IpsyJqqN4udzebPbpbBOMVaoJp1Kdi9KiiiUrRFWQ1cSg7YMHFZat1s
Pp8V0jl3gaSzQF2q6EsNRelWKEErZMhVKVDz6qK6NC9XPMo4ORcbslJR5fJSk/dqujB7MV04kpqa
irsvMjpKkbbWMAI1bkGRdF1WF/VApSpyXSqbnSyYajVdn5dWalJdltRyVyEm3YWryAx7KKYvyYqi
BytYq0tVSa0EukFNVWS1dV+lTO46KuZZZC6XeWtOgEdsdlVs9aq4ffp8viBkLuTgJeF6i0e0wWiz
L8VhQTgvFITcrFCEGEvrXpsFNwt4Vr1Y1xq1ThVbDF7VRuKmXxQCXwLwJff34R0R1jkuHN23j7t3
wxCR4dgysY+h2YKQLgmwlD6bFagyc/QTFxhcKWQupwvXTY04+1O7U9ChwMl7SxEDGjHqK8j2fcBS
VVypSDXNkA2p6pN/Wa4psu4FRZH4xp5QOLp/P3d/1ZJkq9u2/s9TpEl2bZ/ypLawJur6u1q94le4
xmqtO1yR6FERV/XAQx8qFKjMkrRK3kSCNlYksMFCqoqy0sMgs6Bo5SWpEmjcfFesq4EHGByPugp9
ixCNA2Vg/m0Rfe8FPhyNxbgfvmcZgZ2a1pv/20ExgeapQVhAEGjpogwCU7AhqiOzIi1LSiCzWtbK
YmC347YkKsbt7qM/pRBCsoDl/Ls3hJuiLS1oldWgzo22dEuSjOCl0O1VgpdCQ54evJQv8JycJouJ
lUo7iPEnxaq46KtPEYX8+JSuIsG7hllKr0lqMAdd1xrB7sfQ3lU72B/CnV0mtoEdLMJnxOhJJNP+
d4JlgP5+yn0eusJfehRXHd+xK5qOcUBWK9KKfkdB4cS82DA06/t807eZTzY/7Fx/dacVbG3ssYMt
Mzei28enacGWdeYRBVsIYtEo78fHKdcly2OpiIboJ3TSjEogv5zi+WKNozi+hBfp8nzXnt4Vjo6O
cmtvtQU/L6vLSF869mW3lxpaDJg2btrXRUPTTQ8R3GwWpjCgVq2Ew9HgWm1V6UP2QTpAJzfDOyTB
2kILSbA+7FZM6inLItbPWIq5rTV0SbePEYoq7DN9WITVkXwIribKwfJkREhYEr5RcmiaeSeMGD3Z
3gmzf0aMmP0zYsSI2T8jRoyeHPvnQR6APDcSWum7urXi087EkZUV8fl8UtYN34y0XIZnJghvBCUT
hOduXJmg9SsRK0W3Me94cjxfkUTjto59ec7zKXKTgZIe2szT+bjzwJPhgj/zNeduSZX5hdUe5ivI
ejOv7HN6IEVVhDR6yKfe27k7HD12jPvgJK6s1owa1w/Pd1IaMQ+nV8VZFc0HzNvpvqquBazVvJ0O
z4jxya2NgI9PRcOoywuNdjKaMh12S7TOvBhGjFgUw4gRI2b/jBgxerLsfwd4B4B3uG+FyvzWzSIH
63u+ZiUD7knO+NJe84R9ecE7rsRWSPUaU1qV+OJcFpWGFHBZo//Ib0viubWbkXA0HufW38OkbGh1
cZH49mIHOdscfQq6veijVyFvpaDef8YS1L0pp6CaC4Lwb3u9BYUvIOpVUKiWboxbIAPPip3N6UWy
rzwbjkaj3Lo9I9KQFUm3Di9R5Gid6GPy14oP8frphXc914AxD4kRIxYhMWLEiNk/I0aMmP0zYsTo
ybB/HnwGwGfcf/k3Hq+2r595Lhw9eJDbyGymYuataTntT1GPpMy81/Qd+6SvROsTMw8HkwklZYZl
udzT5E48H46OjHAbSWcq0jnpyvq8zzsNGWCqVXdNdddSYA350c52nSG1JrxgPbdYz2AZ9ZrkeG5h
fXmlQz7dYugzS+xv4S+bJcaIESMWAzFixIjZPyNGjPq2/xD4GICPQ43t17p7pT3h6N693P3dVoS2
IKq6+S9GicfM32k5DR97P+Ihbi3g5o36UrcCx1Mnj5+cPpE6OTXmChCDbpgcOO8RfLd4SdQ1NejK
LNHajT1oqbJWrbb3o2zFvtOJ7vsAi6rqXJPnfblI/N5TL4ZjR/dxH8wZdXlxUaprqrUpmjTv3NIN
tPpUIXPBrKm1oTrGav8YSZ8vIY5MrigUSjCfo2yeFTkrXMjkrAY32VAL89iWYOau/ERc3s4DjLlX
K45B+iZeV9PZORTut/JVtyWYlcRKq2eNwckxmBOuTRCR/6n/Q9tEeFUuS+N481LbqHmXpepCu2VJ
j5YJuXM2au4xX9GxswlVH2h7w7HxGPfdA2Qvw7dV7tLPsHwN1tEimx0N5+nU06iTa6mpozHaFNox
90TOttDcshlDxg2TCU/lPerWJLdVa1LbqjWT26o1x7dVa6a2VWumm61BsLO28lI4dmw/d298E2Mq
kiKZ25gS7y/wQhmCfRNCzNwyGjOzQklo4wzBhXigkJ69CAv5aw7UsUvB84X8ZWrO+dpFoSB47c5+
Guaz54hbPuVRrcPDc9bp8PBOw0mYzp2jekv0KzWxnAO/Bubf40ffPhO1hp0Pz5Bdwt+wgzN37g84
k0d3KKJCsyVYSGeKwpFCPps9m569NAZHm/rUVGi58tSusixrChoEdfNV9ZK8qM5Qd7u9VdeqWCVO
x2s0brXC7iBHmo0hJp47+hS24amzV+GXpHWeOMwUN/3NU5GOtkCsJnBeiHxORLsUzBdo6wmCGA91
+UfQdnSr3AmJA67b+Rx0wFW7trQYtFicjwgHVbcfMEw5wBCLNr0vNHflnIkSlD1gikKJsivvaZhw
m40fxA2BTwH4lPvXYzbrYuZlK5TcOEmirZ9QEmPtDLUYjwfSYrrCgbStLPKNbqfNQJr6XjhSleRb
4/yiKRadOSskdsKmYqpXd++7ZqvjbezaZw2W9y9vqk9Wdalu+BwscWZcg52DtICDZdPr7GmwJH0s
bERsO5juF+UU7WVRsEmoxd01TrwTy6kUhzq8rxpvXbY5gG6FQPC3B3mIg3zFUC/CwF7o1FUU5Puh
NgWxiZBfAPBF6A+Pb255Y9crpLk1ahX/KRGcGTc3G/wGZG5NJGXmNgiBPIbmtj4Rs4f1g65h3fGG
xW7DuqM5nsO6k2cgARQmBH8qcQdQmGIDRlDewT5xVR8xVBP5doAUAClODj3giz58suOv2sobJwd1
Pz4Zxtp5RPfjkwUbv7Do01fw62FOxOtgerEmbz1SzYl4xwtmTcf3kwppIrkfhWCsnTG/H4XQEW44
FbKW+LqlkPUREt6cb3DpAm/OYNAL3jAe3+lCey9SMz1Cu1liu1RP337t9QPhWDzKre8nb7K9TUGX
W3TM5fa6QyeL7xt0TbrHInZs0n3nmJl7G3Bvh37BZi0MOKrPw3Bs6jVuI08dQeyw0/HRz1jijFU7
DigY4+BGFSxW9vQLsLjZy1UjXmDVk6vmlWalu2rEY1pscMkfJHXlHDF868pdyMdY04+uOgw4w6or
hllbiVm2xD2AyzGmOj52AS7XQOwFXG7GgQCX2xHwMgbcKfAwBnKj9V6MAUuBdzUGcld1HLhe8wCu
YLpyF+oMXH3rig5cQ60rG7heBtzLoQ8Z1DhA586hcCx9jNt4j54/77SnvK+cuutZXOfsupt9gHl2
93NBrx5OPMfz6OKuBYGPICh0rQ/EEOnOCKlNLOPaiza9KvCTvO1bm52ylkOvTRuz3gTcm6EHDKl6
wLYbh8VqDflTJ0e5jbIHvlH2NPWHa86pEV0wDWMdJJ5h0zOGDctujJKaw6EogOZoBX3hVz+a64hd
w6w5G7emATcd+oihkG+0WjgSjp2KcxuyF1LR9gX2iVXOOWLdwArjHShaYTPVhg2uFuKk+gjUCaI+
alF/iNWP+jpD1jCrz56ecReAu6GfPOIpFaOvWx3nvu5h99Rtrv3ZPTZHtYvd47yDtHt8puwwdZyt
lolzbrCHQPDtyB+BNPANxzEIvH7UhsBrHhAYqCdTi/qCwL56ckcIHEat2VumPQPAM9y10IP182Ph
2ORBbiNNohFtP7IuKEQ+JfVCIBffQNDH9YzWS1/Y81oPhREbqfWiMee+Yl31RWxShpnZ+XFSRU1b
CaIiV5HOptWviuhmNbQqujHRJevg3pHMpyfvWHnQzZF3sg7Uj3eufhhKPxCC0AN0oHlr7yeQZmPc
d455TICdF28ZUj3QNFi7CLY+uKe5sEGWq7TnpCiibijaoqw2zx9W0KEtLfI0uf5kwEuAtke7PNYP
bY/G0RZ8bY+W0ZbEPbKWWbB7rEvK0D/s0gr6C8D7gN3O8fcQw+7/ADkIl20=
----Einde KNIP----
----Begin RAW----

ERROR: C1 C2 LEN: 15 16 41765
STR: 

SVN: $Id: sqlparser.lib.php 11123 2008-02-13 13:01:35Z lem9 $
MySQL: 5.0.51a
USR OS, AGENT, VER: Win IE 7.0
PMA: 2.11.5
PHP VER,OS: 5.2.5 WINNT
LANG: nl-utf-8
SQL: SQLite format 3@  7/�)�������������������(.'+&)%'$%
����player%a gamemaster����a goda���
��
1��0
��c++

Account Manager��n22�



��+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")
)
cc��{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,

vv��PK-Aindexsqlite_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
)




OO%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")
)



jj�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_guildsguildsCREATE 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_playersplayersCREATE 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_accountsaccountsCREATE 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_playersplayersCREATE 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_guildsguildsCREATE 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_playersplayersCREATE 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_playersplayersCREATE 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_groupsgroupsCREATE 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
22i�S�4+�-triggeroninsert_guildsguildsCREATE 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_guildsguildsCREATE 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_houseshousesCREATE TRIGGER "ondelete_houses"
BEFORE DELETE
ON "houses"
FOR EACH ROW
BEGIN
    DELETE FROM "house_lists" WHERE "house_id" = OLD."id";
END�*)�triggerondelete_tilestilesCREATE 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_ranksCREATE 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_ranksCREATE 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_listsCREATE 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_listsCREATE 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_depotitemsCREATE 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_depotitemsCREATE 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_skillsCREATE 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_skillsCREATE 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
66��b(;)�itriggeroninsert_player_storageplayer_storageCREATE 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_storageCREATE 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
zz��'*;)�striggeroninsert_player_viplistplayer_viplistCREATE 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_viplistCREATE 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_itemsCREATE 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_itemsCREATE 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_spellsCREATE 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_afterplayersCREATE 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_spellsCREATE 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----Einde RAW----


SQL-query:  

SQLite format 3@ 7/�)�������������������(.'+&)%'$% ����player%a gamemaster����a goda��� ��  1��0 ��c++  Account Manager��n22� ��+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") ) cc��{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,  vv��PK-Aindexsqlite_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_invites CREATE 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 )     OO%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") )    jj�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_guildsguildsCREATE 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_playersplayersCREATE 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_accountsaccountsCREATE 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_playersplayersCREATE 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_guildsguildsCREATE 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_playersplayersCREATE 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_playersplayersCREATE 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_groupsgroupsCREATE 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 22i�S�4+�-triggeroninsert_guildsguildsCREATE 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_guildsguildsCREATE 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_houseshousesCREATE TRIGGER "ondelete_houses" BEFORE DELETE ON "houses" FOR EACH ROW BEGIN DELETE FROM "house_lists" WHERE "house_id" = OLD."id"; END�*)�triggerondelete_tilestilesCREATE 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_ranksCREATE 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_ranksCREATE 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_listsCREATE 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_listsCREATE 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_depotitemsCREATE 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_depotitemsCREATE 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_skillsCREATE 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_skillsCREATE 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 66��b(;)�itriggeroninsert_player_storageplayer_storageCREATE 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_storageCREATE 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 zz��'*;)�striggeroninsert_player_viplistplayer_viplistCREATE 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_viplistCREATE 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_itemsCREATE 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_itemsCREATE 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_spellsCREATE 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_afterplayersCREATE 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_spellsCREATE 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 


#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
 
how do i set up players start with free premium? :blink:
 
Last edited:
Maybe you dont have characters:
Sorcerer Sampel
Knight Sample
...
in database?
Remember to always reinstall acc. maker when you create new database/delete all from database.
Some people don't have this characters even after installation.
----------------------------------------------
//fixed problem with new player position
 
Last edited:
I have changed the pos of all sample character but still It takes me to Venore instead of Thais, How to fix this? And In map editor Town1 is thais.
 
Last edited:
Monte said:
I have changed the pos of all sample character but still It takes me to Venore instead of Thais, How to fix this?
Click to expand...
In file accountmanagement.php find (~490 line in file):
Code: 
$player->setLookLegs($char_to_copy->getLookLegs());
$player->setLookType($char_to_copy->getLookType());
$player->setCap($char_to_copy->getCap());
$player->setLossExperience($char_to_copy->getLossExperience());
$player->setLossMana($char_to_copy->getLossMana());
$player->setLossSkills($char_to_copy->getLossSkills());
and change to:
Code: 
$player->setLookLegs($char_to_copy->getLookLegs());
$player->setLookType($char_to_copy->getLookType());
$player->setCap($char_to_copy->getCap());
$player->setPosX($char_to_copy->getPosX());
$player->setPosY($char_to_copy->getPosY());
$player->setPosZ($char_to_copy->getPosZ());
$player->setLossExperience($char_to_copy->getLossExperience());
$player->setLossMana($char_to_copy->getLossMana());
$player->setLossSkills($char_to_copy->getLossSkills());
and now it will copy position.
 
Here, it does not appear panel ADMIN... and nor of the one to logar in the site with mine of GOD
 
I got now this error,
The Following Errors Have Occurred:
# Wrong characters configuration ("Load vocations" in admin panel, "character to copy" doesn't exist in DB). Try again or contact with admin.
Click to expand...
 
Status
Not open for further replies.

Similar threads

nitrox
[NT ACC] Account Manager in NextJs
Replies
13
Views
1K
Fjorda
F
maxumic
  • Locked
[$50] OTC Advanced Guild Module
Replies
13
Views
2K
Niebieski
Niebieski
Jpstafe
  • Solved
Erro Rook_Sample created(MYACC)
Replies
2
Views
351
Jpstafe
Jpstafe
Back
Top