• 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!

MySQL How to setup MySQL (Answers for the normal errors too) Photos now!

I can't login at the PHP site.

Kan niet inloggen op de MySQL server

"cannot login at the MySQL server".

I changed the password

And still I can't login :S

When are you getting that error? And what operative system are you having?


@Richux Ask your dad or anyone you know that installed your router and set a password. Otherwise, you can just press at the reset button but then you need to configure all connections again because the internet will stop working. If you dont know your router IP, go to this site www.portforward.com. That will help you alot!
 
Hmmm verry simple question how do you run a sql server? I mean i don't find the file to start it...

EDIT: My bad. My virusscanner had removed the Armonia.exe thanks to a torjan that was on it. So problem solved. Thx for the great tutorial btw. Only one small point on the point you have to load in your 'forgotten.sql' please explain nice and clear that it's a file in you tibia server. I was searching in tha xamp file in first place. But just a small point on a bigger fantastic tutorial. Btw i was totaly new to SQL servers. Always runned a XML server. But SQL seems to have more opporunitys (don't mind the spelling)

Thx M8
 
Last edited:
k ive gotten abit further, im at the step where I need to import my database "forgotten.sql". ive been searching thru everything and its not there.. if anyone could upload it I would really appreaciate it.

Thanks
 
Found error:
After selected the database and pressed the ok button get this error:
Talvez tenha encontrado um bug no analizador (parser) do SQL. Analise a sua Consulta SQL com atenção, e verifique se as aspas estão corretas e não estão desencontradas. Outra possibilidade de falha é o fato de estar tentando subir um arquivo com saída binária de uma área de texto citada. Pode também experimentar a sua consulta SQL no prompt de comandos do MySQL. A saída de erro do MySQL, isto se existir alguma, também poderá ajudar a diagnosticar o problema. Se continuar a ter problemas ou se o analisador (parser) falhar onde a interface da linha de comandos tiver sucesso, reduza por favor a entrada da consulta SQL até aquele que causou o problema, e envie o relatório de bug com os dados do chunk da seção CORTE abaixo:
----INICIO CORTE----
eNrtnW1sG+UdwO/8OHHrVC0vLSZUHYdgbUObYCekNOmHkQa3pMtLSdJ2RZqii31NT7F9xue0DfuA
0m5on7ZpwF6AbWKa9gVp4gvSxpdJiAlNmkAaH8bQGNI0MW1D2iZNbBof2HN3dmI7duxrCjH271f3
fGc/z/nuufs/vj7/c3/x6emp6WFtNKaN9mvj8clhLTaoxY7I6VBsMBqemZVvKuHwzFn5zj1jyWHN
fiyV1XO2ketLmfN92YtZLdYfG7pf649Gh3qjsd7YUfnCcH90OHbkUS1lpIe0e8ITyzOPjA9rg32x
voGB3oSVTi9lzPxy+MzMtDY1c1gbORmfnD2snY3LDztnZrSxuHakLxo+PTEyrA04lfpi4dMPn3YK
HJ6acVbU3zeknRubnJwNj49MnhzWsvn5XO9S/kLv0bD7UXJi5g3tgpVL63ltQAkqqqo8qGmKEjiu
lDMh/6oly6rSIB3y727xvFPlh+Ij8aH4l/hA/EX8Sbwr3hZviTfEr8Vr4pfiFfGyeEm8KH4qXnAL
A7Q56g9G5eT5B+Xkuf0L+WPy+dn9Kff5+8Ny8r2jcvLdQTn5TkxOnumTk6d75eSpQ7L24L1yEj0g
Jz37H1uynGrKPfvk5HPdcnL7bjm5+SY5CW+Xk+2dYTkNiHcV8U85AYDW4eaAOKBmddu+bOWSc/nl
rKHsVMVdanJ+7pKRs00r44X/e4r8dn6P9gJorQ6gMv4DO8vCX3XiXxVvK/IBAC3Cfj2dPaYGVXVC
Vc4ZqYSVNrS8pc1eNLQTVm7ByueNjDZj5GQ/cJfXB/xXkQ8AaBNCsntQVcW9BugQryviP+Lv4j3x
lpwFgM8W4Q4Zz8Ggcqr3BREOOvNCzj9/KCyc+YCcf+7FcMCZV+X8t78Zci4PnOF8L/5fVcSH4q/i
D+JNOQsAnxl2dDhR7YV+h7fgxX7QW/CCX3gLXvQHtneoXvi73/9KkFYEaMsLB/m3U71NUW9Tf6H+
O/By4APxK1plRVNDkQMH1JUn8vp8yrDdsZK5hJW5YC6ULQRGp+Mjs3FtduT4eFzzcq5lBbyXtIPh
7d5c2atnR6ZHHx6ZPjgw2KNNTs1qk2fGx7WH4idGzozPagcOHC5WuqSnloxCnbHJ2fjJ+PRqeVno
zOTYI2fi2sH1n9AT7hkKdEYmDqiKmUkaV+zHUmbemNOX8pa7PFe2rXOxskWx4iSgRShy993q1dHS
hkhb+WTJbLB2IzhvVzaBmay9K947l61cKjlXs9xqE0VXa+SNK/lC6dn4l2ZrtGZ5QxXXf1ir9qmy
6QaDnZGxu+s0nbOHqw3nLHSsnO1wT56ri6VtljMSVi5ZttBZu928ApUtV/bqjWw9M23YeT2dbfQc
K92Q6s1XfLVi1c4J2dnACel9wGq7eoshp7MSSlpR0gEh3vyE+4Brt4ZCkZ4e9Wt6+WHMWrm8Xb60
baMD6ZaoGwOnp8cmRqbPa1+Mn9/Egcym9GX5ob6qWPYVX6WXfZV+/MadhVWqeK1bP/CLpfWkXXfl
4Z5rY9tCkX371CcN98jriYS1lMnbxeeuKke7+J6f47w+cjN62qj4augfLPluWGvYQlqvscI5I53U
l+3GmzWl23lZo/EKRlo3UxttTLXDsWgsV1aJVqsRXasyn7ISi0Zxt49PTY3HRyY32rDLei5jZhZ8
7PtCzlrKNhBBsXWd4trRk73cfds7I6P7avVyxdNlLlac2+H0bSFxhyLeF6+JH4snxJeFc9+XfAWg
zdFCXUp3txoM71JVdejI/QNDR7ypcuq+l74RVRT1zs4uJVIskZbdo37BSJlZY7WA1lGyivsH1/6c
L5a4K9il7C2WuKAbqVj/gHw8MDiwthJRspL+waPyERt8QD6cEj9xSwRKSnjvrZVw13G72qXs2iUK
JWLKxx+f6vvN09HCWExI/FwR/xP/EH8WvxdviFflIgA0MdtFxOtyOrvE3mLPEQyL7kJXFXJmvc6m
w5n1Og7hzHp9Q6BD7FJjqvOrCVV85KzyqPcEAO3BA9vCbl/ydUX8TfxR/Fa8Ll4RPxM/Ek/JlwDg
08qJBPeo6qNmJqN0dgUjqjqT1XOLSnhncJ+qTsjveTNzUVe2uW+NLyVMXdm+I9itqqesnDGvK8Kt
Lhd0JeSWeWjJKR9w50ety5cfVzr2BA+p6oj3T39tQs/oC0bO/XXlTZsey60zfrFarjDw0EDJlHHJ
SDUyHFJIVlgJPW9amcY3+aKhp/IX635CtLJGWr/ip5JxJWvkTCOTMHyMhFnW4ryVXK7/OWVVLhhG
3mcVuUtJn1VSRv2BrYoqzs8A6lYZOFJWR08mrYyPEbS0vtDQKVNaI6P7OZJOeZ8H36liZ41MvvGt
sq0lH/uQty5nGgim5hluT1iZpOkEavHQHh+fOr5+gxO6j/F427jib5Q5ZS2YNXoKpyeuVc30s036
JaPegHGsJEeQtBeXUqnGh5iLNZz0hY/MhZ5ZbOB0WVgyU8mMmVj0O7heaFxryccJ72S5bH+j5fN6
SvfVoToJHrOBaB+M9UcdVismzZyRaOR7pb+k87LtucZ7/dLuwq3qt1tyK9mLZipl+64mozGvmxkj
57+qmTfSvmo5CSEj4+Oawsqk5KYV02xjk+dlnY3781zOlNc0PrqunJW2/F01JI2UkfeTC0oadiJn
Zks+pYFoqpXiKea3y7aiR1Y4MTUdHzs56Sb4Dla/1OrRpuMn4tPxydH4TI38YXn2sCfc444NK3cq
8vGM8pr6rPo7ca84t3rJ+q2FcCiyd6/6wufdlKWXB7YLT+EqCcvCW59UvlJu0q7ers7IyN5aKbDC
BszFCjM7V2Z2uPn2q16+fSFlyc5lzs7LC+mFiqVbquxQeYnK/VrLNd7A2yZKb8upcypF159Lq5tU
8/6TY+HOyFRPrQYs3+G5WPnyrVdP7wxFurvVr37Fa07ni8T2prurNZ/7zqd0m0LDeW55TSU777rf
komc4f6TIylPnXplS+5IugHhX3HMqsd/2V5UCf6KWFwX+4d2dUa+0F3zPHCPnDz+7vOeFffXfzd5
dyB1rR37OTNzSVa0yxZuq3UmFAtUnhD1bjApv3DZsFx501as+LBWbTWFfpD7lQHadGyO+Acg/gGA
+AcA4h8AiH8AaOn4DyrvKMo76p6AKt5qnT0bunmj30WXZWUKyZ7iYmTFvMX9lf617pJ8j3OHiV0y
210z1+O+fV2pv/pZHp8Jv41uHKueXKvIEK3PrpVnNtcl165N3ermSZ9cdtvuorVkG7Y3vaNKi3nv
fBr/pYGbNax7O5nuZ5X+fw3r3EZUqPUJpHede+Z83DpkPu7rjhLTz31JuQZvDfT5X0gc2r1R6tY7
meZi3vNerm0A2hfn938d4n1n1v3pf1Gc9D5NA9BSPLhyi5weQ8YG0KwgYwOAzYOMDaCdOwBkbADt
BzI2ANgIZGwALQMyNoC2BBkbAFznhYOCjG09yNiQsSFjQ8aGjA0ZGzI2ZGzI2AC2DmRsANCcIGMD
gM2BjA2gKXIiyNiQsSFjQ8aGjA0ZGzI2ZGzI2JCxIWNDxoaMDRkbMjZkbACwNWNzxD8A8Q8AxD8A
EP8AQPwDQEvHPzI2ZGzI2JCxIWMDgFYBGRtAe4CMDaDJQcYGAJsHGRtAO3cAyNgA2g9kbACwEcjY
AFoGZGwAbQkyNgC4zgsHBRnbepCxIWNDxoaMDRkbMjZkbMjYkLEBbB3I2ACgOUHGBgCbAxkbQFPk
RJCxIWNDxoaMDRkbMjZkbMjYkLEhY0PGhowNGRsyNmRsyNgAYGvG5oh/AOIfAIh/ACD+AYD4B4CW
jn9kbMjYkLEhY0PGBgCtAjI2gPYAGRtAk4OMDQA2DzI2gHbuAJCxAbQfyNgAYCOQsQG0DMjYANoS
ZGwAcJ0XDgoytvUgY0PGhowNGRsyNmRsyNiQsSFjA9g6kLEBQHOCjA0ANgcyNoCmyIkgY0PGhowN
GRsyNmRsyNiQsSFjQ8aGjA0ZGzI2ZGzI2JCxAcDWjM0R/wDEPwAQ/wBA/AMA8Q8ALR3/yNiQsSFj
Q8aGjA0AWgVkbADtATI2gCYHGRsAbB5kbADt3AEgYwNoP5CxAcBGIGMDaBmQsQG0JcjYAOA6LxwU
ZGzrQcaGjA0ZGzI2ZGzI2JCxIWNDxgawdSBjA4DmBBkbAGwOZGwATZETQcaGjA0ZGzI2ZGzI2JCx
IWNDxoaMDRkbMjZkbMjYkLEhYwOArRmbI/4BiH8AIP4BgPgHAOIfAFo6/pGxIWNDxoaMDRkbALQK
yNgA2gNkbABNDjI2ANg8yNgA2rkDQMYG0H4gYwOAjUDGBtAyIGMDaEuQsQHAdV44KMjY1oOMDRkb
MjZkbMjYkLEhY0PGhowNYOtAxgYAzQkyNgDYHMjYAJoiJ4KMDRkbMjZkbMjYkLEhY0PGhowNGRsy
NmRsyNiQsSFjQ8YGAFszNkf8AxD/AED8AwDxDwDEPwC0dPwjY0PGhowNGRsyNgBoFZCxAbQHBRnb
/wGD2G28
----FIM CORTE----
----INICIO CRU----

ERROR: C1 C2 LEN: 15 16 159150
STR:

SVN: $Id: sqlparser.lib.php 12194 2009-01-18 12:20:16Z lem9 $
MySQL: 5.1.33-community
USR OS, AGENT, VER: Win IE 6.0
PMA: 3.1.3.1
PHP VER,OS: 5.2.9 WINNT
LANG: ptbr-utf-8
SQL: SQLite format 3@ BM???샧⃝؃Ӄ΃Ƀă?????????C?@?>?<?:?8?5?1?.?-?+5*0')"$

݀?'password_type!db_version
߀'password_type!db_version
؀؀&MWelcome to The Forgotten Server!
?
ǀ?߃Ӄǀ
J-?
J-?+
J-??
J-??
€?܃σ€ J-? J-?+ J-?? J-?? 

?샅? ''?tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_config?>##?Ctableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd?V''?ktableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
mmπ?))?atableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)?I?etableaccountsaccounts CREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ Cindexsqlite_autoindex_accounts_1accounts
惄?]<  
964396964396J/??0 
massafelipeJ/??0  
454545454545YJ/??0! 
fael123123753J/??0  
258258157157J/??0  
157157157157J/??0 
11?̔0
??ك΃ƒ? massa fael123
964396
454545
258258
1571571?8?7
?ꃞ҃ǃ?????
Zinn Spark
Massinha Lucia Joreba
Jora Dunha Cowwz+Account ManagerT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"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,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
?ā?׃*W?g
?%tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NO- Aindexsqlite_autoindex_players_1players?S ))?atableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);
O)indexsqlite_autoindex_global_storage_1global_storage?P?{tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?indexsqlite_autoindex_guilds_1guilds?&''? tableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id")
)






ڀځӀ9M'indexsqlite_autoindex_guild_invites_1guild_invites?i##?tableguild_ranksguild_ranksCREATE 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")
)?O?ytablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
UNIQUE ("id", "world_id")
)+?indexsqlite_autoindex_houses_1houses
怀<?샦@?;SQLite format 3@ BM???샧⃝؃Ӄ΃Ƀă?????????C?@?>?<?:?8?5?1?.?-?+5*0')"$

݀?'password_type!db_version
߀'password_type!db_version
؀؀&MWelcome to The Forgotten Server!
?
ǀ?߃Ӄǀ
J-?
J-?+
J-??
J-??
€?܃σ€ J-? J-?+ J-?? J-?? 

?샅? ''?tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_config?>##?Ctableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd?V''?ktableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
mmπ?))?atableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)?I?etableaccountsaccounts CREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ Cindexsqlite_autoindex_accounts_1accounts
惄?]<  
964396964396J/??0 
massafelipeJ/??0  
454545454545YJ/??0! 
fael123123753J/??0  
258258157157J/??0  
157157157157J/??0 
11?̔0
??ك΃ƒ? massa fael123
964396
454545
258258
1571571?8?7
?ꃞ҃ǃ?????
Zinn Spark
Massinha Lucia Joreba
Jora Dunha Cowwz+Account ManagerT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"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,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
?ā?׃*W?g
?%tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NO- Aindexsqlite_autoindex_players_1players?S ))?atableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);
O)indexsqlite_autoindex_global_storage_1global_storage?P?{tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?indexsqlite_autoindex_guilds_1guilds?&''? tableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id")
)






ڀځӀ9M'indexsqlite_autoindex_guild_invites_1guild_invites?i##?tableguild_ranksguild_ranksCREATE 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")
)?O?ytablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
UNIQUE ("id", "world_id")
)+?indexsqlite_autoindex_houses_1houses
怀<?샦@?;SQLite format 3@ BM???샧⃝؃Ӄ΃Ƀă?????????C?@?>?<?:?8?5?1?.?-?+5*0')"$

݀?'password_type!db_version
߀'password_type!db_version
؀؀&MWelcome to The Forgotten Server!
?
ǀ?߃Ӄǀ
J-?
J-?+
J-??
J-??
€?܃σ€ J-? J-?+ J-?? J-?? 

?샅? ''?tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_config?>##?Ctableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd?V''?ktableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
mmπ?))?atableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)?I?etableaccountsaccounts CREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ Cindexsqlite_autoindex_accounts_1accounts
惄?]<  
964396964396J/??0 
massafelipeJ/??0  
454545454545YJ/??0! 
fael123123753J/??0  
258258157157J/??0  
157157157157J/??0 
11?̔0
??ك΃ƒ? massa fael123
964396
454545
258258
1571571?8?7
?ꃞ҃ǃ?????
Zinn Spark
Massinha Lucia Joreba
Jora Dunha Cowwz+Account ManagerT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"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,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
?ā?׃*W?g
?%tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NO- Aindexsqlite_autoindex_players_1players?S ))?atableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);
O)indexsqlite_autoindex_global_storage_1global_storage?P?{tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?indexsqlite_autoindex_guilds_1guilds?&''? tableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id")
)






ڀځӀ9M'indexsqlite_autoindex_guild_invites_1guild_invites?i##?tableguild_ranksguild_ranksCREATE 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")
)?O?ytablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
UNIQUE ("id", "world_id")
)+?indexsqlite_autoindex_houses_1houses
怀<?샦@?;SQLite format 3@ BM???샧⃝؃Ӄ΃Ƀă?????????C?@?>?<?:?8?5?1?.?-?+5*0')"$

݀?'password_type!db_version
߀'password_type!db_version
؀؀&MWelcome to The Forgotten Server!
?
ǀ?߃Ӄǀ
J-?
J-?+
J-??
J-??
€?܃σ€ J-? J-?+ J-?? J-?? 

?샅? ''?tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_config?>##?Ctableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd?V''?ktableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
mmπ?))?atableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)?I?etableaccountsaccounts CREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ Cindexsqlite_autoindex_accounts_1accounts
惄?]<  
964396964396J/??0 
massafelipeJ/??0  
454545454545YJ/??0! 
fael123123753J/??0  
258258157157J/??0  
157157157157J/??0 
11?̔0
??ك΃ƒ? massa fael123
964396
454545
258258
1571571?8?7
?ꃞ҃ǃ?????
Zinn Spark
Massinha Lucia Joreba
Jora Dunha Cowwz+Account ManagerT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"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,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
?ā?׃*W?g
?%tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NO- Aindexsqlite_autoindex_players_1players?S ))?atableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);
O)indexsqlite_autoindex_global_storage_1global_storage?P?{tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?indexsqlite_autoindex_guilds_1guilds?&''? tableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id")
)






ڀځӀ9M'indexsqlite_autoindex_guild_invites_1guild_invites?i##?tableguild_ranksguild_ranksCREATE 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")
)?O?ytablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
UNIQUE ("id", "world_id")
)+?indexsqlite_autoindex_houses_1houses
怀<?샦@?;SQLite format 3@ BM???샧⃝؃Ӄ΃Ƀă?????????C?@?>?<?:?8?5?1?.?-?+5*0')"$

݀?'password_type!db_version
߀'password_type!db_version
؀؀&MWelcome to The Forgotten Server!
?
ǀ?߃Ӄǀ
J-?
J-?+
J-??
J-??
€?܃σ€ J-? J-?+ J-?? J-?? 

?샅? ''?tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_config?>##?Ctableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd?V''?ktableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
mmπ?))?atableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)?I?etableaccountsaccounts CREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ Cindexsqlite_autoindex_accounts_1accounts
惄?]<  
964396964396J/??0 
massafelipeJ/??0  
454545454545YJ/??0! 
fael123123753J/??0  
258258157157J/??0  
157157157157J/??0 
11?̔0
??ك΃ƒ? massa fael123
964396
454545
258258
1571571?8?7
?ꃞ҃ǃ?????
Zinn Spark
Massinha Lucia Joreba
Jora Dunha Cowwz+Account ManagerT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"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,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
?ā?׃*W?g
?%tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NO- Aindexsqlite_autoindex_players_1players?S ))?atableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);
O)indexsqlite_autoindex_global_storage_1global_storage?P?{tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?indexsqlite_autoindex_guilds_1guilds?&''? tableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id")
)






ڀځӀ9M'indexsqlite_autoindex_guild_invites_1guild_invites?i##?tableguild_ranksguild_ranksCREATE 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")
)?O?ytablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
UNIQUE ("id", "world_id")
)+?indexsqlite_autoindex_houses_1houses
怀<?샦@?;SQLite format 3@ BM???샧⃝؃Ӄ΃Ƀă?????????C?@?>?<?:?8?5?1?.?-?+5*0')"$

݀?'password_type!db_version
߀'password_type!db_version
؀؀&MWelcome to The Forgotten Server!
?
ǀ?߃Ӄǀ
J-?
J-?+
J-??
J-??
€?܃σ€ J-? J-?+ J-?? J-?? 

?샅? ''?tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_config?>##?Ctableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd?V''?ktableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
mmπ?))?atableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)?I?etableaccountsaccounts CREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ Cindexsqlite_autoindex_accounts_1accounts
惄?]<  
964396964396J/??0 
massafelipeJ/??0  
454545454545YJ/??0! 
fael123123753J/??0  
258258157157J/??0  
157157157157J/??0 
11?̔0
??ك΃ƒ? massa fael123
964396
454545
258258
1571571?8?7
?ꃞ҃ǃ?????
Zinn Spark
Massinha Lucia Joreba
Jora Dunha Cowwz+Account ManagerT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"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,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
?ā?׃*W?g
?%tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NO- Aindexsqlite_autoindex_players_1players?S ))?atableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);
O)indexsqlite_autoindex_global_storage_1global_storage?P?{tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?indexsqlite_autoindex_guilds_1guilds?&''? tableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id")
)






ڀځӀ9M'indexsqlite_autoindex_guild_invites_1guild_invites?i##?tableguild_ranksguild_ranksCREATE 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")
)?O?ytablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
UNIQUE ("id", "world_id")
)+?indexsqlite_autoindex_houses_1houses
怀<?샦@?;----FIM CRU----


consulta SQL:

SQLite format 3@ BM???샧⃝؃Ӄ΃Ƀă?????????C?@?>?<?:?8?5?1?.?-?+5*0')"$  ݀?'password_type!db_version ߀'password_type!db_version ؀؀&MWelcome to The Forgotten Server! ? ǀ?߃Ӄǀ J-? J-?+ J-?? J-?? €?܃σ€ J-? J-?+ J-?? J-??   ?샅? ''?tableserver_configserver_configCREATE TABLE "server_config" ( "config" VARCHAR(35) NOT NULL DEFAULT '', "value" INTEGER NOT NULL, UNIQUE ("config") )9M'indexsqlite_autoindex_server_config_1server_config?>##?Ctableserver_motdserver_motdCREATE TABLE "server_motd" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "text" TEXT NOT NULL DEFAULT '', UNIQUE ("id", "world_id") )5I#indexsqlite_autoindex_server_motd_1server_motd?V''?ktableserver_recordserver_recordCREATE TABLE "server_record" ( "record" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL, UNIQUE ("record", "world_id", "timestamp") )9M'indexsqlite_autoindex_server_record_1server_record mmπ?))?atableserver_reportsserver_reportsCREATE TABLE "server_reports" ( "id" INTEGER PRIMARY KEY, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL DEFAULT 0, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL DEFAULT 0, "report" TEXT NOT NULL DEFAULT '', "reads" INTEGER NOT NULL DEFAULT 0 )?I?etableaccountsaccounts CREATE TABLE "accounts" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "password" VARCHAR(255) NOT NULL, "premdays" INTEGER NOT NULL DEFAULT 0, "lastday" INTEGER NOT NULL DEFAULT 0, "email" VARCHAR(255) NOT NULL DEFAULT '', "key" VARCHAR(20) NOT NULL DEFAULT '0', "blocked" BOOLEAN NOT NULL DEFAULT 0, "warnings" INTEGER NOT NULL DEFAULT 0, "group_id" INTEGER NOT NULL DEFAULT 1, UNIQUE ("name") )/ Cindexsqlite_autoindex_accounts_1accounts 惄?]<   964396964396J/??0  massafelipeJ/??0   454545454545YJ/??0!  fael123123753J/??0   258258157157J/??0   157157157157J/??0  11?̔0 ??ك΃ƒ? massa fael123 964396 454545 258258 1571571?8?7 ?ꃞ҃ǃ????? Zinn Spark Massinha Lucia Joreba Jora Dunha Cowwz+Account ManagerT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "group_id" INTEGER NOT NULL, "account_id" INTEGER NOT NULL, "level" INTEGER NOT NULL DEFAULT 1, "vocation" INTEGER NOT NULL DEFAULT 0, "health" INTEGER NOT NULL DEFAULT 100, "healthmax" INTEGER NOT NULL DEFAULT 100, "experience" INTEGER NOT NULL DEFAULT 0, "lookbody" INTEGER NOT NULL DEFAULT 10, "lookfeet" INTEGER NOT NULL DEFAULT 10, "lookhead" INTEGER NOT NULL DEFAULT 10, "looklegs" INTEGER NOT NULL DEFAULT 10, "looktype" INTEGER NOT NULL DEFAULT 136, "lookaddons" INTEGER NOT NULL DEFAULT 0, "maglevel" INTEGER NOT NULL DEFAULT 0, "mana" INTEGER NOT NULL DEFAULT 100, "manamax" INTEGER NOT NULL DEFAULT 100, "manaspent" INTEGER NOT NULL DEFAULT 0, "soul" INTEGER NOT NULL DEFAULT 0, "town_id" INTEGER NOT NULL, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "conditions" BLOB NOT NULL, "cap" INTEGER NOT NULL DEFAULT 0, "sex" INTEGER NOT NULL DEFAULT 0, "lastlogin" INTEGER NOT NULL DEFAULT 0, "lastip" INTEGER NOT NULL DEFAULT 0, "save" BOOLEAN NOT NULL DEFAULT 1, "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, "balance" INTEGER NOT NULL DEFAULT 0, "stamina" INTEGER NOT NULL DEFAULT 151200000, "direction" INTEGER NOT NULL DEFAULT 2, "loss_experience" INTEGER NOT NULL DEFAULT 100, "loss_mana" INTEGER NOT NULL DEFAULT 100, "loss_skills" INTEGER NOT NULL DEFAULT 100, "loss_containers" INTEGER NOT NULL DEFAULT 100, "loss_items" INTEGER NOT NULL DEFAULT 100, "premend" INTEGER NOT NULL DEFAULT 0, "online" TINYINT NOT NULL DEFAULT 0, "marriage" INTEGER NOT NULL DEFAULT 0, "promotion" INTEGER NOT NULL DEFAULT 0, "deleted" BOOLEAN NOT NULL DEFAULT 0, "description" VARCHAR(255) NOT NULL DEFAULT '', UNIQUE ("name", "deleted"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id") ) ?ā?׃*W?g ?%tableplayersplayers CREATE TABLE "players" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NO- Aindexsqlite_autoindex_players_1players?S ))?atableglobal_storageglobal_storageCREATE TABLE "global_storage" ( "key" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "value" VARCHAR(255) NOT NULL DEFAULT '0', UNIQUE ("key", "world_id") ); O)indexsqlite_autoindex_global_storage_1global_storage?P?{tableguildsguildsCREATE TABLE "guilds" ( "id" INTEGER PRIMARY KEY, "world_id" INTEGER NOT NULL DEFAULT 0, "name" VARCHAR(255) NOT NULL, "ownerid" INTEGER NOT NULL, "creationdata" INTEGER NOT NULL, "motd" VARCHAR(255) NOT NULL DEFAULT '', UNIQUE ("name", "world_id"), FOREIGN KEY ("ownerid") REFERENCES "players" ("id") )+?indexsqlite_autoindex_guilds_1guilds?&''? tableguild_invitesguild_invitesCREATE TABLE "guild_invites" ( "player_id" INTEGER NOT NULL, "guild_id" INTEGER NOT NULL, UNIQUE ("player_id", "guild_id") )       ڀځӀ9M'indexsqlite_autoindex_guild_invites_1guild_invites?i##?tableguild_ranksguild_ranksCREATE 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") )?O?ytablehouseshousesCREATE TABLE "houses" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "owner" INTEGER NOT NULL, "paid" INTEGER NOT NULL DEFAULT 0, "warnings" INTEGER NOT NULL DEFAULT 0, "lastwarning" INTEGER NOT NULL DEFAULT 0, "name" VARCHAR(255) NOT NULL, "town" INTEGER NOT NULL DEFAULT 0, "size" INTEGER NOT NULL DEFAULT 0, "price" INTEGER NOT NULL DEFAULT 0, "rent" INTEGER NOT NULL DEFAULT 0, UNIQUE ("id", "world_id") )+?indexsqlite_autoindex_houses_1houses 怀<?샦@?;

Mensagens do MySQL :

#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


Edit....

I'm Using latest xampp version {1.7.1}
I'm Using latest TFS 0.3.4 pl2
I'm Will use gesior account maker
 
Found error:
After selected the database and pressed the ok button get this error:



Edit....

I'm Using latest xampp version {1.7.1}
I'm Using latest TFS 0.3.4 pl2
I'm Will use gesior account maker


Use the 1.6.6 xampp version and it will work.
 
Hello , I have problem.

It's my xampp.

nyv4om.jpg


And this is localhost
nv6vq9.jpg


What is wrong? =))
 
Nice tutorial...
It will help many people ;D

But maybe you can help me with this:
How can I make a database's backup?

Cya ;D
 
Hello , I have problem.

It's my xampp.

nyv4om.jpg


And this is localhost
nv6vq9.jpg


What is wrong? =))


Make sure you are not using IIS (Another type of web server manager)

And make sure that you dont have started the "xampp_start" while trying to start the xampp via the xampp control panel.
 
Back
Top