Ir para conteúdo

Site Para Poketibia Versões 8.5X


bruno333

Posts Recomendados

# Revolution Website #



 

Nome: Revolution Website

Versão: 8.5+

Autor: Bruno333

Coméntario:

Bom, eu vi que tem varios Poketibia e nenhum site , então resolvi fazer um bom, leve e pratico!

 

*lembrando que eu,uso como base o site do Nicaw SVN 19b

 



Configurando o site:


Primeiro passo e acessar o phpmyadmin (http://localhost/ ou http://localhost:8090)

Entre na sua conta do PhpMyAdmin, "Root" "sua senha"

Agora cria uma database (coloque um nome mais simples que puder, aconselho coloca o nome de "tibia")

agora la em cima no menu tem o butão [iMPORTAR]
Clique ele!

Depois irar aparecer uma pagina, com um butão chamado PROCURAR, clique e va até a pasta do seu ot.. e importa a database do ot. Caso não tenho pode baixar Clicando aqui[/url]

Agora continuando no [iMPORTAR] vc deve importar agora a database no NICAW ACC, que se encontra na pasta
xampp/htdocs/documents
nome do arquivo eh shema.mysql (database do nicaw)
Podemos fechar o internet explorer e configurar logo!

va a pasta Xampp/htdocs/config.inc
e abra ele!

 

Vamos agora configurar:

 

# Set data directory of your OT server



$cfg['dirdata'] = 'C:\otserv\data;

 

$cfg['house_file'] = 'world/map-house.xml';

 

# MySQL server settings

$cfg['SQL_Server'] = 'localhost';

$cfg['SQL_User'] = 'root';

$cfg['SQL_Password'] = '123456';

$cfg['SQL_Database'] = 'tibia';

 

 

Configurando:

Onde a pasta data do seu ot está localizado



entre na pasta data/world do seu ot e ve o arquivo que ta no final com house.xml e coloque no lugar do map-house.xml

senha do seu phpmyadmin!

Nome da tua database, aconselho colocar a database com nome de tibia!! ai so colocar como está ai em cima!

Agora feche e salve..

 

Va a pasta do seu ot

abra config lua e aperte ctrl + f e procure por root la vc encontrara tpw assim:

 

sql_host = "localhost"



sql_user = "root"

sql_pass = "SUA SENHA"

sql_db = "COLOQUE O NOME DA TUA DATABASE"

 



* só lembrando galera que o site eu ia usar em meu servidor então tem certas funções que esta configurada para meu servidor mais quem tem um conhecimento minimo consegue de boa fazer as devidas mudanças!

 

SS

siteou.png

 

Agora o mais importante de tudo o Download e Scan !!!

 

Bom galerinha do Xtibia é isso ai, espero que gostem do meu Website qualquer Duvida ou Bug's postem aqui



 

Não se esqueça de quem gostou da um +Repp que não vai cair a mão tbem !!!

Link para o comentário
Compartilhar em outros sites

  • Respostas 63
  • Created
  • Última resposta

Top Posters In This Topic

afs cara não seu tutorial tah Incrivel!!! não sei o que deu acho que fiz besteira agora não quer entra no http://localhost/phpmyadmin/

fala assim:

Erro

Mensagens do MySQL :

 

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Conexão para controle do usuário como definido nas configurações falhou.

phpMyAdmin tentou se conectar no servidor MySQL e a conxão foi recusada. Você deve checar o servidor, nome de usuário e senha no config.inc.php e se certificar que correspondam com as informações fornecidas pelo administrador do servidor MySQL.

 

:cry:

sabe como arruma :sad:

 

há cara deixa já vouto ao normal ^^ mas eo seguinte na parte do database eu vo em inportar e escolho o arquivo

forgottenserver.s3db ai tobo em executar e da erro aparece :

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----
eNrtnF1sG0kBx2d2HLvZVi0fd3Uh19NWrZpETYLXrtM0VSXc4OaiS5zWSfp1cL6NvU2XrHfd3XWb
IHH0AxAvSMADvCAdnE6VECDuherEC0LAAy/wwAnxAAL14Q4KQgcPPXQndMzu2ontfNjbjxDs/y/K
eNc7szs7OzOezDi/dDY7nR2VxmRpLC5NpjOjkpyU5GFpJDkix8SZWX6MiOLMOX7g0ERhVLKv6iXF
slVrSNfmh0pXSpKckOVjUjwWOz4oy4Nu6sRoMjaaiF+SdLV4XDokTi3PnJ0clZJD8tBRWZybyUrT
MwNSajydmR2QzqX5Jc5rhjSTOp3KTvBYsaFk4qh4Zio1KiWG4kN887kzbrSB6Rn3JIkhWTo/kcnM
ipOpzPioVHLmrcGyc3lwRPQuwwPNUaXLplVUHClBQoRS8klJIiT8HVLPVf5La/YpaZEu/vsMc9xN
lb3PHrB/sr+zt9k99kf2e/Zb9mv2K/YL9lP2E/Zj9jr7PrvDvsu+zb7FvsG+yr7CbrOX2bKfGIA2
oXCOB/k5HszP8EA5w4OXMjzIPc+DFyd48JlxHnw6zYMXxnhwKcWDi4cXnBP89cIoD84d48HcUR6c
SvDAPSTz12MDPIj38WDoIA/6JfeYUiyd2M83DnycB8/u5cG+p3jw4T08ELt50B0WeSiwPxP2Dg8A
AG3FboEdoKqRt5ZLjmYaZDfl+4X53DXVsvl+1G//9wj/dL6H0gKg7XqAug5A2F3X/qnf/t8gfEz+
BsoKgP8PnhVClJ4UyHlVz5tFVXJMqWQuqkXTkAqKfeWAN/anPM4UrY0ze0WVTpvWguk4qiHNqBbv
Bw74fcA7hP2bBwCAtibCuwUqEMF7pcQbAzD2J8LeZX/jLwCA9kFkvJ2HBDJ18u5nRXfYEKJkavj9
30Xc4YE7ne+3/z8Q9oD9lb8AANqEXV1ue/cbP/N3/NYvdHdRv/l7n/8khLICoCMHCPw3THcQuoP+
iN4XXhfeZr/sxHK4eYhGor299FbEUeZ11fZmR3J507isLdTtCGPZdGo2Lc2mTk2mpcNXy6Zzoi6C
/5bUJ3b7W3Xvnktlx55LZfsSyX4pMz0rZeYmJ6VPpU+n5iZnpd7egWqia4peVitpJjKz6fF0diU+
jzSXmTg7l5b61l6hX+w/LoSjU72UaEZBXbKv6pqj5pSyY3r7ubq85uS6XXZzjEWiBw/SW1O1pVA0
nULNZmjjEnAPN96/Vtj4Pvwj101LL+Q2jLdSPrGVFI665FRiz6YvzG5QlPWlVD3/gLTeVXm5JUPh
6MTBJuXm3uFKqbk7XTdf6PJrTrm2zCw1b1qFup3wxuXmR2gsubp3H2fpaUXVdpRiqdUKVpuR9Yuv
+m7Dqd3aGG6hNvoXWClXfzfi/W1CzhNynr7LfvPYmvrt/ZFItL+ffqnhgZVMy7Hr93Zs9si8GE1r
+5nsxFQqe1F6Pn3xER5ZSVeW+UUDJTHtpUCxlwPF/tzjq2/rJPFLt3kTr8ZWCnbTk4v9t+d2RKL7
99Mvf9578ko+b5YNx66+7lznaVePBXnOa9uooRTVhk+AeLLmI2C1YBXbvr7a6JtEttRiQVm2Wy9W
XbEdnqL1BGpR0fTNMrPe41hUlxuTxNZLEVtNMq+b+UW1etunpqcn06nMZhm7rliGZiwEuPcFyyyX
WmhB8prub/Xp8f7sE93h6Nj+jfqzanXJydWtXW4vRtlbhL3FXmGvYMQJwPZivOdjNCTuoZTKx0eS
w/KwHHd/yJT7Bct9vTH/i8+HenoqseKJ+LCcHHFfYsmRS160hOlG20d3kj17WOVkMvngg6mTd+/E
KvMslL1H2HvsH/i2FQDtOOFa6RkEd7vSl7AutofKlfZ/g7AbAv9BUYGthpKn3aV/Kgje0r9AfQSB
7hJoyFsQEL0FwlXETLlo82rL6+/gi7G9Pa/+6zXvVHwUS8OEx+0KkQj9GvU/KPsIudVFfuh+Vnpv
PDNHSLdw9AcCKXCq2bgRPBeTyiLPhcBzEdvLc/Ga87NqLoQwCdFQiP0nXM3FyIOGXBzWnRN33YxM
DFYy4h56mR4lR6pXrs2Iez2eEe/6Im3ISMof00tTiqEsqBYJu2so3+Q/XvnGKncYj/MycRdd7vCj
X1hZi9n7knf5wsq0K2X3CbvP3mRvonIC0AbspV6PyfjmTup1W8LTId7PNHYcbhf0oZanJlbiVeYU
Woipq9dUvZWZjspyg5lX3G+Itz6bckVVdOdK0yvEGlMUlaUgidSlkmppqpFXA0xymebivFlYbn6d
uiSXVdUJmITfUiFgEl1tPmfVkMRZLjW9ezkxXJdGKRRMI8DkWFFZaKnK1KYwlCBP0o0f8OG7SeyS
ajit58o2ywHuwTGvGy00pu0zk543jYLmNtTqoz01OX1qbYbzSoCpdltdCjaBrJsLmhEoids1OlqQ
PCnX1GZzwau9l71Y1gM8dS+6uyYRYDlCMRZbqCgLZU0vGFp+MeiMeaVYzXKAqu4uXdnBpsDnFV0J
1JW6qzZaC+08KcdjLisJC5ql5lv5RInXdFu2nWu9v6/tKLykQTskL5G9qOm6HTgZb4eOohmqFTyp
5qjFQKncVR7VCLDwZxo6z1p17Wwic5Gn2bwntyyND0sCdFqWWTSDjRcKqq46QRZ4Cqqdt7RSzVVa
aE0brdtUl6frctHPE5yezqYnxjPeql3f+oOsfimbPp3OpjNj6ZkNFgXrlwT7xX7vWzXkBv9rl/r/
jDMnfE/4C/v5Vo5Fvx4VI9GeHvpql7fY6a8g25UXcZ2lzsqhLVrpbHUNnN/JnsGd4WiqZ6M1t0q+
c3JlY/ets7si0SNH6Bcv1i7z5q5pJV3jPVr97kc2XvStRmkskdaH4Y9/oX9NJW/MzIC07omeWGVf
/7yNV1972obatqYJnRTD0bNHmqyzVp/QynJr9Y2P3ryw2/uSx61Frw4s6Cb/8MvZjmnxnq5+76l1
akB9jMYKsLrA/RiffO1Xvpp0dbG1fd1Kljb8etMJiH8A2HIg/gEAbCEQ/wDQ0T0AxD8AtBkQ/wAA
HgaIfwDoGCD+AaBDgfgHALDpAIFA/OMC8Q/EPxD/QPwD8Q/EPxD/QPwD8Q8AnQHEPwCAR59whfgH
bFcg/oH4BwDw5ID4B+IfiH8g/oH4B+IfiH8g/oH4B+IfiH8g/oH4B+IfiH8g/gGdB8Q/AIAtBOIf
ADq6B4D4B4A2A+IfAMDDAPEPAB0DxD8AdCgQ/wAANh0gEIh/XCD+gfgH4h+IfyD+gfgH4h+IfyD+
AaAzgPgHAPDoE64Q/4DtCsQ/EP8AAJ4cEP9A/APxD8Q/EP9A/APxD8Q/EP9A/APxD8Q/EP9A/APx
D8Q/oPOA+AcAsIVA/ANAR/cAEP8A0GZA/AMAeBgg/gGgY4D4B4AOBeIfAMCmAwQC8Y8LxD8Q/0D8
A/EPxD8Q/0D8A/EPxD8AdAYQ/wAAHn3CFeIfsF2B+AfiHwDAkwPiH4h/IP6B+AfiH4h/IP6B+Afi
H4h/IP6B+AfiH4h/IP6B+Ad0HhD/AAC2EIh/AOjoHgDiHwDaDIh/AAAPA8Q/AHQMEP8A0KFA/AMA
2HSAQCD+cYH4B+IfiH8g/oH4B+IfiH8g/oH4B4DOAOIfAMCjT7hC/AO2KxD/QPwDAHhyQPwD8Q/E
PxD/QPwD8Q/EPxD/QPwD8Q/EPxD/QPwD8c//XPzzX/K6LCU=
----FIM CORTE----
----INICIO CRU----
ERROR: C1 C2 LEN: 15 16 85810
STR: 

SVN: $Id: sqlparser.lib.php 13117 2009-11-15 13:50:32Z lem9 $
MySQL: 5.1.41
USR OS, AGENT, VER: Win SAFARI 5.0.534
PMA: 3.2.4
PHP VER,OS: 5.3.1 WINNT
LANG: ptbr-utf-8
SQL: SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_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[''utableserver_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
WW))utableserver_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
)U}tableaccountsaccountsCREATE 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
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"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,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" 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")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_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")
);SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_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[''utableserver_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
WW))utableserver_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
)U}tableaccountsaccountsCREATE 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
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"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,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" 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")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_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")
);SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_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[''utableserver_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
WW))utableserver_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
)U}tableaccountsaccountsCREATE 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
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"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,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" 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")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_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")
);SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_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[''utableserver_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
WW))utableserver_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
)U}tableaccountsaccountsCREATE 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
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"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,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" 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")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_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")
);SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_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[''utableserver_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
WW))utableserver_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
)U}tableaccountsaccountsCREATE 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
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"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,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" 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")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_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")
);
----FIM CRU----

consulta SQL:

SQLite format 3@ qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!  !encryption!db_version !encryption!db_version =Welcome to pokemon dash!&MWelcome to The Forgotten Server!   M=j M6 M=jM6	  $''tableserver_configserver_configCREATE TABLE "server_config" ( "config" VARCHAR(35) NOT NULL DEFAULT '', "value" INTEGER NOT NULL, UNIQUE ("config") )9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_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[''utableserver_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 WW))utableserver_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 )U}tableaccountsaccountsCREATE 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 G 1985616121212M>'0$ 23261582326058ZM>3o0 11M=0 232615819856161   Nums1-^0M>(M>U	4dddd  Laks100tM>8M>< I-dddd~4+   Account Manager022M=`ddddd NumsLaks+Account Manager0, "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, "skull" INTEGER NOT NULL DEFAULT 0, "skulltime" 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") ) &U tableplayersplayers CREATE TABLE "players" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" ( "account_id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL, UNIQUE ("account_id", "player_id"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id") )= Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_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") );

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 

 

sabe como arruma isso??

Link para o comentário
Compartilhar em outros sites

homens me venda un erro cuando creo la cuenta por la pagina venda me la pokebag y en el suelo y la sem recojer puedo cuando me la creo gerente de conta con el me venda do todo bien ayudaaaa

Link para o comentário
Compartilhar em outros sites

@XmaximoX

 

você esta tentando importa o banco de dados sqlite

 

esse site não tem suporte para sqlite ... somente para Mysql

por isso esta dando esse erro ai

 

vlw espero ter ajudado !!!

Link para o comentário
Compartilhar em outros sites

  • 2 weeks later...

Percebi ai a dúvida de muita gente em relação ao database, é o seguinte, você não vai utilizar o database "forgotten.s3db" pelo fato de phpmyadmin não reconhecer sqlite, então o database que vocês irão importar pode ser encontrado no seguinte diretório:

"PASTA-DO-SEU-OT/schemas/mysql.sql". Nesse site também é necessário importar o banco de dados do próprio site, para executar suas funcções como adicionar novas notícias e etc... Para isso você vai no diretório: "PASTA-DO-SITE/documents/schema.sql" e importa esse arquivo no mesmo banco de dados da importação anterior.

 

Na pasta do site você abre o arquivo config.inc.php, e em database ele vai pedir o nome do banco de dados e não o nome do arquivo, não vá confundir... "Mas e aonde eu vejo o nome do banco de dados?" vai no seu phpmyadmin logo na página inicial tem um local pra você criar seu banco de dados e importar o arquivo ".SQL" esse nome será o que você irá colocar lá.

 

//* Primeira contribuição, espero que ajude! :weight_lift: *\\

Editado por 081094
Link para o comentário
Compartilhar em outros sites

Entao cara no meu esta dando este erro como resolvo este erro?

 

 

Fatal error: Uncaught exception 'DatabaseConnectException'

Message: Unable to connect to mysql server. Please make sure it is up and running and you have correct user/password in config.inc.php.

Online help: More Info

File: sql.php on line: 37

Script was terminated because something unexpected happened. You can report this, if you think it's a bug.

 

Debug Backtrace:Disabled

Link para o comentário
Compartilhar em outros sites

Entao cara no meu esta dando este erro como resolvo este erro?

 

 

Fatal error: Uncaught exception 'DatabaseConnectException'

Message: Unable to connect to mysql server. Please make sure it is up and running and you have correct user/password in config.inc.php.

Online help: More Info

File: sql.php on line: 37

Script was terminated because something unexpected happened. You can report this, if you think it's a bug.

 

Debug Backtrace:Disabled

Vai no C:\xampp\htdocs/config.inc

 

 

$cfg['SQL_Password']e tirar o Password

 

:button_ok: :button_ok: :button_ok:

Link para o comentário
Compartilhar em outros sites

Visitante
Este tópico está impedido de receber novos posts.

×
×
  • Criar Novo...